Need to Create a Product Family Matrix?

QI Macros has a Ready-Made Product Family Matrix Template for Excel!

Why it Matters? Use a product family matrix to identify product groups that are based upon shared processes. It is a valuable step in Value Stream Mapping.

How to Use QI Macros Product Family Matrix

Once you open the template:

  1. Input the date of your Matrix (Note: QI Macros auto-fills this portion to the current date the template is/was opened):
  2. Date: 4/1/2023

  3. In Column A of the Matrix, you will find a "Product" field - list your Product description there:
  4. product family matrix product field

  5. Next, in row 4, input your "Process" description:
  6. product family matrix process field

  7. Lastly, go through each Product and indicate if it shares any of your Processes:
  8. product family matrix template

Where to find the Product Family Matrix in QI Macros

To access this matrix, click on the QI Macros Menu, and then select "Lean Tools" > "Value Stream Mapping":

Once the template opens, you have several options:

  1. VSM Text: Input your data into each cell in the spreadsheet and then click a button to automatically create a value stream map.
  2. Symbols: inventory of VSM symbols to copy and paste into any Value Stream Map.
  3. Value Stream Examples 1, 2, and Emergency Room to use as a starting point to save time.
  4. Spaghetti Diagram
  5. Product Family Matrix

vsm template options

Haven't you waited long enough?
Start creating your Product Family Matrix in just minutes.

Download a free 30-day trial. Get the Product Family Matrix now!

The Product Family Matrix is one of many tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. If you can't locate a tool, use the find tools feature on the far right side of QI Macros menu.

find tools on QI Macros menu

Other Charts Created by QI Macros Add-in for Excel