Versions Compared

Old Version 4

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.






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.
*Attention - Note

Image Removed

Info
titleSupply Chain Excellence
Jose-Pablo Leyva
Info
titleD&PS Expert
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)”.
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
Info
iconfalse
titleAuthorization & 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
provisioning
accruals values.
  • Gross Weight: in kilograms only
    Conversion rules: EUR
    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:
THIERS

TIERS

Query filters applied:

Standard & Extra costs, Net Weight and Gross Weight,
Standard Costs Manual accrual (CP)
QVSCE_BW_QRY_MVSDTR01_
0012
0010
Image Removed
Image Added
Number of Shipments, Number of Containers, Total KM
QVSCE_BW_QRY_MVSDTR01_
0010
0012
Image Removed
Image Added
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