Use Static and Flexed Budgets for Different Questions
A static budget records the original plan; a flexed budget adjusts the appropriate cost allowances to actual activity. Both are useful. If planned output is 10,000 units but actual output is 14,000, higher variable expenditure may reflect volume rather than inefficiency. At 6,000 units, a lower total cost does not necessarily demonstrate better performance. Reconcile the original plan to actual activity before investigating price, consumption and productivity.
This is a management-accounting guide, not a statutory prescription for universal tolerance limits. All seven cases are hypothetical illustrations. Their operational explanations are stipulated scenarios or investigation hypotheses, not documented findings about real businesses. Amounts exclude tax unless stated. Suggested controls require approval and implementation by the business; product functionality must be confirmed before relying on automated integrations or alerts.
Classify Costs Before Flexing Them
ICMAI CAS-1 addresses cost classification and CAS-3 addresses production and operation overheads. Directness and cost behaviour are different classifications: direct labour can be fixed or variable depending on contracts. Semi-variable costs contain fixed and variable elements; step-fixed costs change at capacity thresholds and are not synonymous with semi-variable costs. Validate the relevant range and driver for each line.
| Cost behaviour | Static plan | Flexed allowance | Review |
|---|---|---|---|
| Variable | Planned activity × standard rate | Actual activity × standard rate | Price and consumption; use the correct activity driver. |
| Mixed or semi-variable | Fixed base plus variable allowance at planned activity | Supported fixed base plus actual activity × standard variable rate | Separate tariff, consumption and base charges. |
| Fixed within the relevant range | Approved period expenditure | Normally the same period amount | Review expenditure separately from absorption and capacity. |
| Step-fixed | Capacity blocks expected in the plan | Supported blocks needed at actual activity | Do not force a smooth linear formula across thresholds. |
Standard-cost absorption variances are management measures. CAS-3's fixed-overhead assignment uses normal capacity; a monthly budget denominator is not automatically the appropriate financial-reporting inventory allocation basis. Keep statutory reporting and the management variance bridge reconciled.
Standard Costing Formulas and Sign Convention
For costs below, positive means favourable (F), negative means adverse (A). SQ and SH mean standard quantity and hours allowed for actual output; AQ is material consumed, SP/AP standard/actual price, SR the standard labour rate, HP hours paid and HW hours worked. Use consistent quantities, periods and units. If purchase-price variance is measured on purchases rather than consumption, separately reconcile inventory movements before combining it with usage.
- Material total: SQ × SP − AQ × AP. Price: AQ × (SP − AP). Usage: SP × (SQ − AQ). Total = price + usage.
- For multiple materials, mix = sum of SP × (actual total input redistributed in standard proportions − actual material quantity). Yield = standard cost per output unit × (actual output − standard output from actual total input). Usage = mix + yield: do not add usage again to its components.
- Labour total: SH × SR − actual payroll. Rate: HP × SR − payroll. With idle time shown separately, productive efficiency = SR × (SH − HW), and signed idle-time variance = −SR × (HP − HW). Their sum reconciles to total labour variance. A two-part efficiency calculation using HP already includes idle time.
- Variable overhead: expenditure = HW × standard variable-overhead rate − actual variable overhead; efficiency = rate × (SH − HW), where hours are the appropriate driver. Separate fixed demand charges.
- Fixed overhead: expenditure = budgeted fixed overhead − actual fixed overhead; volume = standard absorbed fixed overhead for actual output − budgeted fixed overhead. Volume normally splits into capacity and efficiency; where calendar is shown separately, remove it from capacity to avoid duplication.
- For a fixed product mix, sales price = actual units × (actual price − budget price). A contribution-based sales-volume variance uses standard contribution per unit. A revenue bridge uses selling prices instead: do not combine revenue and contribution measures in one reconciliation.
Define Tolerances Without Overlaps or Gaps
The following is an illustrative policy, not a CAS requirement or an established software default. Let P be the absolute cost deviation divided by the positive flexed budget, and R the absolute rupee deviation. Assign Red first, then Green, then Amber. Retain the favourable/adverse label separately.
| Band | Illustrative rule | Suggested response |
|---|---|---|
| Red | P > 8% OR R > ₹1,50,000 | Immediate finance review; assign an owner and target date. |
| Green | Not Red, AND (P ≤ 3% OR R < ₹25,000) | Routine monitoring, with qualitative exceptions. |
| Amber | Every remaining case | Written explanation, for example within 48 hours, and follow-up. |
This ordering resolves conflicts between a small rupee amount and a large percentage. Use full precision rather than leaving a gap between 3.0% and 3.1%. A zero or negative budget needs a separately defined rule; do not divide by it. Safety, fraud indicators, statutory compliance, quality failures and repeated small deviations can require escalation regardless of colour. A favourable cost result may also conceal deferred maintenance or poor quality.
Seven Worked Numerical Cases
Case 1: Manesar Auto Components—Steel Price and Scrap
Planned production is 20,000 brackets; actual production 24,000. Standard steel input is 6 kg per bracket at ₹66/kg, including 0.40 kg standard scrap. Actual purchases equal consumption: 1,56,000 kg at ₹72.50/kg.
- Static budget: 20,000 × 6 × ₹66 = ₹79,20,000.
- Standard quantity for actual output: 24,000 × 6 = 1,44,000 kg; flexed cost ₹95,04,000.
- Actual cost: 1,56,000 × ₹72.50 = ₹1,13,10,000.
- Price variance: 1,56,000 × (₹66 − ₹72.50) = ₹10,14,000 A.
- Usage variance: ₹66 × (1,44,000 − 1,56,000) = ₹7,92,000 A.
- Total: ₹18,06,000 A, or 19.00% of flexed cost after rounding. The static overspend of ₹33,90,000 includes ₹15,84,000 attributable to higher output at standard cost.
The price rose 9.85% from ₹66 to ₹72.50, approximately. A commodity escalation clause might support a ₹9,20,000 recovery in this illustration, but entitlement requires the actual contract and acceptance; it does not erase gross material variances. If the same 5.60 kg of useful metal remains in each bracket, standard scrap/input is 0.40/6 = 6.67%; at 6.50 kg input, scrap is 0.90/6.50 = 13.85%, not 11.54%.
Investigate die alignment, material quality and scrap records. If improved input becomes 5.95 kg at the same output and price, consumption falls to 1,42,800 kg and the reduction from actual consumption is 13,200 kg, worth ₹9,57,000. This is a conditional same-volume comparison, not a verified recurring saving of ₹7.5 lakh.
Case 2: Vapi Chemicals—Mix, Yield and Rounding
A standard batch uses A: 600 kg × ₹140 = ₹84,000; B: 300 kg × ₹220 = ₹66,000; C: 100 kg × ₹450 = ₹45,000. Total input is 1,000 kg costing ₹1,95,000, yielding 900 kg after 10% normal loss. Standard cost per output kg is the unrounded fraction ₹1,95,000/900, approximately ₹216.666667. A plant may handle 500-tonne campaigns, but this example's actual period output is 86,400 kg; the batch scale does not change its arithmetic.
Actual input totals 1,00,000 kg: A 65,000 kg at ₹138 = ₹89,70,000; B 27,000 kg at ₹225 = ₹60,75,000; C 8,000 kg at ₹460 = ₹36,80,000. Actual cost is ₹1,87,25,000. Standard cost for actual output is exactly ₹1,87,20,000; total variance is ₹5,000 A.
| Material | Mix variance | Price variance |
|---|---|---|
| A | ₹140 × (60,000 − 65,000) = ₹7,00,000 A | 65,000 × (₹140 − ₹138) = ₹1,30,000 F |
| B | ₹220 × (30,000 − 27,000) = ₹6,60,000 F | 27,000 × (₹220 − ₹225) = ₹1,35,000 A |
| C | ₹450 × (10,000 − 8,000) = ₹9,00,000 F | 8,000 × (₹450 − ₹460) = ₹80,000 A |
Net mix is ₹8,60,000 F. Standard output from actual input is 90,000 kg, compared with actual 86,400 kg: the 3,600 kg yield deficit, valued without premature rounding, is ₹7,80,000 A. Usage is therefore ₹80,000 F; net price is ₹85,000 A; total reconciles to ₹5,000 A. Actual yield is 86.4%. Using ₹216.67 too early creates the erroneous ₹1,87,20,288 allowance and ₹7,80,012 yield loss.
A cheaper mix may impair quality even when the usage result is favourable. If testing identifies 18% of output as at risk, that is 15,552 kg; establish whether it is saleable, reworkable or rejected before quantifying additional loss. Formula changes should require technical approval, and process logs should support any claimed connection to curing time or vessel residue.
Case 3: Delhi-NCR Restaurants—Pay Rate, Overtime and Idle Hours
A hypothetical chain has 22 outlets and 220 crew/supervisors. For 2,80,000 orders, the standard is 4.5 minutes, or 0.075 hours, per order at a modelled all-in cost of ₹110/hour. Standard hours are 21,000 and flexed payroll ₹23,10,000. The inclusive rate is an assumption, not a calculation of statutory PF, ESI or bonus obligations.
Actual paid time is 29,400 hours: 21,200 × ₹115 = ₹24,38,000 and 8,200 overtime hours × ₹230 = ₹18,86,000. Total payroll is ₹43,24,000; total variance ₹20,14,000 A, or 87.19%. The earlier 34%/₹24.8 lakh description does not match these inputs.
The exact blended rate is ₹43,24,000/29,400, approximately ₹147.07483/hour; use the unrounded value. Rate variance is ₹10,90,000 A, comprising ₹1,47,000 from the ₹5 base-rate increase over all 29,400 paid hours and ₹9,43,000 from the additional ₹115 premium on 8,200 overtime hours. Overtime is not the only cause.
If 4,800 paid hours were idle, worked time is 24,600 hours. Productive efficiency is ₹110 × (21,000 − 24,600) = ₹3,96,000 A; idle time is ₹5,28,000 A. Together they equal the two-part efficiency result ₹9,24,000 A. Paid time per order is 6.3 minutes; productive time is approximately 5.27 minutes. Do not add idle time again to an efficiency variance already based on paid hours.
Compare rosters, POS demand, attendance and overtime approvals before attributing blame. Treat proposed ₹16 lakh monthly recovery as a target requiring a later like-for-like reconciliation, not a proven saving.
Case 4: Greater Noida Manufacturing—Calendar, Capacity and Efficiency
Budgeted fixed overhead is ₹48,00,000, over 25 days and 200 operating hours, for 10,000 units. Standard time is 0.02 hours per unit. Rates are ₹480/unit, ₹24,000/hour and ₹1,92,000/day; hours per planned day are 8. Actual operations cover 20 days, 152 hours and 7,200 units; actual fixed cost is ₹49,20,000.
- Expenditure: ₹48,00,000 − ₹49,20,000 = ₹1,20,000 A.
- Volume: ₹480 × (7,200 − 10,000) = ₹13,44,000 A.
- Calendar: ₹1,92,000 × (20 − 25) = ₹9,60,000 A.
- Capacity after removing calendar: ₹24,000 × (152 − 20 × 8) = ₹1,92,000 A.
- Efficiency: standard output hours are 7,200 × 0.02 = 144; ₹24,000 × (144 − 152) = ₹1,92,000 A.
The three volume components total ₹13,44,000 A; adding expenditure gives ₹14,64,000 total under-absorption. Calendar represents 71.43% of volume variance and the other two components total ₹3,84,000. These are absorption effects, not necessarily incremental cash losses. Flooding, feeder maintenance, changeover delays and power backup require operational evidence; the calendar split alone does not prove controllability. A later 102% efficiency result would mean standard hours earned/worked hours = 1.02, and needs that month's records.
Case 5: SaaS Sales—Quantity, Mix, Discounting and ARR
Use rupees consistently; the dollar tier labels are not currency equivalents without an exchange-rate assumption. This illustration measures the full-month recurring run rate of a new-account cohort at quarter end, not recognised quarterly revenue or cash collections. Annualise by twelve, assuming unchanged contracts and no churn.
| Tier | Budget accounts × monthly price | Actual accounts × monthly price |
|---|---|---|
| Starter | 50 × ₹50,000 = ₹25,00,000 | 90 × ₹42,000 = ₹37,80,000 |
| Professional | 50 × ₹1,50,000 = ₹75,00,000 | 40 × ₹1,30,000 = ₹52,00,000 |
| Enterprise | 25 × ₹4,00,000 = ₹1,00,00,000 | 10 × ₹3,40,000 = ₹34,00,000 |
Budget totals 125 accounts and ₹2,00,00,000 monthly; actual totals 140 accounts and ₹1,23,80,000 monthly. Count attainment is 112%; budget average monthly price ₹1,60,000; actual average approximately ₹88,428.57. Actual quantity at each tier's budget price totals ₹1,45,00,000, an average of ₹1,03,571.43 across 140 accounts.
- Price: Starter ₹7,20,000 A, Professional ₹8,00,000 A, Enterprise ₹6,00,000 A; total ₹21,20,000 A.
- Pure quantity at budget mix: ₹1,60,000 × (140 − 125) = ₹24,00,000 F.
- Mix: ₹1,45,00,000 − (140 × ₹1,60,000) = ₹79,00,000 A.
- Bridge: +₹24,00,000 − ₹79,00,000 − ₹21,20,000 = ₹76,20,000 monthly shortfall.
Budget annualised run rate is ₹24 crore; actual ₹14.856 crore; deficit ₹9.144 crore. Three months at the full run-rate difference would be ₹2.286 crore, not annualised ARR. Neither ₹1.15 crore nor the earlier ₹74 lakh mix loss reconciles to the supplied figures. Recognised revenue and cash depend on start dates, service delivery and collection terms.
Review discount authority, tier mix, gross margin and retention. A suggested commission policy requiring CFO approval for discounts above 10% is a company choice, not an asserted assurePractice feature or evidence that all discounts were unauthorised.
Case 6: Logistics—Fuel Price and Consumption
An 80-truck fleet plans 8,00,000 km at 4 km/litre and ₹88/litre: standard cost is ₹22/km and budget fuel cost ₹1,76,00,000. Actual distance is 8,40,000 km. Assume purchases equal consumption with no tank-stock movement: 2,33,333 litres at ₹93.50/litre.
- Actual cost: ₹2,18,16,635.50; flexed allowance: 8,40,000 × ₹22 = ₹1,84,80,000.
- Total cost variance: ₹33,36,635.50 A, approximately 18.06%.
- Price: 2,33,333 × (₹88 − ₹93.50) = ₹12,83,331.50 A.
- Standard consumption is 2,10,000 litres; usage: ₹88 × (2,10,000 − 2,33,333) = ₹20,53,304 A.
The components reconcile exactly before rounding. Actual efficiency is approximately 3.600005 km/litre. Reconcile vehicle distance, receipts and tank balances before investigating alleged pilferage. A hypothetical finding of 14,000 idle-consumption litres and 18 vehicles with injector problems needs evidence; a fuel-price variance does not itself prove a VAT-rate change.
If servicing and route controls improve efficiency to 4.08 km/litre at the same 8,40,000 km and ₹93.50 price, required fuel is approximately 2,05,882.35 litres and cost ₹1,92,50,000. The reduction against actual cost is ₹25,66,635.50, not a demonstrated ₹22 lakh recurring saving. A 4.1 km/litre driver target is a separate proposed benchmark.
Case 7: Hyderabad Contract Laboratory—Outsourcing and Maintenance
Budget subcontracting is ₹12,00,000; actual ledger cost ₹34,50,000: ₹22,50,000 A, or 187.5%. If 85 batches are outsourced at ₹40,000 per batch, they account for ₹34,00,000; reconcile the remaining ₹50,000 separately. Do not alternate “batch” and “sample” as the billing unit.
A hypothetical investigation finds two instruments unavailable for 18 days, one with a vacuum-pump failure and another with a failed required qualification check. The exact calibration and qualification obligations depend on the applicable laboratory quality framework; no universal annual US-FDA rule is asserted. An AMC costing ₹8,00,000 lapsed in August while a ₹75,000 discount was discussed; the potential discount is 9.375% of the AMC. Investigate the suggested three-month procurement delay against records rather than inferring causation from these totals.
The ₹22,50,000 is the ledger excess over budget, not automatically the full incremental consequence of downtime: establish what normal work would have been outsourced and the costs avoided internally. Classify critical maintenance contracts for priority approval, set proposed alerts 60 days before expiry and review backup testing capacity. Repairing equipment may reduce emergency outsourcing; it does not establish that all external testing cost disappears in December.
Investigation and Responsibility Matrix
| Variance | Evidence and joint review | Interpretation |
|---|---|---|
| Material price | Procurement, supplier invoices, freight and market benchmarks | Separate market movement, negotiation and specification changes. |
| Material usage/mix/yield | Production, engineering, quality, BOM and scrap records | Check rework and quality before calling cheaper inputs a saving. |
| Labour rate/efficiency/idle time | HR and operations: payroll, paid hours, productive hours and rosters | Avoid double-counting idle time or blaming workers for unavailable inputs. |
| Overheads | Finance and operations: tariff, capacity, utilisation and calendar evidence | Separate spending from absorption effects and cash consequences. |
| Sales price/mix/quantity | Sales and finance: contracts, tier counts, discounts and contribution | Do not confuse account count, run rate, recognised revenue and receipts. |
Six Practical FAQs
1. How should standards respond to volatile commodity prices?
Retain the original budget and add approved revised standards when justified. A quarterly refresh or a trailing 60-day average is an optional policy requiring a suitable benchmark, not a universal rule. Keep engineering usage standards under technical change control. Separate original-to-revised planning effects from revised-to-actual operational effects without rewriting performance history.
2. Should static utility comparisons always be discarded?
No: they still show departure from the original expenditure plan. Add a flexed comparison using appropriate machine hours, output or other drivers. Power costs can change through tariffs, demand charges, consumption, penalties or mix; an adverse variance is not restricted to kWh per operating hour. A 30% output increase does not mechanically imply the same increase in every utility component.
3. What if price is favourable but usage adverse?
Add the signed components and investigate quality, yield, rework, suppliers and planning assumptions jointly. A hypothetical 10% purchase discount is not proof of inferior inputs or procurement fault. Escalate any unsupported specification change regardless of the apparent net saving.
4. How do planning and operational variances reconcile?
For a cost comparison using the favourable-positive convention: total = original allowance − actual cost = (original allowance − revised allowance) + (revised allowance − actual cost). Use the same output and valuation basis, document what was revised, and assess controllability on evidence. Planning errors may themselves need management accountability.
5. When should a CAPA be required?
Approve a business-specific policy. For example, a Red case can require a cross-functional review within five business days, a named corrective-action owner and a 30-day progress check. Repetition over two months can trigger higher review. These are proposed internal controls, not statutory deadlines or mandatory Board Audit Committee rules for every business.
6. Can Tally or another system supply the data?
Accounting and inventory exports may support automation, subject to the installed product, version, licences, data quality and configured integrations. Validate production drivers, mapping, cut-off, reconciliation and access controls. Test any desired daily extraction, email or WhatsApp alert before relying on it. This guide does not assert that Tally lacks all budgeting features or that a particular assureOffice product currently provides every integration described.