- Franklin Morris
Given how important demand planning is, you’d think consumer goods manufacturers are using really advanced tools for it, right? Especially in consumer electronics, where many companies are based in Silicon Valley and pushing the boundaries of technology in their own products.
Late last year, Kristin Markworth, one of Alloy’s strategic advisors, set out to help us research this hypothesis, and the result was surprising, if not unexpected. Kristin is a 20+ year veteran in consumer electronics. She was most recently VP of Sales and Sales Operations at GoPro, where she went on her own journey implementing planning processes and tools. To answer this question, she met with demand planners at a half-dozen consumer electronics companies, from Fortune 100 brands to digital-native upstarts, and heard a consistent story at each.
The most popular planning software? Microsoft Excel.
And, no one was happy with the tool they were using. Those who relied on Excel were frustrated with the time involved. Those with other tools did not like them and had either abandoned them altogether or worked primarily outside the tool to analyze the business — often by exporting data to Excel.
Several common reasons came up as to why Excel remains the most used software.
1. Trust and Transparency
Some teams or individuals have a hard time trusting a tool to produce more accurate forecasts than what they can create in Excel. They look at the tool as a “black box” that takes away the planner’s ability to see the nuances in the data that impact the bigger picture. Because the methodologies used to produce the forecast for planning are unclear, it becomes a challenge for them to explain or determine what happened when actuals inevitably do not match plans.
Without this visibility, teams also find it difficult to do scenario analysis. They need to make decisions like whether to change price or cancel a promo, but can only do so if solid scenarios are available. The lack of transparency into the factors behind a forecast thus limits its usefulness.
2. Budget and ROI
Other teams might want a purpose-built forecasting or planning tool, but simply cannot afford it or justify the expense. Budget is a common reason why companies opt for Excel. A robust planning solution itself can be pricey, but add on the onboarding and data integration consultants, and you have a whole other level of cost and burden on the company’s resources.
Quantifying the ROI of a tool is often difficult and time-consuming, making it challenging for teams to justify the expense to management.
3. Change Management
Say a company wants a tool and has the budget. It should be smooth sailing, right?
Consumer goods brands vary greatly in several key factors, including which function owns demand forecasting and planning, where the necessary data lives, and how it’s siloed, what processes are followed (which within a company are constantly morphing or changing), what terminology and KPIs are used, and how they’re defined, and of course, how demand changes. All these differences create a lot of frustration for the team trying to implement any new tool. While software may be based on best-in-class workflows, it likely still doesn’t match exactly what the company is currently doing. Without proper change management, users will resist changes to existing processes, and adoption of the tool will be limited.
4. Ongoing Support and TCO
Finally, even if the initial implementation goes well, other issues that arise as a company grows or changes can lead it to abandon a tool.
- As the business evolves, teams may ask for changes to the tool to continue to meet their needs. These requests can result in costly change orders, which cause many budget owners to take pause. They may decide the added investment isn’t worth it and don’t go through with the changes. Eventually, users stop using the tool since it no longer serves their needs well.
- Another reason teams abandon tools after implementation is the need for a super user trained on the tool’s nuances. That resource is required to train and onboard new team members and serve as a troubleshooter for the general team because the tool is too technical for a typical user to learn and resolve issues on their own. Having a headcount focused heavily on support is often more than companies bargained for, and it’s not always easy to find someone with this skill set outside of IT.
Most demand planners we’ve spoken to want a more accurate forecast and would love a tool to help them. But only if it offers good value, allows them to do ad-hoc analysis and scenario analysis, the methodologies used are transparent, and it is simple enough that they don’t need several days of training and a super user to leverage it effectively.
We also believe it’s important for a tool to provide a reasonable ROI, taking into account the Total Cost of Ownership. Those touting unrealistic levels of forecast improvement do themselves and the planners a disservice. Decision-makers need real examples of how the tool pays for itself in terms of value drivers like inventory savings, additional sales opportunities, and reduced loads on existing headcount, not just bold claims of how “black box” artificial intelligence will lead to major leaps in forecast accuracy.
Franklin Morris
Franklin Morris is Vice President and Head of Global Marketing at Alloy.ai. He's spent his career leading brand, content and demand generation marketing for high-growth startups, ad agencies, and Fortune 50 giants, including IBM, Dell, Oracle, Rackspace, 3M, Facebook, Electronic Arts, Informatica, Sisense, and Argo Group.
Retailer POS Forecast Dashboard Demo Video
Watch Alloy.ai’s POS Forecast demo: demand-sensing forecasts, forward-looking WoS, weekly backtesting, and exports to planning systems to prevent stockouts.
Collaborative Replenishment Dashboard Demo Video
Watch the Alloy.ai Collaborative Replenishment demo to see how you can surface current and chronic out-of-stocks and phantom inventory, and align with retail partners to…
Cross-Retailer Scorecard Demo – Monitoring Inventory & Sales Trends Across Retailers
Watch Alloy.ai’s Cross-Retailer Scorecard demo to compare retailer performance weekly, spot outliers fast, and drill from partner to location to SKU to act fast.
The Alloy.ai Launchpad
Distilling messy data from multiple sources starts here. See a video overview of Alloy.ai’s launchpad — a single hub for your sales and inventory performance,…
The Consumer Goods Guide to Modern Commerce
Everything a consumer brand needs to grow: sales channels, retail partnerships, eCommerce, omnichannel strategy, and operational playbooks — no fluff.
Marketing & Brand Building for Consumer Brands
Behind every great brand is great ops. Learn how to manage cash flow, set smart pricing, optimize margins, and build a supply chain that scales…