This keeps track of orders being made to suppliers and allows the monitoring of prices between different suppliers. “The Association of Manufacturers of Domestic Appliances has reported a shipping cost increase of up to 300% since 2020, while the China-Britain Business Council (CBBC) say it’s as much as 350%.” – AAT Setting Up Excel for Supply Chain ManagementĮxcel is an incredibly powerful tool and has the capacity to store and number crunch vast amounts of data, making it ideal for keeping records of your supply chain.Ī simple supply chain management spreadsheet would have a spreadsheet tab with the following columns: Similarly, the worldwide chip shortage affecting vehicle production is another example of how a chink in your supply chain management can cause a significant risk to the business. This is very apparent at the moment with major supply chain problems between the UK and Europe. Many businesses work on ‘just in time’ ordering, so when the unexpected happens with deliveries, this causes a disaster if not properly managed. There’s also a free Excel Supply Chain Management template to download at the bottom of this post. In this post, we’ll explore some of the ways to use Excel for supply chain management with examples and screenshots.

Additionally, Excel has a very advanced filtering system that allows different data to be selected from a wide range of tabular data. Using Excel for supply chain management is ideal because it allows you to keep tabular data, which can be used as a database by using VBA code. This makes supply chain management a critical business function – one where MS Excel thrives. Most businesses are heavily reliant on suppliers to keep their business running smoothly.

Supply chain workflow excel template