Using activity-based casting (ABC) , determine the total activity costs allocated to each product 4 line

Spreadsheet HOME DATA VIEW & Cut Font Name Font Size * TabStop Wrap Text E 3 " Insert Column "" Delete Column Copy B us Overline Merge Cell 3- Insert Row + Delete Row Paste CLICK HERE TO SAVE YOUR WORK C25 B C D E F G H 3 Activities Activity Costs Saving your work for grading: Machine Set-Ups $ 196,000.00 Remember to press the yellow button to save your 5 Extruding $ 480,000.00 A link to your spreadsheet will be placed in the cli 6 Quality Control $ 160,000.00 Click the Moodle tab and follow the instructions 7 Total $ 836,000.00 If you make changes to your spreadsheet, click th 8 There is no need to paste another link to your sp 10 Acitivites Cost Drivers Refrigerators Freezers 11 Machine Set-Ups Number of Set-Ups 300 484 12 Extruding Machine Hours 60,000 20,000 13 Quality Control Number of Inspections 5,000 3,000 14 *There are 3 parts to this question below. 15 1.Using the current traditional costing method that assigns overhead costs based on machine hours, calculate the total overhead cost allocated to each type of product for the current year. (3 Marks) 16 17 estimated allocated OH cost 836000 18 estimated machine houes 80000 19 predetermined OH rate 10.45 per machine hour 20 21 Refrigerator freezer 22 predetermined OH rate 10.45 10.45 23 machine hour 60000 20000 24 Manufacturing OH allocated 627000 209000 25 6 2. Under activity-based costing (ABC): Determine the activity rate for each of the three activities. (3 Marks) ABC New... ADY MacBook Air