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...
-
Refer to the previous exercise. The output shows some results of using software to analyze the data with a significance test. Paired T for BeforeAfter T-Test of mean difference = 0 (vs not = 0):...
-
Using your college, university, or an organization your team is familiar with, create a mind map of a SWOT analysis, including at least three branches under each category. Also, add sub-branches with...
-
What mechanisms are available to help provide stakeholders with an assurance that a company complies with environmental regulations?
-
A 5.00-wt% aqueous sulfuric acid solution (p = 1.03g/mL) flows through a 45-m long pipe with a 6.0cm diameter at a rate of 87L/min. (a) What is the morality of sulfuric acid in the solution? (b) How...
-
Giblin's Goodies pays employees weekly on Fridays. However, the company notices that March 31 is a Wednesday, and the pay period will end on April 2. The payroll data for March 29-31 is as follows:...
-
AT&T plans to sell the new iPhone for $200. The lower-priced phone would give AT&T an attractive weapon to win new subscribers. AT&Ts revenue is an average of $95 a month from each iPhone customer,...
-
The OrangeBeer brewery is in the process of expanding its production division, so it will integrate new branches, in order to increase its production capacity. However, there is a problem that...
-
What is the role of a corporations auditor? To whom is the auditors duty owed?
-
On what grounds is a business justified in dismissing its employees without notice?
-
In what circumstances should a business owner require a confidentiality agreement?
-
What are a corporations documents of record?
-
Describe some of the main elements in a collective agreement.
-
Beginning Retained Earnings are $40,000 sales are $53,800 expenses are $44,000 and dividends paid are $2,900. How much is the net income or loss for the company?
-
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
-
A centrifugal pump impeller having dimensions and angles as shown rotates at \(500 \mathrm{rpm}\). Assuming a radial direction of velocity at the blade entrance, calculate the flow rate, the pressure...
-
Data measured during tests of a centrifugal pump driven at \(3000 \mathrm{rpm}\) are The flow rate is \(65 \mathrm{gpm}\) and the torque applied to the pump shaft is \(4.75 \mathrm{lbf} \cdot...
-
A centrifugal pump impeller having \(r_{1}=50 \mathrm{~mm}\), \(r_{2}=150 \mathrm{~mm}\), and width \(b=3.75 \mathrm{~mm}\) is to pump \(225 \mathrm{~L} / \mathrm{s}\) of water and supply \(12.2...
Study smarter with the SolutionInn App