Blog
GUIDE · MATERIAL FLOW
PFEP (Plan for Every Part): What It Is and How to Build One
A washer costs pennies. Run out of washers, and your final assembly line stops. In a large automotive plant, Siemens puts the cost of one idle hour at $2.3 million.
We've lived this. At a fork truck plant in Wales, a new line was stuck below 50% of plan, and parts shortages were a big reason why. Four months after our first assessment, it was building its target of ten trucks a week, and several million dollars of working capital came off the shelves.
The turnaround didn't come from working harder. It came from giving each of the plant's several thousand parts its own plan. Put those plans in one place and you have a PFEP. Gerard Leone and I will show you how to build one your team keeps using, with a worked example, our formulas and a free Excel template.
Want to go deeper? This page covers the essentials. Our free 18-page ebook, The Complete Guide to PFEP, has the full method, more worked examples and a self-assessment you can print. Get the free ebook ↓
What is a PFEP?
A PFEP (Plan for Every Part) is a database, usually a spreadsheet, with one row for every part you buy or make. Each row records how that part gets from the supplier to the point of use: daily usage, lead time, container size, storage location, delivery route and replenishment method.
Your bill of materials tells you what goes into a product. The PFEP tells you how each part gets to the operator's hand. Think shopping list versus delivery plan. And no part is too small for one: a missing washer stops the line as fast as a missing engine.
The idea comes from the Toyota Production System, and the Lean Enterprise Institute's 2003 workbook Making Materials Flow made it widely known. Gerard and I set out our method in our book Material Flow. A spreadsheet is fine to start. Once you have thousands of parts and many people making changes, move the master data into a database.
Get it right and the payback shows up quickly: fewer line stoppages, right-sized inventory, less floor space tied up in parts, and a purchasing team that knows which suppliers to work on first.
In supply chain terms, the PFEP is the link between your suppliers and your line. It ties each supplier's lead time, shipment frequency and packaging to what the line actually uses, so a change at either end shows up in one place.
What information goes in a PFEP?
Four groups of fields. The first three come from Material Flow. The fourth holds the numbers you calculate.
Group
Typical fields
Why it matters
Part data
Part number, description, revision, dimensions, package quantity, daily usage
Everyone means the same part, and daily usage drives every calculation
Supplier data
Supplier, location, transit time, lead time, shipment frequency, kanban capability
Shows how much time and risk sit between you and the next delivery
Location data
Point of use, storage location, container type and quantity, special handling
Tells the material handler where the part lives and how it moves
Replenishment
Method, safety factor, days on hand, kanban quantity
Turns the data into a plan
Start with the fields your team will actually use. Every extra column is one more thing someone has to keep current.
What does a PFEP look like?
Here's a simplified PFEP for a made-up line that builds 40 units a day: 20 of Model A, 12 of Model B and 8 of Model C.
Part
Used on
Qty per unit
Daily usage
Supplier, lead time
Container
Point of use
Replenishment
Bracket, steel
10-2241
All models
2
80
Supplier A, 5 days
40 per tote
Station 4
Two-bin
Bolt, M8 x 25
10-3307
All models
8
320
Supplier B, 3 days
200 per box
Station 2
Two-bin
Wire harness
20-1150
Model A
1
20
Supplier C, 10 days
10 per tote
Station 6
Multi-bin kanban
Hood, painted
30-0410
All models (one per model and color)
1
40
In-house paint shop, 1 day
1 per rack slot
Station 7
Sequenced
Hose kit
40-0920
Model C
1
8
Supplier D, 15 days
1 kit per unit
Station 5
Kitted
Example PFEP for a made-up mixed model line. Scroll sideways to see every column on a phone.
Read the first row. Every unit takes two brackets, so 40 units a day need 80. With half a day at the line and a 10% safety factor, that's 44 brackets, which rounds up to two totes of 40: a two-bin system. The harness only goes on Model A, so its usage moves with the mix. The hood matches each unit's model and color, so it arrives in build order, called sequencing, instead of sitting in bins.
How do you build a PFEP?
In seven steps:
1. Set the scope: one line or product family, not the whole plant.
2. Export what your ERP, bills of materials and purchasing records already hold.
3. Walk the floor and check it. Supplier packaging is the usual weak spot.
4. Calculate daily usage, container quantities and stock at each location.
5. Set each part's point of use, supermarket location and delivery route.
6. Choose how each part gets refilled: two-bin, kanban, sequencing or kitting.
7. Name a PFEP Manager and send every change through a change request form.
Build it with a mixed team from engineering, production, purchasing, the warehouse and IT. A tiger team that builds it fast and moves on leaves behind a PFEP that starts decaying the day they hand it over.
How do you calculate the numbers in a PFEP?
Kanban quantity = Daily usage × (1 + Safety factor) × Days on hand
Containers = Kanban quantity ÷ Container size, rounded up
Days on hand is the total supply you want at a location, across all its bins. Take the bolt from the table: 320 a day, a 10% safety factor and half a day at the line give 320 × 1.1 × 0.5 = 176 bolts. They ship in boxes of 200, and a two-bin system needs two containers, so the line holds 400. If space is tight, repack into bins of 100.
At the supermarket, with 2 days on hand and no second safety factor, it's 320 × 2 = 640 bolts, or 4 boxes. Add safety stock where you need it, not at every location.
What changes on a mixed model line?
Two things. First, daily usage comes from the mix: add up each model's quantity times its units per day. A plate used twice on Model A and four times on Model B, at 20 and 12 a day, needs (2 × 20) + (4 × 12) = 88.
Second, a part used at several stations gets its stock split by each station's share of usage. We call those shares line consumption factors. And when the mix changes, recalculate. At 20 Model A a day, the harness needs 11 at the line, so two totes. At 40 a day it needs 22, and a third tote.
How do you keep a PFEP up to date?
Give it one owner and one way in. Name a PFEP Manager, one per line in a big plant, who approves every change, and send every change through a short request form. Update it whenever a part, supplier, container, engineering revision or the model mix changes.
Link it to your ERP if you can, but don't let the link replace the change process. Most PFEPs fail here, not on the math: built once, copied from the ERP without a floor check, owned by nobody.
A quick test. Pick five parts at random, walk to their point of use and compare what you find with the PFEP. If more than one doesn't match, your change process isn't working.
Kept current, a PFEP feeds everything downstream: the size of the supermarket, the delivery routes and the rack at each station. That's why we build it first, the same way we design a line before improving it in Mixed Model Line Design. For the rest of the picture, read What Is Mixed Model Material Flow?
Get the free PFEP template
Everything in this guide in one Excel file: the column groups, the formulas, our example line and a quick self-assessment to check your PFEP. No email needed. For the full method, see our book Material Flow and our hands-on workshops.
