Build a master budget and coordinate schedules
Trace the sales, operating, cash and financial-statement schedules that combine into a master budget.
Cambridge International AS & A Level Accounting 9706, 2026–2028 syllabus, Version 2. Topic 4.3 covers budgetary control, linked master-budget schedules, spreadsheets, limiting factors, flexible budgets, reconciliations, behavioural effects and supported decisions. Practice is self-checked, not an official Cambridge grade. Full timed Papers 1–4 and human subject-teacher review remain outstanding.
Before you begin
- Use AS Topics 2.1–2.2 for cost behaviour, contribution and budgeting foundations. For each schedule, label the period, units, price, inventory policy, timing assumptions and opening balance before calculating.
Work on paper. Try each question before revealing help, and explain why your method works.
Quick readiness check
Which schedule commonly helps drive a production budget?
What you will learn
- Define a master budget
- Explain links between operating and financial budgets
- Assess spreadsheet preparation and controls
Schedules feed one another
A master budget is the linked set of budgets for an organisation, including operating schedules and financial budgets. Sales assumptions often drive production or purchases; those schedules drive labour, cash payments, inventory and the budgeted statements.
A useful preparation order follows these dependencies: estimate sales, prepare output or purchase needs, calculate resource requirements, then prepare cash and financial statements. If assumptions change, update the affected schedules and check that totals still agree.
Spreadsheets improve speed but need controls
Spreadsheets can calculate repeated schedules quickly, change assumptions for scenarios and share information across departments. A transparent model can help managers see how a sales forecast affects output and cash.
A wrong formula, overwritten cell, outdated version or unprotected input can produce plausible but incorrect totals. Use clear labels, documented assumptions, formula checks, access controls, version review and independent checks of key outputs; do not treat automation as proof of accuracy.
Pause and explain
A spreadsheet shows lower cash after the sales forecast falls. What should be checked?
Worked example
Sales are forecast at 8,000 units. Production needs 1.5 labour hours per unit. Explain how a sales change may affect the master budget.
Show the worked solution
- A sales forecast affects required units to produce, after inventory changes.
- Production units multiplied by 1.5 hours gives budgeted labour hours.
- Hours affect labour cost and cash payments, so linked schedules should be updated.
Answer A sales change can flow through production, labour, purchasing, cash and financial statements. Each dependent schedule should use the same revised assumptions.
Try a topic test
Choose Easy, Normal or Difficult. Save your answers and open worked review after finishing.
Test this topic →From guided practice to a new situation
Write your answer and reasoning first. Use a hint only if you are stuck. The model solution is for self-checking; your written work is not automatically marked.
Production rises by 200 units, each using 3 labour hours. Which linked budget amount changes, and by how much?
Give me a hint
Multiply the additional units by hours per unit.
Compare my reasoning
- Additional hours = 200 × 3 = 600.
- The labour-hours budget should increase by 600 hours.
- The labour-cost budget also changes using the applicable wage rate.
Budgeted labour hours rise by 600; multiply those hours by the stated rate to revise labour cost.
Look for these in your work
- Calculate incremental hours
- Identify labour schedule
- Link hours to cost
List three controls that reduce the risk of an inaccurate spreadsheet budget.
Give me a hint
Think about input, formula and output review.
Compare my reasoning
- Document sources and assumptions for inputs.
- Protect formula cells and review changes or versions.
- Independently check key totals and linked schedule reconciliations.
Suitable controls include source documentation, protected formulas, version history, access restrictions and independent checks of outputs and linked totals.
Look for these in your work
- Input control
- Formula/version control
- Output check
Two departments use different versions of a shared budget. Give a practical control before management approves the master budget.
Give me a hint
Establish one controlled source and confirm the key assumptions with both departments.
Compare my reasoning
- Identify the authorised current version and its owner.
- Reconcile sales, output, staffing and payment assumptions across schedules.
- Lock the approved version and record later changes with dates and reasons.
Use one controlled version, reconcile shared assumptions and log approved changes so departments and decision-makers rely on the same plan.
Look for these in your work
- Version controlled
- Assumptions reconciled
- Changes traceable
Common mistakes
- Treating the master budget as a single worksheet total
- Changing one schedule without updating dependent budgets
- Assuming a spreadsheet formula cannot be wrong
What can you explain now?
What makes a set of budgets a master budget?
Compare with the explanation
Its schedules are coordinated and linked across the organisation
The master budget combines linked operating and financial budgets for the period.
After trying it yourself, choose your next review. This is your self-assessment.
Your review choice appears on Today. Sign in to sync it across devices.
Make it stick
What is a master budget, and why must a spreadsheet budget be checked?
If you needed the solution, close it and solve the problem again from a blank page. A correct answer is stronger when you can explain the reason for each step.