I'm struggling to find the appropriate solution to a project that I'm working on. I am trying measure the variability of lead time on products that we purchase I can't figure out what an appropriate calculation would be. Below are some of the details.
- I'm trying to compare vendors. Some tend to have short lead times (3-5 days) some are long (60-90 days). Whatever measure I use I need to be able to compare these vendors on the same scale.
- The data tends to have a lot of outliers.
My end goal is to be able to evaluate suppliers against each other. Are their lead times all over the place? Or do they tend to be relatively consistent.
Sample A - 32, 6, 9, 16, 3, 30, 34, 36, 33, 35, 42, 25, 38, 10
Sample B - 6, 7, 6, 6, 10, 8, 10, 8, 5, 8, 8, 7, 8, 6, 6, 6
Sample C - 7, 35, 6, 33, 31, 6, 32, 35, 30
Sample D - 28, 28, 20, 34, 16, 26, 27, 28, 15, 21, 23
Sample E - 2, 2, 4, 2, 1, 3, 4, 7, 11, 2, 1, 3, 2, 2, 2, 5
Any suggestions would be greatly appreciated!
- I'm trying to compare vendors. Some tend to have short lead times (3-5 days) some are long (60-90 days). Whatever measure I use I need to be able to compare these vendors on the same scale.
- The data tends to have a lot of outliers.
My end goal is to be able to evaluate suppliers against each other. Are their lead times all over the place? Or do they tend to be relatively consistent.
Sample A - 32, 6, 9, 16, 3, 30, 34, 36, 33, 35, 42, 25, 38, 10
Sample B - 6, 7, 6, 6, 10, 8, 10, 8, 5, 8, 8, 7, 8, 6, 6, 6
Sample C - 7, 35, 6, 33, 31, 6, 32, 35, 30
Sample D - 28, 28, 20, 34, 16, 26, 27, 28, 15, 21, 23
Sample E - 2, 2, 4, 2, 1, 3, 4, 7, 11, 2, 1, 3, 2, 2, 2, 5
Any suggestions would be greatly appreciated!