Costs Tab

The Costs tab allows you to specify the cost of running the vehicle.  Among other things, you can enter the purchase date, received date, purchase amount, service life, and usable hours for the vehicle.  Several fields contain values calculated by the system.  These fields are described in the table below:

Field Name

Automatic System Calculations

Full Depreciation Date

 

This is the date expected for the item to be fully depreciated.  The user can modify this value, but the default calculation is:

Received Date + Service Life = Full Depreciation Date.

Service Life

If the user enters a Full Depreciation Date and Purchase Date but not a Service Life value, the system will calculate the Service Life in the following manner:

Full Depreciation Date - Received Date = Service Life

Note:  You will receive an error message if the Full Depreciation Date is not greater than the Received Date.

Field Name

Optional System Calculations (using Toolkit)

 

 

To access this feature, select the Toolkit option on the main menu bar.  You will see the following window:

toolkit

Highlight "Calculate Fleet Rate" and select Execute. The system will run the calculations for Depreciation Amount, Book Value, and Hourly Cost. After the Toolkit has ended its run, refresh the record to view the final calculations.  These calculations are described below.

Depreciation Amount

This is a straight-line depreciation amount that the system calculates in the following manner:

  • Determine TMD:  Service Life*12 = Number of Months for Depreciation
  • Determine Date of Last Full Month (LFM): e.g. if System Date = 4/7/2005 then LFM = March 31, 2005; if System Date = March 31, 2005 then LFM = February 28, 2005.
  • Determine First Month of Depreciation (FMD) and set to the first day of that month:  e.g. April 14, 2001 would be set FMD to 4/1/2001 and April 16, 2001 would be set to 5/1/2001.
  • Determine months between LFM and FMD = MD
  • Final Calculation: (MD(Purchase Amount - Salvage))/TMD = Depreciation Amount

Book Value

Reflects the remaining value using the following calculation:

Purchase Amount - Full Depreciation Amount = Book Value

Hourly Cost

Takes into consideration all vehicles in the class with an operating status less than 950.  This calculation totals all costs spent on a vehicle.  That number is then divided by the total average hours to reach the Hourly Cost value.

Total Costs/Total Average Hours = Hourly Cost

  • Total Costs = Sum of (FL_AMTCST)
  • Total Average Hours = Sum of (FL_USEHRS * ((Current Date - FL_REC_DT)/365)

Note: This calculation is performed by the Toolkit Function, "Calculate Fleet Rate".

Additionally, there are two grids containing information on cost and insurance.  These grids are described below.

In This Section

Cost Information Grid

Insurance Costs Grid

See Also

Fleet Inventory

Fleet Inventory Header Data

General Tab

WO/PM/Req Tab

Travel Log Tab

Tracking Tab

Tasks Tab

Fueling Tab

Items Tab

Specs Tab

Purchase Tab

Eval Tab

Reset Tab

Email Tab

Custom and Comments

Toolkit