Exclusivity Agreements

Document Sample
Exclusivity Agreements Powered By Docstoc
					Supplier Systems Assessment
Rev - Effective 19/Jan/05


Supplier Information                            Initial SSA Date:
Supplier Name                                Latest SSA Update:
DUNS Number
Supplier Location



SSA Reason                      Yes/No     SSA Participants                  Name of Dana Assessor   Name of Supplier Support Personnel
New Supplier                               Business Conduct
New Manufacturing Process                  Materials
20%+ Increase In Business                  Quality
New Technology to Dana                     ME & DFM
New Facility / Facility Move               Purchasing
Supplier Development                       Critical Tier 2 Mgmt
Project Criticality / Problem              Design & Reliability
                                           Project Management
                                           Capacity

Summary




                                         USE TEXT BOX!




                                                     Version 2b (01-19-05)                                                 2/3/2011
Supplier Strategic Assessment: Selection Phase
Rev - Effective 11/04


                 Supplier: Cell Automaticlly Populates                                            Latest SSA Update: Auto Populate             Risk Code
         DUNS Number: Cell Automaticlly Populates                                         * Target Date for Low risk:                           >2: High
     Supplier Location: Cell Automaticlly Populates                                     Project Implementation Date:                         1-2: Moderate
                                                                                                                                                <1: Low


                           Overall Risk Assessment                                                                      No Scores

                           Functional Risk Assessment

                        Business Conduct:           No Scores                                       Purchasing:           No Scores

                                 Materials:         No Scores                             Critical Tier2 Mgmt             No Scores

                                    Quality:        No Scores                           Design & Reliability:             No Scores

                                          ME:       No Scores                           Project Management                No Scores




* Note: Dana will re-evaluate sourcing decision if the supplier fails to reach an Overall Risk assessment of "Low" on/or before the Target date.




                                                                                                                                                   2/3/2011
        Risk Mitigation Plan                                                                                                                    21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls

      Supplier:   Cell Automaticlly Populates       0     Complete
DUNS Number:      Cell Automaticlly Populates       1     Planned / In Process / On Time
      Location:   Cell Automaticlly Populates       2     Planned / Not Started / Behind Schedule
 Last Updated:    Cell Automaticlly Populates       3     No Plan / No Action Taken
                                                   N/A    question does not apply (taken out of performance calculations)

                                                                                                                                                                                         Date
Function   Q#                          Question   Score      Risk                          Findings                         Corrective Action                  Who         Timing
                                                                                                                                                                                       Complete
   No Risks Identified for this Supplier            2




        2/3/2011                                                                                                                                                                 3 of 32
      Bus Conduct                                                                                               21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                          0     Complete
     DUNS Number:      Cell Automaticlly Populates                                          1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                          2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                          3     No Plan / No Action Taken
                                                                                           N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                         Question                         Score   Risk                                      Findings
        Social         Bus Conduct Can the supplier provide policy or documentation
     Responsibility                to verify that no child labor below the age of 16 or
1                                  the applicable legal standard, whichever is higher,                 L
                                   is occurring, unless this is part of a valid work-
                                   study or apprenticeship program?
        Social         Bus Conduct Does the supplier maintain a system for recording
2    Responsibility                wages and benefits, deductions and pay dates for                    L
                                   all employees?
        Social         Bus Conduct Can the supplier demonstrate that all employees
3                                                                                                      L
     Responsibility                are paid at least the legal minimum wage?
        Social         Bus Conduct Does the supplier have a written policy concerning
4    Responsibility                a process to address workplace grievances?                          L


        Social         Bus Conduct Can the supplier produce records of safety-related
5                                                                                                      L
     Responsibility                incidents during the last three years?
        Social         Bus Conduct Has the supplier been the subject of any
6    Responsibility                governmental investigation related to health and                    L
                                   safety matters during the last three years?
        Social         Bus Conduct Does the supplier have an on-site emergency
     Responsibility                evacuation and response plan and resources to
7                                                                                                      L
                                   respond to health and safety or environmental
                                   emergencies?
        Social         Bus Conduct Does the supplier provide personal protective
8    Responsibility                equipment to employees who may be exposed to                        L
                                   possible hazardous substances?
        Social         Bus Conduct Does the supplier routinely have any form of review
9    Responsibility                of health and safety and environmental conditions?                  L


        Social         Bus Conduct Does the supplier provide health and safety training
10                                                                                                     L
     Responsibility                for employees?
        Social         Bus Conduct Does the supplier have all necessary permits for
11   Responsibility                any environmental discharges (waste water, air,                     L
                                   etc.)
        Social         Bus Conduct Is the supplier in compliance with all environmental
12                                                                                                     L
     Responsibility                permits?
        Social         Bus Conduct Does the supplier use asbestos in any of its
13                                                                                                     L
     Responsibility                products that it may supply to Dana?
      2/3/2011                                                                                                                                         Page 4 of 32
      Bus Conduct                                                                                            21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                      0      Complete
     DUNS Number:      Cell Automaticlly Populates                                      1      Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                      2      Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                      3      No Plan / No Action Taken
                                                                                       N/A     question does not apply (taken out of performance calculations)

Q#       Area           Function                         Question                     Score    Risk                                      Findings
        Social         Bus Conduct Does the supplier have a code of conduct that
14   Responsibility                establishes business conduct, ethics and legal                   L
                                   compliance requirements for its employees?
        Social         Bus Conduct Does the supplier have a documented policy
15                                                                                                  L
     Responsibility                against harassment and discrimination?
        Social         Bus Conduct Is the potential supplier familiar with Dana's
16                                                                                                  L
     Responsibility                Supplier's Code of Business Conduct?

                                                                                        No
                                                     Overall BUSINESS CONDUCT Score                H
                                                                                      Scores




      2/3/2011                                                                                                                                      Page 5 of 32
      ME                                                                                                           21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                             0     Complete
     DUNS Number:      Cell Automaticlly Populates                                             1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                             2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                             3     No Plan / No Action Taken
                                                                                              N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                          Question                           Score      Risk                                   Findings
       Business            ME       What electronic design capability does the supplier
       Systems                      have (i.e., Pro-E, CAD)? (for design and/or tool
1                                                                                                         L
                                    design responsibility) Is it 2D or 3D capable?

       Business            ME       Does the supplier have an FTP site that is
       Systems                      compatible with the transmission of math data and
2                                   Pro-E files? If so, which division approved it? What                  L
                                    is the site address and Dana password?

       Facilities          ME       Are the Supplier's facilities that are involved in the
                                    manufacturing and/or storage of Dana goods and
3                                                                                                         L
                                    equipment adequately protected from damage/loss
                                    due to Fire, Flood, etc?
       Facilities          ME       Is the Supplier in compliance with all applicable
4                                   federal/local environmental statutes/guidelines?                      L


       Facilities          ME       Is the production process layout conducive to
                                    synchronous manufacturing. Does the flow appear
5                                                                                                         L
                                    logical? Is there limited handling, damage
                                    potential, movement of material?
       Facilities          ME       Is there adequate existing / planned lighting at each
6                                                                                                         L
                                    workstation?
       Facilities          ME       Is the production area/cell well laid out and
                                    adequate (i.e., Non-congested, staging areas,
7                                   sufficient work space)? Were comfort, safety, and                     L
                                    ergonomic factors considered during design?

       Handling            ME       Have handling and storage requirements for the
8                                   part and/or raw material been reviewed? Are they                      L
                                    acceptable?
       Handling            ME       Are special handling requirements for delicate
9                                                                                                         L
                                    components documented and adequate.
       Handling            ME       Have procedures and controls been established to
10                                  protect raw material from contamination (i.e., Mixed                  L
                                    lots, resins, paint batches, adhesives)?



      2/3/2011                                                                                                                                            Page 6 of 32
      ME                                                                                                         21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                           0     Complete
     DUNS Number:      Cell Automaticlly Populates                                           1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                           2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                           3     No Plan / No Action Taken
                                                                                            N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                          Question                         Score      Risk                                   Findings
       Handling            ME       What controls are in place to prevent the accidental
11                                  mixing or unauthorized substitution of materials                    L
                                    (grades, lots, etc.)?
       Handling            ME       Are the necessary equipment, assembly fixtures,
12                                  and work-in-process racks available? If Dana                        L
                                    owned, are they properly identified?
      Operations           ME       Have procedures been developed and are they
                                    being followed to ensure material is at the correct
13                                                                                                      L
                                    revision level? Does the supplier audit Part
                                    Number Revision levels?
      Operations           ME       Has a staffing plan been developed? (For a project
                                    need to see launch and full staffing plan. For
14                                                                                                      L
                                    existing operations need to see current staffing
                                    plan.)
      Operations           ME       Does the supplier have an updated floor plan
                                    showing process flow? Has it been analyzed to
15                                  minimize extra movement and improve efficiency?                     L
                                    Is the supplier moving towards One Piece Flow?
                                    (value stream map)
      Operations           ME       Does the supplier have a formal maintenance and
                                    preventative maintenance management system?
16                                  Does it include all production equipment, tooling                   L
                                    and supporting fixtures? Can it track specific
                                    tools? Is it being followed?
      Operations           ME       Has the maintenance and PM program been in
17                                                                                                      L
                                    effect at least six months?
      Operations           ME       Is the supplier tracking and managing unscheduled
                                    and scheduled downtime (mechanical, setup,
18                                                                                                      L
                                    personnel, part shortages, etc.)?

      Operations           ME       Does the supplier recertify a tool after repair and
19                                  before production? (how, when, and where)                           L




      2/3/2011                                                                                                                                          Page 7 of 32
      ME                                                                                                          21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                            0     Complete
     DUNS Number:      Cell Automaticlly Populates                                            1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                            2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                            3     No Plan / No Action Taken
                                                                                             N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                          Question                          Score      Risk                                   Findings
     Specifications        ME       Does the supplier have all appropriate lower level
                                    specifications to conduct proper validation testing
20                                  on file (Example: ASTM standards for raw Mat'ls,                     L
                                    Aluminum Assoc. specifications, VQA's, fastener
                                    specifications and controls)?
     Specifications        ME       Have all product/process related specifications
21                                                                                                       L
                                    been included in the control plan?
     Specifications        ME       Is there a formal process/procedure to verify
                                    compliance to Dana specifications and/or
22                                                                                                       L
                                    Government regulations (DOT, FMVSS) on a regular
                                    basis? Is it being followed?
        Tooling            ME       Does the supplier have a procedure/process to
23                                  track/manage new tooling and tooling revision                        L
                                    orders?
        Tooling            ME       Does the suppliers tooling database clearly show
                                    which tools are supplier owned vs. customer
24                                                                                                       L
                                    owned? Does it include all production tools and
                                    supporting fixtures?
        Tooling            ME       Does the suppliers tooling database clearly show
25                                  WHICH tools produce WHICH part numbers?                              L


        Tooling            ME       Does the supplier have a procedure/process to
26                                  document the addition of new part numbers being                      L
                                    produced from common tooling?
        Tooling            ME       Are all Dana tools identified with a Dana Asset tag.
                                    Does it show the part number, revision level, and
27                                  the Dana tool number? Does it identify whether the                   L
                                    part is RH or LH if mirrored parts?

        Tooling            ME       What procedure does the supplier use to document
                                    last piece inspection data and/or capability
28                                  (Cp/Cpk) information prior to storing production                     L
                                    tooling? (Critical and significant characteristics or
                                    those characteristics deemed significant by the
                                    supplier)


      2/3/2011                                                                                                                                           Page 8 of 32
      ME                                                                                                           21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                            0      Complete
     DUNS Number:      Cell Automaticlly Populates                                            1      Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                            2      Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                            3      No Plan / No Action Taken
                                                                                             N/A     question does not apply (taken out of performance calculations)

Q#       Area           Function                           Question                         Score       Risk                                   Findings
        Tooling            ME       Is all tooling stored in a location that is protected
29                                  from environmental / handling damage?                                 L


        Tooling            ME       When did the supplier last conduct a tooling
                                    inventory and compare the results against the
30                                  tooling database? (should be at least annually)                       L
                                    What were the results? Does it clearly show where
                                    each tool is stored?
        Tooling            ME       Does the Supplier have a procedure/process to
                                    ensure that Dana assets at Tier 2 Supplier locations
31                                                                                                        L
                                    are managed in accordance with Dana
                                    requirements?
        Tooling            ME       Does the supplier have a procedure/process for
                                    submitting tooling invoices within 30 days after
32                                                                                                        L
                                    PPAP approval? Are they in compliance with their
                                    procedure?
        Tooling            ME       Does the supplier have a procedure to dispose of
                                    Dana proprietary tooling? Does that procedure
33                                  include disposal at Tier 2 Suppliers? Is there                        L
                                    evidence that the procedure is being used?

        Tooling            ME       Does the Supplier's tool disposal procedure
34                                  guarantee the tool is destroyed so as to prevent any                  L
                                    future usage?
         Dana              ME       Has Dana communicated the requirements for
                                    receiving tooling payment, and how well does the
35                                  supplier understand these requirements?                               L
                                    (Requirements include: PPAP submission and
                                    approval , copy of the tooling record, proof of
                                    capability, picture, and an asset tag)

                                                                                              No
                                                                         Overall ME Score                H
                                                                                            Scores




      2/3/2011                                                                                                                                            Page 9 of 32
      Materials                                                                                                   21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                            0     Complete
     DUNS Number:      Cell Automaticlly Populates                                            1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                            2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                            3     No Plan / No Action Taken
                                                                                             N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                          Question                          Score   Risk                                      Findings
      Operations         Materials   Where and how does the Supplier receive Dana
                                     requirements? How are they communicated to the
1                                    production unit? (method: automatic / manual) Is                    L
                                     there a potential for information to be lost and/or
                                     misinterpreted during transmission?

      Operations         Materials   How does the supplier plan the plant, i.e., MRP,
                                     ERP, manual, spreadsheet, etc.? Are there any
2                                    proposed changes to this system in the next 6                       L
                                     months ? If so, is the change being tracked /
                                     managed ?
      Operations         Materials   Can the supplier directly download EDI
3                                    transmissions into their Materials planning systems                 L
                                     ? (vs. manually entering data)
      Operations         Materials    Is there an automated exception report that
4                                    identifies changes/adds/deletes to quantities and                   L
                                     due dates ?
      Operations         Materials   Does the exception report identify rev level changes
5                                    between transmissions? What actions are being                       L
                                     taken to address issues?
      Operations         Materials   Does the supplier monitor on-time delivery from
6                                                                                                        L
                                     their Tier 1 suppliers? Results?
      Operations         Materials   Does the Supplier have a system/procedure to track
                                     orders to their Tier-1 Suppliers? Do order
7                                                                                                        L
                                     quantities meet requirements? (Trace a B.O.M.. to
                                     the PO.)
      Operations         Materials   Does the supplier have an approved supplier list?
8                                    How are suppliers approved ? How are they                           L
                                     removed from the list ?
       Capacity          Materials   Has a formal, documented analysis of the
9                                    manufacturing process been completed? Does it                       L
                                     identify the top bottlenecks?
       Capacity          Materials   Has an action plan been developed to address the
10                                                                                                       L
                                     bottlenecks that were identified ?




      2/3/2011                                                                                                                                           Page 10 of 32
      Materials                                                                                                     21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                              0     Complete
     DUNS Number:      Cell Automaticlly Populates                                              1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                              2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                              3     No Plan / No Action Taken
                                                                                               N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                           Question                           Score   Risk                                      Findings
       Capacity          Materials   Does the supplier have a formal capacity plan and
                                     analysis? Does it identify any issues? (example:
11                                                                                                         L
                                     Load Report, Business Plan, Staffing Plan, etc)

       Capacity          Materials   Is there any major scheduled downtime for the
12                                   critical equipment? For the facility? Is it built into                L
                                     the production schedule?
       Capacity          Materials   At what rate does the supplier plan to load to
                                     capacity (in terms of percent) when this product is
13                                                                                                         L
                                     launched and at full production levels? (Should be
                                     less than 90%)
       Capacity          Materials   What is the average lead time per part? What is the
14                                   Expedited lead time per part? (total time from order                  L
                                     to shipment?)
       Capacity          Materials   What is the overtime rate as a percent of regular
15                                   direct hours? What is the reason for the overtime?                    L
                                     Does it seem reasonable?
       Capacity          Materials   What is the current machine utilization as a
16                                                                                                         L
                                     percentage ?
       Capacity          Materials   Is the capacity sufficient to meet Dana production
                                     demands, taking into account process yields and all
17                                                                                                         L
                                     other production demands ?

       Capacity          Materials   Does the supplier project future load vs. capacity
                                     based on forecast information? (i.e. - EDI Info),
18                                   History, Industry projections, etc.) What is the                      L
                                     forecast time frame and is it appropriate? Include
                                     copies of supplier's documentation as appropriate.

       Capacity          Materials   What is the contingency plan for over-capacity ?
                                     Does the supplier have a documented plan
19                                   outlining necessary actions and timing required to                    L
                                     support a 20%, 40% and 60% increase in
                                     production?




      2/3/2011                                                                                                                                             Page 11 of 32
      Materials                                                                                                  21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                           0     Complete
     DUNS Number:      Cell Automaticlly Populates                                           1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                           2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                           3     No Plan / No Action Taken
                                                                                            N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                          Question                         Score   Risk                                      Findings
      Inventory          Materials   Does the supplier have a procedure to identify and
     Management                      manage part shortages for their production ?
20                                                                                                      L
                                     (How far ahead do they look ?)

      Inventory          Materials   What is the suppliers warehouse space utilization?
21                                                                                                      L
     Management
      Inventory          Materials   Does the supplier have a "controlled" warehouse
22   Management                      where deposits and withdrawals are entered by                      L
                                     authorized personnel?
      Inventory          Materials   Is material storage adequate to protect parts from
23   Management                      damaging environmental factors?                                    L
                                     (Raw material, in-process, and finished goods)
      Inventory          Materials   Does the supplier use a FIFO system to manage the
     Management                      flow of material through their system and do they
24                                                                                                      L
                                     track the age of the material in the warehouse?

      Inventory          Materials   Does the supplier have a procedure to prevent the
     Management                      accumulation of inventory well in excess of quoted
                                     lead-times? What is the risk of excess inventory if
25                                   a change were made within quoted lead-times (i.e.                  L
                                     are there any tier 2 suppliers with minimum buys or
                                     lead-times longer than those quoted for new
                                     orders)?
      Inventory          Materials   Does the supplier routinely perform cycle counts?
26   Management                      What are the Results? Are there action plans to                    L
                                     address noted issues?
      Inventory          Materials   Does the supplier perform a physical inventory?
     Management                      What were the latest results for accuracy as a
27                                   percentage measured against the goal? Is there a                   L
                                     formal procedure for Inventory adjustment that
                                     defines the amount and authority?

      Inventory          Materials   What are the supplier's inventory turns YTD?
28   Management                      What were their inventory turns last year? What is                 L
                                     the goal?



      2/3/2011                                                                                                                                          Page 12 of 32
      Materials                                                                                                     21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                             0      Complete
     DUNS Number:      Cell Automaticlly Populates                                             1      Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                             2      Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                             3      No Plan / No Action Taken
                                                                                              N/A     question does not apply (taken out of performance calculations)

Q#       Area           Function                          Question                           Score    Risk                                      Findings
       Handling          Materials   Has adequate protective packaging for finished
                                     product been identified and approved by Dana?
29                                                                                                         L
                                     (Verify with the plants that there are no current
                                     shipping/damage issues)
       Handling          Materials   Do the packaging labels meet Dana requirements?
30                                                                                                         L

       Handling          Materials   Does the supplier have a system to manage
31                                                                                                         L
                                     returnable containers ?
       Shipping          Materials   Does the Supplier utilize Advanced Shipping
                                     Notice's (ASN's)? Does the supplier verify the ASN
32                                   to the Bill of Lading, and are they submitted in a                    L
                                     timely manner? Concerns? (Verify with the plants
                                     for issues)
       Shipping          Materials   Does the supplier have a procedure / process to
                                     validate the contents, label accuracy, and quantities
33                                                                                                         L
                                     of all containers shipped? Results of latest
                                     validation?
       Shipping          Materials   Does the supplier monitor, track, and record
                                     shipping issues (i.e., Wrong parts, not on time,
34                                                                                                         L
                                     damage)? Have action items been initiated to
                                     address issues?
       Shipping          Materials   Is the supplier following the Dana routing
35                                                                                                         L
                                     instructions. ?
         Dana            Materials   Has a formal capacity analysis been completed and
36                                   submitted to Dana identifying all associated risks?                   L


         Dana            Materials   Has Dana communicated the primary plant and
37                                   divisions Materials contact information to the                        L
                                     supplier?
       Capacity          Materials   Has a Run-at-Rate/High Volume Production Trial
38                                   (HVPT) been completed for all predetermined                           L
                                     processes of interest? Are there any issues?

                                                                                               No
                                                               Overall MATERIALS Score                    H
                                                                                             Scores



      2/3/2011                                                                                                                                             Page 13 of 32
      Quality                                                                                                        21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                               0     Complete
     DUNS Number:      Cell Automaticlly Populates                                               1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                               2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                               3     No Plan / No Action Taken
                                                                                                N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                           Question                            Score      Risk                                   Findings
      Continuous          Quality   Is the Supplier ISO, QS, or TS registered ? If not,
