Table $4$ contains information on revenue earned from new and existing customers for three sales reps in the Fastenal sales office last quarter as well as for the sales team overall.

Table $4$

Revenue from New and Existing Customers

Sales Rep Revenue $-$ New Customers Revenue $-$ Existing Customers $\%$ Revenue from New Customers $\%$ Revenue from Existing Customers

Allison $$66,000$ $$320,00021\%$

Brian $$70,000$ $$328,00021\%$

Oscar $$82,000$ $$315,00026\%$

Total Sales Team $$218,000$ $$963,00023\%$

$7.$ What is the $\%$ revenue from new customers and existing customers for each sales rep and for the sales team? Calculate in Table $4.(3$ points$)$

$8.$ Alan, Fastenal sales manager, reviewed the information you calculated in Q$7.$ Give Alan an overview of each rep's performance in generating revenue from new and existing customers compared to the performance of the sales team overall. Enter answer in space below. $(3$ points$)$

Q$8$ ANSWER: