Question

In: Accounting

University Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked...

University 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.

University Inn

Budget vs. Actual Expense Report

For The Month Ending October 31, 20X7

Actual

Budget

Variance

Utilities

$52,000

$45,000

($7,000)

Laundry

20,000

18,000

($2,000)

Food service

41,000

35,000

($6,000)

Rent/taxes

60,000

60,000

$0

Staff wages

57,000

55,000

($2,000)

Management salaries

43,500

45,000

$1,500

Water

13,000

10,000

($3,000)

Maintenance

15,200

15,000

($200)

Total

$301,700

$283,000

($18,700)

The Inn has observed that utilities, water, food service, staff wages, and laundry costs all vary with activity. The other costs are fixed.

The preceding budget was based upon an assumed 70% occupancy rate. The university's football team was on a winning streak and numerous alumni were returning to campus in October, resulting in a 91% occupancy rate during the month.

Prepare a "flexible budget" based upon a 91% occupancy rate, and calculate the total variance.

Solutions

Expert Solution

Please give a positive rating, if you find this helpful. Comment if you have any doubts and I will get back to you. Thank you.

ANSWER:

Flexible Budget

Particulars Flexible Budget (A) (@ 91% Occupancy rate) Actual (B) Variance (A - B)
Utilities 58,500 [45,000 * (91% / 70%)] 52,000 6,500 Favorable
Laundry 23,400 [18,000 * (91% / 70%)] 20,000 3,400 Favorable
Food Service 45,500 [35,000 * (91% / 70%)] 41,000 4,500 Favorable
Rent/taxes 60,000 60,000 N/A
Staff wages 71,500 [55,000 * (91% / 70%)] 57,000 14,500 Favorable
Management salaries 45,000 43,500 1,500 Favorable
Water 13,000 [10,000 * (91% / 70%)] 13,000 0
Maintenance 19,500 [15,000 * (91% / 70%) 15,200 4,300 Favorable
Total 336,400‬ 301,700 34,700‬ Favorable

Related Solutions

University Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked...
University 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. University Inn Budget v. Actual Expense Report For the Month Ending October 31, 2007 Actual (at 96% capacity) Budget (established at 80% capacity) Variance Utilities $ 52,000 $ 45,000 $ (7,000) Laundry 20,000 18,000 (2,000) Food service 41,000 35,000 (6,000) Rent/taxes 60,000 60,000 - Staff wages 57,000...
University Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked...
University 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. University Inn Budget vs. Actual Expense Report For The Month Ending October 31, 20X7 Actual Budget Variance Utilities $52,000 $45,000 ($7,000) Laundry 20,000 18,000 ($2,000) Food service 41,000 35,000 ($6,000) Rent/taxes 60,000 60,000 $0 Staff wages 57,000 55,000 ($2,000) Management salaries 43,500 45,000 $1,500 Water 13,000 10,000...
A recent health report revealed that a woman with insurance spends an average of 2.3 days...
A recent health report revealed that a woman with insurance spends an average of 2.3 days in the hospital following a routine childbirth, while a woman without insurance spends an average of 1.9 days at the hospital. Two samples of 16 women each were used in both samples. The standard deviation of the first sample is equal to 0.6 day, and the standard deviation of the second sample is 0.3 day. At ?=0.01, test the claim that the means are...
What were some of the findings of the most recent (2011) EPA Benefit-Cost Analysis of the...
What were some of the findings of the most recent (2011) EPA Benefit-Cost Analysis of the 1990 Amendments to the Clean Air Act (CAA)?
Tom's Shoe Repair provides a variety of shoe repair services. Analysis of monthly costs revealed the...
Tom's Shoe Repair provides a variety of shoe repair services. Analysis of monthly costs revealed the following cost formulas when direct labor hours are used as the basis of cost determination: Supplies: y=$0+$4.00X Production supervision and direct labor: y=$500+$7.00X Utilities: y=$350+$5.40X Rent: y=$450+$0.00X Advertising: y=$75+$0.00X a. Prepare a flexible budget 250, 300, 350, and 400 direct labor hours. b. Calculate a total cost per direct labor at each level of activity. c. Tom's employees usually work 350 direct labor hours...
. Given the following monthly expense report for EKGs calculate price, efficiency, intensity, and quantity variances...
. Given the following monthly expense report for EKGs calculate price, efficiency, intensity, and quantity variances for each object code. Second write an explanation for why expenses differ from budget, one paragraph per expense line and create a table similar to table 11.4. Discuss how much of these variances the manager may be responsible for. Obj.Code Expenses Actual Budget $ Diff % Diff 4020 Staff Salaries $77,619 $75,000 $2,619 3.49% 4212 Medical Supplies $11,452 $11,875 -$423 -3.56% 4350 Biomedical Repair/Maint....
A. Imagine you are a HRM manager and asked to do a job analysis for a...
A. Imagine you are a HRM manager and asked to do a job analysis for a job title at your company, choose any job title you know or hear about and make a job description and job specification. 10 marks B. Discuss and explain in your own words with relevant examples the “Marketing concept” 15 marks
Review the most recent Report to the Nation on Occupational Fraud and Abuse published by the...
Review the most recent Report to the Nation on Occupational Fraud and Abuse published by the ACFE. Discuss what you found interesting in this report and what impact, if any, you think the legal system and corporate governance have had on reducing fraud?
Prepare a report on Workflow process, Risk analysis and resourcemanagement for the University online Help...
Prepare a report on Workflow process, Risk analysis and resource management for the University online Help desk management system.1.Determine the purpose and importance of project management from the perspectives of planning, tracking and completion of project.2.Evaluate the feasibility of project proposals utilizing appropriate tools, techniques and methods.3.Manage project schedule, expenses and resources with of suitable project management tools.
You are manager of a district that has just hired several recent university and college graduates....
You are manager of a district that has just hired several recent university and college graduates. Most of these people are starting their first full-time job, although most or all have held part-time and summer positions in the past. They have general knowledge of their particular skill area (accounting, engineering, marketing, etc.) but know relatively little about specific business practices and developments. Explain how you would nurture the self-concepts in these new hires to strengthen their performance and maintain their...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT