<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=114819295626675&amp;ev=PageView&amp;noscript=1">
CONTACTAPPLY

How to Forecast the Annual Fuel Usage For Your Business

[fa icon="calendar"] Jan 3, 2019 9:19:00 AM / by Piper Bloom

Blog_stacks-of-papers_Rectangle

Every new year, it’s essential to forecast the annual fuel usage of your business in order to create a tentative budget and monitor for any significant changes. If you’re looking to create an estimate for 2019, these tips will help you navigate the challenging issues to make actionable predictions.

 

Start with Gallons Versus Dollar Spend

The oil and gas industry is one of the most volatile and unpredictable markets around, making it difficult to estimate future prices. Between the sensitivity of crude oil prices to supply and demand changes and domestic refining issues , it’s almost impossible to predict when prices will rise and fall. However, while it’s difficult to predict the prices that you will pay at the pump, it’s easier to forecast the number of gallons that you will use. If you have a fleet card, you can automatically generate a report that breaks down how many gallons your company purchased each month. Otherwise, you may need to compile your total fuel spending for the year, then divide by the average fuel price for your area. This will give you a rough estimate of how many gallons you used over the previous year. Once this is complete, take time to evaluate whether your spending will increase over the next year. Have you added any vehicles or added new routes? Take these changes into account when running your calculations.

 

Create Your Average Budget

Once you’ve estimated your monthly consumption by gallons, you can multiply it by the average price you expect to pay per gallon. To ensure that you’re giving your team enough wiggle room, you may even want to add a buffer of a few cents to this calculation. Though your actual spending may be higher or lower, this gives you the baseline you need to monitor your fleet’s monthly spending.

 

Evaluate Monthly Differences

One factor that often goes overlooked in business spending is the number of working days per month. Break out your calendar and tally the number of days every month that your drivers could possibly fuel. In 2019, February has 20 weekdays while May has 23, so you may want to adjust your May budget to account for these three extra days. For industries where drivers work 6 days per week or frequently pick up weekend shifts, you should take these extra days into account for each month. Additionally, industries with drastically different seasonal volumes need to be very specific when creating their budget, and you should look back on previous usage to guide your calculations.

 

Consider the Breakdown of Diesel Versus Unleaded

If you have different types of vehicles, be sure to run separate calculations for the costs of diesel and unleaded fuel. In 2018 the national average unleaded price was $0.456 lower than the average diesel price, so keep these differences in mind if your fleet uses multiple fuel types. If your fleet includes unleaded vehicles, it is essential to ensure that your drivers are not splurging on premium unleaded without cause, so this may be the perfect time to review your driver fuel card policy with your employees.

 

Create Your Price Forecast

If you want to get extremely granular in your forecast, historical data is your best friend. The U.S. Energy Information Administration (EIA) has been recording daily gas prices since 1990, and you can download a full spreadsheet of their data at eia.gov. By looking at the prices in your region over the last few years, you can get a better idea of what to expect every month. To get an idea of where prices are headed, you can also look at the EIA’s national average forecast for 2019, though nothing is guaranteed. You should also be aware of regional differences when looking at these predictions, and you can use the historical data to estimate the differences between the national average and your specific routes. In general, prices rise over the summer and during holidays, so take these changes into account while creating your budget.

 

Example of an Annual Fuel Forecast

To help you forecast your 2019 fuel budget, we’ve mocked up some numbers to guide your way. These estimates are for a company operating on the west coast with 10 unleaded vehicles and 9 diesel trucks. This business is also expanding and plans to add an additional diesel truck in May, which will raise their expenditures moving forward. When reviewing the prices from 2018, they found that the west coast usually experiences higher fuel prices than the national average, so they need to adjust their estimate accordingly. As a result, they’ve added $0.579 to the estimated unleaded prices throughout the year and $.466 to the diesel. With the December 2018 price slightly above the forecasted 2019 average, we factored in a slow monthly decline in prices.

  Gallons Price Forecast
  Unleaded Diesel Total Unleaded Diesel Unleaded Diesel Total
January 500 9,000 9,500 $3.125 $3.589 $1,562 $32,298 $33,860
February 500 9,000 9,500 $3.116 $3.557 $1,558 $32,015 $33,573
March 500 9,000 9,500 $3.108 $3.526 $1,554 $31,733 $33,287
April 500 9,000 9,500 $3.100 $3.494 $1,550 $31,450 $33,000
May 500 10,000 10,500 $3.091 $3.463 $1,546 $34,631 $35,859
June 500 10,000 10,500 $3.083 $3.432 $1,542 $34,317 $35,859
July 500 10,000 10,500 $3.075 $3.400 $1,537 $34,003 $35,541
August 500 10,000 10,500 $3.067 $3.369 $1,533 $33,689 $35,223
September 500 10,000 10,500 $3.058 $3.338 $1,529 $33,375 $34,905
October 500 10,000 10,500 $3.050 $3.306 $1,525 $33,062 $34,587
November 500 10,000 10,500 $3.042 $3.275 $1,521 $32,748 $34,269
December 500 10,000 10,500 $3.033 $3.234 $1,517 $32,434 $33,951
Total 6,000 116,000 122,000     $18,474 $395,754 $414,228
Average 500 9,667 10,167 $3.079 $3.416 $1,540 $32,979 $34,519

 

Keeping It Simple?

If your company requires a less complicated version of a fuel forecast, you can create a simple spreadsheet to send to your team. Take the average price you paid in 2018 and add 46 Cents per gallon to account for the EIA's estimated price increases across 2019. Though this is less accurate than a comprehensive monthly forecast, it will work for companies that don't need a more precise estimate. 

 

Conclusion

As you calculate your fuel usage for the new year, these tips will help you make informed predictions. Though the cost of fuel is erratic and volatile, you can still create a tentative budget that will help your company stay on track throughout 2019.

 

To learn about the reports your company should be using, click here! 

Topic: Fuel Cards

 

Piper Bloom

Written by Piper Bloom

Subscribe for Updates