Skip to content

Free template

Updated

Cost savings tracker

A cost savings tracker is the list of every improvement project with what it saves, kept the same way for every project so the total means something. The two numbers that matter are the cost per year before and after the change; the difference is the annual saving. Savings are usually split into hard savings, where spending goes down and Finance can see it in the accounts, and soft savings, where a cost is avoided or time is freed but nobody pays less yet. A tracker earns its keep when Finance checks each saving against the books before it is reported, so the CI team and the controller quote the same figure. Page 1 of this template is the log: project, area and owner, category, hard or soft, cost per year before and after, annual savings, one-time cost, payback in months, when the saving starts, and Finance's decision with the verified amount. Page 2 explains hard and soft savings with examples, has a worked example and a month-by-month glide path against the target. The Excel version works out the savings, payback and status, totals claimed against verified savings by type and category, and draws the glide path of verified savings against the year's target.

Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.

Page 1 of the cost savings trackerFields for site, year, target and Finance contact, a key for hard, soft, pending, verified and rejected, and a log with project, area, category, type, cost before and after, annual savings, one-time cost, payback, start and Finance sign-off.
Savings logHard or softCost before and afterPayback in monthsFinance sign-offVerified savingsGlide path to target

When to use it

When to use a cost savings tracker

  • When a CI program has to show what it saved, not just how many projects it closed.
  • When the savings the engineers report and the savings Finance can find are different numbers.
  • To track a yearly savings target month by month.
  • Before a budget review, to separate the savings that are real from the ones still waiting to be checked.

How to fill it in

  1. 1

    Agree the rules with Finance

    What counts as hard, which labor and scrap rates to use, when a saving starts and how many months it is counted. Write them on page 2.

  2. 2

    Log the project

    Owner, area, category and whether the saving is hard or soft. One row per project, even small ones.

  3. 3

    Write the cost before and after

    Cost per year as it was and as it is now, from real data: scrap reports, overtime hours, invoices. Annual savings is the difference.

  4. 4

    Add the one-time cost

    What the change cost to make: a fixture, a part, contractor hours. Payback in months = one-time cost ÷ annual savings × 12.

  5. 5

    Get Finance to verify it

    Finance checks the numbers against the accounts and marks the saving verified or rejected, with the amount they accept.

  6. 6

    Track the glide path

    Each month, verified savings to date against the target to date. The gap shows early whether the year's target is in reach.

A filled-in example

Illustrative, not a benchmark

An example: one project in a machining plant (illustrative numbers).

The example project's hard saving and payback

Scrap cost a year

Before
$122,400
After fixture
$40,800

Hard saving: $81,600 a year.

Payback (months) = cost ÷ annual saving × 12

  1. Payback =$12,000 ÷ $81,600 × 12= 1.8 months
  2. Soft (not counted) =5 h a week × 52 × $32= $8,320 a year

Scrap cost fell from 122,400 to 40,800 dollars a year, a hard saving of 81,600. A 12,000 dollar fixture pays back in 1.8 months. 8,320 dollars of freed time stays a soft saving.

Only the scrap saving counts as hard, because less material is bought. The freed searching time is logged as soft.
  • Before: 1,200 parts scrapped a month at $8.50 each, $122,400 a year.
  • After a new fixture: 400 a month, $40,800 a year. Annual savings $81,600, hard, because less material is bought.
  • The fixture cost $12,000: payback = $12,000 ÷ $81,600 × 12 = 1.8 months.
  • The same project freed 5 hours a week of searching after 5S: 5 × 52 × $32 = $8,320 a year, logged as soft because nobody is paid fewer hours.

Finance checked the scrap cost against the material account and verified the $81,600. The $8,320 stayed in the soft column and was not counted toward the hard savings target.

Common mistakes

  • Mixing hard and soft

    Adding freed hours to cash savings makes a total Finance will not accept. Keep two columns and report them apart.

  • No baseline

    A saving with no cost before the change is a guess. Take the baseline from real data before the work starts.

  • Counting a saving forever

    Agree how long a saving is counted, often 12 months from its start, so the same project does not inflate every year's total.

  • Reporting before Finance checks

    Unverified savings are claims. Report them separately until Finance has signed them off.

Download the template

Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.

Run this template in LeanSuite

In LeanSuite every improvement project and its savings sit in one portfolio, workflow rules can require Finance to sign off on savings before a project closes, and hard and soft savings, cost avoidance and CapEx are tracked separately.

See it in a 45-minute demo

FAQ

Cost savings tracker: common questions

  1. Hard savings lower spending that shows in the accounts: less material bought, fewer overtime hours paid, a contract cancelled. Soft savings are costs avoided or time and space freed without anyone paying less yet, such as hours freed with no change in headcount or overtime.

  2. Take the cost per year of the process before the change and after it, from real data, and subtract. The one-time cost of making the change is kept separate and used for the payback: one-time cost divided by annual savings, times 12, gives the payback in months.

  3. So the CI team and the plant controller report the same number. Finance checks that the saving shows up in the accounts, or agrees it is a real avoided cost, before it counts toward the target.

  4. Agree it with Finance. A common rule is 12 months from the month the saving starts, after which it becomes part of the normal budget. The Excel version lets you set the number of months.

  5. A month-by-month line of savings to date against the target to date. If verified savings fall behind the line early in the year, there is still time to start more projects.

More free templates

All templates
Browse all 199 templates

Can't find the template you need?

Tell us what you're looking for. We'll make it and send it to your inbox, free.

A shift handover sheet, a red tag log, a changeover checklist for one machine: if your team uses it on the floor, ask.

By sending this form you agree to our Terms of Service and Privacy Policy.

Pass it on

We want LeanSuite to be the best place on the internet for lean help. If this was useful, send it to someone on your team or in your network who needs it.