Well, you lost me on Cases 3 & 4. I would have expected them to be 66.667% &
33.333%. Basically, you are saying they are expected to do 100 items in 60
minutes which would also be 25 items every 15 minutes. If they are down for
15 minutes, then they should only be expected to do 75 items. You say they
have finished 50 and 25, that would be two thirds and one third, not one
half and one quarter.
Is there a smallest unit of time that you use (i.e. if they're down for 10
minutes or 14 minutes, is it listed as 15)? Generally, break down what they
are expected to do per the smallest unit of time you use (if that's one
minute intervals, it would be 1.667 items per minute). Next, computer the
available minutes and compare the number of items completed with the number
of items expected. In one minute intervals, this would be 1.667 * number of
minutes available.
--
Wayne Morgan
MS Access MVP
"kevcar40" <ke******@btinternet.com> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com...
i am trying to calculate the efficieny of a work group
case 1
a group has 1 hour as available time
The group have a target of 100
They Achieve 50
and have no downtime
this = 50% efficient
case 2
a group has 1 hour as available time
The group have a target of 100
They Achieve 50
and have 30 minutes downtime
this = 100% efficient
case 3
a group has 1 hour as available time
The group have a target of 100
They Achieve 50
and have 15 minutes downtime
this = 75% efficient
case 4
a group has 1 hour as available time
The group have a target of 100
They Achieve 25
and have 15 minutes downtime
this = 25% efficient
can anyone help with a formula
kevin