My F250 Fuel Records


Summary:

I decided to post my fuel records on the web. I keep detailed records on my fuel economy and fuel costs for the following reasons. First I can detect when I have an engine or driveline problem when suddenly my fuel economy drops for no apparent reason; Second, I can figure out how much a trip will cost me whenever I get the urge to travel; and third, I can work out a monthly fuel budget as I am consistent in my driving patterns from season to season. I can also quickly figure out the impact of crazy fuel prices on my wallet too.

Below you will find a table and three graphs. The table is identical to a spreadsheet I maintain for my truck. The table is month to month, except when my camper or 5th wheel is attached to the truck. Every time I fill up with fuel, I record my odometer reading on the receipt. I then add the liters, dollars and odometer reading to the spreadsheet. The spreadsheet then calculates Km driven per month (between fillup dates that is), the Km per liter, the imperial mpg , (which is 120% greater than US mpg), the cents per km, the cents per mile and the cents per liter I paid for the fuel. The cents per liter calculation is a reality check to ensure that all fuel is accounted for. I make a separate entry for whenever I have the camper or the 5th wheel attached as they are my most heavily loaded conditions. To ensure accuracy between unloaded and loaded conditions, I fill up with fuel at trip start and trip end.

One thing I like about my truck is the 144L (38 US Gal) fuel tank. I fill up about every 14 days and I get 12 or more hours driving on it in the unloaded condition.

Table Legend:

KM: Kilometers
M: Miles
e = unloaded; Camp = camper on; 5th = Dutchmen 5th wheel attached.
~: running average of
M/Gal: miles per imperial gallon (1 imp gal = 1.20 US Gal)
C/Km: cents per KM
C/m : cents/Mile
C/L: cents per liter of fuel
US Units.: US Gals, US Dollars at an exchange rate of $1.55 : $1; US Mpg, US $/mile, US $/US Gal

Mpg is Imperial unless otherwise noted.

Note that for all these numbers and graphs, they are the average for the whole month, or the average for the whole trip when the camper or 5th wheel is attached.

*Tank dump refers to when I had a full tank of Sunoco Diesel dumped from my truck due to a bad case of water in fuel. It messed up the numbers because I had to estimate the km driven and liters consumed. I will never buy fuel from Sunoco again as the East Pembroke, NY staff had the poorest attitude I've ever met - I mean ever!

Table 1 - Caculations
  Date Odometer Liters ($) Load KM Km/L ~Km/L M/Gal ~M/Gal C/Km ~C/Km C/M ~C/M C/L
2000 2-Feb 30 0.0 $0.00 e 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
  16-Feb 1311 192.1 $140.00 e 1281 6.7 6.7 18.8 18.8 10.9 10.9 17.6 17.6 72.9
  27-Mar 4034 367.1 $250.00 e 2723 7.4 7.2 21.0 20.2 9.2 9.7 14.8 15.7 68.1
  24-Apr 5887 247.7 $162.00 e 1853 7.5 7.3 21.1 20.5 8.7 9.4 14.1 15.2 65.4
  24-May 7625 237.0 $155.00 e 1738 7.3 7.3 20.7 20.6 8.9 9.3 14.4 15.0 65.4
*Tank dump 6-Jun 11386 637.9 $385.97 Camp 3761 5.9 6.8 16.7 19.1 10.3 9.6 16.5 15.5 60.5
  17-Jun 12412 125.2 $80.00 e 1026 8.2 6.8 23.2 19.3 7.8 9.5 12.6 15.3 63.9
  21-Jul 15542 370.9 $237.00 e 3130 8.4 7.1 23.8 20.1 7.6 9.1 12.2 14.7 63.9
  29-Aug 18964 409.9 $268.10 e 3422 8.3 7.3 23.6 20.7 7.8 8.9 12.6 14.3 65.4
  7-Sep 19497 61.3 $44.00 e 533 8.7 7.3 24.6 20.7 8.3 8.9 13.3 14.3 71.8
  9-Sep 20339 139.5 $99.00 Camp 842 6.0 7.3 17.1 20.6 11.8 9.0 18.9 14.5 71.0
  29-Sep 21346 121.0 $87.00 e 1007 8.3 7.3 23.5 20.7 8.6 9.0 13.9 14.4 71.9
 

26-Oct

23325 252.5 $179.00 e 1979 7.8 7.4 22.1 20.8 9.0 9.0 14.6 14.5 70.9
 

23-Nov

25295 252.7 $183.00 e 1970 7.8 7.4 22.0 20.9 9.3 9.0 15.0 14.5 72.4
 

19-Dec

27037 245.7 $184.00 e 1742 7.1 7.4 20.0 20.8 10.6 9.1 17.0 14.7 74.9
2001 31-Jan 30391 487.4 $354.04 e 3354 6.9 7.3 19.4 20.7 10.6 9.3 17.0 14.9 72.6
  28-Feb 32014 250.8 $175.00 e 1623 6.5 7.3 18.3 20.5 10.8 9.3 17.4 15.0 69.8
  31-Mar 34757 365.6 $246.02 e 2743 7.5 7.3 21.2 20.6 9.0 9.3 14.4 15.0 67.3
  27-Apr 36529 218.5 $144.00 e 1772 8.1 7.3 22.9 20.7 8.1 9.3 13.1 14.9 65.9
  29-May 39516 359.5 $235.00 e 2987 8.3 7.4 23.5 20.9 7.9 9.2 12.7 14.7 65.4
  27-Jun 42245 324.2 $212.00 e 2729 8.4 7.4 23.8 21.0 7.8 9.1 12.5 14.6 65.4
  10-Aug 46843 545.3 $353.35 e 4598 8.4 7.5 23.8 21.3 7.7 8.9 12.4 14.4 64.8
  13-Aug 47958 190.8 $120.86 Camp 1115 5.8 7.5 16.5 21.1 10.8 9.0 17.5 14.4 63.3
  20-Aug 49051 124.8 $82.00 e 1093 8.8 7.5 24.8 21.2 7.5 8.9 12.1 14.4 65.7
  25-Sep 52431 384.4 $248.01 e 3380 8.8 7.6 24.8 21.4 7.3 8.8 11.8 14.2 64.5
  22-Oct 55496 353.7 $218.01 e 3065 8.7 7.6 24.5 21.6 7.1 8.7 11.5 14.1 61.6
  26-Nov 59382 496.4 $297.00 e 3886 7.8 7.6 22.1 21.6 7.6 8.7 12.3 14.0 59.8
  31-Dec 62020 373.6 $214.00 e 2638 7.1 7.6 20.0 21.5 8.1 8.6 13.1 13.9 57.3
2002 24-Jan 63782 253.6 $143.01 e 1762 6.9 7.6 19.6 21.5 8.1 8.6 13.1 13.9 56.4
  18-Feb 65477 245.4 $136.00 e 1695 6.9 7.6 19.5 21.4 8.0 8.6 12.9 13.9 55.4
  24-Mar 67135 245.0 $140.00 e 1658 6.8 7.6 19.1 21.3 8.4 8.6 13.6 13.9 57.1
  02-Apr 70633 650.1 $360.29 5th 3498 5.4 7.4 15.2 20.9 10.3 8.7 16.6 14.0 55.4
  21-Apr 71623 122.6 $71.00 e 990 8.1 7.4 22.8 21.0 7.2 8.7 11.5 14.0 57.9
  23-May 72905 159.7 $98.00 e 1349 8.5 7.4 23.9 21.0 7.3 8.6 11.7 13.9 61.4
  23-Jun 75041 250.4 $155.00 e 2248 9.0 7.5 25.4 21.1 6.9 8.6 11.1 13.8 61.9
  13-Jul 75919 106.6 $66.00 e 924 8.7 7.5 24.5 21.2 7.1 8.6 11.5 13.8 61.9
  15-Jul 76766 132.5 $82.00 5th 847 6.4 7.5 18.1 21.1 9.7 8.6 15.6 13.8 61.9
  26-Jul 77713 83.7 $50.00 e 697 8.3 7.5 23.5 21.1 7.2 8.6 11.6 13.8 59.7
  21-Aug 79844 249.3 $147.00 e 2131 8.5 7.5 24.2 21.1 6.9 8.6 11.1 13.8 59.0
  06-Sep 80809 120.8 $76.00 e 965 8.0 7.5 22.6 21.1 7.9 8.5 12.7 13.8 62.9
  09-Sep 81548 129.2 $80.00 5th 739 5.7 7.5 16.2 21.1 10.8 8.6 17.4 13.8 61.9
  26-Sep 82676 125.2 $80.00 e 1128 9.0 7.5 25.5 21.1 7.1 8.5 11.4 13.8 63.9
