9.2 Functional Budgets, Cash Budgets & Master Budgets

Functional Budgets, Cash Budgets & Master Budgets

Core Principle: Functional budgeting is an interconnected accounting architecture. Every operational plan serves as the mathematical foundation for the next, moving methodically from market demand or key limiting factor down to physical material quantities, labour hours, overhead absorption, cash liquidity flows, and finally consolidated financial statements. Mastering the formulas and timing differences across these budgets is crucial for professional management accounting.

---

1. The Interrelationship and Sequence of Functional Budgets

A functional budget is an operational budget relating to a specific business function, department, or cost centre. Because departments rely upon mutual resource inputs and outputs, functional budgets cannot be compiled in isolation. They follow a strict logical hierarchy:

                                Principal Budget Factor
                             (Usually Market Sales Demand)
                                           │
                                           ▼
                                     Sales Budget
                                (Units & Total Value)
                                           │
                                           ▼
                                   Production Budget
                              (Units to be Manufactured)
                                           │
         ┌─────────────────────────────────┼─────────────────────────────────┐
         ▼                                 ▼                                 ▼
 Direct Materials Usage            Direct Labour Budget             Production Overheads
  (kg, metres, litres)             (Hours & Wage Costs)             (Variable & Fixed)
         │                                 │                                 │
         ▼                                 │                                 │
 Direct Materials Purchases                │                                 │
     (Units & Cost)                        │                                 │
         │                                 │                                 │
         └─────────────────────────────────┼─────────────────────────────────┘
                                           │
                                           ▼
        ┌──────────────────────────────────┴──────────────────────────────────┐
        │ • Non-Production Overheads Budget (Selling, Admin & Distribution)    │
        │ • Capital Expenditure Budget (Plant & Machinery Acquisitions)       │
        └──────────────────────────────────┬──────────────────────────────────┘
                                           │
                                           ▼
                                      Cash Budget
                           (Receipts, Payments & Liquidity)
                                           │
                                           ▼
                                      Master Budget
                   ┌───────────────────────┴───────────────────────┐
                   ▼                                               ▼
      Budgeted Statement of Profit or Loss          Budgeted Statement of Financial Position

---

2. Core Functional Budget Formulas and Inventory Policies

1. The Sales Budget

The sales budget establishes total expected commercial turnover:

$\text{Budgeted Sales Revenue} = \text{Budgeted Sales Volume (Units)} \times \text{Budgeted Selling Price per Unit}$

2. The Production Budget

The production budget calculates the physical units that must be manufactured to fulfill sales commitments while satisfying inventory buffer policies:

$\text{Required Production Units} = \text{Budgeted Sales Units} + \text{Target Closing Finished Goods Inventory} - \text{Opening Finished Goods Inventory}$

• Why Closing Inventory is Added: Management must manufacture enough units to satisfy current customer demand plus leave the desired safety stock on hand at the end of the period.
• Why Opening Inventory is Subtracted: Goods already residing in the finished goods warehouse at the start of the period are available for immediate sale and do not need to be manufactured again.

3. The Direct Materials Usage Budget

Translates required production units into physical raw material consumption based on standard engineering specifications:

$\text{Direct Material Usage (Quantity)} = \text{Required Production Units} \times \text{Standard Material Usage per Unit}$

4. The Direct Materials Purchases Budget

Determines the raw material quantities that procurement must purchase from suppliers, accounting for raw material inventory buffer levels and standard purchase prices:

$\text{Required Material Purchases (Quantity)} = \text{Material Usage} + \text{Target Closing Raw Material Inventory} - \text{Opening Raw Material Inventory}$

$\text{Budgeted Purchases Cost (\$)} = \text{Required Material Purchases (Quantity)} \times \text{Standard Purchase Price per Unit}$

5. The Direct Labour Budget

Calculates total direct labour hours required to manufacture the planned production units, alongside total gross wages payable:

$\text{Budgeted Direct Labour Hours} = \text{Required Production Units} \times \text{Standard Labour Hours per Unit}$

$\text{Budgeted Direct Labour Cost (\$)} = \text{Budgeted Direct Labour Hours} \times \text{Standard Labour Rate per Hour}$

Note on Idle Time: If standard idle time is expected (e.g., 5% unproductive downtime for machine setup or maintenance), the productive hours must be grossed up:

$\text{Total Hours Paid} = \frac{\text{Productive Labour Hours Required}}{1 - \text{Idle Time Percentage}}$

6. Production and Non-Production Overhead Budgets

• Production Overheads: Split into variable factory overheads (budgeted as a rate per direct labour or machine hour) and fixed factory overheads (budgeted as constant periodic sums for factory rent, rates, and supervisor salaries).
• Non-Production Overheads: Administration overheads (executive salaries, accounting, legal fees) and selling and distribution overheads (sales commissions, advertising campaigns, delivery fleet fuel and maintenance).

---

3. Worked Comprehensive Numerical Example: Functional Budgets Cascade

