Fleet Fields

These are fields on the fleet record that have to do with the assets operational status.

These is a field on the fleet record that has to do with the assets operational status.

These are fields found on the fleet record that store information about inspections.

These are fields found on the fleet record that store information about fuelings.

These fields help agencies estimate the running cost of a vehicle and assess its life span based on running costs and recorded usage. Some of these fields are entered by the user. (These fields appear in white in the module.) Other fields are calculated automatically by the system. (These fields are grayed out in the module.)

These need to be filled out prior to the other fields being properly calculated.

eval fields 1

These fields record the status of vehicle when it was first used. (orange)

Start Date

The date the vehicle went into service.

Starting Odometer

Starting Hourmeter

Starting Other Meter

The meter reading when the vehicle went into service.

These fields record life expectancy of the vehicle. (blue)

Service Life

The number of years the vehicle is expected to be in service.

Maximum Odometer

Maximum Hourmeter

Maximum Other Meter

The anticipated maximum meter reading for the vehicle.

Maximum Cost

The maximum amount of money available to spend on vehicle repairs and preventative maintenance during the vehicle's life span.

These fields record the estimated annual usage of the vehicle. (green)

Est. Ann. Odometer

Est. Ann. Hourmeter

Est. Ann. Other Meter

The estimated annual meter reading for the vehicle.

Est. Annual Cost

The estimated annual expenses for the vehicle.

Once the above fields have been populated and the record is saved, the system will automatically calculate values for the remaining fields. These calculated fields are highlighted in yellow below.

calcualted eval fields

These fields have to do with the current state of the vehicle. They are updated each night, as well as upon save or refresh of the Fleet record. The data in these fields come from Fleet Fuelings, Work Orders, Travel Logs, and Reset records. If any of these records are created with a more recent date and higher meter reading, these fields will be updated.


Current Amounts
Current Date	The last date that any work, fueling, travel log, or reset was recorded for the vehicle.
Most Current Time	The last time that any work, fueling, travel log, or reset we recorded on the last date. This allows multiple of the previously mentioned records to occur on the same day.
Current Odometer Current Hourmeter Current Other Meter	The most recent meter reading. This can come from a fueling record, travel log, work order, or reset.
Vehicle Usage
Amount Used Date	The number of years the vehicle has been in service. Calculated as: Current Date - Start Date.
Used Odometer Used Hourmeter Used Other Meter	The number of miles the vehicle has been used since being put into service. Calculated as: Current Odometer - Starting Odometer.
Used Cost	The total dollar amount spent on the vehicle to date. This includes work order costs, fueling costs, and additional costs. Calculated as Fuel Total Cost + Total Maintenance Cost + Sum of Amount Fields on all Cost Information Records.
Total Maintenance Cost	The sum of all work order costs for this vehicle. Calculated by adding the WO Cost field on all Work Order Asset records for the vehicle.
Fuel Total Cost	The total cost of fueling the vehicle. Note: Also appears in the Fueling Related Fields. Calculated by adding the Total Fuel Cost fields for all fueling records found in the Fueling grid.
Remaining Amounts
Remaining Date	The number of years left the vehicle's estimated max lifespan. Calculated as Maximum Amount - Amount Used.
Remaining Odometer Remaining Hourmeter Remaining Other Meter	The available working miles left in the vehicle's estimated max meter reading. Calculated as Maximum Odometer - Used Odometer.
Remaining Amt	The amount left in the budget for vehicle repairs and maintenance. Calculated as Maximum Cost - Used Cost.
Actual Annual Usage
Actual Odometer Actual Hourmeter Actual Other Meter	The amount the vehicle is used every year. Calculated as Used Odometer / Amount Used Date.
Actual Annual Cost	The dollar amount spent to keep the vehicle running over the course of a year. Calculated based on Used Cost / Amount Used Date.
Estimated Remaining Lifespan based on Usage
Remain Odo Life Remaining Hour Life Remaining Other Life	An estimate of how many more years the vehicle will run. Calculated as Remaining Odometer / Actual Odometer.
Remaining Cost Life	The dollar amount left per year to keep the vehicle working. Calculated as Remaining Amt / Actual Annual Cost.
Average Total Cost per Meter
Cost per Odometer Cost per Hourmeter Cost per Other Meter	The dollar amount required to run the vehicle for one iteration of the meter. For example, it costs $2 to drive the vehicle for one mile. Calculated as Used Cost / Used Odometer.
Average Total Maintenance Cost per Meter
Maint Cost/Odometer Maint Cost/Hourmeter Maint Cost/Other Meter	The dollar amount required to maintain the vehicle for one iteration of the meter. For example, it costs $4 to drive it one mile. Calculated as Total Maintenance Cost / Used Odometer.
Total Operational
Total Operational Cost	The dollar amount required to operate the vehicle and keep it operational. Calculated based on Fuel Total Cost + Total Maintenance Cost.

