A worked example of the written summary and SKU-level results included in an Inventory Review.
Illustration only. These 10 products and their history are synthetic. This is not a customer report, testimonial or evidence of savings. An actual review is based on the agreed data and scope.
10SKUs reviewed
3reorder alerts
404suggested units*
1. What to review first
Canvas tote: no units available. Verify any incoming stock and supplier capacity first. The formula suggests 132 units; a new order cannot fix today’s stockout.
Oat body wash: 10 days of cover, 14-day lead time. The formula suggests 82 units. Confirm whether incoming stock or a change in lead time changes the decision.
Daily face serum: 9 days of cover. The formula suggests 190 units, but its sales rate is based on just 10 in-stock days. Confirm that availability record and review whether the observed rate is representative.
2. Where cash may be tied up
Amber table lamp has 400 days of observed stock cover. Check seasonality and future plans before adding stock. Stoneware mug has 80 units and no sales across 90 fully in-stock days; it is a dead-stock candidate for review, not an automatic write-off.
3. Data gaps that change the answer
New linen pouch has only 5 days of history: no stockout or reorder estimate is shown. Jasmine tea tin has no recent sales but did sell earlier; it is not classified as dead stock. Oak coaster set has only 18 calendar days of history and its estimate may be unstable.
4. SKU action list
One synthetic stock pool · units are whole units
SKU / product
Available
Days of cover
Suggested units
Status
OAT-001Oat body wash
20
10.0
82
Reorder now
SOAP-002Cedar hand soap
70
35.0
0
Healthy
LAMP-003Amber table lamp
400
400.0
0
Slow mover
MUG-004Stoneware mug
80
Unknown
0
Dead-stock candidate
TOTE-005Canvas tote
0
0.0
132
Reorder now
NEW-006New linen pouch
25
Unknown
0
Insufficient data
TEA-007Jasmine tea tin
12
Unknown
0
No recent demand
CANDLE-008Juniper candle
52
26.0
0
Watch soon
SERUM-009Daily face serum
45
9.0
190
Reorder now
COASTER-010Oak coaster set
18
18.0
0
Watch soon
*The 404-unit total adds quantities across different products. It is not a budget, purchase order or value calculation.
5. Assumptions & calculation check
Safety buffer: 7 days. Next order coverage: 30 days. Slow-moving threshold: more than 90 days. Sales and inventory must refer to the same stock pool and snapshot.
OAT-001 60 sold ÷ 30 in-stock days = 2 units/day 20 available ÷ 2 = 10 days of cover Reorder point = ceil(2 × (14 + 7)) = 42 units Suggested reorder = ceil(2 × (14 + 7 + 30) − 20) = 82 units
Incoming orders are not deducted. Check outstanding orders, minimum quantities, pack sizes, promotions, cash constraints and seasonal demand before ordering. Observed sales do not reveal lost demand during stockouts.
6. Questions before taking action
Do all sales windows and stock numbers represent the same location?
Are there confirmed incoming orders for the three reorder items?
Was a promotion responsible for the serum’s observed sales rate?
Is the lamp seasonal, and is the mug still actively listed?
Show the calculation explanation for every SKU
OAT-001 · Oat body wash
60 units sold ÷ 30 in-stock days = 2 units/day. 20 available units provide about 10 days of cover. Stock is at or below the 42-unit reorder point (14 lead + 7 safety days). Consider 82 units to cover lead, safety, and 30 review days.
SOAP-002 · Cedar hand soap
60 units sold ÷ 30 in-stock days = 2 units/day. 70 available units provide about 35 days of cover. Stock is above the reorder point and within the configured stock-cover limits.
LAMP-003 · Amber table lamp
30 units sold ÷ 30 in-stock days = 1 units/day. 400 available units provide about 400 days of cover. Coverage exceeds 90 days. Review demand and stock levels.
MUG-004 · Stoneware mug
80 units remain after 90 fully observed, in-stock days with no sales. Review this dead-stock candidate before buying more.
TOTE-005 · Canvas tote
90 units sold ÷ 30 in-stock days = 3 units/day. 0 available units provide about 0 days of cover. Stock is at or below the 42-unit reorder point (7 lead + 7 safety days). Consider 132 units to cover lead, safety, and 30 review days.
NEW-006 · New linen pouch
Only 5 in-stock days are available in the recent window. At least 7 are required; coverage and reorder estimates are withheld.
Only 5 calendar days of history are available.
TEA-007 · Jasmine tea tin
No sales were recorded during the recent in-stock days. A stockout date cannot be estimated; review demand before buying more.
CANDLE-008 · Juniper candle
60 units sold ÷ 30 in-stock days = 2 units/day. 52 available units provide about 26 days of cover. Coverage is within 7 days of the lead-plus-safety window. Watch this SKU; no reorder is triggered yet.
SERUM-009 · Daily face serum
50 units sold ÷ 10 in-stock days = 5 units/day. 45 available units provide about 9 days of cover. Stock is at or below the 85-unit reorder point (10 lead + 7 safety days). Consider 190 units to cover lead, safety, and 30 review days.
Demand is estimated from 10 in-stock days; missing demand during stockouts is unknown.
COASTER-010 · Oak coaster set
18 units sold ÷ 18 in-stock days = 1 units/day. 18 available units provide about 18 days of cover. Coverage is within 7 days of the lead-plus-safety window. Watch this SKU; no reorder is triggered yet.