For each problem, please provide detail solution and written answers in a separate Excel tab. Your optimization model must be stored in different tab to get full credit: 1. The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of concentrate each week. The company has just received orders of 10 tons from Miami for the coming week, 15 tons for Orlando, and 10 tons for Tallahassee. The cost per ton for supplying each of the distributors from each of the processing plants is shown in the following table.

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? (1 point) F. Interpret the reduced cost for shipping from Eustis to Miami

\begin{tabular}{lccc} & Miami & Orlando & Tallahassee \\ \hline Eustis & $260 & $220 & $290 \\ Clermont & $230 & $240 & $310 \end{tabular}