Pone Descriptive Analytic Project Spring 2022 Task: Utilizing your assigned file only (see file 3. File Assignments), perform a descriptive analysis over the data that provides a comprehensive overview of "What happened" / "What is happening". Utilize the extra information provided to provide management with solutions or additional insights based on the guidance received below. Each dataset has its own specific information (see below). Tools: Students are expected to utilize Excel or Tableau or both! In all cases, the data can be explored in multiple different ways. Your task is to be creative yet thorough. Use as many data fields as possible in your analysis. The tool you choose is entirely up to you. However, you MUST include AT LEAST 3 visualizations (bar charts, pie charts, histograms, bubble charts, etc.). Deliverable: A PowerPoint Presentation that highlights your findings and includes commentary as if you were presenting the PowerPoint in front of the class. Under each slide, insert comments as if you were presenting live to the class in the comments. This is the "Notes" portion of the slide. Your PowerPoint should be roughly 8-9 slides with a max of 10 slides, It is recommended to stick close to the following. This is only a suggestion 1. Title Slide 2. Intro Slide 3. 2-3 Slides of descriptive analytics, breaking down the data by the information provided 4. 2-3 Slides devoted to specifically addressing Management's question. These are found in next few pages of this document, 5. Conclusion slide stys Pane File 1: Health and Safety Inspections You are in the business of providing consulting services for clients that need to pass health and safety inspections to stay in business. You are trying to raise capital to expand your business and are giving a meeting next week to some angel investors. Describe the first-year business results and determine whether or not this is a profitable venture. You get paid revenue up front for your services, but if you fail to live up to the job you must provide refunds. You make the following upfront revenues from clients based on their level of risk: o Extremely High Risk = $2,250 High Risk = $1,750 Medium Risk = $1,000 O Low Risk $750 If a client passes their initial inspection, the business arrangement is done, and you keep all of the revenue. If a client fails a health inspection, you refund the client a flat fee of $2,500. If a client fails a safety inspection, you refund the client a flat fee of $2,000 Requirements: 1. Create 4 descriptives that provide insights into the profitability of the venture. Each of the following variables MUST show up in at least once: o Inspection Date (feel free to analyze by month) o Facility Type Risk Level o Inspection Type Revenue Refund Income (Revenue - Refund) You o O sh (United States Heading 2 Title Sty Pa iveurum RISKIVOU Low Risk $750 If a client passes their initial inspection, the business arrangement is done, and you keep all of the revenue. If a client fails a health inspection, you refund the client a flat fee of $2,500. If a client fails a safety inspection, you refund the client a flat fee of $2,000 Requirements: 1. Create 4 descriptives that provide insights into the profitability of the venture. Each of the following variables MUST show up in at least once: o Inspection Date (feel free to analyze by month) Facility Type Risk Level Inspection Type Revenue Refund o Income (Revenue - Refund) 2. A descriptive that answers the following: Are healthy and safety inspections profitable ventures in each of the cities? O O Home Inspecti Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 V GA Wrap Text Paste GE $ B I U HE v = = Merge & Center $ J9 fx D Risk Code E Location 1 4 2 3 1 5 3 2 4 1 4 1 3 3 1 1 3 2 2 3 4 3 1 1 5 4 4 3 1 3 5 1 2 5 3 3 2 4 B c 1 Inspection ID Business Name Facility Type 2 2243957 TWO MILE COFEE BAR Restaurant 3 2243958 FAMILY DOLLAR Grocery Store 4 2243959 CARMELO'S TACO PLACE Restaurant 5 2243960 AVONDALE COFFEE AND GRILL HOUSE Restaurant 6 2243961 MR. POLLO Restaurant 7 2243962 COMMUNITY FOOD MART Restaurant 8 2243963 WINGSTOP Restaurant 9 2243964 EL LLANO RESTAURANT Restaurant 10 2243965 CHINA PALACE Restaurant 11 2243966 EL CENTENARIO SPORTS BAR & GRILL Restaurant 12 2243967 MAGGIE GYROS & CHICKEN Restaurant 13 2243968 REMIS BARBEQUE AND CHICKEN Restaurant 14 2243969 RENALDI'S PIZZA Restaurant 15 2243971 JEWEL/STARBUCKS Grocery Store 16 2243972 MANOLOS TAMALES, INC. Restaurant 17 2243973 SUPER FOOD MART Grocery Store 18 2243975 Hash Restaurant 19 2243978 DELI & MORE Grocery Store 20 2243979 NORTHERN TRUST FOOD HALL Restaurant 21 2243980 J&C FOOD MARKET CARNECERIA Y FRUTE Grocery Store 22 2243981 BONGO ROOM Restaurant 23 2243982 ERNST PRUSSING ELEMENTARY SCHOOL School 24 2243983 REWIRED CAFE Restaurant 25 2243984 LA LUNA Restaurant 26 2243985 Whole Foods Market Grocery Store 27 2243987 BLUE SKY BAKERY & CAFE Restaurant 28 2243988 LA LUNA Restaurant 29 2243989 Kitchen Sink Restaurant 30 2243990 DUNKIN DONUTS BASKIN ROBBINS Restaurant 31 2243991 GARFIELD GYROS Restaurant 32 2243994 INSPIRATION CORPORATION Restaurant 33 2243995 TAQUERIA MIUNOA HACIENDA Restaurant 34 2243997 HOLY TACOL Restaurant 35 2243998 NATYS PIZZA Restaurant 36 2243999 Northern Trust Bark, Brecutive Dining Restaurant 37 2244000 MIDDLE BROW Restaurant 38 2244001 Habanero Restaurant 39 2244002 AFC SUSHI Restaurant 40 2244003 MIDDLE BROW Restaurant 41 2244004 NANDO'S Restaurant 42 2244005 MODLE BROW Restaurant 43 2244006 SHIRLEY'S CAFE Restaurant 44 2244007 NOONOKARAB Restaurant Inspection Results Risk Location Ready NNNNN 2 3 1 1 F G Inspection Dat Inspection Results 1/2/21 B 1/2/21 8 1/2/21 8 1/2/21 A 1/2/21 A 1/2/21 B 1/2/21 1/2/21 A 1/2/21 1/2/21 8 1/2/21 A 122/21 B 1/2/21 B 1/3/21 B 1/3/21 A 1/3/21 B 1/3/21 A 1/3/218 1/3/21 B 1/3/21 A 1/3/21 C 1/3/21 A 1/3/21 B 1/3/21 A 1/3/213 1/3/21 1/3/21 B 1/3/21 A 1/3/21 B 1/3/21 A 1/3/21 A 1/3/21 a 1/3/21 A 1/3/21 8 1/3/21 B 1/3/21 8 1/3/21 B 1/3/21 1/3/21 B 1/3/21-5 1/3/21 A 1/3/21 1/3/213 3 4 3 2 1 3 3 4 1 2 1 4 4 1 1 2 5 5 2 2 1 1 2 5 5 5 4 2 3 1 2 2 4 2 4 4 3 1 2 3 4 1 1 Results + ON AutoSave Page Layout 4. Health_Inspection Home Insert Draw Formulas Data Review View Tell me X Calibri (Body 11 ' III Paste Gene B 1 U a.A- 29 Wrap Text Merge & Center $ 19 x x D E 4 45 46 47 45 49 50 51 4 1 2 2 4 1 3 2 3 1 2 1 4 1 2 3 3 4 1 1 2 3 4 53 54 55 56 57 58 59 60 61 62 63 54 65 65 -57 68 69 70 71 72 73 74 75 76 77 73 79 BO 1 2 3 5 3 + 3 2 5 3 5 3 5 4 1 2244008 JIMMY JOHNS SANDWICH SHOPS Restaurant 2244009 NOONOKABAB Restaurant 2244010 BURGER FEDERATION (321) Restaurant 2244011 FINE FAIR FOOD & LIQUOR Grocery Store 2244012 Seven Seas Submarine Restaurant 2244013 LOTUS SEED Restaurant 2244014 N Restaurant 2244015 BURGER FEDERATION (1321) Restaurant 2244015 FRANK & MARYS Restaurant 2244017 NOONOKABAB Restaurant 2244018 NEW TEA GARDEN CHOP SUEY Restaurant 2244020 FRANK'S FOOD MART Grocery Store 2244021 YOUNG'S RESTAURANT Restaurant 2244022 JANMYBURGER Restaurant 2244023 PRETA MANGER Restaurant 2244024 KAMEYA Restaurant 2244025 HEALTHCARE ALTERNATIVE SYSTEMS Restaurant 2244026 FRUTERIA ANDY R2 Grocery Store 2244027 SUBWAY SANDWICH STORE Restaurant 2244028 LA TORTA CHILANGAR Restaurant 2244029 BUB CITY Restaurant 2244030 HILDA'S KITCHEN INC Restaurant 2244031 THE SCOUT Restaurant 2244032 PICANTE TAQUERIA Restaurant 2244033 MORENAS KITCHEN Restaurant 2244035 The Dark Horse Tap and Grill Restaurant 2244035 HAROLDS 82 Restaurant 2244037 WENDY'S Restaurant 2244038 SUBWAY Restaurant 2244039 MARTYRS Restaurant 2244070 SUBWAY SANDWICH Restaurant 2244168 ROLANDO TACO'S Restaurant 2252333 HERMOSA Restaurant 2244041 JOHNNA CAFE Restaurant 2244042 LA HACIENDITATAQUERIA Restaurant 2244043 MAC KELLYS GREENS & THONGS Restaurant 2244044 DORE ELEMENTARY SCHOOL School 2244045 HARBORSIDE INTERNATIONAL CLUBHOUS Restaurant 224.6046 CENACLE RETIREMENT Restaurant 2244047 BELMONTSNACK SHOP Restaurant 2244048 HASHBROWNS Restaurant 22.44049 SUBWAY Restaurant 2244050 LYFE KITCHEN Restaurant 2244051 JOSEPH'S FINEST MEATS Grocery Store Inspection Results Risk Location Ready 1/3/21 A 1/3/218 1/3/218 1/3/21 8 1/3/218 1/3/21 1/3/21 A 1/3/213 1/3/21 22.21 A 1/3/21 8 1/3/21 A 1/3/218 1/3/21 C 1/3/21 A 1/2/21 5 1/3/21 1/3/21 1/3/21 11/21 A 1/3/21 a 1/3/2113 1/3/210 1/3/21 A 1/3/21 A 1/3/21 A 2 2 4 2 1 2 3 3 2 3 1 5 2 3 4 3 4 2 1 2 2 1 1/3/215 1/3/21 1/3/21 A 1/3.21 1/3/21 A 1/1/21 1/4/21 1/4/21 5 1/4/21A 14/21 A 1213 1/4/21 A 5 5 3 2 2 5 1 2 5 + 5 4 5 5 4 82 83 34 5 85 87 88 4 3 1/4/21 A 1/421 A 1/4/21 A 1/4/21 Results + w AutoSave ON 4. Health_inspections Tell me Home Insert Draw Page Layout Formulas Data Review View X Calibri (Body) 11 == Genere Paste 8 IU 2 Wrap Text Marge & Center v A DI ill Inl $ 19 3 c D F G 88 985 4 2 5 4 1 2 4 1 2 2 1 3 4 3 3 3 1 3 1 1 4 4 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 102 108 109 110 111 112 113 114 115 116 + 2 1 1 3 4 5 5 3 1 3 1 2 1 2244051 JOSEPH'S FINEST MEATS Grocery Store 2244052 SUBWAY Restaurant 2244053 EASY LIVING JUICE BAR LLC Restaurant 2244054 EINSTEIN BROS BAGELS Restaurant 2244055 SUBWAY Restaurant 2244056 SUBWAY Restaurant 2244057 SUPER TAQUERIA ELTACONAZO EL TIO Restaurant 2244059 SUNLIGHT CAFE Restaurant 2244060 SUBWAY 47512 Restaurant 2244061 CAFE TOLA II Restaurant 2244062 PROTEIN BAR Restaurant 2244063 LALO'S MEXICAN RESTAURANT Restaurant 2244064 JEWEL FOOD STORE 3345 Grocery Store 2244065 RYO SUSHI Restaurant 2244066 NORTH POND CAFE Restaurant 2244067 LA MICHOACANA AZTECA Restaurant 2244068 LE PARIS BAKERY NO 3 Restaurant 2244069 JIMMY JOHNS Restaurant 2244071 MARIANO'S Grocery Store 2244072 TIMOTHY O'TOOLE'S Restaurant 2244074 DRAGON LADY LOUNGE Restaurant 2244075 PUNKY'S PIZZA AND PASTA Restaurant 2244076 HALAIN Restaurant 2244072 ASIAN TOWN NOODLES Restaurant 2244078 TRASPASADA RESTAURANT Restaurant 2244079 OBEROIS INDIAN FOOD Restaurant 2244080 SHARKS FISH AND CHICKEN Restaurant 2244081 OBEROIS INDIAN FOOD & GROCERYINC Restaurant 2244082 CHIPOTE MEXICAN GRILL Restaurant 2244083 THE FLOWER FLAT Restaurant 2244084 EL PACIFICO Restaurant 2244085 STAR EAST Restaurant 2244086 CAFECITO Restaurant 2244087 PANTRY EXPRESS Grocery Store 2244088 CHIPOTLE Restaurant 2244089 FINLEY DUNNE'S Restaurant 2244090 CAFETERIA MARCELAS Restaurant 2244092 LA MICHOACANAD BEATRIZ & ALMA Restaurant 2244093 WOK CUISINE Restaurant 2244094 580 SUPPLY Restaurant 2244095 NARANIA DULCE Restaurant 2244096 THE LAR ON BUENA Restaurant 2244097 Durango Pizzeria Resturant As wVID RETARIAT Inspection Results Risk Location Ready 1 2 3 1 2 1 1/4/21 8 1/4/21 B 1/4/21 8 1/4/21 B 1/4/21 8 1/4/21 8 1/4/21 A 1/4/21 8 1/4/21 A 1/4/21 B 1/4/21 1/4/21 a 1/4/21 A 1/4/213 1/4/21 A 1/4/21 A 1/4/21 A 1/4/21 C 1/4/21 B 1/4/21 a 1/4/21 8 1/4/21 1/4/21 A 1 1C 1/4/21 1/421 C 1/4/21 A 1/4/21 A 1/4/21 1/4/21 A 1/4/21 5 1/4216 1/4/21 0 1/4/21 1/4/213 1/4/21 1/4/21 B 1/4/21 0 1/4/21 A 1/4/21 A 1/4/21 1/4/21 0 1/4/21 A 3 1 1 3 1 3 3 S 4 117 5 1 4 1 3 1 3 2 4 4 4 118 119 120 121 122 122 124 125 126 127 128 129 130 12 4 2 1 3 5 3 5 2 2 1 3 3 1 1 Results + Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 ' == Gener 2Wrap Text Merge & Center Paste B 10 I U IM IM J9 ex fx A D E NN 2 2 2 1 1 1 1 5 1 2 3 2 4 4 2 2 2 4 5 4 5 5 3 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 145 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 154 165 165 167 16 169 170 171 172 173 174 1 2244098 WING YIP RESTAURANT 2244101 NELLA PIZZA PASTA 2244104 BURKE'S 2244106 CHICAGO DIPLOMAT CAFE 2244107 GAO'S KABOB 2244102 DONI DESSERT AND PASTRY 2244103 JOHNSON'S REAL ICE CREAM 2244105 LA LLAMARADA RESTAURANT 2244108 IMMY JOHNS SANDWICH SHOP 2244109 CANDLELIGHT 2244110 Dixon 2244111 Edgebrook 2244112 SUBWAY 2244113 ARMOUR ELEMENTARY SCHOOL 2244114 TBD 2244115 SUBWAY 2244116 TJ JAMAICAN JERK CHICKEN 2244118 South Loop Elementary 2244120 Beaublen Elementary School 2244121 GUNSAULUS ELEMENTARY 2244122 CICERO & NORTH FOOD & LIQUOR 2244123 SUBWAY 2244124 CHARTWELL'S DINING 2244125 Gale Community Academy 2244126 CICERO & NORTH FOOD & LIQUOR 2244127 LUNA EMPANADASHOP 2244128 JAY'S BACKYARD BBQ 2244129 CONVENE 2244130 DUNKIN DONUTS 2244131 TASTY PLACE 2244132 Shoop 2244133 BERNARD MOOS ELEMENTARY SCHOOL 2244134 CONVENE 2244136 McDade Classical 2244137 TASTY CHICKEN & SALAD FOOD MART 2244138 CHARLEY NOBLE 2244139 Walgreens 7559 2244140 ARMOUR BRANCH 2244143 LOU MALNATIS PUZZERIA 2244144 JEWEL FOOD STORE 3470 2244145 De Diego Community 2244146 ONE STOP SHOP 2244147 ELIARDIN RESTAURANT 2244148 AFC SUSHI JEWEL OSCO 3470 Inspection Results Risk 4 2 3 4 2 1 4 4 4 2 3 1 3 3 Restaurant Restaurant Restaurant Restaurant Restaurant Bakery Restaurant Restaurant Restaurant Restaurant School School Restaurant School Grocery Store Restaurant Restaurant School School School Grocery Store Restaurant Restaurant School Grocery Store Restaurant Restaurant Restaurant Restaurant Bakery School School Restaurant School Restaurant Restaurant Grocery Store School Restaurant Grocery Store School Grocery Store Restaurant Grocery Store Location 3 1 1 2 2 4 1 1 1/4/21 A 1/4/21 A 3/4/21 B 1/4/21 A 1/4/21 A 1/7/21 A 177/21 B 1/7/21 8 1/21 B 1/7/21 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 8 1/8/21 8 1/8/21 A 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 B 1/8/21 8 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 B 1/8/21 B 1/8/21 1/8:21 A 1/8/21 B 1/8/21 1/8/21 1/8/21 B 1/8/21 A 1/8/21 1/8/21 A 1/8/21 A 1/8:21B 1 1 4 2 2 3 3 3 4 2 2 4 2 3 2 1 3 1 1 1 2 5 1 4 1 5 2 3 3 2 1 Results + + Ready AutoSave ON 4. Health_Inspectior Home Insert Draw Page Layout Formulas Data Review View Tell me [D Calibri (Body) 11 ' ' 29 Wrap Text Gen Paste B CA y === Merge & Center $ 19 Xfx 0 D G 1 5 1 4 3 1 1 5 1 1 5 4 4 2 4 3 182 183 1 4 1 3 1 4 2 4 4 4 2 1 4 2 4 2 4 195 174 2244148 AFC SUSHIJEWEL OSCO 13470 Grocery Store 175 2244149 WENDY'S Restaurant 176 2244150 EAT AND RUN NFP Restaurant 177 2244151 UNCLE JOE'S JERK CHICKEN & FISH Restaurant 178 2244152 MAIN KITCHEN Restaurant 179 2244153 GAO'S KABOB Restaurant 180 2244154 M&M STOP & SHOP Grocery Store 181 2244155 Neil School 2244156 BEREKE RESTAURANT Restaurant 2244157 BORELLI'S Restaurant 184 2244158 ATHENIAN ROOM RESTAURANT Restaurant 185 2244159 SHANGHAI TERRACE Restaurant 126 2244160 PIERROT GOURMET Restaurant 187 2244161 AMAZON GO Grocery Store 188 2244162 TASTE OF CANTON Restaurant 189 2244163 LOS GAMAS TORTILLAS Y RESTORANTE Restaurant 190 2244164 AMAZON GO Grocery Store 191 2244165 FOUR SEASONS NOODLES Restaurant 192 2244166 YUMMY YUMMY NOODLES Restaurant 193 2244167 UGO'S Restaurant 194 2244169 ALIBABA CAFE Restaurant 2244170 POTBELLY SANDWICH SHOP Restaurant 196 2244171 FIRST SLICE PIE CAFE Restaurant 197 2244172 ROLANDO TACO'S Restaurant 398 2244174 CANTINA LAREDO Restaurant 199 2244175 SAM'S CHICKEN AND RIBS, PIZZA Restaurant 200 2244177 LOU MALNATIS PIZZERIA Restaurant 201 2244178 LA TORTA CHILANGAN2 Restaurant 202 2244179 PENINSULA CHICAGO, LLC Restaurant 203 2244110 TACO BELL Restaurant 204 2244181 NEW TEA GARDEN CHOP SUEY Restaurant 205 2244182 TAQUERIA SUPER BURRSTO Restaurant 206 2244183 YAMON JERK GRILL Restaurant 207 2244184 MRPATS HOAGY AND STEAK SANDWICH Restaurant 208 2244185 LAGRANIA RESTAURANT Restaurant 2244186 POPEYES FAMOUS FRIED CHICKEN Restaurant 210 2244187 MOGEE'S TAVERN & GRILLE Restaurant 231 2244188 SEE THRU CHINESE KITCHEN Restaurant 212 2244189 MIDOLE BROW Restaurant 213 14100 KIN Restaurant 214 2244191 STARBUCKS COFFEE #232 Restaurant 215 2244192 MIDOLE BROW Restaurant 216 2244193 MIDOLE BROW Restaurant 212 2244194 TURKEY CHOP Restaurant Inspection Results Risk Location Ready 3 1 2 3 1 5 2 3 3 4 2 5 1 2 3 2 5 2 4 5 2 1 1 1/8/21 B 1/8/21 A 1/8/21 c 1/8/21 A 1/8/21 B 1/8/21 B 1/8/21 8 1/8/21 A 1/8/21 8 1/8/21 1/8/21 B 1/8/21 B 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 B 1/8/21 A 1/8/21 0 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 A 1/8/21 A 1/8/21 8 1/8/21 B 1/8/21 A 2/8/21 A 1/8/21 D 1/8/218 1/8/21 8 1/8/21 D 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 A 1/8/218 1/8/21 A 1/8/210 1/8/21 0 1/8/21 A 1/8/21 A 1/8/21 0 1/8/21 1/8/215 4 4 1 2 2 4 1 2 1 3 209 2 2 3 1 2 5 4 4 2 2 3 3 4 3 2 + 3 4 5 4 Results + Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 ' Gene Paste Wrap Text Merge & Center . I U v 5 10 ilil $ J9 fx D G 17 218 3 3 19 4 4 4 2 2 2 2 4 3 2 4 4 4 4 3 2 3 4 2 3 4 3 3 4 220 221 12:22 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 245 247 248 249 250 3 4 2 2 2 4 A B w 2244194 TURKEY CHOP 2244195 C'EST BIEN THAI 2244197 Ashe 2244198 FAMILY DOLLAR 2244199 TWEET 2244201 Washington Irving School 2244202 COLECTIVO COFFEE ROASTERS 2244204 LE PAIN QUOTIDIEN 2244205 Savanna Restaurant 2244208 Eugene Field 2244209 LA MICHOACANAD BEATRIZ & ALMA 2244210 ST. RICHARD SCHOOL 2252211 HOTEL CHICAGO 2252212 CHICAGO DIPLOMAT CAFE 2252213. HOTEL CHICAGO 2252214 SEE THRU CHINESE KITCHEN 2252216 PIRIE FINE ARTS ACADEMY 2252217 BRYN MAWR BREAKFAST CLUB 2252218 ANTOJITOS COLOMBIANOS 2252219 GOETHE ELEMENTARY SCHOOL 2252220 SEE THRU CHINESE KITCHEN 2252221 LASALLEU MAGNET SCHOOL 2252222 CHAPPELL SCHOOL 2252223 CERES CAFE 2252224 LAMICHOACANA AZTECA 2252225 DIMDIM FOOD INC 2252226 CELLARS MARKET 2252227 MARIANO'S FRESH MARKET 2252228 CALIFORNIA SUB & FAST FOOD 2252229 SUBWAY 48735 2252230 SALVATORE'S 2252231 FLUBADUB CHUB'S 2252233 LE PARIS BAKERY 2252234 WINDY CITY 80 2252235 DUNKIN DONUTS/ BASKIN ROBBINS 2252236 PANTRY EXPRESS 2252237 WINDY CITY BBQ 2252238 FESTA GRILL 2252239 O'DONOVAN'S 2252240 GRILL AND GARDEN 2252241 TACO BELL 2252242 VISANU THAI 5S, INC. 2252243 CAFFE BACHINC 4 4 3 3 2 2 5 1 4 Restaurant Restaurant School Grocery Store Restaurant School Restaurant Restaurant Restaurant School Restaurant School Restaurant Restaurant Restaurant Restaurant School Restaurant Restaurant School Restaurant School School Restaurant Restaurant Restaurant Restaurant Grocery Store Restaurant Restaurant Restaurant Restaurant Restaurant Restaurant Restaurant Grocery Store Restaurant Restaurant Restaurant Restaurant Restaurant Restaurant Restaurant 4 1 1 3 1 1 1/8/21 B 1/8/21 A 1/9/21 A 1/9/21 B 1/9/21 A 1/9/21 A 1/9/21 A 1/9/21 A 1/9/21 8 1/9/21 8 1/9/21 D 1/9/21 B 1/9/21 B 1/9/21 A 1/9/21 A 1/9/21 B 1/9/21 B 1/9/21 B 1/9/21 8 1/9/21 B 1/9/21 B 1/9/21 8 1/9/21 B 1/9/21 B 1/9/21 c 1/9/21 A 1/9/21 B 1/9/21 A 1/9/21 A 1/9/21 A 1/9/21 B 1/9/21 A 1/9/21 8 1/9/21 C 1/9/21 A 1/9/21 1/9/21 C 1/9/21 A 1/9/213 1/9/21 A 1/9/21 c 1/9/21 A 1/9/210 2 1 1 4 4 1 14 4 4 1 3 1 251 1 2 4 3 1 3 5 1 2 5 2 1 2 1 4 4 3 1 3 3 1 252 253 254 255 256 257 258 259 4 2 2 1 2 Inspection Results Risk Location Results + + UU 4. Health_Inspection Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 ' ' = 2 Wrap Text Gen Paste B I U Av = lili 2010 ill 191 IM Merge & Center $ J9 + x V fx A B C D E F 687 3 3 4 4 2 2 4 3 1 3 1 1 2 3 4 4 2 2 1 2 4 3 4 2 2 5 3 S 3 3 4 5 5 4 2 4 1 2 1 682 2252707 FAMILY STYLE PIZZA Restaurant 683 2252708 ONE ELEVEN FOOD & LIQUOR Grocery Store 684 2252709 WAFFLES Restaurant 685 2252710 RAY HARRINGTON CATERING COMPANY Restaurant 686 2252711 BUONA Restaurant 2252712 Subway Restaurant 688 2252713 GRACE CHRISTIAN ACADEMY School 689 2252714 EL GARCIA RESTAURANT Restaurant 690 2252715 WALSH ELEMENTARY School 691 2252716 SHARKS FISH & CHICKEN Restaurant 692 2252717 LABAMBA Restaurant 693 2252718 TRULUCK'S SEAFOOD, STEAK AND CRABH Restaurant 694 2252719 VOLCANO SUSHI CAFE Restaurant 695 2252720 MR. TACOS RESTAURANT Restaurant 696 2252721 JACKSON TAVERN Restaurant 697 2252722 PENNY'S NOODLE SHOP Restaurant 698 2252723 SWEDISH AMERICAN MUSEUM Restaurant 699 2252724 HERMOSA Restaurant 700 2252725 LIFE'S SWEETINC Bakery 701 2252726 POKE POKE Restaurant 702 2252727 POTBELLY SANDWICH SHOP Restaurant 703 2252728 LOUISIANA FAMOUS FRIED CHICKEN Restaurant 704 2252729 MICHAEL FARADAY ELEMENTARY School 705 2252731 MORENA'S KITCHEN Restaurant 705 2252732 Habanero Restaurant 707 2252733 NINIA SUSHI Restaurant 708 2252734 William H. Ray Elementary School 709 2252735 SKYLARK Restaurant 710 2252736 RICOBENES ON 26TH STREET Restaurant 2252738 NEW CHINA BUFFET Restaurant 712 2252739 MANOLO'S TAMALES 3 Restaurant 7.13 2252740 SUGAR FACTORY Resturant 714 2252741 Polish Food Restaurant 715 2252742 SUBWAY Restaurant 716 2252743 DAVID'S GRILL Restaurant 712 2252740 BACCI PIZZA Restaurant 718 2252745 KAI SUSHI Restaurant 719 2252746 BROWN BAG SEAFOOD CO Restaurant 720 2252747 WESTERN CAFE Restaurant 721 2252748 OPEN OUTCRY Restaurant 722 2252749 SUNSET PHO CASE Restaurant 123 2252750 O SHAUGHNESSYS PUBLIC HOUSE Restaurant 724 2252751 SUBWAY Restaurant 225 2252752 ROYAL SUSHI Restaurant Inspection Results Risk Location 1 3 2 3 5 4 5 4 1/17/21 1/17/21 D 1/17/21 A 1/17/21 B 1/17/16 1/17/21 A 1/17/21 8 1/17/21 B 1/17/218 1/17/21 A 1/17/21 8 1/17/2210 1/17/21 A 1/17/21 A 1/17/21 A 1/17/21 B 1/17/21 A 1/17/21 D 1/17/21 8 1/17/21 B 1/17/21 A 1/17/21 A 1/27/213 1/17/210 1/17/21 0 1/17/210 1/17/21 A 1/17/21 A 1/17/21 A 1/27/21 A 1/17/210 1/17/210 1/17/18 1/17/21 A 1/27/21 A 1/17/21 B 1/17/21 A 1/17/21 A 1/1721 A 1/17221A 1/17/21 A 1/17/13 1/17/21 8 1/17/213 3 0 2 4 + 3 231 2 3 1 2 3 2 4 1 5 4 1 2 1 2 2 5 5 1 3 1 2 2 2 4 1 1 5 1 1 2 Result + Rendy Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 AA 2 Wrap Text Paste B 1 U AA lili 100 ill Merge & Center C2 xfx 2250 A B D E F a H 1 Risk Code 2 3 Risk Level 1 Extremely High 2 High 3 Medium 4 Low C Revenue 2250 1750 1000 750 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 26 25 26 27 28 29 30 31 32 33 34 35 36 37 33 39 40 41 43 44 Inspection Results Risk Location Results + Home Insert Draw Page Layout Formulas Data Review View Tell me 10 Calibri (Body) 11 ' ' 2 Wrap Text Paste V BIU 3 === Merge & Cel C18 A x fx A B D E F G H Nm 1 Location Code City 2 1 Baltimore 3 2 Phoenix 4 3 Hartford 5 4 Cleveland 6 5 San Jose 7 8 9 10 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 28 39 40 41 42 43 Inspection Results Rink Loction Results + Formulas Data Review View Tente Home Insert Draw Page Layout 101 2. Wrap Tex X Calibri (Body) ' 11 v ilil Merge & v 111 Paste B I U v B8 . x fx F G E G H C D Refund Owed 2500 0 3000 0 B 1 Inspection Results Inspection Type 2A Health Inspection-Fail 3B Health Inspection-Pass 4 C Safety Inspection-Fall 5D Safety Inspection-Pass 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 44 Inspection Results Risk Location Results + Ready Pone Descriptive Analytic Project Spring 2022 Task: Utilizing your assigned file only (see file 3. File Assignments), perform a descriptive analysis over the data that provides a comprehensive overview of "What happened" / "What is happening". Utilize the extra information provided to provide management with solutions or additional insights based on the guidance received below. Each dataset has its own specific information (see below). Tools: Students are expected to utilize Excel or Tableau or both! In all cases, the data can be explored in multiple different ways. Your task is to be creative yet thorough. Use as many data fields as possible in your analysis. The tool you choose is entirely up to you. However, you MUST include AT LEAST 3 visualizations (bar charts, pie charts, histograms, bubble charts, etc.). Deliverable: A PowerPoint Presentation that highlights your findings and includes commentary as if you were presenting the PowerPoint in front of the class. Under each slide, insert comments as if you were presenting live to the class in the comments. This is the "Notes" portion of the slide. Your PowerPoint should be roughly 8-9 slides with a max of 10 slides, It is recommended to stick close to the following. This is only a suggestion 1. Title Slide 2. Intro Slide 3. 2-3 Slides of descriptive analytics, breaking down the data by the information provided 4. 2-3 Slides devoted to specifically addressing Management's question. These are found in next few pages of this document, 5. Conclusion slide stys Pane File 1: Health and Safety Inspections You are in the business of providing consulting services for clients that need to pass health and safety inspections to stay in business. You are trying to raise capital to expand your business and are giving a meeting next week to some angel investors. Describe the first-year business results and determine whether or not this is a profitable venture. You get paid revenue up front for your services, but if you fail to live up to the job you must provide refunds. You make the following upfront revenues from clients based on their level of risk: o Extremely High Risk = $2,250 High Risk = $1,750 Medium Risk = $1,000 O Low Risk $750 If a client passes their initial inspection, the business arrangement is done, and you keep all of the revenue. If a client fails a health inspection, you refund the client a flat fee of $2,500. If a client fails a safety inspection, you refund the client a flat fee of $2,000 Requirements: 1. Create 4 descriptives that provide insights into the profitability of the venture. Each of the following variables MUST show up in at least once: o Inspection Date (feel free to analyze by month) o Facility Type Risk Level o Inspection Type Revenue Refund Income (Revenue - Refund) You o O sh (United States Heading 2 Title Sty Pa iveurum RISKIVOU Low Risk $750 If a client passes their initial inspection, the business arrangement is done, and you keep all of the revenue. If a client fails a health inspection, you refund the client a flat fee of $2,500. If a client fails a safety inspection, you refund the client a flat fee of $2,000 Requirements: 1. Create 4 descriptives that provide insights into the profitability of the venture. Each of the following variables MUST show up in at least once: o Inspection Date (feel free to analyze by month) Facility Type Risk Level Inspection Type Revenue Refund o Income (Revenue - Refund) 2. A descriptive that answers the following: Are healthy and safety inspections profitable ventures in each of the cities? O O Home Inspecti Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 V GA Wrap Text Paste GE $ B I U HE v = = Merge & Center $ J9 fx D Risk Code E Location 1 4 2 3 1 5 3 2 4 1 4 1 3 3 1 1 3 2 2 3 4 3 1 1 5 4 4 3 1 3 5 1 2 5 3 3 2 4 B c 1 Inspection ID Business Name Facility Type 2 2243957 TWO MILE COFEE BAR Restaurant 3 2243958 FAMILY DOLLAR Grocery Store 4 2243959 CARMELO'S TACO PLACE Restaurant 5 2243960 AVONDALE COFFEE AND GRILL HOUSE Restaurant 6 2243961 MR. POLLO Restaurant 7 2243962 COMMUNITY FOOD MART Restaurant 8 2243963 WINGSTOP Restaurant 9 2243964 EL LLANO RESTAURANT Restaurant 10 2243965 CHINA PALACE Restaurant 11 2243966 EL CENTENARIO SPORTS BAR & GRILL Restaurant 12 2243967 MAGGIE GYROS & CHICKEN Restaurant 13 2243968 REMIS BARBEQUE AND CHICKEN Restaurant 14 2243969 RENALDI'S PIZZA Restaurant 15 2243971 JEWEL/STARBUCKS Grocery Store 16 2243972 MANOLOS TAMALES, INC. Restaurant 17 2243973 SUPER FOOD MART Grocery Store 18 2243975 Hash Restaurant 19 2243978 DELI & MORE Grocery Store 20 2243979 NORTHERN TRUST FOOD HALL Restaurant 21 2243980 J&C FOOD MARKET CARNECERIA Y FRUTE Grocery Store 22 2243981 BONGO ROOM Restaurant 23 2243982 ERNST PRUSSING ELEMENTARY SCHOOL School 24 2243983 REWIRED CAFE Restaurant 25 2243984 LA LUNA Restaurant 26 2243985 Whole Foods Market Grocery Store 27 2243987 BLUE SKY BAKERY & CAFE Restaurant 28 2243988 LA LUNA Restaurant 29 2243989 Kitchen Sink Restaurant 30 2243990 DUNKIN DONUTS BASKIN ROBBINS Restaurant 31 2243991 GARFIELD GYROS Restaurant 32 2243994 INSPIRATION CORPORATION Restaurant 33 2243995 TAQUERIA MIUNOA HACIENDA Restaurant 34 2243997 HOLY TACOL Restaurant 35 2243998 NATYS PIZZA Restaurant 36 2243999 Northern Trust Bark, Brecutive Dining Restaurant 37 2244000 MIDDLE BROW Restaurant 38 2244001 Habanero Restaurant 39 2244002 AFC SUSHI Restaurant 40 2244003 MIDDLE BROW Restaurant 41 2244004 NANDO'S Restaurant 42 2244005 MODLE BROW Restaurant 43 2244006 SHIRLEY'S CAFE Restaurant 44 2244007 NOONOKARAB Restaurant Inspection Results Risk Location Ready NNNNN 2 3 1 1 F G Inspection Dat Inspection Results 1/2/21 B 1/2/21 8 1/2/21 8 1/2/21 A 1/2/21 A 1/2/21 B 1/2/21 1/2/21 A 1/2/21 1/2/21 8 1/2/21 A 122/21 B 1/2/21 B 1/3/21 B 1/3/21 A 1/3/21 B 1/3/21 A 1/3/218 1/3/21 B 1/3/21 A 1/3/21 C 1/3/21 A 1/3/21 B 1/3/21 A 1/3/213 1/3/21 1/3/21 B 1/3/21 A 1/3/21 B 1/3/21 A 1/3/21 A 1/3/21 a 1/3/21 A 1/3/21 8 1/3/21 B 1/3/21 8 1/3/21 B 1/3/21 1/3/21 B 1/3/21-5 1/3/21 A 1/3/21 1/3/213 3 4 3 2 1 3 3 4 1 2 1 4 4 1 1 2 5 5 2 2 1 1 2 5 5 5 4 2 3 1 2 2 4 2 4 4 3 1 2 3 4 1 1 Results + ON AutoSave Page Layout 4. Health_Inspection Home Insert Draw Formulas Data Review View Tell me X Calibri (Body 11 ' III Paste Gene B 1 U a.A- 29 Wrap Text Merge & Center $ 19 x x D E 4 45 46 47 45 49 50 51 4 1 2 2 4 1 3 2 3 1 2 1 4 1 2 3 3 4 1 1 2 3 4 53 54 55 56 57 58 59 60 61 62 63 54 65 65 -57 68 69 70 71 72 73 74 75 76 77 73 79 BO 1 2 3 5 3 + 3 2 5 3 5 3 5 4 1 2244008 JIMMY JOHNS SANDWICH SHOPS Restaurant 2244009 NOONOKABAB Restaurant 2244010 BURGER FEDERATION (321) Restaurant 2244011 FINE FAIR FOOD & LIQUOR Grocery Store 2244012 Seven Seas Submarine Restaurant 2244013 LOTUS SEED Restaurant 2244014 N Restaurant 2244015 BURGER FEDERATION (1321) Restaurant 2244015 FRANK & MARYS Restaurant 2244017 NOONOKABAB Restaurant 2244018 NEW TEA GARDEN CHOP SUEY Restaurant 2244020 FRANK'S FOOD MART Grocery Store 2244021 YOUNG'S RESTAURANT Restaurant 2244022 JANMYBURGER Restaurant 2244023 PRETA MANGER Restaurant 2244024 KAMEYA Restaurant 2244025 HEALTHCARE ALTERNATIVE SYSTEMS Restaurant 2244026 FRUTERIA ANDY R2 Grocery Store 2244027 SUBWAY SANDWICH STORE Restaurant 2244028 LA TORTA CHILANGAR Restaurant 2244029 BUB CITY Restaurant 2244030 HILDA'S KITCHEN INC Restaurant 2244031 THE SCOUT Restaurant 2244032 PICANTE TAQUERIA Restaurant 2244033 MORENAS KITCHEN Restaurant 2244035 The Dark Horse Tap and Grill Restaurant 2244035 HAROLDS 82 Restaurant 2244037 WENDY'S Restaurant 2244038 SUBWAY Restaurant 2244039 MARTYRS Restaurant 2244070 SUBWAY SANDWICH Restaurant 2244168 ROLANDO TACO'S Restaurant 2252333 HERMOSA Restaurant 2244041 JOHNNA CAFE Restaurant 2244042 LA HACIENDITATAQUERIA Restaurant 2244043 MAC KELLYS GREENS & THONGS Restaurant 2244044 DORE ELEMENTARY SCHOOL School 2244045 HARBORSIDE INTERNATIONAL CLUBHOUS Restaurant 224.6046 CENACLE RETIREMENT Restaurant 2244047 BELMONTSNACK SHOP Restaurant 2244048 HASHBROWNS Restaurant 22.44049 SUBWAY Restaurant 2244050 LYFE KITCHEN Restaurant 2244051 JOSEPH'S FINEST MEATS Grocery Store Inspection Results Risk Location Ready 1/3/21 A 1/3/218 1/3/218 1/3/21 8 1/3/218 1/3/21 1/3/21 A 1/3/213 1/3/21 22.21 A 1/3/21 8 1/3/21 A 1/3/218 1/3/21 C 1/3/21 A 1/2/21 5 1/3/21 1/3/21 1/3/21 11/21 A 1/3/21 a 1/3/2113 1/3/210 1/3/21 A 1/3/21 A 1/3/21 A 2 2 4 2 1 2 3 3 2 3 1 5 2 3 4 3 4 2 1 2 2 1 1/3/215 1/3/21 1/3/21 A 1/3.21 1/3/21 A 1/1/21 1/4/21 1/4/21 5 1/4/21A 14/21 A 1213 1/4/21 A 5 5 3 2 2 5 1 2 5 + 5 4 5 5 4 82 83 34 5 85 87 88 4 3 1/4/21 A 1/421 A 1/4/21 A 1/4/21 Results + w AutoSave ON 4. Health_inspections Tell me Home Insert Draw Page Layout Formulas Data Review View X Calibri (Body) 11 == Genere Paste 8 IU 2 Wrap Text Marge & Center v A DI ill Inl $ 19 3 c D F G 88 985 4 2 5 4 1 2 4 1 2 2 1 3 4 3 3 3 1 3 1 1 4 4 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 102 108 109 110 111 112 113 114 115 116 + 2 1 1 3 4 5 5 3 1 3 1 2 1 2244051 JOSEPH'S FINEST MEATS Grocery Store 2244052 SUBWAY Restaurant 2244053 EASY LIVING JUICE BAR LLC Restaurant 2244054 EINSTEIN BROS BAGELS Restaurant 2244055 SUBWAY Restaurant 2244056 SUBWAY Restaurant 2244057 SUPER TAQUERIA ELTACONAZO EL TIO Restaurant 2244059 SUNLIGHT CAFE Restaurant 2244060 SUBWAY 47512 Restaurant 2244061 CAFE TOLA II Restaurant 2244062 PROTEIN BAR Restaurant 2244063 LALO'S MEXICAN RESTAURANT Restaurant 2244064 JEWEL FOOD STORE 3345 Grocery Store 2244065 RYO SUSHI Restaurant 2244066 NORTH POND CAFE Restaurant 2244067 LA MICHOACANA AZTECA Restaurant 2244068 LE PARIS BAKERY NO 3 Restaurant 2244069 JIMMY JOHNS Restaurant 2244071 MARIANO'S Grocery Store 2244072 TIMOTHY O'TOOLE'S Restaurant 2244074 DRAGON LADY LOUNGE Restaurant 2244075 PUNKY'S PIZZA AND PASTA Restaurant 2244076 HALAIN Restaurant 2244072 ASIAN TOWN NOODLES Restaurant 2244078 TRASPASADA RESTAURANT Restaurant 2244079 OBEROIS INDIAN FOOD Restaurant 2244080 SHARKS FISH AND CHICKEN Restaurant 2244081 OBEROIS INDIAN FOOD & GROCERYINC Restaurant 2244082 CHIPOTE MEXICAN GRILL Restaurant 2244083 THE FLOWER FLAT Restaurant 2244084 EL PACIFICO Restaurant 2244085 STAR EAST Restaurant 2244086 CAFECITO Restaurant 2244087 PANTRY EXPRESS Grocery Store 2244088 CHIPOTLE Restaurant 2244089 FINLEY DUNNE'S Restaurant 2244090 CAFETERIA MARCELAS Restaurant 2244092 LA MICHOACANAD BEATRIZ & ALMA Restaurant 2244093 WOK CUISINE Restaurant 2244094 580 SUPPLY Restaurant 2244095 NARANIA DULCE Restaurant 2244096 THE LAR ON BUENA Restaurant 2244097 Durango Pizzeria Resturant As wVID RETARIAT Inspection Results Risk Location Ready 1 2 3 1 2 1 1/4/21 8 1/4/21 B 1/4/21 8 1/4/21 B 1/4/21 8 1/4/21 8 1/4/21 A 1/4/21 8 1/4/21 A 1/4/21 B 1/4/21 1/4/21 a 1/4/21 A 1/4/213 1/4/21 A 1/4/21 A 1/4/21 A 1/4/21 C 1/4/21 B 1/4/21 a 1/4/21 8 1/4/21 1/4/21 A 1 1C 1/4/21 1/421 C 1/4/21 A 1/4/21 A 1/4/21 1/4/21 A 1/4/21 5 1/4216 1/4/21 0 1/4/21 1/4/213 1/4/21 1/4/21 B 1/4/21 0 1/4/21 A 1/4/21 A 1/4/21 1/4/21 0 1/4/21 A 3 1 1 3 1 3 3 S 4 117 5 1 4 1 3 1 3 2 4 4 4 118 119 120 121 122 122 124 125 126 127 128 129 130 12 4 2 1 3 5 3 5 2 2 1 3 3 1 1 Results + Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 ' == Gener 2Wrap Text Merge & Center Paste B 10 I U IM IM J9 ex fx A D E NN 2 2 2 1 1 1 1 5 1 2 3 2 4 4 2 2 2 4 5 4 5 5 3 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 145 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 154 165 165 167 16 169 170 171 172 173 174 1 2244098 WING YIP RESTAURANT 2244101 NELLA PIZZA PASTA 2244104 BURKE'S 2244106 CHICAGO DIPLOMAT CAFE 2244107 GAO'S KABOB 2244102 DONI DESSERT AND PASTRY 2244103 JOHNSON'S REAL ICE CREAM 2244105 LA LLAMARADA RESTAURANT 2244108 IMMY JOHNS SANDWICH SHOP 2244109 CANDLELIGHT 2244110 Dixon 2244111 Edgebrook 2244112 SUBWAY 2244113 ARMOUR ELEMENTARY SCHOOL 2244114 TBD 2244115 SUBWAY 2244116 TJ JAMAICAN JERK CHICKEN 2244118 South Loop Elementary 2244120 Beaublen Elementary School 2244121 GUNSAULUS ELEMENTARY 2244122 CICERO & NORTH FOOD & LIQUOR 2244123 SUBWAY 2244124 CHARTWELL'S DINING 2244125 Gale Community Academy 2244126 CICERO & NORTH FOOD & LIQUOR 2244127 LUNA EMPANADASHOP 2244128 JAY'S BACKYARD BBQ 2244129 CONVENE 2244130 DUNKIN DONUTS 2244131 TASTY PLACE 2244132 Shoop 2244133 BERNARD MOOS ELEMENTARY SCHOOL 2244134 CONVENE 2244136 McDade Classical 2244137 TASTY CHICKEN & SALAD FOOD MART 2244138 CHARLEY NOBLE 2244139 Walgreens 7559 2244140 ARMOUR BRANCH 2244143 LOU MALNATIS PUZZERIA 2244144 JEWEL FOOD STORE 3470 2244145 De Diego Community 2244146 ONE STOP SHOP 2244147 ELIARDIN RESTAURANT 2244148 AFC SUSHI JEWEL OSCO 3470 Inspection Results Risk 4 2 3 4 2 1 4 4 4 2 3 1 3 3 Restaurant Restaurant Restaurant Restaurant Restaurant Bakery Restaurant Restaurant Restaurant Restaurant School School Restaurant School Grocery Store Restaurant Restaurant School School School Grocery Store Restaurant Restaurant School Grocery Store Restaurant Restaurant Restaurant Restaurant Bakery School School Restaurant School Restaurant Restaurant Grocery Store School Restaurant Grocery Store School Grocery Store Restaurant Grocery Store Location 3 1 1 2 2 4 1 1 1/4/21 A 1/4/21 A 3/4/21 B 1/4/21 A 1/4/21 A 1/7/21 A 177/21 B 1/7/21 8 1/21 B 1/7/21 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 8 1/8/21 8 1/8/21 A 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 B 1/8/21 8 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 B 1/8/21 B 1/8/21 1/8:21 A 1/8/21 B 1/8/21 1/8/21 1/8/21 B 1/8/21 A 1/8/21 1/8/21 A 1/8/21 A 1/8:21B 1 1 4 2 2 3 3 3 4 2 2 4 2 3 2 1 3 1 1 1 2 5 1 4 1 5 2 3 3 2 1 Results + + Ready AutoSave ON 4. Health_Inspectior Home Insert Draw Page Layout Formulas Data Review View Tell me [D Calibri (Body) 11 ' ' 29 Wrap Text Gen Paste B CA y === Merge & Center $ 19 Xfx 0 D G 1 5 1 4 3 1 1 5 1 1 5 4 4 2 4 3 182 183 1 4 1 3 1 4 2 4 4 4 2 1 4 2 4 2 4 195 174 2244148 AFC SUSHIJEWEL OSCO 13470 Grocery Store 175 2244149 WENDY'S Restaurant 176 2244150 EAT AND RUN NFP Restaurant 177 2244151 UNCLE JOE'S JERK CHICKEN & FISH Restaurant 178 2244152 MAIN KITCHEN Restaurant 179 2244153 GAO'S KABOB Restaurant 180 2244154 M&M STOP & SHOP Grocery Store 181 2244155 Neil School 2244156 BEREKE RESTAURANT Restaurant 2244157 BORELLI'S Restaurant 184 2244158 ATHENIAN ROOM RESTAURANT Restaurant 185 2244159 SHANGHAI TERRACE Restaurant 126 2244160 PIERROT GOURMET Restaurant 187 2244161 AMAZON GO Grocery Store 188 2244162 TASTE OF CANTON Restaurant 189 2244163 LOS GAMAS TORTILLAS Y RESTORANTE Restaurant 190 2244164 AMAZON GO Grocery Store 191 2244165 FOUR SEASONS NOODLES Restaurant 192 2244166 YUMMY YUMMY NOODLES Restaurant 193 2244167 UGO'S Restaurant 194 2244169 ALIBABA CAFE Restaurant 2244170 POTBELLY SANDWICH SHOP Restaurant 196 2244171 FIRST SLICE PIE CAFE Restaurant 197 2244172 ROLANDO TACO'S Restaurant 398 2244174 CANTINA LAREDO Restaurant 199 2244175 SAM'S CHICKEN AND RIBS, PIZZA Restaurant 200 2244177 LOU MALNATIS PIZZERIA Restaurant 201 2244178 LA TORTA CHILANGAN2 Restaurant 202 2244179 PENINSULA CHICAGO, LLC Restaurant 203 2244110 TACO BELL Restaurant 204 2244181 NEW TEA GARDEN CHOP SUEY Restaurant 205 2244182 TAQUERIA SUPER BURRSTO Restaurant 206 2244183 YAMON JERK GRILL Restaurant 207 2244184 MRPATS HOAGY AND STEAK SANDWICH Restaurant 208 2244185 LAGRANIA RESTAURANT Restaurant 2244186 POPEYES FAMOUS FRIED CHICKEN Restaurant 210 2244187 MOGEE'S TAVERN & GRILLE Restaurant 231 2244188 SEE THRU CHINESE KITCHEN Restaurant 212 2244189 MIDOLE BROW Restaurant 213 14100 KIN Restaurant 214 2244191 STARBUCKS COFFEE #232 Restaurant 215 2244192 MIDOLE BROW Restaurant 216 2244193 MIDOLE BROW Restaurant 212 2244194 TURKEY CHOP Restaurant Inspection Results Risk Location Ready 3 1 2 3 1 5 2 3 3 4 2 5 1 2 3 2 5 2 4 5 2 1 1 1/8/21 B 1/8/21 A 1/8/21 c 1/8/21 A 1/8/21 B 1/8/21 B 1/8/21 8 1/8/21 A 1/8/21 8 1/8/21 1/8/21 B 1/8/21 B 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 B 1/8/21 A 1/8/21 0 1/8/21 B 1/8/21 A 1/8/21 B 1/8/21 A 1/8/21 A 1/8/21 8 1/8/21 B 1/8/21 A 2/8/21 A 1/8/21 D 1/8/218 1/8/21 8 1/8/21 D 1/8/21 A 1/8/21 A 1/8/21 A 1/8/21 A 1/8/218 1/8/21 A 1/8/210 1/8/21 0 1/8/21 A 1/8/21 A 1/8/21 0 1/8/21 1/8/215 4 4 1 2 2 4 1 2 1 3 209 2 2 3 1 2 5 4 4 2 2 3 3 4 3 2 + 3 4 5 4 Results + Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 ' Gene Paste Wrap Text Merge & Center . I U v 5 10 ilil $ J9 fx D G 17 218 3 3 19 4 4 4 2 2 2 2 4 3 2 4 4 4 4 3 2 3 4 2 3 4 3 3 4 220 221 12:22 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 245 247 248 249 250 3 4 2 2 2 4 A B w 2244194 TURKEY CHOP 2244195 C'EST BIEN THAI 2244197 Ashe 2244198 FAMILY DOLLAR 2244199 TWEET 2244201 Washington Irving School 2244202 COLECTIVO COFFEE ROASTERS 2244204 LE PAIN QUOTIDIEN 2244205 Savanna Restaurant 2244208 Eugene Field 2244209 LA MICHOACANAD BEATRIZ & ALMA 2244210 ST. RICHARD SCHOOL 2252211 HOTEL CHICAGO 2252212 CHICAGO DIPLOMAT CAFE 2252213. HOTEL CHICAGO 2252214 SEE THRU CHINESE KITCHEN 2252216 PIRIE FINE ARTS ACADEMY 2252217 BRYN MAWR BREAKFAST CLUB 2252218 ANTOJITOS COLOMBIANOS 2252219 GOETHE ELEMENTARY SCHOOL 2252220 SEE THRU CHINESE KITCHEN 2252221 LASALLEU MAGNET SCHOOL 2252222 CHAPPELL SCHOOL 2252223 CERES CAFE 2252224 LAMICHOACANA AZTECA 2252225 DIMDIM FOOD INC 2252226 CELLARS MARKET 2252227 MARIANO'S FRESH MARKET 2252228 CALIFORNIA SUB & FAST FOOD 2252229 SUBWAY 48735 2252230 SALVATORE'S 2252231 FLUBADUB CHUB'S 2252233 LE PARIS BAKERY 2252234 WINDY CITY 80 2252235 DUNKIN DONUTS/ BASKIN ROBBINS 2252236 PANTRY EXPRESS 2252237 WINDY CITY BBQ 2252238 FESTA GRILL 2252239 O'DONOVAN'S 2252240 GRILL AND GARDEN 2252241 TACO BELL 2252242 VISANU THAI 5S, INC. 2252243 CAFFE BACHINC 4 4 3 3 2 2 5 1 4 Restaurant Restaurant School Grocery Store Restaurant School Restaurant Restaurant Restaurant School Restaurant School Restaurant Restaurant Restaurant Restaurant School Restaurant Restaurant School Restaurant School School Restaurant Restaurant Restaurant Restaurant Grocery Store Restaurant Restaurant Restaurant Restaurant Restaurant Restaurant Restaurant Grocery Store Restaurant Restaurant Restaurant Restaurant Restaurant Restaurant Restaurant 4 1 1 3 1 1 1/8/21 B 1/8/21 A 1/9/21 A 1/9/21 B 1/9/21 A 1/9/21 A 1/9/21 A 1/9/21 A 1/9/21 8 1/9/21 8 1/9/21 D 1/9/21 B 1/9/21 B 1/9/21 A 1/9/21 A 1/9/21 B 1/9/21 B 1/9/21 B 1/9/21 8 1/9/21 B 1/9/21 B 1/9/21 8 1/9/21 B 1/9/21 B 1/9/21 c 1/9/21 A 1/9/21 B 1/9/21 A 1/9/21 A 1/9/21 A 1/9/21 B 1/9/21 A 1/9/21 8 1/9/21 C 1/9/21 A 1/9/21 1/9/21 C 1/9/21 A 1/9/213 1/9/21 A 1/9/21 c 1/9/21 A 1/9/210 2 1 1 4 4 1 14 4 4 1 3 1 251 1 2 4 3 1 3 5 1 2 5 2 1 2 1 4 4 3 1 3 3 1 252 253 254 255 256 257 258 259 4 2 2 1 2 Inspection Results Risk Location Results + + UU 4. Health_Inspection Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 ' ' = 2 Wrap Text Gen Paste B I U Av = lili 2010 ill 191 IM Merge & Center $ J9 + x V fx A B C D E F 687 3 3 4 4 2 2 4 3 1 3 1 1 2 3 4 4 2 2 1 2 4 3 4 2 2 5 3 S 3 3 4 5 5 4 2 4 1 2 1 682 2252707 FAMILY STYLE PIZZA Restaurant 683 2252708 ONE ELEVEN FOOD & LIQUOR Grocery Store 684 2252709 WAFFLES Restaurant 685 2252710 RAY HARRINGTON CATERING COMPANY Restaurant 686 2252711 BUONA Restaurant 2252712 Subway Restaurant 688 2252713 GRACE CHRISTIAN ACADEMY School 689 2252714 EL GARCIA RESTAURANT Restaurant 690 2252715 WALSH ELEMENTARY School 691 2252716 SHARKS FISH & CHICKEN Restaurant 692 2252717 LABAMBA Restaurant 693 2252718 TRULUCK'S SEAFOOD, STEAK AND CRABH Restaurant 694 2252719 VOLCANO SUSHI CAFE Restaurant 695 2252720 MR. TACOS RESTAURANT Restaurant 696 2252721 JACKSON TAVERN Restaurant 697 2252722 PENNY'S NOODLE SHOP Restaurant 698 2252723 SWEDISH AMERICAN MUSEUM Restaurant 699 2252724 HERMOSA Restaurant 700 2252725 LIFE'S SWEETINC Bakery 701 2252726 POKE POKE Restaurant 702 2252727 POTBELLY SANDWICH SHOP Restaurant 703 2252728 LOUISIANA FAMOUS FRIED CHICKEN Restaurant 704 2252729 MICHAEL FARADAY ELEMENTARY School 705 2252731 MORENA'S KITCHEN Restaurant 705 2252732 Habanero Restaurant 707 2252733 NINIA SUSHI Restaurant 708 2252734 William H. Ray Elementary School 709 2252735 SKYLARK Restaurant 710 2252736 RICOBENES ON 26TH STREET Restaurant 2252738 NEW CHINA BUFFET Restaurant 712 2252739 MANOLO'S TAMALES 3 Restaurant 7.13 2252740 SUGAR FACTORY Resturant 714 2252741 Polish Food Restaurant 715 2252742 SUBWAY Restaurant 716 2252743 DAVID'S GRILL Restaurant 712 2252740 BACCI PIZZA Restaurant 718 2252745 KAI SUSHI Restaurant 719 2252746 BROWN BAG SEAFOOD CO Restaurant 720 2252747 WESTERN CAFE Restaurant 721 2252748 OPEN OUTCRY Restaurant 722 2252749 SUNSET PHO CASE Restaurant 123 2252750 O SHAUGHNESSYS PUBLIC HOUSE Restaurant 724 2252751 SUBWAY Restaurant 225 2252752 ROYAL SUSHI Restaurant Inspection Results Risk Location 1 3 2 3 5 4 5 4 1/17/21 1/17/21 D 1/17/21 A 1/17/21 B 1/17/16 1/17/21 A 1/17/21 8 1/17/21 B 1/17/218 1/17/21 A 1/17/21 8 1/17/2210 1/17/21 A 1/17/21 A 1/17/21 A 1/17/21 B 1/17/21 A 1/17/21 D 1/17/21 8 1/17/21 B 1/17/21 A 1/17/21 A 1/27/213 1/17/210 1/17/21 0 1/17/210 1/17/21 A 1/17/21 A 1/17/21 A 1/27/21 A 1/17/210 1/17/210 1/17/18 1/17/21 A 1/27/21 A 1/17/21 B 1/17/21 A 1/17/21 A 1/1721 A 1/17221A 1/17/21 A 1/17/13 1/17/21 8 1/17/213 3 0 2 4 + 3 231 2 3 1 2 3 2 4 1 5 4 1 2 1 2 2 5 5 1 3 1 2 2 2 4 1 1 5 1 1 2 Result + Rendy Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 AA 2 Wrap Text Paste B 1 U AA lili 100 ill Merge & Center C2 xfx 2250 A B D E F a H 1 Risk Code 2 3 Risk Level 1 Extremely High 2 High 3 Medium 4 Low C Revenue 2250 1750 1000 750 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 26 25 26 27 28 29 30 31 32 33 34 35 36 37 33 39 40 41 43 44 Inspection Results Risk Location Results + Home Insert Draw Page Layout Formulas Data Review View Tell me 10 Calibri (Body) 11 ' ' 2 Wrap Text Paste V BIU 3 === Merge & Cel C18 A x fx A B D E F G H Nm 1 Location Code City 2 1 Baltimore 3 2 Phoenix 4 3 Hartford 5 4 Cleveland 6 5 San Jose 7 8 9 10 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 28 39 40 41 42 43 Inspection Results Rink Loction Results + Formulas Data Review View Tente Home Insert Draw Page Layout 101 2. Wrap Tex X Calibri (Body) ' 11 v ilil Merge & v 111 Paste B I U v B8 . x fx F G E G H C D Refund Owed 2500 0 3000 0 B 1 Inspection Results Inspection Type 2A Health Inspection-Fail 3B Health Inspection-Pass 4 C Safety Inspection-Fall 5D Safety Inspection-Pass 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 44 Inspection Results Risk Location Results + Ready