Question

Chapter 11: Applying Excel: Exercise (Part 2 of 2) 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 11: Applying Excel $ $ 155,000 40,000 3 Data 4 Exhibit 11-7 Santa Maria Wool Cooperative Cost of wool 6 Cost of separation process 7 Sales value of intermediate products at split-off point: Undyed coarse wool Undyed fine wool Undyed superfine wool 11 Costs of further processing (dyeing) intermediate products: 12 Undyed coarse wool ...1.3....... ......... ......... Ola 117,000 130,000 80,000 10 50,000 ........20.onal

Answer 1

in = increase sales - price (disadvantage) (b) tinancial advantage costs of further procening a – 12,000 Coarse wool - 50,000 (155,000 - 117,000) - 64000 s 50,000 fine wool & (240,000 - 130,000) - Superfine wool - (86,000 - 80,000) - 10,000 - - 4000 Sence only fine wool in financially Coars wool, super fine wool should be state cand fine wool in deped state advantageong sold i undyed Overall profit a ales price - cost 114000 240,000 + 80,000 55,000 + 40,000 & 60,000) 189.000