FP&A Product Prices

Options
anshul.savant
anshul.savant Member, ALL USERS, Partner Posts: 2 New Contributor

Hi,

I was trying to upload the product cost and prices to a module, to be used later to calculate the revenue.

 

The data is present in one of the excel tabs in the 2017 Budgeting files. However nothing is mentioned about the currency.

 

Can someone please let me know if it is in GBP or local currency?

 

Any help would be much appreciated.

Thanks.

Comments

  • anshul.savant
    anshul.savant Member, ALL USERS, Partner Posts: 2 New Contributor

    In my opinion, since the product prices are same for all the products respectively for any country, they should be in local currency. There is a user story that mentions that revenue/P&L should be available in both GBP and local currency. So we can later convert the local currency revenue into GBP by multiplying it with the relevant month exchange rate.

    Omkar, about your question, you should use the correct exchange rate in the correct month for forecast.