Retail Intelligence
Forecasting
Replenish
3
Projected shortageTransfer Review
3
High stock coverageMarkdown Review
1
Aging weak movementNo Demand
0
No recent movementDemand Projection
Seed Forecasting Simulation
This module estimates short-term demand using average weekly sales, current stock, stock coverage, aging, and sell-through. Later, this can be replaced with stronger forecasting logic using historical weekly summaries.
Forecasting Monitor
Projected demand, stock coverage, and recommended action
| Branch | Style / SKU | Brand / Category | Stock | Avg Weekly Sales | 4-Week Demand | Projected Ending | Coverage | Sell-Through | Forecast Action | Reason |
|---|---|---|---|---|---|---|---|---|---|---|
| Ayala CebuVISAYAS · Cebu | STY2201Casual short sleeve top 00022345 · WHITE · S | BAYOSHORT SLEEVES | 14 | 6.0 | 24.0 | 0.0 | 2.3 wks | 63.2% | Replenish | Projected demand is higher than current stock |
| SM North EDSANCR · Metro Manila North | STY3456Printed midi dress 00012345 · BLACK · S | BAYODRESS | 8 | 3.0 | 12.0 | 0.0 | 2.7 wks | 60.0% | Replenish | Projected demand is higher than current stock |
| SM North EDSANCR · Metro Manila North | STY3456Printed midi dress 00012346 · BLACK · M | BAYODRESS | 6 | 2.5 | 10.0 | 0.0 | 2.4 wks | 62.5% | Replenish | Projected demand is higher than current stock |
| Robinsons PampangaLUZON · Central Luzon | STY9022Knitted basic tee 00042345 · BEIGE · FREE | UNICA_DSKNITTED/T-SHIRT | 70 | 0.8 | 3.0 | 67.0 | 93.3 wks | 4.1% | Transfer Review | Stock is high compared to sales movement |
| SM DavaoMINDANAO · Davao | STY7810Straight cut trousers 00032345 · NAVY · M | UNICA_BTQPANTS | 45 | 1.3 | 5.0 | 40.0 | 36.0 wks | 10.0% | Transfer Review | Stock is high compared to sales movement |
| Iloilo Business ParkVISAYAS · Iloilo | STY5588Lightweight jacket 00052345 · OLIVE · M | BAYOJACKET | 35 | 0.3 | 1.0 | 34.0 | 140.0 wks | 2.8% | Transfer Review | Stock is high compared to sales movement |
| GloriettaNCR · Metro Manila South | STY3456Printed midi dress 00012345 · BLACK · S | BAYODRESS | 40 | 0.0 | 0.0 | 40.0 | No sales | 0.0% | Markdown Review | Aging inventory with weak sell-through |
| GloriettaNCR · Metro Manila South | STY3456Printed midi dress 00012347 · RED · S | BAYODRESS | 9 | 2.3 | 9.0 | 0.0 | 4.0 wks | 50.0% | Hold | Stock and demand are currently balanced |