Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Performance Report -- Laundry Department October - December (Over) % (Over) Under Under Budget Actual Budget Budget Client nights 9,500 11,900 (2,400) (25) Pounds of

Performance Report -- Laundry Department October - December (Over) % (Over) Under Under Budget Actual Budget Budget Client nights 9,500 11,900 (2,400) (25) Pounds of laundry processed 125,000 156,600 (31,600) (25) Costs Laundry labor $9,000 $12,512 $(3,512) (39) Supplies 1,125 1,875 (750) (67) Water and water heating and softening 1,750 2,500 (750) (43) Maintenance 1,375 2,200 (825) (60) Supervisor's salary 3,125 3,750 (625) (20) Allocated administrative costs 4,000 5,000 (1,000) (25) Equipment depreciation 1,250 1,250 - 0 --------- --------- -------- ------- Total $21,625 $29,087 $(7,462) (35) TCG267 Spruce Street Shelter 2 of 2

Below is what I have so far. The cells blank are the ones I'm having trouble with. I want to round it to 4 decimal places. Thank you.

image text in transcribed

Home Insert Draw Page Layout Formulas Data Review View Add-ins Help Team Bc 1) Flexible budget and total variance decomposition Activity variance Favorable or Unfavorable Spending variance Favorable or Unfavorable Rate per pound Master budget 9,500 125,000 Flexible Budget 11,900 156,600 Actual 11,900 156,600 10 Activity 11 Client nights 12 Pounds of laundry processed 13 Costs 14 Laundry labor 15 Supplies 16 Water & water heating & softening 17 Maintenance 18 Supervisor's salary 19 Allocated administrative costs 20 Equipment depreciation 21 Total $ 9,000.00 $ 1,125.00 $ 1,750.00 1,375.00 $ 3,125.00 $ 4,000.00 $ 1,250.00 $ 21,625.00 $ $ $ $ $ $ $ $ 11,275.00 1,409.00 2,192.00 1,722.00 3,125.00 4,000.00 1,250.00 24,973.00 $ $ $ $ $ $ $ $ 12,512.00 1,875.00 2,500.00 2,200.00 3,750.00 5,000.00 1,250.00 29,087.00 23 2) Laundry labor-Spending variance analysis Actual labor minutes at budgeted labor rate 11,900 Actual labor cost Budgeted labor cost 25 Client nights 26 Pounds of laundry processed 156,600 28 Budgeted labor rate per hour 29 Actual labor rate per hour $ $ 9.00 10.20 Labor efficiency variance ! Favorable or Unfavorable Labor rate variance Favorable or Unfavorable 31 Budgeted labor rate per minute 32 Actual labor rate per minute 34 Budgeted labor minutes per pound 35 Actual labor minutes per pound 26 Sheet1 o O Type here to search

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

ISO 13485 Auditing Journal Notes Checklists Observations Evidence Log

Authors: Just Visualize It, The Quality Guy

1st Edition

B08W7SNPGP, 979-8706121884

More Books

Students also viewed these Accounting questions

Question

manageremployee relationship deteriorating over time;

Answered: 1 week ago