1 Chapter 11: Applying Excel 4 Exhibit 11.7 Santa Maris Wool Cooperative 5 Cast of wool 6 Cast of separation CSS 7 Sales va intermediate products a ll of it 22.000 50.000 $199.000 51140 $50.000 10 Unded supertine wool 11 Cost of u r processing dying intermediate products $50.000 550.000 $50.000 13 Undyed fine wool 14 Unted supertine 15 Saks value and products 16 Dyed on wool 17 Dyed in wool 18 Dyed superfine wool $147.000 5197,090 $17.000 20 Enter a forma into each of the cols marked with a below 21 Example Product Cows and the Contribution Approach 23 Analysis of the profitability of me overall operation 24 Combined fralles value 25 Lass costs of producing the end products 26 Cost of wool 27 Cast of separation process 28 Omned cons of dying 29 Pratt $ 11,000 120.000 300.000 SO1 31 Analysis of sell or process further Care Separte Chapter 11 Form 550.000 550 000 10 Undyed perline wool 11 Costs of the processing iyong termediate products 12 Undyed course wool 13 Undyed fine wol 14 Undyed superine wool 15 Salas value of and products 16 Dyed coarse wool 17 Dyed fine wool 18 Dyed superfine wool $90 000 $147 000 $117 000 597,000 20 E ra forma into each of the cele marked with a below 21 Example: Joint Product costs and the Contribution Approach 23 Analysis of the profitability of the overall operation 24 Combined inal sales vale 25 less costs of producing the end products 27 Cost of separation process 29 Combined costs of dyeing 29 Pont 26 Con $ 69,000 31 Analysis of all or process further 34 Final sales weer the processing 35 les sales we the sit-off point 36 hcrementale m rther processing 37 less cost of the processing dying 38 Financin g of the processing Superfine Hool $ 147 000 $ 197,000 $ 97000 1000 164 000 50.000 47.000 53000 99.000 S20002000017000 SOBTE Windows 431 Chapter 11 Form Answer is complete and correct. Sell as is or process further the intermediate product undyed coarse wool? Sell as is or process further the intermediate product undyed fine wool? Sell as is or process further the intermediate product undyed superfine wool? Sell as is Sell as is Process further C-2. If your recommendation in part (C-1) is followed, what would be the company's overall profit? Answer is not complete. Overall profit from following the plan in part (c)