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.
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
-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