May 5, 2016

One of the biggest hurdles to implementing a Plan for Every Part (PFEP) is deciding where to begin. In an ideal situation your ERP system, existing spreadsheets, and other legacy systems may be able to provide some of the data you need to populate your PFEP.  Chances are high that this information will lack visibility to changing bill of materials and production schedules and your team will have to begin the process of large scale data collection.

There is no absolute answer to where to begin, but in the years that we have worked with PFEP systems, we have developed a few questions you can ask your team that can help illuminate the path to PFEP success.

First, how will you house your PFEP data?

This seems like a simple answer, but the ramifications of making a poor choice can and likely will come back to haunt your team in the future. The easiest decision is to create a spreadsheet PFEP template. While excel is very user friendly, the control and ability to manage the spreadsheet becomes unreliable when more than one person has to access and modify the spreadsheet. We firmly believe that a properly built PFEP can be so much more than a spreadsheet, and an application that can facilitate data integrity, control, and collaboration is a more strategic choice. We have already discussed the advantage of a web based PFEP platform, but if you missed that post, read about it here.

Second, What data to collect?

Once you have selected the system framework for you PFEP data, you can begin the actual data collection process. Depending on your needs and goals, your team should decide on the key data points that will be required to consider your PFEP data “complete”. The collection of additional data points should not be ignored during this process. Defining the key elements required to make strategic business decisions and plan the movement of material is vital.

Third, what data to collect first?

This situation can seem overwhelming. If you have 40,000 manufactured and purchased parts to plan, selecting the starting point is a major decision point.  One method we use to select a starting point is to select a group of suppliers with the highest transportation spend. Targeting this group will allow a few immediate benefits to this process and your organization. Once the data is collected for this group, you can get a quick win by improving these part loops and begin to eliminate waste from these material paths. More importantly, reducing the transportation spend for these suppliers can mean big savings.

In summary, the process to implement PFEP should follow a stepped approach.

  1. 1. Determine how to house PFEP data
  2. 2. Determine required data elements for your business
  3. 3. Segment your parts by PFEP impact and repeat


About loopPFEP:

Nothing improves operations like having a plan. With our web-based part planning software, collaboration, logistics and data become transparent throughout your entire supply chain. loopPFEP  is a web based Plan for Every Part that allows your organization to analyze, optimize and implement improvements to your entire supply chain that results in cost savings to your bottom-line. To learn more about our web based PFEP, visit or contact me directly at