Jose-Pablo Leyva


Miriam Luttrin


General Description

We decided to put in the same KPI the cost & the volume data in order to have the quick visibility between the quantities shipped and their cost.

We use the accrual information for the cost that bring a deeper granularity compare to invoice information. That's why we also provide a new KPI to measure the accrual accuracy versus the invoices.

The costs are divided in standard and extra cost, depending on the inputs the GBU done in SAP.

Warning: On the Go live Total cost is not equal to Standard Cost + Extra Cost

This is due to a line missing: Manual standard cost only used in Brazil, thus Coatis is the main GBu impacted. We're going to fix this problem during Q1 2019.



(*Attention - Please note that Volumes are multiplied by each leg and divided by the total costs, which makes the Unit Prices errenous when looking at flows with several legs)

KPI:

Standard Costs & Extra Costs

Transport Costs Accruals Accuracy & Accruals & Invoiced

Net Weight & Gross Weight

Number of Shipments  &  Number of Containers  &  Total KM

Net Weight Unit Costs = Standard Costs + Extra Costs / Net Weight

Costs per KM = Standard Costs + Extra Costs / Total KM


  • Transport Mode: Main one of the shipment file

  • Multicontainers (9024/9025): because of the SAP structure, containers are counted twice if we don’t filter on the Shipment Type. To correct this issue, we delete the Shipment Type “Approach Multi Cont.” and we keep “Sea Export (multi)”.


The Activity is calculated for each and every one shipment file present in TIERS. (Inbound and Outbound)

TIERS: Number of single shipment files (shipment operation assigned to one Forwarding Agent) Thus, it depends on each GBU process.




  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers


All the accesses must be validated by:

Supply Chain Excellence

Click here for the Access form to get access to the Global Supply Chain Dashboard.


  • Net Value Accrual CP: Net Costs in provisions in EUR or USD

The transportation costs are not the invoiced one. We can only have the product level with the accruals values.
  • EUR / USD

The conversion from a local currency to EUR or USD is based on the exchange rate managed by Finance. For each cost, the rate considered is the one of its reference month*.

* The reference month of a transportation cost is :

      • the actual completion month
      • the planned completion month if the actual completion month is not available
      • the shipment creation date if the planned completion month is also not available 

For USD, we don’t have all the exchange rates because it's not the official currency at Solvay (EUR).

So for the following countries: Argentina, Bulgaria, Egypt, Mexico, New Zealand and Switzerland, when selecting USD, the unit will not be USD but the local currency.



The Transportation Costs are calculated for each and every one of the shipment files present in TIERS. (Inbound and Outbound)

TIERS: Number of single shipment files (shipment operation assigned to one Forwarding Agent) Thus, it depends on each GBU process.v



Technical Documentation

Source:

TIERS

Query filters applied:

Standard & Extra costs, Net Weight and Gross Weight

QVSCE_BW_QRY_MVSDTR01_0010

Number of Shipments, Number of Containers, Total KMQVSCE_BW_QRY_MVSDTR01_0012
Transport Cost Accrual Accuracy, Accruals and InvoicedQVSCE_BW_QRY_MVSDTR01_0011

Update:

Daily

Dimensions:

Global Overview of Dimensions





THIERS

Global Filters
















PeriodMonth YearShip Actual for Ship [C_SHIPNU2__C_COMPMON]

Organization


GBU

BFC GBU [C_SUBACT2__CPFCTR1_2]

Group of Activity

[C_SUBACT2__CPFCTR2_2] BFC Group of activities

Sub-Activity

Sub-activity [C_MATPNT2__0G_CWWE01] Attribute/ BFC Activity 1 [C_MAGNUTU]

Company

[C_COMPCDE] Company_code
PlantZone[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Country[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant[C_PLANT] Plant
Ship DestinationZoneShip Dest Geo Zone [C_PNTDS3__C_ZONE]
CountryShip Dest Country [C_PNTDS3__0COUNTRY]
Corporate GroupDelivery [MVSDTR017 / Del Ship to Party [C_SHIPTID] / Corporate Group [C_CORPGR]
Ship DestinationShip Destination Point [C_PNTDS3]
ProductProduct HierarchyMaterial Hierarchy [C_MATNR2__0PROD_HIER]
ProductCommercial Product [C_MATNR2__C_PROD]
Bulk/PackedTransportation Group [C_MATNR2__C_BULKPAC]
Transport Mode

Ship Transportation [C_SHIPNU2__C_TR_MODE]

Specific Filters




Packaging Type

[C_MATNR2] Material\Attributes\[C_PACKAG]

Forward Agent

Forward Agent [C_FWDAGID]

Partner Type

PARTNER [MVSDTR014] \ [C_PNTY3PY] 3rd Party Type