**show all formulas

Chapter 12: Applying Excel $200,000 $40,000 $120,000 $150,000 $60,000 Data Exhibit 12-7 Santa Maria Wool Cooperative Cost of wool Cost of separation process Sales value of intermediate products at split-off point: Undyed coarse wool Undyed fine wool Undyed superfine wool Costs of further processing (dyeing) intermediate products: Undyed coarse wool Undyed fine wool Undyed superfine wool Sales value of end products: Dyed coarse wool Dyed fine wool Dyed superfine wool $50,000 $60,000 $10,000 $160,000 $240,000 $90,000 Enter a formula into each of the cells marked with a ? below Example: Joint Product Costs and the Contribution Approach Analysis of the profitability of the overall operation: Combined final sales value Less costs of producing the end products: Cost of wool Cost of separation process Combined costs of dyeing Profit Analysis of sell or process further: Coarse Wool Fine Wool Superfine Wool Final sales value after further processing Less sales value at the split-off point Incremental revenue from further processing Less cost of further processing (dyeing) Profit (loss) from further processing