Is the juice worth the squeeze?


A little over 10 years ago I was on a project to help one of Canada’s largest grocery and general merchandise retailers design and implement new planning processes and technology. My role was the co-lead of the Integrated Planning, Forecasting & Replenishment Team and, shockingly, we ended up with a Flowcasting-like design.

The company was engaged in a massive supply chain transformation and the planning component was only one piece of the puzzle. As a result of this, one of the world’s preeminent consulting firms, Accenture, was retained to help oversee and guide the entire program.

One of the partners leading the transformation was a chap named Gary. Gary was a sports lover, a really decent person, great communicator and good listener. He also had a number of “southern sayings” – nuggets of wisdom gleaned from growing up in the southern United States.

One of his saying’s that’s always stuck with me is his question, “is the juice worth the squeeze?”, alluding to the fact that sometimes the result is not worth the effort.

I can remember the exact situation when this comment first surfaced. We were trying to help him understand that even for slow and very slow selling items, creating a long term forecast by item/store was not only worth the squeeze, but also critical. As loyal and devoted Flowcasting disciples know this is needed for planning completeness and to be able to provide a valid simulation of reality and work to a single set of numbers – two fundamental principles of Flowcasting.

The good news was that our colleague did eventually listen to us and understood that the squeeze was not too onerous and today, this client is planning and using Flowcasting – for all items, regardless of sales velocity.

But Gary’s question is an instructive one and one that I’ve been pondering quite a bit recently, particularly with respect to demand planning. Let me explain.

The progress that’s been made by leading technology vendors in forecasting by item/store has been impressive. The leading solutions essentially utilize a unified model/approach (sometimes based on AI/ML, and in other cases not), essentially allowing demand planners to largely take their hands off the wheel in terms of generating a baseline forecast.

The implications of this are significant as it allows the work of demand planning to be more focused and value added – that is, instead of learning and tuning forecasting models, they are working with Merchants and Leaders to develop and implement programs and strategies to drive sales and customer loyalty.

But, I think, perhaps we might be reaching the point where we’re too consumed with trying to squeeze the same orange.

My point is how much better, or more accurate, can you make an item/store forecast when most retailers’ assortments have 60%+ items selling less than 26 units per year, by item/store? It’s a diminishing return for sure.

Delivering exceptional levels of daily in-stock and inventory performance is not solely governed by the forecast. Integrating and seamlessly connecting the supply chain from the item/store forecast to factory is, at this stage, I believe, even more crucial.

Of course, I’m talking about the seamless integration of arrival-based, time-phased, planned shipments from consumption to supply, and updated daily (or even in real time if needed) based on the latest sales and inventory information. This allows all partners in the supply chain to work to a single set of numbers and provides the foundation to make meaningful and impactful improvements in lead times and ordering parameters that impede product flow.

The leading solutions and enabling processes need to produce a decent and reasonable forecast, but that’s not what’s going to make a difference, in my opinion. The big difference, now, will be in planning flexibility and agility – for example, how early and easily supply issues can be surfaced and resolved and/or demand re-mapped to supply.

You and your team can work hard on trying to squeeze an extra 1-3% in terms of forecast accuracy. You could also work to ensure planning flexibility and agility. Or you could work hard on both.

It’s a bit like trying to get great orange juice. To get the best juice, you need to squeeze the right oranges.

Which ones are you squeezing?

Marketplace Perceptions Rarely Reflect Reality (at least in this case)


What’s wrong with this picture?

Back in 2014, Lora Cecere (a well-regarded supply chain consultant, researcher and blogger) wrote a post called Preparing for the Third Act. She said “JDA has used the maintenance stream from customers as an annuity income base with very little innovation into manufacturing applications. While there has been some funding of retail applications, customers are disappointed.”

Our experience is consistent with Lora’s assessment. We’ve been working in the trenches on this for the last 20 years and that opinion is also shared by many of our colleagues in the consulting ranks.

In fact, we have first-hand experience with customers who have been disappointed and with customers who are delighted. That puts us in a unique position.

What’s going on now makes no sense. You can buy the software that disappoints, but you can’t buy the software that does not disappoint. To make things even more absurd, the same company (JDA) has both software packages in its stable.

Retailers agree that planning all of their inventory and supply chain resources based on a forecast of sales at the retail shelf makes perfect sense. Additionally, manufacturers agree that getting time-phased replenishment schedules based on those plans from their retail customers provides significant additional value across the extended supply chain.

But because you can only buy the software that disappoints, most of the implementations will likewise be disappointing. Consequently, the perception of these systems in the marketplace is fairly negative.

It shouldn’t be. These systems can work very well.

First, a brief history of where this all started and how we got where we are today.

Initially, retailers had a choice between time-phased planning software designed for the manufacturing/distribution market or software designed for retail that couldn’t do time-phased planning.

Later, software was developed specifically for the mission: time-phased planning at store level. It could handle gigantic data volumes economically, is easy to use and easy to implement. It’s suitable for a small company (a handful of stores) and has been tested with volumes up to 450 million item/store combinations on inexpensive hardware.

Unsurprisingly, a square peg forced into a round hole (systems initially designed for use in manufacturing plants and distribution centres being applied to store level) yielded the disappointing results.

Also unsurprisingly, a system designed specifically to plan from store level back to manufacturers works just fine. In fact, our client (a mid-market Canadian hard goods retailer) is now planning every item at every store and DC, sharing schedules with suppliers, managing capacities and achieving extraordinary business results.

No doubt, the problem has been solved.

So what’s the path forward?

It’s in everybody’s best interest to work together.

From JDA’s perspective, this is a new wide-open market for them – and it’s enormous. But it won’t be developed if the marketplace perceives that implementing these systems delivers disappointing results.

In the event that JDA were to develop a new system with new technology and features appropriate to a retail business, they still need to build it, sell it to some early adopters, get it working well and rack up a few unequivocal success stories before they can begin to overcome the current level of customer disappointment.

How long will all of that take? An optimistic estimate would be 2 years. A realistic one is more like 3-5 years. Will there still be a market then?

From the retailer’s and manufacturer’s perspective, they can be saving tens to hundreds of millions of dollars per year (depending on size) and providing a superior consumer experience.

From the consultant’s point of view (the people who recommend and implement these systems for a living), having the ability to implement the software that isn’t being sold – but has been proven to work  will increase the number of implementations with outstanding results (rather than disappointing results). The net effect of this is that JDA will have more revenue and more success than if they continue to keep this software off the market. JDA has made this type of arrangement with other partners to their mutual benefit, without head-butting or causing confusion in the marketplace.

It could be that JDA is too close to the problem to see this as a solution.

Maybe Blackstone can look at situations like this more objectively and without bias, unencumbered from all that’s transpired to date.