Excel Spreadsheet

Fuel Cost Savings Calculator

You must be logged in to download this document
Description

Fuel Cost Savings Calculator

Reviews
Shared by: carthi
Categories
Tags
Stats
views:
308
downloads:
30
rating:
not rated
reviews:
0
posted:
12/24/2007
language:
English
pages:
0
FLEET FUEL SAVINGS CALCULATOR 25 Step 1: Calculate Fuel Cost per Kilometre Step 2: Distance Driven per Vehicle and Guaranteed Savings Average Litres Purchased Per Month 450 Estimated Kilometres Driven Per Vehicle Per Month 3,000 36000 annual Average Cost per Litre $0.78 If Estimated Monthly Kilometres are < 1500 then 5% Average Monthly Fuel Purchases $351 if Monthly Kilometres are > 1500 and <2500 then 7% Average Kilometres Driven per Month 3,000 if Monthly Kilometres are > 2500 then 360 12% Guaranteed Distance Savings 360 km Average Running Cost Per Kilometre $0.117 Guaranteed Monthly Fuel Savings Per Vehicle $42.12 Step 3: Calculate Engine Idle Time Vehicle Type Savings Idle Savings (Hours) Light Duty Vehicles 6% 4.9 Engine hours Medium Duty Vehicles 12% 9.7 81 Heavy Duty Vehicles 20% 16.2 Guaranteed Monthly Fuel Savings Per Vehicle by Reducing Idle time $15.18 Light Duty Vehicle $10 $210.00 21 days/month Distance Idling Productivity Total Monthly Savings $42.12 $15.18 $210.00 $267 Total Number of Vehicles/Drivers 25 Estimated Monthly Savings $6,682 Number of Branches 1 Total Estimated Cost of the GEOTAB Solution $29,200 Estimated Cost of Financing Per Vehicle Per Month $56 PURCHASE SAVINGS LEASE FINANCED SAVINGS Estimated Gross Annual Savings $80,190 Gross Savings Per vehicle Per Month $267 Estimated Net Savings in Year 1 $50,990 Net Savings Per Vehicle Per Month $212 Estimated Net Savings in Year 2 $131,179 Net Savings Per Year $63,510 The GEOTAB fleet solution will result in payback in under 12 months. Payback is even faster when more time during the day is found for invoiced projects. In addition, GEOTAB alerts risk management of harsh braking and over-speeding. GEOTAB improves maintenance scheduling and provides an audit trail of driving activity as required by government. Qualifying fleets must complete a leasing application and be approved. There are NO monthly fees with GEOTAB -so the savings below are REAL and NET SAVINGS that have a positive impact on your budget! Copyright © GEOTAB 2004, All Rights Reserved MONTHLY FUEL SAVINGS -REDUCE DISTANCE DRIVEN BY MONITORING ROUTE AND PERSONAL TRIPS MONTHLY FUEL SAVINGS -REDUCE ENGINE IDLING -SAVE GREENHOUSE GAS EMISSIONS TARGET 10% to 15% FUEL COST SAVINGS MONTHLY FUEL SAVINGS -REDUCE HIGHWAY SPEEDING -REDUCE ACCIDENT CLAIMS Idling gets you nowhere…turn off your engine…save fuel, save engine wear, save maintenance, reduce SMOG What is the value of 30 extra minutes per vehicle each day to you? Estimated engine hours are based on kilometres driven divided by average 37 kph speed. Fuel loss is about 1% for each kilometre per hour increase in speed over 100 kph Additional benefit of reducing highway speed is reducing accident claims and traffic violations primarily due to rear end collisions. The GEOTAB system reports harsh braking to notify managers of drivers that require driving training. Harsh braking and over-speeding equals higher fuel expense and higher risk of collision and the resulting personal injury. You've just saved each driver 30 minutes each day through more efficient routing, driving and less idling. WHAT IS TIME WORTH TO YOU? This Return On Investment Calculator is a business tool to identify possible areas of savings for a fleet in fuel cost reduction and the resulting improvement in productivity. To review your specific payback calculations, please contact your GEOTAB representative. This document is not an offer to sell, lease or finance GEOTAB systems nor is it a guarantee of payback. GEOTAB will provide a payback guarantee for your specific fleet once your operation has been reviewed. Payback results must be achieved through behavior modification leading to savings. GEOTAB's high resolution information reports provide the best opportunity to retrain and modify behavior based on the quality information gathered. Statistics and percentages are a composite of information available http://oee.nrcan.gc.ca/, www.mto.gov.on.ca/english/pubs/fueleconomy.htm and the GEOTAB White Paper on reducing fleet idling. What does a kilometre of driving cost your operation? Use the calculator below to find savings by reducing distance driven. Keep tires properly inflated, rotated and replaced. Proper tire inflation increases fuel economy by as much as 5%. Don't Idle when stopped. 4 litres of fuel is burned when an engine idles for approximately 1 hour at rest (900 RPM). Watch your speed. At speeds above 100 km/h, the fuel loss is about 1% for each kilometre per hour increase in speed. Keep your car tuned. Proper tuning not only increases fuel economy by up to 10%, but it also reduces air pollution. Use your air conditioner wisely. Air conditioners can increase your fuel consumption by up to 12% in stop-and-go traffic. Unnecessary weight wastes fuel. Every 45 kg (100 lbs) of extra weight consumes 1% more fuel. What is that time worth to you? ...an extra invoiced sale per day, less overtime paid, one less vehicle you need to buy? We'll show you that simply based on the conservative numbers we've provided on this sheet that the GEOTAB system pays for itself in less than 12 months or, if leased, payback is realized immediately. SAVINGS SUMMARYGEOTAB is pleased to offer this financing option through Lease Corporation of America (LCA), widely recognized as a leader in the small ticket lease finance industry throughout the U.S. Below is the LCA lease finance quote you requested with a monthly payment option for your review: Equipment Cost: 29,200.00 $ Term: 24 Lease Option: Monthly Payment Amount (Excludes Sales/Use Tax): 1,389.92 $ * Monthly Payment Amount Per Vehicle (Excluding Sales/Use Tax) 55.60 $ Benefits of Leasing *Finance 100% of the equipment cost, including software, installation and training *Realize potential tax advantages *Budget efficiently with a fixed monthly payment during the entire term of the lease *Conserve operating capital and free up bank lines of credit * Does not include Documentation Fee of $49.00 To qualify for these terms, a one-page application must be submitted to GEOTAB for transmission to LCA. If you have any questions regarding this lease proposal or would like to discuss other leasing options, please contact your GEOTAB account representative at 1-800-227-3716. Best Regards, Account Representative GEOTAB * All payments are exclusive of tax * All leases are subject to credit approval by Lease Corporation of America * Purchase options are available only if lessee has not been in default during the term of the lease * All rights reserved * This is not an application for credit Payment includes sales/use tax on the equipment cost. * Actual payment may vary depending on end-user credit and financial references Finance Proposal Calculator Revision 11/7/03 $1.00 BuyoutCost Bounds Cost Check Cat 1 1000.00 5000.00 0.00 Cat 2 5000.00 10000.00 0.00 Cat 3 10000.00 15000.00 0.00 Cat 4 15000.00 25000.00 0.00 Cat 5 25000.00 50000.00 1.00 Cat 6 50000.00 100000.00 0.00 Card Check Red 0.00 Blue 1.00 Option Check 10% Buyout 0.00 10% Prepaid Purchase Option 0.00 $1.00 Buyout 1.00 Fair Market Value 0.00 Term Check 12.00 24.00 36.00 48.00 60.00 0.00 1.00 0.00 0.00 0.00 Blue 10% PURCHASE OPTION $2,000 -$4,999 0.00000 0.00000 0.00000 0.00000 0.00000 $5,000 -$9,999 0.00000 0.00000 0.00000 0.00000 0.00000 $10,000 -$14,999 0.00000 0.00000 0.00000 0.00000 0.00000 $15,000 -$25,000 0.00000 0.00000 0.00000 0.00000 0.00000 $25,001-$50,000 0.00000 0.00000 0.00000 0.00000 0.00000 $50,001 -$99,999 0.00000 0.00000 0.00000 0.00000 0.00000 Blue 10% SECURITY AND $1.00 BUY OUT LEASE $2,000 -$4,999 0.00000 0.00000 0.00000 0.00000 0.00000 $5,000 -$9,999 0.00000 0.00000 0.00000 0.00000 0.00000 $10,000 -$14,999 0.00000 0.00000 0.00000 0.00000 0.00000 $15,000 -$25,000 0.00000 0.00000 0.00000 0.00000 0.00000 $25,001-$50,000 0.00000 0.00000 0.00000 0.00000 0.00000 $50,001 -$99,999 0.00000 0.00000 0.00000 0.00000 0.00000 Blue $1.00 PURCHASE OPTION $2,000 -$4,999 0.00000 0.00000 0.00000 0.00000 0.00000 $5,000 -$9,999 0.00000 0.00000 0.00000 0.00000 0.00000 $10,000 -$14,999 0.00000 0.00000 0.00000 0.00000 0.00000 $15,000 -$25,000 0.00000 0.00000 0.00000 0.00000 0.00000 $25,001-$50,000 0.00000 0.04760 0.00000 0.00000 0.00000 $50,001 -$99,999 0.00000 0.00000 0.00000 0.00000 0.00000 Blue FMV PURCHASE OPTION $2,000 -$4,999 0.00000 0.00000 0.00000 0.00000 0.00000$5,000 -$9,999 0.00000 0.00000 0.00000 0.00000 0.00000 $10,000 -$14,999 0.00000 0.00000 0.00000 0.00000 0.00000 $15,000 -$25,000 0.00000 0.00000 0.00000 0.00000 0.00000 $25,001-$50,000 0.00000 0.00000 0.00000 0.00000 0.00000 $50,001 -$99,999 0.00000 0.00000 0.00000 0.00000 0.000000.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.04760 0.00000 0.000000.00000 0.00000 0.00000 0.00000 0.00000 0.04760BLUE 10% PURCHASE OPTION Term: 12 24 36 48 60 $2,000 -$4,999 0.09050 0.04760 0.03440 0.02870 $5,000 -$9,999 0.08955 0.04720 0.03385 0.02675 0.02349 $10,000 -$14,999 0.08880 0.04705 0.03355 0.02665 0.02320 $15,000 -$25,000 0.08850 0.04675 0.03345 0.02635 0.02295 $25,001-$50,000 0.08835 0.04660 0.03310 0.02625 0.02270 $50,001 -$99,999 0.08795 0.04622 0.03293 0.02599 0.02250 BLUE 10% PREPAID PURCHASE OPTION Term: 12 24 36 48 60 $2,000 -$4,999 0.08510 0.04713 0.03345 0.02680 $5,000 -$9,999 0.08467 0.04613 0.03278 0.02597 0.02230 $10,000 -$14,999 0.08208 0.04581 0.03253 0.02535 0.02212 $15,000 -$25,000 0.08166 0.04450 0.03209 0.02528 0.02189 $25,001-$50,000 0.08144 0.04428 0.03164 0.02505 0.02165 $50,001 -$99,999 0.08123 0.04407 0.03153 0.02493 0.02141 BLUE $1.00 PURCHASE OPTION Term: 12 24 36 48 60 $2,000 -$4,999 0.09106 0.04850 0.03531 0.02953 $5,000 -$9,999 0.08984 0.04820 0.03438 0.02798 0.02398 $10,000 -$14,999 0.08948 0.04795 0.03395 0.02743 0.02373 $15,000 -$25,000 0.08919 0.04773 0.03373 0.02699 0.02345 $25,001-$50,000 0.08890 0.04760 0.03365 0.02685 0.02310 $50,001 -$99,999 0.08870 0.04730 0.03350 0.02670 0.02290 BLUE FMV PURCHASE OPTION Term: 12 24 36 48 60 $2,000 -$4,999 0.08750 0.04670 0.03356 0.02842 $5,000 -$9,999 0.08720 0.04620 0.03302 0.02649 0.02326 $10,000 -$14,999 0.08690 0.04595 0.03273 0.02639 0.02297 $15,000 -$25,000 0.08670 0.04580 0.03263 0.02609 0.02272 $25,001-$50,000 0.08650 0.04563 0.03238 0.02599 0.02248 $50,001 -$99,999 0.08630 0.04529 0.03225 0.02585 0.02228Tax in Payment Calc 0 0 0 0 Tax on Payment Calc 0 0 0 0 Tax in Payment 1 1 0 1 Tax on Payment 0 0 0 1 M Payment Calc -$ -$ -$ -$ M Tax Calc -$ -$ -$ -$ M Payment -$ -$ -$ -$ M Tax -$ -$ -$ -$ A Payment Calc -$ -$ -$ -$ A Tax Calc -$ -$ -$ -$ A Payment 1,389.92 $ 1,389.92 $ 1,389.92 $ 1,389.92 $ A Tax -$ -$ -$ -$ Up Cost Calc 0 0 0 0 Up Cost 0 1 0 0 0 0 0 0 0 0 0 1 Up Gross Double Calc 0 0 0 0 Up Gross, Double? 1 0 0 1 Master Check 0 0 0 0 combined FALSE FALSE FALSE FALSE Purch Opt Check FALSE FALSE FALSE FALSE State Check FALSE FALSE FALSE FALSE State Taxation Summaries "Up Gross" meaning that sales/use tax is paid up front on the entire receivable. "Up Cost" meaning that sales/use tax is paid up front on the equipment cost. No sales/use tax. "Double Stream" meaning that sales use/tax is paid both up front on the receivable and on the resulting lease payment. (none) IL NH HI ME MT LA NJ OR Fair Market Value Leases (Purchase Options > $100.00) These tables and the resulting calculations are provided to assist in calculating an estimate of the sales/use tax payment, and they may be changed without notice.Up Gross Up Cost No Tax Double Stream0 1 0 0 0 1 0 0 0 0 0 0 1 1 0 1 0 0 0 0 1 1 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 1,389.92 $ -$ -$ -$ ####### -$ -$ -$ -$ -$ -$ 1,389.92 $ 1,389.92 $ 1,389.92 $ 1,389.92 $ ####### -$ -$ -$ -$ -$ 0 1 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 FALSE TRUE FALSE FALSE TRUE TRUE TRUE TRUE FALSE TRUE FALSE FALSE "Up Gross" meaning that sales/use tax is paid up front on the entire receivable. "Up Cost" meaning that sales/use tax is paid up front on the equipment cost. No sales/use tax. "Double Stream" meaning that sales use/tax is paid both up front on the receivable and on the resulting lease payment. Stream AL CA DE HI CT ID MT DC MN NH FL NM OR Nominal Purchase Options (Purchase Options <= $100.00)IN NY IA RI KS LA ME MA MI NE NV OH TX VT VA WA WV WI Up Gross Up Cost No Tax Double Stream
Related docs
Other docs by carthi
Telecom Terminal Equipment Sample Recovery Form
Views: 167  |  Downloads: 2
Suggested Sample for Improvement Measurement
Views: 130  |  Downloads: 5
Pre-orientation test
Views: 229  |  Downloads: 3
GENERAL INFORMATION NOTE
Views: 219  |  Downloads: 1
Faculty Evaluation Form
Views: 177  |  Downloads: 1
Data Analysis for Post-Graduate
Views: 162  |  Downloads: 1
Computer Placement Test_Sample Exam
Views: 316  |  Downloads: 5
COMPRESSIVE STRENGHT
Views: 286  |  Downloads: 0