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