5. Next you compute to important worksheet topics: 2100 Sales Quota and 2099 Compensation: a. 2100 Sales Quota Determination: Faade's 2100 Sales Quota calculation: 1) If a representative did not meet their 2099 quota, increase their 2099 quota by five percent to determine their new 2100 quota. For instance, if their 2099 quota was $100 their 2100 quota will be $105. 2) If a representative met or exceed their 2099 quota, increase their 2099 quota by ten percent to determine their new 2100 quota. For instance, if their 2099 quota was $100 their 2100 quota will be $110. 3) 2100 quotas are rounded to the next lowest $100. b. Federal 2099 Compensation Guidelines: Faade's sales representatives are entitled to the following net compensation: Income (percentage paid on sales) less taxes (fixed percentage of income). C. Anticipating you will encounter hard values that you want to avoid, you take action. 6. Without delay, you: a. Map out a new Compensation/Quota section on the worksheet b. Add Compensation Percentage, which is 12.3% and Fixed Taxes, which is 25.5%. c. Update this section with two labels: 2100 Quota % Increase, 5% and 10%. d. Include a Sales Cancellation Limit of 2% and a Quota Percent Limit of 100% 7. Now, you employ a complex single formula with appropriate cell referencing and operation controls to compute each representative's 2100 Sales Quota and 2099 Compensation. 8. The last portion of your worksheet recognizes a representatives' performance as well as training needs when warranted with the following categories: a. Outstanding Performance: A representative's performance is outstanding when Percentage of Quota is NOT less than the Quota Percent Limit of 100%. TRUE means Quota Percent Limit or greater. FALSE means less than the Quota Percent Limit. b. Superior Performance: A representative's superior performance is TRUE when Outstanding Performance is true AND Percent of Total Sales is less than the sales cancellation limit. C. Sales Training: A representative is selected for additional training when Outstanding Performance is not true OR Percent of Total Sales equal to or greater than the sales cancellation limit. 5. Next you compute to important worksheet topics: 2100 Sales Quota and 2099 Compensation: a. 2100 Sales Quota Determination: Faade's 2100 Sales Quota calculation: 1) If a representative did not meet their 2099 quota, increase their 2099 quota by five percent to determine their new 2100 quota. For instance, if their 2099 quota was $100 their 2100 quota will be $105. 2) If a representative met or exceed their 2099 quota, increase their 2099 quota by ten percent to determine their new 2100 quota. For instance, if their 2099 quota was $100 their 2100 quota will be $110. 3) 2100 quotas are rounded to the next lowest $100. b. Federal 2099 Compensation Guidelines: Faade's sales representatives are entitled to the following net compensation: Income (percentage paid on sales) less taxes (fixed percentage of income). C. Anticipating you will encounter hard values that you want to avoid, you take action. 6. Without delay, you: a. Map out a new Compensation/Quota section on the worksheet b. Add Compensation Percentage, which is 12.3% and Fixed Taxes, which is 25.5%. c. Update this section with two labels: 2100 Quota % Increase, 5% and 10%. d. Include a Sales Cancellation Limit of 2% and a Quota Percent Limit of 100% 7. Now, you employ a complex single formula with appropriate cell referencing and operation controls to compute each representative's 2100 Sales Quota and 2099 Compensation. 8. The last portion of your worksheet recognizes a representatives' performance as well as training needs when warranted with the following categories: a. Outstanding Performance: A representative's performance is outstanding when Percentage of Quota is NOT less than the Quota Percent Limit of 100%. TRUE means Quota Percent Limit or greater. FALSE means less than the Quota Percent Limit. b. Superior Performance: A representative's superior performance is TRUE when Outstanding Performance is true AND Percent of Total Sales is less than the sales cancellation limit. C. Sales Training: A representative is selected for additional training when Outstanding Performance is not true OR Percent of Total Sales equal to or greater than the sales cancellation limit