Please Solve the Activity-Based Costing table using excel formulas

A B C D E F G 1 2 3 $ 4 5 6 7 8 Units produced & sold per year Sales Revenue Prime Cost # of Direct Labor Hours # of Machine hours # of Set Ups # of Inspection runs # of packing orders 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 9 10 11 12 13 14 15 16 17 18 Manufacturing Overhead Costs: Machining Setup costs Inspection costs Packing Costs Total to to toto 160,000.00 180,000.00 140,000.00 180,000.00 660,000.00 $ 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