Allocating Joint Product Costs and Decsions to Process Further 3 Build a worksheet to allocate joint product costs using the physical units method, and the NRV 4 method. Also determine which proucts should be processed further. 6 2 Douglas manufactures four grades of lubricant, W-10 W-20, W-30, and W-40, from a joint process. Additional information follows: total joint costs of $240,000 Units Product Produced W-10 35.000 W-20 25.000 W-30 20.000 W-40 20.000 100.000 Sales Value at Split-Off $210.000 180.000 120.000 90,000 S600.000 If Processed Further Additional Sales Costs Values $22.500 $270,000 18.000 210.000 12.000 150.000 7.500 90.000 $60.000 $720.000 20 Joint Product Costs $ 270,000 Assume no estimated sales value at the split-off point is available, and calculate the Estimated NRV. Estimated NRV S 23 Product 24 W-10 25 W-20 26 W-30 27 W-40 Sales Value at Units Produced Split Off 35,000 $ 210,000 210.000 25,000 180,000 20,000 120,000 20,000 90,000 100,000 600,000 If Processed further Additional Costs Sales Value 22,500 $ 270,000 18,000 210,000 12,000 150,000 7,500 90,000 60,000 720,000 Physical Units Using an If Statement: http://youtu.b 31 Product 32 W-10 33 W-20 34 W-30 35W-40 Allocated cost Sales Value at Split Off Estimated NRV Process Futher 94,500 $ 101,250 81,000 648,000 54,000 54,000 40,500 33,750 270.000 837,000 67,500 54,000 54,000 270.000