re. predicting associate performance

deepa

New member
We have activities like unloading, putaway, picking,loading activities performed by associates in a warehouse.
we have the associates working in say 3 shifts.
We have the shiftwise associate performance as below
activityColumn1associateactivity weightassociate weightperformanceColumn2Column3
XX1ua1
0.222222222​
0.166666667​
85​
48.57143​
36.42857143​
XX2ua2
0.222222222​
0.277777778​
90​
40​
50​
YY1ta3
0.444444444​
0.333333333​
91​
52​
39​
YY2ta4
0.444444444​
0.222222222​
92​
61.33333​
30.66666667​
ZZ1ba2
0.333333333​
0.277777778​
87​
47.45455​
39.54545455​
ZZ2ba3
0.333333333​
0.333333333​
89​
44.5​
44.5​
XX1ua1
0.222222222​
0.166666667​
92​
52.57143​
39.42857143​
XX2ua4
0.222222222​
0.222222222​
93​
46.5​
46.5​
...
0.358024691​
0.265432099​
90.55556​
52.0022​
38.55335534​

we have an overall performance.
Activity weight, associate weight is calculated as below.
3 a1 associates allocated in this shift 3/18 , 5/18 for a2 , 6/18 for a3,4/18 for a4
The activity weight is nbr of unique column 1 value . i.e 4/18 for u etc
The last line shows the overall total.

Then the column 2 is activity weightage contribution to overall performance like .222* 85/(.222+.1667)=48.57143
Then the column 3 is associate weightage contribution to overall performance like .16667* 85/(.222+.1667)=36.42857143
with this idea I would like to predict the best possible overall performance by deploying various combination of associates, provided i know the workload for next day
Suppose even if i consider the same workload for next day, say for e.g. i would just swap the associates increase a1 by 2 and reduce a2 by 2 , then what would be the overall performance of the shift
We want to maximise the overall performance for different workloads by deploying appropriate associates
Pls let me know how to do it
 

Alexandoy

Member
This discussion is interesting to me for it reminds me of the production management during my college days. Unfortunately, I seem to be having a hard time in understanding the numbers due to lack of practice. I hope someone here who has a fresher mind would pitch in for proper comment that can be of help.
 
Thread starter Similar threads Forum Replies Date
P Warehousing & Distribution Centres 14
Top