Question
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started