Practice problem given as an example for our exam. If you could show the steps I would appreciate it. If you can do it but need more credits, let me know.
The UN must evacuate an aid team and their belongings from Iraq. They can hire two types of planes to handle the evacuation. One is an Airbus 201 which can handle 25 passengers and 10 tons of cargo for $800 per day. The other is a Boeing 179 which can handle 40 passengers and 4 tons of cargo at a cost of $1000 per day. The evacuation must take out at least 2000 personnel and at least 440 tons of belongings. How many of each type of plane should be chartered to minimize the cost per day and what is that minimum cost per day?
Objective: Z= 800x + 1000y
Constraints: 25x + 40y >= 2000
10x + 4y >= 440
x,y >= 0
1. Solve the problem graphically
2. Solve the problem using Solver (under Tools in Excel)
3. Solve the problem using QM for Windows
4. What is the additional cost if you need to take out 1 additional last minute passenger?
A Complete, Neat and Step-by-step Solution is provided in the attached files.