CVP and Breakeven Analyses

6.1 Break-even Analysis

A. Introduction

One of the primary goals of many businesses is to make a profit. Achieving this goal requires that total revenue surpasses the total costs incurred. As such, it becomes essential for business owners to carefully examine variables like the selling price per unit, the quantity of products sold, and the relationship between total revenue and costs. A powerful tool to aid this understanding is the Cost-Volume-Profit (CVP) analysis.

A part of CVP analysis looks at the ‘break-even point’. This represents the sales volume at which total revenue exactly equals total costs, resulting in a balance where neither profit nor loss is realized. This type of analysis is known as break-even analysis.

While the break-even point serves as a foundational benchmark, most businesses want to do better than just breaking even. They want to earn a profit. Therefore, understanding the impact of sales on earnings is important. Furthermore, to be competitive in the market, businesses try to set competitive selling prices and look into ways to lower their costs to increase profitability. This chapter will delve into these critical aspects of business decision-making, looking at how CVP and break-even analyses can help businesses make these decisions.

B. Compute Break-even Point Using Break-even Analysis

Imagine Sarah, who has started a small business selling hand-made candles. Each candle costs her $5 to make (materials), and she sells them for $25 each. Sarah also has fixed costs, which include her monthly rent for the workshop, totaling $2000 a month. Before she can make any profit, Sarah needs to know how many candles she must sell to cover her costs, or in other words, to break even. Table 5.1.1 summarizes the revenue, cost, and profit for Sarah’s business based on the different numbers of candles sold in a given month.

Table 5.1.1: Revenue, cost, and profit for different numbers of candles sold in a given month

Number of Candles 0 10 100 200
Total Revenue (TR) 0 10($25) = $250 $2500 $5000
   Cost of Materials (TVC) 0 10($5) = $50 $500 $1000
   Rent (FC) $2000 $2000 $2000 $2000
Total Costs (TC) $2000 $50 + $2000 = $2050 $2500 $3000
Net Income (NI)  -$2000 (Loss) -$1800 (Loss) 0 (Break-even) +$2000 (Profit)

Note that at the point where 100 candles are sold, the net income is zero. This is recognized as the break-even point, a point where total revenue precisely matches total costs, resulting in a net income of zero. Selling fewer than 100 units (e.g., 0 and 10 candle cases) results in a financial loss, whereas selling more than the break-even point of 100 units (such as the 200 candle case) ensures a profit.

C. CVP Assumptions

To streamline our discussion on CVP and break-even analyses, let us establish some foundational assumptions:

  1. Selling Price: The price at which we sell each unit remains the same, so as we sell more, our total revenue increases at a consistent rate.
  2. Costs categories and behavior: Costs are linear and can be classified as either fixed or variable cost
    • Fixed costs remain constant over a given time period. They do not depend on volume and remain unchanged throughout a specific time period. Examples include rent, mortgage, property taxes, and salaries.
    • Variable costs are constant per unit regardless of volume. Some of the examples are direct material, labor costs, and sales commissions.
  3. Inventory: All units produced in a particular operating period are sold, i.e., there is no inventory.
  4. Multiple products: When multiple products are produced within a business, the ratio of various products remains constant.

Note that in reality, fixed costs don’t always remain the same across different levels of production; they can change. Similarly, the unit variable cost can vary, often due to economies of scale. Furthermore, it’s not always clear-cut to label costs as either fixed or variable. Some costs have elements of both and are termed semi-fixed costs or mixed costs.

D. CVP Formulas

The CVP analysis focuses on profitability. In its simplest form, the income statement shows that profit is the result of subtracting total costs (TC) from total revenue (TR). This profit is commonly known as net income (NI) or operating income.

[asciimath]"Net Income" = "Total Revenue" - "Total Costs"[/asciimath]

Or

 [asciimath]NI=TR-TC[/asciimath]Formula 6.1

Assuming the business only sells one product, the total revenue is the product of the unit selling price and the number of units sold or volume. Given [asciimath]"SP"[/asciimath] represents the selling price and [asciimath]X[/asciimath] the volume (quantity), the total revenue can be written as

 [asciimath]TR=SP*X[/asciimath]Formula 6.2

Formula 6.2 is referred to as the total revenue function. 

The total costs are the sum of the total variable costs (TVC) and the fixed costs (FC).

 [asciimath]TC=TVC+FC[/asciimath]Formula 6.3

The total variable costs can be written in terms of the variable cost per unit (VC) and the volume (X).

 [asciimath]TVC=VC*X[/asciimath]Formula 6.4

Substituting Formula 6.4 into Formula 6.3 yields

 [asciimath]TC=VC*X+FC[/asciimath]Formula 6.5

Formula 6.5 is called the total cost function. Now plugging Formulas 6.2 and 6.5 into Formula 6.1 gives

 [asciimath]NI=(SP*X)-(VC*X+FC)[/asciimath]Formula 6.6a

