Fuel Mathematics

Hi,

Looking into getting a new job. In fact - been offered a new job. There is now a mini battle between my old employees and my new employees as my old ones want to keep me and have told me they will up my wages.

The new job is a 10000 miles per year trip, the old job is a 2000 mile trip. Based on different mpg (I'm looking at new cars petrol/diesel) how do I work out exactly how much more it's going to cost me to travel to work so I can work that into a new wage agreement with my old employees?

I've tried, and my answers are obviously incorrect at the moment.

14 Comments

That all depends on what car you want to drive with

Original Poster

I'd like a formula where I can use different cars. If I go to the new job, it is likely I will buy a 50mpg Diesel though.

(Difference in distance in miles divided by mpg) multiplied by ( litre Fuel price x 4.55)

So an extra 8000 miles with a 50mpg car and £1 per litre fuel would give

8000 x £1 x 4.55 = £728
50

I knew I would find a Excel formula on one of the forums I belong to:

Column Headings -

a1 MPG
b1 Miles driven
c1 Gallons
d1 Litres
e1 Pence per Litre
f1 Pounds worth of fuel

Formulas/Data -

a2 =sum(B2/C2) b2 type miles driven here c2 =sum(D2/4.54) d2 =sum(F2/E2) e2 type pence per litre here f2 type pounds worth of petrol here

in F2 the cost needs to be entered without the decimal place eg: £25.81 is 2581

Banned

Quick think.

m/g(4.54 x f) + T + I = P

Do it with both then minus one from the other, that will be the difference. I'll check it later.

M = Miles.
G = MPG.
F = Fuel cost per ltr.
T = Tax.
I = Insurance.
P = Price.

JDeal

Quick think. m/g(3.7854118 x f) + T + I = PDo it with both then minus one … Quick think. m/g(3.7854118 x f) + T + I = PDo it with both then minus one from the other, that will be the difference. I'll check it later. M = Miles.G = MPG. F = Fuel cost per ltr. T = Tax.I = Insurance.P = Price.




that's right, JDeal ... just remember that the (3.785 x f) is on the TOP of the sum: ie it's

cost = (3.785 x m x f ) + T + I
.....................G

(sorry, had to put dots in or the G wouldn't line up, but just ignore them)

so you work out the cost for the 'old employer trip' using your current vehicle, and then the cost for the 'new employer trip', and the difference is what you're interested in.

If you aren't bothered about including tax and insurance you can just drop those bits off the calculation.

Happy baragining - and well done on the job offer :thumbsup:

JDeal

Quick think. m/g(3.7854118 x f) + T + I = PDo it with both then minus one … Quick think. m/g(3.7854118 x f) + T + I = PDo it with both then minus one from the other, that will be the difference. I'll check it later. M = Miles.G = MPG. F = Fuel cost per ltr. T = Tax.I = Insurance.P = Price.



I think you've used the US gallon not the UK gallon

U.S. liquid gallon is legally defined as 231 cubic inches, and is equal … U.S. liquid gallon is legally defined as 231 cubic inches, and is equal to 3.785411784 litres (exactly)Imperial (UK) gallon is legally defined as 4.54609 litres

Banned

barneydog

I think you've used the US gallon not the UK gallon



Indeed I have. Oh well, good if he's in america.

By the way, I couldn't be bothered with dots. Thanks for confirming melissab and thanks for correcting the minor error barneydog.

Original Poster

Lots of rep given out.

Thanks for all the help

Original Poster

Small error...

Original Poster

I'm struggling. lol.

Worked out on a Seat Leon 1.8 20V with an mpg of 35.3 (official figures, unlikely to reach these I know). Gives me a total of £1072 per year for doing 10000 miles. Minus the 2000 (£214) gives me an increase of £858 per year for doing an extra 8000 miles. Worked out with £1 a litre for unleaded.

Does this seem at all realistic? It sounds really cheap to me, only £90 per calendar month for doing 1216 miles.

I think you've got your maths wrong

8000 x 1 x4.55 = £1031
35.3

Which is £85.93 per month

Original Poster

If you say it's an increase of £85.93 per month ... I'll believe ya. lol.
Post a comment
Avatar
@
    Text
    Top Discussions
    1. GOT Leaks again415
    2. Cheapo tips for around the home. Aka "life hacks"2242
    3. Walnut snip: Nestlé cuts nut out of chocolate after prices surge - The Guar…1516
    4. jeremy hunt £44.000 for a new bathroom ??1212

    See more discussions