Product Family Matrix
Easy to Use Product Family Matrix Template
The purpose of this matrix is to identify product groups that are based upon shared processes, and is a valuable step in Value Stream Mapping analysis.
QI Macros Add-in for Excel Makes Product Family Matrix Templates as Easy as 1-2-3
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:
- VSM Text: Input your data into each cell in the spreadsheet and then click a button to automatically create a value stream map.
- Symbols: inventory of VSM symbols to copy and paste into any Value Stream Map.
- Value Stream Examples 1, 2, and Emergency Room to use as a starting point to save time.
- Spaghetti Diagram
- Product Family Matrix
Product Family Matrix
To use this tool, follow the instructions below:
- Input the date of your Matrix (Note: QI Macros auto-fills this portion to the current date the template is/was opened):
- In Column A of the Matrix, you will find a "Product" field - list your Product description there:
- Next, in row 4, input your "Process" description:
- Lastly, go through each Product and indicate if it shares any of your Processes: