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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
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?
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Methods of accounting
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