A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | Flying Out Of U.S. Airports | A Calculator for Canadians from | www.YYCdeals.com | ||||
2 | Calgary (YYC) vs Kalispell (FCA) | ||||||
3 | |||||||
4 | Common Variables | Personal Variables | |||||
5 | One-way distance to YYC (km) | 17 | Price of gas (per litre) | $0.92 | |||
6 | One-way distance to FCA (km) | 479 | Fuel efficiency of vehicle (km/l) | 9.1 | |||
7 | |||||||
8 | One-way time to YYC (minutes) | 20 | Vehicle depreciation ($ / km) | $0.15 | (set to 0 if you don't believe in this) | ||
9 | One-way time to FCA (minutes) | 322 | (including est. border wait time) | Value of time (per hour) | $25 | (set to 0 if you don't value your time) | |
10 | |||||||
11 | Variables To Play With | ||||||
12 | Number of people going on the trip | 2 | |||||
13 | |||||||
14 | Cost of flight from YYC | $675 | (roundtrip, per person, after taxes) | Cost of flight from FCA | $200 | (roundtrip, per person, after taxes) | |
15 | |||||||
16 | Baggage fees from YYC | $0 | (per person, roundtrip) | Baggage fees from FCA | $0 | (per person, roundtrip) | |
17 | |||||||
18 | Total cost to park at YYC | $36.00 | Current rate: ($9.00/day, $47/week) | Total cost to park at FCA | $28.00 | Current rate: ($7/day, $42/week) | |
19 | (If taking a cab, enter the roundtrip | ||||||
20 | price from your house to YYC | Hotel required for… | 0 | night(s) | |||
21 | and back instead) | at a cost of | $75 | per night | |||
22 | |||||||
23 | Cost Calculations | ||||||
24 | YYC | FCA | Difference | ||||
25 | |||||||
26 | Everyone's Flights | $1,350 | $400 | $950.00 | |||
27 | Everyone's Baggage | $0 | $0 | $0.00 | |||
28 | Fuel | $3.44 | $96.85 | -$93.42 | |||
29 | Parking | $36.00 | $28.00 | $8.00 | |||
30 | Hotel | $0.00 | $0.00 | $0.00 | |||
31 | Vehicle Depreciation | $5.10 | $143.70 | -$138.60 | |||
32 | Everyone's Time | $33.33 | $536.67 | -$503.33 | |||
33 | |||||||
34 | Total Costs | $1,428 | $1,205.22 | $222.65 | <-- total amount saved, by flying out of Kalispell | ||
35 | (assuming this is a positive number) | ||||||
36 | |||||||
37 | $111.33 | <--- amount saved per person |