Skip to main content
Sign in Create a free account
Varsity Tutors
Sign in
Back to lessons

Managerial Accounting • Budgeting and Planning

Sales & Production Budgets — Prepare sales and production budgets

Learn how forecasted demand drives the master budget, linking revenue targets to production requirements.

Explore the lesson 17 min read
Managerial Accounting emblem with a calculator, a financial report, and a column chart.
Inside this lesson 10 sections 5 questions 10 figures

SECTION 1

Historical Context & Motivation

Long before spreadsheets and enterprise resource planning systems, businesses needed a way to translate anticipated customer demand into concrete operating plans. The practice of budgeting evolved from simple cash-flow projections maintained by European merchants into the sophisticated, interconnected planning frameworks used by modern corporations. The sales budget and its downstream counterpart, the production budget, sit at the very top of the master budget hierarchy—every other operating budget depends on them. Understanding why these two documents were formalized reveals a great deal about the managerial challenges they solve: coordinating supply with demand, controlling costs before they are incurred, and communicating performance expectations across an entire organization.

1920s • Birth of Scientific Budgeting

Inspired by Frederick Taylor's scientific management, firms such as DuPont and General Motors began requiring formal, quantified annual budgets. The sales forecast emerged as the logical starting point for all planning.

1950s • Standard Costing Meets Budgets

Post-war manufacturers paired standard costing systems with production budgets, allowing managers to set predetermined quantities of materials, labor, and overhead for each unit produced.

1970s • Zero-Based Budgeting

Peter Pyhrr popularized zero-based budgeting at Texas Instruments, challenging organizations to justify every dollar rather than simply inflating last year's figures. Sales forecasts became more analytical.

2000s • ERP-Driven Rolling Budgets

Enterprise resource planning software integrated sales, production, and financial budgets in real time. Rolling forecasts began supplementing—and sometimes replacing—static annual budgets.

Despite a century of evolution in tools and philosophies, the fundamental question remains the same: How many units do we expect to sell, and how many units must we therefore produce? Answering that question accurately and systematically is the purpose of the sales and production budgets.

SECTION 2

Core Principles & Definitions

Before constructing either budget, you need a firm grasp of the concepts that link them together. The sales budget quantifies expected revenue by multiplying forecasted unit sales by the anticipated selling price per unit for each period. It is the cornerstone of the master budget because every downstream budget—production, direct materials, direct labor, manufacturing overhead, and selling and administrative expenses—flows from the sales forecast. The production budget then translates unit sales into the number of units that must be manufactured, adjusting for the desired ending finished-goods inventory and the beginning inventory already on hand.

1

Sales Forecast

An estimate of future unit sales derived from market research, historical trends, economic indicators, and management judgment. It is the input to the sales budget.
2

Sales Budget

A formal document multiplying forecasted units by selling price to project total revenue for each sub-period (month, quarter). It sets the revenue target the company aims to achieve.
3

Production Budget

Determines how many units must be produced to meet budgeted sales while also achieving the desired ending inventory of finished goods. It accounts for beginning inventory already available.
4

Desired Ending Inventory

A policy-driven target for finished-goods inventory at the end of each period. Common policies include holding a percentage of next period's budgeted sales as a buffer against demand variability.
5

Master Budget

The comprehensive financial plan for a period, encompassing operating budgets (sales, production, purchasing, labor, overhead, S&A) and financial budgets (cash, capital expenditure, pro-forma statements).
✦

KEY TAKEAWAY

Think of the master budget like an assembly line of dominoes. The sales budget is the first domino: when you tip it—by setting unit sales and price—it knocks over the production budget, which in turn triggers materials, labor, and overhead budgets. If the first domino is poorly placed (i.e., the sales forecast is flawed), every subsequent plan topples in the wrong direction. That is why organizations invest heavily in refining their sales forecasts before any other budget is prepared.

SECTION 3

Visual Explanation — Budget Flow

