How to deal with and track Customer Specific Requirements

I

Iceman414641

#1
Hello all,

I'm working at a automotive supplier (semiconductor) and i'm doing my Diploma Thesis. We want to introduce a system how to deal with incoming Customer Specific Requirements eg. Delphi, Bosch .... My Job is to build such a system and i am curious to know how you are dealing with the CSRs. Actually we have a large excel list where someone has to read the CSR and fill the form out by Hand. I'm open for suggestions and i'm looking forward to read your answers.
 
Elsmar Forum Sponsor
J

Joe Cruse

#2
It sounds like you need a database of some kind that can hold the requirements, and then spit out an automatic listing of them for those that need access to them, without having to copy them by hand. We use an AS400 system to handle this, along with order entry. I don't know much about it, other than the small part I use of it every day.

The same thing could be set up in a relational database. You'd probably want something bigger than MS Access, though you could pony up a "front end" for users with it.
 

Marc

Hunkered Down for the Duration with a Mask on...
Staff member
Admin
#3
There will typically be differences in each contract - How do you deal with that aspect?
 

Wes Bucey

Quite Involved in Discussions
#4
You should be able to readily find a "database designer" who will act as a consultant to design a relational database and the various queries and reports you will need to mine the database for information and turn out a usable document , even including differences in individual contracts.

The most difficult task for your database designer will be making it easy for you to populate and update your database as new information becomes available and some old information becomes obsolete. Certainly, it should be a named task for the designer to make provision for contract-specific requirements as well as generic customer-specific requirements - that's where the tough part of making it easy for you to populate the database comes in. (Good point to raise, Marc!)

Even an Access system will work faster than the Excel system and have more flexibility in making queries and generating reports to merge into documents like Bills of Material, Certificates of Conformance, Shipping documents, in-process travelers, and the like.

Much will depend on the sheer number of data points and the variety of queries and reports you will need in making the assessment whether to use Access, SQL, Oracle, etc. (That and company budget, of course.)

It should be noted that I normally advocate large companies deal with major software publishers versus "bargain basement" or open source database software, simply because of the wider variety of people familiar with the software to call on when there is a problem (almost invariably, there WILL be a problem.)
 

bpritts

Involved - Posts
#5
I would endorse Wes' comments about Access probably being adequate, unless (a) the organization is very large or (b) the computer network facility is very large, demanding something higher power than Access. I would be nervous
about using Excel - no audit controls; too easy to lose a row when edited, etc.

While on the topic, let me throw out a related question on a pet peeve. How do you interpret/audit the scope of "Customer Specific Requirements"?

When a customer (say, General Motors) publishes a list of C.S.R.... but they also have a plethora (or, maybe just a lot!) of methods and procedures that you as a supplier are expected to do. (Example: the "Quality System Basics" program they've rolled out over the past few years.)

My sense of the spirit of TS16949 is that all of these types of requirements should be identified and followed.... even if the customer didn't list them on their C.S.R. However, this does pose practical problems, such as, how do you audit such a requirement without a master list prepared by the customer?

I have handled this with my clients by identifying these as "additional" C.S.R.'s.

How do others handle this type of situation?


Best regards,
Brad
 
I

Iceman414641

#6
Hi all,

first of all thanks for the fast replies. I think the only appropriate solution of this problem would be a database. The major Problem iss how to identify the important things in CSRs or Contracts and make cross-references to other customers and of course the ISO 16949. Often there are CSR that have been copied by the customers from the ISO into their own documents, such things have to be filtered out. If its possible to do such cross-references you can easily detect Market-Trends (eg. 50% of all customers want the same --> identified Market-trend or possible future Standard). This is important for the company strategy in the future. Such a system can be much more than only a system for the 16949 certification. The next Problem is to define what a CSRs exactly is. I searched the Web but i didn't find an exact specification for CSR, because when all Customers or most of the customers want the same things there is no more a specific requirement.
Actually i have a bunch of problems and no clue how to solve them :)

So long,
Iceman414641

PS: Sorry for my bad english :)
 

bpritts

Involved - Posts
#7
I think you have some good thinking on the problem... and perhaps a good topic for your research. Keep us posted!

Best regards,

Brad
 
