Virtualization Cost/Benefit Analysis SPREADSHEETS

Excel spreadsheet example with all formulas provided, description has more information but cant be display here. • Currently ITCorp is running 500 physical servers which support various applications and several different operating systems. • These servers are configured into three different groups: – Group 1 consists of 400 mission critical servers. Two hundred of these servers consume 3000W of power each at full load and the other two hundred consume 3500W of power each at full load. The two hundred 3000W servers average load is 25% and the two hundred 3500W servers average load is 30% – Group 2 consists of 30 non-mission critical in-house application and file servers, each of which consumes 2800W of power at full load. The servers in this group run with an average load of 12% – Group 3 consists of a pool of 70 redundant servers utilized as backup servers. Sixty of these servers (drawing 3500W at full load) are used as backups for Group 1 servers and the other ten (drawing 2800W at full load) are used as backups for Group 2 servers. These servers all run at 8% load. • The maintenance contracts on the current physical servers are as follows: – Group 1 (3500W) servers: $8500.00/server/year – Group 1 (3000W) servers: $6500.00/server/year – Group 2 (2800W) servers: $1000.00/server/year – Group 3 (3500W) servers: $4000.00/server/year – Group 3 (2800W) servers: $1750.00/server/year • Assume that server maintenance costs will increase 3%/year over the duration of the study for all server maintenance agreements. • Server administration efforts also vary across the server groups as follows: – Group 1 (3500W) servers: 15 administrative weeks/server/year – Group 1 (3000W) servers: 14 administrative weeks/server/year – Group 2 (2800W) servers: 5 administrative weeks/server/year – Group 3 (3500W) servers: 6 administrative weeks/server/year – Group 3 (2800W) servers: 4 administrative weeks/server/year • Administrative costs are currently $100/administrative hour. Assume that administrative costs will increase at the rate of 2%/year over the duration of the study. • An administrative day is 10 hours long. An administrative week is 7 days long. A server day is 24 hours long. • Server backup efforts also vary across the server groups as follows: – Group 1 (3500W) servers: these servers are backed-up nightly and require 90 minutes per server. – Group 1 (3000W) servers: these servers are backed-up nightly and require 75 minutes per server. – Group 2 (2800W) servers: these servers are backed-up weekly and require 4 hours per server. – Group 3 (3500W) servers: these servers are backed-up nightly and require 90 minutes per server. – Group 3 (2800W) servers: these servers are backed-up weekly and require 2 hours per server.