Plane Data: Opera Operatin ting Cargo g Cost Passenger Cost Available Fill Plane Type Capacity per Capacity per Fleet Legend ( ft ) Passenge Cargo r Mile Mile Boeing 717 117 935 $0.11 $0.06 15 Changing Cells Bombardier CRJ700 78 150 $0.10 $0.05 18 Optimization Cell Embraer E17 70 156 $0.09 $0.05 12 Airbus A220 133 838 $0.08 $0.04 5 Fee Schedule: Average Ticket Cargo Destination Price Price/ft3 Las Vegas $213 $300.00 Albuquerque $263 $150.00 $29,851 Denver $127 $200.00 Cheyenne $678 $200.00 Boise $133 $300.00 Ren $317 $125.00 Phoenix $274 $175.00 Calculations and Results Section: Daily Demand Plane Assignment lane Utilization Costs Extra % of % of Add' Daily Daily Total Distance from | Passenge Cargo Passenger Cargo Operating Cargo fts Destination Cargo Shipment Capacity Capacity Cost to be Salt Lake Hub Capacity s ft Utilized Added Bookings Utilized 750 1,500 188% 2079 72% 313 $37,704 Las Vegas 421 500 1,500 126% 2079 72% $38,079 Albuquerque 2,000 138% 2079 Denver 322 6% Cheyenne 321 100 1,500 25% 2079 72% Boise 257 750 1,000 188% 2079 48% 372 500 750 126% 2079 36% Ren 1,250 2079 24% Phoenix 439 500 314% Total/Avg 4400 3750 158% 14553 60% Total Cost Income Statement Section: Passenger Revenues: $1,029,650 Cargo Revenues: $1,856,250 Additional Cargo Total Revenues: $2,885,900 less Operating Costs: Daily Gross Profit