Pad 10:43 PM Copy of Excel Project 1 S17 template [Read-Only] Home Insert Draw Formulas Data Review View ABC Genera 23 Calibr 11 Product Data Model A Model B 3 Units produced & sold per year 50,000 500,00 Sales Revenue 1750,000.00 7,500,000.00 Prime Cost 125,000.00 250,000.00 6 of Direct Labor Hours 125.000 475,00 of Machine hours 50,000 450,00 8 of Set Ups 25 200 9 of Inspection runs 80 10 of packing orders 12,000 68,00 Manufacturing overhead costs: 2 Machining 150,000.00 set up costs 280,000.00 Inspection costs 180,000.00 Packing costs 260,000.00 870,000.00 Sim e or Traditional Cost Alloca Model A Model B 20 Plant-wide MOH Rate 45 45 21 $181.250.00 22 Allocated MOH $688,750.00 23 $125 000.00 24 Direct Materials & Direct Labor $1,250,000.00 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 Model A Model B Based Costin 35 Activity Rates 36 37 Machining 38 Setup costs 39 Inspection costs 40 Packing Costs 41 42 Allocated MoH Sheet3 Sheet Sheet2 71% Sum 0