What is the overall profit if all intermediate products are

Assignment Help Accounting Basics

Reference no: EM13568551

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	C
1	Chapter : Applying Excel
2
3	Data
4	Exhibit 12-6 Santa Maria Wool Cooperative
5	Cost of wool	$182,000
6	Cost of separation process	$40,000
7	Sales value of intermediate products at split-off point:
8	Undyed coarse wool	$128,000
9	Undyed fine wool	$172,000
10	Undyed superfine wool	$72,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	$168,000
17	Dyed fine wool	$204,000
18	Dyed superfine wool	$97,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? (Omit the "$" sign in your response.)

Overall profit from processing all intermediate products

(b)	What is the residual income? (Input all amounts as positive values. Omit the "$" sign in your response.)


(Loss or profit) from further processing undyed coarse wool	$
(Loss or profit) from further processing undyed fine wool	$
(Loss or profit)from further processing undyed superfine wool	$

(c)	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?

(c)	If your recommendation in part (c) is followed, what would be the company's overall profit? (Omit the "$" sign in your response.)

Overall profit from following the plan in part (c)

Reference no: EM13568551

Questions Cloud

What is the projects npv note that a projects projected npv : what is the projects npv? note that a projects projected npv can be negative in which case it will be rejected.wacc

Weston is preparing the companys statement of cash flows : weston is preparing the companys statement of cash flows for the fiscal year just ended. using the following

Topic why do you think that security seems to be a greater : requirements1 content of the paper should be 3 pages not include the information page and references page.2 the paper

It is considering two hedging alternatives sell the euro : boeing just signed a contract to sell a boeing 737 aircraft to air france. air france will be billed euro20 million

What is the overall profit if all intermediate products are : in industries that process joint products the costs of the raw materials inputs and the sales values of intermediate

Determination of taxable gifts in the current year beth : determination of taxable gifts. in the current year beth who is single sells stock valued at 40000 to linda for 18000.

List uniform crime reporting ucr and the national crime : create a detailed outline in bullet form that contains information for the following 5 topics1 list uniform crime

Suppose that baltimore machinery sold a drilling machine to : suppose that baltimore machinery sold a drilling machine to a swiss firm and gave the swiss client a choice of paying

The monthly payment on a 1000000 15 yr mortgage at 6 is : the monthly payment on a 1000000 15 yr. mortgage at 6 is 8438.57 per month. how much of that 1000000 on day 1 is deemed

User Account

All Pages