2. In industries that process joint products, the costs of the raw materials inputs and the sales values of intermediate and final produc are often volatile. Change the data area of your worksheet to match the following: A в Chapter 11: Applying Excel 1. Data Exhibit 11-7 Santa Maria Wool Cooperative Cost of wool 4 213,000 6. Cost of separation process 40,000 7 Sales value of intermediate products at split-off point Undyed coarse wool 8 116,000 Undyed fine wool 148,000 Undyed superfine wool 11 Costs of further processing (dyeing) intermediate products: 10 58,000 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 149,000 17 Dyed fine wool $ 188,000 18 Dyed superfine wool 96,000 %24 2.
2. In industries that process joint products, the costs of the raw materials inputs and the sales values of intermediate and final produc are often volatile. Change the data area of your worksheet to match the following: A в Chapter 11: Applying Excel 1. Data Exhibit 11-7 Santa Maria Wool Cooperative Cost of wool 4 213,000 6. Cost of separation process 40,000 7 Sales value of intermediate products at split-off point Undyed coarse wool 8 116,000 Undyed fine wool 148,000 Undyed superfine wool 11 Costs of further processing (dyeing) intermediate products: 10 58,000 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 149,000 17 Dyed fine wool $ 188,000 18 Dyed superfine wool 96,000 %24 2.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
c-2. If your recommendation in part (c-1) is followed, what would be the company’s overall profit?
![b. What is the financial advantage (disadvantage) from further processing?
from further processing undyed coarse wool
from further processing undyed fine wool
from further processing undyed superfine wool
c-1. With these new costs and selling prices, what recommendations would you make concerning the company's operations?
Sell as is or process further the intermediate product undyed coarse wool?
Sell as is or process further the intermediate product undyed fine wool?
Sell as is or process further the intermediate product undyed superfine wool?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F67bd0f67-f477-48c3-9595-e9f233b7a05d%2Fd577b693-d90e-4eb9-a6a7-92f70af016a2%2F0z7uy3i_processed.png&w=3840&q=75)
Transcribed Image Text:b. What is the financial advantage (disadvantage) from further processing?
from further processing undyed coarse wool
from further processing undyed fine wool
from further processing undyed superfine wool
c-1. With these new costs and selling prices, what recommendations would you make concerning the company's operations?
Sell as is or process further the intermediate product undyed coarse wool?
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. In industries that process joint products, the costs of the raw materials inputs and the sales values of intermediate and final products
are often volatile. Change the data area of your worksheet to match the following:
A
B
1 Chapter 11: Applying Excel
2
3 Data
4 Exhibit 11-7 Santa Maria Wool Cooperative
5 Cost of wool
6 Cost of separation process
7 Sales value of intermediate products at split-off point:
$
213,000
$
40,000
8
Undyed coarse wool
116,000
9
Undyed fine wool
148,000
Undyed superfine wool
58,000
10
11 Costs of further processing (dyeing) intermediate products:
12
Undyed coarse wool
50,000
13
Undyed fine wool
60,000
Undyed superfine wool
15 Sales value of end products:
14
10,000
16
Dyed coarse wool
$
149,000
Dyed fine wool
$
188,000
17
18
Dyed superfine wool
96,000
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
%24
%24
%24
%24
%24
%24
%24
%24
%24](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F67bd0f67-f477-48c3-9595-e9f233b7a05d%2Fd577b693-d90e-4eb9-a6a7-92f70af016a2%2Fmbn1m2_processed.png&w=3840&q=75)
Transcribed Image Text:2. In industries that process joint products, the costs of the raw materials inputs and the sales values of intermediate and final products
are often volatile. Change the data area of your worksheet to match the following:
A
B
1 Chapter 11: Applying Excel
2
3 Data
4 Exhibit 11-7 Santa Maria Wool Cooperative
5 Cost of wool
6 Cost of separation process
7 Sales value of intermediate products at split-off point:
$
213,000
$
40,000
8
Undyed coarse wool
116,000
9
Undyed fine wool
148,000
Undyed superfine wool
58,000
10
11 Costs of further processing (dyeing) intermediate products:
12
Undyed coarse wool
50,000
13
Undyed fine wool
60,000
Undyed superfine wool
15 Sales value of end products:
14
10,000
16
Dyed coarse wool
$
149,000
Dyed fine wool
$
188,000
17
18
Dyed superfine wool
96,000
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
%24
%24
%24
%24
%24
%24
%24
%24
%24
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education