Who is bobs best customer by total sales

Assignment Help Business Management

Reference no: EM131299534

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

Pivot Table 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)?

Attachment:- Data.rar

Reference no: EM131299534

Questions Cloud

Monetary policies in the united states : What were some monetary policies in the United States during the 1950's? What impact did they have during that decade?

Discuss three methods for adding editable sound to the daw : Discuss three methods for adding editable sound to the DAW. What is "mastering," and how is it different from mixing? How recorded audio, sequencing, effects, mixing, and processing data are managed by the DAW.

Write an expression for the first four nonzero terms : Use the results in Figure 13-4 to calculate the Fourier coefficients of the full-wave rectified sine wave in Figure P13-13. Use MATLAB to verify your results. Write an expression for the first four nonzero terms in the Fourier series.

What are the labeling requirements required on each carton : You can place 9 cartons per layer on a pallet.- How many pallets do you need? What are the labeling requirements required on each carton?

Who is bobs best customer by total sales : 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?

Decrease corporate income tax rates : Suppose Congress votes to decrease corporate income tax rates. Use the AD/AS model to analyze the likely impact of the tax cuts on the macroeconomy. Show graphically and explain your reasoning. What exactly causes AD and/or AS to shift? What happe..

Differences between the two waveforms : Use MATLAB to plot two periods of the original signal and an estimate for the signal using the first four nonzero terms in the Fourier series. Comment on the differences between the two waveforms.

Identify the symmetry features of the waveform : Find the period and fundamental frequency in rad/s and Hz. Identify the harmonics present in the first five terms.

If there limits on type of actions government can take : Is it appropriate for the government, or in this case President-Elect Trump, to threaten and coerce U.S. companies to engage in certain actions? Why or why not?

User Account

All Pages