Skip to content

Free template

Updated

Machine history record template

A machine history record is the running file of one machine: what it is, which components wear out, and everything that has happened to it. Kept well, it shows which components fail again and again, what each failure costs and whether it is cheaper to keep repairing a part or to change it for one that lasts. This template has a machine card with a component ledger (part number, supplier code, expected life, last replaced and next due), a history log for breakdowns, planned maintenance, inspections and modifications, the sums per component (breakdowns, down time, repair cost, MTBF and MTTR), and a repair-or-extend comparison with payback. The Excel version does the arithmetic and flags components past their expected life. The PDF has the blank forms and a worked example.

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 machine history record templateFields for machine ID, machine, line, make, model, serial number, install date and rates above a component table with part number, supplier code, expected life, last replaced and next due.
Machine cardComponent ledger with next dueHistory log with repair costMTBF and MTTR per componentRepair-or-extend checkWorked example
Filled-in Machine history record template: a made-up case packer over 18 months
The same sheet filled in with the worked example (page 4 of the PDF, illustrative numbers). Open full size (opens the picture in a new tab)

When to use it

When to use a machine history record

  • For a machine that keeps breaking down in the same place, to put its failures and costs on one page.
  • To decide whether to keep repairing a component or to upgrade it, with the cost of each failure and a payback.
  • To plan replacements by the expected life of components, before they fail.
  • To hand a machine over, buy a spare or prepare a root cause analysis, all of which start from its history.
  • Not as the plant-wide breakdown log. For that, use the equipment downtime log; this record is per machine and per component.

How to fill it in

  1. 1

    Fill in the machine card

    Record the machine's ID, make, model, serial number, install date, criticality and owner. Add run hours a week, the labour rate and what an hour of down time costs; the sums use them.

  2. 2

    List the components that wear or fail

    For each, the part number you order, the supplier code, the expected life in months and the date it was last replaced. The next due date is the last replaced date plus the expected life.

  3. 3

    Log every event

    Date, event type (breakdown, planned maintenance, inspection or modification), the component, the cause for a breakdown, what was found and done, minutes down, labour hours and parts cost.

  4. 4

    Read the sums

    Per component: breakdowns, down time, repair cost, MTBF, MTTR and the months between failures. A component that fails more often than its expected life is the one to look at.

  5. 5

    Check repair against extension

    For the worst component, enter the cost of a change that extends its life and how often you expect it to fail afterwards. The comparison gives the annual saving and the payback.

  6. 6

    Keep the record alive

    Add the event the same day it happens, while the details are fresh. A history written from memory a month later loses the cause.

A filled-in example

Illustrative, not a benchmark

An invented case packer is tracked over 18 months, 100 run hours a week, with labour at $50 an hour and down time at $400 an hour.

  • The log holds 18 events, 11 of them breakdowns. The gripper head failed four times, the lift gearbox three times, the vacuum pump twice.
  • The gearbox is the costliest: three failures, each a new bearing and gearbox at $2,400 plus about 4.25 hours down. Its MTBF is 2,600 run hours against an expected life of three years.
  • An upgraded gearbox costs $5,100 and is expected to fail once in four years, with $200 a year of extra checks.
  • Keeping on repairing costs about $8,200 a year; the upgrade about $1,200. The saving is about $7,000 a year.

The upgrade pays back in 8.7 months, well inside a 24-month limit, so the verdict is to extend. The oil sample taken before the third failure had already shown metal in the oil.

Common mistakes

  • Logging only the big failures

    Short stops and quick fixes are the ones that repeat. If they are not in the log, the component with four small failures looks healthy.

  • No cause, or the wrong one

    A log full of unknown causes cannot guide anything. Write the cause as found and correct it when the investigation is done.

  • Counting repair cost but not down time

    A failure that costs $50 in parts can cost thousands in lost output. Put a cost on an hour of down time, even a rough one, and include it.

  • Trusting MTBF from two failures

    With very few failures, MTBF swings widely. Use it to rank components and to ask questions, not as a precise figure.

  • Believing the supplier's expected life

    The maker's figure is for a standard duty. Replace it with your own record once you have two or three replacements.

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 a professional maintenance tag becomes a work order with photos, location and equipment ID attached, rules route it to the right technician and set its due date by priority, and the technician records the fix and the parts used when closing it.

See it in a 45-minute demo

FAQ

Machine history record template: common questions

  1. A machine history record is the file kept for one machine: its details, the components that wear out and the log of every breakdown, planned maintenance, inspection and modification, with cost and down time. It shows what keeps failing and what it costs.

  2. A downtime log lists stops across machines or a line, usually by reason. A machine history record follows one machine and its components over time, with the repair cost and the cause, so repeat failures on one part are easy to see.

  3. The sheet divides the run hours in the period by the number of breakdowns of that component. It is a rough figure when there are few failures. Use it to rank components, and compare the months between failures with the component's expected life.

  4. When the yearly cost of its repeat failures, including the down time, is more than the extension saves within the payback you accept, often 12 to 24 months. The sheet works out the saving and the payback from your log; the failure rate after the change is an estimate.

  5. No. A paper card or this workbook is enough for a few critical machines. A maintenance system holds the same data for many machines and is worth having when you cannot keep them current by hand.

More free templates

All templates
Browse all 236 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.