# 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.

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.

Original Poster

8000x £1 x 4.55 = £72850

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

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.

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:

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

Banned

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

Thanks for all the help

Original Poster

Original Poster

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.

8000x 1 x4.55 = £103135.3

Which is £85.93 per month

Original Poster