each worksheet should have the pivot table and the pivot table fields please and thank you!

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 chang? 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. 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 chang? 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