Transportation Management Dashboard

The Transportation Management dashboard groups and presents information about an organization’s logistics operations in terms of the movement of freight. The dashboard provides information on freight costs, arrival performance, carrier billing, and freight cost recovery and variance. With this information, transportation managers can
understand transportation performance as of any date and track trends over time. This can help transportation managers control costs, manage freight carriers, and drive continual improvement in the transportation operation.

KPI Definitions
¡E Rated Freight Cost per Unit Weight: Rated freight cost / Freight weight
The cost per unit of weight for transporting goods for all deliveries within trips

• Freight Weight: The sum of all gross weights for deliveries that are associated with rated freight costs.
• On-time Arrival Rate: [(Number of On-Time Arrivals to Trip Stops) / (Number of Arrivals Planned for every Trip Stop)] * 100
The amount of times deliveries arrived at trip stops on time as a percentage of total deliveries.

• Carrier Billed to Paid Variance: [(Billed – Paid In Full) / (Absolute Value of Paid In
Full for all carrier bills paid in full within the selected period)] * 100
The amount of payment made to the carrier as a percentage of the total amount billed.

• Carrier Payments: The sum of all payments made to the carrier for the selected
period (aggregated on the paid date of the payment created)

You can use these reports to answer the following questions:
• How much did transportation cost per pound, per cubic feet, or per mile this period?
• How did organizations perform in comparison with last month, quarter, or year?
• Which organization is achieving the best unit cost per weight, volume, and distance?
• Which carrier service levels have the worst unit cost per weight, volume, and
distance?
• How are the unit costs doing over time for carriers and organizations?
• What is the total spend by carrier, mode, and service level?
• Which carrier is responsible for the greatest cost of shipping goods?

 

Graphs

• Rated Freight Cost: This graph shows the rated freight costs across the selected
parameters. The rated freight cost from the selected period is contrasted with that of
the selected compare-to period.
• Rated Freight Cost Trend: This graph shows the rated freight cost from the selected
date back in time. The data is grouped in increments of the selected time period.
• Freight Weight: This graph shows freight weight across the selected parameters. The
freight weight from the selected period is contrasted with that of the selected
compare-to period.
• Freight Weight Trend: This graph shows the freight weight from the selected date
back in time. The data is grouped in increments of the selected time period.
• Rated Freight Cost per Unit Weight: This graph shows the rated freight cost per
unit weight across the selected parameters. The rated freight cost per unit weight
from the selected period is contrasted with that of the selected compare-to period.
• Rated Freight Cost per Unit Weight Trend: This graph shows the rated freight cost
per unit weight trend from the selected date back in time. The data is grouped in
increments of the selected time period

On-Time Arrival Rate

You can use these reports to answer the following questions:
• Which carriers are consistently late on arrivals?
• What mode of transportation, carrier, or service level is most reliable?
• Are carriers typically early, late, or on time?
• How are carriers performing over time?
• How late are carriers arriving at trip stops?

These reports show the timeliness of carriers arriving to their trip stops. Supply chain or transportation managers can assess on-time performance. This information shows how carriers are performing, which ultimately affects deliveries to intermediate and end customers.

Image

management dashboard