Budget Scenario Analysis
Yellow cells will be calculated for you. You do not need to enter anything in them.
Revenue Impact (examples)
Probability of shipping on time Number of building permits released within last 6 months Number of efficient sales representatives Number of new customers Churn rate among existing customers Probability of getting expected pricing Regional economic growth Competitive strength (products, pricing, promotion, placement) Probability of key supplier performance Budgeted Annual Revenue Using Base Case Scenario
Scenario 1 (Best case) 2.0% 3.0% 5.0% 4.0% 1.0% 3.0% 2.0% 3.0% 2.0% $15,000
Scenario 2 (Average case) 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
Scenario 3 (Worst case) -5.0% -2.0% -5.0% -4.0% -4.0% -6.0% -3.0% -3.0% -5.0%
Budget Scenarios
Scenario 1: Best case Scenario 2: Average case Scenario 3: Worst case
Results $18,750 $15,000 $9,450
Base Case Variance $3,750 — ($5,550)
Variance Percentage 20.00% — -58.73%
Scenario Comparison - Annual Revenue
$20,000 $18,000 $16,000 $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $0
Scenario 1: Best case Scenario 2: Average case Scenario 3: Worst case