As you know from a previous assignment, Schweiser Distribution specializes in distributing fresh produce to local restaurants in the Chicago area. The company still sells $12$ different products through the efforts of three sales representatives to $10$ restaurants. The company is interested in finding ways to increase revenues and decrease expenses.

The company's founder, Bob Schweiser, has provided you with last year's sales information in a data file. Calculate the missing information, and help Bob analyze his distribution company by using a PivotTable to determine the following:

Who is Bob's best customer by total sales?

Who is Bob's worst customer by total sales?

Who is Bob's best customer by total profit?

Who is Bob's worst customer by total profit?

Who is Bob's best$-$selling product by total sales?

What is Bob's worst best$-$selling product by total sales?

What is Bob's best$-$selling product by total profit?

What is Bob's worst$-$selling product by total profit?

Who is Bob's best sales representative by total profit?

Who is Bob's worst sales representative by total profit?

What is the best sales representative's best$-$selling product $($by total profit$)?$

Who is the best sales representative's best customer $($by total profit$)?$

What is the best sales representative's worst$-$selling product $($by total profit$)?$

Who is the best sales representative's worst customer $($by total profit$)?$