090 COM Lucy Formatting - Table Clipboard Font Alignment Number 19 Styles G24 fo . D E G H K B C F 1 2020 cyber week (during the thanksgiving period) saw a spike in e-commerce sales throughout the USA, A2Z eCommerz ulc website and app also witnessed a surge in traffic During the cyber week, the IT team rented some temporary servers. Two types of servers were rented, () On-demand servers and () Spot servers. Spot servers are idle servers in the cloud service provider's inventory, and they come at a discounted rate. However, you can not use spot servers for the long term because when the provider's idle server inventory reduces, some of the spot servers may be terminated. Hence, there is a termination risk in using spot servers. However, on-demand servers can't be terminated by the provider. 2 3 The servers are available in different sizes, but the firm rented only Small, Medium, and Large servers. 4 Table 8 has the pricing and spot server discounts for the servers of various sizes. Table 10 has details on the servers which the firm rented. 5 () Write a formula in cell F24 to compute the # of hours the firm rented the server. The number of hours rented = (Returned Date & Time - Rented Date and Time) * 24. Copy the formula to F25 to F41 6. (b) Using VLOOKUP, write a formula in cell G24 to find the rate per hour from Table 8 for the given server size. Copy the formula to G25 to G41. 7 (c) Using IF and VLOOKUP functions, write a formula in cell H24 to find the spot server's discount rate. For on-demand servers, the discount rate is 0%. Copy the formula to H25 to H41. 8 (d) Write a formula in cell 124 to compute the discount amount on the server. Discount Amount = Percent Discount Rate per hour. Copy the formula to 125 to 141. 9 (e) Write a formula in cell 124 to compute the rate per hour after the discount. Rate per hour after discount=Rate per hour - Discount Amount. Copy the formula from J25 to $41. 10 (1) Write a formula in cell K24 to compute the Total cost for the given server. Total Cost = Rate per hour after discount * # of hours Rented. Copy the formula from k25 to K4L. 11 (8) Write a formula in cell G17 to compute the average hours Rented Average hours rented is the average of the # of hours Rented (F24:F41). 12 (h) Write a formula in cell G18 to calculate the average total cost. The average total cost is the average of the total cost (K24:K41). 13 () Using the IF function, write a formula in cell L24 to determine if the number of hours rented for the given server is more than the average. Copy the formula from K25 25 to K41. 14 ) Using the IF function, write a formula in cell M24 to determine if the number of hours rented for the given server is more than the average. Copy the formula to M25 to M41. 15 Table - 16 16 Table 9 Server Size Table 8 On-Demand Instance Hourly Rate Discount for Spot Servers 17 Average Hours Rented Average Total Cost 1 Small 2 Medium 18 19 20 21 22 $0.33280 $0.66560 $1.33120 3 Large 20% 30% 40% % Table 10 Percent Discount Discount Amount Rate per hour after discount Total Cost Is number of hours rented more than average? is cost mor than the average cost? 2 5 Large Server Server Size Rented Server Type Returned # of hours Rate per ID Date & Time Date & Time Rented hour 23 24 1 Medium Spot 11/25/2020 2:00 11/26/2020 9:00 31 25 2 Large Spot 11/25/2020 9:00 11/27/2020 1:00 40 26 3 Large On-Demand 11/25/2020 17:00 11/30/2020 13:00 116 27 4 Large Spot 11/25/2020 21:00 11/30/2020 13:00 112 28 Spot 11/26/2020 9:00 11/30/2020 13:00 1001 100 29 age 6 Large On-Demand 11/26/2020 11:00 11/30/2020 13:00 00 98 30 7 Small On-Demand 11/26/2020 16:00 11/30/2020 13:00 93 31 8 Small Spot 11/26/2020 23:00 3 11/30/2020 13:00 32 86 9 Large Spot 11/27/2020 1:00 11/30/2020 13:00 84 33 10 Medium On-Demand 11/27/2020 23:00 11/30/2020 13:00 62 34 11 Large On-Demand 11/28/2020 1:00 11/30/2020 13:00 60 35 12 Small Spot 11/28/2020 2:00 11/30/2020 13:00 59 36 13 Small Spot 11/28/2020 3:00 11/30/2020 13:00 58 37 14 Small On-Demand 11/28/2020 9:00 11/30/2020 13:00 52 38 15 Medium Spot 11/28/2020 11:00 11/30/2020 13:00 50 39 16 Large On-Demand 11/28/2020 16:00 11/20/2020 13:00 45 40 17 Medium Spot 11/28/2020 16:00 11/30/2020 13:00 45 41 18 Large On-Demand 11/28/2020 16:00 11/30/2020 13:00 45 42 43. You would like to present the server usage statistics to help create a server renting strategy for the future. 44 Table 11 has the statistics based on server Size, and Table 12 has Statistics based on Server Type and Server Size Instructions 01 Q2 Q3 QI-SampleAnswer Ready EF Type here to search O O DL 30% 40% % 0% 40% % 40% 0% 0% 20% 40% 0% 096 20% 20% 0% 30% 0% 30% 0% * SAMSUNG 090 COM Lucy Formatting - Table Clipboard Font Alignment Number 19 Styles G24 fo . D E G H K B C F 1 2020 cyber week (during the thanksgiving period) saw a spike in e-commerce sales throughout the USA, A2Z eCommerz ulc website and app also witnessed a surge in traffic During the cyber week, the IT team rented some temporary servers. Two types of servers were rented, () On-demand servers and () Spot servers. Spot servers are idle servers in the cloud service provider's inventory, and they come at a discounted rate. However, you can not use spot servers for the long term because when the provider's idle server inventory reduces, some of the spot servers may be terminated. Hence, there is a termination risk in using spot servers. However, on-demand servers can't be terminated by the provider. 2 3 The servers are available in different sizes, but the firm rented only Small, Medium, and Large servers. 4 Table 8 has the pricing and spot server discounts for the servers of various sizes. Table 10 has details on the servers which the firm rented. 5 () Write a formula in cell F24 to compute the # of hours the firm rented the server. The number of hours rented = (Returned Date & Time - Rented Date and Time) * 24. Copy the formula to F25 to F41 6. (b) Using VLOOKUP, write a formula in cell G24 to find the rate per hour from Table 8 for the given server size. Copy the formula to G25 to G41. 7 (c) Using IF and VLOOKUP functions, write a formula in cell H24 to find the spot server's discount rate. For on-demand servers, the discount rate is 0%. Copy the formula to H25 to H41. 8 (d) Write a formula in cell 124 to compute the discount amount on the server. Discount Amount = Percent Discount Rate per hour. Copy the formula to 125 to 141. 9 (e) Write a formula in cell 124 to compute the rate per hour after the discount. Rate per hour after discount=Rate per hour - Discount Amount. Copy the formula from J25 to $41. 10 (1) Write a formula in cell K24 to compute the Total cost for the given server. Total Cost = Rate per hour after discount * # of hours Rented. Copy the formula from k25 to K4L. 11 (8) Write a formula in cell G17 to compute the average hours Rented Average hours rented is the average of the # of hours Rented (F24:F41). 12 (h) Write a formula in cell G18 to calculate the average total cost. The average total cost is the average of the total cost (K24:K41). 13 () Using the IF function, write a formula in cell L24 to determine if the number of hours rented for the given server is more than the average. Copy the formula from K25 25 to K41. 14 ) Using the IF function, write a formula in cell M24 to determine if the number of hours rented for the given server is more than the average. Copy the formula to M25 to M41. 15 Table - 16 16 Table 9 Server Size Table 8 On-Demand Instance Hourly Rate Discount for Spot Servers 17 Average Hours Rented Average Total Cost 1 Small 2 Medium 18 19 20 21 22 $0.33280 $0.66560 $1.33120 3 Large 20% 30% 40% % Table 10 Percent Discount Discount Amount Rate per hour after discount Total Cost Is number of hours rented more than average? is cost mor than the average cost? 2 5 Large Server Server Size Rented Server Type Returned # of hours Rate per ID Date & Time Date & Time Rented hour 23 24 1 Medium Spot 11/25/2020 2:00 11/26/2020 9:00 31 25 2 Large Spot 11/25/2020 9:00 11/27/2020 1:00 40 26 3 Large On-Demand 11/25/2020 17:00 11/30/2020 13:00 116 27 4 Large Spot 11/25/2020 21:00 11/30/2020 13:00 112 28 Spot 11/26/2020 9:00 11/30/2020 13:00 1001 100 29 age 6 Large On-Demand 11/26/2020 11:00 11/30/2020 13:00 00 98 30 7 Small On-Demand 11/26/2020 16:00 11/30/2020 13:00 93 31 8 Small Spot 11/26/2020 23:00 3 11/30/2020 13:00 32 86 9 Large Spot 11/27/2020 1:00 11/30/2020 13:00 84 33 10 Medium On-Demand 11/27/2020 23:00 11/30/2020 13:00 62 34 11 Large On-Demand 11/28/2020 1:00 11/30/2020 13:00 60 35 12 Small Spot 11/28/2020 2:00 11/30/2020 13:00 59 36 13 Small Spot 11/28/2020 3:00 11/30/2020 13:00 58 37 14 Small On-Demand 11/28/2020 9:00 11/30/2020 13:00 52 38 15 Medium Spot 11/28/2020 11:00 11/30/2020 13:00 50 39 16 Large On-Demand 11/28/2020 16:00 11/20/2020 13:00 45 40 17 Medium Spot 11/28/2020 16:00 11/30/2020 13:00 45 41 18 Large On-Demand 11/28/2020 16:00 11/30/2020 13:00 45 42 43. You would like to present the server usage statistics to help create a server renting strategy for the future. 44 Table 11 has the statistics based on server Size, and Table 12 has Statistics based on Server Type and Server Size Instructions 01 Q2 Q3 QI-SampleAnswer Ready EF Type here to search O O DL 30% 40% % 0% 40% % 40% 0% 0% 20% 40% 0% 096 20% 20% 0% 30% 0% 30% 0% * SAMSUNG