Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 %
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started