Initial variable list for which the data extracted from transparency to price optimization engine (Novecare)
Latest list shared by Leo (May 11)
| Google Drive Live Link | ||
|---|---|---|
|
| Google Drive Live Link | ||
|---|---|---|
|
...
| Google Drive Live Link | ||
|---|---|---|
|
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)
...
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?
...