Yasashi Daily Dashboard — FairPrice

As of 06 Jun 2026, 02:00
Refreshes hourly
Overview
Store Rankings
Store Detail
Shelf Life Priority
Operations Playbook
Rolling 3 months 08 Mar–06 Jun 26
Sales qty
299.5 ctns
$14,987.00
Sales value
$14,987.00
299.5 ctns
RTV qty
78.3 ctns
$3,915.60
RTV value
$3,915.60
78.3 ctns
RTV rate
22.1%
Target <8%
Status
Above by 14.1%
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
FC
Exp 27 Jun 26
RTV by 24 Jun 26
18d to RTV
RF — Reduced Fat
RF
Exp 26 Jun 26
RTV by 23 Jun 26
17d to RTV
Stores not delivered in last 30 days 14 stores
StoreGap3-mth sales (ctns)3-mth RTV (ctns)RTV%
KOMO 1mth 43.4 85%
CLML 1mth 2d 61.6 26.7%
THPZ 1mth 7d 102.6 26%
HGA 1mth 15d 21.6 80%
DUNEARN 1mth 16d 43.3 82.5%
CQ 1mth 19d 10 0%
AMK712B 1mth 21d 31.9 63.3%
WTML 3mths 3d 00
PGDD 4mths 01.3
HSPH 4mths 2d 01.5
HCBP 4mths 16d 00.9
BMPZ 4mths 16d 00
FUNAN 4mths 21d 01.2
ARTRA 7mths 4d 01
Store net sales — rolling 3 months 08 Mar–06 Jun 26
Top 5 — best
StoreNet (ctns)Sales (ctns)RTV (ctns)RTV%
HVIVO 17.9 180.1 0.6%
PGWW 16 226 27.3%
WDLG 15 249 37.5%
HPWP 11.7 120.3 2.5%
BTPZ 10 100 0%
Bottom 5 — worst
StoreNet (ctns)Sales (ctns)RTV (ctns)RTV%
HGA 0.4 21.6 80%
MYVI 0.6 32.4 80%
KOMO 0.6 43.4 85%
DUNEARN 0.7 43.3 82.5%
SLML 0.9 32.1 70%
Store net sales — all time Jan 2025 – today
Top 5 — best
StoreNet (ctns)Sales (ctns)RTV (ctns)RTV%
PGWW 103.2 12622.8 18.1%
WDLG 84 939 9.7%
HAMK 51.7 553.3 6%
HVIVO 48.7 523.3 6.3%
BTPZ 47.9 5810.1 17.4%
Bottom 5 — worst
StoreNet (ctns)Sales (ctns)RTV (ctns)RTV%
PGDD 1.5 86.5 81.3%
FUNAN 1.8 31.2 40%
CQ 2.8 52.2 44%
BMPZ 2.9 41.1 27.5%
CIA3 3 52 40%
Top 10 stores by RTV — reason breakdown
StoreTotal RTV (ctns)Returned expiredNear expiryOversupply
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 ofDelivered (ctns)FCRFRTV (ctns)RTV%
Monthly summary
MonthSales (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 date Quantity received Expiry 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.