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 |
| |