Search for Inventory Planning Setup, or find it
under Manual Setup. One page configures all four calculators.
General
These settings apply to every calculator.
| Field | Default | What it does |
|---|---|---|
| Demand History Window (Days) | 365 | Calendar days of history to analyse, ending on the work date. Range 30–1095. A shorter window reacts faster to change but is noisier; a longer one is stabler but lags. |
| Min Demand Observations | 20 | Minimum number of days with demand before a result is produced. Below this the item reports Insufficient Demand Data. Minimum 3. This counts days, not transaction lines. |
| Round Up Results to Whole Units | Yes | Round results up to whole units. Turn off for items measured in kilograms, litres or metres. |
| Log Calculation History | Yes | Write an entry to the calculation log for every calculation. Leaving this on is what makes results auditable. |
| Skip Make-to-Order Items | Yes | Skip items whose replenishment is make-to-order. Their supply is driven by the order that demands them, not by a reorder point. |
| Fallback Lead Time (Days) | 7 | Used when neither receipt history nor the item’s Lead Time Calculation yields a lead time. |
| Count Consumption as Demand | No | Count production and assembly consumption as demand alongside sales. Turn this on in manufacturing companies, or purchased components will report zero demand. |
| Trend Warning Threshold % (0 = off) | 30 | Warn in the calculation note when recent demand deviates from the window average by more than this. Set 0 to disable. |
Safety stock
| Field | Default | What it does |
|---|---|---|
| Default Service Level % | 95 | Probability of not stocking out during a replenishment cycle. Range 70–99.99. Can be overridden per item. |
| Write Safety Stock to Item | Yes | Turn off to calculate and log without writing anything to items — useful while you are evaluating. |
Service level is not linear in cost.
Moving from 95% to 99% roughly doubles the buffer. Raise it for the items
where a stockout is expensive, not across the board — that is what the
per-item override is for.
Reorder point
| Field | Default | What it does |
|---|---|---|
| Add Safety Stock to Reorder Point | Yes | Include the freshly calculated safety stock in the reorder point, rather than the value stored on the item. |
| Write Reorder Point to Item | Yes | Turn off to preview only. |
| Set Policy to Fixed Reorder Qty. when None | Yes | Give items with no reordering policy one, so the calculated reorder point actually does something. Suppressed for an item when the advisor recommends a different policy. |
| Write Maximum Inventory (ROP + EOQ) for Maximum Qty. Items | Yes | Set the order-up-to level for items on the Maximum Qty. policy. |
EOQ
| Field | Default | What it does |
|---|---|---|
| Ordering Cost (S) | 50 | Cost of placing one order — administration, receiving, inspection — in your local currency. This is the single input most worth getting right. |
| Holding Rate | 0.25 | Annual cost of holding one unit as a fraction of unit cost. 0.25 means 25% a year, covering capital, storage, insurance and obsolescence. Range 0–1. |
| Maximum EOQ (Months of Demand) | 6 | Cap on the result. Stops a cheap, high-volume item from ordering two years of stock. Minimum 0.5. When the cap binds, the result code is Cap Applied. |
| EOQ Write Target | Reorder Quantity | Or Order Multiple, if you would rather the planning engine round order sizes than fix them. |
| Unit Cost Source | Last Direct Cost | Or Standard Cost or Unit Cost. Pick the one your items actually populate. |
| Write EOQ to Item | Yes | Turn off to preview only. |
Policy advisor
| Field | Default | What it does |
|---|---|---|
| Intermittent ADI Threshold | 1.32 | Average Demand Interval above which demand counts as intermittent. The standard Syntetos–Boylan value. |
| Erratic CV-Squared Threshold | 0.49 | Squared coefficient of variation above which demand size counts as erratic. Also Syntetos–Boylan. |
| Treat Shelf Life as Maximum Qty. | Yes | Items with an Expiration Calculation are steered to the Maximum Qty. policy so standing stock is capped. |
| Auto-Update Item Reordering Policy | No | Whether an applied advice run writes the recommended policy to the item. Off by default. Recommendations are logged either way — turn this on only once you trust the advice. |
Auto-update only ever writes Fixed Reorder Qty., Maximum Qty. or
Lot-for-Lot. It never flips an item to Order automatically:
that is a sourcing decision, not a statistical one.
Planning engine integration
| Field | Default | What it does |
|---|---|---|
| Supply Values at Planning Time (Dynamic) | No | Supplies freshly calculated values to the planning engine during a planning run, instead of relying on whatever the last batch run wrote to the item. |
Verify the dynamic provider on a sandbox first.
Run a regenerative plan for one item, confirm the requisition line reflects
the calculated values, and check that a Dynamic Supply entry appears
in the calculation log. Real Stockkeeping Units are never modified, items that
cannot be calculated fall back to their stored values, and order modifiers
stay under the planning engine’s control.
Actions on this page
- Create Job Queue Entry — a daily 03:00 recurring entry,
created on hold for you to review - Planning Worksheet — opens the
worksheet - Calculation Log — opens the
log
