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 Labor

USD USD USD USD USD USD USD USD USD USD USD USD USD USD USD USD

03 Body System B

1 05 Interior Trim and Ornamentation Subsystem 86.72 11.47 27.90 126.09 0.31 6.16 4.10 1.03 11.59 0 137.68 - - - 106.39 17.02

2 06 Sound and Heat Control Subsystem 3.63 0.27 0.33 4.23 0.01 0.21 0.14 0.04 0.40 0 4.63 - - - 4.03 0.28

3 07 Sealing Subsystem 43.95 9.42 9.42 62.79 - - - - - - 62.79 - - - 47.09 15.70

4 10 Seating Subsystem 111.06 18.40 51.55 181.01 1.15 17.46 14.28 4.06 36.95 0 217.96 - 7,025.40 - 119.32 57.61

5 12 Instrument Panel and Console Subsystem 73.61 4.18 15.58 93.36 0.23 4.69 3.13 0.78 8.84 0 102.20 - 8,360.00 - 64.30 3.98

Manufacturing 

SYSTEM & SUBSYSTEM DESCRIPTION

Manufacturing Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

Item

Subsystem

Sub-Subsystem Description

System

Investment

(X1000)

Markup Net 

Component/ 

Assembly 

Cost Impact to 

OEM

Total Markup 

Cost 

(Component/ 

Assembly)

Total 

Packaging 

Cost 

(Component

/ Assembly)

Tooling 

(x1000)

NEW TECHNOLOGY GENERAL PART INFORMATION:

System 

ED&T/R&D

(x1000)

Technology Level: Toyota Venza Mass-Reduction and Cost Analysis

Vehicle Class: Small & Mid Size Cross-Over Passenger Vehicle

Study Case#: 07-069-303LW

5 12 Instrument Panel and Console Subsystem

6 20 Occupant Restraining Device Subsystem 16.31 4.07 6.33 26.70 0.07 1.34 0.89 0.22 2.53 0 29.23 - 796.00 - 14.87 4.45

SUBSYSTEM ROLL-UP 335.28 47.79 111.10 494.18 1.77 29.86 22.55 6.13 60.31 0 554.49 - 16,181.40 - 356.01 99.03

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

03 Body System B

1 05 Interior Trim and Ornamentation Subsystem

2 06 Sound and Heat Control Subsystem

3 07 Sealing Subsystem

4 10 Seating Subsystem

5 12 Instrument Panel and Console Subsystem

Item

Subsystem

System

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

 36.21 159.62 0.44 7.88 5.73 1.72 15.78 0 175.40 - - - 19.68 5.55 8.31 33.54 0.14 1.73 1.63 0.69 4.18 0 37.72

 0.26 4.57 0.01 0.23 0.15 0.04 0.43 0 5.01 - - - 0.40 0.01 (0.07) 0.34 0.00 0.02 0.01 0.00 0.03 0 0.38

 15.70 78.49 - - - - - - 78.49 - - - 3.14 6.28 6.28 15.70 - - - - - - 15.70

 75.85 252.79 1.57 22.39 19.26 6.51 49.73 0 302.51 - 21,532.45 - 8.26 39.22 24.30 71.78 0.42 4.93 4.97 2.45 12.78 0 84.56

 13.68 81.95 0.21 4.12 2.75 0.69 7.76 0 89.71 - 3,042.10 - (9.32) (0.20) (1.90) (11.41) (0.03) (0.57) (0.38) (0.10) (1.08) 0 (12.49)

Total 

Packaging 

Cost 

(Component

/ Assembly)

Net 

Component/ 

Assembly 

Cost Impact to 

OEM

Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

Markup

Total Markup 

Cost 

(Component/ 

Assembly)

Investment

(X1000)

Manufacturing Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

Markup

Total Markup 

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

System 

ED&T/R&D

(x1000)

Tooling 

(x1000)

5 12 Instrument Panel and Console Subsystem

6 20 Occupant Restraining Device Subsystem 4.75 24.07 0.06 1.21 0.81 0.20 2.28 0 26.35 - 1,573.00 - (1.44) 0.38 (1.57) (2.63) (0.01) (0.13) (0.09) (0.02) (0.25) 0 (2.88)

 146.46 601.50 2.30 35.83 28.69 9.15 75.97 0 677.47 - 26,147.55 - 20.73 51.24 35.35 107.32 0.53 5.97 6.14 3.02 15.66 0 122.98

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

03 Body System B

1 05 Interior Trim and Ornamentation Subsystem

2 06 Sound and Heat Control Subsystem

3 07 Sealing Subsystem

4 10 Seating Subsystem

5 12 Instrument Panel and Console Subsystem

Item

Subsystem

System

USD USD USD

 - - -

 - - -

 - - -

 - 14,507.05 -

 - (5,317.90) -

Investment 

(X1000)

 NEW TECHNOLOGY PACKAGE

System 

ED&T/R&D

(x1000)

Tooling 

(x1000)

5 12 Instrument Panel and Console Subsystem

6 20 Occupant Restraining Device Subsystem - 777.00 -

 - 9,966.15 -

09000064810d3b0c.xls

EPA Contract:EP-C-07-069 WA1-3 PROPRIETARY and CONFIDENTIAL

Author: G. Kolwich

(248)373-6000 Ext. 2411