1    Improvement                    does the supplier have plans to become registered                       L
                                    in the next 12 months?
     Documentation        Quality   Is there a system in place to ensure all process and
                                    product documentation reflects the current revision
2                                   level (i.e., PFMEA, Control Plans, setup sheets,                        L
                                    visual aids, etc.)? Is the documentation current?

     Documentation        Quality   Did an appropriate cross-functional team establish
3                                   the PFMEA ? (Look for list of participants, meeting                     L
                                    minutes, etc.)
     Documentation        Quality   Does the supplier have an up-to-date PFMEA?
4                                                                                                           L
                                    (look for Rev level, and date)
     Documentation        Quality   Does the PFMEA follow the Process Flow Diagram?
5                                                                                                           L

     Documentation        Quality   For the FMEA, are the risk numbers for occurrence
                                    and detection appropriately based on historical
6                                                                                                           L
                                    (statistical) data or an existing similar product (i.e.,
                                    NCP data)?
     Documentation        Quality   Are formal corrective actions developed for the
7                                   highest RPN numbers from the FMEA? Have they                            L
                                    been implemented in a timely manner?
     Documentation        Quality   Does the PFMEA include analyses of all Dana
                                    critical and significant characteristics (identified on
8                                                                                                           L
                                    the drawings and/or specifications)? Does it also
                                    include the Suppliers key characteristics?
     Documentation        Quality   Is the control plan part specific, family specific, or
9                                   generic? Was it developed by a cross functional                         L
                                    team?
     Documentation        Quality   Does the control plan follow the Process Flow
10                                                                                                          L
                                    Diagram / Process FMEA?
     Documentation        Quality   Does the Control Plan include all Dana critical and
11                                  significant characteristics? Does it also include                       L
                                    the Suppliers key characteristics?
     Documentation        Quality   Does the control plan identify gauges and test
12                                                                                                          L
                                    equipment required for inspection?


      2/3/2011                                                                                                                                              Page 14 of 32
      Quality                                                                                                       21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                              0     Complete
     DUNS Number:      Cell Automaticlly Populates                                              1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                              2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                              3     No Plan / No Action Taken
                                                                                               N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                          Question                            Score      Risk                                   Findings
     Documentation        Quality   Are setup, operator, and inspection instructions
13                                  tied directly to the control plan? Are they in place?                  L


     Documentation        Quality   Were the operators or manufacturing team leaders
14                                  involved in the creation of the operating                              L
                                    instructions ?
15   Documentation        Quality   Are set-up instructions and/or checklists in place?                    L
     Documentation        Quality   Do the operator instructions include all Dana
                                    critical and significant characteristics (identified on
16                                                                                                         L
                                    the drawings and/or specifications)? Do they also
                                    include the Suppliers key characteristics?
17   Documentation        Quality   Are rework and repair procedures documented?                           L
     Measurement          Quality   Is there a procedure to develop and qualify all
18                                                                                                         L
       Systems                      gauge / test fixtures? Is it in use?
     Measurement          Quality   Are Engineering revision levels, gauge i.d.
19     Systems                      numbers, and calibration dates clearly identified on                   L
                                    all gauges ?
     Measurement          Quality   Are gauges and test fixtures stored in an
20                                                                                                         L
       Systems                      appropriate place when not in use ?
     Measurement          Quality   Does the Supplier have internal CMM capability or
21     Systems                      are they outsourcing? What type of CMM is used?                        L
                                    (name, model, and software language)
     Measurement          Quality   What is the effective measuring envelope of the
22                                                                                                         L
       Systems                      CMM? (dimensional)
     Measurement          Quality   What are the limitations for volumes of product
23     Systems                      inspected? How is usage managed? What are the                          L
                                    capacity constraints?
     Measurement          Quality   Have MSA's been completed for all inspection
       Systems                      gauges and fixtures used to measure Dana/Supplier
24                                                                                                         L
                                    identified critical and/or significant characteristics?
                                    What are the results?
     Measurement          Quality   Has the Supplier identified all appropriate
25     Systems                      inspection equipment for product and process                           L
                                    verification at all steps of the process?



      2/3/2011                                                                                                                                             Page 15 of 32
      Quality                                                                                                  21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                         0     Complete
     DUNS Number:      Cell Automaticlly Populates                                         1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                         2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                         3     No Plan / No Action Taken
                                                                                          N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                        Question                         Score      Risk                                   Findings
      Operations          Quality   Is there a System for identifying/segregating non-
26                                  conforming material in receiving, in-process and                  L
                                    finished product areas?
      Operations          Quality   Does the Supplier track upcoming PPAP
27                                  requirements for Dana? Does the Supplier's                        L
                                    schedule agree with Dana's schedule?
      Operations          Quality   Does the Supplier track PPAP performance with
28                                                                                                    L
                                    Dana? Are actions being taken to address issues?
      Operations          Quality   Has the Supplier completed/scheduled PPAP's for
29                                  Dana/Supplier proprietary lower level components?                 L
                                    Are there any issues or concerns?
       Capability         Quality   Are machine process capability studies completed
30                                  and documented for all pieces of equipment (both                  L
                                    short and long term capability) ?
      Performance         Quality   Does the Supplier monitor their on-time delivery?
31                                  Are issues being addressed? (verify performance                   L
                                    with the plants)
      Performance         Quality   What is the Supplier's 6 month PPAP Approval
32                                  performance?                                                      L
                                    >=99% = 0, 98%=1, 97%=2, <97%=3
      Performance         Quality   What is the Supplier's 6 month PPAP On Time
33                                  performance?                                                      L
                                    >97% = 0, 96%=1, 95%=2, <94%=3
      Performance         Quality   What is the Suppliers current PPM performance
34                                                                                                    L
                                    with Dana?       <50=0, <250=1, <500=2, >500=3
      Performance         Quality   Has the Supplier been ranked as a "Bottom 10"
35                                  performing supplier during the last 6 months?                     L
                                    No = 0, Yes = 3
        Training          Quality   Has a training matrix been established to track
36                                  team members' training for all departments? (Do                   L
                                    they have a training schedule, and procedure?)
        Training          Quality   Is there a system in place to train new team
37                                                                                                    L
                                    members?
        Training          Quality   Have production trainers been identified for each
38                                                                                                    L
                                    shift? How have the trainers been qualified?


      2/3/2011                                                                                                                                        Page 16 of 32
      Quality                                                                                                    21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                           0     Complete
     DUNS Number:      Cell Automaticlly Populates                                           1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                           2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                           3     No Plan / No Action Taken
                                                                                            N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                         Question                          Score      Risk                                   Findings
        Training          Quality   Has appropriate training been conducted to ensure
                                    proper measuring techniques are used at all levels
39                                                                                                      L
                                    of production (i.e., Training records, log,
                                    standards)?
        Training          Quality   How does the Supplier determine effectiveness of
40                                  the training (Ex: tests during training, practical                  L
                                    evaluation)?
        Training          Quality   Are the operators who perform special
                                    manufacturing processes (i.e. welding, painting)
