Please Solve the Departmental OH Allocation 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 I 55 Departmental MOH Rates: $ 1.25 Department 2 Assembly $ 2.75 Department 1 Fabrication Machine Hours 56 57 Direct Labor Hours 58 Model A 55,000 145,000 110,000 330,000 59 Model B 60 61 Model A Model B Departmental OH Allocation Direct Materials & Direct Labor Allocated MOH Dept 1 Allocated MOH Dept 2 Total Product Costs 62 63 64 65 66 67 68 69 70 71 72 73 74 Product Cost (CGS) per unit Selling Price per unit CGS per unit Gross Profit per Unit