Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please answer by showing exel functions. Thanks. 8 9 1 Chapter 13: Applying Excel 2 3 Data 4 Exhibit 13-7 Santa Maria Wool
Can you please answer by showing exel functions. Thanks.
8 9 1 Chapter 13: Applying Excel 2 3 Data 4 Exhibit 13-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: Undyed coarse wool $120,000 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 13 Undyed fine wool $60,000 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 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 $ 200,000 27 Cost of separation process $40,000 28 Combined costs of dyeing $120,000 29 Profit 30 31 Analysis of sell or process further: 32 Coarse 33 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 $ 490,000 320.000 $ 170,000 Fine Wool Superfine Wool ? ? 2 ? 2 + ? 2 ? ? 2 2 ? 40 41 Chantar 13 Form Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started