# Customer-Owned Tooling PM Log Worksheet

> Source: https://netray.co/tools/customer-owned-tooling-pm-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Log shots or hits against the preventive maintenance interval for each mold, die or fixture and see how much of the interval is used.

## Category

maintenance

## Industry

Automotive

## Audience

- Tooling manager
- Maintenance planner
- Quality engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Tool ID

**Key:** tool

**Type:** text

#### Description

**Key:** desc

**Type:** text

#### Owner

**Key:** owner

**Type:** select

**Options:**

- Customer
- Supplier
- Third party

#### PM interval (shots)

**Key:** interval

**Type:** number

#### Shots since last PM

**Key:** shots

**Type:** number

#### Shots remaining

**Key:** remaining

**Type:** number

**Expr:** interval - shots

#### Interval used

**Key:** used

**Type:** number

**Expr:** if(gt(interval, 0), shots / interval * 100, 0)

**Format:** percent

#### Last PM date

**Key:** last_pm

**Type:** date

#### Location

**Key:** location

**Type:** text

**Rows:**

**Tool:** MLD-4410-01

**Desc:** 4 cavity housing mold

**Owner:** Customer

**Interval:** 250000

**Shots:** 212000

**Last pm:** 2026-07-22

**Location:** Press 12

**Tool:** DIE-0931-03

**Desc:** Progressive die clip

**Owner:** Supplier

**Interval:** 500000

**Shots:** 118000

**Last pm:** 2026-08-30

**Location:** Press 3

**Tool:** MLD-2208-02

**Desc:** 2 cavity cover mold

**Owner:** Customer

**Interval:** 150000

**Shots:** 149000

**Last pm:** 2026-04-11

**Location:** Press 7

**Tool:** FIX-7710-01

**Desc:** Weld fixture

**Owner:** Supplier

**Interval:** 100000

**Shots:** 31000

**Last pm:** 2026-09-15

**Location:** Cell B

**Totals:**

#### Highest interval used

**Key:** used

**Agg:** max

**Format:** percent

**Summary:**

#### Tools tracked

**Key:** tools

**Expr:** count

**Format:** integer

**Primary:** true

**Notes:** Update shots from press counters at each shift or each production order. Plan the PM when a tool passes about 85 to 90 percent of its interval so that it can be scheduled around production. Customer-owned tools usually require permanent identification and a record of who holds them.

## Content

**Intro:** IATF 16949 expects organizations to manage production tooling, including tool maintenance, storage and identification, and to mark customer-owned tools. This log gives you a simple shot-count based view of what is due.

**Sections:**

#### How to use the log

**Body:** List every mold, die or fixture with its owner, PM interval in shots and the shots completed since the last preventive maintenance. The sheet calculates the shots remaining and the percentage of the interval used. Update the shots from the press counter and sort by percent used to see which tool needs to come off the press next. Export to Excel or PDF for audits.

#### Setting the PM interval

**Body:** Intervals come from the tool builder recommendation, the material being molded or stamped, and your own wear history. Glass-filled resins wear molds faster than unfilled grades, and abrasive coated steel wears dies faster. Start conservatively, record findings at each PM and lengthen or shorten the interval based on evidence.

**Bullets:**

- Record the condition found at PM, not just that it was done
- Shorten the interval after a quality escape caused by wear
- Keep spare inserts and wear parts for tools near their limit
- Treat the interval as a trigger, not a failure limit

#### Customer-owned tooling

**Body:** Where the customer owns the tool, you normally need clear identification, a record of location and a way to show maintenance on request. Do not move or scrap a customer tool without written approval. Keep the log with the tool history so an audit can follow one tool from build to current condition.

#### ERP and CMMS notes

**Body:** If your ERP or maintenance system holds tools as assets with a meter reading, the shot count can drive the PM work order automatically. Otherwise this log is a reliable stand-in. Reconcile the shot count with production quantity every month to catch counter errors.

**Cta:** Netray can connect press counts or production quantities in your ERP or MES to this log so work orders trigger from real usage. The worksheet works on its own without that.

**Faq:**

#### How do I choose a PM interval for a mold?

**Answer:** Begin with the tool builder guidance, adjust for material abrasiveness and cavity count, then use findings from each maintenance event to refine it. Shorten it when wear causes defects and lengthen it when inspections find little wear.

#### Do I count shots or parts?

**Answer:** Count shots or strokes, since wear follows the cycle count. Multiply by the number of cavities to get parts. Use whichever the tool builder uses for the interval.

#### What does IATF 16949 say about tooling?

**Answer:** It requires a system for production tooling management including maintenance and repair, storage, setup, tool change and identification, and it addresses marking of customer-owned tools. Check the standard text and your customer requirements for the details.

#### Can I export the log for an audit?

**Answer:** Yes. Export to PDF for a readable snapshot or to Excel for a working copy. All processing is in your browser.

## Search terms

tooling pm log excel, mold maintenance log template, die shot count tracker, customer owned tooling register, tool preventive maintenance schedule, tooling maintenance tracking sheet, iatf tooling management

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