>
Depot Input Data
A
B
C
1
UID Input Data for XXX Depot
04/22/05
2
3
EQUIPMENT
4
Number of UID Marking Stations
10
5
Number of UID Readers
200
6
Number of UID Lab Verifiers
1
7
8
DOCUMENTS
9
Number of Static Documents
300
10
Time Required to Revise Each Static
Document (man-days)
0.5
11
Number of New Documents per Year
50
12
Time Required to Revise Each New Document
(man-days)
0.5
13
14
TRAINING
15
Employees to be Trained in UID Marking
30
16
Employees to be Trained in UID Verifying
30
17
Employees to be Trained in UID Reading
300
18
19
INDUSTRIAL PLANT EQUIPMENT
20
Number of Existing Pieces of IPE
800
21
Number of New Pieces of IPE Purchased
per Year
20
22
Number of New Pieces of IPE Manufactured
at Depot per Year
15
23
24
WORKLOAD
25
End Items per Year
10,000
26
Embedded Items per Year
80,000
27
Items Purchased from Supply per Year
500
28
Items Manufactured at Depot per Year
500
29
Items Scrapped at Depot per Year
500
30
Items Subjected to UID-Damaging Operations
per Year
500
Input Constants
A
B
C
1
UID Input Constants for XXX Depot
04/22/05
2
3
EQUIPMENT
4
Cost of a Marking Station
$208,000
5
Cost of a Reader
$5,000
6
Cost of a Verifier
$10,000
7
8
EQUIPMENT MAINTENANCE
9
Annual Cost of PM & Consumables
for a Marking Station
$9,550
10
Annual Cost of PM & Consumables
for a Reader
$0
11
Annual Cost of PM & Consumables
for a Verifier
$0
12
Annual Cost of Repair & Replacement
for a Marking Station as a Percent of Purchase Cost
5%
13
Annual Cost of Repair & Replacement
for a Reader as a Percent of Purchase Cost
5%
14
Annual Cost of Repair & Replacement
for a Verifier as a Percent of Purchase Cost
5%
15
16
TRAINING
17
Cost of a Training Class for Part Marking
$6,000
18
Number of Students in a Part Marking
Class
6
19
Duration of Part Marking Class (days)
5
20
Cost of a Training Class for UID Verifying
$2,000
21
Number of Students in a UID Verifying
Class
20
22
Duration of UID Verifying Class (days)
2
23
Duration of UID Reading Class (hours)
2
24
Annual Cost of Refresher Training as
a Percent of Initial Training
20%
25
26
LABOR
27
Labor Time to Mark an End Item (minutes)
11
28
Labor Time to Mark an Embedded Item
(minutes)
11
29
Labor Time to Mark a Manufactured Item
(minutes)
11
30
Labor Time to Mark a UID-Damaged Item
(minutes)
9
31
Labor Time to Mark a Piece of IPE
11
32
Labor Time to Read a UID on an End Item
(minutes)
3
33
Labor Time to Read a UID on an Embedded
Item (minutes)
3.5
34
Labor Time to Read a UID on a Purchased
Item (minutes)
4.5
35
Labor Time to Read a UID on a Scrapped
Item (minutes)
3
36
Labor Time to Read a UID on a UID-Damaged
Item (minutes)
3
37
Labor Rate (per hour)
$100
Nonrecurring Costs
A
B
C
D
E
F
G
H
1
UID Nonrecurring Costs for XXX Depot
04/22/05
2
3
Category
Item
Quantity
Unit Cost
Total
Cost
Notes
4
Unit Labor
Labor Rate
Unit Cost
5
Equipment
Purchase
Marking Stations
10
$208,000
$2,080,000
6
Readers
200
$5,000
$1,000,000
7
Lab Verifiers
1
$10,000
$10,000
8
Subtotal
Equipment Purchases
$3,090,000
9
10
Static Documents
Procedures, Guides,
Instructions, Drawings
300
0.5
$100
$400
$120,000
Labor in days
11
12
Initial
Training
Part Marking - Employee Time
30
5
$100
$4,000
$120,000
Labor in days
13
Part Marking - Class Cost
5
$6,000
$30,000
14
UID Verifying - Employee Time
30
2
$100
$1,600
$48,000
Labor in days
15
UID Verifying - Class Cost
2
$2,000
$4,000
16
UID Reading - Employee Time
300
2
$100
$200
$60,000
Labor in hours
17
Subtotal
Initial Training
$262,000
18
19
Existing IPE
Test, Support, Industrial
Plant Equipment
800
11
$100
$18
$14,667
Labor in minutes
20
21
Total
Non-Recurring Costs
$3,486,667
Recurring Costs
A
B
C
D
E
F
G
H
1
UID Recurring Costs for XXX Depot
04/22/05
2
3
Category
Item
Quantity
Unit Cost
Total
Cost
Notes
4
Unit Labor
Labor Rate
Unit Cost
5
Maintenance
Workload
End Items - Mark & Read
10,000
14
$100
$23
$233,333
Labor in minutes
6
Embedded Items - Mark & Read
80,000
14.5
$100
$24
$1,933,333
Labor in minutes
7
Items Purchased from Supply - Read
500
4.5
$100
$8
$3,750
Labor in minutes
8
Items Manufactured at Depot - Mark
500
11
$100
$18
$9,167
Labor in minutes
9
Items Scrapped at Depot - Read
500
3
$100
$5
$2,500
Labor in minutes
10
Items in UID-Damaging Operations - Mark
& Read
500
12
$100
$20
$10,000
Labor in minutes
11
Subtotal
Maintenance Workload
$2,192,083
12
13
Equipment
Maintenance
Marking Stations - Consumables
10
$9,550
$95,500
14
Marking Stations - Repair & Replacement
10
$10,400
$104,000
5% x Purchase Cost
15
Readers - Repair & Replacement
200
$250
$50,000
5% x Purchase Cost
16
Lab Verifiers - Repair & Replacement
1
$500
$500
5% x Purchase Cost
17
Subtotal
Equipment Maintenance
$250,000
18
19
New Documents
Procedures, Guides,
Instructions, Drawings
50
0.5
$100
$400
$20,000
Labor in days
20
21
Refresher
Training
Part Marking
$30,000
20% x Initial Training
22
UID Verifying
$10,400
20% x Initial Training
23
UID Reading
$12,000
20% x Initial Training
24
Subtotal Refresher
Training
$52,400
25
26
New IPE
Test, Support, & IPE - Purchased
20
11
$100
$18
$367
Labor in minutes
27
Test, Support, & IPE - Manufactured
15
11
$100
$18
$275
Labor in minutes
28
Subtotal New IPE
$642
29
30
Total Recurring
Costs
$2,515,125
per year
search
