X C USA 2: Conditional matting Genel S - % 9 2 O RO Paste Aw om Sort & Field Die an A ye Sys A Si M2 fc D H M N 0 P R 1. Consider the lower table of a sensitivity report on the left and explain what it tells us Constraints Final Cell Name Value $G$28 Total 400000 SG$29 MaxA 120000 $G$30 Max 40000 $G$31 Max 120000 SG$32 MaxD 120000 SG$33 MaxBC 160000 $G$34 MinAC 240000 2. Discuss the forecasting method Nestle used to predict the sales volume of its pizza product List some their most important assumptions. Explain how this procedure and the assumptions might have contributed to the failure of the project 3. What are the most important takeaways from the World, Co. Case considering supply chain management? 4. What is the bullwhip effect? How does the Barilla case illustrate the bullwhip effect? Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 0.0645 400000 0 40000 0 120000 1E30 0 0 120000 1E+30 80000 0.005 120000 40000 40000 0.013 120000 40000 0 0.0205 160000 40000 0 0 200000 40000 1E+30 10 11 12 14 15 To 48 pts. th 19 5. Discuss centralization versus decentralization in purchasing. What are the advantages of each? (6 pts. each)