I am trying to do a formula within excel to find out Picking rates within a Warehouse to measure the picking team,
I know it is normally done by cases picked within a shift then divide by hours spent on the picking task
eg 1000 cases picked in 8 hour shift equates to pick rate 125 cases an hour,
Examples below Issue I have is eg, This is new position for me in a place where they never had pick rates , Working day 8.5 Hours with 45 minutes break time so actual working time 7 Hours 45 minutes
I have started a new job as Warehouse Manager and there is no benchmark in place for what the case rate an hour should be , The benchmark I could then judge by would be taking the 3 best pickers take their average and set benchmark eg at 85%-90% of their average, But I do not know how to do a formula on the picking task,
Picker A. 70 cases 50 products(50 Lines) on the order which means the picker must go to 50 locations to pick the order, time taken 50 minutes.
Picker B. 90 cases 5 products (5 Lines) on order which means picker must go to 5 locations to pick order, time taken 10 minutes .
Picker C. 200 cases 17 products (17 Lines) on order which means picker must go to 17 locations to pick order, time taken 33 minutes
What formula can I use that will take into account cases picked and also the amount of Lines on the order so all is equal when doing the pick rate measure,
Picker A. Pick's 500 cases that day and picked 400 Lines
Picker B. Pick's 1400 cases that day and picked 110 Lines ,
Picker C. Pick's 778 cases that day and picked 195 Lines
So how to get the perfect formula ?
Any help would be great,
I know it is normally done by cases picked within a shift then divide by hours spent on the picking task
eg 1000 cases picked in 8 hour shift equates to pick rate 125 cases an hour,
Examples below Issue I have is eg, This is new position for me in a place where they never had pick rates , Working day 8.5 Hours with 45 minutes break time so actual working time 7 Hours 45 minutes
I have started a new job as Warehouse Manager and there is no benchmark in place for what the case rate an hour should be , The benchmark I could then judge by would be taking the 3 best pickers take their average and set benchmark eg at 85%-90% of their average, But I do not know how to do a formula on the picking task,
Picker A. 70 cases 50 products(50 Lines) on the order which means the picker must go to 50 locations to pick the order, time taken 50 minutes.
Picker B. 90 cases 5 products (5 Lines) on order which means picker must go to 5 locations to pick order, time taken 10 minutes .
Picker C. 200 cases 17 products (17 Lines) on order which means picker must go to 17 locations to pick order, time taken 33 minutes
What formula can I use that will take into account cases picked and also the amount of Lines on the order so all is equal when doing the pick rate measure,
Picker A. Pick's 500 cases that day and picked 400 Lines
Picker B. Pick's 1400 cases that day and picked 110 Lines ,
Picker C. Pick's 778 cases that day and picked 195 Lines
So how to get the perfect formula ?
Any help would be great,