I CAN NOT USE EXCEL DONT SOLVE WTH EXEL. TOO MUCH DETAL PLEASE Problem 2 (1 pts)

I CAN NOT USE EXCEL DONT SOLVE WTH EXEL. TOO MUCH DETAL PLEASE

Transcribed Image Text:

Problem 2 (1 pts) A flight has 100 seats and a passenger fare of $130. The number x of no-shows is independent of total bookings and is given by a normal distribution with mean of 22 and standard deviation of 15. The denied-boarding cost is $260 per denied boarding. Determine the optimal booking limit in this case. Recall that the booking limit needs to be an integer. Problem 2 (1 pts) A flight has 100 seats and a passenger fare of $130. The number x of no-shows is independent of total bookings and is given by a normal distribution with mean of 22 and standard deviation of 15. The denied-boarding cost is $260 per denied boarding. Determine the optimal booking limit in this case. Recall that the booking limit needs to be an integer.