ABCDEFGHIJKLMNOPQRST
1
AmazonCommercial
2
Levers in yellowGB transferred per host/month320Gigabytes
3
PUE1.8
4
Utility Power0.14Dollars (PG&E Schedule E-20)/PeakAlternative pricing calculation
5
Cost Per Hour (XL)$0.68Cost Per Rack (street)1400Dollars per month1,000.00gigabytes/month xferred
6
 Cost per GB Transferred$0.08@150 TB ratePower Per Rack (KW)4.5NEMA L6-30R = 30A * 208V * .8 (80% rule) = 4.992KW8,000,000.00megabits/month x
7
 Cost per Hour (ELB)$0.03Peak to Average Ratio1.7Peak bandwidth to average (for %ile billing)3.09Rate (megabits/sec)
8
ELB Cost Per GB Transferred0.008MRC Rack cost in KW Equivalent311.11$/KW24.69Cost/month/Host (flat traffic)
9
Cost Per GB Transferred ELB$0.09MRC (Power)/Month181.44KW41.98Multiply by Peak to Average Ratio
10
Cost Per KiloWatt-Hr (Space)0.432 KW-Hr
11
Cost Per KiloWatt-Hr (Power)0.252Dollars (PUE * Utility Power)
12
13
Total Cost Per KW-Hr0.684Power and Space
14
Data CenterTransit Rates (datacenter)8Dollars/Mb/sec billed 95percentile 30 days
15
 Cost Per Host (CAPEX) - "XL" Equivalent one time3,315.00Cost w/ DRAC. Subract B17 if unusedSeconds in a month2592000See note below on duration of a "month"
16
Dell R300 w/ 16GB RAM 2 - 2 TB Disks, 2 post non-Dell Rack rails, NBD Support for 3 yearsGigabytes/Month324(Seconds in a month / 1000)/8
17
DRAC299.00Remote ConsoleGB/Month/Dollar Transferred0.025Dollars per GB
18
 Cost Per Watt MRC0.68Machine Cost/Month Per GB Transferred0.0420Multiple by Peak to Average ratio to get pricing
19
 Cost Per Machine (GB/Xferred)0.04
20
 Network Cost Per Host (One time)400.00setup, etc.Loaded Cost/KW (power and space)$492.55
21
Annual Rate5.00%Cost of Money
22
Watts consumed per host300.00Cashflow Per Year (savings)515,895.91(amazon cost - datacenter cost) * 12
23
Initial Capital Outlay(743,000.00)(Servers + NRC setup (B20)) * # servers
24
Hosts200NPV661,912.51NPV over 3 years (savings y1, savings y2, savings y3)+outlay - this is discounting y1 cashflow because it is realized throughout the first period. If I did it monthly, it would be different, the point is it doesn't change the answer significantly
25
FTE in both cases is equivalent2
26
Monthly Amazon CostMonthly Data Center Cost
27
 Instances97,920.00 Hosts (divided over 3 year life)$18,416.67
28
 Bandwidth5,120.00 Bandwidth$2,686.42
29
 ELB4,322.56 Space/Power/Cooling$41,045.93
30
 Network (divided over 3 year life)$2,222.22
31
Amazon$107,362.56Datacenter$64,371.23
32
33
Source of Amazon Pricing from AWS pricesheet at http://aws.amazon.com/ec2/#pricing
34
Source of Dell pricing - dell.com website - accurate as of August 9, 2010
35
Source of Colocation Pricing is estimated street
36
Note I am not including a load balancer in the equation - the dedicated horsepower on the dells allows you to run a soft loadbalancer
37
Would like to thank ASR for help on modeling
38
Hours in a month: 720: 24 hours/day * 30 days. This is slightly lower than the actual of 365.25*24/12 - which gives you 730 hours/month. I've used 720 hours a month based on commercial contract calculations.
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100