In cell H6, enter a formula to determine any discount that should be applied. If the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In cell H6, enter a formula to determine any discount that should be applied. If the payment method was Express Miles or Rewards, the customer should receive the discount shown in B42. If no discount should be applied, the formula should return a zero. Use the named range for cell B42, not the cell address, in this formula. Copy the formula to the range H7:H32. In cell J6, enter a formula to determine the cost of gas if the customer chose that option as indicated in column I. If the customer did not choose the option, then the formula should return zero. Use the named range for cell B44 in this formula. Copy the formula to the range J7:J32. 7 In cell K6, enter a formula to determine the total cost of the rental based on the daily rate, the number of days rented, the cost of gas, and any discount given to the customer. Note that the discount applies only to K7:K32. 8. car rental, not the cost of gas. Copy the formula to the range In cell B46, use the appropriate function to calculate the median length of rental in days. In cell B47, use the appropriate function to count the number of rentals in the data, using the data in column A. 10 th TE v fx H6 =IF(OR(F6="Express Miles",F6="Rewards"),$E$12,0) Date Returned/or Amount of S Auto Type 6 Green Collection Auto ld Date Rented Expected Return Days Rented Payment Method Daily Rate Discount Gas Option Cost of Gas Total Cost 988 4/5/17 4/5/17 4/8/17 Credit Card $49.99 S 7Compact/Midsize 8 Compact/Midsiae 275 4/10/17 4/10/17 COD $76.4 S $76.4S $49.9S S84.9S $104.99S $104 9S 277 4/9/17 4/5/17 Express Miles 3.00 9Green Coliection 10 Fulsize/Standard 11 SUV/Minivan 12 SUV/Minivan 13 Fulsian/Standard 14 Green Collection 15 Compact/Midsize 990 4/6/17 Credit Card 350 4/S/17 4/8/17 4/9/17 Credit Card S50 4//17 4. Rewards 3.00 551 4/7/17 4/7/17 4/10/17 Credit Card 352 4/9/17 2. Credit Card S89 4/6/17 4/9/17 Credit Card $49.99$ $76.4 S84 s SaS S84.95S 275 4/11/17 16 Fulsae/Standard 17 Fulsise/Standard 1Fulsiae/Standard 19 SUV/Minivan 4/18/17 4/16/17 4//17 4/11/17 355 4/9/17 Credit Card a56 4/6/17 Credit Card 350 4/5/17 Rewards 3.00 S53 4//17 4/14/17 4/17/17 Express Mies $104.9S 3.00 20 SUV/Minivan 21 Green Collection 22 Green Colection S50 4/11/17 4/9/17 COo $104.9S S88 4/15/17 4/16/17 4/10/17 Credit Card $49.99S $49.9S 4/10/17 Express Miles 3.00 23 Green Collection 24 Fullsian/Standard 25 SUV/Minivan 26 SUN /Minivan 27 Fulisian/Standard 25 Fulisiae/Standard 29 Compact/Midsiae 990 4/7/17 Credit Card 356 4/9/17 4/20/17 Rewards S84.9S $104.9S $104.95 3.00 S51 4/11/17 4/15/17 Express Miles 1.00 S54 4/17 2. Express Miles 3.00 352 4/20/27 4/11/17 Credit Card S84.9S 356 4/11/17 4/17/17 4/14/17 Express Miles 1.00 276 4/11/17 Credt Card 30 Compact/Midsian 21 SUV/Minivan 32 Green Callecion $76.4S S76.4S $10495 277 4/11/17 4/15/17 Aewards 4. 3.00 s54 4/20/17 14/11/17 4/22/17 Coo 990 4/18/17 Express Miles 3.00 33 34 35 36 Rental Rates 37 Green Colliection 38 Compac/Midsise 29 Fulisia/standard 40 SUN/Minivan S45.99 S7549 $30499 41 Diucount for Espress Miles or 42 Rewards 20% 44 Cost to Fil Tan 45 Medan Rental Lengsh 47 Number af Rentals 48 RentalData ClientData Average: $1.22 Count: 27 Sum: $33.00 曲 回 77% In cell H6, enter a formula to determine any discount that should be applied. If the payment method was Express Miles or Rewards, the customer should receive the discount shown in B42. If no discount should be applied, the formula should return a zero. Use the named range for cell B42, not the cell address, in this formula. Copy the formula to the range H7:H32. In cell J6, enter a formula to determine the cost of gas if the customer chose that option as indicated in column I. If the customer did not choose the option, then the formula should return zero. Use the named range for cell B44 in this formula. Copy the formula to the range J7:J32. 7 In cell K6, enter a formula to determine the total cost of the rental based on the daily rate, the number of days rented, the cost of gas, and any discount given to the customer. Note that the discount applies only to K7:K32. 8. car rental, not the cost of gas. Copy the formula to the range In cell B46, use the appropriate function to calculate the median length of rental in days. In cell B47, use the appropriate function to count the number of rentals in the data, using the data in column A. 10 th TE v fx H6 =IF(OR(F6="Express Miles",F6="Rewards"),$E$12,0) Date Returned/or Amount of S Auto Type 6 Green Collection Auto ld Date Rented Expected Return Days Rented Payment Method Daily Rate Discount Gas Option Cost of Gas Total Cost 988 4/5/17 4/5/17 4/8/17 Credit Card $49.99 S 7Compact/Midsize 8 Compact/Midsiae 275 4/10/17 4/10/17 COD $76.4 S $76.4S $49.9S S84.9S $104.99S $104 9S 277 4/9/17 4/5/17 Express Miles 3.00 9Green Coliection 10 Fulsize/Standard 11 SUV/Minivan 12 SUV/Minivan 13 Fulsian/Standard 14 Green Collection 15 Compact/Midsize 990 4/6/17 Credit Card 350 4/S/17 4/8/17 4/9/17 Credit Card S50 4//17 4. Rewards 3.00 551 4/7/17 4/7/17 4/10/17 Credit Card 352 4/9/17 2. Credit Card S89 4/6/17 4/9/17 Credit Card $49.99$ $76.4 S84 s SaS S84.95S 275 4/11/17 16 Fulsae/Standard 17 Fulsise/Standard 1Fulsiae/Standard 19 SUV/Minivan 4/18/17 4/16/17 4//17 4/11/17 355 4/9/17 Credit Card a56 4/6/17 Credit Card 350 4/5/17 Rewards 3.00 S53 4//17 4/14/17 4/17/17 Express Mies $104.9S 3.00 20 SUV/Minivan 21 Green Collection 22 Green Colection S50 4/11/17 4/9/17 COo $104.9S S88 4/15/17 4/16/17 4/10/17 Credit Card $49.99S $49.9S 4/10/17 Express Miles 3.00 23 Green Collection 24 Fullsian/Standard 25 SUV/Minivan 26 SUN /Minivan 27 Fulisian/Standard 25 Fulisiae/Standard 29 Compact/Midsiae 990 4/7/17 Credit Card 356 4/9/17 4/20/17 Rewards S84.9S $104.9S $104.95 3.00 S51 4/11/17 4/15/17 Express Miles 1.00 S54 4/17 2. Express Miles 3.00 352 4/20/27 4/11/17 Credit Card S84.9S 356 4/11/17 4/17/17 4/14/17 Express Miles 1.00 276 4/11/17 Credt Card 30 Compact/Midsian 21 SUV/Minivan 32 Green Callecion $76.4S S76.4S $10495 277 4/11/17 4/15/17 Aewards 4. 3.00 s54 4/20/17 14/11/17 4/22/17 Coo 990 4/18/17 Express Miles 3.00 33 34 35 36 Rental Rates 37 Green Colliection 38 Compac/Midsise 29 Fulisia/standard 40 SUN/Minivan S45.99 S7549 $30499 41 Diucount for Espress Miles or 42 Rewards 20% 44 Cost to Fil Tan 45 Medan Rental Lengsh 47 Number af Rentals 48 RentalData ClientData Average: $1.22 Count: 27 Sum: $33.00 曲 回 77%
Expert Answer:
Answer rating: 100% (QA)
In cell h6 enter a formula to determine any discount that should be applied if the payment method wa... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Determine the magnitude of the force F that should be applied at the end of the lever such that this force creates a clockwise moment M about point O. Given: M = 15 Nm φ = 60 deg θ = 30 deg...
-
Laboratory 7: List and String Review the related lecture note(s), and finish exercises below. 1. Write a Python program to create a list (named lab7.py): Create a list named myList and initialize it...
-
In cell C11 of Excel, enter a formula to reference the date stored in cell B7. Insert a nested function in cell C12 to calculate the date for the next payment. Nest the YEAR, MONTH, and DAY functions...
-
On March 31, 2019, the balances of the accounts appearing in the ledger of Racine Furnishings Company, a furniture wholesaler, are as follows: a. Prepare a multiple-step income statement for the year...
-
If the interest rate money can earn is revised upward, is todays economic value of a given stream of future payments higher or lower? Explain.
-
In a fashion similar to that in Figure, write a short program to determine the smallest number, xmin, used on the computer you will be employing along with this book. Note that your computer will be...
-
A significant issue when a contract is breached is whether the cause of action is strictly in breach of contract or may be expanded to negligence and strict liability. The significance comes into...
-
WORK SHEET, ADJUSTING ENTRIES, AND FINANCIAL STATEMENTS Herrera Company had the following trial balance columns on its work sheet: Data for adjusting the accounts are as follows: (a) Factory overhead...
-
While many parties were interested in acquiring MCI, the major players included Verizon and Qwest. U.S.-based Qwest is an integrated communications company that provides data, multimedia, and...
-
Determine the magnitude of the resultant force F R = F 1 + F 2 and its orientation , measured counterclockwise from the positive x axis. F = 260 lb 45 F=310 lb 12 5 13 y X
-
On August 1, 2021, Limbaugh Communications issued $24 million of 8% nonconvertible bonds at 105. The bonds are due on July 31, 2041. Each $1,000 bond was issued with 20 detachable stock warrants,...
-
1. Air flows through an adiabatic system. M downstream, M = 1.8 and p2 = 7.0 psia. 4.0 and poi (a) Are there losses in this system? If so, compute As. (b) Determine the ratio of A/A. = 45 psia. At a...
-
1/3 SS For the given vectors V and V2, determine V + V, V + V, V - V2, V X V2, V x V, and V V. Consider the vectors to be nondimensional. V = 15 4 3 y 30 V = 12 PROBLEM 1/3 --x ine th
-
Given that the breaking stress of the rope material consisting of "n" number of wires used on a ship is "omax (kg/cm)", the safety coefficient is "EKS", and the load it carries is "Psafe", what...
-
If the breaking strength of the bolt used on a ship is omax (kg/cm), the safety coefficient is "EKS" and the safe carrying force is "Psafe", what should be the diameter of the bolt that we want it to...
-
The height of the bolt head used on a ship is "h(cm)" and the safe tension of a bolt with a bolt diameter of "d(cm)" is Tsafe (kg/cm). Find the force (Psafe) that can be applied to the bolt....
-
A donor transfers $100,000 to a Charitable Remainder Unitrust scheduled to last for 10 years. It will pay equal shares to all 12 grandchildren of the donor for 10 years. However, if one of the...
-
d) For die casting processes: 1. What are the most common metals processed using die casting and discuss why other metals are not commonly die casted? 2. Which die casting machines usually have a...
-
Three torques act on the shaft. Determine the internal torque at points A, B, C, and D. Given: M1 = 300 N m M2 = 400 N m M3 = 200 N m M2 D. M3 ,
-
Determine the normal force shear force and moment at a section passing through point D of the two memberframe. 400 N/m 200 N/m 2.5 m 6m-
-
Determine the internal normal force, shear force, and moment at point C. Units Used: kip = 103 lb Given: a = 0.5 ft d = 8ft b = 2 ft e = 4 ft c = 3 ft w = 150lb/ft B
-
Use the numbers for the alcohol and tobacco category from the table in the Application "Goods with a Large Consumer Surplus Loss from Price Increases" to draw a figure that illustrates the roles that...
-
Change the answer given in the Challenge Solution for the short run rather than for the long run.
-
Are allocations \(a\) and \(g\) in Figure 10.4 part of the contract curve? Data From Figure 10.4:- 60 80 50 160 30 12. 20 20 Jane's wood 40 40 Denise's candy Od 20 Contract curve Denise's wood 20 218...
Study smarter with the SolutionInn App