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.

This is all the data i was provided with.As far as the picture goes This is the best onw i could get.

CHW Excel Irsat Page Layou Fomu D RaviVi Hl Tel me what you wan to do pboard Stl:s A19 ) cow many caras aer singlernesar this server ch4 anwerpoint, slide4provide; aack rand. Hin this server has , processors Cost lper yr for 5 Total Months Annual Cost 1Item -In house Exchanze Server Price Extended Cost Item doud Exchanre Server Price (Month # of Users u Years Total [4 3 WIndows 2012 Scrver R2-Includad 4 | 2 Processors och with Cores . Incluced 50 7 Exthanes Serverstandard license 9 Inltial ystem Admin Suppcrttcramall 1/10th ot avcrall $65,000s2: 2 Systemn Admin Suppert for email 1/1Uth of overall $65,00U selleryl-Year $o,50 m Admin S um at adimin suppart ontyl-4 nst at Chamership rinitial Cloud Exchanee Server Model (5 users Earned Short Answers 16 10% what is the ast per year per user On Premise Exchange Server Model | Earned Short Answers11what is the annual oost per year for Susers 12 What is the totaliast (S '/sers for yer.rs] 13) whstis the Inttial capital quired torthe cloud setup (Month 1) for 5users 1 Wht is the dierence (in I between the Inltlal cptal requircdtor the hoted la vsthe cloud environment12) 5) What is the diffcrcnc2(in between the 9 er). Ch4 powerpcint,lde 4 provides background. Hint this server has 2 p 20 How many total ccres cn the server total cores on both processorsl 4) How much main memory (RAM) (tatal RAM on tho claud onvironment (12) awor4yrs 20 23) How much secondary storage itctal hard driwa capaclty an thiss 24 Tis secondary storage volatile or NV 8) wht is the itiapetal equired for this selug (ell server, xtharge r, and client liconseal this ignaras SysAcimin ccts) )Assumell get 4 yrs aut afusage tom your h/w andw, hew mich the overall total ccet for the in house Exchange cmtronmenti Initial Hosted vs Cloud ekad nf Dell confi O lype hene to search CHW Excel Irsat Page Layou Fomu D RaviVi Hl Tel me what you wan to do pboard Stl:s A19 ) cow many caras aer singlernesar this server ch4 anwerpoint, slide4provide; aack rand. Hin this server has , processors Cost lper yr for 5 Total Months Annual Cost 1Item -In house Exchanze Server Price Extended Cost Item doud Exchanre Server Price (Month # of Users u Years Total [4 3 WIndows 2012 Scrver R2-Includad 4 | 2 Processors och with Cores . Incluced 50 7 Exthanes Serverstandard license 9 Inltial ystem Admin Suppcrttcramall 1/10th ot avcrall $65,000s2: 2 Systemn Admin Suppert for email 1/1Uth of overall $65,00U selleryl-Year $o,50 m Admin S um at adimin suppart ontyl-4 nst at Chamership rinitial Cloud Exchanee Server Model (5 users Earned Short Answers 16 10% what is the ast per year per user On Premise Exchange Server Model | Earned Short Answers11what is the annual oost per year for Susers 12 What is the totaliast (S '/sers for yer.rs] 13) whstis the Inttial capital quired torthe cloud setup (Month 1) for 5users 1 Wht is the dierence (in I between the Inltlal cptal requircdtor the hoted la vsthe cloud environment12) 5) What is the diffcrcnc2(in between the 9 er). Ch4 powerpcint,lde 4 provides background. Hint this server has 2 p 20 How many total ccres cn the server total cores on both processorsl 4) How much main memory (RAM) (tatal RAM on tho claud onvironment (12) awor4yrs 20 23) How much secondary storage itctal hard driwa capaclty an thiss 24 Tis secondary storage volatile or NV 8) wht is the itiapetal equired for this selug (ell server, xtharge r, and client liconseal this ignaras SysAcimin ccts) )Assumell get 4 yrs aut afusage tom your h/w andw, hew mich the overall total ccet for the in house Exchange cmtronmenti Initial Hosted vs Cloud ekad nf Dell confi O lype hene to search