# New Product Introduction Forecast Template

> Source: https://netray.co/tools/new-product-introduction-forecast-template
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Document the assumptions, analog items and ramp behind a new product forecast so sales, planning and finance agree on it.

## Category

supply-chain

## Audience

- Demand planner
- Product manager
- S&OP lead

## Tool

**Kind:** template

**Output:** document

**Fields:**

#### Company

**Key:** company

**Type:** text

**Default:** Acme Precision Ltd

#### New item

**Key:** item

**Type:** text

**Default:** AX-900 sensor housing

#### Product owner

**Key:** owner

**Type:** text

**Default:** S. Iyer

#### Planned launch date

**Key:** launch

**Type:** date

**Default:** 2027-02-01

#### Analog item(s)

**Key:** analog

**Type:** text

**Default:** AX-700 sensor housing, launched 2023

#### Forecast basis

**Key:** basis

**Type:** select

**Options:**

- Analog item history
- Customer commitments
- Market sizing
- Blend of methods

**Default:** Blend of methods

#### Ramp assumption

**Key:** ramp

**Type:** textarea

**Default:** Month 1 at 20% of steady state, month 2 at 45%, month 3 at 70%, steady state from month 4. Steady state set at 800 units per month.

#### Risks and what would change the plan

**Key:** risks

**Type:** textarea

**Default:** Customer qualification could slip the launch by 6 weeks. Cannibalization of AX-700 expected at 30%.

**Blocks:**

#### New Product Forecast Assumptions

**Body:** Company: {{company}}
Item: {{item}}
Product owner: {{owner}}
Planned launch: {{launch}}

#### Method

**Body:** Basis: {{basis}}
Analog item(s): {{analog}}

#### Ramp curve

**Body:** {{ramp}}

#### Monthly forecast

**Table:**

**Columns:**

- Month
- Low
- Base
- High
- Source of number

**Rows:**

**0:** 1

**0:** 2

**0:** 3

**0:** 4

**0:** 5

**0:** 6

#### Risks and triggers

**Body:** {{risks}}

#### Approvals

**Signatures:**

- Product owner
- Demand planner
- Finance partner

**Notes:** Review the forecast against actual orders every month for the first six months and replace the assumed ramp with real history as soon as it exists.

## Content

**Intro:** Items with no history cannot be forecast by a statistical model, yet they often carry the most supply risk. This template makes the launch assumptions explicit: the analog item, the ramp, a low, base and high range, and the events that would change the plan.

**Sections:**

#### How to use it

**Body:** Fill the header, choose the forecast basis and describe the ramp. Download the document and complete the monthly table with low, base and high volumes. Share it with sales, the product owner and finance before the demand review, so the number is agreed once instead of argued in every meeting. When actual orders arrive, compare them to the base column monthly.

#### Picking analog items

**Body:** An analog is an existing item that behaved like the new one will. Match on customer segment, price point, channel and lifecycle, not just on product family. Use the analog's first twelve months, indexed to its steady state, as the ramp shape, then scale to the expected steady state volume. If there is no good analog, say so and rely on customer commitments or market sizing, with a wider range.

**Bullets:**

- Same customer segment and channel
- Similar price tier
- Comparable launch support
- Use first 12 months indexed to steady state

#### Ranges, not a single number

**Body:** A single figure for a new item is almost always wrong. A low, base and high range lets supply plan flexible capacity for the base and hold materials only for the range it can recover. Tie the high case to a trigger, for example a signed customer qualification, so safety stock is built only when the evidence appears.

#### Common mistakes

**Body:** Planners often forecast the launch spike and forget the cannibalization of the old item. Others keep the launch assumptions after real orders show a different shape. Another common error is loading the full steady state volume from month one. Track actual versus assumed ramp and correct early.

**Cta:** Netray can pull analog item history from your ERP and draft the ramp curve and range for a planner to review, with the sources shown.

**Faq:**

#### How do you forecast a product with no sales history?

**Answer:** Use an analog item, customer commitments or market sizing, or a blend. Express the result as low, base and high volumes with a ramp, and replace the assumptions with actual orders as soon as they exist.

#### What is a ramp curve?

**Answer:** A ramp curve shows demand as a percentage of steady state for each month after launch. It is usually taken from the first year of a comparable item and scaled to the volume you expect at maturity.

#### Should new item forecasts be locked?

**Answer:** Keep the document under version control and review monthly. Lock the numbers inside the supply frozen window, but allow the assumptions to be revised each cycle as real orders arrive.

#### Who owns the new product forecast?

**Answer:** The product owner or sales owns the assumptions, the demand planner owns the numbers in the plan and finance reviews the revenue effect. The template records all three so ownership is clear.

## Search terms

new product forecast template, NPI demand forecast, new product launch forecast, forecasting items with no history, analog product forecasting template, product launch demand plan, new item forecast assumptions

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json