Prepare a 350- to 700-word analysis of Situation 9.6, Financial Ratios from Income Statements (Ch. 9) from Hospitality Management: A Capstone Course. To complete your analysis, calculate the following financial ratios:
•Occupancy percentage
• Cost of labor percentage for rooms and F&B
• Cost of food sold percentage
• Cost of beverage sold percentage
• Average daily rate
• Profit margin for rooms and F&B
•Total revenue change from budget for rooms and F&B
• Housekeeping cost per occupied room
• Room sales to total sales
• Total rooms division payroll per occupied room
Note. In your financial analysis, discuss the findings from your calculations and how they effect the organization.
Rooms Division Report
Actual Budgeted
Rooms Revenue $473,979 $541,800
Total Payroll and Related
Front office 28,219 33,605
Housekeeping 48,833 57,283
Other Expenses
Front office 16,754 18,411
Housekeeping 9,396 15,600
Departmental Income 370,777 416,901
F&B Report
F&B Revenue
Food $220,728 $210,095
Beverage 70,578 78,706
Other income 10,882 12,000
Cost of Sales
Food 85,840 68,481
Beverage 16,177 17,709
Total F&B Payroll and Related 113,439 122,692
Other Expenses 20,076 30,052
Departmental Income 66,656 61,867
USA 
India