AI CXO
Value created · QTD₹4.82 Cr▲9:14:00 AM · Mon 26 Jan ISTActive

Triggers & ratios

The leading indicators the scores are built from, and the clusters that fire an event when they turn red together.

◍

Fourteen ratios, six composite triggers. Each ratio is computed from SAP with a normal band and a trigger level; each composite trigger fires only when a cluster aligns — never on a single signal. Tune the bands here; the change recomputes overnight.

Ratio bands

14 ratios · SAP-computed
RatioCodeSAP sourceNormalTrigger atLeads to
Order-Frequency RatioOFRSAP SD · VBAK0.8–1.2Dealer slowdown / churn
Avg-Order-Value RatioAOVRSAP SD · VBRP0.9–1.1Down-trading
Payment-Delay RatioPDRSAP FI-AR · BSAD≤1.05Liquidity stress
Credit-Utilization RatioCURSAP Credit Mgmt<0.80Order-block risk
Overdue RatioODRSAP FI-AR · BSID<0.15Bad-debt
Premium-Mix RatioPMRSAP SD · MVKEstableMargin erosion
Return/Complaint RatioRCRSAP SD + QM<0.05Dissatisfaction
Sell-Through RatioSTRSAP SD + MM>0.30Dead stock
Stock-Cover (months)SCRSAP MM · MARD1.5–3Surplus
OTIF / Fill-RateOTIFSAP LE · LIKP>0.95Dispatch risk
Dispatch-Delay RatioDDRSAP LE · LIKP<0.05SLA breach
Scheme-ConversionSCNVSAP SD>0.40Disengagement
Target-Pace RatioTPRSAP SD vs target≥0.95Target miss
Wallet-Share TrendWSTSAP SD + peerstableShare loss
◷ Editing a band re-flags dealers/SKUs on tonight's recompute. No live system is touched until you approve the resulting decisions.

Composite triggers — fire in totality

6
Dealer churn / revenue-at-risk
fires → DEALER_CHURN_RISK · REVENUE_MISS_RISK
OFRAOVRPMRWSTRCRPDR
Rule: ≥ 3 reds incl. one of {OFR, PDR} — equals churn_score ≥ 60
Credit / order-block
fires → DEALER_CREDIT_RISK
CURODRPDR
Rule: CUR > 0.90 AND (ODR > 0.30 OR PDR > 1.30)
Dead-stock / liquidation
fires → DEAD_STOCK_DETECTED
STRSCRAgeRCR
Rule: STR < 0.15 AND SCR > 5 AND age > 120d — equals liquidation_score ≥ 60
Dispatch / delivery risk
fires → DISPATCH_DELAYED
OTIFDDR
Rule: OTIF < 0.90 OR DDR > 0.15, sustained 7 days
Sales target-miss
fires → SALES_TARGET_MISSED
TPROFR
Rule: TPR < 0.85 AND OFR < 0.70 with > 10 days left
SKU demand-shift
fires → INVENTORY_RISK
VelocityPMRMargin
Rule: velocity down > 25% AND margin compression > 20%
Demo — fictional companies, illustrative data