Worked solution
(a)(i) Production budget (units)
$$\begin{array}{lrrr}
\hline
\textbf{Month} & \textbf{October} & \textbf{November} & \textbf{December} \\
\hline
\text{Budgeted sales (units)} & 4\,000 & 5\,000 & 6\,000 \\
\text{Add: Budgeted closing inventory} & 1\,000 & 1\,200 & 900 \\
\hline
\text{Total units required} & 5\,000 & 6\,200 & 6\,900 \\
\text{Less: Opening inventory} & (800) & (1\,000) & (1\,200) \\
\hline
\textbf{Budgeted production (units)} & \mathbf{4\,200} & \mathbf{5\,200} & \mathbf{5\,700} \\
\hline
\end{array}$$
Workings:
- Closing inventory:
- Oct: $20\% \times 5\,000 = 1\,000$
- Nov: $20\% \times 6\,000 = 1\,200$
- Dec: $20\% \times 4\,500 = 900$
---
(a)(ii) Raw materials purchases budget
$$\begin{array}{lrrr}
\hline
\textbf{Month} & \textbf{October} & \textbf{November} & \textbf{December} \\
\hline
\text{Material required for production (kg)} & 10\,500 & 13\,000 & 14\,250 \\
\text{Add: Budgeted closing inventory (kg)} & 1\,300 & 1\,425 & 1\,150 \\
\hline
\text{Total material required (kg)} & 11\,800 & 14\,425 & 15\,400 \\
\text{Less: Opening inventory (kg)} & (1\,050) & (1\,300) & (1\,425) \\
\hline
\textbf{Budgeted purchases (kg)} & \mathbf{10\,750} & \mathbf{13\,125} & \mathbf{13\,975} \\
\text{Standard purchase price per kg} & \$8 & \$8 & \$8 \\
\hline
\textbf{Budgeted purchase cost (\$)} & \mathbf{\$86\,000} & \mathbf{\$105\,000} & \mathbf{\$111\,800} \\
\hline
\end{array}$$
Workings:
- Material usage for production:
- Oct: $4\,200 \times 2.5 = 10\,500\text{ kg}$
- Nov: $5\,200 \times 2.5 = 13\,000\text{ kg}$
- Dec: $5\,700 \times 2.5 = 14\,250\text{ kg}$
- Closing inventory (10% of following month requirement):
- Oct: $10\% \times 13\,000 = 1\,300\text{ kg}$
- Nov: $10\% \times 14\,250 = 1\,425\text{ kg}$
- Dec: $10\% \times 11\,500 = 1\,150\text{ kg}$
---
(b) Cash budget for the three months ending 31 December 2026
$$\begin{array}{lrrr}
\hline
& \textbf{October (\$)} & \textbf{November (\$)} & \textbf{December (\$)} \\
\hline
\textbf{Receipts:} & & & \\
\text{Cash sales} & 70\,560 & 88\,200 & 105\,840 \\
\text{Receipts from credit customers} & 168\,000 & 168\,000 & 210\,000 \\
\hline
\textbf{Total receipts} & \mathbf{238\,560} & \mathbf{256\,200} & \mathbf{315\,840} \\
\hline
\textbf{Payments:} & & & \\
\text{Trade payables (materials)} & 95\,000 & 86\,000 & 105\,000 \\
\text{Direct labour} & 75\,600 & 93\,600 & 102\,600 \\
\text{Variable overheads} & 25\,200 & 31\,200 & 34\,200 \\
\text{Fixed overheads} & 18\,000 & 18\,000 & 18\,000 \\
\text{Machinery purchase} & - & 20\,000 & 20\,000 \\
\hline
\textbf{Total payments} & \mathbf{213\,800} & \mathbf{248\,800} & \mathbf{279\,800} \\
\hline
\textbf{Net cash flow} & \mathbf{24\,760} & \mathbf{7\,400} & \mathbf{36\,040} \\
\text{Opening bank balance} & 15\,000 & 39\,760 & 47\,160 \\
\hline
\textbf{Closing bank balance} & \mathbf{39\,760} & \mathbf{47\,160} & \mathbf{83\,200} \\
\hline
\end{array}$$
Workings:
- Total sales value: Oct $4\,000 \times $60 = $240\,000$; Nov $5\,000 \times $60 = $300\,000$; Dec $6\,000 \times $60 = $360\,000$.
- Cash sales ($30\% \text{ after } 2\% \text{ discount} = 30\% \times 98\% = 29.4\%$):
- Oct: $$240\,000 \times 0.294 = \$70\,560\$
- Nov: $$300\,000 \times 0.294 = $88\,200$
- Dec: $$360\,000 \times 0.294 = \$105\,840\$
- Credit customer receipts (\$70\%\$ received 1 month in arrears):
- Oct: Sept credit sales balance = $$168\,000$
- Nov: Oct credit sales = $70\% \times $240\,000 = $168\,000$
- Dec: Nov credit sales = $70\% \times $300\,000 = $210\,000$
- Direct labour cost ($1.5\text{ hours} \times $12 = $18\text{ per unit}$ produced):
- Oct: $4\,200 \times $18 = $75\,600$
- Nov: $5\,200 \times $18 = $93\,600$
- Dec: $5\,700 \times $18 = $102\,600$
- Variable overheads ($1.5\text{ hours} \times $4 = $6\text{ per unit}$ produced):
- Oct: $4\,200 \times $6 = $25\,200$
- Nov: $5\,200 \times $6 = $31\,200$
- Dec: $5\,700 \times $6 = $34\,200$
- Note: Factory depreciation of $$6\,000$ per month is a non-cash expense and is omitted from the cash budget.
---
(c) Advice on adopting participative budgeting
Benefits of participative budgeting:
- Improves motivation and morale of operational managers as they feel involved in setting targets and their opinions are valued.
- Increases accuracy and realism of budget estimates because lower-level managers possess closer day-to-day knowledge of operational constraints, machine capacities, and supplier conditions.
- Enhances commitment and goal congruence; managers are more likely to take ownership of budgets they helped create rather than seeing them as unreasonable imposed targets.
Drawbacks of participative budgeting:
- Increases the risk of budgetary slack (cushioning/padding budgets by overestimating costs or underestimating revenues) so that targets are easily achieved.
- More time-consuming and expensive to co-ordinate, negotiate, and consolidate across multiple departments.
- Sub-unit managers may focus on departmental self-interest rather than overarching corporate strategic objectives.
Evaluation / Conclusion:
- Calverton Ltd should adopt a participative budgeting approach, but ensure senior management exercises rigorous oversight, review, and benchmarking to challenge proposed targets and prevent the creation of excessive budgetary slack.
Marking scheme
(a)(i) Production budget (3 marks)
- 1 mark for correct calculation of closing inventories (1 000, 1 200, 900)
- 1 mark for correct opening inventory treatments (800, 1 000, 1 200)
- 1 mark for all three final production unit figures (4 200, 5 200, 5 700)
(a)(ii) Raw materials purchases budget (6 marks)
- 1 mark for material usage calculation (10 500, 13 000, 14 250 kg)
- 1 mark for closing inventory calculation (1 300, 1 425, 1 150 kg)
- 1 mark for opening inventory deduction (1 050, 1 300, 1 425 kg)
- 1 mark for purchase quantities in kg (10 750, 13 125, 13 975 kg)
- 2 marks (1 mark for Oct/Nov, 1 mark for Dec) for purchase values in $ ($86 000, $105 000, $111 800)
(b) Cash budget (10 marks)
- 2 marks for cash sales (1 mark if discount correctly applied to all 3 months: $70 560, $88 200, $105 840)
- 2 marks for receipts from credit customers ($168 000, $168 000, $210 000)
- 1 mark for payments to trade payables ($95 000, $86 000, $105 000 [Own Figure from (a)(ii)])
- 1 mark for direct labour payments ($75 600, $93 600, $102 600 [Own Figure from (a)(i)])
- 1 mark for variable overhead payments ($25 200, $31 200, $34 200 [Own Figure from (a)(i)])
- 1 mark for fixed overheads ($18 000 each month) and omission of depreciation
- 1 mark for machinery payments ($20 000 in Nov, $20 000 in Dec)
- 1 mark for correctly derived net cash flow and closing bank balances ($39 760, $47 160, $83 200)
(c) Evaluative Advice (6 marks)
- Up to 2 marks for benefits of participative budgeting (motivation, practical operational insight, goal congruence).
- Up to 2 marks for drawbacks of participative budgeting (budgetary slack, time-consuming process, potential conflict/lack of strategic alignment).
- 2 marks for a clear, justified conclusion/advice based on candidate's points.