### Page:1 of 6 

# COST MODEL ANALYSIS TEMPLATE Light-Duty Technology Cost Study EP-C-07-069 WA1-3 Printed: 8/2/2010 DRAFT

Material Labor Burden End Item ScrapSG&AProfitED&T-R&D Material Labor Burden 

# 01TRANSMISSION SYSTEM

1 01EXTERNAL COMPONENTS: Consists of installation of oil coolers,

lift eyes, vent caps. - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$



### 2 02CASE(S): Includes pressed in components (i.e., bearing races),

plugs, and associated hardware. - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ 0.83

$ 0.53

$ 4.21

$ 5.56

$



### 3 03GEAR TRAIN: Includes Input Shafts, Output Shafts, Differential and

all associated gears and bearings on the shaft. - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ 1.77

$ 4.54

$ 15.39

$ 21.70

$



### 4 04INTERNAL CLUTCHES: Internal for Gears, Synchronizers, Bands,

etc. - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ 19.46

$ 8.87

$ 33.50

$ 61.84

$



### 5 05LAUNCH CLUTCHES: Torque Converter - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$



### 6 06OIL PUMP & FILTER: Includes Pump, Pump Shaft/Drive

Mechanism, Oil Filters (Internal or External), Pick-up Tube, and Oil Baffles. - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$



### 7 07MECHANICAL CONTROLS - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ 0.17

$ 0.52

$ 0.32

$ 1.01

$



### 8 08ELECTRICAL CONTROLS - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$



### 9 09PARK MECHANISM: Includes Park & Lock Pawl Mechanism and

Actuating Levers - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$



### 10 10MISCELLANEOUS: - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$



### - $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ 

### 22.23

$ 14.46

$ 53.42

$ 90.11

$

# BASE TECHNOLOGY PACKAGE COST INFORMATION 5 Speed Automatic Transmission: 2004-2006 Toyota CamryItemSubsystem 

### Sub-Subsystem Description Manufacturing 

# SYSTEM & SUBSYSTEM DESCRIPTION NEW TECHNOLOGY PACKAGE COST INFORMATION 6 Speed Automatic Transmission: 2007-2009 Toyota Camry
Net Component/ Assembly Cost Impact to OEM System

ED&T/R&D (x1000) Tooling

(x1000)Investment

(X1000) Total Manufacturing Cost (Component/ Assembly) Markup Total Markup Cost (Component/ Assembly) Total

Packaging Cost (Component / Assembly) Manufacturing Total Manufacturing Cost (Component/ Assembly)



### SUBSYSTEM ROLL-UP 

# TechnologyLevel:6 Speed Automatic Transmission versus 5 Speed Automatic Transmission 

# Vehicle Class:Mid to Large Size Passenger Vehilce, 4
-6 Passengers 

# Study Case#:N0802 & B0802 (N=New, B=Base), 08=Technology Package, 02=Vehicle Class

EPA-HQ-OAR-2009-0472-DRAFT-11739.xls EPA Contract:EP-C-07-069 WA1-3 PROPRIETARY and CONFIDENTIAL Author: G. Kolwich (248)373-6000 Ext. 2411

### Page:2 of 6 

# COST MODEL ANALYSIS TEMPLATE Light-Duty Technology Cost Study EP-C-07-069 WA1-3 Printed: 8/2/2010 DRAFT


# TechnologyLevel:6 Speed Automatic Transmission versus 5 Speed Automatic Transmission 

# Vehicle Class:Mid to Large Size Passenger Vehilce, 4
-6 Passengers 

# Study Case#:N0802 & B0802 (N=New, B=Base), 08=Technology Package, 02=Vehicle Class

EPA-HQ-OAR-2009-0472-DRAFT-11739.xls EPA Contract:EP-C-07-069 WA1-3 PROPRIETARY and CONFIDENTIAL Author: G. Kolwich (248)373-6000 Ext. 2411

### Page:3 of 6 

# COST MODEL ANALYSIS TEMPLATE Light-Duty Technology Cost Study EP-C-07-069 WA1-3 Printed: 8/2/2010 DRAFT



# 01TRANSMISSION SYSTEM

1 01

2 02

3 03

4 04

5 05

6 06

7 07

8 08

9 09

10 10ItemSubsystem

# SYSTEM & SUBSYSTEM DESCRIPTION

End Item ScrapSG&AProfitED&T-R&D Material Labor Burden End Item ScrapSG&AProfitED&T-R&D

- $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$

- $ -

$ -

$ -

$ -

$ -

$ 5.56

