Data Mining for Managers -Project

profilenkarmarkar4
Mgmt635segF211.xls

Sheet1

Restaurants App Take Out Service Town Population Outdoor Dining Distance from Town Center Monthly Revenue
LPK 1 0 70,000 0 4 $147,900 The data provided includes operational variables of numerous restaurants throughout the Tri-state area.
WDU 0 1 140,000 0 2 $492,000 You are to mine this to gain insights on how to adjust your strategy in opening a restaurant to achieve the highest revenue.
LJP 1 0 50,000 0 5 $148,000 The restaurants in this file are rated ($$ out of $$$$) regarding price of dining.
SMM 1 1 130,000 0 5 $225,000
SLV 0 1 140,000 0 3 $428,583 Restaurant: Identifier of restaurant location
NGT 0 1 110,000 0 4 $315,146 App: Whether the restaurant belongs to an App network where the App lets people remotely book reservations (there is no penalty to consumers who do not show for reservations)
WWD 1 0 50,000 0 3 $136,700 (1 the restaurant uses the App, 0 they do not)
ARR 0 0 100,000 0 5 $174,896 Take Out Service: Whether the restaurant services take out orders.
PLM 1 1 80,000 0 5 $264,271 Town Population: The population of the surrounding 10 mile radius of the restaraunt.
AVL 0 1 190,000 1 2 $531,708 OutDoor Dining: Whether the restaurant provides outdoor dining.
SPK 1 1 110,000 0 6 $174,208 Dist. from Twn Center: The amount of miles the restaurant is from the nearest town center.
FJK 1 1 90,000 0 6 $142,583 Monthly Revenue: The monthly revenue generated by the restaurant
SRD 1 1 80,000 0 2 $139,833
VAR 1 1 100,000 1 5 $263,583
DME 1 0 120,000 0 2 $428,583
SET 0 1 120,000 0 7 $264,958
RJM 0 1 150,000 0 3 $407,958
MJW 1 0 30,000 0 5 $162,750
SJP 1 1 90,000 0 7 $244,333 As a restaurant investor, you have an opportunity to open a restaurant at a location less then 3 miles from the center of a NJ town.
PT 1 1 190,000 0 2 $407,958 The population of the town is 21,000 people. If the owner of the building will rent you the space for $5,000 a month and your monthly operating
CHH 1 0 140,000 0 2 $332,333 costs are $350,000 a month, and you also must spend $85,000 to rennovate the building, How many months will it take you to generate a profit?
MCE 1 0 50,000 0 6 $98,583 (what is your profit at the end of that month?)
LJP 1 1 70,000 0 5 $131,583
SMM 1 0 100,000 0 6 $162,750 A high net worth Tech developer has offered to pay you $100,000 a month to use the restaurant App for promotional purposes. The App data is included in this data set. Is it worth for you to use the App? Yes or No and provide the $$ amount to support your answer.
SLV 0 0 100,000 0 7 $181,083
NGT 0 0 60,000 0 5 $152,208 Use a decision tree to calculale your answers. Assume that your monthly revenue is equal to the average monthly estimate in the tree diagram.
WWD 1 1 160,000 0 6 $216,833
ARR 0 1 120,000 0 5 $222,333
ART 1 1 110,000 0 4 $202,396
ABB 1 0 100,000 0 4 $222,333
CCF 0 1 170,000 1 2 $531,708
AGT 0 0 70,000 0 7 $164,583
AWS 1 1 60,000 0 6 $165,271
CJE 1 1 150,000 0 7 $203,771
CZO 0 1 80,000 0 3 $153,583
YER 1 1 110,000 0 4 $258,083
WWK 0 0 200,000 0 3 $483,583
PLM 0 0 320,000 1 4 $744,833
AVL 0 1 120,000 0 6 $181,083
SPK 1 1 240,000 0 5 $162,750
FJK 0 1 120,000 1 3 $263,583
SRD 1 1 110,000 0 3 $311,708
VAR 0 1 130,000 0 5 $291,083
DME 0 0 110,000 0 3 $397,646
SET 1 0 110,000 0 4 $283,797
RJM 1 0 190,000 0 6 $129,521
RAK 0 1 100,000 1 2 $407,958
RIM 1 0 230,000 0 6 $43,957
BEK 0 0 110,000 0 5 $226,470
ELM 1 0 250,000 0 8 $104,960
GDJ 0 1 110,000 0 3 $346,083
MDD 1 1 150,000 0 4 $254,417
MJM 1 0 200,000 0 7 $25,708
PAK 0 1 110,000 1 3 $359,833
PFK 1 0 200,000 0 7 $90,726
ETY 0 1 180,000 0 4 $139,833
HGD 0 0 100,000 1 3 $530,997
PIN 1 0 100,000 0 2 $25,250
BFE 1 0 210,000 0 4 $223,448
EFR 1 0 210,000 0 6 $160,458
MJK 1 0 230,000 0 6 $149,789
TAC 0 1 110,000 0 5 $257,402
TEY 0 1 290,000 1 3 $555,460
SAM 1 0 240,000 0 7 $122,972
CEW 1 0 150,000 0 6 $140,615
AIZ 0 1 110,000 1 2 $464,938
HEN 1 0 230,000 0 6 $149,789
MDT 0 0 160,000 0 5 $245,115
SDE 0 1 330,000 1 2 $850,853
EFC 0 0 190,000 0 5 $257,402
LMC 0 0 300,000 1 2 $733,258
THH 1 0 170,000 0 5 $236,083
KNE 0 1 110,000 0 5 $245,115
DMJ 1 0 190,000 0 6 $142,583
MCC 1 1 160,000 0 4 $231,958
JAK 1 0 190,000 0 5 $142,583
BLM 1 1 290,000 1 2 $621,083
JJJ 1 1 140,000 1 2 $464,938
CJG 1 1 130,000 0 2 $485,968
BER 0 0 160,000 0 6 $181,083
CHM 0 1 300,000 1 2 $666,917
JDN 0 1 190,000 0 3 $464,938
SEG 1 0 80,000 0 6 $140,615
KLR 0 0 280,000 0 2 $552,333
LPE 1 1 50,000 0 6 $140,615
IJN 1 1 100,000 0 2 $318,583
EFD 0 0 140,000 1 2 $456,083
UHG 0 0 150,000 0 4 $253,271
ODN 0 0 220,000 1 2 $581,070
EDJ 1 1 50,000 0 6 $149,789
ENK 0 1 140,000 0 3 $346,083
LPK 1 1 120,000 0 3 $222,333
WDU 1 0 90,000 0 4 $197,583
LJP 1 0 130,000 0 2 $201,708
SMM 1 0 50,000 0 3 $123,333
SLV 1 0 100,000 1 3 $304,833
NGT 0 1 200,000 0 6 $552,333
WWD 0 1 240,000 0 2 $593,583
ARR 0 1 180,000 0 2 $407,958

Sheet2

Sheet3