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:
439
rating:
not rated
reviews:
0
posted:
12/24/2007
language:
English
pages:
0
FLEET FUEL SAVINGS CALCULATOR 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. 25 TARGET 10% to 15% FUEL COST SAVINGS 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. MONTHLY FUEL SAVINGS - REDUCE DISTANCE DRIVEN BY MONITORING ROUTE AND PERSONAL TRIPS Step 1: Calculate Fuel Cost per Kilometre Average Litres Purchased Per Month Average Cost per Litre Average Monthly Fuel Purchases Average Kilometres Driven per Month Step 2: Distance Driven per Vehicle and Guaranteed Savings Estimated Kilometres Driven Per Vehicle Per Month If Estimated Monthly Kilometres are < 1500 then if Monthly Kilometres are > 1500 and <2500 then if Monthly Kilometres are > 2500 then 450 $0.78 $351 3,000 3,000 36000 annual 5% 7% Guaranteed Distance Savings Average Running Cost Per Kilometre 360 360 $42.12 12% km $0.117 Guaranteed Monthly Fuel Savings Per Vehicle MONTHLY FUEL SAVINGS - REDUCE ENGINE IDLING - SAVE GREENHOUSE GAS EMISSIONS Idling gets you nowhere…turn off your engine…save fuel, save engine wear, save maintenance, reduce SMOG Step 3: Calculate Engine Idle Time Estimated engine hours are based on kilometres driven divided by average 37 kph speed. Vehicle Type Light Duty Vehicles Medium Duty Vehicles Heavy Duty Vehicles Savings 6% 12% 20% Engine hours 81 Idle Savings (Hours) 4.9 9.7 16.2 $15.18 Light Duty Vehicle Guaranteed Monthly Fuel Savings Per Vehicle by Reducing Idle time MONTHLY FUEL SAVINGS - REDUCE HIGHWAY SPEEDING - REDUCE ACCIDENT CLAIMS 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. WHAT IS TIME WORTH TO YOU? You've just saved each driver 30 minutes each day through more efficient routing, driving and less idling. 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. What is the value of 30 extra minutes per vehicle each day to you? $10 $210.00 21 days/month SAVINGS SUMMARY Distance Monthly Savings Total Number of Vehicles/Drivers Number of Branches Total Estimated Cost of the GEOTAB Solution Idling Productivity Total $42.12 25 1 $29,200 $15.18 $210.00 Estimated Monthly Savings $267 $6,682 $56 Estimated Cost of Financing Per Vehicle Per Month There are NO monthly fees with GEOTAB - so the savings below are REAL and NET SAVINGS that have a positive impact on your budget! PURCHASE SAVINGS Estimated Gross Annual Savings Estimated Net Savings in Year 1 Estimated Net Savings in Year 2 LEASE FINANCED SAVINGS Gross Savings Per vehicle Per Month Net Savings Per Vehicle Per Month Net Savings Per Year $80,190 $50,990 $131,179 $267 $212 $63,510 Qualifying fleets must complete a leasing application and be approved. 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 Copyright © GEOTAB 2004, All Rights Reserved Finance Proposal Calculator Revision 11/7/03 GEOTAB 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): Monthly Payment Amount Per Vehicle (Excluding Sales/Use Tax) $1.00 Buyout $ 1,389.92 * $ 55.60 Payment includes sales/use tax on the equipment cost. 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 * Actual payment may vary depending on end-user credit and financial references * 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 Cost Bounds Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 Cat 6 Card Check Red Blue Option Check 10% Buyout 10% Prepaid Purchase Option $1.00 Buyout Fair Market Value Term Check 1000.00 5000.00 10000.00 15000.00 25000.00 50000.00 5000.00 10000.00 15000.00 25000.00 50000.00 100000.00 Cost Check 0.00 0.00 0.00 0.00 1.00 0.00 0.00 1.00 0.00 0.00 1.00 0.00 12.00 0.00 24.00 1.00 36.00 0.00 48.00 0.00 60.00 0.00 Blue 10% PURCHASE OPTION $2,000 - $4,999 $5,000 - $9,999 $10,000 - $14,999 $15,000 - $25,000 $25,001- $50,000 $50,001 - $99,999 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.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 Blue 10% SECURITY AND $1.00 BUY OUT LEASE $2,000 - $4,999 $5,000 - $9,999 $10,000 - $14,999 $15,000 - $25,000 $25,001- $50,000 $50,001 - $99,999 Blue $1.00 PURCHASE OPTION $2,000 - $4,999 $5,000 - $9,999 $10,000 - $14,999 $15,000 - $25,000 $25,001- $50,000 $50,001 - $99,999 Blue FMV PURCHASE OPTION $2,000 - $4,999 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.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.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.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 $5,000 - $9,999 $10,000 - $14,999 $15,000 - $25,000 $25,001- $50,000 $50,001 - $99,999 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.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.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.04760 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.04760 BLUE 10% PURCHASE OPTION Term: $2,000 - $4,999 $5,000 - $9,999 $10,000 - $14,999 $15,000 - $25,000 $25,001- $50,000 $50,001 - $99,999 12 0.09050 0.08955 0.08880 0.08850 0.08835 0.08795 24 0.04760 0.04720 0.04705 0.04675 0.04660 0.04622 36 0.03440 0.03385 0.03355 0.03345 0.03310 0.03293 48 0.02870 0.02675 0.02665 0.02635 0.02625 0.02599 60 0.02349 0.02320 0.02295 0.02270 0.02250 BLUE 10% PREPAID PURCHASE OPTION Term: $2,000 - $4,999 $5,000 - $9,999 $10,000 - $14,999 $15,000 - $25,000 $25,001- $50,000 $50,001 - $99,999 12 0.08510 0.08467 0.08208 0.08166 0.08144 0.08123 24 0.04713 0.04613 0.04581 0.04450 0.04428 0.04407 36 0.03345 0.03278 0.03253 0.03209 0.03164 0.03153 48 0.02680 0.02597 0.02535 0.02528 0.02505 0.02493 60 0.02230 0.02212 0.02189 0.02165 0.02141 BLUE $1.00 PURCHASE OPTION Term: $2,000 - $4,999 $5,000 - $9,999 $10,000 - $14,999 $15,000 - $25,000 $25,001- $50,000 $50,001 - $99,999 12 0.09106 0.08984 0.08948 0.08919 0.08890 0.08870 24 0.04850 0.04820 0.04795 0.04773 0.04760 0.04730 36 0.03531 0.03438 0.03395 0.03373 0.03365 0.03350 48 0.02953 0.02798 0.02743 0.02699 0.02685 0.02670 60 0.02398 0.02373 0.02345 0.02310 0.02290 BLUE FMV PURCHASE OPTION Term: $2,000 - $4,999 $5,000 - $9,999 $10,000 - $14,999 $15,000 - $25,000 $25,001- $50,000 $50,001 - $99,999 12 0.08750 0.08720 0.08690 0.08670 0.08650 0.08630 24 0.04670 0.04620 0.04595 0.04580 0.04563 0.04529 36 0.03356 0.03302 0.03273 0.03263 0.03238 0.03225 48 0.02842 0.02649 0.02639 0.02609 0.02599 0.02585 60 0.02326 0.02297 0.02272 0.02248 0.02228 Tax in Payment Calc Tax on Payment Calc Tax in Payment Tax on Payment M Payment Calc M Tax Calc M Payment M Tax A Payment Calc A Tax Calc A Payment A Tax Up Cost Calc Up Cost 0 0 1 0 $ $ $ $ $ $ $ $ 1,389.92 0 0 0 0 0 1 0 FALSE FALSE FALSE $ $ $ $ $ $ $ $ 0 0 1 0 1,389.92 0 1 0 0 0 0 0 FALSE FALSE FALSE $ $ $ $ $ $ $ $ 0 0 0 0 1,389.92 0 0 0 0 0 0 0 FALSE FALSE FALSE $ $ $ $ $ $ $ $ 0 0 1 1 1,389.92 0 0 0 1 0 1 0 FALSE FALSE FALSE Up Gross Double Calc Up Gross, Double? Master Check combined Purch Opt Check State Check State Taxation Summaries 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. Fair Market Value Leases (Purchase Options > $100.00) "Up Gross" meaning that sales/use tax is paid up front on the entire receivable. (none) "Up Cost" meaning that sales/use tax is paid up front on the equipment cost. IL ME NJ "Double Stream" meaning that sales use/tax is paid both up front on the receivable and on the resulting lease payment. HI LA No sales/use tax. NH MT OR IA KS LA ME MA MI NE NV OH TX VT VA WA WV WI Up Gross Up Cost No Tax Double Stream 0 0 1 0 $ $ $ $ $ $ $ $ 1,389.92 0 0 0 0 0 1 0 FALSE TRUE FALSE $ $ $ $ $ $ $ $ 1 0 1 0 1,389.92 1,389.92 1 1 0 0 0 0 1 TRUE TRUE TRUE $ $ $ $ $ $ $ $ 0 0 0 0 1,389.92 0 0 0 0 0 0 0 FALSE TRUE FALSE $ $ $ $ $ $ $ $ 0 0 1 1 1,389.92 0 0 0 1 0 1 0 FALSE TRUE FALSE 0 0 0 1 1 0 $ $ $ $ $ $ $ ####### $ $ ####### $ 0 1 0 0 0 0 0 0 0 0 Nominal Purchase Options (Purchase Options <= $100.00) "Up Gross" meaning that sales/use tax is paid up front on the entire receivable. AL CT DC FL "Up Cost" meaning that sales/use tax is paid up front on the equipment cost. CA ID MN NM "Double Stream" meaning that sales use/tax is paid both up front on the receivable and on the resulting lease payment. HI No sales/use tax. DE MT NH OR Stream IN IA KS LA ME MA MI NE NV OH TX VT VA WA WV WI NY RI Up Gross Up Cost No Tax Double Stream

