Supply Chain Resilience: Achieving Long-Term Resilience and Agility
Get ahead of your supply chain vulnerability issues.
The ongoing Russia-Ukraine conflict has shed light on the critical importance of Supply Chains and the wider economy. From increases in food commodity costs to impacts on energy and fuel costs, the relatively stable global economy has suddenly had an injection of inflation and scarcity. And some business partners have unexpectedly become unavailable due to sanctions being applied.
This is on top of the challenging disruptions caused by Covid which have already influenced many companies’ attitude to risk and long-distance supply chains.
In addition, Brexit has had a significant impact, with various companies re-modelling their Supply Chain to minimise impact and maximise their potential opportunity.
Even the Ever-Given blockage of the Suez Canal highlighted the vulnerability and criticality of supply chains.
Is this a perfect storm or a massive opportunity? What does it mean to businesses?
It means they need to be able to easily understand what risk they are exposed to by continuously monitoring change. It means each business needs a detailed understanding of who its partners are, where its stock is, and its ability to mitigate price changes and product/resource availability.
To address these independent challenges requires joined up thinking and the ability to leverage systems and processes.
Know your Partners
The providence of your Supply Chain partners has become increasingly important in recent times. Knowing their underlying ownership structure and their vulnerabilities to disruption is important to understand to make sure that you can mitigate risks.
Microsoft’s “Supply Chain Insights” tools enable you to create resiliency and make better Supply Chain decisions with proactive risk mitigation via prescriptive insights, all powered by Artificial Intelligence (AI).
Being able to simply use your existing BI tools to –
Plot your partner locations, geographically highlights political and geographical impacts;
Integrate to Credit Management tools to enrich your data and therefore understand the ability of your partners to withstand economic shock.
Have regular conversations with suppliers (and customers where necessary) and capture their constraints, ownership structures and key partner characteristics in an easy to analyse tool.
The end result? You can answer these questions:
Know your stocks and supply chain bottlenecks
If the Ever Given happened to block the Suez Canal again, do you know the consequences for tomorrow? If a new conflict arose, would you know which partners are unlikely to be able to deliver next week? If a harvest failed in a critical ingredient how quickly could you find replacements?
How do you understand this?
You need a clear view of inventory, commitments and orders. You need to be able to understand it quickly and be able to make decisions quickly. This is where an inventory management “optimiser” or Supply Chain control tower comes in.
How do you manage it?
By managing your source of supply and dual or multi sourcing products so you can switch suppliers under times of stress quickly. Don’t forget to make sure that these alternative suppliers have exposures to different risks than the “prime” supplier…
Or – if you have some materials/ingredients that can’t be mitigated then the only way to be sure is to hold additional ingredient/material inventory. I’ve seen clients that have needed to hold 18 months of ingredient stocks just in case a sensitive harvest fails.
Understand your demand
Stock is the key to managing Supply Chain risk, it’s also one of the most significant costs to a business, consequently, balancing risk against working capital and forward commitments is one of the most challenging elements for any supply chain and financial manager.
To manage risk, it’s useful to quantify the “predictable” variations and then assess the additional safety factors that might be appropriate. To do this companies often use specialist demand planning tools to generate a forecast. However, it’s often not the forecast that is important but the variability of demand (easy to calculate – **see example below). You can do the same calculations for supply variations, the same for all levels of the BoM. To mitigate the current demand challenges, it may be best to ignore your finished goods forecasts and simply forecast consumption of key ingredients. It should be simpler as they are likely to be damped by your production processes and the divergence of your portfolio. They should therefore have a smaller fluctuation and allow you to report to your board of directors the investment required to provide confidence against typical Supply Chain fluctuations. Then decide on the additional factors to use to insure yourselves against unexpected risks, conflicts, ecological disruption...
The above doesn’t need a fancy Supply Chain forecasting tool (although it can help), the BI functions are available within Excel and the results are deployable from within your ERP system. Consequently, the tools you can use to understand and mitigate your risks are already at your fingertips.
Once you have quantified that risk and projected it forward, you can then assess how you mitigate it. Financially, you may wish to hedge or take a forward position on some of your more variable/significant commodities. For example, if wheat is a significant percentage of your procurement, then taking a forward position may have enabled you to reduce the impact of some of the 50% price rises expected in the next year. Achieving this may not need a new system or process but simply a clear view of your data, a good set of assumptions about your demand, and a method of recording your decisions and assumptions. Microsoft Dynamics 365 can provide all of these, particularly when aligned to the Power BI analytics and the data capture tools available within the Power Platform.
What else can you do?
Transport is a major cost but also a way to mitigate risk. It may not need to be a binary decision to sea or airfreight goods, but might be pertinent to use both methods. Ship your baseline demand via sea and then manage the variability via air? This maximises your ability to respond while reducing your overall stock cost (but increasing transport). Obviously a balanced view should be taken according to the profitability of your portfolio and the bulk/value density of your products. Again, managing this transport, highlighting shortages, and understanding the costs of shipment are key components of the Microsoft Dynamics 365 solution. Leveraging them together can provide you with some powerful information to make informed decisions and improve your cost/risk position.
As you can see, your systems are key to consolidating information, and leveraging tactical alerting can make sure that your company stays on the front foot through times of disruption. Leveraging the information that’s already available to you about your Supply Chain can help you identify challenges, highlight and mitigate risks, and work through unexpected and unpredictable challenges.
If you have questions or would like help to address these challenges, then please contact HSO.
**Demand Variability – example
If you have a consistent demand of five per week, every week, then you have zero demand variability and therefore don’t (theoretically) require any kind of safety stock to mitigate demand fluctuation (and yet with 4 weeks cover in place you’d be holding 20 in stock with no real purpose).
However If you have a more random demand profile then your average demand per week is still five, however, to cover your maximum historic demand (12) would require an additional safety stock of 7 (7+5 [runrate]= 12).
In this case the traditional thinking of using “weeks cover” is crude and unwieldy using a statistical method, choosing
a “service level” (all available within Excel or PowerBI) can then help you optimise your demand profile against a defined service level.
The standard deviation of my sample (calculated in excel using stddev.s) is 3.35. Then, mathematically and for a desired service level of 90% fulfilment, I should carry a safety stock of 4.28, 95% = 5.494, 99% = 7.8, 99.99% = 12.5. That simple calculation can reduce your safety stock holding by more than 50% and you could implement it this afternoon, using excel!

Supply Chain Resilience: Achieving Long-Term Resilience and Agility
Get ahead of your supply chain vulnerability issues.
HOW CAN WE HELP?
Dive into our knowledge and best practices
We, and third parties, use cookies on our website. We use cookies to keep statistics, to save your preferences, but also for marketing purposes (for example, tailoring advertisements). By clicking on 'Settings' you can read more about our cookies and adjust your preferences. By clicking 'Accept all', you agree to the use of all cookies as described in our privacy and cookie policy.
Purpose
This cookie is used to store your preferences regarding cookies. The history is stored in your local storage.
Cookies
Location of Processing
European Union
Technologies Used
Cookies
Expiration date
1 year
Why required?
Required web technologies and cookies make our website technically accessible to and usable for you. This applies to essential base functionalities such as navigation on the website, correct display in your internet browser or requesting your consent. Without these web technologies and cookies our website does not work.
Purpose
These cookies are stored to keep you logged into the website.
Cookies
Location of Processing
European Union
Technologies Used
Cookies
Expiration date
1 year
Why required?
Required web technologies and cookies make our website technically accessible to and usable for you. This applies to essential base functionalities such as navigation on the website, correct display in your internet browser or requesting your consent. Without these web technologies and cookies our website does not work.
Purpose
This cookie is used to submit forms to us in a safe way.
Cookies
Location of Processing
European Union
Technologies Used
Cookies
Expiration date
1 year
Why required?
Required web technologies and cookies make our website technically accessible to and usable for you. This applies to essential base functionalities such as navigation on the website, correct display in your internet browser or requesting your consent. Without these web technologies and cookies our website does not work.
Purpose
This service provided by Google is used to load specific tags (or trackers) based on your preferences and location.
Why required?
This web technology enables us to insert tags based on your preferences. It is required but adheres to your settings and will not load any tags if you do not consent to them.
Purpose
This cookie is used to store your preferences regarding language.
Cookies
Why required?
We use your browser language to determine which language to show on our website. When you change the default language, this cookie makes sure your language preference is persistent.
Purpose
This service is used to track anonymized analytics on the HSO.com application. We find it very important that your privacy is protected. Therefore, we collect and store this data anonymously on our own servers. This cookie helps us collect data from HSO.com so that we can improve the website. Examples of this are: it allows us to track engagement by page, measuring various events like scroll-depth, time on page and clicks.
Cookie
Purpose
With your consent, this website will load Google Analytics to track behavior across the site.
Cookies
Purpose
With your consent, this website will load the Google Advertising tag which enables HSO to report user activity from HSO.com to Google. This enables HSO to track conversions and create remarketing lists based on user activity on HSO.com.
Possible cookies
Please refer to the below page for an updated view of all possible cookies that the Google Ads tag may set.
Cookie information for Google's ad products (safety.google)
Technologies Used
Cookies
Purpose
With your consent, we use IPGeoLocation to retrieve a country code based on your IP address. We use this service to be able to trigger the right web technologies for the right people.
Purpose
With your consent, we use Leadfeeder to identify companies by their IP-addresses. Leadfeeder automatically filters out all users visiting from residential IP addresses and ISPs. All visit data is aggregated on the company level.
Cookies
Purpose
With your consent, this website will load the LinkedIn Insights tag which enables us to see analytical data on website performance, allows us to build audiences, and use retargeting as an advertising technique. Learn more about LinkedIn cookies here.
Cookies
Purpose
With your consent, this website will load the Microsoft Advertising Universal Event Tracking tag which enables HSO to report user activity from HSO.com to Microsoft Advertising. HSO can then create conversion goals to specify which subset of user actions on the website qualify to be counted as conversions. Similarly, HSO can create remarketing lists based on user activity on HSO.com and Microsoft Advertising matches the list definitions with UET logged user activity to put users into those lists.
Cookies
Technologies Used
Cookies
Purpose
With your consent, this website will load the Microsoft Dynamics 365 Marketing tag which enables HSO to score leads based on your level of interaction with the website. The cookie contains no personal information, but does uniquely identify a specific browser on a specific machine. Learn more about Microsoft Dynamics 365 Marketing cookies here.
Cookies
Technologies Used
Cookies
Purpose
With your consent, we use Spotler to measures more extensive recurring website visits based on IP address and draw up a profile of a visitor.
Cookies
Purpose
With your consent, this website will show videos embedded from Vimeo.
Technologies Used
Cookies
Purpose
With your consent, this website will show videos embedded from Youtube.
Cookies
Technologies Used
Cookies
Purpose
With your consent, this website will load the Meta-pixel tag which enables us to see analytical data on website performance, allows us to build audiences, and use retargeting as an advertising technique through platforms owned by Meta, like Facebook and Instagram. Learn more about Facebook cookies here. You can adjust how ads work for you on Facebook here.
Cookies
Purpose
With your consent, we use LeadInfo to identify companies by their IP-addresses. LeadInfo automatically filters out all users visiting from residential IP addresses and ISPs. These cookies are not shared with third parties under any circumstances.
Cookies
Purpose
With your consent, we use TechTarget to identify companies by their IP address(es).
Cookies
Purpose
With your consent, we use this service provided by uMarketingSuite to run A/B tests across the HSO.com application. A/B testing (also called split testing) is comparing two versions of a web page to learn how we can improve your experience.
Purpose
With your consent, we use this service provided by uMarketingSuite to personalize pages and content across the HSO.com application. Personalization helps us to tailor the website to your specific needs, aiming to improve your experience on HSO.com.
Purpose
With your consent, we use ZoomInfo to identify companies by their IP addresses. The data collected helps us understand which companies are visiting our website, enabling us to target sales and marketing efforts more effectively.
Cookies