Manager orders on day 14 when the shelf looks thin. Delivery lands on day 35. Jasmine drinks are off the menu for 2 weeks.
Alert fires at 28 days of cover (21 lead + 7 buffer). The order goes out a week before anyone would notice.
Manager records cartons received against the order. Stock goes up.
Manager uploads the day's POS sales report. Takes about 5 minutes.
Each drink sold uses its share of a carton, from HQ's recipes.
When cover drops to lead time + buffer, a draft order appears.
| Role | New work | How often |
|---|---|---|
| Counter staff | Nothing | None |
| Outlet manager | Upload sales report, record deliveries, count sealed cartons | Daily · per delivery · monthly |
| Franchise owner | Approve draft orders | Weekly |
| HQ | Keep recipes and suppliers current | When the menu changes |
| Action | HQ admin | HQ warehouse | Franchise owner | Outlet manager |
|---|---|---|---|---|
| See outlets | All 12 | Warehouse | Own outlets | One outlet |
| Edit menu and recipes | ✓ | – | – | – |
| Approve suppliers | ✓ | – | – | – |
| Upload daily sales | ✓ | – | ✓ | ✓ |
| Record deliveries | ✓ | ✓ | ✓ | ✓ |
| Monthly stock count | – | ✓ | ✓ | ✓ |
| Draft purchase orders | ✓ | ✓ | ✓ | ✓ |
| Approve purchase orders | ✓ | ✓ | ✓ | – |
| Approve stock adjustments over S$30 | ✓ | – | ✓ | – |
| Approve invoices for payment | ✓ | ✓ | ✓ | – |
| Transfer stock | Any outlet | To outlets | Between own outlets | Request only |
| Trends and benchmarks | Network | Warehouse | Own vs network median | Own outlet |
| Outlet | Franchisee | Cups/day | Lowest cover | Upload |
|---|---|---|---|---|
| Tampines Mall | Eastside F&B | 382 | Jasmine green 20.5 d | 14 Nov |
| Bugis Junction | HQ-operated | 512 | Cheese foam 11 d | 14 Nov |
| Woodlands | Northline Beverages | 341 | Brown sugar syrup 17 d | 14 Nov |
| Jurong Point | Westgate Brews | 455 | Black sugar pearls 26 d | Missing 13 Nov |
| Orchard Gateway | HQ-operated | 468 | All above 30 d | 14 Nov |
| + 7 more outlets · sorted by risk | ||||
| Ingredient | Carton | Regular drinks per carton | Cost per cup |
|---|---|---|---|
| Black sugar tapioca pearls | 6 × 3 kg | 510 | S$0.19 |
| Brown sugar syrup | 4 × 2.5 kg | 330 | S$0.16 |
| Fresh milk | 12 × 1 L | 60 | S$0.46 |
| Cup 500 ml (Regular) | 1,000 cups | 1,000 | S$0.07 |
| Sealing film | Roll of 3,000 | 3,000 | S$0.03 |
| Regular, 100% sugar | S$0.91 | ||
| POS item name | Qty | Matched to | |
|---|---|---|---|
| BSPM 50%sugar Lg | 23 | Brown Sugar Pearl Milk · Large · 50% sugar | Confirm |
| XMAS Osmanthus Oolong L | 17 | No recipe yet | Ask HQ |
| Brown Sugar Pearl Milk R | 64 | Brown Sugar Pearl Milk · Regular | Matched |
| Jasmine Green Milk Tea L | 41 | Jasmine Green Milk Tea · Large | Matched |
| Ingredient | On hand | Uses/day | Days of cover | Lead | Status |
|---|
Quantities in cartons. Reorder when days of cover ≤ lead time + buffer days.
| Item | Suggested | Price | Amount |
|---|---|---|---|
| Black sugar tapioca pearls | 8 | S$96.00 | S$768.00 |
| Jasmine green tea | 5 | S$148.00 | S$740.00 |
| Cheese foam powder | 4 | S$132.00 | S$528.00 |
| Total | S$2,036.00 | ||
| Item | Ordered | Received | Best before | |
|---|---|---|---|---|
| Black sugar tapioca pearls | 8 | 8 | 12 May 2027 | OK |
| Jasmine green tea | 5 | 4 | 30 Sep 2027 | 1 short |
| Cheese foam powder | 4 | 4 | 18 Feb 2027 | OK |
| Item | Sent | Sent by | Received |
|---|---|---|---|
| Cheese foam powder | 2 | HQ admin · 15 Nov 10:20 | Waiting for Tampines |
| Ingredient | Expected | Counted | Difference | Value | Reason |
|---|---|---|---|---|---|
| Black sugar tapioca pearls | 17.4 | 16.6 | −0.8 (−4.6%) | −S$76.80 | Over-portioning |
| Brown sugar syrup | 8.3 | 7.4 | −0.9 (−10.8%) | −S$48.60 | Not explained yet |
| Fresh milk | 10.2 | 9.0 | −1.2 (−11.8%) | −S$33.12 | Expired, not logged |
| Assam black tea | 10.1 | 10.0 | −0.1 (−1.0%) | −S$9.80 | Within tolerance |
| Jasmine green tea | 5.6 | 5.5 | −0.1 (−1.8%) | −S$14.80 | Within tolerance |
| Cups 500 ml | 4.2 | 4.3 | +0.1 (+2.4%) | +S$6.80 | Within tolerance |
| Net variance, October | −S$176.32 | ||||
| Item | Ordered | Received | Billed | PO price | Billed price | Result |
|---|---|---|---|---|---|---|
| Black sugar tapioca pearls | 8 | 8 | 8 | S$96.00 | S$98.00 | Price +S$16.00 |
| Jasmine green tea | 5 | 4 | 5 | S$148.00 | S$148.00 | Billed 1 not received |
| Cheese foam powder | 4 | 4 | 4 | S$132.00 | S$132.00 | Match |
| Freight | – | – | 1 | S$85.00 | S$85.00 | Per agreement |
| Check | What doesn't match | Where | Value | Age | With |
|---|---|---|---|---|---|
| Count | Brown sugar syrup −0.9 cartons, no reason yet | Tampines | S$48.60 | 15 d | Outlet manager |
| Warehouse | Tuas sent 40 cartons of pearls in Oct, outlets received 39 | Network | S$96.00 | 6 d | HQ warehouse |
| Invoice | Pearls billed at S$98.00, PO says S$96.00 | Tampines | S$16.00 | 3 d | Franchise owner |
| Sales upload | 13 Nov report not uploaded | Jurong Point | – | 2 d | Outlet manager |
| Sales upload | Item lines total S$2,396.20, report total S$2,412.20 | Woodlands | S$16.00 | 1 d | HQ |
| Delivery | 1 carton jasmine green tea short, credit note requested | Tampines | S$148.00 | 0 d | Formosa |
| Transfer | 2 cartons cheese foam sent, not yet received | Bugis → Tampines | S$264.00 | 0 d | Tampines manager |
| Ingredient | Trend | Next 6 wks | Order by |
|---|---|---|---|
| Black sugar pearls | ▲ +11% in 12 wks | 203 cartons | 18 Nov |
| Cheese foam powder | ▲ +34% in 12 wks | 61 cartons | 17 Nov |
| Jasmine green tea | ▲ +3% | 94 cartons | 26 Nov |
| Assam black tea | ▼ −4% | 88 cartons | 9 Dec |
| Singapore calendar | When | Effect on cups |
|---|---|---|
| Year-end school holidays | 22 Nov to 31 Dec | +17% |
| June school holidays and Great Singapore Sale | Late May to June | +14% |
| Chinese New Year eve and day 1 | Feb | −35% |
| Week after Chinese New Year | Feb | +12% |
| Hari Raya and Deepavali weekends | Varies | +4% |
| Outlet | Aug | Sep | Oct | Count variance trend |
|---|---|---|---|---|
| Bugis Junction | −3.1% | −5.8% | −9.2% | Worsening 3 months |
| Woodlands | −6.4% | −7.0% | −6.1% | Steady, high |
| Tampines Mall | −2.2% | −3.0% | −4.6% | Watch |
| Orchard Gateway | −1.1% | −0.8% | −1.2% | Best in network |
| Supplier | Promised | Actual (90 d) | On time | Short or damaged | Use for reorder |
|---|---|---|---|---|---|
| Formosa Tea & Tapioca | 21 d | 25 d | 38% | 4.1% | 25 days |
| Golden Leaf Trading | 18 d | 18.5 d | 86% | 0.8% | 18 days |
| FreshDairy SG | 2 d | 2.1 d | 94% | 0.3% | 2 days |
| PackRight SG | 5 d | 6.2 d | 71% | 1.2% | 7 days |
| Expiring in 30 days | Outlet | Cartons | Best before | Suggestion |
|---|---|---|---|---|
| Mango purée | Clementi | 3 | 2 Dec 2026 | Transfer 2 to VivoCity |
| Grass jelly | Punggol Waterway | 2 | 24 Nov 2026 | Use first |
PO-HQ-0198 was due 10 Nov. Tampines, Bedok and Punggol fall below cover on jasmine green tea by 21 Nov. Suggested: transfer 4 cartons from the Tuas warehouse.
Cups sold are flat, but pearls used per 1,000 cups jumped from 1.45 to 1.71.
Stock for this outlet is 2 days out of date. Reorder alerts may be late.
Forecast raised. Network order-by date moved 9 days earlier, to 17 Nov.
17 cups on day one at Tampines with no recipe. Osmanthus oolong leaves are not yet tracked.
| # | Question | Why it matters |
|---|---|---|
| 1 | Which POS do outlets use? Can we get a sample sales export? | Sets the upload format, item matching and how toppings are read |
| 2 | Do outlets order imports through a Tuas warehouse, or direct from suppliers? | A warehouse adds a second stock level and shortens outlet lead times |
| 3 | Who approves orders, invoices and stock adjustments, and above what limit? We suggest S$30 for counts and 1% for invoice prices. | Sets the approval flow and who can write off stock |
| 4 | Count monthly or every two weeks? | More counts mean faster correction and earlier waste signals |
| 5 | Can franchisees add local drinks or set their own prices? | Affects recipe ownership and cost-per-cup reporting |
| 6 | Should royalty reporting be in scope? | Sales are already uploaded, so it is a small addition |
| 7 | Use weather data in forecasts now or later? | Adds about 9% accuracy on hot days |
| 8 | Host in Singapore for PDPA? | Hosting region and data handling |
Timeline is an estimate for a team of two. We confirm it after discovery and the sample sales export.
By signing below, both parties agree that the workflows, roles and screens in this walkthrough describe the scope of StockRite v1, subject to the open decisions on slide 23.