Microsoft Exchange server and Microsoft Outlook client are the most popular email configurations in the business world. Up until the cloud, companies had to purchase all of the hardware and software to install and maintain Exchange at their business on premise. Hardware has a typical 4 year life span before it needs to be updated. With the advent of the cloud, businesses have the option to purchase access to a cloud-based Exchange server that is hosted off premise via Microsoft at a much lower cost. This assignment compares both the hosted (on-premise) scenario (left hand table) and the cloud scenario (right hand table) found in this assignment’s Ch4 HW excel sheet. Your analysis will be for a new small business that is starting with 5 employees. Since the hardware environment is good for four years, we will also need to ensure that we calculate the total cost of our cloud environment for four years and 5 users to have an accurate comparison.
For the hosted scenario, a Dell Server was provided that includes the operating system, processors with multiple cores, several main memory (RAM) modules, several secondary storage hard drives, along with the cost of Exchange server that is installed on the hardware, and the quantity and cost of outlook client access licenses (CALs). Since this is being hosted on premise, a company will need part of a system administrator’s time to maintain the system (roughly 4hrs or 10% a week). Since the system administrator’s salary is $50K per year, we will need to account for benefits (1.3 is a typical number). Therefore the ‘real’ cost to a company for a sys admin in this scenario is $65K ($50K x 1.3).
Calculate the extended price in column D for each line item (rows 2-8 and 10-13) and then place totals in cell D9,14, and 15. The capital required to get the Exchange server up and going is the price of the server along with the Exchange and CAL costs. However, the total cost of ownership must also take into account the system administrator cost for four (4) years. For simplification purposes, the space required and the electricity and cooling (HVAC) have been ignored.
In addition to the calculations, one must answer the embedded questions in the xlsx. Place answers in cells B19:B27 and G18:G23. You must have formulas for cells D2:D15 and G2:M2 to get credit.
Item – On Premise Exchange Server
Price
Dell PowerEdge R730 Server
Windows 2019 Server -Included
2 Processors each with 8 Cores – Included
4 RAM Modules each with 8GB – Included
6 Hard Drives each 2TB – Included
Exchange Server Standard license
Outlook Client Access License (CAL) (per user)
Initial Capital (Sum of Extended Costs) – 1st month cost
System Admin Support for email (1/10th of overall $65,000 salary) – Year1
System Admin Support for email (1/10th of overall $65,000 salary) – Year2
System Admin Support for email (1/10th of overall $65,000 salary) – Year3
System Admin Support for email (1/10th of overall $65,000 salary) – Year4
Total of System Admin Support (sum of admin support only) – 4 yrs
Total Cost of Ownership (Initial Capital + total Sys Admin support)
$9,795
$0
$0
$0
$0
$775
$88
$6,500
$6,500
$6,500
$6,500
On Premise Exchange Server Model (5 users)
Short Answers
Use information in A2:A6 to answer Q1-Q4, Q6
1) What is this Dell Server’s Operating System (be specific)
2) How many cores per single processor (this server). Ch4 powerpoint, slide 4
provides background.
3) How many total cores on the server (total cores on both processors). Hint this
server has 2 processors.
Fill in
4) How much main memory (RAM) (total RAM on the server)
Fill in
5) Is RAM volatile or non-volatile (NV)
Fill in
Fill in
Fill in
Fill in
Fill in
6) How much secondary storage (total hard drive capacity on this server)
7) Is secondary storage volatile or NV
8) What is the initial capital required for this setup (Dell server, Exchange server,
and client licenses) (this ignores SysAdmin costs)
Fill in
9) Assume you will get 4 yrs out of usage from your h/w and s/w, how much is the
overall total cost for this in house Exchange environment (Initial Capital +
SysAdmin costs).
Fill in
Total
Qty
Extended Cost
Item – Cloud Exchange Server
Price
(per month)
Office 365 (Use Office 365 Business Standard pricing
for Price.)
1
1
5
1
1
1
1
Points
Pts Earned
6
Cloud Exchange Server Model (5 users)
Short Answers
10) What is the cost per year per user
Fill in
Fill in
1
11) What is the annual cost per year for 5 users
1
1
12) What is the total cost (5 users for 4 years)
13) What is the initial capital required for the cloud
setup (Month 1) for 5 users
1
14) What is the difference (in $) between the initial
capital required for the hosted (Question8) vs the
cloud environment (Question13)
Fill in
Fill in
15) What is the difference (in $) between the total
cost required for the hosted (Question9) vs the cloud
environment (Question12) over 4 yrs
Fill in
Total
1
1
1
0
Formulas for D2:D15, I2, K2, M2, and price filled in for Nothing required
G2
here
1
1
9
Fill in
Grand Total
0
Annual
Total Cost
Cost (per yr Total Ownership(
# of Users for 5 users) Years 4 yrs)
Months Annual Cost
(per yr) (per 1 user)
12
Points
5
Pts Earned
1
1
1
1
1
1
6
0
5
20
0
4
Memory DIMM Type and Speed
PowerEdge R730 Server
No Trusted Platform Module
Chassis with up to 8, 3.5″ Hard Drives
Intel® Xeon® E5-2620 v4 2.1GHz,20M Cache,8.0GT/s
QPI,Turbo,HT,8C/16T (85W) Max Mem 2133MHz
Risers with up to 1, x8 PCIe Slots + 2, x16 PCIe Slots
Intel® Xeon® E5-2620 v4 2.1GHz,20M Cache,8.0GT/s
QPI,Turbo,HT,8C/16T (85W) Max Mem 2133MHz
2400MT/s RDIMMs
Processor Thermal Configuration
2 CPU Standard
Memory Configuration Type
Memory Capacity
RAID Configuration
RAID Controller
Hard Drives
Network Daughter Card
Additional Network Cards
Additional PCIe Cards
Performance Optimized
32GB RDIMM, 2400MT/s, Dual Rank, x4 Data Width
RAID 10 for H330/H730/H730P (4-16 HDDs or SSDs in pairs)
PERC H330 RAID Controller
2TB 7.2K RPM SATA 6Gbps 3.5in Hot-plug Hard Drive
Broadcom 5720 QP 1Gb Network Daughter Card
Broadcom 5719 QP 1Gb Network Interface Card
None
Embedded Systems Management
iDRAC8 Express, integrated Dell Remote Access Controller, Express
PowerEdge R730
Trusted Platform Module (TPM)
Chassis Configuration
Processor
PCIe Riser
Additional Processor
Host Bus Adapter/Converged
Network Adapter
Internal Optical Drive
Bezel
Rack Rails
None
No Internal Optical Drive
No Bezel
ReadyRails™ Sliding Rails With Cable Management Arm
Power Management BIOS Settings
Power Saving Dell Active Power Controller
Internal SD Module
None
Dual, Hot-plug, Redundant Power Supply (1+1), 750W, Titanium, 200240VAC
C13 to C14, PDU Style, 12 AMP, 6.5 Feet (2m) Power Cord, North
America
Electronic System Documentation and OpenManage DVD Kit
Windows Server®2019
Windows Server® 2019,DC Ed,Media Kit w/Factory Inst STD DGRD
Images
Power Supply
Power Cords
System Documentation
Operating System
OS Media Kits
