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
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more