EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Operating Ratio Formula
 

Operating Ratio Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 26, 2023

Operating Ratio Formula

 

 

Operating Ratio Formula (Table of Contents)
  • Formula
  • Examples
  • Calculator

What is the Operating Ratio Formula?

The term “operating ratio” refers to the efficiency ratio that assesses how well a company can manage the different operating expenses while conducting the business in a normal economic set-up. The ratio is also known as an expenses-to-sales ratio.

The formula for an operating ratio can be derived by dividing the sum of the cost of goods sold (a.k.a. cost of sales) of the company and it’s operating expenses by its total revenue. Mathematically, it is represented as,

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Operating Ratio = (Cost of Goods Sold + Operating Expenses) / Total Revenue

Examples of Operating Ratio Formula (With Excel Template)

Let’s take an example to understand the calculation of Operating Ratio Formula in a better manner.

You can download this Operating Ratio Formula Excel Template here – Operating Ratio Formula Excel Template

Operating Ratio Formula – Example #1

Let us take the example of a company named ADG Ltd which is engaged in the business of manufacturing electronic parts for Tier I auto parts supplier. During 2018, the company clocked a total revenue of $450 million. The cost incurred includes the raw material cost of $200 million, the direct labor cost of $120 million, the manufacturing overhead cost of $50 million, the selling expense of $30 million and the administrative expense of $10 million. Calculate the operating ratio of ADG Ltd based on the given information.

Example of a Company named ADG Ltd -1.1

Solution:

Cost of Goods Sold is calculated using the formula given below

Cost of Goods Sold = Raw Material Cost + Direct Labor Cost + Manufacturing Overhead Cost

Calculation Cost of Goods Sold -1.2

  • Cost of Goods Sold = $200 million + $120 million + $50 million
  • Cost of Goods Sold = $370 million

Operating Expense is calculated using the formula given below

Operating Expense = Selling Expense + Administration Expense

Calculation of Operating Expense -1.3

  • Operating Expense = $30 million + $10 million
  • Operating Expense = $40 million

Operating Ratio is calculated using the formula given below

Operating Ratio = (Cost of Goods Sold + Operating Expenses) / Total Revenue

Operating Ratio Formula -1.4

  • Operating Ratio = ($370 million + $40 million) / $450 million
  • Operating Ratio = 91.11%

Therefore, the operating ratio of ADG Ltd for the year 2018 stood at 91.11%.

Operating Ratio Formula – Example #2

Let us take the example of Samsung Electronics Co. Ltd. and calculate its operating ratio for the year 2018. During 2018, the company and its subsidiaries registered total revenue of $221.57 billion, while the cost of sales and selling & administrative expenses incurred by the company during the year stood at $120.34 billion and $47.71 billion respectively. Calculate the operating ratio of Samsung Electronics Co. Ltd. for the year 2018 based on the given information.

Example of Samsung Electronics Co. Ltd-2.1

Solution:

Operating Ratio is calculated using the formula given below

Operating Ratio = (Cost of Goods Sold + Operating Expenses) / Total Revenue

Operating Ratio Formula -2.2

  • Operating Ratio = ($120.34 billion + $47.71 billion) / $221.57 billion
  • Operating Ratio = 75.85%

Therefore, the operating ratio of Samsung Electronics Co. Ltd. for the year 2018 stood at 75.85%.

Operating Ratio-2.4

Source Link: Samsung Balance Sheet

Operating Ratio Formula – Example #3

Let us take the example of Walmart Inc. According to its annual report, the company generated net sales of $500.34 billion during 2018. Calculate the operating ratio of Walmart Inc. if the cost of sales and operating expenses incurred during the period are $373.40 billion and $106.51 billion respectively.

 example of Walmart Inc -3.1

Solution:

Operating Ratio is calculated using the formula given below

Operating Ratio = (Cost of Goods Sold + Operating Expenses) / Total Revenue

Operating Ratio Formula -3.2

  • Operating Ratio = ($373.40 billion + $106.51 billion) / $500.34 billion
  • Operating Ratio = 95.92%

Therefore, Walmart Inc. operating ratio for the year 2018 stood at 95.92%.

Operating Ratio Formula -3.3

Source: Walmart Annual Reports (Investor Relations)

Explanation

The formula for an operating ratio can be derived by using the following steps:

Step 1: Firstly, determine the cost of goods sold by the company. It is the summation of all direct and indirect costs that can be assigned to the job orders, and it primarily comprises raw material cost, direct labor cost and manufacturing overhead cost. These cost fields are easily available in the income statement.

Cost of Goods Sold = Raw Material Cost + Direct Labor Cost + Manufacturing Overhead Cost

Step 2: Next, determine the operating expenses of the company that primarily includes all indirect costs of production that can’t be assigned to the job orders. Examples of operating expenses are selling & distribution expenses, office & administration expenses, etc. which are seen as separate line items in the income statement.

Operating Expenses = Selling & Distribution Expenses + Office & Administration Expenses

Step 3: Next, find out the total revenue of the company and it is easily available as the first line item in the income statement of a company.

Step 4: Finally, the formula for an operating ratio can be derived by dividing a sum of the cost of goods sold (step 1) of the company and it’s operating expenses (step 2) by its total revenue (step 3) as shown below.

Operating Ratio = (Cost of Goods Sold + Operating Expenses) / Total Revenue

Relevance and Uses of Operating Ratio Formula

It is important to understand the concept of operating ratio because it is used to evaluate the ability of the company’s management to generate sales while controlling its operating expenses in the process. A lower value of the ratio indicates better efficiency of the company management in generating dollar against the operating expenses which means higher profit margin or higher return for the investors. On the other hand, a higher value is unfavorable as it means lower profitability and hence lower return.

Operating Ratio Formula Calculator

You can use the following Operating Ratio Calculator

Cost of Goods Sold
Operating Expenses
Total Revenue
Operating Ratio
 

Operating Ratio =
Cost of Goods Sold + Operating Expenses
=
Total Revenue
0 + 0
= 0
0

Recommended Articles

This is a guide to Operating Ratio Formula. Here we discussed how to calculate Operating Ratio along with practical examples. We also provide an Operating Ratio calculator with a downloadable excel template. You may also look at the following articles to learn more –

  1. Formula For Decile
  2. How to Calculate Quartile Deviation Uusing Formula
  3. Example of Net Operating Income Formula
  4. Calculation of Portfolio Return
  5. Manufacturing Overhead | Introduction | Advantages and Disadvantages
  6. Top Differences of Gross sales vs Net sales
  7. Guide to Price to Sales Ratio

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Operating Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Operating Ratio Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW