Call: (516) 609-5000     Toll-Free: (855) 977-7100

Ahead In The Cloud

The Business Solution Partners Blog

What are the advantages of Bottom-Up Planning for CPG?

Written by Ron Rubens | Nov 10, 2023 9:58:13 AM

Topics: NetSuite, Blog Post

In the dynamic landscape of the consumer packaged goods (CPG) industry, strategic planning plays a pivotal role in achieving sustainable growth and market success. Amidst various planning methodologies, the spotlight is increasingly turning towards bottom-up planning as a transformative approach for CPG companies.

Unlike traditional top-down strategies, bottom-up planning empowers organizations by harnessing insights from the ground level, involving frontline teams, and leveraging real-time data.

Let's explore the forecasting challenges facing CPG organizations, and uncover the advantages of adopting a bottom-up planning approach in the CPG sector - enhancing agility, responsiveness, and innovation within companies, ultimately driving competitive advantage in an ever-evolving market. From fostering cross-functional collaboration to optimizing resource allocation, we delve into the nuances of how this strategic paradigm shift can reshape the future trajectory of CPG businesses.

Here are some observations for the CPG industry that create forecasting challenges:

  • The timing and frequency of trade promotions dramatically impact how much you sell in any given week or month.  Unlike some industries which have a steady, predictable business, CPG is highly driven by promotional events.  Rebates, MCBs, discounts and allowances impact how much you need to manufacture, and they impact your financial statements.
  • Promotions are unique to individual customers, in lift, timing, and financial impact.  The era of a national trade promotions across all customers is a relic of the last century.
  • Your sales team is most knowledgeable about customer promotions because they negotiate these deals with customer.   
  • Top customers can be a significant share of a company’s business, so promotions at one customer can dramatically change the demand plan and impact the company’s P&Ls.
  • You can't always use shipments to track your promotion results.  You don't ship to indirect customers because they buy through a distributor.   For direct customers, you may have shipped the product weeks or months before the promotion dates.
  • Trade promotion timing changes often, and with short-notice.  This makes it more difficult do accurate long-range forecasting.

Here are some of the advantages of a bottom-up approach that address many of the CPG industry forecasting challenges:

  • topdownThe forecast is created by customer and promotion, the level at where promotional timing, frequency and lift is more accurate.

  • You can plan promotions for indirect customers, and for promotions where there is a disconnect between sell-in and sell-through.

  • The forecast is generated by the sales team, which has more accurate knowledge about the timing, frequency and lift of promotions.

  • This bottom-up forecast can be used to help validate a top-down forecast generated mathematically by a demand planning solution.

    Demand planning modules can utilize some of the promotional information from the bottom-up forecast as independent variables to create a more accurate forecast model from historical data. The demand planning forecast will also be more accurate because the promotional coefficients will be applied based on more accrual deal timing of future deals.

  • You can your sales team improve promotional forecasting accuracy by using syndicated data like IRI or AC Nielsen, SPINS, POS and/or other third-party data.  To see an improvement in forecasting accuracy, you don’t have to buy data for all your customers.   Consider focusing on your top volume customers.

Ready to master your trade promotions?  Click here to schedule a call with a subject matter expert

Written by Ron Rubens

Since 2014, Ron has been a go-to expert for companies navigating their ERP challenges. Leveraging his entrepreneurial acumen and tech savvy, he offers empathetic insights into the issues businesses face, delivering actionable solutions.

Subscribe To Our Blog

Netsuite Pricing Calculator

Select your scope, answer a few questions, and we will quote a price for NetSuite based on your unique business needs.

View Our Packages

Connect With BSP on LinkedIn

Meet our team of experts, and find out about our latest articles, tutorials, and webinars.

Connect Now

Subscribe to BSP’s YouTube Channel

Learn more about leveraging ERPs to streamline your business with our video tutorials, recorded webinars, and virtual summits.

Subscribe & Set Alerts Now

Recent Posts