calculate a productivity percentage

D

Dyson

Hi guys.

I'm looking for some help. I'm trying to calculate the productivity of my
team via excel. What I need is to set an average so that if they complete 12
tasks within an hour this is 100% performance.

My two columns are Productive time (in minutes) and forms complete. If it
falls below 12 an hour I need the percentage to reflect that.

Any help?
 
M

Mike H

Hi,

If we assume a data layout of:-

Col A= minutes
Col B= units produced
C1 = 12. The standard units per hour productiion rate
the this formula in D1 returns the % of standard production which can be
dragged down

=(60/(A1/B1)/$C$1)*100

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Weighted % Complete calculation 1
percentage help 0
How to modify and updte specific styles for specific paragraphs across the document 0
How do I calculate a percentage of a column? 2
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Percentage of month passed formula 1
Assigning percentage values? 1

Top