A B C D E F H. I J L M N 1 To ensure employee productivity and security, the organization has decided to implement desktop virtualization for all remote employees. There are two popular solutions. VDI (Virtual desktop infrastructure) and Daas (Desktop as a Service). Citrix and Amazon Workspaces are examples of VDI and Daas, respectively. 2 3 VDI is managed by the company itself, hosted and managed on-site or at a colocation facility, while DaaS is a managed infrastructure service delivered by a provider and hosted in their data centers. 4 It would help if you compared VDI and DaaS and recommend a better solution to the management. 5 Table 1 has VDI and DaaS's ratings on the various parameter; the rating is on a scale of 1 to 4, where 1 is least preferred, and 4 is most preferred. 6 Cell range C12:C20 has the weights for the assessment criteria. Range D12:D20 and E12:E20 have the ratings for VDI and Daas, respectively. 7 (a) Using SUMPRODUCT Function, write a formula in cell range D22 to compute the weighted score of VDI. Copy the formula to cell E22 to calculate Daas' weighted score. 1 4 4 1 8 (b) Using IF function, write a formula in cell range D24 to display your recommendation. Hint: If the Weighted Score of VDI is more than Daas, then VDI should be recommended, else DaaS should be recommended. 9 10 Table 1 11 Assessment Criteria Weight VDI DaaS 12 Platform Maintenance 15% 1 4 13 Initial Cost 15% 4 14 Ongoing Cost 15% 1 15 Control 5% 2 16 Time to setup 5% 4 17 Modification 10% 3 1 18 Dedicated IT Staff 15% 4 19 Total Cost of Ownership 10% 3 3 20 Technology Maturity 10% 4 2 21 22 Weighted Score Weighted Score 23 24 Your Recommendation Your Recommendation 25 1 Sample Answer 2.3 2.85 Daas