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 1 #1 Blue Yonder Airlines 2 3 tickets sold 4 Capacity 5 Number showing up (you can choose this number) 6 unit cost overbook fee (IF Statement showing if overbooked how much 7 does the airline pay for each individual passenger) 8 ticket price (enter ticket price) 9 10 ticket revenue (number of tickets sold ticket price) variable cost (show smallest number between those showing 11 up or capacity using MIN function)*unit cost overbook cost (IF Satement showing total overbook cost if 12 airlines are over capacity or not) 13 profit (revenue-overbook-variable cost) 14 15 16 #2 Bidding on Construction 17 project cost 18 my bid B 12 airlines are over capacity or not) 13 profit (revenue-overbook-variable cost) 14 15 16 #2 Bidding on Construction 17 project cost 18 my bid 19 comp1 bid 20 comp 2 bid 21 comp 3 bid 22 comp 4 bid 23 bid cost 22 24 win bid (IF statement) - use MIN function for comparison of competitors bids against your bid (should state words if you won 25 or lost) profit (IF statement) - if you win what is the profit vs if you lose 26 what is the profit including the bid cost) 27 2222 28 29 #3 Bidding on Painting 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