Skip to content
January 23, 2013 / or4green

Vehicle Fleet Comparisons using GREET

Recently I was asked to do some calculations to determine whether it made sense for my city of New London, CT to switch from a gasoline-fueled truck fleet to one running on compressed natural gas (CNG).  Could this change lower fuel costs and emissions, and have a reasonable payback period?  I wrote about the GREET transportation model from Argonne national lab a while back and thought this would give me a good chance to take its fleet footprint calculator for a spin.  I found it to be a flexible and relatively user-friendly tool.  One of the dangers of these calculators is that the user is not always aware of the assumptions being made (see this post about the issue in LCA calculators) but in the case of GREET, many of the assumptions are clearly indicated within the calculator.  Furthermore, you have the ability to alter them to suit your own situation.  I did have to do a little reverse-engineering to arrive at the results I was looking for, which I describe below.


The calculator, part of which is shown in the screen shot above, can be run using one of two methods.  I used method two, for when you already know the fuel consumption of your fleet.  In method one, you specify the size of the fleet by vehicle and fuel types, selecting from the following lists:

Vehicle Types:

  • School Bus
  • Transit Bus
  • Shuttle/Paratransit Bus
  • Waste Hauler
  • Street Sweeper
  • Delivery Step Van
  • Transport/Freight Truck
  • Medium/Heavy Duty Pickup Truck
  • Maintenance Utility Vehicle
  • Other

Fuel types:

  • Gasoline
  • Diesel
  • Diesel HEV
  • Biodiesel (B20)
  • Biodiesel (B100)
  • Ethanol (E85)
  • Compressed Natural Gas (CNG)
  • Liquefied Natural Gas (LNG)
  • Liquefied Petroleum Gas/ Propane (LPG)
  • Electricity
  • Gaseous Hydrogen (G.H2)
  • Liquid Hydrogen (L.H2)

So for instance, you could enter five school buses running on diesel, a street sweeper on B20, delivery van on CNG, etc.  The GREET calculator has average mileages and fuel economies for each vehicle-fuel pair, which it can then use together with your inputted fleet information to generate overall fuel usage.  All of the mileage and fuel economy numbers are estimates, assumptions the calculator is making for your fleet.  But these are editable by the user.  So if you know your school buses average 6,000 miles per year instead of the default 12,000, you can simply change that value.  Ideally, you would have the fuel usage information, as my city fortunately does, and you would be able to skip all of this and use Method two.  But, the functionality of Method one allows you to conduct some what-if explorations, to see what kind of fuel usage and emissions you might rack up should you decide, for example, to add a street sweeper to your fleet.  Or suppose you are starting a brand new campus from scratch and want to explore various combinations of vehicles.

Our situation was quite simple:  compare a small gasoline-fueled fleet with an equivalent (in terms of mileage) CNG fleet on fuel usage and emissions.  I could easily enter the fuel usage (roughly 3,000 gallons of gasoline annually) into the calculator.  GREET then output petroleum usage of 67.8 barrels of oil and 37.6 short tons of GHG emissions.  To find the equivalent amount of CNG, I had to work backwards since the calculator does not have a direct conversion capability, though perhaps this is present in another of the Argonne tools.  The fuel use block in the calculator has a “gasoline gallon equivalent” line at the bottom.  So a crude way to achieve the conversion is to enter numbers in the desired fuel column (vehicle type does not matter) until the gasoline equivalents match.  In my case, a few tries got me fairly close with 360,000 cubic feet of CNG (see screen shot below).


To get a more accurate value, I drilled down into the calculations for the gasoline-equivalent row.  The conversion is fairly straightforward and can be extracted from the calculator with a small amount of trace-back through cell formulas.  Essentially the different fuel types start off as apples and oranges, but can be compared by converting them into energy in units of Btu’s.  This is achieved by GREET using the lower heat values (LHV), and it indicates values of 0.983 Btu per cubic feet of CNG, and about 115,000 Btu per gallon of gasoline.  This assumes the gasoline is 50% conventional / 50% reformulated or low sulfur and that CNG is sourced in North America with a breakdown of 77% conventional and 23% shale (which can be extracted using fracking).  Again, these assumptions are indicated in the calculator and you could adjust them as needed.  I included a partial screen shot below showing the CNG assumptions; you can also see many of the others.  Depending on your scenario, changes in assumptions may or may not make a difference.  But you would need to determine that, rather than just going with what the default settings tell you.


Putting the LHV’s together results in the following conversion formula, which is what GREET used in this case:


That is about 116.832 cubic feet of CNG per gallon of gasoline.  For the fleet I was looking at, that translates to approximately 357,506 cubic feet annually.  Now that the equivalent amounts of both fuels are known, then given the unit price of each, a fuel cost comparison can be made.


When I was doing the rough trial and error fuel calculation before, I left both the CNG and gasoline fuel consumptions in the spreadsheet.  Now with a precise value for the CNG amount from my formula above, I delete the gasoline to see the consequences of a CNG-only fleet.  The calculator reports 0.4 barrels of oil and 33.8 short tons of GHG emissions.  Why is there still petroleum usage even though we have switched to CNG?  GREET calculates emissions and petroleum usage in a well-to-wheels (WTW) manner, so it is including the life-cycle of the fuel from the time it is extracted through transport to when it is consumed by the vehicle.  Of course it does take some form of energy to get even a clean fuel from well to wheels.

I also drilled down into this emissions calculation and it is similar to the fuel equivalence one, but adds the additional emissions factor corresponding to each fuel.  This is the key factor underlying sustainability arguments.  CNG is generally considered a more environmentally friendly fuel than gasoline because it produces fewer emissions.  So this emissions factor, which GREET provides in units of grams per Btu, should be lower for CNG compared to gasoline.  Or should it?  The table below lists the factors used by GREET:


