X

Two-Variable Cost Allocation Calculator

The Two-Variable Cost Allocator Calculator determines allocated costs and performance measures for transit services sorted by travel mode, jurisdiction, service type and individual route/service and by sponsor (if applicable).  The data can be used for National Transit Database (NTD) reporting, managing federal and state grants, and pricing and planning new services. 
The Two-Variable Cost Allocation Calculator is available in an MS Excel or MS Access application.  Both versions provide the same level of specificity for data inputs and produce output reports for individual routes/services or groups of routes.  You do not need Access installed to run the Access version.  

Product Features

 

  • An application tool to help transit agencies accurately allocate costs
  • Available in both Microsoft Excel and Microsoft Access, with the same functionality
  • Transit costs calculated per two variables: time and distance. 
  • Requires no special skills 
  • Relies on standard transit agency data – no new data collection is necessary
  • Can be used to allocate cost to individual routes/services or groups of routes

 

Service Data

Characteristics of the Routes and Services 

  • Route / Service Name: Given name of the service
  • NTD Mode: Options include nine fixed-route and demand responsive travel modes
  • NTD Jurisdiction: Options include Urbanized Area (UZA) or Rural Area (non-UZA). UZAs can be named by the user, and multiple UZAs are allowed
  • Service Type: Options include Directly Operated or Purchased Transportation
  • Sponsored Type: Options include General Public Service or Sponsored
  • Funding Source: Options include Section 5307 Urbanized, Section 5311 Non-Urbanized, Section 5310 Elderly & Disabled, or other sources
Operational Data

Information for each route/service

  • Revenue Hours: Number of revenue hours for the route/service
  • Vehicle Hours: Number of total vehicle hours for the route/service
  • Revenue Miles: Number of revenue miles for the route/service
  • Vehicle Miles: Number of total vehicle miles for the route/service.
    • *Revenue hours/miles must be less than or equal to vehicle hours/miles
  • PassengerTrips: Number of passenger trips for the route/service.

Application Methodology - Four Step Process

Financial Data

Expenses information from Chart of Accounts

  • Choose USOA Object Class: Select the appropriate USOA Object Class for the expense from the available options
  • Subclass: Select the appropriate subclass for the expenses from the available options, corresponding with the use of the expense for the transit agency
  • Enter Amount ($): Write in the amount of the expense using numeric text only; no commas are necessary

 

 

 

Allocate Costs

Putting the three data sets together

Allocate expenses information at the push of a button once data has been entered
in the previous steps

  • Click on the Click to Allocate Costs button at the top of the page
  • Click on the Generate Summary Report button to navigate to the summary report tab and view the cost allocation tables

 

 

 

Getting Started

As with all National RTAP web apps, you must be logged into the Cloud in order to access the Cost Allocation Calculator.  If you do not have a Cloud Account, create one by clicking the “Cloud Signup” button in the top right corner of this page.  If you already have a Cloud Account, log in using the “Cloud Login” button also in the top right corner.  To learn more, please see the Web Apps Overview page on the main National RTAP website. You can also email support@nationalrtap.org for assistance.

 

Instructional Videos and Manual

Excel Version | Webinar | PowerPoint

Access Version | Webinar | Powerpoint