Homework help_Customer Relationshttp://customwritings-us.com/orders.php


Homework help- http://customwritings-us.com/orders.php

Contact us: support@customwritings-us.com

Apply Your Knowledge Project 6

Customer Relations

Use the data file provided in this module to use PivotTables to provide data and recommendations to a restaurant distributor on ways to increase revenue and decrease expenses. Full assignment details can be provided on the Apply Your Knowledge Project 6 page. Once you have completed the assignment, submit your data file to the appropriate dropbox.

This project requires the use of PivotTables, a useful tool to help sort and analyze large quantities of unsorted data. Refer to the following documentation for help creating and manipulating PivotTables:

 

 

 

Note: This is an exception to the requirement of having the formulas in the Yellow cells. You may place your answer in the cells based on the information obtained in the required pivot tables.

Apply Your Knowledge Project 6

Customer Relations

Schweizer Distribution specializes in distributing fresh produce to local restaurants in the Chicago area. The company currently sells 12 different 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 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 relationships with its customers.

Bob has provided you with last year’s sales information in the data file provided. 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)?

Homework help- http://customwritings-us.com/orders.php

Contact us: support@customwritings-us.com

 

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: