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-12) and then place the total in cell D13. 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 D18:D26 and I16:I21. You must have formulas for cells D2:D15 and I2:M2 to get credit.

PAGE1

Item - In house Exchange Server

Price

Qty

Extended Cost

Item - Cloud Exchange Server

Price (Month)

Months per yr

Annual Cost (per 1 user)

# of Users

Annual Cost (per yr for 5 users)

Total Years

Total (4 yrs)

Dell PowerEdge R730 Server

$9,795

1

Office 365 (Use Office 365 Business pricing.)

Windows 2012 Server R2-Included

$0

2 Processors each with 8 Cores - Included

$0

4 RAM Modules each with 8GB - Included

$0

6 Hard Drives each 2TB - Included

$0

Exchange Server Standard license

$775

1

Outlook Client Access License (CAL) (per user)

$88

5

Initial Capital (Sum of above) - 1st month cost

System Admin Support for email (1/10th of overall $65,000 salary) - Year1

$6,500

1

System Admin Support for email (1/10th of overall $65,000 salary) - Year2

$6,500

1

System Admin Support for email (1/10th of overall $65,000 salary) - Year3

$6,500

1

System Admin Support for email (1/10th of overall $65,000 salary) - Year4

$6,500

1

Total of System Admin Support (sum of admin support only) - 4 yrs

Total Cost of Ownership (Initial Capital + total Sys Admin support)

Cloud Exchange Server Model (5 users)

Points

Earned

Short Answers

10) What is the cost per year per user

1

On Premise Exchange Server Model (5 users)

Points

Earned

Short Answers

11) What is the annual cost per year for 5 users

1

Use information in A2:A6 to answer Q1-Q4, Q6

12) What is the total cost (5 users for 4 years)

1

1) What is this Dell Server's Operating System (be specific)

1

13) What is the initial capital required for the cloud setup (Month 1) for 5 users

2

2) How many cores per single processor (this server). Ch4 powerpoint, slide 4 provides background. Hint this server has 2 processors

1

14) What is the difference (in $) between the initial capital required for the hosted (Q8) vs the cloud environment (Q13)

2

3) How many total cores on the server (total cores on both processors)

1

15) What is the difference (in $) between the total cost required for the hosted (Q9) vs the cloud environment (Q12) over 4 yrs

2

4) How much main memory (RAM) (total RAM on the server)

1

Total

20

0

5) Is RAM volatile or non-volatile (NV)

1

6) How much secondary storage (total hard drive capacity on this server)

1

7) Is secondary storage volatile or NV

1

8) What is the initial capital required for this setup (Dell server, Exchange server, and client licenses) (this ignores SysAdmin costs)

2

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).

PAGE2

PowerEdge R730	PowerEdge R730 Server
Trusted Platform Module (TPM)	No Trusted Platform Module
Chassis Configuration	Chassis with up to 8, 3.5" Hard Drives
Processor	Intel Xeon E5-2620 v4 2.1GHz,20M Cache,8.0GT/s QPI,Turbo,HT,8C/16T (85W) Max Mem 2133MHz
PCIe Riser	Risers with up to 1, x8 PCIe Slots + 2, x16 PCIe Slots
Additional Processor	Intel Xeon E5-2620 v4 2.1GHz,20M Cache,8.0GT/s QPI,Turbo,HT,8C/16T (85W) Max Mem 2133MHz
Memory DIMM Type and Speed	2400MT/s RDIMMs
Processor Thermal Configuration	2 CPU Standard
Memory Configuration Type	Performance Optimized
Memory Capacity	32GB RDIMM, 2400MT/s, Dual Rank, x4 Data Width
RAID Configuration	RAID 10 for H330/H730/H730P (4-16 HDDs or SSDs in pairs)
RAID Controller	PERC H330 RAID Controller
Hard Drives	2TB 7.2K RPM SATA 6Gbps 3.5in Hot-plug Hard Drive
Network Daughter Card	Broadcom 5720 QP 1Gb Network Daughter Card
Additional Network Cards	Broadcom 5719 QP 1Gb Network Interface Card
Additional PCIe Cards	None
Embedded Systems Management	iDRAC8 Express, integrated Dell Remote Access Controller, Express
Host Bus Adapter/Converged Network Adapter	None
Internal Optical Drive	No Internal Optical Drive
Bezel	No Bezel
Rack Rails	ReadyRails Sliding Rails With Cable Management Arm
Power Management BIOS Settings	Power Saving Dell Active Power Controller
Internal SD Module	None
Power Supply	Dual, Hot-plug, Redundant Power Supply (1+1), 750W, Titanium, 200-240VAC
Power Cords	C13 to C14, PDU Style, 12 AMP, 6.5 Feet (2m) Power Cord, North America
System Documentation	Electronic System Documentation and OpenManage DVD Kit
Operating System	Windows Server2012R2,DataCTR Ed,Factory Inst,No MED,2SKT,Unlimited VM
OS Media Kits Page2	Windows Server 2012R2,DC Ed,Media Kit w/Factory Inst STD DGRD Images Page1

