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, 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. 8 9 10 11 12 13 B 14 15 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. 16 17 18 19 20 21 22 23 24 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 15% 15% 15% 5% 5% 10% 15% 10% 10% Weighted Score Your Recommendation Table 1 VDI 1 1 4 Al 4 1 3 1 3 4 2.3 DaaS 4 4 1 2 4 1 4 3 2 G 2.85 Weighted Score Your Recommendation H Sample Answer DaaS 2.3 J L M 2.85 N

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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.

Screenshot attached thanks

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
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
B
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
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
M
2.85
N
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 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 B 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 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 M 2.85 N
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Types of CRM
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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education