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 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)”.

Shipment 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.



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

Provisioning 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 
         

USD 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.

Shipment 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
Number of Shipments, Number of Containers, Total KM
QVSCE_BW_QRY_MVSDTR01_0012
Transport Cost Accrual Accuracy, Accruals and Invoiced
QVSCE_BW_QRY_MVSDTR01_0011
Update:
Daily
Dimensions:
Global Overview of Dimensions



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

Not able to find the solution? Contact SBS Support.

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