A single budget forecast can hide the assumptions that matter most. If it assumes last month's efficiency will continue at higher spend, a precise revenue number may create more confidence than the evidence deserves.
Three scenarios make those assumptions visible. A conservative case, a base case, and an expansion case should describe different plausible operating conditions and the decisions they imply. They should not be the same spreadsheet with every number multiplied by an arbitrary percentage.
Start with a common baseline
Use a completed period with consistent spend, customer, revenue, and cost definitions. Record promotions, inventory issues, measurement gaps, and other conditions that make the period unusual.
Separate actual values from estimates. If recent refunds or sales outcomes are still developing, show the preliminary status rather than quietly treating them as final.
The US Small Business Administration's break-even planning guide provides a basic reference for connecting revenue, variable costs, and fixed costs. Your advertising scenarios should retain that economic structure rather than forecast revenue alone.
Identify the assumptions that drive the decision
For ecommerce, important variables may include new-customer cost, first-order value, retained revenue, product mix, and fulfillment cost. For lead generation, they may include qualification, attendance, close rate, sale value, and capacity.
Choose a small set of variables with meaningful uncertainty. Record where each assumption comes from: observed history, a planned commercial change, an experiment, or a management estimate.
Do not vary every input independently if the business relationships make that combination implausible. A deep discount may change both conversion behavior and contribution per order.
Define what each scenario means
The conservative case should represent a plausible weaker outcome, not an impossible disaster inserted to make the base case look safe. The base case should reflect the most defensible operating assumptions. The expansion case should require identifiable conditions that could support more spend.
For example, expansion might depend on new stock arriving, a validated creative concept, or sales capacity becoming available. It should not depend only on the team's desire to grow.
Use the marginal ROAS guide to avoid assuming the additional spending tranche earns the same return as the historical average.
Build an illustrative scenario table
| Planning input | Conservative | Base | Expansion |
|---|---|---|---|
| Media spend | $15,000 | $20,000 | $25,000 |
| Assumed retained revenue associated with the plan | $42,000 | $60,000 | $72,500 |
| Assumed pre-ad contribution rate | 40% | 40% | 40% |
| Modeled contribution before media | $16,800 | $24,000 | $29,000 |
| Modeled contribution after media | $1,800 | $4,000 | $4,000 |
These figures are hypothetical and do not establish causal revenue. They illustrate that an expansion case can produce more revenue without more contribution after media. Other excluded costs and cash timing can further change the decision.
The table should make the tradeoff visible, not select the answer automatically.
Add capacity constraints
Translate the revenue or lead assumptions into operational demand. How many orders, shipments, consultations, or sales conversations would each scenario require?
Check stock, service coverage, staffing, appointment availability, and support load. A forecast that exceeds capacity should include the cost and timing of increasing capacity or reduce the feasible advertising plan.
Do not assume every additional customer can be served at the same unit cost. Some costs change in steps when the business needs another shift, contractor, or warehouse arrangement.
Build a separate cash view
Profitability and cash availability can differ because costs and customer receipts occur at different times. Use the cash timing guide to place the planned outflows and inflows on a calendar.
Include known supplier payments, advertising billing, payroll, and other commitments relevant to the decision. Keep speculative sales receipts separate from confirmed collections.
A scenario with attractive contribution may still require more working cash than the business is willing to expose. That is a decision constraint, not a flaw to hide by changing the revenue assumption.
Use sensitivity checks to find fragile assumptions
Change one important input at a time around the base case to see what most affects the result. If a small change in retained revenue or qualification rate reverses the decision, that variable deserves more evidence and monitoring.
This is different from claiming a precise probability for each scenario. Unless the model supports probabilities, describe the cases as conditional possibilities.
Keep the formulas simple enough that another person can reproduce a few rows by hand. Complex formatting should not conceal an unexplained assumption.
Define movement between scenarios
Write the conditions that would justify reducing, maintaining, or expanding the plan. Examples include verified stock arrival, mature acquisition results, a healthy conversion feed, or a confirmed increase in sales capacity.
Assign an owner and a review date. A condition should be observable and relevant, not a vague statement that performance “feels strong.”
Once a scenario is approved, translate it into the monthly pacing sheet. Keep future recommendations separate from the current authorized budget.
Review actuals against assumptions
During the month, compare actual spending, outcomes, contribution, and capacity with the selected scenario. Identify which assumptions moved rather than treating every forecast miss as an advertising execution failure.
After the period matures, preserve the original plan and the actual result. Repeatedly optimistic assumptions should be revised before the next cycle.
The useful output is a set of decisions the business can make under different conditions. That makes the budget more adaptable and gives an operator clear evidence requirements for changing the plan.
Work through a forecast
The free PPC budget workbook provides three editable channel columns and visible calculations from spend to contribution after media. Use it to change a clearly stated driver, then record why that alternative is plausible. The worked example includes a lower close-rate case and a combined CPC-and-qualification case.