AYK Project $-$ Customer Relations Analysis

Case Study:

Schweizer Distribution specializes in distributing fresh produce to local restaurants in the Chicago area. The company currently sells $12$ different products through the effort of three sales representatives to $10$ restaurants. The company, like all smali businesses, is always interested in finding ways to increase revenues and decrease expenses.

The company's founder, Bob schweizer, has recently hired you as a new 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 reiationships with its customers.

Bob has provided you with last year's saies information in an Excel file. Help Bob analyze his distribution company by creating Excel Pivotrabies to answer the questions below. You may combine multiple pieces of information on one PivotTable but you may need to create multipie PivotTobles to easily and quickly find the answers.

Who is Bab's best customer by total cales?

Who is Bob's worst customer by total sales

Who is Bob's best customer by profit?

Who is Bob's worst customer by profit?

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

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

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

$/.$ What is Rob's worst selling product by profit?

Who is Bob's best saies representative by profit?

Who is $BC{b}^{\text{'}}s$ worst sales representative by profit?

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

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

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

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