Tropicsun is a leading grower and distributor of fresh citrus products with three

large citrus groves scattered around central Florida in the cities of Mt$.$ Dora, Eustis,

and Clermont. Tropicsun currently has $275,000$ bushels of citrus at the grove in Mt$.$

Dora, $400,000$ bushels at the grove in Eustis, and $300,000$ at the grove in Clermont.

Tropicsun has citrus processing plants in Ocala, Orlando, and Leesburg with pro$-$

cessing capacities to handle $200,000,600,000,$ and $225,000$ bushels, respectively.

Tropicsun contracts with a local trucking company to transport its fruit from the

groves to the processing plants. The trucking company charges a flat rate of $$8$ per

mile regardless of how many bushels of fruit are transported. The following table

summarizes the distances $($in miles$)$ between each grove and processing plant:

Distances $($in Miles$)$ Between Groves and Plants

Tropicsun wants to determine how many bushels to ship from each grove to each

processing plant in order to minimize the total transportation cost.

a$.$ Formulate an ILP model for this problem.

b$.$ Create a spreadsheet model for this problem and solve it$.$

c$.$ What is the optimal solution? need excel solution and stepds