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

User Tag List

LinkBack Thread Tools Display Modes
post #1 of 3 Old 02-06-2010, 01:57 AM Thread Starter
Compression Ignition Addict
Join Date: Oct 2008
Posts: 363
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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, 69 views)

2009 LARIAT 4x4 PSD
-2.5"King Coilovers & Bypass system
-Deaver Full leaf kit
-Kumho Kl71 37x13.5x20
-310 Spartan Tune & TCM
-5" Flo Pro Dpf / Cat Delete
-Spearco Intercooler
-AFE Intake & Pro-Guard 7
-Twin Viair 480C On Board Air System
-Nathan K5LA Running @ 200 Psi
-55 Watt HID & Fog
-Titan 51 Gallon Fuel Tank

2005josh2006 is offline  
Sponsored Links
post #2 of 3 Old 02-06-2010, 03:23 AM
Compression Ignition Addict
cobraracing's Avatar
Join Date: Dec 2008
Location: Great white north (GTA)
Posts: 246
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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

2009 F250 FX4 Crew cab 6.4L
Recon Headlights, tail lights, tailgate and 3rd brake light
Moto Metal 20" wheels
My Other toy is a
2007 Shelby GT500
600 RWHP & 600RWTQ
cobraracing is offline  
post #3 of 3 Old 02-06-2010, 06:51 AM
Powerstroke.org Fanatic
Join Date: Jan 2010
Posts: 141
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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.
Whatcop? is offline  
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
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode

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

For the best viewing experience please update your browser to Google Chrome