How to Calculate Productivity Percentage in Excel (3 Useful Cases)

Get FREE Advanced Excel Exercises with Solutions!

Certainly, you can easily calculate a percentage in Microsoft Excel, powerful software for calculations. Productivity is a common term in economics. So, you may need to calculate the productivity percentage in Excel. In terms of calculation, Excel shines with its enormous formulas and features. You can also calculate the productivity percentage in Excel. In this article, we are going to show you how to calculate productivity percentage in Excel. So, let’s get started.


What Is Productivity Percentage?

Productivity is defined as the ratio of the total output and the total input. You can calculate the productivity of labor, products, and machines. A good productivity percentage lies between 70-75%. It means that workers spend 75% of their time producing and 25% of their time resting or doing unproductive work. A good productivity percentage is a must for making a profit for a company. The total output income of a company is divided by the total input workload to gain the productivity percentage. So, the arithmetic formula to calculate the productivity range is as follows.

% of Productivity=(Total Input/Total Output)╳100%


How to Calculate Productivity Percentage in Excel: 3 Cases

This section covers 3 diverse cases to calculate productivity percentages. The most common thing while calculating productivity percentages is that you have to divide the actual or target production by the achieved or output production first. Then you need to convert the number into percentages. To make your Excel journey smoother, we’ll show you a different way to show the percentage for each case. Here, we have taken a dataset of a company’s Total Output and Total Working Inputs. We took the No. of Labors and their corresponding Working Hours, No. of Machines with their Working Time, No of Products produced Per Day, and the No. of Employees.

Dataset

Not to mention, we have used the Microsoft 365 version. You can use any other version at your convenience.


1. Finding Labor Productivity Percentage

You can calculate the labor productivity percentage by the ratio of the total output income and the total working hours of the labor force. You can get the total working hours of the laborers by multiplying the total labor by the working hours per day. Then we convert it to a percentage using the Percent Style button. Follow the steps to get a proper idea.

📌 Steps:

  • First, you must multiply the number of laborers by their corresponding working hours per day.
  • To do the operation, go to cell  F5 and enter the formula
=C5*D5

Labor Productivity Percentage in Excel

  • Consequently, press ENTER and drag down the Fill Handle tool for other cells.

Fill Handle

  • Then, move to cell G5 and write up the formula.
=C5/F5

It will divide the Output Amount by the Total Working Hours.

Eventually, you will get productivity. Now, you need to convert it into percentages.

Labor Productivity Percentage in Excel

  • Afterward, to convert the values into percentages, select the entire column of G and go to the Home tab >> choose Percent Style under the Number command.

Using Percent Style to calculate productivity Percentage in Excel

Finally, you will get the Productivity Percentage.


2. Finding the Productivity Percentage of Machines

It also follows the same procedure to calculate the Productivity of the Machine while calculating the Productivity of the Labor. Here we describe the use of the Format Cells method to show the percentage. Go through the steps to do it.

📌 Steps:

  • Firstly, go to cell F5 and insert the formula to get the Total working Hours of Machines.
=D5*E5

Here,

D5 = Machine Working Hours.

E5 = No. of Machines.

Calculate the Productivity Percentage of Machines in Excel

  • Subsequently, press ENTER, and you will get the result just like the image below.

  • Then, go to cell G5 and enter the formula.
=C5/F5

It will divide the value of C5 by the value of F5 to get Productivity.

  • You will get your answer after pressing ENTER and dragging it down gradually.

  • Now, for converting to the percentages, select the entire range and go to the Home tab >> click on Number Format.

Using Format cells to calculate productivity percentage in Excel

  • After that, the Format Cells dialog box will appear. From there select Percentage and hit OK.

Format Cells

Note: Just press CTRL + 1 to open the Format Cells dialog box.

Finally, you will get the desired result in the percentage format.


3. Estimating the Productivity Percentage of Products

Generally, you can calculate the productivity percentage of products by dividing the output income by the total number of products. Thus, you will get productivity for each product. Next, convert the decimal value into percentages by applying the keyboard shortcut. We have attached the steps to give you a basic visualization.

📌 Steps:

  • Firstly, select cell E5, and enter the formula.
=C5/D5
  • Then, press ENTER and drag it down for other cells.

Estimate the Productivity Percentage of Products in Excel

  • Sequentially, you will get the result in decimal format.

  • Now, select the entire range of Productivity and simply press CTRL + SHIFT + 5 to get the result in percentages form.

Using Keyboard Shortcut to calculate productivity percentage in excel

So, your result will look like the image above.


How to Calculate Productivity Per Employee

Sometimes, you may need to calculate per-employee productivity, or how much production is available per employee. Though it is a process to calculate productivity, it is not displayed through percentages. Follow the steps to do it.

📌 Steps:

  • Initially, move to cell E5 and insert the formula.
=C5/D5

Basically, it will divide the value of C5, which is the total output amount for your production, by the total number of employees.

How to Calculate Productivity Per Employee in Excel

Eventually, you will get the Per Employee Productivity after pressing ENTER and dragging it down to cell E9.


Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.

Practice Section


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


Conclusion

That’s all about today’s session. And these are some easy methods on how to convert time zones in Excel Please let us know in the comments section if you have any questions or suggestions. For a better understanding please download the practice sheet. Thanks for your patience in reading this article.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Hello! Welcome to my Excel blog! I am a big fan of MS Excel. I am learning new and exciting things in Excel and writing the process here. I think this will be helpful for you to get used to Excel. Keep visiting our website for new and updated Excel methods.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo