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 

Scrap SG&A Profit ED&T-R&D Material Labor Burden

01 TRANSMISSION SYSTEM

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

lift eyes, vent caps. $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

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

plugs, and associated hardware. $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 0.83 $ 0.53 $ 4.21 $ 5.56

3 03 GEAR 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 04 INTERNAL CLUTCHES: Internal for Gears, Synchronizers, Bands, 

etc.

$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 19.46 $ 8.87 $ 33.50 $ 61.84

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

6 06

OIL PUMP & FILTER: Includes Pump, Pump Shaft/Drive 

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

Baffles.

$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

7 07 MECHANICAL CONTROLS $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 0.17 $ 0.52 $ 0.32 $ 1.01

8 08 ELECTRICAL CONTROLS $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

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

Actuating Levers $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

10 10 MISCELLANEOUS: $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 22.23 $ 14.46 $ 53.42 $ 90.11

BASE TECHNOLOG

5 Speed Automatic Tr

Item

Subsystem

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

Technology Level: 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

Technology Level: 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

01 TRANSMISSION SYSTEM

1 01

2 02

3 03

4 04

5 05

6 06

7 07

8 08

9 09

10 10 Item Subsystem

SYSTEM & SUBSYSTEM DESCRIPTION

End Item 

Scrap SG&A Profit ED&T-R&D Material Labor Burden End Item Scrap SG&A Profit ED&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

01 TRANSMISSION SYSTEM

1 01

2 02

3 03

4 04

5 05

6 06

7 07

8 08

9 09

10 10 Item Subsystem

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