(f) 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 K41. Screenshots attacched thank you

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

(f) 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 K41.

Screenshots attacched

thank

you

 

19
20
21
22
23
24
25
26
27
28
29
30
31
2
32
2
33
74
34
2
35
→
36
37
38
39
40
41
42
A
B
2 Medium
3 Large
Server
ID
Server Size
1 Medium
2 Large
3 Large
4 Large
5 Large
Large
6 Large
fa
7 Small
femm
8 Small
eman
9 Large
come
10 Medium
com
11 Large
years
12 Small
13 Small
14 Small
15 Medium
16 Large
17 Medium
18 Large
Spot
Spot
Server Type
On-Demand
Spot
Spot
B
B
On-Demand
On-Demand
с
$0.66560
$1.33120
Spot
Spot
B
On-Demand
On-Demand
-
E
Spot
p
Spot
On-Demand
Spot
On-Demand
Spot
On-Demand
D
30%
40%
Rented
Date & Time
11/25/2020 2:00
11/25/2020 9:00
11/25/2020 17:00
11/25/2020 21:00
11/26/2020 9:00
11/26/2020 11:00
wwwwwwwww
11/26/2020 16:00
ninas n
11/26/2020 23:00
.
11/27/2020 1:00
VENEVEN
11/27/2020 23:00
11/28/2020 1:00
**/60/EVEN
11/28/2020 2:00
11/28/2020 3:00
in
11/28/2020 9:00
11/28/2020 11:00
11/28/2020 16:00
11/28/2020 16:00
11/28/2020 16:00
E
Returned
Date & Time
11/26/2020 9:00
11/27/2020 1:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
**YOUT EVEN A
11/30/2020 13:00
11/30/2020 13:00
**/09/even
11/30/2020 13:00
11/30/2020 13:00
you/even
11/30/2020 13:00
44/00/000
11/30/2020 13:00
**//****
11/30/2020 13:00
*******
11/30/2020 13:00
inginan a
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
F
# of hours
Rented
Table 10
31
40
116
112
100
98
=
93
=
86
7
84
=
62
=
60
FA
59
FA
58
=
52
=
50
45
45
45
G
Rate per
hour
H
Percent
Discount
Discount
Amount
Rate per hour
after discount
K
Total
Cost
Is number of hours
rented more than
average?
M
Is cost more
than the
average
cost?
N
P
Q
Transcribed Image Text:19 20 21 22 23 24 25 26 27 28 29 30 31 2 32 2 33 74 34 2 35 → 36 37 38 39 40 41 42 A B 2 Medium 3 Large Server ID Server Size 1 Medium 2 Large 3 Large 4 Large 5 Large Large 6 Large fa 7 Small femm 8 Small eman 9 Large come 10 Medium com 11 Large years 12 Small 13 Small 14 Small 15 Medium 16 Large 17 Medium 18 Large Spot Spot Server Type On-Demand Spot Spot B B On-Demand On-Demand с $0.66560 $1.33120 Spot Spot B On-Demand On-Demand - E Spot p Spot On-Demand Spot On-Demand Spot On-Demand D 30% 40% Rented Date & Time 11/25/2020 2:00 11/25/2020 9:00 11/25/2020 17:00 11/25/2020 21:00 11/26/2020 9:00 11/26/2020 11:00 wwwwwwwww 11/26/2020 16:00 ninas n 11/26/2020 23:00 . 11/27/2020 1:00 VENEVEN 11/27/2020 23:00 11/28/2020 1:00 **/60/EVEN 11/28/2020 2:00 11/28/2020 3:00 in 11/28/2020 9:00 11/28/2020 11:00 11/28/2020 16:00 11/28/2020 16:00 11/28/2020 16:00 E Returned Date & Time 11/26/2020 9:00 11/27/2020 1:00 11/30/2020 13:00 11/30/2020 13:00 11/30/2020 13:00 **YOUT EVEN A 11/30/2020 13:00 11/30/2020 13:00 **/09/even 11/30/2020 13:00 11/30/2020 13:00 you/even 11/30/2020 13:00 44/00/000 11/30/2020 13:00 **//**** 11/30/2020 13:00 ******* 11/30/2020 13:00 inginan a 11/30/2020 13:00 11/30/2020 13:00 11/30/2020 13:00 11/30/2020 13:00 11/30/2020 13:00 F # of hours Rented Table 10 31 40 116 112 100 98 = 93 = 86 7 84 = 62 = 60 FA 59 FA 58 = 52 = 50 45 45 45 G Rate per hour H Percent Discount Discount Amount Rate per hour after discount K Total Cost Is number of hours rented more than average? M Is cost more than the average cost? N P Q
A
B
с
D
E
F
G
H
I
J
L
1 2020 cyber week (during the thanksgiving period) saw a spike in e-commerce sales throughout the USA. A2Z eCommerz LLC 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, (i) On-demand servers and (ii) 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.
K
M
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
(a) 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
(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.
6
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 120hour after the discount Date or discount = Rate per hour - Discount Amount. Copy the formula from J25 to J41.
compute the rate per hour after the discount. Rate per hour after
MAN
10 (f) 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 K41.
11 (g) 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 (i) 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 to K41.
14 (j) 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
Transcribed Image Text:A B с D E F G H I J L 1 2020 cyber week (during the thanksgiving period) saw a spike in e-commerce sales throughout the USA. A2Z eCommerz LLC 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, (i) On-demand servers and (ii) 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. K M 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 (a) 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 (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. 6 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 120hour after the discount Date or discount = Rate per hour - Discount Amount. Copy the formula from J25 to J41. compute the rate per hour after the discount. Rate per hour after MAN 10 (f) 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 K41. 11 (g) 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 (i) 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 to K41. 14 (j) 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
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Public key encryption
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 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