Lily's Garden Inc. produces wood chips, wood pulp, and mulch. These products are produced through harvesting trees and sending the logs through a woodchipper machine. One batch of logs produces 20,304 cubic yards of wood chips, 14,100 cubic yards of mulch, and 9,024 cubic yards of wood pulp. The joint production process costs a total of $32,000 per batch. After the split-off point, wood chips are immediately sold for $ 25.00 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 $22.00 and $24.00 yard, after which it is sold for $ 30.00 per cubic yard. The additional production process of the mulch costs $ 4.00 per cubic yard, after which it is sold for $ 32.00 per cubic yard. Allocate the joint costs of production to each product using the net realizable value method. Please use the Excel template provided to assist you in solving this problem. Allocation Joint Product Cubic yards Total Market value at Total Net Realizable Market Value per cubic yard Greater of Total NRV Market Price per cubic yard Added Costs per cubic yard Net Realizable Value per Percentage Proportion Joint Costs per batch Value or Market Split-off Cubic Value at Split-off at split- off yard