Prepare a more logical performance report

Assignment Help Accounting Basics
Reference no: EM131784095

Assignment

Anna Van Degna, supervisor, of housecleaning for Hotel Dell, was surprised by her summary performance report for March given below.

Actual

Budget

Variance

% Variance

$169,744

$159,200

$10,544 U

6.623% U

Anna was disappointed. She thought she had done a good job controlling housekeeping labor and materials usage but her performance report revealed an unfavorable variance of $10,544. She had been hoping for a bonus for her good work but now expected a series of questions from her manager.

The cost budget for housekeeping is based on standard costs. At the beginning of a month, Anna receives a report from Hotel Delll's Sales Department outlining the planned room activity for the month. Anna then schedules labor and materials using this information. The March budget for the housekeeping was based on 8,400 room nights. Each room night is budgeted based on the following standards for various materials, labor, and overhead:

Shower Supplies

3 bottles @ $0.30 each

Towels*

1 @ $2.00

Laundry

10 lbs. @ $0.30 a lb

Labor

½ hour @ $12.00 an hour

VOH

$6.00 per labor hour

FOH

$5 a room night (based on 8,400 room nights)

*Replacement for towels evaluated by housekeeping as inappropriate for cleaning and reuse.

With 8,900 room nights sold, actual costs and usage for housekeeping during April were:

$8,190 for 26,500 bottles of shower supplies.
$15,563 for 7,900 towels.
$27,339 for 88,500 lbs. of laundry.
$51,591 for 4,350 labor hours.
$25,839 in total VOH
$41,222 in FOH

QUESTIONS TO ANSWER:

(A) Develop a complete budget column for the above performance report presented to Anna. Break it down by expense category. The following format, with additional lines for expense categories is suggested:

Account

Actual

Budget

Variance

(B) Evaluate the usefulness of the cost center performance report presented to Anna.

(C) Prepare a more logical performance report where standard allowed is based on actual output. Also, split each variance into its price/rate/spending and quantity/efficiency components (except fixed of course). The following format, with additional lines for expense categories, is suggested:

Account

Actual

Flexible Budget

Total Variance ;;; Price/Rate/Spending Variance ;;; Quantity/Efficiency Variance

(D) Explain to Anna's boss what your report suggests about Anna's department performance.

(E) Identify additional non financial performance measures management might consider when evaluating the performance of the housekeeping department and Anna as a manager.

Reference no: EM131784095

Questions Cloud

Discuss the city of monroe stores and service fund : Open a general journal for the City of Monroe Stores and Service Fund and record the following transactions
Determine the minimum ph for quantitative separation : Assume the initial condition for each ion is 0.050 M. The pKsp for Fe(OH)3 is 37.39 and the pKsp for Mn(OH)2 is 12.72.
What observed rotation is expected : The specific rotation of (R)-2-butanol is -13.9 degrees mL g-1 dm-1.
How much interest expense can diana deduct as an itemised : home equity loan on his home. How much interest expense can Diana deduct as an itemised deduction
Prepare a more logical performance report : Prepare a more logical performance report where standard allowed is based on actual output. Also, split each variance into its price/rate/spending.
Set up the difference equations for the torsional system : Set up the difference equations for the torsional system shown in Figure. Determine the boundary equations and solve for the natural frequencies.
Calculate the amount of taxes that tendai can include : Calculate the amount of taxes that Tendai can include with his itemized deductions
What is the final temperature : What is the final temperature when a 0.4 kg horseshoe initially at a temperature of 800 K is dropped into a bucket containing 2 kg of water initially at 300 K?
What is the total deductible amount of these expenditures : Donna operates a talent agency as a sole proprietorship, and this year she incurred the following expenses in operating her talent agency.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd