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.
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.
- 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
- Consequently, press ENTER and drag down the Fill Handle tool for other cells.
- Then, move to cell G5 and write up the formula.
It will divide the Output Amount by the Total Working Hours.
Eventually, you will get productivity. Now, you need to convert it into percentages.
- 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.
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.
- Firstly, go to cell F5 and insert the formula to get the Total working Hours of Machines.
D5 = Machine Working Hours.
E5 = No. of Machines.
- Subsequently, press ENTER, and you will get the result just like the image below.
- Then, go to cell G5 and enter the formula.
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.
- After that, the Format Cells dialog box will appear. From there select Percentage and hit OK.
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.
- Firstly, select cell E5, and enter the formula.
- Then, press ENTER and drag it down for other cells.
- 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.
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.
- Initially, move to cell E5 and insert the formula.
Basically, it will divide the value of C5, which is the total output amount for your production, by the total number of employees.
Eventually, you will get the Per Employee Productivity after pressing ENTER and dragging it down to cell E9.
We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.
Download Practice Workbook
Download the following practice workbook. It will help you to realize the topic more clearly.
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.
- How to Calculate Error Percentage in Excel
- How to Calculate Cumulative Percentage in Excel
- How to Calculate Mean Percentage Error in Excel
- How to Calculate Remaining Shelf Life Percentage in Excel
- How to Calculate Percentage of Completion in Excel
- How to Calculate Absenteeism Percentage in Excel
- How to Calculate Savings Percentage in Excel
- How to Calculate Variance Percentage in Excel
- How to Calculate Accuracy Percentage in Excel
- How to Calculate Grade Percentage in Excel
- How to Calculate Win-Loss Percentage in Excel
- How to Calculate SLA Percentage in Excel
- How to Calculate Percentage of Budget Spent in Excel
- How to Calculate Utilization Percentage in Excel