Standard Costing Variance Decomposition & SPC Analyzer

A variance report only tells you something moved. Statistical process control tells you whether that move was ever likely to happen by chance in the first place.

How To Use This Model

Reading This Tool

Enter standard and actual price, quantity, rate and hours for materials and labour, and this period's actual output.

The tool splits the total variance into the four classic components, flexed to actual output, then layers on a statistical process control chart so you can tell a genuine special-cause cost shift apart from ordinary period-to-period noise.

Materials

Standard Price ($/kg) $4.00

Actual Price ($/kg) $4.30

Standard Quantity (kg/unit) 2.00

Actual Quantity Used (kg/unit) 2.15

Labour

Standard Rate ($/hr) $28.00

Actual Rate ($/hr) $29.50

Standard Hours (hr/unit) 0.50

Actual Hours (hr/unit) 0.46

Actual Output This Period (Units) 10,000

Control Chart

Process Std. Dev. (Unit Cost, $) $0.35

Inject Special-Cause Shift At Period 8?

No Yes

Variance Decomposition

Total Cost Variance

Material Price Variance

Material Quantity Variance

Labour Rate Variance

Labour Efficiency Variance

Variance Bridge: Standard Cost To Actual Cost

Cost Accounting & Statistical Process Control

The Core Formulas

Material Price Variance = (Actual Price − Standard Price) × Actual Quantity Used
Material Quantity Variance = (Actual Qty − Standard Qty Allowed) × Standard Price
Labour Rate Variance = (Actual Rate − Standard Rate) × Actual Hours
Labour Efficiency Variance = (Actual Hours − Standard Hours Allowed) × Standard Rate
UCL / LCL = Center Line ± 3σ

"Standard Quantity/Hours Allowed" always flexes the standard to the actual output level achieved, comparing actual cost at actual volume against a static budget volume would confuse a volume variance with a genuine efficiency variance.

When To Actually Use This Model

Teaching the four-variance model in a cost or managerial accounting course, and pairing it with control charts to show when a variance is a real signal versus noise.
Investigating a monthly cost variance report before assigning it to a department, distinguishing a one-off cause from a systematic process shift.
Deciding whether a standard itself needs updating, a persistent, repeated variance in the same direction usually means the standard is stale, not that operations are underperforming.

Key Assumptions & Limitations

This control chart uses individual observations (an I-chart), appropriate for one cost figure per period, a true X-bar chart would require multiple samples within each period.
Real control charts also apply run-rule tests (e.g., eight consecutive points on one side of the center line) beyond the simple 3-sigma limit shown here.
Standard costing variance analysis assumes standards were set reasonably in the first place, a badly set standard will generate variances every period regardless of how well the process is actually running.

Foundational Reference

Horngren, C. T., Datar, S. M., & Rajan, M. V. Cost Accounting: A Managerial Emphasis. Pearson. Montgomery, D. C. Introduction to Statistical Quality Control. Wiley.

Comparing this against a budget-to-actual bridge too?

Open The Budget Variance Waterfall →