2

CHW Excel Irsat Page Layou Fomu D RaviVi Hl Tel me what you wan to do r u, a- , $ , % , Condicu"al Funrala Heading 2 Heading 3 Heading 4 Title = = Merge a center pboard Nuncer Styfes Annual Cost lper yr for 5 Total Years Total [4 Months Annual Cost Item -In house Exchanze Server 2 Dcll PowrEd R730 Scrver (per 1 user)Hof Users users) Price Extended Cost Item doud Exchanre Server Price (Month per yr WIndows 2012 Server R2-Includad 4 | 2 Processors coch with 8 cr21 incluced 50 7 |Txd.are-Ser.-, StHnda'': li'. 9 Initialc Sum of abowe) - 1st month cost 10 Svstem Admin Suppert for emall oth ot avrall $65,000alry Yearl $6,500 ystem Admin Suppcrt or mai ith ot averall $A5,000 salary-Year? 12 System Admin Sappert ter emil1hof overall S5,0aryl-Year 14 Total at System Admin Support [sum ot admin support only]-4 yrs +wtal Sys Admin Points Earned Short Answers Cloud Exchange Server Model 0) what is the cost per year per user what is the annual cost peryearf 17 On Premisc Exchangc Server Model (5 users 8 whst is this Dell Server's Operatirg Systete speafic) Earned Short Answers wint, 8L1 )10 or 5 uscr What ts the tutal cost (5 users for 4 years] 13 what is the initial capital requirn far the Ho many cores peraingle pshs ser.CMpwprpaint, lde 4 provides barkground. Hint thls scrver has 2 processors CPU concs W withincloud setup (Month 1) tor S users What ts the drference(in between the initial capital required tor the hostd )s the claud environment(13 15) what l' the ditterenca (ln S between the total cost requirec for the hosted (91 vs th 20 ) How many total ccrcs on the server(tot:l corcs n both procaroor otal 22 5)s RAM voletile cr non-volatle INV 2316) How much ieanidary crarar :tntal hari drivecacity on this server; 24 7sendary storaga volatiie or Nv 8) whet is the initial capital required for this setup (Dell server, Exchange 25lserver, and dient licens(this ienaresSyshiimin a sts) the cerall total cost torthis in hcusa Exchange ennwironment (Initial |Capital + SysAdmin Hosted vs Cloud | ekad Info-Dell Config O lype hene to search CHW Excel Irsat Page Layou Fomu D RaviVi Hl Tel me what you wan to do r u, a- , $ , % , Condicu"al Funrala Heading 2 Heading 3 Heading 4 Title = = Merge a center pboard Nuncer Styfes Annual Cost lper yr for 5 Total Years Total [4 Months Annual Cost Item -In house Exchanze Server 2 Dcll PowrEd R730 Scrver (per 1 user)Hof Users users) Price Extended Cost Item doud Exchanre Server Price (Month per yr WIndows 2012 Server R2-Includad 4 | 2 Processors coch with 8 cr21 incluced 50 7 |Txd.are-Ser.-, StHnda'': li'. 9 Initialc Sum of abowe) - 1st month cost 10 Svstem Admin Suppert for emall oth ot avrall $65,000alry Yearl $6,500 ystem Admin Suppcrt or mai ith ot averall $A5,000 salary-Year? 12 System Admin Sappert ter emil1hof overall S5,0aryl-Year 14 Total at System Admin Support [sum ot admin support only]-4 yrs +wtal Sys Admin Points Earned Short Answers Cloud Exchange Server Model 0) what is the cost per year per user what is the annual cost peryearf 17 On Premisc Exchangc Server Model (5 users 8 whst is this Dell Server's Operatirg Systete speafic) Earned Short Answers wint, 8L1 )10 or 5 uscr What ts the tutal cost (5 users for 4 years] 13 what is the initial capital requirn far the Ho many cores peraingle pshs ser.CMpwprpaint, lde 4 provides barkground. Hint thls scrver has 2 processors CPU concs W withincloud setup (Month 1) tor S users What ts the drference(in between the initial capital required tor the hostd )s the claud environment(13 15) what l' the ditterenca (ln S between the total cost requirec for the hosted (91 vs th 20 ) How many total ccrcs on the server(tot:l corcs n both procaroor otal 22 5)s RAM voletile cr non-volatle INV 2316) How much ieanidary crarar :tntal hari drivecacity on this server; 24 7sendary storaga volatiie or Nv 8) whet is the initial capital required for this setup (Dell server, Exchange 25lserver, and dient licens(this ienaresSyshiimin a sts) the cerall total cost torthis in hcusa Exchange ennwironment (Initial |Capital + SysAdmin Hosted vs Cloud | ekad Info-Dell Config O lype hene to search