What is the recommended leading practice workflow for a compensation template?

Your customer has the following requirements for their compensation plan:
1. Use a hard stop in the customer's guidelines
2. Display only the high and low values in the compensation worksheet.
3. Display a prompt message to planners if they go outside of the high/low values. Which guideline rule settings must you set to fulfill these requirements?

Your customer is based in and has a functional currency of GBP. However, they also have offices in the US (USD), France (EUR), and Ge EUR). They would like the budget displayed in local currency, for all planners for example, German planners h budget in EUR, NOT GBR. How can you best account list? Note: There are 2 correct answers to this question

How would you use a lookup table result in a numeric operation?

Your customer has the requirement that employees wit performance ratings have a different text in their statement than those with high performance ratings. How can accomplish this?