May 17, 2020

Achieving the future of demand planning

prediction software
demand planning
Stock Keep
Freddie Pierce
4 min
Demand planning
Robert Byrne, CEO of Terra Technology Despite calls for supply chain rationalisation in recent years, networks have become increasingly complex with mo...

Robert Byrne, CEO of Terra Technology

Despite calls for supply chain rationalisation in recent years, networks have become increasingly complex with more locations and continued SKU (Stock Keeping Unit) proliferation.

For planners, market uncertainty has compounded the problem, making forecasting the most challenging in decades. Fortunately, the amount of supply chain data available to manufacturers, both from their operations and from trading partners, has also grown exponentially. Within these masses of data, each individual data point contains small but valuable information about the current state of demand that can be unlocked to provide the most likely prediction of future demand for any planning horizon. 

Since the advent of Holt-Winters exponential smoothing in the 1950s, there has been little innovation in the fundamental techniques used to forecast demand.  During that time, many areas of the economy, such as the Internet, mobile communications and social media have undergone transformational change, sometimes more than once. 

While computer platforms used for forecasting have grown faster and more powerful, the underlying algorithms remain essentially unchanged. Most forecasting software in use today was designed for hardware capabilities of 30 years ago.  It’s time to upgrade planning software to take advantage of today’s technology. 

Developing the right tools

At a recent conference, Kellogg summed this issue up by explaining that there is a difference between simply having tools and having the right tools. They stressed that predicting demand is about making the right choices, and that includes tools, processes, and partners. To succeed, companies need the right tools. This transformation is already underway with automated pattern recognition software that uses better math and more data to sense demand, without relying on the assumption that history will reoccur.

In contrast, traditional forecasting engines use time-series methods founded on the premise that history does indeed repeat itself. This is rarely the case, even for stable products with long shipment histories. Promotions are effective at driving sales, but introduce complexity by distorting past shipment distributions. Innovation in the form of new products has no history whatsoever, which is problematic for time-series techniques since they require a minimum of two years data for the most basic analysis. 

With up to 50 percent of items for consumer products companies having less than two years of history, this can be challenging. Even small product changes like a new colour, scent or package size require labour-intensive mapping to get meaningful results.  Additionally, changing consumer preferences in response to economic pressures, new mobile technologies or weather-related disruptions like Superstorm Sandy all combine to make last year’s shipments a poor predictor of future sales. 

 Automation is the answer

Automation is at the heart of any system that senses demand. The sheer scale of data at multinational manufacturers quickly surpasses human capabilities to process, let alone comprehend.  For example, a manufacturer selling 500 items through Walmart’s 3,800 stores receives almost 2 million new data points every day through Retail Link – just for its North American business with Walmart.

This requires an army of planners to manage if forecasts are updated on a regular basis. More often, planners focus their limited resources on important fast-moving items and high-profile promotions because they don’t have time to do everything. Findings from an annual forecasting benchmark study,encompassing one third of consumer packaged goods volume in North America, confirm this reality.

Forecast error for the slowest-moving products (which represent 80% of all items but only 20% of volume) is 1.6 times higher than for the fastest-moving products (2% of all items representing 20% of volume).  While understandable from a human resource perspective, this prioritisation creates less than ideal business results considering the large capital investment in inventory for 80% of a company’s items. Addressing this gap is a clear opportunity for automation. 

Unlike their human counterparts, software that senses demand using automated pattern recognition algorithms is particularly well-suited for the computationally-intense and mind-numbingly repetitive tasks of crunching data and finding correlations for the entire business. 

At some of the world’s largest companies, near-term forecasts are updated daily and published directly into supply planning systems to adjust manufacturing and deployment in time to respond to unexpected lifts or downturns in markets.  For long-term horizons, automated pattern recognition provides companies with a better starting point for their demand planning process. 

Its robust statistical baseline removes the need for planners to individually tune and curve-fit each model, reapply forecast adjustments from prior reviews and account for mathematically-complex interactions like promotion cannibalisation or similar item matching.  This frees planners to focus on important business areas that require human knowledge like strategic planning and promotional activities.


By upgrading demand prediction software to do what machines are capable of today, companies are breaking free from the traditional time-series methods that have held back industry in recent years.  It is an important step towards realising the promise of the digital supply chain and the future of demand planning – paving the way for better planner and S&OP productivity, better cash flow and return on capital with less unnecessary inventory and the competitive advantage of an agile supply chain that can quickly respond to unexpected market opportunities. 

Share article

Jun 10, 2021

Will Public Procurement Budgets Increase in 2021?

3 min
Often overlooked, government procurement professionals will play a critical role in helping communities, and local businesses recover from the pandemic

Procurement is more than just a private enterprise. COVID-19 reminded us that sourcing materials is an essential part of the government’s role. Throughout 2022, tiny departments sourced massive amounts of personal protective equipment (PPE), medical supplies, and emergency vaccines and testing kits. Even non-procurement professionals were pulled into the fray, as frantic timelines demanded nothing less. 

According to Celeste Frye, co-founder and CEO of Public Works Partners, the crisis brought procurement to the attention of skilled employees who had never considered it. As non-procurement personnel stepped up to help their coworkers, many found that they’d stumbled upon a critical and rewarding job. “Existing public employees have seen the essential nature of the work”, Frye said. “[They’ve] gained some critical skills and possibly [grown] interested in pursuing procurement as a longer-term career”. 

Small, Local Suppliers Take Charge

Frye, whose firm helps organisations engage stakeholders and develop long-term procurement strategies, thinks it well worth the effort to open one’s mind to new opportunities. Cooperative contracts, for instance, can help public departments and municipalities save money, time, and effort. By joining together with other towns or cities in the region, public procurement teams aggregate their purchasing power and can drive better deals. 

These cooperative contracts have the added benefit of advancing equity. Smaller suppliers that struggle to compete with established firms for government contracts can act as subcontractors, helping big suppliers fulfil bits of the project. Once they get their foot in the door, small, local, and disadvantaged suppliers can then leverage that government relationship to take on additional projects. 

Especially as governments start to pay attention to procurement resilience, public procurement departments must expand their requests for proposals (RFPs) to take into account innovative solutions and diverse suppliers. According to Frye, Public Works Partners—a certified female-owned firm—has benefitted from local and state requirements that specify diversity. 

Post-Pandemic Funding Swells Procurement Budgets 

And the pandemic won’t be the end of it. City governments need to build sustainable energy infrastructure such as solar panels, charging stations, and recycling plants, ensure that masks and medicines are never in short supply, and source new technologies to keep up with cloud and cybersecurity concerns. 

Public procurement budgets will likely increase to match demand. As Peter Ware, Partner and Head of Government at Browne Jacobson, explained, “in a non-pandemic world, the [U.K.] government spends on average around £290 billion on outsourced services, goods, and works...anywhere between 10% and 14% of Gross Domestic Product (GDP). Post-pandemic, city procurement will only increase as national governments provide local divisions with emergency funding.
And in truth, government employees might jump at the opportunity. Frye noted that public procurement could give immediate feedback on new programmes: “[Procurement] is where new laws and policies ‘hit the road’ and are implemented”, she said. “Professionals in these fields get the satisfaction of creating real change and seeing quantifiable outcomes of their work”.

Share article