Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Occupancy %: year 1 75.5% year 2 87.6% year 3 69.5% The Example Hotel below is looking at several possible rate and occupancy scenarios. You

image text in transcribed

Occupancy %:

year 1

75.5%

year 2

87.6%

year 3

69.5%

The Example Hotel below is looking at several possible rate and occupancy scenarios. You have been asked to complete the financial information for the hotel, using the information about Fixed and Variable costs that are given. Year Year Year Scenario 1 Scenario 2 Scenario 3 Rooms 100 100 100 Available Annual Room Nights 36,500 36,500 36,500 Occupied Rooms 27,564 32,000 25,375 Occupancy % ADR $ 165.00 $ 165.00 $ 165.00 Room Revenue Management Hours Rate Per Hour - Wage Expense $ Benefit Expense per Hour $ 8160 26.00 13.00 Housekeeper Hours POR (0.5d (Do NOT add this line to the total) Rate Per Hour $ Benefit Expense per Hour $ Total Payroll and Benefit Expense 11.50 5.75 Amenities Linen Laundry Reservatuions Cable Television Decorations Transportation Uniforms Total Direct Expenses $3.25 Per Occuped Room (POR) $2.05 POR $5.05 POR $8.95 POR $22,000 Per Year $10,500 Per Year $26,000 Per Year $21,000 Per Year Total Expenses (Payroll and Direct Expenses Total Cost Per Occupied Room The Example Hotel below is looking at several possible rate and occupancy scenarios. You have been asked to complete the financial information for the hotel, using the information about Fixed and Variable costs that are given. Year Year Year Scenario 1 Scenario 2 Scenario 3 Rooms 100 100 100 Available Annual Room Nights 36,500 36,500 36,500 Occupied Rooms 27,564 32,000 25,375 Occupancy % ADR $ 165.00 $ 165.00 $ 165.00 Room Revenue Management Hours Rate Per Hour - Wage Expense $ Benefit Expense per Hour $ 8160 26.00 13.00 Housekeeper Hours POR (0.5d (Do NOT add this line to the total) Rate Per Hour $ Benefit Expense per Hour $ Total Payroll and Benefit Expense 11.50 5.75 Amenities Linen Laundry Reservatuions Cable Television Decorations Transportation Uniforms Total Direct Expenses $3.25 Per Occuped Room (POR) $2.05 POR $5.05 POR $8.95 POR $22,000 Per Year $10,500 Per Year $26,000 Per Year $21,000 Per Year Total Expenses (Payroll and Direct Expenses Total Cost Per Occupied Room

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions