File Home Insert Draw Formulas Data Review View Help Calibri (Body) 11 B A ab A1 A 1 Editing Comments General ... fx Accessibility tab summary: Information about Lucern Company is provided in row 2. A data table is provided in A4 to B C Lucern Company reports the following for its overhead cost for the year. 2 (Click on the Part 1 and Part 2 Tabs below.) D E McGraw Hill 34 4 Activity Budgeted Cost Budgeted Activity Usage 5 Engineering support $24,500 6 Electricity 34,000 7 Setup 52,500 70 design changes 3,400 machine hours 350 setups Check Answers Check My Work Legend 8 9 Required: 10 1. Compute the activity rate for each activity using activity-based costing. 11 12 2. The company's Pro model used these activities to produce 1,200 units during the year: 2 desig 13 changes, 140 machine hours, and 12 setups. Allocate overhead cost to the Pro model and compu 14 its overhead cost per unit using activity-based costing. 15 16 17 18 Students: The scratchpad area is for you to do any additional work you need to solve this questio 19 Nothing in this area will be graded, but it will be submitted with your assignment. 20 Graded cell: Leave blank if no answer is needed. Scratchpad: Use as a non-graded workspace 21 22 23 24 25 26 27 Save and Return to Assignment < Question Data Part 1 Part 2 +