### Page:1 of 3 

# COST MODEL ANALYSIS TEMPLATE

**Light-Duty Technology Cost Study**

**EP-C-07-069 WA1-3** Printed: 8/13/2012

DRAFT

Material Labor Burden End Item

Scrap SG&A Profit ED&T-R&D Material



### USD **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD** 



# 04 **Suspension Sy stem** 

1 **01 Front Suspension Subsystem**  **62.17 13.94**  **28.51 104.62**  **1.81 10.44**  **8.94 2.62**  **23.81**

**- 128.42** 

**- 8,684.08** 

**- 60.25** 



### 2 **02 Rear Suspension Subsystem**  **62.26 14.67**  **28.34 105.26**  **1.73 10.59**  **9.03 2.62**  **23.97**

**- 129.23** 

**- 4,631.88** 

**- 58.85** 



### 3 **03 Shock Absorber Subsystem**  **56.71 17.17**  **17.81 91.69**  **0.65 10.01**  **8.06 2.08**  **20.81**

**- 112.50** 

**- 2,555.28** 

**- 86.57** 



### 4 **04 Wheels and Tires Subsystem**  **173.83 35.66**  **35.66 245.16**  **0.62 12.32**  **8.21 2.05**  **23.20**

**- 268.36** 

**- -**  **- 223.42** 



### 5 **05 Suspension Load Leveling Control Subsystem (NA)** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



# SYSTEM & SUBSYSTEM DESCRIPTION **NEW TECHNOLOGY GENERAL PART INFORMATION**

Manufacturing **Total**

**Manufacturing**

**Cost**

