ExamenfinalPabloLeón

8/3/2019 ExamenfinalPabloLen

1/10

Factura Producto Cantidad Marca Venta Proveedor DescripcionProducto Ao

2 3 33 Wacko's 3300 Hershey Raisn covered fruit bars 2001


2/10

Mes Cliente Ciudad Estado CodigoPostal Pais Despacho

2 Merry GrapEast VancoBC V3F 4A9 Canada Federal Express


3/10

Pais (Todas)

Suma de Venta Etiquetas de columna

Etiquetas de fila 01 02 03 04 05 06 07 08 09

2001 2500 3350 1750 11305 850

BC 3300

NY 2500 1750 3825 850

OR 7480

TX 502002 28880 6800 ### ### ### 500 20000 27000 ###

AZ ###

BC 28000 ###

CA 880 3250

MT ### 20000 25000

NY 6800 2000

OR 500

WA ### 40000 ###

2003 3600 ### ### 7000 35865 ### 95000 ###

BC 3600 2500 20000

CO 15000

MT 14125NM 3000 2240 2500

NY 750 ###

OR 15000 76725

WA ### 5000 4000 2000 85000 80000 ###

Total general 34980 ### ### ### ### ### ### ### ###


4/10

Total general

19755

3300

8925

7480

50686430

75000

378000

4130

145000

8800

500

75000

531440

26100

15000

141257740

24750

91725

352000

1237625


5/10

Suma de Cantidad Etiquetas de columna

Etiquetas de fila 2001 2002 ### Total general

Canada 33 90 123

East Vancouver 33 90 123

BC 33 90 123

UK 50 7025 300 7375

London 40 7025 300 7365

BC 7000 300 7300

NY 40 25 65Sevenoaks 10 10

NY 10 10

USA 213 7993 ### 16265

Albuquerque 300 141 441

NM 141 141

WA 300 300

Auburn 500 400 900

WA 500 400 900

Austin 5 5

TX 5 5

Bellingham ### 1000

WA ### 1000Berkeley 233 233

CA 153 153

NY 80 80

Buffalo 25 430 455

NY 25 430 455

Denver 600 600

CO 600 600

Eugene 88 10 33 131

OR 88 10 33 131

Helena 25 2750 300 3075

MT 2750 300 3050

NY 25 25Phoenix 3000 3000

AZ 3000 3000

Pocatello 70 ### 1870

NY 70 70

OR ### 1000

WA 800 800

Port Townsend ### 2300

WA ### 2300

Portland 255 255

MT 85 85

OR 90 90

WA 80 80Seattle 700 600 1300

BC 700 700

OR 600 600

Walla Walla 500 200 700

WA 500 200 700

Total general 296 ### ### 23763

BC BC NY NY NM

1000

2000

3000

4000

5000

6000

7000

8000


6/10

A WA T X W A CA NY NY CO OR MT NY AZ NY OR W A WA MT OR WA B C OR W A


7/10

2001

2002

2003


8/10

Factura Producto Cantidad Marca Venta Proveedor

1 1 10 Mars Bars 500 Nabisco

1 2 33 Milky Way 825 Nabisco

1 13 88 Salted Peanuts 7,480 Nabisco

2 3 33 Wacko's 3,300 Hershey

2 10 90 Bananna Rondos 3,600 Hormell

3 4 200 Zig Zags 5,000 General Foods

3 11 500 Tootsie Rolls 40,000 Tootsie Company

4 5 500 Paydays 20,000 Hormell4 6 250 100,000 dollar bars 25,000 Hershey

4 7 300 Peanut butter Cups 12,000 General Foods

5 8 5 Fire Tarts 50 Morton Foods


6 4 30 Zig Zags 750 General Foods

6 12 400 Tootsie Pops 24,000 Tootsie Company

7 13 1,000 Salted Peanuts 85,000 Nabisco

8 1 2,000 Mars Bars 100,000 Nabisco

9 2 3,000 Milky Way 75,000 Nabisco


11 2 25 Milky Way 625 Nabisco

12 13 10 Salted Peanuts 850 Nabisco13 1 80 Mars Bars 4,000 Nabisco

13 2 85 Milky Way 2,125 Nabisco


14 1 65 Mars Bars 3,250 Nabisco


15 13 80 Salted Peanuts 6,800 Nabisco




17 9 1,000 Reeces Pieces 75,000 General Foods


18 3 200 Wacko's 20,000 Hershey19 1 300 Mars Bars 15,000 Nabisco

20 5 500 Paydays 20,000 Hormell

20 7 400 Peanut butter Cups 16,000 General Foods

21 4 600 Zig Zags 15,000 General Foods

21 10 700 Bananna Rondos 28,000 Hormell

22 1 7,000 Mars Bars 350,000 Nabisco


23 8 200 Fire Tarts 2,000 Morton Foods

23 9 2,000 Reeces Pieces 150,000 General Foods


25 1 60 Mars Bars 3,000 Nabisco

25 5 56 Paydays 2,240 Hormell25 6 25 100,000 dollar bars 2,500 Hershey


9/10

DescripcionProducto Ao Mes Cliente

Chocolate covered caramel nugget 2002 06 Frugal Feast Comestibles

Chocolate covered nugget with caraml 2003 08 Frugal Feast Comestibles

Roasted Peanuts covered with healthy salt 2001 05 Frugal Feast Comestibles