41                                                                                                      L
                                    qualified / certified? How are they qualified or
                                    certified?
      Continuous          Quality   Are systems in place for continuous data collection
     Improvement                    to drive 'continuous improvement'? What proof is
42                                  there to show continuous improvement? (Review                       L
                                    monthly performance metrics)

      Continuous          Quality   Is SPC being used to better understand
43                                                                                                      L
     Improvement                    product/process variation? How is it being used?
      Continuous          Quality   Is the SPC data available to the operator? How is it
44                                                                                                      L
     Improvement                    being used to control part/process variation?
      Continuous          Quality   Does the Supplier have a process to track and
     Improvement                    manage internal scrap? What is their current scrap
45                                                                                                      L
                                    rate? What are the Action plans to address issues?

      Continuous          Quality   Does the Supplier review non-conforming parts to
46                                                                                                      L
     Improvement                    determine root cause?
      Continuous          Quality   Is there a formal problem solving method in use?
47   Improvement                    Are the appropriate people trained in that method?                  L


      Continuous          Quality   Does the Supplier track both internal and external
48   Improvement                    open and closed corrective actions? Are they                        L
                                    conforming to the 3/10 Day criteria?
      Continuous          Quality   How are corrective actions monitored for
49                                                                                                      L
     Improvement                    effectiveness?




      2/3/2011                                                                                                                                          Page 17 of 32
      Quality                                                                                                    21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                          0      Complete
     DUNS Number:      Cell Automaticlly Populates                                          1      Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                          2      Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                          3      No Plan / No Action Taken
                                                                                           N/A     question does not apply (taken out of performance calculations)

Q#       Area           Function                         Question                         Score       Risk                                   Findings
      Continuous          Quality   Does the Supplier track quality levels by customer
50   Improvement                    location? What are current goals and performance                    L
                                    levels?
      Continuous          Quality   Is there a procedure and process in place to review
51   Improvement                    each process step for mistake-proofing                              L
                                    opportunities?
      Continuous          Quality   Does the Supplier perform internal audits of their
52                                                                                                      L
     Improvement                    quality system? How often? Results?

                                                                                            No
                                                                Overall QUALITY Score                  H
                                                                                          Scores




      2/3/2011                                                                                                                                          Page 18 of 32
      Purchasing                                                                                                 21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                           0     Complete
     DUNS Number:      Cell Automaticlly Populates                                           1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                           2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                           3     No Plan / No Action Taken
                                                                                            N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                          Question                         Score      Risk                                   Findings
      Commercial        Purchasing Has the Supplier provided the financial information
1                                  identified on the Dana Financial Information Audit                   L
                                   form?
      Commercial        Purchasing Does the Supplier have a system to manage RFQ's
                                   to ensure that quotes are submitted in a timely
2                                                                                                       L
                                   manner? (Procedures, Tracking Log, Performance
                                   metrics)
      Commercial        Purchasing How does the Supplier communicate customer
3                                  requirements to the appropriate groups (tier-1, tier-                L
                                   2) during the quoting process?
      Commercial        Purchasing Does the Supplier review quotes for pricing
4                                                                                                       L
                                   consistency and accuracy prior to submission?
      Commercial        Purchasing Have capacity constraints for the quoting process
5                                  been established and communicated to Dana?                           L


      Commercial        Purchasing How does the Supplier communicate all Dana
                                   requirements to a Tier 2 Supplier? Is the Supplier
6                                  tracking a part file for latest revision levels                      L
                                   /specifications / prints? Are our specifications
                                   referenced in P.O.'s or other documents sent to the
                                   Tier 2 Supplier?
      Commercial        Purchasing Does the Tier 2 Supplier know which specifications
7                                                                                                       L
                                   apply to them ?
      Commercial        Purchasing Is the suppliers facility unionized? If yes, when
8                                                                                                       L
                                   does the union contract expire ?
      Commercial        Purchasing If Unionized, has the Supplier submitted the strike
                                   protection plan? Is the Supplier aware of Dana's
9                                                                                                       L
                                   requirement to have and maintain 90 days of
                                   inventory in times of a labor dispute ?
      Commercial        Purchasing What type of labor disputes has the Supplier had in
10                                                                                                      L
                                   the past ?
      Commercial        Purchasing Have all commercial/Business issues been
                                   resolved between the Supplier and Dana
11                                                                                                      L
                                   Purchasing? (ex: pricing, LTA's, exclusivity
                                   agreements, etc.)



      2/3/2011                                                                                                                                          Page 19 of 32
      Purchasing                                                                                                   21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                            0      Complete
     DUNS Number:      Cell Automaticlly Populates                                            1      Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                            2      Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                            3      No Plan / No Action Taken
                                                                                             N/A     question does not apply (taken out of performance calculations)

Q#       Area           Function                           Question                         Score       Risk                                   Findings
      Commercial        Purchasing How does the Supplier effectively communicate
12                                 changes and additions to Dana specific business                        L
                                   throughout their organization?
         Dana           Purchasing Has the Dana Purchasing Controller reviewed and
                                   approved the financial information identified on the
13                                                                                                        L
                                   Dana Financial Information Audit form?

         Dana           Purchasing Has Purchasing sent all relevant drawings and
14                                 specifications, including all significant and critical                 L
                                   characteristics, to the Supplier ?
         Dana           Purchasing Has Dana obtained a current Warranty Support
15                                                                                                        L
                                   Agreement signed by the supplier?

                                                                                              No
                                                             Overall PURCHASING Score                    H
                                                                                            Scores




      2/3/2011                                                                                                                                            Page 20 of 32
      Critical Tier 2 Mgmt                                                                                            21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                                0     Complete
     DUNS Number:      Cell Automaticlly Populates                                                1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                                2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                                3     No Plan / No Action Taken
                                                                                                 N/A    question does not apply (taken out of performance calculations)

Q#       Area            Function                             Question                          Score      Risk                                   Findings
       Materials       Critical Tier 2 Has the Supplier identified all critical raw materials
                            Mgmt       and lower level components? Have Tier 2 suppliers
1                                                                                                            L
                                       been identified for these components?

       Materials       Critical Tier 2   Are any of the critical raw material/lower level
2                                                                                                            L
                            Mgmt         components sourced from overseas suppliers?
       Materials       Critical Tier 2   Are any of the critical raw material/lower level
3                           Mgmt         components sourced from Dana-directed                               L
                                         suppliers?
       Materials       Critical Tier 2   Have all single source Tier 2 Suppliers of critical
4                           Mgmt         raw materials and lower level components been                       L
                                         identified as "Critical Tier 2" Suppliers?
       Materials       Critical Tier 2   Are all critical raw materials and lower level
5                           Mgmt         components readily available through multiple                       L
                                         sources?
       Materials       Critical Tier 2    Has the Supplier conducted a formal capacity
6                           Mgmt         analysis of Critical Tier 2 Suppliers? Are there any                L
                                         concerns?
       Materials       Critical Tier 2   Has the Supplier communicated the projected ramp-
7                           Mgmt         up and peak demands to Critical Tier 2 Suppliers ?                  L


        Quality        Critical Tier 2 Does the supplier have a process/procedure to
