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:

[TABLE="width: 507"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Orders[/TD]
[TD]Units[/TD]
[TD]Average units per Orders[/TD]
[TD]Orders/HR[/TD]
[TD]Units/HR[/TD]
[TD]AV Units/HR[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]100[/TD]
[TD]1,000[/TD]
[TD] 10[/TD]
[TD]10.00[/TD]
[TD]100[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]50[/TD]
[TD]2,000[/TD]
[TD] 40[/TD]
[TD]5.00[/TD]
[TD]200[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

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