File Home Insert Draw Formulas Data Review View Help Editing Calibri B BA ab General H7 Js D E F G H 1 MO Lucern Company reports the following for its overhead cost for the year 1 2 3 4 5 6 Activity Engineering support Electricity Setup Budgeted Cost $24,500 34,000 52,500 Budgeted Activity Usage 70 design changes 3,400 machine hours 350 setups 7 LE 8 n w Setups 9 Required: 10 1. Compute the activity rate for each activity using activity-based costing. 11 12 (Use cells A4 to D7 from the given information to complete this question.) 13 14 Activity Budgeted Cost Budgeted Activity Usage Activity Rate 15 Engineering support 16 Electricity 17 Setup 18 19 2. The company's Pro model used these activities to produce 1,200 units during the year: 2 design Units produced 20 changes, 140 machine hours, and 12 setups. Allocate overhead cost to the Pro model and compute 21 its overhead cost per unit using activity-based costing. 1,200 22 23 (Use cells A4 to D7 from the given information to complete this question.) 24 25 Activity Activity Usage Activity Rate Allocated Cost 26 Engineering support 27 Electricity Ratin Graded Worksheet + Design Changes Machine Hours 140 2 12 Calculabon Mode: Automatic Workbook Statistics MacBook Pro 1106 ruids Data Review View Help Editing Calibri v General H7 H Setups Machine Hours 140 12 A B D E G 14 Activity Budgeted Cost Budgeted Activity Usage Activity Rate 15 Engineering support 16 Electricity 17 Setup 18 19 2. The company's Pro model used these activities to produce 1,200 units during the year: 2 design Units produced Design 20 changes, 140 machine hours, and 12 setups. Allocate overhead cost to the Pro model and compute Changes 21 its overhead cost per unit using activity-based costing. 1,200 2 22 23 (Use cells A4 to D7 from the given information to complete this question.) 24 25 Activity Activity Usage Activity Rate Allocated Cost 26 Engineering support 27 Electricity 28 Setup 29 Total allocated cost 30 Units produced 31 Overhead cost per unit 32 33 34 35 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work 36 Nothing in this area will be graded, but it will be submitted with your assignment. 37 38 39 40 41 B Graded Worksheet + Workbook Statistics Calculation Mode: Automatic > nok Pro