Totals  26-Sep 82676 11051.6 $7,062.42   82646   7.5   21.1   8.5   13.8 63.9
 
Table 1a - Totals converted to US Units
US Units Odometer US Gal US $ Miles US mpg US C/M US $/Gal (@1.55/$)
51352 2923.7 $4,556.40   51333   17.6   8.9 $1.56
 
Table 2 - Trips with Camper or 5th wheel attached (loaded)
      Liters USGal ($)
USD
KM Miles Km/L
M/Gal C/Km C/M USC/M C/L US$/Gal
Cape Hatteras 2000   Can Units 638.0 385.97   3761 5.9   16.7   10.3   16.5   60.5
Camper   US Units 168.8 255.00   2336     13.8       10.9   $1.51
Lake George 2000   Can Units 139.5 99.00   842 6.0   17.1   11.8   18.9   71.0
Camper    US Units 36.9 66.00   523     14.2       12.6   $1.79
East Durham 2001   Can Units 190.8 120.86   1115 5.8   16.5   10.8   17.5   63.3
Camper 
  US Units 50.5 77.23   693     13.7       11.2   $1.53
Cape Hatteras 2002   Can: 650.1 360.29   3498 5.4   15.2   10.3   16.6   55.4
5th 
  US: 172.0 221.52   2173     12.6       10.2   $1.29
Orillia 2002   Can: 132.5 82.00   847 6.4   18.1   9.7   15.6   61.9
5th   US: 35.1 50.55   526     15.0       9.6   $1.44
Lake George 2002   Can: 129.2 80.00   739 5.7   16.2   10.8   17.4   61.9
5th   US: 34.2 49.32   459     13.4       10.7   $1.44

Interesting Stats:

Percentage distance driven under load: 11052/82646 = 13.37%
Number of Days Truck Owned:
967
liters per day used:
11.4
CAD/day cost:
$7.30
Km/day driven:
85
Total Barrels of Diesel Consumed:
69.6

Detailed Analysis:

The following graph shows how my fuel performance varies month to month. You can clearly see the patttern that the table is reporting. Note that fuel economy varies with the time of year or drops whenever I have a full load on. Winter fuel and winter driving conditions clearly affects the fuel economy of the PSD (the EBPV comes on frequently, the engine takes longer to warm up, snowy roads & more idle time). In Canada, most resellers switch to winter fuel sometime in Oct with the onset of frost. The fuel economy drops as a result, since winter fuel has less heating value than summer fuel, and vehicle drag increases due to denser air, and the truck rolling resistance increases due to higher friction.

ChartObject Fuel Performance by Distance (Loaded)

Here is a picture of my truck with my 1993 Dutchmen 27FWRK-RYL attached. I hardly know its behind me. This is my most heavily loaded condition and I get 16 mpg with it on (and thats towing through the Pennsylvania Mountains at 100KM/hr in 6th!)


When Loaded, I average consistent mpg's. The x-axis is Kilometers as my odometer is in KM. The solid bar and right axis represents the number entries in the table above (equals number of trips). The blue line represents the average cost for those months. The yellow line is an adjusted line based on the life average cost of fuel (total fuel cost / total liters purchased). When the blue line is above the yellow line it indicates the price of fuel was higher than average for those entries. As an example, I drove two trips where I averaged 3630 KM, my average mpg was 16, (pink line) it cost me 16.5 c/mile (blue line), which is lower than my life cost of 18 c/mile (yellow line). Thats because both of these trips were to Cape Hatteras, and the fuel cost is much lower in the mid eastern States than in Ontario at that time.

The next graph shows I get between 21 and 24 mpg imperial each month just going about my daily business. The high mpg occur during the summer months . The low mpg occur during the winter months. I am bining the data on distance travelled per month because I am consitent in my travel patterns year to year. This way I can distinguish between months of just commuting and months that include lots of extra travel, which tends to be the summer months. For example, for 10 months, I averaged 1779 KM, my fuel economy was 20.5 mpg (pink line), it cost me 14.5 c/mile (blue line) which is lower than the life cost of 14 C/mile (yellow line). Thats because these are mostly winter months, and mostly commuting, and since Feb 2000, the price of Diesel spikes up during the heating months due to heating oil supply problems in the USA.

Back home

Last Updated on 09/30/02

Hosted by www.Geocities.ws

1