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

11 Steering System

01 Steering Gear Subsystem 4.79 - - 4.79 0.02 0.26 0.24 0.10 0.62 0 5.41 - - - 5.01 -

02 Power Steering Subsystem 0.39 0.13 0.07 0.59 0.00 0.03 0.02 - 0.05 0 0.64 - 89.20 - 0.55 0.06

04 Steering Column Subsystem 3.57 2.80 3.75 10.12 0.18 1.04 0.88 0.23 2.34 0 12.45 - 2,532.90 - 5.42 6.28

NEW TECHNOLOGY GENERAL PART INFORMATION:

System 

ED&T/R&D

(x1000)

Investment

(X1000)

Markup Net 

Component/ 

Assembly 

Cost Impact to 

OEM

Total Markup 

Cost 

(Component/ 

Assembly)

Total 

Packaging 

Cost 

(Component

/ Assembly)

Tooling 

(x1000)

SYSTEM & SUBSYSTEM DESCRIPTION

Manufacturing Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

Item

Subsystem

Sub-Subsystem Description

System

Manufacturing 

Technology Level: Toyota Venza Mass-Reduction and Cost Analysis

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

Study Case#: 07-069-303LW

05 Steering Column Switches Subsystem - - - - - - - - - - - - - - - -

06 Steering Wheel Subsystem 8.07 1.72 1.75 11.54 0.00 0.02 0.01 0.00 0.03 0 11.56 - 393.30 - 7.51 1.50

SUBSYSTEM ROLL-UP 16.81 4.64 5.57 27.03 0.20 1.35 1.15 0.34 3.04 0 30.07 - 3,015.40 - 18.48 7.84

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

11 Steering System

01 Steering Gear Subsystem

02 Power Steering Subsystem

04 Steering Column 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

 - 5.01 0.02 0.27 0.25 0.10 0.65 0 5.66 - - - 0.22 - - 0.22 0.00 0.01 0.01 0.00 0.03 0 0.24

 0.07 0.67 0.00 0.03 0.02 - 0.06 0 0.73 - 276.00 - 0.16 (0.07) (0.00) 0.09 0.00 0.00 0.00 - 0.01 0 0.10

 7.06 18.76 0.14 1.84 1.64 0.47 4.08 0 22.84 - 622.90 - 1.85 3.48 3.31 8.64 (0.04) 0.80 0.75 0.24 1.75 0 10.39

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)

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

Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

Markup

Total Markup 

Cost 

(Component/ 

Assembly)

05 Steering Column Switches Subsystem

06 Steering Wheel Subsystem

 - - - - - - - - - - - - - - - - - - - - - - -

 1.73 10.73 0.23 0.54 0.37 0.01 1.15 0 11.88 - 3,469.20 - (0.56) (0.22) (0.02) (0.80) 0.23 0.53 0.36 0.01 1.12 0 0.32

 8.86 35.18 0.38 2.69 2.28 0.59 5.94 0 41.11 - 4,368.10 - 1.67 3.19 3.28 8.15 0.18 1.34 1.13 0.25 2.90 0 11.05

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

11 Steering System

01 Steering Gear Subsystem

02 Power Steering Subsystem

04 Steering Column Subsystem

Item

Subsystem

System

USD

USD USD USD

 - - -

 - 186.80 -

 - (1,910.00) -

Investment 

(X1000)

 NEW TECHNOLOGY PACKAGE

System 

ED&T/R&D

(x1000)

Tooling 

(x1000)

05 Steering Column Switches Subsystem

06 Steering Wheel Subsystem

 - - -

 - 3,075.90 -

 - 1,352.70 -

09000064810d3b0c.xls

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

Author: G. Kolwich

(248)373-6000 Ext. 2411