Productivity Formula

**Warehouse Dan** · 02-27-2012, 03:23 PM

I currently have two productivity numbers that I measure to see how my employees are doing. Lines per hour and pieces per hour. The issue is that I can't get a true account of how productive people are because some of my orders will be high in lines and low in pieces and vise versa. I am looking to create a formula that will take in to account that I place 80% worth on lines and 20% worth on pieces and calculate what percent the employee has achieved that day. I used this in a previous job but the calculation was already set in an access database and I am trying to do this in excel.

Any suggestions would be appreciated

**dilipandey** · 02-27-2012, 03:31 PM

Hi Warehouse Dan,

Welcome to the forum.

It would be more easy to understand if you could just post a sample file. Click on Go Advanced while replying and look for paper clip icon to attach a file. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Warehouse Dan** · 03-02-2012, 03:19 PM

Attached is a sample of the productivity for the month of February. Taking into account that my Lines per hour target is 19/hour and my Pieces per hour target is 870/hour I would like to have a percentage of the work accomplished with lines being worth 80% and pieces being worth 20%Sample Employee Stats.xls

**dilipandey** · 03-02-2012, 03:23 PM

Hi Dan,

I am not able to find out Pieces per hour in the attachment. Is it "Eaches / Hour"?

Regards,
DILIPandey

<click on below 'star' if this helps>

**FDibbins** · 03-02-2012, 05:26 PM

Add this formula to the right of your table....

=((C3*0.8)+(E3*0.2))/(($C$9*0.8)+($E$9*0.2))

copy down. When i added up the results for all lines in the 1st table, it came out to 1

This is absoluted for just the 1st table, you will have to adjust the $C$9 etc to accomodate the other tables.