Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
(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.

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

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter5: Advanced Data Modeling
Section: Chapter Questions
Problem 10C
See similar textbooks
icon
Related questions
Question

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

Thanks screenshot attached

thanks

thankz

A с D E F 1 To ensure employee productivity and security, the organization has decided to implement desktop virtualization for all remote employees. 2 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, 8 9 10 11 12 13 → 14 15 16 B 3 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 (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. 17 18 19 20 21 22 23 24 25 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. Assessment Criteria Platform Maintenance Initial Cost Ongoing Cost Control Time to setup Modification Dedicated IT Staff Total Cost of Ownership Technology Maturity Weight Weighted Score 15% 15% 15% 5% 5% 10% 15% 10% 10% Your Recommendation Table 1 VDI 1 1 4 4 1 3 1 3 4 2.3 DaaS 4 4 1 2 4 1 4 3 2 2.85 G Weighted Score Your Recommendation H Sample Answer DaaS 2.3 J K L M 2.85 N 0
Transcribed Image Text:A с D E F 1 To ensure employee productivity and security, the organization has decided to implement desktop virtualization for all remote employees. 2 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, 8 9 10 11 12 13 → 14 15 16 B 3 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 (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. 17 18 19 20 21 22 23 24 25 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. Assessment Criteria Platform Maintenance Initial Cost Ongoing Cost Control Time to setup Modification Dedicated IT Staff Total Cost of Ownership Technology Maturity Weight Weighted Score 15% 15% 15% 5% 5% 10% 15% 10% 10% Your Recommendation Table 1 VDI 1 1 4 4 1 3 1 3 4 2.3 DaaS 4 4 1 2 4 1 4 3 2 2.85 G Weighted Score Your Recommendation H Sample Answer DaaS 2.3 J K L M 2.85 N 0
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Fundamentals of Boolean Algebra and Digital Logics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS