The model builds on-hand stock from opening balances, goods received and net dispatches as of a selected date. The reorder point combines minimum stock with expected demand during the supplier's lead time.
Which inbound stock counts
Open orders due within lead time contribute to stock position. Overdue inbound is visible in a separate column so the model does not count it as stock arriving on time. For items below the reorder point, the recommended buy quantity closes the gap to the target and rounds up to the supplier's ordering lot.
The review at 31 October 2026
Twenty of 48 SKUs were flagged for replenishment. The proposed purchase totals 642 units and €5,004.54 at standard unit cost. The workbook also shows 278 overdue inbound units and includes controls for the stock equation, supplier matching and purchasing totals.


Inventory overview with replenishment quantities, purchasing value and overdue inbound stock.
0 likes · 0 views · Nov 17, 2026
A twelve-sheet inventory model for 48 SKUs. The review identifies 20 reorders and 642 units to buy, worth €5,004.54, with overdue stock shown separately.