Functional Budgets: Sales Production Raw Material Cash Master Budget
1. The Interlocking Architecture of Functional Budgets
A Functional Budget is an operational plan dedicated to a specific business activity or organizational department. Functional budgets are not prepared in isolation; they form an interlocking chain where the outputs of one schedule serve as direct inputs for the next.
The master sequence begins with the Sales Budget (assuming market demand is the principal budget factor). This dictates the Production Budget, which in turn drives the Raw Material Purchase Budget, Direct Labour Budget, and Factory Overhead Budget. These operational schedules flow into the Cash Budget, culminating in the consolidated Master Budget.
2. Operational Schedules: Sales, Production, Materials & Labour
The operational budgeting chain relies on clear mathematical formulas for each functional area:
Mathematical Formulary: Functional Budgets
Purchase Cost = Purchase Units × Standard Price
3. Cash Budget Mechanics: The Receipts & Payments Method
The Cash Budget forecasts an enterprise's cash inflows and outflows over a specific period. It is vital for ensuring organizational solvency, identifying upcoming liquidity shortfalls or surpluses, and arranging bank overdraft facilities or short-term investments in advance.
The most widely used approach is the Receipts & Payments Method. Key operational considerations include:
- Distinction Between Revenue and Cash Inflow: Credit sales generate accounting revenue immediately, but cash arrives only after the credit collection lag (e.g., 30 or 60 days).
- Distinction Between Expense and Cash Outflow: Purchases on credit, monthly wages, and operating overheads involve payment time-lags (e.g., wages paid in the first week of the following month).
- Exclusion of Non-Cash Charges: Depreciation, amortization, and provisions for bad debts involve no cash movement and are excluded entirely from the cash budget.
- Non-Operating Cash Transactions: Capital expenditures (equipment purchases), dividend distributions, tax payments, share issuances, and debenture redemptions must be included in their respective payment months.
4. Comprehensive Solved Cash Budget Numerical (10-Mark AKTU Parity)
Below is a standard AKTU 10-mark examination problem requiring the preparation of a monthly cash budget covering a three-month period.
AKTU Exam Problem: Three-Month Cash Budget (April to June)
Zenith Industrial Solutions Ltd. provides the following budgeted operational figures for the first half of the year:
| Month | Total Sales (₹) | Purchases (₹) | Wages (₹) | Manufacturing Overheads (₹) |
|---|---|---|---|---|
| February | ₹ 1,80,000 | ₹ 1,20,000 | ₹ 20,000 | ₹ 15,000 |
| March | ₹ 1,90,000 | ₹ 1,40,000 | ₹ 22,000 | ₹ 16,000 |
| April | ₹ 2,10,000 | ₹ 1,50,000 | ₹ 24,000 | ₹ 17,000 |
| May | ₹ 2,40,000 | ₹ 1,60,000 | ₹ 26,000 | ₹ 18,000 |
| June | ₹ 2,20,000 | ₹ 1,30,000 | ₹ 25,000 | ₹ 16,000 |
Additional Information:
- Opening Cash Balance on 1st April is estimated at ₹ 50,000.
- Sales Policy: 20% of sales are on a cash basis; remaining 80% are collected in the month following the sale.
- Credit allowed by suppliers is 1 month (all purchases are on credit).
- Delay in payment of wages is 0.5 month (50% paid in current month, 50% paid in following month).
- Delay in payment of manufacturing overheads is 1 month.
- Advance income tax of ₹ 30,000 is payable in June.
- Plant machinery costing ₹ 40,000 is scheduled for delivery and payment in April.
Required: Prepare a Cash Budget for the three months ending 30th June (April, May, June).
Step 1: Supporting Working Schedules
• April Collection = 80% of March Sales (₹ 1,90,000) = ₹ 1,52,000
• May Collection = 80% of April Sales (₹ 2,10,000) = ₹ 1,68,000
• June Collection = 80% of May Sales (₹ 2,40,000) = ₹ 1,92,000
2. Cash Sales (20% current month):
• April: 20% × ₹ 2,10,000 = ₹ 42,000 | May: 20% × ₹ 2,40,000 = ₹ 48,000 | June: 20% × ₹ 2,20,000 = ₹ 44,000
3. Payment to Creditors (1-month credit lag):
• April Payment = March Purchases = ₹ 1,40,000
• May Payment = April Purchases = ₹ 1,50,000
• June Payment = May Purchases = ₹ 1,60,000
4. Wages Payment (50% current month + 50% prior month):
• April: 50% March (₹ 11,000) + 50% April (₹ 12,000) = ₹ 23,000
• May: 50% April (₹ 12,000) + 50% May (₹ 13,000) = ₹ 25,000
• June: 50% May (₹ 13,000) + 50% June (₹ 12,500) = ₹ 25,500
5. Payment of Manufacturing Overheads (1-month lag):
• April = March Overheads = ₹ 16,000 | May = April = ₹ 17,000 | June = May = ₹ 18,000
Step 2: Monthly Cash Budget Schedule
| Particulars | April (₹) | May (₹) | June (₹) |
|---|---|---|---|
| Opening Cash Balance | ₹ 50,000 | ₹ 25,000 | ₹ 49,000 |
| (A) Cash Receipts | |||
| Cash Sales (20%) | ₹ 42,000 | ₹ 48,000 | ₹ 44,000 |
| Collections from Debtors (80%) | ₹ 1,52,000 | ₹ 1,68,000 | ₹ 1,92,000 |
| Total Receipts (A) | ₹ 1,94,000 | ₹ 2,16,000 | ₹ 2,36,000 |
| Total Cash Available (Opening + Receipts) | ₹ 2,44,000 | ₹ 2,41,000 | ₹ 2,85,000 |
| (B) Cash Payments | |||
| Payment to Creditors | ₹ 1,40,000 | ₹ 1,50,000 | ₹ 1,60,000 |
| Payment of Wages | ₹ 23,000 | ₹ 25,000 | ₹ 25,500 |
| Payment of Manufacturing Overheads | ₹ 16,000 | ₹ 17,000 | ₹ 18,000 |
| Purchase of Plant & Machinery | ₹ 40,000 | ā | ā |
| Payment of Advance Income Tax | ā | ā | ₹ 30,000 |
| Total Payments (B) | ₹ 2,19,000 | ₹ 1,92,000 | ₹ 2,33,500 |
| Closing Cash Balance (Available - Payments) | ₹ 25,000 | ₹ 49,000 | ₹ 51,500 |
5. The Master Budget: Apex Financial Integration
The Master Budget represents the consolidation of all functional, operating, and financial budgets into an integrated enterprise financial plan. It synthesizes operational projections into two primary corporate statements:
- Budgeted Profit & Loss Account (Budgeted Income Statement): Projects gross margin, operating profit (EBIT), financing interest costs, taxes, and net profit after tax.
- Budgeted Balance Sheet: Projects the enterprise's asset, liability, and equity position at the close of the budget period, reflecting planned capital investments and debt servicing.
6. Visual Framework: Interlocking Functional Budget Hierarchy
The visual layout below summarizes the operational flow of functional budgeting: Sales-to-Production conversion, Material Procurement, Receipts & Payments Cash Architecture, and Master Consolidation:
7. Corporate Case Vignette: Asian Paints Working Capital Budgeting
Corporate Application: Managing Working Capital Lags Ahead of Festive Season
India's decorative coatings market leader, Asian Paints Ltd., generates over 40% of its annual sales volume during the pre-Diwali festive painting season (SeptemberāNovember). To support this volume, manufacturing facilities run at peak output during August and September, requiring substantial advance procurement of pigments, solvents, and packaging materials.
Asian Paints' treasury team coordinates its Production and Cash Budgets to manage working capital. While raw material purchases and manufacturing wages create heavy cash outflows in July and August, collections from dealer trade credit materialize only in October and November.
By using a dynamic monthly Cash Budgeting model, Asian Paints identifies seasonal liquidity gaps months in advance. The treasury team arranges commercial paper (CP) issuances at competitive rates to fund inventory build-up, and deploys surplus dealer cash collections into liquid mutual funds post-Diwali, minimizing net interest costs across the business cycle.
8. AKTU Exam Orientation: Solved Theoretical & Practical Questions
Section A (2 Marks Conceptual Questions)
Answer: $\text{Budgeted Production (Units)} = \text{Budgeted Sales Units} + \text{Desired Closing Finished Goods Inventory} - \text{Opening Finished Goods Inventory}$.
Answer: The Cash Budget tracks physical movements of cash. Depreciation is an accounting allocation of past capital cost and involves no cash outflow, so it is excluded from cash budget receipts and payments.
Answer: The Master Budget is the apex consolidated financial budget that summarizes all underlying functional budgets into a projected Budgeted Profit & Loss Account and Budgeted Balance Sheet for executive ratification.
Answer: In most commercial enterprises, market sales demand is the principal budget factor that restricts operations. The volume of goods that can be sold dictates the volume that needs to be produced, procured, and financed.
Section B & C (10 Marks Analytical Questions)
Structuring the 10-Mark Answer:
- Flowchart: Present the budgeting sequence: Sales Budget → Production Budget → Direct Materials / Direct Labour / Factory Overheads → Cost of Production → Cash Budget → Master Budget.
- Functional Budget Mechanics:
- Sales Budget: Quantitative product-line and regional targets multiplied by selling price.
- Production Budget: Adjusts sales volume for opening and desired closing inventory levels.
- Materials Budgets: Translates production units into raw material consumption and procurement schedules.
- Labour & Overhead Budgets: Establishes staffing requirements, machine hour allocations, and operational spending.
- Consolidation into the Master Budget: Explain how functional schedules culminate in the budgeted income statement and balance sheet for board review.
Structuring the 10-Mark Answer:
- Structure of Receipts and Payments: Detail the layout: Opening Cash + Cash Inflows (cash sales, debtor collections, asset sales) = Cash Available; minus Cash Outflows (creditors, wages, overheads, Capex, tax) = Closing Balance.
- The Time-Lag Phenomenon: Explain credit periods (debtors and creditors) and payment delays (wages and overheads), showing how revenue recognition differs from cash realization.
- Solvency and Treasury Decisions: Discuss how anticipating cash shortfalls enables timely credit line arrangements, while identifying cash surpluses allows profitable short-term treasury investments.
Discussion & Questions
0 CommentsAcademic insights, questions, and conceptual clarifications from students & faculty.
No questions or comments yet
Have a doubt about this topic, an exam tip, or a conceptual perspective? Start the discussion below!
Leave a Comment / Ask a Question
Your email address will not be published. Required fields are marked *