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)

Answer rating: 100% (QA)

To reformulate the problem and determine if there is an alternative optimal solution we need to adjust the model created in Excel for the given scenar... View the full answer