Ma Cvp Break Even

CVP / Break-Even Analysis

Overview

Cost-Volume-Profit analysis determines the relationship between costs, volume, and profit to find the break-even point and plan for target profits. Supports single-product and multi-product scenarios with what-if simulation capabilities.

When to Use This Skill

Use this skill in the following scenarios:

1. Break-Even Point Calculation - Determine the sales volume needed to cover all costs
   • 「損益分岐点を計算して」「何個売れば元が取れる？」
2. New Business/Product Feasibility - Evaluate whether a new venture can be profitable
   • 「新商品の採算シミュレーションをして」「新規事業の損益分岐点を出して」
3. Pricing Decision Support - Analyze the profit impact of price changes
   • 「値上げしたら利益はどう変わる？」「価格設定のシミュレーションをして」
4. Cost Structure Optimization - Evaluate fixed cost reduction or variable cost improvement scenarios
   • 「固定費を削減したらどうなる？」「変動費率を改善した場合の効果は？」
5. What-If / Sensitivity Analysis - Model multiple scenarios for management decision-making
   • 「売上が10%減ったら利益はどうなる？」「What-if分析をして」

Prerequisites

Before running this skill, ensure the following data is available:

• Revenue Data: Selling price per unit and/or total sales amount
• Variable Cost Data: Variable cost per unit or total variable costs
• Fixed Cost Data: Total fixed costs for the analysis period
• Volume Data: Current or projected sales volume (units)
• For Multi-Product: Sales mix ratios for each product

Input Data Format

Single Product:

Multi-Product (CSV):

product_name,selling_price,variable_cost,sales_mix_ratio
Product A,500,300,0.60
Product B,800,500,0.30
Product C,200,120,0.10

Workflow 1: Cost Structure Analysis

1. Identify Cost Behavior: Classify all costs as fixed or variable
2. Calculate Unit Contribution Margin: Unit CM = Selling Price - Variable Cost per Unit
3. Calculate CM Ratio: CM Ratio = Unit CM / Selling Price
4. Assess Cost Structure: Determine operating leverage (fixed cost proportion)
5. For Multi-Product: Calculate weighted average CM ratio using sales mix

Key Formulas

Workflow 2: Break-Even Calculation

1. Break-Even in Units: BEP (units) = Fixed Costs / Unit CM
2. Break-Even in Sales: BEP (sales) = Fixed Costs / CM Ratio
3. Target Profit Sales: Required Sales = (Fixed Costs + Target Profit) / CM Ratio
4. Margin of Safety:
   • Amount: Current Sales - Break-Even Sales
   • Ratio: (Current Sales - BEP) / Current Sales * 100%
5. Multi-Product BEP: Use weighted average CM ratio, note constant sales mix assumption

Margin of Safety Interpretation

Workflow 3: Scenario Analysis & Decision Support

1. Price Change Scenarios: Model profit impact of price increases/decreases
2. Cost Structure Changes: Simulate fixed cost reduction or variable cost improvement
3. Volume Sensitivity: Show profit at different volume levels (e.g., 80%, 90%, 100%, 110%, 120%)
4. Operating Leverage Analysis: How profit changes amplify relative to revenue changes
5. Decision Recommendations: Summarize findings with actionable recommendations

Output

The analysis produces a structured CVP report containing:

1. Cost Structure Summary: Fixed costs, variable costs, CM ratio breakdown
2. Break-Even Analysis: BEP in units and sales, with visualization data
3. Margin of Safety Assessment: Current position relative to break-even
4. Scenario Analysis Table: Multiple what-if scenarios with profit projections
5. Decision Recommendations: Prioritized actions based on analysis

Output template: assets/cvp_analysis_template_ja.md (Japanese) or assets/cvp_analysis_template_en.md (English)

Resources

References (load into context for guidance)

• references/09_break-even-analysis_20251005.md - Break-even analysis fundamentals with practical bakery business examples, margin of safety concepts
• references/10_differential-cost-analysis_20251104.md - Differential cost-revenue analysis for make-or-buy and special order decisions

Assets (templates for output generation)

• assets/cvp_analysis_template_ja.md - Japanese CVP analysis report template
• assets/cvp_analysis_template_en.md - English CVP analysis report template

Best Practices

• Always verify cost classification (fixed vs. variable) - misclassification leads to incorrect BEP
• CVP analysis assumes linear cost behavior within the relevant range
• For multi-product analysis, clearly state the sales mix assumption
• Present margin of safety alongside BEP to convey the risk context
• Include sensitivity analysis - single-point BEP is less useful than a range of scenarios
• Remember CVP limitations: single-period model, constant prices, no inventory changes

Examples

Example: Bakery Break-Even Analysis

Input:

• Selling Price per unit (bread loaf): ¥350
• Variable Cost per unit: ¥150
• Fixed Costs (monthly): ¥600,000
• Current Monthly Volume: 5,000 loaves

Analysis:

• Unit CM: ¥350 - ¥150 = ¥200
• CM Ratio: ¥200 / ¥350 = 57.1%
• BEP (units): ¥600,000 / ¥200 = 3,000 loaves
• BEP (sales): ¥600,000 / 0.571 = ¥1,050,000
• Current Sales: ¥1,750,000
• Margin of Safety: (¥1,750,000 - ¥1,050,000) / ¥1,750,000 = 40.0% (Low Risk)

Scenario Analysis: