need a expert who can do cost benefit analysis in excel

need an expert who can do cost benefit analysis in excel Group 1 consists of 800 mission critical servers. Five hundred of these servers (call them Group 1A) consume 3000W of power each at full load and the other three hundred (call them Group 1B) consume 3500W of power each at full load. The Group 1A servers average load is 20% and the Group 1B servers average load is 35% – Group 2 consists of 100 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 10% – Group 3 consists of a pool of 300 redundant servers utilized as backup servers. Two hundred and eighty of these servers (call them Group 3A) draw 3500W at full load and are used as backups for Group 1 servers. The other twenty servers (call them Group 3B) draw 2800W at full load and are used as backups for Group 2 servers. Group 3A and 3B servers run at 8% load. CNT 4603: Project Two Page 5 Dr. Mark Llewellyn © Project Two: The Current Scenario • The maintenance contracts on the current physical servers are as follows: – Group 1A (3000W) servers: $5500.00/server/year – Group 1B (3500W) servers: $8500.00/server/year – Group 2 (2800W) servers: $1000.00/server/year – Group 3A (3500W) servers: $4000.00/server/year – Group 3B (2800W) servers: $1850.00/server/year • Assume that server maintenance costs will increase 3%/year over the duration of the study for all server maintenance agreements. CNT 4603: Project Two Page 6 Dr. Mark Llewellyn © Project Two: The Current Scenario • Server administration efforts also vary across the server groups as follows: – Group 1A (3000W) servers: 10 administrative weeks/server/year – Group 1B (3500W) servers: 12 administrative weeks/server/year – Group 2 (2800W) servers: 5 administrative weeks/server/year – Group 3A (3500W) servers: 6 administrative weeks/server/year – Group 3B (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. CNT 4603: Project Two Page 7 Dr. Mark Llewellyn © Project Two: The Current Scenario • Server backup efforts also vary across the server groups as follows: – Group 1A (3000W) servers: these servers are backed-up nightly and require 75 minutes per server. – Group 1B (3500W) servers: these servers are backed-up nightly and require 90 minutes per server. – Group 2 (2800W) servers: these servers are backed-up weekly and require 4 hours per server. – Group 3A (3500W) servers: these servers are backed-up nightly and require 90 minutes per server. – Group 3B (2800W) servers: these servers are backed-up weekly and require 2 hours per server