You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »


Objective

This report is a fixed costs report on Travel & Expenses set up by Solvay reporting platform and is the reference for P&L calculation.


Currency - RSB - FX effect

In order to neutralize the FX effect, spend is always extracted in local currency and calculated in EUR using the following methodology :
  • Current Year (M-1)+ Y-1 RSB : Data are extracted in EUR each month
      • Exchange rate : CAR 3 (Monthly Average of M-1)
All spend of current year is adjusted from local currency to EUR using the exchange rate (average value) of M.


  • Y-1 Historical : Data are extracted once a year (in January)
      • Exchange rate : CAR 3 (Monthly Average December Y-1)
All spend of previous year is fixed and adjusted using average value of December of this same year.

 

Source, Scope & Refresh

BW sources :
  • GBUs : BW_QRY_MPR_FC003_0003
  • Functions : BW_QRY_MPR_FC001_0001
    Refresh : Monthly ( the 15th)
Solvay group
Exception
BAAN & PE1 spend cannot be extracted from BW. 
In the meantime of Composites Materials integration on WP1, data are extracted from Cognos (owner: James Blandford) and are RSB with the same methodology as spend extracted from BW.

Additional Information

It has been agreed that controlling data are the reference to measure the spend evolution and will only be adjusted with FX effect and not on scope.
Also note that there is an average of about 35 days lagging effect between a booking and its impact in BW, with the assumption that travelers are expensing at least once a month (policy recommendation).

Not able to find the solution? Contact SBS Support.

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