WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Variable Costing Formula

Variable Costing Formula

What is Variable Costing Formula?

The variable Cost formula is quite straightforward and is calculated by dividing the total variable cost of production by the number of the units produced. The variable cost of production primarily includes direct labor cost, direct raw material cost, and variable manufacturing overhead, which is easily available from the income statement.

Mathematically, it is represented as,

Variable Costing = (Direct Labour Cost + Direct Raw Material Cost + Variable Manufacturing Overhead)/Number of Units Produced 

Variable-Costing-Formula

Conversely, this can also be represented as a summation of direct labor cost per unit, direct raw material cost per unit, and variable manufacturing overhead per unit. Mathematically, it is represented as,

variable costing formula2

Explanation of the Variable Costing Formula

The variable costing formula can be calculated in the following five steps:

  • Step 1: Firstly, direct labor cost directly attributes to production. The direct labor cost is derived according to the rate, level of expertise of the labor, and the number of hours employed for the production. Nevertheless, the cost can be extracted from the income statement.
  • Step 2: Secondly, one has to identify the type of material required and then the amount of material to be used in the production of each unit to determine the unit price of those materials. However, the direct raw material cost can also be extracted from the income statement.
  • Step 3: Thirdly, identify the other remaining variable part of the manufacturing overheads from the income statement.
  • Step 4: Now, determine the most crucial part of the formula, which is the number of units that have been produced from the production details annexed with the annual report.
  • Step 5: Finally, add up direct labor cost, direct raw material cost, and variable manufacturing overhead and then divide the sum with the number of units produced.

Examples of Variable Costing Formula

Let’s take a few simples to advanced examples to understand Variable Costing Formula

You can download this Variable Costing Formula Excel Template here – Variable Costing Formula Excel Template

Example #1

Let us assume that XYZ Limited is a company that manufactures clothes for people of the elite class living in the modern city. The managerial accountant provides the following data, which has been vetted by the financial director of the company that:

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
  • Raw material per unit of cloth = $10
  • Labor cost per unit of cloth = $6
  • Fixed cost in total for the period = $500,000 (redundant)
  • Salary for Sales team for the period = $250,000 (redundant)
  • Other direct costs (variable overhead) per unit of cloth = $4

Therefore, Variable costing formula= Raw material per unit of cloth + Labour cost per unit of cloth + Other direct costs (variable overhead) per unit of cloth

  • Variable costing = $10 + $6 + $4
  • = $20 per unit of cloth

Example #2

Let us assume ABC Limited is a manufacturer of mobile phone covers. The company currently has received an order for 1,000,000 mobile covers at a total contract price of $350,000. However, the company is not sure whether the order is a profitable proposition. The following are the excerpts from the entity’s income statement for the calendar year ending in December 2017:

  • Raw material = $300,000
  • Labour cost = $150,000
  • Machinery = $100,000
  • Insurance = $50,000
  • Equipment = $100,000
  • Utilities (fixed overhead) = $40,000
  • Utilities (variable overhead) = $150,000
  • Number of mobile covers produced = 2,000,000

Now, based on the above information calculation of variable costing will be,

  • Variable costing formula= (Raw material + Labour cost + Utilities (variable overhead)) ÷ Number of mobile covers produced
  • = ($300,000 + $150,000 + $150,000) ÷ 2,000,000
  • = $0.30 per mobile case
  • As per the contract pricing, the per unit price = $350,000 / 1,000,000 = $0.35 per mobile case

Therefore, the variable costing is lower than the pricing offered in the contract, which means that the order should be accepted.

Variable Costing Formula Calculator

You can use the following Calculator

Direct Labour Cost
Direct Raw Material Cost
Variable Manufacturing Overhead
Number of Units Produced
Variable Costing Formula =
 

Variable Costing Formula =
Direct Labour Cost + Direct Raw Material Cost + Variable Manufacturing Overhead
Number of Units Produced
0+0+0
= 0
0

 

Relevance and Use of Variable Costing Formula

It helps a company in the determination of the contribution margin of a product, which eventually aids the break-even analysis that can be conducted to fix the number of units needed to be sold to book a profit.

Further, the application of variable costing in the production and sales of additional units can add to a company’s bottom line in terms of profit because the units would not cost the company any additional fixed cost to produce. Variable costing excludes fixed or absorption costs, and hence profit is most likely to increase owing to the money made through the sale of the additional items.

Variable Costing Calculation (with excel template)

Let us assume that PQR is a chocolate factory and has the costs, sales, and production information as per the below template.

In the below-given template is the data of the chocolate factory.

variable costing formula excel1.1

By using the above-given data, we will first calculate the total variable cost.

variable costing formula excel1.2

So the calculation of total variable cost will be-

variable costing formula excel1.3

In the below given excel template, we have used the calculation to find the chocolate factory’s Variable Costing.

variable costing formula excel1.4

So the Calculation will be:-

variable costing formula excel1.5

Recommended Articles:

This article has been a guide to Variable Costing Formula. Here we discuss its uses along with simple to advanced practical examples to understand Variable Costing Formula. Here we also provide you with the calculator along with a downloadable excel template. You can learn more about Financial Analysis from the following articles –

  • Formula for Cost of Goods Sold
  • Unit Contribution Margin Formula
  • Opportunity Cost Calculation
6 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
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

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 Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

WallStreetMojo

Download Variable Costing Formula Excel Template

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