คู่มือโดยละเอียดเร็วๆ นี้
เรากำลังจัดทำคู่มือการศึกษาที่ครอบคลุมสำหรับ CVP Analysis Calculator กลับมาเร็วๆ นี้เพื่อดูคำอธิบายทีละขั้นตอน สูตร ตัวอย่างจริง และเคล็ดลับจากผู้เชี่ยวชาญ
Cost-Volume-Profit (CVP) analysis is a managerial accounting technique that examines the relationship between a company's costs, the volume of products or services sold, and the resulting profit. It provides a structured framework for understanding how changes in any one of these variables ripple through to the bottom line, making it an indispensable tool for planning, decision-making, and performance evaluation. CVP analysis is built on the contribution margin concept: for every unit sold, revenue first covers variable costs, and the remaining contribution margin goes toward covering fixed costs. Once fixed costs are fully covered, each additional unit's contribution margin flows directly to operating profit. This binary structure — covering fixed costs first, then generating profit — is what gives CVP analysis its power. Key metrics derived from CVP analysis include the contribution margin per unit, the contribution margin ratio (CMR), the break-even point (BEP), the margin of safety, the degree of operating leverage (DOL), and the target volume needed to achieve any specified profit goal. Sensitivity analysis, which tests how results change with small variations in assumptions, is a natural extension of CVP. The model assumes linearity: selling price and variable cost per unit are constant, and fixed costs are fixed within the relevant range of activity. These assumptions simplify reality but are reasonable within normal operating bounds. More sophisticated versions use non-linear cost functions or incorporate income taxes by solving for the required pre-tax profit that yields a desired after-tax result. CVP analysis is widely applied in diverse settings: manufacturers use it to evaluate capacity expansion, retailers use it for pricing and product mix decisions, service firms use it for staffing models, and entrepreneurs use it to determine if a business concept is financially viable. It is one of the most practically useful analytical frameworks in all of business finance.
Operating Profit = (P − VC) × Q − FC = CM × Q − FC DOL = Contribution Margin / Operating Income Target Q = (FC + Target Profit) / CM
- 1Determine the selling price per unit, variable cost per unit, and total fixed costs for the planning period.
- 2Calculate contribution margin per unit: CM = P − VC, and contribution margin ratio: CMR = CM / P.
- 3Compute break-even quantity: BEP = FC / CM, and BEP revenue: BEP$ = FC / CMR.
- 4For any given volume Q, calculate operating profit: Profit = CM × Q − FC.
- 5To find the volume needed for a target profit (before tax): Q = (FC + Target Profit) / CM. For after-tax target: Q = (FC + Target Profit After Tax / (1 − Tax Rate)) / CM.
- 6Calculate degree of operating leverage at planned volume: DOL = (CM × Q) / ((CM × Q) − FC).
- 7Perform sensitivity analysis by varying price, volume, or costs by small percentages and observing the profit impact, guided by the DOL.
At BEP, DOL is theoretically infinite
CM = $80 − $30 = $50; CMR = 62.5%. BEP = $100,000 / $50 = 2,000 units. To earn $50,000 profit: Q = ($100,000 + $50,000) / $50 = 3,000 units. At 3,000 units: revenue = $240,000, total variable costs = $90,000, CM = $150,000, operating profit = $50,000. DOL = $150,000 / $50,000 = 3.0x, meaning a 10% increase in sales produces a 30% increase in operating profit.
Always gross up after-tax target before applying CVP formula
First, convert after-tax target to pre-tax: $60,000 / (1 − 0.30) = $85,714. CM = $120 − $45 = $75. Required volume = ($150,000 + $85,714) / $75 = 3,143 units. Revenue = 3,143 × $120 = $377,143. Contribution = 3,143 × $75 = $235,714. Operating profit = $235,714 − $150,000 = $85,714. After-tax = $85,714 × (1 − 0.30) = $60,000.
10% price cut causes 50% profit drop — leverage magnification
Base CM = $30; base profit = ($30 × 3,000) − $60,000 = $30,000. After 10% price cut: new price = $45, new CM = $25, new profit = ($25 × 3,000) − $60,000 = $15,000. Profit dropped 50% on a 10% price cut. DOL at base = ($30 × 3,000) / $30,000 = 3.0x, which predicted: 10% sales $ change × 3.0 DOL = 30% profit change — but the price cut is a direct CM reduction (worse than a volume decrease), illustrating the extreme sensitivity of profit to pricing.
New fixed costs push BEP exactly to current volume — no margin of safety
CM = $60; base BEP = $120,000 / $60 = 2,000 units; base profit at 2,500 = $30,000. After adding $30,000 fixed costs: new FC = $150,000; new BEP = $150,000 / $60 = 2,500 units. At the existing volume of 2,500, the company now breaks even with zero profit and zero margin of safety. To restore $30,000 profit, volume must reach 3,000 units. This analysis shows how capacity expansions can significantly raise the revenue hurdle.
Annual profit planning and budgeting for business units, enabling practitioners to make well-informed quantitative decisions based on validated computational methods and industry-standard approaches, which requires precise quantitative analysis to support evidence-based decisions, strategic resource allocation, and performance optimization across diverse organizational contexts and professional disciplines
New product launch feasibility and pricing analysis, helping analysts produce accurate results that support strategic planning, resource allocation, and performance benchmarking across organizations, where accurate numerical computation is essential for producing reliable outputs that inform planning, evaluation, and continuous improvement processes in both corporate and individual settings
Evaluating the financial impact of wage increases or cost savings initiatives, allowing professionals to quantify outcomes systematically and compare scenarios using reliable mathematical frameworks and established formulas, demanding systematic calculation approaches that translate raw input data into actionable insights for stakeholders who depend on quantitative rigor in their daily professional activities
Acquisition due diligence — assessing target's profit sensitivity, supporting data-driven evaluation processes where numerical precision is essential for compliance, reporting, and optimization objectives, necessitating robust computational methods that deliver consistent and verifiable results suitable for reporting, auditing, and long-term trend analysis in professional environments
Capacity expansion decisions in manufacturing and hospitality, which requires precise quantitative analysis to support evidence-based decisions, strategic resource allocation, and performance optimization across diverse organizational contexts and professional disciplines
{'case': 'Loss-Making Operation', 'explanation': "When a business operates below break-even, increasing volume reduces per-unit fixed cost absorption but doesn't flip the profitability until BEP is reached. Shutting down is only preferable if revenues don't even cover variable costs (contribution is negative)."}. Professionals working with cost volume profit should be especially attentive to this scenario because it can lead to misleading results if not handled properly. Always verify boundary conditions and cross-check with independent methods when this case arises in practice.
avoidable fixed costs when deciding to drop a product. If discontinuation eliminates only variable costs but fixed costs remain, the 'savings' may be illusory and overall profitability may worsen."}. Professionals working with cost volume profit should be especially attentive to this scenario because it can lead to misleading results if not handled properly. Always verify boundary conditions and cross-check with independent methods when this case arises in practice.
Professionals working with cost volume profit should be especially attentive to this scenario because it can lead to misleading results if not handled properly. Always verify boundary conditions and cross-check with independent methods when this case arises in practice.
| Change | Effect on CM | Effect on BEP | Effect on Profit |
|---|---|---|---|
| Increase selling price | Increases | Decreases | Increases |
| Decrease selling price | Decreases | Increases | Decreases |
| Increase variable cost/unit | Decreases | Increases | Decreases |
| Decrease variable cost/unit | Increases | Decreases | Increases |
| Increase fixed costs | No change | Increases | Decreases |
| Decrease fixed costs | No change | Decreases | Increases |
| Increase volume | No change | No change | Increases (CM × ΔQ) |
What is the degree of operating leverage and why does it matter?
The degree of operating leverage (DOL) measures how sensitive operating income is to changes in sales. DOL = Contribution Margin / Operating Income. A DOL of 4.0 means that a 10% increase in sales will produce a 40% increase in operating income, and vice versa for declines. High DOL reflects a cost structure dominated by fixed costs — which magnifies both gains and losses. Airlines, manufacturers, and capital-intensive businesses typically have high DOL. Service and retail businesses with more variable cost structures have lower DOL and steadier earnings.
How does CVP analysis change when income taxes are included?
When incorporating income taxes, CVP analysis requires you to work backward from the desired after-tax profit to the required pre-tax profit. The formula is: Required Pre-Tax Profit = Desired After-Tax Profit / (1 − Tax Rate). Then use this pre-tax profit in the standard CVP formula: Volume = (Fixed Costs + Required Pre-Tax Profit) / CM per unit. This adjustment is critical for accurate planning because the volume needed to achieve a specific net income after taxes is significantly higher than a simple before-tax calculation would suggest.
What is the relevant range in CVP analysis?
The relevant range is the span of activity within which the CVP assumptions hold: fixed costs remain fixed, variable costs remain constant per unit, and selling price is stable. Outside the relevant range, fixed costs may step up (e.g., needing a new facility), variable costs may change (volume discounts), or price may vary. CVP analysis should only be applied within the relevant range of expected operations. When considering a major expansion or contraction, you must redefine the relevant range and re-estimate all cost parameters.
How is CVP analysis used in pricing decisions?
CVP analysis quantifies the volume trade-off of any pricing change. If you cut price by 10%, contribution margin drops, and you can calculate exactly how many additional units must be sold to maintain the same total profit. Similarly, a price increase raises CM per unit, so you can afford to lose some volume and still end up ahead. This framework turns pricing decisions from guesswork into mathematically grounded choices — you know exactly what volume increase is needed to justify a discount, and whether that level of demand response is realistic.
Can CVP analysis be used for service businesses with no physical units?
Yes. For service businesses, the 'unit' can be any meaningful measure: a billable hour, a patient visit, a delivery, a consulting project, or a subscription. Variable costs are those that scale with service delivery (clinician time, supplies used per visit), while fixed costs are those independent of volume (office lease, management salaries, insurance). Once these are identified, the CVP formula works identically. Many service businesses have very high CMRs because incremental service delivery costs are minimal relative to the fee charged.
What is the margin of safety, and how is it calculated?
The margin of safety is the amount by which actual or budgeted sales exceed the break-even point. It represents how much sales can fall before the company incurs a loss. In units: MOS = Budgeted Units − BEP Units. As a percentage: MOS% = (Budgeted Sales − BEP Sales) / Budgeted Sales × 100. A higher margin of safety is always desirable as it provides a larger buffer against revenue downturns. Companies with high operating leverage should closely monitor their margin of safety, as it decreases rapidly when revenue falls.
How does a change in sales mix affect CVP analysis results?
In multi-product CVP analysis, the overall break-even and profit depend on the weighted-average contribution margin, which is determined by the sales mix. If the mix shifts toward higher-margin products, the weighted CM rises, lowering the BEP and increasing profit. A shift toward lower-margin products has the opposite effect. For this reason, even when total unit volume is maintained, a change in product mix can significantly change profitability. Sales teams should understand that not all revenue is equally valuable — selling more of the high-margin product line has disproportionate profit impact.
เคล็ดลับโปร
Plot the CVP chart (revenue and total cost vs. volume) alongside a profit-volume chart. Together they provide a complete visual picture of your business's profit sensitivity across the full range of possible sales volumes.
คุณรู้ไหม?
CVP analysis was formally developed as a management tool in the early 20th century by engineers at companies like DuPont, who needed to understand how their large fixed-cost chemical plants would perform at different production levels. The DuPont financial model (which also gave us ROE decomposition) is one of the earliest systematic applications of these principles.