Select the 1 Supplier based on the Parts Durability from 6 Supplier Samples using Minitab

#1
Hello there,

I have 6 Supplier samples to compare based on the Durability and Cost. In Total there are 6 Samples * 25 observation each = 150 observations. I would like to use Minitab to generate the outcome for selection of the Sample from one of these 6 samples.

The data set is from samples provided by the suppliers containing Durability (in months) and Cost (in rupees). I will have to select the best possible sample to fit the company needs.

But I have no idea what I should use for comparing these 6 Samples. Could anyone give me an idea?

Sorry for my English and Thanks in advance!!!

To help your understanding...the data set looks like this:


Samples Durability Cost
Sample 1 39 3800
Sample 1 38 3800
Sample 1 40 3800
Sample 1 42 3800
Sample 1 47 3800
Sample 1 42 3800
Sample 1 39 3800
Sample 1 37 3800
Sample 1 41 3800
Sample 1 46 3800
Sample 1 40 3800
Sample 1 38 3800
Sample 1 40 3800
Sample 1 44 3800
Sample 1 41 3800
Sample 1 44 3800
Sample 1 44 3800
Sample 1 43 3800
Sample 1 41 3800
Sample 1 41 3800
Sample 1 40 3800
Sample 1 43 3800
Sample 1 47 3800
Sample 1 38 3800
Sample 1 41 3800
Sample 2 1 950
Sample 2 0 950
Sample 2 0 950
Sample 2 1 950
Sample 2 1 950
Sample 2 1 950
Sample 2 1 950
Sample 2 1 950
Sample 2 0 950
Sample 2 1 950
Sample 2 1 950
Sample 2 0 950
Sample 2 0 950
Sample 2 1 950
Sample 2 0 950
Sample 2 0 950
Sample 2 0 950
Sample 2 0 950
Sample 2 1 950
Sample 2 1 950
Sample 2 1 950
Sample 2 0 950
Sample 2 1 950
Sample 2 0 950
Sample 2 1 950
Sample 3 6 1150
Sample 3 6 1150
Sample 3 6 1150
Sample 3 6 1150
Sample 3 7 1150
Sample 3 6 1150
Sample 3 5 1150
Sample 3 7 1150
Sample 3 6 1150
Sample 3 8 1150
Sample 3 6 1150
Sample 3 8 1150
Sample 3 5 1150
Sample 3 8 1150
Sample 3 6 1150
Sample 3 5 1150
Sample 3 6 1150
Sample 3 8 1150
Sample 3 6 1150
Sample 3 7 1150
Sample 3 8 1150
Sample 3 5 1150
Sample 3 7 1150
Sample 3 7 1150
Sample 3 6 1150
Sample 4 1 780
Sample 4 1 780
Sample 4 1 780
Sample 4 1 780
Sample 4 0 780
Sample 4 1 780
Sample 4 0 780
Sample 4 2 780
Sample 4 2 780
Sample 4 2 780
Sample 4 1 780
Sample 4 1 780
Sample 4 2 780
Sample 4 0 780
Sample 4 2 780
Sample 4 2 780
Sample 4 1 780
Sample 4 1 780
Sample 4 2 780
Sample 4 1 780
Sample 4 1 780
Sample 4 1 780
Sample 4 1 780
Sample 4 1 780
Sample 4 2 780
Sample 5 2 680
Sample 5 1 680
Sample 5 0 680
Sample 5 1 680
Sample 5 1 680
Sample 5 1 680
Sample 5 2 680
Sample 5 1 680
Sample 5 1 680
Sample 5 0 680
Sample 5 0 680
Sample 5 2 680
Sample 5 1 680
Sample 5 1 680
Sample 5 1 680
Sample 5 2 680
Sample 5 0 680
Sample 5 2 680
Sample 5 2 680
Sample 5 1 680
Sample 5 1 680
Sample 5 0 680
Sample 5 0 680
Sample 5 2 680
Sample 5 0 680
Sample 6 18 365
Sample 6 24 365
Sample 6 20 365
Sample 6 19 365
Sample 6 20 365
Sample 6 21 365
Sample 6 21 365
Sample 6 21 365
Sample 6 23 365
Sample 6 18 365
Sample 6 21 365
Sample 6 22 365
Sample 6 22 365
Sample 6 22 365
Sample 6 21 365
Sample 6 24 365
Sample 6 20 365
Sample 6 23 365
Sample 6 23 365
Sample 6 21 365
Sample 6 23 365
Sample 6 21 365
Sample 6 18 365
Sample 6 22 365
Sample 6 22 365
 

Attachments

Elsmar Forum Sponsor

Ninja

Looking for Reality
Trusted Information Resource
#2
Howdy, and welcome to the Cove.
The data set is from samples provided by the suppliers containing Durability (in months) and Cost (in rupees). I will have to select the best possible sample to fit the company needs.
What are the company needs?
- Highest durability?
- Cheapest part (probably not)
- Best durability per cost?

If it is best durability per cost, divide cost by durability in months...$/month and analyze from there.
If you have a minimum durability need...cull your data of all that doesn't meet that need then go by cost (and statistical analysis or risk that future parts may not have the same durability).

Is there more you can share regarding what the company needs are?
 
#3
Yes @Ninja , as you mentioned the company goal is to get the Best Durability per Cost.

I'm looking for a way to support my outcome (e.g. Sample 6 seems to be the best fit) Durability/Cost, but looking for a Statistical approach to explain the decision to my management. (e.g. using 2 sample T-test/ANOVA) in Minitab.

Please let me know if there is a specific approach that I can apply or follow.
 

Ninja

Looking for Reality
Trusted Information Resource
#4
FWIW, I would just immediately downselect to Vendors 6, 1 and 3 (in that priority order) and run each of them through reliability analysis on your small sample set (or get a larger sample set for these three).

