Identify fast-rotating products to optimize preparation and returns flows

The context

A company delivering household goods was faced with a constant flow of items back and forth between stock and packaging areas.

Certain high-demand products were also frequently returned, creating a significant loss of time for on-site teams.

The aim was to identify fast-moving items, so as to consider investing in an intelligent sorter capable of streamlining the flow of goods.

What I’ve done

• ABC analysis of shipments (outgoing) and returns to identify the most affected items
• Visualize Pareto curves to analyze distribution
• Cross-referencing of shipment/return results with application of a rotation score
  • A/B/C weighting → Calculation of a rotation index
• Final classification of products with the highest sorting potential

• Creation of an interactive Power BI dashboard, with :
  • Global time filtering
  • Analysis by returns, departures or turnover rate
  • View by product category or individual item

The results

• Identification of critical rotation products, justifying pre-storage in the sorter
• Better visibility for operators: focus on 5 key products
• A scalable tool for tracking volumes and fine-tuning logistics strategies
• Projected time savings through intelligent product flow management

What about the technical side ?

• Excel for initial ABC analysis
• Power BI for final dashboard creation
• Rigorous methodology based on Pareto’s law

Let’s talk about it !

Do you manage a warehouse, a supply chain, or a large volume of product returns?
I can help you with :

• Identify high-turnover products
• Set up a logistics tracking dashboard
• Help your teams save time and optimize operational flows

📩 Contact me to discuss your requirements !