Question
HI, I am sorry to post this Q again because I could not understand the formula. Also, the answer was different from the answer sheet
HI, I am sorry to post this Q again because I could not understand the formula. Also, the answer was different from the answer sheet that I should do this project on it.
this is the Q:
| 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. and the total cost of k6 the answer should be loke is the box down Amount of Discount | ||||||||||
| 0%,0%,20%,0%,0%,20%,0%,0%,0%,0%,0%,0% like this | ||||||||||
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
Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 2012 Proceedings Part 2 Lnai 7197
Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen
2012th Edition
3642284892, 978-3642284892
