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.

  1. 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)

  1. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Jack Tasker opened his Auto Repair Shop in November 2020. The balance sheet at November 30, 2020, prepared by an inexperienced part-time bookkeeper, is shown below. Required Prepare a correct balance...

Q:

3. Here is the question all about excel! In 2016-17, the firm employed 68 salespeople. The attached spreadsheet provides information on their 2016-17 sales targets, new client accounts, and total...

Q:

Sales $7,642 $6,262 $9,432 $7,498 $4,369 $3,020 $3,877 $6,061 $6,981 $8,681 $9,121 $8,758 $3,986 $7,390 $6,685 $7,498 $9,248 $6,326 $11,221 $11,146 $4,670 $6,312 $9,990 $7,515 $9,332 $3,390 $7,451...

Q:

Would you be able to put together another monthly cash flow analysis, this time for year 1? INCOME STATEMENT Year 1 269,115.00 48,930.00 20,388.00 338,433.00 $ $ $ $ COGS $ 113,940.00 $ 125,940.00 $...

Q:

Need stakeholder analysis, swot analysis and pestle analysis for the below case study- Bella Beverages Inc. 1 Bella Beverages Inc. Overview Bella Beverages Inc. (BB) is a Canadian company traded on...

Q:

Attached, kindly find SNHU Course material for QSO-320 Management Science Spreadsheet Management - Milestone Four. Thank you! QSO 320 Final Project Guidelines and Rubric Overview The final project...

Q:

SynthesisProject1 Creating an order form in Excel Skills Required (all are covered in Modules 1-3): General spreadsheet layout and formatting VLOOKUP Simple IF function Conditional formatting Simple...

Q:

Overview Nineteen67apparel is an apparel e-commerce company in London Ontario. This town is heavily populated with university students and young professionals, the total population of university...

Q:

Customer Metrics Google Sheets Tutorial Customer Analytics - Professor Atlas Objectives of Today's Session - Introduction to Google Sheets: orientation, formulas, cell references - Calculate common...

Q:

please use excel with tje formulas to how to do it on excel Screens Tops Screenshot Tops, Inc. The Business Situation After graduating with a degree in business from Rural College in Campus Town,...

Q:

In March 1991, Russ Lesser, president of Body Glove, a small wetsuit manufacturer, reviewed the progress his company had made, as well as the problems it had encountered, in the nine months he had...

Q:

You are trying to purify a protein that is soluble in a solution of 2 M ammonium sulfate. After centrifugation to remove other proteins that have precipitated at this high salt concentration, you...

Q:

A 1200 hp dragster engine has a drive shaft rotating at 2000 RPM. How much torque is on the shaft?

Q:

When preparing 1 0 9 9 s in QuickBooks, you need to check your client s company details. What should appear in the Company legal name field in the 1 0 9 9 workflow?

Q:

Assume that you buy 2 shares of Facebook Inc. at $220 per share, putting up a 50% margin. i) How much equity funds do you need to provide to make this margin transaction? What is the borrowed amount...

Q:

Trade unions. Some enterprises may view the increasing influence of trade unions as a problem, with trade unionists seeing the future of trade unions as uncertain.

Q:

Attempts to address over-staffing through various methods which did not reflect future skills and operational needs have highlighted the need to develop other methods of human resource planning.

Q:

a high level of employee turnover and absenteeism and a lack of identification with hard work;