Below is a compiled parameter list from the XLS workbook, grouped by type across the main sheets, especially General, Destinations, Aircraft Data, Crew Costs, Fuel_prices, B747_Refurbishment, All Routes, Route Basic, and 5yr plan.
The spreadsheet uses well over 100 explicit operating and financial parameters, plus numerous route-specific and aircraft-specific linked assumptions, to calculate revenue, cost, fleet scaling, and profitability for the CanAm platform under a wide range of operational conditions.
Core drivers:
- Aircraft type
- Route distance
- Block time
- Seating capacity
- Load factor
- Ticket yield
- Cargo yield
- Cargo load factor
- Fuel price
- Fuel burn
- Crew cost
- Maintenance cost
- Airport and handling charges
- Aircraft acquisition / refurbishment cost
- ACMI cost
- Infrastructure cost
- Fleet size
- Flight cycles
- Depreciation
- Growth timing
Detailed list of parameters within the spreadsheets:
1. Currency, conversion, and base constants
- US$ to EUR exchange rate
- km per nautical mile
- liters per US gallon
- liters per kg
- Jet A fuel weight per US gallon
2. Fleet utilization and operating scale parameters
- Utilisation block-hours per year per aircraft
- Utilisation block-hours per year total
- Flight cycles per year, all aircraft
- Flight cycles per year per aircraft
- Maximum flight cycles per year per aircraft
- Average flight cycles per day
- Average flight duration per cycle
- Aircraft purchased
- Aircraft in service
- Stand-by or rotating aircraft assumption
3. Passenger and cabin parameters
- Average passengers per flight
- Maximum passengers per flight
- Maximum passengers carried per year per aircraft
- Total transport capacity per year
- Average load factor
- Passenger max-load assumption
- Extra meals
- Passenger requiring inter-island transport
- Business / First passenger weight slot
- Prime passenger weight slot
- Economy passenger weight slot
- Crew weight slot
4. Flight-time and operational timing parameters
- Taxi time out
- Taxi time in
- Climb time
- Descent time
- Approach and landing time
- Reserve flying time
- Crew maximum work time
- Crew layover days
- Layover cost per crew
5. Ticket and passenger yield parameters
- Division factor from distance to ticket price
- Average ticket price ECO
- Average ticket price Discovery
- Average ticket price Business Class
- Average ticket price First Class
- Ticket price offset for overhead
- Average third-party inter-island ticket price
- Assumed ticket price by route distance
- Ticket prices by ACMI start-route combinations
6. Cargo parameters
- LD1 / LD3 cargo container capacity
- Gross weight per container
- Tare weight per container
- Average cargo price outbound
- Average cargo load factor outbound
- Average cargo price inbound
- Average cargo load factor inbound
- Average base distance for cargo calculation
- Cargo capacity by aircraft
- Cargo revenue outbound
- Cargo revenue inbound
7. Fuel and fuel-cost parameters
- Fuel cost at U.S. destination reference
- Fuel cost at LPA
- Final fuel safety reserve
- Fuel prices by airport
- Average fuel cost assumptions
- Minimum-route fuel consumption reference
- Maximum-route fuel consumption reference
- Average fuel consumption per flight
- Total annual fuel cost
- Possible fuel-burn advantage factor
- Deviation fuel cost via TFS
- Fuel compensation to MTOW in LPA
8. Route and network parameters
- Route origin
- Route destination
- Alternate airport
- Route order during startup
- Route number
- Route distance in NM
- Route distance in km
- Flight time by route
- Catchment area by route
- Route fare by distance
- Approximate startup sequence
- Feeder flight requirement
- Network flight links
- Schedules for startup and full operation
9. Aircraft technical parameters
From Aircraft Data, A340_600, B747-400, and seatmap sheets:
- Aircraft type
- MTOW
- MZFW
- BOW
- Maximum cargo payload
- LD1 / LD3 container count
- Total fuel capacity
- Climb speed
- Descent speed
- Cruise speed
- Maximum cruise speed
- Cruise speed at maximum efficiency
- Range
- Fuel economy
- Service ceiling
- Rate of climb
- Seatmap-based capacity
- Aircraft-specific cargo geometry
- Aircraft-specific operating assumptions
10. Crew cost and staffing parameters
From Crew Costs and staffing sections in General:
Flight crew remuneration
- Base salary, Captains
- Base salary, First Officers
- Base salary, Heads of Cabin
- Base salary, Pursers
- Base salary, Cabin Crew
- Bonus by crew category
- Active flight-hour rate
- Passive flight-hour rate
- Aircraft flights per month
- Long-range trips per month
- Active hours per flight
- Passive hours per flight
- Active hours per month
- Passive hours per month
- Remuneration per month
- Total compensation per crew type
Ground and airline staff
- Management planning team
- Accountable manager
- Compliance and safety staff
- Head of maintenance
- Maintenance base staff
- Maintenance line staff
- Head of engineering
- Engineering and ops staff
- Head of quality control
- Quality control staff
- Head of ground ops
- Ground ops staff
- Head of flight operations
- Flight operations staff
- Assistant to flight ops
- Training / deputy head of flight ops
- Ramp agents and local reps
- Tourism-board and tour-operator agents
- Cargo agents
- Head of crew planning
- Crew planning staff
- Head of cabin crews
- Marketing and admin staff
- Secretarial assistance
- Drivers
- Social security cost factor
- Crews per aircraft
- Uniform cost
11. Airport, navigation, and ground-operation parameters
- Average NAV charges per 100 NM
- Navigation charges in EUR
- Landing charges at destination
- Landing charges at LPA
- Approach charges at destination
- Approach charges at LPA
- Ground handling at destination
- Ground handling at LPA
- Line maintenance at destination
- Electronic reservation system cost
- Lost and Found cost
- Back-up aircraft cost per block-hour
- Flight delay / cancellation cost per passenger
- International arrival / departure tax
- September 11th security fee
- Costs of third party inter-island cooperation
12. Maintenance and technical support parameters
- Aircraft spares per hour
- Power by the hour including APU
- Engine LLP per cycle
- Wheels, brakes, landing gear per landing
- Heavy checks per hour
- Average distance flown per hour / year
- AOC-related reserve costs
13. Aircraft acquisition and refurbishment parameters
From B747_Refurbishment:
- Rest-value purchase price for retired aircraft
- D-check cost
- New interior cost
- Engineering for new layout
- Upgraded galleys
- Upgraded toilets
- New cockpit windows
- New passenger windows
- New livery / paint scheme
- Landing gear overhaul
- Engine overhaul, parts, and spares
- APU replacement
- Avionics update components
- Horizontal stabilizer kingpin
- Air conditioning pack / compressor
- Slides
- Aircraft door overhaul
- Cargo door overhaul
- Refurbishment scaling factor
- Total capital cost per activated aircraft
- Residual value after operating period
- Annual depreciation
- Running period
- Total capital cost per aircraft per annum
- Future B747-8 purchase price
14. Infrastructure and facility parameters
Airline infrastructure
- Hangar space rent
- Office space rent
- Electricity and water
- IT
- Fuel for vehicles
- Insurance fire / water
- Insurance liability
- Air conditioning and heating
- AOC-related costs
LPA infrastructure
- CanAm flats / real estate
- Monorail to flats
- Catering centre / real estate
- Hangar / real estate
- Crew buses
- Total infrastructure investment
- Infrastructure depreciation period
- Revenue from flats / real estate
- Revenue from catering centre / real estate
15. Marketing, sales, and general overhead parameters
- Public relations
- Brochures and schedules
- Sales staff
- Sales promotions
- External advertising / TV spots
- Web marketing / communications
- Office material
- Phone, fax, internet
- Liability insurance operations
- Licences
- SITA
- Administration general
- Crew training cycle cost
- Company car leasing rate
16. Insurance parameters
Via Insurances links:
- Aircraft / operational insurance categories
- Liability-related insurance categories
- Staff-related insurance categories
- Infrastructure-related insurance categories
17. ACMI scenario parameters
From ACMI sheets:
- ACMI wet-lease block-hour rate
- ACMI monthly block-hours
- Total ACMI annual cost
- ACMI startup routes
- ACMI route-specific ticket price combinations
- ACMI summary and fallback-cost structures
18. 5-year plan and growth parameters
From 5yr plan:
- Aircraft in service by year
- Aircraft purchased and stored by year
- Capital cost per activated aircraft by year
- Total variable carrier-related costs
- Total ground personnel costs
- Total flight personnel costs
- Total airline infrastructure costs
- Total crew-quarters infrastructure costs
- Total marketing and sales costs
- Total general costs
- Total insurance costs
- Annual fuel-cost increase factor
- Total annual cost
- Load factor by year
- Revenue by year
- Sequential ramp-up logic
- Fleet growth timing
- Profit scaling over time
19. Profitability and output parameters
- Revenue PAX
- Revenue Cargo
- Total revenue
- Fuel costs
- Feeder-flight costs
- Total route cost
- Profit per flight before taxes
- Annual route profit
- Annual total revenue airline
- Annual total cost airline
- Tax-effective depreciation
- Annual profit before taxes
- Resulting profit before taxes
20. Strategic and scenario framing parameters
- Startup order of routes
- Own-metal versus ACMI operation
- Airport alternates
- Hub logic via LPA
- Inter-island feeder dependence
- Cargo integration
- Growth timing and fleet activation
- Stand-by aircraft logic
- Scaling limits by utilization and capital
Condensed top-parameter list
Core drivers:
- Aircraft type
- Route distance
- Block time
- Seating capacity
- Load factor
- Ticket yield
- Cargo yield
- Cargo load factor
- Fuel price
- Fuel burn
- Crew cost
- Maintenance cost
- Airport and handling charges
- Aircraft acquisition / refurbishment cost
- ACMI cost
- Infrastructure cost
- Fleet size
- Flight cycles
- Depreciation
- Growth timing