Related docs
Fuel Savings Calculator
Views: 49  |  Downloads: 5
The Fuel Savings Calculator
Views: 18  |  Downloads: 5
Savings Calculator
Views: 313  |  Downloads: 25
AJW Fuel Savings Calculator
Views: 2  |  Downloads: 1
savings calculator
Views: 99  |  Downloads: 11
fuel economy calculator
Views: 262  |  Downloads: 2
Simple Savings Calculator
Views: 79  |  Downloads: 6
Simple Savings Calculator
Views: 198  |  Downloads: 11
Gas Cost Calculator For
Views: 10  |  Downloads: 1
Simple Savings Calculator
Views: 182  |  Downloads: 13
Fuel cost savings
Views: 10  |  Downloads: 2
Fuel Savings
Views: 52  |  Downloads: 1
premium docs
Other docs by carthi
Telecom Terminal Equipment Sample Recovery Form
Views: 256  |  Downloads: 3
Suggested Sample for Improvement Measurement
Views: 395  |  Downloads: 6
Pre-orientation test
Views: 340  |  Downloads: 3
GENERAL INFORMATION NOTE
Views: 336  |  Downloads: 1
Faculty Evaluation Form
Views: 349  |  Downloads: 5
Data Analysis for Post-Graduate
Views: 338  |  Downloads: 9
Computer Placement Test_Sample Exam
Views: 509  |  Downloads: 9
COMPRESSIVE STRENGHT
Views: 551  |  Downloads: 2
Business Source Premier
Views: 189  |  Downloads: 1
Business Plan
Views: 390  |  Downloads: 19
Additional Account Form
Views: 109  |  Downloads: 0
WSI SALES SHEET TEMPLATE
Views: 143  |  Downloads: 1
Withdrawal_Request
Views: 119  |  Downloads: 0