Brand Portfolio: HealthMax (Starbust & Shinez) Category: Haircare / Shampoo Domain: Fast-Moving Consumer Goods (FMCG) Role: Category & Data Analyst Tools Used: Microsoft Excel (PivotTables, VLOOKUP, Advanced Formulas, Forecasting, Waterfalls) Core Objective: Analyse sales performance for a personal care brand (Healthmax) and leverage Net Revenue Management (NRM) principles to identify sustainable growth opportunities and optimize pricing/promotions.
1. Executive Summary
HealthMax is a key player in the personal care haircare sector with two primary brands: Starbust (mass) and Shinez (premium). Despite generating $31.44M in retail sales and $20.48M in Net Sales in 2022, HealthMax faced flattening market share for Starbust (falling from 24% in 2018 to 20% in 2023) and margin pressure from inefficient promotional spend.
2022 Baseline Strategic Levers (2024) 2024 Projection
┌──────────────────────────┐ ┌──────────────────────────────────┐ ┌──────────────────────────┐
│ Net Sales: $20.48M │ │ 1. Natural Organic Growth │ │ Net Sales: $21.24M │
│ Gross Profit: $14.03M │ ──>│ 2. NPD: Herbashine Organic │ ──>│ Gross Profit: ~$14.65M │
│ Gross Margin: 68.5% │ │ 3. PPA: Starbust 50ml Launch │ │ Accretive Margin Mix │
│ Category Share: 32% (All)│ │ 4. Promo Spend Reallocation │ │ Enhanced ROI Discipline │
└──────────────────────────┘ └──────────────────────────────────┘ └──────────────────────────┘ Key Commercial Outcomes
- Identified $795,952 in Incremental Net Sales for 2024, bridging Net Sales from $20.44M (2023E) to $21.24M (2024P) (+3.9% growth) across natural growth and two strategic product interventions.
- White-Space Subcategory Penetration: Capitalized on the fastest-growing category segment (Organic, exhibiting a 2018–2022 CAGR of ~40%) by simulating and recommending the launch of Herbashine (12% segment share, $336,896 Net Sales, 67% Gross Margin, and $226,639 Gross Profit).
- Price-Pack Architecture (PPA) Format Innovation: Modelled the launch of a high-margin travel/trial format (Starbust Ultra Soft 50ml) priced at $0.075/ml (a 50% premium per ml over the 100ml core SKU), unlocking $265,960 in Net Sales at a 70% Gross Margin.
- Trade Promotion Optimization: Uncovered that the primary volume-driver mechanic (“Buy 2, Get 1 Free”) generated an ROI of -2% (loss-making), whereas threshold and multi-buy mechanics (“Buy 2, Get 20% Off” and “2nd at 50% Off”) delivered +12% and +6% ROI, providing the commercial team with a clear mandate to redirect trade spend.
2. Business Context & Problem Statement
HealthMax operates within a $98.45M MAT shampoo category. While HealthMax commands ~32% aggregate market share across its two brands, portfolio momentum was diverging:
- Starbust (Core Mass): Stagnated at $19.82M retail sales between 2021 and 2022 (0.0% YoY growth), seeing its market value share erode from 24% (2018) down to 20% (2023) under aggressive pressure from competitors such as Harmonix (GreenLeaf) and Diamond Shine (Nature’s Harvest).
- Shinez (Premium Treatment): Expanded from $10.22M (2018) to $11.63M (2022) (+13.4% 5-year growth), reaching a 14% value share. However, monthly sales volatility was heavily dependent on deep, margin-diluting discount promotions.
- Portfolio Gaps: Zero commercial presence in the rapidly expanding Organic subcategory, leaving high-margin white space uncontested.
Primary Objectives
- Evaluate brand health, revenue trends, and competitor market share shifts (2018–2023).
- Conduct an SKU-level profitability matrix to identify core volume engines vs. margin drags.
- Formulate actionable Net Revenue Management (NRM) strategies across Pack-Price Architecture (PPA), Trade Promotion Optimization, and Subcategory Expansion (NPD).
- Build a 2024 strategic revenue forecast and bridge waterfall for executive review.
3. Brand & Market Performance Diagnostic
3.1 HealthMax 5 Year Value & Growth Trajectory (Retail Value)
| Year | Shinez Retail Sales | Shinez YoY Growth | Starbust Retail Sales | Starbust YoY Growth | HealthMax Total Sales | HealthMax YoY Growth |
|---|---|---|---|---|---|---|
| 2018 | $10,219,544 | Baseline | $20,465,725 | Baseline | $30,685,269 | Baseline |
| 2019 | $10,026,886 | -1.9% | $19,234,663 | -6.0% | $29,261,549 | -4.6% |
| 2020 | $10,794,936 | +7.7% | $19,575,997 | +1.8% | $30,370,933 | +3.8% |
| 2021 | $10,891,598 | +0.9% | $19,819,198 | +1.2% | $30,710,796 | +1.1% |
| 2022 | $11,625,500 | +6.7% | $19,817,392 | 0.0% | $31,442,892 | +2.4% |
| Total / CAGR | $53,558,464 | +13.4% (5-yr) | $98,912,975 | -3.0% (5-yr) | $152,471,439 | +2.7% (5-yr) |
3.2 Category Market Share Evolution (2018 vs. 2023)
Analysis of the 24 tracked shampoo brands reveals structural shifts across the market landscape:
- Starbust: Dropped from 24% (2018) to 20% (2023).
- Vitalize (FreshCo): Collapsed from 25% (2018) down to 18% (2023).
- Harmonix (GreenLeaf): Surged from 13% (2018) to 18% (2023), matching Vitalize as the #2 player.
- Shinez (HealthMax): Expanded steadily from 12% (2018) to 14% (2023).
- Diamond Shine (Nature’s Harvest): Fast-growing disruptor, rising from 4% (2018) to 9% (2023).
[!NOTE] Add Imaage Market Share
4. SKU-Level Profitability & Portfolio Matrix (2022 Internal Data)
Evaluating HealthMax’s 10 active commercial SKUs reveals a blended gross margin of 68.5% on $20.48M Net Sales across 5.59M units.
4.1 SKU Economics & Performance Table
4.2 HealthMax Profitability Matrix Insights
Plotting Net Sales Contribution (%) against Gross Margin (%) reveals four distinct portfolio roles:
- Core Engines (High Share, High Margin):
- Shinez Repair 100ml (18.6% Sales, 67.1% Margin) and Starbust Ultra Soft 100ml (17.5% Sales, 71.0% Margin) account for 36.1% of total manufacturer net sales.
- Margin Enhancers (Moderate Share, High Margin):
- Shinez Repair 200ml (71.7% Margin) and Starbust Ultra Soft 200ml (70.0% Margin) deliver strong gross profit per unit ($4.30 and $3.50, respectively) and require upselling focus.
- Underperformers (Low Share, Low Margin):
- Starbust Strong Hair 100ml (4.7% Sales, 64.3% Margin) and 150ml (4.2% Sales, 64.9% Margin) operate below the portfolio margin benchmark (68.5%) and require formula/packaging cost re-engineering or price realignments.
5. Subcategory Dynamics & White-Space Identification
Market volume breakdown across subcategories indicates a shift in consumer demand:
5.1 Subcategory Annual Volume (Units) & YoY Growth Trends
- Strategic Finding: The Organic subcategory expanded by 276% between 2018 and 2022, reaching an MAT of 850,749 units, with an estimated FY24 category volume of 1,020,898 units. HealthMax possessed 0% market share in this high-growth subcategory.
6. Net Revenue Management (NRM) Impementation
Lever 1: Subcategory Expansion (NPD Concept Simulation)
HealthMax evaluated two alternative concepts to enter the projected 1,020,898-unit Organic subcategory in 2024:
| Strategic Metric | Concept A: HerbEssentials | Concept B: Herbashine | Variance / Commercial Decision |
|---|---|---|---|
| Est. Unit Market Share | 10.0% | 12.0% | Herbashine delivers +2.0% (+20,418 units) penetration |
| Est. Units Sold (2024) | 102,090 units | 122,508 units | Higher scale and velocity |
| Net Supplier Price | $3.50 | $2.75 | More competitive price tier for mass adoption |
| Supplier Unit COGS | $1.35 | $0.90 | Superior product formulation economics |
| Net Sales Contribution | $357,314 | $336,896 | Slightly lower net top-line due to price point |
| Gross Profit per Unit | $2.15 | $1.85 | -$0.30/unit |
| Total Gross Profit | $219,493 | $226,639 | +$7,146 (+3.3%) higher total cash profit |
| Gross Margin % | 61.4% | 67.3% | +590 bps higher gross margin efficiency |
Decision: Herbashine was selected for commercial launch. It achieves higher market penetration (12% share), secures higher absolute gross profit ($226.6k), and preserves a 67% margin benchmark, aligning with HealthMax’s corporate profitability threshold.
Lever 2: Price-Pack Architecture (PPA) Format Innovation
To unlock entry-level price points and drive consumer trial without cannibalizing core volume, a 50ml travel/trial format was engineered for the portfolio’s top product: Starbust Ultra Soft.
Format Pack Size Retail Price Net Price Price / mL Gross Margin %
Core Base 100ml $5.00 $3.10 $0.050 71.0%
Extension 50ml $3.75 $2.30 $0.075 70.0%
▲
+50.0% Premium / mLPPA Economics for Starbust Ultra Soft 50ml:
- Retail Price: $3.75 ($0.075/ml vs. $0.050/ml for 100ml) $\rightarrow$ +50% price realization per mL.
- Net Supplier Price: $2.30 | Unit COGS: $0.70.
- Unit Gross Profit: $1.60 | Gross Margin: 70.0%.
- Projected 2024 Trial Volume: 115,635 units.
- Revenue Contribution: +$265,960.04 Net Sales | +$185,016 Gross Profit.
Lever 3: Trade Promotion Optimization (Shinez 2022 Deep-Dive)
An econometric evaluation of Shinez’s promotional calendar was conducted against a calculated non-promoted monthly baseline of $840,836.
Month 04: "Buy 2, Get 1 Free" ──> Uplift: $604,790 │ Spend: $620,000 │ ROI: -2% ✘ (Margin Drag)
Month 08: "Buy 2, Get 20% Off" ──> Uplift: $357,872 │ Spend: $320,000 │ ROI: +12% ✔ (High Return)
Month 11: "2nd at 50% Off" ──> Uplift: $572,810 │ Spend: $540,000 │ ROI: +6% ✔ (Scale & Value)| Promotion # | Promotional Mechanism | Month (2022) | Promoted Sales | Non-Promoted Baseline | Incremental Uplift | Promotion Trade Cost | Net ROI % | Commercial Assessment |
|---|---|---|---|---|---|---|---|---|
| Promo 1 | Buy 2, get 1 free | Month 4 | $1,445,626 | $840,836 | $604,790.44 | $620,000.00 | -2.5% | Value Destructive: Deep discount subsidized pantry loading; failed to cover retailer trade investment. |
| Promo 2 | Buy 2, get 20% off | Month 8 | $1,198,708 | $840,836 | $357,872.44 | $320,000.00 | +11.8% | Highly Efficient: Controlled threshold discount preserved value while generating incremental volume. |
| Promo 3 | 2nd at 50% off | Month 11 | $1,413,646 | $840,836 | $572,810.44 | $540,000.00 | +6.1% | Balanced Engine: Blended effective 25% basket discount drove scale and delivered net positive returns. |
NRM Recommendation: Immediately terminate “Buy 2, Get 1 Free” from the Joint Business Planning (JBP) calendar. Reallocate the $620,000 trade spend into “Buy 2, Get 20% Off” and targeted shopper marketing to optimize overall portfolio trade ROI.
7. 2024 Revenue Bridge & Strategic Waterfall
Using statistical time-series forecasting across historical market data (2018–2022), the category baseline for 2024 was projected at $31,680,085. At HealthMax’s historical retail-to-net realization ratio of 65.13%, this sets an unassisted 2024 baseline Net Sales figure of $20,635,213 (a natural growth increment of +$193,096 over 2023 estimated net sales of $20,442,118).
Layering the NRM strategic initiatives constructs the 2024 Net Revenue Bridge:
Waterfall Component Breakdown
| Strategic Growth Building Block | Net Sales Value | Cumulative Net Sales | % Contrib. to Growth | Strategic Rationale |
|---|---|---|---|---|
| Estimated Net Sales 2023 | $20,442,118.00 | $20,442,118.00 | — | Baseline forecast benchmark. |
| (+) Natural Organic Market Growth | +$193,095.53 | $20,635,213.53 | 24.3% | Category market recovery & baseline momentum (65.13% net-to-retail ratio). |
| (+) NPD: Herbashine Organic Launch | +$336,896.00 | $20,972,109.53 | 42.3% | Capturing 12% share of booming Organic subcategory (122,508 units @ $2.75 Net). |
| (+) PPA: Starbust Ultra Soft 50ml | +$265,960.04 | $21,238,069.57 | 33.4% | Premium trial format capturing new user occasions (115,635 units @ $2.30 Net). |
| Projected Net Sales 2024 | $21,238,070.00 | $21,238,070.00 | 100.0% | +$795,952 Net Expansion (+3.9% YoY Net Growth) |
8. Strategic Commercial Roadmap
Phase 1: Q1 2024 Phase 2: Q2 2024 Phase 3: Q3-Q4 2024
┌──────────────────────────────────────┐ ┌──────────────────────────────────────┐ ┌──────────────────────────────────────┐
│ • Eliminate "Buy 2, Get 1 Free" │ │ • Roll out Starbust Ultra Soft 50ml │ │ • Execute JBP mid-year reviews with │
│ • Reallocate $620k promo spend to │ │ to impulse checkouts & travel sets│ | key retail accounts │
│ "Buy 2, Get 20% Off" mechanics │ │ • Secure end-cap feature displays │ │ • Audit Herbashine rate of sale │
│ • Finalize Herbashine listing with │ │ • Launch Herbashine Organic across │ | against 12% segment share target │
│ key retail partners │ | grocery & pharmacy channels | │ • Value-engineer Starbust Strong │
└──────────────────────────────────────┘ └──────────────────────────────────────┘ └──────────────────────────────────────┘- Promotional Governance & JBP Alignment:
- Mandate an immediate cessation of the “Buy 2, Get 1 Free” promotional mechanic.
- Shift promotional investment toward threshold multi-buys (“Buy 2, Get 20% Off”) and staggered secondary purchase discounts (“2nd at 50% Off”), lifting blended promotional ROI above 8%.
- Retail Execution for PPA Extension (50ml):
- Target convenience stores, travel retail, and impulse checkout displays for Starbust Ultra Soft 50ml.
- Position the format to drive household penetration and cross-sell into the 150ml and 200ml SKUs.
- Organic Launch Plan (Herbashine):
- Prioritize listing Herbashine across top-tier grocers and beauty retailers, aiming for 80% weighted distribution within the first six months.
- Portfolio Pruning & Reformulation:
- Initiate value-engineering for Starbust Strong Hair 100ml and 150ml to reduce unit COGS ($1.00 and $1.30, respectively), lifting product gross margins from ~64% toward the 68.5% portfolio benchmark.