Replenishment arithmetic
Calculate cover, stockout risk, reorder quantity, and the risk list from supplied values.
Provide stock, reservations, inbound units, average daily sales, lead time, pack size, target cover, and remaining capacity. StockMosaic returns risk and reorder records.
Sign in and you go straight back to the StockMosaic conversation. Work happens in chat. This page never asks for your card details or email address.
14-DAY COVER
- B3 days of cover
- A14 days of cover
Inclusive 14-day horizon. Soonest first, then SKU. C stays off the list because 40 days of cover is above the tape. This is the in-repo risk-list check, not a published retailer packet.
FIRST REAL RESULT
A replayed inventory-risk list with replenishment assumptions
Cover arithmetic · pack-rounded reorder · no purchase sentHOW THE WALL IS RANKED
Only SKUs with 14 or fewer days of cover appear, soonest first.
Average daily sales must be positive for cover and risk-list calculations. Reorder quantity is capped by remaining capacity.
| SKU | On hand | Reserved | Avg daily sales | Days of cover | On the list |
|---|---|---|---|---|---|
| B | 30 | 0 | 10 | 3 | yes |
| A | 80 | 10 | 5 | 14 | yes |
| C | 200 | 0 | 5 | 40 | no |
- 01
StockMosaic validates every numeric input and requires positive sales for cover and risk-list calculations.
- 02
It computes available units and compares days of cover with the supplied lead time.
- 03
It rounds reorder shortfall to whole packs, caps it by capacity, and sorts qualifying SKU risks by cover then SKU.
THREE RETURNS FROM THE SAME ENGINE
Cover, stockout diagnosis, and a capacity-capped reorder.
Available 50 units · 5 days of cover against a 7-day lead time.
stockout_before_replenishmentOn hand 45 + inbound due 10 − reserved 5, at 10 average daily sales. Non-positive average daily sales is refused.Pack-rounded shortfall 120, then capped by remaining capacity 100.
100 unitsTarget 21 days × 8 daily sales, net of on hand 40, inbound 24, reserved 8, pack size 12.A soonest-first SKU risk list limited to 14 days of cover
B then AC is dropped. Purchase drafts stay approval-required. The engine does not write to ERP or WMS.Available units, days of cover, and a covered or stockout-before-replenishment result
A reorder quantity rounded to whole packs and capped by remaining capacity
A soonest-first SKU risk list limited to 14 days of cover
WHAT YOU PUT ON THE WALL
The mosaic is built from the numbers you supply.
Inputs cover stock, reservations, inbound units, average daily sales, lead time, target cover, pack size, and capacity.
- 01
On-hand, reserved, and inbound units for each SKU
- 02
Average daily sales and supplier lead time in days
- 03
Target cover days, pack size, and remaining warehouse capacity
- 04
SKU rows for the inclusive 14-day risk list
THE PURCHASE LINE
A reorder record is not a purchase order.
Forecasts depend on sales history, lead-time quality, and stated assumptions.
Purchase orders remain proposals until a buyer approves them.
- Forecasting a sales rate that was not supplied
- Placing a purchase order or changing inventory
- Producing a cover result from non-positive or invalid average daily sales
STARTER
Open a replenishment workspace.
$19.00 is stated here before you register; card payment runs through Stripe Checkout inside the signed-in workspace.
$19.00 per month
Continue to workspace billingBEFORE YOU RANK SKUS
Questions
How is stockout risk decided?
Available units are on hand plus inbound due before lead time minus reserved units. Their days of cover are compared with the supplied lead-time days.
How is the reorder quantity calculated?
The target stock is target days times average daily sales. Current and inbound stock net of reservations is subtracted, the shortfall is rounded to packs, and capacity caps the result.
Which SKUs appear in the risk list?
Only supplied SKU rows with 14 or fewer days of cover appear. They are sorted by the lowest cover first, then by SKU.
Does the result create a purchase order?
No. The engine returns arithmetic and a risk list; purchase execution is outside this capability.