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...
-
At the beginning of year 1, you have $10,000. Investments A and B are available; their cash flows are shown in the file S14_84.xlsx. Assume that any money not invested in A or B earns interest at an...
-
Folk Landscaping is evaluating an offer to purchase Bruce Lawn Care, its main competitor, for \($250,000.00.\) An accountant has projected that the purchase will increase Folks annual net cash flow...
-
The present values of cash flows for projects, each of which has an initial capital outlay of $350,000, are The cash value added (or profitability index) for each project suggests that the preferred...
-
A manufacturing company has developed a fuel efficient machine for cleaning carpet because it delivers carpet cleaner so rapidly. Of interest is a random variable Y, the amount in gallons per minute...
-
When testing a new treatment, what is the difference between statistical significance and practical significance? Can a treatment have statistical significance, but not practical significance? Choose...
-
Create an employee earnings record for a new employee. 1. Patrick Workman (SSN 123-45-6789) begins working for Fishing Experts Co, on Monday, 6/18/2018. He lives at 817 Remote Lane, Bentonville, AR...
-
Find the mode(s) for the set of numbers. 591,425,116,116,861116,677 If there is more than one mode, separate them with commas. If there is no mode, select "None". Mode(s)
-
While living on the streets, Sonia is introduced to drugs and alcohol by a group of friends she associated with. Sonia's habit of 'collecting' small things turns into collecting larger items that she...
-
Question 3.(a)(5 marks) Suppose 2 < f'(x) <4 for all values of x. Prove that 4
-
Find a current terrorism related news article (written preferred) or news story. Summarize in no more than ONE page, the sum and substance of the article and how it applies to some of the lessons and...
-
The Harrison family recently purchases a home for $2.3 million.The paid $250,000 down at signing and decided to pay the balance over the next 15 years in equal payments plus 4.5% interest on the...
-
21. A ball is thrown downward from a height of 256 feet with a velocity of 60 feet per second. How long will it take for the ball to reach the ground? 22. A rock was dropped from a cliff (the cliff...
-
Churyk Company manufactures equipment. Churyk has the following arrangement with Kay Inc. Kay purchases equipment from Churyk for a price of $1,000,000 and contracts with Churyk to install 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
-
EEG Ince. is a decentralized organization with four autonomous divisions. The divisions are evaluated on the basis of the change in their return on invested assets. Operating results in the...
-
The Willowbrook Community Bank recently decided to adopt a balanced scorecard system of performance evaluation. Below is a list of primary performance goals for four major performance categories that...
-
Washington State Products has several manufacturing divisions. The Seattle Division produces a component part that is used in the manufacture of electronic equipment. The cost per part for July is as...
Study smarter with the SolutionInn App