Fuel cost calculator
Discussion
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
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
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.
DundeeI'll have to stop looking at fuel prices. It's nothing but depression.
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 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 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.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.
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)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 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.
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 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. 
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.
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!).
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
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. Forums | General Gassing | Top of Page | What's New | My Stuff



