" /> Flowcasting: August 2007 Archives

« July 2007 | Main | September 2007 »

August 30, 2007

Process, not data or tools

Not to sound like a broken record, Flowcasting is a business process supported by information and tools. To make it successful and sustainable you'll need to think through how promotions will work, product introductions and discontinuations, etc. across your extended supply chain.

Here's an interesting piece that supports our process first mentality:

From "Clobberation" to Collaboration

Lori Mitchell-Keller also believes that greater collaboration is increasingly a requirement in the retail supply chain, and she says that consumers' capricious nature makes this sort of closer retailer-supplier relationship more of a necessity. As evidence, Mitchell-Keller, who is senior vice president of global marketing and solution management at supply chain solution provider Manugistics, points to a survey, commissioned by her company and unveiled at the National Retail Federation conference, which revealed that during the most recent holiday season 58 percent of Americans who did not find the item they were shopping for on the shelf at one store walked out the door and went elsewhere. (Similarly, Stephen David, chief information officer and business-to-business officer at Cincinnati, Ohio-based Procter & Gamble, has cited figures suggesting that 75 percent of the time, out-of-stocks result in no sale.) ...

But Mitchell-Keller cautions that just having the right tool in place at either the retailer or the supplier is not enough, and she warns of the danger of "clobberation," a term that she says a colleague at Manugistics uses to describe situations in which a "channel master" uses its 800-pound-gorilla status to force its own terms and conditions on its trading partners. A retailer may achieve some level of benefit by throwing massive amounts of POS data "over the wall" and mandating that suppliers run the data through an analytical tool to ensure high in-stock levels. However, the retailers and suppliers would be better served by creating a collaborative work process to reach a shared understanding of what the data mean. "It's not just a matter of one portion of the supply chain having the data and one portion of the supply chain having the tools. It really is a matter of the extended network using those tools and the data in combination," Mitchell-Keller concludes.

To read the full article, click here.

August 27, 2007

Innovation vs Complexity

Here's a great Harvard Business Review article from 2005, courtesy of my SAP Business Flash newsletter. The article - Innovation versus Complexity: What Is Too Much of a Good Thing? by Mark Gottfredson and Keith Aspenall - discusses the true costs of complexity and explains how organizations can define their "innovation fulcrum" to create a customer offering that is both complete and profitable. A 10-page PDF that's a great read for retailers and manufacturers alike.

August 25, 2007

The New Retail Supply Chain

The retail supply chain now extends all the way to the retail shelf.

We came across a great article that talks about the shift in thinking that's happening in retail supply chain management. Here's a snippet:

"In the old way of doing things, retailers replenished warehouses based on predetermined reorder points after inventory was shipped out of the warehouse (see diagram). "What you really need to do is bring in the items you need to support the store based on promotions, seasonality and what's selling," says Bowen. "Retailers are trying to get to the point where consumer demand in the stores is driving the replenishment activities in the warehouse.""

Click here to read the entire article.

August 01, 2007

The Myth of Large Numbers

“Did you hear about the 6 foot tall man who tried to walk across a lake with an average depth of 4 feet? He drowned." - Author Unknown

Jakob_Bernoulli.jpg

Jakob Bernoulli (1645-1705) was a Swiss mathematician and is credited with Bernoulli’s Law, known more colloquially as the “Law of Large Numbers” (not to be confused with Daniel Bernoulli’s Law from the realm of physics, which has to do with lift and fluid dynamics).

The law simply states that the more times you repeat a random event, such as flipping a coin or rolling a die, the outcomes will trend closer and closer to the theoretical average. Bernoulli described his law as being “so simple that even the stupidest man instinctively knows it is true.”

We’ve heard the same argument at least a dozen times since Flowcasting the Retail Supply Chain was released last year: Why would you even suggest forecasting weekly item demand at store level? Aren’t aggregate forecasts of larger numbers more accurate?

This viewpoint is best summed up in an online e-book (provocatively titled “What Jessica Simpson Has to Teach Supply Chain Executives”) that is semi-critical of Flowcasting:

“While Flowcasting validates the importance of the store, having a forecast model at the store level is ridiculous. This is where a forecast is the least accurate. Can you imagine the devastation to a business if it tried to forecast the purchase of each SKU at a store level? Basic statistics show that forecasts are most accurate at a consolidated level, such as a country or distribution center, and even still cause inordinate levels of shortages and excess inventory.”

In other words, why is it that we haven’t grasped “what the stupidest man instinctively knows is true”?

This line of reasoning betrays a fundamental and critical flaw in thinking when it comes to forecasting in the retail supply chain.

We’re not saying that forecasts of aggregate demand aren’t more accurate than the far more granular forecasts we advocate in Flowcasting – they most assuredly are. We’re just saying that this fact is completely irrelevant.

Retail out-of-stocks have been stubbornly stuck at 8% since they started measuring it (15% when an item is promoted). The methods and samples vary, but all of the major studies* point to store level forecasting and replenishment practices as the primary cause for the out-of-stocks.

So, given the fact that: 1) consumer demand occurs by item by day at store level; 2) retail out-of-stocks occur by item by day at store level and; 3) the root cause of the out-of-stocks has been shown to be at store level, what’s the purpose of producing “more accurate” demand forecasts at aggregate levels?

If you take the aggregation argument to its logical conclusion, you would just forecast annual GDP for your country as a whole. When you aggregate that much, a ton of random variation would be smoothed out and you’d surely get error rates in fractions of a percent. But how would you use it to run a retail business where consumers are buying particular items in particular stores on particular days?

In our opinion, the lack of effort and thought about store level forecasting and replenishment practices over the last decade – despite strong evidence that this is where the opportunity lies (everyone seemed to be hiding behind the Law of Large Numbers) - is the main reason why out-of-stocks haven’t budged.

A view from 10,000 feet may be beautiful and majestic, but it doesn’t help you when you’re looking for a needle in a haystack.


* “Where to Look for Incremental Sales Gains – The Retail Problem of Out-of-Stock Merchandise”, a 1996 study conducted by Andersen Consulting for the Coca-Cola Retailing Research Council, “Retail Out-of-Stocks: A Worldwide Examination of Extent, Causes and Consumer Responses” conducted by the Food Marketing Institute and Grocery Manufacturers of America in 2002 and most recently “Improve OOS Methods at the Shelf”, a 2006 study by Tom Gruen from University of Colorado and Daniel Corsten from London Business School.