Marty Ford is an operations analyst for Piedmont Commuter Airlines (PCA). Recently, Marty was asked to make a recommendation on how many reservations PCA should book on Flight 343 - a flight from a small regional airport in New England to a major hub at Boston's Logan Airport. The plane used on Flight 343 is a small twin-engine turbo-prop with 19 passenger seats available. PCA sells nonrefundable tickets for Flight 343 for $150 per seat.

Industry statistics show that for every ticket sold for a commuter flight, a 10% of the ticket holder will not be on the flight. Thus if PCA sells 19 tickets for this flight, there is a fairly good chance that one or more seats on the plane will be empty. Of course, empty seats represent lost potential revenue to the company. On the other hand, if PCA overbooks this flight and more than 19 passengers show up, some of them will have to bumped to a later flight.

To compensate for the inconvenience of being bumped, PCA gives these passengers vouchers for a free meal, a free flight at a later date, and sometimes also pays for them to stay overnight in a hotel near the airport. PCA pays an average so $325 (including the cost of lost goodwill) for each passenger that gets bumped. Marty wants to determine if PCA can increase net revenue (revenue - overbooking cost) by overbooking this flight.

1) Create a spreadsheet to calculate the net revenue for any reservation demand between 14 and 25 seats and any reservation policy booking from 19 to 30 seats.

2) Create a data table that displays net revenue for reservation demand from 14 to 25 and reservation policy from 19 to 30.