Budgeting and Variance Analysis

What is a Budget?

A budget is a formal quantitative plan that documents intended activities and allocates available resources. At its core, budgeting answers: What do we plan to do, and what resources do we need?

Personal vs. Business Budgeting

Why a business budget is non‑negotiable: Without a shared budget, a marketing team can launch an aggressive sales drive (e.g., targeting 30% growth) while purchasing and production are unprepared. The result – emergency purchases, forced overtime, and unnecessary costs. The same reasoning applies to not‑for‑profit organisations.

The Planning‑Controlling Cycle

Budgeting is embedded in the three core management activities:

• Planning – setting objectives and deciding how to achieve them (using accounting information to forecast revenues, costs, and resource needs).
• Controlling – comparing actual performance against the budget to identify deviations and take corrective action.
• Decision‑making – using budget data to evaluate alternatives (e.g., capacity expansion, credit terms, promotional spending).

A Cautionary Tale: Girish & Co.

The dialogue between Girish (President), Noothan (Marketing), Prabhu (Production), Pooja (HR), and Souravi (CFO) reveals classic budgeting pitfalls.

The Situation

• Actual performance far exceeded the budget assumption. Budget was prepared assuming 40% → 52% capacity utilisation. Actual volume reached ≈100% – nearly double the forecast.
• Because the budget became irrelevant, managers used special approvals (bypassing the budget committee) to spend. The budget was abandoned.
• Consequences: cash shortage (wafer‑thin margins), bank refused credit line, payroll struggled, and the firm faced shutdown within three months.

Root Problems Identified

Key Principles from the Case

• Budgets must be flexible – when assumptions change (e.g., capacity jumps to 100%), revise the budget, do not bypass it.
• Use multiple scenarios – prepare best‑case, most‑likely, and worst‑case budgets to handle uncertainty.
• Enforce budget discipline – special approvals undermine the budget; all requests should go through a budget committee.
• Evaluate performance holistically – measure not just sales but also collection, margin, and cash flow.
• Balance Growth, Profit, and Cash – as Girish emphasised, all three are essential.

Exam tip: A common exam mistake is to treat a budget as a static document. The Girish & Co. case illustrates that when actual volume diverges significantly from the budgeted level, the organisation must rebuild the budget or adopt flexible budgeting techniques (covered in the full module). Look for questions that test your ability to identify symptoms of a broken budgeting process – e.g., reliance on special approvals, misaligned performance metrics, and absence of cash focus.

Key Takeaways

• A budget is a formal plan that coordinates resources across departments and prevents chaos.
• Forecasting errors are a primary cause of budget irrelevance; build in multiple scenarios.
• Special approvals outside the budget committee destroy the budget’s control function.
• Performance evaluation should consider topline, profit, and cash – not sales alone.
• Without cash discipline and cost control, rapid growth can lead to collapse (as in Girish & Co.).
• Budgeting is part of the planning‑controlling‑decision making cycle; feedback from actuals must feed the next budget.

Strategic Planning and Budgets

Strategic planning translates an organization’s aspirations into executable action. The process flows from abstract intentions to concrete departmental plans, forming a clear hierarchy: vision → mission → long-range planning → budgeting. Each step is more detailed and time-bound than the last.

Vision – “What we want to be”

A vision statement describes the organization’s long-term aspiration — where it aims to be in the future. It is typically 2–5 lines but requires extensive deliberation and resources to craft.

Example (Asian Paints): “Asian Paints aims to become one of the top five decorative coatings companies worldwide by leveraging its expertise in the higher growth emerging markets. Simultaneously, the company intends to build long term value in the industrial coatings business through alliances with established global partners.”

Vision is abstract and inspirational; it does not specify how to achieve the goal.

Mission – “How we plan to get there”

A mission statement explains the approach the organization will take to realize its vision. It is still an abstract statement, but it outlines the strategic logic and guiding principles. All employees are expected to be familiar with both vision and mission.

Long-Range Planning – Quantitative targets, medium-term

Long-range planning converts abstract mission into measurable targets over a multi‑year horizon (typically 5–10 years). These plans are macro‑level but provide specific quantitative objectives. They are discussed and approved at the Board level.

• Example: A 5‑year growth plan setting a target of 40% annual sales increase.
• Governments also use long-range plans (e.g., India’s Five‑Year Plans, aligned with the ruling party’s tenure).

Long-range planning is the bridge between strategic direction and operational action.

Budgeting – Detailed, action-oriented, annual

Budgeting is the final step in the planning process. A budget is a plan of action for each department, derived from the targets established in the long-range plan.

• It expresses the organization’s commitment to planned activities.
• Each department prepares its own budget to support the overall targets.
• Preparation is elaborate and typically takes 2–3 months.

Analogy: When a national government presents its annual budget, it announces the specific activities and allocations for the coming year — exactly how it intends to implement its larger plan.

Hierarchy of Planning

Comparison of Planning Levels

Key Takeaways

• Vision defines the end state; mission defines the path; long-range planning sets numeric targets; budgeting executes the plan.
• Each successive step is more concrete, shorter in horizon, and more detailed than the previous.
• A budget cannot be prepared without a long-range plan; a long-range plan cannot exist without a mission; a mission requires a vision.
• Budget preparation is intensive (2–3 months) and commits the organization to specific activities.

Exam tip: The relationship is strictly nested: Budget ← Long‑Range Plan ← Mission ← Vision. Questions often ask which level is most abstract or most detailed — or why a budget fails if the higher levels are missing.

Budgeting Process

Budgeting is a cross‑functional, iterative process that translates organisational strategy into a quantified plan – a master budget – covering all activities for the coming period. It aligns departmental goals with the firm’s overall objectives and forces managers to negotiate the use of scarce resources.

The Master Budget: Operating + Financial

The final budgeting output is the master budget, comprising two layers:

All components are heavily interdependent – a change in the sales forecast ripples through production, purchasing, labour, and cash.

The Key Factor (Limiting Factor)

Budgeting starts by identifying the key factor – the scarce resource that constrains the organisation’s performance and determines the pace of all other activities.

• Most common: demand / sales – the firm estimates sales first, then plans production and support activities to meet that target. If a long‑range plan already sets a sales target, that target itself becomes the key factor.
• Alternative key factors (when demand is not the binding constraint):
  • Production capacity or availability of raw materials.
  • For a consulting firm: number of consultant‑hours available.
  • For a nuclear power plant: availability of critical raw material.

Once the key factor is identified, the budget for that factor is drawn up and communicated to all divisions. The other divisions then build their budgets around that constraint.

The Budgeting Process – Step by Step

Key activities during the process:

• Functional heads exchange information and bargain over limited resources.
• A budget committee coordinates the divisions and attempts to strike a balance between conflicting departmental goals.
• The final document is a blueprint of all activities to be performed during the year.

Typical Inputs / Outputs of Budgeting

Exam tip: The key factor is almost always sales unless the question explicitly describes a production‑side constraint (e.g., limited machine hours, scarce raw materials). The first budget prepared is always the budget for the key factor.

Key takeaways

• Budgeting is a cross‑departmental process that aligns managers around organisational goals, culminating in the master budget.
• The master budget has two parts: operating budgets (units + money) and financial budgets (money only). Components are interdependent.
• The key factor (limiting factor) drives the entire budget; for most firms, it is sales.
• Steps: identify key factor → draw its budget → communicate → divisions build their budgets → committee coordinates → final master budget.
• Typical inputs include sales forecasts, inventory policies, production schedules, resource requirements, credit policies, and capital proposals.

Types of Budgets

Organizations choose a budget type based on the predictability of demand, the nature of the activity, and the desired level of control. Below are the major approaches covered.

Flexible Budget

Intuition: When sales volume is unpredictable, a fixed budget becomes obsolete within weeks. A flexible budget is drawn for different levels of capacity utilisation, allowing management to adjust planned costs and revenues to actual activity without redoing the entire budget.

• Designed for firms with high volatility in demand.
• Shows budgeted costs and revenues at multiple output levels.
• Avoids the need to start from scratch when volume changes.

Exam tip: Flexible budgets are a cornerstone of variance analysis – they separate volume effects from efficiency effects.

Zero-Based Budget (ZBB)

Intuition: Instead of rolling forward last year’s budget, each activity must be justified from scratch every period. This forces managers to critically examine whether a programme should continue at all.

• Common in government agencies, but also useful for commercial firms, especially in service functions and R&D.
• Example: A government’s polio vaccination scheme initially planned for five years. Under ZBB, at the start of each year the agency must justify continuation – it is not automatically renewed.
• Brings discipline by preventing wasteful continuation of legacy activities.

Rolling Budget (Continuous Budget)

Intuition: Budgeting should be an ongoing process, not a one‑off annual event. A rolling budget extends the budget horizon forward each period, so a 12‑month view is always available.

• Example: A firm prepares a one‑year budget, but updates it every quarter by adding a new quarter ahead, keeping a rolling 12‑month forecast.
• Encourages continuous planning and reduces the “budget season” crunch.

Activity‑Based Budgeting (ABB)

Intuition: Traditional budgets focus on inputs (labour, materials) and simply adjust last year’s numbers. ABB starts from the activities that create output, just as Activity‑Based Costing (ABC) does for unit costs.

Requirement: ABC must already be in place before ABB can be implemented.

Steps in Activity‑Based Budgeting:

1. Determine the cost of performing each unit of activity.
2. Determine the demand for the activity based on sales or production targets.
3. Compute the budgeted cost of performing each activity.
4. Consolidate the activity budgets.

Kaizen Budgeting

Intuition: Budgeting can drive continuous improvement. Kaizen budgeting requires every division to set explicit improvement targets and identify the resources needed to achieve them.

• A formal plan must be submitted by each manager, stating:
  • The improvement planned for the year.
  • Resources required (e.g., new equipment, employee training).
• Success is measured not only by meeting physical targets, but also by the improvement achieved.
• Can be combined with any other budget type.

Combining Budget Types

Different budget methods are not mutually exclusive. Three useful combinations are:

Key takeaways

• Flexible budget: multiple volume levels → handles demand volatility.
• Zero‑based budget: justify every activity from scratch → eliminates legacy waste.
• Rolling budget: constantly updated 12‑month horizon → encourages ongoing planning.
• Activity‑based budget: uses ABC cost data → budget based on activities, not inputs.
• Kaizen budget: explicit improvement plans → measures both output and improvement.
• Combination: ZBB + flexible, kaizen as additive, ABC to drive flexible budgets per activity.

Budgeting: Benefits and Preparation Approaches

A budget is a formal plan that guides organisational activities, aligns functions, and lays the foundation for cost control. The budgeting process yields a set of interlocking benefits that go far beyond financial forecasting — it becomes the operating manual for the year.

---

1. Planning and Resource Acquisition

Budgeting forces the firm to plan activities in advance and identify gaps between plans and execution. It allows management to acquire resources — people, materials, capital — before they are urgently needed, avoiding last-minute scrambles.

