RTV% = current period returns ÷ prior period sales
All time Jan 2025 – today
Sales qty
1410.5 ctns
$70,581.40
Sales value
$70,581.40
1410.5 ctns
RTV qty
245.5 ctns
$12,284.80
RTV value
$12,284.80
245.5 ctns
RTV rate
17.7%
Target <8%
Status
Above by 9.7%
RTV% = current period returns ÷ prior period sales
Active batches in trade
FC — Full Cream
Exp 27 Jun 26
RTV by 24 Jun 26
18d to RTV
RF — Reduced Fat
Exp 26 Jun 26
RTV by 23 Jun 26
17d to RTV
Stores not delivered in last 30 days 14 stores
Store
Gap
3-mth sales (ctns)
3-mth RTV (ctns)
RTV%
KOMO
1mth
4
3.4
85%
CLML
1mth 2d
6
1.6
26.7%
THPZ
1mth 7d
10
2.6
26%
HGA
1mth 15d
2
1.6
80%
DUNEARN
1mth 16d
4
3.3
82.5%
CQ
1mth 19d
1
0
0%
AMK712B
1mth 21d
3
1.9
63.3%
WTML
3mths 3d
0
0
—
PGDD
4mths
0
1.3
—
HSPH
4mths 2d
0
1.5
—
HCBP
4mths 16d
0
0.9
—
BMPZ
4mths 16d
0
0
—
FUNAN
4mths 21d
0
1.2
—
ARTRA
7mths 4d
0
1
—
Store net sales — rolling 3 months 08 Mar–06 Jun 26
Top 5 — best
Store
Net (ctns)
Sales (ctns)
RTV (ctns)
RTV%
HVIVO
17.9
18
0.1
0.6%
PGWW
16
22
6
27.3%
WDLG
15
24
9
37.5%
HPWP
11.7
12
0.3
2.5%
BTPZ
10
10
0
0%
Bottom 5 — worst
Store
Net (ctns)
Sales (ctns)
RTV (ctns)
RTV%
HGA
0.4
2
1.6
80%
MYVI
0.6
3
2.4
80%
KOMO
0.6
4
3.4
85%
DUNEARN
0.7
4
3.3
82.5%
SLML
0.9
3
2.1
70%
Store net sales — all time Jan 2025 – today
Top 5 — best
Store
Net (ctns)
Sales (ctns)
RTV (ctns)
RTV%
PGWW
103.2
126
22.8
18.1%
WDLG
84
93
9
9.7%
HAMK
51.7
55
3.3
6%
HVIVO
48.7
52
3.3
6.3%
BTPZ
47.9
58
10.1
17.4%
Bottom 5 — worst
Store
Net (ctns)
Sales (ctns)
RTV (ctns)
RTV%
PGDD
1.5
8
6.5
81.3%
FUNAN
1.8
3
1.2
40%
CQ
2.8
5
2.2
44%
BMPZ
2.9
4
1.1
27.5%
CIA3
3
5
2
40%
Top 10 stores by RTV — reason breakdown
Store
Total RTV (ctns)
Returned expired
Near expiry
Oversupply
PGWW
22.8
—
67.5%
32.5%
HJEM
15.9
0.5%
81.2%
18.3%
MP
12
79.9%
20.1%
—
CWPT
11.9
—
100%
—
BTPZ
10.1
—
9.9%
90.1%
WDLG
9
16.7%
38%
45.4%
DFARM
8.3
22%
70%
8%
SCOT
7
2.4%
20.2%
77.4%
RHV
6.8
—
38.3%
61.7%
HNEX
6.7
1.3%
41.3%
57.5%
All stores — ranked by sales
Select date range
#
Store
Sales (ctns)
RTV (ctns)
Net (ctns)
RTV%
Days ago
Last delivery (FC ctns / RF ctns)
Store
Rolling 3 months
RTV% = store RTV ÷ store sales, same period
All time
Weekly delivery & return pattern — rolling 13 weeks
Week-by-week detail
Week of
Delivered (ctns)
FC
RF
RTV (ctns)
RTV%
Monthly summary
Month
Sales (ctns)
RTV (ctns)
RTV%
Shelf Life Priority
Short shelf life exception
0
High sell-through, low RTV
Regular fulfilment
0
Default warehouse decision
Long shelf life only
0
Slow / high RTV risk
Recommendation
Store
Sales 3M
RTV 3M
RTV%
Days Since Delivery
Last Delivery
Reason
Operations Playbook
Yasashi FairPrice Operations Playbook
A practical guide for PO release, shelf life allocation, FEFO execution, and RTV reduction decisions.
1. Daily Order Processing Workflow
Step 1: Refer to the Shelf Life Priority tab. Step 2: Check the store recommendation. Step 3: Process PO based on the recommended shelf life handling.
2. Short Shelf Life Exception
These are fast-moving stores with healthy sell-through.
If the store appears in this list, Ops may allocate shorter shelf life batches with higher confidence due to stronger sell-through and lower RTV risk, subject to stock availability and normal operational checks.
3. Regular Fulfilment
Use standard warehouse fulfilment logic.
Normal MOV, order quantity checks, and FEFO stock rotation apply.
4. Long Shelf Life Only
These stores carry higher RTV or slower sell-through risk.
Prioritise fresher stock. Avoid short shelf life batches unless approved by KAM, BM, or management.
Shipment & Fulfilment SOP
Incoming Shipment SOP
For every new incoming shipment, Ops should email KAMs and Brand Management with:
Shipment arrival dateQuantity receivedExpiry dates by batch
Order Processing SOP
During order processing, Ops should provide available expiry dates and batch quantities where needed.
This helps KAM / BM make better order quantity and store allocation decisions.
Decision Engine Documentation
Management-Approved Logic
This section documents how the Shelf Life Priority tab classifies FairPrice stores for stock allocation decisions.
Objective
Reduce RTV, improve FEFO deployment, and allocate stock based on real store sell-through behaviour.
Rolling 3-Month Basis
The system uses rolling 13-week data to avoid overreacting to short-term spikes.
Metrics include sales quantity, RTV quantity, RTV rate, and days since last delivery.
Short Shelf Life Logic
Stores qualify when they show strong sales, low RTV, and frequent replenishment.
This indicates higher confidence that stock can sell through before expiry risk builds.
Long Shelf Life Logic
Stores are flagged when they show elevated RTV and longer replenishment gaps.
This indicates lower sell-through confidence and higher future near-expiry risk.