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

Principles of Accounting Volume 2
Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter10: Short-term Decision Making
Section: Chapter Questions
Problem 15MC: When operating in a constrained environment, which products should be produced? A. products with the...
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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS