Fuel cost calculator
Fuel cost calculator
Author
Discussion

HasToBeV8

Original Poster:

163 posts

119 months

Thursday 10th March 2022
quotequote all
Something I put together out of my own interest, but might be useful to others, so thought I'd share it here.

It shows firstly the estimated fuel price you pay at the pumps for a given range of oil prices. E.g. At an oil price of $120 per barrel (approximately the current price), this would estimate a typical pump price of about 163p/litre.

Secondly it shows for a given miles per gallon of a car, how much it would cost you to travel 1 mile at that fuel price. E.g. for a 30 MPG car at 163p/litre, this means it costs about 25p per mile (in fuel costs only).

I also for completeness estimated an equivalent table for electric cars at different electricity rates (20p/KWH - roughly the price cap at the moment, 29p/KWH - roughly the new price cap from April and 40-50p/KWH - roughly where the price cap could be in October at market levels).

I hope people find this useful. Any feedback welcome.





Assumptions made:- Litres per barrel 158.987
- Litres per UK gallon 4.54609
- Fuel duty p per litre 57.95
- VAT 20%
- Refining margin % of oil price 10%
- Distribution/delivery/retailer margin p per litre 15
- USDGBP FX rate 1.32

Google sheet link if anyone wants to see the formulas: https://docs.google.com/spreadsheets/d/1blWhWplh8f88rRi336siXjUDcDoYUcG8EWGQbLkktrk/edit?usp=sharing

Krikkit

27,943 posts

212 months

Thursday 10th March 2022
quotequote all
Nice work, I have the lazy man's version using ppl at the pump

delta0

2,553 posts

137 months

Thursday 10th March 2022
quotequote all
Seems a little off as we are around £1.80-£2.00 per litre now and that will be based on the oil price from a few weeks ago too.

RazerSauber

2,947 posts

91 months

Thursday 10th March 2022
quotequote all
Unrelated note, a Shell garage near me was charging 195.9 for diesel yesterday. Absolute scandal!

I'll have to stop looking at fuel prices. It's nothing but depression.

CraigyMc

18,374 posts

267 months

Thursday 10th March 2022
quotequote all
RazerSauber said:
Unrelated note, a Shell garage near me was charging 195.9 for diesel yesterday. Absolute scandal!

I'll have to stop looking at fuel prices. It's nothing but depression.
Dundee


I have been reminding myself that £2 a litre for diesel at 60mpg in a 320d is functionally the same price per mile as £6 a litre for petrol at 20mpg in a V6 exige... and I don't care what fuel costs for the exige.

David87

7,046 posts

243 months

Thursday 10th March 2022
quotequote all
This is great, thank you. All I would say to add is that many EV owners will be home charging on tariffs that are a lot less than 20p / kWh. Most will be paying 5.5-7.5p per kWh during the night when the car charges.

Pixelpeep 135

9,050 posts

173 months

Thursday 10th March 2022
quotequote all
David87 said:
This is great, thank you. All I would say to add is that many EV owners will be home charging on tariffs that are a lot less than 20p / kWh. Most will be paying 5.5-7.5p per kWh during the night when the car charges.
That gravy train has ended my friend.

HasToBeV8

Original Poster:

163 posts

119 months

Thursday 10th March 2022
quotequote all
David87 said:
This is great, thank you. All I would say to add is that many EV owners will be home charging on tariffs that are a lot less than 20p / kWh. Most will be paying 5.5-7.5p per kWh during the night when the car charges.
Good point. I've added some lower bands to take into account off peak electricity rates - thanks!


SSBB

698 posts

187 months

Thursday 10th March 2022
quotequote all
delta0 said:
Seems a little off as we are around £1.80-£2.00 per litre now and that will be based on the oil price from a few weeks ago too.
Hmm. I’ve seen plenty around £1.45/1.50 this week. That’s E10 95 unleaded though.

delta0

2,553 posts

137 months

Thursday 10th March 2022
quotequote all
Pixelpeep 135 said:
That gravy train has ended my friend.
Erm no. You can get 7.5p kWh fixed overnight rates right now.

Brett748

977 posts

197 months

Thursday 10th March 2022
quotequote all
So I should read this as EVs already no longer stack up financially unless it is a company car or salary sacrifice (which has its own drawbacks)?

HasToBeV8

Original Poster:

163 posts

119 months

Thursday 10th March 2022
quotequote all
SSBB said:
delta0 said:
Seems a little off as we are around £1.80-£2.00 per litre now and that will be based on the oil price from a few weeks ago too.
Hmm. I’ve seen plenty around £1.45/1.50 this week. That’s E10 95 unleaded though.
Indeed - there seems to be quite a bit more than normal regional variation at the moment.

According to this news article, the UK average for petrol was 159.6p and diesel 167.4p yesterday. Pretty close to the 163p estimated by the model at $120 oil.

https://www.independent.co.uk/news/uk/home-news/uk...


For what its worth I filled up with Esso 99 in north london yesterday at 169.9p and my wife filled up with Sainsburys regular diesel at 155p in Hemel Hempstead yesterday.

HasToBeV8

Original Poster:

163 posts

119 months

Thursday 10th March 2022
quotequote all
Brett748 said:
So I should read this as EVs already no longer stack up financially unless it is a company car or salary sacrifice (which has its own drawbacks)?
That was something I was thinking too and one of the reasons I did the calculation in the first place. At $120 oil and 40p/unit electricity (where spot rates would likely be if we didn't have a price cap, and probably where they will go in October if nothing changes), a 50mpg diesel and 3 mile per KWH EV are pretty similar in terms of pence per mile (15p/mile vs. 13p/mile)

CraigyMc

18,374 posts

267 months

Thursday 10th March 2022
quotequote all
delta0 said:
Pixelpeep 135 said:
That gravy train has ended my friend.
Erm no. You can get 7.5p kWh fixed overnight rates right now.
Octopus does this, it's for 4h per night (00:30 to 04:30) on Octopus Go.

Octopus do require that you prove you have an electric car, otherwise I could see a few people opting to do things like run immersion heating for hot water or running dishwashers/washing machine cycles in the middle of the night to take advantage of electricity at about a quarter of the daytime market rate (7.5p/kWh versus 30p/kWh).

It's basically a modern version of Economy7.

David87

7,046 posts

243 months

Thursday 10th March 2022
quotequote all
Pixelpeep 135 said:
That gravy train has ended my friend.
No it hasn't. Not quite as good as it used to be, granted. I charged my car at 7.5p last night. I also charged my Powerwall at the cheap rate to supply my house during the day whilst it's expensive (32p / kWh).

If you have solar and batteries it can still be basically free to run an EV. Yes, there's a significant upfront cost for the system, but at today's prices it'll soon pay for itself (as long as you don't move house!).

David87

7,046 posts

243 months

Thursday 10th March 2022
quotequote all
CraigyMc said:
running dishwashers/washing machine cycles in the middle of the night.
Whilst I have an EV and Octopus Go so all is legit, I do also do this. biggrin

CraigyMc

18,374 posts

267 months

Thursday 10th March 2022
quotequote all
David87 said:
CraigyMc said:
running dishwashers/washing machine cycles in the middle of the night.
Whilst I have an EV and Octopus Go so all is legit, I do also do this. biggrin
All of a sudden it becomes important that the heater element part of the wash cycle is inside a 4h window (one of the eco cycles on my Bosch is 5h:07m long so you need to actually know when the element is in use!).

HasToBeV8

Original Poster:

163 posts

119 months

Thursday 10th March 2022
quotequote all
Krikkit said:
Nice work, I have the lazy man's version using ppl at the pump
At the end of the day the price you pay at the pump near where you are is what matters in the short term.

However this hopefully helps you benchmark whether that pump price is good or bad versus an approximate national average fair value for a given oil price.

It also translates that pence per litre into a more useful pence per mile cost.

It also gives you an idea of what pump prices might look at in the future at different possible oil prices.

HasToBeV8

Original Poster:

163 posts

119 months

Thursday 10th March 2022
quotequote all
David87 said:
Pixelpeep 135 said:
That gravy train has ended my friend.
No it hasn't. Not quite as good as it used to be, granted. I charged my car at 7.5p last night. I also charged my Powerwall at the cheap rate to supply my house during the day whilst it's expensive (32p / kWh).

If you have solar and batteries it can still be basically free to run an EV. Yes, there's a significant upfront cost for the system, but at today's prices it'll soon pay for itself (as long as you don't move house!).
Let's be realistic though. 7.5p special nightly EV rates are not sustainable for the power companies and unlikely to last. Most of the UK electricity still comes from gas - more so at night when there's not any solar. I know there's the supply/demand dynamic to consider (i.e. currently much less demand for electric at night), but this will converge in time as more people get EVs and charge them overnight.

That 7.5p/unit you're paying is probably costing them at least 20p/unit at current overnight electricity production rates.

It also looks like on that tariff, you pay about 2p/unit more than you would do on a normal price capped tariff for 20 hours a day (between 0430 and 0030). So it looks like all Octopus are doing is charging you more on your normal electricity for 20 hours a day and then a lot less for 4 hours a day. I suspect they have done their maths and it probably works out about the same as a price capped tariff for the average household. I can see how you could take advantage of that tariff if you are disciplined and motivated though (such as also running washing machines / immersion heaters etc during those times as mentioned).

Good point about solar/battery storage. Like EVs in general though the high upfront cost, especially for the amount you'd need to produce + store 50-100 KWH to charge a car every few days, means this simply isn't realistic for the vast majority of people.

Edited by HasToBeV8 on Thursday 10th March 13:38


Edited by HasToBeV8 on Thursday 10th March 13:39

Maracus

4,553 posts

199 months

Thursday 10th March 2022
quotequote all
delta0 said:
Pixelpeep 135 said:
That gravy train has ended my friend.
Erm no. You can get 7.5p kWh fixed overnight rates right now.
Still on 5p/kWh until December. The train is still on the tracks until then, probably be treble or quadruple that by the time of renewal, but still way cheaper than petrol.