Q$3$

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 region $($alphabetical$)$ and then sales volume $($largest to smallest$).(8$ points$)$

B $-$ Calculate what each salesperson's "New Customer Bonus" should be$.$ Salespeople with at least $12$ new customers should get a total bonus of $$36,000,$ salespeople with at least $9$ new customers but fewer than $12$ new customers should receive a bonus of $$11,000.$ Salespeople with fewer than $9$ new customers will not receive this bonus. $(10$ points$)$

C $-$ Calculate what each salesperson's "Sales Volume Bonus" should be$.$ Salespeople with sales volume of at least $$510,000$ should get a bonus of $$10,000.$ Salespeople with fewer sales will not receive this bonus. $(10$ points$)$

D $-$ Calculate the total number of new customers and the average sales volume for each region. $(6$ points each$)$

$\backslash$table$[[$Region$,$Manager,Name,$\backslash$table$[[$New$],[$Customers$]],\backslash$table$[[$Sales$],[$Volume$]],\backslash$table$[[$New$],[$Customer$],[$Bonus$]],\backslash$table$[[$Sales$],[$Volume$],[$Bonus$]]],[$Midwest$,$Jonathan Golden,Christopher Brown Jr$.,18,,1,070,000,,],[$Midwest$,$Noah Rodriguez,Jennifer Campbell,$15,950,000,,],[$Midwest$,$Jason Russell,Matthew Gates,$18,950,000,,],[$Midwest$,$Matthew Matthews,Laura Reyes,$15,940,000,,],[$Midwest$,$Noah Rodriguez,Richard Green,$18,940,000,,],[$Midwest$,$Michelle Mcbride,Timothy Martinez,$15,920,000,,],[$Midwest$,$Matthew Sanchez,Craig Shelton,$14,900,000,,],[$Midwest$,$Kim Mann,Erin Morris,$13,870,000,,],[$Midwest$,$Jonathan Golden,Dana Hart,$16,850,000,,],[$Midwest$,$Matthew Matthews,Michael Avila,$15,850,000,,],[$Midwest$,$Matthew Matthews,Debra Boyd,$12,850,000,,],[$Midwest$,$Jonathan Golden,Lauren Gonzales,$16,840,000,,],[$Midwest$,$Noah Rodriguez,Alicia Glenn,$10,830,000,,],[$Midwest$,$Kimberly Scott,Elaine Jones,$12,830,000,,],[$Midwest$,$Noah Rodriguez,Craig Becker,$14,820,000,,],[$Midwest$,$Kimberly Scott,Kristin Brown,$13,810,000,,],[$Midwest$,$Angela Davis,Ronald Roberts,$13,810,000,,],[$Midwest$,$Jonathan Golden,Glenn Martinez,$17,800,000,,],[$Midwest$,$Douglas Schwartz,Xavier Davis,$15,800,000,,]]$

$\backslash$table$[[$Region$,\backslash$table$[[$Total$],[$New$],[$Customers$]],\backslash$table$[[$Average$],[$Sales$],[$Volume$]]],[$Northeast$,,],[$South$,,],[$Midwest$,,],[$West$,,]]$

Please give the excel formulas