Accounting › Section T · Budgeting › Topic T.2

Operating budgets

The operating budgets turn one sales forecast into a full plan for production, purchasing, staffing and spending. Follow one manufacturer from its sales budget to its budgeted operating income and you will see how every schedule feeds the next.

One forecast, a chain of schedules

Brackley Paddle Works makes carbon-fibre kayak paddles and is preparing its master budget for 2027, by quarter. Its operating budgets form a chain: the sales budget feeds the production budget, which feeds the direct materials, direct labour and manufacturing overhead budgets; sales also drive the selling and administrative budget; and together they give budgeted cost of goods sold and operating income. Each schedule uses figures from the ones before it. Brackley's figures continue in "Financial budgets and the cash budget", which completes the cash budget and budgeted statements. All figures are planning assumptions.

The sales budget

The sales budget multiplies expected units by the expected price. Marketing builds the unit forecast from past sales, customer orders, industry trends, economic conditions and planned promotions. Brackley expects to sell paddles at $80 each:

\begin{array}{lrr} \text{Quarter} & \text{Paddles} & \text{Sales} \\ \hline \text{Q1} & 2{,}000 & 160{,}000 \\ \text{Q2} & 3{,}000 & 240{,}000 \\ \text{Q3} & 4{,}000 & 320{,}000 \\ \text{Q4} & 2{,}500 & 200{,}000 \\ \hline \text{Year} & 11{,}500 & 920{,}000 \end{array}

An overestimate leaves too much stock, material and labour; an underestimate means lost sales when stock runs out. Either error flows through every later schedule.

The production budget

A company must make enough to cover sales and leave the ending stock it wants, but the units already in beginning stock need not be made again:

\text{Make} = \text{Sales} + \text{End} - \text{Begin}

This is the cost of goods sold identity rearranged, in units. Brackley wants finished paddles at the end of each quarter equal to 20% of the next quarter's sales, enough to absorb a busy week without filling the warehouse. A merchandiser makes nothing, so it prepares a purchases budget instead, with the same formula giving units to buy.

Worked example: Brackley's production budget

Brackley starts 2027 with 400 paddles, and forecasts 2,200 for Q1 of 2028. 1. Q1 ending stock: \(20\% \times 3{,}000 = 600\), so Q1 production is \(2{,}000 + 600 - 400 = 2{,}200\). 2. Q2: ending stock 800, production \(3{,}000 + 800 - 600 = 3{,}200\). 3. Q3: ending stock 500, production 3,700. 4. Q4 uses next year's forecast: ending stock \(20\% \times 2{,}200 = 440\), production \(2{,}500 + 440 - 500 = 2{,}440\).

\begin{array}{lrr} \text{Quarter} & \text{Sales} & \text{Make} \\ \hline \text{Q1} & 2{,}000 & 2{,}200 \\ \text{Q2} & 3{,}000 & 3{,}200 \\ \text{Q3} & 4{,}000 & 3{,}700 \\ \text{Q4} & 2{,}500 & 2{,}440 \\ \hline \text{Year} & 11{,}500 & 11{,}540 \end{array}

5. Check: \(11{,}500 + 440 - 400 = 11{,}540\).

The direct materials budget

The materials budget works the same way in kilograms, then prices the purchases:

\text{Buy} = \text{Needed} + \text{End} - \text{Begin}

where the amount needed is production times material per unit. Each paddle uses 2 kg of composite costing $6 per kg, so materials cost $12 per paddle. Brackley keeps material at each quarter-end equal to 10% of the next quarter's needs, and starts the year with 440 kg. Q4's ending material depends on Q1 2028 production of 2,400 paddles, worked out from 2028 forecasts of 2,200 paddles sold in Q1 and 3,200 in Q2.

Worked example: materials purchases

1. Q1 needs \(2{,}200 \times 2 = 4{,}400\) kg. 2. Desired ending material is 10% of Q2's needs: \(10\% \times 6{,}400 = 640\) kg. 3. Purchases: \(4{,}400 + 640 - 440 = 4{,}600\) kg, costing \(4{,}600 \times 6 = 27{,}600\). 4. The other quarters follow, with Q4 ending at \(10\% \times 4{,}800 = 480\) kg:

\begin{array}{lrr} \text{Quarter} & \text{Kg bought} & \text{Cost} \\ \hline \text{Q1} & 4{,}600 & 27{,}600 \\ \text{Q2} & 6{,}500 & 39{,}000 \\ \text{Q3} & 7{,}148 & 42{,}888 \\ \text{Q4} & 4{,}872 & 29{,}232 \\ \hline \text{Year} & 23{,}120 & 138{,}720 \end{array}

5. Check: \(23{,}080\) kg needed \(+ 480 - 440 = 23{,}120\) kg.

The direct labour budget

