SHOW SOLUTION FOR NO. 24 AND 25. PLS USE EXCEL IF POSSIBLE AND MAKE SURE IT IS WELL EXPLAINED PLS

PROBLEM F (Service Department Costs) CLEAN COMPANY has five departments: the Electricity Department, the Maintenance Department, the Human Resources Department, the Grinding Department, and the Finishing Department. The first three departments render services to the other departments. The following schedule summarizes the service departments' bases for allocating costs. Service Department Electricity Department Maintenance Department Human Resources Department Basis for Allocation No. of Kilowatt Hours No. of Maintenance Hours No. of Employees A schedule pertaining to the data of each department is presented. Kilowatt Hours Main. Hours 200 Employees 5 Estimated Costs $250,000 175,000 150,000 560,000 640,000 Electricity Maintenance Human Resources Grinding Finishing 5 1,000 2,000 5,000 3,000 250 525 12 425 13 CASE A: The company uses the sequential method in allocating service department costs. The electricity department's costs are allocated first followed by the maintenance department and then the human resources department. 24. What is the cost of the Grinding Department after allocation? 25. What is the cost of the Finishing Department after allocation