KPI based multiple factors

%3CLINGO-SUB%20id%3D%22lingo-sub-2682135%22%20slang%3D%22en-US%22%3EKPI%20based%20multiple%20factors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2682135%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20KPI%20based%20on%20three%20factors.%20example%20employees%20are%20performing%20multiple%20functions%20but%20at%20the%20end%20of%20the%20day%20i%20need%20each%20employee%20to%20perform%20100%25%20during%20his%2Fher%208%20hours.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%20-%20putaway%2015%20skids%2Fhour%20-%20replenishment%2010%20skids%2Fhour%20-%20picking%2026%20lines%2Fhour.%20the%20combination%20of%20all%20this%20must%20be%20100%25.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20help%20me%20get%20there%20if%20you%20can.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2682135%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2682806%22%20slang%3D%22en-US%22%3ERe%3A%20KPI%20based%20multiple%20factors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2682806%22%20slang%3D%22en-US%22%3E%3CP%3Ethis%20is%20typical%20example%3CBR%20%2F%3E%3CBR%20%2F%3E8%2F23%2F2021%20PUTAWAY%20Operator%201%20-%203%20skids%3CBR%20%2F%3E8%2F23%2F2021%20REPLENISHMENT%20Operator%201%20-%2011%20skids%3CBR%20%2F%3E8%2F23%2F2021%20Order%20PICKING%20Operator%201-%2014%20lines%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2690775%22%20slang%3D%22en-US%22%3ERe%3A%20KPI%20based%20multiple%20factors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2690775%22%20slang%3D%22en-US%22%3EAm%20i%20helpless%20in%20here%20with%20all%20experts%20in%20the%20room.%3F%3F%20anything%20wrong%20with%20my%20request%3F%3C%2FLINGO-BODY%3E
New Contributor

hi, 

I want to create KPI based on three factors. example employees are performing multiple functions but at the end of the day i need each employee to perform 100% during his/her 8 hours.

 

example - putaway 15 skids/hour - replenishment 10 skids/hour - picking 26 lines/hour. the combination of all this must be 100%.

 

please help me get there if you can.

 

thank you

4 Replies

this is typical example

8/23/2021 PUTAWAY Operator 1 - 3 skids
8/23/2021 REPLENISHMENT Operator 1 - 11 skids
8/23/2021 Order PICKING Operator 1- 14 lines

Am i helpless in here with all experts in the room.?? anything wrong with my request?

@baandow 

It all depends on how your data is structured, much better to have sample file.

If you have separate table with targets of skids/lines for each activity, you may add helper column to main data which transforms actual skids/lines into hours or percentage of target. When you may aggregate your data by PivotTable to show data for each employee/operator for each date.

thank you