skill review EXCEL

1

2

3

4

5

6

7

8

9

10

11

12

13

18

22

25

31

39

48

58

68

77

87

A B C D E F G

Annual Sales

SW2 1,125,667

SW1 851,283

NE2 1,102,101

SE1 1,272,386

NW2 1,256,707

NE1 875,800

SE2 1,025,987

NW1 634,728

First Name Last Name Region Client Annual Sales

Commission

Rate

Commission

Earned

Ahjab Total 8,813.70

Quarles Total 15,338.58

Ahjab Total 4,443.32

Quarles Total 45,883.74

Lopez Total 12,694.56

Schmidt Total 51,755.60

Brown Total 41,129.56

Zhu Total 29,906.82

Anderson Total 19,880.34

Johansen Total 31,768.18

Sales by Region

Sales by Sales Associate

Analysis

SOLUTION SAMPLE

1

2

3

8

12

15

21

29

38

48

58

67

77

78

A B C D E F G

First Name Last Name Region Client Annual Sales

Commission

Rate

Commission

Earned

Ahjab Total 8,813.70

Quarles Total 15,338.58

Ahjab Total 4,443.32

Quarles Total 45,883.74

Lopez Total 12,694.56

Schmidt Total 51,755.60

Brown Total 41,129.56

Zhu Total 29,906.82

Anderson Total 19,880.34

Johansen Total 31,768.18

Grand Total 261,614.40

National Pharmaceutical Sales

Sales Data

SOLUTION SAMPLE

1

2

3

4

5

6

7

22

28

39

44

52

58

71

A B C D E F G

First Name Last Name Region Client Annual Sales

Commission

Rate

Commission

Earned

George Anderson >110000

Xin Zhu >110000

First Name Last Name Region Client Annual Sales

Commission

Rate

Commission

Earned

George Anderson SW1 Emergency Medicine Association 121,252 2% 2,425.04

George Anderson SW1 Joint Healthcare Associates 142,734 4% 5,709.36

Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08

George Anderson SW1 NM Pharmacies, Inc. 115,975 2% 2,319.50

Xin Zhu SE2 Palmetto Physicans 165,700 4% 6,628.00

Xin Zhu SE2 SC Medical Associates 115,272 2% 2,305.44

Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08

National Pharmaceutical Sales

Sales Data Filter

SOLUTION SAMPLE

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

A B C D E F G H

First Name Last Name Region Client Annual Sales

Commission

Rate

Commission

Earned Rating

Marques Quarles NE2 Baltimore Bariatrics, Inc. 300,708 6% 18,042.48

Marques Quarles NE2 Delaware Dental Associates 215,609 6% 12,936.54

Marques Quarles NE2 Maryland Pharmacies, Inc. 209,708 6% 12,582.48

Matthew Schmidt NW2 Casper Cardiology, Inc. 207,555 6% 12,453.30

Matthew Schmidt NW2 Laramie EMTs, Inc. 201,211 6% 12,072.66

Raminian Ahjab NE1 Garden State Pharmacies 122,222 2% 2,444.44

Raminian Ahjab NE1 MA OBGyn Associates 128,979 2% 2,579.58

Raminian Ahjab NE2 MD Dental Associates 133,288 2% 2,665.76

Raminian Ahjab NE1 New England Pharmacies, Inc. 91,995 2% 1,839.90

Raminian Ahjab NE1 New England Physicians, Inc. 97,489 2% 1,949.78

Raminian Ahjab NE2 PA Medical Practices, Inc. 88,878 2% 1,777.56

George Anderson SW1 AZ Ambulatory Care 91,222 2% 1,824.44

George Anderson SW1 CA Chiropractic Associates, Inc. 107,373 2% 2,147.46

George Anderson SW1 Emergency Medicine Association 115,609 2% 2,312.18

George Anderson SW1 Joint Healthcare Associates 142,734 4% 5,709.36

George Anderson SW1 NM Pharmacies, Inc. 115,975 2% 2,319.50

George Anderson SW1 Southwest Dermatology 108,277 2% 2,165.54

George Anderson SW1 Southwest Medical Associates 82,651 2% 1,653.02

George Anderson SW1 Tri-state Pharmacies 87,442 2% 1,748.84

Tatisha Brown SE1 Bama Chiropractic Clinics, Inc. 157,721 4% 6,308.84

Tatisha Brown SE1 Bama Chiropractic Clinics, Inc. 153,211 4% 6,128.44

Tatisha Brown SE1 Gerontology Associates of MS 127,555 2% 2,551.10

Tatisha Brown SE1 Internal Medicine of MS 169,272 4% 6,770.88

Tatisha Brown SE1 LA Cardiologists, Inc. 162,777 4% 6,511.08

Tatisha Brown SE1 Louisiana Dermatologists, Inc. 118,118 2% 2,362.36

Tatisha Brown SE1 MS Women's Clinics, Inc. 133,288 2% 2,665.76

Tatisha Brown SE1 Physicians of MS, Inc. 141,111 4% 5,644.44

Tatisha Brown SE1 Women's Medicine of FL, Inc. 109,333 2% 2,186.66

Jan Johansen SW2 Ambulatory Care of TX, Inc. 176,208 4% 7,048.32

Jan Johansen SW2 CO Pharmacies, Inc. 106,266 2% 2,125.32

Jan Johansen SW2 EMTS of CO, Inc. 152,686 4% 6,107.44

Jan Johansen SW2 Lone Star Medicine 133,991 2% 2,679.82

National Pharmaceutical Sales

Commissions

SOLUTION SAMPLE

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

A B C D E F G H

Jan Johansen SW2 Nephrology Associates, Inc. 87,556 2% 1,751.12

Jan Johansen SW2 NV Emergency Medical Associates, Inc. 114,111 2% 2,282.22

Jan Johansen SW2 OK Clinics 105,767 2% 2,115.34

Jan Johansen SW2 Pharmacies of Nevada, Inc. 115,234 2% 2,304.68

Jan Johansen SW2 TEX-MEX Pharmacies, Inc. 153,848 4% 6,153.92

Julieta Lopez NW1 OBGyn Associates of Montana, Inc. 88,888 2% 1,777.76

Julieta Lopez NW1 Oregon Opthamology, Inc. 96,606 2% 1,932.12

Julieta Lopez NW1 Orthodontial, Inc. 83,363 2% 1,667.26

Julieta Lopez NW1 Seattle Psychiatric Associates, Inc. 97,443 2% 1,948.86

Julieta Lopez NW1 Seattle Psychologists, Inc. 97,002 2% 1,940.04

Julieta Lopez NW1 Utah Urology Associates, Inc. 82,319 2% 1,646.38

Julieta Lopez NW1 Washington Physicians, Inc. 89,107 2% 1,782.14

Marques Quarles NE1 Connecticut Pulmonary Associates, Inc. 103,301 2% 2,066.02

Marques Quarles NE2 DC Dialysis 162,202 4% 6,488.08

Marques Quarles NE1 Maine Medical Associates, Inc. 165,907 4% 6,636.28

Marques Quarles NE1 Maine Medical Associates, Inc. 165,907 4% 6,636.28

Marques Quarles NE2 Rhode Island Gastroenterology, Inc. 91,708 2% 1,834.16

Matthew Schmidt NW2 Bellevue Bariatics, Inc. 152,101 4% 6,084.04

Matthew Schmidt NW2 Boise Oncology 108,878 2% 2,177.56

Matthew Schmidt NW2 Cheyenne Cardiologists, Inc. 114,411 2% 2,288.22

Matthew Schmidt NW2 ID Internal Medicine Associates 185,272 4% 7,410.88

Matthew Schmidt NW2 WY OBGyn, Inc. 176,168 4% 7,046.72

Matthew Schmidt NW2 Wyoming Health Care, Inc. 111,111 2% 2,222.22

Xin Zhu SE2 Low County Medical Associates, Inc. 82,625 2% 1,652.50

Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08

Xin Zhu SE2 Orthopaedic Medical Associates 87,773 2% 1,755.46

Xin Zhu SE2 Palmetto Physicans 165,700 4% 6,628.00

Xin Zhu SE2 Palmetto Podiatrists, Inc. 82,935 2% 1,658.70

Xin Zhu SE2 Piedmont Health Associates, Inc. 98,333 2% 1,966.66

Xin Zhu SE2 SC Medical Associates 115,272 2% 2,305.44

Xin Zhu SE2 Upstate Pharmacies, Inc. 89,695 2% 1,793.90

Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08

Commissions

SOLUTION SAMPLE

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

A B C D E F G H

Row Labels Sum of Annual Sales Sum of Commission Earned Average Commission

Lopez 634,728$ 12,695$ 2.00%

OBGyn Associates of Montana, Inc. 88,888$ 1,778$ 2.00%

Oregon Opthamology, Inc. 96,606$ 1,932$ 2.00%

Orthodontial, Inc. 83,363$ 1,667$ 2.00%

Seattle Psychiatric Associates, Inc. 97,443$ 1,949$ 2.00%

Seattle Psychologists, Inc. 97,002$ 1,940$ 2.00%

Utah Urology Associates, Inc. 82,319$ 1,646$ 2.00%

Washington Physicians, Inc. 89,107$ 1,782$ 2.00%

Grand Total 634,728$ 12,695$ 2.00%

Region

NE1

NE2

NW1

NW2

SE1

SE2

SW1

SW2

PivotTable

SOLUTION SAMPLE

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

A B C D E F G H I J K L M

Row Labels Sum of Annual Sales

Lopez 634,728$

Schmidt 1,256,707$

Grand Total 1,891,435$

34%

66%

Total

Lopez

Schmidt

Last Name

Sum of Annual Sales Region

NE1

NE2

NW1

NW2

SE1

SE2

SW1

SW2

PivotChart

SOLUTION SAMPLE