Budgeting & Functional Budgeting: Types, Process, and Real-World Applications

TAKEAWAYS:

• Budgeting is a planning tool that aligns financial goals with operational activities, using historical data, market trends, and strategic objectives.
• Functional budgets (sales, production, materials, labor, overhead) are interdependent and feed into the master budget, which includes cash flow and budgeted financial statements.
• The budgeting process follows a cycle: preparation, approval, implementation, and control, with feedback loops for continuous improvement.
• Variance analysis compares actual vs. budgeted figures to identify deviations and take corrective actions.
• Real-world applications include eSewa’s cash flow budgeting, Daraz’s sales and inventory budgets, and Nepal Rastra Bank’s monetary policy budgets.
• Zero-based budgeting and activity-based budgeting are advanced techniques used by modern businesses to optimize resource allocation.

---

---

1. Introduction to Budgeting

Budgeting is a formalized planning process that quantifies financial goals and allocates resources to achieve them. It serves as a roadmap for businesses, ensuring efficient use of funds while aligning with strategic objectives.

Why Budgeting Matters

• Planning: Sets clear financial targets for the organization.
• Control: Monitors performance against budgets and takes corrective actions.
• Communication: Aligns departments (sales, production, finance) toward common goals.
• Decision-Making: Helps evaluate projects, investments, and cost-saving measures.

Types of Budgets

---

A visual representation of how functional budgets feed into the master budget (cash budget, budgeted income statement, balance sheet).

---

2. Functional Budgets: The Building Blocks

Functional budgets are interdependent and must be prepared in a logical sequence. Below is the standard order and how they interact:

A. Sales Budget

• Definition: Projects units to be sold and revenue based on market demand, past trends, and promotions.
• Formula:

  Sales Budget = Expected Sales Units × Selling Price per Unit
  

• Example: Kathmandu Retail Shop (KRS)
  • Forecasted Sales (6 months): 400,000 units
  • Monthly Breakdown:

    Month	% of Sales	Units Sold	Selling Price (NPR)	Revenue (NPR)
    Chaitra	20%	80,000	500	40,000,000
    Baisakh	15%	60,000	500	30,000,000
    ...	...	...	...	...
    Total	100%	400,000	500	200,000,000

B. Production Budget

• Definition: Determines units to produce based on:
  • Expected sales (from sales budget)
  • Desired ending inventory
  • Beginning inventory
• Formula:

  Production Units = Sales Units + Desired Ending Inventory - Beginning Inventory
  

• Example: KRS (Cont’d)
  • Beginning Inventory (Jan): 20,000 units
  • Desired Ending Inventory (June): 30,000 units
  • Total Production Needed for 6 Months:

    400,000 (sales) + 30,000 (ending) - 20,000 (beginning) = 410,000 units
    

C. Materials Budget

• Definition: Estimates raw material purchases needed for production.
• Formula:

  Materials Needed = Production Units × Raw Materials per Unit
  Materials Purchases = Materials Needed + Desired Ending Inventory - Beginning Inventory
  

• Example: KRS (Assuming 2 kg material per unit)
  • Materials Needed: 410,000 × 2 kg = 820,000 kg
  • Beginning Inventory: 50,000 kg
  • Desired Ending Inventory: 60,000 kg
  • Purchases Required:

    820,000 + 60,000 - 50,000 = 830,000 kg
    

  • Cost: 830,000 kg × NPR 100/kg = NPR 83,000,000

D. Labor Budget

• Definition: Projects direct labor costs based on production needs.
• Formula:

  Labor Hours Needed = Production Units × Labor Hours per Unit
  Labor Cost = Labor Hours × Hourly Wage Rate
  

• Example: KRS (Assuming 0.5 hours/labor and NPR 200/hour)
  • Labor Hours: 410,000 × 0.5 = 205,000 hours
  • Labor Cost: 205,000 × 200 = NPR 41,000,000

E. Overhead Budget

• Definition: Estimates indirect costs (rent, utilities, depreciation, etc.).
• Example: KRS (Fixed + Variable Overhead)

  Item	Fixed Cost (NPR)	Variable Cost (NPR/unit)	Total (410,000 units)
  Rent	5,000,000	-	5,000,000
  Utilities	2,000,000	-	2,000,000
  Depreciation	3,000,000	-	3,000,000
  Indirect Labor	-	50	20,500,000
  Total Overhead	10,000,000	50	30,500,000

---

A ledger entry showing the flow of materials purchases, usage, and inventory for KRS.

---

3. The Budgeting Process: Step-by-Step

The budgeting process is iterative and involves collaboration across departments. Here’s how it works:

Key Steps Explained

1. Establish Objectives:
   • Align budgets with strategic goals (e.g., Ncell’s target of 10M subscribers in 5 years).
2. Gather Data:
   • Historical financial statements, market research, industry trends.
3. Prepare Functional Budgets:
   • Sales → Production → Materials → Labor → Overhead (as shown above).
4. Master Budget:
   • Combines all functional budgets into pro forma financial statements (income statement, balance sheet, cash flow).
5. Approval:
   • Top management reviews and approves budgets.
6. Implementation:
   • Departments execute their budgets (e.g., Daraz’s warehouse teams follow the production budget).
7. Control & Feedback:
   • Variance analysis compares actual vs. budgeted performance.
   • Corrective actions are taken (e.g., if sales are 10% below budget, marketing campaigns are adjusted).

---

A comparison of actual vs. budgeted sales for KRS (Chaitra month).

