Fuel Cost Analysis

[RyanbabZ71]

I computed the total fuel cost from April 29, 2000 (when i picked my truck up) until January 1, 2004.

 

Year Product Price

2000 Gas $1,102.20

2001 Gas $1,356.55

2002 Gas $945.40

2003 Gas $1,040.32

 

TOTAL Gas $4,444.47

[Wingnut]

C'mon man, you're an engineer...You can come up with more numbers than that.

 

 

How many miles? Fuel economy? Price of tea in Bangladesh?

 

 

I don't even want to add up my numbers, which is why I don't keep them.

[RyanbabZ71]

I got others figued out here they are

 

2000 gallons/avg mpg/ avg cost per gallon

 

734.5 13.5 $1.51

 

2001 gallons/avg mpg/ avg cost per gallon

 

958.6 13.4 $1.42

 

 

2002 gallons/avg mpg/ avg cost per gallon

 

716.8 13.0 $1.30

 

 

2003 gallons/avg mpg/ avg cost per gallon

 

683.2 13.8 $1.52

[Wingnut]

Hmmm...It appears that you are averaging a little better mileage when gas prices go up. That's weird.

[RyanbabZ71]

haha I didnt even notice that must be higher quality gas

 

Actually I think the reason is because last yr i started doing more highway traveling.

[Shaners]

Here's my numbers for April 14, 2004.

 

Gassed up 2 vehicles for $62.50. Neither were empty...

[asepgrad98]

you got way too much time on your hands

[blue2kzr2]

Mine is all in a spreadsheet. Have the old truck in one also. I actually have a workbook set up, splits out each year individually, and have a running total for the whole time I own the truck, but only need to enter once for each fill-up (on the running total one), can have cells in one sheet take on the value of cells in another sheet. I also have my maintenence on a sheet in the same workbook.

 

Hey, my dad did all the work setting it up, I just took a copy he sent me (blank) and made it my own.

 

At the end of the year I just set up calcs at the bottom to figure out how many gallons I used, total fuel cost, how many miles I drove and what the overall average was.

 

Example, for the old truck, in 2003, I drove 9550 miles and used 625.87 gallons of gas, for an overall MPG of 15.xxx. I wasn't keeping track of the cost then.