Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pls include the excel formulas! Thank You! For example, in cell C26 enter the formula = B5. Verify that your worksheet matches the example in

image text in transcribedimage text in transcribed

pls include the excel formulas! Thank You!

For example, in cell C26 enter the formula "= B5". Verify that your worksheet matches the example in the text. 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. B D 1 Chapter 12: Applying Excel 2 3 Data 4 Exhibit 12-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: 8 Undyed coarse wool $120,000 9 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 ? 27 Cost of separation process ? 28 Combined costs of dyeing ? 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 ? ? ? ? Fine Wool ? ? ? ? ? Superfine Wool

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

Control And Audit Of Minicomputer Systems

Authors: British Computer Society

1st Edition

0471261866, 978-0471261865

More Books

Students also viewed these Accounting questions