# Tropicsun is a leading grower and distributor of fresh citrus products with three large citrus groves scattered

## Question:

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 processing 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:

Tropicsun wants to determine how many bushels to ship from each grove to each processing plant 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 optimalsolution?

## Step by Step Answer:

**Related Book For**

## Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics

**ISBN:** 1233

8th Edition

**Authors:** Cliff T. Ragsdale