Chapter 11: Applying Excel: Exercise (Part 2 of 2) (Algo) 2. In Industries that process font products, the costs of the raw materials Inputs and the sales valu are often volatile. Change the data area of your worksheet to match the following: B $ $ 173,000 40,000 A 1 Chapter 11: Applying Excel 2 3 Data Exhibit 11-7 Santa Maria Wool Cooperativa Cost of wool Cost of separation process 6 Sales value of intermediate products at split-off point 7 Undyed course wool B Undyed fine wool 9 Undyed superfine wool 10 Costs of further processing (dyaingi Intermediate products, 11 Undyod course wool 12 Undyod fine wool 13 Undyed superfine wool 14 Sales value of and products 15 Dyed course wool 16 Dyod tro wool 17 Dyad superfine wool 18 $ $ S 119,000 178,000 53,000 5 $ 5 50,000 50,000 10,000 $ 5 166,000 208,000 96.000 5 If your formules are correct you should get the correct answers to the following questions s. What is the overall profit all intermediate products are processed into final products Overal proto proceeding media prodds b. What is the financial advantage vintage from further processing 2 b. What is the financial advantage disadvantage) from further processing HA from further processing undyed coorde wool from further processing undyed the wool from further processing undyed superfine wool ht he 0-1 With these new costs and selling prices, what recommendations would you make concerning the company's operations? Selais or process further the intermediate product und coorsewoon Sol as is o process further the intermediate product undyed no wool? Sell as is or process the thermal product unde superfine woon? c-2 * your recommendation in port (ch) is followed, what would be the company's overal profit Our pot from towar ni partic