Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mylab Accounting With Pearson -- Access Card -- For Managerial Accounting

Authors: Karen W. Braun, Wendy M. Tietz

5th Edition

0134161645, 9780134161648

More Books

Students also viewed these Accounting questions