Exp19_Access_Ch2_Cap_Foodies.accdb

profilelacey.xyY
Products.xlsx

Products

ProductID ProductName SupplierID CategoryID QuantityPerUnit UnitPrice ProductCost UnitsInStock UnitsOnOrder ReorderLevel Discontinued
1 Chai 1 1 10 boxes x 20 bags $18.00 $12.95 39 0 10 FALSE
2 Chang 1 1 24 - 12 oz bottles $19.00 $13.50 17 40 25 FALSE
3 Aniseed Syrup 1 2 12 - 550 ml bottles $10.00 $8.40 13 70 25 FALSE
4 Chef Anton's Cajun Seasoning 2 2 48 - 6 oz jars $22.00 $15.50 53 0 0 FALSE
5 Chef Anton's Gumbo Mix 2 2 36 boxes $21.35 $18.00 0 0 0 TRUE
6 Grandma's Boysenberry Spread 3 2 12 - 8 oz jars $25.00 $19.00 120 0 25 FALSE
7 Uncle Bob's Organic Dried Pears 3 7 12 - 1 lb pkgs. $30.00 $22.50 15 0 10 FALSE
8 Northwoods Cranberry Sauce 3 2 12 - 12 oz jars $40.00 $28.75 6 0 0 FALSE
9 Mishi Kobe Niku 4 6 18 - 500 g pkgs. $97.00 $65.00 29 0 0 TRUE
10 Ikura 4 8 12 - 200 ml jars $31.00 $30.00 31 0 0 FALSE
11 Queso Cabrales 5 4 1 kg pkg. $21.00 $16.00 22 30 30 FALSE
12 Queso Manchego La Pastora 5 4 10 - 500 g pkgs. $38.00 $22.75 86 0 0 FALSE
13 Konbu 6 8 2 kg box $6.00 $2.12 24 0 5 FALSE
14 Tofu 6 7 40 - 100 g pkgs. $23.25 $15.85 35 0 0 FALSE
15 Genen Shouyu 6 2 24 - 250 ml bottles $15.50 $9.99 39 0 5 FALSE
16 Pavlova 7 3 32 - 500 g boxes $17.45 $16.99 29 0 10 FALSE
17 Alice Mutton 7 6 20 - 1 kg tins $39.00 $20.70 0 0 0 TRUE
18 Carnarvon Tigers 7 8 16 kg pkg. $62.50 $48.75 42 0 0 FALSE
19 Teatime Chocolate Biscuits 8 3 10 boxes x 12 pieces $9.20 $4.50 25 0 5 FALSE
20 Sir Rodney's Marmalade 8 3 30 gift boxes $81.00 $58.80 40 0 0 FALSE
21 Sir Rodney's Scones 8 3 24 pkgs. x 4 pieces $10.00 $4.50 3 40 5 FALSE
22 Gustaf's Knäckebröd 9 5 24 - 500 g pkgs. $21.00 $16.90 104 0 25 FALSE
23 Tunnbröd 9 5 12 - 250 g pkgs. $9.00 $2.75 61 0 25 FALSE
24 Guaraná Fantástica 10 1 12 - 355 ml cans $4.50 $0.89 20 0 0 TRUE
25 NuNuCa Nuß-Nougat-Creme 11 3 20 - 450 g glasses $14.00 $8.50 76 0 30 FALSE
26 Gumbär Gummibärchen 11 3 100 - 250 g bags $31.23 $22.80 15 0 0 FALSE
27 Schoggi Schokolade 11 3 100 - 100 g pieces $43.90 $22.89 49 0 30 FALSE
28 Rössle Sauerkraut 12 7 25 - 825 g cans $45.60 $32.50 26 0 0 TRUE
29 Thüringer Rostbratwurst 12 6 50 bags x 30 sausgs. $123.79 $82.50 0 0 0 TRUE
30 Nord-Ost Matjeshering 13 8 10 - 200 g glasses $25.89 $12.20 10 0 15 FALSE
31 Gorgonzola Telino 14 4 12 - 100 g pkgs $12.50 $6.60 0 70 20 FALSE
32 Mascarpone Fabioli 14 4 24 - 200 g pkgs. $32.00 $14.40 9 40 25 FALSE
33 Geitost 15 4 500 g $2.50 $2.01 112 0 20 FALSE
34 Sasquatch Ale 16 1 24 - 12 oz bottles $14.00 $13.51 111 0 15 FALSE
35 Steeleye Stout 16 1 24 - 12 oz bottles $18.00 $17.51 20 0 15 FALSE
36 Inlagd Sill 17 8 24 - 250 g jars $19.00 $18.51 112 0 20 FALSE
37 Gravad lax 17 8 12 - 500 g pkgs. $26.00 $25.51 11 50 25 FALSE
38 Côte de Blaye 18 1 12 - 75 cl bottles $263.50 $263.01 17 0 15 FALSE
39 Chartreuse verte 18 1 750 cc per bottle $18.00 $17.51 69 0 5 FALSE
40 Boston Crab Meat 19 8 24 - 4 oz tins $18.40 $17.91 123 0 30 FALSE
41 Jack's New England Clam Chowder 19 8 12 - 12 oz cans $9.65 $9.16 85 0 10 FALSE
42 Singaporean Hokkien Fried Mee 20 5 32 - 1 kg pkgs. $14.00 $13.51 26 0 0 TRUE
43 Ipoh Coffee 20 1 16 - 500 g tins $46.00 $45.51 17 10 25 FALSE
63 Vegie-spread 7 2 15 - 625 g jars $43.90 $43.41 24 0 5 FALSE
64 Wimmers gute Semmelknödel 12 5 20 bags x 4 pieces $33.25 $32.76 22 80 30 FALSE
65 Louisiana Fiery Hot Pepper Sauce 2 2 32 - 8 oz bottles $21.05 $20.56 76 0 0 FALSE
68 Scottish Longbreads 8 3 10 boxes x 8 pieces $12.50 $12.01 6 10 15 FALSE
69 Gudbrandsdalsost 15 4 10 kg pkg. $36.00 $35.51 26 0 15 FALSE
70 Outback Lager 7 1 24 - 355 ml bottles $15.00 $14.51 15 10 30 FALSE
74 Longlife Tofu 4 7 5 kg pkg. $10.00 $9.51 4 20 5 FALSE