Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Aunt Janes Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked to explain the deviations. Below is the budget

image text in transcribed
image text in transcribed
Aunt Janes Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked to explain the deviations. Below is the budget v. actual expense report for the month in question Actual Budget Variance Utilities 85,678.00 71,300.00 (14,378.00) Laundry Food Service 31,538.00 26,400.00 (5,138,00) 59,800.00 54,000.00 (5,800.00) Rent/taxes 95,000.00 95.000.00 Staff Wages 91,500.00 88,700.00 2,800.00) 65,000.00 68,000.00 3,000.00 Management Salaries Water 23,690.00 17,000.00 (6,690.00) 31,400.00 28,000.00 3.400.00) Maintenance 483,606.00 448,400.00 (35,206,00) The Inn has observed that utilities, water, food service, staff wages, and laundry costs all vary with activity. The other costs are fixed. The budget reflected above was based upon an assumed 80% occupancy rate. The university's football team was on a winning streak and numerous alumni were returning to campus in October, resulting in a 92% occupancy rate during the month. Prepare a flexible budget" based upon a 92% occupancy rate, and identify whether the Inn is being efficiently or inefficiently run. Comment on specific costs, and note why a flexible budget can improve performance evaluations. Hint - Use the table above and leave actual" column unchanged. Calculate new budgeted and variance columns

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

The Routledge International Handbook Of Financialization

Authors: Philip Mader, Daniel Mertens, Natascha Van Der Zwan

1st Edition

1138308218, 978-1138308213

More Books

Students also viewed these Finance questions

Question

Describe the appropriate use of supplementary parts of a letter.

Answered: 1 week ago