inventory management and control

How to Develop Traffic Light Inventory Management and Control Report in Excel to Reduce Stock Outs

Please raise your hand if you’ve ever panicked when your boss asked the question how many items are Out of Stock from Made to Stock list? Or How many items we are carrying too much excess stock? And it is not unusual that your boss wants this information in next 5 minutes! This is where inventory management and control report comes into play. Just to clear one point from start, I am not talking about inventory management and control reporting system from warehouse physical inventory control perspective but I am talking about inventory management and control report from a  planning/management […]

supply chain risk

10 Supply Chain Risks You Need to be Mindful of to Avoid Disruption

As supply chains have lengthened and more complex, supply chain professionals are increasingly responsible for anticipating and eliminating a greater number of supply chain risk. The stakes are high: in the past five years, nearly three-fourths of companies experienced significant disruptions. Which makes topic of ‘supply chain risk’ very important in current context. 1.    Supplier Risk There are several supply chain risks involved with working with other companies especially in the supply chain where there is high dependency on the other firms. These supply chain risks can vary from a supplier going bankrupt to not delivering the right quantity of […]