1 2 3 4 Section C - The following questions are to be answered on the MOH Sheet Calculate Cost per unit of activity driver (dividing Budgeted Activity Cost by Budgeted Activity Driver) Cells: F6 to F9 Calculate "Allocated MOH" ( Multiply Actual activity by Cost per unit of activity drivers from the last step) Calculate "Total allocated MOH per each job" Calculate "Total allocated MOH" Cell: K19 Section D.The following questions are to be answered on the Production Report Sheet Calculate "Total Direct Material cost per each Job" by linking the cells to "Section A-Direct Material" sheet- Column Calculate "Total Direct Labour cost per each Job" by linking the cells to "Section B-Direct Labour' sheet-column D Calculate "Total Allocated MOH per each Job" by linking the cells to "Section C-MOH"sheet-Column E LLLLLL Instructions Section - Direct Materal Section B-Direct Labour Section C-MOH Section De Production Report 1 2 13 4 Cost per unit of activity driver 3 5 2 3 Activity Activity driver Machine Set up Number of setup Material Handling Number of material removal Inspection Number of inspections Product design Design hours Budgeted Activity Budgeted Activity Cost Driver $1,600.000 160,000 $1,120,000 600.000 $800,000 330.000 5610,000 35,600 Number of setup Allocated MOH Number of Number of material removal Inspection Designated hou MON perloh SYD100 SYD202 SYD: 206 MELO MELON Actual Number of setup Number of material retnovel 24,000 168,000 12.000 114,240 18,000 20130 14,000 141.120 16,000 53,700 Number of Inspection 67,200 53,700 33,600 100,000 25,3 Design Hous 2.240 1,120 12.688 1,712 1.344 Total Allocated MOH: At Window CHOI