Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Express Car Rental Rentals Initiated in Week Starting 4/5/2015 Created by Jason Easton Auto Type Auto Id Date Rented Date Returned/or Expected Return #Days Rented
Express Car Rental | |||||||||||
Rentals Initiated in Week Starting 4/5/2015 | |||||||||||
Created by Jason Easton | |||||||||||
Auto Type | Auto Id | Date Rented | Date Returned/or Expected Return | #Days Rented | Payment Method | Daily Rate | Amount of Discount | Gas Option | Cost of Gas | Total Cost | |
Green Collection | 988 | 4/5/2015 | 4/8/2015 | 3 | Credit Card | $49.99 | n | ||||
Compact/Midsize | 275 | 4/5/2015 | 4/10/2015 | 5 | COD | $76.49 | n | ||||
Compact/Midsize | 277 | 4/9/2015 | 4/10/2015 | 1 | Express Miles | $76.49 | n | ||||
Green Collection | 990 | 4/5/2015 | 4/6/2015 | 1 | Credit Card | $49.99 | n | ||||
Fullsize/Standard | 350 | 4/5/2015 | 4/8/2015 | 3 | Credit Card | $84.99 | y | ||||
SUV/Minivan | 550 | 4/5/2015 | 4/9/2015 | 4 | Rewards | $104.99 | y | ||||
SUV/Minivan | 551 | 4/7/2015 | 4/10/2015 | 3 | Credit Card | $104.99 | n | ||||
Fullsize/Standard | 352 | 4/7/2015 | 4/9/2015 | 2 | Credit Card | $84.99 | y | ||||
Green Collection | 989 | 4/6/2015 | 4/9/2015 | 3 | Credit Card | $49.99 | n | ||||
Compact/Midsize | 275 | 4/11/2015 | 4/18/2015 | 7 | COD | $76.49 | n | ||||
Fullsize/Standard | 355 | 4/9/2015 | 4/16/2015 | 7 | Credit Card | $84.99 | y | ||||
Fullsize/Standard | 356 | 4/6/2015 | 4/8/2015 | 2 | Credit Card | $84.99 | y | ||||
Fullsize/Standard | 350 | 4/9/2015 | 4/13/2015 | 4 | Rewards | $84.99 | y | ||||
SUV/Minivan | 553 | 4/8/2015 | 4/14/2015 | 6 | Express Miles | $104.99 | y | ||||
SUV/Minivan | 550 | 4/11/2015 | 4/17/2015 | 6 | COD | $104.99 | y | ||||
Green Collection | 988 | 4/9/2015 | 4/15/2015 | 6 | Credit Card | $49.99 | n | ||||
Green Collection | 989 | 4/10/2015 | 4/16/2015 | 6 | Express Miles | $49.99 | n | ||||
Green Collection | 990 | 4/7/2015 | 4/10/2015 | 3 | Credit Card | $49.99 | n | ||||
Fullsize/Standard | 356 | 4/9/2015 | 4/10/2015 | 1 | Rewards | $84.99 | n | ||||
SUV/Minivan | 551 | 4/11/2015 | 4/15/2015 | 4 | Express Miles | $104.99 | y | ||||
SUV/Minivan | 554 | 4/7/2015 | 4/9/2015 | 2 | Express Miles | $104.99 | y | ||||
Fullsize/Standard | 352 | 4/10/2015 | 4/11/2015 | 1 | Credit Card | $84.99 | y | ||||
Fullsize/Standard | 356 | 4/11/2015 | 4/17/2015 | 6 | Express Miles | $84.99 | y | ||||
Compact/Midsize | 276 | 4/11/2015 | 4/14/2015 | 3 | Credit Card | $76.49 | n | ||||
Compact/Midsize | 277 | 4/11/2015 | 4/15/2015 | 4 | Rewards | $76.49 | n | ||||
SUV/Minivan | 554 | 4/10/2015 | 4/12/2015 | 2 | COD | $104.99 | y | ||||
Green Collection | 990 | 4/11/2015 | 4/18/2015 | 7 | Express Miles | $49.99 | n | ||||
Rental Rates | |||||||||||
Green Collection | $49.99 | ||||||||||
Compact/Midsize | $76.49 | ||||||||||
Fullsize/Standard | $84.99 | ||||||||||
SUV/Minivan | $104.99 | ||||||||||
Discount for Express Miles or Rewards | 20% | ||||||||||
Cost to Fill Tank | $65.00 | ||||||||||
Median Rental Length | |||||||||||
Number of Rentals |
in cell h6, enter a formula to determine any discount that should be applied. if the payment method was express miles or reward, the customer should receive the discount shown in b24. if no discound should be applied, the formula should return a zero.
i could not understand how to put the formula????
Also, this part in cell j6, enter the correct formula to determine the cost of gas if the customer chose that option as indicated in colum i.
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started