PB

PenBev · Business Intelligence

DASHBOARD 2 OF 2 · MASTER DATA + TRANSACTIONAL · SAP RETAIL ARTICLE MODEL · CCPB CAPE TOWN
R28.4b ex-VAT · 88 SKUs · 2.31M sales lines
Master · governed

Product / Article Master

88
Current Variant Articles
IsCurrent=1
29
Generic Articles
brand × flavour
352
Article-UOM Rows
EA·PK1·PK2·PLT
108
Total Rows (incl. history)
20 SCD2-versioned

Generic → Variant → UOM → Barcode (SAP retail article)

Merchandise Hierarchy → Generic Article → Variant Article (SAPArticleNumber) → Article-UOM (EA/PK1/PK2/PLT) → Barcode (EAN-13 / GTIN-14 / SSCC)

Sample of current variant articles

SAP #Variant ArticleBrandFlavourSugar
100000001Coca-Cola Original 330ml CanCoca-ColaColaRegular
100000002Coca-Cola Original 500ml PETCoca-ColaColaRegular
100000004Coca-Cola Original 2L PETCoca-ColaColaRegular
100000006Sprite Original 1L PETSpriteLemon LimeRegular
100000008Stoney Ginger Beer 1L PETStoneyGinger BeerRegular
100000011Powerade Berry Ice 500ml PETPoweradeBerry IceRegular
100000012Costa Coffee Latte 250ml CanCostaLatteRegular
→ full product master (every variant × UOM × barcode)
Master · governed

Brands & Merchandise Hierarchy

14
Brands
cleaned from 39 spellings
6
Product Categories
CSD·Water·Juice·…
14
Merch Hierarchy Nodes
5-level SAP
4
Package Types
CAN·PET·GLASS·TETRA

5-level merchandise hierarchy

Division BEV — Beverages
↳ Department SOFT — Soft Drinks
  ↳ Category CSD — Carbonated Drinks
    ↳ SubCategory COLA — Cola
      ↳ Segment COCA — Coca-Cola
Each generic article hangs off one hierarchy node; the hierarchy drives merchandising, range & planogram reporting.

Brand portfolio

BrandOwnerType
Coca-ColaTCCCCarbonated
SpriteTCCCCarbonated
FantaTCCCCarbonated
StoneyTCCCCarbonated
SchweppesTCCCCarbonated
Bonaqua / ValpreTCCCWater
PoweradeTCCCSports
Powerplay / MonsterTCCC / MonsterEnergy
Minute Maid / CappyTCCCJuice
Master · governed

Units of Measure & Packaging

Bulk-selling rule — PenBev does not sell loose units

The consumer EA (each) exists only so a single bottle can be scanned at retail — it is IsSellable=1, IsOrderable=0. Trade orders are placed in cases (PK2) and pallets (PLT). Every sales/inventory fact is therefore in a bulk UoM, and EA appears only on the shelf-edge barcode.
UoMDescriptionConv → EASellableOrderableWarehouse
EAEach sellable unit (scan only)1YESnono
PK1Inner pack / shrink pack6noYESYES
PK2Outer case (primary order unit)24noYESYES
PLTPallet1,440noYESYES
Conversions vary by pack size (e.g. a 2L case = 6 EA, a 330ml case = 24 EA). Each UoM row carries gross/net weight, volume in litres and physical dimensions (H×W×D cm) for load planning.
Master · governed

Barcodes & GS1

352
Barcodes
one per article-UOM
88
EAN-13
consumer EA
176
GTIN-14
PK1 / PK2 cases
88
SSCC
pallets

GS1 structure

TypeGTINPrefix
EAN-1360010000000186001000
GTIN-14160010000000156001000
GTIN-14260010000000126001000
SSCC360010000000196001000
Packaging indicator (1=inner, 2=case, 3=pallet) prefixes the company GTIN; check digit is mod-10.

Integrity (resolved in pipeline)

Valid in master
100%
Shared GTIN (source)
4 GTINs
Variants affected
9
Collisions live in the dirty source; the governed master stays clean. Detection recall vs injected truth = 100%. See the Health dashboard → Barcodes.
Master · governed

Customers

1,206
Current Customers
Western Cape trade
60
SCD2-Versioned
credit / channel moves
4
Channels
MT·Conv·WS·Informal
~7%
Inactive Flagged
IsActive=0

Customers by channel

Modern Trade
682
Convenience
213
Wholesale
213
Informal Trade
98

By customer type

Retail Store
467
Wholesale
311
Retailer DC
215
Forecourt
213
Each customer carries credit limit, geo-coordinates and an active flag; changes are tracked as SCD2 history.
Master · governed

Distribution Network

4
Sites
DC · plant · cross-dock · depot
6
Routes
Western Cape regions
7
Trucks
rigid · artic · urban

Sites

SiteTypeCityPallets
Parow Distribution CentreDCParow18,000
Athlone Production PlantPlantCape Town12,000
Epping Cross DockCross DockEpping6,000
George DepotDepotGeorge3,000

Routes

RouteRegionkmHrs
Parow → Northern SuburbsNorthern Sub.45.53.2
Parow → Cape Town CBDCBD32.02.8
Parow → Southern SuburbsSouthern Sub.58.74.1
Epping → West CoastWest Coast88.05.0
George Garden RouteGarden Route110.05.5
Master · governed