Scenario: Kestrel Instruments Ltd manufactures a high-precision digital sensor, Sensor Alpha. The company is compiling its operational budget for the second quarter (April, May, and June). The following commercial data has been agreed upon:

Sales Volume Forecast:

• April: 4,000 units
• May: 5,000 units
• June: 6,000 units
• July (projected): 5,500 units
• Selling Price: $60.00 per unit

Inventory Policies & Cost Standards:

1. Finished Goods: Closing finished goods inventory at the end of each month must equal 20% of the following month's budgeted sales volume. Opening finished goods inventory on 1 April is 800 units.
2. Direct Materials (Component K): Each unit of Sensor Alpha requires 2.5 kg of Component K. The standard purchase price is $6.00 per kg.
3. Raw Materials Inventory: Closing inventory of Component K at the end of each month must equal 10% of the following month's material usage requirements. Opening inventory of Component K on 1 April is 1,050 kg.
4. Direct Labour: Each sensor requires 2.0 direct labour hours at a standard wage rate of $15.00 per hour.
5. July Production Baseline: To calculate the raw materials inventory for June, the production manager estimates that July production will be 5,400 units.

Step 1: Prepare the Sales Budget

$\text{Revenue} = \text{Volume} \times \$60.00$

Step 2: Prepare the Production Budget (Units)

Closing FG targets:

• 30 April: 20% of May sales (5,000) = 1,000 units
• 31 May: 20% of June sales (6,000) = 1,200 units
• 30 June: 20% of July sales (5,500) = 1,100 units

(Notice: For the Total Q2 column, closing inventory is 30 June's closing stock [1,100], and opening inventory is 1 April's opening stock [800]).

Step 3: Prepare the Direct Materials Usage Budget (Component K)

Usage per unit = 2.5 kg.

• April Usage: $4,200 \text{ units} \times 2.5 \text{ kg} = \mathbf{10,500 \text{ kg}}$
• May Usage: $5,200 \text{ units} \times 2.5 \text{ kg} = \mathbf{13,000 \text{ kg}}$
• June Usage: $5,900 \text{ units} \times 2.5 \text{ kg} = \mathbf{14,750 \text{ kg}}$
• Total Q2 Usage: $15,300 \text{ units} \times 2.5 \text{ kg} = \mathbf{38,250 \text{ kg}}$
• (July estimated usage: $5,400 \text{ units} \times 2.5 \text{ kg} = 13,500 \text{ kg})*

Step 4: Prepare the Direct Materials Purchases Budget

