Closed

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

Skills: Business Analysis, Excel, Excel Macros, Excel VBA

See more: cost benefit analysis template excel, cost benefit analysis template xls, simple cost benefit analysis example, cost benefit analysis template word, cost benefit analysis formula, how to do a cost benefit analysis, cost benefit analysis economics, cost benefit analysis steps, simple cost benefit template excel, free cost benefit analysis template, cost benefit analysis ppt for inventory outsourcing, cost benefit analysis engineering software package for sale, outsourcing cost benefit analysis template, cost benefit analysis template, cost benefit analysis

About the Employer:
( 180 reviews ) Calcutta, India

Project ID: #17163246

16 freelancers are bidding on average ₹320/hour for this job

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
(12 Reviews)
5.2
tiaratechies

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

₹1000 INR / hour
(37 Reviews)
5.2
₹277 INR / hour
(30 Reviews)
5.1
NeetuSinghal

Hi, I have 9 yrs of experience in data analytics with [login to view URL] in operational Research. I have created lots of automated excel dashboard in last 9 years which shows customized reports, using graphs etc. Technique More

₹277 INR / hour
(10 Reviews)
3.5
₹100 INR / hour
(16 Reviews)
3.2
kunalcj

Hello. I am ready to accept the Cost Benefit Analysis of your project. I am providing following services: > Cash Flow, Fund Flow, Business Plans > Financial Modeling, Financial Analysis, Excel > Finance, Accou More

₹170 INR / hour
(6 Reviews)
3.1
₹100 INR / hour
(3 Reviews)
1.1
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
Developer102

Hi, am Data analyst in Financial and banking sector. Specialized with business performance and reporting.I can be able to complete your task as specified. I have skills in financials and excel.

₹100 INR / hour
(0 Reviews)
0.0
chiragsparekh

A Gujarati man can do well cost analysis than other.

₹100 INR / hour
(0 Reviews)
0.0
₹111 INR / hour
(0 Reviews)
0.0
₹277 INR / hour
(0 Reviews)
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
₹277 INR / hour
(0 Reviews)
0.0