managment information system and app excel
Mo7ammedaziz 
e02b1Tickets.xlsxTickets
| Check Bag Cost: | $ 20.00 | ||||||||
| Date Booked | Departure Date | Weekday | Arrival Airport | Class | Check Bag? | Base Ticket | Surcharge | Bag Cost | Total Cost |
| 5/1/16 | 5/15/16 | TUL | First | Yes | |||||
| 5/11/16 | 5/20/16 | ORD | First | Yes | |||||
| 5/13/16 | 6/3/16 | MCI | Coach | No | |||||
| 5/14/16 | 5/18/16 | DFW | First | No | |||||
| 5/15/16 | 6/16/16 | DEN | First | Yes | |||||
| 5/20/16 | 6/20/16 | DEN | Coach | No | |||||
| 5/21/16 | 6/1/16 | DFW | Coach | No | |||||
| 5/22/16 | 6/10/16 | AUS | Coach | Yes | |||||
| 5/23/16 | 5/29/16 | ORD | First | No | |||||
| 5/24/16 | 6/20/16 | MCI | Coach | No | |||||
| 5/24/16 | 6/15/16 | ORD | Coach | Yes | |||||
| 5/27/16 | 6/10/16 | AUS | Coach | Yes | |||||
| 5/29/16 | 6/5/16 | DEN | First | Yes | |||||
| 5/30/16 | 6/11/16 | MCI | Coach | No | |||||
| 5/31/16 | 6/1/16 | DEN | Coach | Yes | |||||
| 5/31/16 | 6/14/16 | DFW | First | No | |||||
| 6/1/16 | 6/8/16 | OKC | Coach | Yes | |||||
| 6/5/16 | 6/13/16 | DEN | First | No | |||||
| 6/8/16 | 6/17/16 | TUL | Coach | Yes | |||||
| 6/14/16 | 6/18/16 | TUL | Coach | No | |||||
| 6/14/16 | 6/14/16 | OKC | First | No |
Lookup Tables
| Weekday Lookup | Base Ticket Prices | Ticket Booked X Days Before Travel | |||||||
| Day Number | Day Name | Airport | City | First | Coach | Days | Surcharge | ||
| DEN | Denver | $ 500.00 | $ 275.00 | ||||||
| TUL | Tulsa | $ 325.00 | $ 175.00 | ||||||
| OKC | Oklahoma City | $ 350.00 | $ 200.00 | ||||||
| MCI | Kansas City | $ 375.00 | $ 215.00 | ||||||
| DFW | Dallas/Fort Worth | $ 450.00 | $ 235.00 | ||||||
| AUS | Austin | $ 350.00 | $ 205.00 | ||||||
| ORD | Chicago O'Hare | $ 700.00 | $ 325.00 |
