Consumer Channel Price-by-Brand analytics for a South African FMCG beverage distributor — 246 active SKUs, 6 trade channels, R21M+ revenue tracked across all 9 provinces.
A full-stack FMCG business intelligence suite covering SKU performance, channel mix, trade spend ROI, and distribution analytics for a Coca-Cola FMCG portfolio in South Africa.
PenBev is a South African FMCG beverage distributor operating under a Consumer Channel Price-by-Brand (CCPB) commercial model. CCPB pricing means each brand × channel × pack size combination carries its own negotiated price point — creating a complex SKU master that requires dedicated analytics infrastructure to manage profitability, distribution coverage, and trade investment effectively.
Six trade channels each with distinct pricing dynamics, margin profiles, and trade investment requirements.
| Channel | Revenue Share | Margin Profile | Trade Spend | Avg Weighted Dist. | Strategic Role |
|---|---|---|---|---|---|
| Mass Retail | 35% | High | High (12-15%) | 92% | Volume driver, brand visibility |
| Convenience | 20% | Very High | Low (3-5%) | 78% | Premium pricing, impulse purchase |
| On-Trade | 18% | Medium | Medium (8-10%) | 65% | Brand experience, trial generation |
| E-Commerce | 12% | High | Medium (6-8%) | 55% | Fast-growing, data-rich channel |
| Wholesale | 10% | Low | Very High (15-20%) | 88% | Reach, informal trade gateway |
| Petrol & Travel | 5% | Very High | Very Low (2-3%) | 42% | Captive audience, premium format |
35% of revenue but absorbs 12-15% trade spend. Checkers, Pick n Pay, and SPAR drive the majority of carbonated soft drink volume with aggressive promotional calendars requiring proactive trade investment planning.
12% revenue share and accelerating. Checkers Sixty60, Pick n Pay asap!, and Woolworths Dash have created a high-frequency replenishment channel with better margin visibility and lower trade investment than traditional retail.
Lowest margin channel (wholesale pricing) but highest geographic reach into informal trade. Key entry point for Limpopo, Mpumalanga, and Northern Cape markets where modern retail penetration is below 40%.
11 brands across 6 categories — from core Coca-Cola CSD to energy, juice, water, and mixer segments.
Carbonated Soft Drinks · 86 SKUs · 40% Revenue Share
Flagship brand driving volume leadership across all channels. 330ml and 500ml PET formats dominate convenience; 2L and multipack drive mass retail volume.
Juices & Nectars · 24 SKUs · 10% Revenue Share
Premium juice portfolio with highest margin per unit in the PenBev range. Chilled format drives on-trade and petrol convenience. Wt. distribution lags at 62% — key growth opportunity.
Energy Drinks · 18 SKUs · 6% Revenue Share
Fastest-growing category in SA FMCG. Monster leads the premium energy segment; Powerplay competes in the mid-tier. Combined energy portfolio growing at 22% YoY — outpacing all other categories.
Mixers · 18 SKUs · 7% Revenue Share
Dominant in the mixer segment with 78% category share. On-trade is the primary channel — bars, restaurants, and hotels account for 62% of Schweppes volume. Premium positioning protects margin.
Water · 11 SKUs · 5% Revenue Share
Bottled water with the lowest margin per litre but highest volume potential. Petrol & Travel channel drives impulse purchase of 500ml formats. Category growing on health trend tailwind.
Sports Drinks · 7 SKUs · 2% Revenue Share
Smallest brand by SKU count but high per-unit margin. Currently under-distributed (Wt. Dist. 44%) relative to the sports nutrition trend. Gym channel and Petrol & Travel are priority expansion targets.
Three sklearn models supporting SKU rationalisation, revenue forecasting, and trade investment optimisation.
From 8,000 CCPB sales transactions, 246 SKUs, and 6 trade channels across 9 provinces.
Gauteng generates 32% of total revenue — disproportionate vs. 26% population share. Revenue per capita is R2,580 vs. national average of R1,210. This concentration creates vulnerability; a Gauteng economic shock would disproportionately impact overall performance.
Monster and Powerplay combined represent 6% revenue but 22% YoY growth — the highest category growth rate in the portfolio. At current trajectory, energy drinks will be the #2 category by volume within 3 years, overtaking Sprite and Fanta.
10% of SKUs classified D-grade represent dead weight in the range — they consume trade spend, warehouse space, and sales force attention while contributing negative margin contribution after overheads. SKU rationalisation targeting D-grades could improve portfolio margin by 2-3 percentage points.
Despite only 20% revenue share, Convenience delivers the highest gross margin per rand sold — with minimal trade investment (3-5%) relative to mass retail (12-15%). Redirecting 5% of mass retail trade spend to convenience activation would generate equivalent volume at 40% higher margin.