Skip to main content
Business LibreTexts

3.4: Perform Break-Even Sensitivity Analysis for a Single Product Under Changing Business Situations

  • Page ID
    5195
  • Finding the break-even point or the sales necessary to meet a desired profit is very useful to a business, but cost-volume-profit analysis also can be used to conduct a sensitivity analysis, which shows what will happen if the sales price, units sold, variable cost per unit, or fixed costs change. Companies use this type of analysis to consider possible scenarios that assist them in planning.

    LINK TO LEARNING

    Watch this video that shows what happens if one or more of the variables in a break-even analysis is changed to learn more.

    The Effects on Break-Even under Changing Business Conditions

    Circumstances often change within a company, within an industry, or even within the economy that impact the decision-making of an organization. Sometimes, these effects are sudden and unexpected, for example, if a hurricane destroyed the factory of a company’s major supplier; other times, they occur more slowly, such as when union negotiations affect your labor costs. In either of these situations, costs to the company will be affected. Using CVP analysis, the company can predict how these changes will affect profits.

    Changing a Single Variable

    To demonstrate the effects of changing any one of these variables, consider Back Door Café, a small coffee shop that roasts its own beans to make espresso drinks and gourmet coffee. They also sell a variety of baked goods and T-shirts with their logo on them. They track their costs carefully and use CVP analysis to make sure that their sales cover their fixed costs and provide a reasonable level of profit for the owners.

    Change in Sales Price

    The owner of Back Door has one of her employees conduct a survey of the other coffee shops in the area and finds that they are charging $0.75 more for espresso drinks. As a result, the owner wants to determine what would happen to operating income if she increased her price by just $0.50 and sales remained constant, so she performs the following analysis:

    Price Change Analysis: With Current Price, With New Price (respectively): Sales Price per Unit $3.75, $4.25; Variable Cost per Unit 1.50, 1.50; Contribution Margin per Unit $2.25, $2.75; Fixed Costs $2,475, $2,475; Break-even in Units 1,100, 900; Break-even in Dollars $4,125, $3,825. Contribution Margin Income Statement: Current Price, New Price (respectively): Unit Sales Expected 1,500, 1,500; Sales $5,625, $6,375; Variable Costs 2,250, 2,250; Contribution Margin $3,375, $4,125; Fixed Costs 2,475, 2,475; Net Income $900, $1,650.

    The only variable that has changed is the $0.50 increase in the price of their espresso drinks, but the net operating income will increase by $750. Another way to think of this increase in income is that, if the sales price increases by $0.50 per expresso drink and the estimated sales are 1,500 units, then this will result in an increase in overall contribution margin of $750. Moreover, since all of the fixed costs were met by the lower sales price, all of this $750 goes to profit. Again, this is assuming the higher sales price does not decrease the number of units sold. Since the other coffee shops will still be priced higher than Back Door, the owner believes that there will not be a decrease in sales volume.

    When making this adjustment to their sales price, Back Door Café is engaging in target pricing, a process in which a company uses market analysis and production information to determine the maximum price customers are willing to pay for a good or service in addition to the markup percentage. If the good can be produced at a cost that allows both the desired profit percentage as well as deliver the good at a price acceptable to the customer, then the company should proceed with the product; otherwise, the company will not achieve its desired profit goals.

    Change in Variable Cost

    In March, the owner of Back Door receives a letter from her cups supplier informing her that there is a $0.05 price increase due to higher material prices. Assume that the example uses the original $3.75 per unit sales price. The owner wants to know what would happen to net operating income if she absorbs the cost increase, so she performs the following analysis:

    Variable Cost Change Analysis: With Current Price, With Increased Variable Cost (respectively): Sales Price per Unit $3.75, $3.75; Variable Cost per Unit 1.50, 1.55; Contribution Margin per Unit $2.25, $2.20; Fixed Costs $2,475, $2,475; Break-even in Units 1,100, 1,125; Break-even in Dollars $4,125, $4,218.75. Monthly Contribution Margin Income Statement: Current Variable Cost, Increased Variable Costs (respectively): Unit Sales Expected 1,500, 1,500; Sales $5,625, $5,625; Variable Costs 2,250, 2,325; Contribution Margin $3,375, $3,300; Fixed Costs 2,475, 2,475; Net Income $900, $825.

    She is surprised to see that just a $0.05 increase in variable costs (cups) will reduce her net income by $75. The owner may decide that she is fine with the lower income, but if she wants to maintain her income, she will need to find a new cup supplier, reduce other costs, or pass the price increase on to her customers. Because the increase in the cost of the cups was a variable cost, the impact on net income can be seen by taking the increase in cost per unit, $0.05, and multiplying that by the units expected to be sold, 1,500, to see the impact on the contribution margin, which in this case would be a decrease of $75. This also means a decrease in net income of $75.

    Change in Fixed Cost

    Back Door Café’s lease is coming up for renewal. The owner calls the landlord to indicate that she wants to renew her lease for another 5 years. The landlord is happy to hear she will continue renting from him but informs her that the rent will increase $225 per month. She is not certain that she can afford an additional $225 per month and tells him she needs to look at her numbers and will call him back. She pulls out her CVP spreadsheet and adjusts her monthly fixed costs upwards by $225. Assume that the example uses the original $3.75 per unit sales price. The results of her analysis of the impact of the rent increase on her annual net income are:

    Fixed Cost Change Analysis: With Current Price, With Increased Fixed Cost (respectively): Sales Price per Unit $3.75, $3.75; Variable Cost per Unit 1.50, 1.50; Contribution Margin per Unit $2.25, $2.25; Fixed Costs $2,475, $2,700; Break-even in Units 1,100, 1,200; Break-even in Dollars $4,125, $4,500. Monthly Contribution Margin Income Statement: Current Fixed Costs, Increased Fixed Costs (respectively): Unit Sales Expected 1,500, 1,500; Sales $5,625, $5,625; Variable Costs 2,250, 2,250; Contribution Margin $3,375, $3,375; Fixed Costs 2,475, 2,700; Net Income $900, $675.

    Because the rent increase is a change in a fixed cost, the contribution margin per unit remains the same. However, the break-even point in both units and dollars increase because more units of contribution are needed to cover the $225 monthly increase in fixed costs. If the owner of the Back Door agrees to the increase in rent for the new lease, she will likely look for ways to increase the contribution margin per unit to offset this increase in fixed costs.

    In each of the prior examples, only one variable was changed—sales volume, variable costs, or fixed costs. There are some generalizations that can be made regarding how a change in any one of these variables affects the break-even point. These generalizations are summarized in Table 3.1.

    Generalizations Regarding Changes in Break-Even Point from a Change in One Variable

    Condition Result
    Sales Price Increases Break-Even Point Decreases (Contribution Margin is Higher, Need Fewer Sales to Break Even)
    Sales Price Decreases Break-Even Point Increases (Contribution Margin is Lower, Need More Sales to Break Even)
    Variable Costs Increase Break-Even Point Increases (Contribution Margin is Lower, Need More Sales to Break Even)
    Variable Costs Decrease Break-Even Point Decreases (Contribution Margin is Higher, Need Fewer Sales to Break Even)
    Fixed Costs Increase Break-Even Point Increases (Contribution Margin Does Not Change, but Need More Sales to Meet Fixed Costs)
    Fixed Costs Decrease Break-Even Point Decreases (Contribution Margin Does Not Change, but Need Fewer Sales to Meet Fixed Costs)

    Table3.1

    LINK TO LEARNING

    Watch this video that walks through, step by step, how to calculate break even in units and dollars and at a desired profit or sales level to learn more.

    Changing Multiple Variables

    We have analyzed situations in which one variable changes, but often, more than one change will occur at a time. For example, a company may need to lower its selling price to compete, but they may also be able to lower certain variable costs by switching suppliers.

    Suppose Back Door Café has the opportunity to purchase a new espresso machine that will reduce the amount of coffee beans required for an espresso drink by putting the beans under higher pressure. The new machine will cost $15,000, but it will decrease the variable cost per cup by $0.05. The owner wants to see what the effect will be on the net operating income and break-even point if she purchases the new machine. She has arranged financing for the new machine and the monthly payment will increase her fixed costs by $400 per month. When she conducts this analysis, she gets the following results:

    Variable Cost and Fixed Cost Change Analysis: With Current Price, With Decreased VC and Increased FC (respectively): Sales Price per Unit $3.75, $3.75; Variable Cost per Unit 1.50, 1.45; Contribution Margin per Unit $2.25, $2.30; Fixed Costs $2,475, $2,875; Break-even in Units 1,100, 1250; Break-even in Dollars $4,125, $4,687.50. Contribution Margin Income Statement: Current Fixed Costs, Increased Fixed Costs (respectively): Unit Sales Expected 1,500, 1,500; Sales $5,625, $5,625; Variable Costs 2,250, 2,175; Contribution Margin $3,375, $3,450; Fixed Costs 2,475, 2,875; Net Income $900, $575.

    Looking at the “what-if” analysis, we see that the contribution margin per unit increases because of the $0.05 reduction in variable cost per unit. As a result, she has a higher total contribution margin available to cover fixed expenses. This is good, because the monthly payment on the espresso machine represents an increased fixed cost. Even though the contribution margin ratio increases, it is not enough to totally offset the increase in fixed costs, and her monthly break-even point has risen from $4,125.00 to $4,687.50. If the new break-even point in units is a realistic number (within the relevant range), then she would decide to purchase the new machine because, once it has been paid for, her break-even point will fall and her net income will rise. Performing this analysis is an effective way for managers and business owners to look into the future, so to speak, and see what impact business decisions will have on their financial position.

    Let’s look at another option the owner of the Back Door Café has to consider when making the decision about this new machine. What would happen if she purchased the new machine to realize the variable cost savings and also raised her price by just $0.20? She feels confident that such a small price increase will go virtually unnoticed by her customers but may help her offset the increase in fixed costs. She runs the analysis as follows:

    Selling Price, Variable Cost, and Fixed Cost Change Analysis: With Current Price, With Decreased VC and Increased FC, With Increased SP Decreased VC and Increased FC (respectively): Sales Price per Unit $3.75, $3.75, $3.95; Variable Cost per Unit 1.50, 1.45, 1.45; Contribution Margin per Unit $2.25, $2.30, $2.50; Fixed Costs $2,475, $2,875, $2,875; Break-even in Units 1,100, 1,250, 1,150; Break-even in Dollars $4,125, $4,687.50, $4,542.50. Contribution Margin Income Statement: With Current Price, With Decreased VC and Increased FC, With Increased SP Decreased VC and Increased FC (respectively): Unit Sales Expected 1,500, 1,500, 1,500; Sales $5,625, $5,625, 5,925; Variable Costs 2,250, 2,175, 2,175; Contribution Margin $3,375, $3,450, $3,750; Fixed Costs 2,475, 2,875, 2,875; Net Income $900, $575, 875.

    The analysis shows the expected result: an increase in the per-unit contribution margin, a decrease in the break-even point, and an increase in the net operating income. She has changed three variables in her costs—sales price, variable cost, and fixed cost. In fact, the small price increase almost gets her back to the net operating income she realized before the purchase of the new expresso machine.

    By now, you should begin to understand why CVP analysis is such a powerful tool. The owner of Back Door Café can run an unlimited number of these what-if scenarios until she meets the financial goals for her company. There are very few tools in managerial accounting as powerful and meaningful as a cost-volume-profit analysis.

    CONCEPTS IN PRACTICE

    Value Menus

    In January 2018, McDonald’s brought back its $1 value menu. After discontinuing its popular Dollar Menu six years previously, the new version has a list of items priced not only at $1, but at $2 and $3 as well. How can McDonald’s afford to offer menu items at this discounted price? Volume! Although the margin on each unit is very small, the food chain hopes to make up the difference in quantity. They also hope that consumers will add higher priced (and higher margin) items to their orders.1 The strategy is not without its risks, however, as rising food or labor costs could put franchisees in a position where the value pricing does not cover their product costs. Rivals Taco Bell and Dunkin’ Donuts have aggressively marketed their value menus, making it almost impossible for McDonald’s to ignore the growing trend among consumers for “value pricing.” Watch this video to see what McDonald’s is offering consumers.

     

    Footnotes