Find the excel formula for Rate per Hour after discount and Total costRefer to the screenshots atttached below thank you ABCDEFGHJK1 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.2 Hence, there is a termination risk in using spot servers. However, on-demand servers can't be terminated by the provider.3 The servers are available in different sizes, but the firm rented only Small, Medium, and Large servers.4Table 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 F41.(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.67(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.89 (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 J24 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 J41.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.15161718192021Server Size1 Small2 Medium3 LargeTable 8On-DemandInstanceHourly Rate$0.33280$0.66560$1.33120Discount for SpotServers20%30%40%Table 9MAverage HoursRentedAverage TotalCostNOP 202122232425252262727552820292030→3125322733→34S35→36-37חר383910404142A3 LargeServerIDServer Size1 Medium2 Large3 Large4 Largelieme5 Largepres6 Large7 Small8 Smallallema9 LargeBTO10 Medium11 Largeatomen12 Small13 Small14 Small15 Medium16 Large17 Medium18 Largeс$1.33120Server TypeSpotSpotOn-DemandSpotKSpotOn-DemandOn-DemandteSpotSpotKOn-DemandtooOn-DemandteSpotSpotOn-DemandSpotOn-DemandSpotOn-DemandD40%RentedDate & Time11/25/2020 2:0011/25/2020 9:0011/25/2020 17:0011/25/2020 21:0011/26/2030.00011/26/2020 9:0011/26/2020 11:0011/25/2000-16.0011/26/2020 16:0044/6/2000 53.0011/26/2020 23:0044/32/2000 4.011/27/2020 1:0024/03/1630-23.011/27/2020 23:0044/20/2020 4.11/28/2020 1:0044/50/2000 511/28/2020 2:00*4/20/2020 2.0011/28/2020 3:0011/29/2020.0-0011/28/2020 9:0011/28/2020 11:0011/28/2020 16:0011/28/2020 16:0011/28/2020 16:00EReturnedDate & Time11/26/2020 9:0011/27/2020 1:0011/30/2020 13:004/20/2020 12-0011/30/2020 13:0044/20/2020 13.0011/30/2020 13:0011/30/2020 13:0011/20/2020 12:0011/30/2020 13:0011/20/2020 12:0011/30/2020 13:0011/20/2020 12:0011/30/2020 13:0044/20/2020 42.0011/30/2020 13:0044/20/2020 45.0011/30/2020 13:0044/50/5000 45.0011/30/2020 13:0044/20/2000 45.0011/30/2020 13:001/20/2020 12.0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:00F# of hoursRentedTable 10D8631 S 0.6656040 $ 1.33120116 $ 1.33120112 #N/A100 #N/A98 Spot27932484C62GRate perhour#N/A#N/AOn-Demand#N/ACO60 SpotFO59 On-Demand58 On-Demand52 Spot5050 On-Demand45 On-Demand4545 #N/A45#N/AHPercentDiscount30%40%0%#N/A#N/A0%0%#N/A4416071%#N/A0%0%4416167%4416167%0%4416296%0%0%IDiscountAmountJRate per hourafter discountKTotalCostIs number of hoursrented more thanaverage?MIs cost morethan theaveragecost?NO

Answered: Find the excel formula for Rate per…

Find the excel formula for Rate per Hour after discount and Total cost Refer to the screenshots atttached below 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

See similar textbooks

Related questions

Q: As a scholar of HCI(Human Computer Interaction), make a suggestion and stand strongly by your…

A: HCI (Human-Computer Interaction) is the study of how humans interact with computers and the extent…

Q: Match each scan type with its characteristic. Ping ◆ Connect SYN ◆ FIN A. Will be detected B. ICMP…

A: According to the information given:- We have to match the following and choose the correct option in…

Q: Consider inserting the keys 10, 22, 31, 4, 15, 28, 17, 88, and 59 into a hash table of length m = 11…

A: Linear Probing In computer programming, a technique known as linear probing is used to resolve…

Q: Question 4 For every integer k ≥1, construct a triangle-free graph Gk with χ(G) ≥k Full explain…

A: The question has been answered in step2

Q: Explain characterized features of patterns and pattern languages.

Q: List and briefly define categories of security mechanisms.

Q: Count Dracula buys blood from tha public (AIDS tested, of course). But since he prefers certain…

A: Use of Java: Java is used by developers to create applications for laptops, data centers,…

Q: we want to map out a garden in a coordinate plane using integers. O will represent an empty space…

