Please complete the yellow cells

SPRUCE STREET SHELTER Exhibit 1. Performance Report -- Laundry Department October - December (Over) Under Budget % (Over) Under Budget Budget Actual Client nights Pounds of laundry processed 9,500 125,000 11.900 156,600 (2,400) (31,600) (25) (25) $(3.512) Costs Laundry labor $9,000 Supplies 1,125 Water and water heating and softening 1,750 Maintenance 1,375 Supervisor's salary 3,125 Allocated administrative costs 4,000 Equipment depreciation 1.250 Total $21,625 $12,512 1875 2.500 2.200 3,750 5.000 1,250 (750) (825) (625) (1,000) 86638a 18 $29,087 $(7,462) Spruce Street Shelter - Laundry Department 1) Flexible budget and total variance decomposition Activity variance Favorable or Unfavorable Flexible Budget Spending variance Favorable or Unfavorable Rate per pound Master budget 9.500 125.000 Actual 11.900 156.600 156.600 Activity Client nights Pounds of laundry processed Costs Laundry labor Supplies Water & water heating & softening Maintenance Supervisor's salary Allocated administrative costs Equipment depreciation 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 $ $ $ $ $ $ $ $ U 2.275,00 284,00 442,00 347,00 - - - 3.349,00 11.275,00 1.409,00 2.192,00 1.722,00 3.125,00 4.000,00 1.250,00 24.974,00 1.237,00 466,00 308,00 478, 00 625,00 1.000,00 $ $ $ $ $ $ $ $ 22=== U none none none U $ $ $ $ $ $ $ $ 12.512,00 1.875,00 2.500,00 2.200,00 3.750,00 5.000,00 1.250,00 29.087,00 $ $ $ $ none 4.113,00 0 2) Laundry labor - Spending variance analysis Actual labor minutes at budgeted labor rate Client nights Pounds of laundry processed 11.900 156.600 Budgeted labor cost Actual labor cost $ 9,00 Budgeted labor rate per hour Actual labor rate per hour Labor efficiency variance Favorable or Unfavorable Labor rate variance Favorable or Unfavorable Budgeted labor rate per minute Actual labor rate per minute Budgeted labor minutes per pound Actual labor minutes per pound SPRUCE STREET SHELTER Exhibit 1. Performance Report -- Laundry Department October - December (Over) Under Budget % (Over) Under Budget Budget Actual Client nights Pounds of laundry processed 9,500 125,000 11.900 156,600 (2,400) (31,600) (25) (25) $(3.512) Costs Laundry labor $9,000 Supplies 1,125 Water and water heating and softening 1,750 Maintenance 1,375 Supervisor's salary 3,125 Allocated administrative costs 4,000 Equipment depreciation 1.250 Total $21,625 $12,512 1875 2.500 2.200 3,750 5.000 1,250 (750) (825) (625) (1,000) 86638a 18 $29,087 $(7,462) Spruce Street Shelter - Laundry Department 1) Flexible budget and total variance decomposition Activity variance Favorable or Unfavorable Flexible Budget Spending variance Favorable or Unfavorable Rate per pound Master budget 9.500 125.000 Actual 11.900 156.600 156.600 Activity Client nights Pounds of laundry processed Costs Laundry labor Supplies Water & water heating & softening Maintenance Supervisor's salary Allocated administrative costs Equipment depreciation 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 $ $ $ $ $ $ $ $ U 2.275,00 284,00 442,00 347,00 - - - 3.349,00 11.275,00 1.409,00 2.192,00 1.722,00 3.125,00 4.000,00 1.250,00 24.974,00 1.237,00 466,00 308,00 478, 00 625,00 1.000,00 $ $ $ $ $ $ $ $ 22=== U none none none U $ $ $ $ $ $ $ $ 12.512,00 1.875,00 2.500,00 2.200,00 3.750,00 5.000,00 1.250,00 29.087,00 $ $ $ $ none 4.113,00 0 2) Laundry labor - Spending variance analysis Actual labor minutes at budgeted labor rate Client nights Pounds of laundry processed 11.900 156.600 Budgeted labor cost Actual labor cost $ 9,00 Budgeted labor rate per hour Actual labor rate per hour Labor efficiency variance Favorable or Unfavorable Labor rate variance Favorable or Unfavorable Budgeted labor rate per minute Actual labor rate per minute Budgeted labor minutes per pound Actual labor minutes per pound