The following are all several parts of one question. Use the data above to answer.

a. What is the overall profit if all intermediate products are processed into final products?

b. What is the financial advantage (disadvantage) from further processing? Financial advantage or disadvantage.

c. With these new costs and selling prices, what recommendations would you make concerning the companys operations? Process further or sell as is?

d. If your recommendation in part (c) is followed, what would be the companys overall profit?

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 1 Chapter 12: Applying Excel 2 3 Data 4 Exhibit 12-7 Santa Maria Wool Cooperative 5 Cost of wool 6 Cost of separation process 7 Sales value of intermediate products at split-off point: 8 9 158,000 $40,000 Undyed coarse wool $ 128,000 $170,000 56,000 Undyed fine wool 10 Undyed superfine wool 11 Costs of further processing (dyeing) intermediate products 12 Undyed coarse wool 13 Undyed fine wool 50,000 60,000 10,000 14 Undyed superfine wool 15 Sales value of end products: 16 17 Dyed fine wool 18Dyed superfine wool Dyed coarse wool 169,000 S 240,000 90,000