# OEM Annual Price Down Margin Erosion Calculator

> Source: https://netray.co/tools/oem-annual-price-down-margin-erosion-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Model a yearly contractual price reduction against material and conversion cost savings and see where piece margin lands in each program year.

## Category

cost-finance

## Industry

Automotive

## Audience

- Automotive supplier
- Sales and costing manager
- Controller

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Current piece price

**Key:** price

**Type:** number

**Default:** 12.5

**Min:** 0

**Step:** 0.05

**Unit:** $/pc

**Help:** Price you invoice today.

#### Material cost per piece

**Key:** cost_mat

**Type:** number

**Default:** 7.4

**Min:** 0

**Step:** 0.05

**Unit:** $/pc

**Help:** Purchased material including scrap allowance.

#### Conversion cost per piece

**Key:** cost_conv

**Type:** number

**Default:** 3.6

**Min:** 0

**Step:** 0.05

**Unit:** $/pc

**Help:** Labor, burden, machine and overhead per piece.

#### Annual volume

**Key:** volume

**Type:** number

**Default:** 450000

**Min:** 0

**Step:** 5000

**Unit:** pcs/yr

#### Contract price down per year

**Key:** pd

**Type:** slider

**Default:** 2

**Min:** 0

**Max:** 6

**Step:** 0.25

**Unit:** %

**Help:** Annual reduction in the LTA, often 1 to 3 percent.

#### Material cost reduction per year

**Key:** ms

**Type:** slider

**Default:** 0.75

**Min:** 0

**Max:** 5

**Step:** 0.25

**Unit:** %

**Help:** Yield, sourcing and design savings you can realistically deliver.

#### Conversion cost reduction per year

**Key:** cs

**Type:** slider

**Default:** 2

**Min:** 0

**Max:** 8

**Step:** 0.25

**Unit:** %

**Help:** Cycle time, labor and OEE gains.

#### Years into program

**Key:** years

**Type:** slider

**Default:** 4

**Min:** 0

**Max:** 10

**Step:** 1

**Unit:** years

**Outputs:**

#### Piece price in that year

**Key:** price_n

**Expr:** price * pow(1 - pd / 100, years)

**Format:** currency

#### Piece cost in that year

**Key:** cost_n

**Expr:** cost_mat * pow(1 - ms / 100, years) + cost_conv * pow(1 - cs / 100, years)

**Format:** currency

#### Margin today

**Key:** margin_now

**Expr:** if(gt(price, 0), (price - cost_mat - cost_conv) / price * 100, 0)

**Format:** percent

#### Margin in that year

**Key:** margin_pct

**Expr:** if(gt(price_n, 0), (price_n - cost_n) / price_n * 100, 0)

**Format:** percent

**Primary:** true

**Description:** Contribution margin after price down and your cost savings.

#### Annual profit in that year

**Key:** profit_n

**Expr:** (price_n - cost_n) * volume

**Format:** currency

**Primary:** true

#### Annual revenue given back

**Key:** given_up

**Expr:** (price - price_n) * volume

**Format:** currency

**Description:** Revenue per year lost compared with today's price at flat volume.

**Chart:**

#### Piece margin percent by program year

**Type:** line

**X:** years

**From:** 0

**To:** 10

**Steps:** 11

**Series:**

- margin_pct

**Disclaimer:** Simplified compounding model on a per piece basis. It ignores volume change, inflation, tooling and indexed material clauses.

## Content

**Intro:** Most automotive supply agreements carry an annual price reduction, often called productivity give back. This calculator compounds that price down against the cost savings you can actually deliver, so you can see whether piece margin holds, shrinks or disappears before the program ends.

**Sections:**

#### How to use the calculator

**Body:** Enter today's piece price and your material and conversion cost per piece. Set the contractual price down and the yearly savings you believe you can deliver on each cost bucket, then move the years slider. The chart sweeps year zero to year ten so you can find the year margin crosses your minimum acceptable level.

**Bullets:**

- Use standard cost from your ERP, not a quote estimate
- Keep material and conversion savings separate, they behave differently
- Run it twice: once with commitments, once with proven savings only

#### The math behind it

**Body:** Price in year n equals price times (1 minus price down) to the power n, which is how a percentage reduction compounds. Each cost bucket compounds the same way with its own savings rate. Margin percent is price minus cost over price. If the price falls faster than the combined cost, margin shrinks every year, and the gap widens because the reduction applies to the whole price while savings apply to cost.

#### Reading the result

**Body:** A flat margin line means your savings keep pace with give back. A falling line shows the year you must reopen the cost structure, ask for an indexed material clause, or request a resourcing conversation with the customer. Compare the annual profit output with your fixed program costs to see when the program stops covering its overhead.

#### Common mistakes

**Body:** Suppliers often assume savings land on day one. They arrive late, after tooling changes, validation and customer approval. Also remember that price down in the contract is usually applied to the current price, not the original, which is exactly what compounding captures. Do not mix indexed commodity pass through into this model without adjusting the material cost line.

**Cta:** If standard costs and quoted price downs live in separate systems, Netray can help surface program level margin by part from your ERP data so this check is not a spreadsheet exercise.

**Faq:**

#### Is price down the same as a PPAP price change?

**Answer:** No. Price down is a contractual yearly give back agreed in the LTA or nomination. A PPAP revision concerns a design or process change, though a customer approved cost saving may be shared with them under the contract terms.

#### Should I use percent of price or fixed dollars?

**Answer:** Contracts differ. Many state a percentage of the current price, which compounds. If yours states a fixed amount per year, use the percent equal to that amount over your price and note it will drift.

#### Can material savings be negative?

**Answer:** The slider starts at zero, but if commodity inflation is expected enter the base case at zero and model the increase separately, or use an indexed pass through clause to protect margin.

#### What margin should I aim to keep?

**Answer:** It depends on your overhead recovery and fixed cost. Compare the annual profit output with the program's share of fixed cost and with your corporate hurdle rate rather than relying on one percentage.

## Search terms

annual price reduction automotive supplier, long term agreement price down calculator, LTA price reduction margin impact, OEM price down erosion, automotive piece price margin calculator, productivity give back calculator, supplier annual cost reduction target

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