need a expert who can do cost benefit analysis in excel
₹100-400 INR / hour
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
Project ID: #17163246
About the project
14 freelancers are bidding on average ₹346/hour for this job
Hello, we are a team of chartered accountants and CPA, if you are interested drop a message to discuss further.
Hello, I am proficient in excel and can perform cost benefit analysis in excel as well. Please let me know the details on the same. Thanks and have a good day!
I can do financial and business analyzes of any kind. I worked as personal financial analyst for Phinance S.A. and now I starting my own business on the extended field!
I have extensive experience in financial modeling. I have worked with consulting companies such as KPMG, Ernst & Young and Accenture. I have worked with large companies looking to enter new markets as well as small com More
I have good analysis skills and data-understanding skills. I have in-depth experience in requirements analysis, IT design and application development.