Question: Sales Data Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Sales Data Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Percent Gross ProfitGross Sales 51.0% $170.00 32.0% $181.00 20.0% $203.00 22.0% $249.00 21.0% $476.00 21.0% $476.00 22.0% $635.00 34.0% $856.00 26.0% $1,062.00 16.6% $1,110.00 20.0% $1,153.00 36.0% $1,392.00 18.0% $1,743.00 20.0% $2,307.00 5.0% $2,534.00 29.0% $2,683.00 10.0% $2,780.00 37.0% $3,272.00 60.0% $3,864.00 24.0% $3,988.00 9.0% $4,072.00 50.0% $4,190.00 17.0% $4,219.00 32.0% $4,711.00 15.0% $4,824.00 10.0% $4,878.00 13.0% $5,157.00 22.0% $5,552.00 17.0% $5,876.00 19.0% $5,888.00 6.0% $7,632.00 23.0% $8,058.00 23.0% $12,056.00 14.0% $12,981.00 22.0% $13,406.00 14.0% $15,882.00 28.0% $16,343.00 27.0% $19,985.00 3.0% $20,160.00 46.0% $26,616.00 26.0% $28,018.00 11.0% $28,950.00 18.0% $29,646.00 37.0% $31,019.00 20.0% $31,305.00 21.0% $34,769.00 10.0% $34,817.00 Gross Profit Industry Code Competitive Rating* $86.70 1 2 $57.92 3 4 $40.60 2 2 $54.78 5 1 $99.96 5 1 $99.96 5 4 $139.70 2 3 $291.04 3 3 $276.12 4 2 $183.71 7 3 $230.60 7 3 $501.12 4 2 $313.74 4 2 $461.40 7 3 $126.70 4 5 $778.07 7 2 $278.00 2 3 $1,210.64 5 3 $2,318.40 7 1 $957.12 6 3 $366.48 7 3 $2,095.00 5 3 $717.23 3 4 $1,507.52 7 1 $723.60 6 3 $487.80 7 4 $670.41 7 2 $1,221.44 2 3 $998.92 1 3 $1,118.72 6 4 $457.92 5 4 $1,853.34 3 3 $2,772.88 7 2 $1,817.34 2 4 $2,949.32 2 3 $2,223.48 7 3 $4,576.04 3 3 $5,395.95 5 3 $604.80 5 5 $12,243.36 5 2 $7,284.68 5 3 $3,184.50 4 4 $5,336.28 4 3 $11,477.03 6 1 $6,261.00 2 3 $7,301.49 7 1 $3,481.70 4 3 48 49 50 51 52 53 54 55 56 57 58 59 60 14.0% 9.0% 16.0% 22.0% 21.0% 17.0% 11.0% 7.0% 14.0% 15.0% 13.0% 21.0% 14.0% $38,609.00 $38,923.00 $40,536.00 $54,851.00 $54,861.00 $58,063.00 $62,862.00 $78,574.00 $92,776.00 $112,837.00 $115,999.00 $120,854.00 $179,101.00 $5,405.26 $3,503.07 $6,485.76 $12,067.22 $11,520.81 $9,870.71 $6,914.82 $5,500.18 $12,988.64 $16,925.55 $15,079.87 $25,379.34 $25,074.14 1 2 4 6 7 5 4 3 4 1 4 5 6 3 5 3 2 2 4 5 5 3 4 5 4 3 *Rates the amount of competition for sales of the products sold to these customers: 1 = very little competition to 5 = very comp ompetition to 5 = very competitive

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

I need help answering this case! I need the discussion questions answered. Continental Airlines INTRODUCTION In 2008, the senior management team at Continental Airlines, commanded by Lawrence...

Here is another one that I need assistance with. Let me know if you have any issues getting these done, because I have to turn them in by tonight On Pages 733 and 734, please read the background for...

Hello Finstat. I have really appreciated your help so far. Can you help with the attached? From what I can tell and what the instructor has told us is that this is less involved than the previous...

Using ?VehicleFailureData? available on the course website, answer the following: Classify each variable as nominal, ordinal, interval or ratio. Identify qualitative and quantitative variables. How...

Use the extended DuPont equation to provide a summary and overview of your firm?s financial condition. Be sure to do all calculations for 3 years, using Excel. Use real numbers from the financials,...

CODE IN C++ PLEASE: Include comments and read from a file Create a 2 dimensional array named: array1[5][7] Design and Implement a program that will read all values from a file for your array. You are...

Julie Whiteweiler made $930 this week. Only social security (fully taxable) and federal income taxes attach to her pay. Whiteweiler contributes $100 each week to her company's 401(k) plan and has $25...

Good Morning I need help writing a deep analysis for these cases, thank you. Retirement Planning Savings Accumulation for retirement Age 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56...

I need the answers or instructions on how to get the answers for all of problem three and the unfinished part of problem 4. This class is financial modeling, must use the formulas by tagging them to...

Pyrrole on hydrogenation gives Piperidine 2-hydro pyrrole Pyrrolidene Pyridine None Which of the following compound is the mont basic

Put options increase in value as stock prices fall, and call options increase in value as stock prices rise. How can the same movement in an underlying variable (e. g., an increase either in time...

The diagram shows shapes J, K, L, M, N and P. Choose the correct equation of the mirror line for each of these reflections. a J and K A x = 1 B y = 3 C x = 3 b J and M A x = 4 B y = 4 C x = 5 c M and...

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...