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:

• Order Book - takes by default the last Order Book snapshot. Otherwise the snapshot of the selected date
• vs. EoM Actual Sales Y-1 (based on Actual FX rae (no RSB) - % comparison with the same month Y-1
• vs. Orderbook xx/xx/xxxx - compares with the same date of M-1. 
  • Conditions: Check for same date M-1;
    • if available use that date for automatic comparison
    • if not available  (eg: 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