Dashboard Zone

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.

The Shipping Management dashboard shows data for shippable items only, from a shipping and operations perspective.

Because the intent of this dashboard is to show the performance of
your shipping processes, both internal and external orders are included in the Shipping Management reports.
Use the Shipping Management dashboard to monitor your warehouse
operations, including the performance of your shipping operations and changes over
time

• View number of lines shipped, and percentage of late shipments by
organization, inventory category, item, and customer.

• View a trend of the number and percentage of lines shipped early, late, and on time, compared to the schedule ship date, over the selected time
periods.

• View book-to-ship cycle time by organization, inventory category, item, and customer.

• View the number of lines shipped by cycle time buckets—for example, lines that were shipped within a day, a week, and so on.

• View the number of lines that are past due by aging buckets—for example, lines that are a day past due, a week past due, and so on.

• View the number of lines that are in backorder status by organization, inventory category, item, and customer.

• Monitor key performance measures in number of lines shipped, percentage of late shipments, book-to-ship cycle time, and past due scheduled lines.

The Shipping Management reports display information for shippable items only. For assemble-to-order (ATO) items, only the configured (assembled) item is shippable on the sales order. Therefore, only that sales order line is included in the report calculations.

For pick-to-order (PTO) and kit items, any line that is shippable is included in the reports. Since service items, such as warranties, are not shippable, they are not included in the reports.

Note: For ATO, PTO, and kit items, child items are assigned to categories
just as all other items are. They are not necessarily assigned to the same
category as their parent items. That is, child items in the reports can be
under the same or different category as their parent items

Shipping KPIs
Shipping key performance indicators (KPIs) are described in this section.
KPI DeƒOnitions
- Lines Shipped: Total number of sales order lines that have shipped.
Use this KPI to identify the volume of lines shipped for organizations and how they compare to the previous period. This KPI suggests whether warehouse activity is increasing or decreasing.

- Lines Late to Schedule: (Total number of lines shipped late after the Schedule Ship Date on the sales order line / Lines Shipped) * 100
Use this KPI to determine which organizations have the best or worst shipping performance and which customer is impacted the most. This KPI shows whether the timeliness of shipments is worsening or improving.

- Lines Late to Promise: (Total number of lines shipped late, after the Promise Date on the sales order line / Lines Shipped) * 100

- Book to Ship Days: For all order lines, the average of (Shipped Date – Firmed Date). If a firmed date is not available, booked date is used. This KPI shows the average number of days between booking the sales order and
shipping the items.

Use this KPI to determine an organization¡¦s cycle time from order booking to shipping. Select the KPI to view the report, which shows the cycle time by organization, inventory category, items, or customer to determine what is driving the cycle time or who is affected by it.

- Past Due Schedule Lines: Number of booked sales order lines that are not yet shipped and where the Schedule Ship Date is earlier than the selected date.
Use this KPI to determine the current state of past due order lines. You can compare this KPI to the prior period to determine the fluctuation of volume in terms of lines and to see whether the trend is improving.