Cost Decomposition Analysis

Supplier:

HELP

SIC CODE LOOK-UP

Commodity

If you do not know the SIC Code, click on the cell above

SIC Code

From Supplier's Income Statement

From the Annual Survey of Manufactures

$

%

$

Ratio

Revenues

#DIV/0!

Industry spending on materials

#DIV/0!

Cost of Goods Sold

#DIV/0!

Industry spending on labor

Gross Margin

$ -

#DIV/0!

For the Annual Survey of Manufactures, click below

Selling, General & Administrative

#DIV/0!

www.census.gov

Research and Development

#DIV/0!

Direct Labor

Operating Profit

$ -

#DIV/0!

#DIV/0!

Calculate Direct Materials Cost per Unit

Unit Price from Supplier's Proposal

(list all components)

$

QTY

Price quoted by supplier

Total Direct Materials Cost

$ -

OUTPUT

$

%

Direct Labor

#DIV/0!

#DIV/0!

Direct Materials

$ -

#DIV/0!

Manufactuing Overhead

#DIV/0!

#DIV/0!

Unit Manufacturing Cost

#DIV/0!

#DIV/0!

Corporate Overhead (SG&A + R&D)

#DIV/0!

#DIV/0!

Total Unit Cost

#DIV/0!

#DIV/0!

Operating Proft Per Unit

#DIV/0!

#DIV/0!

Unit Price

$ -

#DIV/0!