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

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!