Budgeting & Standard Costing: Planning, Control & Variance Analysis

Core Concepts

1. Budgeting: The Financial Blueprint

Definition: A budget is a quantitative plan for acquiring and using financial and other resources over a specified period (usually 1 year). It coordinates all departments and ensures resources are allocated efficiently to achieve organizational goals.

Types of Budgets:

mindmap
  root((Budget Types))
    Sales Budget
    Production Budget
    Direct Materials Budget
    Direct Labor Budget
    Manufacturing Overhead Budget
    Selling & Administrative Budget
    Cash Budget
    Master Budget

Why Budget?

• Planning: Sets targets for revenue, costs, and investments.
• Control: Monitors performance against targets (variance analysis).
• Communication: Aligns all departments (production, sales, finance).
• Decision-Making: Helps in capital allocation (e.g., expanding a Kathmandu shop).

2. The Budgeting Process: Step-by-Step

Key Steps Explained:

1. Sales Budget: Based on market demand, past trends, and promotions. Example: A Kathmandu retail shop expects sales of 5,000 kg of rice in a month at Rs 120/kg.
2. Production Budget: Units to produce = Expected sales + Desired ending inventory – Beginning inventory.
3. Direct Materials Budget: Quantities and costs of raw materials needed.
4. Direct Labor Budget: Hours and wages required for production.
5. Manufacturing Overhead Budget: Indirect costs (rent, depreciation, utilities).
6. Cash Budget: Ensures liquidity (critical for small businesses like local kirana shops).
7. Master Budget: Combines all budgets into projected financial statements.

3. Flexible Budgets: Adjusting for Reality

Problem: Fixed budgets assume one activity level (e.g., 100% capacity). But actual production may vary (e.g., 80% or 120%). Solution: Flexible budgets adjust costs based on actual output.

Example: Himalayan Tea Factory

Scenario:

• Budgeted output: 10,000 kg (100% capacity).
• Actual output: 8,000 kg (80% capacity).

Flexible Budget Calculation:

| **Item**       | **Budgeted (10,000 kg)** | **Actual (8,000 kg)** |
|----------------|--------------------------|-----------------------|
| Rent           | 50,000                   | 50,000                |
| Electricity    | 20,000 (10,000 × 2)     | 16,000 (8,000 × 2)   |
| Labor          | 100,000 (10,000 × 10)   | 80,000 (8,000 × 10)   |
| Materials      | 150,000 (10,000 × 15)   | 120,000 (8,000 × 15)  |
| **Total Cost** | **320,000**             | **266,000**           |

Why Flexible Budgets Matter:

• Fairly compare actual vs. budgeted performance.
• Helps managers adjust (e.g., reduce labor hours if demand drops).

4. Standard Costing: Setting Benchmarks

Definition: Standard costing assigns predetermined costs (standards) to products/services. It helps in:

• Valuing inventory.
• Controlling costs (variance analysis).
• Motivating efficiency.

Components of Standard Cost:

1. Standard Quantity: Expected input per unit (e.g., 2 kg rice per kg of final product).
2. Standard Price: Expected cost per input (e.g., Rs 100/kg for rice).
3. Standard Cost per Unit: = Standard Quantity × Standard Price.

Example: Kathmandu Rice Mill

• Product: 1 kg of polished rice.
• Direct Material: 1.2 kg of raw rice @ Rs 90/kg.
• Direct Labor: 0.5 hours @ Rs 200/hour.
• Variable Overhead: Rs 50 per kg.

Standard Cost Calculation:

| **Element**          | **Standard Quantity** | **Standard Price (Rs)** | **Standard Cost (Rs)** |
|----------------------|-----------------------|-------------------------|------------------------|
| Direct Materials     | 1.2 kg                | 90                      | 108                    |
| Direct Labor         | 0.5 hours             | 200                     | 100                    |
| Variable Overhead    | –                     | 50                      | 50                     |
| **Total Standard Cost** | –                   | –                       | **258**               |

5. Variance Analysis: Spotting Deviations

Variances = Actual Cost – Standard Cost. Used to identify inefficiencies (e.g., wastage, overpayment).

A. Material Variances

1. Material Price Variance (MPV): = (Actual Price – Standard Price) × Actual Quantity Cause: Supplier charged more (e.g., Rs 100/kg instead of Rs 90/kg).

