Crusty Do Possibl Liquor Student Competitors Competitors Store Size Seating License Population within 2 Miles within 5 Miles s = small Y = yes Y = yes Number Number Number M = medium N = No N = No L = Large VL = Very Large Store store ID Store 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Store Size L L L L VL M VL S M M M L M S L VL L S VL L VL L VL VL VL VL L VL S Seating Y Y Y Y Y N Y N N N N Y N N Y Y Y N Y Y Y Y Y Y Y Y Y Y N Liquor License Yes No No No Yes No Yes Yes Yes Yes No No No No Yes No No Yes No No No No Yes Yes No No Yes Yes Yes Student Competitors Competitors Population within 2 Miles within 5 Miles 12382 2 6 13397 4 7 10028 3 7 10629 4 5 17224 3 4 6451 0 4 21424 4 7 4593 3 6 9902 4 7 7733 2 4 5976 1 2 12837 3 7 8604 2 2 4581 0 1 13041 2 5 19699 3 7 10208 3 7 3791 0 3 15320 3 7 12502 4 8 16618 3 5 14776 3 6 21757 5 7 15220 5 9 16388 4 4 19565 5 8 11994 2 3 16996 3 4 4901 0 4 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 VL L VL L VL S VL VL M S M VL VL VL VL M M VL M VL VL L VL VL M M VL M S L L Y Y Y Y Y N Y Y N N N Y Y Y Y N N Y N Y Y Y Y Y N N Y N N Y Y No No No No No Yes No Yes Yes No Yes Yes No Yes Yes No Yes No No Yes No No Yes Yes Yes No No No No No Yes 19256 10470 15728 12139 16380 3883 19748 20711 6253 3593 9042 20509 20307 15948 15778 6090 9595 17959 8024 20613 18135 11277 21816 21108 8215 5819 15378 7706 4807 10806 13680 3 2 5 4 5 2 4 5 0 2 2 4 3 3 3 3 3 4 2 4 5 2 5 4 3 1 3 3 3 3 2 6 3 8 4 6 4 6 7 1 4 6 6 3 5 4 5 4 6 3 4 7 4 5 5 3 5 3 4 7 3 3 Crusty Dough Pizza Company Possible values for each variable Competitors within 15 Monthly Miles Profit Number Dollars Competitors within 15 Miles 9 17 11 9 12 10 15 17 12 11 5 17 10 4 12 10 18 5 17 13 12 14 12 22 16 18 5 13 11 Population Pizza within 20 Do they Varieties miles Delivery Order Options Number Number Y = yes T = Twitter N= No W = Website F=Fax T&W = Twitter and Website All = all three Population Monthly Pizza within 20 Do they Profit Varieties miles Delivery $23,862 21 246343 Yes $5,896 21 519905 Yes $5,720 29 496384 Yes -$1,504 47 339080 Yes $24,360 44 495901 No $18,871 45 311896 Yes $19,508 46 332115 No $809 25 415816 Yes $6,012 35 248620 Yes $13,043 28 422204 Yes $9,810 44 512501 Yes $8,736 21 105524 Yes $5,758 49 128191 No $11,638 37 457320 No $23,631 50 394021 No $23,711 38 158722 Yes $7,200 37 512157 Yes $17,290 32 345386 Yes $10,756 25 217485 No $7,862 39 448514 Yes $23,366 35 181862 Yes $15,022 38 320615 Yes $12,980 26 430602 No $12,941 23 470963 Yes $14,909 39 235819 Yes $15,018 27 132141 Yes $19,168 34 387869 No $29,447 17 283153 Yes $17,236 35 477892 No Order Options T&W All T&W All T&W T&W W W F F All All All All T&W All All T T W F T&W W T&W All All T T&W F 12 11 14 15 19 10 11 14 3 7 13 12 7 8 10 9 8 16 5 11 12 10 15 16 6 13 10 12 12 13 9 $22,755 $13,826 $672 $7,144 $2,717 -$333 $22,595 $25,715 $22,089 -$1,440 $16,234 $30,189 $29,296 $23,228 $21,862 -$5,740 $6,329 $11,586 $9,190 $30,202 $7,661 $17,388 $15,153 $21,720 $4,234 $9,611 $12,382 $5,329 -$850 $9,610 $19,802 43 44 23 22 33 22 47 35 27 30 40 27 24 43 44 48 26 45 29 50 38 43 46 47 44 45 33 31 25 23 30 361470 118881 144231 465135 517370 341136 338571 532068 211222 203525 450276 542227 435473 104388 286503 244246 370598 116944 210779 253631 170535 381416 226954 378459 112358 161100 141662 523059 301309 204878 163875 No Yes No Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes No T All All T&W All T&W T T T&W T&W W T All All F T T&W T&W All All T&W All F T&W T&W All W F All W W Review in Monthly Offer Pizza local Advertising by the Parking newspaper expenditure Slice Spots Positive Dollars Y = Yes Number Negative N = No Review in local newspaper Negative Positive Negative Negative Positive Positive Positive Positive Positive Positive Negative Positive Positive Negative Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Negative Positive Positive Monthly Offer Pizza Advertising by the Parking expenditure Slice Spots 2338 Yes 82 1293 Yes 57 910 Yes 63 1307 No 45 1948 Yes 156 1888 Yes 42 2237 No 78 1164 Yes 31 1287 Yes 53 1874 No 25 1093 Yes 46 827 No 83 1187 Yes 25 1698 No 32 1727 No 50 1955 No 128 911 Yes 86 2064 Yes 54 2076 No 142 899 Yes 49 1848 Yes 103 1833 No 70 2369 Yes 135 2011 Yes 166 1894 No 131 1992 No 161 2115 Yes 74 2588 No 81 2333 Yes 41 Buffet on Weekends Yes No Buffet on Weekends No Yes No No Yes No No No No No No No No No No Yes Yes No No No No No No Yes Yes No No Yes No Negative Positive Positive Positive Positive Positive Positive Positive Positive Negative Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Negative Positive Positive Positive 2127 1801 880 931 1127 1184 1726 3163 2292 1258 2282 2507 2229 1778 1723 1285 1209 2380 1291 3020 1191 1831 1674 1966 1264 815 1820 1147 1193 924 1922 Yes Yes No Yes Yes Yes Yes No No Yes Yes Yes Yes Yes Yes No Yes No No Yes Yes Yes No No Yes Yes No Yes No Yes Yes 192 77 163 45 157 42 142 86 44 43 19 114 183 101 88 43 48 150 46 175 65 85 67 83 57 27 72 40 58 78 50 Yes No No No Yes No Yes No No No No Yes No No No No No Yes No No Yes No No Yes No No No No No Yes No Crusty Do Possible Store store ID Store A B C D E F G H I J K L M N O P Q R S T Store Size s = small M = medium L = Large VL = Very Large Store Size M L S VL M M M L VL M L VL L L VL VL VL S L VL Liquor Student Seating License Population Y = yes Y = yes Number N = No N = No Seating N Y N Y N N N Y Y N Y Y Y Y Y Y Y N Y Y Liquor License Yes Yes No Yes No No Yes No Yes Yes Yes Yes No Yes Yes Yes Yes No Yes No Student Population 8251 12548 3233 16722 7621 9695 8343 10966 16935 5525 12740 15776 10887 13293 15474 18114 17831 3307 11658 16470 Competitors Competitors within 2 within 5 Miles Miles Number Number Competitors Competitors within 2 within 5 Miles Miles 4 4 4 5 0 0 3 3 3 3 4 8 3 6 2 2 4 8 1 1 3 6 4 8 2 6 3 6 5 7 3 4 5 7 1 2 2 2 3 6 Crusty Dough Pizza Company Possible values for each variable Competitors within 15 Monthly Miles Profit Number Dollars Population Pizza within 20 Do they Varieties miles Delivery Order Options Number Number Y = yes T = Twitter N= No W = Website F=Fax T&W = Twitter and Website All = all three Competitors within 15 Miles 10 13 3 7 13 14 13 9 12 2 15 12 16 14 12 14 15 11 7 14 Population Pizza within 20 Do they Varieties miles Delivery 50 268524 Yes 48 182319 Yes 49 114173 Yes 41 108832 Yes 41 313330 Yes 44 458090 No 22 310058 Yes 45 519397 Yes 28 404978 Yes 17 136913 No 43 434948 Yes 40 250433 Yes 29 359525 Yes 44 82577 Yes 40 419757 Yes 32 503756 Yes 20 301603 No 31 349770 Yes 37 410169 Yes 40 534435 Yes Monthly Profit ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Order Options W All T&W T&W T All W T&W T&W F All T&W F F T&W T All All W T Review in local newspaper Positive Negative Review in local newspaper Positive Positive Positive Negative Positive Positive Positive Positive Negative Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Monthly Offer Pizza Advertising by the Parking expenditure Slice Spots Dollars Y = Yes Number N = No Buffet on Weekends Yes No Monthly Offer Pizza Advertising by the Parking expenditure Slice Spots 1226 Yes 55 933 Yes 66 1927 Yes 16 2984 Yes 190 1244 Yes 43 852 Yes 22 1244 Yes 14 1904 Yes 76 2303 Yes 102 2008 Yes 46 1970 No 66 2084 Yes 98 1738 Yes 51 1755 Yes 44 2123 Yes 199 1840 Yes 66 1819 Yes 160 996 Yes 33 1693 Yes 45 2158 No 182 Buffet on Weekends No No No Yes No No No No Yes No No Yes No No No No Yes No No Yes Crusty Dou Monthl Store A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 Jan $12,180.49 $6,845.97 ($8,667.03) $20,278.69 $22,000.07 $12,378.68 $34,925.57 $10,688.45 ($2,842.50) $22,208.11 Feb $15,087.20 $6,465.64 ($7,614.03) $16,062.33 $18,228.63 $17,813.22 $40,011.82 $11,349.59 ($2,325.68) $19,785.41 Mar $11,350.01 $6,148.69 ($9,234.03) $16,664.67 $22,628.65 $18,115.14 $30,517.49 $10,908.83 ($2,354.39) $22,813.78 Monthly $50,000.00 $40,000.00 $30,000.00 $20,000.00 $10,000.00 $0.00 1 2 3 4 A1 A2 A3 ($10,000.00) A Crusty Dough Pizza Company Monthly Sales Data for ten stores Apr May $11,488.42 $5,197.87 ($6,885.03) $18,270.90 $22,209.60 $17,058.42 $32,891.07 $11,239.40 ($2,325.68) $18,372.16 Jun $13,564.64 $7,606.63 ($9,315.03) $19,074.01 $19,485.78 $15,548.83 $37,977.32 $12,451.49 ($3,072.19) $22,813.78 Jul $16,609.76 $6,465.64 ($7,128.03) $23,089.60 $18,438.16 $16,303.63 $32,551.99 $10,688.45 ($2,526.66) $21,198.65 Aug $14,533.54 $6,719.19 ($8,991.03) $21,081.81 $25,142.94 $13,586.36 $28,143.91 $11,680.16 ($3,359.32) $17,160.81 Monthly Data for ten Stores $50,000.00 $40,000.00 $30,000.00 $20,000.00 $10,000.00 $0.00 1 2 ($10,000.00) A1 3 A2 4 A3 5 A4 6 A5 7 A6 8 9 10 11 A7 A8 A9 A10 $13,010.98 $6,338.86 ($7,290.03) $23,691.93 $24,723.89 $15,397.87 $32,891.07 $12,451.49 ($2,842.50) $19,179.73 Sep $12,042.08 $6,402.25 ($9,234.03) $21,282.58 $21,161.97 $12,227.72 $40,011.82 $12,120.92 ($3,014.77) $17,766.49 Oct $15,225.62 $6,529.03 ($9,477.04) $19,676.35 $24,514.37 $15,548.83 $39,333.65 $9,255.98 ($3,359.32) $23,621.35 Nov $14,118.30 $7,226.30 ($7,290.03) $20,479.47 $19,695.30 $15,548.83 $29,839.32 $10,578.26 ($2,813.79) $21,400.54 Dec ? ? ? ? ? ? ? ? ?