From SettingsTrade discount 8.5%Retailer margin 12%Promo funding ₹14LReturns + other 3.5%Adjust

Gross-to-Net Simulator

Rasa Beverages · Rasa Mango 330ml PET · Bangalore · Modern Trade · 15% OFF

Product

Rasa Mango 330ml PET

Market

Bangalore

Channel

Modern Trade

Retailer

Reliance Retail

Period

18 Aug – 31 Aug 2026

Promotion

15% OFF

Promotion Budget

Cr2.71 Cr used

54% utilized · ₹229L remaining

Gross Revenue

0.00 Cr

Baseline before deductions

Net Revenue

0.00 Cr

67.8% realization

Contribution Margin

0.00 Cr

11.8% of gross revenue

Gross-to-Net Leakage

0.00 Cr

32.2% of gross revenue

Industry avg. 18%Benchmark based on comparable CPG commercial structures.|You 32%|Gap +14 pts

176L annual opportunity vs. industry benchmark

46.6L vs current scenario

Gross-to-Net Waterfall

Where every ₹1 of gross revenue goes

Gross Revenue

₹12.40 Cr

Trade Discount

₹0.81 Cr6.5% of gross

Consumer Promotion Cost

₹0.74 Cr6.0% of gross

Logistics

₹0.62 Cr5.0% of gross

Channel Margin

₹1.39 Cr11.2% of gross

Other GTN Leakage

₹0.43 Cr3.5% of gross

Net Revenue

₹8.40 Cr

COGS

₹6.94 Cr56.0% of gross

Contribution Margin

₹1.46 Cr

Contribution Margin

₹1.46 Cr

Margin %

11.8%

Every ₹100 of Gross Revenue generates 11.81 of contribution.

Where Are We Losing Value?

Share of total gross-to-net leakage by cost bucket

Channel Margin

1.39 Cr31%

Trade Discount

0.81 Cr18%

Consumer Promotion

0.74 Cr17%

Logistics

0.62 Cr14%

COGS wastage

0.50 Cr11%

Other (returns, claims)

0.43 Cr10%

Largest controllable leakage

Channel Margin · ₹1.39 Cr

Commercial Inputs

Change an input to simulate the P&L impact.

Trade Discount

7%

0% – 20% of gross revenue

Impact on Net Revenue −₹0.81 Cr

Consumer Promotion

AI Recommended 15%15%

Promotion cost ₹74 Lakhs

6.0% of gross

Logistics Cost

5.0%

Cost ₹62 Lakhs

2% – 10% of gross

Cost of Goods Sold

₹6.94 Cr

56% of gross revenue

Channel Margin

12%

Applied after trade discount

Other GTN Leakage

₹43 L

Returns · Claims · Damages · Scheme adjustments

Live P&L Impact

Net Revenue+₹46.6L
Contribution Margin+₹46.6L
Gross-to-Net36.0% → 32.2%

P&L Detail

Current scenario vs your live simulation

Promotion Budget 5.00 CrPlan Utilization 54%Remaining 229L
Gross Revenue₹12.40 Cr₹12.40 Cr
Trade Discount₹1.49 Cr₹0.81 Cr+₹68L
Consumer Promotion₹0.99 Cr₹0.74 Cr+₹25L
Logistics₹0.62 Cr₹0.62 Cr
Channel Margin₹0.87 Cr₹1.39 Cr−₹52L
Other GTN Leakage₹0.12 Cr₹0.43 Cr−₹31L
Net Revenue₹8.31 Cr₹8.40 Cr+₹10L
COGS₹6.94 Cr₹6.94 Cr
Contribution Margin₹1.37 Cr₹1.46 Cr+₹10L
Contribution Margin %11.0%11.8%+0.8 pts

AI Gross-to-Net Opportunity

PromoIQ identified 3 opportunities to improve contribution.

Budget-aware recommendation

Your current plan uses 54% of the ₹5.00 Cr quarterly promotion budget. PromoIQ recommends reducing trade discount from 10% to 8% and consumer promotion from 20% to 15%, improving contribution margin by ₹49L without increasing total promotion spend.

Reduce Trade Discount

10%8%

Contribution improvement

+₹24.8 Lakhs

AI Confidence94%

Optimize Consumer Promotion

20%15%

Contribution improvement

+₹42 Lakhs

Expected volume impact −5%

AI Confidence96%

Reduce Logistics Leakage

5.0%4.4%

Contribution improvement

+₹7.4 Lakhs

Route consolidation across Bangalore MT

AI Confidence89%

AI Executive Insight

Rasa Mango currently converts ₹100 of gross revenue into approximately ₹11.81 of contribution under the current commercial structure. Gross-to-net leakage is 32%, 14 pts above the 18% industry benchmark, representing an estimated ₹176L annual opportunity. The current promotion plan uses 54% of the ₹5.00 Cr quarterly budget, leaving ₹229L unallocated.

By reducing trade discount from 10% to 8% and optimizing consumer promotion from 20% to 15%, PromoIQ projects approximately ₹49 Lakhs improvement in contribution margin without increasing the current promotion budget.

₹49 Lakhs

Potential Contribution Improvement

+4.0 pts

Contribution Margin Improvement