--- name: product-costing-pricing description: Determine product costs using absorption costing, variable costing, activity-based costing, or standard costing methods. Calculate break-even points, target costs, and minimum pricing thresholds. Use when establishing product costs, setting pricing floors, performing cost-plus pricing, standard cost maintenance, variance analysis on product costs, or make-vs-buy analysis. Triggers on phrases like "product cost", "cost of goods sold", "COGS calculation", "absorption costing", "variable costing", "standard cost", "target costing", "break-even analysis", "minimum price", "cost floor", "make vs buy", "cost-plus pricing", "BOM cost", "cost build-up". --- # Product Costing & Pricing Determine product costs using various costing methodologies, calculate pricing floors and break-even points, and support cost-plus and target-based pricing decisions. ## Workflow ### 1. Cost Build-Up Framework ``` PRODUCT COST BUILD-UP ═══════════════════════════════════════ Product: Enterprise Software License with Hosting DIRECT MATERIALS (External Costs): ═══════════════════════════════════════ Component Unit Cost Qty Total ───────────────────────────────────────────────────────────── Cloud hosting (AWS) $0.50/hr 8,760 $4,380 Third-party API licenses $0.10/call 50,000 $5,000 Database license (per seat) $120/yr 1 $120 Payment processing (per tx) $0.30 1,000 $300 CDN/bandwidth $0.02/GB 500 GB $10 ───────────────────────────────────────────────────────────── Total Direct Materials: $9,810 DIRECT LABOR: ═══════════════════════════════════════ Activity Rate Hours Total ───────────────────────────────────────────────────────────── Customer onboarding specialist $50/hr 10 hrs $500 Implementation engineer $75/hr 5 hrs $375 Technical support (annual avg) $45/hr 20 hrs $1,000 ───────────────────────────────────────────────────────────── Total Direct Labor: $1,875 MANUFACTURING/OPERATING OVERHEAD: ═══════════════════════════════════════ Applied using allocation rate: $0.85 per direct labor hour (Derived from total overhead $2.55M / total DLH 3,000 = $850/DLH) Wait, let me recalculate properly: Total annual overhead: $2,550,000 Allocation base: Customer support hours (12,000 hrs/year) Allocation rate: $2,550,000 / 12,000 = $212.50 per support hour Per-unit overhead: $212.50 × 20 hours = $4,250 Alternatively, by revenue-based allocation: Total overhead: $2,550,000 Revenue from this product line: $5,000,000 (500 units × $10,000) Overhead rate: 51% of revenue Per-unit overhead: $10,000 × 51% = $5,100 Using support-hour method: $4,250 TOTAL PRODUCT COST (Absorption Costing): ═══════════════════════════════════════ Direct Materials: $9,810 Direct Labor: $1,875 Overhead (allocated): $4,250 ───────────────────────────────────────────── TOTAL PRODUCT COST: $15,935 Per-unit cost at volume of 500 units: $31.87 per unit per year ANNUAL COST PER CUSTOMER: $15,935 (for one annual license) ``` ### 2. Standard Cost vs Actual Cost Variance ``` STANDARD COST CARD — Product SKU-001 ═══════════════════════════════════════ Cost Element Standard Qty Std Price Std Cost Actual Qty Actual Price Actual Cost ────────────────────────────────────────────────────────────────────────────────────────────────── Cloud Hosting 8,760 hrs $0.50/hr $4,380 9,200 hrs $0.52/hr $4,784 API Licenses 50,000 calls $0.10/call $5,000 48,000 calls $0.10/call $4,800 Database License 1 seat $120/seat $120 1 seat $120/seat $120 Payment Proc. 1,000 txns $0.30/txn $300 1,100 txns $0.32/txn $352 ────────────────────────────────────────────────────────────────────────────────────────────────── Total Materials: $9,800 $10,056 DIRECT LABOR VARIANCE: ═══════════════════════════════════════ Onboarding: Standard: 10 hrs × $50/hr = $500 Actual: 12 hrs × $52/hr = $624 Price variance: (52-50) × 12 = $24 U (unfavorable) Quantity variance: (12-10) × 50 = $100 U Support: Standard: 20 hrs × $45/hr = $900 Actual: 25 hrs × $45/hr = $1,125 Price variance: (45-45) × 25 = $0 Quantity variance: (25-20) × 45 = $225 U TOTAL VARIANCES: ═══════════════════════════════════════ Materials Price Variance: ($456) U (actual prices higher than standard) Materials Usage Variance: ($220) U (higher consumption than standard) Labor Price Variance: ($24) U (higher wage rates) Labor Efficiency Variance: ($325) U (more hours than standard) Overhead Variance: ($520) U (actual overhead higher than applied) ───────────────────────────────────────────────────────────────────── TOTAL UNFAVORABLE VARIANCE: ($1,545) VARIANCE ANALYSIS: → $1,545 represents 9.7% of standard cost ($15,935) → Material price variance driven by cloud rate increase (AWS price hike) → Labor efficiency variance from increased onboarding complexity → ACTION: Update standard costs; renegotiate cloud pricing VOLUME IMPACT (at 500 units): → Total unfavorable variance: $1,545 × 500 = $772,500 → This erodes gross margin by $772,500 → Represents 1.5% of revenue ($50M) — material ``` ### 3. Break-Even and Pricing Analysis ``` BREAK-EVEN AND MINIMUM PRICING ANALYSIS ═══════════════════════════════════════ PRODUCT: Enterprise Software License COST STRUCTURE (annual per customer): ═══════════════════════════════════════ Variable Costs (per customer/year): → Cloud hosting: $4,380 → API licenses: $5,000 → Payment processing: $300 → CDN/bandwidth: $10 → Support (variable): $1,000 Total Variable Cost: $10,690 Fixed Costs (annual, total): → Engineering team: $800,000 → Product marketing: $200,000 → Sales team (base): $600,000 → Executive overhead: $300,000 → Facilities: $150,000 → Tools/licenses: $100,000 Total Fixed Cost: $2,150,000 BREAK-EVEN ANALYSIS: ═══════════════════════════════════════ Given pricing: $10,000/customer/year Contribution margin per unit: $10,000 - $10,690 = ($690) PER UNIT ⚠ BREAK-EVEN ANALYSIS REVEALS: VARIABLE COSTS EXCEED PRICE! At current pricing ($10,000), the product loses $690 per customer on a variable cost basis. This is NOT sustainable. CORRECTED ANALYSIS (if pricing is per-seat, not per-customer): → Average customer has 20 seats → Price per seat: $500/year → Revenue per customer: $10,000 → Variable cost is ALREADY calculated per customer The issue: Variable costs ($10,690) > Revenue ($10,000) → NEGATIVE contribution margin: ($690)/customer BREAK-EVEN PRICING: ═══════════════════════════════════════ Minimum price to cover variable costs: $10,690/customer Break-even units (including fixed costs): BEP = Fixed Costs / (Price - Variable Cost) At $10,690 price: BEP = $2,150,000 / $0 = ∞ (no break-even possible) At $12,000 price: CM per unit: $12,000 - $10,690 = $1,310 BEP = $2,150,000 / $1,310 = 1,641 customers At $15,000 price: CM per unit: $15,000 - $10,690 = $4,310 BEP = $2,150,000 / $4,310 = 499 customers At $20,000 price: CM per unit: $20,000 - $10,690 = $9,310 BEP = $2,150,000 / $9,310 = 231 customers COST-PLUS PRICING (20% margin target): ═══════════════════════════════════════ Full cost per customer (at 500 units): Variable cost: $10,690 Fixed cost/unit: $2,150,000 / 500 = $4,300 Total cost: $14,990 Price with 20% margin: Target price = Total cost / (1 - 0.20) = $14,990 / 0.80 = $18,738 Recommended price range: $18,000-$20,000/year ``` ### 4. Make vs Buy Analysis ``` MAKE VS BUY ANALYSIS — Customer Support Function ═══════════════════════════════════════ CURRENT STATE (Make): In-house support team of 10 agents MAKE (In-House): ═══════════════════════════════════════ Costs (annual): Salaries (10 agents × $45K): $450,000 Benefits (30% of salaries): $135,000 Training (annual): $50,000 Management (1 lead × $80K): $80,000 Tools/Software: $30,000 Facilities (allocated): $40,000 Turnover cost (15% × $45K): $67,500 ─────────────────────────────────────────── TOTAL MAKE COST: $852,500 Quality metrics (in-house): → CSAT: 4.5/5.0 → FCR: 85% → Response time: 2 hours BUY (Outsource to BPO): ═══════════════════════════════════════ Options: Option A: Shared BPO (multi-client) Cost per agent/month: $2,500 10 equivalent agents: $300,000/year Management fee (15%): $45,000 Transition costs: $50,000 (one-time) ─────────────────────────────────── TOTAL: $395,000/year (+ $50K one-time) Quality metrics (estimated): → CSAT: 3.8/5.0 → FCR: 75% → Response time: 4 hours Option B: Dedicated BPO (single-client) Cost per agent/month: $3,800 10 equivalent agents: $456,000/year Management fee (10%): $45,600 Transition costs: $80,000 (one-time) ─────────────────────────────────── TOTAL: $501,600/year (+ $80K one-time) Quality metrics (estimated): → CSAT: 4.2/5.0 → FCR: 80% → Response time: 3 hours FINANCIAL COMPARISON: ═══════════════════════════════════════ Option Annual Cost One-Time Savings vs Quality Make Impact ─────────────────────────────────────────────────────────────────── In-house (current) $852,500 $0 $0 Baseline Shared BPO $395,000 $50,000 $457,500 -15% quality Dedicated BPO $501,600 $80,000 $350,900 -7% quality ─────────────────────────────────────────────────────────────────── QUALITY-ADJUSTED ANALYSIS: → CSAT decline of 0.7 points (shared) → estimated churn increase 5% → Revenue at risk from churn: $250,000/year → Net benefit of shared BPO: $457,500 - $250,000 = $207,500 → Dedicated BPO quality loss minimal; net benefit: $350,900 - $50,000 = $300,900 RECOMMENDATION: Dedicated BPO ($501.6K/year) → Saves $351K/year vs in-house → Minimal quality degradation → Scalable for peak periods → Payback on transition cost: 2.8 months ``` ### 5. Target Costing ``` TARGET COSTING — New Product Development ═══════════════════════════════════════ MARKET-DRIVEN APPROACH: Price first, then work backward to allowable cost. MARKET RESEARCH INPUTS: ═══════════════════════════════════════ Competitive landscape: → Competitor A price: $18,000 → Competitor B price: $22,000 → Competitor C price: $15,000 → Market average: $18,333 Target price (positioned between A and B): $19,000 TARGET MARGIN: 35% (company strategic target) TARGET COST CALCULATION: ═══════════════════════════════════════ Target Price: $19,000 Less: Target Margin: ($6,650) [35%] ────────────────────────────────────── TARGET COST: $12,350 CURRENT ESTIMATED COST: $15,200 GAP TO CLOSE: ($2,850) [-23.4%] COST REDUCTION OPPORTUNITIES: ═══════════════════════════════════════ Cost Element Current Cost Target Cost Reduction Method ────────────────────────────────────────────────────────────────────── Cloud hosting $4,380 $3,500 $880 Reserved instances, spot instances API licenses $5,000 $3,500 $1,500 Open-source alternatives Support cost $1,000 $700 $300 Self-service tools Tools/software $300 $150 $150 Negotiate volume Other costs $4,520 $4,500 $20 Efficiency gains ────────────────────────────────────────────────────────────────────── TOTAL $15,200 $12,350 $2,850 100% FEASIBILITY ASSESSMENT: ═══════════════════════════════════════ → $880 cloud savings: FEASIBLE (migrate to reserved instances, 6-month transition) → $1,500 API savings: PARTIAL (switch 2 APIs to open-source; save $1,000) → $300 support savings: FEASIBLE (implement chatbot, reduce tier-1 by 30%) → $150 software savings: FEASIBLE (consolidate tools) → $20 other savings: FEASIBLE (efficiency) Realistic target cost achievable: $12,500 (slightly above target) Adjusted price: $19,200 or accept 34.3% margin (still acceptable) ``` ## Edge Cases - **Joint products**: Allocate shared production costs by relative market value or physical measures - **By-products**: Net realizable value of by-products offsets main product cost - **Seasonal demand**: Fixed cost allocation varies by volume; use annualized rates - **R&D costs**: Typically period costs, not product costs (unless capitalized per ASC 350) - **Freemium model**: Track cost of free users vs paying users separately ## Integration Points - **ERP**: SAP, Oracle (standard cost maintenance, BOM management) - **Cost accounting**: Activity-based costing systems, ABC software - **PLM**: Product lifecycle management (BOM, engineering changes) - **ERP financial modules**: COGS tracking, variance reporting - **Pricing systems**: Cost-based pricing floor calculations - **ERP manufacturing modules**: Standard cost roll-ups ## Output ### Product Costing Summary ``` PRODUCT COST SUMMARY — SKU-001 ═══════════════════════════════════════ Total product cost: $15,935/year per customer → Variable costs: $10,690 (67%) → Fixed costs: $4,300 (27%) [at 500-unit volume] → Overhead: $945 (6%) Current pricing: $10,000/year (NEGATIVE contribution margin!) Minimum viable price: $10,690 (covers variable costs) Break-even price (at 500 units): $14,990 Recommended price: $18,000-$20,000 (20-35% margin) Action required: URGENT — pricing does not cover variable costs ```