Son Petshus the departe, SMS Milling and the of Galete the boabe oferecer the permend Maintenance on the of machine hos Mimas, dan mofect Lab devating data for the upcoming year folkmurs Operating Departments Service Departments Custodia Cafeteria Services $ 130,00 $65,100) 23 41 12 000 Bosted overhew before allocation Number of employees Square metres Machines 10 Wrect labour hours Maintenance $23,00 1 10, 5411, 10 1) W 1. 18. AL 21.210 . 12 Required 1. Prepare a schedule to allocate service department costs to operating departments using the direct method. Calculate the predetermined overhead rate for each operating department. (8 marks). You may not need to use all the highlighted cells 15 Use this table to calculate the allocation percentages 16 Service Departments Operating Departments Custodial 17 Cafeteria Services Maintenance Milling Finishing Total 18 19 20 21 22 Cafeteria $330.000 Services $65,100 Maintenance $93,800 Milling $411.668 Finishing $168,155 Total $1.7 Budited overhead before allocation Budgeted overhead after allocation 35. Predetermined overhead rates 16 2. Assume that the company bids on a job that requires the following machine hours and direct labour hours. You may not need to use all the 37 highlighted cells. 38 Direct labour 39 Machine hours hours 40 Milling 2,800 1,200 41 Finishing 800 13,100 43 How much overhead would have been applied to the job if the direct method had been used? (3 marks) Milline Finishin Total 46 47 48 45 SPDM 1 Now lenovo Severson Products (SP) has three service departments - Cafeteria, Custodial Services and Maintenanon, SP who has two operating departments Milling and finishing SP allocates the cost of Cafeteria on the basis of number of employees, Cintodial Services on the basis space ocupied square metres and Maintenance on the basis of machine hours. Milling applies overhead based on machine hours and Finishing based on the number of direct labour hours 1 2 Budpeted operating data for the upcoming year follows: 4 Operating Departments 5 Service Departments Custodial Cafeteria Services $330,000 $65,100 23 43 12,300 3,900 Maintenance $93,800 51 10,3001 Budgeted overhead before allocation 7 Number of employees * Square metres 9 Machine hours 10 Direct labour hours 11 12 Required: 13 Milling $411,665 108 39,390 156,800 13,000 Finishing $168.155 324 21 210 39,200 72.000 1. Prepare a schedule to allocate service department costs to operating departments using the direct method. Calculate the predetermined overhead rate for each operating department. (8 marks). You may not need to use all the highlighted cells. 1 Use this table to calculate the allocation percentages 16 Service Departments Operating Departments Custodial 7 Cafeteria Services Maintenance Milling Finishing Total Use this table to allocate the costs and calculate the predetermined overhead rates Service Departments Operating Departments Custodial Cafeteria Services Maintenance Milling Finishing Budgeted overhead before allocation $330,000 $65,100 $93,800 $411,665 $168.155 Total $1,068,720 udgeted overhead after allocation edetermined overhead rates hollowing machine hours and direct lahour hours. You may not need to use all the Cafeteria $310,000 Custodial Services $65,100 Budgeted overhead before allocation Maintenance $93.800 Milling $411,665 Finishing $168,155 Total $1.0, 720 32 Budgeted overhead after allocation 09 34 35 Predetermined overhead rates 36 2. Assume that the company bids on a job that requires the following machine hours and direct labour hours. You may not need to use all the 37 highlighted cells. 38 Direct labour 39 Machine hours hours 40 Milling 2,800 1,200 41 Finishing 13,100 42 43 How much overhead would have been applied to the job if the direct method had been used? (3 marks) 44 45 Milling Finishing Total 46 47 Son Petshus the departe, SMS Milling and the of Galete the boabe oferecer the permend Maintenance on the of machine hos Mimas, dan mofect Lab devating data for the upcoming year folkmurs Operating Departments Service Departments Custodia Cafeteria Services $ 130,00 $65,100) 23 41 12 000 Bosted overhew before allocation Number of employees Square metres Machines 10 Wrect labour hours Maintenance $23,00 1 10, 5411, 10 1) W 1. 18. AL 21.210 . 12 Required 1. Prepare a schedule to allocate service department costs to operating departments using the direct method. Calculate the predetermined overhead rate for each operating department. (8 marks). You may not need to use all the highlighted cells 15 Use this table to calculate the allocation percentages 16 Service Departments Operating Departments Custodial 17 Cafeteria Services Maintenance Milling Finishing Total 18 19 20 21 22 Cafeteria $330.000 Services $65,100 Maintenance $93,800 Milling $411.668 Finishing $168,155 Total $1.7 Budited overhead before allocation Budgeted overhead after allocation 35. Predetermined overhead rates 16 2. Assume that the company bids on a job that requires the following machine hours and direct labour hours. You may not need to use all the 37 highlighted cells. 38 Direct labour 39 Machine hours hours 40 Milling 2,800 1,200 41 Finishing 800 13,100 43 How much overhead would have been applied to the job if the direct method had been used? (3 marks) Milline Finishin Total 46 47 48 45 SPDM 1 Now lenovo Severson Products (SP) has three service departments - Cafeteria, Custodial Services and Maintenanon, SP who has two operating departments Milling and finishing SP allocates the cost of Cafeteria on the basis of number of employees, Cintodial Services on the basis space ocupied square metres and Maintenance on the basis of machine hours. Milling applies overhead based on machine hours and Finishing based on the number of direct labour hours 1 2 Budpeted operating data for the upcoming year follows: 4 Operating Departments 5 Service Departments Custodial Cafeteria Services $330,000 $65,100 23 43 12,300 3,900 Maintenance $93,800 51 10,3001 Budgeted overhead before allocation 7 Number of employees * Square metres 9 Machine hours 10 Direct labour hours 11 12 Required: 13 Milling $411,665 108 39,390 156,800 13,000 Finishing $168.155 324 21 210 39,200 72.000 1. Prepare a schedule to allocate service department costs to operating departments using the direct method. Calculate the predetermined overhead rate for each operating department. (8 marks). You may not need to use all the highlighted cells. 1 Use this table to calculate the allocation percentages 16 Service Departments Operating Departments Custodial 7 Cafeteria Services Maintenance Milling Finishing Total Use this table to allocate the costs and calculate the predetermined overhead rates Service Departments Operating Departments Custodial Cafeteria Services Maintenance Milling Finishing Budgeted overhead before allocation $330,000 $65,100 $93,800 $411,665 $168.155 Total $1,068,720 udgeted overhead after allocation edetermined overhead rates hollowing machine hours and direct lahour hours. You may not need to use all the Cafeteria $310,000 Custodial Services $65,100 Budgeted overhead before allocation Maintenance $93.800 Milling $411,665 Finishing $168,155 Total $1.0, 720 32 Budgeted overhead after allocation 09 34 35 Predetermined overhead rates 36 2. Assume that the company bids on a job that requires the following machine hours and direct labour hours. You may not need to use all the 37 highlighted cells. 38 Direct labour 39 Machine hours hours 40 Milling 2,800 1,200 41 Finishing 13,100 42 43 How much overhead would have been applied to the job if the direct method had been used? (3 marks) 44 45 Milling Finishing Total 46 47