Revenue Per Employee Ratio Formula (Table of Contents)
- Revenue Per Employee Ratio Formula
- Revenue Per Employee Ratio Calculator
- Revenue Per Employee Ratio Formula in Excel (With Excel Template)
Revenue Per Employee Ratio
Analyst always looks to analyze company financially as well as operationally. It must be remembered that the operational ratios impact the financial ratio as well.
As legend investor warrant buffet says, operational efficiency leads to more profit. So, it becomes imperative to analyze the company operationally also.
As the employee is an integral part of every business, it makes more sense to analyze operational efficiency by analyzing the revenue per employee ratio. It is the easiest ratio for operational analysis and easy to interpret also.
Revenue Per Employee Ratio Formula
Revenue per employee calculates the number of sales generated by one employee or sales done by each employee. This is one of the important measures of performance of employees of the company. It is an easy indicator of productivity & efficiency of an organization’s personnel. It also indicates how effectively an organization is utilizing its human resources.
Revenue Per Employee Ratio Formula –
Generally, the number of employees keeps changing over period of time. Therefore, it is good practice to use an average number of employees during a particular period. A number of employee figures can be found in an annual report of the company. The figure for sales revenue can be taken from the income statement of the company. From the above formula, it can be easily understood that revenue per employee is easy to calculate and interpret. By common sense, one can say the higher the revenue per employee figure is, the better it is. Less revenue per employee shows less efficient operation.
But revenue per employee varies in different industries according to the need of labor requirements. Labor-intensive industries will be having less revenue per employee, whereas less labor-intensive industries will be having high revenue per employee.
Examples & Explanation of Revenue Per Employee Ratio Formula
Below table shows, revenue per employee of labor-intensive and less labor-intensive industry.
Labour Intensive Industry |
|||
Company Name |
Net Sales (million $) | Number of Employees |
Revenue Per Employee ($) |
Company ABC Ltd. |
25,000 |
80000 |
3,12,500 |
Company Aban Ltd. |
46,000 |
90000 |
5,11,111 |
Company KPIT Ltd. |
23,000 |
50000 |
4,60,000 |
Company PTC Ltd |
39,000 |
75000 |
5,20,000 |
Company XYZ Ltd |
90,000 |
180000 |
5,00,000 |
Less Labour-Intensive Industry |
|||
Company Name | Net Sales (million $) | Number of Employees |
Revenue Per Employee ($) |
Company PQR Ltd |
20000 |
18000 |
11,11,111 |
Company MNO Ltd |
5000 |
1108 |
45,12,635 |
Company TPU Ltd |
6000 |
3000 |
20,00,000 |
Company KNO Ltd |
18000 |
15000 |
12,00,000 |
Company APP Ltd |
2000 |
1500 |
13,33,333 |
As we have discussed earlier, we can see a company’s classification as per the industry. The less labour-intensive company generates more revenue per employee. This is because of industry-specific advantages and variations in the operation.
Analyst generally compares revenue per employee with the median of companies into the same industry. In less labor-intensive industry, Company MNO operates at the highest revenue per employee because its operations are more efficient than its peers. It can be said that each employee in the MNO company is more efficient than the peer set. Same is the true for labor-intensive industries.
Significance and Use of Revenue per employee Ratio Formula
Revenue per employee is an absolute figure in terms of given currency; therefore, it may look less useful in an analytical sense. For interpretation purposes revenue per employee, the figure should be compared with the historical data of the company or industry to see any deterioration or improvement. It must also be compared with the other peer companies operating in the same industry. This comparison across the industry and over time will give a useful understanding of the productivity of personnel.
Revenue per employee might be affected by the age of a company. New companies usually have small revenues and these are usually in the process of hiring more employees to fill positions. Therefore, their revenue per employee is lower than the of well-established companies. Sometimes earnings per employee can be calculated by using net profit, instead of sales revenue, in the above-stated formula. This also gives insights into the productivity of employees.
As the ratio is in the absolute figure, by itself, it is of little use without any benchmark or frame of reference, hence it should be read against the historical ratios for the same industry or company over a number of past years to be able to see if the ratios are falling or rising. This would help to show declining or improving the level of employee productivity. Then again, the ratios should be compared with other industry peers and how they have performed over the past years.
Revenue Per Employee Ratio Calculator
You can use the following Revenue Per Employee Ratio Calculator
Total Revenue | |
Number of Employees | |
Revenue Per Employee Ratio Formula= | |
Revenue Per Employee Ratio Formula= | = |
|
|
Revenue Per Employee Ratio Formula in Excel (With Excel Template)
Here we will do the same example of the Revenue Per Employee Ratio formula in Excel. It is very easy and simple. You need to provide the two inputs i.e Revenue and Number of Employees
You can easily calculate the Revenue Per Employee Ratio using Formula in the template provided.
Recommended Articles
This has been a guide to a Revenue Per Employee Ratio formula. Here we discuss its uses along with practical examples. We also provide you with revenue per employee ratio calculator with a downloadable excel template. You may also look at the following articles to learn more –
- Guide to Operating Profit Margin Formula
- Examples of Accounts Receivables Turnover Formula
- Equity Multiplier Formula Calculator
- Gross Profit Margin Formula Excel Template
250+ Online Courses | 1000+ Hours | Verifiable Certificates | Lifetime Access
4.9
View Course
Related Courses