FMCG Demand Forecasting

FMCG Demand Forecasting

I realized that demand planning role is very essential in each business, it has the ability to change the business into the right road of growth drastically if the below factors are rightly maintained:

1-Understanding the route to market for business including all the trade channels and the distribution nodes.

2-Understanding the financial language.

3-Crafting a robust S&OP.

4-Understanding the Price index in the market.

5-Identifying all types of promotions either trade promotions or consumer promotions.

6-Having a solid promotional library based on the used forecasting unit including the discount depth and promotions intensity.

7-Baseline generation.

Those are the bottom line factors that should be identified for a successful demand planning department, a department that could fuel for authentic growth.

I had always a phrase that "Demand planning is not"

(Not a Pipeline Department), where Inputs are the same as outputs from sales.

Filtration process should occur, demand planning is the gatekeeper for all the demand flows to the upstream, it's not only a pure analysis but also a lot of factors should be considered here like "Route to market and forecast build-up", for instance, the (Regulars, Promotions, and innovations) build-up.

There are 3 KPI's that are collectively used in corporate life, one of those KPI's "the Third one" is not used primarily across corporate, where i see its very essential KPI.

No alt text provided for this image



1-Forecast Accuracy.

2-Forecast Bias.

3-Forecast Variance.


Do companies forecast their sales on SKU Level?!

The answer is "Yes", but the interesting question here:

Do the discussions happen between the Demand planning and sales team take place on the SKU level?!

The answer most commonly is "No".

Why the discussion is not on the SKU level?!

No alt text provided for this image

Imagine a company runs an enormous amount of products in the portfolio.

1-Time factor:

1-How long it will take to have this discussion?

for sure, a long time.

2-Human effort factor:

Does it worth it with our demand and supply uncertainty to go into those details?!

There is a quote "Forecast will never be right" due to the uncertainty in our VUCA life.

How S&OP discussion happens between the Demand planning and Sales team?!

There are mainly two factors should be identified for the S&OP forecast:

1-Forecasting unit.

2-Forecasting level.

Those are the fundamentals for any forecasting systems used in the S&OP.

1-Forecasting unit:

The forecasting unit is the language that takes a place between the sales team and the demand planning team in the monthly S&OP discussion.

