The Blue Yonder Airlines flight from Seattle to New York has a capacity of 250 people....
|
The Blue Yonder Airlines flight from Seattle to New York has a capacity of 250 people. The Airlines sold 270 tickets for the flight at a price of $300 per ticket. Tickets are non refundable. The variable cost of flying a passenger is $30. If more than 250 people show up to the flight, the flight will be over booked. The airlines must pay overbooking compensation of $350 per person to each overbooked passenger. Develop a worksheet that computes Blue Yonder's profit based on the number of customers who show up for the flight. Please use excel if statements and show formula |
Homework Answers
Add Answer to:
The Blue Yonder Airlines flight from Seattle to New York has a
capacity of 250 people....
Problem 11-5 (Algo) Next week, Super Discount Airlines has a flight from New York to Los...
Problem 11-5 (Algo) Next week, Super Discount Airlines has a flight from New York to Los Angeles that will be booked to capacity. The airline knows from history that an average of 25 customers (with a standard deviation of 13) cancel their reservation or do not show for the flight. Revenue from a ticket on the flight is $135. If the flight is overbooked, the airline has a policy of getting the customer on the next available flight and giving...
7. 1.50 points Problem 11-5 Next week, Super Discount Airlines has a fight from New York...
7. 1.50 points Problem 11-5 Next week, Super Discount Airlines has a fight from New York to Los Angeles that will be booked to capacity. The airline knows from past history that an average of 40 customers with a standard deviation of 26) cancel their reservation or do not show for the flight Revenue from a ticket on the fight is $140. If the fight is overbooked, the airline has a policy of getting the customer on the next available...
Problem 13-43 Offwego Airlines has a daily flight from Chicago to Las Vegas. On average, 19...
Problem 13-43 Offwego Airlines has a daily flight from Chicago to Las Vegas. On average, 19 ticket holders cancel their reservations, so the company intentionally overbooks the flight. Cancellations can be described by a normal distribution with a mean of 19 passengers and a standard deviation of 5.90 passengers. Profit per passenger is $99. If a passenger arrives but cannot board due to overbooking, the company policy is to provide a cash payment of $199. Use Table B. How many...
Offwego Airlines has a daily flight from Chicago to Las Vegas. On average, 13 ticket holders...
Offwego Airlines has a daily flight from Chicago to Las Vegas. On average, 13 ticket holders cancel their reservations, so the company intentionally overbooks the flight. Cancellations can be described by a normal distribution with a mean of 13 passengers and a standard deviation of 5.30 passengers. Profit per passenger is $93. If a passenger arrives but cannot board due to overbooking, the company policy is to provide a cash payment of $193. Use Table B. How many tickets should...
Offwefly Airlines has a daily flight from Sacramento to Las Vegas with a capacity of 100...
Offwefly Airlines has a daily flight from Sacramento to Las Vegas with a capacity of 100 passengers. On average, 18 ticket holders cancel their reservations at the last minute, so the company intentionally overbooks the flight. Cancellations can be described by a normal distribution with a standard deviation of 2.2. Profit per passenger is $189. If a passenger arrives but cannot board due to overbooking, the company policy is to provide compensation of $131. What is the optimal probability of...
Case 7.2 Skyhigh Airlines Skyhigh Airlines flight 708 from New York to Los Angeles is a popular flight that is usually s...
Case 7.2 Skyhigh Airlines Skyhigh Airlines flight 708 from New York to Los Angeles is a popular flight that is usually sold out. Unfortunately, some ticketed passengers change their plans at the last minute and cancel or re-book on another flight. Subsequently, the airline loses the $450 for every empty seat that the plane flies. To limit their losses from no-shows, the airline routinely overbooks flight 708, and hopes that the number of no-shows will equal the number of seats...
Flights American Airlines Flight 201 from New York's JFK airport to LAX airport in Los Angeles...
Flights American Airlines Flight 201 from New York's JFK airport to LAX airport in Los Angeles uses a Boeing 767-200 with 168 seats available for passengers. Because some people with reservations don't show up, American can overbook by accepting more than 168 reservations. If the flight is not overbooked, the airline will lose revenue due to empty seats, but if too many seats are sold and some passengers are denied seats, the airline loses money from the compensation that must...
On a given San Jose –New York City United Airlines flight, there are200 seats.The high fare...
On a given San Jose –New York City United Airlines flight, there are200 seats.The high fare is $675 and the low fare is $375. Demand for the low fare is abundant while demand for the high fare is normally distributed with a mean of 80 and standard deviation 35. Suppose there is no overbooking. a)Suppose 60 seats are protected for the high fare seats.What is the booking limit for the low fare seat? b)Find the optimal protection level for high...
What happened on United flight 3411?What service expectations do customers have of airlines such ...
What happened on United flight 3411?What service expectations
do customers have of airlines such as United and How did these
expectations develop over time?
Thank You!
In early April 2017, United Airlines (United), one of the largest airlines in the world, found itself yet again in the middle of a service disaster this time for forcibly dragging a passenger off an overbooked flight. The incident was to become a wake-up call for United, forcing it to ask itself what to...
show all work Airlines often oversell their flights. Suppose that for a plane with 50 seats,...
show all work
Airlines often oversell their flights. Suppose that for a plane with 50 seats, they sold tickets to 55 passengers. Let random variable X be the number of ticketed passengers who actually show up for the flight. Based on the historical data, the airline determines the probability mass function of X in the table below. x 45 46 47 48 49 5 5 52 53 54 55 Px() 0.05 0.1 0.12 0.14 0.25 0.17 0.06 0.05 0.03 0.02...
Problem 11-5 (Algo) Next week, Super Discount Airlines has a flight from New York to Los Angeles that will be booked to capacity. The airline knows from history that an average of 25 customers (with a standard deviation of 13) cancel their reservation or do not show for the flight. Revenue from a ticket on the flight is $135. If the flight is overbooked, the airline has a policy of getting the customer on the next available flight and giving...
7. 1.50 points Problem 11-5 Next week, Super Discount Airlines has a fight from New York to Los Angeles that will be booked to capacity. The airline knows from past history that an average of 40 customers with a standard deviation of 26) cancel their reservation or do not show for the flight Revenue from a ticket on the fight is $140. If the fight is overbooked, the airline has a policy of getting the customer on the next available...
Problem 13-43 Offwego Airlines has a daily flight from Chicago to Las Vegas. On average, 19 ticket holders cancel their reservations, so the company intentionally overbooks the flight. Cancellations can be described by a normal distribution with a mean of 19 passengers and a standard deviation of 5.90 passengers. Profit per passenger is $99. If a passenger arrives but cannot board due to overbooking, the company policy is to provide a cash payment of $199. Use Table B. How many...
What happened on United flight 3411?What service expectations
do customers have of airlines such as United and How did these
expectations develop over time?
Thank You!
In early April 2017, United Airlines (United), one of the largest airlines in the world, found itself yet again in the middle of a service disaster this time for forcibly dragging a passenger off an overbooked flight. The incident was to become a wake-up call for United, forcing it to ask itself what to...
show all work
Airlines often oversell their flights. Suppose that for a plane with 50 seats, they sold tickets to 55 passengers. Let random variable X be the number of ticketed passengers who actually show up for the flight. Based on the historical data, the airline determines the probability mass function of X in the table below. x 45 46 47 48 49 5 5 52 53 54 55 Px() 0.05 0.1 0.12 0.14 0.25 0.17 0.06 0.05 0.03 0.02...
Most questions answered within 3 hours.
-
Little’s Law: Val d’Costa is a world famous ski village in the
French Alps. Because of...
asked 21 minutes ago -
Find the absolute error D for the calculation if A + B/C=D A=
9.4 +/- 0.4...
asked 34 minutes ago -
New Air Heating and Cooling, manufactures furnaces and central
air units. The company pride itself on...
asked 48 minutes ago -
A coach uses a new technique to train gymnasts. Seven
gymnasts were randomly selected and their...
asked 2 hours ago -
While rotating the tires on your car you notice a rock [mass =
0.1 Kg] stuck...
asked 4 hours ago -
Using MARS simulator, write MIPS programs according to
the following scenarios: Receive a positive integer number...
asked 6 hours ago -
An object in front of a concave mirror has a real image that is
11.5 cm...
asked 6 hours ago -
Consider the reaction, C3 H8 + O2 --> CO2 + H2O. How many
moles of O2...
asked 8 hours ago -
You and your opponent both roll a fair die. If you both roll the
same number,...
asked 8 hours ago -
In a study of the accuracy of fast food drive-through orders,
Restaurant A had 257 accurate...
asked 8 hours ago -
Identify and describe in detail the four categories of
institutions that could be included in a...
asked 8 hours ago -
In python
class Customer:
def __init__(self, customer_id, last_name, first_name, phone_number, address):
self._customer_id = int(customer_id)
self._last_name =...
asked 9 hours ago