5.5 Cash Flow Forecasting, Budgeting & Variance Analysis

1. Real-World Case Dilemma

Case Context: A Singapore commercial construction contractor wins a $10 million contract to build a community sports facility.

• The project will take 12 months, and the government client will pay the full S$10 million upon final building completion in Month 12.
• In Months 1 through 6, the contractor must spend S$600,000 every month in cash on concrete, steel, crane rentals, and construction workers’ wages.

The company is guaranteed to make a massive S$2.8 million net profit in Month 12. Why will the business collapse into total liquidation in Month 4 if it fails to prepare a monthly Cash Flow Forecast and arrange financing in advance?

2. Key Terms & Jargon Decoder

3. Concept & Visual Anchor

Master Variance Analysis Framework

\text{Variance (S\$)} = \text{Actual Financial Result} - \text{Budgeted Financial Figure}

The 3 Core Roles of Budgeting in Decision-Making

4. Check Your Understanding

5. Exam Error Surgery: Fix the Weak Answer

Paper 1 Section A Prompt (8 marks): Explain why cash flow forecasts are subject to high uncertainty, and analyze the consequences of an unexpected cash deficit for a business.

6. Strategic Evaluation Matrix

7. “I Do / We Do / You Do” Exam Scaffolds

“I Do” Annotated Model Answer (12 marks)

Question: Evaluate whether a retail business should use flexible budgeting rather than fixed budgeting to control its operational costs.

[AO1/AO2 Definition & Context]

A fixed budget establishes cost and revenue limits based strictly on a single, planned level of output, whereas a flexible budget dynamically recalculates cost allowances to reflect the actual level of output and sales volume achieved during the period.

[AO3 Analysis: The Critical Flaw of Fixed Budgeting]

In dynamic retail markets, customer sales volume constantly fluctuates. If a retail chain budgets for 10,000 customer sales, its total variable cost budget is set at S$50,000. If actual sales surge to 20,000 units due to a successful marketing campaign, actual variable costs will rise to S$95,000. Under a fixed budget, the variance shows a massive S$45,000 Adverse variance, misleading executive directors into penalizing store managers for “overspending”, when in reality the higher costs were the natural, profitable result of doubling sales volume! Fixed budgeting distorts performance evaluation.

[AO3 Analysis: Superiority of Flexible Budgeting]

Flexible budgeting eliminates this distortion by adjusting variable cost allowances to match the actual 20,000 units achieved. The flexible budget allowance becomes S$100,000. Comparing the actual S$95,000 spend against the S$100,000 flexible budget reveals a S$5,000 Favourable variance—correctly identifying that store managers controlled variable costs with high efficiency per unit sold. This provides fair, meaningful managerial performance evaluation.

[AO4 Evaluative Judgment]

In conclusion, flexible budgeting is vastly superior for operational cost control:

1. It separates the volume variance (caused by sales demand) from the cost-efficiency variance (controlled by operations managers), enabling precise diagnostic accountability.
2. However, fixed costs (§5.3) (such as store rent, manager salaries, and insurance) must remain strictly fixed in the budget, as they should never increase simply because output changed.

“We Do” Guided Practice Scaffold

Question: Explain why an Adverse direct material variance of $20,000 might actually be caused by the purchasing department buying cheap, low-grade raw materials (6 marks).

Complete the analytical sentences using the provided sentence frames:

1. [Cheap Materials Cause Scrap Waste] When the purchasing department buys substandard, cheap ingredients to save money, the factory line suffers frequent breakages and defects (§4.6), which causes workers to \dots (Hint: explain why workers must use extra quantities of raw materials to replace scrapped defects).
2. [Net Adverse Outcome] While the unit purchase price was slightly lower, the massive physical material wastage and machine rework hours inflated total material consumption, resulting in \dots (Hint: explain how total actual material spending exceeded the budget, creating an Adverse variance).

“You Do” Independent Exam Practice

8. Self-Diagnosis & Retrieval Matrix