# Cost Reduction Savings Tracker Worksheet > Source: https://netray.co/tools/cost-reduction-savings-tracker-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable list of cost-down projects with unit saving, annual saving, implementation cost and payback. ## Category cost-finance ## Audience - Cost engineer - Buyer - Controller - Operations manager ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Idea **Key:** idea **Type:** text #### Part or product **Key:** part **Type:** text #### Status **Key:** status **Type:** select **Options:** - Idea - Approved - In progress - Implemented - Rejected #### Old unit cost **Key:** old_cost **Type:** number **Format:** currency #### New unit cost **Key:** new_cost **Type:** number **Format:** currency #### Annual volume **Key:** volume **Type:** number **Format:** integer #### Saving per unit **Key:** unit_save **Type:** number **Expr:** old_cost - new_cost **Format:** currency #### Annual saving **Key:** annual_save **Type:** number **Expr:** (old_cost - new_cost) * volume **Format:** currency #### One-time cost **Key:** one_time **Type:** number **Format:** currency #### Payback **Key:** payback **Type:** number **Expr:** one_time / ((old_cost - new_cost) * volume / 12) **Format:** months #### Target date **Key:** due **Type:** date **Rows:** **Idea:** Switch to standard bar size **Part:** SHFT-2201 **Status:** Implemented **Old cost:** 14.8 **New cost:** 13.9 **Volume:** 18000 **One time:** 2500 **Due:** 2026-09-15 **Idea:** Consolidate fasteners **Part:** ASM-4410 **Status:** In progress **Old cost:** 3.45 **New cost:** 3.1 **Volume:** 40000 **One time:** 6000 **Due:** 2026-12-01 **Idea:** Second source for housing **Part:** HSG-1180 **Status:** Approved **Old cost:** 22.5 **New cost:** 20.75 **Volume:** 9000 **One time:** 12000 **Due:** 2027-01-31 **Idea:** Remove secondary deburr **Part:** BRK-1001 **Status:** Idea **Old cost:** 4.15 **New cost:** 3.8 **Volume:** 25000 **One time:** 1500 **Due:** 2027-02-28 **Idea:** Reduce packaging weight **Part:** PKG-0092 **Status:** Rejected **Old cost:** 1.9 **New cost:** 1.7 **Volume:** 60000 **One time:** 4000 **Due:** 2026-11-30 **Totals:** #### Total annual saving **Key:** annual_save **Agg:** sum **Format:** currency #### Total one-time cost **Key:** one_time **Agg:** sum **Format:** currency **Summary:** #### Net first-year benefit **Key:** net_year1 **Expr:** sum_annual_save - sum_one_time **Format:** currency **Primary:** true #### Blended payback **Key:** blend_payback **Expr:** sum_one_time / (sum_annual_save / 12) **Format:** months **Notes:** Totals include every row. Delete rejected ideas, or set their volume to zero, to see only live projects. Savings are gross of any price-down passed to the customer. ## Content **Intro:** Cost reduction programs fail when savings live in people's heads. This worksheet logs each idea with a unit saving, annual value, one-time cost and payback, and exports to Excel for finance review. **Sections:** #### How to use it **Body:** Add a row for each idea. Enter the old unit cost, the new unit cost, annual volume and any one-time cost such as tooling, validation or engineering time. The sheet calculates saving per unit, annual saving and payback in months. The totals row and summary show the portfolio value and net first-year benefit. Update status as ideas move from approved to implemented, and export the list for the monthly cost-down review. Keep a separate column in your own copy for the owner if several people contribute. #### Counting savings honestly **Body:** Finance teams discount savings that cannot be traced to a purchase price variance or a reduced standard cost. Count a saving only once it appears in the standard cost or in actual purchase prices. Distinguish hard savings, which lower spend, from cost avoidance, which prevents an increase. Use the volume you actually expect, not the maximum. For multi-year programs, keep the one-time cost in year one and let the annual figure repeat. Agree with the controller how savings are recognized before the first review so the tracker is accepted. **Bullets:** - Tie each saving to a part number - Do not count the same saving in both purchasing and engineering - Update the standard cost when a saving is implemented #### Common mistakes **Body:** Savings are commonly overstated by using list volume rather than actual shipped volume, or by ignoring the inventory on hand that still carries the old cost. Another error is forgetting that suppliers may recover a price cut elsewhere, and that quality problems from a cheaper source can wipe out the gain. Review payback as well as total value, since a large saving with a long payback is riskier than a small saving that pays back in weeks. **Cta:** If your ERP holds standard cost and purchase price history, we can help reconcile claimed savings against actual price variance automatically. **Faq:** #### What is the difference between cost savings and cost avoidance? **Answer:** Savings reduce actual spend against a baseline, for example a lower purchase price. Avoidance prevents a cost increase that would otherwise have occurred. Most finance teams report them separately because only savings show up in the P&L. #### How is payback calculated here? **Answer:** One-time cost divided by monthly saving, where monthly saving is annual saving divided by twelve. If annual saving is zero or negative, the result displays as zero, so check those rows manually. #### Should I include rejected ideas? **Answer:** Keep them in the log for history, but exclude them from the totals by setting volume to zero or deleting the row. That way the headline figure shows only live projects. #### Can I export this to Excel? **Answer:** Yes. The export buttons produce Excel, PDF and CSV files of the table, including computed columns and the summary, ready to attach to a monthly cost review. ## Search terms cost reduction tracker excel, cost savings tracker template, cost down project list, savings log manufacturing, cost reduction payback worksheet, procurement savings tracker, value engineering savings log --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json