Sales Budget
The starting point for all budgets.
Why This Matters
Every budget in the master budget system is derived from one thing: what you expect to sell. The production budget can't be built until you know how many units to sell. The labor budget can't be built until you know how much to produce. The cash budget can't be built until you know when revenue will be collected.
The Sales Budget is the first, most critical, and most difficult budget to get right. If the sales forecast is off — too optimistic or too pessimistic — every downstream budget is off too. A 10% error in the sales forecast compounds into errors in inventory levels, staffing, cash flow, and ultimately, the financial statements.
The Sales Budget is not just a number — it is a detailed commitment about what you expect to sell, when, in what product mix, at what price, with what collection timing. Getting it right requires analysis, judgment, and honesty about the difference between what you hope for and what the evidence supports.
Components of the Sales Budget
SALES BUDGET STRUCTURE
Units to sell
× Selling price per unit
= Revenue
Broken down by time period, product line, sales channel, and region — then extended to collection timing and variable cost implications for downstream budgets.
Building the Sales Forecast
There is no single correct method for building a sales forecast. Managers typically combine several approaches:
Approach 1 — Historical Trend Analysis
2024: 67,000 cups — $134,000
2025: 75,000 cups — $150,000
2026: 85,000 cups — $170,000
Growth: 11.9% → 13.3% | Trend ~12% compound
2027 baseline: 85,000 × 1.12 = 95,200 cups
Approach 2 — Market Analysis
"Local coffee shop market grew 9% in 2026. A new competitor opened nearby in Q4. Adjusting baseline down to 7% growth."
Adjusted: 85,000 × 1.07 = 90,950 cups
Approach 3 — Sales Team / Management Judgment
Manager: "We have a new corporate contract starting Q2 — estimated 200 cups/week for 9 months = 7,800 cups."
Final estimate: 90,950 + 7,800 = 98,750 cups (total)
Approach 4 — Bottoms-Up Driver Model
280 daily customers × 95% buy rate × 1.15 drinks avg
× $2.00 × 305 days = ~$186,500
Good forecasting uses all four approaches and tests whether the results are consistent with each other.
Sales Budget Builder
Enter units and selling price by period to build revenue. Toggle the collection schedule to see how cash timing diverges from revenue recognition — the bridge to the Cash Budget.
| Period | Units | Price ($) | Revenue |
|---|---|---|---|
| Q1 | $42,640 | ||
| Q2 | $55,890 | ||
| Q3 | $60,030 | ||
| Q4 | $45,240 | ||
| Annual | 98,250 | $2.07 ASP | $203,800 |
Q1 Cash Collected
$40,508
95% current + no prior
AR end: $2,132
Q2 Cash Collected
$55,227
95% current + 5% prior
AR end: $2,795
Q3 Cash Collected
$59,823
95% current + 5% prior
AR end: $3,002
Q4 Cash Collected
$45,980
95% current + 5% prior
AR end: $2,262
Formula
Revenue = Units × Price (by period)
Cash = Current-period sales × 95%
+ Prior-period sales × 5%
Revenue earned ≠ cash collected. This gap feeds the Cash Budget.
ABC Coffee Shop — 2027 Sales Budget (Full)
| Product | Q1 | Q2 | Q3 | Q4 | Annual |
|---|---|---|---|---|---|
| Espresso/Coffee — Units | 14,000 | 19,500 | 21,000 | 14,500 | 69,000 |
| Price | $2.00 | $2.00 | |||
| Revenue | $28,000 | $39,000 | $42,000 | $29,000 | $138,000 |
| Pastries — Units | 6,500 | 7,500 | 8,000 | 7,250 | 29,250 |
| Price | $2.25 | $2.25 | |||
| Revenue | $14,625 | $16,875 | $18,000 | $16,313 | $65,813 |
| TOTAL REVENUE | $42,625 | $55,875 | $60,000 | $45,313 | $203,813 |
ABC Coffee 2027 Seasonal Pattern
Q1 winter/slow, Q2–Q3 spring/summer peak, Q4 moderate. Seasonality must be modeled so low-revenue periods don't create unexpected cash shortfalls.
From Units to Revenue: Price × Mix Considerations
AVERAGE SELLING PRICE (ASP)
2026 ASP: (85,000 × $2.00 + 25,000 × $2.00) ÷ 110,000 = $2.00
2027 ASP: $203,813 ÷ 98,250 = $2.07/unit
Higher ASP is entirely from pastry mix shift — not a price increase. Good! Higher ASP with same price → better product mix.
Implication
If management sees ASP rising and assumes it reflects a price increase, they may relax on volume — when in fact volumes must rise proportionally to hit revenue targets. Breaking revenue by product line prevents this.
Handling Seasonality in the Sales Budget
Seasonality is one of the most important factors to model correctly.
SEASONAL INDEX METHOD
Step 1: Calculate historical monthly sales as % of annual.
Step 2: Average across years to get seasonal index.
Step 3: Apply index to annual budget to get monthly estimates.
ABC Q1 share: 2024 22.4% | 2025 21.8% | 2026 23.5% → Avg 22.6%
2027 Q1 estimate: $203,813 × 22.6% = $46,061
(Slightly above detailed build of $42,625 — within acceptable range)
Why Seasonality Matters for Cash
If Q1 is slow but fixed costs are constant, cash may go negative. Budget-driven planning reveals this before January arrives — not after the owner checks the bank account.
Cash Collection Timing
The Sales Budget shows when revenue is earned. But for the Cash Budget, you need to know when cash actually arrives.
ABC COFFEE SHOP — COLLECTION POLICY
95% collected in the same month/quarter as sale
5% net-30 corporate accounts (collected following period)
2027 Q1 Revenue: $42,625
Cash in Q1: $42,625 × 95% = $40,494
Cash in Q2 from Q1 sales: $42,625 × 5% = $2,131
AR balance (end of Q1) = $2,131
Corporate Accounts Example
A business with 60-day payment terms: "January sales of $100,000 collected 33% in Jan, 67% in Feb." Sales and cash budgets diverge significantly. The gap must be funded by working capital or credit.
Sales Budget and Operating Leverage
The Sales Budget must be interpreted in the context of the company's cost structure:
2027 budgeted revenue growth: +$33,813 (+19.9% vs. 2026)
Fixed costs: $33,500 → $34,300 (+2.4%)
New estimated CM: 98,250 × ($2.07 − ~$1.22) ≈ $83,513
Budget operating income: $83,513 − $34,300 = $49,213
2026 operating income: $34,500
Growth: +$14,713 → +42.6% profit on 19.9% revenue growth
DOL (at 2026 base): ~2.0× → 19.9% × 2.0 ≈ 39.8% profit growth ✓
Budgeting Module Track
Sales Budget is module 3 of 5 in the Budgeting section (#88–92):
| Module | Core Concept | # |
|---|---|---|
| Budgeting Basics | Four purposes; process; top-down vs. bottom-up; slack | #88 |
| Master Budget | Integrated system: operating + financial budgets | #89 |
| Sales Budget ← You are here | Revenue forecast; seasonality; collection timing | #90 |
| Cash Budget | Cash collections; disbursements; financing needs | #91 |
| Flexible vs. Static Budget | Volume variance vs. efficiency variance separation | #92 |
Common Mistakes in Sales Budgeting
Mistake 1: Using Last Year Plus a Percentage Without Analysis
❌ Wrong
"We grew 13% last year, so budget 13% again."
✅ Right
Analyze drivers: foot traffic, conversion rate, average ticket, market growth, pipeline. Cross-check with bottoms-up model.
Mistake 2: Confusing Revenue Recognition with Cash Collection
❌ Wrong
"We're budgeting $203,813 in revenue — so we'll have $203,813 in cash next year."
✅ Right
Build a separate collection schedule and cash budget. Revenue and cash flow are two different things.
Key Takeaway
The Sales Budget is the starting point for every other budget in the master budget. It quantifies expected unit sales, revenue by product line and period, and provides the basis for collection timing analysis used in the Cash Budget. Good sales budgeting combines historical trend analysis, market intelligence, management judgment, and a bottoms-up driver model. Seasonality must be modeled explicitly so that low-revenue periods don't create unexpected cash shortfalls. The Sales Budget is not just a revenue forecast — it sets the volume level that determines production, labor, overhead, and ultimately, operating profit through the operating leverage mechanism.
Test Your Understanding
Collection timing, master budget sequence, ASP mix effects, and operating leverage — check your answers below.
Question 1: Q1 Sales = $60,000. Q2 Sales = $80,000. Collection rate: 70% in month of sale, 30% in next quarter. How much cash is collected in Q2 from Q2 sales?
Question 2: True or False: The Sales Budget is the last budget prepared in the master budget process.
Question 3: ABC Coffee 2027 budget: 98,250 units at $2.07 ASP = $203,813 revenue. 2026 was 110,000 units at $2.00 = $220,000. What drove the higher ASP in 2027?
Question 4: 2027 budgeted revenue growth is +19.9% vs. 2026. Fixed costs grow only +2.4%. At DOL ≈ 2.0×, expected profit growth is approximately:
Ready to Practice?
Build quarterly sales budgets, model collection schedules, and connect revenue forecasts to downstream master budget modules in the Practice Lab.
Try the Practice LabWhat's Next?
Cash Budget — How sales, production, overhead, and capital expenditure plans combine into a period-by-period picture of cash inflows, cash outflows, and whether the business needs external financing to execute its plan.