Transcribed Image Text
In: Accounting2. In industries that process joint products, the costs of theraw materials inputs and the...2. In industries that process joint products, the costs of theraw materials inputs and the sales values of intermediate and finalproducts are often volatile. Change the data area of your worksheetto match the following:AB123456789101112131415161718Chapter 6: Applying ExcelDataExhibit 6-7 Santa Maria WoolCooperativeCost of wool$233,000Cost of separation process$40,000Sales value of intermediate products atsplit-off point:Undyed coarse wool$132,000Undyed fine wool$148,000Undyed superfine wool$70,000Costs of further processing (dyeing)intermediate products:Undyed coarse wool$50,000Undyed fine wool$60,000Undyed superfine wool$10,000Sales value of end products:Dyed coarse wool$158,000Dyed fine wool$190,000Dyed superfine wool$86,000If your formulas are correct, you should get the correct answersto the following questions.a. What is the overall profit if all intermediate products areprocessed into final products?Overall profit from processing allintermediate productsb. What is the financial advantage (disadvantage) from furtherprocessing?from further processing undyed coarsewoolfrom further processing undyed finewoolfrom further processing undyedsuperfine woolc-1. With these new costs and selling prices, whatrecommendations would you make concerning the company’soperations?Sell as is or process further the intermediate productundyed coarse wool?Sell as is or process further the intermediate productundyed fine wool?Sell as is or process further the intermediate productundyed superfine wool?c-2. If your recommendation in part (c-1) is followed, whatwould be the company’s overall profit?Overall profit from following the planin part (c)