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

02 Transmission

1 01 External Components - - - - - - - - - - - - - - -

2 02 Case Sbsystem 69.87 - - 69.87 0.18 3.51 2.34 0.59 6.61 0 76.48 - 0.00 - 59.80

3 03 Gear Train Subsystem 140.22 4.66 10.27 155.16 0.81 15.85 10.76 1.52 28.95 0 184.10 - 0.00 - 42.78

4 05 Launch Clutch Subsystem 11.14 2.25 10.49 23.87 0.77 2.76 2.39 0.56 6.48 0 30.35 - 11,487.50 - 38.10

5 06 OilPump and Filter Subsystem 2.35 - - 2.35 0.11 0.28 0.25 0.06 0.70 0 3.05 - 0.00 - 3.05

Total 

Packaging 

Cost 

(Component/ 

Assembly)

Manufacturing 

SYSTEM & SUBSYSTEM DESCRIPTION

Manufacturing 

Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

NEW TECHNOLOGY GENERAL PART INFORMATION

Item

Subsystem

System 

ED&T/R&D

(x1000)

Sub-Subsystem Description

System

Tooling (x1000)

Markup

Net Component/ 

Assembly Cost 

Impact to OEM

Total Markup 

Cost 

(Component/ 

Assembly)

Investment

(X1000)

Technology Level: Toyota Venza Mass-Reduction and Cost Analysis

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

6 07 Mechanical Controls Subsystem - - - - - - - - - - - - - - -

7 08 Electriacl Controls Subsystem - - - - - - - - - - - - - - -

8 09 Parking Mechanism Subsystem - - - - - - - - - - - - - - -

9 20 Driver Operated External Controls Subsystem 37.68 12.56 12.56 62.80 0.33 6.58 4.39 0.57 11.87 0 74.67 - 0.00 - 22.80

SUBSYSTEM ROLL-UP 261.26 19.48 33.32 314.05 2.20 28.98 20.12 3.30 54.61 0 368.66 - 11,487.50 - 166.53

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

02 Transmission

1 01 External Components

2 02 Case Sbsystem

3 03 Gear Train Subsystem

4 05 Launch Clutch Subsystem

5 06 OilPump and Filter Subsystem

Item

Subsystem

System

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

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

 - - 59.80 0.15 3.00 2.00 0.50 5.66 0 65.45 - 0.00 - (10.08) - - (10.08) (0.03) (0.51) (0.34) (0.08) (0.95) 0

 4.02 10.03 56.83 0.22 3.98 2.81 0.59 7.59 0 64.42 - 0.00 - (97.44) (0.65) (0.24) (98.33) (0.60) (11.88) (7.95) (0.93) (21.35) 0

 12.70 12.70 63.50 0.33 6.66 4.44 0.58 12.01 0 75.51 - 3,836.70 - 26.96 10.45 2.21 39.63 (0.44) 3.90 2.05 0.02 5.53 0

 - - 3.05 0.14 0.36 0.32 0.08 0.90 0 3.95 - 0.00 - 0.69 - - 0.69 0.03 0.08 0.07 0.02 0.21 0

System 

ED&T/R&D

(x1000)

Tooling (x1000) Investment

(X1000)

Total Markup 

Cost 

(Component/ 

Assembly)

Total 

Packaging 

Cost 

(Component/ 

Assembly)

Net 

Component/ 

Assembly 

Cost Impact to 

OEM

Manufacturing 

Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

Markup

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)

Total 

Packaging 

Cost 

(Component/ 

Assembly)

6 07 Mechanical Controls Subsystem

7 08 Electriacl Controls Subsystem

8 09 Parking Mechanism Subsystem

9 20 Driver Operated External Controls Subsystem

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

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

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

 7.60 7.60 38.00 0.20 3.98 2.66 0.35 7.18 0 45.18 - 0.00 - (14.88) (4.96) (4.96) (24.80) (0.13) (2.60) (1.73) (0.23) (4.69) 0

 24.32 30.33 221.17 1.03 17.98 12.23 2.09 33.34 0 254.51 - 3,836.70 - (94.73) 4.84 (2.99) (92.88) (1.16) (11.00) (7.89) (1.21) (21.26) 0

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

02 Transmission

1 01 External Components

2 02 Case Sbsystem

3 03 Gear Train Subsystem

4 05 Launch Clutch Subsystem

5 06 OilPump and Filter Subsystem

Item

Subsystem

System

USD USD USD USD

 - - - -

 (11.03) - - -

 (119.68) - - -

 45.16 - (7,650.80) -

 0.90 - - -

Tooling (x1000)

System 

ED&T/R&D

(x1000)

Investment 

(X1000)

Net 

Component/ 

Assembly 

Cost Impact to 

OEM

6 07 Mechanical Controls Subsystem

7 08 Electriacl Controls Subsystem

8 09 Parking Mechanism Subsystem

9 20 Driver Operated External Controls Subsystem

 - - - -

 - - - -

 - - - -

 (29.49) - - -

 (114.15) - (7,650.80) -

114.15

09000064810d3b0c.xls

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

Author: G. Kolwich

(248)373-6000 Ext. 2411