Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

9781119563099

Students also viewed these Finance questions

Question

CL I P COL Astro- L(1-cas0) Lsing *A=2 L sin(0/2)

Answered: 1 week ago

Question

What is trust, and how does it relate to justice and ethics?

Answered: 1 week ago