Forecasting replenishment correctly and following standardized inventory replenishment processes continue to deliver significant returns to retailers, wholesalers, and manufacturers. For the retailer/ wholesaler/ manufacturer ready to move away from legacy technologies, tremendous opportunities cost 50-90% less than legacy systems. We know forecast accuracy in the 90% range delivers a significant increase of 15% or more in shareholder value.

Several documented events support these claims (click a link): a retailer achieved a 25% inventory reduction and a 3% same-store sales increase in 90 days, the sales and inventory trend continued going forward (press release), Dr. Mentzer’s 3-page story concerning a collection of businesses that delivered an average 15% shareholder value increase via forecast accuracy improvements which directly impacted forecasting replenishment, and The Home Depot Chairman and CEO, Frank Blake, stated explicitly in the 2011Q4 earnings briefing that supply chain investments continued to provide significant benefits including increased turns and same-store sales.

Our supply chain investments continued to deliver benefits for the business, improving our in-stock rate and asset efficiency as we again improved inventory turns this year. As of the end of 2011, we handled approximately 70% of our cost of goods sold through central distribution in
the US. This compares to approximately 25% four years ago.

Key data Sources for Forecasting Replenishment

Forecasting replenishment requires performance indicators for reorder points, order up to amount, forecast accuracy, service level attained, and automated/ configurable alerts and exception management to deliver significant returns for businesses. Data points needed for forecasting replenishment include:

Demand forecast.
Demand forecast error.
Service level goal.
Lead time.
Optimized supplier order cycle (days between reorders).
Product order cycle.
Supplier minimum pick quantity.

Visit this link to learn more about the forecasting replenishment performance indicators and data sources, including how they work together: inventory replenishment.

Key data Sources for Inventory Replenishment Processes

Some data sources needed for the inventory replenishment process but are not part of forecasting replenishment include company rounding rules, supplier minimum ship size, and shelf life. Demand planners should use each of these data points, and additional data points, such as inventory carrying cost, should be used for inventory optimization. The inventory optimization software should deliver the optimized supplier order cycle, which is the key contributor to days of shelf stock maintenance and a key factor for accurate demand plans and purchase projections. To learn more about order cycle optimization via inventory optimization processes, visit this link: inventory optimization.

Forecasting Replenishment and Demand Planning the Budget

Building the demand plan and budget should happen before forecasting replenishment; this may be an old-school methodology. The budget is part of demand planning that should follow AFTER your business’s initial Forecasting Replenishment process. Today’s root issue with many demand planning processes is the acceptance of inaccurate forecasts. A study of planners revealed that 90% change the number their forecast system delivers. Additional research shows that most forecasting systems have an outdated base technology, contributing to the inaccuracy. Worse, some companies use products like Excel for demand forecasting and aggregation. Since many people believe poor forecasting is inevitable and human intervention is the solution, it makes sense to build a plan and then run forecasting. Consider CPFR (collaborative planning, forecasting, and replenishment) – note how planning is before forecasting.
The results of planning first and then forecasting can be seen in the inventory replenishment process we have seen at numerous companies.

The results of plan first and then forecast can be seen in the inventory replenishment process we have seen at numerous companies.

Buy for the non-replenishment plan first to account for promotions, ads, and events.
Use the balance of the plan money for replenishment.
If sales do not meet plan, then cut receipts – often replenishment is the first cut.

The double impact of this decision is lost sales for non-replenished and then lost sales for replenished. Having worked in retail/ wholesale for over 15 years, this is a standard set of events. Today, many businesses need to realize the double loss they create.

Build Demand Planning with Replenishment Forecasting Projections

Assuming your business has accurate demand forecasting (contact us for a free consultation), forecasting replenishment should be step 1. Demand Planning for changes in the business, such as new products, replacement products, promotions, and events, would be step 2. Finally, forecasting replenishment again, where promotions and events are planned in step 2, completes the circle.

Replenishment Forecasting 1st then build Demand Plans

Demand Forecast for each product/ location (include future events and promotions)
Calculate inventory optimization to determine the average on-hand inventory
Project sales, inventory level, open purchase orders, and new orders.
Use data to build demand plans
Where ‘new’ promotions and events are added- recalculate steps 1-3

Confidence in the demand forecasting accuracy when forecasting replenishment and even non replenishment products would encourage the ideas presented today. With an 85 or 90% forecast accuracy, your business processes would embrace the idea of forecasting replenishment first and use the forecasting projections as the starting point for the demand planning. Most Demand Planning tools and software today focus on the planning and not demand forecasting accuracy. The good news is that companies can buy software today that does take advantage of hardware and software improvements to deliver solid, dependable, and accurate Demand Forecasting. These new Demand Forecasting software solutions are making it much easier for accurately forecasting replenishment and non- replenishment products in your business. You can run forecasting projections to use in your Demand Planning and ‘Tighten the Links in Your Chain™.’oint for the demand planning. Most Demand Planning tools and software today focus on the planning and not demand forecasting accuracy. The good news is that companies can buy software today that does take advantage of hardware and software improvements to deliver solid, dependable, and accurate Demand Forecasting. These new Demand Forecasting software solutions are making it much easier for accurately forecasting replenishment and non- replenishment products in your business. You can run forecasting projections to use in your Demand Planning and ‘Tighten the Links in Your Chain™.’

Are your ready to ‘Tighten the Links in Your Supply Chain?™’

We are here and ready to help. Contact us for a free consultation about your forecast accuracy and inventory management opportunities. You can also request a demo and see how things can really start to improve in your business in 90 days.

Stuart D

Stuart Dunkin is a strategic visionary who leads by calling on his broad range of experience as a former retail executive as well as a consultant for top retailers and for the E3/JDA software company. He founded Data Profits to solve a real-world problem plaguing retailers today – the disjointed relationship between supply chain data, people and business goals. He has experienced first-hand the challenges and frustrations that occur when decisions are made based on wrong data, which often leads to the wrong actions being taken with crippling results like overstock, out-of-stock, and increased working capital.
Stuart graduated from Auburn University, with bachelor of science in business administration.Tags:CPFR, Demand Planning, Forecasting Replenishment, Inventory Optimization, Inventory Replenishment

Share this entry

The Hidden Connection: Lead Time And Inventory Optimization Explained

How to Avoid Carrying Cost Mistakes in Inventory Optimization

Five Secrets of Successful Inventory Replenishment You Need to Know

Inventory Optimization: Putting it in to Practice

The Key Reason Your Inventory Replenishment System Loses Your Money

Data Profits Releases 4 Easy Replenishment Ideas that Adapt to the Digital Age

SUBSCRIBE TO DATA PROFITS BLOG

First NameLast Name*Company Email*

https://www.google.com/recaptcha/api2/anchor?ar=1&k=6Ld3iNwZAAAAAOCqcOLmDOh5SoDkQGZMe0IrC8SA&co=aHR0cHM6Ly9kYXRhLXByb2ZpdHMuY29tOjQ0Mw..&hl=en&v=rKbTvxTxwcw5VqzrtN-ICwWt&theme=dark&size=normal&cb=gmsxxv3fzqyl