Question
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
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.4million 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 tripsshould 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 aircraftBlank 1. Fill in the blank, read surrounding text.return trips.
Small aircraftBlank 2. Fill in the blank, read surrounding text.return trips.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started