Initial variable list for which the data extracted from transparency to price optimization engine (Novecare)
Latest list shared by Leo (May 11)
Top priority is the data available in transparency
Second priority
Product characteristics to consider to include in the list → source is unknown
- other characteristic which are not available in P&L (Maybe SAP EHS)
- Product Colour, Grade
- How product is made
What sources and what are the available attributes? (maybe Naveen, Younness)
List of variables to be reviewed (Leo). Leo will share the new file. Carlos/Ahmed when Leo is not available
Master data coming from sources PF1 and WP1 (PRS), and BW (to start with BW).
Forecast is calculated in transparency dashboard (some data is coming from BW and use also other data)→ forecast logic to be shared by Ayoub
Orderbook use in the transparency dashboard is very limited, mainly P&L query is the basis
For optimization product we won't use order book
There are data in the transparency dashboard coming from salesforce, it might be interesting for optimization product
Definition of the CPC to be defined by Leo Ship-to + material (no incoterm) → Leo to confirm
-----------------------------
Transparency team (below has been clarified with Ayoub already)
1. For Novacare, we use below aggregation logic
a. Data will be aggregated on Shipto + Material +incoterm combination to derive CPC combination
b. Further aggregate on Order number to consider adjustments
c. Take the latest order by delivery date to derive Last Invoice Price (€/KG) attribute (Ayoub to conform the exact logic to derive "Last Invoice Price (€/KG)")
2. Rest of the attributes part of Transparency Feature extract will be a 1:1 mapping to COPA03 query
3. All the attributes part of Forecast extract will be a 1:1 mapping to QV_BW_QRY_CPCOPC07_0001
Last Invoice Price (€/KG)" derivation logic, confirming if there are any currency and UOM conversion in Transparency ? specific logic in transparency even though it is available in P&L query (later ask from Franck)
Any data quality issues worth sharing at this stage?
0 sale in the month of Mar for some CPSs but there is a last invoice price. I assume the last order is not during Mar
"Last invoice price" according to c above has been generated in transparency dashboard based on the last invoice per CPC. what is the rule for the same field in forecast?
Price optimization (Novecare):
To aggregate the sales to consider:
sales by sites where solvay is 100% shareholder ?
Should we include internal sales (Ex: Sales between Novecare to SPP)