C24 X V fx ? A B C D E F Chapter 13: Applying Excel Data Exhibit 13-5 Santa Maria Wool Cooperative Cost of wool $228,000 Cost of separation process $40,000 Sales value of intermediate products at split-off point: Undyed coarse wool $132,000 LO 00 Undyed fine wool $122,000 10 Undyed superfine wool $52,000 11 Costs of further processing (dyeing) intermediate products: 12 Undyed coarse wool $50,000 13 Undyed fine wool $60,000 14 Undyed superfine wool $10,000 15 Sales value of end products: 16 Dyed coarse wool $164,000 17 Dyed fine wool $232,000 18 Dyed superfine wool $86,000 19 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: 26 Cost of wool $ 228,000 27 Cost of separation process $40,000 28 Combined costs of dyeing 29 Profit ? 30 31 Analysis of sell or process further: 32 Coarse Fine Superfine 33 Wool Wool Wool 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