A Canadian airline is considering purchasing a new aircraft. The maximum cabinet area that can be used for passenger seats is 350 m2. The airline is considering the optimal allocation of different seat classes in their new aircraft. Three seat classes are considered: First-class, Premium Economy, and Economy. Preliminary studies showed that the airline's annual profit is 105, 72.5, and 70 thousand dollars per seat for each of the three classes, respectively. The table below shows some important requirements of the different classes. The aircraft can carry a maximum of 10 flight attendants. The airline plans to limit the boarding time to a maximum of 40 minutes for operational and economic reasons. Based on the provided information: a) Develop an optimization model to help the airline decide on the optimal seat configuration of their new aircraft. b) Express the developed model in its standard form.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

A Canadian airline is considering purchasing a new aircraft. The maximum cabinet area that can
be used for passenger seats is 350 m2. The airline is considering the optimal allocation of different
seat classes in their new aircraft. Three seat classes are considered: First-class, Premium Economy,
and Economy. Preliminary studies showed that the airline's annual profit is 105, 72.5, and 70
thousand dollars per seat for each of the three classes, respectively. The table below shows some
important requirements of the different classes.

The aircraft can carry a maximum of 10 flight attendants. The airline plans to limit the boarding
time to a maximum of 40 minutes for operational and economic reasons. Based on the provided
information:
a)
Develop an optimization model to help the airline decide on the optimal seat configuration
of their new aircraft.
b) Express the developed model in its standard form. 

mportant requirements of the different classe
Area per seat
(m2)
2.5
Number of Flight
attendants per seat
Boarding time per seat
(seconds)
Class
First-class
0.05
10
0.03
8
Premium Economy
Economy
1.25
1.00
0.02
7
Tho nirline nlans to limit the boarding
Transcribed Image Text:mportant requirements of the different classe Area per seat (m2) 2.5 Number of Flight attendants per seat Boarding time per seat (seconds) Class First-class 0.05 10 0.03 8 Premium Economy Economy 1.25 1.00 0.02 7 Tho nirline nlans to limit the boarding
Expert Solution
steps

Step by step

Solved in 3 steps with 7 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.