BioSAT Trucking Model
Using this model requires that macros are enabled for your Excel software. For help with this, visit here for Excel 2007 and here for Excel 2010.
The transport cost is a large cost component in utilizing cellulosic biomass. The most important type of local transport for cellulosic biomass is truck (tractor- trailer) transport. Truck transport costs vary over the type of trailer used, the type of cellulosic biomass transported, and time and space. The BioSAT Trucking Cost Model is designed to accurately estimate the transport costs on a real-time basis by utililzing data specific to the users' needs.
The BioSAT Trucking Cost Model was adapted from Berwick and Farooq (2003) Trucking Cost Model of Transportation Managers with input and validation by seven transportation and/or logistics companies. The model calculates the operation cost for a single round trip haul of 11 hours or less for an owner-operated, non-specialized tractor-trailer hauling class 50 cargo.
Railroad Locations
Railroad Availability by Code (see spreadsheet)
The codes below identify rail accessibility for each zip code tabulation area.
  • 0 - No track access
  • 1 - Rail line
  • 2 - Major Rail Yard
  • 3 - TDSI Auto Distribution Terminals
  • 4 - Bulk Transfer Terminal
  • 5 - Intermodal Terminal
  • 6 - Self Service Tracks
  • 7 - 2 and 3
  • 8 - 2,3, and 4
  • 9 - 2,3,4 and 5
  • 10 - 2,3,4,5 and 6
  • 11 - 4 and 6
  • 12 - 2 and 6
  • 13 - 2 and 5
  • 14 - 2,4 and 5
  • 15 - 2 and 4
  • 16 - 3 and 6
  • 17 - 3 and 5
  • 18 - 4 and 5
BioSAT Partners