Finance AI Skill

Margin Analysis Product Level

Analyze profitability at product, SKU, or service level including gross margin, contribution margin, and fully-loaded margin calculations. Use when evaluating product mix profitability, identifying margin improvement opportunities, pricing decisions, cost s...

Product-Level Margin Analysis

Analyze profitability at the product, SKU, or service level to identify margin improvement opportunities, optimize product mix, and support pricing decisions.

Workflow

Margin Analysis Process

Trigger: Monthly standard review; quarterly deep-dive; ad-hoc for pricing decisions, product launches, or margin alerts:

  1. Revenue data collection: Sales by product/SKU (units, revenue, discounts, returns); pricing by segment/channel; promotional impact.
  2. Direct cost allocation: COGS by SKU (materials, labor, overhead, freight, duty); variable cost identification; standard vs. actual cost.
  3. Gross margin calculation: Revenue − COGS = Gross Profit; margin % by product, category, segment, channel.
  4. Contribution margin analysis: Gross Profit − variable operating costs (shipping, payment processing, support, commissions); contribution per unit.
  5. Fully-loaded margin: Allocate shared/indirect costs (R&D, G&A, marketing) using drivers (revenue %, headcount, units); net margin by product.
  6. Product mix analysis: Revenue and profit contribution by product; ABC analysis (A = top 20% products by profit); cannibalization assessment.
  7. Pricing analysis: Price realization vs. list price; discount analysis by customer/channel; price elasticity assessment; competitor benchmarking.
  8. Action planning: Margin improvement initiatives (cost reduction, price increase, product rationalization, mix shift).

Margin Calculation Framework

MARGIN CALCULATION LAYERS
============================

Layer 1: Gross Margin
  Formula: Gross Margin % = (Revenue − COGS) / Revenue × 100
  COGS includes:
    - Direct materials (raw materials, components, packaging)
    - Direct labor (production labor, assembly, quality control)
    - Manufacturing overhead (factory rent, utilities, depreciation)
    - Freight-in and import duties
    - Third-party manufacturing costs (contract manufacturers)
  Excludes: SG&A, R&D, marketing, distribution (post-factory)
  Benchmark: 40–80% for SaaS; 30–60% for manufacturing; 25–50% for retail

Layer 2: Contribution Margin
  Formula: Contribution Margin = Gross Profit − Variable Operating Costs
  Variable operating costs include:
    - Shipping and fulfillment (per-unit shipping, packaging, handling)
    - Payment processing fees (2.9% + $0.30 per transaction for Stripe)
    - Sales commissions (percentage of revenue or fixed per deal)
    - Customer support (tier 1 support cost per customer/ticket)
    - Returns and allowances (returns rate × average return cost)
    - Third-party licensing (per-unit royalty or usage-based fees)
  Excludes: Fixed operating costs (salaries, rent, software, marketing)
  Benchmark: 20–60% depending on industry and cost structure
  Use case: Short-term decisions (pricing, promotions, product continuation)

Layer 3: Operating Margin (fully-loaded)
  Formula: Operating Margin = Contribution Margin − Allocated Fixed Costs
  Fixed cost allocation methods:
    - Revenue-based: Fixed costs allocated proportional to product revenue
    - Unit-based: Fixed costs allocated proportional to product units sold
    - Driver-based: Fixed costs allocated by specific drivers (headcount, floor space, machine hours)
    - Activity-based costing (ABC): Fixed costs traced to activities; activities traced to products
  Allocation bases:
    - R&D: Revenue % or product-specific engineering hours
    - Marketing: Campaign spend traced to products; remainder by revenue %
    - G&A: Revenue % (simplest) or headcount % (more accurate)
  Benchmark: 5–20% for manufacturing; 10–25% for software; 3–10% for retail
  Use case: Strategic decisions (product line continuation, resource allocation)

Layer 4: Net Margin
  Formula: Net Margin = Operating Margin − Interest − Taxes
  Includes: All costs including interest and taxes
  Use case: Overall product line profitability; investment return assessment
  Benchmark: 2–15% depending on industry

Product-Level Margin Template

PRODUCT-LEVEL MARGIN ANALYSIS — [Month/Quarter Year]
======================================================

Product: [Product Name/SKU]
Period: [Month/Quarter Year]
Category: [Category]
Channel: [Channel]

REVENUE:
  Units sold:                  XX,XXX
  List price:                 $XXX.XX
  Average selling price:      $XXX.XX  (XX% of list)
  Total revenue:              $XXX,XXX
  Less: Discounts and promos: ($XX,XXX)
  Less: Returns:              ($X,XXX)
  Net revenue:                $XXX,XXX

DIRECT COSTS (COGS):
  Direct materials:           ($XX,XXX)  (XX% of revenue)
  Direct labor:               ($X,XXX)   (X% of revenue)
  Manufacturing overhead:     ($XX,XXX)  (XX% of revenue)
  Freight-in and duties:      ($X,XXX)   (X% of revenue)
  Total COGS:                ($XXX,XXX)
  Gross margin:               $XXX,XXX   (XX.X%)

VARIABLE OPERATING COSTS:
  Shipping and fulfillment:   ($X,XXX)   (X.X% of revenue)
  Payment processing:         ($X,XXX)   (X.X% of revenue)
  Sales commissions:          ($X,XXX)   (X.X% of revenue)
  Customer support:           ($X,XXX)   (X.X% of revenue)
  Returns processing:         ($XXX)     (X.X% of revenue)
  Total variable costs:      ($XX,XXX)
  Contribution margin:        $XXX,XXX   (XX.X%)

ALLOCATED FIXED COSTS:
  R&D allocation:             ($X,XXX)   (X.X% of revenue)
  Marketing allocation:       ($X,XXX)   (X.X% of revenue)
  G&A allocation:             ($X,XXX)   (X.X% of revenue)
  Total allocated costs:      ($XX,XXX)
  Operating margin:           $XX,XXX    (XX.X%)

KEY METRICS:
  Gross margin %:             XX.X%  vs. category avg XX.X%  [↑/↓]
  Contribution margin %:      XX.X%  vs. category avg XX.X%  [↑/↓]
  Operating margin %:         XX.X%  vs. category avg XX.X%  [↑/↓]
  Revenue growth YoY:         +X.X%
  Margin trend QoQ:           +X.Xpp  [improving/declining]

Product Mix and Portfolio Analysis

ABC Analysis and Portfolio Matrix

PRODUCT PORTFOLIO ABC ANALYSIS
================================

Method: Rank products by profit contribution (not revenue); classify:

  Category A (Top 20% of products by profit):
    - Contribute 60–80% of total profit
    - Focus: Protect margins; optimize pricing; ensure supply
    - Action: Premium pricing; volume commitments; innovation investment
    - Monitoring: Monthly margin tracking; competitive pricing alerts

  Category B (Next 30% of products by profit):
    - Contribute 15–25% of total profit
    - Focus: Margin improvement; efficiency gains
    - Action: Cost reduction; process optimization; selective price increases
    - Monitoring: Quarterly margin review; cost benchmarking

  Category C (Bottom 50% of products by profit):
    - Contribute 5–15% of total profit (may be unprofitable)
    - Focus: Rationalization; elimination; bundling
    - Action: Phase out unprofitable; bundle with A/B products; outsource
    - Monitoring: Semi-annual review; sunset criteria defined

Portfolio Matrix (Profit vs. Growth):
  ┌─────────────────┬──────────────┬──────────────┐
  │                 │  High Growth │  Low Growth  │
  ├─────────────────┼──────────────┼──────────────┤
  │ High Profit     │  Stars        │  Cash Cows   │
  │                 │ Invest & grow│ Milk & defend│
  ├─────────────────┼──────────────┼──────────────┤
  │ Low Profit      │  Question Marks│ Dogs         │
  │                 │ Fix or divest │ Phase out    │
  └─────────────────┴──────────────┴──────────────┘

  Stars: High profit, high growth → Invest heavily; expand capacity
  Cash Cows: High profit, low growth → Maintain; minimize investment
  Question Marks: Low profit, high growth → Fix pricing/costs or divest
  Dogs: Low profit, low growth → Phase out; discontinue

Pricing and Discount Analysis

PRICE REALIZATION ANALYSIS
============================

List Price vs. Actual Selling Price:
  Product A: List $1,000 → ASP $850 → 85% realization
  Product B: List $500 → ASP $425 → 85% realization
  Product C: List $2,000 → ASP $1,300 → 65% realization ⚠

Discount Analysis by Channel:
  Direct sales:   10–15% average discount (negotiated deals)
  Reseller:       25–35% discount (channel margin)
  Online:         0–5% discount (promotional only)
  Enterprise:     15–25% discount (volume-based)

Discount Impact on Margin:
  List price margin:  60%
  10% discount margin: 54%
  20% discount margin: 43%
  30% discount margin: 31%
  40% discount margin: 19% ⚠

Price Elasticity Assessment:
  Elastic (> 1): Price decrease → revenue increase (demand sensitive)
    Strategy: Competitive pricing; volume focus; promotional discounts
  Inelastic (< 1): Price change has limited demand impact
    Strategy: Price optimization; value-based pricing; margin focus
  Unitary (= 1): Revenue unchanged with price change
    Strategy: Maintain current price; focus on cost reduction

Competitor Price Benchmarking:
  Track: Quarterly comparison of list prices and ASP
  Data sources: Competitor websites, mystery shopping, channel feedback
  Action: Adjust pricing if > 10% deviation from market

Edge Cases

Integration Points