Exercise 6.1 Based on the scenario to complete hotel's March operating performance Tom is the revenue manager at a 220-room hotel. For the low season of March (31 days in March), Tom decided to reduce the room rates this year by 10% (from ADR $129.99 to ADR $116.99) to help increase occupancy and improve the RevPAR. Tom's room rate deduction resulted in an upswing in occupancy, from 75% last March to 85% this March - an increase of 13.3%. Last March, the hotel's operating costs were $61 per sold room-night. This March, the operating costs rose to $62 per sold room-night.

Fill in the blank cells (14*2 points=28 pionts): *Use formulas to get your results in each of the blank cells. Results without c Statistics Last March This March Change in Dollars Change in % Occupancy % 75% 85% 13.3% Room-nights Sold in March ADR $129.99 $1 16.99 Rooms Revenue RevPAR Total Operating Costs Total Gross Operating Profit GOPPARFill in the blank cells (8*1.S points=12 pionts): Distribution Channel Channel Production Channel Contribution Channel Contribution % Net ADR Yield