Matvey Zakharov
RU

One supplier can stop the business

Alternatives to a critical supplier are unknown or unavailable, so his failure can prevent delivery or destroy margin.

The stock when the main supplier stopped

Supplier 1 stopped shipping. Weeks without his deliveries: 8. Critical materials bought from him: 6 of 8. Each barrel is a week from the day he stopped.

Before
Week 1
4.8
Shipped18
Week 2
1.5
Shipped15
Week 3
0
Shipped7
Week 4
0
Shipped0
Week 5
0
Shipped0
Week 67
13.9
Shipped56
Orders cancelled: 33, worth RUB 1.0M
After
Week 12, 3, 6
7.8
Shipped18
Week 22, 3, 6
6.3
Shipped18
Week 32, 3, 6
5.0
Shipped23
Week 42, 3, 6
10.5
Shipped20
Week 52, 3, 6
6.1
Shipped27
Week 62, 3, 6
8.7
Shipped23
Orders cancelled: 0
The level in a barrel is the stock of his materials at the end of the week, in days of work. Above it, the suppliers who delivered that week; below it, the orders shipped.
Stock threshold, days: 5

Who each material was bought from

Purchases in the last three months of each period. Materials with a single supplier: 7 of 8 before, 1 of 8 after.

Before
After
A circle is a supplier's share of the material. Red: the material has one supplier; blue: two.
SOLUTION

Supplier resilience design

  1. From your purchases and stock, I find the critical materials: what production or shipping stops without, who each one is bought from, and what share of revenue it carries.
  2. For each critical material I find a second supplier and test him on a real delivery. Where the market has no alternative, the stock of that material is kept larger.
  3. Each material gets a stock threshold: once it is crossed, the shortfall is ordered from the second supplier before the shelf is empty. Stock and suppliers are visible every week.

What an engagement produces

  • A list of critical materials: who they are bought from and what share of revenue they carry
  • A second supplier for each material, tested on a delivery
  • Stock thresholds, and what to do when a supplier stops
  • A weekly report on stock and suppliers
  • Setup in your tools, or oversight if you set it up yourself

Rules, thresholds, scripts and automation logic are engagement deliverables and are not published here.

Find out whether this is actually your constraint.

Explore another problem