$ -

$ -

$ -

$ (0.83)

$ (0.53)

$ (4.21)

$ (5.56)

$ -

$ -

$ -

$ -

$ -

$ -

$ (5.56)

$ -

$ -

$

0.15 $ 1.55

$ 1.76

$ 0.87

$ 4.34

$ -

$ 26.03

$ -

$ -

$ -

$ (1.77)

$ (4.54)

$ (15.39)

$ (21.70)

$ (0.15)

$ (1.55)

$ (1.76)

$ (0.87)

$ (4.34)

$ -

$ (26.03)

$ -

$ -

$

0.46 $ 4.20

$ 4.22

$ 1.87

$ 10.74

$ 0.26

$ 72.85

$ -

$ -

$ -

$ (19.46)

$ (8.87)

$ (33.50)

$ (61.84)

$ (0.46)

$ (4.20)

$ (4.22)

$ (1.87)

$ (10.74)

$ (0.26)

$ (72.85)

$ -

$ -

$

- $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$

- $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$

0.00 $ 0.03

$ 0.02

$ 0.00

$ 0.05

$ 0.02

$ 1.08

$ -

$ -

$ -

$ (0.17)

$ (0.52)

$ (0.32)

$ (1.01)

$ (0.00)

$ (0.03)

$ (0.02)

$ (0.00)

$ (0.05)

$ (0.02)

$ (1.08)

$ -

$ -

$

- $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$

- $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$

- $ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$



### 0.62 $ 5.78

$ 5.99

$ 2.74

$ 15.13

$ 0.28

$ 105.53

$ -

$ -

$ -

$ 

### (22.23)

$ (14.46)

$ (53.42)

$ (90.11)

$ (0.62)

$ (5.78)

$ (5.99)

$ (2.74)

$ (15.13)

$ (0.28)

$ (105.53)

$ -

$ -

$ 

# BASE TECHNOLOGY PACKAGE COST INFORMATION 5 Speed Automatic Transmission: 2004-2006 Toyota Camry INCREMENTAL COST TO UPGRADE TO NEW TECHNOLOGY PACKAGE
Markup Total Packaging Cost (Component / Assembly) Net

Component/ Assembly Cost Impact to OEM System

ED&T/R&D (x1000) Tooling

(x1000) Markup Total Markup Cost (Component/ Assembly) Tooling (x1000) Total Markup Cost (Component/ Assembly)Total

Packaging Cost (Component / Assembly) Net

Component/ Assembly Cost Impact to OEM System

ED&T/R&D (x1000) Investment (X1000) Manufacturing Total Manufacturing Cost (Component/ Assembly)



### EPA-HQ-OAR-2009-0472-DRAFT-11739.xls EPA Contract:EP-C-07-069 WA1-3 PROPRIETARY and CONFIDENTIAL Author: G. Kolwich (248)373-6000 Ext. 2411

### Page:4 of 6 

# COST MODEL ANALYSIS TEMPLATE Light-Duty Technology Cost Study EP-C-07-069 WA1-3 Printed: 8/2/2010 DRAFT

EPA-HQ-OAR-2009-0472-DRAFT-11739.xls EPA Contract:EP-C-07-069 WA1-3 PROPRIETARY and CONFIDENTIAL Author: G. Kolwich (248)373-6000 Ext. 2411

### Page:5 of 6 

# COST MODEL ANALYSIS TEMPLATE Light-Duty Technology Cost Study EP-C-07-069 WA1-3 Printed: 8/2/2010 DRAFT



# 01TRANSMISSION SYSTEM

1 01

2 02

3 03

4 04

5 05

6 06

7 07

8 08

9 09

10 10ItemSubsystem

# SYSTEM & SUBSYSTEM DESCRIPTION

- $

- $

- $

- $

- $

- $

- $

- $

- $

- $

- $ Investment(X1 000)



### EPA-HQ-OAR-2009-0472-DRAFT-11739.xls EPA Contract:EP-C-07-069 WA1-3 PROPRIETARY and CONFIDENTIAL Author: G. Kolwich (248)373-6000 Ext. 2411

### Page:6 of 6 

# COST MODEL ANALYSIS TEMPLATE Light-Duty Technology Cost Study EP-C-07-069 WA1-3 Printed: 8/2/2010 DRAFT

EPA-HQ-OAR-2009-0472-DRAFT-11739.xls EPA Contract:EP-C-07-069 WA1-3 PROPRIETARY and CONFIDENTIAL Author: G. Kolwich (248)373-6000 Ext. 2411