The output is the final intended product of the process, which can be revenue, number of units produced, etc. Step 2: Next, determine the value of the output produced in the process. Examples of input include human labor regarding the number of labor or man-hours. The input is the initial resource provided for the production. Step 1: Firstly, identify what you want to consider as the input for the production process and then determine the input used value. The formula for productivity can be derived by using the following steps: Therefore, from the above analysis, it can be seen that Jason is the most productive analyst, with an execution rate of 4 cases per month.

Productivity Henry = 3.8 cases per month.

Productivity David = 3.6 cases per month.

Productivity Jason = 4.0 cases per month.

Revenue per Employee (Productivity) is calculated using the formula given below. of Employees (Input) = (Opening Employee Count + Closing Employee Count) / 2 of Employees is calculated using the formula given belowĪverage No. Calculate the revenue per employee for the company based on the given information.

In 2018, the company generated $35.0 million in revenue, and the company started the year with 200 employees and ended the year with 220 employees. Let us take another example where the company’s senior management wants to calculate the productivity of its employees in terms of revenue generated per employee. Therefore, during the last quarter, the employees produced at a rate of 14.2 units/hour. The productivity of the Employees is calculated using the formula given below. The input of Man Hours is calculated using the formula given below

Man hour calculation excel template