sku

Fill rate can be defined as the percentage of customer demand that was fulfilled with stock in hand.

If this looks like an oversimplified definition, it probably is. The idea behind the fill rate is to make sure the customer is satisfied by getting what they want and when they want. In an ideal scenario all our customers who order online or visit our stores should be immediately (or with some help) to be able to find what they came looking for.

In-store fill rate

Most of the time when customers walk in a store if you are lucky they will ask someone from the staff if they are not able to find what they came to buy. But in most cases customers browse and they walk away unsatisfied. Even when they talk to the staff, this feedback is not rarely captured.

That is why it is important to invest in modern demand forecasting solutions that can help you figure out, how much of this unobserved demand was lost.

So coming back to fill rate, if we have a demand forecast, we can say fill rate to be:

Fill rate = Stock available / Demand forecast for the given period

Why fill rate is important

Fill rates are tied directly to the customer satisfaction rate. Any customer demand that goes unfulfilled would lead to either customer substituting the item with something else or coming back later, but in most cases (ranging from 21% to 41%), the customer would get the item from your competition.

Faulty forecasts lead to lower fill rates

Although the retail operations have gone a sea change in the last couple of decades due to the advent of technology and globalization. But still, many retailers are working with gut-feeling for their forecasts.

One reason forecasts are challenging is because most of the retailers have thousands (or millions) of SKUs and scores (or hundreds or thousands) of stores. So first of all, knowing demand for a given SKU and store location is not a job for manual calculations, neither can it be done by simple spreadsheets (which are pervasive in any planning process).

Another reason is that forecast is not one thing. To properly plan and successfully keep the fill rates up, not only stores need to know their demand forecasts, but distribution hubs, warehouses, manufacturers and even raw material suppliers need to know their forecasts. And add to it the complexity of lead time and seasonal demand, forecasting is best done by specialists.

How much should be ideal fill rate

According to recent studies, 95% and above fill rate is where most of the industry leaders are, anything below 92% is the bottom quartile. So, there you have it, to match or beat your competition, the fill rate you are looking for is 95%.

We Power the Data that Drive Your Business

Phone Number

+91-124-4524599

mayank
Meet Us for

Invest in better
solutions today

blog

News Feeds

Forecast new product success scientifically

A new product is launched in the market to reduce the inflation cost of production by making improvements on existing products, targeted to the current market needs. New products are launched by introducing area-specific changes to extend the market space....

A use case for what-if tool - Long horizon forecasting example

The need for long-horizon forecasting Long-horizon forecasting involves predicting a situation 1.5-2 years in advance. Some businesses need such horizons for procurement of raw materials, ensuring the availability of staff and labour to meet demand and supply, expense management in...

The Coronavirus Crisis-The impact of COVID-19 on the retail industry

While COVID-19 spreads globally, the retail industry braces for the outbreak’s fallout. From the slowdown in sales at the moment to not being able to move inventory and an increase in demand from the consumer market, here’s everything you need...