Raw Materials Code Purchase Order ID he Orde_Date Purchase Employee 11/10 3050 11 11/30/ CODE DE SOCAL/LI GU Supplier 19 1009 100 1000 1001 100 10 TO 10 1 1 11/1 11/11/2009 11/23/2018 11/23/2009 COSO G law Material Purchase Puke 19.99 10 29 G 29 12 4 19.99 12 1991 3 19. 1 19 1 19 4 19. 12 19.1 11 19. Cantity Purchased 1001 10013 100 1000 1001 1001 1001 1003 1001 1001 100 1001 100 1001 1002 100 2 1 1 SINE 11/20 100 to/ 5 10 11 12 13 14 15 IG 100 100 1000 1 3 2010 1 M 3053 1 2 19.11 449 CE 7 11 11 11/2012 44 10 CE 100 INTE 1 1 100 19 NO 21 4 31 10 12 om 100 1001 1003 OCT /2020 1/10/20 //2020 1008 100 1 2 1 44.99 29 19 39 15. 2 10.99 44.99 1001 1 12 G 20520 2011 20 34 25 26 9 L 1000 OS 100 1008 ME RE BE 3003 1001 1000 1001 1001 LOGO 1002 1001 3/2000 10 8 1 5 2 19 44.5 44.99 Cou OOT 10 IE sol 1001 11 19.99 22 3/8/2020 2/21/2020 2/1/2020 2/1/21 2/21/2001 2/ 32 RSS 2 2 2 12 100 100 100 1001 1000 20527 23 23 TOT 1001 1001 1 10 2 BOOT 19 Purchase Orders Suppliers Raw Materials 1001 10 19.30 20517 20518 BOOST OCE SOT GOOL BOOT 1 ED ZL 1 2 6695T 1008 1 12 OSO LORE 23/2000 1/14/2020 L200 1/21/2020 1/2/2000 1/1/ BOOT 9 SERERASROOB 00 E 10 1001 1003 1001 1000 1001 1001 1002 1000 19.99 44.95 1999 GODE 1 WE 65 51 1 CZ OVE 2 1 U 1000 1001 100 1000 44.99 E 9 SOE SOVE so // 2 0 100 TOOT GOT LOOT 19.99 11 12 GOST 2/1/2000 00 9 100 108 1000 ODE GET tot CE 100 2/20/2020 ot EST SE BRE 100 1003 1/2000 100 AH 1000 100 1009 4 2 7 2 12 5 7 12 BROKE // IT 2 41 OM /220 BOOT 49 LOT CODE coot CODE LOGE foot coot ET GO O 1 2 2 1 1/23/2000 1/21/2000 1/2006 4/2000 . 561 1000 5 6 SEDE 3003 3001 GEST 20140 GOR 1 100 1000 2 1 10 194999 TE coot coot COOL E O COGE OS 1 4/11/2020 4/14(2020 200 4/11/20 4/200 3009 5 51 52 1 100 008 2001 019 1 Supplier ID Supplier Company name Supplier Address Supplier City Supplier St 2 1 Northern Brewery Homebre 6021 Lyndale Ave Minneapolis MN 3 2 Hops Direct, LLC 586 Green Valley Road Mabton WA 4 3 The Home Brewery 455 E. Township 5L Fayetteville AR 5 4 The Payroll Company 408 N. Walton Blvd Bentonville AR 6 5 City of Fayetteville. Water 113 West Mountain St Fayetteville AR 7 6 Southwestern Gas P.O. Box 98890 Las Vegas NV B 7 Bob's Repair 3541 Horse Meadow Fayetteville AR 9 8 Farmer's Insurance 1943 College Avenue Fayetteville AR TO 9 Lindsey Management Co. 1.200 East Joyce Blvd. Fayetteville AR 11 12 13 14 G Supplier Zip Supplier Phone Notes 55419 612 843-4444 Bulk Malt Supplier 98935 509-8373616 Bulk Hops Supplier 72703 479-587-1440 Small batch and Speciality ingredient Supplier 72712 1-866 899-8439 Payroll 72701 479-521-1258 Water 877-860 6020 Electric and Gas 72703 479-345-2345 Repairs 72701 479-236-0013 Insurance 72703 479-521-6686 Rent 15 03 44.99 D E B 1 Raw_Materials_Code - Raw Materials Description 2 1001 Malt - Barley 3 1002 Malt - Wheat 4 1003 Hops 5 WN Raw Materials_Price $19.99 $44.99 $29.00 6 un 000 7 8 Required: 1. Which raw material is purchased most frequently from suppliers in Arkansas (AR)? O Hops O Malt - Wheat Malt-Barley OK 2. Which raw material is purchased most frequently from suppliers in Washington? Malt-Barley O Malt - Wheat O Hops 4. From which state are most raw materials purchased, overall? O Washington O Arkansas O Minnesota O Nebraska look int ences 5. From which state are least raw materials purchased, overall? O Washington Minnesota O Arkansas
