Circulos AI

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 structure analysis, product line rationalization, or customer profitability analysis. Triggers on phrases like "product margin", "SKU profitability", "contribution margin", "gross margin by product", "product mix analysis", "margin improvement", "cost-to-serve", "fully-loaded margin", "product profitability", "line item margin".

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

Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.