What is bob best-selling product by total sales

Assignment Help Management Information Sys

Reference no: EM131127608

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

Attachment:- Data.rar

Reference no: EM131127608

Questions Cloud

What is the minimum price of the bond : M&E, Inc., has an outstanding convertible bond. The bond can be converted into 20 shares of common equity (currently trading at $52/share). The bond has five years of remaining maturity, a $1,000 par value, and a 6% annual coupon. M&E’s straight debt..

A two-tank system containing a heated liquid : A two-tank system containing a heated liquid has the model shown in Figure DP9.9 (a), where T0 is the temperature of the fluid flowing into the first tank and T2 is the temperature of the liquid flowing out of the second tank.

Journalize the adjusting entry required assuming the amount : The balance in the unearned fees account, before adjustment at the end of the year, is $31,850. Journalize the adjusting entry required assuming the amount of unearned fees at the end of the year is $6,195.

Definition why is quality so important to an organization : Define quality in your own words. Considering your definition why is quality so important to an organization? Find an example of a company that has experienced a quality problem and describe the situation and its ramifications. Was the problem ever f..

What is bob best-selling product 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? Who is Bob's worst customer by total profit?

A linear combination of the states : (b) Design the gain matrix K to meet the following specifications: (i) the closed-loop system is stable; (ii) the system bandwidth ωb ≥ 1 rad/s; and (iii) the steady-state error to a unit step input R(s) = 1/s is zero.

Connection in this compensation scheme and fact that brokers : Most real estate agents are paid entirely by commission. Commissions are usually paid by the person whose property has been sold, and it is normally calculated as a percentage of the sales price. What is the likely connection between this compensatio..

Journalize the adjusting entry required for unearned rent : On October 1, 2009, Nautilus Co. received $15,300 for the rent of land for 12 months. Journalize the adjusting entry required for unearned rent on December 31, 2009.

, assuming investors are indifferent between the two bonds : If the municipal bond rate is 4.25% and the corporate bond rate is 6.25%, what is the marginal tax rate, assuming investors are indifferent between the two bonds?

User Account

All Pages