Make stock and reorder assumptions visible.
Fictional worked example. These are illustrative inputs, not customer results.
Starting point
Fictional example — not a customer result: A fictional homewares seller supplies 80 SKUs and eight weeks of sales with supplier lead times.
Illustrative delivery
Illustrative output: The workbook flags items below the approved reorder threshold and shows the sales window and safety-stock assumptions behind each flag.
Illustrative working detail
| Input | Illustrative value |
|---|---|
| Average daily units | 5 |
| Supplier lead time | 10 days |
| Owner-approved safety stock | 20 units |
| Reorder threshold | 70 units |
Illustrative threshold: 5 × 10 + 20 = 70 units. The owner approves assumptions. Seasonal demand, supplier disruption and missing stock movements can make a simple threshold unsuitable; this is a planning worksheet, not automatic ordering.
What you receive
- Excel stock and reorder workbook
- assumptions sheet
- missing-data report
- usage instructions
What we check
Reconcile SKU counts and opening stock; independently test lead-time demand and threshold formulas; flag insufficient sales history instead of projecting certainty.
Your completed package uses your approved source material and agreed assumptions. This example is not a guarantee of business results.