1. The Blue Yonder Airline flight from Seattle to New York has a capacity of 325 people. The airline sold 420 tickets for the flight at a price of $300 per ticket. Tickets are nonrefundable. The variable and unit cost of flying a passenger (mostly food costs and fuel costs) is $30 per passenger. If more than 325 people show up for the flight, the flight is overbooked, and Blue Yonder must pay overbooking compensation of $350 per person to each overbooked passenger. Develop worksheet that computes Blue Yonder's profit based on the number of customers who show up for the flight. 2. You are bidding on a construction project. The low bid gets the project. You estimate the project cost at $20,000. Four companies are bidding against you. It costs $500 to prepare the bid. Write a formula that (given the bids of your four competitors and your bid) computes your profit (or loss if you lose the bid). 3. We are bidding on a valuable painting. The high bid gets the painting. We estimate the painting's value at $15,000. Four companies are bidding against us. It costs $500 to prepare the bid. Write a formula that (given the bids of our four competitors and our bid) determines whether we get the painting. Use this sheet to start your problem: Assignment 2 Excel IF Statements.xlsx ont (IF stateme if you win what is the profit vs if you lose 26 what is the profit including the bid cost) 27 28 29 #3 Bidding on Painting 30 value 31 my bid 32 comp 1 bid 33 comp 2 bid 34 comp 3 bid 35 comp 4 bid Bid cost (IF Statement) use MAX function for comparison of competitors bids against your bid including the bid cost do I win? 36 (IF Statement) show if you win or lose 37 38 39 40 41