(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.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
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.
(g) Using INDEX Function, write a formula in cell range D68 to display the vendor. Hint: INDEX the value of cell D67 in the array D55:F55.
Screenshots attached thnaks
Transcribed Image Text:45
46
65
66
67
A
68
69
B
Assessment Criteria
Ease of management
Accessibility
Scalability
с
47 Based on the data in Table 2 and Table3, convert the categorical values to Rating Scale values.
48 (c) Using VLOOKUP write a formula in cell D56 to lookup for the cell D32 value in Table 3 (using Exact match type). Copy the formula to cells D57:F62.
49 (d) Using SUMPRODUCT Function, write a formula in cell range D64 to compute the weighted score of Vendor 1. Copy the formula to cells E64 and F64 to calculate other vendor's
50 (e) Using MAX Function, write a formula in cell range D66 to compute the maximum weighted score.
51 (f) Using MATCH Function, write a formula in cell range D67 to compute the cell's column number having the maximum score. Hint: Match the value D66 in the array D64:F64 using exact
52 (g) Using INDEX Function, write a formula in cell range D68 to display the vendor. Hint: INDEX the value of cell D67 in the array D55:F55.
53
54
55
56
57
58
59
60
61
62
63
64
Cost Savings
Security
Customer Support
Customizability
Weight
Weighted Score
12.0%
10.0%
8.0%
30.0%
20.0%
15.0%
5.0%
Maximum Score
Column Number of
Maximum Score
(using MATCH
Your
D
Exceeds Expectations
Recommendation
Table 4
Vendor 1
3
A
4
4
A
4
3
A
4
4
3.68
3.68
E
1
Vendor 2
4
3
1
2
4
2
2
F
2.66
Vendor 3
3
3
4
4
3
3
3
G
3.38
H
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,
600
9
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
8 recommended, else DaaS should be recommended.
10
11
12
13
14
15
16
17
18
19
0 0 0 22
20
21
B
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
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
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 2 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY