AutoSave O OFF ~ A P . C ... 3 Assignment 5 Activity Based Costing (2022-23) - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 12 A A Wrap Text General Insert Ex AY- O. Ex Delete I V Z Paste B I UVV DVAv E E Merge & Center v $ ~ % 9 Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data B2 x v fx Question 3 (6 marks) A C D E F G H K L M N 0 P Q R N Question 3 (6 marks) Fields Company is a manufacturing firm that currently uses traditional costing with one plantwide overhead rate. The company is determining if they should implement activity-based costing and has identified the potential activity areas along with the expected activity for its' two product lines: Product A and Product B. Expected Activity Overhead Cost Allocation Activity Product A Product B Base Design |Design $350,000 5,000 2,00 Hour Machine Production $800,000 10,00 30,000 Hours $300,000 Labor Finishing 1,000 3,000 10 Hours 11 Required: Calculate the activity rate for each of the cost pools. (2 marks for each activity rate) 16 18 19 20 22 23 24 25 26 27 28 29 30 31 32 D Instructions Question 1 Question 2 Question 3 Question 4 Assessment Criteria + Select destination and press ENTER or choose Paste + 100%