The weekly KPIs that matter most are the ones that expose stock risk early. A buyer at a 7-store accessories chain saw stockout rate rise 18% from Q3 to Q4. The issue was not forecasting, but measurement: they tracked total inventory value across stores instead of days of supply by location. The total looked healthy while individual locations ran dry before the weekend.
Weekly KPI tracking is for early action, not management reports. A stockout in week 4 of a 14-week season may be solved with a fast reorder. Find it in week 11 and you cannot. These five metrics show inventory health with time to respond.
1. Inventory Turns
Formula: Net sales divided by average inventory at cost, annualized.
Inventory turns shows how often all inventory sells and is replaced during a period. Higher turns usually mean less cash tied up and less markdown exposure. Lower turns point to slow sellers or over-buying.
Typical fashion and accessories range: 4 to 8 turns per year in well-managed operations. Sporting goods and home goods often run at 2 to 5 turns because products last longer and have higher average unit value.
The weekly view focuses less on the annualized rate than on direction. If turns decline week-over-week through mid-season, stock is building faster than sales. Pause reorders for slow categories and shift buying attention early.
Turns vary by category. Basics should turn faster than seasonal statement items. Category-level tracking, rather than only brand or store tracking, shows where the issue sits.
2. Days of Supply
Formula: Current on-hand stock divided by average daily sales rate.
Days of supply estimates how long current stock lasts at the present sales pace. It is highly actionable because it turns an inventory figure into a time horizon.
Your supplier lead time sets the target range. With a 10-day lead time, keep at least 14 to 21 days of supply at every location, covering lead time and a safety buffer. With 30 days of lead time, raise the minimum floor accordingly.
Track days of supply by location, not brand, to catch the earlier problem. One city may have 45 days of supply while another has 6. The aggregate can hide the entire shortfall.
For most multichannel fashion and accessories retailers, a practical SKU target is 21 to 60 days of supply. Below 21 days risks a stockout before replenishment arrives. Above 60 days suggests over-buying, so consider moving units from a high-stock location to a low-stock one.
3. Fill Rate
Formula: Complete order lines or units shipped divided by total order lines or units requested.
Fill rate is especially important for wholesale or B2B retailers and online orders containing several items. A low rate produces partial orders, adding fulfillment cost, customer friction, and return risk.
For omnichannel retailers, fill rate shows whether online inventory can meet demand when orders arrive. When stores and online share stock, it also signals how well the channels stay synchronized.
Target: above 95% for most retail operations. Below 90% generally points to under-buying from a forecasting issue or inventory assigned to the wrong channel.
4. Stockout Rate
Formula: Active SKUs with zero on-hand inventory divided by total active SKUs in the assortment, expressed as a percentage.
Stockout rate is the clearest measure of buying accuracy. If 12% of active SKUs are out of stock on a given day, 12% of potential selling surface is unavailable. Some customers wait, but most do not.
A realistic target for a well-managed multichannel retailer is below 5% stockout rate at any point in the season. Above 8% indicates a systemic issue in forecasting, reorder frequency, or supplier reliability.
Track stockout rate by location, not only in aggregate. A zero brand-level result may mean a popular SKU is available at six stores but sold out at the two highest-traffic ones. That is a transfer opportunity hidden by the total.
5. Dead Stock Percentage
Formula: Units on hand for more than a defined period, typically 90 days for fashion and 120 days for home goods, divided by total inventory units.
Dead stock is the counterpart to stockout rate. Stockouts indicate under-buying, while dead stock percentage indicates over-buying. Both cost money: dead stock ties up working capital, uses warehouse space, and often leaves through markdowns instead of full-margin sales.
The dead stock threshold depends on category and season length. In a 16-week fashion season, units unsold at week 12 are effectively dead for that season. For basic or evergreen items without a seasonal end, 90 days without movement is reasonable.
Target: below 8% of total inventory units in dead stock status. Above 12% means meaningful overstock, likely to sell at a loss through markdowns or become a liability in the following season.
How These Five Work Together
Read these metrics together, not separately. Rising stockout rate and dead stock percentage often indicate concentration buying: too much of the wrong SKUs and too little of the right ones. Falling fill rate with rising days of supply points to channel allocation, not volume. The five-metric pattern is more useful than any single figure.
A weekly view of these five metrics is not enough by itself. It confirms a problem, but not the SKU, location, or response: a purchase order, store-to-store transfer, or early markdown. Diagnosis requires per-location, per-SKU visibility. KPIs provide the signal, while SKU data identifies the fix.
If these calculations still happen manually in a spreadsheet, weekly review will take too long. Aim to spend 15 minutes reviewing the numbers and 45 minutes deciding what to do, rather than 4 hours preparing the report.