- It so happens that I have been working on a similar worksheet for pricing & configuring our analytics infrastructure;
- I modified the one I am working on (inspired by the original at ec2 pricing_and_capacity) & morphed into the one Otis wanted
- The Excel worksheet is hosted it in github. Feel free to modify it to fit your needs. Let me know as well …
- I have four sets of prices viz. on-demand, reserved-light,reserved-medium usage and reserved- heavy usage. The prices are calculated for one year (8640 hrs) off of the cell M1 – one has to prorate the upfront fees to get the effective $/hr rate
- The worksheet has multiple uses – I use it to compute the price difference for different usage patterns-high memory for Spark, different sizes for HBase cluster et al. As it is a spreadsheet one could sort it on varying criteria; one could change the numbers (say 6 months) and see what model makes sense.
- BTW, it is interesting to see that the Light -Reserved costs more in all cases except for the storage models.
- Long time ago, I had a graphical representation, which has become very dated. I might resurrect it with the new prices …
The Spreadsheet :
The left columns have the attributes of the various EC2 models.
The 8640 (hrs/year) is in M1. All the calculations are based on this cell. The reserved light is interesting … it costs more !
The reserved medium does save $. Moreover, one can stop the instances when not needed.
I have calculated the yearly price prorating the upfront fees et al. But for Heavy Reserved, it is somewhat meaningless as they will charge for the whole year even if the instances are stopped. But changing the value in M1 gives a feel for the different tiers …
I would be happy to hear other inferences we can make and add columns to the worksheet …