6-1 guided project

profileinwoodchck
BoydAir-06.xlsx
Home>Computer Science homework help>6-1 guided project

Flight Stats

Boyd Air
Flight Statistics
Date Flight Number Origin Destination Departure Arrival Code Passengers
2/1/16 BD 2345 MSP MDW 8:00 AM 9:30 AM On Time 90
2/4/16 BD 980 MSP FAR 12:30 PM 2:00 PM On Time 35
2/7/16 BD 1234 MDW GRB 10:00 AM 11:00 AM Delayed 80
2/10/16 BD 1345 MSP HOU 4:45 PM 7:30 PM On Time 90
2/13/16 BD 4567 MCO MSP 9:00 PM 11:30 PM On Time 75
2/16/16 BD 2213 MDW MCO 6:30 AM 10:30 AM Delayed 90
2/19/16 BD 6578 FAR STL 8:00 AM 9:30 AM On Time 63
2/22/16 BD 234 MDW MSP 2:00 PM 3:30 PM On Time 90
2/25/16 BD 981 FAR MSP 9:00 AM 10:30 AM On Time 35
2/28/16 BD 123 GRB MDW 2:00 PM 3:00 PM Delayed 80
3/3/16 BD 221 MCO MDW 11:00 AM 3:00 PM Delayed 90
3/6/16 BD 134 HOU MSP 10:00 AM 12:45 PM On Time 90
3/9/16 BD 98 FAR MDW 9:30 AM 11:45 AM On Time 35
3/12/16 BD 4567 MCO GRB 1:00 PM 5:00 PM On Time 75
Number of flights originating in MDW
Number of flights arriving in MSP
Average number of passengers to GRB
Smallest passenger count to MDW
Total flights delayed into MDW
Total passengers delayed into MDW
City Arrival Time
FAR

Criteria

Date Flight Number Origin Destination Departure Arrival Code Passengers

Time Deviations

Boyd Air
Scheduled vs. Actual Arrival Times
Date Flight Number Origin Destination Scheduled Actual Deviation
2/1/16 BD 2345 MSP MDW 9:30 AM 9:24 AM
2/4/16 BD 980 MSO FAR 2:00 PM 2:15 PM
2/7/16 BD 1234 MDW GRB 11:00 AM 11:02 AM
2/10/16 BD 1345 MSP HOU 7:30 PM 7:56 PM
2/19/16 BD 6578 FAR STL 9:30 AM 9:14 AM
2/22/16 BD 234 MDW MSP 3:30 PM 3:20 PM
2/25/16 BD 981 FAR MSP 10:30 AM 10:15 AM
2/28/16 BD 123 GRB MDW 3:00 PM 3:24 PM
3/6/16 BD 134 HOU MSP 12:45 PM 1:15 PM
3/9/16 BD 98 FAR MDW 11:45 AM 11:52 AM
4/1/16 BD 2345 MSP MDW 9:30 AM 9:32 AM
4/4/16 BD 980 MSP FAR 2:00 PM 2:14 PM
5/7/16 BD 1234 MDW GRB 11:00 AM 10:48 AM
5/10/16 BD 1345 MSP HOU 7:30 PM 7:41 PM
5/19/16 BD 6578 FAR STL 9:30 AM 9:27 AM
6/22/16 BD 234 MDW MSP 3:30 PM 3:30 PM
6/25/16 BD 981 FAR MSP 10:30 AM 10:30 AM
6/28/16 BD 123 GRB MDW 3:00 PM 2:55 PM
7/6/16 BD 134 HOU MSP 12:45 PM 12:42 PM
7/9/16 BD 98 FAR MDW 11:45 AM 11:51 AM
MAD
Standard Deviation

Flight Hours

Boyd Air
Flight Hours and Percentages
ID Last Name First Name Feb Hours Mar Hours Feb > 20? Either Month Over 20? Both Months Over 20? Total Hours/ Allowable Status Maximum Allowable Hours
001 Howman Christopher 18 15 0.9428571429 35
002 Melson Chad 16 20 1.0285714286
003 Daniels Case 18 10 0.8
004 Mochen Wyatte 19 18 1.0571428571
005 Omang David 13 19 0.9142857143 >=100% Do not schedule
006 Frankel BJ 24 ll ERROR:#VALUE! 91-99% Call to schedule
007 Sheldon Kendra 21 22 1.2285714286 70-89% Schedule
008 Jamison Ella 22 15 1.0571428571
009 Green Alec 21 23 1.2571428571
010 Nelson Natasha 13 14 0.7714285714
011 Jalowiec Nikolai 11 16 0.7714285714
012 Gomez Tabitha 17 14 0.8857142857
013 Gaston Josie 17 12 0.8285714286
014 Chajec Tomas 13 18 0.8857142857
015 McDrew Anthony 15 18 0.9428571429

Flight Staff

Boyd Air
Flight Staff
ID Last Name First Name Printed Label
001 Howman Christopher
002 Melson Chad
003 Daniels Case
004 Mochen Wyatte
005 Omang David
006 Frankel BJ
007 Sheldon Kendra
008 Jamison Ella
009 Green Alec
010 Nelson Natasha
011 Jalowiec Nikolai
012 Gomez Tabitha
013 Gaston Josie
014 Chajec Tomas
015 McDrew Anthony

Equipment Eval

Evaluation of New Equipment Purchases
Purchase A
Assumed Discount Rate 10%
Cost of Equipment $ (125,000.00)
1st Year Return $ 42,000.00
2nd Year Return $ 38,000.00
3rd Year Return $ 42,000.00
Net Present Value
Purchase B
Assumed Discount Rate 8%
Cost of Equipment $ (79,000.00)
1st Year Return $ 42,000.00
2nd Year Return $ 38,000.00
3rd Year Return $ 42,000.00
Net Present Value