The company has three preparation In a separate worksheet, reformulate the problem (you can just change the
Question:
The company has three preparation In a separate worksheet, reformulate the problem (you can just change the model you created in excel, in part b) to determine if there is an alternative optimal solution. Clearly explain your result. d. Perform a sensitivity analysis on part b. What would be the first change(s) in the model to decrease the cost the most? centers available for use. The Apple worksheet contains: (i) the unit preparation costs (in $/pound) to get the apples from company's orchard to the preparation centers and then prepare the apples for retail, (ii) the preparation centers' monthly capacities, (iii) the demand at the specialty stores, and (iv) the unit costs of transporting the apples from the preparation centers to the specialty stores. (40 points)
Introduction To Statistical Investigations
ISBN: 9781118172148
1st Edition
Authors: Beth L.Chance, George W.Cobb, Allan J.Rossman Nathan Tintle, Todd Swanson Soma Roy