Fleet Parts Inventory

citydata.mesaaz.gov | Last Updated 2 Oct 2019

Describes the status of parts inventory in the Fleet Services department.

This dataset has the following 27 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Inventory Month Dateinventory_month_datecalendar_dateMonth of the time period reporting
Inventory Yearinventory_yeartextYear of the time period reporting
Inventory Month Yearinventory_month_yeartextMonth/year of time period reporting
Location Codelocation_codetextFS=West Mesa shop, EM=East Mesa shop, Both= EM and FS shops combined.
Quantity On Handquantity_on_handnumberNumber of each part in inventory
Value On Handvalue_on_handnumber$$ amount of each part in inventory
Stock Issue Quantitystock_issue_quantitynumberQuantity of inventory issued from stock
Stock Issue Valuestock_issue_valuenumber$$ amount of stocked parts issued from inventory
Special Order Issue Quantityspecial_order_issue_quantitynumberQuantity of special-order inventory issued
Special Order Issue Valuespecial_order_issue_valuenumber$$ amount of special-order parts inventory issued
Total Issue Quantitytotal_issue_quantitynumberTotal amount of stocked and special-order parts issued
Total Issue Valuetotal_issue_valuenumberTotal $$ amount of stocked and special-order parts issued
Fill Ratiofill_rationumber% of time parts requested are in stock and able to be issued
Inactive Inventory Quantity 6 Monthsinactive_inventory_quantitynumberQuantity of parts that have not been issued in past 6 months
Inactive Inventory Value 6 Monthsinactive_inventory_valuenumber$$ amount of parts that have not been issued in past 6 months
Inactive Inventory Quantity 1 Yearinactive_inventory_quantity_1numberQuantity of parts that have not been issued in the past 12 months
Inactive Inventory Value 1 Yearinactive_inventory_value_1number$$ amount of parts that have not been issued in the past 12 months
Inactive Inventory Quantity 2 Yearsinactive_inventory_quantity_2numberQuantity of parts that have not been issued in the past 24 months
Inactive Inventory Value 2 Yearsinactive_inventory_value_2number$$ amount of parts that have not been issued in the past 24 months
Average Last 3 Months Value On Handaverage_last_3_months_valuenumberAverage $$ amount of inventory for last 3 months
Last 3 Months Value Stock Issueslast_3_months_value_stocknumber$$ amount of stock issued in last 3 months
Last 3 Months Percent Turnlast_3_months_percent_turnnumberLast 3 months value stock issues/average last 3 months value on hand *100
Part Delay Countpart_delay_countnumberNumber of delays due to parts unavailability
Part Delay Hourspart_delay_hoursnumberNumber of delay hours due to parts unavailability
Total Repairstotal_repairsnumberTotal repairs for the time frame indicated
Part Delay Repair Percentpart_delay_repair_percentnumberPart delay count/total repairs *100
IDidtextMonth-date-year-time that report automatically generated