Sonimad Sawmill, Inc. (SSI), purchases logs from independent timber contractors and processes them into the following three types of lumber products: 1. Studs for residential construction (e.g., walls and ceilings) 2. Decorative pieces (e.g., fireplace mantels and beams for cathedral ceilings) Posts used as support braces (e.g., mine support braces and braces for exterior fences around ranch properties) These products are the result of a joint sawmill process that involves removing bark from the logs, cutting the logs into a workable size (ranging from 8 to 16 feet in length), and then cutting the individual products from the logs, depending upon the type of wood (pine, oak, walnut, or maple) and the size (diameter) of the log The joint process results in the following costs and output of products during a typical month Joint production costs Materials (rough timber logs) Debarking (labor and overhead) Sizing (labor and overhead) Product cutting (labor and overhead) $500,000 50,000 200,000 250,000 $1,000,000 Total joint costs Product yield and average sales value on a per-unit basis from the joint process are as follows Monthly Fully Processed Product Studs Decorative pieces Posts Output 70,000 5,000 25,000 Sales Price $8 100 20 The studs are sold as rough-cut lumber after emerging from the sawmill operation without further processing by SSI. Also, the posts require no further processing. The decorative pieces must be planed and further sized after emerging from the SSI sawmill. This additional processing costs SSI $100,000 per month and normally results ina loss of 10 percent of the units entering the process. Without this planing and sizing process, there is still an active intermediate market for the unfinished decorative pieces where the sales price averages $60 per unit. Required: 1. Based on the information given for Sonimad Sawmill, Inc., allocate the joint processing costs of $1,000,000 to each of the three product lines using the a. Relative sales-value-at-split-off method. When required, round decimal values to four places before converting to a percentage. For example, .88349 would be rounded to 8835 and entered as "88.35" percent. Monthly Unit Output Sales Price Relative Sales Value Percent of Allocated Joint per Unit at Split-Off Sales Costs Studs Decorative pieces Posts 70,000 8 560,000V 41.18 % 415,918 X 300,000 222,806 X 371,276 X 1,010,000 X 5,000 60 V 22.06 % 25,000 500,000 36.76 % $1,360,000V 100 Total (Note: Difference due to rounding.) b. Physical units method at split-off % Allocated Joint Units Percent Joint Cost Costs Studs Decorative pieces Posts Total 70V% $ 1,010,000 x 1,010,000 X 1,010,000 X 70,000 5,000V 25,000 25 % 100,000 c. Estimated net realizable value method. When required, round decimal values to four places before converting to a percentage. For example, .88349 would be rounded to 8835 and entered as "88.35" percent. Fully Processed Monthly Unit Output Estimated Allocated Joint Costs Sales Price Net Realizable Value 560,000 Percent of per Unit Value 70,000 V$ Studs Decorative pieces Posts 39.72 % ,500 100 350,000 24.82 % 25,000 500,000 35.46 % Total $1,410,000 100 %$ (Note: Difference due to rounding.) 2. Prepare an analysis for Sonimad Sawmill, Inc., to compare processing the decorative pieces further as it presently does, with selling the rough-cut product immediately at split-off Sonimad Sawmill, Inc. Analysis Report Monthly unit output Less: Normal further processing shrinkage Units available for sale Final sales value Less: Sales value at split-off Differential revenue Less: Further processing costs Additional contribution from further processing