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, 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. It would help if you compared VDI and DaaS and recommend a better solution to the management. 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. 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. (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. 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 4 1 3 1 3 4 2.3 DaaS 4 1 4 3 2 2.85 Weighted Score Your Recommendation Sample Answer DaaS 2.3 2.85
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, 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. It would help if you compared VDI and DaaS and recommend a better solution to the management. 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. 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. (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. 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 4 1 3 1 3 4 2.3 DaaS 4 1 4 3 2 2.85 Weighted Score Your Recommendation Sample Answer DaaS 2.3 2.85
Chapter11: Operating Systems
Section: Chapter Questions
Problem 2RP
Related questions
Question
(b) Using IF function, write a formula in cell range D24 to display your recommendation. DaaS should be recommended after you input the formula
Thanks
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning