Constants and Shared Variables WorkSheet

Constants

$8760$ hoursInAYear number of hours in $1$ year $(24$ hrs$/$day $*365$ days$/$yr$)$

$12$ monthsInAYear number of months in a year

$52$ weeksInAYear number of weeks in a year

$365$ daysInAYear number of days in $1$ year

$1000$ wattsInAKilowatt number of watts in one kilowatt

$24$ hoursInARealDay

Shared VariablesThese are not constants but are variables which are shared across both scenarios

$$90\mathrm{.}00$ administrativeCostPerHourYear$1$ cost of administrative time per hour in year $1$

administrativeRateIncrease administrative pay increase amount

securityFirmMonthlyCharge cost per month for security auditing service $-$ outside vendor

dataStorageMonthlyChargeYears$1$And$2$ cost per month for storing archival backups $-$ years $1$ & $2-$ outside vendor

dataStorageMonthlyChargeYears$3$Thru$5$ cost per month for storing archival backups $-$ years $3,45-$ outside vendor

serverMaintenanceRateIncrease assume $3\%$ increase in server maintenance cost each year of study

$$0\mathrm{.}13$ costkwHYear$1$ cost of $1$ kwH or power in year $1$

$1\mathrm{.}02$ powerRateIncrease assume $2\%$ increase in cost of power$/$year of study

$10$ hoursInADay number of hours in $1$ administrative day

$70$ hoursInAWeek number of hours in $1$ administrative week

Variables Used In The Current Scenario Spreadsheet

Hard Costs

Value Variable Name Variable Description

$20000$ numServersGroup$1$ Group$1$A consists of this many servers

$4000$ numServersGroup$2$ Group $2$ consists of this many servers

numServersGroup$3$ Group $3$ consists of this many servers

numServersGroup$4$A Group $4$A consists of this many servers $-$ backup servers

numServersGroup$4$B Group $4$B consists of this many servers $-$ backup servers

$3600$ serverPowerGroup$1$ power in watts of the servers in group $1$

serverPowerGroup$2$ power in watts of the servers in group $2$

serverPowerGroup$3$ power in watts of the servers in group

serverPowerGroup$4$A power in watts of the servers in group $4$A

serverPowerGroup$4$B power in watts of the servers in group $4$B

$0\mathrm{.}17$ serverLoadGroup$1$ average load of the servers in group $1$

serverLoadGroup$2$ average load of the servers in group $2$

serverLoadGroup$3$ average load of the servers in group $3$

serverLoadGroup$4$A average load of servers in group $4$A

serverLoadGroup$4$B average load of servers in group $4$B

maintenanceCostYear$1$Group$1$ cost of maintenance contract year $1/100$ servers in group $1-$

maintenanceCostYear$1$Group$2$ cost of maintenance contract year $1/100$ servers in group $2$

maintenanceCostYear$1$Group$3$ cost of maintenance contract year $1-$ servers in group $3$

maintenanceCostYear$1$Group$4$A cost of maintenance contract year $1/100$ servers in group $4$A

maintenanceCostYear$1$Group$4$B cost of maintenance contract year $1/100$servers in group $4$B

costUnitsGroup$1$ cost units for group$1-20000/100=200$

costUnitsGroup$2$ cost units for group $2$

costUnitsGroup$3$ cost units for group$3$

costUnitsGroup$4$A cost units for group $4$A

costUnitsGroup$4$B cost units for group $4$B

Soft Costs

Value Variable Name Variable Description

$5\mathrm{.}00$ weeksAdministrativeTimeGroup$1$ weeks of administrative time per server Group $1$

weeksAdministrativeTimeGroup$2$ weeks of administrative time per server Group

weeksAdministrativeTimeGroup$3$ weeks of administrative time per server Group $3$

weeksAdministrativeTImeGroup$4$A weeks of administrative time per server Group $4$A

weeksAdministrativeTImeGroup$4$B weeks of administrative time per server Group $4$B

hoursPerBackupGroup$1$ hours per backup of server in Group $1$

hoursPerBackupGroup$2$ hours per backup of server in Group $2$

hoursPerBackupGroup$3$ hours per backup of server in Group $3$

hoursPerBackupGroup$4$A hours per backup of server in Group $4$A

hoursPerBackupGroup$4$B hours per backup of server in Group $4$B

numberOfBackupsPerYearGroup$1$ number of backups performed on servers in Group $1$ in $1$ year

numberOfBackupsPerYearGroup$2$ number of backups performed on servers in Group $2$ in $1$ year

numberOfBackupsPerYearGroup$3$ number of backups performed on servers in Group $3$ in $1$ year

numberOfBackupsPerYearGroup$4$A number of backups performed on servers in Group $4$A in $1$ year

numberOfBackupsPerYearGroup$4$B number of backups performed on servers in Group $4$B in $1$ year

$0$

Current Scenario Yearly Costs

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 $4$A

Power $-$ Group $4$B

Total Power Costs$/$Year #NAME?

Server Maintenance $-$ Group $1$

Server Maintenance $-$ Group $2$

Server Maintenance $-$ Group $3$

Server Maintenance $-$ Group $4$A

Server Maintenance $-$ Group $4$B

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 $4$A

Server Administration $-$ Group $4$B

Total Server Administration Costs$/$Year

Server Backup $-$ Group $1$

Server Backup $-$ Group $3$

Server Backup $-$ Group $3$

Server Backup $-$ Group $4$A

Server Backup $-$ Group $4$B

Total