The diagram below illustrates how the sales budget feeds into the production budget and then cascades into downstream operating budgets. Notice that the production budget occupies a pivotal position: it transforms a revenue-oriented plan into an operations-oriented plan by specifying the physical quantity of output required.

Sales BudgetUnits × Price = RevenueProduction BudgetUnits to ProduceDirect Materials BudgetDirect Labor BudgetMfg. Overhead BudgetCost of Goods Sold Budget → Pro-Forma Income StatementSeparate pathS&A Expense BudgetFigure 1 — Operating budget cascade from sales budget to pro-forma income statement
The sales budget (top) feeds directly into the production budget, which then branches into three downstream budgets: direct materials, direct labor, and manufacturing overhead. These converge at the cost of goods sold budget, ultimately shaping the pro-forma income statement. The selling and administrative expense budget follows a separate path but also flows into the income statement.

As Figure 1 makes clear, an error in the sales budget propagates through every downstream document. A 10 % overestimate of unit sales inflates the production budget, which in turn overstates material purchases, labor scheduling, and overhead allocation. The cumulative effect can result in excess inventory, unnecessary cash outflows, and misleading pro-forma financial statements. Conversely, under-forecasting sales leads to stock-outs, expedited production runs, and lost revenue. This cascading dependency is why managerial accountants describe the sales budget as the most critical element of the entire master budget.

SECTION 4

Mathematical Framework

Both the sales budget and the production budget rely on straightforward formulas, but understanding the logic behind each variable is essential for preparing them correctly. Below are the core equations and variable definitions.

Sales Budget Formula

BUDGETED REVENUE

BudgetedSalesRevenue=BudgetedUnitSales×SellingPriceperUnitBudgeted Sales Revenue = Budgeted Unit Sales × Selling Price per Unit

Budgeted Unit Sales = the number of units the company expects to sell in a given period, derived from the sales forecast. Selling Price per Unit = the anticipated price at which each unit will be sold, which may vary across periods if price changes are planned.

The sales budget is typically prepared by period (month or quarter) and by product line, then aggregated into an annual total. Each row states the forecasted units, the price, and the resulting revenue for that period.

Production Budget Formula

REQUIRED PRODUCTION

RequiredProduction(units)=BudgetedUnitSales+DesiredEndingFinishedGoodsInventory−BeginningFinishedGoodsInventoryRequired Production (units) = Budgeted Unit Sales + Desired Ending Finished Goods Inventory − Beginning Finished Goods Inventory

Budgeted Unit Sales = units from the sales budget for that period. Desired Ending Finished Goods Inventory (DEFGI) = a management-policy figure, often expressed as a percentage of next period's budgeted sales (e.g., 20 % of next quarter's sales). Beginning Finished Goods Inventory (BFGI) = inventory on hand at the start of the period; this equals the prior period's ending inventory.

ℹ

Inventory Identity

The production budget is grounded in the basic inventory equation: Beginning Inventory + Production − Sales = Ending Inventory. Rearranging for the unknown—production—yields the formula above. This identity holds for any type of inventory and is the conceptual backbone of the production budget.

TOTAL UNITS NEEDED

TotalUnitsNeeded=BudgetedUnitSales+DesiredEndingFGInventoryTotal Units Needed = Budgeted Unit Sales + Desired Ending FG Inventory

This intermediate subtotal represents the total demand the company must satisfy from a combination of existing inventory and new production.

SECTION 5

Detailed Budget Structure & Inventory Policies

In practice, the sales and production budgets are presented as columnar schedules broken out by sub-period—typically quarters—with an annual total column. The desired ending inventory policy is the key management assumption that differentiates the production budget from a simple echo of the sales budget. Firms adopt various inventory policies depending on their industry, lead times, and tolerance for stock-out risk. A common approach is to hold a fixed percentage of the following period's budgeted sales as a safety stock buffer—say, 20 % of next quarter's expected unit sales.

