Please solve the Simple Cost Allocation Table using excel formulas.

K28 fx B C D E G H $ $ Product Data Model A 20,000 600,000.00 $ 100,000.00 $ 140,000 20,000 40 600 9,000 Model B 200,000 6,000,000.00 1,000,000.00 300,000 180,000 160 1,400 81,000 $ $ $ $ $ 160,000.00 180,000.00 140,000.00 180,000.00 660,000.00 Model A el B 1 2 3 Units produced & sold per year 4 Sales Revenue 5 Prime Cost 6 # of Direct Labor Hours # of Machine hours 8 # of Set Ups 9 # of Inspection runs 10 # of packing orders 11 12 Manufacturing Overhead Costs: 13 Machining 14 Setup costs 15 Inspection costs 16 Packing Costs 17 Total 18 19 Simple Cost location 20 Plant-wide MOH Rate 21 22 Allocated MOH 23 24 Direct Materials & Direct Labor 25 Allocated MOH 26 Total Product Costs 27 28 Product Cost (CGS) per unit 29 30 Selling Price per unit 31 CGS per unit 32 Gross Profit per Unit 33 34 35 Activity-Based Costing 36 37 Machining 38 Setup costs 39 Inspection costs 40 Packing Costs 41 42 Allocated MOH 43 44 Direct Materials & Direct Labor Template + Model A Model B Activity Rates A B C D E F G H J 34 Activity-Based Costing Model A Model B Activity Rates Machining Setup costs Inspection costs Packing Costs Allocated MOH 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Direct Materials & Direct Labor Allocated MOH Total Product Costs Product Cost (CGS) per unit Selling Price per unit CGS per unit Gross Profit per Unit 54 55 Departmental MOH Rates: $ 1.25 Department 2 Assembly 56 $ 2.75 Department 1 Fabrication Machine Hours 55,000 145,000 57 Direct Labor Hours 58 Model A 110,000 330,000 59 Model B 60 C