UNSW Sydney · FACULTY OF ACCOUNTING

ACCT5996 Chap.4 Master Budgets and Cash Planning

- one subject, every graph, every model, every mark
7 Chapters4-page Bible
Our own words - no uploaded lecturer files
Updated for this semester
Chapter 4 of 6 · ACCT5996

Master Budgets and Cash Planning

A master budget translates plans into connected operating and financial schedules. This chapter follows sales assumptions into production, material purchases, cash receipts, cash payments and financing.

It separates accrual results from liquidity, applies inventory policies to the correct future period, and evaluates participation, slack and short-term behaviour as part of the budgeting process.

The schedules are treated as a dependency network.

Sales or a binding resource constraint sets the operating path; inventory policies shift requirements across periods; collection and payment patterns convert accrual amounts into cash timing; and the minimum-cash policy determines financing. Each balance is labelled by date so that one period's ending amount becomes the next period's beginning amount.

The chapter also tests assumptions for feasibility and behaviour, because a balanced spreadsheet can still rely on impossible capacity, hidden slack or a harmful short-term response.

In this chapter

What this chapter covers

  • 01

    Budget purposes and strategic planning

  • 02

    Sales and production dependencies

  • 03

    Finished-goods and material inventory policies

  • 04

    Cash collection and supplier payment schedules

  • 05

    Cash budget and minimum cash policy

  • 06

    Accrual profit versus cash timing

  • 07

    Participation, slack and behavioural consequences

Worked example · free

Build production and material purchases schedules

Q [4 marks]. The displayed weighting guides this original calculation and is not an official university mark allocation. Sales are 4,800 units in January, 5,400 in February and 6,000 in March. Ending finished goods equal 15% of next month's sales. January begins with 720 units. Each unit uses eight metres of timber. Calculate January production and timber purchases if February production is 5,490 units and January begins with 3,800 metres, with material ending inventory at 10% of next month's needs. (4 marks)
A dependency map.A dependency map. Sales assumptions drive collection timing and production needs; those schedules feed cash receipts and payments before financing is decided. SALES BUDGET CASH RECEIPTSPRODUCTIONSELLING COSTS CASH BUDGET
A dependency map. Sales assumptions drive collection timing and production needs; those schedules feed cash receipts and payments before financing is decided.
  • +1January desired finished goods are 15% of 5,400, giving 810 units.
  • +1January production is 4,800 plus 810 minus 720, giving 4,890 units.
  • +1January production needs 4,890 times eight, giving 39,120 metres; desired ending timber is 10% of 5,490 times eight, giving 4,392 metres.
  • +1January purchases are 39,120 plus 4,392 minus 3,800, giving 39,712 metres.
January production is 4,890 units and January timber purchases are 39,712 metres. The future sales forecast sets desired finished goods, while next month's production needs set desired material inventory.
Sia tip — Label every inventory balance by date and remember that one period's ending inventory becomes the next period's beginning inventory.
Glossary

Key terms

Master budget
The coordinated set of operating and financial schedules for a planning period.
Sales budget
The forecast of sales volume and revenue that often begins the budget sequence.
Production budget
The output required to meet sales and the finished-goods inventory policy.
Cash budget
A schedule of opening cash, receipts, payments, financing and closing cash.
Budgetary slack
Deliberate understatement of revenue or overstatement of cost to make a target easier.
Collection pattern
The timing percentages that convert credit sales into expected cash receipts.
Minimum cash
The lowest cash balance management plans to maintain through financing or other action.
FAQ

Master Budgets and Cash Planning FAQ

Why does the sales budget come first?

Expected demand usually drives production, resources and cash. If a scarce resource constrains output, that operational constraint may instead lead the planning sequence and cap feasible sales.

Why can a profitable month need borrowing?

Revenue may be earned before customers pay, while purchases, wages and other cash commitments fall due earlier. Accrual profit and liquidity therefore move on different schedules and require separate controls.

How should depreciation enter the cash budget?

Depreciation affects accounting profit but is not a current cash payment. Remove it from operating expense when converting the expense schedule into current-period cash outflows.

How can participation create slack?

Local managers contribute useful knowledge and commitment but may protect themselves with easier assumptions. Transparent driver evidence and review of contingencies can challenge slack without removing participation.

What is the best control for an inventory schedule?

Reconcile the whole horizon, not only each monthly formula. Total production should equal total sales plus the change in finished-goods inventory, while total material purchases should equal material used plus the change in material inventory. Label balances by date and confirm that every ending balance rolls into the next opening balance. These controls expose shifted months and duplicated inventory adjustments.

How should a cash shortfall be evaluated?

Locate when the balance first falls below the minimum and identify which collection, purchase, expense or capital assumption causes it. Test operational responses such as collection timing, supplier terms or inventory reduction before selecting borrowing. Then state the loan timing, interest treatment, repayment rule and operational cost of each alternative, because preserving cash can damage capacity or customer service.

Study strategy

Exam move

Draw the dependency order before calculating. Label beginning and ending inventories by month, and use the following period when a policy refers to future needs. Build collection and payment schedules separately before the cash summary. Reconcile opening cash plus inflows minus outflows plus financing to closing cash, then run a sensitivity on the assumption most likely to create a shortage.

Use a timeline for every percentage pattern and prove that collectible or payable fractions sum to the intended total. Distinguish cash from expense by marking depreciation, prepayments, accruals, asset purchases and loan flows separately. After the base budget balances, change one driver at a time and explain which linked schedules must be recomputed rather than editing only the closing cash figure.

Working through Master Budgets and Cash Planning in ACCT5996? Sia is AskSia’s AI Accounting tutor — ask any ACCT5996 Master Budgets and Cash Planning question and get a clear, step-by-step explanation grounded in how ACCT5996 is taught and assessed. Read this chapter free, then take your hardest questions to Sia.

A+Everything unlocked
Unlocks this Bible + all 103 of your UNSW Sydney subjects - and 1,000+ Bibles across every Australian university.
Sia - your ACCT5996 tutor, unlimited, worked the way the exam marks it
The full 4-page Bible + practice bank with worked solutions
Chrome extension - sync your LMS so Sia knows your deadlines
Bilingual EN / Chinese on every Bible and every Sia answer
$0.99 Trial
30-day money-back · cancel in one tap · how it works
ACCT5996 · Management Accounting and Business Analysis - independent study guide on the AskSia Library. More UNSW Sydney subjects · Microeconomics across all universities