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, 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

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.