MihsabaHow to use
Estimate weeks and calendar days of coverage from available stock and average weekly demand, excluding future receipts.
- Enter matching-period inputs with consistent units: Available stock in consistent units, Average weekly demand in the same unit
- Weeks of supply = available stock ÷ average weekly demand; days = weeks × 7
- Calculate, then check data definitions and assumptions in the note before comparing with another period.
How it is calculated
Example
Available stock of 600 units at average weekly demand of 120 covers five weeks or 35 calendar days. If demand rises to 150, coverage falls to four weeks or 28 days.
Important notes
Use stock available to fulfill demand after reservations or unusable quantities under your definition. Coverage assumes constant demand, no new receipts, no separately protected safety stock and no seasonal change. Seven days per week is a calendar equivalent, not working days or a guaranteed stockout date. Zero demand has no finite coverage, so demand must be positive; zero stock is allowed.
Worked examples and interpreting results
Available stock of 600 units at average weekly demand of 120 covers five weeks or 35 calendar days. If demand rises to 150, coverage falls to four weeks or 28 days.
| Case | Calculation | Result |
|---|---|---|
| Weeks of coverage | 600 ÷ 120 | 5 |
| Days of coverage | 5 × 7 | 35 days |
How to check the result
Use stock available to fulfill demand after reservations or unusable quantities under your definition. Coverage assumes constant demand, no new receipts, no separately protected safety stock and no seasonal change. Seven days per week is a calendar equivalent, not working days or a guaranteed stockout date. Zero demand has no finite coverage, so demand must be positive; zero stock is allowed.
Frequently asked questions
Is this the same as inventory turnover days?
Coverage uses available quantity and weekly demand. Turnover days use past cost of goods sold and average inventory at cost.
What happens if demand doubles?
Coverage halves if stock stays fixed. Try different demand scenarios rather than relying on a single average.
Are the starting inputs my actual data?
They are only the worked example. Replace them with your data and press Calculate. Editing an input clears the old result.