Versions Compared

Old Version 10

changes.mady.by.user Kyle Amlung

Saved on

compared with

New Version Current

changes.mady.by.user Rachdi, Donia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Exchange Rates

Info
iconfalse
titleProcess Owner
GBU Sales & Marketing / Finance
Info
iconfalse
titleD&PS Expert
Miriam Luttrin



General Description

 Exchange Rates:

 

P&L (Sales Performance Section):
Method 1:

Ex. jan-march you will have the YTD rate for all 3 months’ data

Method 2:

QV Analytics currency YTD Monthly rate

Jan : jan rate

Feb : jan+feb rate

Mar : jan+feb+ mar rate

Image Removed

  • In BW P&L, it looks at data only for one month

    •  

     
    -The CRM Analytics Dashboard will convert data using the “CAR3 Monthly Average Exchange Rate”.
    The monthly average rate has been requested by Group Controlling, Finance directors, and has been validated by the CRM Champions. The main interest is to be more business oriented, with a monthly rate being well known by sales people. 
    This new method more accurately reflects the fluctuation of exchange rates month over month and the impact on selling prices in euros and on business performance.
    Before the end of the current month, the rate is CAR3 M-1.
    All the data coming from the P&L query (BW_QRY_MVCOPA01_0004) are moving to CAR 3 rate:
    • Revenue & Margin in Sales performance
    • Invoiced in Orderbook
    -For any Sales Force related data (Opportunities, Quality):
    The exchange rate on this data is uploaded once per year from Budget department and is a unique rate for the full year. This is provided each year in November.