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.
Download Practice Workbook
Download the following practice workbook. It will help you to realize the topic more clearly.
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%
3 Cases to Calculate Productivity Percentages in Excel
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 labors 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, for converting 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.
Read More: Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)
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.
Read More: How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)
- How to Make Cumulative Percentage Polygon in Excel
- Show One Number as a Percentage of Another in Excel
- Calculate Percentage Based on Conditional Formatting (6 Ways)
- How to Use IF and Percentage Formula in Excel (2 Easy Ways)
- Apply Percentage Formula in Excel for Marksheet (7 Applications)
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.
Read More: How to Calculate Utilization Percentage in Excel (3 Cases)
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.
Read More: Calculate Percentage of Filled Cells in Excel (7 Easy Ways)
We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.
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. Visit our website Exceldemy, a one-stop Excel solution provider, to find out diverse kinds of excel methods. Thanks for your patience in reading this article.
- How to Calculate Contribution Percentage with Formula in Excel
- How to Calculate ROI Percentage in Excel (6 Easy Ways)
- Calculate Total Percentage from Multiple Percentages in Excel
- How to Calculate Savings Percentage in Excel (3 Easy Ways)
- Calculate Error Percentage in Excel (3 Easy Methods)
- How to Calculate SLA Percentage in Excel (with Quick Steps)
- Use Excel Formula to Calculate Percentage of Grand Total