Multi factor productivity calculations

[Sean Keogh]

Hi All,

I've used this site for years to search for answers to formula problems I've had and loved it. But now I'm trying to find a formula to calculate a productivity based on 2 different volume metrics and I'm stumped!

So the basic productivity calculation we use is ORDERS / HOURS = hourly KPI (Key Performance Indicator).
E.g. 100 orders completed in 10 hours would be 10 orders per hour (100/10=10)

However we are in need of being able to produce some sort of weighted / multi-factor / 2 volume data metric type calculation as the individual orders can have widely varying sizes. Below is a basic way of showing it:

Time	Orders	Units	Average units per Orders	Orders/HR	Units/HR	AV Units/HR
10	100	1,000	10	10.00	100	1
10	50	2,000	40	5.00	200	4

<tbody>
</tbody>

As you can see the first line has a higher order per hour rate, but lower units per hour. The second line has a lower orders per hour, but a higher units per hour rate. I need to combine the units and orders metrics somehow.

I was wondering if anyone has come across this before and knew of a way to generate a formula that accounts for the varied volume within each order so I can set a KPI that I can plan more accurately. Currently we have days where we finish the work really early as the units/order are low and days that we run over because the units/order are high.

Any help by brighter minds than mine would be appreciated!

Regards,

Sean