5.) A common rumor for years is that a Cheesecake Factory isgoing to open a location in...
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 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 |