Imagine with me that we have the below Sunsilk shampoo 400 ML ( 7 SKU's)

No alt text provided for this image

How we can drive the discussion in the S&OP?

Should we take it SKU by SKU, it means we will discuss the forecast of 7 products.

How can we solve this to lessen the time taken of discussion?!

This would happen by using the Forecasting unit, so what is the forecasting unit?

To understand the forecasting unit, let's have an overview of the Product Hierarchy.

Product Hierarchy:

Product Hierarchy is simply as a mapping tree to all company products grouping them to higher levels, below are the levels of hierarchy:

Level 1

This is the lowest level which is the (SKU level), for instance, the 7 products of Sunsilk shampoo 400 ML are the SKU's.

Level 2

This level is named as (Format or size level), those 7 SKU's got mapped under a format named as Sunsilk Shampoo 400 ML, so all sales for those 7 SKU's mapped together.

Level 3

It's the (Family group Level), at this level is higher level than format, for instance, in our case will be Sunsilk Shampoo, and to make it clear on the same level could be Sunsilk conditioners, etc....

Level 4

it's the (Brand Level), and in our case will be Sunsilk.

Level 5

This level is the (Category Level), and in our case here will Hair category.

Those are the main levels for the product hierarchy, so what is the forecasting unit again?

The forecasting unit is a selected level from those 5 levels that the company agreed on.

For instance, the S&OP discussion agreed on is (Level 2) which is the (Format level), so the sales team and demand planning team will discuss Sunsilk shampoo 400 Ml mapped under it 7 Sku's, so time is saved instead of talking SKU by SKU.

2-Forecasting Level:

We identified the discussion of the products will be done on which level.

Now we know the forecasting unit, next how can we forecast on the customer level?!

Do the discussions happen between the Demand planning and sales team take place on a customer level?!

No alt text provided for this image

The answer is obvious "No", then how the S&OP discussion takes place.

it takes place mainly based on the sales team's structure inside the company.

There are 2 main structures :

1- Channel structure:

The channels are defined based on the company's direction, for instance there are three main channels in FMCG which are:

A- Modern Trade Channel.

B-Traditional Trade channel.

C-Pharmacy Channel.

For each channel, there is a channel sales head who drives the sales across.

Under each channel, there is a Customer mapped under those channels which we call it (Customer Hierarchy).

2-Geographical structure:

Sales managers here are named as (Country or regional manager) based on the companies direction.

And those Country managers are in charge of all Channels in this country (Modern trade, traditional trade, and pharmacy).

let's have the final example for the same Sunsilk:

if I have 3 Channel manager (Modern trade, Traditional trade, and pharmacy).

So there will be 3 discussions on Sunsilk shampoo 400 Ml with each channel manager, and after agreeing on the Format forecast for each channel, a proportional factor will be taken based on the channel historical sales.

You Do Make a Difference.

Iftikhar Ahmed

Planning Supervisor | Supply Chain | M.Eng | APICS - CPIM, SAP S/4HANA

4 年

Ahmed khaled Great Article? Keep it up.?

Giuseppe Longo

Regional Supply Chain Director

4 年

good reading! thank you Ahmed

Anass El Khaouli ? CSCP ?

Certified Supply Chain Professional with expertise in Sourcing, Procurement, Planning & Logistics

4 年

Thank you for sharing this insightful article Mr. Ahmed khaled

Yousuf Jamal S.

Senior Associate | IFRS Expertise | Data Analysis Skills | External Audit Liaison | Driven for Organizational Financial Growth

4 年

Appreciate for the post

要查看或添加评论,请登录

Ahmed Khaled的更多文章

  • The 4 Levels of Thought Leadership Networking Strategy

    The 4 Levels of Thought Leadership Networking Strategy

    As a director or C-suite executive, your ability to build a network of influential decision-makers can define the…

    5 条评论
  • Momentum Mindset Program

    Momentum Mindset Program

    $1,000,000,000 companies are laying off their employees -Google (12,000 employees). -Unilever (7500 employees).

    5 条评论
  • Corporate Vs Thought Leaders on Linkedin

    Corporate Vs Thought Leaders on Linkedin

    Thought leadership will be always above Corporate leadership. It's not about the titles.

    21 条评论
  • Episode #1 (Branding Vs Bragging)

    Episode #1 (Branding Vs Bragging)

    In the bustling world of LinkedIn, where every post competes for attention, how do you ensure your voice stands out…

    14 条评论
  • Thought Leadership Branding Lounge Podcast

    Thought Leadership Branding Lounge Podcast

    Are you a leader and looking to lead with Impact in your industry? Are you a leader who's looking to be visible to the…

    11 条评论
  • Personal Branding vs. personal bragging, Which one do you select?

    Personal Branding vs. personal bragging, Which one do you select?

    Join me for an insightful audio event where we delve into the art of personal branding and its fine line with personal…

    13 条评论
  • 5 Reasons to Share Your Experience on linkedin

    5 Reasons to Share Your Experience on linkedin

    Catch me live tomorrow at 8:00 PM Dubai time where I will share with you the 5 reasons why do you need to share your…

    16 条评论
  • Elevate Your Corporate Persona

    Elevate Your Corporate Persona

    I will be going audio live every Tuesday on LinkedIn to help and guide Corporate leaders on building their personal…

    21 条评论
  • From Startup To Standout Episode

    From Startup To Standout Episode

    Listen to the first episode here: As the sun sets on another week, it's the perfect time for a moment of reflection and…

    16 条评论
  • Free Live Webinar (Build Your Personal Brand on LinkedIn)

    Free Live Webinar (Build Your Personal Brand on LinkedIn)

    Join my FREE Live Webinar (Build your personal brand on Linkedin). I am going to go live via Zoom webinar on 24th Jan…

    13 条评论

社区洞察

其他会员也浏览了