Analytics for warehouse

[Former Member]

Hello, I have a very simple query to you functional people. What type of visualization/Dashboards do you think warehouse managers would like to see for their warehouses? I can only think of something like Picking accuracy. Are there other dashboards to make sure their warehouses run better? I don't have any knowledge in this area so, asking for your help.

Thanks.

[jobi_t · Accepted solution]

Hi Venkat,

accuracy in inventory, fast shipping, quality , space optimization etc....

[Former Member · Accepted solution]

Jobi, thank you for these ideas. so which tables in ECC can give me information about these?

Thanks.

[christian_reinhardt · Accepted solution]

Hi Venkat,

you'll very likely no find a single table in EWM that will provide this kind of information. Therefor you first need to define how a KPI like picking accuracy be created, e.g. based on delivery date, number of entered exception codes, overall pciking differences etc. As soon as you know how the KPI is defined you can start searching the depending table.

Kind regards,

Christian

[Former Member · Accepted solution]

Ok, i got it. thank you. can you please share with me some more KPIs that can help warehouse management?

[Former Member]

Hi Venkat

Normally each warehouse will have KPIs(Key performance Indicators). Based on which efficiency of the ware house is measured. Warehosue managers, Supply chain managers would like to have overview of KPIs to know perfromance of WH. You can google with tag warehouse KPIs, will get lot of info.

Here are some KPI used. 

1) Outbound overview:-

Based on planned GI date VS actual GI date, you can tell number of delivery which are delivered on time Or late Or still not delivered.

2) Full pallet pickin:-

% of full pallet picks in total picked lines. For resource planning.

3) Avg. min per pick:-

This is most important KPI. Deviation from normal picking time needs to be analyzed. This may lead to better training of pickers to improve efficiency Or addressing bottle necks in picking process.

4) Weekly warehouse work load:- Identify warehouse work load in each silo. i.e Putaway, Pikcing, Replenishment & internal WH tasks. Helps you plan resources.

5) Slow moving stock, value.

Like this many more things are there. Information is spread across several tables.

Hope this helps.

Regards

Phani