SparkLink Vehicle Services Pvt. Ltd. is a company that allows customers to register into their system and choose vehicle/s for hire. It is further known that customer has credit limit. The customer can choose an option for driver facility. The payment of driver is paid by the company on hour basis.
The customer pays for each vehicle depending upon its hourly rate and period of hours engaged. The manager wants reports like but not limited to:
- List of all vehicles inside the system.
- List of vehicles that are on hire on specified date (or duration).
- Total amount collected from any type of vehicles.
- Total amount collected from each customer.
- Total dues amount of any customer.
- The customer should be able to see payment history and dues amount.
[Contributed By: Susan Shrestha, BIM VII, Orchid International College]