Pricing (with history)

528
Price Rows
per orderable UOM
2
Price Epochs
2025 → 2026 list
+8.7%
List Increase
2025 → 2026

National list price — sample (ZAR ex-VAT, 2026)

Variant ArticleUoMCostWholesaleRRP
Coca-Cola Original 330ml CanPK243.5657.0279.12
Coca-Cola Original 330ml CanPLT4,356.005,702.407,912.08
Coca-Cola Original 500ml PETPK266.0086.40119.88
Coca-Cola Original 1L PETPK266.0086.40119.88
Pricing is held at orderable-UoM level with EffectiveFromDate / EffectiveToDate — the 2025 list is expired and the 2026 list is current, so historical orders re-price correctly.
Master · governed

SCD Type-2 History

20
Versioned Variants
pack / shelf-edge change
60
Versioned Customers
credit / channel change
2
Price Epochs
list-price history

Variant article version history (example)

Variant CodeShelf-Edge LabelEffective FromEffective ToVersionCurrent
VA-COCA-ZERO-1L-PET1 litre PET2022-01-012025-06-301no
VA-COCA-ZERO-1L-PET1 litre PET (NEW)2025-07-01—2YES
VA-MONSTER-ORG-500-CAN500ml Can2022-01-012025-06-301no
VA-MONSTER-ORG-500-CAN500ml Can (NEW)2025-07-01—2YES
A change expires the current row (EffectiveTo, IsCurrent=0) and inserts a new version with a fresh surrogate key. Facts join on the surrogate key, so a 2024 sale reflects the attributes as they were then.
Transactional · high-volume

Sales

2.31M
Clean Sales Lines
of 2.52M raw
R28.4b
Revenue ex-VAT
2024–2026 demo span
R17.4b
Cases (PK2)
~61% of revenue
R11.0b
Pallets (PLT)
~39% of revenue

Revenue by channel (R bn)

Modern Trade
16.06
Wholesale
5.07
Convenience
4.94
Informal Trade
2.30

Revenue by brand (R bn)

Coca-Cola
9.01
Fanta
3.84
Stoney
2.71
Sprite
2.52
Bonaqua
1.70
Schweppes
1.66
Powerade
1.61

Revenue by category (R bn)

Carbonated Soft Drinks
19.74
Water
2.84
Energy Drinks
1.99
Juice
1.69
Sports Drinks
1.61
RTD Coffee
0.49
Transactional · high-volume

Inventory

48,640
Snapshot Rows
site × SKU × day
4
Sites Tracked
DC·plant·xdock·depot
3-day
Snapshot Cadence
2024–2026
opening+recv−sold−damaged
Closing Identity
balance check

Inventory model

Each snapshot carries opening, received, sold and damaged quantities in cases (PK2), with a derived closing balance, its EA equivalent (via ConversionToEA) and an ex-VAT stock value from the current price. Negative or imbalanced closings are flagged in the quality layer.
Transactional · high-volume

Logistics / Delivery

59,681
Delivery Lines
2024–2026
14.9%
Late Deliveries
LateDeliveryFlag=1
50%
Delivered In Full
vs partial / failed
~60
Cases / Pallet
load conversion

Delivery status mix

Delivered
29,676
Partial
15,030
Failed
14,975
Each line links customer · site · route · truck, with start/end timestamps and fuel cost — feeding on-time-in-full (OTIF) and cost-to-serve.
Transactional · high-volume

Production

2,744
Production Batches
Athlone plant
R47.4m
Total Cost of Production
material+labour+OH
R17.5k
Avg Batch Cost
blended
EA out
Batch Yield
→ stock receipts

Cost build-up (R m)

Material
36.0
Overhead
9.7
Labour
1.7
Each batch consumes ingredients per its bill of materials and absorbs labour + plant overhead, giving a fully-costed cost-per-litre that links manufacturing to the BOM and expense layers.
Transactional · high-volume

Ingredients / Bill of Materials

21,952
BOM Lines
batch × ingredient
8
Ingredients
sugar → preservative
R36.0m
Ingredient Spend
material cost

Ingredient spend (R m)

Refined White Sugar
17.2
Concentrate 7X
13.0
Flavour Blend
3.8
Caramel / Colour
0.7
Food-grade CO₂
0.7
Citric / Phosphoric Acid
0.4
Treated Water
0.2
Sodium Benzoate
0.1
Transactional · high-volume

Operating Expenses

1,152
Expense Postings
cost centre × period
R19.7m
Total Opex
demo period
9
Cost Centres
fleet → lab

Opex by cost centre (R m)

Distribution Fleet
4.33
Production Line 1–3
2.90
Production Line 4–6
2.74
Sales & Trade Marketing
2.57
Warehouse / Logistics
2.22
Site Utilities
1.74
Admin / Finance / IT
1.45
Syrup Room / Blending
0.98
Quality / Laboratory
0.79
DASHBOARD 2 OF 2 · Business Intelligence · 8 master-data tabs + 6 transactional tabs · governed master joins high-volume facts on surrogate keys · R28.4b ex-VAT