AI Narrative · Plan vs Actual · Corporate
Revenue trailing plan by 1.2%
The gap is driven primarily by volume variance (38% share), concentrated in Silicone Male External Catheter (SMEC). Production attainment of 91% compounds the shortfall through margin compression of 11.6%. Confidence in this attribution: 89%.
Plan
₹14,474.3 L
Actual
₹14,302.9 L
Variance
₹-171.4 L
Variance %
-1.2%
Revenue
On TrackPlan → Actual
₹14,474.3 L → ₹14,302.9 L
-1.2%
Production (units)
CriticalPlan → Actual
7.80 M → 7.12 M
-8.7%
Gross Margin %
CriticalPlan → Actual
28.4% → 25.1%
-11.6%
Variance Waterfall
Decomposition of plan vs actual — ₹ Lakhs
BaselineUnfavorableFavorableResult
Driver Pareto
Top contributors to revenue variance
Variance Heat Map
Products × variance metric (YTD %)
| Product | Revenue | Production | Inventory | Margin |
|---|---|---|---|---|
| Latex | +1.2% | +2.2% | -0.5% | -0.5% |
| Injection | -1.4% | -1.4% | -2.4% | -2.0% |
| Silicone | -3.2% | -2.2% | +1.3% | -3.1% |
| Nitrile | -1.8% | -0.8% | +2.7% | -2.3% |
| Cut | -0.4% | -3.4% | -1.8% | -1.4% |
| Injection | -1.3% | -0.3% | -2.5% | -2.0% |
Variance Trend
Plan vs Forecast vs Actual — monthly variance
AI Explainability
Observation · Root cause · Impact · Recommendation · Confidence
Revenue achieved 98.8% of YTD plan (₹14,302.9 L vs ₹14,474.3 L).
Root cause
Volume variance is the dominant contributor at 38% of the gap, concentrated in Silicone Male External Catheter (SMEC).
Impact
Revenue exposure of ₹171.4 L; flows through to a -11.6% margin compression.
Recommendation
Reallocate sales coverage to high-velocity SKUs (Latex family) and tighten discount governance in the South region.
AI confidence
89%
Production attained 91.3% of plan — short by 680k units.
Root cause
Material Shortage accounts for 40%, followed by Machine Downtime at 28%.
Impact
Capacity opportunity-cost equivalent to ₹28.6 L in unrealised revenue this period.
Recommendation
Trigger expedited PO release for top-3 raw materials and bring forward preventive maintenance window on Line 2.
AI confidence
92%
Forecast bias detected: current forecast tracks -2.6% below plan.
Root cause
Recurring under-forecast in Latex family; planner inputs lag actual demand signal by ~2 cycles.
Impact
Risk of stockouts on fast-movers and ₹12.4 L missed revenue if uncorrected.
Recommendation
Switch planner cadence to weekly, enable AI auto-baseline for the affected family.
AI confidence
81%
Root Cause Drill-down
Corporate → Business Unit → Product → Customer
Cephas Medical (Corporate)₹-171.4 L-1.2%
Medical Devices BU₹-133.7 L-1.2%
Production Variance
Plan 7.80M → Actual 7.12M units
Margin Variance Bridge
28.4% → 25.1%
Inventory Variance
Raw · WIP · Finished Goods
Forecast Error38%
Excess Stock24%
Slow Moving18%
Stockouts12%
Obsolescence8%
Raw
-4.2%
WIP
+1.8%
FG
+8.4%
AI Recommendations
Prioritised corrective actions
Revenue
- Increase coverage on top-10 customers (80% of pipeline).
- Cap discount approvals above 12% to CFO desk.
- Prioritise dispatch of high-margin SKUs in week 1–2.
Production
- Schedule preventive maintenance during low-demand window (Feb).
- Dual-source critical raw materials with >30-day lead time.
- Re-sequence MPS to load idle capacity on Plant 2.
Inventory
- Run liquidation campaign on slow-moving SKUs (>120 DOH).
- Reduce safety stock on B/C items by 15%.
- Tighten forecast horizon to 8 weeks for fast-movers.