The Elsmar Cove Forum and Site Map The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page

Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools


The Elsmar Cove Forum SideBar!
Monitor the Forum
Monitor New Forum Posts
New Threads Feeds
RSS FeedRSS Feed
Sponsor Link










$ Contributor Forum Access
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:


Howard's International Quality Services

Atul's Symphony Technologies

Dave Scott's Scott Quality Solutions

Praxiom Research Group


NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest Portal

IEST - Institute of Environmental Sciences and Technology

ASQ - American Society for Quality


All the Important Standards and Related Web Sites in the World
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 6th November 2003, 12:27 PM
s-bell's Avatar
s-bell s-bell is offline
E-Mails Invalid or Rejected

Registration Date: Oct 2003
Location: England
Age: 35
 
Posts: 41
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 0
Karma: 61
s-bell has less than 100 Karma points so far.
Listen To Me! APQP thoughts - Excel .xls spreadsheet vs. APQP Specific Software

I'm presently scoping out a project for a Masters Degree and would like to gauge from the good people in the cove as to what they feel would make APQP, and its related documentation easier to complete, and more effective on implementation?

Is simply completing various Excel documents the answer, or is Powerway or other APQP specific software the best way forward?

Just wondering to see if common themes exist.

A bit of an open one this but lets see how the posts develop.
Reply With Quote

Sponsored Links
  #2  
Old 6th November 2003, 12:50 PM
Randy Stewart's Avatar
Randy Stewart Randy Stewart is offline
VINI, VIDI, DORMIVI

Registration Date: Feb 2002
Location: Walled Lake, Michigan
 
Posts: 1,153
Thanks Given to Others: 20
Thanked 79 Times in 51 Posts
Karma Power: 84
Karma: 1481
Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.
Default

APQP isn't something you get from a canned program or forms. It is something that comes from knowing your business, processes and capabilities.
All businesses will complete portions with any project - some are just better than others.
IMO this was an attempt to force suppliers to do some "up-front" planning in order to support the B3 and fill in the cracks caused by their lack of planning.
If you look at what is asked of APQP, it makes sense (the intent). If you look at what the customers require of APQP it starts to get muddy and non-value added.
As I go through APQP, my customer hasn't issued a design freeze. I may still be waiting on clay freeze.
__________________
"What this country needs is more unemployed politicians." Edward Langley
Reply With Quote
Sponsored Links

  #3  
Old 6th November 2003, 01:37 PM
Wes Bucey's Avatar
Wes Bucey Wes Bucey is offline
Quality Manager

Registration Date: Sep 2003
Location: Illinois
 
Posts: 7,536
Thanks Given to Others: 182
Thanked 1,127 Times in 762 Posts
Karma Power: 397
Karma: 11090
Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.
Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.Wes Bucey is appreciated, and has over 1700 Karma points.
Default

Quote:
Originally Posted by Randy Stewart

