CEA - Order Book

• All GBUs
• Sales Orders only - External Sales
• Consolidated Entities = Yes
• Exclusion of Peroxide JVs (0360 Nippon Solvay, 5985 Basip Silent Partner, 6034 Mtp Hpjv (Thailand), 6235 Saudi Hydrogen Per)

KPIs:

• Total Order Book M (Invoiced + Pending + Not Confirmed)
• Invoiced M
• Pending M (Confirmed + Shipped not billed)
• Not Confirmed M, this can be switched on or off with the Y/N selection)
• M+1
• M+2
• M+3
• Actual Sales EoM Y-1

Available in both M€ and volumes in Tonnes

Key Figures:

• Orderbook (M€) - takes by default the last Orderbook snapshot. Otherwise the snapshot of the selected date.
• Extrapolation vs. RSB EoM Y-1 - % comparison of the extrapolation with the same month Y-1 restated (RSB) using CAR3 monthly exchange rate of current year.
• Extrapolation (M€) -  calculates the % variation between M-1* and today, and adds/subtracts this variation with the result of Actual Sales EoM M-1.
  • Example 5th November: Orderbook Nov 5th vs. Oct 5th => +8%, Extrapolation Nov : 716M€ +8% => 777M€
• vs. Actual Sales EoM Y-1 -  % comparison of the Orderbook with the same month Y-1.
  • Based on Actual FX rate - for Y-1 data we take the CAR3 monthly exchange rate of each month previous year
  • Based on RSB -  for Y-1 data we take the CAR3 monthly exchange rate of each month of the current year.
• vs. Orderbook xx/xx/xxxx - % comparison of Orderbook with M-1*.

* Check for same date M-1;

• • • if available use that date for automatic comparison
    • if not available  (i.e.: weekend) use the previous day available
    • if none exist for M-1, then take the next available date

Dimensions:

Dimensions Overview

Exceptions:

• The first of each month of ther Order book is replaced by M-1 Actual Sales.
• Data corrections may be applied to historical data by Commercial Excellence team.

Currencies and Exchange Rate:

• Pending, M+1, M+2, M+3 : extracted in local currency and converted to EUR using CAR4 exchange rate, which are simulated future rates defined by corporate finance
• Invoiced, Actual Sales M-1, Actual Sales EoM Y-1 : extracted in local currency and converted to EUR using CAR3 exchange rate, which is the monthly average rate applied to each month in question
• Composite Materials Actual Sales and Order Book: displayed EUR which are already converted by the GBU

*Snapshots are stored in EUR, with the rate at the time we take the snapshot. If the rate is revised (monthly revision for instance), it will have no impact on the snapshot.

Sources:

• Pending, Not Confirmed, M+1, M+2, M+3 : BW Global Sales query (QVSD_BW_QRY_MVSDSO41_SD004)
• Invoiced, Actual Sales M-1, Actual Sales EoM Y-1 : BW P&L query (QVSBS_BW_QRY_MVCOPA01_0004)
• Manual flat file for Composite Materials - QV server folder: \\WDCQSAP31\Composite Materials Manual Sales
  • Full GBU Order Book
  • External Sales excl WP1
  • WP1 Actual Sales come from the P&L query.
    
    

• Daily CET (morning, mid-day, evening). Snapshot are saved after last data refresh of the day.
• For Composite Materials, the manual data files are posted Weekly (on monday afternoons) for Order Book, and monthly after clsoing for Actual Sales excluding WP1