WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Accounting Tutorials » Income Statement Tutorials » Variance Analysis

Variance Analysis

What is the Variance Analysis?

Variance analysis refers to the identification and examination of the difference between the standards numbers expected by the business to achieve and the actual numbers achieved by them which helps the business to analyze favorable or unfavorable outcomes in terms of cost incurred while production and sale of the products of the business or quantity manufactured or sold by them etc.

In simple words, it is the study of deviation of the actual outcome against the forecasted behavior in finance. This is essentially concerned with how the difference between actual and planned behavior indicates and how business performance is being impacted.

Businesses can often improve their results if they will first plan their standards for their performance, but sometimes, their actual result doesn’t match their expected standard results. When the actual result comes in, Management can focus on variances from the standards to find areas needing improvement.

For Example, let’s assume that Taj Hotel pays housekeeping crew $5 per hour. Did the Housekeeping crew take longer to clean the room then that management planned? This results in a direct Labour Variance efficiency.

Explanation

 

Variance Analysis1

Suppose a company set a target to make a profit of an amount of $100 million by selling good worth $200 million and the total production cost is $100 million.

But at the end of the year, the company observed that the profit is $50 million instead of $100 million, which is not a good fit for an organization, so the company has to think about the reason for not achieving the target set by the company. There are certain factors that affect the profit of the company by analyzing the facts they came to know that the production cost changes from $100 million to $120 million. Production cost changes due to the following factors

  1. Change in Material cost.
  2. Change in Labour Cost
  3. And, Change in Overhead Cost

So the difference from the Actual output to the Standard output is called as variance

Types of Variance

Variance Analysis2

 

  • Controllable variance can be controlled by taking necessary action.
  • Uncontrollable Variance (UV) is beyond the control of the Departmental head.
  • If UV is standard in nature and persistent, the standard may require revision
  • It is very important to know the cause of variance analysis so that one can approach for corrective measure

Top 4 Types of Variance analysis in Budgeting

Given below are the Top 4 types of Variance Analysis

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

#1 – Material Variance

  • If you pay too much then the purchasing cost increases
  • If you use too many materials then the production cost increase

Both purchasing and production costs are dependent on each other, so we have to look into not only the purchasing cost but also the Production Cost to know the total variance as well.

Example of Material Variance

Given below is the example of material variance

Material Variance example1

Cost Variance

cost variance example1

A: (Standard Quantity: 800 Kg)* (Standard Price: Rs.6/-) – (Actual Quantity: 750kg)*(Actual Price: Rs.7/-)

B: (Standard Quantity: 400 Kg)* (Standard Price: Rs.4/-)– (Actual Quantity: 750kg)*(Actual Price: Rs.5/-)

The Impact of the variance of Cost of Material is due to Price and Quantity.

Impact of Price on Material Variance Analysis

The Variation of Price for Type A is (Rs.7/- minus Rs.6/-) for 750 Kg

  • Impact of Price on Material A : ( Rs.1/-)*(750Kg) = Rs.750 (A)

The Variation of Price for Type B is (Rs.5/- minus Rs.4/-) for 750 Kg

  • Impact of Price on Material B : ( Rs.1/-)*(500Kg) = Rs.500(A)

Total impact of Price = Rs.750 (A) + Rs.500 (A)= Rs.1250 (A)

  • *F stands for Favourable
  • *A stands for Adverse.
Impact of Quantity on Material Variance analysis

Variation of Quantity Used in Type A material is (800 Kg- 750Kg)*6

  • Price due to change in Quantity or Type A is: 300(F)

Variation of Quantity Used in Type B material is (400 Kg- 500Kg)*4

  • Price due to change in Quantity or Type A is: 400(A)

Impact of Quantity on Cost Variance is 300(F)-400(A) = 100(A)

Quantity further can be analyzed into two categories i.e., Yield and Mix. Yield occurs due to the use of inferior material or excess material. In comparison, Mix is due to using a combination of two materials in a different proportion during the production process.

#2 – Labour Variance

Labour Variance occurs when the actual cost of labor differs from the projected labor Cost

  • If you paid too much, that would be personal
  • If you use too many hours which is called efficiency of the Labour that will affects the production

Example of Labour Variance

Standard (4 pieces production for 1 Hour)

  • Skilled: 2workers@20/
  • Semiskilled: 4 workers@ 12/-
  • Unskilled: 4 Workers@ 8/-

Actual Output

  • Skilled: 2workers@20/
  • Semiskilled: 3 workers@ 14/-
  • Unskilled: 5 Workers@ 10/-
  • 200 Hours Work
  • 12 Hours Idle time
  • 810 Pieces Production

Labour Variance example1

  • Actual Time for Skilled Worker: 200*2(No .of Employee) = 400 Hours
  • Actual Time Work for Skilled Worker: (200 Hrs- 12(Idle Time)*2(No of Employee) = 376 Hours

Standard Time for Skilled Worker

  • To produce 4 Pieces (Standard time) a skilled worker needed 2 Hours so to produce 810 pieces standard time required
  • 4/2 *(810)= 405 Hours
Direct Labour Cost Variance
  • (Standard time* Standard Rate)- (Actual Time*Actual Rate)

example1

Direct Labour Rate Variance Analysis
  • (Standard Rate- Actual Rate)*Actual Time

example1

Direct Labour Efficiency Variance
  • Standard Rate*(Standard Time – Actual Time)

example1

Reasons for Labour Variance
  • Time-Related Issues.
  • Change in design and quality standard.
  • Low Motivation.
  • Poor working conditions.
  • Improper scheduling/placement of labor;
  • Inadequate Training.
  • Rate Related Issues.
  • Increments / high labor wages.
  • Overtime.
  • Labour shortage leading to higher rates.
  • Union agreement.

#3 – Variable Overheads (OH) Variance

Variable overheads include costs such as

  • Patents that have to be paid on units produced
  • Power Cost per unit produced

The total overhead variance is the difference between

  • The actual Variable Overhead incurred for the actual output of the business
  • The standard variable overhead we should have incurred for the actual output
  • Variable OH Variance=(SH*SR)-(AH*AR)

Example of Variable Overheads Variance

example1

Variance example2

Reasons for Overheads Variance
  • Under or over absorption of fixed overheads;
  • Fall in demand/ improper planning.
  • Breakdowns /Power Failure.
  • Labour issues.
  • Inflation.
  • Lack of planning.
  • Lack of cost control

#4 – Sales Variances

  • Sales Value Variance = Budgeted Sales – Actual Sales

Further Sales Variance is due to either change in sales price or Change in Sales Volume

  • Sales Price Variance = Actual Quantity (Actual Price – Budgeted Price)
  • Sales Volume Variance = Budgeted Price (Actual Quantity – Budgeted Quantity)

Reasons for Sales Variance

  • Change in Price.
  • Change in Market Size.
  • Inflation
  • Change in Market Share
  • Change in Customer Behaviour

Thus Variance analysis helps to minimize the Risk by comparing the actual performance to Standards.

Recommended Articles

This has been a guide to What is Variance Analysis. Here we look at the calculation and examples of the top 4 types of variance analysis, including material variance, sales variance, labor variance, and variable overheads. You may also take a look at the following articles:-

  • Variance Analysis Formula
  • What is Sunk Cost?
  • Indirect Costs Meaning
  • Depreciation on Furniture
15 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

* Please provide your correct email id. Login details for this Free course will be emailed to you

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More