Question: You have a small package delivery van, and must decide which of 10 possible deliveries you will accept for tomorrow's route, in addition to previous
You have a small package delivery van, and must decide which of 10 possible deliveries you will accept for tomorrow's route, in addition to previous commitments. Each delivery will add both weight and time to your regular route.You cannot accept a partial delivery. -->The delivery requests are given at left, along with a) the weight (in ounces) of the delivery b) the time (in minutes) necessary to add the delivery to your regular route c) the profit ($) you will make by accepting the delivery. -->Given your current commitments, you can add at most 2 hours to your regular route. You also only have the capacity for an additional 500 ounces of packages. 1. (95 points) Formulate spreadsheet model that will determine how to maximize your profit from these delivery options. You do not need to include a mathematical formulation. 2. (5 points) Which deliveries does your model suggest that you should accept? Check all that apply.
| Delivery Requests | |||
| Weight (ounces) | Time (minutes) | Profit ($) | |
| Request 1 | 198 | 14 | 104 |
| Request 2 | 298 | 44 | 107 |
| Request 3 | 194 | 27 | 74 |
| Request 4 | 168 | 42 | 118 |
| Request 5 | 216 | 14 | 51 |
| Request 6 | 226 | 44 | 76 |
| Request 7 | 193 | 41 | 125 |
| Request 8 | 263 | 21 | 95 |
| Request 9 | 228 | 43 | 81 |
| Request 10 | 61 | 31 | 94 |
| Available | 500 | 120 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
