mindstair

Home / Courses / Managerial Accounting / Unit 7

Managerial Accounting Unit 7: Budgeting and the Master Budget

The master budget turns a sales forecast into a full set of plans for production, purchases, labor, cash and financial statements. Students must be able to prepare each schedule in the right order.

Covers: Purposes of budgeting and behavioral issues, Sales and production budgets, Direct materials, labor and overhead budgets, Selling and administrative expense budget, Cash collections and disbursements, Cash budget and financing, Budgeted income statement and balance sheet

Study guide

A budget is a detailed plan for acquiring and using resources over a period. Budgets help managers plan, coordinate departments, communicate goals, allocate resources and evaluate performance. How a budget is set matters. In participative (self-imposed) budgeting, managers help prepare their own budgets, which improves accuracy and commitment but invites budgetary slack, the padding of costs or understating of revenue to make targets easier. Many firms use a continuous or rolling budget that always looks 12 months ahead. Zero-based budgeting requires every expense to be justified from scratch rather than adjusted from last year.

The master budget is a linked set of schedules. It begins with the sales budget: budgeted units × price. The production budget follows: required production = budgeted sales + desired ending finished goods - beginning finished goods. Next comes the direct materials budget: materials needed for production + desired ending materials - beginning materials = materials to purchase, then times cost per unit. The direct labor budget multiplies units produced by labor-hours per unit and the wage rate. The manufacturing overhead budget lists variable and fixed overhead, and the selling and administrative budget lists those period costs. Inventory targets are often a percentage of the next period's needs.

The cash budget gathers the cash effects of all the operating budgets. Cash receipts come mainly from collections of sales, which follow a pattern, such as 60% in the month of sale and 40% the next month. Cash disbursements include payments for materials (often lagging purchases), direct labor, overhead, selling and administrative costs, equipment, taxes and dividends. Non-cash expenses such as depreciation are excluded. The format is: beginning cash + receipts = cash available; minus disbursements = excess or deficiency; plus borrowing or minus repayments and interest = ending cash. Borrowing is set to keep the required minimum balance.

The last pieces are the budgeted income statement and budgeted balance sheet. The income statement uses budgeted sales, cost of goods sold (units sold × budgeted unit product cost), selling and administrative expenses and interest. The balance sheet uses ending balances from the schedules: ending cash from the cash budget, receivables from uncollected sales, inventories from the production and materials budgets, and payables from unpaid purchases. Because everything links back to the sales forecast, an error in sales flows through every schedule. A static master budget is set for one activity level, so it cannot be used alone to judge costs when actual activity differs.

Key ideas

Formulas and rules

Production (units) = Budgeted sales + Desired ending FG - Beginning FG
Materials to purchase = Production × Materials per unit + Desired ending RM - Beginning RM
Direct labor cost = Units produced × DLH per unit × Wage rate
Cash available = Beginning cash + Cash receipts
Ending cash = Cash available - Disbursements + Borrowing - Repayments - Interest
Merchandise purchases = COGS + Desired ending inventory - Beginning inventory

Common mistakes

Before the test, make sure you can

Words to know

Budget
A detailed plan, usually in dollars, for acquiring and using resources over a period.
Master budget
A linked set of budgets covering operations and finances for a period.
Sales budget
A schedule of expected sales in units and dollars; the starting point of the master budget.
Production budget
A schedule of units that must be produced to meet sales and inventory targets.
Direct materials budget
A schedule of materials needed and materials to purchase.
Direct labor budget
A schedule of labor-hours and labor cost needed for planned production.
Cash budget
A schedule of expected cash receipts, disbursements and financing.
Schedule of expected cash collections
A schedule showing when sales will be collected in cash.
Budgeted balance sheet
A projected balance sheet using ending balances from the other budgets.
Participative budget
A budget prepared with the input of the managers responsible for meeting it.
Budgetary slack
Padding in a budget from underestimating revenues or overestimating costs.
Continuous budget
A rolling budget that adds a new period as each period ends.
Zero-based budgeting
A method requiring every expense to be justified from zero each period.
Static budget
A budget prepared for one planned level of activity.
Minimum cash balance
The lowest cash balance a company wants to hold; it determines borrowing needs.

Sample practice questions

30 more questions like these, from level 1 to 5, are in the practice set.

Question 1 (level 1)

Which budget is usually prepared first because most other budgets depend on it?

  1. Sales budget
  2. Cash budget
  3. Budgeted balance sheet
  4. Production budget
Show the answer and steps

Answer: A) Sales budget

  1. The master budget starts with expected sales.
  2. Production, purchases, labor, selling expenses and cash collections all depend on sales volume.
  3. The cash budget and budgeted statements come near the end.
Question 2 (level 1)

Required production in units equals:

  1. Budgeted sales + beginning finished goods
  2. Budgeted sales + desired ending finished goods - beginning finished goods
  3. Budgeted sales - desired ending finished goods + beginning finished goods
  4. Desired ending finished goods - beginning finished goods
Show the answer and steps

Answer: B) Budgeted sales + desired ending finished goods - beginning finished goods

  1. Production must cover sales and leave the desired ending inventory.
  2. Units already on hand at the start reduce what must be made.
  3. So production = sales + desired ending FG - beginning FG.
Question 3 (level 3)

Quarterly sales are budgeted at 6,000, 7,000 and 8,000 units for Q1-Q3, and 9,000 units for Q4. Ending finished goods must equal 25% of the next quarter's sales, and Q1 beginning inventory met that policy. What is budgeted production for Q2?

  1. 7,000 units
  2. 6,750 units
  3. 9,000 units
  4. 7,250 units
Show the answer and steps

Answer: D) 7,250 units

  1. Q2 desired ending FG = 25% × 8,000 = 2,000.
  2. Q2 beginning FG = Q1 ending = 25% × 7,000 = 1,750.
  3. Production = 7,000 + 2,000 - 1,750 = 7,250.