A cumulative report for all vehicles detailing total cost and calculate cost per mile.
Vehicle- Vehicle ID
Description- Description of the Vehicle
Age- Age of the Vehicle based on In Service Date.
Capital Cost- The Capital Cost column reflects the current (depreciated) capital cost and is calculated as follows: (Capital Cost of the Vehicle x Age in month) / Expected Life in months.
If Expected Life is zero, Capital Cost will be listed as zero on the report.
Operating Cost- Total of all Cost Codes through the Cutoff date.
Total Cost- Adds the Capital and Operating Cost columns for each vehicle.
Miles Used- Total miles recorded for the vehicle.
Avg Miles Per Month- The Miles Used divided by the Vehicle Age.
Capital Cost Per Mile- Capital Cost for the Vehicle divided by Miles Used.
Operating Cost Per Mile- Operating Cost divided by Miles Used.
Total Cost Per Mile- Total Cost divided by Miles Used.
Department Totals- All columns are totaled by department.
Report Totals- All columns are totaled for the entire report.