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
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 |
Step by Step Solution
3.45 Rating (145 Votes )
There are 3 Steps involved in it
Step: 1
LP model in Excel is as follows Formula B17 SUMB13B16 copy to B17...See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started