Schweizer Distribution specializes in distributing fresh produce to local restaurants in the

Chicago area. The company currently sells $12$ products through the efforts of three sales

representatives to $10$ restaurants. The company, like all small businesses, is always interested

in finding ways to increase revenues and decrease expenses. The companys founder, Bob

Schweizer, has recently hired you as a business analyst. You have just graduated from

college with a degree in marketing and a specialization in customer relationship management.

Bob is eager to hear your thoughts and ideas on how to improve the business and help the

company build strong lasting relationships with its customers. Bob has provided you with last

years sales information in the datasheet file provided. Help Bob analyze his distribution

company by using a PivotTable to determine the following:

$1.$ Who is Bobs best customer by total sales?

$2.$ Who is Bobs worst customer by total sales?

$3.$ Who is Bobs best customer by total profit?

$4.$ Who is Bobs worst customer by total profit?

$5.$ What is Bobs best$-$selling product by total sales?

$6.$ What is Bobs worst$-$selling product by total sales?

$7.$ What is Bobs best$-$selling product by total profit?

$8.$ What is Bobs worst$-$selling product by total profit?

$9.$ Who is Bobs best sales representative by total profit?

$10.$ Who is Bobs worst sales representative by total profit?

$11.$ What is the best sales representatives best$-$selling product $($by total profit$)?$

$12.$ Who is the best sales representatives best customer $($by total profit$)?$

$13.$ What is the best sales representatives worst$-$selling product $($by total profit$)?$

$14.$ Who is the best sales representatives worst customer $($by total profit