use a Excel doccument please and thank you.

APPENDIX - MANUAL, OFF-LINE HOMEWORK ASSIGNMENT EXERCISE H2 worth 2 points Mordica Company identifies three activities in its manufacturing process: machine setups, machining and inspections. Estimated annual overhead cost for each activity is $150,000, $325,000, and $87.500, respectively. The cost driver for each activity and the expected annual usage are number of setup 2.500, machine hours 25,000, and number of inspections 1.750 Instructions Please use an Excel spreadsheet to compute the overhead rate for each activity and upload it into Canvas. Clearly mark each activity's answer. EXERCISE HSfworth 6 points): Schule Electronics manufactures two large-screen devision models the Royale which sells for $1.600, and a new model the Majestic which sells for 51,300 Tive production cost computed per unit under traditional costing for each modelin 2020 was as follows Assige overhead to products using ABC and evaluate decision Traditional Costing Royale Majestic Direct materials 5700 5420 Direct labor (20 per hour 120 100 Manufacturing overhead ($38 per DLH) 228 190 Total petto 51,046 5710 In 2020. Schatz manufactured 25.000 units of the Royale and 10.000 units of the Mapestic The overhead rate of $38 per direct labor hour was determined by dviding total expected manufacturing overhead of 57,600,000 by the relatior hours (200.000) for the two models Under traditional couting, the grote proft on the models was Royale 5662 or (51900 - 51045) and Marc 690 or 51 300 - 5710). Because of this difference management is considering phasing out the Royale model and increasing the prediction of the Malic model Before finaling is decision management and Schulte's conter to prepare an y based couting (ABC) The core of the following Information about overhead for the yewended December 31 2020 Activities Cost Drivers Estrated Expected Use of Activity Based Ova Cost Drivers Overhead Rate Purchasing Number of 51.200.000 10.000 Sidor orders Machine umber of 900.000 1000 seup pe Activities Cost Drivers Estimated Expected Use of Activity-Based Overhead Cost Drivers Overhead Rate Machining Machine hours 4.800,000 120.000 S40/hour Quality Number of 700.000 28.000 $25Anspection control Inspection The con divers used for each product were Cost Delvers Royale Majestic Total Purchase orders 17.000 23.000 40.000 Machine setups 5.000 13000 18,000 Machine hours 75.000 45.000 120,000 Inspections 11,000 17 000 28,000 Instructions Please use an Excel spreadsheet for your answers, dearly marking the answers to each requirement () - Id and upload isto Canvas a. Assign the total 2020 manufacturing overhead costs to the two products using activity based coring (ABC) and determine the overhead cost per un . What was the cost per unit and grom peollt of each modeling ABC? c. Are management's he plans for the treo models sound? Explain APPENDIX - MANUAL, OFF-LINE HOMEWORK ASSIGNMENT EXERCISE H2 worth 2 points Mordica Company identifies three activities in its manufacturing process: machine setups, machining and inspections. Estimated annual overhead cost for each activity is $150,000, $325,000, and $87.500, respectively. The cost driver for each activity and the expected annual usage are number of setup 2.500, machine hours 25,000, and number of inspections 1.750 Instructions Please use an Excel spreadsheet to compute the overhead rate for each activity and upload it into Canvas. Clearly mark each activity's answer. EXERCISE HSfworth 6 points): Schule Electronics manufactures two large-screen devision models the Royale which sells for $1.600, and a new model the Majestic which sells for 51,300 Tive production cost computed per unit under traditional costing for each modelin 2020 was as follows Assige overhead to products using ABC and evaluate decision Traditional Costing Royale Majestic Direct materials 5700 5420 Direct labor (20 per hour 120 100 Manufacturing overhead ($38 per DLH) 228 190 Total petto 51,046 5710 In 2020. Schatz manufactured 25.000 units of the Royale and 10.000 units of the Mapestic The overhead rate of $38 per direct labor hour was determined by dviding total expected manufacturing overhead of 57,600,000 by the relatior hours (200.000) for the two models Under traditional couting, the grote proft on the models was Royale 5662 or (51900 - 51045) and Marc 690 or 51 300 - 5710). Because of this difference management is considering phasing out the Royale model and increasing the prediction of the Malic model Before finaling is decision management and Schulte's conter to prepare an y based couting (ABC) The core of the following Information about overhead for the yewended December 31 2020 Activities Cost Drivers Estrated Expected Use of Activity Based Ova Cost Drivers Overhead Rate Purchasing Number of 51.200.000 10.000 Sidor orders Machine umber of 900.000 1000 seup pe Activities Cost Drivers Estimated Expected Use of Activity-Based Overhead Cost Drivers Overhead Rate Machining Machine hours 4.800,000 120.000 S40/hour Quality Number of 700.000 28.000 $25Anspection control Inspection The con divers used for each product were Cost Delvers Royale Majestic Total Purchase orders 17.000 23.000 40.000 Machine setups 5.000 13000 18,000 Machine hours 75.000 45.000 120,000 Inspections 11,000 17 000 28,000 Instructions Please use an Excel spreadsheet for your answers, dearly marking the answers to each requirement () - Id and upload isto Canvas a. Assign the total 2020 manufacturing overhead costs to the two products using activity based coring (ABC) and determine the overhead cost per un . What was the cost per unit and grom peollt of each modeling ABC? c. Are management's he plans for the treo models sound? Explain