Retail Supply Chain · Digital Product Solution

Sales Forecast & Buying Management System

Buying System — the AI digital hub helping retailers "forecast right, buy right, sell well"

Forecast rightAI baseline supports human judgment Buy rightDRP engine outputs purchase suggestions Sell wellHealthy inventory, fewer stockouts and expiry losses

Know first: why is sales forecasting so hard?

KNOWLEDGE

Before the product, understand this — forecasting is one of the most expensive problems in retail.

Too much to compute

5 channels × 300 SKUs × 12 months ≈ 18,000 numbers — manual Excel planning hits combinatorial explosion.

Polluted baseline

Promo spikes and stockout dips mix into history; forecasting from distorted history leads you astray.

Targets never land

Annual finance targets are hard to split scientifically to "SKU × month"; budget and execution diverge.

Inventory loses both ways

Too little means stockouts and lost sales; too much ties up cash; expiry write-offs are pure loss.

In plain words: forecasting is not mysticism — it is a math problem that data and systems can solve.

Three generations of forecasting

EVOLUTION
1Experience-drivenVeteran buyer + Excel: gut-feel numbers, knowledge lost with turnover, fails on promos/new items
2Rule-drivenStatistical formulas + BI: handles the routine, not exceptions — patched by people
3AI + system-driven · this solutionAuto noise cleaning, seasonality modeling; AI computes the baseline, people decide

What can AI actually do for forecasting?

AI ENGINE

Data cleaning

"Denoising" historical data

Auto-detects promo spikes and stockout dips, models after removal, and builds a true demand baseline.

Rhythm modeling

Finding the product's "biological clock"

Multiplicative seasonal index models distill a smooth baseline from ~425 days, capturing Double-11 peaks and seasonality.

Old-new linkage

Quantifying the new item's "cannibalization effect"

Parent codes link old and new items in a series; cannibalization volume is quantified automatically.

Human-AI collaboration

AI drafts, people judge

AI outputs the baseline; the business manually adjusts promo/new-item multipliers, with every intervention logged and auditable.

The product in one sentence

PRODUCT

The "digital buyer hub" for retailers: finance targets, sales forecasts, inventory ledgers and purchasing plans in one closed-loop system.

INInput layer · know your baseMaster data: channel/category/SKU mapping | Finance targets: annual Top-down budget
CALCEngine layer · system computesTrend model baseline | Smart Split breakdown | Inventory ledger + expiry drop | DRP replenishment
OUTOutput layer · ready to useRolling 15~18M sales plan | Net purchase suggestions for HQ | Alerts and decision dashboard
In plain words: money (budget) in, goods (purchase suggestions) out — every step in between is data-backed, justified and recorded.

Smart baseline

Data cleaning + seasonal index fix distorted baselines

One-click budget split

Quickly allocate the total target to SKU × month

Rolling simulation

Rolling 15~18M; change one number, everything recalculates

Inventory heatmap

Red stockout / green healthy / blue surplus at a glance

DRP buying engine

APICS-compliant; net demand is transparent and auditable

Decision dashboard

Budget attainment and anomaly alerts on one screen

Three key retail scenarios

SCENARIOS
Landing plan ›

Scenario 1 · Annual buying planning meeting

From "2 weeks of Excel grind" to "decided in 1 day"

  • Before: 3 buyers spent 2+ weeks manually planning ~18,000 cells; any target change meant starting over
  • Now: enter the total target → one-click smart split → fine-tune key items, decided on the meeting day
  • Smart Split: breaks down to "SKU × month" by channel/category/historical structure weights, aligning Top-down and Bottom-up in one sheet
  • Decide in-meeting: project the simulation sheet, parameters recalculate live — discuss with data, not volume
  • Version snapshots: Draft→Active auto-archived, clear which data is official, with rollback and comparison
Enter targetannual budget
Smart splitSKU × month
Fine-tunehuman judgment
Snapshot finalversion retained
Value: compresses annual planning from weeks to days (depending on data maturity), aligning budget with execution.
Landing plan ›

Scenario 2 · New launches & big promos

Two moments when buying goes wrong

  • Parent Code: auto-quantifies new-item cannibalization, avoiding duplicate stock of old and new
  • New items have no history: anchor to a similar item's baseline for the first order, converging as sales accumulate
  • Manual promo multipliers: every change, who made it and why is logged; intervention experience accumulates
  • This year's Double-11 peak is auto-flagged and removed, keeping next year's baseline clean
  • Automatic post-promo review: forecast vs. actual variance, multiplier experience kept for next time
