## Sensitivity Analysis

### Learning Outcomes

• Demonstrate how changes in the cost-volume-profit equation affect profit.

Sensitivity analysis shows how the CVP model will change with changes in any of its variables (e.g., changes in fixed costs, variable costs, sales price, or sales mix). The focus is typically on how changes in variables will alter profit.

For BlankBooks, Inc., the monthly break-even point is 2,000 units, and the company must sell 2,900 units to achieve a target profit of $1,530. Let’s assume management believes a goal of 2,900 units is overly optimistic and settles instead on a more reasonable goal of 2,500 units in monthly sales. This is called the base case. The base case is summarized as follows in the contribution margin income statement format, using the following assumptions (the same ones we have been using):  Bindings$5.00 each Pages (preassembled, ready to bind) $1.00 each Labor per piece assembled$2.00 each Sales Salary $2,000.00 per month Commission 3% each Internet and web site$200.00 per month Production facility rent $1,200.00 per month Sales Price$10.00 each

-

Although management believes the base case is reasonably accurate, it is concerned about what will happen if certain variables change. As a result, you are asked to address the following questions from management (you are now performing sensitivity analysis!). Each scenario is independent of the others. Unless told otherwise, assume that the variables used in the base case remain the same. How do you answer the following questions for management?

• Scenario 1: How will profit change if the sales price increases by 2 percent?
• Scenario 2: How will profit change if sales volume decreases by 10 percent?
• Scenario 3: How will profit change if fixed costs decrease by 60 percent and variable costs increase by 10 percent?

Let’s assume all of these scenarios are independent of each other.

### Scenario 1: sales price increases by 2 percent

Mathematically, the increase is represented by 1.00 + 0.02 = 1.02 (the entire sales price = 1, and the increase in the price = 0.02)

Therefore, a 2% increase in sales price = $10.00 * 1.02 =$10.20.

Plugging this revised sales price into our model, we get:

-

### Scenario 3: fixed costs decrease by 60 percent and variable costs increase by 10 percent

Mathematically, the decrease in fixed costs is represented by 1.00 – 0.60 = 0.40 (the entire fixed costs = 1, and the reduction = -0.60), and the increase in variable costs is represented by 1.00 + 0.10 (the entire variable cost = 1, and the increase = 0.10)

Therefore, a 0% decrease in fixed costs = $3,400 * 0.40 =$1,360, and a 10% increase in variable costs = $8.30 * 1.10 =$9.13, which is the same as (1 * 8.3) + ( 0.10 * 8.3) = 8.3 + 0.83 = 9.13.

Plugging these revised fixed and variable costs into our model, we get:

-

This shows that a 10% increase in variable costs, from $8.30 to$9.13, is not even offset by a robust 60% decrease in fixed costs, from $3,400 to$1,360. Our model is sensitive to increases in variable costs because the margin on each unit is so small.

Let’s see a side by side summary of these scenarios:

-

As you can see, once the model is established, you can quickly answer a wide variety of what-if scenarios.

Sensitivity analysis shows how the cost-volume-profit model will change with changes in any of its variables. Although the focus is typically on how changes in variables affect profit, accountants often analyze the impact on the break-even point and target profit as well.

Now, let’s check your understanding of sensitivity analysis.