Problem 4 - Activity Based Costing Orange Computer Company produces two types of laptop computers. Model J3MP has a 15" screen and a 8MB hard disk. Model P5NX has a 20" screen and a 20MB hard disk. The Model J3MP computer sells for $1,200.00 per unit and the Model P5NX sells for $2,250.00 per unit. Current planned production: Model J3MP - 5,000 units Model P5NX - 4,500 units Cost Pool Expected Amount Application Rate Overhead Activity Driver Amount Assembly Department 1,480,000 Machine Hours Assembling 32,000 hours Machine Setups 398,275 Number of Setups 445 setups Material Handling 196 76,800 No. of Production Runs Packaging Department $324,700 Labor Hours 195,500 Inspecting and Packaging Shipping $105,000 No. of Shipments 1600 Total $2,384.775 Job or Product Product JUMP Product P5NX Total Assembling Number of Production Labor Hours No. of Setups Runs Shipments 6,000 45 46 60,000 200 26,000 400 50 400 32,000 445 96 95,500 600 35,500 Required: Using Excel, prepare worksheet to compute the cost per unit for each product using Activity Based Costing. Compute the Profit Margin per unit and Profit Margin Percentage for each product. . Use the table provided as a guideline to organize your worksheet. Save your completed file using the following filename: (yourname) P4 Orange Computer - Activity Based Costing.xls Activity Based Costing Template Computation of Rates Cost Pool Cost Pool Amount Activity Base Activity Amount Rate Cost - Product ABC Cost of Product XYZ XYZ Assumptions ABC 35,200 62,150 Direct Materials Direct Labor 28,700 50,500