2. Coordination and Discipline

Once approved by top management, the budget becomes a binding guide for every function. It brings discipline: departments must follow the stated targets and cannot deviate without prior approval. This makes cross-functional coordination much easier because everyone works from the same plan.

3. Prioritisation Under Constraints (“Distributing Dissatisfaction”)

Most organisations face resource constraints — every department submits justified proposals, but funds are insufficient. Budgeting handles this systematically by linking departmental activities and evaluating all proposals simultaneously. This enables prioritisation: only the most critical activities are funded. Fresh proposals during the year are normally discouraged and deferred to the next budget cycle.

In practice, budgeting is often described as “distributing dissatisfaction” — no department gets everything it wants, but the process makes the trade-offs explicit and orderly.

4. Participatory Evolution

In early-stage organisations, budgets are imposed by a few top managers. As the organisation matures, the budgeting process becomes participatory: senior and middle managers actively contribute, ironing out differences during preparation. This reduces future conflicts and builds ownership.

5. Cost Control and Monitoring

Budgeting rests on the assumption that cost control improves profitability and is feasible. The budget committee sets cost-control targets; functional heads propose ways to meet them. In doing so, they identify hard-to-control cost items and monitor them closely. The process also exposes cross-functional interdependencies — without coordination across departments, the budget cannot be completed.

6. Learning and Continuous Improvement

After two or three budget cycles, managers learn from comparing actuals to budgets. This experience improves future planning accuracy. The budget also provides a framework for decision making:

• A marketing manager can assess the impact of extending the credit period on cash management.
• Changes in assumptions (e.g., a planned 5% price increase that cannot be implemented) can be modelled within the budget framework, allowing quick scenario analysis and corrective action.

7. Performance Evaluation and Incentives

Gathering actuals and comparing them to the budget is the natural extension of the process. Departments that meet or beat budget targets (assuming no slack) are identified as performing well. Performance evaluation and incentive systems are built around budget achievement to motivate managers.

Key Takeaways — Benefits of Budgeting

• Budgets force advance planning and resource acquisition.
• They create discipline, coordination, and a single reference point for all functions.
• They resolve resource allocation conflicts through structured prioritisation.
• As organisations mature, budgeting becomes participatory, reducing future conflict.
• Cost control, learning, scenario analysis, and performance evaluation are all built into the budget framework.
• Budgeting is a continuous feedback loop, not a one-off exercise.

---

Approaches to Budget Preparation

Two broad approaches exist for preparing budgets. The choice depends on organisational maturity, size, economic conditions, and the skills of operating managers.

Exam tip: The imposed approach is best for start-ups and crises; participatory is best when managers have the skills and autonomy. Be ready to explain why each suits different contexts.

Link to Variance Analysis

Budgets fix targets and grant financial authority to managers. Performance is reported periodically, with deviations (variances) between plan and actual analysed for causes. This analysis feeds back into revising budgets and tightening control. At a micro level, cost control is better achieved through standards and variance analysis — the topic of the next module.

Key Takeaways — Approaches to Budgeting

• Imposed budgets are top-down, fast, and suited to inexperienced managers or crisis conditions.
• Participatory budgets involve line managers, build ownership, and fit established, autonomous business units.
• The choice is not permanent — organisations can move from imposed to participatory as they mature.
• Actual-to-budget comparison and variance analysis are the logical next steps after the budget is set.

Preparation of Master Budget

Master budget is the comprehensive set of budgets that integrates all functional areas—sales, production, materials, labour, overheads, and finances—into a single coherent plan. The process begins with the sales forecast, because every other budget depends on expected demand. This section walks through a worked example for the product REGAL (a paint) for the first quarter of 2013–14.

Inputs Required

Before any budget can be prepared, the following data must be gathered:

Exam tip: The master budget is a chain. An error in the sales forecast propagates through every subsequent budget. Verify the production policy and material policy calculations carefully—they are the most common points for arithmetic mistakes.

---

1. Sales Budget

The sales budget translates the forecast into revenue. It is the foundation of all other budgets.

Formula: $\text{Sales Revenue} = \text{Sales Quantity} \times \text{Selling Price}$

---

2. Production Budget

The production budget determines how many units must be produced to meet sales and maintain the desired inventory level.

Formula: $\text{Production (kg)} = \text{Sales} + \text{Desired Closing FG} - \text{Opening FG}$

Desired closing FG = 20% of next month’s sales.

Note: The quarter’s production can be verified as $370,000 + 12,000 - 0 = 382,000$ kg.

---

3. Material Purchase Budget

For each raw material, compute the quantity to purchase each month, then value at the material’s price.

General formula:

$\text{Material needed for production} = \text{Production (kg)} \times \text{Usage per kg}$

