AutoSave File Home Insert Arial Ib BIU v Paste Clipboard WSU Case Study Instrument Clusters Winter2021.pdf.xlsx Draw Page Layout 12 ' ' Excel Search Review View Help ACROBAT Formulas Data Wrap Text General Font 5 Alignment Merge & Center $ % -8 5 Number Conditional Format as Formatting Table Styles Cell Styles A raid matti RM H Share Comments Insert Delete Format Sort & Find & Filter Select Ideas Sensitivity Cells Editing Ideas Sensitivity S UJ V W X Y A6 A B CLF F G H Also, make sure that you always consider today's business environment and economy LMNOPQR K Supplier Zio: Historically, this supplier has had production constraints, utilizing two shifts due to improperly forecasted tact time. This supplier is quoting out of their site in Chongqing, China Supplier Confianza: Supplier is based out of Nuevo Laredo, Mexico and is known to have historic quality concerns. This is a Greenfield site for them as well. Supplier Creed : Supplier is quoting from their facility in Detroit, MI which drives a high price point for labor. They are veteran owned and the incumbent for previous Instrument Clusters as well as have optimal quality scores for their site. *Note All suppliers have design capabilities to manufacture this part and all suppliers have had business with Ford in the past or currently do (not necessarily for this commodity). Tools For Success: Key Factors for Analyzing Quote 1. Price 2. Quality 3. Risk 4. Sustainability 5. Location 6. Supplier Diversity and Development Calculations Total Hours Required x Engineering Labor Rate x (1 + WACC %) / 3,900,000 pieces = ED&T Tier 1 Components - Tier 2 Components + (Mark Up from Tier 2 Components) + ED&T = Piece Price Piece Price x Volume = Annual Turnover Annual Turnover x Program Life + Tooling = Total Lifetime Costs Additional Things to Consider for the Case: Consider that these calculations do NOT include tariffs. You must take into consideration the impact that Tariffs have on the purchased components which could affect the piece price (not including ED&T which is fixed) Additionally, in order for your program to be USMCA Compliant you must consider your RVC/LVC Content Prepare an analysis from a qualitative and quantitative perspective Also, make sure that you always consider today's business environment and economy 6 Table 1 Edit Type here to search C D 10:43 AM 2/7/2021 100%