B D E F G A1 x fx Chapter 11: Applying Excel A 1 Chapter 11: Applying Excel 2 3 Data 4 Exhibit 11-7 Santa Maria Wool Cooperative 5 Cost of wool $200,000 6 Cost of separation process $40,000 7 Sales value of intermediate products at split-off point: 8 Undyed coarse wool $120,000 9 Undyed fine wool $150,000 10 Undyed superfine wool $60,000 11 Costs of further processing (dyeing) intermediate products: 12 Undyed coarse wool $50,000 11 Undyed fine wool $60,000 pc 14 Undyed superfine wool $10,000 15 Sales value of end products: 16 Dyed coarse wool $160,000 17 Dyed fine wool $240,000 18 Dyed superfine wool $90,000 20 Enter a formula into each of the cells marked with a ? below 21 Example: Joint Product Costs and the Contribution Approach 22 23 Analysis of the profitability of the overall operation: 24 Combined final sales value 25 Less costs of producing the end products: Cost of wool 27 Cost of separation process Combined costs of dyeing 29 Profit 13 19 ? 26 ? ? 2 28 ? ? 20 Fine Wool 30 31 Analysis of sell or process further: 32 oc 33 34 Final sales value after further processing 35 Less sales value at the split-off point 36 Incremental revenue from further processing 37 Less cost of further processing (dyeing) 38 Financial advantage (disadvantage) of further processing 39 40 41 Coarse Wool ? ? ? ? ? ? ? ? ? ? Superfine Wool ? ? ? ? ? 99