Version Control for FMCG Forecasting Beyond Excel

By James Smith on November 3, 2026

version-control-for-fmcg-forecasting-beyond-excel

A collaborative forecasting workflow for an FMCG team starts from one statistical baseline and lets sales, marketing, supply and finance add structured input in the same system, instead of emailing spreadsheets around. Each input is recorded, challenged and measured, because manual adjustments are not always an improvement: a 2025 study found they improved bias and accuracy for only just over half of SKUs. The aim is a consensus number that everyone can trace back to its inputs. Demand teams can watch a consensus cycle run on their own SKUs in a short session.

FMCG Demand Planning · Consensus Forecasting

Four Teams, One Baseline, and a Consensus Nobody Has to Email

iFactory AI, an on-premise industrial AI platform, gathers sales, marketing, supply and finance input in one place and shows which inputs actually improve the number.

Sales
Marketing
Statistical baseline
Consensus forecast
Supply
Finance

What Is Collaborative Forecasting for FMCG Teams?

It is a shared process where each function contributes what it knows, inside one record. Research shows why the process needs measuring, not just meetings.

Just over half
of SKUs improved by manual adjustment in one study (Fildes, Goodwin and De Baets, 2025)
180% to 69%
error after downward overrides, against 54% to 200% after upward ones (Baker, MIT CTL, 2018)
47%
fewer manual overrides in a 2018 SAS test of assisted planning
Forecasting is a team sport only when the rules are shared. Agree the baseline, the entry format and the lock date before the first cycle starts, then hold every team to them equally.

Who Contributes What to the Forecast?

Each team brings real knowledge and a typical bias. Naming both makes the process fairer. Teams can ask for a contribution matrix to adapt to their roles.

TeamBringsTypical Bias to Watch
SalesAccount plans, orders and retailer newsCautious numbers to protect targets (John Galt)
MarketingPromotions, launches and media plansOptimism on new products (John Galt)
SupplyCapacity, constraints and lead timesPlans to what is easy to make
FinanceBudget and margin targetsPulling the forecast toward budget
Bias is a feature of the workflow, not a fault of people. Measure it by team and show it back to them.

What Does a Four-Week Consensus Cycle Look Like?

A fixed rhythm stops the process drifting into endless meetings, and it gives every team the same deadline for input. This is an example cycle to adapt to your own planning window and lock date.

Week 1
Statistical baseline runs and is shared with all teams.
Week 2
Teams add structured inputs with reasons and evidence.
Week 3
Consensus meeting reviews only the contested items.
Week 4
Forecast is approved, locked and sent to supply.

Replace the Email Chain With One Shared Forecast

Share how your teams submit input today. iFactory AI's team will map a consensus cycle with roles, evidence rules and a clear lock date.

Which Inputs Add Value and Which Add Noise?

Forecast value added measures whether each step lowered error. The columns show an illustrative error index, where lower is better. Note that one step makes it worse.






Naive
100
Statistical
78
Plus sales
74
Plus marketing
84
Consensus
76
If a step raises the error, change the step. In the study above, positive adjustments were more likely to worsen performance.

How Should an Override Be Entered?

A structured entry makes every input comparable. Six fields cover it, and the size of the change should be judged against how noisy the item normally is (MIT CTL, 2018).

SKU and period
New value
Size against baseline
Reason code
Evidence attached
Owner who will answer for it

How Do You Settle a Disagreement?

Use a ladder so debates end in evidence, not volume. Teams can see a disagreement ladder in a live cycle with our team.

Step 3Escalate to the S&OP lead for a ruling
Step 2Test the input against its past value added
Step 1Show the evidence behind the change

How Do You Track Bias by Team Over Time?

Track the direction of each team's adjustments, not only the size. A steady lean one way is a bias to coach, and it can be corrected over time (John Galt).

SignalWhat It SuggestsAction
Always adjusts upwardOptimism biasReview launch and promotion assumptions
Always adjusts downwardCaution biasSeparate targets from forecasts
Large, rare changesEvent-driven inputRequire evidence for each
Many small changesNoiseRaise the threshold for entry

How Do You Handle New Launches and Promotions?

These are the items where human knowledge matters most and bias is strongest, so they deserve their own rules.

New launches
Compare with similar past launches
Cap the first-month volume claim
Review after the first four weeks
Promotions
Plan uplift from last comparable event
Record the planned and actual uplift
Adjust the next event from the gap

What Should the Consensus Meeting Cover?

A short agenda keeps the meeting on decisions. Teams can request a meeting agenda template to adapt to their cycle.

Items where inputs disagree with the baseline
Largest value changes since last cycle
Promotions and launches in the window
Supply constraints that cap the plan
Forecast value added by each input
Bias by team since last quarter
Decisions and owners recorded
Lock date and next input deadline
Skip items where everyone agrees with the baseline. Meetings that rewrite every line waste the time that contested items need.

Which Mistakes Break a Collaborative Process?

Inputs by email
Numbers arrive in different formats and nobody can compare them.
Targets as forecasts
Budget numbers replace expected demand and the plan inflates.
No value-added check
Inputs that make the forecast worse are never removed.
Late inputs accepted
The lock date moves, and supply plans on a number that changes.

Where Does iFactory AI Fit in Collaborative Forecasting?

iFactory, an on-premise AI platform for manufacturing, links the shared forecast to the daily replan, so the plant sees the agreed number.

Sales inputMarketing inputSupply constraintsFinance targets

iFactory AI on-premise forecast workspace

Value added by inputBias by teamApproved forecast to the daily replan
Demand lead (illustrative): which team's adjustments lowered error last quarter?
iFactory AI: sales input on key accounts improved accuracy, while marketing uplifts on new launches raised it and are flagged for review.

Expert Review: Judging a Consensus Process

Expert reviewCollaborative forecasting for FMCG
What holds up
A strong statistical baseline, structured input with reasons, and forecast value added measured step by step.
What to verify
That each team's adjustments are tracked for bias, and that contested items, not all items, reach the meeting.
What to avoid
Meetings that rewrite every line, inputs with no reason, and rewarding the loudest voice.
Bottom line: collaborate on the exceptions, and let evidence decide which inputs stay.
Written from established demand planning practice and published forecast value added research.

Frequently Asked Questions

What is collaborative forecasting in FMCG?

It is a shared process where sales, marketing, supply and finance add structured input to a statistical baseline, producing one consensus forecast with a visible trail. It replaces spreadsheets passed by email. See the process on your own SKUs in a short demo.

Do manual adjustments improve forecast accuracy?

Not always. One study found adjustments improved bias and accuracy for only just over half of SKUs, and positive adjustments were more likely to worsen performance (Fildes, Goodwin and De Baets, 2025). Measure your own value added with our team.

How do we stop sales and marketing bias in the forecast?

Record every adjustment with a reason, track its direction by team, and feed the pattern back so the habit changes over time (John Galt). Keep targets separate from forecasts. Ask support for a bias report layout to adapt.

How often should the consensus meeting run?

Most FMCG teams run it monthly with weekly checks on key items, but the right rhythm follows your planning window. Review only contested items, so the meeting stays short. Design your cycle with our planners.

Does iFactory AI replace our planners?

No. Planners and function heads still decide. iFactory AI holds the shared forecast, records every input and shows which ones add value. See how it supports a planner in a walkthrough.

{"@context":"https://schema.org","@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is collaborative forecasting in FMCG?","acceptedAnswer":{"@type":"Answer","text":"It is a shared process where sales, marketing, supply and finance add structured input to a statistical baseline, producing one consensus forecast with a visible trail. It replaces spreadsheets passed by email."}},{"@type":"Question","name":"Do manual adjustments improve forecast accuracy?","acceptedAnswer":{"@type":"Answer","text":"Not always. One study found adjustments improved bias and accuracy for only just over half of SKUs, and positive adjustments were more likely to worsen performance (Fildes, Goodwin and De Baets, 2025)."}},{"@type":"Question","name":"How do we stop sales and marketing bias in the forecast?","acceptedAnswer":{"@type":"Answer","text":"Record every adjustment with a reason, track its direction by team, and feed the pattern back so the habit changes over time (John Galt). Keep targets separate from forecasts."}},{"@type":"Question","name":"How often should the consensus meeting run?","acceptedAnswer":{"@type":"Answer","text":"Most FMCG teams run it monthly with weekly checks on key items, but the right rhythm follows your planning window. Review only contested items, so the meeting stays short."}},{"@type":"Question","name":"Does iFactory AI replace our planners?","acceptedAnswer":{"@type":"Answer","text":"No. Planners and function heads still decide. iFactory AI holds the shared forecast, records every input and shows which ones add value."}}]}

Build One Forecast Every Team Can Trace

See iFactory AI gather sales, marketing, supply and finance input and show which adds value. Book a walkthrough using your own SKUs and calendar.


Share This Story, Choose Your Platform!