This could be the end of forecast error

Supply chain execution software supplier RedPrairie believes a technique called flowcasting can solve one of  the most difficult problems confronting consumer goods manufacturers: How to keep excess inventory out of the supply chain without leaving retail customers short of needed merchandise.

08/19/2009


Supply chain execution software supplier RedPrairie believes it has discovered the answer to perhaps the most difficult problem confronting consumer goods manufacturers: How to keep excess inventory out of the supply chain without leaving retail customers short of needed merchandise.

The answer, according to RedPrairie, is a technique called flowcasting. The technique was developed by Andre Martin and Darryl Landvater, two entrepreneurs who have spent their careers attacking various supply chain problems.
They have devoted the past decade to developing technology to support the concept of flowcasting, which Landvater describes as store-level distribution requirements planning (DRP).
Typically, DRP takes place at distribution centers, with planners using various techniques and technologies-most based on statistical forecasting -to determine the level and mix of inventory to keep retail stores adequately stocked without busting the corporate budget.
"Trying to do forecasting at the DC level is like sitting behind a wall and trying to figure out what's happening on the other side by looking at what's occasionally thrown over on your side, which in this case would be orders," Landvater said in a recent interview. "We're breaking down that wall."
With flowcasting, the retailer must agree to feed the manufacturer point-of-sale data on all transactions in its stores. Tracking sold goods backward through the supply chain gives the manufacturer a clear picture of not only what goods are selling but which DCs and plants those goods came from. The manufacturer can then use that information to predict when and where its next group of orders will originate.
So far, Martin and Landvater can only count one pilot implementation of their flowcasting solution, but the companies involved—Sam's Club and one of its large consumer packaged goods suppliers—provide instant credibility. In fact, RedPrairie believes so strongly in the concept that it recently formed the RedPrairie Collaborative Forecasting Group , a joint venture that calls for adding the application Martin and Landvater developed to the RedPrairie supply chain execution software portfolio.
The new entity is targeting customers in food and beverage, consumer packaged goods, consumer electronics, and high-volume retailers. Like the pilot, this venture represents a coup for Martin and Landvater, who for years struggled to get anyone in the industry to take the concept of flowcasting seriously.
"We went to all of the DRP software suppliers and said,‘You should work at the store level," Landvater recalls. "They told us we were nuts; that no program could handle the volume [of goods flowing through retail stores]. Our choices were to give up or prove that it could be done. So, in a somewhat radical move, we created a piece of software that proved it could be done."
Next came the pilot, in which the software plans the flow of 115 items from 40 distribution centers to 20 Sam's Club distribution centers and 599 Sam's Club stores.
In the 1.5 years this pilot has been running, Sam's Club has increased inventory turns while reducing stock outs. The packaged goods manufacturer has taken significant inventory out of the overall supply chain and dramatically cut safety stock levels.
"The work we've done with [with the pilot] is outstanding," Landvater declared." We're able to predict orders from the ship-to location level. We can predict when an order from a given DC would go to [the manufacturer] a month in advance. The average absolute error is 2 to 3 days. That's so much better than statistical forecasting."



No comments
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by...
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Big Data and IIoT value; Monitoring Big Data; Robotics safety standards and programming; Learning about PID
Motor specification guidelines; Understanding multivariable control; Improving a safety instrumented system; 2017 Engineers' Choice Award Winners
Selecting the best controller from several viewpoints; System integrator advice for the IIoT; TSN and real-time Ethernet; Questions to ask when selecting a VFD; Action items for an aging PLC/DCS
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.
Motion control advances and solutions can help with machine control, automated control on assembly lines, integration of robotics and automation, and machine safety.
This article collection contains several articles on the Industrial Internet of Things (IIoT) and how it is transforming manufacturing.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Future of oil and gas projects; Reservoir models; The importance of SCADA to oil and gas
Big Data and bigger solutions; Tablet technologies; SCADA developments
SCADA at the junction, Managing risk through maintenance, Moving at the speed of data
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
click me