Comprehensive Study Guide for Cost-Volume-Profit (CVP) Analysis

CVP Analysis Fundamentals and Marginal Costing Principles

• Conceptual Foundations:

  • Cost-Volume-Profit (CVP) analysis and marginal costing are two primary tools utilized by management for short-term tactical decision-making.

  • CVP analysis is fundamentally built upon the principles of marginal costing.

• Key Features of Marginal Costing:

  • Cost Segmentation: All costs, whether they are production or non-production related, must be separated into their fixed and variable components.

  • Treatment of Fixed Costs: Marginal costing treats all fixed costs as period costs rather than product costs.

  • Contribution Calculation: The primary metric is "contribution," defined as the difference between sales revenues and total variable costs.

  • Definition of Contribution: $Contribution = Sales\,Revenue - Total\,Variable\,Costs$

• The Break-Even Point (BEP):

  • The center of focus for CVP analysis is the break-even point.

  • Definition: The break-even point is the minimum level of production/activity where total costs are fully covered by total revenues.

  • At this specific level of activity, the total revenues equal total costs ($Total\,Revenues = Total\,Costs$), resulting in an operating income of exactly zero ($Operating\,Income = 0$).

Baker Company: Case Study Data and Initial Requirements

• Original Data Overview:

  • The company sells a single product.

  • Estimated Annual Sales: $6,000\,units$

  • Break-Even Units: $4,000\,units$

• Variable Expenses per Unit:

  • Direct Material: $\$36$

  • Direct Labor: $\$22$

  • Variable Production Overhead: $\$26$

  • Variable Selling and Administrative (S&A) Costs (Non-production): $\$6$

• Fixed Expenses:

  • Fixed Production Overhead: $\$192,000\,per\,year$

  • Fixed Selling and Administrative (S&A): $\$48,000\,per\,year$

• Calculations (Requirement 1):

  • Variable Production Cost per Unit: The sum of direct materials, direct labor, and variable production overhead.

    • $36 + 22 + 26 = \$84$

  • Total Variable Cost per Unit: The sum of variable production costs and variable non-production costs.

    • $84 + 6 = \$90$

    • Note: CVP analysis utilizes the total variable cost per unit ($\$90$), not just the production component ($\$84$).

  • Fixed Production Overhead per Unit: Calculated based on the expected sales volume.

    • $\frac{192,000}{6,000} = \$32$

  • Total Production Cost per Unit: Under total costing (absorption costing), this includes variable manufacturing and fixed manufacturing overhead as product costs.

    • $36 + 22 + 26 + 32 = \$116$

  • Total Fixed Costs: The sum of all fixed production and non-production components.

    • $192,000 + 48,000 = \$240,000$

Determination of Selling Price

• Requirement 2: Calculating Selling Price (SP) per Unit:

  • Approach 1: Income Statement Equation at Break-Even:

    • $Sales\,Revenue - Total\,Variable\,Costs - Total\,Fixed\,Costs = Operating\,Income$

    • At break-even, operating income is $0$.

    • Using break-even units ($4,000$):

    • $4,000(SP) - (4,000 \times 90) - 240,000 = 0$

    • $4,000(SP) - 360,000 - 240,000 = 0$

    • $4,000(SP) - 600,000 = 0$

    • $4,000(SP) = 600,000$

    • $SP = \frac{600,000}{4,000} = \$150$

  • Approach 2: Contribution Margin Method:

    • $Break-Even\,Units = \frac{Total\,Fixed\,Costs}{Contribution\,per\,Unit}$

    • $4,000 = \frac{240,000}{SP - 90}$

    • $4,000 \times (SP - 90) = 240,000$

    • $4,000(SP) - 360,000 = 240,000$

    • $4,000(SP) = 600,000$

    • $SP = \$150$

• Lowest Acceptable Price Concept:

  • This is the price at which the entity covers all its variable and fixed costs (Operating Income = 0).

  • Formula: $Fixed\,Cost\,per\,Unit + Variable\,Cost\,per\,Unit$

  • Calculation for Baker Company:

    • Fixed cost per unit at expected sales: $\frac{240,000}{6,000} = \$40$

    • Total Variable cost per unit: $\$90$

    • $40 + 90 = \$130$

  • The selling price of $\$150$ is $\$20$ above the minimum price required to cover costs.

Financial Statements and Performance Ratios

• Requirement 3: Contribution Margin Statement (Year Ended Dec 31, 2024):

  • Sales Revenue ($6,000 \times 150$): $\$900,000$

  • Less Variable Costs:

    • Variable Production ($6,000 \times 84$): $\$504,000$

    • Variable S&A ($6,000 \times 6$): $\$36,000$

    • Total Variable Cost: $\$540,000$

  • Contribution Margin ($900,000 - 540,000$): $\$360,000$

  • Less Total Fixed Costs:

    • Fixed Production: $\$192,000$

    • Fixed S&A: $\$48,000$

    • Total Fixed Cost: $\$240,000$

  • Operating Income: $\$120,000$

