An airline can reconfigure the seating in an aircraft to respond to demand and to maximise revenue. The seating is arranged in rows and can be configured in different classes which have more or fewer seats per row and more or less separation between the rows. Each row consists of identical seating. The table below shows the four options. The Row separation includes the size of the seat itself and measures from the rear of the seat to the rear of the seat in front of it, or the front bulkhead. All measurements are in metres. Class No. of Seats Row separation Revenue per Seat Minimum Rows Maximum Rows First 4 1.98m £9,541 0 3 Business 8 1.93m £6,133 3 20 Premium Economy 10 0.86m £692 2 41 Economy 10 0.78m £404 5 48 The aircraft the company uses have 45 metres of available space and a legal limit of 374 passenger seats. One possible valid configuration is: 12 first class seats (taking up 3 rows and 5.94 metres) 56 business class seats (taking up 7 rows and 13.51 metres) 190 premium economy seats (taking up 19 rows and 16.34 metres) 110 economy (taking up 11 rows and 8.58 metres) This configuration is valid as the total length is 44.37: there is no room for additional rows of seating. The number of passenger seats (368) is below the maximum of 374. Question: The airline wishes to know how much revenue a particular configuration generates. Explain how you would adapt the class in part (b) to provide this information.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

An airline can reconfigure the seating in an aircraft to respond to demand and to maximise revenue. The seating is arranged in rows and can be configured in different classes which have more or fewer seats per row and more or less separation between the rows. Each row consists of identical seating. The table below shows the four options. The Row separation includes the size of the seat itself and measures from the rear of the seat to the rear of the seat in front of it, or the front bulkhead. All measurements are in metres.

Class	No. of Seats	Row separation	Revenue per Seat	Minimum Rows	Maximum Rows
First	4	1.98m	£9,541	0	3
Business	8	1.93m	£6,133	3	20
Premium Economy	10	0.86m	£692	2	41
Economy	10	0.78m	£404	5	48

The aircraft the company uses have 45 metres of available space and a legal limit of 374 passenger seats.

One possible valid configuration is:

12 first class seats (taking up 3 rows and 5.94 metres)
56 business class seats (taking up 7 rows and 13.51 metres)
190 premium economy seats (taking up 19 rows and 16.34 metres)
110 economy (taking up 11 rows and 8.58 metres)

This configuration is valid as the total length is 44.37: there is no room for additional rows of seating. The number of passenger seats (368) is below the maximum of 374.

Question:

The airline wishes to know how much revenue a particular configuration generates. Explain how you would adapt the class in part (b) to provide this information.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions