Skip to main content

Lead Time Forecasting: An Essential Step to Expert Demand Planning

When it comes to lead times, the days of making impulsive or unstrategic decisions are behind us.

Where long lead times were once nearly impossible to predict, modern technologies and forecasting strategies can help your company better prepare for all types of supply chain situations. Harnessing advanced solutions for lead times means staying ahead of your demand planning and inventory management.

Welcome Back to Our ‘7 Essential Steps’ Series!

We hope you enjoyed last week’s post on demand forecasting. Today it’s onto the second essential step of ‘getting it right’ in the purchasing process… Lead time forecasting!

Lead time forecasting is a critical and often overlooked component of demand planning and replenishment. For many retail and wholesale distributors, this is the first time you will put the words “lead time” and “forecast” together.

Since supply chain experts do not have a crystal ball for lead time predictions, we need to adopt a more methodical approach to calculating safety stock in terms of lead times. Data-driven decision-making (DDDM) is key to improving accuracy and driving more substantial results.

It makes a ton of sense when you think about it. With service and inventory performance at stake, why would you put tremendous resources into demand forecasting for your customers without giving the same attention to describing suppliers’ lead times? Lead time forecasting intelligence needs and deserves the same level of sophistication as demand forecasting!

Get Off the ‘Worst-Case-Scenario’ Train!

Supply chain and retail professionals have followed an interesting yet costly buying pattern for decades. While analysts are comfortable with a demand forecast that cuts through the middle of their demand history, lead time forecasting tends to send us spiraling into a worst-case scenario.

If the deliveries have been averaging 8 to 12 days, you are often more likely to see a 12-day lead time set rather than the average of 10.

At the same time, an item that historically sells between 50 and 150 will have a demand forecast of 100.

The first step of the lead time forecasting process is to treat the lead time value as a forecast rather than a setting.

If you have this mindset, great results will follow.

Supplier and Item Lead Time Forecasting

A strong lead time forecasting process analyzes the main receipt history and offers a supplier lead time forecast, but also offers item-level lead time forecasting for those items that are being scratched or short-shipped frequently.

The need for unique item-level lead time forecasting typically varies by industry.   Industries where suppliers have poor and inconsistent delivery performance — such as furniture distribution — will benefit from item-level lead time forecasting.

Just like in demand forecasting, gather as much lead time history as possible. Your data is extremely valuable. Years of lead time history and real-time analysis will allow you to put inventory behind the winning SKUs.

Key Components

Similar to the demand forecasting process, there are 3 critical attributes of lead time forecasting:  Lead Time Forecast, Lead Time Deviation, and Lead Time Seasonality. When done right, lead time forecasting delivers precision in all 3.

1. Lead Time Forecast

Start with the actual lead time forecast value, but don’t stop there. Offer as much history as possible. An intelligent forecasting method will tell you how much to use for each supplier and item. You can find this in today’s advanced cloud-native solutions for forecasting.

2. Lead Time Deviation

The deviation describes the reliability of the supplier and their performance.

Similar to the demand deviation, the higher the lead time deviation, the more safety stock will be required. This additional safety stock becomes part of the inventory operating expense and will negatively impact the profit of an item.

Your suppliers need to know, and so do you.

Suppliers need to realize that their consistency is just as important as their length of lead time. A lead time of 10 days that varies from 6 to 14 days will likely cause more inventory expense than a consistent lead time of 11 days. The extra safety stock will absolutely impact your inventory operating expense.

3. Lead Time Seasonality

Yes, your lead time deliveries also experience seasonal fluctuations. Accounting for these seasonal shifts can help your company improve the customer experience while minimizing supply chain cost spikes.

Common causes of seasonal delivery changes include:

  • Seasonal weather conditions.
  • Supplier plant shutdowns.
  • Employee vacations.
  • And plenty of other pains in the #$%!

In fact, it is often your own receiving departments that cause these seasonal changes! Your safety stock calculations and processes need to read these seasons and help you react.

Here’s how you can keep control over the situation. Just like with every component, your company needs to maintain lead time values proactively, as they influence the decision of ‘when to buy’ as much as they influence the obvious decision of ‘how much to buy.’ An accurate lead time calculation strategy will help you ensure you’re correctly timing inventory purchases, which can cut costs elsewhere in the supply chain.

The Financial Impact of Long Lead Times

Yes, your lead time deviation will influence your safety stock needs. But so will the length of the lead time.

A lead time of 100 days will require a much greater safety stock amount than a lead time of 10 days. Purchasing for a time 3 months from now reduces your confidence in how much you will sell during that period.

In fact, of the various safety stock components, your lead time can have the most influence when the lead times grow to several weeks and beyond. When purchasing import items with a goal of achieving lower pricing, it is important to analyze the additional cost of the safety stock.

Avoid Relying on the Worst-Case Scenario

If you continue to set your lead times using the worst-case-scenario strategy, you are adding unneeded days of inventory. Three days of cushioned lead time results in 3 days of unneeded safety stock. This adds to your inventory but is a monstrous misuse of cash!

If you know the value of 1 day of inventory, as most top-performing inventory management teams do, then you know the excess investment from cushioned lead times.

Common, Costly Pitfalls to Avoid

