How to Set Lead Times When Your Supplier Is Unreliable

The problem with a single lead time number

If you manage inventory for a Shopify store, you know the drill. Your supplier quotes a 30-day lead time. Sometimes the shipment arrives in 28 days. Sometimes it takes 45 days. Sometimes it sits at the port for a week before anyone tells you.

When your supplier is unreliable, the standard advice is to "just order earlier." But ordering earlier without a mathematical framework is just guessing. It ties up cash in excess inventory and still leaves you vulnerable to stockouts when the delay is worse than you guessed.

Here is how to mathematically handle unreliable suppliers without destroying your cash flow.

The problem with "average" lead time

Most inventory planning tools ask for a single number for lead time. If your last five shipments took 30, 45, 32, 28, and 40 days, the average is 35 days.

If you set your lead time to 35 days in your planning software, you are planning for failure.

Why? Because an average is just the middle point. By definition, roughly half of your shipments will take longer than the average. If you plan your reorder point based on a 35-day lead time, you will stock out on the shipments that take 40 or 45 days.

You cannot plan inventory based on averages when the downside of being wrong (stocking out) is much more expensive than the upside of being right (saving a few dollars in holding costs).

The two ways to handle supplier unreliability

When a supplier is unreliable, you have two mathematical levers to pull:

1. Increase your stated lead time. Plan as if the worst-case scenario is the normal scenario.
2. Increase your safety stock. Keep more buffer inventory on hand to absorb the delays.

Both approaches result in you holding more inventory, but they do it in different ways. Increasing your stated lead time pushes your reorder point earlier. Increasing your safety stock raises the floor of your inventory.

Which one should you use? It depends on the nature of the unreliability.

Scenario A: The consistently late supplier

If your supplier quotes 30 days but consistently delivers in 40 to 45 days, they are not unreliable. Their stated lead time is simply inaccurate.

In this scenario, do not increase your safety stock. Just change the lead time in your planning tool to 45 days.

Safety stock is for variability. If the supplier is consistently late, it is not a matter of variability. The lead time is just longer than they claim. Plan for the reality, not the quote.

Scenario B: The truly erratic supplier

If your supplier quotes 30 days and delivers in 25 days one month, 45 days the next, and 30 days the month after that, you have true variability.

This is where you need safety stock.

How to calculate safety stock for erratic lead times

As we covered in our guide on how to calculate safety stock, the textbook-correct formula accounts for both demand variability and lead time variability:

SS = Z x sqrt( (LT x SD_d²) + (AD² x SD_lt²) )

The second half of that formula under the square root — (AD² x SD_lt²) — is the part that protects you from your supplier.

Breaking down those variables:

• AD (Average Daily Demand): How many units you sell per day.
• SD_lt (Standard Deviation of Lead Time): How much your lead time bounces around.

If your lead time is highly variable, SD_lt will be a large number. Because it gets squared in the formula, a highly variable supplier will dramatically increase your required safety stock.

A worked example

Let's say you sell a product with these characteristics:

• Average daily demand: 10 units/day (AD = 10)
• Standard deviation of daily demand: 2.5 units (SD_d = 2.5)
• Average lead time from both suppliers: 30 days (LT = 30)
• Target service level: 95% (Z = 1.65)

Supplier A is reliable. They always deliver between 28 and 32 days. Their standard deviation of lead time is roughly 1.5 days (SD_lt = 1.5).

Plugging into the full formula:

SS = 1.65 x sqrt( (30 x 2.5²) + (10² x 1.5²) )

SS = 1.65 x sqrt( (30 x 6.25) + (100 x 2.25) )

SS = 1.65 x sqrt( 187.5 + 225 )

SS = 1.65 x sqrt( 412.5 )

SS = 1.65 x 20.31

SS = 33.5 → round up to 34 units

Supplier B is erratic. They average the same 30 days, but deliver anywhere from 20 to 50 days. Their standard deviation of lead time is roughly 10 days (SD_lt = 10).

Same formula, same product, same service level target — only SD_lt changes:

SS = 1.65 x sqrt( (30 x 2.5²) + (10² x 10²) )

SS = 1.65 x sqrt( (30 x 6.25) + (100 x 100) )

SS = 1.65 x sqrt( 187.5 + 10,000 )

SS = 1.65 x sqrt( 10,187.5 )

SS = 1.65 x 100.93

SS = 166.5 → round up to 167 units

Same product. Same average lead time. Same demand. Same service level target.

Supplier A requires 34 units of safety stock. Supplier B requires 167 units — nearly 5 times more — because their delivery window is unpredictable.

Notice what drove that difference: the supply variability term for Supplier A was 225, while for Supplier B it was 10,000. That is a 44x difference in just one component of the formula, and it is entirely caused by the supplier's erratic delivery pattern.

The cost of unreliability

This math reveals a critical business insight: unreliable suppliers are expensive.

When a supplier is erratic, the math forces you to hold more safety stock to maintain your service level. That safety stock ties up cash.

If Supplier B is 5% cheaper per unit than Supplier A, but requires you to hold $10,000 more in safety stock to prevent stockouts, Supplier B might actually be the more expensive option when you factor in the cost of capital.

Most Shopify operators evaluate suppliers based on unit cost and shipping fees. Very few evaluate them based on the working capital cost of their unreliability.

How to implement this today

If you are dealing with an unreliable supplier right now, here is your action plan:

1. Stop using their quoted lead time. Look at your last 5 to 10 receipts from that supplier. Calculate the actual average lead time and the standard deviation.
2. Update your planning tool. If your tool only accepts a single lead time number and does not calculate safety stock based on lead time variability, you have to manually pad the lead time. Use the average plus one standard deviation as your new baseline.
3. Calculate the true cost. Run the safety stock formula for that supplier's items. Look at how much extra cash is tied up just to buffer their unreliability. Use that number to negotiate better terms or justify moving to a more reliable, slightly higher-priced (but ultimately less expensive) supplier.

Why most inventory tools get this wrong

Most Shopify inventory apps use a simplified safety stock formula that only accounts for demand variability. They assume your supplier always delivers exactly on time. If your supplier is reliable, that simplification is fine. If your supplier is erratic, the tool is systematically underestimating your required buffer and you will stock out.

Any planning tool you use — whether it is a spreadsheet you build yourself or software you pay for — needs to accept lead time variability as an input. If it only asks for a single lead time number with no way to express how much that number fluctuates, it cannot protect you from an unreliable supplier.

In SkuClerk, this is handled through the Lead Time (days) and the safety stock formula on the Reorder Calc tab, which uses the combined variability formula shown above. You enter your average lead time and your lead time standard deviation per SKU, and the model calculates the appropriate buffer. If you do not have enough receipt history to calculate SD_lt precisely, a reasonable starting estimate is 20 to 25% of your average lead time.

The real decision

Once you run this math, the conversation with your supplier changes. You are no longer asking "can you deliver faster?" You are asking "can you deliver more consistently?" A supplier who averages 35 days but always lands between 33 and 37 is cheaper to plan around than one who averages 30 days but swings from 20 to 50.

Consistency reduces your required safety stock. Reduced safety stock frees up cash. Knowing that math can give you leverage to negotiate with the less reliable supplier or knowledge to inform better supplier selection.

If you want to see how this plays out across your full catalog, the reorder point formula and EOQ calculation both feed directly from the lead time and safety stock inputs covered here.