User Account

All Pages

About the customer relations

Assignment Help Operation Management
Reference no: EM131714813

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:

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 total profit?

Who is Bob's worst customer by total profit?

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 total profit?

What is Bob's worst-selling product by total profit?

Who is Bob's best sales representative by total profit?

Who is Bob's worst sales representative by total 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 representative's worst customer (by total profit)?

Reference no: EM131714813

Questions Cloud

About is the one between myself and the firm owners : As a top executive, the only agency relationship I am concerned about is the one between myself and the firm’s owners.
Find ways to promote job satisfaction : You also have to be aware of organizational behavior and find ways to promote job satisfaction, increase morale, and motivate the employees.
Likely to arise between owners and managers : Discuss the incentive conflicts that are likely to arise between owners and managers of a restaurant.
Accomplish with the great game of life program : What is Eitel attempting to accomplish with the “Great Game of Life” (GGOL) program? What is the premise of GGOL?
About the customer relations : Schweizer Distribution specializes in distributing fresh produce to local restaurants in the Chicago area. Who is Bob's worst customer by total sales?
Explain the antikickback and antireferral statutes : Explain the Antikickback and Antireferral statutes. Provide an example for each.
Most lean adherents warn against running out and buying such : Most lean adherents warn against running out and buying such. Why? What all should you do before buying?
Health care professionals in presence of competitive market : How do healthcare organizations recruit and retain health care professionals in the presence of a competitive market?
How many months worth of inventory does the company have : A company reported 40 units sold in 2009. At the end of 2009, How many months worth of inventory does the company have?

Reviews

Write a Review

Operation Management Questions & Answers

  Create a payoff table and a decision tree

Create a payoff table and a decision tree for this situation. Calculate the best options using maximax, maximin, and equal likelihood criteria (ignoring the probabilities), and then calculate the expected value for each situation. Which choice sho..

  Calculate the range of the data in module assignment five

Calculate the Range of the data in Module Assignment Five. Calculate the Sample Standard Deviation of the data in Module Assignment Five.

  How will you place and connect the hardware

What are the physical locations where workstations, printers, servers, and other hardware will be installed? How will you provide users enough information about the system being installed to gain their confidence?

  Important elements of the governing board

1.Describe the five (5) important elements of the governing board' s agenda for areas of improvement in core functions

  Discuss the need for organisations to realign

Discuss the need for organisations to realign their choices in response to changing customer requirements making reference to at least one case covered in class.

  Ability to modify the usa patriot act

Pretend you have the ability to modify the USA PATRIOT Act in any way you want. Describe the change(s) you would make. Support your changes with sound reasoning.

  Expected demand for implants during lead time

Expected demand for implants during lead time is ten units and the management keeps a safety stock level of twenty units, the ROP would be thirty units.

  Significant impact on the average profitability of firms

Government policies can have a significant impact on the average profitability of firms in an industry. Government, however, is not included as a potential threat in the five forces model. Should the model be expanded to include government (to make a..

  In healthcare delivery environment

In a healthcare delivery environment, how does one re-define changes in business relationships and improve functionality?

  In response to variety of expected environmental changes

In response to a variety of expected environmental changes in your industry, your business has decided to change its organizational structure to be more consistent with a new strategy for increased competitiveness. They plan to move from a mechanisti..

  Some query objectives and reports and forms of interest

Write a Narrative describing a salon’s business processes, some query objectives, reports and forms of interest,

  Creating shared meaning with the receiver of message

Creating shared meaning with the receiver of a message is what organizational communication is all about. Choose and respond to ONE of the following statements below. Explain whether you agree or disagree. Describe how a different perspective from so..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd