# Tooling and NRE Amortization Quote Worksheet > Source: https://netray.co/tools/tooling-and-nre-amortization-quote-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Spread tooling, fixtures, gauges and engineering NRE across the quoted volume, net of what the customer pays up front. ## Category cost-finance ## Industry Discrete Manufacturing ## Audience - Estimator - Controller - Program manager ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Item **Key:** item **Type:** text #### Type **Key:** type **Type:** select **Options:** - Tooling - Fixture - Gauge - CNC programming - First article - Engineering #### Total cost **Key:** cost **Type:** number **Format:** currency #### Customer funded **Key:** funded_pct **Type:** number **Unit:** % #### Pieces to amortize over **Key:** qty_amort **Type:** number #### To recover in price **Key:** unrecovered **Type:** number **Expr:** cost * (1 - funded_pct / 100) **Format:** currency #### Per piece **Key:** per_unit **Type:** number **Expr:** unrecovered / qty_amort **Format:** decimal **Rows:** **Item:** Soft jaws and vise fixture **Type:** Fixture **Cost:** 1800 **Funded pct:** 0 **Qty amort:** 500 **Item:** Forming die **Type:** Tooling **Cost:** 14500 **Funded pct:** 50 **Qty amort:** 5000 **Item:** 5-axis CAM programming **Type:** CNC programming **Cost:** 2400 **Funded pct:** 0 **Qty amort:** 500 **Item:** Go/no-go thread gauge **Type:** Gauge **Cost:** 650 **Funded pct:** 100 **Qty amort:** 500 **Item:** FAI inspection and report **Type:** First article **Cost:** 1200 **Funded pct:** 0 **Qty amort:** 500 **Totals:** #### Total NRE and tooling **Key:** cost **Agg:** sum **Format:** currency #### Total to recover in price **Key:** unrecovered **Agg:** sum **Format:** currency #### Sum of per piece charges **Key:** per_unit **Agg:** sum **Format:** decimal **Summary:** #### Funded by customer **Key:** funded_value **Expr:** sum_cost - sum_unrecovered **Format:** currency #### Customer funded share **Key:** funded_share **Expr:** (sum_cost - sum_unrecovered) / sum_cost * 100 **Format:** percent **Primary:** true **Notes:** Per piece uses each line's own amortization quantity. If lines share one quantity, the sum of per piece charges is the NRE loading to add to each unit price. Revisit if the volume forecast is not firm. ## Content **Intro:** Tooling and non-recurring engineering are real cash that leaves before the first good part ships. This worksheet lists each item, takes off what the customer pays directly, and spreads the remainder over the pieces you expect to sell. Export to Excel to attach to the quote file. **Sections:** #### How to use the worksheet **Body:** Add one row per tooling or NRE item. Enter the full cost, the percentage the customer will fund as a separate line item or tooling purchase order, and the quantity over which you intend to recover the rest. The sheet computes the unrecovered amount and the per piece charge. Add the per piece total to your unit price, or show it as a separate tooling line. Be honest about the amortization quantity: use committed volume, not the optimistic forecast. **Bullets:** - Include programming and first article effort, not just physical tooling - Set funded percent to 100 for fully customer-paid items - Use one row per item so a change is traceable #### The method behind it **Body:** Amortization here is straight-line by volume: unrecovered cost divided by planned pieces. It ignores interest, which is acceptable for short programs and understated for multi-year ones. For long programs add a cost of capital factor or shorten the recovery period. Tooling owned by the customer should not be amortized into your price at all, and the contract should say who owns it, who maintains it and what happens at end of life. #### Reading the result **Body:** The customer funded share tells you how much risk you carry. In the example, roughly a third of the spend is covered, so the rest depends on volume materializing. If actual volume is half the forecast, the per piece recovery doubles and you absorb the difference. Compare the per piece total against your target margin: if it is more than a few percent of price on low volumes, ask for a tooling purchase order or a minimum order quantity. #### Common mistakes **Body:** Leaving out maintenance and replacement of wear items such as dies and inserts, amortizing over a forecast the customer has not committed to, and burying NRE in margin so nobody can see it when the program is repriced. In an ERP, post tooling to a capital or work-in-process account consistently, and use a separate cost element for NRE so recovery can be reported. **Cta:** If tooling and NRE live in several spreadsheets, we can help pull actual program spend from your ERP so recovery is tracked against what you quoted. **Faq:** #### Should NRE be a separate line or built into piece price? **Answer:** A separate line is clearer and protects you if the program is cancelled, because the customer has agreed to pay it. Building it into piece price is simpler for the buyer but leaves you exposed if volume falls short. #### What quantity should I amortize over? **Answer:** Use committed volume or a conservative portion of the forecast. Amortizing over the optimistic forecast makes the quote look better but leaves unrecovered cost if the program underdelivers. #### Who owns tooling the customer paid for? **Answer:** That is a contract matter. Commonly the customer owns fully funded tooling and you hold it for their use. Put ownership, maintenance and return terms in writing. This worksheet is not legal advice. #### Does this include interest on tooling spend? **Answer:** No. It is straight-line by volume. For multi-year programs add a financing factor to the recovered amount, or shorten the recovery period so the carrying cost is covered. ## Search terms tooling amortization worksheet, NRE cost recovery excel, tooling cost per piece calculator excel, non recurring engineering cost template, fixture cost amortization quote, tooling cost allocation per part, nre amortization spreadsheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json