Foreign Exchange Forecasting

Hi

I'm wanting to know if there's a standard SAP report to fulfill my below requirement.....

Every month we manually produce a Foreign Exchange Forecast document which shows for particular vendors how much in value we will purchase over the next 18 months. This way we know how much foreign currency we need to purchase and try to get this at the best rates.

Currently we use MRP (MD04) to determine the quantity required each month and look at the last purchase order to get the price we pay and multiply. This is very much a guestimate but does the job.

I'm guessing we are not the first people wanting to know this information and there must be something standard that would show us what we need to know. Unfortunately I just can't find it and hope someone can help me out here.

Thanks in advance