The company wants to determine the least costly plan for filling their orders for the coming week.

A. Formulate mathematical linear programming problem

B. Implement the model in a separate Excel tab and solve it

C. What is the optimal solution? Is the optimal solution degenerate? Is the optimal solution unique? identify an alternate optimal solution for the problem

D. How would the solution change if the plant in Clermont is forced to shut for one day resulting in a loss of four tons of production capacity?

E. What would the optimal objective function value be if the processing capacity in Eustis was reduced by five tons?

F. Interpret the reduced cost for shipping from Eustis to Miami