8                           Mgmt       manage their Tier 2 suppliers? Is it documented                       L
                                       and Is it effective?
        Quality        Critical Tier 2 Does the supplier require PPAP's from Critical Tier
9                           Mgmt       2 Suppliers? Are there any issues or concerns?                        L


        Quality        Critical Tier 2 Does the Supplier track PPAP
                            Mgmt       submissions/approvals and NCP/PPM performance
10                                                                                                           L
                                       for Critical Tier 2 Suppliers? Are there any
                                       identified performance issues?
        Quality        Critical Tier 2 Does the Supplier require Critical Tier 2 Suppliers
                            Mgmt       to demonstrate acceptable process capability for all
11                                     Dana/Tier 1 critical and significant characteristics                  L
                                       (Cp >= 2.0, Ppk >= 1.67, PPM = 76 for attribute data)
                                       ?

      2/3/2011                                                                                                                                               Page 21 of 32
      Critical Tier 2 Mgmt                                                                                          21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                              0     Complete
     DUNS Number:      Cell Automaticlly Populates                                              1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                              2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                              3     No Plan / No Action Taken
                                                                                               N/A    question does not apply (taken out of performance calculations)

Q#       Area           Function                           Question                           Score      Risk                                   Findings
        Quality        Critical Tier 2 Does the Supplier monitor Critical Tier 2 corrective
12                          Mgmt       actions for timeliness(3/10) and effectiveness?                     L


          ME           Critical Tier 2 Has the Supplier identified all critical special
                            Mgmt       processes (Painting, plating, polishing, welding,
13                                                                                                         L
                                       etc.) that will be outsourced? Have Tier 2 suppliers
                                       been identified for these processes?
          ME           Critical Tier 2 Are any of the critical special processes being
14                                                                                                         L
                            Mgmt       outsourced to Dana-directed suppliers?
          ME           Critical Tier 2 Have all single source Tier 2 special process
15                          Mgmt       suppliers been identified as "Critical Tier 2"                      L
                                       Suppliers?
          ME           Critical Tier 2 Have the single-source Tier 2 special process
16                          Mgmt       suppliers been qualified by a 3rd Party Registrar?                  L
                                       Is their status current?
          ME           Critical Tier 2 Has the Supplier conducted a formal capacity
17                          Mgmt       analysis of Critical Tier 2 special process                         L
                                       Suppliers? Are there any concerns?
          ME           Critical Tier 2 Has the Supplier communicated the projected ramp-
18                          Mgmt       up and peak demands to Critical Tier 2 special                      L
                                       process Suppliers ?
          ME           Critical Tier 2 Has the Supplier reviewed Critical Tier 2 facilities
                            Mgmt       that are involved in the manufacturing and/or
19                                     storage of Dana goods and equipment to ensure                       L
                                       adequate protection from damage/loss due to Fire,
                                       Flood, etc?
          ME           Critical Tier 2 Has the Supplier validated that Critical Tier 2
                            Mgmt       Suppliers have established procedures and
20                                     controls to protect raw material from                               L
                                       contamination (i.e., mixed lots, resins, paint
                                       batches, adhesives)?
          ME           Critical Tier 2 Has the Supplier validated that Critical Tier 2
                            Mgmt       Suppliers have controls in place to prevent the
21                                                                                                         L
                                       accidental mixing or unauthorized substitution of
                                       materials (grades, lots)?



      2/3/2011                                                                                                                                             Page 22 of 32
      Critical Tier 2 Mgmt                                                                                               21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                                  0      Complete
     DUNS Number:      Cell Automaticlly Populates                                                  1      Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                                  2      Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                                  3      No Plan / No Action Taken
                                                                                                   N/A     question does not apply (taken out of performance calculations)

Q#       Area            Function                            Question                             Score       Risk                                   Findings
          ME           Critical Tier 2 Has the Supplier validated that Critical Tier 2
                            Mgmt       Suppliers have a formal maintenance and
22                                     preventative maintenance management system?                              L
                                       Does it include all production equipment, tooling
                                       and supporting fixtures? Can it track specific
                                       tools? Is it being followed?
          ME           Critical Tier 2 Have all Critical Tier 2 Suppliers received all
                            Mgmt       appropriate engineering specifications? Do they
23                                                                                                              L
                                       concur with the requirements established in the
                                       specifications?
          ME           Critical Tier 2 Does the Tier 1 Supplier verify that all Critical Tier 2
                            Mgmt       Suppliers are in compliance with Dana
24                                                                                                              L
                                       specifications and/or Government regulations
                                       (DOT, FMVSS) on a regular basis?
          ME           Critical Tier 2 Has the Supplier validated that all Critical Tier 2
25                          Mgmt       Suppliers are in compliance with all applicable                          L
                                       federal/local environmental statutes/guidelines?
      Purchasing       Critical Tier 2 Has the Supplier validated the financial stability of
26                          Mgmt       the Critical Tier 2 Suppliers? Were there any                            L
                                       financial concerns?
      Purchasing       Critical Tier 2 Does the Supplier know which Critical Tier 2
27                          Mgmt       Supplier facilities are unionized? If unionized,                         L
                                       when do the union contracts expire ?
      Purchasing       Critical Tier 2 If Critical Tier 2 Suppliers are unionized, have they
28                          Mgmt       submitted a strike protection plan to the Supplier?                      L


      Purchasing       Critical Tier 2   What type of labor disputes have Critical Tier 2
29                                                                                                              L
                            Mgmt         Suppliers had in the past ?
      Purchasing       Critical Tier 2   Does the Supplier have exclusivity arrangements
30                                                                                                              L
                            Mgmt         with single-source Critical Tier 2 Suppliers?

                                                                                                    No
                                              Overall CRITICAL TIER 2 MANAGEMENT Score                         H
                                                                                                  Scores




      2/3/2011                                                                                                                                                  Page 23 of 32
       Design & Reliability                                                                                           21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                               0      Complete
     DUNS Number:      Cell Automaticlly Populates                                               1      Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                               2      Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                               3      No Plan / No Action Taken
                                                                                                N/A     question does not apply (taken out of performance calculations)

                                                          Is this section required (yes/no):
Q#        Area          Function                            Question                           Score       Risk                                   Findings
      New Content       Design &      Does the Supplier have a detailed listing (down to
                        Reliability   the part level) of all the changes being made to the
1                                                                                                            L
                                      existing product within the scope of this project?

      New Content       Design &      What is the Supplier's method for determining the
2                                                                                                            L
                        Reliability   percentage of new content in the product?
        D-FMEA          Design &      Has a D-FMEA been completed for this project? Is
                        Reliability   it current and comprehensive? Were appropriate
3                                                                                                            L
                                      individuals involved in it's development?

        D-FMEA          Design &      Have action items been initiated to address the
4                                                                                                            L
                        Reliability   high RPN failure modes identified in the D-FMEA?
      Known Failure     Design &      Have corrective actions been initiated to address
     Mode Corrective    Reliability   all failure modes observed by the Supplier during
5                                                                                                            L
         Action                       field testing/validation? What is the status of the
                                      C/A's (on-time, late, etc.)?
        DVP&R           Design &      Has the design team completed a Design Validation
                        Reliability   Plan & Report (DVP&R) for each new product model
