An airline has been tasked with repatriating SA citizens who are currently stranded in Europe due to the Covid 19 crisis. The airline has been given a budget of R3.4 million rands by donors for fuel to transport 12 000 passengers. The airline has 2 types of aircraft, a large and smaller one. The fuel costs for a return flight are R145 000 and R85 000 respectively. The labour hours for each return flight are 12 hours for the large plane and 8 hours for the small with a total of 300 hours budgeted for the month. (The labour budget is not part of the fuel budget). The large plane can transport 600 passengers while the smaller one can transport 350 passengers. Due to the urgency of the matter, each type of plane must make at least 10 trips to Europe.

You are required to use Solver on excel to answer the questions that follow.

1. How many return trips should each type of aircraft make in order to bring home the 12 000 passengers while minimizing fuel costs and the hours for the month?

Large aircraft Blank 1. Fill in the blank, read surrounding text. return trips.

Small aircraft Blank 2. Fill in the blank, read surrounding text. return trips.

How much of the fuel budget would not be used? R Blank 3. Fill in the blank, read surrounding text.

3. How many crew hours would be left for the month? : Blank 4. Fill in the blank, read surrounding text. hours

Before any flights have embarked on the mission, it has been discovered that an additional 1800 SA citizens have indicated their desire to return home. How many trips would be required now given this increase in passenger numbers?

Large aircraft : Blank 5. Fill in the blank, read surrounding text.

Small aircraft: Blank 6. Fill in the blank, read surrounding text.

How much of the fuel budget would not be spent? R Blank 7. Fill in the blank, read surrounding text.

Hours that would not be used: Blank 8. Fill in the blank, read the surrounding text. hours

Given that the new number of passengers need to be transported, and that the government would like to substitute the smaller plane for a medium sized plane that can carry 500 passengers with fuel costs of R120 000 per return flight. Labour hours would be the same as the small aircraft.

How many flights would be taken by the large and medium aircraft in this case? Each aircraft should make at least 10 flights.

Large : Blank 9. Fill in the blank, read the surrounding text. trips

Medium: Blank 10. Fill in the blank, read the surrounding text. trips

How much of the fuel budget would remain unused? R Blank 11. Fill in the blank, read the surrounding text.

Hours that would not be used: Blank 12. Fill in the blank, read the surrounding text.