For all currencies listed in the "Export" column of one spreadsheet which i am having, in that sheet it is being asked to set up an exchange ratio:
1. To AUD
2. From AUD
3. To NZD
4. From NZD
The sample extract of the excel sheet is given below in word format for reference.
FOREIGN CURRENCY QUOTING & SOURCING TABLE
Highlighted currencies are designated by NYTO as a "Hard Currency"
Currencies noted with "(S3)" are defined by NYTO as a "Soft 3 Currency" experiencing hyperinflation 2
(At present there are no "soft 3" currencies currently defined by NYTO)
COUNTRY OF LOCAL CCY QUOTING SOURCING CURRENCY 1
MANUFACTURE CURRENCY CODE LOCAL EXPORT
Argentina Peso ARS ARS $U.S.
Australia Aust. Dollar AUD AUD AUD
Austria Euro EUR EUR EUR
Belgium Euro EUR EUR EUR
Botswana Pula BWP BWP $U.S.
Brazil Real BRL BRL $U.S.
Bulgaria Lev BGN BGN Euro
1. Definition of Local & Export
Local: When supplier's component, product, or service is consumed by company within the supplier's country of manufacture.
Export: When supplier's component, product, or service is consumed by company outside the supplier's country of manufacture
Due to the local price instability of u201CSoft 3u201D currencies, for local company use, the company will request quotes
and contract in local currency with an index to the applicable export currency
Hence, anyone can help me...