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: Create data base 4 table about Oscar Award : 1-actor 2-actress 3-movie 4-Nominations

A: Here are the tables regarding Oscar:

Q: Entering a formula in excel. Enter a formula in Cell E4 to calculate how long each item has been on…

A: = YEARFRAC($D$4,$C$20): calculates the difference between two dates in years further, if you want to…

Q: nction should be utilized if one desires to highlight the sales reps that do not met their goals?…

A: Q What Excel function should be utilized if one desires to highlight the sales reps that do not met…

Q: Create your own format of the market list to include, name of items or supplies that are used…

A: import java.util.ArrayList; import java.util.List; import java.util.Scanner; class Product { //…

Q: Considering the above table, what appropriate Excel function to use in finding the the difference,…

A: In this question we have to find the differences in days, between the closing date and the release…

Q: Assignment: - Here is the Salesforce scenrio please explain in breif what is the differece between…

A: Required:

Q: Set up Excel Quick Tip 5-3 in Excel.

A: The volume of a cylindrical object (like a round column) is calculated using the formula: . In this…

Q: Create an organisational chart with at least 15 employees. The chart should display at least 4…

Q: Create, print, and export to Excel a Profit and Loss report for January 2024. Customize this report…

A: The objective of the question is to create a Profit and Loss report for January 2024, add a column…

Q: Display the lowest rate for each RType having more than 10 minimum rate in the ROOMS table.

A: SQL (Structured Query Language) is a standard programming language that used to manage relational…

Q: If you wish to run more than two conditions in a single Excel run, what filter will you use?

A: The correct answer is

Q: MS EXCEL Topic - Theory, basics Give a very simple explanation on how to do these things in MS…

A: MS Excel 2013 version is used here to illustrate the above-mentioned things. The following step…

Q: Create a view named 'EmployeeReport' that contains the employee name, employee surname and the total…

A: SOLUTION : To create the view of surname, name, and total days work let us take the employee table…

Q: Display product ID, product name, and category ID for products of the category(s) that the lowest…

A: In programming a domain specific language is used, which is called SQL or standard query language.…

Q: No written by hand solution What is the main difference between a PowerPoint key points slide and…

A: Introduction: PowerPoint is a popular presentation software that enables users to create slideshows…

Q: Your Name UMC Theaters Ticket Sales Theater Cocoplace Sunset Walk October November December Totals…

A: In this the data is for comparison of theaters ticket sales per month. In this situation, we cannot…

Q: Task 7: List the square footage, owner number, owner last name, and owner first name for each…

A: Given: Task 7: List the square footage, owner number, owner last name, and owner first name for each…

Q: Please provide examples of 3 excel functions with formulas except addition, subtraction,…

A: In this question, we have to provide the three excel functions. Excel has many functions like COUNT,…

Q: Prepare a flowchart depicting the process of training report formatting using MSword.

A: Create Flowchart using MS Word: Create a new blank document in MSWord. Add shapes for flowchart…

Q: How do we determine which Microsoft Access table layout template to use?

A: When determining the most suitable Microsoft Access table layout template, it is important to…

Q: When the user selects a costume, the corresponding cost and a picture of the costume should be…

A: The updated code which will clear the prior price and picture when the user selects a different…

Q: Show how to create a view tot credits (year, num credits) that returns the total amount of credits…

A: -> Views are created using CREATE VIEW -> Perform natural join between TAKES AND COURSE table…

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.

Similar questions

Choose which tab in Excel these belongs. Page Home Insert Draw Formulas Data Review View Layout Draw with Touch Queries Scatter Print Area Merge & Center Clear Workbook Statistics Freeze Panes Pie Show Formulas
Excel VBA Please fill in the blanks using your understanding of VBA. there is not other msterials to go along with the problem. thank you
Which type of request where multiple vendors were asked to submit their proposal? RFP RFQ RFI The option is not available from the given choices.
Task 7 - Task 10 Task 7: List the square footage, owner number, owner last name, and owner first name for each property managed by the StayWell-Columbia City office. Task 8: Repeat Task 7, but this time include only those properties with three bedrooms. Task 9: List the office number, address, and monthly rent for properties whose owners live in Washington State or own two-bedroom properties. Task 10: List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two-bedroom property.
Enter the data provided below into Excel in a column (for example A1:A8). Copy the data and transpose it where the leftmost cell is H1. What is the value in L1? 10, 20, 41, 57, 33, 51, q53, 23
The following are excel sheets with column headings. Select all the themes that can be gleamed from the lists. Name of Spreadsheet: EQUIPMENT Column Headings: (Number, Description, AcquisitionDate, AcquisitionPrice) Name of Spreadsheet: COMPANY Column Headings: (Name, IndustryCode, Gross Sales, OfficerName, OfficerTitle) Select one or more: O a. COMPANY: Columns are CompanyID, CompanyName, CompanylndustryCode, CompanyGrossSales O b. SERVICE: Columns are ServicelD, Service Type, ServiceCharge, ServiceDate. O c. OFFICER Columns are OfficerlD, OfficerName, OfficerTitle O d. OWNER: Columns are OwnerlD, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail O e. EQUIPMENT: Columns are EquipmentNumber, EquipmentDescription, EquipmentAcquisitionDate, EquipmentPrice,
Excel Tables - Structured Reference What does the "@" symbol represent in a Structured Reference to an Excel table? OPTIONS: A reference to the header row of the table A reference to the entire table of data A reference to the current column of the table A reference to the current row of the table
Based on the ERD below, for each project calculate the difference between the project value and the project balance. Display the result in a new column name “Remaining Balance”. Include the project number and project name in the result output.
How to insert data in an existing column in excel
Using data as shown in Figure 3-3 you need to : 1)Key in data in Excel using formula according to the format above. 2)Calculate periodic payment for interest rate above. 3)The amount of RM must be in 2 decimal points. 4)Insert (name, matric number, section) on top (left side) of every worksheet. 5)Please rename and save your work as (matricnumber_LabSheet3_3).