Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started