solution

Suppose there are 10 items for shipping. The weight of each item is shown below. Assume you have5 identical vehicles available for use. Each vehicle has a capacity of 2,000 lbs on weight.

Item

Weight (lb)

1

833

2

295

3

320

4

810

5

653

6

580

7

610

8

567

9

540

10

925

Consider the following two problems independently. Formulate each problem as an integer programming model and solve each problem using Excel Solver.

a.The problem is to assign these items to the vehicles so as to minimize the number of vehicles to be used.

b.Assuming to use all the vehicles, the problem is to assign these items to the vehicles so as to minimize the maximum weight of the vehicles. Do not use the Max() function or other similar function sin Excel.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"