A: Introduction Arrays In Java: A collection of variables with similar types that are referred to as an…

Q: Create a new database (named MyUniversity) Student (sid: integer, sname: string(100 chars), GPA:…

A: (a) Creating 6 different courses: INSERT INTO Course VALUES (501, 'OS', 100) INSERT INTO Course…

Q: S assembly program (F t and submit a .asm file

A: Given :- In the above given question, the statement is mention in the above given question Need…

Q: Comment on scaling parallel merge sort.

A: Merge sort:- One of the most effective sorting algorithms is merge sort. Its foundation is the…

Q: Please fill in the blanks. Programing language is C. /*For simplicity, this program will get the…

A: The complete C program is given below:

Q: To ensure employee productivity and security, the organization has decided to implement desktop…

A: The excel formula is given in the below step

Q: How to solve these 3 questions using MATLAB A) x-14=-2y-3z B) 40-4x=6y+8z C) x+30+7z-28=0

A: The complete answer in MATLAB is below:

Q: STUDENT Start Fills the registration/information form Fills the login username and password Confirm…

A: The question has been answered in step2

Q: Write an assembly program (Data and Code) that uses loop to read 10 numbers and output the largest…

A: Answer is given below

Q: loop to read 10 numbers and output the largest of those two numbers, you can assume any length for…

Q: The function below is supposed to replicate the lower() string method (that is, it converts all…

A: chr function returns the character corresponding to a Unicode code integer. Thus, the input to chr…

Q: Perform the following tasks on your lab machine: 1. Create a list with the following numbers…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub- parts for…

Q: (e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38.…

A: (e) Formula to enter the cell E37: =SUM(C37,D37) Explanation: The formula does the sum of the mobile…

Q: (c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell…

A: The complete answer is excel is below:

Q: multiply in binary: 11011 x 1011

A: ANSWER:-

Q: Work out the following without using a calculator 11101010(two) +2122(eight) + ABC (Hex) -…

A: Disclaimer: “Since you have asked multiple questions, we will solve the first question for you. If…

Q: Find the Big-Oh for each of the following programs. B.1 sum = 0; for(i = 0; i < n; i++)…

A: The question is to find the Big Oh for the given programs.

Q: Question 3 Please help with a Koltin-based Countdown Timer -Entity Relationship Diagram 1.…

A: An entity relationship diagram (ERD), also known as an entity-relationship model, is a graphical…

Q: Explain data structure of big data.

Q: Why are abstraction and composition part of good software design? A. By putting duplicated code to…

A: Answer:

Q: Explain any two applications of NLP

Q: Consider the following relational schema: Student (sid, sname, dept) Enroll (cid, sid, grade,…

A: The question is to write relational algebra for the given queries.

Q: dont need to use : #include what is an alternative, I only know basic C++ not that

A: Please find the answer below :

Q: Who are the stakeholders? Explain its types. Classify the stakeholders of an airline booking system,

A: Any individual, entity or party with an interest in a business and the results of its operations is…

Q: Explain in detail what is problem Decomposition.

A: Introduction: Problem decomposition: Breaks/divides problems into smaller parts/subproblems Helps…

Q: Explain Interviews and questionnaires of query techniques.

Q: How does the dynamic recursive traversal disassembly algorithm operate? Describe a simple method…

A: Dynamic Recursive Algorithm:- In dynamic programming, a recursive function is optimized by storing…

Q: (f) Write a formula in cell K24 to compute the Total cost for the given server. Total Cost = Rate…

A: Given question: (f). Write a formula in cell K24 to compute the Total cost for the given server.…

Q: Recursion Trees Use the recursion tree method to determine the asymptotic upper bound of T(n).…

A: The subproblem size for a node at depth i is n − i. Thus, the tree has n+1 levels (i=0,1,2,…,n) and…

Q: Add the answer to the parts that say #TODO ..... . this is in yaml!

A: Coded in YAML.

Q: Explain in detail what is problem Decomposition

Q: Q)What is the class relationship that best describes Car and Driver? Group of answer choices a)Car…

A: Association A relationship between two different classes that is established through their objects…

Q: 1. What are the command(s) to • Assign the variable t the value of 20. • Next, assign the variable…

A: Disclaimer: Since you have asked multiple questions, we will solve the first question for you. If…

Q: _______________ involves providing feedback regarding a potential data problem and enables users to…

A: Data correction : There are a few different types of data correction that can be performed on data…

Q: 1. Provide an algebraic expression, in terms of n, for the size of the phenotypic search space (the…

A: According to bartleby guidelines we are supposed to answer only 1 question or 3 subparts of the same…

Q: Hint: ▪ The group will be a single character (uppercase or lowercase) Your output should be of type…

A: Answer: We have done code in MATLAB with the output

Q: Complexity of Sorting Algorithms Sort a number of n integers. The value of the integers ranges from…

A: 1. Insertion Sort: Worst case time complexity of insertion Sort is O(n^2), this can be possible when…

Q: What are step words? Explain stemming with e.q.

Q: Here we explain applications of Hadoop.

A: For storing data and running applications on clusters of affordable hardware, Hadoop is an…

Q: Show how quicksort can be made to run in O(nlogn) time in the worst case. Assume the input array is…

A: QuickSort Sorting is the systematic arrangement of objects. The popular sorting algorithm known as…

Q: All vehicles used for transportation in the U.S. must have identification, which varies according to…

A: Complete the code below: /** represents a vehicle. */ public class Auto extends Vehicle{ private…

Q: Write a webpage that will do the following: Prompt the user to provide their course code and the…

A: Solution:

Q: Consider the following database scheme Employee (SSN, fname, Iname, salary, deptno)/ Department…

A: Employee salary (Emp Salary) has an impact on the overall department salary. First, let me tell you…

Question

Find the excel formula for Rate per Hour after discount and Total cost

Refer to the screenshots atttached below thank you

A
B
C
D
E
F
G
H
J
K
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.
2 Hence, there is a termination risk in using spot servers. However, on-demand servers can't be terminated by the provider.
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 F41.
(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
9 (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 J24 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 J41.
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
16
17
18
19
20
21
Server Size
1 Small
2 Medium
3 Large
Table 8
On-Demand
Instance
Hourly Rate
$0.33280
$0.66560
$1.33120
Discount for Spot
Servers
20%
30%
40%
Table 9
M
Average Hours
Rented
Average Total
Cost
N
O
P

20
21
22
23
24
25
25
2
26
27
27
55
28
20
29
20
30
→
31
25
32
27
33
→
34
S
35
→
36
-
37
חר
38
39
10
40
41
42
A
3 Large
Server
ID
Server Size
1 Medium
2 Large
3 Large
4 Large
lieme
5 Large
pres
6 Large
7 Small
8 Small
allema
9 Large
B
TO
10 Medium
11 Large
atomen
12 Small
13 Small
14 Small
15 Medium
16 Large
17 Medium
18 Large
с
$1.33120
Server Type
Spot
Spot
On-Demand
Spot
K
Spot
On-Demand
On-Demand
te
Spot
Spot
K
On-Demand
too
On-Demand
te
Spot
Spot
On-Demand
Spot
On-Demand
Spot
On-Demand
D
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/2030.000
11/26/2020 9:00
11/26/2020 11:00
11/25/2000-16.00
11/26/2020 16:00
44/6/2000 53.00
11/26/2020 23:00
44/32/2000 4.0
11/27/2020 1:00
24/03/1630-23.0
11/27/2020 23:00
44/20/2020 4.
11/28/2020 1:00
44/50/2000 5
11/28/2020 2:00
*4/20/2020 2.00
11/28/2020 3:00
11/29/2020.0-00
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
4/20/2020 12-00
11/30/2020 13:00
44/20/2020 13.00
11/30/2020 13:00
11/30/2020 13:00
11/20/2020 12:00
11/30/2020 13:00
11/20/2020 12:00
11/30/2020 13:00
11/20/2020 12:00
11/30/2020 13:00
44/20/2020 42.00
11/30/2020 13:00
44/20/2020 45.00
11/30/2020 13:00
44/50/5000 45.00
11/30/2020 13:00
44/20/2000 45.00
11/30/2020 13:00
1/20/2020 12.00
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
D
86
31 S 0.66560
40 $ 1.33120
116 $ 1.33120
112 #N/A
100 #N/A
98 Spot
27
93
24
84
C
62
G
Rate per
hour
#N/A
#N/A
On-Demand
#N/A
CO
60 Spot
FO
59 On-Demand
58 On-Demand
52 Spot
50
50 On-Demand
45 On-Demand
45
45 #N/A
45
#N/A
H
Percent
Discount
30%
40%
0%
#N/A
#N/A
0%
0%
#N/A
4416071%
#N/A
0%
0%
4416167%
4416167%
0%
4416296%
0%
0%
I
Discount
Amount
J
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
O

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

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.