4.1. Compile Part Number List

4.1.1. Get part number list from supplier
4.1.2. Open O:\\supplierdevelopment\BTD\flex\Part List For Supplier Flexibility
4.1.3. Use the pivot table to select the supplier.  All Horicon part numbers and their 52 week volume will be shown.

4.2.1. Select all the part numbers, their volumes, and the grand total for the desired supplier from the pivot table.  Copy them into a new worksheet.
4.2.2. Use the sort function to sort the part numbers from highest volume to lowest volume.
4.2.3. Determine the percentage of total volume that each part number accounts for by taking each part number and dividing it by the grand total.
4.2.4. Create another column with the cumulative percentage by adding the percentage of each part number to the percentages of all the part numbers whose volume is greater then theirs.
4.2.5. Create a line chart using the chart wizard.  Place the part numbers on the x-axis and their volumes on the y-axis.
4.2.6. Using both the 80/20 rule and chart to determine the greatest change of slope in the line.
4.2.7. All part numbers to the left of the greatest change of slope will be the high volume parts.  All to the left of the greatest change of slope will be the low volume part numbers.

4.3.1. Request routing information from the supplier for all Horicon part numbers that they supply.
4.3.2. Determine process and design difference that affect how difficult it is for the part to be manufactured.
4.3.3. Using the defined differences, have the supplier give a complexity score between one and five to each part number.  One should be given to parts that historically have been easy to manufacture.  Five should be given to parts that historically have been most difficult to manufacture.
4.3.4. All part numbers with a complexity score of four or five are high complexity parts.  All part numbers with complexity scores of one to three are low complexity parts.

4.4.1. If the supplier supplies 30 or less part numbers study all of the part numbers manufactured during the duration of the study.
4.4.2. If the supplier supplies greater than 30 part numbers select between 12 and 24 part numbers to study.

4.4.2.1. Create an XY scatter charter using complexity on the x-axis and volume on the y-axis.
4.4.2.2. Divide the charter into four quadrants by separating the high and low volume and the high and low complexity parts.
4.4.2.3. Randomly select between three and six part numbers in each quadrant.
4.4.2.4. Ensure that the selected parts are scheduled to be manufactured during the study period.

BTD Methodology
Pre Study | Study Prep | Roll Out | Part Selection | Data Collection | Utilization | Analysis
Build to Demand Homepage | Process Mapping Homepage | Online Process Mapping

Last Modified on: 14-Dec-2001

---

Please forward your comments to Here
Copyright © Production Control Charting
All Rights Reserved

Page Design, Creation & Graphics © 2001 GCA
All Rights Reserved. Do not copy or redistribute in any form.