Answer the question

Joint cost allocation net realizable value method Nature's Garden Inc. produces wood chips, wood pulp, and mulch. These products are produced through harvesting trees and sending the logs through a wood chipper machine. One batch of logs produces 20,578 cubic yards of wood chips, 14,150 cubic yards of mulch, and 9,682 cubic yards of wood pulp. The joint production process costs a total of $36,000 per batch. After the split-off point, wood chips are immediately sold for $20 per cubic yard while wood pulp and mulch are processed further. The market value of the wood pulp and mulch at the split-off point is estimated to be $30 and $29 per cubic yard, respectively. The additional production process of the wood pulp costs $6 per cubic yard, after which it is sold for $38 per cubic yard. The additional production process of the mulch costs $5 per cubic yard, after which it is sold for $37 per cubic yard. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Allocate the joint costs of production to each product using the net realizable value method. Do not round intermediate calculations. Round your answers to the nearest dollar. Joint Product Allocation Wood chips Wood pulp Mulch Totals Joint cost allocation - net realizable value method Nature's Garden Inc. produces wood chips, wood pulp, and mulch. These products are produced through harvesting trees and sending the logs through a wood chipper machine. The following data is provided: Cubic Yards per Batch Joint product Wood chips Wood pulp Mulch DATA Market Value per Cubic Yard at Split-Off $20 30 29 20,578 9,682 14,150 Market Price per Cubic Yard $20 38 37 Added Cost per Cubic Yard Joint Costs $0 $36,000 $6 36,000 5 36,000 Using formulas and cell references, perform the required analysis, and input your answers into the B, C, D, E, F, and G columns. Use the blue entry cells (B14:F16, E17) for intermediate calculations. Transfer the numeric results for the green entry cells (G14:G17) into the appropriate fields in CNOWv2 for grading. Total Market Value at Split-Off Formulas Greater of Total NRV and Market Value at Split-Off Net Realizable Value per Cubic Yard Total Net Realizable Value Proportion Allocation Joint product Wood chips Wood pulp Mulch Totals