| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Flying Out Of U.S. Airports | A Calculator for Canadians from | www.YOWdeals.com | ||||
2 | Ottawa (YOW) vs Ogdensburg (OGS) | ||||||
3 | |||||||
4 | Common Variables | Personal Variables | |||||
5 | One-way distance to YOW (km) | 7 | Price of gas (per litre) | $1.15 | |||
6 | One-way distance to OGS (km) | 99 | Fuel efficiency of vehicle (km/l) | 9.1 | |||
7 | |||||||
8 | One-way time to YOW (minutes) | 11 | Vehicle depreciation ($ / km) | $0.15 | (set to 0 if you don't believe in this) | ||
9 | One-way time to OGS (minutes) | 74 | (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 YOW | $575 | (roundtrip, per person, after taxes) | Cost of flight from OGS | $400 | (roundtrip, per person, after taxes) | |
15 | |||||||
16 | Baggage fees from YOW | $0 | (per person, roundtrip) | Baggage fees from OGS | $0 | (per person, roundtrip) | |
17 | |||||||
18 | Total cost to park at YOW | $40.00 | Current rate: ($19.00/day, $65/week) | Total cost to park at OGS | $0.00 | Current rate: (free) | |
19 | (If taking a cab, enter the roundtrip | ||||||
20 | price from your house to YOW | Hotel required for… | 0 | night(s) | |||
21 | and back instead) | at a cost of | $75 | per night | |||
22 | |||||||
23 | Cost Calculations | ||||||
24 | YOW | OGS | Difference | ||||
25 | |||||||
26 | Everyone's Flights | $1,150 | $800 | $350.00 | |||
27 | Everyone's Baggage | $0 | $0 | $0.00 | |||
28 | Fuel | $1.77 | $25.02 | -$23.25 | |||
29 | Parking | $40.00 | $0.00 | $40.00 | |||
30 | Hotel | $0.00 | $0.00 | $0.00 | |||
31 | Vehicle Depreciation | $2.10 | $29.70 | -$27.60 | |||
32 | Everyone's Time | $18.33 | $123.33 | -$105.00 | |||
33 | |||||||
34 | Total Costs | $1,212 | $978.06 | $234.15 | <-- total amount saved, by flying out of Ogdensburg | ||
35 | (assuming this is a positive number) | ||||||
36 | |||||||
37 | $117.07 | <--- amount saved per person |