Replacing a 14-sheet inventory spreadsheet
Problem
Stock was tracked across fourteen linked Excel files maintained by three people. Reconciliation took two days a month and purchase decisions were made on numbers that were always a week stale.
What we did
Built a web-based inventory and purchase system with barcode entry, role-based access and automatic reorder alerts. Migrated four years of history and ran both systems in parallel for a month.