General Description 
High level overview on the costs and allocation on different spend categories. 


Definitions and calculations 
Indicator DefinitionCalculation
Transport Costs (€)
Total of all transport Costs
Sum of Costs in EUR YTD vs sum of costs in YTD-1 
On Shipment Docs (€)
Total of all transport costs on shipment documents
Sum of all transport costs on shipment documents in EUR YTD vs sum of costs in YTD-1 
On Costs Centers (€)
Total of all transport costs on costs centers
Sum of all transport costs on costs centers in EUR YTD vs sum of costs in YTD-1 
Accruals Accuracy (%)
Improvement or reduction of number of shipments for which the freight is accurate, comparing reference period vs current period and expressed in % of total number of shipments
% variation accrual accuracy = (Y-X)/X
X= YTD N-1 nb of shipment (Accurate) =
      nb of shipment accurate YTD-1  ___________________________________
(total nb of shipments YTD-1 Accurate + not accurate (value in %))


Y = YTD N nb of shipment ( Accurate) = 
      nb of shipment accurate YTD    __________________________________
   (total nb of shipments YTD Accurate +                   not accurate (value in %))


(variation in %) = (Value YTD - Value YTD-1)/Value YTD-1
Accurate means for one shipment number FREIGHT ACC only and invoice date existing
If FREIGHT ACC + FREIGHT INV = Not accurate
Invoice not received = Freight ACC only and no invoice date (if several invoice consider 1st one)
Accruals Accuracy 
KPI object displaying Accrual Accuracy repartition. 
Dimensions available:
  • Package
  • Subpackage
  • Departure Zone
  • Departure Country
  • Site
  • Vendor
  • GBU
TOTAL INVOICED COSTS / TOTAL ACCRUAL COSTS  en EUR (%)


Target = costs Y-1
Transport Costs (€) Repartition
Repartition of Transport Costs. 
By default the data is displayed according to a TOP 5 of the largest costs by package.
Sum of Costs 
Yellow line : cost of the previous period (target) YTD Y-1
Transport Costs (€) Repartition by Cost Category
Repartition of costs by cost category.
% EUR Value of each cost category vs total
Sources 
IndicatorSourceScope
Transport Costs (€)
PROD_QV_BW_QRY_CPCOCT02_0001 
Filter - BFC Account =  R12910
On Shipment Docs (€)
PROD_QV_BW_QRY_CPCOCT02_0001 
Permanent/set analysis:
-Origin Flow = FREIGHT ACCR and FREIGHT INV
- filter : BFC Account R12910
On Costs Centers (€)
PROD_QV_BW_QRY_CPCOCT02_0001  
Permanent/set analysis:
-Origin Flow = All except FREIGHT ACCR and FREIGHT INV
- filter : BFC Account R12910
Accruals Accuracy (%)
PROD_QV_BW_QRY_CPCOCT02_0001
Permanent/set analysis:
-Origin Flow = FREIGHT ACCR and INV
-Cost Type Key (Shipment cost type) = T,O 
- filter : BFC Account R12910
Accruals Accuracy 
PROD_QV_BW_QRY_CPCOCT02_0001 
Permanent/set analysis:
-Origin Flow = FREIGHT ACCR and INV
- filter : BFC Account R12910
Transport Costs (€) Repartition
PROD_QV_BW_QRY_CPCOCT02_0001 +   QV_BW_QRY_CPCOCT07_0001
Permanent/set analysis:
- BFC Account:  R12910
Transport Costs (€) Repartition by Cost Category
PROD_QV_BW_QRY_CPCOCT02_0001
Permanent/set analysis:
- BFC Account:  R12910

Target Users

  • GBU Supply Chain 
  • Procurement organisation
  • SBS PSL
  • SBS Data Log
  • Transformation Center for Diagnostics

Authorization & Rights

All the accesses must be validated by the Process Owner. 
No access restrictions on the perimeter.
Please request access to the dasboard using this form:
Access form   

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels