AI Copilot
Natural-language → SQL over the SAP + DMS model · Azure OpenAI gpt-4.1 · read-only & governed
● grounded on live data
Total net sales in crore by channelTop 5 products by net sales valueContribution margin percent by channelHow many outlets by class?Distributor claims approved vs pending by status
Standing intelligenceauto-generated insights · gpt-4.1
AI insights
Growth
Double-digit annual growth driven by diversified channels
FY25-26 net revenue is ₹240.7 crore, up 11% YoY, with Modern Trade (+36.3 crore), E-Commerce (+28.8 crore), and Quick Commerce (+14.4 crore) now contributing 33% of total sales, reflecting robust omnichannel expansion.
→ Accelerate investments in digital and modern trade channels, leveraging data-driven promotions and exclusive SKUs to sustain double-digit growth.
Margin
EBITDA margin under pressure despite topline growth
EBITDA is ₹33.7 crore (14.0% margin), down from 15.8% last year, indicating cost inflation or mix dilution, as gross margin is flat at 38.0 crore.
→ Initiate cost optimization in supply chain and packaging; review pricing architecture in Modern and Quick Commerce to restore margin trajectory.
Channel
General Trade dominance declining
General Trade contributes 50% (₹120.4 crore), down from 55% last year, as Modern Trade and digital channels gain share.
→ Reinvigorate General Trade with targeted loyalty programs and rural distribution expansion to defend share against emerging channels.
Supply Chain
Inventory turns below FMCG benchmark
Inventory turns at 0.92x (from KPI), significantly lagging FMCG best practice (3-4x), tying up working capital and risking obsolescence.
→ Implement S&OP and demand forecasting tools; rationalize SKUs to improve inventory velocity and free up cash.
Working Capital
Receivables cycle stretching cash conversion
Receivables days at 78.7 (from KPI), above industry norm (45-60 days), indicating delayed collections and potential credit risk.
→ Tighten credit policies and incentivize early payments, especially in Modern Trade and Export, to improve cash flow.
Portfolio
Top 10 products highly fragmented
Top 10 SKUs contribute only ₹61.0 crore (~25% of sales), with no single product >3% share, diluting marketing focus and scale benefits.
→ Prioritize 3-4 hero SKUs for above-the-line investment and distribution push; consider pruning tail SKUs to drive efficiency.
Region
West and South outperform, Central and East lag
West (₹63.6 crore) and South (₹50.8 crore) are growth engines, while Central and East (each ₹25.4 crore) under-index relative to population.
→ Deploy region-specific activation and trade marketing in Central and East to unlock latent demand and rebalance regional mix.
Seasonality
Strong festive seasonality creates supply chain stress
Sales spike in Sep-Nov (₹69.9 crore, 29% of annual), risking stockouts and service gaps if not anticipated.
→ Advance production planning and pre-build inventory for Q2-Q3; collaborate with key retailers for joint forecasting.
Recent questions
| Question | OK | Rows |
|---|---|---|
| Top 5 products by net sales value | ✓ | 5 |
| Total net sales in crore by channel | ✓ | 6 |
| Total net sales in crore by channel | ✓ | 6 |
| Total net sales in crore by channel | ✓ | 6 |
| what did ebitda slips | ✓ | 12 |
| Total net sales in crore by channel | ✓ | 6 |
| Which month had the highest net sales? | ✓ | 1 |
| How many distributors are wholesalers located in Gujarat? | ✓ | 1 |