The table below shows the sales data for all the salespeople at Oscorp Industries last
year, including the region they work in, their manager, their name, the number of
new customers they acquired last year, and their total sales volume.
A - Sort the data by sales volume (largest to smallest).
B - Calculate what each salesperson's "New Customer Bonus" should be. Salespeople
with at least 8 new customers should get a total bonus of $12,500, salespeople with
at least 2 new customers but fewer than 8 new customers should receive a bonus of
$3,000. Salespeople with fewer than 2 new customers will not receive this bonus.
C - Calculate what each salesperson's "Sales Volume Bonus" should be. Salespeople
with sales volume of at least $520,000 should get a bonus of $6,000. Salespeople
with fewer sales will not receive this bonus.
D - Calculate the total number of new questions and the average sales volume for each
manager.

22 23 24 25 26 Gridlines AB 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 D Manager South Heidi Hicks Northeast Anthony Phillips South Heidi Hicks Northeast Ruben Smith South Jordan Juarez Midwest Derek Campbell South Patrick Stone Northeast Karina Cooper West Christine Hull Northeast Sean Romero Patrick Stone South West Christine Hull West Heather Scott Northeast Robert Bryant Northeast Megan Williams Northeast Sydney Miller Midwest Ricky Henderson West Jacqueline Powell Northeast Sean Romero Midwest Tammie Murray Midwest Dustin Calhoun Midwest Ricky Henderson Northeast Mitchell Austin South Meredith Smith West James Roberts Midwest Cynthia Pena Northeast Sean Romero West Shirley Young Northeast Sydney Miller West Donna Taylor Northeast Adriana Lewis Northeast Adriana Lewis Midwest Katherine Munoz West William Wallace C Region E Name Lindsey Mendoza Julia Barnes Mitchell Newman Noah Rodriguez Johnny Campbell Charles Sims Joseph Williams David Martin Kimberly Duncan Jamie Garza Angela Rodriguez Douglas Banks Carlos Lewis Jesse Williams Lisa Woodward Edward Matthews Karen Thompson Eileen Mcbride Howard Alvarado Brenda Drake Jacqueline Brooks Kimberly Gardner John Chan Miss Jacqueline Ford Jason Russell Paul Yates Kelly Johnson Kaitlyn Gordon John Garcia Alyssa Solis Todd Christian Jr. Lindsey Lowe Katherine Garcia Michelle Mcbride. Leah Directions 91 92 F G New Sales Customers Volume 3260,000 3 110,000 8 350,000 8 440,000 6 410,000 9 420,000 7 370,000 11 660,000 9 550,000 0 120,000 3 490,000 7 280,000 70,000 0 5 310,000 10 660,000 6 520,000 4 280,000 13 740,000 9 680,000 400,000 8 6 370,000 6 400,000 5 Y 380,000 8 380,000 9540,000 1 170,000 3400,000 7 660,000 0 60,000 560,000 8 2 X 90.000 9 470,000 4 X 260,000 3 330,000 a VERA Ana H New Customer Bonus I Sales Volume Bonus J K Manager Adriana Lewis Anthony Phillips Anthony Wise Bethany Bennett Brian Carrillo Brian George Carolyn Thomas Catherine Yates Charles Schroeder Cheryl Hamilton Christine Hull Christopher Guerrero Courtney King Cynthia Pena Daniel Stanley David Bailey Derek Campbell Donna Taylor Dustin Calhoun Erin Hanna Heather Scott Heidi Hicks Jacqueline Powell James Roberts Jennifer Proctor Jerry Richardson Jesse Wu Jordan Juarez Karina Cooper Katherine Munoz Megan Williams Meredith Smith Michael Goodwin Mitchell Austin Dakila L Total New Customers M Average Sales Volume 22 23 24 25 26 Gridlines AB 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 D Manager South Heidi Hicks Northeast Anthony Phillips South Heidi Hicks Northeast Ruben Smith South Jordan Juarez Midwest Derek Campbell South Patrick Stone Northeast Karina Cooper West Christine Hull Northeast Sean Romero Patrick Stone South West Christine Hull West Heather Scott Northeast Robert Bryant Northeast Megan Williams Northeast Sydney Miller Midwest Ricky Henderson West Jacqueline Powell Northeast Sean Romero Midwest Tammie Murray Midwest Dustin Calhoun Midwest Ricky Henderson Northeast Mitchell Austin South Meredith Smith West James Roberts Midwest Cynthia Pena Northeast Sean Romero West Shirley Young Northeast Sydney Miller West Donna Taylor Northeast Adriana Lewis Northeast Adriana Lewis Midwest Katherine Munoz West William Wallace C Region E Name Lindsey Mendoza Julia Barnes Mitchell Newman Noah Rodriguez Johnny Campbell Charles Sims Joseph Williams David Martin Kimberly Duncan Jamie Garza Angela Rodriguez Douglas Banks Carlos Lewis Jesse Williams Lisa Woodward Edward Matthews Karen Thompson Eileen Mcbride Howard Alvarado Brenda Drake Jacqueline Brooks Kimberly Gardner John Chan Miss Jacqueline Ford Jason Russell Paul Yates Kelly Johnson Kaitlyn Gordon John Garcia Alyssa Solis Todd Christian Jr. Lindsey Lowe Katherine Garcia Michelle Mcbride. Leah Directions 91 92 F G New Sales Customers Volume 3260,000 3 110,000 8 350,000 8 440,000 6 410,000 9 420,000 7 370,000 11 660,000 9 550,000 0 120,000 3 490,000 7 280,000 70,000 0 5 310,000 10 660,000 6 520,000 4 280,000 13 740,000 9 680,000 400,000 8 6 370,000 6 400,000 5 Y 380,000 8 380,000 9540,000 1 170,000 3400,000 7 660,000 0 60,000 560,000 8 2 X 90.000 9 470,000 4 X 260,000 3 330,000 a VERA Ana H New Customer Bonus I Sales Volume Bonus J K Manager Adriana Lewis Anthony Phillips Anthony Wise Bethany Bennett Brian Carrillo Brian George Carolyn Thomas Catherine Yates Charles Schroeder Cheryl Hamilton Christine Hull Christopher Guerrero Courtney King Cynthia Pena Daniel Stanley David Bailey Derek Campbell Donna Taylor Dustin Calhoun Erin Hanna Heather Scott Heidi Hicks Jacqueline Powell James Roberts Jennifer Proctor Jerry Richardson Jesse Wu Jordan Juarez Karina Cooper Katherine Munoz Megan Williams Meredith Smith Michael Goodwin Mitchell Austin Dakila L Total New Customers M Average Sales Volume