Given the following data for a particular hotel and restaurant, please calculate the selected ratios below. Compare them to the US Virgin Islands and US benchmarks and draw conclusions. You are responsible to find the respective benchmarks. If you cannot find any published benchmarks, find any 3-10 hotels and restaurants, calculate their averages for that ratio. That average will be the respective benchmark to use. Scores distribution: Excel Ratios including Excel formulas used 10, Virgin Islands average 10, US Averages 10, Conclusion 5. Totals 35. Note: No ratios score if there are no Excel formula used. HOTEL Total Rooms 775 Rooms Available for Sale 700 Rooms Occupied and Sold 140 Number of Guests 308 Housekeeping Costs $7,170 Rooms Revenue $17,500 Total Revenue from Hotel Guests $53,900 RESTAURANT Food Sales $7,700 Beverage Sales $900 Total Sales $3,600 Number of Guests (Covers) Sold 180 Number of Seats in the Restaurant 150 Available Seat Hours 1500 Labor Cost $1,760 Food  Beginning Inventory $5,000  Purchases $500  Ending Inventory $4,565  Transfers Out $700  Transfers In $100  Employee Meals $75 Beverage  Beginning Inventory $7,000  Purchases $750  Ending Inventory $7,188  Transfers Out $100  Transfer In $700

 

Transcribed Image Text:

Create an Excel Template to Calculate the following: HOTEL Homework Occupancy Percentage Average Daily Rate (ADR) RevPAR RevPAC Housekeeping CPOR RESTAURANT Check Average Seat Turnover RevPASH Cost of Food Sold Food Cost Percentage Cost of Beverage Sold Beverage Cost Percentage Labor Cost The Virgin Islands Average US Benchmark Conclusions* Percentage In your conclusions you can use terms such as fair, needs attention, good, bad, etc. Create an Excel Template to Calculate the following: HOTEL Homework Occupancy Percentage Average Daily Rate (ADR) RevPAR RevPAC Housekeeping CPOR RESTAURANT Check Average Seat Turnover RevPASH Cost of Food Sold Food Cost Percentage Cost of Beverage Sold Beverage Cost Percentage Labor Cost The Virgin Islands Average US Benchmark Conclusions* Percentage In your conclusions you can use terms such as fair, needs attention, good, bad, etc.