roid matti RM Share Comments 1 AutoSave On wsu Case Study Instrument Clusters_Winter2021 (1).p... Search File Home Insert Draw Design Transitions Animations Slide Show Review View Help ACROBAT Volume is amortized over the entire 6 year life of program 2 E Vehicle Volume: 660,000 3 B VARIABLE COST Tier 1 Components) Part Number Cluster Description Take Rate Total Volume (Total Vehide) Raw Materials Purchased Parts Labor Burden Scrap Profit Tooling AA $ 30.00 $ 5.66 $ JJ1T 849001 JU1T 84500 JJ1T 84900 JJ1T 84900 32.24 $ 34.58S Fully Digital-MPH Fully Digital - KPH Hybrid Type 1 Hybrid Type 2 40% 10% 25% 25% 260LCO 65000 162500 BA CA DA Display Cost Tier 2 Markup (Tier 2) ISH S 50.00 S 50.00 10% of Tier 2 S 10.00 Component S 15.00 $ $ 10.16 $ 001 $ 3.08 14.01 $0.00 $ 2.05 13.17 $ 00$ 1.59 22.50 $ 0.045 0.95 $ 200,000.00 30.00 $ 586 $ 32.00 $ 5.01$ 37.00 $ 525$ 32.20 $ 29.525 1625CO 5 U.S VARIABLE COST Tier 1 Components) Part Number Cluster Description Take Rate Total Volume (Total Vehide] Raw Materials Purchased Parts Labor Burden Scrap Profit Tooling 260000 $ 3.17 AA BA 6500 JJAT 84900 JJ1T 84900 JJ1T 84900 JJ1T 84900 $ Fuly Digital-MPH Fully Digital - KPH Hybrid Type 1 Hybrid Type 2 40% 10% 25% 25% 20.07S 32.255 30.50 5 27.545 Display Cost Tier 2 Markup (Tier 2) 151 $ 50.00 IS 50.00 10% of Tier2 S 10.00 Component $ 15.00 30.00 $ 401 $ 30.00 $ 436 $ S 32.00 $ 4.49 $ 37.00 $ 473 $ 8.74 $ 0.01$ 12.05 $ 0.00 $ 11.33 $ 0.05 S 480,000.00 162500 $ CA DA 2.11 1.64 0.98 162500 $ 19.35 $ 0.04 $ Mexico VARIABLE COST Tier 1 Components) Part Number Cluster Description Take Rate Total Volume (Total Vehide] Raw Materials Purchased Parts Labor Burden Scrap Profit Tooling 2.15 AA BA CA 260000 68000 5 S JJ1T 84900 JJ1T 84900 JJ1T 84000 JJ1T 84900 Fuly Digital - MPH Fully Digital - KPH Hybrid Type 1 Hybrid Type 2 1.44 40% 10% 25% 25% 26.00 $ 27.89S 26.37 $ 23.81 $ 30.00 $ 290$ 30.00 $ 315$ 32.00$ 324 $ 37.00 $ 341 $ 7.11 $ 0.04 $ 9.81 $ 000 $ 9.32 $ 0.06 $ Display Cost Tier 2 Markup (Tier 2) $1 S 50.00 S 50.00 10% of Tier2 S 10.00 Component $ 15.00 $ 162500 $ 1.11 DA 162500 $ 15.75 S 001$ 0.67 Click to add notes Slide 3 of 3 Notes BA Type here to search o BI P . 11:06 AM 2/7/2021 AutoSave On 59 WSU Case Study Instrument Clusters_Winter2021 (1).p... Search roid matti RM File Home Insert Draw Design Transitions Animations Slide Show Review View Help ACROBAT Share Comments 1 2 3 3 Ford Motor Company - GSC5650 Ford Instrument Clusters ED&T Labor Budget (Man Hours) Engineer Type Labor Rate ($) Design/Product Engr $ CAE Engr $ CAD/MCAD/ECAD Designer $ System/Application Engr $ Product Assurance/Validation Engr. $ Test Engr $ 68.00 68.00 68.00 68.00 68.00 68.00 Total Hours Required (per WACC (Weighted Engineer) Average Cost of Capital 2600 1450 2250 2000 1050 150 8% Volume is amortized over the entire 6 year life of program Vehicle Volume: 650 000 VARIABLE COST |Tier 1 Components) Part Number Cluster Description Tale Rate Total Volume Total Vetidel Raw Materials Purchased Parts Labor Burden Scrap Profit Display Cast Tier2 Markup I Tier1 Tooling Click to add notes Slide 3 of 3 Notes 1454 Type here to search BI P 11:04 AM 2/7/2021 AutoSave On 59 wsU Case Study Instrument Clusters_Winter2021 (1).... Search roid matti RM File Home Insert Draw Animations Slide Show Review View ACROBAT Shape Format Share Comments 1 Design Transitions Help 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. 2 3 *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 o 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 Click to add notes Slide 2 of 3 2 3 D Notes 1294 Type here to search BI P 11:08 AM 2/7/2021 roid matti RM Share Comments 1 AutoSave On wsu Case Study Instrument Clusters_Winter2021 (1).p... Search File Home Insert Draw Design Transitions Animations Slide Show Review View Help ACROBAT Volume is amortized over the entire 6 year life of program 2 E Vehicle Volume: 660,000 3 B VARIABLE COST Tier 1 Components) Part Number Cluster Description Take Rate Total Volume (Total Vehide) Raw Materials Purchased Parts Labor Burden Scrap Profit Tooling AA $ 30.00 $ 5.66 $ JJ1T 849001 JU1T 84500 JJ1T 84900 JJ1T 84900 32.24 $ 34.58S Fully Digital-MPH Fully Digital - KPH Hybrid Type 1 Hybrid Type 2 40% 10% 25% 25% 260LCO 65000 162500 BA CA DA Display Cost Tier 2 Markup (Tier 2) ISH S 50.00 S 50.00 10% of Tier 2 S 10.00 Component S 15.00 $ $ 10.16 $ 001 $ 3.08 14.01 $0.00 $ 2.05 13.17 $ 00$ 1.59 22.50 $ 0.045 0.95 $ 200,000.00 30.00 $ 586 $ 32.00 $ 5.01$ 37.00 $ 525$ 32.20 $ 29.525 1625CO 5 U.S VARIABLE COST Tier 1 Components) Part Number Cluster Description Take Rate Total Volume (Total Vehide] Raw Materials Purchased Parts Labor Burden Scrap Profit Tooling 260000 $ 3.17 AA BA 6500 JJAT 84900 JJ1T 84900 JJ1T 84900 JJ1T 84900 $ Fuly Digital-MPH Fully Digital - KPH Hybrid Type 1 Hybrid Type 2 40% 10% 25% 25% 20.07S 32.255 30.50 5 27.545 Display Cost Tier 2 Markup (Tier 2) 151 $ 50.00 IS 50.00 10% of Tier2 S 10.00 Component $ 15.00 30.00 $ 401 $ 30.00 $ 436 $ S 32.00 $ 4.49 $ 37.00 $ 473 $ 8.74 $ 0.01$ 12.05 $ 0.00 $ 11.33 $ 0.05 S 480,000.00 162500 $ CA DA 2.11 1.64 0.98 162500 $ 19.35 $ 0.04 $ Mexico VARIABLE COST Tier 1 Components) Part Number Cluster Description Take Rate Total Volume (Total Vehide] Raw Materials Purchased Parts Labor Burden Scrap Profit Tooling 2.15 AA BA CA 260000 68000 5 S JJ1T 84900 JJ1T 84900 JJ1T 84000 JJ1T 84900 Fuly Digital - MPH Fully Digital - KPH Hybrid Type 1 Hybrid Type 2 1.44 40% 10% 25% 25% 26.00 $ 27.89S 26.37 $ 23.81 $ 30.00 $ 290$ 30.00 $ 315$ 32.00$ 324 $ 37.00 $ 341 $ 7.11 $ 0.04 $ 9.81 $ 000 $ 9.32 $ 0.06 $ Display Cost Tier 2 Markup (Tier 2) $1 S 50.00 S 50.00 10% of Tier2 S 10.00 Component $ 15.00 $ 162500 $ 1.11 DA 162500 $ 15.75 S 001$ 0.67 Click to add notes Slide 3 of 3 Notes BA Type here to search o BI P . 11:06 AM 2/7/2021 AutoSave On 59 WSU Case Study Instrument Clusters_Winter2021 (1).p... Search roid matti RM File Home Insert Draw Design Transitions Animations Slide Show Review View Help ACROBAT Share Comments 1 2 3 3 Ford Motor Company - GSC5650 Ford Instrument Clusters ED&T Labor Budget (Man Hours) Engineer Type Labor Rate ($) Design/Product Engr $ CAE Engr $ CAD/MCAD/ECAD Designer $ System/Application Engr $ Product Assurance/Validation Engr. $ Test Engr $ 68.00 68.00 68.00 68.00 68.00 68.00 Total Hours Required (per WACC (Weighted Engineer) Average Cost of Capital 2600 1450 2250 2000 1050 150 8% Volume is amortized over the entire 6 year life of program Vehicle Volume: 650 000 VARIABLE COST |Tier 1 Components) Part Number Cluster Description Tale Rate Total Volume Total Vetidel Raw Materials Purchased Parts Labor Burden Scrap Profit Display Cast Tier2 Markup I Tier1 Tooling Click to add notes Slide 3 of 3 Notes 1454 Type here to search BI P 11:04 AM 2/7/2021 AutoSave On 59 wsU Case Study Instrument Clusters_Winter2021 (1).... Search roid matti RM File Home Insert Draw Animations Slide Show Review View ACROBAT Shape Format Share Comments 1 Design Transitions Help 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. 2 3 *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 o 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 Click to add notes Slide 2 of 3 2 3 D Notes 1294 Type here to search BI P 11:08 AM 2/7/2021