APQP isn't something you get from a canned program or forms. It is something that comes from knowing your business, processes and capabilities.
All businesses will complete portions with any project - some are just better than others.
IMO this was an attempt to force suppliers to do some "up-front" planning in order to support the B3 and fill in the cracks caused by their lack of planning.
If you look at what is asked of APQP, it makes sense (the intent). If you look at what the customers require of APQP it starts to get muddy and non-value added.
As I go through APQP, my customer hasn't issued a design freeze. I may still be waiting on clay freeze.
Advanced Product Quality Planning, IMO (similar to Randy's), is nothing more than the processes our Quality Industry has traditionally used in developing a Control Plan for producing any product or service. These are some of the mental and physical gyrations we go through in producing a Control Plan with factors ranging from
  1. determining initial capability and capacity of the organization to tackle the project
    to
  2. evaluating product design for potential pitfalls (3 decimal callouts where 1 decimal is sufficent?)
    to
  3. acquiring and confirming suitability of input material (purchasing, supplier quality, etc.)
    to
  4. selecting the most efficient process (machines?) to produce the intended quantity
    to
  5. instruments and methods for in-process inspection (evaluation?)
    to
  6. instruments and methods for confirming conformity and functionality of finished product
    to
  7. protective handling, packaging, storage, and shipping
These processes have been a part of good manufacturing practice for at least the 30+ years I've been involved.

Do checklists and software programs make the process produce better quality?
Not in my opinion.
Do checklists and software programs make the process a little or a lot faster?
Probably.
Do checklists and software programs make the process more uniform and easier to follow for folks of different skill and experience levels?
Definitely. However, this really only works when the products are all very similar and will use existing suppliers, machinery, and processes within the organization. All this goes out the window when the organization is contemplating a unique product or a unique quantity outside the normal scope of the organization.
Ultimately, an organization makes the decision based on a profit motive - especially if not following a process with the specific title APQP will result in the loss of a customer.
__________________
"Few minds wear out; more rust out"
Inscribed over the entrance of Louis Pasteur School, Chicago
Christian Nestell Bovee (1820-1904) in Thoughts, Feelings and Fancies, 1857
Reply With Quote
  #4  
Old 6th November 2003, 02:04 PM
Cari Spears's Avatar
Cari Spears Cari Spears is offline
Super Moderator

Registration Date: May 2003
Location: Clinton Township, MI USA
Age: 41
 
Posts: 1,600
Thanks Given to Others: 389
Thanked 134 Times in 80 Posts
Karma Power: 128
Karma: 3499
Cari Spears is appreciated, and has over 1700 Karma points.
Cari Spears is appreciated, and has over 1700 Karma points.Cari Spears is appreciated, and has over 1700 Karma points.Cari Spears is appreciated, and has over 1700 Karma points.Cari Spears is appreciated, and has over 1700 Karma points.Cari Spears is appreciated, and has over 1700 Karma points.
Default

Quote:
Originally Posted by Randy Stewart

...If you look at what is asked of APQP, it makes sense (the intent). If you look at what the customers require of APQP it starts to get muddy and non-value added...
You got that right!!
__________________
First thing each morning, I try on my bathing suit. Then, nothing worse can happen the rest of the day.
Reply With Quote
  #5  
Old 6th November 2003, 03:08 PM
SteelWoman's Avatar
SteelWoman SteelWoman is offline
Inactive Registered Visitor

Registration Date: Aug 2001
Location: USA
 
Posts: 417
Thanks Given to Others: 0
Thanked 1 Time in 1 Post
Karma Power: 50
Karma: 442
SteelWoman is appreciated, and has over 400 Karma points.SteelWoman is appreciated, and has over 400 Karma points.SteelWoman is appreciated, and has over 400 Karma points.SteelWoman is appreciated, and has over 400 Karma points.SteelWoman is appreciated, and has over 400 Karma points.
Default

We recently added a new line and the ONLY "form" we used was the one page form (can't recall the name) that asks for everyone from all the effected disciplines to sign off on the process. All of our other documentation of the APQP process was forms, communications, charts, budgets, etc that we would naturally produce as part of the process of bringing on a new line anyway. Our "APQP" notebook (the compilation of all that documentation and the one sign-off form) not only passed the audit with flying colors but got major kudo's for it's thoroughness.

What is the INTENT of APQP? To require a disciplined, thorough product planning process.

Does that have to, even NEED TO be done with software or a volume of forms or whatever? IMHO, no. Sure, there probably are situations where the forms/software/checklists serve the purpose of prompting you to consider certain things you might not consider otherwise, but adding a process or product successfully requires a certain level of forethought and planning anyway, but a level usually consistent with YOUR business, not necessarily consistent with or applicable to someone elses.

Just MHO, of course
Reply With Quote
  #6  
Old 7th November 2003, 02:15 AM
Howard Atkins's Avatar
Howard Atkins Howard Atkins is offline
Forum Administrator

Registration Date: Jul 1997
Location: Revivim, Israel
 
Posts: 2,412
Thanks Given to Others: 100
Thanked 448 Times in 253 Posts
Blog Entries: 8
Karma Power: 195
Karma: 4817
Howard Atkins is appreciated, and has over 1700 Karma points.
Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.
Send a message via Skype™ to Howard Atkins
Default

As I see it there is a lot of confusion which is compounded by the customers.
As SteelWoman said
Quote:
What is the INTENT of APQP? To require a disciplined, thorough product planning process.

Does that have to, even NEED TO be done with software or a volume of forms or whatever? IMHO, no. Sure, there probably are situations where the forms/software/checklists serve the purpose of prompting you to consider certain things you might not consider otherwise, but adding a process or product successfully requires a certain level of forethought and planning anyway, but a level usually consistent with YOUR business, not necessarily consistent with or applicable to someone elses.
APQP is a process in which the inputs are the customer and your requirements.
The output is the production process and the part and the documentation of this "PPAP"
The documentation of the APQP should be that of of design control (of part and/or process). One of the outputs is PPAP on the required customers forms.

One of the ways customers control their suppliers is by supplying lists of APQP actions and requiring a report on the timetable, this has made a lot of people think that APQP is in fact a timetable and not the process itself.

The only documents that have to be in customer format are PPAP and any other requested by him obviously part of the process is the FMEA and creation of the CP and this should be done on the standard forms to save time.
The need for software or other tools is to ensure the integrity and completeness of the 3 master documents that have to be completed for PPAP - whether you supply to the customer or not - Flow chart, FMEA and CP.
Reply With Quote
  #7  
Old 7th November 2003, 04:07 AM
s-bell's Avatar
s-bell s-bell is offline
E-Mails Invalid or Rejected

Registration Date: Oct 2003
Location: England
Age: 35
 
Posts: 41
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 0
Karma: 61
s-bell has less than 100 Karma points so far.
Default

Quote:
Originally Posted by Howard Atkins

One of the ways customers control their suppliers is by supplying lists of APQP actions and requiring a report on the timetable, this has made a lot of people think that APQP is in fact a timetable and not the process itself.
I agree completely with this, APQP is often confused by the customer requirements and focus. APQP is a natural evolution in project development to obtain a quality product and should be performed at the correct stage through product and process development.

The customer does confuse things with the APQP reporting documents, which do make APQP more of a timetable.

The latest reporting document we have recieved covers 23 elements with approx 10-20 questions behind each element to provide verification. An APQP validation meeting with the customer can take up to one day on one component. Given on some projects we have 20 components the APQP reporting becomes a nightmare and a distraction of resource from key activities.

Do others have similar reporting problems, we are dealing with customers new to the APQP philosophy and I am unsure of how the B3 deal with these issues.

We obviously need to report status to our customers but are the issued documents the best way to go? Have any of you agreed an alternative format with your customers?
Reply With Quote
  #8  
Old 7th November 2003, 08:45 AM
Randy Stewart's Avatar
Randy Stewart Randy Stewart is offline
VINI, VIDI, DORMIVI

Registration Date: Feb 2002
Location: Walled Lake, Michigan
 
Posts: 1,153
Thanks Given to Others: 20
Thanked 79 Times in 51 Posts
Karma Power: 84
Karma: 1481
Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.Randy Stewart is appreciated, and has over 1300 Karma points.
Default Reports and more Reports

S-Bell,
I feel it goes along with the PPAP submission level. If your customer allows self certification then all the other requirements are backed off on. We have gone from the APQPQOE to the APQPRPT (attachments).
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting the post it is in, 3. Use at your Own Risk.
File Type: xls APQPRPT.XLS (64.0 KB, 1137 views)
File Type: xls APQPQOE.XLS (277.5 KB, 1179 views)
__________________
"What this country needs is more unemployed politicians." Edward Langley
Reply With Quote
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors and 1 Unregistered Guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
5 Whys Template - Excel .xls Spreadsheet jrubio ISO/TS 16949 - International Automotive Quality Systems Standard 10 27th October 2009 04:15 PM
APQP Process Assessment Tool - Excel .xls Spreadsheet Stijloor Excel .xls Spreadsheet Templates and Tools 1 21st April 2008 04:33 AM
APQP Timeline spreadsheet form in Word .doc or Excel .xls wanted chiefexec Excel .xls Spreadsheet Templates and Tools 11 23rd April 2007 05:59 PM
Calculating PPM for a Supplier on a Specific Defect - Excel .xls Spreadsheet Wanted jkittle SPC Monitoring and Statistical Analysis Techniques 7 31st August 2006 03:06 PM
Software or Excel .xls spreadsheet to calculate sample size and the AQL - ISO 2859-1 Ced Excel .xls Spreadsheet Templates and Tools 2 24th September 2002 11:14 AM



The time now is 12:17 PM. All times are GMT -4.
The time zone can be changed in your UserCP --> Options.



   

All Y'All Come Back Now, Y' Hear?

Made With A Mac! FreeBSD OS Powered by Apache!
Using php4 Forums provided and maintained by Marc Smith Database by MySQL

FAIR USE and CORRECTNESS NOTICE: This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available in our efforts to advance understanding of environmental, political, human rights, economic, democracy, scientific, and social justice issues, etc. We believe herein constitutes a 'fair use' of any such copyrighted material as provided for in section 107 of the US Copyright Law. In accordance with Title 17 U.S.C. Section 107, the material on this site is distributed without profit to those who have expressed a prior interest in receiving the included information for research and educational purposes. For more information go to: http://www.law.cornell.edu/uscode/17/ If you wish to use copyrighted material from this site for purposes of your own that go beyond 'fair use', you must obtain permission from the copyright owner. In addition, I do not guarantee the correctness of the content. The risk of using content from the Elsmar Cove web site and forums remains with the user/visitor.

Responsibility Statement: Each person is responsible for anything they post in the Elsmar Cove forum. Neither I, Marc Timothy Smith, nor any of the forum Moderators, are responsible for the content of posts people make. Liability for post content resides with the poster as does interpretation and/or acceptance and/or use of advice by the reader.

Complaints: If you have a complaint with a post in a forum discussion thread, including Content in general, fighting, flaming, copyright infringement, defamation and/or 'slander', please use the 'Report This Post Report This Post Button button which appears at the top of every post in every thread.

Site courtesy of:
Marc Timothy Smith - Cayman Business Systems, 8466 Lesourdsville-West Chester Road, West Chester, Ohio 45069-1929 - USA
(513) 341-6272

To contact me, click the Google Voice link below, enter Your Name and Your Phone Number and Google will ring your phone and connect you for free!

The Elsmar Cove Web Site is *CopyFree*
no new posts