access project

Project Overview

Car Rental

Statement of Purpose

To keep track of business operation specifics. For example: who the clients are, payment amounts, payment types, cars being rented, whether clients are individual or large companies, etc.

Reports

1. The most popular cars rented.

2. The average rental length.

3. The most popular season for rentals.

4. The frequency for types of cars rented.

5. How customers usually pay.

6. What percentage of income comes from large company rentals.

7. The average cost for clients to rent moving trucks.

8. The average age of individual rentals.

9. The percentages of client occupations that are employed. (vs self-employed or student).

10. The average annual repair costs.

Business Processes

1. Rental length

(daily, weekend, weekly, monthly)

2. Maintenance costs

(monthly)

3. Client payment amounts and types of payment

(Mastercard, Cash, VISA)

4. Post-rental car check-up

(charges for customer if damage is found and maintenance information (over mileage charges etc.)).

5. Client information and frequency

6. Employee wages

7. Requested rental car class and mileage allowance

8. Promotions

(based on popular season/customer loyalty/large companies)