Total Cost Analysis

Worksheet

Commodity name:

Supplier:

Expected life:

Annual Discount Rate (obtain from Finance Department)

Costs Year

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

ACQUISITION

Unit Cost (net any discounts)

Unit Price

Startup

Cost of additional equipment needed

Cost of labor during installation

Training

Transportation

Total cost of transportation

Service Agreements and Warranty

Annual Payment

Inspections

Anticipated annual cost of inspections

Administration

Annual cost for processing invoices,

reconciling bills, using purchasing

cards, etc.

IN HOUSE

Storage

Warehousing facilities, inventory moves, etc.

Operating

Energy

Cost of failure

Cost of transformation

Maintenance

Scheduled/Prevenitve maintenance

Cost to fix (anticipated failure rate x cost per repair)

Downtime opportunity cost

Training

DISPOSAL

Costs

Packaging

Transportation

Environmental liability

Recycling Costs

Recovered

Price received for used product

OTHER

If there are any other expenses which could not be

classified under any of the above categories, please

enter the amount here

If there are any other amounts received, which could

not be classified under any of the above cateogories,

please enter them here

DO NOT WRITE BELOW THIS LINE

Total Expenditure:

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

Present Value:

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

Net Present Value:

$0

Additional comments: