Case Study: City of Woodbury achieves year-round accurate inventory and eliminates year-end headaches with Collective Data

How the City of Woodbury Accurately Accounts for its Inventory All Year Long

The City of Woodbury, MN, a fast‑growing suburb of the Twin Cities with 900+ assets and more than $100K in parts inventory, struggled with limited reporting from a previous fleet system that led to inaccurate billing and large year‑end discrepancies. Year‑end inventory reconciliation was painful and finance often had $50K–$80K in unallocated charges, prompting the city to seek a more reliable fleet information system.

After implementing collectiveFleet, Woodbury conducts monthly inventory counts and reconciliations (about eight man‑hours/month), uses barcodes and min/max stocking, and relies on Inventory Valuation and parts‑usage reports to reconcile in real time. The result is accurate billing and allocation, reduced year‑end adjustments, optimized inventory (phasing out slow movers, ensuring critical part availability), improved budget forecasting and regulatory compliance—managed by Fleet Specialist Mike Zilka.

City of Woodbury

Mike Zilka

Fleet Specialist