Sales vs. Production Units by Quarter02,0004,0006,0007,5003,0003,500Q14,0004,400Q25,0005,300Q36,0005,700Q4Budgeted SalesRequired Production
This bar chart compares budgeted unit sales (blue) with required production (violet) for each quarter. Notice that production exceeds sales in Q1–Q3 because the company is building ending inventory for the following quarter's anticipated higher sales. In Q4, production drops below sales because the company draws down inventory to a lean year-end target.

The visual above highlights a crucial insight: production and sales are almost never equal in any single period. The gap between the two bars is determined entirely by inventory policy. When a company expects sales to rise next quarter, it produces ahead of demand, building a cushion of finished goods. When demand is expected to decline—or when year-end inventory targets call for a drawdown—production is deliberately scheduled below current sales. This inventory-smoothing mechanism is one of the primary reasons the production budget exists as a separate document from the sales budget.

Inventory PolicyFormula for Desired Ending FG InventoryWhen It Is Common
Percentage of Next Period SalesDEFGI = x % × Next Period's Budgeted Unit SalesConsumer goods with seasonal demand swings
Fixed Number of Days' SupplyDEFGI = (Next Period Sales ÷ Days in Period) × Desired DaysJust-in-time environments, perishable goods
Constant LevelDEFGI = fixed number of units (e.g., 500 units always)Stable-demand industries, make-to-order hybrids

Common Ending Inventory Policies

SECTION 6

Worked Example — Cascade Electronics, Inc.

Cascade Electronics, Inc. manufactures a single product: a portable Bluetooth speaker. Management has gathered the following data for the upcoming fiscal year. The selling price is $50 per unit. Budgeted unit sales by quarter are: Q1 = 3,000; Q2 = 4,000; Q3 = 5,000; Q4 = 6,000. Company policy requires that the desired ending finished-goods inventory for each quarter equal 20 % of the next quarter's budgeted unit sales. The beginning inventory for Q1 is 600 units (i.e., 20 % of Q1 sales). Budgeted sales for Q1 of the following year are projected at 3,500 units. Our task is to prepare the sales budget and the production budget for the year.

Part A — Sales Budget

Sales Budget Preparation

  1. 1

    Step 1 — List Budgeted Unit Sales

    Enter the forecasted unit sales for each quarter: Q1 = 3,000; Q2 = 4,000; Q3 = 5,000; Q4 = 6,000.
  2. 2

    Step 2 — Multiply by Selling Price

    Budgeted revenue for each quarter is: Q1 = 3,000 × $50 = $150,000; Q2 = 4,000 × $50 = $200,000; Q3 = 5,000 × $50 = $250,000; Q4 = 6,000 × $50 = $300,000.
  3. 3

    Step 3 — Compute Annual Total

    Total budgeted sales for the year = $150,000 + $200,000 + $250,000 + $300,000.
    Total Budgeted Revenue = $900,000
Q1Q2Q3Q4Year
Budgeted Unit Sales3,0004,0005,0006,00018,000
× Selling Price$50$50$50$50$50
Budgeted Revenue$150,000$200,000$250,000$300,000$900,000

Cascade Electronics — Sales Budget

Part B — Production Budget

