Case Studies /Know When to Reorder
A bookshop shelf runs low as the exam season rush begins
A bookshop shelf runs low as the exam-season rush begins.Illustration · Data Stories Lab
Inventory & demand planning

Know when to reorder

Reorder stock in time to stop losing sales

Illustrative model on sample data.
385
titles analysed
RM 1.49m
lost to stockouts
149
reorder now
8.6x
avg stock turns
Most stock value sits in healthy titles
Stock value held, by performance group
Source: two years of sales; stock simulated. Illustrative.
A quarter of titles make the money
Share of revenue, by ABC tier
Source: two years of sales. Illustrative.
+52%
January vs avg month
44.9k
workbook units, peak Jan
~2/3
of avg in Jun–Jul lull
RM 860k
workbook stockout loss
Workbooks drive the seasonal swing
Monthly units sold, by category
Source: two years of sales. Representative monthly pattern.
10.4x
workbook turns / yr
149
at/below reorder point
10
top earners to reorder
RM 7.7k
cash to free (clear)
Workbooks turn fastest
Inventory turns per year, by category
Source: two years of sales; stock simulated. Illustrative.
Reorder list: top titles to order now
Highest sales currently at risk
TitleOn handReorder ptOrder qty
Pakej Soalan SPM Lengkap1460180
Modul SPM English840120
Modul Latihan English Tkt 51138110
Modul SPM Fizik934100
Modul SPM Kimia123090
Source: per-title reorder model. Illustrative.
81%
revenue from school-bulk
11%
walk-in
8%
online
RM 372k
annual revenue uplift
Two businesses on one shelf
Units sold, by channel and category
Source: two years of sales. Illustrative.
The prize is recurring six-figure profit
Annual uplift and one-off cash from better timing
Source: 50% lost-sales recovery scenario. Conservative.