Question
How can I get these answers based on the excel sheet. Which salesperson performed the best, in terms of (a) number of new clients; (b)
How can I get these answers based on the excel sheet.
- Which salesperson performed the best, in terms of (a) number of new clients; (b) total sales; and (c) average investment per new client? Who performed the worst on each of these criteria? Note their 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 percentage outperformance or underperformance relative to his or her 2016-17 sales target? Who performed the worst? Note their names and percentage outperformance or underperformance.
|
| Name | Percentage of Target |
| Best performer | Florio, Ismail, Kennedy |
|
| Worst performer | Warren, Vitelloni, Mancini, Houtz, |
|
| SALESPERSON | 2016 SALES TARGET | 2016 NEW CLIENTS | 2016 NEW SALES |
| Almeida | 215000 | 15 | 212723 |
| Anderson | 170000 | 16 | 171616 |
| Ball | 155000 | 13 | 153201 |
| Ballestero | 125000 | 12 | 124904 |
| Barrio | 215000 | 15 | 213756 |
| Billimoria | 65000 | 5 | 66519 |
| Budge | 185000 | 14 | 183450 |
| Cohen | 95000 | 10 | 96370 |
| Curtin | 185000 | 15 | 183008 |
| Drew | 185000 | 12 | 186783 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advances In Databases 28th British National Conference On Databases Bncod 28 Manchester Uk July 2011 Revised Selected Papers Lncs 7051
Authors: Alvaro A.A. Fernandes ,Alasdair J.G. Gray ,Khalid Belhajjame
2011th Edition
3642245765, 978-3642245763
