Understanding Execution dashboard

The data for the executed trips show up on this page in the following sections - 

Dashboard shows  the Total plans created, all the trips in execution, Total Vehicles, Total deliveries in all of the trips, total weight of all the load in the trips and the number of trips edited.  All widgets show numbers for confirmed Plans and Trips.

Trips by Category - All trips per vehicle category which are or were executed in the time period. 

Activity Status of all the deliveries in the trip - The deliveries are slotted among On time deliveries, Delayed deliveries, Not delivered and Unknown deliveries. 

Trip Status - Trips are divided among On time and Delayed trips. 

Trips can be viewed in Completed by Time view. 

Trip completion view 

Score card Metric - Trip level and Driver level 

Trip level score card - There are 6 variables determining the scores. 

On time deliveries - This is the ratio of the number of completed deliveries in a given time duration to the total number of deliveries in a trip. All deliveries with the visited status / job status as completed are considered to be completed deliveries irrespective of auto close OR manual close of trips. Denominator = all the deliveries planned. 

Distance Adherence - if (actual Travel distance <  planned travel distance), then it is 100%
else
100 - ( (actual Travel distance - planned travel distance)/planned travel distance *100)

In summary, as long as the actual travel distance is within the planned travel distance, it is 100%. If it goes above the planned distance then the rating will drop. This is to ensure that the driver does the trip within the planned distance.

It is possible that poor execution from the driver leads to a 100% score on this parameter. Hence it has to be looked at in conjunction with other parameters such as location Adherence and trackerData Adherence 

Location accuracy - Completed Deliveries will be considered as adhered to location as long as the location deviation computed is within the geofence radius set. If the radius is not set then the default value will be 100 Mtrs.

Example : 10 Deliveries, 2 are not delivered, 2 are in unknown status, 6 are completed. Out of 6, 4 are swiped within the geofence radius. Then the score will be  4/10 which is 40%. ( 10 = 6 completed + 2 unknown + 2 not delivered, 4 = 4 deliveries are swiped within geogence) 

POD availability - It is a ratio of the number of shipments for which POD is uploaded to the total number of deliveries.

Example:  if there are 10 shipments in a trip, 7 PODs uploaded , the value will be 7/10 that is 70% . The denominator will be 10 irrespective of unknown deliveries, not delivered or delivered shipments. 

Traceability - This will be calculated after the trip completion.  The driver app is set up to send out location updates every 30 sec to our servers (pings). We compare the number of locations received with the number of expected pings assuming 2 pings for a minute for the total travel time.
Calculation :
No of Locations received / (total trip duration in sec / 30) . Say, We have the trip duration for an hour, per hour 120 locations should be received. If we have received a value, based on upper bound and lower bound the score is determined for each parameter.

For example, for a trip of 1 hour duration, 120 pings are expected. If 60 locations pings were received, the numerator is 60, denominator is 120, value is 60/120 that is 50% 

Activity Completion - This score is calculated as number of activities completed against number of activities to be completed through out the trip. 

The drivers are rated on their trip scores. 

Example - If there are 3 trips executed by a driver. His score will be = (1st trip score + 2nd Trip score + 3rd trip score) / 3

Total Cost Metric - 

The summation of cost configured against each vehicle category of a transporter shows up for the trips planned for the particular duration. The actual cost value is summation of all the trips completed out of the planned trips. 

example - Planned Cost for 21 trips = 3860 INR and the Actual Cost for 1 trip completed is 1285 INR. 

Total Distance Metric- This is the distance planned across trips for the selected duration versus the actual distance for all the completed trips. 

In the following example - total 3 trips of 76 KM were planned, 3 trips of 76 KM were confirmed. These 3 confirmed trips were completed however the actual distance traversed is 3 Km. 

Total Utilization Metric - This metric categorizes trips based on percentage of weight or volume utilization. 

Vehicles planned for the day - 

Maximum Vehicle utilization metric - Vehicles which have done more than 1 trip out of the total vehicles available. This helps to understand if we are utilizing the available fleet of vehicles to the maximum level possible. 

Unplanned Vehicles metric - This suggests vehicles which are idle and not used for the duration selected. This helps to determine if we have extra vehicles which can be let go.  

Market Vehicle Recommendation - This metric helps us determine if we are in need of more vehicles than the ones available to run the operations. This suggestion helps us to increase the fleet based on the demand pattern.