Sean Keogh
New Member
- Joined
- Oct 12, 2017
- Messages
- 1
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!![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Regards,
Sean
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!
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Regards,
Sean