Homework Help is Here – Start Your Trial Now!
Business
Accounting
A 1 Chapter 13: Applying Excel 2 3 Data 4 Exhibit 13-5 Santa Maria Wool Cooperative 5 Cost of wool 6 Cost of separation process 7 Sales value of intermediate products at split-off point: Undyed coarse wool 8 9 Undyed fine wool 10 Undyed superfine wool 11 Costs of further processing (dyeing) intermediate products: 12 Undyed coarse wool 13 14 15 16 17 18 19 20 Enter a formula into each of the cells marked with a ? below 21 Example: Joint Product Costs and the Contribution Approach 22 Undyed fine wool Undyed superfine wool Sales value of end products: Dyed coarse wool Dyed fine wool Dyed superfine wool 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 27 Cost of separation process 28 Combined costs of dyeing 29 Profit 30 31 Analysis of sell or process further: 32 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 B $228,000 $40,000 $132,000 $122,000 $52,000 $50,000 $60,000 $10,000 $164,000 $232,000 $86,000 $ 228,000 $40,000 $132,000 Coarse Wool C $ 482,000 400,000 $ 82,000 Fine Wool D Superfine Wool $164,000 $232,000 $86,000 $132,000 $122,000 $60,000 $40,000 $86,000 $26,000 $132,000 $60,000 $10,000 -$92,000 $26,000 $16,000 E

A 1 Chapter 13: Applying Excel 2 3 Data 4 Exhibit 13-5 Santa Maria Wool Cooperative 5 Cost of wool 6 Cost of separation process 7 Sales value of intermediate products at split-off point: Undyed coarse wool 8 9 Undyed fine wool 10 Undyed superfine wool 11 Costs of further processing (dyeing) intermediate products: 12 Undyed coarse wool 13 14 15 16 17 18 19 20 Enter a formula into each of the cells marked with a ? below 21 Example: Joint Product Costs and the Contribution Approach 22 Undyed fine wool Undyed superfine wool Sales value of end products: Dyed coarse wool Dyed fine wool Dyed superfine wool 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 27 Cost of separation process 28 Combined costs of dyeing 29 Profit 30 31 Analysis of sell or process further: 32 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 B $228,000 $40,000 $132,000 $122,000 $52,000 $50,000 $60,000 $10,000 $164,000 $232,000 $86,000 $ 228,000 $40,000 $132,000 Coarse Wool C $ 482,000 400,000 $ 82,000 Fine Wool D Superfine Wool $164,000 $232,000 $86,000 $132,000 $122,000 $60,000 $40,000 $86,000 $26,000 $132,000 $60,000 $10,000 -$92,000 $26,000 $16,000 E

Essentials Of Business Analytics
Essentials Of Business Analytics
1st Edition
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Camm, Jeff.
Chapter11: Monte Carlo Simulation
Section: Chapter Questions
Problem 2P
See similar textbooks
icon
Related questions
Question

please fix my excel worksheet and answer this questions as well please as soon as possible: 

In addition possibly answer this too if possible: 

c-2. If your recommendation in part (c-1) is followed, what would be the company’s overall profit?

 

F21 X fx A 1 Chapter 13: Applying Excel 2 3 Data 4 Exhibit 13-5 Santa Maria Wool Cooperative 5 Cost of wool 6 Cost of separation process 7 Sales value of intermediate products at split-off point: 8 Undyed coarse wool 9 Undyed fine wool 10 Undyed superfine wool 11 Costs of further processing (dyeing) intermediate products: Undyed coarse wool 12 13 Undyed fine wool 14 Undyed superfine wool 15 Sales value of end products: 16 Dyed coarse wool 17 Dyed fine wool 18 Dyed superfine wool 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 27 Cost of separation process 28 Combined costs of dyeing 29 Profit 30 31 Analysis of sell or process further: 32 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 B $228,000 $40,000 $132,000 $122,000 $52,000 $50,000 $60,000 $10,000 $164,000 $232,000 $86,000 Coarse Wool C $ 228,000 $40,000 $132,000 400,000 $ 82,000 $ 482,000 $132,000 -$92,000 Fine Wool $164,000 $232,000 $132,000 $122,000 $40,000 $86,000 $60,000 $26,000 D Superfine Wool $86,000 $60,000 $26,000 $10,000 $16,000 E
Transcribed Image Text:F21 X fx A 1 Chapter 13: Applying Excel 2 3 Data 4 Exhibit 13-5 Santa Maria Wool Cooperative 5 Cost of wool 6 Cost of separation process 7 Sales value of intermediate products at split-off point: 8 Undyed coarse wool 9 Undyed fine wool 10 Undyed superfine wool 11 Costs of further processing (dyeing) intermediate products: Undyed coarse wool 12 13 Undyed fine wool 14 Undyed superfine wool 15 Sales value of end products: 16 Dyed coarse wool 17 Dyed fine wool 18 Dyed superfine wool 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 27 Cost of separation process 28 Combined costs of dyeing 29 Profit 30 31 Analysis of sell or process further: 32 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 B $228,000 $40,000 $132,000 $122,000 $52,000 $50,000 $60,000 $10,000 $164,000 $232,000 $86,000 Coarse Wool C $ 228,000 $40,000 $132,000 400,000 $ 82,000 $ 482,000 $132,000 -$92,000 Fine Wool $164,000 $232,000 $132,000 $122,000 $40,000 $86,000 $60,000 $26,000 D Superfine Wool $86,000 $60,000 $26,000 $10,000 $16,000 E
If your formulas are correct, you should get the correct answers to the following questions. a. What is the overall profit if all intermediate products are processed into final products? X Answer is not complete. Overall profit from processing all intermediate products b. What is the financial advantage (disadvantage) from further processing? Financial (disadvantage) Financial advantage Financial advantage X Answer is complete but not entirely correct. from further processing undyed coarse wool from further processing undyed fine wool from further processing undyed superfine wool $ $ $ (92,000) 26,000 16,000
Transcribed Image Text:If your formulas are correct, you should get the correct answers to the following questions. a. What is the overall profit if all intermediate products are processed into final products? X Answer is not complete. Overall profit from processing all intermediate products b. What is the financial advantage (disadvantage) from further processing? Financial (disadvantage) Financial advantage Financial advantage X Answer is complete but not entirely correct. from further processing undyed coarse wool from further processing undyed fine wool from further processing undyed superfine wool $ $ $ (92,000) 26,000 16,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS