Rule-based assistant — keyword-intent matching over your live data (~10 intents). Actions that change anything always require your approval first.
Forecast (statistical): 12-week sales history, projected 4 weeks ahead with a 4-week moving average + trend continuation. Seeded on real weekly velocity.
Safety stock = lead-time demand (142.9 stem over 5-day lead from 🇹🇭 Bangkok Flora Exports) + 25% buffer = 36 stem. Reorder when available falls to 179. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (19.3 pcs over 9-day lead from 🇱🇰 Colombo Trade House) + 25% buffer = 5 pcs. Reorder when available falls to 25. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (38.6 pcs over 9-day lead from 🇱🇰 Colombo Trade House) + 25% buffer = 10 pcs. Reorder when available falls to 49. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (10.3 roll over 9-day lead from 🇱🇰 Colombo Trade House) + 25% buffer = 3 roll. Reorder when available falls to 14. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (30.9 pcs over 24-day lead from 🇨🇳 Guangzhou Homeware Co) + 25% buffer = 8 pcs. Reorder when available falls to 39. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (20.6 pcs over 24-day lead from 🇨🇳 Guangzhou Homeware Co) + 25% buffer = 6 pcs. Reorder when available falls to 27. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (77.1 ream over 12-day lead from 🇮🇳 Mumbai Stationers) + 25% buffer = 20 ream. Reorder when available falls to 98. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (20.6 box over 12-day lead from 🇮🇳 Mumbai Stationers) + 25% buffer = 6 box. Reorder when available falls to 27. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (6.3 carton over 2-day lead from 🇲🇻 Felivaru Fisheries) + 25% buffer = 2 carton. Reorder when available falls to 9. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (45.7 case over 2-day lead from 🇲🇻 Felivaru Fisheries) + 25% buffer = 12 case. Reorder when available falls to 58. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (48 bottle over 24-day lead from 🇨🇳 Guangzhou Homeware Co) + 25% buffer = 12 bottle. Reorder when available falls to 60. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (9 pcs over 9-day lead from 🇱🇰 Colombo Trade House) + 25% buffer = 3 pcs. Reorder when available falls to 12. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (10.7 pcs over 15-day lead from 🇦🇪 Dubai Fragrance FZE) + 25% buffer = 3 pcs. Reorder when available falls to 14. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (10.3 pcs over 24-day lead from 🇨🇳 Guangzhou Homeware Co) + 25% buffer = 3 pcs. Reorder when available falls to 14. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (12.9 pcs over 9-day lead from 🇱🇰 Colombo Trade House) + 25% buffer = 4 pcs. Reorder when available falls to 17. Amber band = statistical projection, not a promise.
Safety stock = lead-time demand (30.9 pack over 12-day lead from 🇮🇳 Mumbai Stationers) + 25% buffer = 8 pack. Reorder when available falls to 39. Amber band = statistical projection, not a promise.
| Product | Weekly sales | Cover (days) |
|---|---|---|
| 🌹 Red Roses (stem) | 200 | 2 |
| 💧 Mineral Water 500ml (case) | 160 | 14.4 |
| 📄 A4 Paper 80gsm (ream) | 45 | 27.5 |
| 🎁 Gift Box Large | 30 | 5.8 |
| 🐟 Canned Tuna 185g (ctn) | 22 | 25.8 |
| Product | Weekly sales | Weeks of cover |
|---|---|---|
| 🛠️ Cordless Drill 18V | 3 | 4.7 |
| 🧿 Oud Perfume 50ml | 5 | 4.6 |
| 🌀 Stand Fan 16" | 6 | 4.5 |
| 🧱 Building Blocks 120pc | 7 | 5 |
| 🎀 Satin Ribbon Roll 25m | 8 | 0.8 |
Rule: 4.5+ weeks of cover and 20+ units held.
| Product | On hand | Weekly | Cover | Value held |
|---|---|---|---|---|
| 🧱 Building Blocks 120pc | 35 | 7 | 5 wk | MVR 7,280.00 |
| 🫖 Electric Kettle 1.7L | 44 | 9 | 4.9 wk | MVR 11,484.00 |
| 🪴 Ceramic Plant Pot | 48 | 10 | 4.8 wk | MVR 3,120.00 |
| 🧿 Oud Perfume 50ml | 23 | 5 | 4.6 wk | MVR 9,600.20 |
| 🌀 Stand Fan 16" | 27 | 6 | 4.5 wk | MVR 12,881.70 |
| 🖊️ Ballpoint Pen (box 50) | 54 | 12 | 4.5 wk | MVR 6,091.20 |
Ceramic Plant Pot already has a clearance recommendation on the Pricing tab — 3 sales in 30 days with 48 units held.
Units above a 3-week cover target, valued at landed cost.
| Product | On hand | Excess units | Excess value |
|---|---|---|---|
| 🐟 Canned Tuna 185g (ctn) | 81 | 15 | MVR 4,860.00 |
| 🫖 Electric Kettle 1.7L | 44 | 17 | MVR 4,437.00 |
| 🛠️ Cordless Drill 18V | 14 | 5 | MVR 4,369.00 |
| 🌀 Stand Fan 16" | 27 | 9 | MVR 4,293.90 |
| 🧿 Oud Perfume 50ml | 23 | 8 | MVR 3,339.20 |
| 📄 A4 Paper 80gsm (ream) | 177 | 42 | MVR 3,171.00 |
Days of cover = available ÷ (weekly sales ÷ 7), sorted most urgent first.
| Product | Available | Daily sales | Days of cover | Lead time | Status |
|---|---|---|---|---|---|
| 🔋 AA Batteries (24pk) | 0 | 2.6 | 0 | 🇮🇳 12d — Mumbai Stationers | critical |
| 🌹 Red Roses (stem) | 56 | 28.6 | 2 | 🇹🇭 5d — Bangkok Flora Exports | critical |
| 🧴 Detergent 5L | 6 | 2.0 | 3 | 🇨🇳 24d — Guangzhou Homeware Co | critical |
| 🏺 Glass Vase Medium | 10 | 2.1 | 4.7 | 🇱🇰 9d — Colombo Trade House | critical |
| 🎀 Satin Ribbon Roll 25m | 6 | 1.1 | 5.3 | 🇱🇰 9d — Colombo Trade House | critical |
| 🎁 Gift Box Large | 25 | 4.3 | 5.8 | 🇱🇰 9d — Colombo Trade House | critical |
| 💧 Mineral Water 500ml (case) | 330 | 22.9 | 14.4 | 🇲🇻 2d — Felivaru Fisheries | watch |
Red Roses have ~2 days of cover against a 5-day Bangkok lead; AA Batteries are already out with an open backorder (SO-2026-0127) — both genuinely critical.
Formula: safety stock = lead-time demand (daily sales × supplier lead days) + 25% buffer. Reorder point = lead-time demand + safety stock.
| Product | Lead demand | Safety stock | Reorder point | Available | Position |
|---|---|---|---|---|---|
| 🔋 AA Batteries (24pk) | 30.9 | 8 | 39 | 0 | below ROP |
| 🌹 Red Roses (stem) | 142.9 | 36 | 179 | 56 | below ROP |
| 🧴 Detergent 5L | 48 | 12 | 60 | 6 | below ROP |
| 🏺 Glass Vase Medium | 19.3 | 5 | 25 | 10 | below ROP |
| 🎀 Satin Ribbon Roll 25m | 10.3 | 3 | 14 | 6 | below ROP |
| 🎁 Gift Box Large | 38.6 | 10 | 49 | 25 | below ROP |
| 💧 Mineral Water 500ml (case) | 45.7 | 12 | 58 | 330 | covered |
| Supplier | Lead (days) | On-time % |
|---|---|---|
| 🇲🇻 Felivaru Fisheries | 2 | 99% |
| 🇹🇭 Bangkok Flora Exports | 5 | 97% |
| 🇱🇰 Colombo Trade House | 9 | 93% |
| 🇮🇳 Mumbai Stationers | 12 | 81% |
| 🇦🇪 Dubai Fragrance FZE | 15 | 89% |
| 🇨🇳 Guangzhou Homeware Co | 24 | 86% |
Forecast (statistical): current value MVR 134,028.00, drawn down by weekly cost of sales (MVR 45,903.00/wk). Green assumes the purchase plan lands; red assumes no reordering.
With the purchase plan
Without reordering
Rule-based recommendation built from the smart-reorder engine, with order quantities rounded to each supplier’s order pack.
| Product | Urgency | Available | Weekly | Lead | Suggested | Order qty | Pack | Unit cost | Line value | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| 🌹 Red Roses (stem) | critical | 56 | 200 | 5d | 320 | 350 | bundle of 50 | MVR 8.00 | MVR 2,800.00 | 🇹🇭 Bangkok Flora Exports |
| 🔋 AA Batteries (24pk) | critical | 0 | 18 | 12d | 100 | — | carton of 24 | MVR 88.00 | incoming 100 — chase | 🇮🇳 Mumbai Stationers |
| 🧴 Detergent 5L | high | 6 | 14 | 24d | 60 | 75 | case of 25 | MVR 96.00 | MVR 7,200.00 | 🇨🇳 Guangzhou Homeware Co |
| 🏺 Glass Vase Medium | high | 10 | 15 | 9d | 40 | 42 | crate of 6 | MVR 85.00 | MVR 3,570.00 | 🇱🇰 Colombo Trade House |
| 🎀 Satin Ribbon Roll 25m | normal | 6 | 8 | 9d | 20 | 24 | box of 8 | MVR 30.00 | MVR 720.00 | 🇱🇰 Colombo Trade House |
| Total to order — 3 suppliers (Bangkok Flora Exports, Guangzhou Homeware Co, Colombo Trade House) | MVR 14,290.00 | |||||||||
🌹 Red Roses (stem): Available covers ~2 days at current velocity; lead time is 5 days. Order must land before Friday’s event demand.
🔋 AA Batteries (24pk): Stocked out with an open backorder (SO-2026-0127). Incoming 100 confirmed — chase the shipment, don’t double-order.
🧴 Detergent 5L: Below minimum (18) with a 24-day lead from Guangzhou. Half-week of cover left.
🏺 Glass Vase Medium: Under one week of cover; pairs with rose demand (bought together in 62% of orders).
🎀 Satin Ribbon Roll 25m: Below minimum; moderate velocity. Add to the next CTH Lanka consolidated order.
MVR 520.00 MVR 545.00
Margin 26.8% is below the 33% category floor and demand is steady (22/wk). A 4.8% rise keeps you under Addu Mart’s shelf price.
Landed cost: MVR 324.00 · margin at suggested: 40.6% (margin on price)
MVR 420.00 MVR 379.00
Velocity halved in 4 weeks; 35 units on hand ≈ 10 weeks of cover. A 10% cut historically lifts toy volume ~30%.
Landed cost: MVR 208.00 · margin at suggested: 45.1% (margin on price)
MVR 135.00 MVR 99.00
Dead stock: 3 sales in 30 days, 48 units held. At MVR 99 you still clear landed cost (MVR 65) + 34%.
Landed cost: MVR 65.00 · margin at suggested: 34.3% (margin on price)
Drag the price — projected weekly profit uses real velocity and landed cost, with a stated elasticity assumption of −1.2 (a 10% price rise trims volume ~12%).
The landed unit cost is the break-even floor; the policy floor (min selling price) sits above it.
| Product | Landed (break-even) | Policy floor | Retail | Retail margin |
|---|---|---|---|---|
| 🛠️ Cordless Drill 18V | MVR 873.80 | MVR 1,120.00 | MVR 1,690.00 | 48.3% |
| 🌀 Stand Fan 16" | MVR 477.10 | MVR 620.00 | MVR 895.00 | 46.7% |
| 🧿 Oud Perfume 50ml | MVR 417.40 | MVR 560.00 | MVR 890.00 | 53.1% |
| 🐟 Canned Tuna 185g (ctn) | MVR 324.00 | MVR 380.00 | MVR 520.00 | 37.7% |
| 🫖 Electric Kettle 1.7L | MVR 261.00 | MVR 340.00 | MVR 495.00 | 47.3% |
| 🧱 Building Blocks 120pc | MVR 208.00 | MVR 275.00 | MVR 420.00 | 50.5% |
| 🧴 Detergent 5L | MVR 119.60 | MVR 160.00 | MVR 235.00 | 49.1% |
| 🖊️ Ballpoint Pen (box 50) | MVR 112.80 | MVR 135.00 | MVR 210.00 | 46.3% |
| 🏺 Glass Vase Medium | MVR 107.00 | MVR 125.00 | MVR 180.00 | 40.6% |
| 🔋 AA Batteries (24pk) | MVR 103.40 | MVR 130.00 | MVR 195.00 | 47% |
| 💧 Mineral Water 500ml (case) | MVR 84.70 | MVR 98.00 | MVR 140.00 | 39.5% |
| 📄 A4 Paper 80gsm (ream) | MVR 75.50 | MVR 85.00 | MVR 125.00 | 39.6% |
| 🪴 Ceramic Plant Pot | MVR 65.00 | MVR 88.00 | MVR 135.00 | 51.9% |
| 🎀 Satin Ribbon Roll 25m | MVR 35.80 | MVR 44.00 | MVR 68.00 | 47.4% |
| 🎁 Gift Box Large | MVR 27.30 | MVR 35.00 | MVR 55.00 | 50.4% |
| 🌹 Red Roses (stem) | MVR 11.00 | MVR 12.00 | MVR 18.00 | 38.9% |
Price tiers selling below the 30% margin floor (margin on price, against landed cost).
| Product | Tier | Price | Margin | |
|---|---|---|---|---|
| 🌹 Red Roses (stem) | staff | MVR 12.00 | 8.3% | intentional |
| 🌹 Red Roses (stem) | distributor | MVR 12.50 | 12% | review |
| 🌹 Red Roses (stem) | dealer | MVR 13.00 | 15.4% | review |
| 🏺 Glass Vase Medium | staff | MVR 130.00 | 17.7% | intentional |
| 📄 A4 Paper 80gsm (ream) | staff | MVR 92.00 | 17.9% | intentional |
| 💧 Mineral Water 500ml (case) | staff | MVR 104.00 | 18.6% | intentional |
| 🏺 Glass Vase Medium | distributor | MVR 132.00 | 18.9% | review |
| 🐟 Canned Tuna 185g (ctn) | staff | MVR 400.00 | 19% | intentional |
| 📄 A4 Paper 80gsm (ream) | distributor | MVR 94.00 | 19.7% | review |
| 🐟 Canned Tuna 185g (ctn) | distributor | MVR 405.00 | 20% | review |
Configurable, rule-based — each rule states exactly what it does. Toggles persist on this device.
If the 4-week velocity trend moves ±20%, adjust price by up to ∓5% — always inside the min/max band, changes queued for approval.
Eid & wedding season: Red Roses +15% for Jul 20 – Aug 2; Stand Fans −8% off-season (Nov–Jan).
45 days without a sale and 20+ units held → −25%, floored at landed cost +10%. Currently matches 6 SKUs.
“Dozen roses + vase + gift box” at MVR 399.00 (vs MVR 451.00 separately). Bundle cost MVR 266.30 → 33.3% margin — above the 33% floor.