The Douze Droppe Inn had the following results against their static budget for January. Ownership wants...

Transcribed Image Text:

The Douze Droppe Inn had the following results against their static budget for January. Ownership wants you to prepare a variable budget, and compare the results to that variable budget Standard Driver Rooms Occupied Rooms ADR Rooms Revenue Pagroll and Benefits Fixed Actual % Budget % $ 25,200 178.00 26750 165 $ 4,485,600 4413750 Front Desk Man Hours Housekeeping Man Hou Bell Service Man Hours 0.18 Per occupied room 4,536 4815 0.5 12,600 16 Fixed Per Day 485 13375 480 Front Desk Wage Rate Housekeeping Wage Ra Bell Service Wage Rate Total Wage Expense $ 15.85 Per Hour $ 72,122 1.61% $ 76,318 $ 14.50 Per Hour $ 179,550 $ 13.25 Per Hour $ 6,548 4.00% $193,938 0.15% $ 6,360 $ 258,220 5.76% $276,615 Tax and Benefit Expens 51% Total Wages $ 134,274 2.99% $141,074 Total Payroll Expense $ 392,494 8.75% $ 417.689 Direct Expenses Guest Amenities $ 1.85 CPOR $ 47,880 1.07% $ 49,488 Linen $ 1.10 CPOR $ 26,460 0.59% $ 29,425 Terry $ 1.05 CPOR $ 31,500 0.70% $ 28,088 Cleaning Supplies Decorations Reservations Expense Travel Agency Expense Uniforms Expense Total Direct Expense Total Expense Rooms Department Profit $ 0.75 CPOR $ 20,160 0.45% $ 20,063 $ 750.00 FIXED $ 650 0.01% $ 750 $ 5.65 CPOR $ 144,900 3.23% $ 151,138 2.0% REVENUE $ 80,741 1.80% $ 88,275 $ 900.00 FIXED $ 950 0.02% $ 900 $ 353,241 7.87% $ 368,125 $ 745,735 16.63% $ 785,814 17.80% $ 3,739,865 83.37% $3,627,936 82.20% Variable Budget % Variance To Variabl % The Douze Droppe Inn had the following results against their static budget for January. Ownership wants you to prepare a variable budget, and compare the results to that variable budget Standard Driver Rooms Occupied Rooms ADR Rooms Revenue Pagroll and Benefits Fixed Actual % Budget % $ 25,200 178.00 26750 165 $ 4,485,600 4413750 Front Desk Man Hours Housekeeping Man Hou Bell Service Man Hours 0.18 Per occupied room 4,536 4815 0.5 12,600 16 Fixed Per Day 485 13375 480 Front Desk Wage Rate Housekeeping Wage Ra Bell Service Wage Rate Total Wage Expense $ 15.85 Per Hour $ 72,122 1.61% $ 76,318 $ 14.50 Per Hour $ 179,550 $ 13.25 Per Hour $ 6,548 4.00% $193,938 0.15% $ 6,360 $ 258,220 5.76% $276,615 Tax and Benefit Expens 51% Total Wages $ 134,274 2.99% $141,074 Total Payroll Expense $ 392,494 8.75% $ 417.689 Direct Expenses Guest Amenities $ 1.85 CPOR $ 47,880 1.07% $ 49,488 Linen $ 1.10 CPOR $ 26,460 0.59% $ 29,425 Terry $ 1.05 CPOR $ 31,500 0.70% $ 28,088 Cleaning Supplies Decorations Reservations Expense Travel Agency Expense Uniforms Expense Total Direct Expense Total Expense Rooms Department Profit $ 0.75 CPOR $ 20,160 0.45% $ 20,063 $ 750.00 FIXED $ 650 0.01% $ 750 $ 5.65 CPOR $ 144,900 3.23% $ 151,138 2.0% REVENUE $ 80,741 1.80% $ 88,275 $ 900.00 FIXED $ 950 0.02% $ 900 $ 353,241 7.87% $ 368,125 $ 745,735 16.63% $ 785,814 17.80% $ 3,739,865 83.37% $3,627,936 82.20% Variable Budget % Variance To Variabl %