2. Material Quantity Variance (MQV): = (Actual Quantity – Standard Quantity) × Standard Price Cause: Workers wasted rice (used 1.5 kg instead of 1.2 kg).

Example: Kathmandu Rice Mill

• Actual Data: Bought 1,000 kg @ Rs 100/kg, used 1,500 kg.
• Standards: 1.2 kg @ Rs 90/kg per kg of output.

| **Variance**               | **Calculation**                          | **Result (Rs)** |
|----------------------------|------------------------------------------|-----------------|
| Material Price Variance    | (100 – 90) × 1,000                       | **+10,000**     |
| Material Quantity Variance | (1,500 – 1,200) × 90                     | **+27,000**     |
| **Total Material Variance** | –                                      | **+37,000**     |

B. Labor Variances

1. Labor Rate Variance (LRV): = (Actual Rate – Standard Rate) × Actual Hours Cause: Paid workers more (e.g., Rs 250/hour instead of Rs 200).

2. Labor Efficiency Variance (LEV): = (Actual Hours – Standard Hours) × Standard Rate Cause: Workers took longer (e.g., 0.6 hours instead of 0.5).

Example:

• Actual: 500 hours @ Rs 250/hour.
• Standards: 0.5 hours @ Rs 200/hour per kg of output.

| **Variance**               | **Calculation**                          | **Result (Rs)** |
|----------------------------|------------------------------------------|-----------------|
| Labor Rate Variance        | (250 – 200) × 500                        | **+25,000**     |
| Labor Efficiency Variance  | (500 – 400) × 200                        | **+20,000**     |
| **Total Labor Variance**   | –                                      | **+45,000**     |

C. Overhead Variances

1. Variable Overhead Spending Variance: = Actual Variable Overhead – (Standard Rate × Actual Hours)
2. Fixed Overhead Volume Variance: = Budgeted Fixed Overhead – (Standard Rate × Standard Hours)

6. Budgetary Control: Taking Corrective Action

Steps:

1. Identify Variance: Use variance reports (e.g., MPV = +37,000).
2. Analyze Cause: Was it supplier price hike? Inefficient workers?
3. Take Action:
   • Favorable Variance: Investigate why (e.g., workers more efficient).
   • Unfavorable Variance: Correct (e.g., renegotiate with supplier, train workers).
4. Update Standards: Adjust standards if variances are recurring.

Example: Daraz Nepal’s Warehouse

• Problem: High material quantity variance in packaging.
• Action: Introduced automated packing machines → reduced wastage.

In the Real World

1. eSewa (Nepal):

   • Uses cash budgets to manage liquidity for millions of daily transactions.
   • Standard costing for processing fees (e.g., Rs 25 per transaction).

2. Khalti (Digital Wallet):

   • Flexible budgets adjust for seasonal spending (e.g., higher in Dashain/Tihar).
   • Variance analysis tracks fraudulent transaction costs.

3. NTC (Nepal Telecom):

   • Master budgets plan infrastructure costs (e.g., 4G tower expansions).
   • Standard costing for maintenance per kilometer of fiber optic cable.

4. Local Kathmandu Shop (Example):

   • Sales Budget: 10,000 kg rice/month @ Rs 120/kg → Rs 1.2M revenue.
   • Material Variance: Bought rice at Rs 130/kg (instead of Rs 120) → unfavorable price variance.
   • Action: Switch to a cheaper supplier or negotiate bulk discount.

Worked Example: Full Budget and Variance Analysis

Scenario: Sagarmatha Spices Ltd. produces 5,000 kg of turmeric powder monthly. Given:

• Standard Costs:
  • Direct Material: 6 kg raw turmeric @ Rs 80/kg.
  • Direct Labor: 0.2 hours @ Rs 150/hour.
  • Variable Overhead: Rs 30/kg.
• Actual Data (June):
  • Produced 4,000 kg.
  • Bought 25,000 kg @ Rs 85/kg, used 26,000 kg.
  • Labor: 900 hours @ Rs 160/hour.
  • Variable Overhead: Rs 130,000.

Step 1: Prepare Flexible Budget for 4,000 kg

