Wollmer Distribution Company collects fruit from several small farms in the region, consolidates its collections, and then
Question:
Wollmer Distribution Company collects fruit from several small farms in the region, consolidates its collections, and then ships the fruit to a regional wholesale fruit market by truck. The most recent amounts of grapes, peaches, and bananas collected and available to be shipped to markets are specified in the table below, along with the price per ton of revenue generated by each type of fruit. Wollmer owns four trucks that can transport fruit to market. Each truck has its own maximum load amount, and Wollmer has discovered that yield losses occur at different rates depending on which fruit is carried in which truck, shown as a percentage in the table below, along with the capacity available for transporting tons of fruit per truck. The company would like to determine the allocation of fruit to trucks in a way that achieves the best revenue possible. Construct and solve a Linear Optimization model for this problem in Excel.
Grapes | Peaches | Bananas | Max Load (tons) | |
Truck 1 | 12% | 10% | 4% | 40 |
Truck 2 | 12% | 14% | 5% | 50 |
Truck 3 | 16% | 13% | 6% | 55 |
Truck 4 | 18% | 17% | 8% | 75 |
Available (tons) | 57 | 62 | 81 | |
Price/ton | $500 | $1,000 | $1,750 |