Labour hours follow production, not sales: units to make times hours per unit, then times the wage rate. Each paddle takes 0.5 hours at $26 an hour, or $13 per paddle.

\begin{array}{lrr} \text{Quarter} & \text{Hours} & \text{Cost} \\ \hline \text{Q1} & 1{,}100 & 28{,}600 \\ \text{Q2} & 1{,}600 & 41{,}600 \\ \text{Q3} & 1{,}850 & 48{,}100 \\ \text{Q4} & 1{,}220 & 31{,}720 \\ \hline \text{Year} & 5{,}770 & 150{,}020 \end{array}

The hours tell the production manager how many staff to schedule each quarter, and whether overtime or temporary workers will be needed in the busy Q3.

The manufacturing overhead budget

Overhead is split by behaviour, as in "Variable, fixed, and mixed costs". Brackley's variable overhead is $10 per direct labour hour; fixed overhead is $28,850 a quarter, including $5,000 of depreciation.

\begin{array}{lrr} \text{Quarter} & \text{Variable} & \text{Total} \\ \hline \text{Q1} & 11{,}000 & 39{,}850 \\ \text{Q2} & 16{,}000 & 44{,}850 \\ \text{Q3} & 18{,}500 & 47{,}350 \\ \text{Q4} & 12{,}200 & 41{,}050 \\ \hline \text{Year} & 57{,}700 & 173{,}100 \end{array}

The overhead rate is \(173{,}100 \div 5{,}770 = 30\) per hour, or $15 per paddle, so a paddle costs \(12 + 13 + 15 = 40\) to make.

The selling and administrative budget

Selling and administrative costs are period costs, never part of inventory, and their variable part follows units sold. Brackley pays $4 per paddle sold in commissions and delivery, plus $60,000 a quarter of fixed costs, including $5,000 of depreciation. The totals are $68,000, $72,000, $76,000 and $70,000 for the four quarters, or $286,000 for the year. In practice this schedule gathers many smaller budgets from sales, marketing, finance and other departments.

Worked example: budgeted cost of goods sold

1. Materials used are \(23{,}080 \times 6 = 138{,}480\), so manufacturing costs are \(138{,}480 + 150{,}020 + 173{,}100 = 461{,}600\), which equals \(11{,}540 \times 40\). 2. Beginning paddles cost \(400 \times 40 = 16{,}000\) and ending paddles \(440 \times 40 = 17{,}600\), assuming the unit cost is unchanged:

\begin{array}{lr} \text{Opening stock} & 16{,}000 \\ \text{Manufactured} & 461{,}600 \\ \text{Closing stock} & (17{,}600) \\ \hline \text{Cost of goods sold} & 460{,}000 \end{array}

3. Check: \(11{,}500 \times 40 = 460{,}000\). 4. Gross margin is \(920{,}000 - 460{,}000 = 460{,}000\), and after selling and administrative costs, budgeted operating income is \(460{,}000 - 286{,}000 = 174{,}000\). Interest and income tax wait for the cash budget.

Common mistakes to avoid

First, basing materials, labour or overhead on units sold instead of units produced. Second, reversing the inventory adjustment: desired ending stock is added and beginning stock subtracted. Third, forgetting that Q4's ending stock needs next year's forecast. Fourth, confusing materials bought with materials used. Fifth, adding the quarterly stock figures in the Year row: the year begins with Q1's opening stock and ends with Q4's closing stock. Sixth, putting selling and administrative costs into inventory.

Key takeaways

The operating budgets start from the sales budget, units times price. Production equals sales plus desired ending finished goods minus beginning finished goods. Materials purchases equal production needs plus desired ending materials minus beginning materials, priced per kilogram or unit. Labour hours and variable overhead follow production; fixed overhead stays constant each quarter. Selling and administrative costs follow sales and are period costs. Combining them gives the product cost per unit, budgeted cost of goods sold and budgeted operating income, here $174,000 before interest and tax.

Flashcards

Flashcard

Sales budget

Expected units sold × expected price, by period

The first schedule; every other budget depends on it.

Test your understanding

Question 1 of 5

Expected sales are 5,000 units, desired ending finished goods are 900 units and beginning finished goods are 700 units. How many units should be produced?

Question 2 of 5

Production is 3,000 units at 3 kg each. Desired ending material is 1,200 kg and beginning material is 1,500 kg. How many kilograms should be bought?

Question 3 of 5

A company budgets sales of 3,000 units and production of 2,400 units. Each unit needs 0.75 direct labour hours at $20 an hour. What is the direct labour budget?

Question 4 of 5

Which budget's variable costs are driven by units sold rather than units produced?

Question 5 of 5

A company budgets to make 11,540 units and sell 11,500 at a cost of $40 each, starting with 400 units and ending with 440. What is budgeted cost of goods sold?

← Previous topicNext topic →