Demand Forecasting for CPG Brands: From Guessing to Control

A forecast is not a prediction you hope is right. It is the operating assumption your purchasing, production, cash, and customer promises are built on. Make the assumption visible, update it often, and give every decision an owner.

Jordan Harper, Logic Agency Inc.Updated Sep 202613 min readGuides

Why forecasting breaks as brands scale

Early-stage brands can run on intuition because the founder is close to every order. That stops working when sales split across DTC, wholesale, marketplaces, distributors, and retail. Each channel has different timing, order behavior, and data quality.

The common failure is a single annual number treated as a plan. Operations needs a rolling view by SKU, channel, customer, and month—with a clear distinction between what has been ordered, what is expected, and what is merely hoped for.

Build a forecast people can operate

1

Start with the demand signal

Separate shipped orders, retailer orders, subscriptions, promotions, pipeline, and one-time events. Do not blend committed demand with a sales wish list.

2

Forecast at SKU and channel level

A total-company forecast hides the stockout. Plan the items that actually drive service levels, margin, and production constraints.

3

Add the timing reality

Include production lead time, component lead time, ocean or domestic freight, receiving, QC, and retailer appointment windows.

4

Show a range

Use base, upside, and downside cases. The point is not false precision. It is making the cash and capacity implications of uncertainty visible.

The monthly planning rhythm

A useful forecast is a recurring conversation between sales, finance, marketing, and operations. It does not need enterprise software. It needs a shared file, a calendar, and decisions that do not disappear in a meeting.

Review actuals versus forecast, update the next 90 days, flag supply constraints, and decide what changes. Keep a short record of the assumptions behind the forecast so next month’s variance teaches you something.

ReviewQuestionOwner
DemandWhat changed in orders, velocity, or pipeline?Sales / marketing
SupplyWhat can we make, buy, receive, and release?Operations
CashWhat does the plan require us to fund?Finance / founder
DecisionWhat changes today because of the new information?Leadership

The signals that deserve attention

Forecast accuracy is not the only measure. Watch bias, stockout risk, excess inventory, supplier lead-time variance, and the number of manual overrides. A forecast that is consistently optimistic is more dangerous than one that is simply imperfect.

When a SKU misses plan, ask whether the problem was demand, availability, price, placement, or execution. That diagnosis determines whether you change the forecast or fix the system.

Simple test. If your forecast cannot tell you what you should buy, make, or delay this month, it is reporting—not planning.

Frequently Asked Questions

How far out should a CPG brand forecast?

Use a detailed 90-day operating forecast and a lighter six- to 18-month view for capacity, cash, and major commitments. The right horizon depends on lead times and retailer calendars.

Should we forecast by revenue or units?

Use units for production and inventory decisions, then translate to revenue and cash. Revenue alone can hide SKU mix and channel differences.

What if our historical data is too limited?

Start with explicit assumptions and a range. Use comparable products, launch timing, channel commitments, and weekly updates. A transparent imperfect forecast beats an opaque precise-looking one.

Need to turn the framework into operating rhythm?

Logic Agency gives scaling consumer brands senior supply chain and packaging operations without forcing an early full-time hire.

Logic Agency Inc. · Packaging & Supply Chain Ops on a Monthly Retainer