Question: the following critical elements must be addressed: III. Analysis: In this section, you will analyze the data within the spreadsheets in order to understand what

the following critical elements must be addressed:

III. Analysis: In this section, you will analyze the data within the spreadsheets in order to understand what information it will provide and its relation to the business question.

A. Explain what the data actually is and how the data correlates back to the question you intend to answer.

B. Analyze the data and identify any areas that are not aligned properly. Be sure that you adjust these later to ensure that they are matched up properly.

C. Describe how you will pull all of the data together in order to make sure it works collectively and will report correctly for your needs.

D. Based on your analysis, provide a list of potential questions you could answer for management.

IV. Compiling and Cleaning the Data: In this section, you will load the relevant data into an enterprise-style system (in this case Access) and clean the data in preparation for generating a report.

A. Compile the spreadsheets you have analyzed and load them into Access in order to create a table.

B. Create a query to maintain the integrity of the original data and clean the data. For example, if you have different names within your table that actually mean the same thing, you will use the query to make the necessary changes.

C. While cleaning the data, be sure to look for and fix any incorrect, incomplete, and erroneous data.

D. Based on your initial analysis and your compiled and cleaned data, explain how it will effectively answer the business question.

the following critical elements must be

56 fa Hy-Vee Food and Drug #6 / Cedar Rapi City A B D Invoice/Item NumbeDate Store Numbe Store Name S23294000008 1/7/2015 9001 Cedar Ridge Vineyards S23424800006 1/12/2015 4154 Fareway Stores #055 / Hiawatha S23432200078 1/12/2015 3773 Benz Distributing S23530800003 1/15/2015 2652 Hy-Vee Drugstore / Mason City S23687400015 1/26/2015 2605 Hy-Vee Drugstore #5 / Cedar Rapids S23680200137 1/26/2015 2647 Hy-Vee #7 / Cedar Rapids S23695400135 1/27/2015 2620 Hy-Vee / Windsor Heights S23737500025 1/28/2015 4157 Fareway Stores #993 / North Liberty S23794400007 2/2/2015 2670 Hy-Vee Food Store / Coralville S23985000026 2/11/2015 4829 Central City 2 S24077400074 2/17/2015 2565 Hy-Vee Food Store / Spencer S24183200075 2/23/2015 2512 Hy-Vee Wine and Spirits / Iowa City S24213900003 2/24/2015 2663 Hy-Vee / Urbandale S24278800004 3/4/2015 9001 Cedar Ridge Vineyards S24584900090 3/18/2015 2572 Hy-Vee Food Store / Cedar Falls S24618100040 3/19/2015 2528 Hy-Vee Food Store #3 / Des Moines S25105800081 4/15/2015 2512 Hy-Vee Wine and Spirits / Iowa City S25208500125 4/21/2015 2552 Hy-Vee Food Store #3 / Cedar Rapids S25183800160 4/21/2015 2620 Hy-Vee / Windsor Heights S25379100007 4/29/2015 9001 Cedar Ridge Vineyards S25400100170 4/30/2015 2587 Hy-Vee Food Store / Johnston S25632900073 5/13/2015 3773 Benz Distributing S25825000033 5/26/2015 2661 Hy-Vee Food Store / Sheldon S25826200179 5/26/2015 2620 Hy-Vee / Windsor Heights S25827900006 5/27/2015 9001 Cedar Ridge Vineyards S25860500373 5/27/2015 2622 Hy-Vee Food Store / Iowa City S26075200082 6/8/2015 2512 Hy-Vee Wine and Spirits / Iowa City S26097400250 6/9/2015 2651 Hy-Vee / Waverly S26160000041 6/11/2015 2635 Hy-Vee #4 / Davenport S26138200001 6/11/2015 4537 Casey's General Store #1834 / Leon S26528300024 7/1/2015 4829 Central City 2 S26586100094 7/6/2015 2613 Hy-Vee Food Store #1 / Council Bluff S26590100077 7/6/2015 2512 Hy-Vee Wine and Spirits / Iowa City S26676100188 7/9/2015 2587 Hy-Vee Food Store / Johnston S26791500010 7/15/2015 2512 Hy-Vee Wine and Spirits / lowa City S26875900099 7/21/2015 2665 Hy-Vee / Waukee 1027CAOLA o/ 1n1 201L LAA LA.. E F G H Address Zip Code County Category Category Name 1441 MARAK RD NW SWISHER 52338 Johnson 1051010 AMERICAN GRAPE BRANDIES 885 MILLER RD HIAWATHA 52233 Linn 1051010 AMERICAN GRAPE BRANDIES 501 7TH AVE SE CEDAR RAPIDS 52401 Linn 1051010 AMERICAN GRAPE BRANDIES 875 4TH ST SW MASON CITY 50401 Cerro Gordo 1051010 AMERICAN GRAPE BRANDIES 2001 BLAIRS FERRY ROAD NE CEDAR RAPIDS 52402 Linn 1051010 AMERICAN GRAPE BRANDIES 5050 EDGEWOOD RD CEDAR RAPIDS 52411 Linn 1051010 AMERICAN GRAPE BRANDIES 7101 UNIVERSITY AVE WINDSOR HEIGHTS 50311 Polk 1051010 AMERICAN GRAPE BRANDIES 615 WESTWOOD DR P.O Box 96 NORTH LIBERTY 52317 Johnson 1051010 AMERICAN GRAPE BRANDIES 2004 8TH ST CORALVILLE 52241 Johnson 1051010 AMERICAN GRAPE BRANDIES 1501 MICHIGAN AVE DES MOINES 50314 Polk 1051010 AMERICAN GRAPE BRANDIES 819 N GRAND AVE SPENCER 51301 Clay 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 8701 DOUGLAS URBANDALE 50322 Polk 1051010 AMERICAN GRAPE BRANDIES 1441 MARAK RD NW SWISHER 52338 Johnson 1051010 AMERICAN GRAPE BRANDIES 6301 UNIVERSITY CEDAR FALLS 50613 Black Hawk 1051010 AMERICAN GRAPE BRANDIES 3221 SE 14TH ST DES MOINES 50315 Polk 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 20 WILSON AVENUE WEST CEDAR RAPIDS 52404 Linn 1051010 AMERICAN GRAPE BRANDIES 7101 UNIVERSITY AVE WINDSOR HEIGHTS 50311 Polk 1051010 AMERICAN GRAPE BRANDIES 1441 MARAK RD NW SWISHER 52338 Johnson 1051010 AMERICAN GRAPE BRANDIES 5750 MERLE HAY ROAD JOHNSTON 50131 Polk 1051010 AMERICAN GRAPE BRANDIES 501 7TH AVE SE CEDAR RAPIDS 52401 Linn 1051010 AMERICAN GRAPE BRANDIES 1989 PARK ST SHELDON 51201 O'Brien 1051010 AMERICAN GRAPE BRANDIES 7101 UNIVERSITY AVE WINDSOR HEIGHTS 50311 Polk 1051010 AMERICAN GRAPE BRANDIES 1441 MARAK RD NW SWISHER 52338 Johnson 1051010 AMERICAN GRAPE BRANDIES 1125 N DODGE ST IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 1311 4 STREET SW WAVERLY 50677 Bremer 1051010 AMERICAN GRAPE BRANDIES 4064 E 53RD ST DAVENPORT 52807 Scott 1051010 AMERICAN GRAPE BRANDIES 401 NW CHURCH ST LEON 50144 Decatur 1051010 AMERICAN GRAPE BRANDIES 1501 MICHIGAN AVE DES MOINES 50314 Polk 1051010 AMERICAN GRAPE BRANDIES 2323 W BROADWAY COUNCIL BLUFFS 51501 Pottawattamie 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 5750 MERLE HAY ROAD JOHNSTON 50131 Polk 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 1005 E HICKMAN RD WAUKEE 50263 Dallas 1051010 AMERICAN GRAPE BRANDIES CAN LINCOLMALAV AMEC conin ton 100 1010 AMACDICAMLCDADE DDAMDICO K L M N Vendor Numbe. Vendor Name Item NumbeItem Description P 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 100 cadar Dideo Visuare IC 16. Cadar Didas Draad 41 f Invoice/Item Number Invoice/Item Number S23417700010 S23417700008 S23417700004 S23417700002 S23417700005 S23417700009 S23417700007 S23417700003 S23417700006 S23786300004 2 S23786300009 S23786300010 4 S23786300001 S23786300007 5 S23786300005 7 S23786300003 BS23786300008 S23786300002 S23786300006 S23917800005 S23917800010 B S23917800007 S23917800001 5 S23917800009 5 S23917800002 7 S23917800008 S23917800012 S23917800006 S23917800004 S23917800003 2S24168000001 BS24168000007 1 S24168000003 5 S24168000005 5 S24168000002 7 S24168000006 C21Connnnn B G Date Store Number Store Name Address City Zip Code County 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar lanlan 12. Cocou Cocacolctors #2000 /Mooban 200 CLODTCT MCCLLA MCCLLLC 220c Codor Category Category Name Vendor Number - Vendor Name 1062310 SPICED RUM 260 Diageo Americas 1062310 SPICED RUM 259 Heaven Hill Brands 1031080 VODKA 80 PROOF 259 Heaven Hill Brands 1081300 PEPPERMINT SCHNAPPS 434 Luxco-St Louis 1031200 VODKA FLAVORED 380 Phillips Beverage Company 1081305 APPLE SCHNAPPS 65 Jim Beam Brands 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 260 Diageo Americas 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1011200 STRAIGHT BOURBON WHISKIES 65 Jim Beam Brands 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 434 Luxco-St Louis 1011300 TENNESSEE WHISKIES 85 Brown-Forman Corporation 1011300 TENNESSEE WHISKIES 85 Brown-Forman Corporation 1051110 BLACKBERRY BRANDIES 434 Luxco-St Louis 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1062200 PUERTO RICO & VIRGIN ISLANDS RUM 35 Bacardi U.S.A., Inc. 1031080 VODKA 80 PROOF 300 Mccormick Distilling Company 1081390 IMPORTED SCHNAPPS 421 Sazerac Co., Inc. 1081030 COFFEE LIQUEURS 370 Pernod Ricard USA/Austin Nichols 1062310 SPICED RUM 260 Diageo Americas 1031080 VODKA 80 PROOF 300 Mccormick Distilling Company 1081600 WHISKEY LIQUEUR 421 Sazerac Co., Inc. 1081900 MISC. AMERICAN CORDIALS & LIQUEURS 322 Prestige Wine and Spirits Group 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 260 Diageo Americas 1081700 DISTILLED SPIRITS SPECIALTY 384 Piedmont Distillers 1012100 CANADIAN WHISKIES 260 Diageo Americas 1022100 TEQUILA 395 Proximo 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 434 Luxco-St Louis 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 434 Luxco-St Louis 1062200 PUERTO RICO & VIRGIN ISLANDS RUM 434 Luxco-St Louis 1021000 VODA OO noor 20 L ALBUHLD.and M Item Number Item Desa 43336 Captain Morg 43026 Admiral Nels 35416 Burnett's Vod 81206 Paramount Pe 41693 Uv Blue (rasp 82606 Dekuyper Sou 10550 Black Velvet 37996 Smirnoff Vod 11788 Black Velvet 19064 Jim Beam 10550 Black Velvet 36308 Hawkeye Vod 26820 Jack Daniels 86670 Jack Daniel's 55086 Paramount BI 11774 Black Velvet 43126 Bacardi Super 36904 Mccormick Vo 69636 Dr. Mcgillicud 67524 Kahlua Coffee 43338 Captain Morg 36904 Mccormick V 64865 Fireball Cinna 75211 Kinky Liqueur 11788 Black Velvet 37996 Smirnoff Vod 76036 Midnight Mod 11294 Crown Royal 89194 Jose Cuervo E 10550 Black Velvet 36308 Hawkeye Vod 11776 Black Velvet 11788 Black Velvet 11774 Black Velvet 36306 Hawkeye Vod 45276 Paramount w 2011- Duratllad A1 for Invoice/Item Number M D 1 Invoice/Item Number - Date Store Number Store Name Address City 52 S25922800008 6/1/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 53 S25922800006 6/1/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 54 S25922800016 6/1/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 55 S25922800021 6/1/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 56 S26832200005 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 57 S26832200015 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 58 S26832200008 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 59 S26832200001 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD FO S26832200010 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 1 S26832200011 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 2 S26832200012 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 3 S26832200006 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD +4 S26832200013 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 5 S26832200004 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 16 S26832200009 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD -7 S26832200014 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 18 S26832200016 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 19 S26832200007 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD BO S26832200002 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 31 S26832200003 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 2 S28776500001 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 3 S28776500006 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 34 S28776500009 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 35 S28776500008 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 36 S28776500002 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 37 S28776500013 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 88 S28776500015 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 89 S28776500011 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 20 S28776500005 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 1 S28776500012 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 2 S28776500003 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 3 S28776500004 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 34 528776500007 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 25 S28776500014 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 6 S28776500010 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 37 H Zip Code County Number County Category Category Name 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1012100 CANADIAN WHISKIES 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1081600 WHISKEY LIQUEUR 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1032200 IMPORTED VODKA - MISC 52337 16 Cedar 1031200 VODKA FLAVORED 52337 16 Cedar 1081600 WHISKEY LIQUEUR 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1081390 IMPORTED SCHNAPPS 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1081200 CREAM LIQUEURS 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1081600 WHISKEY LIQUEUR 52337 16 Cedar 1032080 IMPORTED VODKA 52337 16 Cedar 1012100 CANADIAN WHISKIES 52337 16 Cedar 1031200 VODKA FLAVORED 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1011300 TENNESSEE WHISKIES 52337 16 Cedar 1022100 TEQUILA 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1062300 FLAVORED RUM 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1081390 IMPORTED SCHNAPPS 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1022100 TEQUILA 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1011200 STRAIGHT BOURBON WHISKIES 52337 16 Cedar 1012100 CANADIAN WHISKIES Vendor Number - Vendor Name 434 Luxco-St Louis 55 Sazerac North America 300 Mccormick Distilling Company 259 Heaven Hill Brands 115 Constellation Wine Company, Inc. 434 Luxco-St Louis 259 Heaven Hill Brands 421 Sazerac Co., Inc. 297 Laird And Company 260 Diageo Americas 380 Phillips Beverage Company 85 Brown-Forman Corporation 260 Diageo Americas 55 Sazerac North America 421 Sazerac Co., Inc. 434 Luxco-St Louis 300 Mccormick Distilling Company 259 Heaven Hill Brands 421 Sazerac Co., Inc. 420 Moet Hennessy USA, Inc. 115 Constellation Wine Company, Inc. 380 Phillips Beverage Company 55 Sazerac North America 85 Brown-Forman Corporation 395 Proximo 55 Sazerac North America 370 Pernod Ricard USA/Austin Nichols 434 Luxco-St Louis 421 Sazerac Co., Inc. 434 Luxco-St Louis 395 Proximo 259 Heaven Hill Brands 260 Diageo Americas 65 Jim Beam Brands 260 Diageo Americas N Item Number Item Desa 36308 Hawkeye V 35946 Fleischman 36904 Mccormick 43026 Admiral Ne 11788 Black Velve 36306 Hawkeye v 43024 Admiral Ne 64863 Fireball Cin 35914 Five O'clock- 64716 Ciroc Peach 41693 Uv Blue (ras 86886 Southern C 43336 Captain Mo 35944 Fleischman 69636 Dr. Mcgillic 36308 Hawkeye V 65204 Tequila Ros 43026 Admiral Ne 64864 Fireball Cin 34155 Belvedere 11788 Black Velve 41692 Uv Blue (ras 35316 Barton Vod 26828 Jack Daniels 89196 Jose Cuervo 35944 Fleischman 42714 Malibu Coc 36306 Hawkeye V 69636 Dr. Mcgillic 36308 Hawkeye V 89194 Jose Cuervo 43026 Admiral Ne 43336 Captain Mo 27392 Jim Beam M 11296 Crown Roya 017 Dewey's Jack and Jill L S T U V Vendor Name 6 Luxco-St Louis 7 Pernod Ricard USA/Austin Nichols 8 Pernod Ricard USA/Austin Nichols 9 Pernod Ricard USA/Austin Nichols o Pernod Ricard USA/Austin Nichols 1 Pernod Ricard USA/Austin Nichols 2 Bacardi U.S.A., Inc. 3 Sazerac North America 4 Laird And Company 5 Sazerac North America 6 Luxco-St Louis 7 Luxco-St Louis 8 Mccormick Distilling Company 9 E AND J GALLO WINERY O Diageo Americas 1 Fifth Generation Inc. 2 Diageo Americas 3 Diageo Americas 4 E AND J GALLO WINERY 5 Constellation Wine Company, Inc. 6 Charles Jacquin Et. Cie., Inc. 7 Sazerac North America 8 Proximo 9 Sazerac Co., Inc. o Pernod Ricard USA/Austin Nichols 1 Pernod Ricard USA/Austin Nichols 2 Luxco-St Louis 3 4 M N Item Number Item Description 30528 Hawkeye Gin 32234 Seagrams Extra Dry Gin 32236 Seagrams Extra Dry Gin 34001 Absolut Swedish Vodka 80 Prf Mini 34006 Absolut Swedish Vodka 80 Prf 34061 Absolut Ruby Red 34423 Grey Goose Vodka 35317 Barton Vodka 35926 Five O'clock PET Vodka 35947 Fleischmann's Royal Vodka 36306 Hawkeye Vodka 36308 Hawkeye Vodka 36886 Mccormick Vodka 36969 New Amsterdam Vodka 37996 Smirnoff Vodka 80 Prf 38176 Titos Vodka 39866 Smirnoff Vodka 100 Prf 42166 Myers's Rum Original Dark 52594 E & J Vs Brandy 53214 Paul Masson Grande Amber Brandy 56957 Bartenders Hot Sex 57148 Chi-Chi's Margarita W/tequila 58868 Jose Cuervo Authentic Strawberry Margarita 64867 Fireball Cinnamon Whiskey 67524 Kahlua Coffee Liqueur 67526 Kahlua Coffee Liqueur 89387 Juarez Tequila Gold o Pack State Bottle Cost 6 6 $7.17 24 $3.39 12 $6.49 10 $7.92 12 $11.49 12 $11.49 12 $9.00 12 $3.97 12 $3.37 12 $4.00 12 $3.34 6 $7.17 12 $3.31 12 $6.90 12 $8.25 12 $9.65 12 $9.50 12 $10.00 24 $3.22 24 $3.22 12 $5.28 6 $6.00 6 $8.20 12 $11.34 24 $6.49 12 $11.99 12 $6.92 Q R State Bottle Retail Bottles Sold - $10.76 1 $5.09 6 $9.74 1 $11.88 1 $17.24 2 $17.24 1 $13.50 1 $5.96 3 $5.06 2 $6.00 2 $5.01 12 $10.76 6 $4.97 2 $10.35 6 $12.38 3 $14.48 2 $14.25 3 $15.00 1 $4.83 6 $4.83 6 $7.92 1 $9.25 1 $12.30 2 $17.01 1 $9.74 1 $17.99 1 1 $10.38 1 5 6 6 7 8 9 -0 -1 8491 X S26439100006 A B D Invoice/Item Number S26439100006 3 S26439100027 5 S26439100026 0 S26579100019 6 S26579100044 0 S26579100045 2 S26579100021 1 S26706400002 4 526833900028 5 S26833900006 7 S26833900029 2 S26968400011 4 S26968400026 6 S26968400010 4 S27098200005 O S27232300019 8 527232300003 2 S27232300014 8 S27614000003 6 S27614000005 2 S27614000004 0 S27889600049 2 S28030100010 2 S28148600014 0 S28412100004 5 S28539300017 8 S28669700017 9 S28943800017 5 S28943800006 9 S29083400025 9 S29083400026 0 S29083400004 1 S29083400023 4 S29342300044 9 S29342300011 1 S29342300045 470700nnc Date Store Number - Store Name 6/26/2015 5071 Jeff's Market / Durant 6/26/2015 5071 Jeff's Market / Durant 6/26/2015 5071 Jeff's Market / Durant 7/6/2015 5071 Jeff's Market / Durant 7/6/2015 5071 Jeff's Market / Durant 7/6/2015 5071 Jeff's Market / Durant 7/6/2015 5071 Jeff's Market / Durant 7/13/2015 5071 Jeff's Market / Durant 7/20/2015 5071 Jeff's Market / Durant 7/20/2015 5071 Jeff's Market / Durant 7/20/2015 5071 Jeff's Market / Durant 7/27/2015 5071 Jeff's Market / Durant 7/27/2015 5071 Jeff's Market / Durant 7/27/2015 5071 Jeff's Market / Durant 8/3/2015 5071 Jeff's Market / Durant 8/10/2015 5071 Jeff's Market / Durant 8/10/2015 5071 Jeff's Market / Durant 8/10/2015 5071 Jeff's Market / Durant 8/31/2015 5071 Jeff's Market / Durant 8/31/2015 5071 Jeff's Market / Durant 8/31/2015 5071 Jeff's Market / Durant 9/14/2015 5071 Jeff's Market / Durant 9/21/2015 5071 Jeff's Market / Durant 9/28/2015 5071 Jeff's Market / Durant 10/12/2015 5071 Jeff's Market / Durant 10/19/2015 5071 Jeff's Market / Durant 10/26/2015 5071 Jeff's Market / Durant 11/9/2015 5071 Jeff's Market / Durant 11/9/2015 5071 Jeff's Market / Durant 11/16/2015 5071 Jeff's Market / Durant 11/16/2015 5071 Jeff's Market / Durant 11/16/2015 5071 Jeff's Market / Durant 11/16/2015 5071 Jeff's Market / Durant 11/30/2015 5071 Jeff's Market / Durant 11/30/2015 5071 Jeff's Market / Durant 11/30/2015 5071 Jeff's Market / Durant 12/7/an1 E F Address City 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 100 CTILAC OLID ANT G H Zip Code - County Category 7 Category Name 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES Cazzicader 1011200DLEMDEN WILLS VICC K L Vendor Number Vendor Name 297 Laird And Company 260 Diageo Americas 65 Jim Beam Brands 260 Diageo Americas 260 Diageo Americas 492 Western Spirits Beverage Co. LLC 65 Jim Beam Brands 65 Jim Beam Brands 492 Western Spirits Beverage Co. LLC 434 Luxco-St Louis 260 Diageo Americas 65 Jim Beam Brands 260 Diageo Americas 260 Diageo Americas 260 Diageo Americas 260 Diageo Americas 434 Luxco-St Louis 65 Jim Beam Brands 297 Laird And Company 434 Luxco-St Louis 65 Jim Beam Brands 260 Diageo Americas 260 Diageo Americas 65 Jim Beam Brands 434 Luxco-St Louis 65 Jim Beam Brands 260 Diageo Americas 260 Diageo Americas 297 Laird And Company 260 Diageo Americas 65 Jim Beam Brands 434 Luxco-St Louis 260 Diageo Americas 260 Diageo Americas 260 Diageo Americas 65 Jim Beam Brands Discmerica M N Item Number Item Description 23826 Five Star 25604 Seagrams 7 Crown Bl Whiskey 24454 Kessler Blend Whiskey 25604 Seagrams 7 Crown Bl Whiskey 25608 Seagrams 7 Crown Bl Whiskey 27474 Bird Dog Blackberry Whiskey 24454 Kessler Blend Whiskey 24466 Kessler Blend Whiskey Traveler 27474 Bird Dog Blackberry Whiskey 24158 Hawkeye Blend Whiskey 25607 Seagrams 7 Crown Bl Whiskey 24454 Kessler Blend Whiskey 25608 Seagrams 7 Crown Bl Whiskey 25604 Seagrams 7 Crown Bl Whiskey 25608 Seagrams 7 Crown Bl Whiskey 25607 Seagrams 7 Crown Bl Whiskey 24158 Hawkeye Blend Whiskey 24457 Kessler Blend Whiskey 23828 Five Star 24158 Hawkeye Blend Whiskey 24458 Kessler Blend Whiskey 25607 Seagrams 7 Crown Bl Whiskey 25604 Seagrams 7 Crown Bl Whiskey 24454 Kessler Blend Whiskey 24158 Hawkeye Blend Whiskey 24454 Kessler Blend Whiskey 25607 Seagrams 7 Crown Bl Whiskey 25604 Seagrams 7 Crown Bl Whiskey 23828 Five Star 25608 Seagrams 7 Crown Bl Whiskey 24458 Kessler Blend Whiskey 24158 Hawkeye Blend Whiskey 25607 Seagrams 7 Crown Bl Whiskey 25604 Seagrams 7 Crown Bl Whiskey 25607 Seagrams 7 Crown Bl Whiskey 24454 Kessler Blend Whiskey DECO Cromezerou Wibickou C07-11 FEL. Mockat luant A1 foc Invoice/Item Number T U M N o P Q R S 1. Vendor Name Item Number Item Description Pack State Bottle Cost - State Bottle Retail - Bottles Sold - Sale (Dollars) 173 Phillips Beverage Company 41704 Uv Red (cherry) Vodka 12 $6.50 $9.75 2 $19.50 174 Diageo Americas 42166 Myers's Rum Original Dark 12 $10.00 $15.00 3 $45.00 175 MHW Ltd 42204 Blue Chair Bay Banana 12 $9.42 $14.13 3 $42.39 176 MHW Ltd 42242 Blue Chair Bay Coconut 12 $9.42 $14.13 2 $28.26 177 Pernod Ricard USA/Austin Nichols 42712 Malibu Coconut Rum Mini 12 $4.95 $7.43 3 $22.29 178 Pernod Ricard USA/Austin Nichols 42716 Malibu Coconut Rum 12 $7.49 $11.24 6 $67.44 179 Heaven Hill Brands 43024 Admiral Nelson Spiced Rum 24 $2.74 $4.11 10 $41.10 180 Diageo Americas 67266 Yukon Jack Canadian Liqueur 12 $9.25 $13.88 3 $41.64 181 Pernod Ricard USA/Austin Nichols 67522 Kahlua Coffee Liqueur Mini 12 $6.60 $9.90 3 $29.70 182 Pernod Ricard USA/Austin Nichols 67524 Kahlua Coffee Liqueur 24 $6.49 $9.74 3 $29.22 183 Diageo Americas 68017 Bailey's Chocolate Cherry 12 $13.49 $20.24 6 6 $121.44 184 Diageo Americas 68022 Bailey's Salted Caramel 12 $13.49 $20.24 6 $121.44 185 Diageo Americas 68036 Bailey's Original Irish Cream 12 $13.49 $20.24 6 $121.44 186 Sazerac Co., Inc. 69611 Dr. Mcgillicuddy's Apple Pie Schnapps 12 $8.32 $12.48 4 4 $49.92 187 Sazerac Co., Inc. 69634 Dr. Mcgillicuddy's Cherry Schnapps 24 $5.33 $8.00 6 $48.00 188 Sazerac Co., Inc. 69636 Dr. Mcgillicuddy's Cherry Schnapps 12 $8.67 $13.01 4 $52.04 189 Sazerac Co., Inc. 69638 Dr. Mcgillicuddy's Cherry Schnapps 6 $14.66 $21.99 6 $131.94 190 Sazerac Co., Inc. 69666 Dr. Mcgillicuddy's Vanilla 12 $8.67 $13.01 2 $26.02 191 Diageo Americas 69945 Rumple Minze Peppermint Schnapps Liqueur 12 $10.70 3 $32.10 192 Sazerac Co., Inc. 71886 Amaretto E Dolce 12 $3.34 $5.01 4 $20.04 193 Heaven Hill Brands 72722 Christian Bros Honey 12 $5.43 $8.15 3 $24.45 194 MHW Ltd 73055 Rumchata 12 $12.50 $18.75 6 $112.50 195 Prestige Wine and Spirits Group 75211 Kinky Liqueur 12 $10.00 $ $15.00 3 $45.00 196 Prestige Wine and Spirits Group 75214 Kinky Blue 12 $10.00 $15.00 1 $15.00 197 Prestige Wine and Spirits Group 75216 Kinky Gold 12 $10.00 $15.00 3 $45.00 198 Luxco-St Louis 76486 Paramount Amaretto 12 $3.38 $5.07 6 $30.42 199 Luxco-St Louis 76526 Paramount Melon Liqueur 12 $5.30 $7.95 4 4 $31.80 200 Diageo Americas 77714 Smirnoff Pineapple 12 $8.25 $12.38 2 $24.76 201 Campari(skyy) 77776 Wild Turkey American Honey 12 $10.50 $15.75 2 $31.50 202 MHW Ltd 80022 Blue Chair Bay Coconut Spiced Rum Cream 12 $10.97 $16.46 2 $32.92 203 A Hardy / U.S.A., Ltd. 80034 Brown Jug Bourbon Cream 6 $11.00 $16.50 6 $99.00 204 Prestige Wine and Spirits Group 80438 Ricura 6 $10.00 $15.00 4 $60.00 205 Luxco-St Louis 80574 Arrow Peppermint Schnapps 24 $2.26 $3.39 6 $20.34 206 Luxco-St Louis 81208 Paramount Peppermint Schnapps 6 6 $7.08 $10.62 6 $63.72 207 Luxco-St Louis 82126 Arrow Peach Schnapps 12 $4.34 $6.51 4 $26.04 208 Jim Beam Brands 82606 Dekuyper Sour Apple Pucker 12 $6.30 $9.45 3 $28.35 hollin Dan prend OCCUC Dole DO CIABAT DI LUACAO lowa_Liquor Sales_52772 $7.13 12 F 2 176 56 fa Hy-Vee Food and Drug #6 / Cedar Rapi City A B D Invoice/Item NumbeDate Store Numbe Store Name S23294000008 1/7/2015 9001 Cedar Ridge Vineyards S23424800006 1/12/2015 4154 Fareway Stores #055 / Hiawatha S23432200078 1/12/2015 3773 Benz Distributing S23530800003 1/15/2015 2652 Hy-Vee Drugstore / Mason City S23687400015 1/26/2015 2605 Hy-Vee Drugstore #5 / Cedar Rapids S23680200137 1/26/2015 2647 Hy-Vee #7 / Cedar Rapids S23695400135 1/27/2015 2620 Hy-Vee / Windsor Heights S23737500025 1/28/2015 4157 Fareway Stores #993 / North Liberty S23794400007 2/2/2015 2670 Hy-Vee Food Store / Coralville S23985000026 2/11/2015 4829 Central City 2 S24077400074 2/17/2015 2565 Hy-Vee Food Store / Spencer S24183200075 2/23/2015 2512 Hy-Vee Wine and Spirits / Iowa City S24213900003 2/24/2015 2663 Hy-Vee / Urbandale S24278800004 3/4/2015 9001 Cedar Ridge Vineyards S24584900090 3/18/2015 2572 Hy-Vee Food Store / Cedar Falls S24618100040 3/19/2015 2528 Hy-Vee Food Store #3 / Des Moines S25105800081 4/15/2015 2512 Hy-Vee Wine and Spirits / Iowa City S25208500125 4/21/2015 2552 Hy-Vee Food Store #3 / Cedar Rapids S25183800160 4/21/2015 2620 Hy-Vee / Windsor Heights S25379100007 4/29/2015 9001 Cedar Ridge Vineyards S25400100170 4/30/2015 2587 Hy-Vee Food Store / Johnston S25632900073 5/13/2015 3773 Benz Distributing S25825000033 5/26/2015 2661 Hy-Vee Food Store / Sheldon S25826200179 5/26/2015 2620 Hy-Vee / Windsor Heights S25827900006 5/27/2015 9001 Cedar Ridge Vineyards S25860500373 5/27/2015 2622 Hy-Vee Food Store / Iowa City S26075200082 6/8/2015 2512 Hy-Vee Wine and Spirits / Iowa City S26097400250 6/9/2015 2651 Hy-Vee / Waverly S26160000041 6/11/2015 2635 Hy-Vee #4 / Davenport S26138200001 6/11/2015 4537 Casey's General Store #1834 / Leon S26528300024 7/1/2015 4829 Central City 2 S26586100094 7/6/2015 2613 Hy-Vee Food Store #1 / Council Bluff S26590100077 7/6/2015 2512 Hy-Vee Wine and Spirits / Iowa City S26676100188 7/9/2015 2587 Hy-Vee Food Store / Johnston S26791500010 7/15/2015 2512 Hy-Vee Wine and Spirits / lowa City S26875900099 7/21/2015 2665 Hy-Vee / Waukee 1027CAOLA o/ 1n1 201L LAA LA.. E F G H Address Zip Code County Category Category Name 1441 MARAK RD NW SWISHER 52338 Johnson 1051010 AMERICAN GRAPE BRANDIES 885 MILLER RD HIAWATHA 52233 Linn 1051010 AMERICAN GRAPE BRANDIES 501 7TH AVE SE CEDAR RAPIDS 52401 Linn 1051010 AMERICAN GRAPE BRANDIES 875 4TH ST SW MASON CITY 50401 Cerro Gordo 1051010 AMERICAN GRAPE BRANDIES 2001 BLAIRS FERRY ROAD NE CEDAR RAPIDS 52402 Linn 1051010 AMERICAN GRAPE BRANDIES 5050 EDGEWOOD RD CEDAR RAPIDS 52411 Linn 1051010 AMERICAN GRAPE BRANDIES 7101 UNIVERSITY AVE WINDSOR HEIGHTS 50311 Polk 1051010 AMERICAN GRAPE BRANDIES 615 WESTWOOD DR P.O Box 96 NORTH LIBERTY 52317 Johnson 1051010 AMERICAN GRAPE BRANDIES 2004 8TH ST CORALVILLE 52241 Johnson 1051010 AMERICAN GRAPE BRANDIES 1501 MICHIGAN AVE DES MOINES 50314 Polk 1051010 AMERICAN GRAPE BRANDIES 819 N GRAND AVE SPENCER 51301 Clay 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 8701 DOUGLAS URBANDALE 50322 Polk 1051010 AMERICAN GRAPE BRANDIES 1441 MARAK RD NW SWISHER 52338 Johnson 1051010 AMERICAN GRAPE BRANDIES 6301 UNIVERSITY CEDAR FALLS 50613 Black Hawk 1051010 AMERICAN GRAPE BRANDIES 3221 SE 14TH ST DES MOINES 50315 Polk 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 20 WILSON AVENUE WEST CEDAR RAPIDS 52404 Linn 1051010 AMERICAN GRAPE BRANDIES 7101 UNIVERSITY AVE WINDSOR HEIGHTS 50311 Polk 1051010 AMERICAN GRAPE BRANDIES 1441 MARAK RD NW SWISHER 52338 Johnson 1051010 AMERICAN GRAPE BRANDIES 5750 MERLE HAY ROAD JOHNSTON 50131 Polk 1051010 AMERICAN GRAPE BRANDIES 501 7TH AVE SE CEDAR RAPIDS 52401 Linn 1051010 AMERICAN GRAPE BRANDIES 1989 PARK ST SHELDON 51201 O'Brien 1051010 AMERICAN GRAPE BRANDIES 7101 UNIVERSITY AVE WINDSOR HEIGHTS 50311 Polk 1051010 AMERICAN GRAPE BRANDIES 1441 MARAK RD NW SWISHER 52338 Johnson 1051010 AMERICAN GRAPE BRANDIES 1125 N DODGE ST IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 1311 4 STREET SW WAVERLY 50677 Bremer 1051010 AMERICAN GRAPE BRANDIES 4064 E 53RD ST DAVENPORT 52807 Scott 1051010 AMERICAN GRAPE BRANDIES 401 NW CHURCH ST LEON 50144 Decatur 1051010 AMERICAN GRAPE BRANDIES 1501 MICHIGAN AVE DES MOINES 50314 Polk 1051010 AMERICAN GRAPE BRANDIES 2323 W BROADWAY COUNCIL BLUFFS 51501 Pottawattamie 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 5750 MERLE HAY ROAD JOHNSTON 50131 Polk 1051010 AMERICAN GRAPE BRANDIES 1720 WATERFRONT DR IOWA CITY 52240 Johnson 1051010 AMERICAN GRAPE BRANDIES 1005 E HICKMAN RD WAUKEE 50263 Dallas 1051010 AMERICAN GRAPE BRANDIES CAN LINCOLMALAV AMEC conin ton 100 1010 AMACDICAMLCDADE DDAMDICO K L M N Vendor Numbe. Vendor Name Item NumbeItem Description P 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 125 Cedar Ridge Vineyards, LLC 52216 Cedar Ridge Brandy 100 cadar Dideo Visuare IC 16. Cadar Didas Draad 41 f Invoice/Item Number Invoice/Item Number S23417700010 S23417700008 S23417700004 S23417700002 S23417700005 S23417700009 S23417700007 S23417700003 S23417700006 S23786300004 2 S23786300009 S23786300010 4 S23786300001 S23786300007 5 S23786300005 7 S23786300003 BS23786300008 S23786300002 S23786300006 S23917800005 S23917800010 B S23917800007 S23917800001 5 S23917800009 5 S23917800002 7 S23917800008 S23917800012 S23917800006 S23917800004 S23917800003 2S24168000001 BS24168000007 1 S24168000003 5 S24168000005 5 S24168000002 7 S24168000006 C21Connnnn B G Date Store Number Store Name Address City Zip Code County 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 1/12/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/2/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/9/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar 2/23/2015 4562 Casey's General Store #2989 / Mechan 206 SHORT ST MECHANICSVILLE 52306 Cedar lanlan 12. Cocou Cocacolctors #2000 /Mooban 200 CLODTCT MCCLLA MCCLLLC 220c Codor Category Category Name Vendor Number - Vendor Name 1062310 SPICED RUM 260 Diageo Americas 1062310 SPICED RUM 259 Heaven Hill Brands 1031080 VODKA 80 PROOF 259 Heaven Hill Brands 1081300 PEPPERMINT SCHNAPPS 434 Luxco-St Louis 1031200 VODKA FLAVORED 380 Phillips Beverage Company 1081305 APPLE SCHNAPPS 65 Jim Beam Brands 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 260 Diageo Americas 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1011200 STRAIGHT BOURBON WHISKIES 65 Jim Beam Brands 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 434 Luxco-St Louis 1011300 TENNESSEE WHISKIES 85 Brown-Forman Corporation 1011300 TENNESSEE WHISKIES 85 Brown-Forman Corporation 1051110 BLACKBERRY BRANDIES 434 Luxco-St Louis 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1062200 PUERTO RICO & VIRGIN ISLANDS RUM 35 Bacardi U.S.A., Inc. 1031080 VODKA 80 PROOF 300 Mccormick Distilling Company 1081390 IMPORTED SCHNAPPS 421 Sazerac Co., Inc. 1081030 COFFEE LIQUEURS 370 Pernod Ricard USA/Austin Nichols 1062310 SPICED RUM 260 Diageo Americas 1031080 VODKA 80 PROOF 300 Mccormick Distilling Company 1081600 WHISKEY LIQUEUR 421 Sazerac Co., Inc. 1081900 MISC. AMERICAN CORDIALS & LIQUEURS 322 Prestige Wine and Spirits Group 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 260 Diageo Americas 1081700 DISTILLED SPIRITS SPECIALTY 384 Piedmont Distillers 1012100 CANADIAN WHISKIES 260 Diageo Americas 1022100 TEQUILA 395 Proximo 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 434 Luxco-St Louis 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1012100 CANADIAN WHISKIES 115 Constellation Wine Company, Inc. 1031080 VODKA 80 PROOF 434 Luxco-St Louis 1062200 PUERTO RICO & VIRGIN ISLANDS RUM 434 Luxco-St Louis 1021000 VODA OO noor 20 L ALBUHLD.and M Item Number Item Desa 43336 Captain Morg 43026 Admiral Nels 35416 Burnett's Vod 81206 Paramount Pe 41693 Uv Blue (rasp 82606 Dekuyper Sou 10550 Black Velvet 37996 Smirnoff Vod 11788 Black Velvet 19064 Jim Beam 10550 Black Velvet 36308 Hawkeye Vod 26820 Jack Daniels 86670 Jack Daniel's 55086 Paramount BI 11774 Black Velvet 43126 Bacardi Super 36904 Mccormick Vo 69636 Dr. Mcgillicud 67524 Kahlua Coffee 43338 Captain Morg 36904 Mccormick V 64865 Fireball Cinna 75211 Kinky Liqueur 11788 Black Velvet 37996 Smirnoff Vod 76036 Midnight Mod 11294 Crown Royal 89194 Jose Cuervo E 10550 Black Velvet 36308 Hawkeye Vod 11776 Black Velvet 11788 Black Velvet 11774 Black Velvet 36306 Hawkeye Vod 45276 Paramount w 2011- Duratllad A1 for Invoice/Item Number M D 1 Invoice/Item Number - Date Store Number Store Name Address City 52 S25922800008 6/1/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 53 S25922800006 6/1/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 54 S25922800016 6/1/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 55 S25922800021 6/1/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 56 S26832200005 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 57 S26832200015 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 58 S26832200008 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 59 S26832200001 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD FO S26832200010 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 1 S26832200011 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 2 S26832200012 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 3 S26832200006 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD +4 S26832200013 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 5 S26832200004 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 16 S26832200009 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD -7 S26832200014 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 18 S26832200016 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 19 S26832200007 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD BO S26832200002 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 31 S26832200003 7/20/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 2 S28776500001 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 3 S28776500006 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 34 S28776500009 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 35 S28776500008 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 36 S28776500002 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 37 S28776500013 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 88 S28776500015 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 89 S28776500011 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 20 S28776500005 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 1 S28776500012 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 2 S28776500003 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 3 S28776500004 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 34 528776500007 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 25 S28776500014 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 6 S28776500010 11/2/2015 5020 Petromart Stanwood 1118, HIGHWAY 30 STANWOOD 37 H Zip Code County Number County Category Category Name 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1012100 CANADIAN WHISKIES 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1081600 WHISKEY LIQUEUR 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1032200 IMPORTED VODKA - MISC 52337 16 Cedar 1031200 VODKA FLAVORED 52337 16 Cedar 1081600 WHISKEY LIQUEUR 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1081390 IMPORTED SCHNAPPS 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1081200 CREAM LIQUEURS 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1081600 WHISKEY LIQUEUR 52337 16 Cedar 1032080 IMPORTED VODKA 52337 16 Cedar 1012100 CANADIAN WHISKIES 52337 16 Cedar 1031200 VODKA FLAVORED 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1011300 TENNESSEE WHISKIES 52337 16 Cedar 1022100 TEQUILA 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1062300 FLAVORED RUM 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1081390 IMPORTED SCHNAPPS 52337 16 Cedar 1031080 VODKA 80 PROOF 52337 16 Cedar 1022100 TEQUILA 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1062310 SPICED RUM 52337 16 Cedar 1011200 STRAIGHT BOURBON WHISKIES 52337 16 Cedar 1012100 CANADIAN WHISKIES Vendor Number - Vendor Name 434 Luxco-St Louis 55 Sazerac North America 300 Mccormick Distilling Company 259 Heaven Hill Brands 115 Constellation Wine Company, Inc. 434 Luxco-St Louis 259 Heaven Hill Brands 421 Sazerac Co., Inc. 297 Laird And Company 260 Diageo Americas 380 Phillips Beverage Company 85 Brown-Forman Corporation 260 Diageo Americas 55 Sazerac North America 421 Sazerac Co., Inc. 434 Luxco-St Louis 300 Mccormick Distilling Company 259 Heaven Hill Brands 421 Sazerac Co., Inc. 420 Moet Hennessy USA, Inc. 115 Constellation Wine Company, Inc. 380 Phillips Beverage Company 55 Sazerac North America 85 Brown-Forman Corporation 395 Proximo 55 Sazerac North America 370 Pernod Ricard USA/Austin Nichols 434 Luxco-St Louis 421 Sazerac Co., Inc. 434 Luxco-St Louis 395 Proximo 259 Heaven Hill Brands 260 Diageo Americas 65 Jim Beam Brands 260 Diageo Americas N Item Number Item Desa 36308 Hawkeye V 35946 Fleischman 36904 Mccormick 43026 Admiral Ne 11788 Black Velve 36306 Hawkeye v 43024 Admiral Ne 64863 Fireball Cin 35914 Five O'clock- 64716 Ciroc Peach 41693 Uv Blue (ras 86886 Southern C 43336 Captain Mo 35944 Fleischman 69636 Dr. Mcgillic 36308 Hawkeye V 65204 Tequila Ros 43026 Admiral Ne 64864 Fireball Cin 34155 Belvedere 11788 Black Velve 41692 Uv Blue (ras 35316 Barton Vod 26828 Jack Daniels 89196 Jose Cuervo 35944 Fleischman 42714 Malibu Coc 36306 Hawkeye V 69636 Dr. Mcgillic 36308 Hawkeye V 89194 Jose Cuervo 43026 Admiral Ne 43336 Captain Mo 27392 Jim Beam M 11296 Crown Roya 017 Dewey's Jack and Jill L S T U V Vendor Name 6 Luxco-St Louis 7 Pernod Ricard USA/Austin Nichols 8 Pernod Ricard USA/Austin Nichols 9 Pernod Ricard USA/Austin Nichols o Pernod Ricard USA/Austin Nichols 1 Pernod Ricard USA/Austin Nichols 2 Bacardi U.S.A., Inc. 3 Sazerac North America 4 Laird And Company 5 Sazerac North America 6 Luxco-St Louis 7 Luxco-St Louis 8 Mccormick Distilling Company 9 E AND J GALLO WINERY O Diageo Americas 1 Fifth Generation Inc. 2 Diageo Americas 3 Diageo Americas 4 E AND J GALLO WINERY 5 Constellation Wine Company, Inc. 6 Charles Jacquin Et. Cie., Inc. 7 Sazerac North America 8 Proximo 9 Sazerac Co., Inc. o Pernod Ricard USA/Austin Nichols 1 Pernod Ricard USA/Austin Nichols 2 Luxco-St Louis 3 4 M N Item Number Item Description 30528 Hawkeye Gin 32234 Seagrams Extra Dry Gin 32236 Seagrams Extra Dry Gin 34001 Absolut Swedish Vodka 80 Prf Mini 34006 Absolut Swedish Vodka 80 Prf 34061 Absolut Ruby Red 34423 Grey Goose Vodka 35317 Barton Vodka 35926 Five O'clock PET Vodka 35947 Fleischmann's Royal Vodka 36306 Hawkeye Vodka 36308 Hawkeye Vodka 36886 Mccormick Vodka 36969 New Amsterdam Vodka 37996 Smirnoff Vodka 80 Prf 38176 Titos Vodka 39866 Smirnoff Vodka 100 Prf 42166 Myers's Rum Original Dark 52594 E & J Vs Brandy 53214 Paul Masson Grande Amber Brandy 56957 Bartenders Hot Sex 57148 Chi-Chi's Margarita W/tequila 58868 Jose Cuervo Authentic Strawberry Margarita 64867 Fireball Cinnamon Whiskey 67524 Kahlua Coffee Liqueur 67526 Kahlua Coffee Liqueur 89387 Juarez Tequila Gold o Pack State Bottle Cost 6 6 $7.17 24 $3.39 12 $6.49 10 $7.92 12 $11.49 12 $11.49 12 $9.00 12 $3.97 12 $3.37 12 $4.00 12 $3.34 6 $7.17 12 $3.31 12 $6.90 12 $8.25 12 $9.65 12 $9.50 12 $10.00 24 $3.22 24 $3.22 12 $5.28 6 $6.00 6 $8.20 12 $11.34 24 $6.49 12 $11.99 12 $6.92 Q R State Bottle Retail Bottles Sold - $10.76 1 $5.09 6 $9.74 1 $11.88 1 $17.24 2 $17.24 1 $13.50 1 $5.96 3 $5.06 2 $6.00 2 $5.01 12 $10.76 6 $4.97 2 $10.35 6 $12.38 3 $14.48 2 $14.25 3 $15.00 1 $4.83 6 $4.83 6 $7.92 1 $9.25 1 $12.30 2 $17.01 1 $9.74 1 $17.99 1 1 $10.38 1 5 6 6 7 8 9 -0 -1 8491 X S26439100006 A B D Invoice/Item Number S26439100006 3 S26439100027 5 S26439100026 0 S26579100019 6 S26579100044 0 S26579100045 2 S26579100021 1 S26706400002 4 526833900028 5 S26833900006 7 S26833900029 2 S26968400011 4 S26968400026 6 S26968400010 4 S27098200005 O S27232300019 8 527232300003 2 S27232300014 8 S27614000003 6 S27614000005 2 S27614000004 0 S27889600049 2 S28030100010 2 S28148600014 0 S28412100004 5 S28539300017 8 S28669700017 9 S28943800017 5 S28943800006 9 S29083400025 9 S29083400026 0 S29083400004 1 S29083400023 4 S29342300044 9 S29342300011 1 S29342300045 470700nnc Date Store Number - Store Name 6/26/2015 5071 Jeff's Market / Durant 6/26/2015 5071 Jeff's Market / Durant 6/26/2015 5071 Jeff's Market / Durant 7/6/2015 5071 Jeff's Market / Durant 7/6/2015 5071 Jeff's Market / Durant 7/6/2015 5071 Jeff's Market / Durant 7/6/2015 5071 Jeff's Market / Durant 7/13/2015 5071 Jeff's Market / Durant 7/20/2015 5071 Jeff's Market / Durant 7/20/2015 5071 Jeff's Market / Durant 7/20/2015 5071 Jeff's Market / Durant 7/27/2015 5071 Jeff's Market / Durant 7/27/2015 5071 Jeff's Market / Durant 7/27/2015 5071 Jeff's Market / Durant 8/3/2015 5071 Jeff's Market / Durant 8/10/2015 5071 Jeff's Market / Durant 8/10/2015 5071 Jeff's Market / Durant 8/10/2015 5071 Jeff's Market / Durant 8/31/2015 5071 Jeff's Market / Durant 8/31/2015 5071 Jeff's Market / Durant 8/31/2015 5071 Jeff's Market / Durant 9/14/2015 5071 Jeff's Market / Durant 9/21/2015 5071 Jeff's Market / Durant 9/28/2015 5071 Jeff's Market / Durant 10/12/2015 5071 Jeff's Market / Durant 10/19/2015 5071 Jeff's Market / Durant 10/26/2015 5071 Jeff's Market / Durant 11/9/2015 5071 Jeff's Market / Durant 11/9/2015 5071 Jeff's Market / Durant 11/16/2015 5071 Jeff's Market / Durant 11/16/2015 5071 Jeff's Market / Durant 11/16/2015 5071 Jeff's Market / Durant 11/16/2015 5071 Jeff's Market / Durant 11/30/2015 5071 Jeff's Market / Durant 11/30/2015 5071 Jeff's Market / Durant 11/30/2015 5071 Jeff's Market / Durant 12/7/an1 E F Address City 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 408 6TH AVE DURANT 100 CTILAC OLID ANT G H Zip Code - County Category 7 Category Name 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES 52747 Cedar 1011200 BLENDED WHISKIES Cazzicader 1011200DLEMDEN WILLS VICC K L Vendor Number Vendor Name 297 Laird And Company 260 Diageo Americas 65 Jim Beam Brands 260 Diageo Americas 260 Diageo Americas 492 Western Spirits Beverage Co. LLC 65 Jim Beam Brands 65 Jim Beam Brands 492 Western Spirits Beverage Co. LLC 434 Luxco-St Louis 260 Diageo Americas 65 Jim Beam Brands 260 Diageo Americas 260 Diageo Americas 260 Diageo Americas 260 Diageo Americas 434 Luxco-St Louis 65 Jim Beam Brands 297 Laird And Company 434 Luxco-St Louis 65 Jim Beam Brands 260 Diageo Americas 260 Diageo Americas 65 Jim Beam Brands 434 Luxco-St Louis 65 Jim Beam Brands 260 Diageo Americas 260 Diageo Americas 297 Laird And Company 260 Diageo Americas 65 Jim Beam Brands 434 Luxco-St Louis 260 Diageo Americas 260 Diageo Americas 260 Diageo Americas 65 Jim Beam Brands Discmerica M N Item Number Item Description 23826 Five Star 25604 Seagrams 7 Crown Bl Whiskey 24454 Kessler Blend Whiskey 25604 Seagrams 7 Crown Bl Whiskey 25608 Seagrams 7 Crown Bl Whiskey 27474 Bird Dog Blackberry Whiskey 24454 Kessler Blend Whiskey 24466 Kessler Blend Whiskey Traveler 27474 Bird Dog Blackberry Whiskey 24158 Hawkeye Blend Whiskey 25607 Seagrams 7 Crown Bl Whiskey 24454 Kessler Blend Whiskey 25608 Seagrams 7 Crown Bl Whiskey 25604 Seagrams 7 Crown Bl Whiskey 25608 Seagrams 7 Crown Bl Whiskey 25607 Seagrams 7 Crown Bl Whiskey 24158 Hawkeye Blend Whiskey 24457 Kessler Blend Whiskey 23828 Five Star 24158 Hawkeye Blend Whiskey 24458 Kessler Blend Whiskey 25607 Seagrams 7 Crown Bl Whiskey 25604 Seagrams 7 Crown Bl Whiskey 24454 Kessler Blend Whiskey 24158 Hawkeye Blend Whiskey 24454 Kessler Blend Whiskey 25607 Seagrams 7 Crown Bl Whiskey 25604 Seagrams 7 Crown Bl Whiskey 23828 Five Star 25608 Seagrams 7 Crown Bl Whiskey 24458 Kessler Blend Whiskey 24158 Hawkeye Blend Whiskey 25607 Seagrams 7 Crown Bl Whiskey 25604 Seagrams 7 Crown Bl Whiskey 25607 Seagrams 7 Crown Bl Whiskey 24454 Kessler Blend Whiskey DECO Cromezerou Wibickou C07-11 FEL. Mockat luant A1 foc Invoice/Item Number T U M N o P Q R S 1. Vendor Name Item Number Item Description Pack State Bottle Cost - State Bottle Retail - Bottles Sold - Sale (Dollars) 173 Phillips Beverage Company 41704 Uv Red (cherry) Vodka 12 $6.50 $9.75 2 $19.50 174 Diageo Americas 42166 Myers's Rum Original Dark 12 $10.00 $15.00 3 $45.00 175 MHW Ltd 42204 Blue Chair Bay Banana 12 $9.42 $14.13 3 $42.39 176 MHW Ltd 42242 Blue Chair Bay Coconut 12 $9.42 $14.13 2 $28.26 177 Pernod Ricard USA/Austin Nichols 42712 Malibu Coconut Rum Mini 12 $4.95 $7.43 3 $22.29 178 Pernod Ricard USA/Austin Nichols 42716 Malibu Coconut Rum 12 $7.49 $11.24 6 $67.44 179 Heaven Hill Brands 43024 Admiral Nelson Spiced Rum 24 $2.74 $4.11 10 $41.10 180 Diageo Americas 67266 Yukon Jack Canadian Liqueur 12 $9.25 $13.88 3 $41.64 181 Pernod Ricard USA/Austin Nichols 67522 Kahlua Coffee Liqueur Mini 12 $6.60 $9.90 3 $29.70 182 Pernod Ricard USA/Austin Nichols 67524 Kahlua Coffee Liqueur 24 $6.49 $9.74 3 $29.22 183 Diageo Americas 68017 Bailey's Chocolate Cherry 12 $13.49 $20.24 6 6 $121.44 184 Diageo Americas 68022 Bailey's Salted Caramel 12 $13.49 $20.24 6 $121.44 185 Diageo Americas 68036 Bailey's Original Irish Cream 12 $13.49 $20.24 6 $121.44 186 Sazerac Co., Inc. 69611 Dr. Mcgillicuddy's Apple Pie Schnapps 12 $8.32 $12.48 4 4 $49.92 187 Sazerac Co., Inc. 69634 Dr. Mcgillicuddy's Cherry Schnapps 24 $5.33 $8.00 6 $48.00 188 Sazerac Co., Inc. 69636 Dr. Mcgillicuddy's Cherry Schnapps 12 $8.67 $13.01 4 $52.04 189 Sazerac Co., Inc. 69638 Dr. Mcgillicuddy's Cherry Schnapps 6 $14.66 $21.99 6 $131.94 190 Sazerac Co., Inc. 69666 Dr. Mcgillicuddy's Vanilla 12 $8.67 $13.01 2 $26.02 191 Diageo Americas 69945 Rumple Minze Peppermint Schnapps Liqueur 12 $10.70 3 $32.10 192 Sazerac Co., Inc. 71886 Amaretto E Dolce 12 $3.34 $5.01 4 $20.04 193 Heaven Hill Brands 72722 Christian Bros Honey 12 $5.43 $8.15 3 $24.45 194 MHW Ltd 73055 Rumchata 12 $12.50 $18.75 6 $112.50 195 Prestige Wine and Spirits Group 75211 Kinky Liqueur 12 $10.00 $ $15.00 3 $45.00 196 Prestige Wine and Spirits Group 75214 Kinky Blue 12 $10.00 $15.00 1 $15.00 197 Prestige Wine and Spirits Group 75216 Kinky Gold 12 $10.00 $15.00 3 $45.00 198 Luxco-St Louis 76486 Paramount Amaretto 12 $3.38 $5.07 6 $30.42 199 Luxco-St Louis 76526 Paramount Melon Liqueur 12 $5.30 $7.95 4 4 $31.80 200 Diageo Americas 77714 Smirnoff Pineapple 12 $8.25 $12.38 2 $24.76 201 Campari(skyy) 77776 Wild Turkey American Honey 12 $10.50 $15.75 2 $31.50 202 MHW Ltd 80022 Blue Chair Bay Coconut Spiced Rum Cream 12 $10.97 $16.46 2 $32.92 203 A Hardy / U.S.A., Ltd. 80034 Brown Jug Bourbon Cream 6 $11.00 $16.50 6 $99.00 204 Prestige Wine and Spirits Group 80438 Ricura 6 $10.00 $15.00 4 $60.00 205 Luxco-St Louis 80574 Arrow Peppermint Schnapps 24 $2.26 $3.39 6 $20.34 206 Luxco-St Louis 81208 Paramount Peppermint Schnapps 6 6 $7.08 $10.62 6 $63.72 207 Luxco-St Louis 82126 Arrow Peach Schnapps 12 $4.34 $6.51 4 $26.04 208 Jim Beam Brands 82606 Dekuyper Sour Apple Pucker 12 $6.30 $9.45 3 $28.35 hollin Dan prend OCCUC Dole DO CIABAT DI LUACAO lowa_Liquor Sales_52772 $7.13 12 F 2 176

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Overview: Modern companies compete in a challenging environment. To remain competitive, they must react rapidly to problems and opportunities that arise from extremely dynamic conditions. Enterprise...