Many lead time forecasting habits have become common practice but cause excess time and expense. Usually much more than organizations realize. As you move from good to great in lead time forecasting, work to remove these common lead time pitfalls:

  1. Buying with a cushioned lead time that describes a worst-case scenario and keeps unnecessary just-in-case inventory dollars.
  2. Not actually forecasting a lead time from receipt history, but buying with a static number based on vendor promises or gut feel.
  3. Using one vendor-level lead time number for all of the line’s items, even though some items have experienced occasional short-ships or other mishaps and require a unique item lead time.
  4. Not tracking or utilizing the historical deviation information of the item’s receipt history for proper safety stock building.
  5. When forecasting vendor/item lead times, using one single forecasting calculation, even though each item has unique receipt history characteristics.
  6. Overreacting to individual long lead time spikes and reacting by building up unneeded inventory.
  7. Not filtering promotional, or other special-order receipts, out of the lead time calculations, which could inflate the inventory.
  8. Failing to forecast lead time demand, which measures how customer interest for a specific product fluctuates during your average lead time.
  9. Not taking seasonal lead time patterns into account when buying.

If you are doing any of the above, be sure to check out what these pitfalls are costing your business. This Inventory ROI Calculator will show you.

Advanced Operational KPIs for Inventory Management

Advanced lead time forecasting will also provide numerous operational studies. Here are some of the KPIs that deserve study and action by your inventory management team:

Increased Supplier Lead Times Costs

When suppliers suddenly struggle, and your lead time forecasting response is to move from 9 days to 14 days, there is a precise financial burden to the new normal.

For example, your forecasting tools should show that the change from 9 to 14 will add $100,000 to your inventory and $26,000 to your cost of carrying inventory. You are now carrying inventory that your supplier used to carry. They have transferred a cost to you.  You need to redeem that cost in the form of pricing, a bill-back, or some other agreement.

Supplier Performance Rates

Your suppliers are a crucial component in optimizing lead time. You need to continuously monitor their percent service to you and make adjustments if it does not match your needs.

Here’s what I mean. If your mission and promise is to deliver 98% service to your customers, and your suppliers service you at 96%, you need great tools to visualize the impact of that.

Track, study and respond to this critical number. Know the overall number as well as the value for each supplier and DC. There should be a rolling supplier service % calculation, and you should receive automatic alerts when the value changes. You will likely find seasonal changes in the number, which should lead to adjustments in replenishment.

Also, any value like this deserves a gap value, the current gap between your supplier’s service to you and your service to your customers. Your team will need to keep an eye on this gap value so you can make adjustments if anything seems off — changes in the gap should trigger action!

Averages Lines per PO

The size of the orders will influence your receiving schedules. As you make adjustments to your replenishment components, you have to watch for changes in the size of the orders.  These changes can influence receiving schedules and patterns.

How Order Size Affects Lead Times

When receiving gets heavy, or vacations limit the labor pool, disruptions can occur. Receiving teams often respond in different ways, even in different DCs in the same company.

You might find that your receiving teams push large orders for later to meet their goals. However, this increases lead times for those orders, and another DC could do the exact opposite. Put your data to good work and build stories that help you take the right action.

Time-to-Shelf and Available-for-Sale

You’ll also want to measure the time from the initial dock receipt to when that product becomes available for sale in your ERP’s on-hand value. Closely monitoring this gap can help you pinpoint which lead time spikes result from slowdowns inside the warehouse instead of external factors like weather and holidays.

What Does ‘Textbook’ Lead Time Forecasting Look Like?

Top-performing inventory management teams invest time and resources in lead time forecasting just as they do demand forecasting. They are in a constant journey to enhance, refine and sharpen the accuracy.

Valuable results await on both sides. Teams will experience an inventory reduction by removing the cushion and a service improvement by buying earlier on items with longer lead times.

Analysts should have the same degree of forecasting accuracy tools to monitor lead time trends and make changes.

Top inventory management teams also value collaboration. Integrated business planning with their suppliers leads to constantly getting the smartest, most accurate lead times possible. They offer purchase projections to help suppliers be prepared and in stock.

What Results Can You Expect?

Companies that add advanced lead time forecasting to their supply chain planning solutions consistently report additional 10% to 12% inventory reductions several months after their inventory solutions go live.

For those companies whose service-level promise is higher than their supplier’s performance, lead time forecasting is the key to delivering on that promise.

Analytical tools can help build a bridge between supply chain planning, the warehouse and the transportation teams. Inventory planning often has the data and insights that their operational peers need.

The lead time component has often been referred to as the “sleeper component.” There is too much at stake to allow it to stay in a slumber.

Add robust lead time forecasting to your good-to-great journey, and you will add to your bottom line!

Enhance Lead Time Forecasting With Blue Ridge Global

Modern software can help you streamline your demand and lead time forecasting processes so you and your team can focus on making solutions that work. And at Blue Ridge Global, that’s what we aim to produce.

Our AI-powered Demand Planning software uses machine learning to continuously improve forecast accuracy across all your channels and locations. Whether you’re managing 100 or 100,000 SKUs, Blue Ridge can help you easily forecast lead times.

Want to see Blue Ridge’s Supply Chain Management Software in action? Contact us today to set up your live demo!

Up next in our series: Step #3: Order Cycle Optimization. Be sure to subscribe so you don’t miss it!