Finance AI Skill
Product Costing Pricing
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,...
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) — material3. 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/year4. 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 months5. 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