Suppose the price of a product will change at dates in the future, as follows:

On any given date, if the ordering quantity is above $100$units$,$ there would be also a $10\%$discount$.$

The information on $5$orders is provided in the following Excel file. Write a formula that computes the prices of the product based on the order date

and ordering quantity

Order No$.$Order Data Quantity

$13/15/04139$

$24/3/04622$

$310/11/05220$

$42/15/05499$

$53/22/06518$

The Blue Yonder Airline flight from Seattle to New York has a capacity of $250$people$.$ The airline sold $270$tickets for the flight for $$300$per ticket. Tickets are nonrefundable. The variable cost of flying a passenger $($mostly food costs and fuel costs$)$is $$40$per passenger. If more than $250$people show up for the flight, the flight is overbooked, and Blue Yonder must pay overbooking compensation of $$360$per person to each overbooked passenger. Develop a worksheet that computes Blue Yonder$$s profit based on the number of passengers who show up for the flight.

Hint: you can assume any number of passengers $($e$.$g$.,260)$who show up and try to calculate the profit based on that given number of passengers.

pls answer with excel