Open the Excel $5$ Assignment Template from Blackboard. Save the spreadsheet as

LastName$\_$FirstName$\_$Excel$5\_$xlsx and submit the completed spreadsheet to Blackboard before the due

date.

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 company$$s founder, Bob Schweizer, has recently hired you as a business analyst. You have

just graduated from college with a degree in marketing and 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 year$$s sales information in the Excel $5$ Assignment Template. Help

Bob analyze his distribution company by using PivotTables to determine the following questions.

$1.$ You must answer EACH question on page $2$ with a pivot table on the given worksheet tabs$.$

$($The tabs are named for you$).$ Failure to show each pivot table will result in a loss of points. Do NOT

copy and paste pivot tables. Do NOT re$-$arrange the worksheet tabs$.($See page $2)$

$2.$ Provide the answers generated from the pivot tables and type them on the Solution worksheet.

Make sure the answers you type in the Solutions worksheet are in the correct order. Do NOT change

the order on the Solutions worksheet.

$3.$ Pick one $(1)$ question and create a pivot chart based on the pivot table. $($Click on Analyze,

PivotChart and use the default chart provided by Excel$).$ Place the chart on the PivotChart worksheet

tab.

NOTE: I cannot grade this assignment if you $(1)$ copy and paste pivot tables; $(2)$ re$-$arrange the

worksheet tabs; $(3)$ change the order of the Solutions worksheet.

Page $2$ of $2$

Questions:

$1.$ Who is Bob$$s best customer by total sales?

$2.$ Who is Bob$$s worst customer by total sales?

$3.$ Who is Bob$$s best customer by total profit?

$4.$ Who is Bob$$s worst customer by total profit?

$5.$ What is Bob$$s best$-$selling product by total

sales?

$6.$ What is Bob$$s worst$-$selling product by total

sales?

$7.$ What is Bob$$s best$-$selling product by total

profit?

$8.$ What is Bob$$s worst$-$selling product by total

profit?

$9.$ Who is Bob$$s best sales representative by total

profit?

$10.$ Who is Bob$$s worst sales representative by total

profit?

$11.$ What is the best sales representative$$s bestselling product $($by total profit$)?$

$12.$ Who is the best sales representative$$s best

customer $($by total profit$)?$

$13.$ What is the best sales representative$$s worstselling product $($by total profit$)?$

$14.$ Who is the best sales representative$$s worst

customer $($by total profit$)$