need a expert who can do cost benefit analysis in excel

Closed Posted 5 years ago Paid on delivery
Closed

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

Business Analysis Excel Excel Macros Excel VBA

Project ID: #17163246

About the project

14 proposals Remote project Active 5 years ago

14 freelancers are bidding on average ₹346/hour for this job

tiaratechies

Hello, we are a team of chartered accountants and CPA, if you are interested drop a message to discuss further.

₹1000 INR / hour
(97 Reviews)
7.4
vaidyag

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in I More

₹1000 INR / hour
(15 Reviews)
5.4
tapanil

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!

₹400 INR / hour
(0 Reviews)
0.0
AstroSolar

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!

₹370 INR / hour
(0 Reviews)
0.0
chiragsparekh

A Gujarati man can do well cost analysis than other.

₹100 INR / hour
(1 Review)
0.0
nivedita75

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

₹277 INR / hour
(0 Reviews)
0.0
vk2227

I have good analysis skills and data-understanding skills. I have in-depth experience in requirements analysis, IT design and application development.

₹277 INR / hour
(0 Reviews)
0.0