EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • 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,

ADVERTISEMENT
Popular Course in this category
FINANCIAL MODELING & VALUATION Course Bundle - 51 Courses in 1 | 30 Mock Tests | World's #1 Training

Start Your Free Investment Banking Course

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

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
ADVERTISEMENT
EQUITY RESEARCH ANALYST Certification Course Bundle - 23 Courses in 1 | 8 Mock Tests
93+ Hours of HD Videos
23 Courses
8 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.9
ADVERTISEMENT
FOREX TRADING Certification Course Bundle - 5 Courses in 1 | 3 Mock Tests
29+ Hours of HD Videos
5 Courses
3 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
CFA LEVEL 1 Prep Course Bundle - 20 Courses in 1 | 29 Mock Tests
113+ Hours of HD Videos
20 Courses
29 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
IFRS Course Bundle - 30 Courses in 1 | 5 Mock Tests
42+ Hour of HD Videos
30 Courses
5 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - 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

EDUCBA

Download Operating Ratio Formula Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

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

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

Forgot Password?

EDUCBA

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

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW