Discussion
Well, not just excel a bit of maths help!!
Recently started a new job where I get a "jobs need car" I get 11p per mile.
Wanted a quick spreadsheet with a formula that if I enter the petrol cost and how many miles the trip is it would work out what my mpg would need to be to break even.
I'm sure it's simple enough but struggling.
Cheers
Recently started a new job where I get a "jobs need car" I get 11p per mile.
Wanted a quick spreadsheet with a formula that if I enter the petrol cost and how many miles the trip is it would work out what my mpg would need to be to break even.
I'm sure it's simple enough but struggling.
Cheers
i think you are over complicating it
if the amount you get per mile is a constant, doesn't matter if you are going 1 mile or a million miles
at 11p per mile
£1.00 per L, you need to get 40mpg
£1.10 per L, you need to get 45mpg
£1.25 per L, you need to get 50mpg
£1.35 per L, you need to get 55mpg
if the amount you get per mile is a constant, doesn't matter if you are going 1 mile or a million miles
at 11p per mile
£1.00 per L, you need to get 40mpg
£1.10 per L, you need to get 45mpg
£1.25 per L, you need to get 50mpg
£1.35 per L, you need to get 55mpg
Job needs car is just an internal phrase I would think. To all intents and purposes this is a company car.
In our company it just means that the job grade doesn't automatically entitle them to a company car but the geographical area or job that individual carries out means a company car is needed.
In our company it just means that the job grade doesn't automatically entitle them to a company car but the geographical area or job that individual carries out means a company car is needed.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff