This dashboard is supposed to have management overview how well the system is doing. This may change over time. 



Permission

The permission required to view this chart is: TRANSPORT:REPORTJOBSUMMARY. Please make sure to set this before trying to view this.


General

  • Dates(daily) on the dashboard are shipperRequiredDate.
  • All of the metrics are by jobs except stated otherwise for e.g deliveries (trips), invoiced (by booking)
  • The number inside the parenthesis() is a subCon (subContractor) count. If subcon is 0, then the parenthesis won't appear at all. 
  • Can use date selector to see the metrics for a week from the selected date. 
  • data with only these statuses are included in computation:-
    • booking: [BookingStatus.Accepted, BookingStatus.CloseFinance, BookingStatus.CloseOperation]
    • job: [JobStatus.Active]
    • trip: [TripStatus.AtDropoff, TripStatus.AtPickup, TripStatus.Completed, TripStatus.Enroute,    TripStatus.Pending, TripStatus.Planned, TripStatus.Staged, TripStatus.Started ]
    • leg:  [LegStatus.Completed, LegStatus.Enroute, LegStatus.Pending, LegStatus.Planned]
    • availability: [AvailabilityStatus.Available]


Metrics

  • Revenue - Invoice (AR) approved generated for the job that day. This metrics is by BaseCompanySetting (ShipperRequiredDate or ActivityStartDate). Please note, if you generate an invoice but do not link the Job, the metrics will not show up. 
  • MTD Revenue - Total revenue for period starting from the beginning of the current month up until now. 
  • TEU - computed based on 20 ft equivalent. May not be be useful for all business units. 
  • Total Deliveries - Number of delivery trips completed. 
  • MTD Deliveries - Number of deliveries for the period starting from the beginning of the current month up until now.


  • Deliveries (trips) - Total number of trips which are delivery type.
    • SUBCON - if  a trip uses OUTSOURCE transportSource in any leg, then the trip is consider subCon    
    • OWN - if a trip uses OWN transportsource in any leg, then the trip is consider own
  • Total Jobs - Total number of jobs
    • SUBCON - if a job uses OUTSOURCE transportSource in any leg, then the job is consider subCon 
    • OWN - if a job uses OWN transportsource in any leg, then the job is consider own
  • Jobs Planned - Total number of jobs with planned legs (if job has any planned leg then job consider planned)
    • same as Total Jobs's metric except based on planned jobs
  • Jobs Completed - Total number of jobs where all legs are completed
    • same as Total Jobs's metric except based on completed jobs
  • PODs (web, driverApp) - Total Number of POD uploaded by non-driverApp(web) and driverApp. A job is counted as POD uploaded if atleast one of the trip has POD uploaded. e.g (1) 9, 7 one subCon and nine own for web & 0 subCon and 7 own for driverApp
    • same as Total Jobs's metric
  • Invoiced - Total number of bookings are invoiced
  • Average Update Time (min)- Average minute variance from top 90th percentile of legActivity.
    • a = sort legActivities by minuteVariance (descending)
b = 90th percentile of a

c= sum of minuteVariance (b) / count of (b)

# c * 100%
                    
  • Driver Update (%) -  (count of timings updated by driver / total timings update) * 100
  • Prime Mover Utilization  - count of PM assigned to jobs / total PM availability
  • Driver Utilization - count of DR assigned to jobs / total DR availability
  • Est. Cost - to be updated
  • Est. Sell - to be updated
  • Revenue - to be updated