What is the Variance Analysis Formula?

Variance analysisVariance AnalysisVariance analysis is the process of identifying and analyzing the difference between the standard numbers that a company expects to accomplish and the actual numbers that they achieve, in order to help the firm analyze positive or negative consequences.read more refers to the investigation, due to deviations, in the financial performance from the standards set by the company in the budget. It helps the company’s management to keep an eye on and a control check on its operational performance.

Variance Analysis can apply to many variables, but they are generally and broadly categorized into the following different types:

  • Material VarianceVariable Overhead VarianceLabor VarianceSales VarianceFixed Overhead Variance

Below are some of the Variance Analysis formulae that one can apply:

  • Material Cost Variance Formula = Standard Cost – Actual Cost = (SQ * SP) – (AQ * AP)Labor Variance Formula= Standard Wages – Actual Wages = (SH * SP) – (AH * AP)Variable Overhead Variance Formula = Standard Variable Overhead – Actual Variable Overhead = (SR – AR) * AO.Fixed Overhead Variance Formula = (AO * SR) – Actual Fixed Overhead.Sales Variance Formula = (BQ * BP) – (AQ * AP)

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Variance Analysis Formula (wallstreetmojo.com)

NOTES:

Where,

  • SQ = Standard Quantity for actual output,SP = Standard PriceAQ = Actual QuantityAP = Actual PriceSH = Standard HoursAH = Actual HoursSR = Standard RateAR = Actual RateAO = Actual OutputBQ = Budgeted QuantityBP = Budgeted Price

Explanation of the Variance Analysis Formula

There are various aspects of the variance analysis formula, as mentioned above. The difference between the direct material’s standard costStandard CostStandard cost is an estimated cost determined by the company for the production of the goods and services or for performing an operation under normal circumstances and are derived by the company from the historical analysis of the data or from the time and the motion studies.read more and the direct material’s actual cost that the firm uses for its production can be termed Material Variance (Cost Variance). The first term in every formula is associated with a set standard, and the second term in every formula state actually. The difference gives us whether that Variance is favorable or adverse. When the result is positive, that is favorable, versus the result that comes in negative is adverse.

Examples of Variance Analysis Formula (with Excel Template)

Let’s see some simple to advanced examples of Variance Analysis Formula to understand it better.

Example # 1

Below is the summary extracted from ABC Ltd., which manufactures steel. You are required to do material and labor variance analysis.

Below is given data for the calculation of variance analysis.

Calculation of Standard Quantity for AO

Calculation of Standard Hours for AO

Calculation of Material Cost Variance

Material Cost Variance Formula = Standard Cost – Actual Cost

= (SQ * SP) – (AQ * AP)

= (32011) – (3009)

Material Cost Variance will be –

=2080 (Favorable)

Calculation of Labor Variance

Labor Variance formula  = Standard wages – Actual Wages

= (SH * SP) – (AH * AP)

= (2409) – (3508)

Labor Variance will be –

=640 (Adverse)

Example # 2

Prashant industries, a well-renowned company in the manufacturing of copper cables, is worried about its actual performance due to an increment of overhead expenses and has provided you the below data and asked you to conduct overhead analysis for both fixed and variable.

Calculation of Variable Overhead Variance

Variable Overhead Variance = Standard Variable Overhead – Actual Variable Overhead                                                                                                          =  (SR – AR) * AO

= (25 – 27) * 80

Variable Overhead Variance will be –

=160 (Adverse)

Calculation of Fixed Overhead Variance

Fixed Overhead Variance  =  (AO * SR) – Actual Fixed Overhead

=(80 * 25) – 2500

Fixed Overhead Variance will be –

=500 (Adverse)

Example # 3

Silver ltd has been trying to analyze its issue related to performance as it is not able to analyze why it shortfall with meeting its street estimate profits, and upon initial investigation, it found out that its operating profit is fluctuating year on year. Hence, the driver for the same was gross profit, and hence it decided to review its production-related issues, if any. You are required to conduct all the variance analysis and advise the management of Silver ltd where the issue lies.

Calculation of Standard Hours for AO

Calculation of Material Cost Variance

Material Cost Variance Formula =Standard Cost – Actual Cost

=(SQ * SP) – (AQ * AP)

=(10803.55) – (27004)

=6966 (Adverse)

Calculation of Labor Variance Formula

=(129602) – (110001.5)

= 9420 (Favorable)

Variable Overhead Variance = Standard Variable Overhead – Actual Variable Overhead                                                                                                           = (SR – AR) * AO

=(2 – 1.5) * 2700

=1350 (Favorable)

Fixed Overhead Variance = (AO * SR) – Actual Fixed Overhead

=(2700 * 2) – 7000

=1600 (Adverse)

Calculation of Sales Variance

Sales Variance = (BQ * BP) – (AQ * AP)

=(25005.6) – (27005.5)

Sales Variance will be –

=850 (Adverse)

Relevance and Uses

This has been a guide to Variance Analysis Formula. Here we discuss how to calculate the top 5 variances using its formulas along with examples & excel templates. You can learn more about financing from the following articles –

  • Calculate Population VarianceCalculate Population VariancePopulation variance can be calculated using this formula: σ2 = ∑ni=1 (xi – μ)2 / N, where, σ2 is population variance, x1, x2, x3,…..xn are the observations, N is the number of observations and µ is the mean of the data set.read moreFormula of Vertical Analysis Calculate Portfolio VarianceCalculate Portfolio VariancePortfolio variance is a statistical value of modern investment theory that measures the dispersion of average returns of a portfolio from its mean. In short, it determines the total risk of the portfolio. Portfolio variance = w12 * ơ12+w22 * ơ22+2 * ρ1,2 * w1 * w2 * ơ1 * ơ2read moreVariance vs. Standard DeviationVariance Vs. Standard DeviationVariance is a numeric value that defines every observation’s variability from the arithmetic mean, while Standard Deviation is a measure to determine how spread out the observations are from the arithmetic mean. read moreJob Costing vs Process CostingJob Costing Vs Process CostingIn case of the Job Costing, costs of the customized or the special contract is calculated where the work is done according to the instructions of the specific client of the company, whereas, in case of the Process costing, the cost charged to a different process of the company is determined.read more