Cover V04, I06
Article
Sidebar 1
Table 1
Table 2
Table 3
Table 4

nov95.tar


Table 3: Sample Spreadsheet: Model for Computing System Cost Effectiveness

MEDIA TYPE BetaCam 3590 DLT 2000 DLT 4000 8mm 4mm MO CD-R 19mm VHS
Archive Size (GB) 300 300 300 300 300 300 300 300 300 300
Time of Extended Cost (years) 1 1 1 1 1 1 1 1 1 1
Kilowatt-hour Cost $0.15 $0.15 $0.15 $0.15 $0.15 $0.15 $0.15 $0.15 $0.15 $0.15
Archives per Month 2 2 2 2 2 2 2 2 2 2
Restores per Month 1 1 1 1 1 1 1 1 1 1
Admin. Manhour Cost ($/hr) $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Physical Space Cost ($/ft3/yr) $0.48 $0.48 $0.48 $0.48 $0.48 $0.48 $0.48 $0.48 $0.48 $0.48
Archive Babysitting Time (min/hr) 10 10 10 10 10 10 10 10 10 10
Initial System Cost $130,000 $49,500 $40,000 $50,000 $35,000 $30,000 $40,000 $78,000 $120,000 $61,000
Percent of Total Cost 85% 38% 50% 48% 50% 32% 10% 27% 95% 72%
Single Media Cost $120 $100 $35 $120 $15 22 80 12 200 23
Single Media Native Capacity (GB) 42 10 10 20 7 4 1.7 0.681 330 21
Support Compression? n y y y y n n n y
Compression Factor Used 1 1 1 1 1 1 1 1 1 1
Effective Media Capacity (GB) 42 10 10 20 7 4 1.7 0.681 330 21
System Media Capacity 25 10 28 26 60 72 180 500 1 48
System Total Data Capacity (GB) 1,050 100 280 520 420 288 306 340.5 330 1,008
Effective Media Cost/GB ($/GB) $2.86 $10.00 $3.50 $6.00 $2.14 $5.50 $47.06 $17.62 $0.61 $1,095
Number of Media per Archive 7 30 30 15 43 75 176 441 1 14
Media Cost per Archive ($) $840 $3,000 $1,050 $1,800 $645 $1,650 $14,080 $5,292 $200 $322
Extended Media Cost ($) $20,160 $72,000 $25,200 $43,200 $15,480 $39,600 $337,920 $127,008 $4,800 $7,728
Percent of Total Cost (%) 13% ?% 31% 41% 22% 42% 80% 44% 4% 9%
Single Media Volume (in3) 56.09 ? 16.81 16.81 10.02 3.00 11.81 6.25 151.63 25.38
Media Data Density (in3/GB) 1.34 ? 1.68 0.84 1.43 0.75 6.95 9.18 0.46 1.21
Extended Media Storage Space (ft3) 5.45 ? 7.00 3.50 5.98 3.13 28.87 38.28 2.11 4.94
Extended Media Storage Cost ($) $2.62 ? $3.36 $1.68 $2.87 $1.50 $13.86 $18.38 $1.01 $2.37
Percent of Total Cost (%) 0% ?% 0% 0% 0% 0% 0% 0% 0% 0%
Native System Thruput (MB/s) 12.0 9.0 2.5 3.0 2.0 2.0 2.2 3.0 15.0 2.0
Effect. System Thruput (MB/s) 12.0 9.0 2.5 3.0 2.0 2.0 2.2 3.0 15.0 2.0
Time to Write 1 Data Set (hr) 7.11 9.48 34.33 28.44 42.67 42.67 38.79 28.44 5.69 42.67
Archive Babysitting Cost ($) $177.78 $237.04 $853.33 $711.11 $1,066.67 $1,067 $970 $711 $142 $1,067
Extended Babysitting Cost ($) $2,133 $2,844 $10,240 $8,533 $12,800 $12,800 $11,636 $8,533 $1,707 $12,800
Percent of Total Cost (%) 1% 2% 13% 8% 18% 14% 3% 3% 1% 15%
System Volume (ft3) 6.78 4.23 7.03 7.03 9.3 2.76 29.77 6.51 3.55 42.77
Extended System Space Cost ($) $3.25 $2.03 $3.37 $3.37 $4.46 $1.32 $14.29 $3.12 $1.70 $20.53
Percent of Total Cost (%) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
System Power Usage (watts) 350 300 300 300 300 300 200 200 600 1,170
Extended Power Usage Cost ($) $22.89 $23.46 $63.40 $54.18 $77.22 $77.22 $47.29 $36.12 $34.63 $301.16
Percent of Total Cost (%) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Manhours per Cleaning (min) 5 5 5 5 5 5 5 5 5 5
Hours between Cleanings 30 1,000 1,000 1,000 30 20 5,000 5,000 30 30
Materials Cost per Cleaning ($) $2.08 $2.08 $4.00 $4.00 $2.08 $1.25 $0.00 $0.00 $2.08 $2.08
Maintenance Cost per Archive $4.44 $0.18 $0.84 $0.70 $26.65 $4.67 $0.10 $0.07 $3.55 $26.65
Extended System Maint Cost $53.30 $2.13 $10.04 $8.36 $319.83 $416 $1.16 $0.85 $42.64 $319
Percent of Total Cost (%) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Media Formatting Time (min/media) 0 0 0 0 0 0 2 1 0 0
Manpower Media Loading per Archive $92 $394 $394 $197 $564 $984 $2,603 $6,156 $13 $184
Ext'd Manpower Media Loading Cost $1,103 $4,725 $4,725 $2,363 $6,773 $11,813 $31,240 $73,868 $158 $2,205
Percent of Total Cost (%) 1% 4% 6% 2% 9% 12% 7% 26% 0% 3%
EXTENDED TOTAL COST ($) $153,478 $129,097 $80,245 $104,163 $70,457 $94,709 $420,873 $287,467 $126,744 $84,377
EXTENDED TOTAL COST PER DATA SET $6,395 $5,379 $3,344 $4,340 $2,936 $3,946 $17,536 $11,978 $5,281 $3,516
EXTENDED TOTAL COST/GB ($/GB) $21.32 $17.93 $11.15 $14.47 $9.79 $13.15 $58.45 $39.93 $17.60 $11.72