| Express Car Rental | | | | | | | | | | | | Car Rental Analysis |
| Rentals Initiated in Week Starting 4/5/2022 |
| 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 | | Analysis
Criteria | Payment Method | | Analysis Critieria | Average
Total
Cost | Total
Cost |
| Green Collection | 988 | 4/5/22 | 4/8/22 | | Credit Card | | | N | | $0.00 | | Rewards | | | Rewards |
| Compact/Midsize | 275 | 4/5/22 | 4/10/22 | | Cash | | | N | | $0.00 | | Express Miles | | | Express Miles |
| Compact/Midsize | 277 | 4/9/22 | 4/10/22 | | Express Miles | | | N | | $0.00 | | Credit Card | | | Credit Card |
| Green Collection | 990 | 4/5/22 | 4/6/22 | | Credit Card | | | N | | $0.00 | | Cash | | | Cash |
| Fullsize/Standard | 350 | 4/5/22 | 4/8/22 | | Credit Card | | | Y | | $0.00 |
| SUV/Minivan | 550 | 4/5/22 | 4/9/22 | | Rewards | | | Y | | $0.00 | | Number of Rentals |
| SUV/Minivan | 551 | 4/7/22 | 4/10/22 | | Credit Card | | | N | | $0.00 |
| Fullsize/Standard | 352 | 4/7/22 | 4/9/22 | | Credit Card | | | Y | | $0.00 |
| Green Collection | 989 | 4/6/22 | 4/9/22 | | Credit Card | | | N | | $0.00 |
| Compact/Midsize | 275 | 4/11/22 | 4/18/22 | | Cash | | | N | | $0.00 |
| Fullsize/Standard | 355 | 4/9/22 | 4/16/22 | | Credit Card | | | Y | | $0.00 |
| Fullsize/Standard | 356 | 4/6/22 | 4/8/22 | | Credit Card | | | Y | | $0.00 |
| Fullsize/Standard | 350 | 4/9/22 | 4/13/22 | | Rewards | | | Y | | $0.00 |
| SUV/Minivan | 553 | 4/8/22 | 4/14/22 | | Express Miles | | | Y | | $0.00 |
| SUV/Minivan | 550 | 4/11/22 | 4/17/22 | | Cash | | | Y | | $0.00 |
| Green Collection | 988 | 4/9/22 | 4/15/22 | | Credit Card | | | N | | $0.00 |
| Green Collection | 989 | 4/10/22 | 4/16/22 | | Express Miles | | | N | | $0.00 |
| Green Collection | 990 | 4/7/22 | 4/10/22 | | Credit Card | | | N | | $0.00 |
| Fullsize/Standard | 356 | 4/9/22 | 4/10/22 | | Rewards | | | N | | $0.00 |
| SUV/Minivan | 551 | 4/11/22 | 4/15/22 | | Express Miles | | | Y | | $0.00 |
| SUV/Minivan | 554 | 4/7/22 | 4/9/22 | | Express Miles | | | Y | | $0.00 |
| Fullsize/Standard | 352 | 4/10/22 | 4/11/22 | | Credit Card | | | Y | | $0.00 |
| Fullsize/Standard | 356 | 4/11/22 | 4/17/22 | | Express Miles | | | Y | | $0.00 |
| Compact/Midsize | 276 | 4/11/22 | 4/14/22 | | Credit Card | | | N | | $0.00 |
| Compact/Midsize | 277 | 4/11/22 | 4/15/22 | | Rewards | | | N | | $0.00 |
| SUV/Minivan | 554 | 4/10/22 | 4/12/22 | | Cash | | | Y | | $0.00 |
| Green Collection | 990 | 4/11/22 | 4/18/22 | | Express Miles | | | N | | $0.00 |
| 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 | $75.00 |
abparsley
Parsley_Excel_Ch03_Assessment_CarRental.xlsx
