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: Added Cost per Cubic DATA Market Value per Cubic Yard at Split-Off $21 27 23 Joint product Wood chips Wood pulp Mulch Yard Cubic Yards per Batch 20,550 9,550 14,700 Market Price per Cubic Yard $21 35 31 $0 $5 4 Joint Costs $36,000 36,000 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 Net Realizable Value per Cubic Yard Greater of Total NRV and Total Net Market Value Realizable Value at Split-Off Proportion Joint product Wood chips Wood pulp Mulch Totals Allocation = Data