Fuel Mathematics - HotUKDeals
Get the HUKD app free at Google Play

#### Search Error

An error occurred when searching, please try again!

# Fuel Mathematics

9y, 1m agoPosted 9 years, 1 month ago
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.
9y, 1m agoPosted 9 years, 1 month ago
Options

(14)
#1
That all depends on what car you want to drive with
#2
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.
#3
(Difference in distance in miles divided by mpg) multiplied by ( litre Fuel price x 4.55)
1 Like #4
So an extra 8000 miles with a 50mpg car and £1 per litre fuel would give

8000 x £1 x 4.55 = £728
50
1 Like #5
I knew I would find a Excel formula on one of the forums I belong to:

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 1 Like #6
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.
2 Likes #7
JDeal
Quick think.

m/g(3.7854118 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:
1 Like #8
JDeal
Quick think.

m/g(3.7854118 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.

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 to 3.785411784 litres (exactly)

Imperial (UK) gallon is legally defined as 4.54609 litres
banned#9
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.
#10
Lots of rep given out.

Thanks for all the help :)
#11
Small error...
#12
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.
#13
I think you've got your maths wrong

8000 x 1 x4.55 = £1031
35.3

Which is £85.93 per month
#14
If you say it's an increase of £85.93 per month ... I'll believe ya. lol.