Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

How To Read The Report

Registration Number: Vehicle registration number
Pool Name: The Pool the vehicle is assigned to
Make: Vehicle make as entered in the Asset Register
Model: Vehicle model as entered in the Asset Register
Body Type: Vehicle body type as entered in the Asset Register.
Total Bookings: Total number of bookings on that particular vehicle over the reporting period
Avg Bookings Per Day: Total number of bookings over the reporting period divided by the number of days in the reporting period.

  • For example:
    The report period is Monday – Friday (5 days)
    There are 16 bookings across the report period.
    16 bookings divided by 5 days = An average of 3.2 bookings per day

Avg Booking Length (mins): Total booked minutes divided by total bookings over the report period.  
Availability (mins): How many minutes the vehicle was available to be booked for the period you specify and the business hours you have chosen. The system uses the formula of Business hours availability x number of work week days in the report period.

Note: If a vehicle was added to / removed from a Pool during the reporting period, the availability (in minutes) will reflect that.

  • For example:
    Your business hours filter is set to 89:00am - 5:00pm. (9 8 hours/540 480 minutes in total per vehicle)
    You run the report over 7 days (including the weekend which for full year 2023 (365 days of which 260 are week days. Weekends are is excluded by default)
    540 480 minutes x 5 260 days = 2700 124,800 available minutes

Bookings (mins): How many minutes the vehicle was booked for over the reporting period.
Booking Util (%): Booking time (in minutes) divided by availability (in minutes). This represents the percentage of time the vehicle was booked in its total available time.
Check Out/In (mins): How long, in minutes, was the booking checked out.
Check Out/In Util (%): Check out time (in minutes) divided by availability (in minutes). This represents the percentage of time the vehicle was actually used its total available time.
Billable (mins): The system will use the booking start time or the check out time (whichever is earlier) and the booking end time or the check in time (whichever is later).

  • For Example:
    Booking is made between 10:00am – 11:00am (Booking minutes is 60)
    Driver checks out at 9:55am and checks in at 10:50am (Check Out/In minutes is 50)
    Billable minutes is check out time to booking end time (65 minutes)
    Billable Util (%): Billable time (in minutes) divided by availability (in minutes).
    Total Passengers: How many passengers were on the trips over the report period according to the passenger manifest.

Avail. Seats: How many seats were available over the report period. (Taken from the seat count entered into the Asset Register).

Passenger Util (%): Available seats divided by total passengers.

image-20240429-234717.png

...