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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!