Question: Use excel to solve the following with solver function. Four families are going on their annual family picnic. Four cars are available to transport the
Use excel to solve the following with solver function.
Four families are going on their annual family picnic. Four cars are available to transport the families to the picnic. The cars can carry the following numbers of people: car 1, four; car 2, three; car 3, three; and car 4, four. There are four people in each family, and no car can carry more than two people from any one family. Determine the maximum number of people that can be transported to the picnic.
Please take screen shot of the model and list the constraints.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