Overview Your job as a financial advisor is to create investment goals for your client and a plan to reach them. You will then make subsequent investments in appropriate assets. Working as an...

I need help with company valuations and portfolio analysis project. FIN 640 Milestone One Guidelines and Rubric Overview: For your final project, the CEO has asked you, the new investment manager of...

In this milestone, you will draft the remaining subsections of Section III (I and J) as well as Section IV of the final project regarding the fraud case Crisis atthe Mill: Cash Flow Forecasting...

The three milestones below make up a final paper I am needing assistance with. I can also provide the excel template but was not sure how to upload here. I would like all three modules questions...

SO 510 Milestone Two Guidelines and Rubric The final project for this course is the creation of a statistical analysis report. Operations management professionals are often relied upon to make...

I have another part of the project that I need assistance with if you re interested in answering part two. I have attached the prompt In this milestone, you will draft a major portion of Section III...

The final project for this course is the creation of a statistical analysis report. Operations management professionals are often relied upon to make decisions regarding operational processes. Those...

Need help with project on NIKE In this milestone, submit a draft of a portion of the analysis step, Part II, Section D: Vertical Analysis and Section E: Horizontal Analysis. You will review and...

Let A = CR where C 0 is a column in Rm and R 0 is a row in Rn. (a) Show that col A = span {C} and row A = span {R}. (b) Find dim(null A). (c) Show that null A = null R.

An air standard Diesel cycle has a compression ratio of 19, and heat transfer to the working fluid per cycle is 2000 kJ/kg. At the beginning of the compression process the pressure is 105 kPa and the...

Which of the following is the approprinte discount rate to use in the valuation of a company's bonds? 3 A ) Coupon rateB ) Current yieldC ) Yield to maturityD ) Weighted average cost of capital

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...