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.
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
