Excel Tips & Tricks

24 Excel Tips & Tricks to Becoming a Supply Chain Nomad

Knowing useful Excel Tips & Tricks are important for supply chain professionals at all levels. I have come across some candidate who has fantastic CV, but when asked to use simple Excel formulas like vlookup or pivot table, they struggle. I remember once candidate left halfway through the interview process as he struggles to apply the Excel formulas required to get the desired outcome. The Supply Chain Management environment requires plenty of artistic vision, brainstorming, and inventiveness along with usual technical competencies. However, if you are a professional in supply chain management, then you should know that Excel Tips & […]

5 Quick and Remarkable Tips to Improve Forecasting Accuracy

Many businesses do some kind of forecast, due to its importance to benefits it provides. However, most business also complains about accuracy of their forecasting process and want to how they can improve forecasting accuracy?   Supply Chain Management is a broad umbrella of complex functions which are aligned to meet one common goal – customer satisfaction. A customer may walk into your store or browse your website to purchase their products. What happens if your store understocks the item and it is not available? The customer may wait for backorders, but due to various reasons, they may instead search […]

Supply Chain Processes – What can be Centralize or Decentralize?

CENTRALIZE VS DECENTRALISE SUPPLY CHAIN PROCESSES The debate to centralize or decentralize procurement processes is that organisations have been having for years; however, in supply chain processes context little has been written and said in my opinion (I did google it!). In recent years big organisations have observed a move towards centralized supply chain processes. In this blog I have tried to explain my view of the benefits and drawbacks of a centralized approach, presenting similar perspective on decentralize approach of supply chain processes. Here, we look at arguments for and against and also some example of natural central processes […]

Supply Chain Planning – 5 Levels of Time Horizon and Complexity Hierarchy

Supply Chain Planning Supply Chain Planning within an organisation exists on many levels, as well as in many functional areas. At a minimum, most organisations formally update their Profit Plans on a yearly basis. However, planning is an ongoing process that happens at different levels and different times dependent on resource availability and this is recognised by the 5 levels of Supply Chain Planning Horizon. Additionally, it is important that all the functional plans tie together to ensure that they mesh and support the company’s overall plan and objectives. It is important to have a plan of different time frames […]