AYK14_Data_Version_1

Project 14: Customer Relations 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 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 year's sales information in the AYK14_Data.xlsx data file. Help Bob analyze his distribution company by using a PivotTable to determine the following: 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 best-selling 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 worst-selling product (by total profit)? 14. Who is the best sales representative's worst customer (by total profit)? Data file: AYK14_Data.xlsx DE F Name Schweitzer Distribution Analysis Question 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 profit? Who is Bob's worst customer by prof? What is Bob's best selling product by total sales? What is Bob's worst selling product by total sales? What is Bob's best selling product by profit? What is Bob's worst selling product by profit? Who is Bob's best sales representative by profit? Who is Bob's worst sales representative by 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 representatives warstaustomer lov totalfit? **Select the name using the drop down list Project 14: Customer Relations 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 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 year's sales information in the AYK14_Data.xlsx data file. Help Bob analyze his distribution company by using a PivotTable to determine the following: 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 best-selling 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 worst-selling product (by total profit)? 14. Who is the best sales representative's worst customer (by total profit)? Data file: AYK14_Data.xlsx DE F Name Schweitzer Distribution Analysis Question 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 profit? Who is Bob's worst customer by prof? What is Bob's best selling product by total sales? What is Bob's worst selling product by total sales? What is Bob's best selling product by profit? What is Bob's worst selling product by profit? Who is Bob's best sales representative by profit? Who is Bob's worst sales representative by 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 representatives warstaustomer lov totalfit? **Select the name using the drop down list