Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Check your worksheet by changing the cost of further processing undyed coarse wool in cell B12 to $30,000. The overall financial advantage (disadvantage) from processing

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Check your worksheet by changing the cost of further processing undyed coarse wool in cell B12 to $30,000. The overall financial advantage (disadvantage) from processing all intermediate products into final products should now be $150,000 and the financial advantage (disadvantage) from further processing undyed coarse wool should now be $10,000. If you do not get these answers, find the errors in your worksheet and correct them.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
WPS Office [5 Chapter_13_Ap.._Student_Form Q X + 1 Sign in Go Premium X = Menu v Home Insert Page Layout Formulas Data Review View Tools Q Click to find commands F37 B fx A B C D E F G H J K L M N 3 Data Exhibit 13-7 Santa Maria Wool Cooperative Cost of wool $200,000 Cost of separation process $40,000 Sales value of intermediate products at split-off point: LD CO 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 $ 490,000 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 100,000 340,000 29 Profit $ 150,000 30 31 Analysis of sell or process further: 32 Coarse Fine Superfine 33 Wool Wool Woo 34 Final sales value after further processing $ 160,000 $ 240,000 $ 90,000 K > Chapter 13 Form + 11 4 100% * - + Type here to search a V7 ADD / * ENG 12:52 AM 6/10/2021McGraw-Hill Connect X 5 Question 2 - Chapter Thirteen Ex X * Course Hero X + X C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%252Fm... To Apps Ill Appellate Division -... WAMAP - Math 14... 5 Precalculus C Q:Paparo Corporati.. D| Mathway | Calculus... (10) Limits and cont.. b trignometry - Bing... > > Reading list Chapter Thirteen Excel (5 pts.) Saved Help Save & Exit Submit Check my work 2 Required information Part 2 of 2 A B 1 Chapter 13: Applying Excel 2 2.5 3 Data points 4 Exhibit 13-7 Santa Maria Wool Cooperative 5 Cost of wool $ 208,000 eBook 6 Cost of separation process $ 40,000 7 Sales value of intermediate products at split-off point: Print 8 Undyed coarse wool 128,000 References 9 Undyed fine wool 146,000 10 Undyed superfine wool $ 62,000 1 1 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 $ 169,000 Mc Hill Type here to search V7 A DOX ENG 12:53 AM a 6/10/2021McGraw-Hill Connect X 5 Question 2 - Chapter Thirteen Ex X * Course Hero X + X C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%2530%252F%252FIms.mheducation.com%252Fmghmiddleware%252Fm... To Apps Ill Appellate Division -.. WAMAP - Math 14... ) Precalculus C Q:Paparo Corporati... D Mathway | Calculus... (10) Limits and cont.. b trignometry - Bing... > > Reading list Chapter Thirteen Excel (5 pts.) Saved Help Save & Exit Submit Check my work 2 Required information 12 Undyed coarse wool $ 50.000 13 Part 2 of 2 Undyed fine wool 60,000 14 Undyed superfine wool $ 10,000 15 Sales value of end products: 2.5 16 Dyed coarse wool 169,000 points 17 Dyed fine wool $ 203,000 18 Dyed superfine wool $ 91,000 eBook Print References 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? Overall profit from processing all intermediate products Mc Graw Hill Type here to search 12:53 AM a V7 A DOX ENG 6/10/2021McGraw-Hill Connect X 5 Question 2 - Chapter Thirteen Ex X * Course Hero X + X C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Films.mheducation.com%252Fmghmiddleware%252Fm... To Apps Ill Appellate Division -.. WAMAP - Math 14... S Precalculus C Q:Paparo Corporati... D Mathway | Calculus... @(10) Limits and cont.. b trignometry - Bing... > > Reading list Chapter Thirteen Excel (5 pts.) Saved Help Save & Exit Submit Check my work 2 ! Required information Part 2 of 2 b. What is the financial advantage (disadvantage) from further processing? 2.5 points from further processing undyed coarse wool eBook from further processing undyed fine wool Print from further processing undyed superfine wool References Mc Hill 12:53 AM Type here to search a V7 A DOX ENG 6/10/2021McGraw-Hill Connect X 5 Question 2 - Chapter Thirteen Ex X * Course Hero X + X C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%252Fm... To Apps Ill Appellate Division -.. WAMAP - Math 14... S Precalculus C Q:Paparo Corporati... D| Mathway | Calculus... (10) Limits and cont.. b trignometry - Bing... > > Reading list Chapter Thirteen Excel (5 pts.) Saved Help Save & Exit Submit Check my work 2 ! Required information Sell as is or process further the intermediate product undyed coarse wool? Part 2 of 2 Sell as is or process further the intermediate product undyed fine wool? Sell as is or process further the intermediate product undyed superfine wool? 2.5 points eBook Print References c-2. If your recommendation in part (c-1) is followed, what would be the company's overall profit? Overall profit from following the plan in part (c) Mc Graw Hill Type here to search Fi V7 A DOX ENG 12:54 AM 6/10/2021

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

11th Edition

1119594596, 978-1119594598

More Books

Students also viewed these Accounting questions

Question

Food supply

Answered: 1 week ago

Question

Mortality rate

Answered: 1 week ago