Inventory System

Stock levels lived in a spreadsheet that three people edited at once. Reorder decisions were made from numbers that were often two days old, and the team regularly discovered shortages only when an order could not be fulfilled.

A single source of truth for stock, with intake and dispatch recorded as events rather than overwritten cells. Reorder thresholds are evaluated continuously, and the people who need to act are notified before a shortage happens rather than after.