2, 4 and 5 have multiple fails AND all cost more...so they're just out of consideration.
You may want to do minitab, and others here can help you with that far better than I...but the limited data set you have above makes it pretty clear just by some simple math...attached.

For the money, I would just get a bunch more samples from vendor 6 and pursue that, leaving #1 and #3 on the shelf as a backup plan.
 

Attachments

Miner

Forum Moderator
Staff member
Admin
#5
You need to do a reliability analysis. Samples 2-5 are obviously very unreliable, so the options really narrow down to samples 1 and 6. I ran a quick reliability analysis and am posting the survival plots below. To me, the answer is obviously sample 1. Sample 6 will completely fail before sample 1 begins to fail.

1627410560115.png
 
#7
You need to do a reliability analysis. Samples 2-5 are obviously very unreliable, so the options really narrow down to samples 1 and 6. I ran a quick reliability analysis and am posting the survival plots below. To me, the answer is obviously sample 1. Sample 6 will completely fail before sample 1 begins to fail.

View attachment 28036
Could you please share the sample project file, if the above was produced from Minitab. I haven't performed the Reliability Analysis and would help in understanding the approach you have taken.
 
Thread starter Similar threads Forum Replies Date
V How to select the tests for proficiency testing Measurement Uncertainty (MU) 0
M How to Select FDA Medical Device Product Code? Other US Medical Device Regulations 10
P Material selection - How do we select a raw material? Bolt made of SAE J994 grade 2 Customer and Company Specific Requirements 3
K How do you select the right grips for your tensile tests? Imported Legacy Blogs 0
Y Can manufacturer select AR for MDD different from AR for RED? EU Medical Device Regulations 5
B Historical Standard Deviation or Select Parts for MSA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
S Excel Help - Equivalent of "Range($G$14:$AD$121).Select" in R1C1 notation Excel .xls Spreadsheet Templates and Tools 5
S A Standard for you to select Standards - ISO 16142-1 Other Medical Device Related Standards 1
R Is it possible to randomly select samples from 1 column to many column Using Minitab Software 2
B How important it is to select Parts that represent the Process Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
B How to select parts for a MSA Study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
C UDI: HIBCC vs. GS1 - Recommendations regarding which one to select Other US Medical Device Regulations 2
T Select Updates for Non-Clinical Engineering Tests - Intravascular Stents Other US Medical Device Regulations 0
C When do I select Team for Black Belt Project? Six Sigma 3
R How to select appropriate standards for Multi-Functional Physical Therapy Equipment IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
J How to select pieces for GR&R (Gage R&R) Studies? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
L How to select an Authorized Representative CE Marking (Conformité Européene) / CB Scheme 2
somashekar Definition Evaluate and Select ... What are the most common understandings of these words. Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 12
A Who to decide and select Internal Auditors and what are the criteria? Internal Auditing 18
R How to select the the target value from spec. limit (18 samples) Statistical Analysis Tools, Techniques and SPC 4
C How to select the requirements for Continuous Sampling Plan (CSP-1&F), Mil-Std 1235C? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
A How to select equipment for MSA (Measurement Systems Analysis) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
C ASQ Examination Fees Increasing for Select Certifications Professional Certifications and Degrees 1
H How to Select a Statistically Valid Sampling Plan Inspection, Prints (Drawings), Testing, Sampling and Related Topics 10
R Six Sigma vs. TQM - How to Select and What are their Differences? Six Sigma 2
M How to select a consultant to help out for ISO 14001 Certification? Consultants and Consulting 11
kedarg6500 How to Select Checking Aids APQP and PPAP 7
D Variable sample size - Xbar-s charts - How to select A3 and B4 Statistical Analysis Tools, Techniques and SPC 11
C What is the Best Way to Select a Registrar? The Reading Room 3
S Attribute MSA - Risk analysis -- How to select the samples Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Q Gage R&R - How to select samples near the limits? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S How to select the part for Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
Casana How to select a consultant? What criteria to consider and look for when looking Consultants and Consulting 5
P How To Select Regulatory (Regulatory Requirements?) For Implement Iso/ts 16949 IATF 16949 - Automotive Quality Systems Standard 3
Y How to select the most suitable person to be the Management Representative? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 17
B Operating Range & Measurement System Discrimination:How to select parts for R&R test? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
D Re-labeler - audit the supplier EU Medical Device Regulations 2
Evelyn7E The fastest way to get supplier to ship good parts to you Supplier Quality Assurance and other Supplier Issues 10
J Verification of purchased product / supplier questionnaires ISO 13485:2016 - Medical Device Quality Management Systems 2
D Question on Supplier Quality (SCAR) ISO 13485:2016 - Medical Device Quality Management Systems 3
Z REACH: contradictory statement from supplier? REACH and RoHS Conversations 4
G How to implement H&S and Quality Control Requirements in Contract for Potential Supplier? Contract Review Process 6
K Why does load cell supplier requires force verification General Measurement Device and Calibration Topics 3
D Question and advice for a supplier self audit questionnaire ISO 13485:2016 - Medical Device Quality Management Systems 6
D Special IATF audit of sub-supplier IATF 16949 - Automotive Quality Systems Standard 18
S IATF 16949 Supplier selection criteria 8.4.1.2 IATF 16949 - Automotive Quality Systems Standard 2
M Supplier approved list - Notified body, regulatory body Supply Chain Security Management Systems 4
N Making improvements in supplier relationship last? Supplier Quality Assurance and other Supplier Issues 6
K Supplier Qualification for Engineering Consultant? Supplier Quality Assurance and other Supplier Issues 3
M Supplier evaluation Supplier Quality Assurance and other Supplier Issues 5

Similar threads

Top Bottom