StocklightEXAMPLE REVIEW · SYNTHETIC DATA

Your inventory.
Your next decisions.

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

  1. 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.
  2. 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.
  3. 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 / productAvailableDays of coverSuggested unitsStatus
OAT-001Oat body wash2010.082Reorder now
SOAP-002Cedar hand soap7035.00Healthy
LAMP-003Amber table lamp400400.00Slow mover
MUG-004Stoneware mug80Unknown0Dead-stock candidate
TOTE-005Canvas tote00.0132Reorder now
NEW-006New linen pouch25Unknown0Insufficient data
TEA-007Jasmine tea tin12Unknown0No recent demand
CANDLE-008Juniper candle5226.00Watch soon
SERUM-009Daily face serum459.0190Reorder now
COASTER-010Oak coaster set1818.00Watch 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

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.

Only 18 calendar days of history are available.

Download example results CSVRequest an Inventory Review · THB 990