Opportunity Assessment

Total Costs (€)

This KPI display total logistics costs. It take into account Outbound transport on shipment documents from SCREEN and  others costs including leases from CosTa. 

• Sum of Costs in EUR YTD vs Y-1TD  RSB (and % variation)

Costs On Costs Centers

Total logistics costs from CosTa ON COST CENTER ONLY

• Sum of Costs in EUR YTD vs Y-1TD  RSB (and % variation)

Costs On Shipment Docs

Outbound transport on shipment documents from SCREEN ONly

• Sum of Costs in EUR YTD vs Y-1TD  RSB (and % variation)

Completion 

Total Costs

Total logistics costs = Outbound transport on shipment documents from SCREEN + Others costs including leases from CosTa

Completion date YTD 

Variation Completion costs

This KPI display gap in % of value for ref period posting date (Costs On Shipment Docs) vs completion date (Total Costs Completion date YTD )

(Total Costs Completion date YTD- Costs On Shipment Docs) /Costs On Shipment Docs result in  % 

Vendor Costs

Overview of costs repartition by vendor cluster by taxonomy ( package and subpackage) 

Total Costs EUR for selected period (by default YTD Y)

Unit Cost per distance

Distance= SUM(Distance Dep Point - Destination Point) / Nb of shipments

EUR/ton = total costs Dep point-Origin Point / Total net weight

Total Costs (€)

PROD_QV_BW_QRY_CPCOCT02_0001 + CosTa for FC (QV_BW_QRY_CPCOCT01_R1_0001)

Filters (SCREEN Query)

• Origin Flow = FREIGHT ACCR and INV 

• BFC Account = R12910

Filters (CosTa Query):

• Macropackages P0009 + P0010

Costs On Costs Centers

CosTa for FC (QV_BW_QRY_CPCOCT01_R1_0001)

Filters (CosTa Query):

• Macropackages P0009 + P0010

Costs On Shipment Docs

PROD_QV_BW_QRY_CPCOCT02_0001 

Filters (SCREEN Query)

• Origin Flow = FREIGHT ACCR and INV 

• BFC Account = R12910

 Completion 

Total Costs

PROD_QV_BW_QRY_CPCOCT02_0001 

Filters (SCREEN Query)

• Origin Flow = FREIGHT ACCR and INV 

• BFC Account = R12910

Variation Completion costs

PROD_QV_BW_QRY_CPCOCT02_0001 

Filters (SCREEN Query)

• Origin Flow = FREIGHT ACCR and INV 

• BFC Account = R12910

Vendor Costs

PROD_QV_BW_QRY_CPCOCT02_0001 + CosTa for FC (QV_BW_QRY_CPCOCT01_R1_0001)

Filters (SCREEN Query)

• Origin Flow = FREIGHT ACCR and INV 

• BFC Account = R12910

Filters (CosTa Query):

• Macropackages P0009 + P0010

Unit Cost per distance

PROD_QV_BW_QRY_CPCOCT02_0001

• Origin Flow = FREIGHT ACCR and INV

• BFC Account = R12910

• Packages: Road, Rail, Air

• Excluded multi leg : nb of legs >1