I need to know how to answer this question only in Excel. Pleaseinclude instructions, screenshots, etc. in Excel which explain theprocess (formulas included).
TropSun is a leading grower and distributer of fresh citrusproducts with three large citrus groves scattered around centralFlorida in the cities of Orlando, Eustis, and Winter Haven. TropSuncurrently has 275,000 bushels of citrus at the grove in Mt. Dora,400,000 bushels at the groves in Eustis, and 300,000 bushels at thegrove in Clermont. TropSun has citrus processing plants in Ocala,Orlando, and Leesburg with processing capabilities to handle200,000, 600,000, and 225,000 bushels respectively. TropSuncontracts with a local trucking company to transport its fruit fromthe groves to the processing plant. The trucking company charges aflat rate for each mile that each bushel of fruit must betransported. Each mile a bushel of fruit travels is known as abushel-mile. The following table summarizes the distances (inmiles) between the groves and processing plant.
| | Distance (in miles) Between Groves and Plants |
| Grove | Ocala | Orlando | Leesburg |
| Mt. Dora | 18 | 51 | 39 |
| Eustis | 34 | 33 | 20 |
| Clermont | 52 | 22 | 37 |
TropSun wants to determine how many bushels to ship from eachgrove to each processing plant to minimize the total number ofbushel-miles the fruit must be ship. [ Another way to put it,MINIMIZE the TRANSPORTATION costs of the bushel-miles from thegroves to the Plants] (30 Points) HINT: What decision variables canchange.
1. Define the decision variables.
2. Define the Constraints
3. Implement and Solve the Problem in Excel
4. Analyze the Solution, what is it telling the decisionmaker?
