Sensitivity analysis

Welcome to Sensitivity Analysis!

Hello there! Welcome to one of the most practical parts of your P1 journey. In the real world, management accountants rarely have a crystal ball. When we predict that a project will make a profit of $50,000, we are making a lot of guesses—about prices, costs, and how many customers will walk through the door. Sensitivity Analysis is our way of asking: "How wrong can our guesses be before this project turns into a disaster?"

By the end of these notes, you’ll be able to calculate exactly how much "wiggle room" a project has and identify which parts of a plan are the most dangerous. Don’t worry if the math seems a bit dry at first; we’ll break it down into simple steps!

What is Sensitivity Analysis?

In short, Sensitivity Analysis is a "what-if" technique. It looks at the variables in a decision (like selling price or labor costs) and calculates how much they can change before the project reaches the break-even point (where profit is zero).

Analogy: Imagine you are planning an outdoor picnic. Your "profit" is your happiness. One variable is the weather. Sensitivity analysis would ask: "How many degrees can the temperature drop before I stop enjoying myself and go home?" If your happiness is very "sensitive" to the weather, a tiny cloud might ruin your day!

Key Term: The "Ceteris Paribus" Rule

When we perform sensitivity analysis, we change only one variable at a time while keeping everything else the same. This is known as ceteris paribus. It helps us see the impact of that specific factor in isolation.

Quick Review: Sensitivity Analysis helps management understand the risk of a project by showing how "sensitive" the profit is to changes in individual variables.

How to Calculate Sensitivity

In your P1 exam, you will likely need to calculate the sensitivity of a specific variable. The result is usually expressed as a percentage. The lower the percentage, the more sensitive (and therefore riskier) that variable is.

The General Formula

For most variables, we use this simple logic:
\n\(\text{Sensitivity (\%)} = \frac{\text{Estimated Profit (or NPV)}}{\text{Total value of the variable being tested}} \times 100\%\)

Alternatively, you can think of it as:
\n\(\text{Sensitivity (\%)} = \frac{\text{How much the variable can change before profit is zero}}{\text{The original estimate of that variable}} \times 100\%\)

Step-by-Step Breakdown for Different Variables

1. Sales Volume: This tells us how much our sales quantity can drop before we stop making money.
\n\(\text{Sensitivity of Volume} = \frac{\text{Total Profit}}{\text{Total Contribution}} \times 100\%\)

2. Selling Price: This is often the most sensitive variable in any business.
\n\(\text{Sensitivity of Price} = \frac{\text{Total Profit}}{\text{Total Sales Revenue}} \times 100\%\)

3. Operating Costs (Fixed or Variable): This shows how much costs can rise before the project fails.
\n\(\text{Sensitivity of Costs} = \frac{\text{Total Profit}}{\text{Total value of that specific cost}} \times 100\%\)

Key Takeaway:

A small percentage = High Risk. If a 2% drop in price leads to zero profit, that project is extremely risky!

Let’s Try an Example

Scenario: Sarah’s Smoothie Shack is planning a new "Super-Green Smoothie." Here are the estimates:
\n- Selling Price: $5.00 per unit
- Variable Cost: $2.00 per unit
\n- Expected Sales: 10,000 units
\n- Total Fixed Costs: $20,000

Step 1: Calculate the expected profit.
Total Contribution = \(10,000 \text{ units} \times (\$5.00 - \$2.00) = \$30,000\)
\nProfit = \(\$30,000 \text{ (Contribution)} - \$20,000 \text{ (Fixed Costs)} = \$10,000\)

Step 2: Calculate Sensitivity of Sales Volume.
Using our formula: \(\frac{\$10,000 \text{ (Profit)}}{\$30,000 \text{ (Total Contribution)}} \times 100\% = 33.3\%\)
Meaning: Sarah can sell 33.3% fewer smoothies than expected before she starts losing money.

Step 3: Calculate Sensitivity of Selling Price.
Total Sales Revenue = \(10,000 \times \$5 = \$50,000\)
Using our formula: \(\frac{\$10,000 \text{ (Profit)}}{\$50,000 \text{ (Total Revenue)}} \times 100\% = 20\%\)
Meaning: If Sarah has to drop her price by 20% (down to $4.00), her profit disappears entirely.

Did you know? Selling price is almost always the most sensitive variable because a change in price affects every single dollar of revenue without changing the costs!

Interpreting the Results

Once you have your percentages, how do you use them? Management uses these figures to focus their attention. If the sensitivity of "Material Costs" is only 5%, the manager will spend a lot of time negotiating with suppliers. If the sensitivity of "Rent" is 50%, they won't worry as much about a small rent increase.

Common Mistake to Avoid: Students often think a high percentage is bad. Remember: High % = Safe; Low % = Risky. A 50% sensitivity means you can be 50% wrong and still be okay. A 1% sensitivity means if your estimate is off by just a tiny bit, you are in trouble!

Strengths and Weaknesses of Sensitivity Analysis

While sensitivity analysis is great, it isn’t perfect. In the P1 exam, you might be asked to discuss its limitations.

Advantages (The Good Stuff)

- Simplicity: It is easy to understand and calculate.
- Identification of Critical Factors: It shows management exactly which variables need the most "babysitting."
- Reduces Uncertainty: It provides a clearer picture than just looking at a single "best-case" profit figure.

Limitations (The Bad Stuff)

- One at a time: It only looks at one variable changing at a time. In the real world, if you raise your price, your sales volume usually drops too. Sensitivity analysis ignores this interaction.
- No Probabilities: It tells you how much a variable can change, but it doesn't tell you the likelihood of that change happening.
- Static: It is based on a single point in time and doesn't consider long-term trends.

Quick Summary for Revision

- Sensitivity Analysis measures the margin of safety for individual project variables.
- Formula: Profit / Total value of variable (expressed as a %).
- Lower % = Higher Risk.
- Rule: Only change one variable at a time (ceteris paribus).
- Main Weakness: It does not assign probabilities to the outcomes.

Final Tip: When you're sitting in the exam, if you forget the formula, just ask yourself: "How much can this specific item change before it eats up all my profit?" That logic will lead you to the right calculation every time! You've got this!