What this tool helps you organize
Combine average demand, lead time and an entered stock buffer. It is one defined worksheet, not a complete assessment of your circumstances.
No supplier reliability or demand distribution is modelled.
Method and calculation rules
Reorder marker = daily demand × lead time + your buffer, rounded up.
Display values are rounded for readability. The calculation uses the entered numbers before display rounding. Whole-unit outputs use the rounding rule stated in the method.
Know your inputs
- Average units used per day — Accepted range: 0 to 1000000.
- Supplier lead time (days) — Accepted range: 0 to 1000000.
- Chosen stock buffer (units) — Accepted range: 0 to 1000000.
A worked example
Illustrative inputs: Average units used per day: 12; Supplier lead time (days): 7; Chosen stock buffer (units): 30.
Reorder marker: 114 units
Lead-time demand: 84 units
Chosen buffer: 30 units
These sample figures illustrate the formula, not a recommended target or a prediction.
How to use the working copy
Define a single scenario, check the units and replace each sample value that does not match it. Calculate and read all three result components, not just the most favorable number.
Change one assumption to compare scenarios. An edited field makes the previous answer stale; recalculate before downloading or printing. Reset sample clears the open result and restores the example entries.
What the answer cannot establish
No supplier reliability or demand distribution is modelled.
The tool does not verify the accuracy, completeness or current validity of your inputs. Use authoritative current information and qualified judgement when the decision requires them.
Questions about this worksheet
Are the starting values a suggested target?
No. They show how the arithmetic behaves. Use your own checked values and do not infer a recommendation.
Why is my previous result marked stale?
Changing an input means the displayed answer no longer describes the current fields. Recalculate to refresh it.
Can I share an export?
Review the entries and limitations first. A downloaded file is a working copy, not an independently verified report.
Your entries and privacy
The bundled calculation runs in this open browser page. Inputs are not automatically saved as a server-side calculation history. Browser refresh or navigation may clear them.
Contact messages and technical website records are separate from calculator arithmetic. Read the Privacy Policy for the distinction; do not enter confidential records or credentials.