Versions Compared

Old Version 11

changes.mady.by.user Miriam Luttrin

Saved on

compared with

New Version Current

changes.mady.by.user POLOSSON-ext, Damien

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.






Image Removed

Info
titleSupply Chain Excellence
Jose-Pablo Leyva
Info
titleD&PS Expert
Donia Rachdi

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
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)”.
Info
titleShipment file
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.
Info
iconfalse
titleTarget Users
  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers
InfoiconfalsetitleAuthorization & Rights
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
Warning
titleProvisioning Costs
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 
         
Warning
titleUSD inacurracy
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.
Info
titleShipment file
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,
Standard Costs Manual accrual (CP)
QVSCE_BW_QRY_MVSDTR01_0010
Image Modified
Number of Shipments, Number of Containers, Total KM
QVSCE_BW_QRY_MVSDTR01_0012
Image Modified
Transport Cost Accrual Accuracy, Accruals and Invoiced
QVSCE_BW_QRY_MVSDTR01_0011
Image Modified
Update:
Daily
Dimensions:
Global Overview of Dimensions
THIERS



TIERS

Global Filters
Period
Month Year
Ship 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
Plant
Zone
[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Country
[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant
[C_PLANT] Plant
Ship Destination
Zone
Ship Dest Geo Zone [C_PNTDS3__C_ZONE]
Country
Ship Dest Country [C_PNTDS3__0COUNTRY]
Corporate Group
Delivery [MVSDTR017 / Del Ship to Party [C_SHIPTID] / Corporate Group [C_CORPGR]
Ship Destination
Ship Destination Point [C_PNTDS3]
Product
Product Hierarchy
Material Hierarchy [C_MATNR2__0PROD_HIER]
Product
Commercial Product [C_MATNR2__C_PROD]
Bulk/Packed
Transportation 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