Thread starter Similar threads Forum Replies Date
L How to deal with an ISO 13485 Supplier Audit nonconformance ISO 13485:2016 - Medical Device Quality Management Systems 17
MDD_QNA How to deal with FDA after not reporting anything for several years Other US Medical Device Regulations 14
M Informational Update from GOV.UK – Regulating medical devices in the event of a no-deal Brexit – UK Responsible Person Medical Device and FDA Regulations and Standards News 0
A How to deal with changed shared components in 510k 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
M Informational UK – Contingency legislation covering regulation of medicines and medical devices in a no deal scenario – Human Medicines and Medical Devices (Amendm Medical Device and FDA Regulations and Standards News 3
M Informational EU – Medicinal products and medical devices: Coordinated approach in case of a withdrawal of the United Kingdom from the Union without a deal Medical Device and FDA Regulations and Standards News 0
M Informational UK – Regulating medical devices in the event of a no deal scenario Medical Device and FDA Regulations and Standards News 0
M Informational UK – Businesses supplying medicines and medical devices – what to expect on day one of a ‘no deal’ scenario Medical Device and FDA Regulations and Standards News 1
M Informational Design for new product safety marking for the no-deal Brexit scenario Medical Device and FDA Regulations and Standards News 1
M Informational UK – Contingency legislation covering regulation of medicines and medical devices in a no deal scenario Medical Device and FDA Regulations and Standards News 1
N How to deal with catalog parts suppliers who refuse to submit PPAP documents? APQP and PPAP 0
M Medical Device News MHRA releases response to consultation on EU exit no-deal legislative proposals Medical Device and FDA Regulations and Standards News 0
M Pharmaceuticals News UK – Further guidance note on the regulation of medicines, medical devices and clinical trials if there’s no Brexit deal Medical Device and FDA Regulations and Standards News 0
M Medical Device News Letter to the health and care sector: update on preparations for a potential no-deal Brexit Medical Device and FDA Regulations and Standards News 0
supadrai Indemnity Letters - What's the Deal? Other Medical Device and Orthopedic Related Topics 5
M Medical Device News MHRA to consult on EU exit no-deal legislative proposals EU Medical Device Regulations 1
D How to deal with user needs when it is obvious the design meets the user need 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 5
P Quality Assurance and Quality Control - Which clauses of ISO 9001 deal with each? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
O How to deal with Multiple Datums - Position with respect to Multiple Datum Feature Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
J ISO 9001:2015 Clause10.2 Nonconformity and Corrective Action - Deal with Consequences ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
0 How to deal with resistance to GDP Document Control Discipline Document Control Systems, Procedures, Forms and Templates 7
R How to deal with CONFIDENTIAL documents Document Control Systems, Procedures, Forms and Templates 2
N Interesting Discussion How to Deal with Suppliers Who Refuse to Complete our ISO Survey? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 51
L How to deal with resistance from auditee(s) Internal Auditing 20
P How to deal with a Recruitment Consultant Career and Occupation Discussions 3
AnaMariaVR2 3 Ways To Deal With People Who Play Office Politics Against You Coffee Break and Water Cooler Discussions 7
J How to deal with incomplete forms Nonconformance and Corrective Action 14
R How to deal with the RM requirement of clause 17 Electromagnetic Compatibility? IEC 60601 - Medical Electrical Equipment Safety Standards Series 8
L How to deal with too many CARs (Corrective Action Requests), PARs (Preventive Action) Nonconformance and Corrective Action 25
T How to train employees to deal with external auditors? Internal Auditing 13
S Training on how to deal with Regulations, Rules, Regulations Conflicts, etc. Training - Internal, External, Online and Distance Learning 6
M Mobile Medical Platforms - How to deal with Supplier Hardware/Software Changes? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
S How to deal with non-compliant company after take over of them IEC 27001 - Information Security Management Systems (ISMS) 6
C If my location does not deal with GM - Firewall - CS1 & CS2 Question IATF 16949 - Automotive Quality Systems Standard 3
I How to deal with Behaviour Problem in the work place? Human Factors and Ergonomics in Engineering 20
J How to deal with Mental models IEC 62366 - Medical Device Usability Engineering 1
BradM Deal? Or no Deal? Coffee Break and Water Cooler Discussions 25
Marc Looking for a good deal on a boat? World News 2
S How to deal with telemarketers Funny Stuff - Jokes and Humour 2
ScottK Giving training with a vicious cold - how do you deal? Training - Internal, External, Online and Distance Learning 9
Marc Delphi to close, sell most plants under deal World News 0
J How to deal with an employee who has a bad attitude? - Employee Attitudes Coffee Break and Water Cooler Discussions 15
D X Bar Chart - How can I deal with missing values in subgroups Statistical Analysis Tools, Techniques and SPC 12
E Lets Make a Deal... The TV show - A statistical approach Coffee Break and Water Cooler Discussions 8
M Dock to Stock - How to deal with inspection status requirements Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
Marc Delphi, GM and UAW reach broad buyout deal World News 1
J How to deal with operators who fail to follow work instruction? Misc. Quality Assurance and Business Systems Related Topics 52
W Who is my customer? We only deal with the agent who sells our plastic resins IATF 16949 - Automotive Quality Systems Standard 14
P Is TS-16949 a 2 for 1 Deal? QS-9000 - American Automotive Manufacturers Standard 6
Q Customer Specific Requirement, How to deal? QS-9000 - American Automotive Manufacturers Standard 9

Similar threads

Top Bottom