Production Budget Preparation

  1. 1

    Step 1 — Enter Budgeted Unit Sales

    Carry forward the unit sales from the sales budget: Q1 = 3,000; Q2 = 4,000; Q3 = 5,000; Q4 = 6,000.
  2. 2

    Step 2 — Compute Desired Ending Inventory

    Apply the 20 % policy: Q1 DEFGI = 20 % × 4,000 = 800; Q2 DEFGI = 20 % × 5,000 = 1,000; Q3 DEFGI = 20 % × 6,000 = 1,200; Q4 DEFGI = 20 % × 3,500 (next year Q1) = 700.
  3. 3

    Step 3 — Determine Total Units Needed

    Total units needed = Budgeted sales + DEFGI: Q1 = 3,000 + 800 = 3,800; Q2 = 4,000 + 1,000 = 5,000; Q3 = 5,000 + 1,200 = 6,200; Q4 = 6,000 + 700 = 6,700.
  4. 4

    Step 4 — Subtract Beginning Inventory

    Beginning inventory for each quarter equals the prior quarter's ending inventory: Q1 BFGI = 600 (given); Q2 BFGI = 800 (Q1 ending); Q3 BFGI = 1,000 (Q2 ending); Q4 BFGI = 1,200 (Q3 ending).
  5. 5

    Step 5 — Calculate Required Production

    Required production = Total units needed − BFGI: Q1 = 3,800 − 600 = 3,200; Q2 = 5,000 − 800 = 4,200; Q3 = 6,200 − 1,000 = 5,200; Q4 = 6,700 − 1,200 = 5,500.
    Annual Required Production = 3,200 + 4,200 + 5,200 + 5,500 = 18,100 units
Q1Q2Q3Q4Year
Budgeted Unit Sales3,0004,0005,0006,00018,000
+ Desired Ending FG Inv.8001,0001,200700700*
= Total Units Needed3,8005,0006,2006,700—
− Beginning FG Inv.(600)(800)(1,000)(1,200)(600)*
= Required Production3,2004,2005,2005,50018,100

Cascade Electronics — Production Budget (*Annual column: ending inv. = Q4 ending; beginning inv. = Q1 beginning)

💡

Why 18,100 and Not 18,000?

Annual production (18,100) exceeds annual sales (18,000) by 100 units because the company's ending inventory at year-end (700 units) is higher than its beginning inventory at the start of the year (600 units). This net inventory build of 100 units requires 100 additional units of production beyond what is sold.

SECTION 7

Strengths, Limitations & Practical Considerations

Sales and production budgets are powerful planning tools, but they operate within a set of assumptions that managers must critically evaluate. The table below contrasts the primary strengths and limitations of these budgets as traditionally prepared in a static (fixed) budgeting framework.

