Question: Sales Analysis -Using data to make decisions You are hired as an outside consultant to help a struggling appliances company. Consider the sample data provided

Sales Analysis -Using data to make decisions You are hired as an outside consultant to help a struggling appliances company. Consider the sample data provided by the company. Based on these data, what recommendations would you provide? The company is considering making a change in leadership in Wisconsin. Is this a good idea? Why or why not? Sample Data: State Quota (millions) Sales (millions) Illinois Indiana Michigan Ohio Wisconsin Totalregion: 25.22 10.12 19.49 20.90 8.87 84.60 24.30 10.24 17.77 20.43 6.74 Difference (millions) Performance Index PEES/Q x 100 .92 96.4 .12 101.2 1.72 91.2 47 97.8 2.13 76.0 5.12 94.0 79.48 Sales Rep Quota (millions) Sales millions) Tate Bir 400.2 5594 556.5 848.8 1090.3 Holzer Elbot Martin Campbell Hutchins Lessner Total Wisc 3926 501.0 5124 768 969.3 13403 1285.0 970.5 6739.8 Difference (millions) Performance Index P5/Q x 100 7.6 98.1 58.4 89.6 44.1 921 B01 90.6 1210 88.9 81.0 943 16445 43.9 91.3 91.4 2128.0 760 1421.3 2929.5 1061.8 8857.8 Wisconsin Total regions 302 94.60 6.74 79.43 2.11 5.12 76,0 94.0 Sales Rep Quota (millions Sales (millions) Toto Holtem Elliott Martin Campbell Hutchins Lessner Total Wisc 400.2 559.4 556.5 848.8 1090.3 1421.3 2929.5 1061.8 8867.8 292.6 5010 512.4 768.7 969.3 1340.3 1285.0 970.5 6739.8 Difference (millions) Performance Index PES/QX 100 7.6 98.1 58.4 89.6 44.1 92.1 80.1 90.6 121.0 88.9 810 94.3 1644.5 43.9 91.3 91.4 2128.0 76.0 Hutchins' Sales by Product: Product Sales Quota Sales Difference Can opener Toasters Coffee makers Blenders Griddles Other Total 212.000 468,000 627,000 604,000 573,000 445,500 2,929,500 124,500 237,000 175.000 159,200 340,000 248,300 1,285,000 87,500 231,000 451,000 444.800 233.000 197,200 1,644,500 Performance Index P5/Q x 100 58.7 50.6 28.1 26.4 59.3 557 43.9

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 General Management Questions!

Sartana Rey expects second quarter 2022 net income of Business Solutions's line of computer furniture to be the same as the first quarter's net income (reported below) without any changes in...

What makes marketing creative? Is it more imagination or innovation? Is a creative marketer more artist or entrepreneur? Historically, the term marketing creative has been associated with the words...

Income Statement of an interior design firm, Grand Designs, that makes money by selling hours (fees) and by selling furniture or other items (Sale of Goods). 1) Using the formula for Profit Margin,...

Questions Read the case: Jess Westerly at Kauflauf GmbH Write a synopsis of the case. Identify central and satellite problems. Why did Westerlys initial attempt to change sales patterns fail. Refer...

Discussion Questions 1. How effective has Jess Westerly been in taking charge as assistant product owner at Kauflauf? 2. Why did her first attempt to change sales call patterns fail? 3. Does her...

You have been hired as a consultant to help Ford Motor Company return to its glory days, when either Henry Ford or Alan Mulally ran the company. In doing so, you must produce a short report to Jim...

1)Reading 11: What is an expected monetary value? How does the EMV contrast to the monetary value? Why is it important for a decision maker to ignore irrelevant data? How sensitive is any decision to...

I added 5 questions in this file. They are related each other at the same chapter. I hope to get back all. 8-A1 Burton Transportation Company?s general manager reports quarterly to the company...

8-A1 Burton Transportation Company?s general manager reports quarterly to the company president on the firm?s operating performance. The company uses a budget based on detailed expectations for the...

Administrators' Perception of School Social Work Deirdre Stalnecker, Kevin Tan, and Michelle E. Alvarez This study addresses a gap in the literature by examining K-12 administrators' perceptions of...

Vaughn Video is considering refurbishing its store at a cost of $1.4 million. Management is concerned about the economy and whether a competitor, Viola Video, will open a store in the neighborhood....

A natural gas trading company wants to develop an optimal trading plan for the next 10 days. The following table summarizes the estimated prices (per thousand cubic feet (cf)) at which the company...

38. Translate the following into standard-form categorical propositions. Whoever suff ers allergic reactions has a weakened immune system.

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...