# Editable inventory reorder alert worksheet

Planning aid, not an approved inventory policy or purchase authorization. Use sanitized records. Planning, procurement and relevant specialists must approve actual rules.

## Scope and accounting convention

- SKU, location, inventory unit, lot and timezone: ____________________
- Physical, blocked and usable opening quantities: ____________________
- Reservations, orders and forecast consumption: counted once: ____________________
- Supply destination, remaining quantity, usable date and source: ____________________
- Policy version, threshold operator, calendar and freshness limit: ____________________

## 1. Reorder-point threshold

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## 2. Projected safety-stock breach

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## 3. Days-of-cover warning

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## 4. Demand during the full replenishment window

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## 5. Open-order and backorder reconciliation

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## 6. Minimum order quantity

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## 7. Pack multiple and unit conversion

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## 8. Seasonal and event demand

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## 9. Supplier delay or quality hold

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## 10. Stockout escalation and recovery

- Input snapshot and source record IDs: ____________________
- Trigger calculation, comparison basis and expected result: ____________________
- First buffer breach, first unmet demand and recovery date: ____________________
- Missing evidence, constraints and stop condition: ____________________
- Owner, latest useful decision time and next action: ____________________

## Review and release record

- MOQ, pack multiple, upper limit and feasibility: ____________________
- Old and new source versions; deduplication key: ____________________
- Replay cases, expected output, actual output and differences: ____________________
- Planner decision, conditions and reviewed version: ____________________
- No purchase or external action unless separately authorized: ____________________
- Closure evidence, re-open trigger and fallback owner: ____________________

---
OpenMax · 2026-09-04 · https://openmax.com/resources/blog/inventory-reorder-alert-rules/