Project 4 - Fuel Estimates
| 1 |
Fuel Estimates-(your name)
|
| 2 |
|
|
|
|
|
|
|
|
| 3 |
Plane |
Flight |
Flying
Hours |
Flying
Fuel |
Reserve
Fuel |
Holding
Fuel |
Total Fuel
Needed |
Estimated
Fuel Cost |
| 4 |
Boeing-727 |
MIA-JFK |
2.75 |
|
|
|
|
|
| 5 |
DC-9 |
MIA-ATL |
1.25 |
|
|
|
|
|
| 6 |
DC-9 |
MIA-DFW |
3.15 |
|
|
|
|
|
| 7 |
L-1011 |
MIA-SJU |
3.50 |
|
|
|
|
|
| 8 |
L-1011 |
MIA-IAH |
1.25 |
|
|
|
|
|
| 9 |
Boeing-727 |
MIA-LAX |
5.50 |
|
|
|
|
|
| 10 |
DC-9 |
MIA-MSY |
1.50 |
(COMPUTE Col. D- H, and rows 11-13) |
| 11 |
|
Totals |
|
|
|
|
|
|
| 12 |
|
Average |
|
|
|
|
|
|
| 13 |
|
Maximum |
|
|
|
|
|
|
| 14 |
|
|
|
|
|
|
|
|
| 15 |
Plane |
Range (Miles) |
Gallons/Hr |
|
Fuel Information |
|
|
|
| 16 |
Boeing-727 |
2200 |
10,000 |
|
Price per Gallon |
$3.50 |
|
|
| 17 |
DC-9 |
1200 |
7,000 |
|
Reserve Fuel |
20% |
|
|
| 18 |
L-1011 |
3000 |
12,000 |
|
Holding Fuel |
10% |
|
|
| 19 |
|
|
|
|
|
|
|
|
| 20 |
|
|
|
|
|
|
|
|
| 21 |
(CHART GOES HERE) |
|