I need help calculating simple cost allocation for plantwide overhead rate, allocated overhead rate, unit production cost, and gross profit per unit. Both models a and b. Please show steps. Thanks!

Excel File Edit View Insert Format Tools Data Window Help Home Insert Page Layout Formulas DataReview View Copy Paste BI Merge ' Format D21 Product Data Model A 30,000 Model B Units produced & sold 5 Sales Revenue Prime cost Direct Labor Hours l of Machine hours U of Set 51,500,000.00 $ 250,000.00 400,000 90,000 50 2,500,000.00 600,000 10,000 10 of Inspection runs 11of packing orders 2,400 120,000 0,000 12 Manufacturing 13 Overhead Costs: 160,000.00 315,000.00 220,000.00 Machinin 15 16 17 18 Inspection costs Packing Costs Total 19 20 1) Simple Cost Allocation 21Plantwide OH Rate Model B 23 Allocated OH 24 25 26 Unit Product Cost 27 28 29 0 Gross Profit per Unit 31 32 s Aactbvity Basved Costing Model B 36 Template Sheet3+ Ready