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

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS