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 & […]

Components of Material Management

11 Vital Components of Material Management Technical Competencies to Master

When I started my blogging I wrote a blog on 8 Technical Supply Chain Competencies in Nov 2015. It was pretty basic and was more based on experience than research work. However, I did receive some good feedback on this article. On the back of that I have had opportunity to sponsor a Master’s research work to explore Components of Material Management Technical Competencies at Lancaster University. Nurul Amira, who is also the co-author of this article, has identified 11 Components of Material Management Technical Competencies for supply chain professionals as part of her research work. The purpose of this […]

ABC inventory analysis

Quickest Way to Perform ABC Inventory Analysis- Based on Value, Volume & Frequency of Sales

In supply chain most of us has been performing ABC inventory analysis for many years and in many different ways. This method has served us well and gives us several advantages. However, most supply chain analyst perform ABC analysis on value as you can see in this Wikipedia article and YouTube video. Over the years I have developed an algorithm to perform ABC inventory analysis which is based on Value (£ or $ ), Volume (Qty/Units) and Frequency (number of lines) of sales. I have performed this analysis in many different business and plants I’ve worked with and it has given […]

low cost inventory management software

3 Low Cost Inventory Management Software You Can Buy from Amazon

The success and failure of a business can be determined by the efficacy of the inventory management practices it employs. Certainly, poor inventory control can lead to cash flow problems or customer service issues. It is for this reason that few people have asked me on social media if I can recommend some low cost inventory management software. In very simple terms the main goal of inventory management is high stock turns (low Days on Hand), ensuring low operating costs and greater customer satisfaction. Organizing and managing your entire inventory manually on spread sheets could be difficult task. However, with […]

Supply Chain Modelling

Supply Chain Modelling – Approaches and Characteristics to Consider

Supply Chain modelling is used in industry since last three or four decades. Considering the broad spectrum of supply chain, no model can capture all aspects of supply chain processes. To compromise the dilemma between model complexity and reality, a model builder should define the scope of the supply chain model in such a way that it is reflective of key real-world dimensions, yet too complicated to solve. In this blog I’ve briefly explained supply chain modelling approaches and characteristics (variables) which might be of interest to supply chain analysts. Supply Chain Modelling- Approaches   To incorporate the 4 major […]

Benefits of ERP

Proven Benefits of ERP systems for effective Supply Chain Management

The main benefits of ERP systems are seen as the production of real-time data shared across integration and automation of business processes. This is particularly important in this new business environment where automation, effectiveness and efficiency in operations and real-time data are important factors for business success. Despite all these known benefits of ERP more than 50% of the suppliers who I worked with (mostly SMEs) do not deploy ERP and the ones who do, find the deployment very challenging in first go. To remain competitive, companies are forced to keep up to date with the new technologies. ERP systems […]

9 Critical Success Factors in ERP Implementation

This blog review of Enterprise Resource Planning or ERP Implementation procedures and critical success factors. Now the ERP use is generally common in big corporations and even SME’s are using various available ERP packages. But not every company gets the return from using the ERP system. I have been part of 3 different ERP systems and in my experience companies are failing to set up the ERP system because they cannot reach the predetermined goal. The ERP is not only a technology that support the management but also a way of the management. ERP provides many benefits but in nutshell […]

Supply Chain Improvement

10 Supply Chain Improvement Tools You Should Know About

Supply Chain Improvement Tools As most of the supply chain folks have faced varying degree of supply chain issues, I thought it would be useful to share some of the supply chain Improvement tools I have used over the years to resolve recurring supply chain issues. Intensive competition, fast technological change, and shortened product life cycles are just a few of the recurring challenges faced by many firms in today’s competitive markets. In last decade many western manufacturing firms have increased outsourcing of component parts and services to independent, external suppliers, while focusing on core capabilities to face these challenges. […]