Main Dashboard: Cost Benefits

This Cost Benefits tab displays the KPIs related to key Cost Benefit details of shipments. The actual value of the KPI is compared against the target value with a two-color gauge showing the status of the comparison.

The report for this tab is located in the catalog in /Shared Folders/FTI Reports/_portal/Main Dashboard/Cost Benefits Tab

Metric	Definition	Formula	Threshold (Stop Light) Definition
Order Consolidation Savings	Ratio of cost savings due to order consolidation to the order consolidation savings target.	case when ("- Shipment Order Release Targets"."Order Consolidation Savings Target" is NULL or "- Shipment Order Release Targets"."Order Consolidation Savings Target" = 0) and ("- Shipment Order Release Facts"."Order Consolidation Savings" is NULL or "- Shipment Order Release Facts"."Order Consolidation Savings" = 0) then 100 else ("- Shipment Order Release Targets"."Order Consolidation Savings Target") end	Order consolidation savings is greater than 100% of target value then green. Order consolidation savings is less than 100% of target value then red. If no data exists for the selected criteria then gray.
Order Profit	Ratio of order profit to the order profit target.	case when ("- Shipment Order Release Targets"."Order Profit Target" is NULL or "- Shipment Order Release Targets"."Order Profit Target" = 0) and ("- Shipment Order Release Facts"."Order Profit" is NULL or "- Shipment Order Release Facts"."Order Profit" = 0) then 100 else ("- Shipment Order Release Targets"."Order Profit Target") end	Order profit is greater than 100% of target value then green. Order profit isless than 100% of target value then red. If no data exists for the selected criteria then gray.

Metric

Definition

Formula

Threshold (Stop Light) Definition

Order Consolidation Savings

Ratio of cost savings due to order consolidation to the order consolidation savings target.

case when ("- Shipment Order Release Targets"."Order Consolidation Savings Target" is NULL or "- Shipment Order Release Targets"."Order Consolidation Savings Target" = 0) and ("- Shipment Order Release Facts"."Order Consolidation Savings" is NULL or "- Shipment Order Release Facts"."Order Consolidation Savings" = 0) then 100 else ("- Shipment Order Release Targets"."Order Consolidation Savings Target") end

Order consolidation savings is greater than 100% of target value then green.

Order consolidation savings is less than 100% of target value then red.

If no data exists for the selected criteria then gray.

Order Profit

Ratio of order profit to the order profit target.

case when ("- Shipment Order Release Targets"."Order Profit Target" is NULL or "- Shipment Order Release Targets"."Order Profit Target" = 0) and ("- Shipment Order Release Facts"."Order Profit" is NULL or "- Shipment Order Release Facts"."Order Profit" = 0) then 100 else ("- Shipment Order Release Targets"."Order Profit Target") end

Order profit is greater than 100% of target value then green.

Order profit isless than 100% of target value then red.

If no data exists for the selected criteria then gray.

Main Dashboard: Cost Benefits

Related Topics