These fields record how many rear tire slots are on a vehicle. This is required if you are going to attach tires to the vehicle.

Lucity Web includes a variety of empty fields that an agency can customize to meet its needs. The number of custom fields available varies by module.

Last Inspection	The last date the asset was inspected. Automatically filled out from the Inspection Date field of the most recent inspection record.
Inspection Freq	The number of (date) units between inspections.
Inspection Freq Units	The type of date units between inspections.
Next Inspection	The date the next inspection should occur. This is calculated in one of two ways. If the Inspection Freq and Inspection Freq Units fields are populated, the system will calculate this field automatically based on the Last Inspection date field. If a user manually enters the Next Insp Date on the previous inspection. If the Inspection Freq and Inspection Freq Units fields are filled out and the user fills out the Next Insp Date on the inspection the program uses whichever the closer date. Example: An inspection was completed on 8/15/2014. The user filled out the Next Insp Date as 12/3/2014 but the calculated date is 8/15/2015. This field will display 12/3/2014. Users can filter records by the Next Inspection Date to identify facilities that need to be inspected.

Fuel Total Units	Calculates the sum of the Fuel Amount fields for all fueling records found in the Fueling grid.
Fuel Total Cost	Calculates the sum of the Total Fuel Cost fields for all fueling records found in the Fueling grid.
Total Fluid Cost	Calculates the sum of the Other Fluids fields for all fueling records found in the Fueling grid.

Purchase Date	The date the vehicle was purchased.
Purchase Amount	The dollar amount of the vehicle at purchase.
Received Date	The date the vehicle was taken possession of.
Service Life	The number of years that the vehicle is expected to be used before being retired.
Full Dep. Date	The date that the vehicle will no longer be used. This date is auto-calculated as: Received Date + Service Life = Depreciation Date.
Salvage Value	The dollar amount for which the vehicle can be sold or salvaged.
Dep. Amount	The current worth of the vehicle, which is calculated as follows: Determine the number of Months of Service Life (MSL): *Service Life12 = MSL Determine the date of Last Full Month (LFM) by noting the current date and determining the last day of the previous month. For example, if system date = 4/7/2005 then LFM = 3/31/2005; if system date = 3/31/2005 then LFM = 2/28/2005. Determine the First Month of Depreciation (FMD*) by looking at the Received Date. If the Received Date* is during the first half of the month (14th and before), that month is used. If the Received Date is during the second half of the month, the system considers the next month the FMD. For example, a Received Date of 4/14/2001 would set the FMD to 4/1/2001. A Received Date of 4/16, 2001 would be set to 5/1/2001. Determine the Months of Depreciation (MD): LFM - FMD = MD Final calculation: [MD(Purchase Amount - Salvage)]/MSL = Depreciation Amount
Book Value	The remaining value of the vehicle, which is calculated as: Purchase Amount - Depreciation Amount = Book Value
Replace Cost	The dollar amount necessary to replace the vehicle.
Hourly Cost	The price of operating the vehicle for one hour. This calculation adds all costs related to the vehicle. That number is then divided by the total average hours to reach the Hourly Cost value. Total costs/Total Average Hours = Hourly Cost This field is calculated for all equipment with an operating status less than 950.
Total Ins Cost	The sum of the Amount fields from all records in the Insurance Costs grid.

Last Modified By	The login ID of the last Lucity user to modify the record.
Last Modified Date	The date that the record was last modified.

Pick-List	Lets users select a value (code/type) from an agency-defined list.
Alphanumeric	Allows users to enter letters or numbers in any combination.
Check-box	Used to indicate yes/no or on/off.
Numerical	Accepts numbers only.
Date	Provides a pop-up calendar to enable the user to select a date.