Portfolio Showcase · FMCG Analytics

PenBev
CCPB Intelligence Platform

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.

246
Active SKUs
R21M+
Revenue Tracked
6 Channels
Trade Coverage
45% Margin
Avg Gross Margin

Platform Overview

What Was Built

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.

R21M+
Total Revenue (FY2024)
45.0%
Avg Gross Margin
8.0%
Trade Spend Rate
8,000
Sales Transactions

Business Context

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.

Technical Deliverables

  • 📊 4 HTML Dashboards — Business, Health, Product Master, Executive
  • 📁 Excel Workbook — 5-tab KPI, brand, province, ML, and product sheets
  • 🗺 Distribution Map — SA outlet network with channel filtering
  • 🤖 3 ML Models — SKU grader, revenue predictor, trade ROI model
  • 📦 Product Master — 246 SKUs with barcode, cost, margin, and grade data

Trade Channel Analysis

Channel Performance

Six trade channels each with distinct pricing dynamics, margin profiles, and trade investment requirements.

ChannelRevenue ShareMargin ProfileTrade SpendAvg Weighted Dist.Strategic Role
Mass Retail35%HighHigh (12-15%)92%Volume driver, brand visibility
Convenience20%Very HighLow (3-5%)78%Premium pricing, impulse purchase
On-Trade18%MediumMedium (8-10%)65%Brand experience, trial generation
E-Commerce12%HighMedium (6-8%)55%Fast-growing, data-rich channel
Wholesale10%LowVery High (15-20%)88%Reach, informal trade gateway
Petrol & Travel5%Very HighVery Low (2-3%)42%Captive audience, premium format

Mass Retail Dominates

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.

E-Commerce Growing Fast

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.

Wholesale: Reach vs Margin

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%.


Brand Portfolio

Brand Performance

11 brands across 6 categories — from core Coca-Cola CSD to energy, juice, water, and mixer segments.

Coca-Cola

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.

Cappy

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.

Monster / Powerplay

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.

Schweppes

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.

Bonaqua

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.

Powerade

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.

SKU Grade Distribution

A
25%
High margin, high distribution
Revenue drivers
B
40%
Solid performers
Distribution opportunity
C
25%
Margin or distribution gap
Needs attention
D
10%
Under-performing
Rationalisation candidates

Machine Learning

Predictive Analytics Models

Three sklearn models supporting SKU rationalisation, revenue forecasting, and trade investment optimisation.

Model 1 — SKU Grade Classifier
Classifies each SKU into A / B / C / D performance tier
Random Forest · 100 trees
32%
Test Accuracy
32%
5-Fold CV
4 Classes
A/B/C/D
5
Features
Note: Model accuracy reflects that SKU grades in this synthetic dataset were randomly assigned — in a production environment, grades would be derived from actual outlet audit data (Nielsen/IRI), giving the model a learnable signal. The feature importance output (margin_pct, weighted_distribution) correctly identifies the real-world drivers of SKU performance.
Model 2 — Revenue Predictor
Forecasts SKU revenue by channel given volume, price and promotion inputs
Gradient Boosting
0.997
R² Score
R61
MAE per Transaction
8,000
Training Rows
Business use: High R² reflects a well-specified revenue equation (units × price). In production, this model would incorporate seasonal indices, competitor pricing, and promotional elasticity from scanner data to produce 12-week forward revenue forecasts by SKU and channel.
Model 3 — Trade Spend ROI Predictor
Predicts net revenue per rand of trade investment by channel and brand
Linear Regression
Baseline
R² (needs real data)
3.73x
Avg Trade ROI
8.0%
Avg Trade Spend %
Business use: Trade ROI optimisation is the highest-value FMCG analytics use case. With real promotional redemption data and volume uplifts, this model would identify which channel-brand combinations deliver above-hurdle ROI — redirecting spend from low-ROI mass promotions to targeted convenience and e-commerce activations.

Key Findings

Strategic Insights

From 8,000 CCPB sales transactions, 246 SKUs, and 6 trade channels across 9 provinces.

Gauteng Concentration Risk

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.

Energy Drinks: Fastest Growing

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.

28% of SKUs are D-Grade

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.

Convenience: Best Margin Channel

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.

CCPB Model Highlights

Price-by-Channel
Each SKU carries up to 6 different price points — one per channel. The product master tracks list_price, std_cost, and margin at the EA and CS (case) UOM level enabling true channel-level profitability.
Weighted Distribution
Weighted distribution (Wt. Dist.) is the share of category volume sold through outlets that stock the SKU. It's the primary measure of availability — a SKU with 100% Wt. Dist. is available where all the volume is being bought.
Trade Spend ROI
Trade spend (promotional investment to retailers) averages 8% of revenue. The ROI model targets above 3.5x net revenue return per rand spent — below this hurdle, trade investment destroys value relative to base business margin.
Ask about PenBev CCPB
Hi! Ask me about the channels, the brands, the ML models, or the tech stack.