Jose-Pablo Leyva


Miriam Luttrin



General Description

xxxx - Jose Pablo Leyva


(*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 provisioning values.
  • Gross Weight: in kilograms only

  • Conversion rules: 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:

THIERS

Query filters applied:

Standard & Extra costs, Net Weight and Gross WeightQVSCE_BW_QRY_MVSDTR01_0012
Number of Shipments, Number of Containers, Total KMQVSCE_BW_QRY_MVSDTR01_0010
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