AS9145 Readiness Survey - 2022 Update to previous 2020 survey <2 Min – thank you for your time

https://sprw.io/stt-3fd2c62d2f

PeProSo PPAP Software Requirements Apr 2 2022

 

PeProSo PPAP Software Requirements Apr 2 2022 

Intended Audience - part manufacturers (your suppliers and/or plants)

 In Scope

- Process Flow Diagram (PFD), PFMEA, Control Plan (CP), Gage Studies (GS), and DFMEA if needed

- PPAP Submission to customers, internal, and from suppliers

 Out of Scope – R&D / design centers - Robust design risk assessment (DRA) - block / boundary diagrams, structure analysis tree structure, parameter diagrams, etc.

 Need versus Want – Need is required, a must have.  Want is a would be nice.  NOTE: The answers vary significantly depending on what role you are asking – oversee, manage, or execute.

 At a very, very minimum, there needs to be a software map like this:

 

Criteria	Need/Want	Yes / No	Comments
GENERAL EVALUATION CRITERIA
Pricing Model (Enterprise, Sites, Suppliers)		Yes
Pricing Model (Named User, Concurrent User, Read Only User)		Yes
Payments Terms (CapEx or Opex)		Yes
Vendor financial stability		Yes
Vendor expertise / experience		Yes
Installation Options – either on-premise or cloud/SaaS		Yes
Integration available		Yes
Customization available		Yes
Source code available		Yes
Global consulting / training available		Yes
On Suppler site assistance available		Yes
Supports both AIAG 4th Edition and AIAG VDA Edition FMEA		Yes
Complicated User Security settings		No	Having to define, designate, and modify user roles and responsibilities (create new, edit, delete, etc.) is too complicated – they will go back to spreadsheets.  Baby step – is this better than spreadsheets?
Complicated Workflow management		No	Having to define all sorts of rules to automate the PPAP process is too complicated – they will go back to spreadsheets. Baby step – is this better than spreadsheets?
Hashtag like search capability		Yes
Spreadsheet Like Screens			A database app should provide similar spreadsheet like capability including: -        Ability to store personal setup (related to single user) -        Ability to search/filter each column. -        Export to spreadsheet (where applicable) -        Export to PDF (where applicable)   Move columns, hide columns, filter columns – real time report writer capability for lists of parts, projects, and studies.   In Project Forms – freeze columns, hide columns, etc.
Spell Checking		Yes	Automatic real time spell checking during data entry – no more mistakes from forgetting to run the spell checker in the spreadsheet before submitting documents.
Smart Lookup Filtering		Yes	The lookup list gets shorter as information is entered.
Action Tab – My To Do List		Yes	A single place to see all your project tasks, across all projects, FMEA action items, and more.
Supports multiple/additional languages (i.e., English, Spanish, Chinese, etc.)		Yes	More can be added...
INITIAL SETUP and CONFIGURATION
Ability to import Customer list.		Yes
Ability to import part list.		Yes
Ability to import Supplier list.		Yes
Manage multiple Gage Study Types		Yes
Manage multiple Operation Types.		Yes
Manage multiple plants / locations,		Yes
Manage multiple Product Type.		Yes
Manage multiple Product Classification Types.		Yes
Manage multiple Process Classification Types.		Yes
Manage multiple Project Types.		Yes
PART RECORDS		Yes
Part Number		Yes	Part Number detail includes a few mandatory fields, and then a lot of flexibility, including Search Tags field, like Hashtag capability, for searching and finding information not available in standard fields.
Part Revision History		Yes	A Part Revision History is maintained, with a flexible Revision Level formatting.  This eliminates the need for the old “Part History” form.
Part - Jump to Projects		Yes	There is a direct link to Projects (PPAP Submission) on the Part Number screen, by revision level.
Part - Import product characteristics		Yes
Part – Geometric Dimensioning and Tolerancing (GD&T) symbols		Yes
Part - Import process characteristics		Yes
Part - Import operations		Yes
Part - Import Bill of Material (BOM)		Yes
Part – Manage projects with multiple part revisions at same time.		Yes
Part – Document revision control		Yes
Part – Track suppliers we buy from		Yes
Part – Manage customer we sell to		Yes
Part – Upload attachments (design record(s), etc.)		Yes
Part Family - Manage reusable product characteristics.		Yes
Part Family - Manage reusable process characteristics.		Yes
Part Family - Manage reusable operations.		Yes
Product Family & reusable knowledge		Yes	A new PFMEA is not required for every part.  A new Gage Study does not have to be done on every part.  This is a huge cost savings.
PROJECTS - PPAP SUBMISSIONS
Projects		Yes	Projects is where APQP or PPAP projects are created.  This is where “forms” are created and managed, using the database View.  There is complete flexibility on how Projects are created regarding what Part Number / Revision level is used.  Multiple Projects can be open at the same time, on the same Part Number and Part Revision level, or the same Part Number with different Part Revision Level, to allow complete flexibility to handle multiple customer / supplier submissions at the same time based on what Part Revision manufacturing is currently producing.  This can also handle the issue across multiple plant locations for internal projects.   A Project is defined by the following: -        Part Number / Name and revision level -        Which Customer to be sent to, or if Internal, or if coming from a Supplier – this project is based on only one of these options -        Start and End Date -        Status   Project Revision History is maintained
PPAP Submission Process		Yes	Very flexible PPAP Submission process, including, multiple partial submission, full submissions, and re-submissions.  The PPAP Project status includes: Pending, Interim, Approved, and Rejected
Project - Ability to assign each PPAP package a project number, associated program, and other unique identifiers (tagging for traceability)		Yes
Project - Ability to create customer specific requirements.		Yes
Project - Form Data Columns – Hide, Sort, and Pin options		Yes
Project - Form Data Rows – add below, copy below, move (drag and drop)		Yes
Project - Form Data Rows – hide / view rows in PFD, PFMEA, CP		Yes
Project All Forms view- PF, PFMEA, CP all in a single view		Yes
Project Form Configurator – PFD, PFMEA, CP		Yes
Project Form FMEA Action Item Tracker		Yes	The right side of the FMEAs forms come to life with the Action Item tracking capability – assigned to and due sate tracking.
Project Form Family – manage reusable lookups (control methods, failure modes, failure effects, process controls, measurement techniques, sample size, frequency, reaction plan, devices, etc.)		Yes
Project Form Templates		Yes	A database Form Template will include the ability to configure and store and reuse a Form View – for example OLD versus NEW FMEA views, this Customer view versus that Customer view, etc.  The View Template allows the configuration of almost any form.
Project Forms – ability to create multiple views, including dimensional control plans (DCP) and other combinations of PFD, PFMEA, ad CP information.		Yes
Project forms - PFD ability to auto-populate steps into PFMEA		Yes
Project forms - PFMEA ability to auto-populate steps into CP		Yes
Project forms - PFMEA ability to expand rows to capture multiple failure modes, causes, and effects		Yes
Project Forms - Provide users visibility within drop down with standard S, O, D descriptions		No	The training and documentation are a separate subject.  No one using spreadsheets complained that they could not remember the 1-10 ratings descriptions.
Project Forms - provides automatic merge cell view		Yes
Project Forms - Right side of FMEA - action item tracking		Yes
Project Forms Publish option		Yes
Project Forms revision control		Yes
Project Gantt Chart		Yes	A database app will include a simple Gantt chart, without all the hassles of a MS Project like tool, and more flexibility. Allow for tasks to be related to the Gantt Chart and have a start and end date attributed to them, then show as graphical representations on the chart. If a task has just an end date, it will be show on the Gantt chart as a milestone.
Project Meetings		Yes	If needed, you can record the cross functional team involvement in the process.  If you are assigned to a team, you will receive an email notification.
Project Tasks – attachments		Yes	initial process capability studies, inspection results FAIR, Process Capability Studies, etc.
Project Tasks - Templates		Yes	A task template is re-usable task list – for example, the 18 PPAP items, an APQP task list, or any customer specific tasks, and more.
Project Tasks - Tracker		Yes	A simple task management process with flexibility to customize the task list.   A simple timeline with assignments and due dates is available.  By design, this is NOT a MS Project like tool – you are not forced to do anything to use the Task Tracker. A new Project can be created by combining multiple task templates, as needed for this new Project. If you are assigned a task, you will receive an email notification.
Project Tasks – ability to have unlimited sub-tasks		Yes
Project Tasks - Gantt charting display with sorting option		Yes
Project Tasks – spreadsheet like data entry		Yes
Project Tasks - configurator		Yes	Ability to have multiple task templates for different PPAP submission rules – internal and customer and suppliers.
Ability to select applicable PPAP deliverables by project/part/families.		Yes
Project - Team Members (customers, employees, suppliers)		Yes	Keep track of who has been involved.  Upload video conference files as an attachment.
Projects - Publish user definable PPAP submission elements into one PPAP zip file.		Yes
Projects – manage internal projects.		Yes
Projects – manage same part from multiple suppliers.		Yes
Projects – manage same part to multiple customers.		Yes
Projects - Ability to retain PPAP form revisions & audit trails for each PPAP element for document history progressions.		Yes
Projects - Ability to capture revision levels for each PPAP element.		Yes
Projects - Ability for all documents associated with PPAP submission to be locked when full disposition of the PPAP submission is established and all actions are completed.		Yes
Project - Ability to add additional fields to track data PPAP elements related to a part/product (i.e. customer specific requirements)		Yes
Project Forms - Automatic linkages between the DFMEA and PFMEA		Yes
Project Forms - Ability to be flexible & configurable to standard format changes (e.g. deleting columns on FMEAs, auto updates not forced, customizable templates and dashboard, reshuffling of column/rows, headers customizable, etc.)		Yes
Project - Ability to distinguish between pre-production and production for control plan (and other deliverables)		Yes
GAGE STUDIES
Gage Studies		Yes	One (1) Attribute and Two (2) Variable studies -        GR&R Attribute Hypothesis Test Method -        GR&R Variable Tolerance and TV Methods -        GR&R Anova Method
Gage Studies Minitab Users		Yes	Two points: 1st. If you are ONLY using Minitab for Gage Studies, a single named user license is $1,200 per year. Source 2nd The Minitab Gage Studies reports are complicated, and annoying to your employees and customers – a simple report that shows the results is preferred by most.
Gage Studies – reusable across multiple PPAP Submissions		Yes	Gage studies can be stored in a library and reused in multiple projects.
SYSTEM MANAGEMENT
Ability to export PPAP package from software for local storage (ease of access)		Yes
Ability to use single sign-on (external & internal)		Yes
Ability to have a data back-up system.		Yes
Ability to support multiple/additional languages (i.e., English, Spanish, Chinese, etc.)		Yes

 

Sincerely,

 

John M. Cachat

PeProSo, LLC

jmc@peproso.com

www.linkedin.com/in/johncachat - happy to connect

 

Work travels at the speed of trust…