Fuel Milage Payoff Calculator - Ford Powerstroke Diesel Forum
Please Visit our Site Sponsors
6.4L Performance Parts Discussion What has or has not worked for you?

Powerstroke.org is the premier Diesel Truck Forum on the internet. Registered Users do not see the above ads.
LinkBack Thread Tools Display Modes
Old 02-06-2010, 12:57 AM
Compression Ignition Addict

Join Date: Oct 2008
Posts: 363
Thanks: 0
Thanked 0 Times in 0 Posts
Feedback Score: -1 reviews
Lightbulb Fuel Milage Payoff Calculator

See how long it will take getting the improved mpg for the spartan or sct etc to pay for itself.

Credit goes to 64power. Just thought it would be more helpful here were everybody can use it.

You change the Price per Gallon (Currently @ $2.99) and if you want the Base MPG and the Enhanced MPG fields.

The way I came up with the formula was:
D = Price per gallon
E = Base MPG
F = Enhanced MPG
A = Miles driven
2000 = cost of spartan equipment (I was buying the 2,000 package).

We want to solve for A but I started out with the formula:

Miles Driven * (cost per mile Base - cost per mile enhanced) = 2000
Note: I had to remind myself cost per mile base is higher than cost per mile enhanced

A * ((D/E)-(D/F) = 2000

Solving for A leaves us with:
A = 2000/((D/E)-(D/F))

I chose the variable names to go with the attached spreadsheet.
Attached Files
File Type: zip MPG Payoff.zip (7.1 KB, 68 views)
Reply With Quote Quick reply to this message
Sponsored Links
Old 02-06-2010, 02:23 AM
Compression Ignition Addict

Join Date: Dec 2008
Location: Great white north (GTA)
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Feedback Score: 0 reviews
Used your calculator and my Payoff miles will be 31500 miles, before Spartan MPG 13.5 and after average is 18.9
Thanks for the info
Reply With Quote Quick reply to this message
Old 02-06-2010, 05:51 AM
Powerstroke.org Fanatic

Join Date: Jan 2010
Posts: 141
Thanks: 0
Thanked 0 Times in 0 Posts
Feedback Score: 1 reviews
You forgot to factor in that you can turn around and sell the spartan once you are done with the truck and recuperate some of the costs there.
Reply With Quote Quick reply to this message
Sponsored Links

Quick Reply

Register Now

In order to be able to post messages on the Ford Powerstroke Diesel Forum forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
User Name:
Please enter a password for your user account. Note that passwords are case-sensitive.
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:


Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.

Thread Tools
Display Modes

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

All times are GMT -8. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.6.1
Garage Plus, Vendor Tools vBulletin Plugins by Drive Thru Online, Inc.