Draw the relation between the seat number

Assignment Help Operation Management

Reference no: EM13751432

Question 1:

A hypothetical airline operates a flight from point A to point B, with capacity of 50 seats. Typically there are two booking classes on this flight; named T, and Y, where T represents the booking class with the low fare value and Y represents the booking class with the high fare value. Assume also that low fare bookings occur before high fare bookings. Historical observations regarding the number of passengers booked in "Y" class are as shown in the Table below:

Number of passengers	Number of times this number of passengers was observed	Number of passengers	Number of times this number of passengers was observed
0	1	16	31
1	3	17	30
2	6	18	27
3	7	19	26
4	10	20	25
5	11	21	21
6	12	22	19
7	14	23	14
8	15	24	13
9	18	25	11
10	22	26	10
11	20	27	7
12	22	28	4
13	23	29	3
14	27	30	2
15	31

a- Enter this data into excel in two columns where the first column represents "Number of passengers" and the second column represents "Number of times this number of passengers was observed". Draw the distribution of the demand values.

b- Using this data,

Calculate the probability that "0" passengers of Y class will show up for this flight

Calculate the probability that exactly 15 passengers show up for this flight

Calculate the probability that at least 15 passengers show up for this flight

Calculate the probability that at most 10 passengers show up for this flight

c- If the fare for "Y" class is $400, calculate the expected marginal seat revenue for each seat of the flight based on the "Y" demand. Put your answer in a table

d- Draw the relation between the seat number (index) and its expected revenue.

e- Based on your calculations, determine the protection level for booking class "Y" in the following cases:

- The fare for passengers of booking class "T" is $100

- The fare for passengers of booking class "T" is $150

- The fare for passengers of booking class "T" is $180

Reference no: EM13751432

Questions Cloud

How did english and spanish colonial government differ : How did English Colonial Government differ from Spanish Colonial Government. In answering this question concentrate on the manner in which these two governmental systems were organized.

Plastic-based shipping container for use as a distribution : You are going to compare and contrast the advantages and disadvantages of a paper-based shipping container, a wood-based shipping container and a plastic-based shipping container for use as a distribution package

Return correlation between the fund and the market : A stock has an annual return of 11.2 percent and a standard deviation of 45 percent. What is the smallest expected gain over the next year with a probability of 1 percent?(Round your answer to 2 decimal places. Omit the "%" sign in your response.)

Compared perspectives regarding hanukkah that scholars offer : Critically analyze and compared the perspectives regarding Hanukkah/Chanukah that three scholars offer, while highlighting throughout the essay the argument that you prefer.

Draw the relation between the seat number : Enter this data into excel in two columns where the first column represents "Number of passengers" and the second column represents "Number of times this number of passengers was observed". Draw the distribution of the demand values.

Explain the purpose and the makeup : Explain the purpose and the makeup (which type of employees) that make up each sub team

Department of a large corporation : The finance department of a large corporation has evaluated a possible capital project using the NPV method, the Payback Method, and the IRR method. The analysts are puzzled, since the NPV indicated rejection, but the IRR and Payback methods both..

What impact did the disarmament conferences of the 1920s : What impact did the Disarmament Conferences, Congressional Hearings, and Peace Movements of the 1920s and 30s have on the U.S. Military?

Describe moment captured in leonardos last supper painting : Describe the moment captured in Leonardo's Last Supper painting, and discuss the reasons why disciples are shown on the same side of the table.

User Account

All Pages