Raisn covered fruit bars 2001 02 Merry Grape Wine Merchant

Bananna chips covered in Castor oil 2003 01 Merry Grape Wine Merchant

Chocolate covered taffy 2003 03 Foodmongers, Inc.

Chewy chocolate flavored taffy 2002 04 Foodmongers, Inc.

Nugget & peanuts 2002 07 Silver Screen Food GemsChocolate covered carmel with crispy rice 2002 08 Silver Screen Food Gems

Chocolate covered peanut butter 2003 05 Silver Screen Food Gems

Bubble Gum covered with janipino sause 2001 02 ValuMax Food Stores

Raisn covered fruit bars 2001 01 Walnut Grove Grocery

Chocolate covered taffy 2003 02 Walnut Grove Grocery

Chewy chocolate flavored taffy covered with sugar on a 2003 03 Walnut Grove Grocery

Roasted Peanuts covered with healthy salt 2003 06 Fred's Edibles, Etc.

Chocolate covered caramel nugget 2002 05 Morning Star Health Foods

Chocolate covered nugget with caraml 2002 09 Fujiwara Asian Specialties

Chewy chocolate flavored taffy 2002 08 Seven Seas Imports

Chocolate covered nugget with caraml 2001 05 Silver Screen Food Gems

Roasted Peanuts covered with healthy salt 2001 06 Wellington TradingChocolate covered caramel nugget 2003 04 Live Oak Hotel Gift Shop

Chocolate covered nugget with caraml 2003 05 Live Oak Hotel Gift Shop

Bubble Gum covered with janipino sause 2003 08 Live Oak Hotel Gift Shop

Chocolate covered caramel nugget 2002 04 Rite-Buy Supermarket

Bubble Gum covered with janipino sause 2002 01 Rite-Buy Supermarket

Roasted Peanuts covered with healthy salt 2002 02 Gruenewald Delikatessen

Chewy chocolate flavored taffy 2001 05 Picadilly Foods

Chocolate covered nugget with caraml 2001 04 Frugal Purse Strings

Raisn covered fruit bars 2003 07 Frugal Purse Strings

Peanut Butter & chocolate covered in a candy shell 2003 08 Frugal Purse Strings

Chocolate covered nugget with caraml 2003 05 Blum's Goods

Raisn covered fruit bars 2003 06 Blum's GoodsChocolate covered caramel nugget 2002 09 Rattlesnake Canyon Grocer

Nugget & peanuts 2002 03 Valley Store

Chocolate covered peanut butter 2003 02 Valley Store

Chocolate covered taffy 2003 05 Vine and Barrel, Inc.

Bananna chips covered in Castor oil 2002 01 Vine and Barrel, Inc.

Chocolate covered caramel nugget 2002 04 Empire Trading

Raisn covered fruit bars 2003 02 La Playa Mini Mart

Bubble Gum covered with janipino sause 2003 05 La Playa Mini Mart

Peanut Butter & chocolate covered in a candy shell 2003 08 La Playa Mini Mart

Chocolate covered nugget with caraml 2003 07 Tommy's Imported Specialti

Chocolate covered caramel nugget 2003 04 Rattlesnake Canyon Grocer

Nugget & peanuts 2003 05 Rattlesnake Canyon Grocer Chocolate covered carmel with crispy rice 2003 08 Rattlesnake Canyon Grocer


10/10

Ciudad Estado CodigoPostal Pais Despacho

Eugene OR 97403 USA Federal Express



East VancouveBC V3F 4A9 Canada Federal Express

East VancouveBC V3F 4A9 Canada Federal Express

Walla Walla WA 99362 USA Federal Express

Walla Walla WA 99362 USA Federal Express

Helena MT 59601 USA GrayhoundHelena MT 59601 USA Grayhound

Helena MT 59601 USA Grayhound

Austin TX 78759 USA UPS

Buffalo NY 14240 USA Federal Express



Bellingham WA 98226 USA Grayhound

Helena MT 59601 USA Federal Express

Phoenix AZ 85306 USA Grayhound

London NY OX15 4NB UK Grayhound

Helena NY 59601 USA Grayhound

Sevenoaks NY TN15 7AE UK Federal ExpressPortland WA 97229 USA Grayhound

Portland MT 97229 USA Grayhound

Portland OR 97229 USA Grayhound

Berkeley CA 92701 USA Federal Express

Berkeley CA 92701 USA Federal Express

Berkeley NY 94701 USA Federal Express

London NY SW1 0JR UK Grayhound

Pocatello NY 83201 USA UPS

Pocatello WA 83201 USA UPS

Pocatello OR 83201 USA UPS

London BC NW1 2BP UK Grayhound

London BC NW1 2BP UK GrayhoundAlbuquerque WA 87110 USA Grayhound

Auburn WA 98002 USA Federal Express

Auburn WA 98002 USA Federal Express

Seattle OR 98117 USA Grayhound

Seattle BC 98117 USA Grayhound

London BC SW2 1HJ UK Federal Express

Port TownsendWA 98368 USA Grayhound



Denver CO 80227 USA Grayhound

Albuquerque NM 87110 USA Grayhound

Albuquerque NM 87110 USA GrayhoundAlbuquerque NM 87110 USA Grayhound

ExamenfinalPabloLeón

Documents

Transcript of ExamenfinalPabloLeón