This page describes the visual dashboards available in MRM BI, including the Planned vs Actual, Utilization, and Route Performance dashboards.
Planned vs Actual
This dashboard contains a comparison of planned driving time, service time, distance, capacity pickup, and capacity drop-off data against the final records after operations (delivery/pickup) are performed. These comparisons are made at the route level.
Planned vs Actual Dashboard Page
This page contains the Planned vs Actual Dashboard and includes the following elements:
Filters (7)
Number of routes
Donut charts (5)
Drill through icons
Filters
Start Date (Year)
Start Date (Month)
Start Date (Day)
Start Date (Week)
Business Unit
Route
Driver Name
Charts
Driving time (Hr)
Service Time (Hr)
Distance (Mi)
Drop off Capacity (M1)
Pickup Capacity (M1)
Each chart displays the number of routes and what percentage that represents from the total. This display uses a four-color traffic light performance indicator:
Dark Green: Very good — actuals were less than the planned measure.
Lime Green: Good — actuals were over planned by less than 20%.
Yellow: Bad — actuals were between 20% and 60% over planned.
Red: Very bad — actuals were over planned by more than 100%.
Number of Routes
Displays the number of routes in the data selected using filters.
Drill Through Icons
Inside each donut chart is a drill through icon that displays a page with more detailed data for the metric shown in the chart.
Planned vs Actuals Dashboard Metric Page
This page contains a more detailed picture of a particular metric (e.g., driving time, service time, distance, drop-off capacity, or pickup capacity). Each of these pages includes:
Filters (7)
Donut chart
Number of routes
Gauges (4)
Pivot table
Regular table
Icon to return to the main Planned vs Actual Dashboard page
Filters
Start Date (Year)
Start Date (Month)
Start Date (Day)
Start Date (Week)
Business Unit
Route
Driver Name
Donut Charts
Each chart displays the number of routes and what percentage that represents from the total. Uses the same four-color traffic light indicator described above.
Number of Routes
Displays the number of routes in the data selected using filters.
Gauges
Each gauge displays (in green) the aggregated actual metric represented by the number inside the gauge. The red needle represents the aggregated planned metric (target value) shown outside the gauge. If the needle is in the green area, the actual aggregated metric is larger than planned; if in the gray area, it is smaller than planned.
Total Number of Stops
Metric Aggregated
Metric per Stop
Metric per Route
Pivot Table
The pivot table displays the number of routes in the following drill-down hierarchy:
Year
Month
Day
Route Classification
Table
Contains the following columns:
Route
Driver Name
Planned vs Actual Status
Utilization Dashboard
The utilization visual dashboard reports the time and capacity metrics planned versus the time and capacity metrics available. This dashboard consists of two pages.
Resources Utilization
This page contains the Planned vs Available resources and includes:
Filters (7)
Number of routes
Donut charts (4)
KPI cards
Filters
Start Date (Year)
Start Date (Month)
Start Date (Day)
Start Date (Week)
Business Unit
Route
Driver Name
Number of Routes
Displays the number of routes in the data selected using filters.
Donut Charts
Usage: Available vs empty routes
Capacity pickup: Available vs planned pickup capacity
Capacity drop-off: Available vs planned drop-off capacity
Time: Available vs planned pickup time
KPIs
For each metric (capacity pickup, capacity drop-off, time), the KPIs summarize the totals of the planned used capacity and the unused capacity.
The second page is similar to the first but instead of aggregating utilization for all data selected through filters, it separates utilization by route. Top or bottom route performers can be easily identified. Unused metrics are displayed in red, used metrics in blue. The delta between unused and used metrics is displayed in yellow, and the green line represents the percentage of delta with respect to the planned metrics.
Route Performance Dashboard
This dashboard contains two columns and six rows of charts. The first column represents histograms of performance distribution across routes for a given metric. Performances closer to zero are more desirable because they represent the smallest deviation between planned and actual metrics. The second column contains donut charts displaying the percentage of routes for each metric by distribution category.
The six metrics considered are:
Job Sequence
Late Start
Late End
Distance
Driving Time
Service Time
Distribution categories (by color):
< -40% — Red
-40% to -20% — Red
-20% to -10% — Yellow
-10% to -5% — Yellow
-5% to 1% — Lime green
-1% to 1% — Dark green
1% to 5% — Lime green
5% to 10% — Yellow
10% to 20% — Yellow
20% to 40% — Red
> 40% — Red