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

05 Driveline System

1 03 Front Drive Housed Axle Subsystem 5.62 0.00 0.00 5.63 0.03 0.33 0.38 0.19 0.93 0 6.55 - 80.80 - 6.94 0.00

2 04 Front Drive Half Shaft Subsystem 10.97 2.84 5.87 19.67 0.31 2.28 2.19 0.77 5.54 0 25.22 - 720.86 - 9.84 2.52

SUBSYSTEM ROLL-UP 16.59 2.84 5.87 25.30 0.34 2.61 2.57 0.95 6.47 0 31.77 - 801.66 - 16.79 2.52

Investment

(X1000)

SYSTEM & SUBSYSTEM DESCRIPTION NEW TECHNOLOGY GENERAL PART INFORMATION

Manufacturing Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

Tooling 

(x1000)

Markup

Total Markup 

Cost 

(Component/ 

Assembly)

Item

System

Subsystem

System 

ED&T/R&D

(x1000)

Sub-Subsystem Description

Manufacturing 

Net 

Component/ 

Assembly Cost 

Impact to OEM

Total 

Packaging 

Cost 

(Component/ 

Assembly)

Technology Level: Toyota Venza Mass-Reduction and Cost Analysis

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

Study Case#: 07-069-303LW

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

05 Driveline System

1 03

2 04

Item

System

Subsystem

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

 0.00 6.95 0.04 0.41 0.47 0.23 1.15 0 8.09 - 74.30 - 1.32 - - 1.32 0.01 0.08 0.09 0.04 0.22 0 1.54

 5.95 18.31 0.25 2.13 2.08 0.74 5.20 0 23.51 - 41.50 - (1.13) (0.32) 0.09 (1.36) (0.06) (0.15) (0.11) (0.03) (0.35) 0 (1.70)

 5.96 25.26 0.29 2.54 2.55 0.97 6.34 0 31.60 - 115.80 - 0.19 (0.32) 0.09 (0.04) (0.05) (0.07) (0.02) 0.01 (0.13) 0 (0.16)

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 Markup 

Cost 

(Component/ 

Assembly)

Total 

Packaging 

Cost 

(Component/ 

Assembly)

Net 

Component/ 

Assembly Cost 

Impact to OEM

Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

Total 

Manufacturing 

Cost 

(Component/ 

Assembly)

Markup Markup

Total Markup 

Cost 

(Component/ 

Assembly)

Total 

Packaging 

Cost 

(Component/ 

Assembly)

Net 

Component/ 

Assembly Cost 

Impact to OEM

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

05 Driveline System

1 03

2 04

Item

System

Subsystem

USD USD USD

 - (6.50) -

 - (679.36) -

 - (685.86) -

System 

ED&T/R&D

(x1000)

W TECHNOLOGY PACKAGE

Tooling 

(x1000)

Investment 

(X1000)

09000064810d3b0c.xls

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

Author: G. Kolwich

(248)373-6000 Ext. 2411