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.


Name

Source

Calculation

Comments

Total Spend

BW- Fixed Costs

2018 Spend = ∑Spend N-1

YTD 2019 Spend = ∑Spend Ytd N

No filter available on time dimension


Total Spend YTD vs YTD N-1 RSB

Evolution = (∑Spend "Selection" N -∑Spend "Selection" N-1 RSB)/∑Spend "Selection" N-1 RSB


Spend evolution (N vs N-1)

Monthly/Quarter Spend for N data

Monthly/Quarter RSB Spend for N-1 data


Spend per Region

Share of each region

Location of company (not of the expense)

Details and evolution per GBU and function

Trend = (∑Spend "Selection" N -∑Spend "Selection" N-1 RSB)/∑Spend "Selection" N-1 RSB

Moving average = (∑Spend last 3 months - Average Spend last 12 months)/Average Spend last 12 months in %




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
1 Organisation = Entreprise Fixed Cost
  • Functions : BW_QRY_MPR_FC001_0001
    1 Organisation = ZCBS-FUNCT; ZCBS-CORPO ; ZCBS-PROJ
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).