6                                                                                                            L
                                      that addresses all design/reliability concerns?

        DVP&R           Design &      Is the Supplier testing in accordance with the
7                       Reliability   DVP&R? What is the status of the testing (%                            L
                                      completed, results, etc.)?
        DVP&R           Design &      Within the DVP&R, how have the confidence and
8                                                                                                            L
                        Reliability   risk levels been calculated?
       Reliability      Design &      Has the design team developed a Reliability Growth
9                                                                                                            L
      Growth Plan       Reliability   Plan for each new product model?
       Reliability      Design &      Is the Reliability Growth Plan being followed? Is it
10                                                                                                           L
      Growth Plan       Reliability   on-schedule? What is the % completion?
       Reliability      Design &      Does the methodology/approach of the Reliability
      Growth Plan       Reliability   Growth Plan appear to be valid for predicting
11                                                                                                           L
                                      product reliability performance to targets?


                                                                                                 No
                                                     Overall DESIGN & RELIABILITY Score                     H
                                                                                               Scores
      2/3/2011                                                                                                                                               Page 24 of 32
      Proj. Mgmt.                                                                                                   21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
                                                                          Progect Name:
                                                                        Project Due Date:
           Supplier:   Cell Automaticlly Populates                                              0     Complete
     DUNS Number:      Cell Automaticlly Populates                                              1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                              2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                              3     No Plan / No Action Taken
                                                                                               N/A    question does not apply (taken out of performance calculations)

                                                         Is this section required (yes/no):
Q#       Area           Function                          Question                            Score      Risk                                   Findings
       Project           Materials   Has the material flow for this project been
1                                                                                                          L
     Management                      established and deemed adequate ?
       Project           Materials   For a project, has a build plan been established (to
2    Management                      include all pre-production requirements) that will                    L
                                     meet the scheduled launch date?
       Project           Materials    Has the supplier built launch and full production
3    Management                      requirements into their production forecast?                          L


       Project           Materials   For a new Project/Part has Supplier
     Management                      completed/planned an analysis of the production
      Capacity                       process to verify cycle times and approximate
4                                                                                                          L
                                     capacity? (If not, need explanation of why one has
                                     not been completed/planned)

      Inventory          Materials   Have long lead time components been identified?
     Management                      What are those lead times? Are these components
5                                                                                                          L
                                     on order?                                  (Verify
                                     by tracing through the PO.)
       Handling          Materials   Has package configuration/design been identified
                                     and shared with the consuming Dana plants?
6                                                                                                          L
                                     (Quantity/Package, Size and Weight of Package,
                                     etc)
       Handling          Materials   Has supplier completed and documented test
7                                    shipments to validate packaging? (do the Dana                         L
                                     plants agree there are no issues)
       Handling          Materials   Have packaging materials been ordered to support
8                                    production launch requirements ? (Ex. Cardboard,                      L
                                     logistics containers)
         Dana            Materials   Have the appropriate Dana personnel reviewed and
9                                    approved the shipping specifications, methods,                        L
                                     and packaging provided by supplier?




      2/3/2011                                                                                                                                             Page 25 of 32
      Proj. Mgmt.                                                                                                   21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                              0     Complete
     DUNS Number:      Cell Automaticlly Populates                                              1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                              2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                              3     No Plan / No Action Taken
                                                                                               N/A    question does not apply (taken out of performance calculations)

                                                         Is this section required (yes/no):
Q#       Area           Function                          Question                            Score      Risk                                   Findings
         Dana            Materials   Has the Dana Division communicated launch
                                     information (firm date, daily production
10                                   requirements, by model) to the Supplier? Does the                     L
                                     launch date require an acceleration plan? Are there
                                     any concerns?
     Measurement          Quality    Are all equipment, gauges and tooling the same as
11                                                                                                         L
       Systems                       will be used in production?
      Capability          Quality    Has Pilot build data been analyzed and does it
12                                   demonstrate compliance to requirements? Have all                      L
                                     issues been closed?
       Capability         Quality    Was sufficient process capability demonstrated at
                                     pilot build on Dana critical and significant and/or
13                                                                                                         L
                                     Supplier key characteristics (Cp >= 2.0, Ppk >= 1.76,
                                     PPM = 76 for attribute data) ?
       Project             ME        Does the supplier have a procedure that identifies
14   Management                      their Quality Planning process? And are they using                    L
                                     a checklist?
       Project             ME        Has the supplier assigned a project manager ? Are
     Management                      Dana personnel aware of who this is? Has the
15                                                                                                         L
                                     project manager been fully involved in this project?

       Project             ME        Is there a procedure to create a project
16   Management                      management timeline? Does the timeline identify                       L
                                     supplier and Dana action items?
       Project             ME        Is the project management timeline being followed?
     Management                      Is it on time or behind schedule? If behind
17                                                                                                         L
                                     schedule what actions are planned to put it back on
                                     schedule?
       Project             ME        How does the supplier communicate changes
     Management                      and/or updates to the project timeline/schedule to
18                                   Dana? Has it been done in a timely manner? Who at                     L
                                     Dana receives these communications?
                                     (Project Question)




      2/3/2011                                                                                                                                             Page 26 of 32
      Proj. Mgmt.                                                                                                  21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                             0     Complete
     DUNS Number:      Cell Automaticlly Populates                                             1     Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                             2     Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                             3     No Plan / No Action Taken
                                                                                              N/A    question does not apply (taken out of performance calculations)

                                                        Is this section required (yes/no):
Q#       Area           Function                         Question                            Score      Risk                                   Findings
       Project             ME       Have all product related engineering specifications
     Management                     identified on assembly drawings been reviewed and
19                                                                                                        L
                                    accepted by the supplier? Are there any
                                    unresolved issues?
       Project             ME       Have all product related engineering specifications
     Management                     identified on component drawings been reviewed
20                                                                                                        L
                                    and accepted by the supplier? Are there any
                                    unresolved issues?
       Project             ME       Does the supplier have a system to manage and
21                                                                                                        L
     Management                     track "Supplier Requested" design changes?
       Project             ME       Have internal B.O.M's (Bills of Material) been
22   Management                     completed and tested? (Review several part                            L
                                    numbers through the B.O.M. system)
       Project             ME       Are all test and validation issues from the prototype
23   Management                     / Pilot run documented? Are they being tracked for                    L
                                    closure?
       Project             ME       Is temporary tooling required for this project? Has
24   Management                     all temporary tooling been identified?                                L
       Tooling
       Project             ME      Have all consumable / perishable tooling
25   Management                    requirements for the product under consideration                       L
       Tooling                     been identified? Is there an adequate supply?
        Dana               ME      Has Dana conducted regular pre-launch meetings
26                                 to review project status, etc? If NO, then score = 3,                  L
                                   If YES, then score = 0
         Dana              ME      Is this project scheduled to implement within 10
27                                 weeks of the PPAP date?                                                L
                                   If NO, then score = 0, If YES, then score = 3
      Commercial        Purchasing Is capital investment required by the Supplier to
28                                 support this project/product? (Do they need to buy                     L
                                   machines, tooling, buildings, etc?)
      Commercial        Purchasing Has the Supplier allocated capital to support launch
29                                                                                                        L
                                   ?




      2/3/2011                                                                                                                                            Page 27 of 32
      Proj. Mgmt.                                                                                                    21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls
           Supplier:   Cell Automaticlly Populates                                              0      Complete
     DUNS Number:      Cell Automaticlly Populates                                              1      Planned / In Process / On Time
          Location:    Cell Automaticlly Populates                                              2      Planned / Not Started / Behind Schedule
      Last Updated:    Cell Automaticlly Populates                                              3      No Plan / No Action Taken
                                                                                               N/A     question does not apply (taken out of performance calculations)

                                                         Is this section required (yes/no):
Q#       Area           Function                           Question                           Score       Risk                                   Findings
          ME           Critical Tier 2 Have the Critical Tier 2 Suppliers effectively
                            Mgmt       communicated changes and/or updates to the
30                                     project timeline/schedule to the Tier 1 Supplier?                    L
                                       Who at the Supplier receives these
                                       communications?

                                                                                                No
                                                 Overall PROJECT MANAGEMENT Score                          H
                                                                                              Scores




      2/3/2011                                                                                                                                              Page 28 of 32
               DFM Questions                                                                                                                                21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls

                Supplier:   Cell Automaticlly Populates
          DUNS Number:
               Location:
           Last Updated:
                            Cell Automaticlly Populates
                            Cell Automaticlly Populates
                            Cell Automaticlly Populates
                                                                                                                                               DFM Questions
1) What are the various manufacturing processes performed at this location? (please fill out the following matrix and provide equipment list)

                      Manufacturing Process                                Processes and
           (I.E. metal forming, metal cutting, casting,                  Equipment Used
              injection molding, painting, assembly,                    (I.E. Turret Press,             Current             Material           Max. Blank   Fully Burden
                          welding, etc.)                                Hyd press, Laser)              Application        Limitations            Size       Labor Rates                  Comments




Materials Used (list the various raw materials used at this location)


New Technologies (please describe recent processing technologies in operation or being investigated)


2) Is equipment list provided?
Note: equipment list should the following type of information:
    Example Stamping Press                                       Tonnage, bedsize, strokes/Min, mechanical or hyd, CNC controlled, Cushioned
    Example Laser                                                Power, watts, cut rate, bedsize, type - CO2 or Nd
    Example Paint                                                Type - powder coat, ecoat, spray, manual or robotic, conveyor
    Example Molding Equipment                                    Tonnage, bed size, stroke, shot size, cycle time, quick tool change out


3) Do you use the same fully burdened labor rate for all processes performed at this location?




               2/3/2011                                                                                                                                                                Page 29 of 32
           DFM Questions                                                                                                         21a7d3b2-8b19-4f7a-88a4-4f2e61a68992.xls

4) Identify any outsourced processing and list subcontractors used.



5) What accounting methods are used to depreciate plant equipment (i.e. straight line, accelerated etc) and over what period?



6) Do you build ahead of requirement to reduce set-up costs on low volume part runs?

7) What is your recommended production lot quantity or min run size for each major process?



8) Are set-up times included in your fully burdened labor rates or identified separately and allocated by prod. Lot?



9) What percentage markup is added to cover your costs and profit on purchased components?



10) Do you purchase raw material on contract or spot buys?


11) What is your average cost per pound of commonly used materials?


12) What cost management concepts are practiced in your organization (i.e. target costing, ABC, ABM)?



13) What manufacturing cost control concepts are use (i.e. DFMEA, TOC, value engineering)? Explain how and when they are used.




           2/3/2011                                                                                                                                         Page 30 of 32
         Supplier:    Cell Automaticlly Populates
   DUNS Number:       Cell Automaticlly Populates
         Location:    Cell Automaticlly Populates                     CAPACITY CONSTRAINT ANALYSIS
    Last Updated:     Cell Automaticlly Populates



Constraint Process:                                                                                        TOTAL HOURS AVAILABLE:                                0.0


# OF SHIFTS PLANNED TO OPERATE PROCESS:                                        Shift(s) A                  TOTAL HOURS REQUIRED:                                 0.0
# OF PRODUCTION HOURS per SHIFT AVAILABLE: (less down-time)                    Hour(s) B
TOTAL NUMBER OF HOURS AVAILABLE FOR PROCESS:                                   Hour(s) A x B               VARIANCE: (+/-)                                       0.0


                                                                        (C)                          (D)                            (D) / (C)
                                            PART NUMBERS            PARTS/HOUR                     DAILY                       # OF PRODUCTION
                                                                    CAPABILITY                  REQUIREMENT                    HOURS REQUIRED
                                                                                               FROM CUSTOMER
                                                                                                                                          0.00
                                                                                                                                          0.00
                                                                                                                                          0.00
         DANA PART #                                                                                                                      0.00
                                                                                                                                          0.00
                                                                                                                                          0.00
                                                                                                                                          0.00
                                                                                                                                          0.00
                                                                                                                                          0.00
                                                                                                                                          0.00
                                                                                                                                          0.00
      OTHER CUSTOMERS
                                                                                                                                          0.00
                                                                                                                                          0.00
                                                                                                                                          0.00
                                                                                                                                          0.00

                                                                                 TOTAL HOURS REQUIRED                                     0.0                  Hour(s)
     Submitted by:
             Date:                                   If variance is negative, corrective action is required. Target date to submit counter -measure plan is:




                                                                                  Load Plan
                                                                                    Revision 1.0
                                                        CAPACITY CONSTRAINT ANALYSIS



Constraint Process: ASSEMBLY                                                                             TOTAL HOURS AVAILABLE:                                13.6


# OF SHIFTS PLANNED TO OPERATE PROCESS:                              2         Shift(s) A                TOTAL HOURS REQUIRED:                                 59
# OF PRODUCTION HOURS per SHIFT AVAILABLE: (less down-time)         6.8        Hour(s) B
TOTAL NUMBER OF HOURS AVAILABLE FOR PROCESS:                       13.6        Hour(s) A x B             VARIANCE: (+/-)                                      -45.4


                                                                      (C)                            (D)                          (D) / (C)
                                     PART NUMBERS                 PARTS/HOUR                       DAILY                     # OF PRODUCTION
                                                                  CAPABILITY                    REQUIREMENT                  HOURS REQUIRED
                                                                                               FROM CUSTOMER
                                       25468-78468-00                     10                          100                                10
                                       25468-78469-00                     20                          80                                 4
                                       25468-78477-00                     10                          400                                40
        DANA PART #                                                                                                                      0
                                                                                                                                         0
                                                                                                                                         0
                                                                                                                                         0
                                       24567-45685-00                     10                          50                                 5
                                                                                                                                         0
                                                                                                                                         0
                                                                                                                                         0
     OTHER CUSTOMERS
                                                                                                                                         0
                                                                                                                                         0
                                                                                                                                         0
                                                                                                                                         0

                                                                                  TOTAL HOURS REQUIRED                                   59                  Hour(s)
     Submitted by: Paul Whitter
             Date: 5/15/2002                       If variance is negative, corrective action is required. Target date to submit counter -measure plan is:    5/25/02




                                                                     Load Plan Example
                                                                               Revision 1.0

				
DOCUMENT INFO
Description: Exclusivity Agreements document sample