Target closing raw materials (10% of next month's usage):

• 30 April: 10% of May (13,000 kg) = 1,300 kg
• 31 May: 10% of June (14,750 kg) = 1,475 kg
• 30 June: 10% of July (13,500 kg) = 1,350 kg

Step 5: Prepare the Direct Labour Budget

Standard: 2.0 hours per unit at $15.00 per hour.

---

4. Cash Budgets: Structure, Timing & Liquidity Management

Profit versus Cash Flow: The Fundamental Distinction

A business cannot pay wages or suppliers with "profit"; it pays with cash. The Cash Budget forecasts cash receipts and cash payments over the budget period, isolating future cash surpluses or deficits.

                      Accrual Profit vs. Cash Flow
                      
    Statement of Profit or Loss                 Cash Budget
   ┌────────────────────────────┐              ┌────────────────────────────┐
   │ • Revenue recognized when  │              │ • Inflow recognized when   │
   │   invoiced (earned)        │              │   cash is collected        │
   │ • Expenses matched when    │              │ • Outflow recognized when  │
   │   incurred (consumed)      │              │   cash is disbursed        │
   │ • Non-cash items included  │              │ • Non-cash items (Deprec.) │
   │   (Depreciation, Bad Debts)│              │   are STRICTLY EXCLUDED    │
   │ • Capex amortized over life│              │ • Total Capex entered full │
   └────────────────────────────┘              └────────────────────────────┘

Structure of a Standard Cash Budget

1. Opening Cash Balance: Cash and bank balances at the start of each month.
2. Cash Receipts:
   • Cash sales (received immediately).
   • Collections from credit customers (lagged based on credit terms: e.g., Month 1, Month 2).
   • Proceeds from disposal of non-current assets.
   • Issue of shares, debentures, or bank loan drawdowns.
3. Cash Payments:
   • Payments to trade payables (lagged supplier settlement terms).
   • Direct labour payroll disbursements.
   • Cash operating overheads (excluding depreciation!).
   • Capital expenditure (full cash purchase price of property, plant, and equipment).
   • Corporation tax payments, loan interest, and dividend distributions.
4. Net Cash Flow for the Period: Total Receipts minus Total Payments.
5. Closing Cash Balance: Opening Cash Balance plus Net Cash Flow. (Becomes the opening balance for the subsequent period).

Managing Cash Fluctuations: Surpluses vs. Deficits

---

5. Worked Example: Cash Budget with Lagged Settlements

Scenario: Meridian Trading Ltd is preparing its monthly cash budget for the final quarter of the year (October, November, and December). The opening bank balance on 1 October is $15,000.

Commercial Forecasts:

• Sales Revenue: August (actual) = $120,000; September (actual) = $140,000; October (budget) = $160,000; November (budget) = $180,000; December (budget) = $200,000.
• Debtor Collection Terms:
  • 20% of sales are for immediate cash.
  • 80% are on credit. Credit sales are collected: 60% in the month following sale, 38% in the second month following sale, and the remaining 2% are written off as irrecoverable bad debts.
• Purchases of Materials: September (actual) = $70,000; October (budget) = $80,000; November (budget) = $95,000; December (budget) = $110,000. Suppliers offer one month's credit (purchases are paid in full in the month after purchase).
• Wages and Salaries: Budgeted at $35,000 per month, paid in the month incurred.
• General Overheads: Budgeted at $22,000 per month, which includes $4,000 monthly depreciation. Cash overheads are paid in the month incurred.
• Capital Expenditure: A new commercial transport van costing $28,000 will be purchased and paid for in November.
• Taxation: A corporation tax installment of $25,000 is due for payment in December.

Step 1: Calculate Credit Sales Baselines

Credit sales = 80% of total sales:

• August Credit: $120,000 \times 0.80 = $96,000$
• September Credit: $140,000 \times 0.80 = $112,000$
• October Credit: $160,000 \times 0.80 = $128,000$
• November Credit: $180,000 \times 0.80 = $144,000$
• December Credit: $200,000 \times 0.80 = $160,000$

Step 2: Calculate Monthly Cash Collections from Customers

$\text{Collections} = \text{Cash Sales (20\%)} + \text{Prior Month Credit (60\%)} + \text{Two Months Prior Credit (38\%)}$

• October Collections:

  • Cash Sales (20% of Oct $160,000) = $32,000
  • From Sept Credit (60% of $112,000) = $67,200
  • From August Credit (38% of $96,000) = $36,480
  • Total October Receipts = $135,680

• November Collections:

  • Cash Sales (20% of Nov $180,000) = $36,000
  • From Oct Credit (60% of $128,000) = $76,800
  • From Sept Credit (38% of $112,000) = $42,560
  • Total November Receipts = $155,360

• December Collections:

  • Cash Sales (20% of Dec $200,000) = $40,000
  • From Nov Credit (60% of $144,000) = $86,400
  • From Oct Credit (38% of $128,000) = $48,640
  • Total December Receipts = $175,040

Step 3: Compile the Cash Budget Table

Note on Overheads: Depreciation of $4,000 is a non-cash expense and must be deducted ($22,000 - $4,000 = $18,000 cash paid).

Analysis: Despite a net cash deficit of $5,640 in November caused by the $28,000 vehicle purchase, the opening surplus of $27,680 ensures the company maintains healthy positive bank balances throughout Q4 without requiring overdraft financing.

---

6. The Master Budget: Financial Statements & External Influences

Composition of the Master Budget

The Master Budget is the ultimate consolidation of all functional and cash budgets, presented in the standardized format of formal financial statements:

1. Budgeted Statement of Profit or Loss: Presents planned revenue, standard cost of goods sold, gross profit, distribution costs, administrative expenses, finance costs, and budgeted net profit for the year.
2. Budgeted Statement of Financial Position: Presents projected closing balances for non-current assets (cost less accumulated depreciation plus new capex), current assets (closing raw materials, WIP, finished goods, trade debtors, closing cash balance), current liabilities (trade creditors, accrued expenses, tax payable), and equity funding.

Macroeconomic Influences on Budgeting

Budgets cannot be compiled in an economic vacuum. Management accountants must incorporate macroeconomic variables into their models:

• Inflation Rates: Drives cost-push inflation in raw material purchase prices and nominal wage demands, while eroding consumer real disposable income.
• Interest Rates: Affects debt servicing costs on floating-rate bank loans and overdrafts, while influencing customer borrowing and consumer credit demand.
• Foreign Exchange Rates: Fluctuations impact import costs for foreign components and determine the price competitiveness of export sales.
• Fiscal & Trade Policy: Corporate tax rate revisions, customs tariffs on imported materials, and government subsidies directly alter cost structures.

Incorporating Sustainability and ESG Factors into Modern Budgets

Modern professional budgeting extends beyond traditional financial metrics to incorporate Environmental, Social, and Governance (ESG) commitments:

• Carbon Budgeting: Establishing organizational carbon emissions caps (covering Scope 1 direct fuel, Scope 2 electricity, and Scope 3 supply chain emissions) allocated across operating divisions alongside financial expense ceilings.
• Energy Efficiency Capital Allocations: Ring-fencing capital expenditure budgets specifically for solar photovoltaic installations, heat pump retrofits, and high-efficiency machinery.
• Sustainable Procurement Budgets: Factoring in the price premiums required to source certified sustainable, fair-trade, or recycled raw materials.
• Waste and Circularity Targets: Budgeting for scrap reduction, closed-loop solvent recycling, and hazardous waste remediation fees to comply with environmental regulations (such as the EU CSRD and ISSB IFRS S1/S2 standards).