subject: business analytics

please do not copy and paste answer from other similar chegg questions.

show in excel with formula

thank you

20. 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 Processing Plant Grove Ocala Orlando Leesburg Mt. Dora 21 50 40 Eustis 35 30 22 Clermont 55 20 25 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