$\text{Desired closing RM inventory} = \text{Usage \% policy} \times \text{Next month's production requirement}$

$\text{Purchases (kg)} = \text{Material needed for production} + \text{Desired closing RM} - \text{Opening RM}$

Example: Pigments (usage 0.66 kg/kg, price Rs 40/kg, policy 30%)

Given: Opening stock April = 25,000 kg; July production = 70,000 kg.

Example: Additives (usage 0.1 kg/kg, price Rs 100/kg, policy 10%)

Given: Opening stock April = 1,500 kg.

The material purchase budget combines the separately calculated pigments and additives amounts with other materials combined (solvent, soil, and resins):

---

4. Other Budgets (Overview)

The remaining budgets use the following inputs:

• Labour budget: Fixed Rs 12,00,000 per month (no expansion planned).
• Manufacturing overheads: Variable and fixed components estimated based on budgeted production volume.
• Selling & distribution expenses: Variable and fixed based on target sales volume (advertisement, distribution, dealer rewards, training).
• Administrative expenses: Fixed (legal, communication, travel, audit, printing, etc.).
• Capital expenditure budget: April Rs 15 lakh, May Rs 10 lakh, June Rs 20 lakh (replacements of fully depreciated assets).
• Depreciation: 10% on opening gross block of manufacturing assets (Rs 187.50 lakh), 12% on administration/selling assets (Rs 62.50 lakh). Depreciation computed on opening balance only.
• Cash budget: Minimum cash Rs 15 lakh; borrowing/investment at 8% per annum.
• Credit collection pattern: 30% cash, 50% credit (60-day), 20% credit (30-day); 30% of credit customers take discount and pay immediately; the rest pay on due date.

These are used to prepare the budgeted income statement and budgeted balance sheet, which complete the master budget.

---

Master Budget Flow

The master budget preparation follows a logical sequence. The diagram below shows how the sales forecast drives all other budgets.

Key takeaways

• The master budget integrates all functional budgets; the sales forecast is the starting point.
• Production budget uses the formula: Production = Sales + Desired Ending FG – Beginning FG.
• Material purchase budget repeats the same logic: Purchases = Material needed for production + Desired Ending RM – Beginning RM, applied to each raw material separately.
• Labour cost is treated as fixed in the example (Rs 12,00,000/month).
• Credit policy directly affects cash budget timing: 30% cash, 70% credit with discounts and payment lags.
• Depreciation is budgeted on opening gross block only (no adjustment for additions/disposals in the calculation).

1. Labor Budget

The labor budget is entirely a fixed cost: ₹12,00,000 per month. No variation with production volume.

Key takeaways

• Labour cost is fixed → same each month.
• Quarter total = sum of three months.

2. Operating Expenses Budget

Operating expenses have a variable component (per kg of production) and a fixed component (₹2,00,000 per month).

Variable rates:

Calculation for April (production = 1,50,000 kg): Variable cost = $1,50,000 \times (0.50 + 0.20 + 0.15 + 0.80) = \text{Rs. }2,47,500$ Add fixed: ₹2,00,000 → Total manufacturing expenses = ₹4,47,500

Same logic for May (production 1,20,000 kg) and June (production 1,10,000 kg). Quarter total = ₹12,30,300.

Note: The quarter total is ₹12,30,300 after rounding.

Key takeaways

• Operating expenses = variable + fixed.
• Multiply production quantity (kg) by variable rates.
• Fixed cost ₹2,00,000 added each month.

3. Selling Expenses Budget

Selling expenses are driven by sales quantity (not production). Includes both variable and fixed items.

April calculation (sales = 1,20,000 kg): Advertisement: $(1,20,000 \times 8) + 4,00,000 = \text{Rs. }13,60,000$ Distribution: $1,20,000 \times 3 = \text{Rs. }3,60,000$ Training: ₹2,00,000 (fixed) Dealers: ₹5,00,000 (fixed) Total selling expenses for April = ₹24,20,000

Same for May and June. Quarter total = ₹72,60,000.

Key takeaways

• Selling expenses use sales quantity (not production).
• Some heads are fully variable, some fully fixed, some mixed.

4. Administrative Expenses Budget

All administrative expenses are fixed per month.

All months identical.

Key takeaways

• Admin expenses are fixed – no volume driver.
• Each line item is a flat monthly amount.

5. Credit and Collection Policy

The policy governs cash inflows. Given:

• Cash sales: 30% of total sales.
• Credit sales: 70% of total sales.
  • Of credit sales: 20% are given 30 days credit; 50% given 60 days credit.
  • 30% of those credit customers pay immediately to avail a discount.
    • 30‑day customers get 2% discount → pay 98% of amount.
    • 60‑day customers get 4% discount → pay 96% of amount.
  • The remaining 70% pay on the due date (after 30 or 60 days).

Worked example: Collection pattern for ₹100 sale

Collection percentages (for any month’s sales):

• Same month: 50.28%
• Next month: 14%
• Second month: 35%
• Discount: 0.72% (sum to 100%)

Opening receivables (₹10,00,000 as on April 1): Assume February and March sales were equal. Uncollected amounts: – From Feb sales: 35% (still due in April) – From March sales: 14% (due in April) + 35% (due in May) Ratio: April receives 42%, May receives 58% because $35/84 \approx 42\%$ and $49/84 \approx 58\%$.

Hence, opening receivables split:

• Collected in April: ₹10,00,000 × 0.42 = ₹4,20,000
• Collected in May: ₹10,00,000 × 0.58 = ₹5,80,000

Key takeaways

• Same‐month collection = 50.28% of sales.
• 14% collected after one month, 35% after two months.
• Discount = 0.72% of sales.
• Opening receivables distribution uses assumption of equal prior month sales.

Exam tip: Always check whether variable costs are linked to production or sales. Selling expenses use sales quantity, operating expenses use production quantity.

6. Cash Budget

The cash budget integrates all previous budgets with the collection policy, payments, and capital expenditure.

Core calculation:

$$\text{Closing cash before financing} = \text{Opening cash} + \text{Collections} - \text{Payments} - \text{Capital expenditure}$$

Maintain the minimum cash balance of ₹1,50,000 each month. Only the excess is available for investment:

These final investment amounts should be used with the detailed collection and payment schedules. Do not combine them with an independently reconstructed monthly table unless every component and timing assumption is available.

Payment to suppliers schedule:

• Outstanding as on March 31: ₹3,00,000 (paid in April).
• Purchases in April (₹7,76,400) paid in May.
• Purchases in May (₹6,67,320) paid in June.

Key takeaways

• Cash budget links all monetary budgets.
• Three main sections: opening balance + collections – payments – capex = surplus.
• Surplus must be adjusted for minimum cash balance (₹1,50,000).
• Excess above minimum is available for investment (or borrow if deficit).
• Monthly cash budgets allow short‑term planning.

Exam tip: In cash budget, selling expenses are paid in the same month (assumed); supplier payments follow credit terms (30 days). Always check payment lags.

Budgeted Income Statement

The budgeted income statement consolidates all functional budgets (sales, production, materials, labour, overheads, selling & admin, cash) to forecast quarterly profit. It is prepared for the entire quarter, not month‑by‑month.

Revenue

Target sales for the quarter: ₹4,98,00,000.

Cost of Goods Sold (COGS)

COGS is derived from total manufacturing costs adjusted for opening and closing stocks of work‑in‑progress and finished goods.

1. Material Consumed $\text{Material Consumed} = \text{Opening RM} + \text{Purchases} - \text{Closing RM}$

Closing raw material stock is valued from the purchase budget quantities and unit costs:

Using the given totals: opening RM + purchases – closing RM = material consumed (specific value implied in later calculations).

2. Employee Cost Budgeted employee cost for the quarter: ₹36,00,000.

3. Manufacturing Expenses (excl. depreciation) Operating expenses: ₹12,30,300 (from manufacturing overhead budget).

4. Depreciation – Production Assets Fixed assets used for production: ₹1,87,50,000 × 10% p.a. × 0.25 (quarter) = ₹4,68,750.

Total Manufacturing Expenses = Material consumed + Employee cost + Manufacturing expenses + Depreciation = ₹2,48,00,000.

5. Adjustment for Finished Goods Stock Opening finished goods = ₹0. Closing finished goods quantity (from production budget): 12,000 kg. Production cost per kg: ₹65. $\text{Closing FG value} = 12,000 \times 65 = \text{\text{Rs. }7,82,062}$

COGS = Total manufacturing expenses – Closing FG = ₹2,48,00,000 – ₹7,82,062 ≈ ₹2,41,00,000 (rounded).

Gross Profit

$\text{Gross Profit} = \text{Sales} - \text{COGS} = \text{\text{Rs. }4,98,00,000} - \text{\text{Rs. }2,41,00,000} = \text{\text{Rs. }2,56,00,000}$

Operating Expenses, Discounts & Other Income

• Selling & distribution expenses (from S&D budget): ₹73,70,000

• Administrative expenses (from admin budget): ₹16,20,000

• Discounts given: – April: ₹1,20,000 – May: ₹1,51,200 – June: ₹86,400 Total discounts: ₹3,58,000

• Depreciation on SGA assets (corrected during balance sheet preparation): Assets used in selling, distribution & administration: ₹62,50,000 × 12% × 0.25 = ₹1,87,500 This was initially omitted; inclusion reduces profit.

• Interest on investments (surplus cash invested at 8% p.a.):

  • April investment of ₹50,00,000: interest for 2 months = ₹50,00,000 × 8% × 2/12 = ₹66,667
  • May investment of ₹50,00,000: interest for 1 month = ₹33,333
  • June investment of ₹18,00,000: no interest (invested at quarter end) Total interest income: ₹1,00,501

Net Profit Before Tax

$\text{Net Profit} = \text{Gross Profit} - \text{S\&D} - \text{Admin} - \text{Discounts} - \text{SGA Depreciation} + \text{Interest}$ Original (pre‑correction): ₹1,64,38,353 After adding SGA depreciation: ≈ ₹1,62,50,853 (minor reduction).

Exam tip: Always verify that all depreciation – including that on selling, distribution and administrative assets – has been charged. A missed depreciation item distorts both the income statement and the balance sheet.

Key takeaways – Income Statement

• The budgeted income statement rolls up functional budgets into a quarterly profit forecast.
• COGS = Total manufacturing costs + Opening stocks – Closing stocks (raw materials, WIP, finished goods).
• Closing finished goods is valued at production cost per unit × quantity.
• Gross profit → deduct selling, admin, discounts → add other income → net profit before tax.

---

Budgeted Balance Sheet

The budgeted balance sheet checks the arithmetic consistency of all budgets and shows the projected financial position at quarter‑end.

Assets

Equity & Liabilities

Verification

Total Assets = Total Equity & Liabilities = ₹5,21,62,933 A balanced balance sheet confirms that all budgeting calculations are internally consistent.

Exam tip: Payables are based on purchases made in the last month of the quarter (if credit terms are 30 days). Receivables require tracking opening, sales, collections, and discounts.

Key takeaways – Balance Sheet

• The balance sheet is prepared using the opening structure; only items that change are updated (equity, reserves, payables, gross block, depreciation, inventory, receivables, cash, investments).
• Inventory = raw materials + finished goods (WIP assumed zero here).
• Net block = gross block – accumulated depreciation.
• A balanced balance sheet validates all the earlier budgets.

---

Integration and Sensitivity

Any change in assumptions (e.g., selling price drops to ₹130 in May due to competition) can be entered into the spreadsheet; linked budgets automatically update, producing revised profit and balance sheet figures. This sensitivity analysis is a key advantage of integrated budgeting.

Key takeaways – Overall

• The budgeted income statement and balance sheet together provide a complete financial forecast.
• Every figure originates from one of the functional budgets; cross‑checking totals ensures accuracy.
• A balanced balance sheet confirms that all budgets are arithmetically consistent.
• Integrated budgets allow fast “what‑if” analysis.

Budget Slack

Budget slack (also called budgetary padding) is the deliberate overestimation of expenses or underestimation of revenues by managers to create a safety cushion. Intuitively: managers build in "wiggle room" so that targets are easier to hit — but this defeats the purpose of budgeting as a planning and control tool.

---

The core tension: Budgets are used for performance evaluation. When managers participate in setting budgets, they have an incentive to make targets easy to achieve. What looks like prudent cushioning to them looks like waste to the organization.

How slack gets created

• Overestimate costs / resource requirements — e.g. a purchase manager, fearing a stock-out, budgets for 10% inventory instead of the optimal 5%.
• Underestimate revenues — sales managers lowball expected revenue to guarantee they exceed the target.
• Small amounts per department — each department adds its own cushion; the sum becomes a large distortion.

Why managers keep spending after creating slack

Even with a padded budget, managers often spend up to the budget limit — a phenomenon called "use it or lose it". Three drivers:

1. Fear of future cuts — If a manager spends only ₹20,000 out of a ₹50,000 maintenance budget, management may question the original estimate and reduce next year’s allocation.
2. Avoiding scrutiny — An underspent budget signals poor planning; managers prefer to spend the remainder rather than expose the slack.
3. Institutional habit — Government departments famously rush orders in February–March every year to exhaust annual appropriations.

The "pooling heads" problem

When budgets are managed by separate cost centers, a department that has exhausted its own budget may book expenses under another department’s budget that still has room. In the example:

• Dept A spends ₹200,000 fully by January, needs ₹50,000 more.
• Dept B has spent only ₹120,000 of its ₹200,000.
• Without strong controls, the ₹50,000 is charged to Dept B’s head, hiding Dept A’s overspend and making both look on-budget.

---

Mitigating budget slack

Exam tip: A classic exam question asks you to identify signs of budget slack — look for consistent small variances (above budget), sudden spikes in Q4 spending, or departments shifting expenses between cost heads.

Key takeaways

• Budget slack is the deliberate padding of budgets by managers to ensure easy achievement.
• It undermines both planning (inflated costs) and control (misleading performance evaluation).
• Managers often spend up to the slack because they fear losing future budget (use‑it‑or‑lose‑it).
• Pooling heads — charging one department’s overrun to another — distorts accountability.
• ZBB and ABB are structural remedies; close review of last‑quarter spending is a procedural one.

Variance Analysis: Concepts and Case Study

Variance analysis is the systematic comparison of actual performance against budgeted or standard performance. The goal is not simply to report differences but to spark discussion, identify root causes, and drive corrective action. A variance is favorable if it improves profit (e.g., lower cost than budget) and unfavorable if it reduces profit.

---

Levels of Comparison

---

Standards and Their Role

Standards are predetermined benchmarks for inputs required per unit of output:

• Material quantity (kg/unit)
• Labor hours (hours/unit)
• Machine hours (hours/unit)

For service companies, standard time per service is used. Setting standards is easier for manufacturing than for services. If Activity‑Based Costing (ABC) is in place, the output of ABC (time and resources per activity) automatically serves as a standard. Budgets then aggregate these standards across all cost items for a department.

Exam tip: Standards are the building blocks of variance analysis. They must be realistic and periodically reviewed; otherwise, variances mislead decision‑making.

---

Case Study: Budget vs Actual Meeting

A cross-functional discussion of a “budget versus actual” report, with green (favorable) and red (unfavorable) variances, shows how surface-level numbers can hide deeper problems.

Key Variances Identified

The Danger of Misinterpreting Favorable Variances

The material rate variance appeared favorable, but the lower cost was achieved by sacrificing quality. Consequences:

• 3% of output rejected at final quality inspection.
• Value‑added costs (~60% of total cost) were wasted on defective units.
• Production department lost incentives because throughput dropped.

Product Mix and Revenue

Marketing deviated from the agreed product mix to chase revenue. While revenue beat budget, the change caused:

• Throughput to plummet (production department struggled with non‑standard runs).
• Incentive system to fail – production staff received no bonuses despite meeting delivery schedules.

The discussion concluded that variance reports are not solutions but starting points for dialogue. Actions decided:

1. Switch back to the previous supplier or tighten supplier quality checks.
2. Consider flexible manufacturing system to handle future mix changes.
3. Invest in analytical software for better sales forecasting.

---

Key Takeaways

• Variance analysis compares actuals to budgets/standards at macro (department) and micro (root cause) levels.
• A favorable variance does not automatically mean good performance – it may hide quality or efficiency trade‑offs (e.g., lower material cost → higher scrap).
• Revenue and product mix variances can conflict with production incentives and throughput.
• The real value of variance analysis lies in facilitating cross‑functional problem‑solving, not in the numbers themselves.
• Standards are essential; they are easier to set for manufacturing than services, and ABC can provide ready‑made standards.

Setting Standards

Setting standards is a critical step in a management control system. Standards act as benchmarks: too high (unachievable) demotivates; too low (liberal) wastes resources and destroys respect for the system. The goal is standards that are reasonably accurate and achievable with effort.

Purpose of Standards

• Motivation: A stretch, but reachable target encourages performance.
• Control: Variances highlight deviations early.
• Costing: Standard costs simplify pricing, inventory valuation, and budgeting.
• Continuous improvement: Periodic revision forces re-evaluation of processes.

Setting Material Standards

Material standards come from the product’s technical definition:

1. Quantity standard – derived from R&D documents (engineering drawings, bill of materials) or production specifications. Small normal variations are allowed.
2. Rate standard – obtained by the purchase department from supplier quotes or market prices.

   Standard material cost = standard quantity × standard rate.

Worked example – Herbal toothpowder (FMCG company) For 1 kg of toothpowder the R&D team defined this bill of materials:

The purchase team then collects market prices to set the rate standard.

Setting Labour and Machine Hour Standards

Labour standards matter only when labour content is significant; otherwise, machine hours replace labour.

• Labour quantity – based on time and motion study or external consultants with similar‑industry experience.
• Labour rate – provided by the Human Resources Department.

When labour is insignificant (high automation) – use machine hour rate.

All costs related to running a machine (operator salary, power, repairs, depreciation, factory space) are pooled into a standard machine hour rate.

Worked example – Mixer & blending machine

Given data:

• Machine cost: ₹250,000
• Effective life: 10,000 hours → Depreciation = ₹250,000/10,000 = ₹25/hour
• Power cost: ₹200/hour
• Repairs & maintenance: 20% of machine cost per year = ₹50,000/year Machine usage: 100 hours/month → 1,200 hours/year → R&M = ₹50,000/1,200 = ₹41.67 ≈ ₹42/hour
• Operator: ₹20,000/month, works 100 hours/month → ₹200/hour
• Factory space: 600 sq. ft. × ₹20/sq.ft./month = ₹12,000/month → Building depreciation = ₹12,000/100 hours = ₹120/hour

Standards must be periodically reset when any major cost component changes (e.g., power tariff hike, salary revision).

Setting Overhead Standards (Without ABC)

Overhead standards are difficult without activity‑based costing. The approach:

• Department heads identify resources needed for each task.
• Separate variable and fixed components are estimated (often imperfect in the first iteration).
• If a good accounting system captures monthly departmental expense data, cost‑behaviour analysis (variable vs. fixed split) improves over time.
• With an Activity‑Based Costing system in place, the activity list plus its cost already serves as a standard.

Theoretical vs. Practical Standards

A theoretical standard assumes ideal conditions (no downtime, no breaks). A practical standard reflects real‑world constraints. Always prefer practical standards.

Exam tip: When calculating standard machine hour rates or labour hours, use the practical capacity (expected usage, not maximum theoretical capacity) – otherwise standards become unattainable and demotivating.

Key takeaways

• Standards must be reasonably achievable – too tight demotivates, too loose wastes resources.
• Material standards come from technical documents; labour from time & motion; machine hours replace labour when automation is high.
• Machine hour rate pools depreciation, power, repairs, operator, and space costs.
• Overhead standards rely on cost behaviour analysis (or ABC) and are refined over time.
• Always use practical capacity, not theoretical, when setting standards.
• Revise standards whenever a major cost driver changes.

Variance Analysis – General Framework

Variance analysis is the systematic comparison of actual performance against budgets and standards. Its purpose: identify deviations, diagnose their cause (price vs. quantity), and enable corrective action. Because cost has two components – quantity and price/rate – a deviation can come from either or both. Variance analysis splits the total difference into a rate/price variance and a usage/efficiency variance.

Intuition: Why split the variance?

Cost = Quantity × Rate. If actual cost exceeds standard cost, we need to know whether the team used too much material (quantity problem), paid too much per unit (price problem), or both. Holding one factor constant while isolating the other gives clear accountability.

The General Framework: Three‑point method

Three key values are computed:

The differences between these values give the two variances:

• Price/Rate variance = Actual cost – Standard cost for actual quantity = (Actual rate – Standard rate) × Actual quantity
• Usage/Efficiency variance = Standard cost for actual quantity – Standard cost = (Actual quantity – Standard quantity) × Standard rate

Total variance = Price variance + Usage variance (both adverse or favourable).

Exam tip: Always compute the middle value (AQ × SR). It is the bridge between actual and standard. Without it, variances cannot be separated.

Material Cost Variance

Material cost is: Material cost = Quantity used × Price per unit. Total Material cost variance = Actual material cost – Standard material cost.

Worked example: health drink producer

Data:

• Actual output: 8 000 kg (planned 10 000 kg – volume difference examined separately under budgetary control).
• Standard: 600 g malt per kg product → standard quantity (SQ) for 8 000 kg = 4 800 kg
• Standard price = ₹40/kg → standard cost = 4 800 × 40 = ₹1 92 000
• Actual: consumed 5 000 kg at ₹42/kg → actual cost = 5 000 × 42 = ₹2 10 000

Three-point values:

Variances:

• Material price variance = ₹2 10 000 – ₹2 00 000 = ₹10 000 (Adverse) Check: (42 – 40) × 5 000 = ₹10 000.
• Material usage variance = ₹2 00 000 – ₹1 92 000 = ₹8 000 (Adverse) Check: (5 000 – 4 800) × 40 = ₹8 000.
• Total material cost variance = ₹10 000 + ₹8 000 = ₹18 000 (Adverse).

All variances are adverse (A) because actual cost exceeded standard.

Material Purchase Price Variance

If material purchased differs from material consumed, a separate material purchase price variance can be computed for the purchasing department.

Example extension: Purchase dept bought 5 500 kg at ₹42/kg.

• Purchase price variance = (Standard price – Actual price) × Purchase quantity = (40 – 42) × 5 500 = ₹11 000 (Adverse).

Exam tip: Material price variance usually uses quantity consumed; material purchase price variance uses quantity purchased. The latter is more relevant for evaluating the purchasing department.

Key takeaways – Material variance

• Total material variance = Price variance + Usage variance.
• Price variance = (AR – SR) × AQ (consumed).
• Usage variance = (AQ – SQ) × SR.
• If purchased quantity differs, compute a separate purchase price variance.
• Always state if variance is adverse (A) or favourable (F).

Labour Cost Variance

Labour cost follows the same logic: Labour cost = Hours worked × Hourly rate.

• Labour rate variance = (Actual rate – Standard rate) × Actual hours.
• Labour efficiency variance = (Actual hours – Standard hours allowed) × Standard rate.

Worked example: electronic product assembly

Data:

• Standard time per unit: 2.5 hours.
• Standard rate: ₹150/hour (based on salary ₹30 000 per worker per month ÷ 200 hrs).
• Planned volume: 400 units/month; actual volume: 360 units.
• Actual hours: 1 000 hours; actual labour cost: ₹1 60 000 → actual rate ₹160/hour.

Standard hours for actual output (flexible budget): 360 units × 2.5 hrs = 900 hours.

Three-point values:

Variances:

• Labour rate variance = ₹1 60 000 – ₹1 50 000 = ₹10 000 (A) Check: (160 – 150) × 1 000 = ₹10 000.
• Labour efficiency variance = ₹1 50 000 – ₹1 35 000 = ₹15 000 (A) Check: (1 000 – 900) × 150 = ₹15 000.
• Total labour cost variance = ₹10 000 + ₹15 000 = ₹25 000 (A).

Exam tip: The flexible budget (standard cost for actual output) is the key benchmark – it removes the effect of volume differences. Volume differences (planned vs actual output) are tracked separately under budgetary control, not in labour efficiency variance.

Key takeaways – Labour variance

• Labour variance = Rate variance + Efficiency variance.
• Rate variance = (AR – SR) × AH.
• Efficiency variance = (AH – SH) × SR.
• Standard hours (SH) must be calculated based on actual output, not budgeted output.
• Adverse variances indicate higher cost than standard; favourable if lower.

Variable Overhead Variance

Variable overhead (VOH) costs vary with production activity (e.g., machine power, indirect materials). In standard costing, a VOH rate (e.g., machine‑hour rate) is set during budgeting. This rate is applied to actual activity as production occurs. The accounting system captures the actual VOH cost. Comparing these three figures – actual, applied, and budgeted for actual output – yields two sub‑variances: spending variance and efficiency variance.

Intuition and Formulas

Let:

• $AH$ = actual machine hours used
• $SH$ = standard machine hours allowed for actual output ($\text{actual units} \times \text{standard hours per unit}$)
• $SR$ = standard VOH rate per hour
• $AR$ = actual VOH rate per hour ($\text{actual VOH cost} / AH$)

Then:

$$\begin{aligned} \text{Total VOH variance} &= \text{Actual VOH} - \text{Standard VOH for actual output} \\ &= (AH \times AR) - (SH \times SR) \\ \\ \text{VOH spending variance} &= (AR - SR) \times AH \\ \\ \text{VOH efficiency variance} &= (AH - SH) \times SR \end{aligned}$$

• Spending variance – difference between what we actually paid per hour and what we budgeted, times the actual hours used. Reflects price/rate control.
• Efficiency variance – difference between actual hours and standard hours, times the standard rate. Reflects how efficiently the activity (machine hours) was used.
• Total VOH variance = Spending variance + Efficiency variance.

A variance is favourable (F) when actual cost is less than standard/budgeted cost; adverse (A) when actual cost exceeds standard.

Worked Example: Switchgear Co.

Given data:

• Budgeted volume: 1 000 units
• Actual production: 1 100 units → standard hours for actual output $SH = 1\text{\,}100 \times 2 = \mathbf{2\,200}$ hours
• Standard VOH rate: ₹ 1 000 per machine hour
• Actual machine hours used: 2 300 hours
• Actual VOH cost: ₹ 21 85 000
• Actual VOH rate: $\frac{21\,85\,000}{2\,300} = \text{Rs. }\,950$ per hour

Total VOH variance $\text{Actual} - \text{Standard} = 21\,85\,000 - 22\,00\,000 = -15\,000$ → 15 000 F (cost saved)

Spending variance $(\text{Actual rate} - \text{Standard rate}) \times AH = (950 - 1\,000) \times 2\,300 = -1\,15\,000$ → 1 15 000 F (lower rate)

Efficiency variance $(\text{AH} - \text{SH}) \times SR = (2\,300 - 2\,200) \times 1\,000 = 1\,00\,000$ → 1 00 000 A (extra hours)

Check: $1\,15\,000\ \text{F} + 1\,00\,000\ \text{A} = -15\,000\ \text{F}$ ✓

Exam tip: The total VOH variance can also be expressed as the sum of spending and efficiency variances. The “applied” figure ($AH \times SR$) is an intermediate that separates the two drivers. Spending variance focuses on cost control; efficiency variance on usage control.

Key takeaways

• VOH has two sub-variances: spending (rate) and efficiency (usage).
• Spending variance = $(AR - SR) \times AH$; efficiency variance = $(AH - SH) \times SR$.
• Actual VOH rate = actual total VOH ÷ actual hours; standard hours = actual units × standard hours per unit.
• A favourable total variance does not guarantee both sub-variances are favourable – here efficiency was adverse but more than offset by a strong rate gain.

---

Fixed Overhead Variance

Fixed overhead (FOH) costs (e.g., rent, insurance, annual maintenance) do not change with production volume. A fixed overhead rate is predetermined based on budgeted volume and machine hours. The applied FOH ($\text{actual hours} \times \text{FOH rate}$) is purely an accounting allocation. The actual FOH is the cash spent. Comparing actual, budgeted, and applied figures gives two variances: spending variance (cost control) and volume variance (capacity utilisation).

Intuition and Formulas

Let:

• $AF$ = actual fixed overhead cost
• $BF$ = budgeted fixed overhead cost (at budgeted volume)
• $FH$ = budgeted machine hours (at budgeted volume)
• $FR$ = fixed overhead rate per machine hour ($BF / FH$)
• $AH$ = actual machine hours used

Then:

$$\begin{aligned} \text{FOH spending variance} &= AF - BF \\ \text{FOH volume variance} &= (AH \times FR) - BF \quad (\text{or } BF - \text{Applied? careful}) \\ \text{Total FOH variance} &= AF - (AH \times FR) = \text{Spending variance} + \text{Volume variance} \end{aligned}$$

• Spending variance – how much actual fixed cost deviates from the budgeted lump sum.
• Volume variance – the difference between applied (based on actual hours) and budgeted fixed overhead. It arises because the budgeted fixed cost is spread over a fixed number of hours; if actual hours differ, the allocation changes. A favourable volume variance means actual hours > budgeted hours → more output absorbed fixed costs, reducing unit cost. But it is only beneficial if the extra hours produced additional output (not idle time or waste).
• Total FOH variance = Actual – Applied.

Worked Example: Switchgear Co. (continued)

Given data:

• Budgeted fixed overhead for the month: ₹ 13 20 000
• Budgeted machine hours: 2 200 hours (from earlier: 1 000 units × 2 hrs/unit)
• Fixed overhead rate: $FR = \frac{13\,20\,000}{2\,200} = \text{Rs. }\,600$ per machine hour
• Actual machine hours: 2 300 hours
• Actual fixed overhead cost: ₹ 14 00 000
• Applied fixed overhead: $2\,300 \times 600 = \mathbf{\text{Rs. }\,13\,80\,000}$

FOH spending variance $AF - BF = 14\,00\,000 - 13\,20\,000 = 80\,000$ → 80 000 A (spent more than budget)

FOH volume variance $\text{Applied} - \text{Budgeted} = 13\,80\,000 - 13\,20\,000 = 60\,000$ → 60 000 F (more hours than budgeted)

Total FOH variance $AF - \text{Applied} = 14\,00\,000 - 13\,80\,000 = 20\,000$ → 20 000 A

Check: $80\,000\ \text{A} + 60\,000\ \text{F} = 20\,000\ \text{A}$ ✓

Exam tip: A favourable volume variance is not automatically good. It signals that the plant operated at a higher activity level than budgeted. If the extra hours were used to produce more output, fixed cost per unit decreases – genuinely favourable. If the same output was produced with extra hours (inefficiency), the volume variance is favourable but masks operating waste. Always pair volume variance with efficiency data.

Key takeaways

• FOH has two variances: spending (cost control) and volume (activity level vs. budget).
• Spending variance = Actual – Budgeted; Volume variance = Applied – Budgeted.
• Total FOH variance = Actual – Applied = Spending + Volume.
• Volume variance reflects capacity utilisation; interpret with caution – more hours are not always better if efficiency suffers.

Material Mix and Yield Variance

When multiple materials are blended to make a product (e.g., a tablet, a dish), the total material cost can deviate from standard in three ways: price changes, usage efficiency, and changes in the mix of materials. The mix variance isolates the effect of using a different proportion of ingredients than planned — holding total quantity and price constant.

Intuition

Imagine a recipe that calls for 1 part expensive ghee, 2 parts cheap sugar, and 1 part mid-priced flour. If you deviate from that ratio — say, add extra ghee — the average cost per kg rises, even if the total weight and individual prices stay the same. That shift in cost is the material mix variance. Any leftover difference in total material cost (after pricing and mix effects) is the material yield variance, reflecting whether the total input was more or less than expected for the actual output.

The four values framework

To decompose the total material cost variance into price, mix, and yield components, we need four cost calculations:

Where:

• $AQ$ = actual quantity of each material
• $AP$ = actual price per unit
• $SP$ = standard price per unit
• $SM\%$ = standard mix proportion (e.g., 0.25 gram flour)
• $SQ_{for\;output}$ = standard quantity of each material allowed for the actual output

The three variances are:

Price Variance  = (1) – (2)
Mix Variance    = (2) – (3)
Yield Variance  = (3) – (4)

Worked example: Festive sweet

Standard mix (recipe) — makes a certain number of sweets:

Actual usage — cook adjusted for taste:

Step 1: Compute the four values

(1) Actual Material Cost = ₹738.50

(2) Actual Qty × Std Price:

• Gram flour: $1.0 \times 150 = 150$
• Sugar: $2.1 \times 40 = 84$
• Ghee: $1.2 \times 400 = 480$
• Total = ₹714.00

(3) Std Mix cost for total actual qty (4.3 kg): Apply standard mix percentages to 4.3 kg, then multiply by standard prices.

(4) Standard Cost for Actual Output (what should have been used): If the cook made the same number of sweets, the standard total cost is still ₹630 because actual output equals standard output and the standard quantity of 4 kg applies. → ₹630.00

Step 2: Compute variances

All three variances are adverse because the actual cost exceeded standard.

Why mix variance matters

• It isolates the cost effect of deviating from the prescribed blend. In the example, the cook increased the share of the most expensive ingredient (ghee) and decreased the share of cheaper sugar and flour, raising average cost.
• In industrial settings, mix variance flags issues such as:
  • Poor quality of a raw material (needing more of it)
  • Substitution to cheaper inputs (favourable mix variance)
  • Process inefficiencies that change the blend.

Other variances in the same family

A parallel concept exists for labour mix variance when different grades of workers (skilled, semi-skilled, unskilled) are used in a mix.

Word of caution

In real-life production (especially food or artisanal products), a zero variance does not guarantee a good product. The cook’s deviation may improve taste and quality. Variance analysis is a financial control tool, not a quality gauge. Always interpret variances in context — especially when the “standard” is a recipe, not a rigid specification.

Key takeaways

• When multiple materials are combined, the cost difference can be split into price, mix, and yield variances.
• Material Mix Variance = effect of using materials in different proportions than standard (holding total quantity and price constant).
• Material Yield Variance = effect of using more or less total material than the standard allowed for the actual output.
• The four-value framework ($AQ\times AP, AQ \times SP, SM\% \times AQ_{total} \times SP, SQ_{output} \times SP$) enables the decomposition.
• Mix variance is especially important when materials have large price differences; even small proportional shifts can cause significant cost changes.

Sales and Sales Mix Variance

Variance analysis applies to the revenue side as well. Because fixed costs are constant across budgeted and actual output, we compare contribution margin (selling price minus variable cost) rather than profit. For a single product, total contribution margin variance splits into a price (rate) variance and a volume variance. For multiple products, the volume variance further decomposes into a sales mix variance (change in product proportions) and a sales quantity variance (change in total volume at budget mix).

---

Single-Product Sales Variance

Budgeted contribution per unit is $CM_b = P_b - VC$. Actual contribution per unit is $CM_a = P_a - VC$. The total contribution margin variance is:

$$\text{Total CM variance} = (CM_a \cdot Q_a) - (CM_b \cdot Q_b)$$

Split into:

• Sales price variance (or contribution rate variance) — effect of selling at a different price:

  $$\text{Price variance} = (CM_a - CM_b) \times Q_a$$

• Sales volume variance — effect of selling a different quantity:

  $$\text{Volume variance} = (Q_a - Q_b) \times CM_b$$

Exam tip: The price variance uses actual quantity; the volume variance uses budgeted contribution per unit. This mirrors the cost variance structure (price × actual quantity; quantity × budgeted price).

Worked Example: Book Publisher

• Contribution price variance: $(80 - 120) \times 3,600 = -144,000$ (Adverse)
• Contribution volume variance: $(3,600 - 4,000) \times 120 = -48,000$ (Adverse)
• Total contribution variance: Rs. 192,000 (Adverse)

Note: The same framework on sales revenue gives a volume variance of $(3,600-4,000)\times300=-120,000$ and a price variance of $(260-300)\times3,600=-144,000$, explaining the total sales revenue shortfall of Rs. 264,000.

---

Multiproduct Sales Mix Variance

When a firm sells multiple products with different contribution margins, a change in the sales mix (relative proportions) can affect total contribution even if total volume meets budget. The total volume variance is split into:

• Sales mix variance: the difference caused by selling a different mix than budgeted, holding total volume constant at actual level.
• Sales quantity variance: the difference caused by selling a different total volume, holding the budgeted mix constant.

The decomposition uses four columns (analogous to material mix variance):

Variances:

$$\begin{aligned} \text{Total CM variance} &= \text{Col2} - \text{Col5} \\ \text{Contribution rate variance} &= \text{Col2} - \text{Col3} \\ \text{Sales volume variance} &= \text{Col3} - \text{Col5} \\ \quad \text{Sales mix variance} &= \text{Col3} - \text{Col4} \\ \quad \text{Sales quantity variance} &= \text{Col4} - \text{Col5} \end{aligned}$$

Worked Example: Deodorant Manufacturer (Royal, Cool, Spice)

Budget: Total volume = 20,000 KL. Mix: Royal 40%, Cool 35%, Spice 25%. Budgeted CM/KL: Royal Rs. 20,000; Cool Rs. 12,000; Spice Rs. 9,000. Total budgeted contribution = Rs. 28.90 cr.

Actual: Total volume = 22,000 KL. Actual CM/KL: Royal Rs. 22,000; Cool Rs. 8,000; Spice Rs. 9,000. Actual mix shifted unfavourably (more Spice, less Royal). Actual total contribution = Rs. 26.90 cr.

Variance decomposition (Rs. crores):

Interpretation:

• The rate variance (Rs. 1.60 cr adverse) captures the lower contribution from Cool and higher contribution from Royal at actual quantities.
• Despite selling more total volume (2,000 KL extra), the unfavourable sales mix (selling too much of the low-margin Spice and too little of the high-margin Royal) cost Rs. 3.29 cr. That loss was partly offset by a favourable quantity variance of Rs. 2.89 cr, leaving a net volume variance of Rs. 0.40 cr adverse.
• The overall Rs. 2 cr shortfall is driven mainly by the price/rate drop on Cool and the mix shift.

Exam tip: In a multi-product setting, a favourable total volume variance may hide a serious mix problem. Always decompose volume variance into mix and quantity components. The sales mix variance is often the most actionable piece of information for management.

Visual Hierarchy

---

Key Takeaways

• Sales variance analysis uses contribution margin (price – variable cost) to isolate the effect of fixed costs.
• Single-product: price variance = (actual CM – budget CM) × actual quantity; volume variance = (actual quantity – budget quantity) × budget CM.
• Multi-product: volume variance splits into sales mix variance (change in proportions) and sales quantity variance (change in total volume at budget mix).
• A template approach (four columns) automates computation; interpretation of mix variance is critical for corrective action.
• Adverse mix variance indicates the company sold a less profitable combination of products than planned, even if total volume increased.

Investigating Variance

Variance investigation is the real-world process that turns raw variance numbers into corrective action. Once the IT department produces the periodic variance report and sends it to each manager, the job is not just to read the numbers — it is to explain them.

The investigation cycle

1. Report distribution. The variance report is sent to every departmental manager.
2. Preliminary analysis. Each manager studies the variances relevant to their own department and notes possible reasons.
3. Budget committee meeting. A formal meeting is convened, chaired by the budget committee, where all managers are invited to present their analysis and debate the causes.
4. Debate and blame. Managers argue over who or what caused the variances. Cross-departmental finger-pointing is common.
5. Agreed actions. By the end of the meeting, managers agree on concrete action points to bring costs back to budget levels.
6. Possible budget revision. If a new, uncontrollable development has caused the variance, the budget itself may be revised for the remaining period.

A classic tug-of-war: production vs. purchasing

Consider a high-frequency example:

• Production manager blames material quantity variance (excess usage) on poor quality materials supplied by the purchase department.
• Purchase department intentionally buys cheaper material to show a favourable price variance — but that cheap material reduces quality, causing more waste on the factory floor.
• Production manager also complains that workers are not adequately trained, blaming the HR department for cutting training costs.

These are the arguments and counter‑arguments that dominate the meeting. The committee must disentangle the true root cause from departmental blame-shifting.

Exam tip: The purchase–production conflict is a standard exam case. Favourable purchase price variance can cause unfavourable material usage variance — the two are linked. Always check whether a favourable variance in one department created problems elsewhere.

When favourable variance signals poor standards

Too much favourable variance across a department is not necessarily good news. It often means the original standards were set too loose — making the targets too easy to beat. In that case, standards should be revised upward to reflect realistic, challenging performance.

Performance incentives

Variance analysis is also used to reward managers. Departments that consistently show favourable variances are given performance incentives (bonuses, recognition). This reinforces the importance of accurate standard‑setting: loose standards inflate bonuses without real improvement.

---

Key takeaways

• The budget committee meeting is the critical control point where variances are debated and action plans set.
• Cross‑departmental blame is typical; the committee must identify true root causes, not just accept one manager’s excuse.
• Favourable variance may indicate loose standards, not superior performance — standards should be revised accordingly.
• Variance results are used for performance rewards, giving managers incentive to meet or beat targets.
• Budgets may be revised mid‑period if external developments make the original budget obsolete.

Budgeting

Budgeting is the process of creating a detailed, short‑term plan (typically one year) that translates an organization’s long‑range strategic direction into actionable, financial and operational targets. It is a formal commitment by management to a specific set of activities and resource allocations.

Purpose and Scope

• Long‑range planning (5–10 years) sets macro‑level direction aligned with vision and mission (e.g., sales growth, number of plants, markets, overall profit).
• Budgets provide micro‑level detail for the next 12 months. Every manager participates; the budget represents a commitment to a one‑year operating plan.

Budget Preparation Process

• Sales budget is the starting point – because demand is often the binding constraint, the marketing department’s sales forecast drives all other budgets.
• Managers identify bottlenecks during the process and devise ways to overcome them.
• Functional budgets must be coordinated across departments.
• After operating budgets are complete, financial budgets are prepared: – Cash budget (often updated weekly) – Budgeted income statement – Budgeted balance sheet

Types of Budgets

Several variations include:

Budget Discipline

• Once approved, managers must follow the budget – spending on activities without a budget provision is prohibited.
• Periodic comparison of actuals vs. budget produces variance reports that serve as a control mechanism.

Exam tip: The sales budget is the first and most critical budget – it drives all other functional budgets. Be able to list the order: sales → production → materials/labour/overhead → financial budgets.

Key takeaways – Budgeting

• Budgets are one‑year micro‑plans derived from long‑range strategic plans.
• The process begins with the sales budget; all other budgets support it.
• Financial budgets (cash, income, balance sheet) follow operating budgets.
• Variations include flexible, zero‑based, rolling, activity‑based, and Kaizen budgets.
• Once approved, budgets are binding; variances are tracked for control.

Standard Costing and Variance Analysis

While budgets control costs at a macro level (department/function), standard costing and variance analysis track and control costs at the micro level – individual products, materials, labour, and overheads.

Core Idea

• Standard costs are predetermined targets for materials, labour, variable overhead, and fixed overhead.
• Actual costs are collected and compared to standards.
• A variance is the difference between actual and standard cost.

Variance Decomposition

Actual cost can deviate from standard cost due to:

1. Rate (price) differences – e.g., paying more per kg of material.
2. Usage (efficiency) differences – e.g., using more material than the standard allows.

Standard variance formulas:

$\text{Material Price Variance} = (\text{Actual Price} - \text{Standard Price}) \times \text{Actual Quantity}$ $\text{Material Usage Variance} = (\text{Actual Quantity} - \text{Standard Quantity}) \times \text{Standard Price}$

These are mirrored for labour (rate and efficiency), variable overhead (spending and efficiency), and fixed overhead (spending and volume).

Types of Variances Reported

• Variances can be computed product‑wise or department‑wise.
• Mix variances arise when the actual proportion of inputs (e.g., material grades, labour grades) differs from the standard mix.

The Control Cycle

• The budget committee expects managers to explain why actuals differ from standards and to propose corrective actions.
• Variance discussion is a major part of a manager’s day‑to‑day job, especially in process industries.

Exam tip: Distinguish between planning variances (due to inaccurate standards) and operational variances (due to actual performance). Operational rate/usage and mix variances are core calculations.

Key takeaways – Standard Costing and Variance Analysis

• Standards are micro‑level cost targets for material, labour, and overhead.
• Variances are split into rate/price and usage/efficiency components.
• Mix variances apply when inputs are combined in specific proportions.
• Sales variances (revenue, contribution, mix) are also tracked.
• Managers must analyse variances and take corrective action; this is an ongoing control exercise.

1. Sales and Production Budget

Purpose: Plan sales quantity and the production needed to meet demand while maintaining a desired inventory buffer.

Key inputs:

• Forecast sales (units) for each month
• Opening finished‑goods inventory (units)
• Inventory policy: closing inventory = 20% of the next month’s sales

Core formula:

$$\text{Production} = \text{Target sales} + \text{Desired closing inventory} - \text{Opening inventory}$$

Worked example (numbers in lakh units):

• Sales value = units sold × ₹6 per unit → total quarter sales ₹894 lakh (₹300,₹270,₹324 lakh for Jan–Mar).
• Production total also equals sum of monthly productions (57 + 46.80 + 55.20 = 159.00) – a consistency check.

Key takeaways

• Production = sales + closing stock − opening stock.
• Closing stock is driven by the next month’s sales forecast.
• Quarter totals can be cross‑checked: total production = total sales + closing − opening.

---

2. Purchase Budget (Raw Materials)

Purpose: Determine the quantity and value of raw materials to purchase, using the production budget and raw‑material inventory policy.

Data from production budget:

• Monthly production (units): Jan 57,00,000; Feb 46,80,000; Mar 55,20,000; Apr 60,00,000 (needed for closing stock calc).

Material requirements per 1000 units:

• Magnesium dioxide (MnO₂): 3 kg
• Zinc: 6 kg

Raw‑material inventory policy: closing stock = 5% of the next month’s production requirement.

General formula per material:

$$\text{Purchases (kg)} = \text{Material required for production} + \text{Desired closing stock} - \text{Opening stock}$$

(a) Magnesium dioxide

*Calculated from the stated totals; small differences reflect rounding.

(b) Zinc

• Overall purchase budget = ₹57,72,000 + ₹1,44,30,000 = ₹2,02,02,000 (c. ₹202 lakh) vs. sales ₹894 lakh.

Exam tip: The purchase budget always needs next month’s production requirement to compute closing stock. Always check if the production budget for the following month is given or can be derived.

Key takeaways

• Purchases = material used + closing stock − opening stock.
• Material requirement per unit is fixed (here per 1000 units).
• Closing stock raw material is a % of the next month’s production requirement.
• Total purchases value across materials sums to the total raw material budget.

---

3. Cash Collection Budget (Receivables)

Purpose: Estimate cash inflows from customers, given a mix of cash and credit sales, and a credit collection pattern.

Sales mix:

• Cash sales (individuals): 20% of total sales – collected immediately.
• Credit sales (corporate clients): 80% of total sales – collected over three months.

Credit collection pattern (for any month’s credit sales):

• 30% collected in the same month
• 50% collected in the following month
• 20% collected two months after the sale

Step 1: Derive opening receivables as on April 1

Sales data for Jan–Mar (₹):

Amounts still receivable on April 1:

• From Feb credit sales: 20% (collected in April) = 0.20 × 17,60,000 = ₹3,52,000
• From Mar credit sales: the 70% not collected in Mar (50% in Apr, 20% in May) = 0.70 × 19,71,200 = ₹13,79,840

Opening receivables (April 1) = ₹3,52,000 + ₹13,79,840 = ₹17,31,840.

Step 2: Monthly collections and closing receivables (Apr–Jun)

• Credit collections in a month = (30% of current month’s credit sales)

  • (50% of previous month’s credit sales)
  • (20% of two‑months‑ago credit sales)

• Cash collections = 20% of current month’s total sales.

Example calculation for April:

• Credit sales (Apr) = 80% of Apr total sales (say ₹28,33,000) = ₹22,66,400
• Collections from credit customers:
  • 30% of Apr credit sales = 0.30 × 22,66,400 = ₹6,79,920
  • 50% of Mar credit sales = 0.50 × 19,71,200 = ₹9,85,600
  • 20% of Feb credit sales = 0.20 × 17,60,000 = ₹3,52,000
  • Total credit collections = ₹6,79,920 + ₹9,85,600 + ₹3,52,000 = ₹20,17,520
• Cash collections (Apr) = 20% of 28,33,000 = ₹5,66,600
• Total collections (Apr) = ₹20,17,520 + ₹5,66,600 = ₹25,84,120

Closing receivables formula:

$$\text{Closing receivables} = \text{Opening receivables} + \text{Credit sales} - \text{Credit collections}$$

Thus for April: Closing = 17,31,840 + 22,66,400 − 20,17,520 = ₹19,80,720.

Summary table (Apr–Jun):

Exam tip: Always match collection percentages carefully. Here, 30% same month, 50% next month, 20% two months later – a common pattern. A single swapped number (e.g., 20% and 30%) leads to wrong receivables.

Key takeaways

• Opening receivables = sums of uncollected portions from prior months.
• Credit collections are the sum of three lagged percentages of credit sales.
• Closing receivables = opening + credit sales – credit collections.
• Cash sales add directly to total collections.

Exercise 4: Payment to Suppliers – Credit Terms & Cash Discount

Core problem: Estimate monthly cash payments to suppliers given a mixture of cash and credit purchases, varying credit periods, and optionally a cash discount for early settlement.

Credit terms (without discount)

Goldstar Enterprise has two types of purchases:

• 10% cash purchases – paid immediately.
• 90% credit purchases – split into three payment buckets:

Working backwards from January 1, 2017 – the opening payables balance is the sum of unpaid credit portions from October, November, and December 2016:

• October purchases fully paid by Jan 1 (30% in Oct, 50% in Nov, 20% in Dec) → $0$ owed.
• November credit purchases: 20% (90‑day bucket) still unpaid → $+0.20 \times \text{Nov credit purchases}$.
• December credit purchases: 20% (90‑day) + 50% (45‑day) still unpaid = 70% of Dec credit purchases → $+0.70 \times \text{Dec credit purchases}$.

Example data (from the problem): December credit purchases = 54 (million) → $0.70\times 54 = 37.8$ November credit purchases = 45 → $0.20\times 45 = 9$ Opening payables (Jan 1) = 37.8 + 9 = 46.8 (million).

Cash payment formula (monthly)

$\text{Cash paid to suppliers} = \text{Opening payables} + \text{Credit purchases} - \text{Closing payables}$

Closing payables at month‑end = unpaid credit from that month and prior months, computed using the same three bucket logic.

January example (without discount):

• Opening = 46.8
• Credit purchases (Jan) = 46.8 (total purchases 52 – cash 5.2)
• Closing = 43.56 (from formula)
• Payment = $46.8 + 46.8 - 43.56 = 50.04$
• Plus cash purchases (5.2) → total cash outflow = 55.24

The same logic repeats for February and March (using March closing = April opening = 36.99).

Cash discount scenario

Suppliers offering a 90‑day credit period (20% of credit purchases) are willing to accept immediate payment at a 5% discount (i.e., pay 95% of that amount on the purchase date). Goldstar borrows at 8% p.a. – the decision to take the discount depends on whether the savings exceed the borrowing cost, but here the company decides to pay immediately.

Effect on credit terms:

• The 90‑day bucket disappears; those suppliers are now paid in the same month.
• Remaining credit purchases: 30% (15‑day) and 50% (45‑day) are still paid in same month and next month respectively.
• Net effect: 50% of credit purchases paid same month, 50% paid next month.

Revised opening payables (Jan 1): Only the 50% bucket from December remains unpaid → $0.50 \times \text{Dec credit purchases}$ = $0.50 \times 54 = 27$.

Revised monthly payment calculation: $\text{Cash paid to credit suppliers} = \text{Opening} + \text{Credit purchases} - \text{Closing}$ where closing = 50% of current month’s credit purchases (since the other 50% will be paid next month).

January example (with discount):

• Opening = 27
• Credit purchases (Jan) = 46.8
• Closing (50% of 46.8) = 23.4
• Gross payment = $27 + 46.8 - 23.4 = 50.4$
• Cash discount: only applies to the 20% of credit purchases that would have been 90‑day. That portion is paid immediately this month. Discount = $5\% \times 20\% \times \text{Credit purchases}$ = $0.05 \times 0.20 \times 46.8 = 0.468$ (In the solution, 0.47 is used.)
• Net cash to credit suppliers = $50.4 - 0.468 = 49.932$
• Plus cash purchases (5.2) → total = 55.132

Verification at quarterly level: Total cash paid (with discount) = opening + credit purchases – closing + cash purchases – discount. Substituting quarterly sums (all numbers in million):

This matches the sum of monthly payments (≈150.45).

Exam tip: When credit terms change due to a discount, always reconstruct the payment timeline first. The new opening payables are based on the remaining outstanding buckets, not the original ones.

Comparison (monthly payments):

The discount does not always reduce every month’s payment because the timing of cash flows shifts. Verification at the quarterly level assures consistency.

Key takeaways

• Opening payables = sum of unpaid credit portions from months prior to the budget period, based on each credit bucket.
• Cash payment = opening + credit purchases – closing.
• A cash discount compresses the credit period: the 90‑day bucket collapses into same‑month payment, altering opening payables and monthly cash flows.
• Always verify total cash paid over the quarter by summing inflows/outflows.

---

Exercise 5: Cash Budget for a Finance Company – Determining Deposit Needs

Core problem: Trinity Leasing & Hire Purchase needs to manage its cash balance while lending and borrowing. Given quarterly repayments of deposits, interest costs, and new loans, the company must decide how much incremental deposit to raise each quarter to maintain a minimum cash balance of 10 million.

Data summary

• Opening cash balance: assumed 10 million (at start of Q1).
• Existing loans outstanding: 290 million (as on 1 April).
• Existing deposits outstanding: 300 million.
• Deposit repayment schedule (at quarter‑end): Q1: 60, Q2: 40, Q3: 80, Q4: 60 (million).
• Interest on deposits: 12% p.a., payable quarterly on the outstanding deposit balance at the beginning of the quarter (or on average? Actually the solution uses outstanding at start of quarter).
• New lease proposals: 30 million per quarter, incremental (i.e., total loan portfolio grows by 30 each quarter).
• Collection from existing loans: 28,000 per month per 1 million lease value, for 60 months. For the existing 290 million, monthly collection = $290 \times 28,000 = 8,120,000$ (8.12 million). Quarterly = $8.12 \times 3 = 24.36$ million.
• Collection from new loans: In Q1, new loans 30 million – collect from them from the start? Yes, solution assumes they are disbursed at beginning of quarter and generate immediate collection. For Q1: $30 \times 28,000 \times 3 / 1,000,000 = 2.52$ million. For Q2: total loans become 320 (290+30), so collection includes both previous and new? Actually solution uses incremental: Q1: 24.36 + 2.52; Q2: 24.36 + 2.52 + ? Wait – they compute "10 + 24.36 + 2.42" etc. I'll reconstruct.

Important: The solution assumes collections from new loans are added in the quarter they are made, and continue each quarter (since loans exist for 60 months). So the total collection each quarter = $28,000 \times 3 / 1,000,000 \times \text{(total loans outstanding)}$.

Step‑by‑step cash budget (figures in million)

Let $C_t$ = cash inflow from loan collections in quarter $t$.

The worked values use the stated opening cash and collection assumptions. Some displayed figures differ by rounding, so apply the cash-budget method consistently to the inputs used.

General cash budget framework

Applying to Trinity Leasing (solution results)

We start with an opening cash balance of 10 (assumed minimum). Cash inflows from operations (excluding new deposits):

Note: Some displayed collection figures vary slightly because of rounding.

Cash outflows (excluding new deposits):

• Deposit repayments: Q1=60, Q2=40, Q3=80, Q4=60.
• Interest on deposits: calculated on outstanding at beginning of quarter at 12% p.a. → quarterly rate $3\%$ (12%/4).
  • Q1: on 300 → $300 \times 0.03 = 9$
  • Q2: after repaying 60, outstanding = 240 → $240 \times 0.03 = 7.2$
  • Q3: repay 40 → 200 outstanding → $200 \times 0.03 = 6$
  • Q4: repay 80 → 120 outstanding → $120 \times 0.03 = 3.6$
  • Q4: use the stated interest charge of 3.6. The timing convention for the Q4 balance is not specified.
• New loans disbursed: 30 per quarter.

Computing the required new deposit (balancing item):

The closing cash balance must be at least 10. So: $\text{New deposit} = \text{Total outflows} - \text{Operating inflows} - \text{Opening cash} + 10$

For each quarter, use the balancing formula above to maintain the minimum cash balance. The displayed deposit schedule is the worked result.

These deposits are added to the prior deposit balance, and repayments reduce it. The net deposit balance across the year starts at 300, rises to 374.64, then falls as repayments are made.

Exam tip: In cash budgeting for a finance company, the interest cost on deposits depends on the outstanding balance after previous repayments. New deposits also attract interest in subsequent quarters. The required deposit is a balancing figure that ensures a minimum cash balance.

Key takeaways

• Cash inflows: from loan collections (existing + new).
• Cash outflows: deposit repayments, interest on outstanding deposits, new loan disbursements.
• Required incremental deposit = (outflows – operating inflows + desired closing balance) – opening cash.
• Interest on deposits is paid quarterly on the outstanding amount; new deposits taken in a quarter will affect interest in later quarters.
• The solution uses an iterative approach: compute without new deposit interest, then update.

Exercise 6: Setting Standard Cost per Bag

Standard costing provides a benchmark (the “should be” cost) against which actual performance is measured. The standard cost per bag is built from materials, labour, variable overhead, and fixed overhead.

Material standards (per bag)

Labour standard

• Each group has 4 workers, each paid ₹600 per day (8‑hour shift → ₹75 per hour).
• The group produces 30 bags per day (allowing for slack time between bags).
• Standard labour cost per bag: $\frac{4 \times 600}{30} = \text{Rs. }80$.

Although the problem states “standard hours required for one bag is one hour”, the slack time effectively means 1.0667 hours per bag (32 group‑hours ÷ 30 bags). The labour cost of ₹80 is consistent with $1.0667 \text{ h} \times \text{Rs. }75/\text{h}$.

Overheads

Total standard cost per bag

$\text{Materials } 792 + \text{Labour } 80 + \text{Variable OH } 200 + \text{Fixed OH } 50 = \text{Rs. }1,\!122$

Key takeaways

• Standard cost is the budgeted cost per unit at normal efficiency.
• Material, labour, and overhead components are separately estimated.
• The ₹1,122 becomes the benchmark for variance analysis.

---

Exercise 7: Material Cost Variance

Material cost variance (MCV) measures the difference between actual material cost and the standard material cost for actual output. It splits into material rate variance (MRV) and material usage variance (MUV).

$$\begin{aligned} \text{MCV} &= \text{Actual Cost} - \text{Standard Cost for Actual Output} \\ \text{MRV} &= (\text{Actual Rate} - \text{Standard Rate}) \times \text{Actual Quantity} \\ \text{MUV} &= (\text{Actual Quantity} - \text{Standard Quantity Allowed}) \times \text{Standard Rate} \end{aligned}$$

Adverse variance (positive in cost formulas) means actual > standard; favourable means actual < standard.

Actual data (January 2016: 24 days, 69,000 units produced)

Standard quantities allowed for 69,000 units

Variances computation

Rate variances (Actual Rate – Standard Rate) × Actual Qty

Usage variances (Actual Qty – Std Qty Allowed) × Standard Rate

Total material cost variance = MRV + MUV = ₹8,97,400 A + ₹30,64,000 A = ₹39,61,400 A.

(Check: Actual total cost ₹5,86,09,400 – Standard cost ₹5,46,48,000 = ₹39,61,400 A.)

Variance decomposition

Exam tip: The usage variance dominates (77%). Management must investigate why material consumption exceeded allowance – e.g., waste, poor cutting, low‑quality input.

Key takeaways

• Material cost variance = (AQ × AR) – (SQ × SR) for actual output.
• Rate variance focuses on price paid; usage variance on quantity consumed.
• An adverse usage variance suggests inefficiency in material handling.

---

Exercise 8: Labour Cost Variance

Labour cost variance (LCV) = Actual labour cost – Standard labour cost for actual output. It splits into labour rate variance (LRV) and labour efficiency variance (LEV).

$$\begin{aligned} \text{LCV} &= \text{Actual Cost} - \text{Standard Cost} \\ \text{LRV} &= (\text{Actual Rate} - \text{Standard Rate}) \times \text{Actual Hours} \\ \text{LEV} &= (\text{Actual Hours} - \text{Standard Hours Allowed}) \times \text{Standard Rate} \end{aligned}$$

Standard labour data

• Standard hours per bag (with slack): $32 \text{ h} / 30 \text{ bags} = 1.0667 \text{ h}$
• Standard rate per hour: ₹75
• Standard labour cost for 69,000 units: $69,000 \times 1.0667 \times 75 = \text{Rs. }55,\!20,\!000$

Actual labour data (January 2016)

Variance calculations

Standard hours allowed = $69,000 \times 1.0667 = 73,600\ \text{h}$

Labour efficiency variance (LEV)

$$\begin{aligned} \text{LEV} &= (73,600 - 78,000) \times 75 \\ &= (-4,400) \times 75 \\ &= -₹3,30,000 \quad (\text{adverse}) \end{aligned}$$

Labour rate variance (LRV)

$$\begin{aligned} \text{LRV} &= (75 - 75.58) \times 78,000 \\ &= (-0.58) \times 78,000 \\ &= -₹45,000 \quad (\text{adverse}) \end{aligned}$$

Total labour cost variance = LEV + LRV = ₹3,30,000 A + ₹45,000 A = ₹3,75,000 A.

(Check: ₹58,95,000 actual – ₹55,20,000 standard = ₹3,75,000 A.)

Variance decomposition

The bulk of the labour variance is due to extra hours worked (overtime). This signals low productivity or rushed production to meet delivery.

Key takeaways

• Labour efficiency variance measures how many hours above/below standard were used.
• Labour rate variance captures any difference in wage rate (e.g., overtime premium).
• High efficiency % indicates the problem is time usage, not wage rate.

---

Overall Key Takeaways for Variance Analysis

• Standard cost provides the target; variances show where actuals deviate.
• Material and labour variances each decompose into price/rate and quantity/efficiency components.
• Use the framework to identify root causes: e.g., higher material usage → waste or poor quality; higher labour hours → low productivity or overtime.
• Always label variances as adverse (A) or favourable (F).

Exam tip: When asked to “analyse” a variance, always calculate the two sub‑variances and state which is the major contributor. Recommendations should follow the dominant cause.

Variable Overhead Variances

Variable overhead variances isolate the effect of differences in the spending rate (cost per hour) and the efficiency (hours used vs. hours allowed) on total variable overhead.

Given data (Asian Luggage, January 2016):

Variable Overhead Spending Variance

Measures how much of the total variance is due to paying a different rate per hour than the standard.

$\text{Spending variance} = (\text{Standard rate} - \text{Actual rate}) \times \text{Actual hours}$

Actual rate = ₹14,860,000 ÷ 78,000 hours = ₹190.51 Spending variance = (200 – 190.51) × 78,000 = ₹740,000 favorable (Actual rate lower than standard → favorable)

Variable Overhead Efficiency Variance

Measures how much of the total variance is due to using more or fewer hours than the standard allowed.

$\text{Efficiency variance} = (\text{Standard hours allowed} - \text{Actual hours}) \times \text{Standard rate}$

Efficiency variance = (73,600 – 78,000) × 200 = (–4,400) × 200 = ₹880,000 adverse (More hours used than allowed → adverse)

Total Variable Overhead Variance

$\text{Total} = \text{Spending} + \text{Efficiency} = 740,000\ (\text{F}) + 880,000\ (\text{A}) = \textbf{\text{Rs. }140,000 adverse}$

Exam tip: The spending variance is favorable only because the actual hourly rate dropped. The efficiency variance is consistently adverse, matching the pattern seen earlier in material and labor efficiency – a recurring operational problem.

Key takeaways – Variable overhead variances

• Spending variance = (SR – AR) × AH
• Efficiency variance = (SH allowed – AH) × SR
• A favorable spending variance does not compensate for an adverse efficiency variance; root causes (e.g., machine downtime, rework) must be investigated.

---

Fixed Overhead Variances

Fixed overhead variances separate the effect of spending more or less than budget from the volume effect (producing more or fewer units than planned).

Given data:

Fixed Overhead Spending Variance

$\text{Spending variance} = \text{Actual} - \text{Budget}$

= ₹4,000,000 – ₹3,840,000 = ₹160,000 adverse (Actual spending exceeded budget)

Fixed Overhead Volume Variance

$\text{Volume variance} = \text{Budget} - \text{Applied}$

= ₹3,840,000 – ₹3,900,000 = ₹60,000 favorable (Actual hours > budgeted hours → more overhead absorbed)

The volume variance is purely an accounting adjustment – it reconciles the applied overhead with the budget. It does not reflect a cash saving or loss, only the difference between actual activity and the denominator level.

Exam tip: Do not confuse the volume variance with a “real” variance; it arises because fixed overhead is applied based on actual hours, while the budget is based on estimated capacity. Use the formula: Volume variance = (Budgeted hours – Actual hours) × Standard fixed overhead rate.

Key takeaways – Fixed overhead variances

• Spending variance = actual – budget; indicates cost control.
• Volume variance = budget – applied; arises from producing more (or fewer) hours than planned.
• The volume variance is a “non-cash” accounting variance but must be reported in the variance chart.

---

Summary Variance Report (Exercise 10)

All variances from the earlier exercises are compiled into a single chart and analysed.

Variance Chart (figures in rupees)

The total variance can be expressed as the sum of the four main categories, or as: $\text{Total = Material + Labor + Variable overhead + Fixed overhead}$

Analysis and Management Report

• Material variance dominates – 86% of the total variance (₹3,961,400 out of ₹4,576,400).
• Within material, usage variance accounts for 67% of total – nearly ₹3,064,000.
• Labor efficiency, variable overhead efficiency, and material usage are all adverse, indicating a systemic efficiency problem.
• Priority action: Investigate material usage – possible causes include defective machinery, poor stitching, or excessive rework.
• Labor efficiency and variable overhead efficiency variances are also adverse, suggesting the same operational issues.
• Fixed overhead variances are relatively small (2.2% of total) but the spending variance should still be reviewed.

Exam tip: When writing an external report, focus on the largest variances (typically material usage) and note patterns across efficiency categories. The fixed overhead volume variance is often excluded from operational analysis because it does not reflect cost control.

Key takeaways – Summary report

• Material usage variance is the single largest contributor (≈67%) – control material to fix most of the total adverse variance.
• Efficiency variances are consistently adverse across materials, labor, and variable overhead – a root‑cause investigation is needed.
• Fixed overhead variances are minor and largely accounting‑driven.
• The variance chart (like a DuPont chart) helps visualise the breakdown and prioritise corrective action.

Sales Mix Variance Analysis

Sales mix variance measures the profit impact of selling a different combination of products than planned. Even if total unit sales meet budget, a shift away from high‑margin products toward low‑margin ones erodes profit. The analysis separates the total contribution margin difference into three actionable components: rate variance, mix variance, and volume variance.

ToothFresh – Case Data

ToothFresh manufactures three toothbrush models: Sensitive, Flexible, Standard. The budget vs. actual performance for the year is:

• Budgeted total contribution = ₹289 lakh
• Actual total contribution = ₹250 lakh
• Total adverse variance = ₹39 lakh

The budget and actual contribution margins differ per product. Budget mix: Sensitive 40%, Flexible 35%, Standard 25%. Actual mix: Sensitive ≈31.6%, Flexible ≈36.8%, Standard ≈31.6%.

The Three Variances – Template Approach

A four-column framework isolates the three drivers:

Column 1 – Actual Contribution

Actual Qty × Actual Mix × Actual CM = 190 lakh units × (actual mix percentages) × (actual CM per product) Result = ₹250 lakh (total)

Column 2 – Actual Sales at Actual Mix, Budget CM

Actual Qty × Actual Mix × Budget CM = 190 lakh × same mix but using budget CM (20,12,9) Result = computed per product (see below)

Column 3 – Actual Sales at Budget Mix, Budget CM

Actual Qty × Budget Mix × Budget CM = 190 lakh × (40%,35%,25%) × budget CM Result = computed per product

Column 4 – Budget Contribution

Budget Qty × Budget Mix × Budget CM = 200 lakh × (40%,35%,25%) × budget CM = ₹289 lakh

Computing the Variances for ToothFresh

Applying the template gives the following per-product variances (in lakh ₹):

Note: The most significant numbers are:

• Sensitive mix variance = ₹320 lakh adverse – the shift away from high‑margin Sensitive lost ₹320 lakh.
• Flexible rate variance = ₹140 lakh adverse – actual contribution per unit dropped from ₹12 to ₹10.
• Volume variance (total) = 144.5 lakh adverse – selling 10 lakh fewer units than budgeted.

Interpretation for Management

1. Volume decline contributed 37% of the total loss (144.5 ÷ 390 ≈37%).
2. Mix shift away from Sensitive caused the largest loss – the actual mix of Sensitive fell from 40% to 31.6%.
3. Rate drop on Flexible (₹2 per unit lost) added ₹140 lakh in losses.

Root‑cause questions:

• Why was Sensitive’s actual mix so low? Possible price increase (actual CM ₹21 vs budget ₹20) may have reduced demand.
• Why did Flexible’s contribution shrink? Cost increases or pricing pressure.
• Could lowering Sensitive’s price restore its mix and overall profitability?

Exam tip: The mix variance is often the most critical. A small shift away from high‑margin products can dwarf volume and rate variances. Always check actual vs. budget mix percentages first.

Key Takeaways

• Sales mix variance isolates the profit impact of selling a different product mix, independent of total volume and individual product margins.
• The three variances (rate, mix, volume) are additive: total variance = rate variance + mix variance + volume variance.
• A four‑column template (actual, actual-at-budget-CM, actual-at-budget-mix, budget) neatly decomposes the variance.
• For ToothFresh, the mix variance on Sensitive is the primary culprit (₹320 lakh adverse).
• Management uses this analysis to identify whether pricing, promotion, or competition caused the mix shift and to plan corrective actions.