Skip to content
Shop | Excel tracker

Incoming Inspection Plan Sheet

Scope matrix that scores every part by effect, arrival and detection into a risk class and a plan, a sampling calculator with the acceptance curve, a receipt record with days to stock and a one page status.

Screenshot of the Incoming Inspection Plan Sheet workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: the area, the receipts per day, the hour rate and the targets you want to hold.
  2. 03 Parts: one row per part number or family. Score effect, arrival and detection from 1 to 4. The class and the effort calculate.
  3. 04 Sampling: enter sample size and acceptance number and read what the plan accepts. Write the two percentages on the plan card.
  4. 05 Receipt Record: one row per goods receipt with sample, defects, minutes and the days from truck to stock.
  5. 06 Status: read it every week at the board and compare it with the baseline in 02 Setup.

Definitions used in the workbook

  • Effect: What happens if a defective part passes unnoticed. 4 means function or safety fails at the customer.
  • Arrival: How likely a defect is in the next lot. 4 means a new part, a new supplier or above 5,000 defects per million.
  • Detection: Where in your own process the defect would be found. 4 means only at the customer.
  • Class: Effect times arrival times detection. A from 28 points, B from 9 to 27, C at 8 and below.
  • Acceptance number: The number of defects in the sample at which the lot is still accepted.
  • Dock to stock: Days from the arrival of the truck to the moment the material is in its stock location and available.

Sheets in the workbook

  1. Start
  2. Setup
  3. Parts
  4. Sampling
  5. Receipt Record
  6. Status

Who it is for

Quality and warehouse managers who want the inspection hours where a defect would do damage.

The method behind the numbers

This workbook is part of the Incoming Inspection and Traceability toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every two weeks.