KEY PERFORMANCE INDICATORS
📦
UNITS SHIPPED
0
▲ +12.4% vs prior period
🎯
OTIF RATE
0%
▲ +23.8pp from 72.3%
📊
FORECAST ACCURACY
0%
▲ +34.0% improvement
🔄
INVENTORY TURNS
0×
▲ +1.8× from baseline
✂️
AIR FREIGHT COST
0%
▲ AED 2.1M saved YoY
📉
AGED STOCK %
0%
▼ −18.2pp reduction
[ COMMAND DECISION ENGINE ] — JUN 2024 OPERATIONAL STATUS
● DECISIONS REQUIRED
PRIMARY ACTION — HIGHEST URGENCY
LOCK IN 3PL ANNUAL CONTRACT. Current −30% air freight reduction expires Q3 2024. Without formal renewal, exposure is +AED 840K/yr. Negotiate now while leverage is highest — OTIF at 96.1% proves operational reliability.
SECONDARY ACTION — THIS MONTH
LIQUIDATE C/Z SKUs. LS-006, EL-007, PC-006 carry AED 54K in inventory at 17–19% aged. Markdown now at −25% prevents AED 130K write-off in Q4. Initiate with Warehouse & Sales.
TERTIARY ACTION — NEXT S&OP CYCLE
EXPAND ML MODEL SCOPE. Electronics A/X SKUs show 93%+ forecast accuracy. Extend XGBoost model to Lifestyle category (currently 62–78% accuracy). Estimated gain: −6pp MAPE on 5 SKUs.
DECISION CONFIDENCE
0%
LOW-MEDIUM RISK
BASED ON 18 MONTHS OF VALIDATED OPERATIONAL DATA
[ DEMAND PLAN DEPENDENCY MAP ] — YOUR FORECAST TRIGGERS ALL DOWNSTREAM FUNCTIONS
🎯
YOUR FORECAST
1.93M
UNITS · 18 MONTHS
DEMAND PLANNER CALL
▶▶
📢
MARKETING
AED 2.4M
CAMPAIGNS ACTIVATED
BUDGET LOCKED TO PLAN
▶▶
💰
SALES
AED 17.1M
REVENUE REALIZED
96.1% OTIF DELIVERED
▶▶
📦
INVENTORY
41 DAYS
DSI MAINTAINED
DOWN FROM 57 DAYS
▶▶
🏭
PROCUREMENT
AED 5.04M
POs RELEASED
−AED 2.1M AIR FREIGHT
▶▶
🏗️
WAREHOUSE
3.8%
AGED STOCK
DOWN FROM 22% RISK
OPERATIONAL TRENDS
OTIF vs FORECAST ACCURACY — 18-MONTH TREND
Weekly tracked · Plotted monthly. Baseline: Jan 2023. Target: OTIF ≥95%, FA ≥88%.
MONTHLY UNITS SHIPPED
Total units across China → MENA → GCC trade lanes.
AIR FREIGHT % OF TOTAL LOGISTICS
Target: <10% via 3PL consolidation strategy.
DAYS OF STOCK ON HAND (DSI)
Target band: 35–45 days. Excess = capital locked.
AGED STOCK % (>90 DAYS)
ABC analysis + markdown cadence reduced aged inventory.
UNITS BY TRADE LANE
Share of total volume shipped per corridor.
OTIF PERFORMANCE BY REGION — JUN 2024
All regions above 90% target. UAE Hub leads at 96.1%.
AIR FREIGHT COST REDUCTION WATERFALL — AED '000
Decomposition of −30% YoY savings: vendor consolidation, mode shift, route optimisation, demand smoothing.
OPERATIONS CHRONICLE — 18-MONTH TRANSFORMATION RECORD
JAN 2023
■ BASELINE CRISIS
OTIF: 72.3% · FA: 68.2%
Air Freight: 14.8% of cost
DSI: 57 days
Initiated 3PL audit. Established weekly S&OP cadence. Demand planning function onboarded. Air freight running 5pp above target.
APR 2023
■ INTERVENTION
OTIF: 76.1% · FA: 72.8%
Air Freight: 13.9%
DSI: 55 days
3PL consolidation program formally launched. Min-Max replenishment model for A-class SKUs. Safety stock parameters recalibrated.
JUL 2023
■ MOMENTUM
OTIF: 81.9% · FA: 77.9%
Air Freight: 12.8%
DSI: 50 days
Statistical forecasting model upgraded. ABC/XYZ classification rolled out across all 20 SKUs. Aged stock markdown cadence introduced.
OCT 2023
■ ML DEPLOYED
OTIF: 87.4% · FA: 83.0%
Air Freight: 11.5%
DSI: 46 days
XGBoost ML model deployed in S&OP cycle. Feature engineering with price elasticity + marketing spend + seasonal calendar. FA crosses 83%.
DEC 2023
■ INFLECTION
OTIF: 90.8% · FA: 86.4%
Air Freight: 10.7%
Aged Stock: 4.6%
OTIF crosses 90% threshold. All major metrics trending. Air freight below 11%. Full ML model suite validated across all A/B SKU classes.
JUN 2024
■ PEAK PERFORMANCE
OTIF: 96.1% · FA: 91.4%
Air Freight: −30%
Aged Stock: 3.8%
All targets exceeded. AED 2.1M saved in logistics. 8.9× inventory turns. Zero stockouts on A/X SKUs. Full S&OP cadence established.
SKU PERFORMANCE DETAIL
TOP 20 SKUs — ABC/XYZ CLASSIFICATION & OPERATIONAL KPIs
Sorted by revenue contribution. Click headers to sort. ABC = value class. XYZ = demand variability. Z-class SKUs = liquidation candidates.