21. Real-World Project Briefs

21.3 Inventory Reorder Sheet

By Ravindra Bagale · Last updated: 6 October 2026

The ask. Salman manages stock at a fictional Nashik dark store. Every morning he wants a list of SKUs that have reached the reorder point, with a suggested order quantity, so the purchase order goes out before noon.

Sheet Stock, A1:F6 (fictional):

What to deliver (one under the other):

1. Make the range a Table named tblStock.
2. Add Reorder point = Avg daily sales × Lead time + Safety stock.
3. Add Action: "Order" when On hand is at or below the reorder point, else "OK".
4. Add Order qty = Max stock − On hand, only when Action is Order, else 0.
5. Add Days of cover = On hand ÷ Avg daily sales, one decimal.
6. Filter Action = Order and copy the list into the purchase order.

Key formulas (row 2; copy down or let the Table fill them):

G2: =[@[Avg daily sales]]*[@[Lead time (days)]]+[@[Safety stock]]
H2: =IF([@[On hand]]<=[@[Reorder point]],"Order","OK")
I2: =IF([@Action]="Order",[@[Max stock]]-[@[On hand]],0)
J2: =ROUND([@[On hand]]/[@[Avg daily sales]],1)

Expected result (check your numbers):

SKUs to order today: 3. Total units on the purchase order: 245.

Checks before you send it:

1. Lead time is in days, the same unit as daily sales.
2. Order qty is 0 for every OK row.
3. Milk (lead time 1 day) is checked every morning, not weekly.
4. Days of cover is shown with one decimal.