Formula 6.6a is referred to as the net income function and it shows the relationship among net income (NI), the unit selling price (SP), unit variable cost (VC), fixed costs (FC), and volume (X).

E. Compute Break-even Point Using Break-even Analysis

The breakeven point (BP) is the point at which a business neither makes a profit nor incurs a loss. Therefore, to find out the quantity needed to break even, you can use Formula 6.6a and set the net income (NI) to zero.

 [asciimath]0= SP*X-(VC*X+FC)[/asciimath]Formula 6.6b

Alternatively, we can use the fact that at break-even total costs are equal to the total revenue.

[asciimath]TR=TC[/asciimath]

 [asciimath]SP*X=VC*X+FC[/asciimath]Formula 6.6c

 

Both Formulas 6.6b and 6.6c give the quantity at the breakeven point. The break-even point may be expressed in various ways such as

  • number of units 
  • total revenue at break-even units, or
  • as a percent of capacity.

When Unit Selling Price And Variable Cost Are Known

In most cases, the unit selling price and the unit variable cost are known. Therefore, the values are directly input in Formula 6.6b and the volume is solved for.

 

Example 6.1.1: Compute Break-even Point with Known Unit Selling Price and Variable Cost

Margaret runs a business that makes custom-printed shirts. It will cost her $7 each to purchase and print on shirts, and she will have to pay a rent of $1,596 per month for her workshop. Based on market research, Margaret estimates that she can sell custom shirts for $26 each. a) Find the revenue function. b) Find the cost function. c) Calculate the number of shirts she needs to sell per month to break even. d) Calculate the break-even in dollars (round off to the nearest cent).

Show/Hide Solution

 

The selling price is $26, so [asciimath]SP=$26[/asciimath]

The variable cost per t-shirt is $7, so [asciimath]VC=$7[/asciimath]

The only fixed cost is the workshop rent, so [asciimath]FC=$1596[/asciimath]

a) Total revenue function is given by Formula 6.2:

 [asciimath]TR=SP*X[/asciimath]

[asciimath]TR=26X[/asciimath]

b) Total cost function is given by Formula 6.5:

 [asciimath]TC=VC*X +FC[/asciimath]

 [asciimath]TC=7X+1596[/asciimath]

c) To find the quantity at break-even, we can use Formula 6.6b or use the fact that at break-even total costs equals the total revenue (Formula 6.6c) and solve for [asciimath]X[/asciimath]:

 [asciimath]TR=TC[/asciimath]

[asciimath]26X=7X+1596[/asciimath]

[asciimath](26-7)X=1596[/asciimath]

[asciimath]19X=1596[/asciimath]

[asciimath]X=1596/19[/asciimath]

 [asciimath]X=84[/asciimath]

Therefore, Margaret needs to sell 84 T-shirts to break even.

d) Break-even in dollars is the total revenue at break-even quantity ([asciimath]X=84[/asciimath])

 [asciimath]TR=26*X[/asciimath]

 [asciimath]TR=26(84)[/asciimath]

 [asciimath]=$2184[/asciimath]

 

Try an Example

 

 

Example 6.1.2: Compute Break-even Point with Known Unit Selling Price and Variable Cost

A product can be sold at $50 per unit. Cost analysis provides the following information:

  • Rent per period = $6640
  • Utilities per period = $1100
  • Insurance per period = $900
  • Manufacturing cost per unit = $12
  • Labour costs per unit = $18
  • Production capacity per period = 900 units

Perform a break-even analysis. Provide:

(a) algebraic functions of the total revenue, the total cost, and net income,

(b) computation of the break-even point in units,

(c) computation of break-even point in dollars, and

(d) computation of break-even point as a percent of capacity.

Show/Hide Solution

 

The selling price is $50, so [asciimath]SP=$50[/asciimath]

Costs provided on a per-unit basis represent variable costs. The variable cost per unit consists of the manufacturing cost per unit and the labor cost per unit, so [asciimath]VC=$12+$18=$30[/asciimath]

Costs stated on a per-period basis are classified as fixed costs. The fixed costs are the sum of rent, utilities, and insurance, so [asciimath]FC=$6640+$1100+$900[/asciimath] [asciimath]=$8640[/asciimath]

a) The total revenue function is given by Formula 6.2:

 [asciimath]TR=SP*X[/asciimath]

 [asciimath]TR=50X[/asciimath]

The total cost function is given by Formula 6.5:

 [asciimath]TC=VC*X +FC[/asciimath]

 [asciimath]TC=30X+8640[/asciimath]

The net income function is given by Formula 6.6a:

 [asciimath]NI=SP*X-(VC*X +FC)[/asciimath]

 [asciimath]NI=50X-(30X+8640)[/asciimath]

[asciimath]NI=50X-30X-8640[/asciimath]

 [asciimath]NI=20X-8640[/asciimath]