---

4. Types of Budgeting Techniques

---

5. Real-World Applications

A. eSewa: Cash Flow Budgeting

• How it works: eSewa must ensure liquidity to process millions of transactions daily.
• Key Idea Used: Cash Budget
  • Projects inflows (transaction fees, government subsidies) and outflows (salaries, server costs).
  • Helps avoid shortfalls during peak periods (e.g., Dashain/Tihar).

B. Daraz: Sales and Inventory Budgeting

• How it works: Daraz uses sales forecasts to manage inventory and avoid stockouts.
• Key Idea Used: Sales Budget → Production Budget → Materials Budget
  • Example: If Daraz expects 500,000 mobile phone sales in a month, it budgets for:
    • Production (if manufacturing in-house).
    • Inventory purchases (if sourcing from suppliers).
    • Warehouse labor and logistics.

C. Nepal Rastra Bank (NRB): Monetary Policy Budgeting

• How it works: NRB budgets interest rates, reserve requirements, and liquidity injections to control inflation.
• Key Idea Used: Macro-Level Budgeting
  • Uses economic indicators (GDP growth, inflation) to set financial policies.
  • Example: If inflation is rising, NRB may increase the repo rate (budgeted in advance).

D. Kathmandu Traffic Police: Activity-Based Budgeting

• How it works: Traffic police allocate budgets based on high-traffic zones (e.g., Thapathali, Lakshmi Marg).
• Key Idea Used: Activity-Based Budgeting
  • More patrols and cameras are budgeted for high-congestion areas.
  • Reduces waste by focusing resources where needed.

---

A labeled diagram of Daraz’s warehouse showing how sales budgets drive inventory levels.

---

6. Common Pitfalls and How to Avoid Them

---

7. Worked Example: Full Budget for a Nepali Business

Scenario: Sagarmatha Tea Factory wants to prepare a 6-month master budget based on the following data:

• Selling Price: NPR 200 per kg
• Variable Cost per kg: NPR 80 (materials + labor)
• Fixed Costs (6 months): NPR 12,000,000 (rent, salaries, depreciation)
• Beginning Inventory (Jan 1): 50,000 kg
• Desired Ending Inventory (June 30): 60,000 kg
• Sales Forecast (6 months): 300,000 kg

Step 1: Sales Budget

Step 2: Production Budget

Production Units = 300,000 (sales) + 60,000 (ending) - 50,000 (beginning) = 310,000 kg

Step 3: Materials Budget

• Materials Needed: 310,000 kg × 1 kg/unit = 310,000 kg
• Purchases Required:

  310,000 + 60,000 (ending) - 50,000 (beginning) = 320,000 kg
  

• Cost: 320,000 × NPR 50/kg = NPR 16,000,000

Step 4: Labor Budget

• Labor Cost: 310,000 kg × NPR 30/kg = NPR 9,300,000

Step 5: Overhead Budget

Step 6: Master Budget (Income Statement)

---

A simplified cash budget showing inflows (sales) and outflows (materials, labor, overhead).

---

Exam Tip

What Examiners Look For

1. Logical Sequence:

   • Always prepare budgets in this order: Sales → Production → Materials → Labor → Overhead → Master Budget.
   • Marks are deducted if you skip steps or prepare budgets out of order.

2. Formulas and Calculations:

   • Memorize key formulas:
     • Production Units = Sales + Ending Inventory – Beginning Inventory
     • Materials Purchases = Materials Needed + Ending Inventory – Beginning Inventory
     • Contribution Margin = Sales – Variable Costs
   • Show all workings—examiners reward step-by-step clarity.

3. Real-World Application:

   • Link budgets to Nepali businesses (e.g., Daraz, eSewa, NTC).
   • Example answer starter:

     "For a Kathmandu-based retail shop like KRS, the sales budget of 400,000 units at NPR 500 each would drive a production budget of 410,000 units, ensuring sufficient stock levels while minimizing holding costs."

4. Variance Analysis:

   • Always compare actual vs. budgeted and explain causes (e.g., "Lower sales due to festival delays").
   • Use percentage variances to highlight significance.

5. Common Mistakes to Avoid:

   • Ignoring inventory levels (beginning/ending).
   • Mixing fixed and variable costs in overhead.
   • Forgetting to reconcile the master budget (cash flow must balance).

Sample Exam Question & Answer Structure

Question: "A company expects sales of 50,000 units at NPR 1,000 each for the next quarter. Beginning inventory is 5,000 units, and desired ending inventory is 7,000 units. Variable cost per unit is NPR 600, and fixed costs are NPR 10,000,000. Prepare the sales and production budgets."

Answer Structure:

1. Sales Budget Table (with units and revenue).
2. Production Budget Calculation:

   Production Units = 50,000 (sales) + 7,000 (ending) – 5,000 (beginning) = 52,000 units
   

3. Contribution Margin Calculation:

   Total Revenue = 50,000 × 1,000 = NPR 50,000,000
   Total Variable Cost = 50,000 × 600 = NPR 30,000,000
   Contribution Margin = 50,000,000 – 30,000,000 = NPR 20,000,000
   Net Income = 20,000,000 – 10,000,000 (fixed) = NPR 10,000,000
   

---

Final Note: Budgeting is not just numbers—it’s a strategic tool that helps businesses like eSewa, Daraz, and Ncell plan for growth, avoid cash crises, and make data-driven decisions. Master the sequence, formulas, and real-world links, and you’ll excel in both exams and professional settings!