StrengthsLimitations
Forces management to think systematically about demand drivers and capacity needs before the period begins.Relies heavily on the accuracy of the sales forecast, which is inherently uncertain, especially in volatile markets.
Provides a clear coordination mechanism between sales, operations, and finance departments.Static budgets do not automatically adjust when actual sales deviate from forecasts, potentially causing rigid over- or under-production.
Enables downstream budgets (materials, labor, overhead) to be prepared with precision, improving cost control.Inventory policies (e.g., 20 % of next quarter's sales) are management assumptions, not market certainties; mis-specification creates excess stock or shortages.
Serves as a performance benchmark for variance analysis at period-end.Does not capture capacity constraints; production budget may call for output that exceeds plant capacity without additional capital expenditure.

Strengths vs. Limitations of Sales & Production Budgets

💡

PRACTICAL INSIGHT

Many companies mitigate the rigidity of static budgets by preparing flexible budgets alongside their master budgets. A flexible budget recalculates production and cost figures at several volume levels (e.g., 80 %, 100 %, and 120 % of forecasted sales), providing managers with a ready-made response plan if actual demand diverges from the original forecast. Think of the flexible budget as a GPS that recalculates your route in real time, whereas the static budget is a printed map—useful for orientation but unable to adapt to road closures.

SECTION 8

Connection to Advanced Budgeting Concepts

The sales and production budgets you have learned to prepare are components of a static master budget—a single-scenario plan tied to one set of assumptions. As you advance in managerial accounting, you will encounter more sophisticated planning models that build on, refine, or replace this foundation. The table below maps the basic concepts covered in this lesson to their advanced counterparts, giving you a roadmap for deeper study.

Basic Concept (This Lesson)Advanced ExtensionKey Difference
Static sales budget at one volume levelFlexible budgetAdjusts budgeted costs and revenues to the actual volume achieved, enabling meaningful variance analysis.
Annual budget prepared once per yearRolling (continuous) budgetAdds a new period (e.g., a new quarter) as each period expires, always maintaining a 12-month planning horizon.
Single-product production budgetMulti-product & constrained-resource budgetingRequires optimization (e.g., linear programming) when limited machine hours or materials must be allocated across multiple product lines.
Deterministic sales forecastProbabilistic / scenario-based forecastingUses probability distributions or best-case / worst-case / most-likely scenarios to capture demand uncertainty.
Desired ending inventory as a fixed percentageSafety stock optimization modelsApplies economic order quantity (EOQ) and reorder point models to determine optimal inventory levels probabilistically.

From Basic Budgets to Advanced Planning

As you move into topics such as variance analysis, activity-based budgeting, and capital expenditure planning, remember that the sales and production budgets remain the foundation upon which everything else rests. Mastering their preparation ensures you can construct—and critically evaluate—any budget that follows in the master budget sequence.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

Explain why the sales budget is considered the starting point of the master budget. What would happen to the production budget and its downstream schedules if the sales forecast were significantly overstated?
Show answer
The sales budget is the starting point because virtually every other operating budget—production, direct materials, direct labor, manufacturing overhead, and selling and administrative expenses—is derived from the number of units the company expects to sell. If the sales forecast is significantly overstated, the production budget will schedule too many units, which in turn inflates material purchases, labor hours, and overhead application. The result is excess finished-goods inventory, unnecessary cash outflows, and pro-forma financial statements that overstate revenue and understate the cost of carrying surplus inventory. Managers may also make capital investment decisions (e.g., adding a production shift) based on phantom demand, compounding the financial damage.

Question 2: BASIC CALCULATION

Oakwood Furniture expects to sell 2,400 dining tables in Q1 at $350 each. Company policy requires ending finished-goods inventory equal to 25 % of next quarter's budgeted sales. Q2 budgeted sales are 3,000 tables. Beginning inventory for Q1 is 600 tables. Calculate (a) Q1 budgeted sales revenue and (b) Q1 required production in units.
Show answer
(a) Budgeted sales revenue = 2,400 × $350 = $840,000. (b) Desired ending inventory = 25 % × 3,000 = 750 tables. Total units needed = 2,400 + 750 = 3,150. Required production = 3,150 − 600 (beginning inventory) = 2,550 tables. The key insight is that production (2,550) exceeds sales (2,400) because the company needs to build an additional 150 units of ending inventory to satisfy the 25 % policy going into Q2, which has higher forecasted demand.

Question 3: INTERMEDIATE

SolarTech Ltd. produces portable solar chargers. Budgeted unit sales are: Q1 = 5,000; Q2 = 7,000; Q3 = 8,000; Q4 = 4,000. Desired ending inventory is 15 % of the following quarter's budgeted sales. Beginning inventory for Q1 is 750 units. Expected Q1 sales for the next year are 5,500 units. The selling price is $40 per unit. Prepare the complete production budget for all four quarters and the annual total, then compute total budgeted revenue for the year.
Show answer
Total budgeted revenue = (5,000 + 7,000 + 8,000 + 4,000) × $40 = 24,000 × $40 = $960,000. For the production budget: Q1 DEFGI = 15 % × 7,000 = 1,050; Q2 DEFGI = 15 % × 8,000 = 1,200; Q3 DEFGI = 15 % × 4,000 = 600; Q4 DEFGI = 15 % × 5,500 = 825. Beginning inventories: Q1 = 750; Q2 = 1,050; Q3 = 1,200; Q4 = 600. Required production: Q1 = 5,000 + 1,050 − 750 = 5,300; Q2 = 7,000 + 1,200 − 1,050 = 7,150; Q3 = 8,000 + 600 − 1,200 = 7,400; Q4 = 4,000 + 825 − 600 = 4,225. Annual production = 5,300 + 7,150 + 7,400 + 4,225 = 24,075 units. Note that annual production (24,075) exceeds annual sales (24,000) by 75 units, reflecting the net increase in inventory from 750 units at the beginning of Q1 to 825 units at the end of Q4.

Question 4: APPLIED

Precision Plastics produces two models of reusable water bottles: Standard and Premium. The marketing team forecasts annual sales of 40,000 Standard units at $12 each and 15,000 Premium units at $25 each. Management wants ending inventory equal to 10 % of the following year's estimated sales (42,000 Standard; 16,000 Premium). Beginning inventories are 3,800 Standard and 1,600 Premium. Calculate (a) total budgeted revenue for each product and in total, and (b) required annual production for each product. Then discuss one capacity constraint management should consider.
Show answer
(a) Standard revenue = 40,000 × $12 = $480,000; Premium revenue = 15,000 × $25 = $375,000; total revenue = $855,000. (b) Standard: DEFGI = 10 % × 42,000 = 4,200; Production = 40,000 + 4,200 − 3,800 = 40,400 units. Premium: DEFGI = 10 % × 16,000 = 1,600; Production = 15,000 + 1,600 − 1,600 = 15,000 units. Total production = 55,400 units. A key capacity constraint management should consider is whether the injection-molding machines can handle 55,400 units within available machine hours. If both models share the same equipment, managers must verify that total required machine hours (factoring in different cycle times per model) do not exceed available capacity, or plan for overtime, outsourcing, or capital investment.

Question 5: CRITICAL THINKING

A startup consumer-electronics company is preparing its first master budget. The CEO argues that setting a high desired ending inventory (e.g., 40 % of next quarter's sales) is a conservative, low-risk approach because it virtually eliminates stock-outs. The CFO counters that such a policy ties up working capital and increases storage and obsolescence costs. Construct a balanced argument evaluating both perspectives. Under what specific conditions might a 40 % policy be justified? When would a leaner policy (e.g., 10 %) be preferable?
Show answer
The CEO's position has merit in environments characterized by highly uncertain demand, long production lead times, or severe penalties for stock-outs (such as losing a key retail partnership). For a startup without historical sales data, demand volatility is genuinely high, so a larger buffer can protect nascent customer relationships. However, the CFO correctly identifies the opportunity cost of capital locked in inventory, the carrying costs (warehousing, insurance, handling), and the risk of technological obsolescence—particularly acute in consumer electronics where product life cycles are short. A 40 % ending inventory policy would roughly double the inventory investment relative to a 20 % policy, draining cash that the startup could otherwise deploy toward marketing or R&D. A balanced solution might involve setting a higher buffer (e.g., 30–40 %) during the first year when forecast reliability is lowest, then tapering to 15–20 % as actual sales data accumulates and forecast accuracy improves. A lean 10 % policy would be preferable for products with stable, predictable demand, short production lead times, or where just-in-time manufacturing is feasible. Ultimately, the optimal inventory policy is the one that minimizes the combined costs of carrying excess inventory and the expected cost of stock-outs.

SUMMARY

Lesson Summary

Summary

The sales budget is the starting point of the master budget, projecting total revenue by multiplying budgeted unit sales by the selling price per unit for each sub-period. It translates the sales forecast—a qualitative and quantitative estimate of future demand—into the financial targets that drive every downstream operating budget.

The production budget converts unit sales into units that must be manufactured by adding the desired ending finished-goods inventory and subtracting the beginning finished-goods inventory. The core formula—Required Production = Budgeted Sales + Desired Ending Inventory − Beginning Inventory—is derived from the basic inventory identity. Together, these two budgets establish the volume foundation upon which direct materials, direct labor, and manufacturing overhead budgets are built, ensuring that the entire organization's financial plan is internally consistent and aligned with market expectations.

Varsity Tutors • Managerial Accounting • Sales & Production Budgets