# Demand Plan Template for Product Families (Excel) > Source: https://netray.co/tools/demand-plan-template-by-product-family > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable demand plan worksheet: statistical baseline, sales and marketing adjustments, consensus, growth versus last year and confidence by product family. ## Category supply-chain ## Audience - Demand planner - S&OP lead - Sales operations ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Product family **Key:** family **Type:** text #### UoM **Key:** uom **Type:** select **Options:** - EA - KG - M - BOX #### Same period last year **Key:** ly **Type:** number #### Statistical baseline **Key:** stat **Type:** number #### Sales adjustment (+/-) **Key:** sales **Type:** number #### Marketing adjustment (+/-) **Key:** mkt **Type:** number #### Consensus demand **Key:** consensus **Type:** number **Expr:** stat + sales + mkt **Format:** number #### Change vs last year **Key:** growth **Type:** number **Expr:** (stat + sales + mkt - ly) / ly * 100 **Format:** percent #### Confidence **Key:** conf **Type:** select **Options:** - High - Medium - Low #### Key assumption **Key:** assump **Type:** text **Rows:** **Family:** Machined components **Uom:** EA **Ly:** 42000 **Stat:** 44500 **Sales:** 1500 **Mkt:** 0 **Conf:** High **Assump:** Existing blanket orders renew **Family:** Cable assemblies **Uom:** EA **Ly:** 18500 **Stat:** 19200 **Sales:** -800 **Mkt:** 0 **Conf:** Medium **Assump:** Customer B moves volume to second source **Family:** Control boards **Uom:** EA **Ly:** 6200 **Stat:** 6800 **Sales:** 900 **Mkt:** 300 **Conf:** Medium **Assump:** New programme starts in month 3 **Family:** Gaskets and seals **Uom:** BOX **Ly:** 9800 **Stat:** 10100 **Sales:** 0 **Mkt:** 0 **Conf:** High **Assump:** Stable aftermarket demand **Family:** Spares and service kits **Uom:** EA **Ly:** 3100 **Stat:** 3300 **Sales:** 200 **Mkt:** 150 **Conf:** Low **Assump:** Promotion planned, uplift uncertain **Totals:** #### Total last year **Key:** ly **Agg:** sum **Format:** number #### Total baseline **Key:** stat **Agg:** sum **Format:** number #### Total sales adjustment **Key:** sales **Agg:** sum **Format:** number #### Total marketing adjustment **Key:** mkt **Agg:** sum **Format:** number #### Total consensus demand **Key:** consensus **Agg:** sum **Format:** number **Summary:** #### Consensus vs last year **Key:** growth_total **Expr:** (sum_consensus - sum_ly) / sum_ly * 100 **Format:** percent **Primary:** true #### Net adjustments as % of baseline **Key:** adj_share **Expr:** (sum_sales + sum_mkt) / sum_stat * 100 **Format:** percent **Primary:** true **Description:** Large net adjustments deserve a forecast value add check. #### Baseline vs last year **Key:** base_growth **Expr:** (sum_stat - sum_ly) / sum_ly * 100 **Format:** percent **Notes:** Mixed units of measure are shown for illustration; totals only make sense when all rows share a unit, so convert to a common unit or a value before totalling. Keep each adjustment tied to a written assumption so it can be reviewed later against actuals. ## Content **Intro:** A demand plan is the single agreed view of what the business expects to sell. This template layers sales and marketing adjustments on top of a statistical baseline, so each change to the number is visible and can be reviewed against actuals later. **Sections:** #### How to use the template **Body:** List your product families, one per row. Enter the same period last year and the statistical baseline from your ERP or planning tool. In the sales and marketing columns, enter only the adjustments, positive or negative, that the commercial teams commit to. The worksheet adds them into a consensus demand per family and compares it with last year. Add a confidence rating and a one line assumption for every adjustment. Export to Excel for the demand review meeting and keep one file per cycle. #### Why keep adjustments separate **Body:** Putting only the final number in the system hides who changed it and why. Separating baseline, sales adjustment and marketing adjustment lets you measure whether each layer improves accuracy, which is the idea behind forecast value add. It also stops double counting: a promotion should be added once, not both in the baseline history and again as an adjustment. If net adjustments exceed 10 to 15 percent of baseline regularly, challenge the baseline or the assumptions. **Bullets:** - Baseline: statistical forecast from clean history. - Sales adjustment: known customer wins, losses, project timing. - Marketing adjustment: promotions, launches, pricing actions. - Consensus: the agreed number that drives the supply plan. #### Level of detail and horizon **Body:** Plan at the level where decisions are made. Families are usually right for an executive view, while SKU or SKU by location level is needed for supply planning and can be derived by disaggregating with mix percentages. Use monthly buckets across the planning horizon, often 18 to 24 months, and weekly buckets only inside the frozen window. Copy this sheet for each bucket or add columns for later months, keeping the same structure. #### Common mistakes **Body:** Planning to the budget instead of demand, which turns the plan into a target rather than a forecast. Letting adjustments creep in without an assumption or an owner. Mixing units of measure in the same total. Ignoring capacity: a consensus demand that exceeds what plants can make needs a supply response, not silent acceptance. And not archiving each cycle's plan, which makes it impossible to measure accuracy at a lag later. **Cta:** If the baseline, adjustments and consensus live in different systems, we can help connect them so the plan loads back into your ERP with a clear audit trail. **Faq:** #### What is a consensus demand plan? **Answer:** It is the single forecast agreed between sales, marketing, finance and operations after reviewing the statistical baseline and known commercial events. It is the number that drives the supply plan, and it should be saved each cycle so accuracy can be measured. #### How detailed should a demand plan be? **Answer:** Plan executive-level numbers by product family and region, and plan supply-level numbers by item and location. Use a disaggregation rule, such as recent mix percentages, to go from family to SKU, and keep the two levels consistent. #### Should the demand plan equal the sales budget? **Answer:** Not necessarily. The budget is a target; the demand plan is the best unbiased expectation. Differences between them are normal and should be discussed in S&OP as a gap to plan, with actions rather than silently adjusting the forecast. #### How often should the demand plan be updated? **Answer:** Monthly in most manufacturing S&OP cycles, with weekly adjustments inside the frozen window if orders move. More frequent updates help fast-moving items but add effort, so match the frequency to lead times and demand volatility. ## Search terms demand plan template, demand planning excel template, consensus demand plan, demand plan example, sales forecast template manufacturing, demand review template, statistical forecast override template, demand planning spreadsheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json