In the accompanying spreadsheet $1351$ HW$1.$xlsx$,$ on the worksheet labeled Problem $1,$ I

provide data on sixty salespeople in a small firm. They are identified by serial numbers in Column

B$,$ while their respective sales dollar amounts are shown in Column C$.$

As area sales manager, your task is to categorize these members of your team into three buckets

Fair, Good and Excellent based on their sales amounts. For this purpose, you need to:

a$)$ Determine cutoff sales amounts which will decide which category they fall into. These sales

amounts must be entered into cells H$5$:H$7($highlighted in yellow.$)$

b$)$ Determine which bucket each salesperson falls into based on the cutoffs you specified. Do

this in column D using the $=$IF$()$ function, column E using the $=$IFS$()$ function, and column

F using the $=$VLOOKUP$()$ function. Note that the results in columns D$,$ E and F must be

identical, for the assumed cutoff levels of sales.

c$)$ Having set up the categorization in a$)$ and b$),$ adjust your cutoffs such that the percentages of

salespeople $($of the total of $60)$ in each bucket are as close as possible to the desired

percentages shown in cells J$5$:J$7$