Carrier Scorecard Dashboard

This dashboard contains reports covering the carrier performance information under respective tabs. The dashboard is located in the catalog in Shared Folders/FTI Reports/_portal/Carrier Scorecard Dashboard

This dashboard is available as Preferred Dashboard via User Preferences.

The following prompts are used by this dashboard:

Carrier Score Card

This report captures the overall carrier’s performance as a scorecard.

The report for this section is located in the catalog in /Shared Folders/FTI Reports/_portal/Carrier Scorecard Dashboard/Carrier Scorecard

Metric	Definition	Metadata Mapping	Formula
Carrier	The carrier under review.	"- Shipment Service Provider Dimensions"."Actual Service Provider XID"	NA
Carrier Score Card	The overall score for the carrier based on the on time delivery, on time pickup and tender acceptance performance.		( IFNULL((("- Shipment Stop Delivery Facts"."On Time Count" /"- Shipment Stop Delivery Facts"."Stop Count" ).3) ,0) + IFNULL((("- Shipment Stop Pickup Facts"."On Time Count" /"- Shipment Stop Pickup Facts"."Stop Count" ) .3) ,0) + IFNULL((("- Tender Performance Facts"."Accepted Tender Count" / "- Tender Performance Facts"."Tender Count" ).4), 0) )100
Year	The year under review.	“-Shipment Period Dimensions”.”Year”	NA
Month	The month under review.	“-Shipment Period Dimensions”.”Month”	NA

Percentage Tender Accepted

This report captures the tender acceptance performance of carriers.

The report for this section is located in the catalog in /Shared Folders/FTI Reports/_portal/Carrier Scorecard Dashboard/Percent Tender Accepted

Metric	Definition	Metadata Mapping	Formula
Carrier	The carrier under review.	"- Shipment Service Provider Dimensions"."Actual Service Provider XID"	NA
Percentage Tender Accepted	Percentage ratio of the total number of tenders accepted and the total number of tenders received.		"- Tender Performance Facts"."% Tender Acceptance"
Year	The year under review.	“-Shipment Period Dimensions”.”Year”	NA
Month	The month under review.	“-Shipment Period Dimensions”.”Month”	NA

Percentage On Time Delivery

This report captures the on time delivery performance of carriers.

The report for this section is located in the catalog in /Shared Folders/FTI Reports/_portal/Carrier Scorecard Dashboard/Percent on Time Delivery

Column	Definition	Metadata Mapping	Formula
Carrier	The carrier under review.	"- Shipment Service Provider Dimensions"."Actual Service Provider XID"	NA
Percentage On Time Delivery	Percentage ratio of the total number of shipment stops delivered on time and the total number of stops visited.		"- Shipment Stop Delivery Facts"."% On Time Delivery"
Year	The year under review.	“-Shipment Period Dimensions”.”Year”	NA
Month	The month under review.	“-Shipment Period Dimensions”.”Month”	NA

Percentage On Time Pickup

This report captures the on time delivery performance of carriers.

The report for this section is located in the catalog in /Shared Folders/FTI Reports/_portal/Carrier Scorecard Dashboard/Percent on Time Pickup

Metric	Definition	Metadata Mapping	Formula
Carrier	The carrier under review.	"- Shipment Service Provider Dimensions"."Actual Service Provider XID"	NA
Percentage On Time Pickup	Percentage ratio of the total number of shipment stops picked up on time and the total number of stops visited.		"- Shipment Stop Pickup Facts"."% On Time Pickup"
Year	The year under review.	“-Shipment Period Dimensions”.”Year”	NA
Month	The month under review.	“-Shipment Period Dimensions”.”Month”	NA

Carrier Scorecard Dashboard