**(Component/**

**Assembly) Tooling** 

**(x1000)**ItemSystem Markup

**Net**

**Component/**

**Assembly Cost**

**Impact to OEM Total Markup** 

**Cost**

**(Component/**

**Assembly) Total** 

**Packaging**

**Cost**

**(Component/**

**Assembly) System** 

**ED&T/R&D**

**(x1000)** 

### Subsystem Description **Investment**

**(X1000)** 

# Technology **Level:** Toyota Venza Mass

- Reduction and Cost Analysis

**Vehicle Class:** Small & Mid Size Cross

- Over Passenger Vehicle

**Study Case#:** 07

- 069

- 303LW

6 **06 Rear suspension Modules Subsystem (NA)** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 7 **07 Front Suspension Modules Subsystem (NA)** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 8 **08 N / A** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 9 **09 N / A** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 10 **10 N / A** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 11 **11 N / A** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 12 **12 N / A** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 13 **13 N / A** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 14 **14 N / A** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 15 **15 N / A** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 16 **16 N / A** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 354.97 **81.45 110.32**  **546.73 4.80**  **43.36 34.25**  **9.37 91.78** 

**- 638.51** 

**- 15,871.24** 

**-** 

### 429.10 **SYSTEM ROLL-UP**

09000064810d3b0c.xls

EPA Contract:EP-C-07-069 W A1-3 PROPRIETARY and CONFIDENTIAL Author: G. Kolwich

(248)373-6000 Ext. 2411

### Page:2 of 3 

# COST MODEL ANALYSIS TEMPLATE

**Light-Duty Technology Cost Study**

**EP-C-07-069 WA1-3** Printed: 8/13/2012

DRAFT



# 04 **Suspension Sy stem** 

1 **01**

2 **02**

3 **03**

4 **04**

5 **05**ItemSystem

Labor Burden End Item

Scrap SG&A Profit ED&T-R&D Material Labor Burden End Item

Scrap SG&A Profit ED&T-R&D



### USD **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD**  **USD USD** 

**13.87 32.15**  **106.27 2.12**  **10.92 9.41**  **2.74 25.19** 

**- 131.46** 

**- 3,511.70** 

**- (1.92)**  **(0.07) 3.65**  **1.66 0.31**  **0.49 0.47**  **0.12 1.38** 

**-**

**16.49 32.97**  **108.30 2.07**  **11.32 9.68**  **2.77 25.84** 

**- 134.14** 

**- 2,172.83** 

**- (3.41)**  **1.82 4.64**  **3.04 0.33**  **0.73 0.65**  **0.15 1.87** 

**-**

**26.40 25.96**  **138.94 0.98**  **15.18 12.23**  **3.16 31.55** 

**- 170.48** 

**- 2,642.34** 

**- 29.87**  **9.23 8.16**  **47.25 0.33**  **5.17 4.16**  **1.07 10.74** 

**-**

**46.85 46.85**  **317.12 0.80**  **15.93 10.62**  **2.66 30.01** 

**- 347.13** 

**- -**  **- 49.59**  **11.18 11.18**  **71.96 0.18**  **3.62 2.41**  **0.60 6.81** 

**-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- System** 

**ED&T/R&D**

**(x1000) Tooling** 

**(x1000) Investment** 

**(X1000)** Manufacturing **Total**

**Manufacturing**

**Cost**

**(Component/**

**Assembly)** Markup

**Total Markup**

**Cost**

**(Component/**

**Assembly) Total** 

**Packaging**

**Cost**

**(Component/**

**Assembly) Total** 

**Packaging**

**Cost**

**(Component/**

**Assembly) Net** 

**Component/**

**Assembly Cost**

**Impact to OEM** 

# BASE TECHNOLOGY GENERAL PART INFORMATION **INCREMENTAL COST TO UPGRADE TO NEW TECHNOLOGY PACKAGE**

Manufacturing **Total**

**Manufacturing**

**Cost**

**(Component/**

**Assembly)** Markup

**Total Markup**

**Cost**

**(Component/**

**Assembly)**



### 6 **06**

7 **07**

8 **08**

9 **09**

10 **10**

11 **11**

12 **12**

13 **13**

14 **14**

15 **15**

16 **16 -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -** 

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**

**- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **- -**  **-**



### 103.60 **137.94 670.63**  **5.96 53.36**  **41.94 11.32**  **112.58**

**- 783.22** 

**- 8,326.87** 

**-** 

### 74.13 **22.15 27.62**  **123.91 1.16**  **10.00 7.69**  **1.95 20.80** 

**-**

09000064810d3b0c.xls

EPA Contract:EP-C-07-069 W A1-3 PROPRIETARY and CONFIDENTIAL Author: G. Kolwich

(248)373-6000 Ext. 2411

### Page:3 of 3 

# COST MODEL ANALYSIS TEMPLATE

**Light-Duty Technology Cost Study**

**EP-C-07-069 WA1-3** Printed: 8/13/2012

DRAFT



# 04 **Suspension Sy stem** 

1 **01**

2 **02**

3 **03**

4 **04**

5 **05**ItemSystem



### USD **USD USD**  **USD**

**Part $ Tool $** 

**3.04**

**- (5,172.38)** 

**-** 

### 2.3% -147.3%

**4.91**

**- (2,459.05)** 

**-** 

### 3.7% -113.2%

**57.99**

**- 87.06** 

**-** 

### 34.0% 3.3%

**78.77**

**- -**  **-** 

### 22.7% #DIV/0!

**- -**  **- -** 

**System**

**ED&T/R&D**

**(x1000) Tooling** 

**(x1000) Net** 

**Component/**

**Assembly Cost**

**Impact to OEM Investment** 

**(X1000)** 

# INCREMENTAL COST TO UPGRADE TO NEW TECHNOLOGY PACKAGE

6 **06**

7 **07**

8 **08**

9 **09**

10 **10**

11 **11**

12 **12**

13 **13**

14 **14**

15 **15**

16 **16 -**  **- -**  **-**

**- -**  **- -** 

**- -**  **- -** 

**- -**  **- -** 

**- -**  **- -** 

**- -**  **- -** 

**- -**  **- -** 

**- -**  **- -** 

**- -**  **- -** 

**- -**  **- -** 

**- -**  **- -** 



### 144.71

**- (7,544.37)** 

**-** 

### 18.5% -90.6%

09000064810d3b0c.xls

EPA Contract:EP-C-07-069 W A1-3 PROPRIETARY and CONFIDENTIAL Author: G. Kolwich

(248)373-6000 Ext. 2411