please solve it and explain in excel

Services / Student Portal * $ McGraw-Hill Connect . MGMT85 X Question 2 - ABC Group Assignn X My Profile . Zoom - > C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%2521%252Fims.mheducation.com%252Fmghmiddleware.252Fm... 1: Apps G Gmail YouTube Maps Reatfin ABC Group Assignment Version 5.4 and 5.10 Saved Help Save & Exit Submit base pertaining to each department. For 2022, the following overhead costs were estimated in each of the two departments: 2 Estimated Overhead Cost and Activity Level Machining department $556,000 (206,000 machine-hours) Assembly department $527, 100 (349,000 direct labour-hours) 10 points Consider the following information regarding the actual consumption of resources by each of the four products in 2022: Skipped Regular Standard Business Deluxe Machine-hours 91,000 82, 000 18, 000 15,000 Direct labour-hours 130, 000 150, 060 30, 000 39,000 Prime costs (per unit) $ 15.5 $ 23.6 $ 35.6 $ eBook Print Required: 1. Compute the profitability of each type of chair (please show all the computational steps). 2. In late 2022, Linsey Lindsay, the chief cost accountant, attended a week long workshop entitled "Advanced Cost Management Methods" offered at a local university. One particular concept she caught on to was activity-based costing, . . think she decided to implement Cha found that the total solarband of $1 107 1An consisted of film cant itome and of Mc Next Mc G * ezto.mheducation.com/ext/map/index.html?_con=con&external browser=0&launchUrl=https%253A%2526%252Fims.mheducation.com%252Fmghmiddleware96252Fm. i: Apps G Gmail YouTube Maps [ Reading ABC Group Assignment Version 5.4 and 5.10 Saved Help Save & Exit Submit 2 She further determined the following consumption of resources across the four products: Regular Standard Business Deluxe Total Number of batches 8 10 20 25 63 Setup time per batch 1.5 1.0 2.0 310 Machine-hours 91, 000 000'78 18 , 000 15, 000 206,000 Labour-hours 130,000 150,000 30,000 39,000 349,000 10 Maintenance calls 40 32 20 18 110 points Maintenance-hours 236 210 198 176 820 Engineering-hours 166 156 112 136 570 Skipped 2-a. Prepare a table listing the different activities, costs associated with each activity, the appropriate allocation base and eBook the allocation rate for each activity. 2-b. Using the above activity rates, assign the costs to each of the four types of chairs and determine their profitability. For Print simplicity, assign the facility-level costs equally among the four products. 3. This part of the question is not part of your Connect assignment. Camplata thing Mc