Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question # 2(30p): The most important goal for an airline is to keep aircraft in air hecanse only, flight provides cost decreasing and profit generating.
Question # 2(30p): The most important goal for an airline is to keep aircraft in air hecanse only, flight provides cost decreasing and profit generating. Different aircraft types have different costs. Suppose that the small airline company with 2 Types of aircraft and 3 Routes seeks the possible way of cost minimization Suppose that a small airline company plans to operate with 2 types of aircraft to fly 3 routes. Both types of aircraft must be involved into operations for 3 routes. Let the volume of the aircraft "i" be "A" passengers, let the total number of passengers carried on the route "y" during the year be exactly "D" and the cost of operating the aircraft *i on a given route 'j' be "Cij" Let the decision variable Xy defines the amount of aircraft flights for Type i on route i where i = 1,2 and j = 1,2,3. The airline manager aims to determine the amount of flights, aircraft type and route that will minimize the cost under the transportation demand constraints for routes. Consider the data below and answer the following questions: Types of aircraft and the volumes: Type 1: A2 = 12 seat. Type 2: A2 = 15 seat. Total demand of transportation (1 year): 1st route: D. - 5400 pass 2nd route: D2 = 1350 pass 3rd route D-2700 pass Cost of operation per route: 11 = 100 C2 = 196 C13 = 292 C21 = 156 C22 = 306 C23 = 456 a) Write the LP model based on the given information above. b) Use Excel-spreadsheet solver to find the optimal amount of flights to perform on certain aircraft type and the route. C) As an output, please provide your Excel template file and Solver outputs. Interpret your findings
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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