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 System

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 

I

(x1000) tem

System

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 - - - - - - - - - - - - - - -

SYSTEM ROLL-UP 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

09000064810d3b0c.xls

EPA Contract:EP-C-07-069 WA1-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 System

1 01

2 02

3 03

4 04

5 05

Item

SystemLabor 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 WA1-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 System

1 01

2 02

3 03

4 04

5 05

Item

System

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)

DE 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 WA1-3 PROPRIETARY and CONFIDENTIAL

Author: G. Kolwich

(248)373-6000 Ext. 2411