b) To find the quantity at break-even, we can use Formula 6.6b or Formula 6.6c. We can also use the net income function, set the net income to zero, and solve for [asciimath]X[/asciimath]:

 [asciimath]NI=20X-8640[/asciimath]

 [asciimath]0=20X-8640[/asciimath]

 [asciimath]20X=8640[/asciimath]

 [asciimath]X=8640/20[/asciimath]

 [asciimath]X=432[/asciimath]

Therefore, the break-even volume is 432 units.

c) Break-even in dollars is the total revenue at break-even quantity ([asciimath]X=432[/asciimath])

 [asciimath]TR=50X[/asciimath]

 [asciimath]TR=50(432)[/asciimath]

 [asciimath]=$21,600[/asciimath]

d) To find the break-even point as a percent capacity, divide the quantity at the break-even point by the quantity at the capacity and convert the quotient to percent.

Break-even as a percent of capacity [asciimath]= 432/900[/asciimath]

[asciimath]=0.48[/asciimath]

 [asciimath]= 48%[/asciimath]

 

When Unit Selling Price And Variable Cost Are Unknown

The relationship between total variable costs (TVC) and total revenue (TR) can be expressed as a constant ratio, equivalent to the ratio of unit variable costs (VC) to the selling price (SP). This is represented as:

[asciimath](TVC)/(TR)=(VC*X)/(SP*X)[/asciimath]

Simplifying this, we get:

 [asciimath](TVC)/(TR)=(VC)/(SP)[/asciimath]

In cases where we only have the total dollar values without specific unit selling prices or variable costs, we can still determine the break-even point in dollar terms (i.e., the total revenue at the break-even point) rather than in units. By assuming a unit selling price (SP) of $1, we can then calculate the unit variable cost (VC) as follows:

[asciimath](TVC)/(TR)=(VC)/1[/asciimath]

[asciimath]VC = (TVC)/(TR)[/asciimath]

 

Using the assumed SP of $1 and the calculated VC value, we can apply Formula 6.6c to find ‘X’, where ‘X’ now represents the total revenue at the break-even point, rather than the number of units sold.

 

Example 6.1.3: Compute Break-even Point with Unknown Unit Selling Price and Variable Cost

Comfort Furnishings Inc. had a total revenue of $146,400 last year. Its total variable costs and fixed costs for the period were $25,150 and $31,500, respectively. Compute the break-even point in sales dollars.

Show/Hide Solution

 

Total revenue is $146,400, so [asciimath]TR=$146,400[/asciimath]
Total variable costs are $25,150 so [asciimath]TVC=$25,150[/asciimath]
Fixed costs are $31,500 so [asciimath]FC=$31,500[/asciimath]

Since unit selling price and variable cost are unknown, we assume [asciimath]SP=$1[/asciimath] and [asciimath]VC=(TVC)/(TR)=25150/146400~~$0.1718[/asciimath]

Plugging SP, VC, and FC into Formula 6.6b gives

 [asciimath]$1X=$0.1718X+31,500[/asciimath]

 [asciimath]1X-0.1718X=31,500[/asciimath]

 [asciimath](1-0.1718)X=31,500[/asciimath]

 [asciimath]0.8282X=31,500[/asciimath]

 [asciimath]X=(31,500)/0.8282[/asciimath]

 [asciimath]X=$38,034.291...[/asciimath]

 [asciimath]~~$38,034.29[/asciimath] Rounded to the nearest cent

 

Try an Example

 

Section 6.1 Exercises

  1. A company sells a product for $76 each. The variable costs are $23 per unit and fixed costs are $34,768 per month. a) Find the revenue function. b) Find the cost function. c) Calculate the number of units needed to be sold per month to break even. d)  Calculate the revenue at the break-even point.
    Show/Hide Answer

     

    a) [asciimath]TR = 76X[/asciimath]

    b) [asciimath]TC = 23X+34,768[/asciimath]

    c) [asciimath]X=656[/asciimath]  units

    d) [asciimath]TR=$49,856[/asciimath]

  2. Femto Laser Tech. had a total revenue of $103,050 last year. Its total variable costs and fixed costs for the period were $25,300 and $17,150, respectively. Compute the break-even point in sales dollars.
    Show/Hide Answer

     

    [asciimath]TR = $22,730.65[/asciimath]

  3. Wendy runs a business that makes custom bags. It will cost her $9 each to purchase the needed materials, and she will have to pay a rent of $1,188 per month for her workshop. Based on market research, Wendy estimates that she can sell each bag for $21. a) Calculate the number of bags she needs to sell per month to break even. b) Calculate the break-even point in dollars.
    Show/Hide Answer

     

    a) [asciimath]X=99[/asciimath] bags

    b) [asciimath]TR = $2,079[/asciimath]

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Mathematics of Finance Copyright © 2024 by Amir Tavangar is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book