Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Human Resource Management

Authors: John Bernardin

6th Edition

978-0078029165, 0078029163

More Books

Students also viewed these Accounting questions

Question

How do you ensure data quality?

Answered: 1 week ago

Question

Define deferred revenue. Why is it a liability?

Answered: 1 week ago