(Solved) : Get Answers Based Excel Sheet Salesperson Performed Best Terms Number New Clients B Total Q43918680 . . .
How can I get these answers based on the excel sheet.
- Which salesperson performed the best, in terms of (a) number ofnew clients; (b) total sales; and (c) average investment per newclient? Who performed the worst on each of these criteria? Notetheir names and their performance (# or $).
New clients
Total sales
Average investment / client
Best performer
Lessig, Marcos (17)
Ismail (232449)
Worst performer
Houtz (1)
Warren (18025)
- Which salesperson performed the best, on percentageoutperformance or underperformance relative to his or her 2016-17sales target? Who performed the worst? Note their names andpercentage outperformance or underperformance.
Name
Percentage of Target
Best performer
Florio, Ismail, Kennedy
Worst performer
Warren, Vitelloni, Mancini, Houtz,
SALESPERSON2016 SALES TARGET2016 NEW CLIENTS2016 NEW SALESAlmeida21500015212723Anderson17000016171616Ball15500013153201Ballestero12500012124904Barrio21500015213756Billimoria65000566519Budge18500014183450Cohen950001096370Curtin18500015183008Drew18500012186783
Expert Answer
Answer to How can I get these answers based on the excel sheet. Which salesperson performed the best, in terms of (a) number of ne…
OR