Steel fabrication
Structural fabricator, two plants, 214 stocked parts
The situation
A portal-frame fabricator running two plants. Bills of materials lived in one estimator's spreadsheet, stock lived in the memory of whoever had been in the yard longest.
The challenge
Nobody trusted the stock figure, so every job was counted twice before it was committed. Purchase orders were raised from a phone call and rekeyed into Xero at month end. A missing bolt set could hold a frame on the floor for a week.
The outcome
Both plants barcoded and counted in over a fortnight. Bills of materials moved out of the spreadsheet and into formula-driven parts lists, so a change of span reflows the cut list. Purchase orders now post straight into Xero as they are approved.