New item mappingParent Code
Baseline estimatesimilar-item anchor
Multiplier overridefully logged
Remove & reviewexperience retained
Value: fewer gut-feel stock decisions for new items and promos; every judgment is explainable and reviewable.
Landing plan ›

Scenario 3 · Daily inventory & replenishment

"Should we buy this item again?"

  • Heatmap: red = under 1 month coverage (stockout risk), blue = surplus tying up cash, green = healthy
  • Expiry view: separates normal consumption from expiry write-offs; Expiry Drop conservatively estimates losses for high-risk batches, surfacing risk early
  • DRP: net-demand formulas auto-compute replenishment suggestions and output net purchase recommendations for HQ
  • Safety stock setup: auto-suggests replenishment when below the safety floor; order after human confirmation
  • Weekly meeting dashboard: stockouts/surplus/write-offs on one screen; replenish or not is decided by data
Heatmap diagnosisred/blue/green zones
Expiry viewwrite-off alerts
DRP computationnet demand
Replenishmenthuman confirmation
Value: reduces stockouts and surplus simultaneously, turning inventory from a "black box" into a dashboard.
Accurate baselinenoise cleaned
Fast splitone-click allocation
Buy rightDRP suggestions
Clear decisionsdashboard visibility

Business logic explained: one chain, seven stages

BUSINESS LOGIC

Each system step maps to a real action in existing business processes.

Phase 1 · Data foundationPhase 2 · Plan simulationPhase 3 · Execution closed loop
1Master data governanceChannel/category/SKU registration and validation, carrying Parent Code
2Smart baselineCleaning + seasonality modeling generates a 425-day smooth baseline
3Budget splitTop-down split to SKU × month, version snapshots retained
4Rolling simulationRolling 15~18M; change one number, everything recalculates in real time
5Multi-channel aggregationDemand aggregation + new-item/promo/expiry anomaly detection
6DRP net demandAPICS-standard replenishment computed automatically, outputting net purchase suggestions
7Execution & feedbackPurchasing executed, actuals flow back, variance feeds the next simulation round

← Swipe to see the full chain →

What people do

Maintain master data, confirm new-item mapping
Review seasonal coefficients, lock the baseline
Enter targets, fine-tune key items
Intervene on promos/new items with reasons
Confirm purchase suggestions, place orders with HQ

What the system does

Validate mappings, carry Parent Code
Auto-clean, generate the 425-day baseline
One-click weighted split, snapshots retained
Recalculate all results in real time
APICS computation of net demand and suggested replenishment
In plain words: the ledger only records physical changes; available stock is computed centrally by the engine — clear responsibilities, key numbers traceable.

Technology · Baseline engine pipeline

TECHNOLOGY
Raw historyImport ~425 days of daily sales data
Stockout detectionZero/low sales during stockouts restored as latent demand
Promo removalAbnormal promo peaks flagged and stripped out
True baselineSmooth baseline stored, referenced across the chain
Forecast = true baseline × seasonal index × human multiplier
Light graylast-year same period and system baseline, objective reference
Tealseasonal index applied automatically
Yellowmanual multiplier overrides, logged
Light greenlive simulation feedback
In plain words: the simulation sheet is an "Excel that computes itself": gray shows history, teal applies models, yellow keeps human judgment, green shows instant results.

Technology · Discrete ledger × DRP engine

DRP ENGINE

Discrete event ledger

  • Records only physical changes: snapshot import / inbound increase / planned inbound / expiry drop
  • No sales-deduction logic; available stock computed centrally by the engine
  • Expiry Drop: high-risk batches conservatively estimated as loss, surfacing risk early
Net demand = MAX(0, sales plan total + safety stock − available stock)

DRP replenishment engine (APICS standard)

  • Ending stock below the safety floor → red alert
  • Auto-suggests replenishment with floor settings, outputting net purchase suggestions
  • Expiry view: separates normal consumption from expiry write-offs

Technology · Closed loop & snapshot traceability

CLOSED LOOP
Single-channel planSKU × month
Multi-channel aggregationdemand rollup
Budget comparisonvariance analysis
Closed-loop correctionfed back to simulation

Storage roles & audit

  • MySQL main DB: master data and demand details, transactional reliability
  • MongoDB snapshot store: Draft→Active submission auto-generates JSON snapshots
  • Audit Trail: who, when, what changed and why — traceable long term

IT perspective: architecture · security · rollout

IT & SECURITY

Technical architecture

  • React frontend: Excel-like smooth tables, low learning cost
  • Python FastAPI backend: real-time simulation at massive SKU scale
  • MySQL main DB + MongoDB snapshot store
  • Parameter panel: smoothing/threshold settings take effect instantly

On-premise deployment

