Free Weeks of Cover and Inventory Health Checker
Total stock can look fine while half your range is short and the other half is overstocked. Paste stock and demand by item to see which is which, and how much cash is sitting in the excess.
Weeks of cover and inventory health checker
Paste stock and demand for each item. It shows which items are about to run out, which are carrying too much, and how much cash is sitting in the excess. Nothing is uploaded: the numbers stay in your browser.
Weeks of cover = stock on hand divided by average weekly demand. Use forward-looking demand (your forecast, or recent actual sales if the forecast is unreliable), not last year's average. Excess = stock above your maximum weeks of cover. Short = stock needed to reach your minimum. The 2 and 8 week defaults are starting points: set them by product, using lead time and shelf life.
Related
- Weeks of Cover: The Simplest Inventory Metric You're Probably Using Wrong
- Why You're Out of Stock and Overstocked at the Same Time
- Safety stock calculator
- All free Nerd Tools
Want someone to look at the whole picture? The Planning Health Check from Forward Cover reviews your forecasting, inventory and supply planning and tells you where the money is leaking.