Server Virtualization Feasibility Analysis

Project2-SpreadsheetTemplate1.xlsx

Home >Computer Science homework help >Server Virtualization Feasibility Analysis

Constants

CONSTANTS WORKSHEET
These are numbers will are constants for both scenarios (current and proposed). Do not add any values here which vary between the two scenarios
	Value	Variable Name	Description
			number of hours in 1 administrative day
			number of hours in 1 administrative week
			number of hours in 1 year (24 hrs/day * 365 days/yr)
			number of months in a year
			number of weeks in a year
			number of days in 1 year
			number of watts in one kilowatt

Current - Variables

CURRENT SCENARIO VARIABLES WORKSHEET
Hard Costs
	Value	Variable Name	Variable Description
			Group 1 consists of this many 3500W servers
			Group 2 consists of this many 4500W servers
			Group 3 consists of this many 2800W servers
			Group 4A consists of this many 3800W servers - backup servers
			Group 4B consists of this many 3300W servers - backup servers
			power in watts of the servers in group 1
			power in watts of the servers in group 2
			power in watts of the servers in group 3
			power in watts of the servers in group 4A
			power in watts of the servers in group 4B
			average load of the servers in group 1
			average load of the servers in group 2
			average load of the servers in group 3
			average load of servers in group 4A
			average load of servers in group 4B
			cost of maintenance contract year 1 - servers in group 1
			cost of maintenance contract year 1 - servers in group 2
			cost of maintenance contract year 1 - servers in group 3
			cost of maintenance contract year 1 - servers in group 4A
			cost of maintenance contract year 1 - servers in group 4B
			cost per month for security auditing service - outside vendor
			cost per month for storing archival backups - years 1 & 2 - outside vendor
			cost per month for storing archival backups - years 3,4 5 - outside vendor
Soft Costs
	Value	Variable Name	Variable Description
			administrative pay increase amount
			weeks of administrative time per server Group 1
			weeks of administrative time per server Group 2
			weeks of administrative time per server Group 3
			weeks of administrative time per server Group 4A
			weeks of administrative time per server Group 4B
			hours per backup of server in Group 1
			hours per backup of server in Group 2
			hours per backup of server in Group 3
			hours per backup of server in Group 4A
			hours per backup of server in Group 4B
			number of backups performed on servers in Group 1 in 1 year
			number of backups performed on servers in Group 2 in 1 year
			number of backups performed on servers in Group 3 in 1 year
			number of backups performed on servers in Group 4A in 1 year
			number of backups performed on servers in Group 4B in 1 year

Current Cost Structure

CURRENT SCENARIO WORKSHEET
Category	Cost					5 Year Totals
	Year 1	Year 2	Year 3	Year 4	Year 5
Hard Costs
Power - Group 1
Power - Group 2
Power - Group 3
Power - Group 4A
Power - Group 4B
Total Power Costs/Year							ERROR:#REF!
Server Maintenance - Group 1
Server Maintenance - Group 2
Server Maintenance - Group 3
Server Maintenance - Group 4A
Server Maintenance - Group 4B
Total Server Maintenance Costs/Year
Security Auditing Costs
Archival/Storage Costs
Total Yearly Hard Costs
Total Five Year Hard Costs =
Soft Costs
Server Administration - Group 1
Server Administration - Group 2
Server Administration - Group 3
Server Administration - Group 4A
Server Administration - Group 4B
Total Server Administration Costs/Year
Server Backup - Group 1
Server Backup - Group 3
Server Backup - Group 3
Server Backup - Group 4A
Server Backup - Group 4B
Total Server Backup Costs/Year
Total Yearly Soft Costs
Total Five Year Soft Costs =
Total Current Cost/Year
Total 5 YearCurrent Cost

Proposed - Variables

PROPOSED SCENARIO VARIABLES WORKSHEET
Hard Costs
	Value	Variable Name	Variable Description
			cost of a new group 1 server
			first year service maintenance cost for server in group 1
			cost of a new group 2 server
			first year service maintenance cost for server in group 2
			cost of a new group 3 server
			first year service maintenance cost for server in group 3
			cost of a new group4 server
			first year service maintenance cost for server in group 4
			number of new physical servers in Group 1
			number of virtualized servers in Group 1
			number of new physical servers in Group 2
			number of virtualized servers in Group 2
			number of new physical servers in Group 3
			number of virtualized servers in Group 3
			number of new physical servers in Group 4
			number of virtualized servers in Group 4
			power in watts of a server in group 1
			power in watts of a server in group 2
			power in watts of a server in group 3
			power in watts of a server in group 4
			cost in dollars for virtualization software for 1 server.
			% of original cost to maintain virtualization software
			cost per year to train one employee on virtualized system
			number of employees trained in years 1 and 2 of the study
			number of employees trained in years 3 through 5 of the study
Soft Costs
	Value	Variable Name	Variable Description
			estimated number of weeks/year of administrative time per new physical server
			percentage of regular admin cost associated with a virtual server
			hours per backup of physical servers + virtual servers - Group 1
			hours per backup of physical servers + virtual servers - Group 2
			hours per backup of physical servers + virtual servers - Group 3
			hours per backup of physical servers + virtual servers - Group 4
			number of backup of physical servers + virtual servers per year - Group 1
			number of backup of physical servers + virtual servers per year - Group 2
			number of backup of physical servers + virtual servers per year - Group 3
			number of backup of physical servers + virtual servers per year - Group 4

Virtualized Cost Structure

Virtualized Infrastructure Yearly Costs - Proposed Project Costs
Category	Cost					5 Year Totals
	Year 1	Year 2	Year 3	Year 4	Year 5
Hard Costs
Machine Purchases
Software Purchases
Software Maintenance
Power - Group 1
Power - Group 2
Power - Group 3
Powert Group 4
Server Maintenance - Group 1
Server Maintenance - Group 2
Server Maintenance - Group 3
Server Maintenance - Group 4
Training
Security Auditing Costs
Archival/Storage Costs
Total Yearly Hard Costs
Total Five Year Hard Costs
Soft Costs
Server Administration Group 1 - Physical
Server Admin Group 1 - Virtual Systems
Server Administration Group 2 - Physical
Server Admin Group 2 - Virtual Systems
ServerAdministration Group 3 - Physical
Server Admin Group 3 - Virtual Systems
Server Administration Group 4 - Physical
Server Administration Group 4 - Virtual
Total Administration Cost/Year
Group 1 Backup
Group 2 Backup
Group 3 Backup
Group 4 Backup
Total Backup Cost/Year
Total Yearly Soft Costs
Total Five Year Soft Costs =
Total Proposed Project Costs/Year
Total 5 Year Proposed Project Cost

Project Cost Summary

Virtualization Project Cost Summary
	Category	Cost
		Year 1	Year 2	Year 3	Year 4	Year 5
Current Infrastructure Costs
	Total Yearly Hard Costs
	Total Five Year Hard Costs
	Total Yearly Soft Costs
	Total Five Year Soft Costs
Total 5 Year Cost
Virtualized Infrastructure Costs
	Total Yearly Hard Costs
	Total Five Year Hard Costs
	Total Yearly Soft Costs
	Total Five Year Soft Costs
Total 5 Year Cost
Net Five Year Hard Cost Savings
Net Five Year Soft Cost Savings
	Net Five Year Overall Cost Savings