Categorise car costs
Monday, 12 July 2010 20:32

This calculator is a tool to get a quick overview of your transportation costs. Several kinds of costs will be computed. See also the tab Instructions and the example.

CategoryTypeCosts per
unit
# per
drive
# drivesTotal
row

`        `

Suppose you want to estimate your car costs over the last year. This calculator facilitates quick input of any of your costs types. Use the plus (+) button to add extra rows with costs and the minus buttons (-) to remove rows.

Enter in each row a costs category and a costs type. For example the category could be Commuting and a type could be Fuel (Miles) or Fuel (km) to indicate the fuel costs per distance unit. Enter the fuel price per mile or kilometer in field Costs per unit. This number can be computed with the Fuel Costs Calculator. Enter the number of miles or kilometers per drive in field # per drive. In field # drives you should enter the number of drives to the office last year.

Then enter rows for other categories and types. Another category could be drives for private purposes. Another costs type could be Parking (hours). Suppose you have to pay to park your car at the office. The daily parking time is 9 hours and the rate is \$2/hour. In that case you could add a row with the text Commuting in field Category and the text Parking (hours) in field Type, the value 2 in field Costs per unit, the value 9 in field # per drive and in field # drives the number of working days. Note that it is possible to enter multiple rows with the same values in fields Category and/or Type.

Do the same for non-business traffic: enter similar rows to compute the fuel costs and the parking costs. Use a different value for field Category, such as Weekend travel but the same values for field Type: Fuel (Miles) and Parking (hours).

The calculator computes the total of all parking and fuel costs together after the text Total costs. Two new tables will appear with the costs per type and per category. This way it is easy to compare your fuel costs with your parking costs and to compare the commuting costs to the costs for weekend travel.

You can export your input data with the button Save input data. You can import the saved data later and redo the computation. After clicking a new window/tab appears. Save this page from your browser into a file. To reimport the contents of this file you load the file into a text editor, and paste the contents into the field in the tab Import input. Finally click on the button Import data in the same tab.

You can export your input data with the button Save input data in the first tab. You can import the saved data later and redo the computation. After clicking a new window/tab appears. Save this page from your browser into a file. To import the contents of this file load the file into a text editor, and then paste its contents into the field in the tab Import input. Finally click on the button Import data in the same tab.