• Requirement 4: Contribution to Sales Ratio (CMR):

  • Per Unit Basis: $\frac{Contribution\,per\,unit}{Selling\,Price\,per\,unit} = \frac{60}{150} = 0.40\,or\,40\%$

  • Total Basis: $\frac{360,000}{900,000} = 0.40\,or\,40\%$

  • Economic Meaning: A CMR of $40\%$ implies that variable costs represent $60\%$ of sales revenue ($100\% - 40\% = 60\%$

• Requirement 5: Break-Even Point in Dollars:

  • Formula: $\frac{Total\,Fixed\,Costs}{Contribution\,to\,Sales\,Ratio}$

  • Calculation: $\frac{240,000}{0.4} = \$600,000$

  • Alternative Calculation: $Break-Even\,Units \times Selling\,Price = 4,000 \times 150 = \$600,000$

Margin of Safety (MOS)

• Measure of Risk: The margin of safety indicates how far sales can drop before the company incurs a loss (the "cushion").

• MOS in Units: $Expected\,Sales - Break-Even\,Sales$

  • $6,000 - 4,000 = 2,000\,units$

• MOS in Dollars: $MOS\,units \times Selling\,Price$

  • $2,000 \times 150 = \$300,000$

  • Alternatively: $Total\,Sales\,Dollars - Break-Even\,Sales\,Dollars = 900,000 - 600,000 = \$300,000$

• MOS Percentage: $\frac{MOS\,units}{Expected\,Sales\,units}$ or $\frac{MOS\,dollars}{Total\,Sales\,dollars}$

  • $\frac{2,000}{6,000} = 33.33\%$

Graphical Analysis: Traditional Break-Even Chart

• Assumptions: Revenues and costs are linear functions, and the entity sells everything it makes (no inventory changes).

• Scale Requirements:

  • X-axis (Quantity): $2\,cm = 1,000\,units$

  • Y-axis (Revenue/Costs): $2\,cm = \$100,000$

  • Note: On a standard chart where a big square is $2\,cm$ with $10$ tiny squares, each tiny square on the Y-axis represents $\$10,000$.

• Coordinate Generation Table:     | Units | Fixed Cost | Variable Cost ($90 \times Q$) | Total Cost | Revenue ($150 \times Q$) |     | :--- | :--- | :--- | :--- | :--- |     | 0 | $\$240,000$ | $\$0$ | $\$240,000$ | $\$0$ |     | 6,000 | $\$240,000$ | $\$540,000$ | $\$780,000$ | $\$900,000$ |

• Constructing the Graph:

  1. Expected Sales Line: Draw a vertical line at $6,000\,units$.

  2. Fixed Cost Line: A horizontal line starting at $\$240,000$ on the Y-axis, extending parallel to the X-axis.

  3. Total Cost Line: Connect the point $(0, 240,000)$ to the point $(6,000, 780,000)$.

  4. Total Revenue Line: Connect the origin $(0, 0)$ to the point $(6,000, 900,000)$.

• Graph Interpretations:

  • Profit Area: The region to the right of the break-even point where Revenue > Total Cost.

  • Loss Area: The region to the left of the break-even point where Total Cost > Revenue.

  • Break-Even Point: Where the Total Revenue line intersects the Total Cost line ($4,000\,units$ and $\$600,000$).

Planning for Profit

• Requirement 7: Target Operating Income of $\$90,000$:

  • Equation Method:

    • $150(Q) - 90(Q) - 240,000 = 90,000$

    • $60(Q) = 240,000 + 90,000$

    • $60(Q) = 330,000$

    • $Q = 5,500\,units$

  • Contribution Margin Method:

    • $Target\,Units = \frac{Total\,Fixed\,Costs + Target\,Profit}{Contribution\,per\,Unit}$

    • $Target\,Units = \frac{240,000 + 90,000}{60} = 5,500\,units$

  • Evaluation: This goal is realistic as the expected sales ($6,000\,units$) exceed the target requirement ($5,500\,units$).

• Requirement 8: Impact of Decreased Fixed Expenses (Decrease by $\$18,000$):

  • New Total Fixed Costs: $240,000 - 18,000 = \$222,000$

  • New Break-Even Units: $\frac{222,000}{60} = 3,700\,units$

  • New Break-Even Dollars: $3,700 \times 150 = \$555,000$

  • Business Impact: A lower break-even point increases the margin of safety, reducing risk.

Advanced Scenarios and Profit Pressures

• Requirement 9: Complex Sensitivity Analysis:

  • Variables Changes:

    • Direct Material decrease of $\$5$: New variable cost per unit = $90 - 5 = \$85$

    • Sales volume decrease of $10\%$: New expected units = $6,000 \times 0.9 = 5,400\,units$

    • Fixed Cost increase of $\$85,800$: New fixed costs = $240,000 + 85,800 = \$325,800$

    • Target Profit: $\$90,000$

  • Calculation for New Selling Price (SP):

    • $5,400(SP) - (5,400 \times 85) - 325,800 = 90,000$

    • $5,400(SP) - 459,000 - 325,800 = 90,000$

    • $5,400(SP) - 784,800 = 90,000$

    • $5,400(SP) = 874,800$

    • $SP = \$162$

  • The company must increase the price by $\$12$ (from $\$150$ to $\$162$) to achieve the target profit under these new conditions.

• Bonus Challenge: 50% Increase in Operating Income:

  • Objective: Increase original operating income ($\$120,000$) by $50\%$.

  • New Target Profit: $120,000 \times 1.5 = \$180,000$

  • Assumptions: Fixed costs ($\$240,000$), variable costs ($\$90$), and volume ($6,000$) remain unchanged.

  • Calculation for Required SP:

    • $6,000(SP) - (6,000 \times 90) - 240,000 = 180,000$

    • $6,000(SP) - 540,000 - 240,000 = 180,000$

    • $6,000(SP) - 780,000 = 180,000$

    • $6,000(SP) = 960,000$

    • $SP = \$160$