Wendel Burlat | Freelancer Data Reporting

Data Reporting

Sourcing Recommendation Form REQUIRED Source By Date: Ride Height Sensors Supplier Joe Supplier Strategy Commodity Area Incumbent Supplier or Targeted Supplier Incumbent Supplier Code: Supplier TOM Summary Represents Weighted AVG 57828 Take Rate 33255 Source Package # Sourcing Type Supplier Henry STABLE Supplier Strategy Supplier TOM STABLE SUPPLIER 4 Supplier Strategy GROW Supplier Strategy STABLE ELECTRICAL Technical Evaluation OK Technical Evaluation OK Technical Evaluation OK Technical Evaluation OK Meets Program Timing YES Meets Program Timing YES Meets Program Timing YES Meets Program Timing YES Common Global Supplier YES Green Quality Rating Green Quality Rating Green Quality Rating Financial Rating Parent Green Financial Rating Parent Green Financial Rating Parent Green Financial Rating Local Green Financial Rating Local Green Financial Rating Local Green Delivery Rating Green Delivery Rating Delivery Rating Yellow Delivery Rating Yellow DSD Rating Yellow MFG Location Green MFG Location 31195N MOPAR Rating YELLOW DSD Rating Anywhere Toluca - MX MFG Location Code N/A SHIP From Location N/A MFG Location 57828 MOPAR Rating Muskegon - MI Green DSD Rating Greenville - TN MFG Location Code Green SHIP From Location Red MFG Location 53907I MOPAR Rating Anyone DSD Rating Muskegon - MI MFG Location Code Green SHIP From Location 13194 MOPAR Rating Greenville - TN N/A SHIP From Location Toluca - MX Union Affiliation None Union Affiliation None Union Affiliation None Union Affiliation None Work Pattern (S/H/D) 3/8/5 Work Pattern (S/H/D) 3/8/5 Work Pattern (S/H/D) 3/8/5 Work Pattern (S/H/D) 3/8/5 USD Standard Currency YES Green 10.00% 5/30/2016 Common Global Supplier Green MFG Location Code NPV Discount rate YES Quality Rating WL Actual Expected P.O. Placement Date Common Global Supplier Financial Rating Local 1/13/2020 S.O.P. Date Destination Plant YES Financial Rating Parent New Placement Vehicle/Program (s) Common Global Supplier Raw / Fab (Weeks) 2/6 Raw / Fab (Weeks) FCA Transportation Paid by: Indexation Payment terms 45 USD Exchange rate vs USD Price $/Vehicle Logistics Cost $/Vehicle Total Annual Cost Delivered ($M) $/Vehicle Indexation % of Business: Payment terms Other % of Business: USD Exchange rate vs USD Annual CIP Cost with Saving Logistics ($M) ($M) Other Savings ($M) % of Business: Exchange rate vs USD 100.00 100.00 52.97 52.97 101.00 97.00 97.00 32.45 32.45 1.00 3.0% 97.97 3.0% 94.09 94.09 42.11 42.11 1.30 3.0% 3.0% 91.27 91.27 40.84 40.84 1.26 3.0% 2.0% 89.44 89.44 40.03 40.03 0.82 2.0% 2021 529,694 105.00 1.00 106.00 55.62 56.15 2022 334,579 3.0% 101.85 1.00 102.85 34.08 34.41 1.05 3.0% 2023 447,524 3.0% 98.79 1.00 99.79 44.21 44.66 1.37 2024 447,524 3.0% 95.83 1.00 96.83 42.89 43.33 1.33 2025 447,524 95.83 1.00 96.83 42.89 43.33 2026 30 USD Annual Cost with Logistics ($M) CIP % Price $/Vehicle Logistic Cost $/Vehicl e Payment terms CIP Saving ($M) Other Savings ($M) 2.0% Indexation 100% Annual Cost ($M) Annual Cost with Logistics ($M) 101.00 53.50 53.50 97.97 32.78 32.78 1.01 95.03 95.03 42.53 42.53 1.32 92.18 92.18 41.25 41.25 1.28 90.34 90.34 40.43 40.43 0.83 Total 210.49 210.49 Total Price Logistic Cost Delivered $/Vehicle $/Vehicle $/Vehicle CIP % 2/6 FCA Transportation Paid by: NONE Quoted Currency Annual Cost ($M) VOLUME (FPV) MY Total CIP % 100% Raw / Fab (Weeks) FCA Indexation Total Delivered $/Vehicle YEAR (MY) 2/6 Transportation Paid by: NONE Quoted Currency 100% Raw / Fab (Weeks) FCA Transportation Paid by: NONE Quoted Currency 2/6 CIP Saving ($M) Other Savings ($M) NONE Payment terms 45 Quoted Currency USD CIP % Price $/Vehicle Logistic Cost $/Vehicl e % of Business: 100% Exchange rate vs USD Total Delivered $/Vehicle Annual Cost ($M) Annual Cost with Logistic CIP Saving ($M) 2.0% - Total 2,206,845 Total 219.68 221.89 Average APV 52.84 TARGET COSTS Variable NPV WITHOUT CIP ($M) Total 3.75 $44.83 $193.79 $3.81 FastCar Tooling ($M) $0.09 Tooling $2.0 Var. NPV w/CIP $184.65 Tooling $2.4 FastCar ED&D ($M) $0.02 ED&D $0.3 Total Delivered NPV $188.75 ED&D $0.1 Current CY Savings: $0.75 $110.00 Other FastCar Target Avg. APV($M) $1.68 Target NPV w/ Logistics FastCar Target NPV ($M) $7.14 Other cost ($M) FastCat Target NPV with Logistics ($M) Other Savings NPV: $8.98 Net Delivered NPV NOT RECOMMENDED 4.39 $42.19 $184.56 Var. NPV w/CIP Target NPV w/ Logistics Variable NPV WITHOUT CIP ($M) ---------------------- $ Millions ------------------------- Total Average APV Variable NPV WITHOUT CIP ($M) ---------------------- $ Millions ------------------------- $175.30 Tooling $1.5 Var. NPV w/CIP $177.05 Tooling Var. NPV w/CIP Total Delivered NPV $177.83 ED&D $0.2 Total Delivered NPV $178.75 ED&D Total Delivered NPV Current CY Savings: $1.00 Current CY Savings: $0.50 Other Savings NPV: $7.14 4.43 $42.44 $186.41 Average APV ---------------------- $ Millions ------------------------- Other $188.00 208.40 Variable NPV WITHOUT CIP ($M) FastCar Piece Cost ($/vehicle) ---------------------- $ Millions ------------------------- 208.40 Average APV Net Delivered NPV Other Savings NPV: Other $176.83 NOT RECOMMENDED Target NPV w/ Logistics $7.14 Net Delivered NPV RECOMMENDED Page 1 Current CY Savings: Other $178.25 Target NPV w/ Logistics Other Savings NPV: $7.14 Net Delivered NPV NOT RECOMMENDED Other Savings ($M) Supplier Cost Comparison Summary Vehicle/Program: WL Commodity/Component: Ride Height Sensors Supplier Henry Supplier TOM SUPPLIER 4 Shipping Location Indexation Supplier Joe 441,369 Start of Production: 1/13/2020 Launch Model Year: 2022 2023 2024 Anywhere Anyone USD NONE 3.0% 3.0% 3.0% Muskegon MI Greenville TN Muskegon MI Greenville TN USD NONE 3.0% 3.0% USD NONE 3.0% 3.0% Toluca - MX Toluca - MX USD NONE IN $USD MILLIONS MY 2021 2021 Current or Targeted Supplier from Standardization Supplier TOM CIP - Productivity (% Reduction) MFG Location Currency Supplier Name Avg. Annual Volume: IN $USD MILLIONS Piece Cost ($) Total Delivered Cost ($) Tooling Cost ED&D Cost Variable NPV w/o CIP Variable NPV with CIP Delivered NPV Current Year Savings Other Savings NPV Net Delivered NPV 2025 2026 $105.00 $106.00 $2.00 $0.25 $193.79 $184.65 $188.75 $0.75 $188.00 3.0% 2.0% 2.0% $100.00 $100.00 $2.42 $0.11 $184.56 $175.30 $177.83 $1.00 $176.83 3.0% 2.0% 2.0% $101.00 $101.00 $1.50 $0.20 $186.41 $177.05 $178.75 $0.50 $178.25 $3.81 N/A $0.09 $0.02 CURRENT TARGETS Target NPV with Logistics CIP NPV Future CIP % Required Source By Date: Expected Contract Placement Date: 5/30/2016 < SUPPLIER #1 's $50K BPI contributions are for EMEA < SUPLLIER #1 will increase their DSD score with the award of this business < Ratio Sourced/Target = 13% below target < Negotiated $700K movement in SUPPLIER's 2016 NAFTA BPI (pre-rfq) Page 2 $110.00 $9.35 5.02% Supplier Landscape & Strategic Vision External Door Handles < Commodity Strategy to be Updated in 2017 < To Be Updated In Coordination With Standardization Plans < Standarization Commity Working on "J1" Latch/Handle Solutions < APV is growing as content is added: Passive Entry, Lighting Page 3 Commodity Area: Commodity Name: Vehicle / Program(s): Business Unit: Region(s): APV ($M): Standardized Component: Standardization Deviation: Commodity Strategy, Status and Approval Date: Presentation Date: ELECTRICAL Ride Height Sensors WL FCA US NAFTA $1 M Yes No Approved Pre-RFQ UPDATE_ME UPDATE_ME Source Package Presenter Global Commodity Manager Team Members 33255 Purchasing - NAFTA Supplier Quality Engineer Design Release Engineer Purchasing - EMEA Purchasing - LATAM Purchasing - APAC Page 4 Package Content Summary Standardization Plan Program WL Part Description Ride Height Sensors Name Knee Airbag Family C2 Current Supplier / Targeted Suppler (for resourcing or standardization) TARGET COSTS First Application or Reapplication Piece Price Supplier TOM First ($) Tooling ($M) ED&D ($M) APV ($M) NPV ($M) $3.81 $0.1 $0.0 $1.7 $7.1 NPV Total: Text Box - Briefly describe Sourcing Strategy (if needed), and any other pertinent issues related to this Pre-RFQ and the overall sourcing action. Post additional information as required. Page 5 $7.1 SUPPLIER METRICS SUMMARY PROGRAM: PART/SYSTEM DESCRIPTION WL Ride Height Sensors SUPPLIER Supplier Mfg. Location Name Supplier Group Name (Top Parent) Average Annual Volume: Start of Production: QUALITY FIRST Pre-RFQ Quality First Ranking SUPPLIER RATINGS Quality Relative % to Composite #1 (Top Score Rated) QUOTATION OVERVIEW 441,369 1/13/2020 REGIONAL SPECIFIC Financial Rating: Supplier Financial Rating: Group (Parent) Sustainability Technical Evaluation Meets Program Timing Logistic Assessment Ship-From Location Supplier Joe 6 37% 63% Green Green Green Green Yellow Green Anyone Supplier Henry 1 98% 98% Green Green Green Green Green Green Muskegon - MI Supplier TOM 1 100% 100% Green Green Green Green Green Green Greenville - TN Green Green Green Red Red Green Toluca - MX SUPPLIER 4 < Recommeded Supplier is SUPPLIER #3 < SPLLIER #4 Elected To "No Quote" This Source Package Page 6 BENCHMARKING Bottom Up + Benchmark Walk From Current Part + Benchmark Cost Breakdown Statistical Cost Model 22,5 20,0 17,5 15,0 Logistic costs 12,5 Othes costs 10,0 Process costs 7,5 Raw material 5,0 Procured parts 2,5 0,0 Page 7 Benchmarking OLD "NEW Style" $ 20.91 $ 20.09 Negotiated Huf's Quote to Below SCIE_DT Levels LPP Cost Drivers (R^2 = 91%) Included: Handle Style, Handle Finish, Bezel, P/E, etc. $937,298 Potential Savings on Magna Programs: DS