Managerial Accounting: Cost-Volume-Profit Analysis

Managerial Accounting: Cost-Volume-Profit Analysis

Learning Objectives

  • 7.1 Calculate the unit contribution margin and the contribution margin ratio.

  • 7.2 Use CVP analysis to find the volume needed to break even or earn a target profit.

  • 7.3 Use CVP analysis to measure the impact of changing business conditions.

  • 7.4 Use CVP analysis at multiproduct companies.

  • 7.5 Determine a firm’s margin of safety, operating leverage, and most profitable cost structure.

  • 7.6 Describe scenario analysis and its uses in cost-volume-profit analysis.

  • 7.7 Apply Excel by using the what-if analysis tool to model profitability changes.

Cost-Volume-Profit (CVP) Analysis Overview

  • Definition: CVP analysis is a powerful tool that assists managers in making informed decisions; it expresses the relationship among costs, volume, and profit.

  • Purpose: CVP analysis helps determine the sales volume required to break even or achieve a target profit.

Components of CVP Analysis

Key Components

  • Sales Price: Price at which goods are sold.

    • Example: Art posters sold for $21.00 each.

  • Volume: Quantity of products sold.

    • Example: Number of posters sold.

  • Variable Costs: Costs that vary with production volume.

    • Example: Cost of each poster from suppliers.

  • Fixed Costs: Costs that remain constant regardless of production volume.

    • Examples: Monthly website maintenance, rent for office space.

  • Profit or Loss: Calculated as sales minus variable and fixed costs.

CVP Assumptions

  • Sales price remains constant at all relevant volumes.

  • Managers can accurately classify costs as either variable or fixed.

  • Inventory levels will not fluctuate.

  • The product mix (proportions of products sold) remains unchanged.

Contribution Margin

Definition

  • Contribution Margin: The excess of sales revenue over variable expenses.

  • Unit Contribution Margin: The excess of selling price per unit over variable cost per unit.

    • All variable costs (product and period) must be accounted for when calculating.
      Example:

    • Selling Price per poster: $35

    • Variable Cost per poster: $21

    • Unit Contribution Margin Calculation:
      ext{Unit Contribution Margin} = ext{Selling Price} - ext{Variable Cost} = 35 - 21 = 14

Contribution Margin Ratio

Definition

  • Contribution Margin Ratio: This ratio is the contribution margin divided by sales revenue.

    • Formula:
      ext{Contribution Margin Ratio} = rac{ ext{Contribution Margin}}{ ext{Sales Revenue}}

    • Unit Contribution Margin Ratio:
      ext{Unit Contribution Margin Ratio} = rac{ ext{Unit Contribution Margin}}{ ext{Sales Price per unit}}

Breakeven Analysis

Breakeven Point

  • Definition: The sales level at which the operating income is zero; total revenues equal total expenses.

  • Indicators:

    • Sales below breakeven point result in a loss.

    • Sales above breakeven point indicate profit.

Methods to Calculate Breakeven Point

  1. Income Statement Approach

  2. Shortcut Approach using Unit Contribution Margin

  3. Shortcut Approach using Contribution Margin Ratio

Target Profit Analysis

Determining Required Sales Volume

  • How many units need to be sold to earn a target profit? The formula depends on contribution margin calculations.

Target Profit Calculations

  • Units required for target profit can be assessed using the unit contribution margin and total fixed costs.

Graphing CVP Relationships

Steps in Graphing

  1. Choose a sales volume and plot total sales revenue at that volume; draw the sales revenue line from the origin.

  2. Draw the fixed expense line as a horizontal line intersecting the y-axis.

  3. Draw the total expense line, which summarizes both variable and fixed expenses.

  4. Identify the breakeven point where sales revenue intersects total expenses.

  5. Mark the operating income and operating loss areas on the graph.

Sensitivity Analysis in CVP

Definition

  • Sensitivity Analysis: A technique to prepare for fluctuations in costs, pricing, and other changing business conditions.

  • What-if Analysis: Assess impacts of changes in variables such as sales price, costs, and sales mix.

Margin of Safety

Definition

  • Margin of Safety: The excess of actual or expected sales over breakeven sales.

    • Indicates the sales drop the company can absorb without incurring losses.

    • A higher margin of safety signifies a less risky operation.

Operating Leverage

Definition

  • Operating Leverage: A measure of how sensitive a company’s operating income is to changes in sales volume.

    • Calculated as the ratio of contribution margin to operating income.

Characteristics

  • High operating leverage indicates higher risk but also potential for higher reward. Examples: hotels, airlines.

  • Low operating leverage indicates lower risk and potential for lower reward. Examples: fast-food restaurants.

Choosing an Optimal Cost Structure

Indifference Point

  • The point at which a company is indifferent between two options because both yield the same total cost.

  • Example: Comparison of leasing options for Kay’s business.

Scenario Analysis

Description

  • Scenario Analysis: The process of analyzing various possible future events by considering alternative scenarios.

    • Scenarios can include base, best, and worst cases.

    • Often implemented using spreadsheet tools such as Microsoft Excel.

Using Excel for What-If Analysis

Steps in Data Analysis

  1. Create a profit calculation using formulas for contribution margin and operating income.

  2. Set up a data table with varying sales prices and volumes depending on the situation to analyze.

  3. Use conditional formatting to highlight specific data points above target profit thresholds in the analysis.