Configuration Management template or db wanted

C

chuckhardy

#1
I recenlty inherited CM (yeah) in our small manufacturing company. I was initially planning to manage CM via our ERP, however our ERP is not capable of handling rev levels for components or sub-tier items, so it does me no good. I am looking for a simple database or even a master configuration template form that I can use in Excel to assist me until we can afford a new ERP. We will be controlling external documents as well, and some of our customers have unique DWG rev vs. PL revs, so having a master config record is imparative. If anyone has something for me to look at to use/modify, please pass it along. I would appreciate that.
 
Elsmar Forum Sponsor

Wes Bucey

Prophet of Profit
#3
I recenlty inherited CM (yeah) in our small manufacturing company. I was initially planning to manage CM via our ERP, however our ERP is not capable of handling rev levels for components or sub-tier items, so it does me no good. I am looking for a simple database or even a master configuration template form that I can use in Excel to assist me until we can afford a new ERP. We will be controlling external documents as well, and some of our customers have unique DWG rev vs. PL revs, so having a master config record is imparative. If anyone has something for me to look at to use/modify, please pass it along. I would appreciate that.
Before you try to reinvent the wheel, tell us:

  1. how many documents are you controlling?
  2. how frequently do revisions arise?
  3. How many different customers?
  4. How many different products?
  5. How many suppliers?
  6. Do you employ "continual improvement" in your manufacturing processes so that a process may change even though the product doesn't?
Have you read my screed on Configuration Management? Do you have a process in place for systematic evaluation of a change as it arises so you can decide on the Associated Documents which also have to be reviewed and evaluated to determine if they, also, have to be updated?

The situation with a database for CM is that, in many cases, the number of fields (Associated Documents, Customers, suppliers, materials, secondary processes, etc., etc.) is variable for every product. The changes (revisions) don't always occur in only the primary document (usually the engineering drawing for the product), but in some of the Associated Documents. Do you employ "continual improvement" in your manufacturing processes? (do you change suppliers for a commodity? do you get a new production machine? does tooling change? etc. etc.)

Because the changes and revisions can occur in any of the documents, it's usually better for folks to use a relational database to track them than a spreadsheet like Excel.
 
Thread starter Similar threads Forum Replies Date
K Configuration Management Procedure Template wanted AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
R Configuration Management - Identifying Documentation IEC 62304 - Medical Device Software Life Cycle Processes 3
H AS9100 D - 8.1.2 Configuration Management for Build-to-Print Service Provider AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
William55401 Distributed By Product - Best Practices for Configuration Management and Purchasing Controls ISO 13485:2016 - Medical Device Quality Management Systems 0
John Predmore Configuration Management as a process instead of a procedure AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 10
G AS9100-8.1.2 Configuration Management AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
R Configuration Management in AS9100 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
N Configuration Management - Physical Audit and Functional Audit for Software and Hardware General Auditing Discussions 4
T Change control and configuration management - When to create a new model/part number? Other Medical Device and Orthopedic Related Topics 0
P Configuration Management Software EASA and JAA Aviation Standards and Requirements 4
Q Configuration management clarification and example AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
A Risk Management and Configuration Management ISO 14971 - Medical Device Risk Management 3
K Example of ISO 10007 - Configuration Management Plan AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
A AS9100. 7.1.3 Configuration Management. PCB production. ECN. Revision Control. AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
K Software Configuration Management Audit Questions Quality Assurance and Compliance Software Tools and Solutions 8
Q Configuration Management Audit AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 10
Wes Bucey Aerospace Configuration Management Webinar Book, Video, Blog and Web Site Reviews and Recommendations 3
Q Understanding Configuration Management AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 16
B How to define and implement Configuration Management Document Control Systems, Procedures, Forms and Templates 5
Q Configuration Management Form example(s) wanted Document Control Systems, Procedures, Forms and Templates 1
P Configuration Management for Build to Print Company AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
L What exactly does Configuration Management in ISO 9001, Clause 7.5.3 means? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
S Configuration Management System software that can also be linked to our ERP system AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
N Change Management, Configuration Management or Other Process? Manufacturing and Related Processes 9
G AATT Focus: Configuration Management & Risk Management AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
B AS9100 (FCA / PCA) of section 7.1.3 - Configuration Management - Audit question AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
B Configuration Management and ISO 10007 (again) AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 8
K Configuration Management - AS9100 Requirements AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 11
T Upgrading to AS9120A - Configuration Management AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
B What is meant by "Configuration Management"? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 36
O Difference between Configuration Management Procedure / Plan in IT context? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
T Who owns Configuration Management Document Control Systems, Procedures, Forms and Templates 6
B How to ensure Configuration Management and Control manually AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
D AS9100 Configuration Management Procedure example wanted AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
V Configuration Management - Configurable, Managed and Controlled Document Control Systems, Procedures, Forms and Templates 3
M Configuration Management - AS9100 Rev B or C AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 7
C Configuration Management requirements if this facility is not design responsible AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 9
T Configuration Management For Design and Development (Clause 7.1.3) AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
S Is Configuration Management Mandatory? AS9100 Clause 7.1.3 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 9
B Configuration Management - Is Configuration Management a requirement of ISO 9001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 21
N The International Society of Configuration Management (ISCM) certification exam Professional Certifications and Degrees 2
A Configuration Management and On-Hand/In-Transit Inventory Quality Manager and Management Related Issues 3
L Definition Configuration Management - What is Configuration Management? Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 5
J Configuration Management - ISO 9001 - 7.6 Monitoring and Measuring Equipment ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
S Configuration Management compliance - Adding information to individual procedures AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 8
W Configuration Management for sub-contractors working to Customer Drawings AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 7
C Compliance with AS9100 Configuration Management Requirements AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
K Configuration, Risk Analysis and Project Management in one procedure AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
K Configuration Management Basics - AS9100 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 9
N Configuration Management Exemption? AS9100 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 14

Similar threads

Top Bottom