The Plant Manager has decided to do major maintenance on machinery in July. To do this he has approved
increasing the hourly workers to 267 hours per person for July only. Prior to approving this plan, the Plant
Controller has asked you to estimate/forecast the cost of doing the July maintenance. Using the template
below estimate/forecast the total cost for the Maintenance Department for July.

GENERAL LEDGER MAINTENANCE DEPARTMENT Jan Feb Mar Apr May Jun Oil and Grease Expense $11,899 $12,499 $14,010 $12,012 $10,980 $12,223 Repair Parts and Supplies 7,398 6,609 7,487 6,670 6,500 7,001 Rent - Maintenance Dept. Shed 1,200 1,200 1,200 1,200 1,200 1,200 Tools 3,000 3,128 3,445 3,300 2,456 2,999 Maintenance Supervisor Salary 4,000 4,000 5,000 4,000 4,000 4,000 Hourly Maintenance Payroll 7,590 7,293 9,900 7,656 6,930 7,656 $35,087 $34,729 $41,042 $34,838 $32,066 $35,079 Jan Feb Mar Apr May Jun Hourly Employee Hours Worked Watson 150 150 200 152 144 150 Singh 150 144 200 150 130 154 Alcaty 160 148 200 162 146 160 Hourly Hours Worked 460 442 600 464 420 464 Hourly Pay Rate $16.50 $16.50 $16.50 $16.50 $16.50 $16.50 Maintenance supervisor worked on special project in March and was paid $1,000 above normal salary MAINTENANCE DEPARTMENT JULY Oil and Grease Expense Repair Parts and Supplies Rent - Maintenance Dept. Shed Tools Maintenance Supervisor Salary Hourly Maintenance Payroll $-