Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5.) A common rumor for years is that a Cheesecake Factory isgoing to open a location in El Paso. Everyone knows someone whoknows someone who

5.) A common rumor for years is that a Cheesecake Factory isgoing to open a location in El Paso. Everyone knows “someone” whoknows “someone” who knows they are going to open a location in ElPaso. Most people in El Paso “know” a Cheesecake Factory would dowell here without looking at any data. However, what most people donot realize is that Cheesecake Factory has the most restrictiverequirements for opening a location. These factors includeprojected daily customer volume, availability of premierelocations, location to supplier’s warehouse, and availability ofhigh income consumers. The Cheesecake Factory looks at thesefactors and computes whether a store profit can be greater than$10,000,000. Given the attached data for 15 other CheesecakeFactory locations and given the values for El Paso, construct anANOVA table and show why the Cheesecake Factory will not be openinga location in El Paso anytime soon and what is the major reasonwhy. (75 points)

Location

Profit

Average Daily Customer traffic

Distance to suppliers warehouse (in miles)

Number of high income consumers

1

$12,589,152.00

1300

32

185000

2

$18,456,335.00

1575

11

250000

3

$11,478,592.00

1220

111

200000

4

$12,547,882.00

1300

87

170000

5

$10,523,987.00

1075

95

170000

6

$11,183,527.00

1120

52

190000

7

$17,889,716.00

1440

46

225000

8

$14,498,526.00

1555

49

190000

9

$10,892,674.00

1205

78

200000

10

$13,589,671.00

1515

42

250000

11

$15,085,390.00

1585

33

200000

12

$10,789,741.00

1095

80

150000

13

$13,080,509.00

1095

44

200000

14

$12,589,004.00

1340

41

165000

15

$10,058,905.00

1175

109

185000

El Paso

?

1300

400

100000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Strategy

Authors: Mike W. Peng

5th Edition

0357512367, 978-0357512364

More Books

Students also viewed these Mathematics questions