--- name: margin-analysis-product-level description: 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 - **Negative contribution margin products**: - Product loses money on every unit sold (variable costs > revenue) - Immediate action: Price increase or cost reduction - If cannot fix: Discontinue or reposition (bundle with profitable product) - Exception: Loss leader strategy (intentional negative margin to drive other purchases) - Validation: Loss leader must drive incremental profitable purchases (measurable uplift) - Monitoring: Track cross-sell rate from loss leader to profitable products - **Seasonal product margin fluctuation**: - Peak season: Higher volume → lower unit cost (economies of scale) → higher margin - Off-season: Lower volume → higher unit cost → lower margin (or negative) - Strategy: Price adjustment (premium in peak, discount in off-peak) - Inventory: Build inventory in off-season (when cost lower) for peak season - Cash flow: Margin surplus in peak funds off-season operations - **Bundled product margin attribution**: - Challenge: Bundle price may not reflect individual product margins - Attribution: Allocate bundle revenue to products based on standalone value (SSP) - Example: $1,000 bundle of Product A (SSP $700) + Product B (SSP $500) → Allocate: A = $1,000 × 700/1200 = $583; B = $1,000 × 500/1200 = $417 - Analysis: Compare allocated margin to standalone margin for each product - Risk: Bundle may make unprofitable product appear profitable (allocation artifact) - **Customer-specific margin variation**: - Same product sold at different margins to different customers - Drivers: Negotiated pricing, volume discounts, relationship terms, channel margins - Analysis: Margin by product × customer matrix - Action: Identify low-margin customers; renegotiate pricing or reduce service level - Risk: Customer loss if pricing increased; balance margin improvement with retention - **Product cannibalization**: - New product steals sales from existing product (typically higher-margin) - Detection: Declining sales of older product coinciding with new product launch - Analysis: Net margin impact = New product margin − Cannibalized margin - Strategy: Differentiate products (features, price, target segment) - Acceptance: Some cannibalization is acceptable if total portfolio margin increases ## Integration Points - **ERP/GL**: NetSuite, SAP, Oracle — product-level COGS, revenue by SKU, inventory valuation - **CRM**: Salesforce, HubSpot — revenue by product × customer, pricing data, discount approvals - **PIM systems**: Akeneo, Salsify — product master data, attributes, categorization - **Pricing tools**: PROsight, Pricefx, Vendored — price optimization, discount management, competitor benchmarking - **BI tools**: Tableau, Power BI, Looker — margin dashboards, product profitability analysis, portfolio visualization - **Cost accounting**: ERP cost modules, activity-based costing systems — standard cost, actual cost, variance analysis - **E-commerce platforms**: Shopify, WooCommerce — SKU-level revenue, returns, promotions - **Supply chain**: Blue Yonder, Kinaxis — cost-to-serve analysis, fulfillment costs, inventory carrying costs - **Data warehouse**: Snowflake, BigQuery — centralized product data, historical margin trends, ML-based margin prediction - **Procurement**: Coupa, SAP Ariba — supplier cost data, raw material pricing, contract terms