| **Item**               | **Standard Cost (5,000 kg)** | **Flexible Budget (4,000 kg)** |
|------------------------|-------------------------------|--------------------------------|
| Direct Materials       | 300,000 (6 × 80 × 5,000)      | 240,000 (6 × 80 × 4,000)       |
| Direct Labor           | 150,000 (0.2 × 150 × 5,000)   | 120,000 (0.2 × 150 × 4,000)    |
| Variable Overhead      | 150,000 (30 × 5,000)          | 120,000 (30 × 4,000)           |
| **Total**              | **600,000**                   | **480,000**                    |

Step 2: Calculate Actual Costs

| **Item**               | **Actual Cost** |
|------------------------|-----------------|
| Direct Materials       | 2,175,000 (26,000 × 85) |
| Direct Labor           | 144,000 (900 × 160) |
| Variable Overhead      | 130,000          |
| **Total Actual Cost**  | **2,449,000**   |

Step 3: Compute Variances

| **Variance**               | **Calculation**                                                                 | **Result (Rs)** |
|----------------------------|-------------------------------------------------------------------------------|-----------------|
| Material Price Variance    | (85 – 80) × 26,000                                                             | **+130,000**    |
| Material Quantity Variance | (26,000 – 24,000) × 80                                                        | **+160,000**    |
| Labor Rate Variance        | (160 – 150) × 900                                                              | **+9,000**      |
| Labor Efficiency Variance  | (900 – 800) × 150                                                              | **+15,000**     |
| Variable Overhead Variance | 130,000 – (30 × 900)                                                          | **+57,000**     |
| **Total Unfavorable Variance** | –                                                                           | **+371,000**    |

Step 4: Analysis & Action

• Root Cause: Supplier price hike (+Rs 5/kg), inefficiency in labor (used 26,000 kg vs. 24,000 kg standard).
• Solution:
  1. Negotiate with supplier to reduce price to Rs 82/kg.
  2. Train workers to reduce wastage (target: 24,000 kg).
  3. Introduce quality checks for raw materials.

Comparison: Budgeting vs. Standard Costing

Exam Tip

1. Budget Questions:

   • Always start with the sales budget (given or derived from demand).
   • Link production budget to sales + desired inventory.
   • Cash budget is critical—show beginning balance, receipts, payments, and ending balance.

2. Standard Costing & Variances:

   • Memorize formulas for MPV, MQV, LRV, LEV.
   • Label variances as favorable/unfavorable (e.g., +ve = unfavorable for price/quantity).
   • Explain causes and actions (e.g., "Supplier price hike caused MPV; renegotiate contract").

3. Numerical Problems:

   • Show all steps (flexible budget → actual costs → variances).
   • Use tables for clarity (like the Kathmandu shop example).
   • Assume missing data if needed (e.g., "Assume standard labor rate is Rs 200/hour").

4. Real-World Tie-Ins:

   • Examiners love Nepali business examples (e.g., Daraz’s inventory budgets, Ncell’s overhead costs).
   • Link variances to actions (e.g., "High MQV in rice milling → automate sieving").

5. Common Pitfalls:

   • Ignoring fixed costs in flexible budgets.
   • Mixing actual and standard quantities in variance calculations.
   • Forgetting to reconcile total variances to actual costs.

Final Note: Budgeting and standard costing are interlinked:

• Budgets set targets.
• Standard costs help achieve them.
• Variances reveal where to improve.

Practice: Solve past exam questions by preparing a master budget for a hypothetical Nepali business (e.g., a chowk shop or a small factory) and then compute variances for a month’s actual data. This will build confidence for both theoretical and numerical questions!

In the real world

• eSewa uses budgeting to plan its monthly transaction fees (e.g., Rs 1.5% per transaction) and variance analysis to track actual vs. projected revenue when new government policies change fee structures.
• Nepal Telecom (NTC) applies standard costing to set benchmarks for call rates (e.g., Rs 5/minute) and flexible budgets to adjust for seasonal call volume fluctuations (e.g., higher usage during festivals).
• Local kirana shops in Kathmandu use cash budgets to ensure they have enough liquidity for daily purchases (e.g., Rs 50,000/day for rice, sugar, and spices) and material variances to identify waste (e.g., spoilage of vegetables).