Data never leaves the enterprise boundary, fully under your control

Role-based access

RBAC permissions, visibility by role

Audit trail

Snapshots + intervention logs support internal audit compliance

Encryption & backup

TLS in transit, encrypted at rest, regular drills

Data firstModeling starts after master data governance passes acceptance
Single-channel pilotRun one core channel in parallel for 1–2 planning cycles
Full-channel rolloutSwitch over when targets are met; archive old processes, retain knowledge

Extensibility: universal adapters, no walled garden

EXTENSIBILITY

Integration with existing systems

  • RESTful API: real-time ERP/WMS calls, orders and stock flow in automatically
  • Scheduled jobs: e-commerce sales fetched automatically at T+1
  • Excel template import/export: low-barrier transition, no process changes initially
  • Results flow back: purchase suggestions pushed to HQ, plans synced to BI and finance
NOWNow · rule-based baselineData cleaning + seasonal index, delivered with the system
NEXTNext · machine-learning forecastsExternal factors like weather/traffic/ad spend improve accuracy over time
FARFuture · smart attribution & alertsAutomatic attribution for misses; proactive suggestions pushed on anomalies

Sales support scenarios

  • SKU × month forecasts become channel/store targets and performance baselines
  • Promo stock lock-in reduces "orders without stock"
  • Fast root-cause analysis: forecast error, stockout, or execution issue
  • Sales can check inventory health and stockout risk anytime

A balanced view: value, limits and the path to success

DIALECTICS

No system is a silver bullet. We honestly explain what it cannot do.

Thesis · the value the system creates

Takes over repetitive arithmetic, turns experience into data assets

  • ▪ Planning efficiency: annual planning shortened from weeks to days (depending on data maturity)
  • ▪ Baseline quality: cleaned baselines reduce promo/stockout noise
  • ▪ Traceability: every intervention logged; plans become auditable assets
Antithesis · limits and prerequisites

Three things the outcome depends on

  • ▪ Master data quality: inconsistent codes make accurate computation impossible
  • ▪ Human-system collaboration: the system advises but cannot replace business judgment
  • ▪ Company differences: industry benchmarks are not guarantees; results vary by company
Synthesis · the path to success

Small fast steps: data first → single-channel pilot → full-channel rollout

Parallel validation and steady cutover is the mature path for supply-chain systems; people graduate from "calculators" to "decision makers".

Demo mapping: customer needs × feature modules

SFIPS DEMO

Based on the real modules of the SFIPS demo environment (sls-inv-plan.natec.cn), each typical customer need is mapped to its solution module.

Solution details ›
NeedAnnual budget will not break down; versions are chaotic
Solution
Planning · Budget management + target derivationBudget list | version history | version comparison | AI re-derivation / batch confirmation
Solution details ›
NeedInaccurate forecasts; promo/stockout noise pollutes the baseline
Solution
Smart optimization · Forecast engine + trend modelingARIMA/Prophet/LightGBM/Ensemble tasks | trend types | model list | weekly daily composition
Solution details ›
NeedChannel plans in silos, hard to aggregate and align
Solution
Planning · Sales plans + workflow managementMulti-channel aggregation (qty / amount vs budget) | version history | approval workflow
Solution details ›
NeedFirst orders and promo multipliers decided by gut feel
Solution
Smart optimization · Weekly simulation center + master-data SKUWhat-if scenario simulation | confidence | PARENT code / CARRY OVER | promo configuration
Solution details ›
NeedInventory is a black box; stockouts and surplus coexist
Solution
Planning · Inventory planning + home overviewDaily simulation (571 days) | inventory snapshots | coverage heatmap | batch expiry alerts
Solution details ›
NeedReplenishment is unclear; hard to link with purchasing
Solution
Smart optimization · Buying engine + buying planSafety stock/net demand/MOQ formulas | AI auto-generation | Rolling versions | purchase inbound summary
Solution details ›
NeedEnd-of-life stock builds losses, discovered too late
Solution
Smart optimization · End-of-life optimizerAI identifies declining SKUs | pause replenishment / promo discount suggestions | loss and recoverable estimates
Solution details ›
NeedData silos, reports moved by hand
Solution
Data platform · Data integration + dimensional modelingERP/WMS/PLM/e-commerce channels | PSI/FORECAST/BUDGET/ACTUAL models | data inspection
Solution details ›
NeedUnclear intervention accountability, internal-audit compliance pressure
Solution
System administration · Operation audit + platform audit logsWho/when/what/why | approval workflow | tenant and permission management
Note: module names above come from the actual SFIPS demo menus; functional scope is subject to the contract and delivered version.