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.

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