WeGrewIt Produce Company collects vegetables from several regional farms, consolidates its collections, and then ships the vegetables
Question:
WeGrewIt Produce Company collects vegetables from several regional farms, consolidates its collections, and then ships the vegetables to a regional wholesale vegetable market by truck. The most recent amounts of peppers, cucumbers, and carrots 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 vegetable. WeGrewIt owns four trucks that can transport vegetables to market. Each truck has its own maximum load amount, and WeGrewIt has discovered that yield losses occur at different rates depending on which vegetable is carried in which truck, shown as a percentage in the table below, along with the capacity available for transporting tons of vegetables per truck. The company would like to determine the allocation of vegetables to trucks in a way that achieves the best revenue possible. Solve and submit steps 6-10 including the Excel model (submit spreadsheet in separate link).
Peppers | Cucumbers | Carrots | Max Load (tons) | |
Truck 1 | 13% | 9% | 3% | 52 |
Truck 2 | 11% | 14% | 4% | 55 |
Truck 3 | 17% | 15% | 8% | 71 |
Truck 4 | 19% | 18% | 9% | 42 |
Available (tons) | 46 | 82 | 92 | |
Price/ton | $550 | $1,100 | $1,800 |