solution
|
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!"