Notice how source location of the CNG makes the difference between whether it is environmentally favorable to gasoline or not (at least in terms of CO2 emissions).  This is a US-based tool; hence the non-North-American (NNA) CNG takes an environmental hit, which I am guessing is due to transport emissions.  In our case I assumed North American (NA) CNG, resulting in a 10% emissions reduction for our fleet as compared to gasoline.   The calculation for North American CNG, for instance, would be:


It is interesting to see the emissions factors for various fuel types in the table from the GREET calculator above.  For instance, notice how CNG sourced from landfill gas (LFG) has a negative factor for the upstream portion of GHGs because using this source as fuel prevents emissions from entering the atmosphere that otherwise would have.  There are still associated emissions at the tailpipe as the fuel is burned, but the net effect is very small (factor of 0.018) compared to most of the other fuels.


What would happen next is a look at the cost side of the problem.  Find the prices of each fuel and the replacement CNG vehicles.  Determine the annual fuel savings and then the payback period for the new fleet.  This is tricky as the fuel prices can be highly variable, but you can use estimates from the EIA or elsewhere and run a few different scenarios to get a sense of what might happen.  I did a quick and dirty check and found these fuel prices:

  • Gasoline:  $3.50 / gallon in New England as of 1/21/13 (via this EIA page)
  • CNG:  $2.12 / gasoline gallon equivalent (GGE) in U.S. as of Oct. 2012 (via this EERE page)

Note that the GGE units save one the trouble of converting cubic feet of CNG to equivalent Btu’s, something I did above.  Still, when it comes time to budget or order, you’d need to know how much fuel is needed.  Be aware that these numbers are rough estimates and don’t even match up completely in terms of date and location, but qualitatively you can see a pretty large price difference.  And if you look at the web page the CNG price came from, you can see from the price plot that CNG has not exceeded $2.50 / GGE going back to 2000.

The following table summarizes the results for our example:

Fuel Type

Fuel Consumption

Estimated Fuel Cost

CO2 Emissions (short tons of CO-2 equivalent GHG’s)

% Change in CO2 Emissions Relative to Gasoline

Gasoline 3060 gal. $10,710 37.61
CNG – non-North American 357,506 ft3 38.16 1.5%
CNG – North American 357,506 ft3 $6,487 33.84 -10.0%

The savings are there fuel-wise, on the order of $4K per year, though that is spread over several vehicles.  So it would take some time to recoup the capital expense of investing in the new vehicles.  (This provides a nice opportunity to utilize the capital budgeting problem, found in many undergrad O.R. texts.)  More realistically, vehicles nearing end of use would be replaced with comparable CNG vehicles (and the equipment replacement problem comes in for that).  On the emissions side, the switch to (native) CNG leads to a decent reduction, as was pointed out above.

To tie in more directly with O.R., consider the decision problem of what kind of fuel-type vehicles your fleet should contain.  GREET provides information in the form of energy usage (lower heat values) and emissions on a wide array of types, under many different assumptions (e.g. sourcing).  It can form the back end of a decision support tool using an integer program optimization, the decision variables being how many of each type of vehicle to obtain.  You would most likely add in tables to calculate costs, which might be the (or an) objective.  Constraints could ensure you have enough of each type of vehicle to accomplish required tasks (e.g. trash hauling, landscaping, etc.), are not consuming more a type of fuel than is available (e.g. via electric charging stations), and more.

GREET focuses on vehicles, but a fairly similar problem exists for heating air and water.  We ran a capstone project in 2011 in which our students studied alternate fuel types for the boiler plant using mixed integer programming including elements of the capital budgeting problem.  Similar emissions and energy factors played a role, though the higher heat value (HHV) is used instead of the lower heat value in the case of a boiler.  And there are calculators to handle this kind of work, such as the Clean Air – Cool Planet calculator.  You can go further and combine the energy usage and emissions of not only vehicles and boiler plants, but also buildings (see some of the tools from the EPA’s Energy Star program), industrial facilities, etc. and so look at virtually all aspects of a city or town.  The organization ICLEI provides tools for doing this type of work.

But to get a good handle on vehicle fleets the GREET calculator it is an effective way to go.  It provides a central location for much of the data you need to perform vehicle comparisons, and then uses that data combined with your input to provide vehicle fuel use and emissions.  It lays its assumptions out clearly and it is easy for the user to change them.  And it is transparent enough to allow you to reverse engineer its calculations should you want to take things a step or two further.  So it is clearly a practical tool, but it also is a great learning tool, one that can be a great starting point for a project-based assignment in O.R. and sustainability.  I plan to put something together in the future.  If you do, let me know.


  1. fleet vehicles / Jan 31 2013 10:02 am

    Thanks for sharing this! As a business owner myself, I’m always on the lookout for tools and technologies my company can utilize that will help save money and generate revenue. I have used privately held fleet vehicles management services companies in the past and someone did mention if it would be more beneficial to switch to trucks that run on natural gas as opposed to gasoline-fueled fleet trucks. You go well into depth and explanation. I would like to show this research to my team. Thanks again for sharing!

  2. or4green / Feb 2 2013 5:54 pm

    Thanks, glad you liked it. Please let me know if it ends up being of any use to your company, and also if there are other real-world considerations your team would have in this situation.

  3. TM Fleet Management / Jun 24 2013 4:44 pm

    Great post – I haven’t looked at OR since my uni days (Applied Stats for business & Industry). So its great to see it applied to my current industry – fleet management

Comments are closed.

%d bloggers like this: