Excel 2019 Skills Approach - Ch 6 Challenge Yourself 6.3 >Computer science

profilefmarti51
Freddie.Martinez-EX2019-ChallengeYourself-6-3.xlsx

Summary

National Pharmaceutical Sales
Sales Summary
Average Median Standard Deviation
Annual Sales
Commission Earned
Sales Summary by Region
NE1 SE2 SW1 SE1 SW2 NW1 NE2 NW2
Total
Average
Enter the sales associate's last name and annual sales target in the cells below
If no choices are entered, the table below displays company-wide data
Sales Associate's Last Name Annual Sales
Average Commission Earned
Total Commission Earned
Number of Clients with Annual Sales Reaching Target
AnnualSales ='Sales Data'!$E$4:$E$64
CommissionEarned ='Sales Data'!$G$4:$G$64
Earnings ='Sales Data'!$A$3:$I$64
Regions ='Sales Data'!$C$4:$C$64

Sales Data

National Pharmaceutical Sales
Sales Associate's Last Name Sales Associate's First Name Sales Associate's ID Client Annual Sales Commission Rate Commission Earned Salary Total Earnings Region
Ahjab Raminian NE1-73647 Garden State Pharmacies 78,133 55,000 55,000
Ahjab Raminian NE1-217199 MA OBGyn Associates 230,427
Ahjab Raminian NE1-247543 MD Dental Associates 262,620
Ahjab Raminian NE1-235322 New England Pharmacies, Inc. 249,654
Ahjab Raminian NE1-213262 New England Physicians, Inc. 226,250
Ahjab Raminian NE1-219129 PA Medical Practices, Inc. 232,475
Anderson Cynthia SE2-80660 Low County Medical Associates, Inc. 85,573 51,000 51,000
Anderson Cynthia SE2-231417 NC Medical Associates 245,511
Anderson Cynthia SE2-189894 Orthopaedic Medical Associates 201,459
Anderson Cynthia SE2-87721 Palmetto Physicans 93,064
Anderson Cynthia SE2-153666 Palmetto Podiatrists, Inc. 163,025
Anderson Cynthia SE2-117771 Piedmont Health Associates, Inc. 134,945
Anderson Cynthia SE2-81906 SC Medical Associates 86,895
Anderson Cynthia SE2-115585 Upstate Pharmacies, Inc. 132,625
Anderson George SW1-137004 AZ Ambulatory Care 145,349 60,000 60,000
Anderson George SW1-149663 CA Chiropractic Associates, Inc. 158,778
Anderson George SW1-82895 Emergency Medicine Association 87,944
Anderson George SW1-183010 Joint Healthcare Associates 194,157
Anderson George SW1-150820 NM Pharmacies, Inc. 160,006
Anderson George SW1-126767 Southwest Dermatology 134,489
Anderson George SW1-248636 Southwest Medical Associates 263,779
Anderson George SW1-186345 Tri-state Pharmacies 197,695
Brown Tatisha SE1-230271 Bama Chiropractic Clinics, Inc. 244,296 50,000 50,000
Brown Tatisha SE1-119903 Gerontology Associates of MS 127,207
Brown Tatisha SE1-253055 Internal Medicine of MS 268,467
Brown Tatisha SE1-132658 LA Cardiologists, Inc. 140,738
Brown Tatisha SE1-77149 Louisiana Dermatologists, Inc. 81,848
Brown Tatisha SE1-157263 MS Women's Clinics, Inc. 166,841
Brown Tatisha SE1-230063 Physicians of MS, Inc. 244,074
Brown Tatisha SE1-151999 Women's Medicine of FL, Inc. 161,256
Johansen Jan SW2-214933 Ambulatory Care of TX, Inc. 228,023 62,000 62,000
Johansen Jan SW2-94637 CO Pharmacies, Inc. 99,402
Johansen Jan SW2-92179 EMTS of CO, Inc. 97,794
Johansen Jan SW2-194117 Lone Star Medicine 205,940
Johansen Jan SW2-140911 Nephrology Associates, Inc. 149,494
Johansen Jan SW2-202653 NV Emergency Medical Associates, Inc. 214,995
Johansen Jan SW2-175034 OK Clinics 185,695
Johansen Jan SW2-226564 Pharmacies of Nevada, Inc. 240,362
Johansen Jan SW2-68539 TEX-MEX Pharmacies, Inc. 72,714
Lopez Julieta NW1-176917 OBGyn Associates of Montana, Inc. 187,692 55,000 55,000
Lopez Julieta NW1-207538 Oregon Opthamology, Inc. 220,178
Lopez Julieta NW1-73903 Orthodontial, Inc. 78,405
Lopez Julieta NW1-173347 Seattle Psychiatric Associates, Inc. 183,905
Lopez Julieta NW1-198233 Seattle Psychologists, Inc. 210,306
Lopez Julieta NW1-218623 Utah Urology Associates, Inc. 231,938
Lopez Julieta NW1-245472 Washington Physicians, Inc. 260,423
Quarles Marques NE2-69555 Baltimore Bariatrics, Inc. 73,792 58,000 58,000
Quarles Marques NE2-175858 Connecticut Pulmonary Associates, Inc. 186,569
Quarles Marques NE2-150501 DC Dialysis 159,668
Quarles Marques NE2-123129 Delaware Dental Associates 130,628
Quarles Marques NE2-192148 Maine Medical Associates, Inc. 203,851
Quarles Marques NE2-149537 Maryland Pharmacies, Inc. 158,645
Quarles Marques NE2-177202 Rhode Island Gastroenterology, Inc. 187,995
Schmidt Matthew NW2-210844 Bellevue Bariatics, Inc. 223,686 55,000 55,000
Schmidt Matthew NW2-213043 Boise Oncology 226,019
Schmidt Matthew NW2-186063 Casper Cardiology, Inc. 197,395
Schmidt Matthew NW2-149341 Cheyenne Cardiologists, Inc. 158,437
Schmidt Matthew NW2-234369 ID Internal Medicine Associates 248,644
Schmidt Matthew NW2-146676 Laramie EMTs, Inc. 155,610
Schmidt Matthew NW2-255982 WY OBGyn, Inc. 271,572
Schmidt Matthew NW2-80590 Wyoming Health Care, Inc. 85,499