Employee ID Employee Name Employee Address Employee Phone
EM100 Joseph Johnson 125 East St, Callistoga, CA 02026 203-555-2100
EM110 Susan Simmons 75 CAin St, Oakville, CA 02451 203-555-2110
EM120 Nancy Walsh 335 Thatcher St, Westwood, CA 02090 203-555-2120
EM130 Michael Clinton 313 Highland Ave, Somerville, CA 02180 203-555-2130
EM200 Brian Barry 40 Coolidge St, Angwin, CA 02446 203-555-2200
EM210 Julia Kennedy 32 Summit Ave, Angwin, CA 02446 203-555-2210
EM220 Thomas Vogel 543 Elm St, CArlboro, CA 02432 203-555-2220
EM230 Jonathon Kraft 29 State St, Foxboro, CA 02283 203-555-2230
EM300 Daniel Furlani 132 St. HelenaRd, Rutherford, CA 02231 203-555-2300
EM310 Bruce Doscher 140 Lincoln St, Stow, CA 02045 203-555-2310
EM320 Vincent Miller 129 South St, Wilmington, CA 02227 203-555-2320
EM330 Catherine Louzonis 14 Park Place, Worcestor, CA 02345 203-555-2330
EM340 Robert Germain 1234 Beacon St, Boston, CA 02013 203-555-2340
EM350 Brian Downey 66 Riverdale St, Methuen, CA 02178 203-555-2350
EM360 Kelley Baim 174 Moody St, Oakville, CA 02451 203-555-2360
EM370 Christina Buckheit 59 Wild Rose Dr, Andover, CA 02876 203-555-2370
EM380 Aaron Coffin 18 Fuller Rd, Foxboro, CA 02283 203-555-2380
EM390 Dan Flaherty 803 Haverhill St, Rowley, CA 02643 203-555-2390
EM400 Ryan Ellis 65 Memorial Dr, Stoughton, CA 02264 203-555-2400
EM410 Peter Hartzel 63 Hortonville Rd, Swansea, CA 02223 203-555-2410
EM420 Nick Larkin 57 Granite St, Brockton, CA 02283 203-555-2420
EM430 Thomas Mackie 59 Village Rd, Oak Bluffs, CA 02637 203-555-2430
EM440 Matt Nagler 22 Turkey Hill Rd, Newburyport, CA 02983 203-555-2440
EM450 Dan Jacobs 43 Albert Ave, Belmont, CA 02242 203-555-2450
EM460 Greq Quinn 1 Big Tree Ln, Holland, CA 02493 203-555-2460
Employee SSN Employee Position Supervisor
025-65-7862 Wine Maker Brian Barry
361-45-7841 Wine Maker Brian Barry
112-25-4587 Wine Maker Brian Barry
004-45-7821 Wine Maker Brian Barry
138-45-9862 Grape Farmer Julia Kennedy
201-45-7854 Grape Farmer Julia Kennedy
012-34-5678 Grape Farmer Julia Kennedy
198-45-7825 Grape Farmer Julia Kennedy
186-08-1687 Wine Maker Thomas Vogel
018-45-6810 Wine Maker Thomas Vogel
108-98-7777 Wine Maker Thomas Vogel
045-89-4532 Wine Maker Thomas Vogel
092-63-7801 Wine Maker Thomas Vogel
008-32-3334 Grape Farmer Julia Kennedy
323-21-8721 Grape Farmer Christina Buckheit
247-92-8212 Grape Farmer Christina Buckheit
014-89-2834 Grape Farmer Christina Buckheit
007-08-0132 Grape Farmer Christina Buckheit
312-32-4827 Grape Farmer Christina Buckheit
123-45-7823 Clerk Peter Hartzel
142-12-7823 Clerk Peter Hartzel
189-84-8321 Account Assistant Thomas Mackie
056-23-4829 Clerk Peter Hartzel
107-53-2345 Account Assistant Thomas Mackie
183-04-3212 Account Assistant Thomas Mackie
Customer ID Customer Name Customer Address
CI100 Robert Jones 110 Boulevard Rd, Calistoga, CA 02026
CI110 Martha Rogers 400 Canton St, Westwood, CA 020290
CI120 Mary McCarthy 142 Coolidge St, San Francisco, CA 02446
CI130 William Luce 305 Harvard Ave, Brighton, CA 02215
CI140 Scott Phillips 373 Highland Ave, Sacramento, CA 02180
CI150 George Madison 75 Forrest St, Oakville, CA 02531
CI160 Paul Newman 21 Coslin Drive, Southboro, CA, 04321
CI170 Lisa Simpson 108 Intervale Rd, Springfield, CT 02431
CI180 Corina Smith 98 New Pond Circle, Fresno, CA 02180
CI190 Cynthia Summers 67 River St, Woburn, MA 02787
Customer Phone Customer DOB
343-326-7854 12/27/1950
374-329-6654 3/6/1977
998-739-4448 10/10/1951
456-461-6432 2/28/1979
836-731-4571 4/1/1962
556-931-2000 8/15/1955
556-562-2804 6/20/1976
556-239-4378 9/15/1963
564-431-4328 3/21/1970
781-353-7878 1/1/1958
Customer ID Customer Name Customer Address
CB734 Amherst Wine Cellar 233 Pleasant St, Amherst, MA 01002
CB432 Espirit Du Vin 25 Central Ave, Milton, NC 02186
CB329 Harvard Wine Company 1664 Massachusetts Avenue, Cambridge, MA 02138
CB111 Seacoast Distillers 20 3rd. Avenue, Somerville, CA 02143
CB135 The Wine Cave 33 Union St., Boston, MA 02108
CB668 Best Cellars 1327 Beacon St, Lebanon, NH 02446
Customer Phone Customer Tax #
781-549-0989 T120
303-343-8732 T120
617-547-3300 T170
615-776-7000 T170
617-227-7311 T170
663-232-4100 T150
Vendor ID Vendor Name Vendor Address Vendor Phone
V150 Andler Bottle Co 376 3rd Street, Everett, MA 02149 203-387-5700
V350 Saxco International 21G Olympia Ave., Austin, TX 41801 223-938-0985
V550 Chatham Glass Co. 752 CAin St, Arlington, MI 02633 794-945-5547
Vendor Contact
Stuart Stevens
Samantha Adams
Chip Douglas
Vineyard Name Vineyard Size(acres) Vineyard Location Manager
Hilltop 2.5 Rutherford Brian Barry
Westside 5.7 Rutherford Julia Kennedy
Northwood 7 St. Helena Thomas Vogel
Oak Bluffs 18 Oakville Jonathon Kraft
Southbridge 7.4 Oakville Kelley Baim
Sleepy Hollow 20.3 St. Helena Christina Buckheit
Buck Ridge 4.6 Rutherford Aaron Coffin
Eastside 14.5 St. Helena Dan Flaherty
Pine Valley 9.9 Rutherford Ryan Ellis
Moon Canyon 6 Rutherford Brian Downey
Vineyard Vintage Year Grape Type Amount of Grapes(tons)
Buck Ridge 2010 Cabernet Sauvignon 4.50
2009 Cabernet Sauvignon 5.12
2008 Zinfandel 4.56
Eastside 2010 Merlot 14.75
2009 Merlot 14.26
2008 Pinot Noir 14.44
Hilltop 2010 Cabernet Sauvignon 2.56
2009 Chardonnay 2.33
2008 Chardonnay 2.00
Moon Canyon 2010 Pinot Noir 6.08
2009 Merlot 6.10
2008 Merlot 6.70
Northwood 2010 Zinfandel 2.50
2009 Zinfandel 2.34
2008 Zinfandel 2.22
Oak Bluffs 2010 Pinot Noir 18.56
2009 Pinot Noir 18.66
2008 Pinot Noir 18.20
Pine Valley 2010 Zinfandel 9.00
2009 Cabernet Sauvignon 9.50
2008 Chardonnay 9.03
Sleepy Hollow 2010 Sauvignon Blanc 20.50
2009 Pinot Noir 20.66
2008 Merlot 20.80
Southbridge 2010 Chardonnay 7.40
2009 Zinfandel 7.60
2008 Zinfandel 7.78
Westside 2010 Merlot 5.00
2009 Sauvignon Blanc 5.66
2008 Sauvignon Blanc 5.70
Ripeness
80%
75%
90%
75%
80%
80%
75%
90%
80%
85%
70%
75%
77%
60%
90%
75%
90%
80%
89%
89%
70%
85%
70%
75%
95%
50%
85%
80%
86%
90%
Grape Description Juice Ratio Storage Requirement Aging Requirement
Cabernet Sauvignon 70% Oak Barrel 2
Merlot 75% Oak Barrel 2
Zinfandel 85% Stainless Steel 1
Pinot Noir 65% Oak Barrel 2
Chardonnay 75% Stainless Steel 1
Sauvignon Blanc 80% Stainless Steel 1
Wine ID Wine Name Wine Category Vintage Year Alcohol %
W010 White Zinfandel Dry 2009 12%
W020 2010
W030 2008
W040 Pinot Noir Red 2010 12%
W050 2009
W060 Shiraz Red 2010 12%
W070 2009
W080 Merlot Red 2010 12%
W090 2009
W100 Cabernet Sauvignon Red 2010 12%
W110 2009
W120 Sauvignon Blanc White 2010 12%
W130 2009
W140 Chardonnay White 2010 12%
W150 2009
W160 Port Dessert 2010 12%
W170 2009
W180 Pink Zinfandel White 2010 12%
W190 2009
W200 2008
W210 Burgundy Red 2009 12%
W220 2010
Blend Wine Maker
100% Zinfandel Michael Clinton
100% Pinot Noir Bruce Doscher
75% Pinot Noir, 25% Cabernet Sauvignon Nancy Walsh
90% Merlot, 10% Pinot Noir Robert Germain
100% Cabernet Sauvignon Vincent Miller
100% Sauvignon Blanc Daniel Furlani
100% Chardonnay Catherine Louzonis
85% Merlot, 15% Pinot Noir Bruce Doscher
85% Zinfandel, 15% Chardonnay Michael Clinton
65% Merlot, 20% Pinot Noir, 15% Cabernet Sauvignon Nancy Walsh
Bottle ID Bottle Color Bottle Shape Bottle Size(ml) Bottle Quantity Bottle Price
B1 Green Bordeaux 375 104 $0.65
B2 Green Bordeaux 750 57 $1.35
B3 Clear Burgundy 375 223 $0.85
B4 Clear Burgundy 750 56 $1.25
B5 Green Burgundy 750 73 $1.45
Product ID Wine Bottle Type Bottle Size Case Quantity
P10 White Zinfandel (2009) B2, B4 750 56
P20 White Zinfandel (2010) B4 750 30
P30 White Zinfandel (2008) B5 750 12
P40 Pinot Noir (2010) B2 750 56
P45 Pinot Noir (2010) B1, B3 375 30
P50 Pinot Noir (2009) B4 750 12
P55 Pinot Noir (2009) B3 375 18
P60 Shiraz (2010) B2 750 24
P70 Shiraz (2009) B4 750 48
P80 Merlot (2010) B2 750 16
P90 Merlot (2009) B5 750 12
P100 Cabernet Sauvignon (2010) B2 750 48
P105 Cabernet Sauvignon (2010) B1 375 48
P110 Cabernet Sauvignon (2009) B4 750 26
P115 Cabernet Sauvignon (2009) B3, B1 375 16
P120 Sauvignon Blanc (2010) B4 750 54
P125 Sauvignon Blanc (2010) B1 375 26
P130 Sauvignon Blanc (2009) B5 750 54
P135 Sauvignon Blanc (2009) B3 375 26
P140 Chardonnay (2010) B2 750 16
P150 Chardonnay (2009) B5 750 12
P160 Port (2010) B4 750 16
P170 Port (2009) B5 750 16
P180 Pink Zinfandel (2008) B2 750 28
P190 Pink Zinfandel (2010) B4, B5 750 56
P200 Pink Zinfandel (2009) B5 750 56
P210 Burgundy (2010) B2 750 48
P220 Burgundy (2009) B4 750 48
Qty on Hand Price
200 $492.80
150 $264.00
50 $105.60
100 $364.00
200 $195.00
100 $78.00
200 $117.00
150 $175.20
150 $350.40
250 $116.80
250 $87.60
100 $350.40
100 $350.40
100 $189.80
100 $116.80
150 $297.00
300 $143.00
150 $297.00
300 $143.00
100 $65.60
100 $49.20
100 $65.60
100 $65.60
200 $114.80
200 $229.60
200 $229.60
300 $374.40
300 $374.40
Order ID Product ID Product Customer ID Customer Date Received
O10 P140 Chardonnay CB734 Amherst Wine Cellar 4/26/2010
P170 Port
P220 Burgundy
O11 P160 Port CB432 Espirit Du Vin 4/30/2010
P220 Burgundy
O12 P190 Pink Zinfandel CB329 Harvard Wine Company 4/30/2010
P150 Chardonnay
P40 Pinot Noir
P60 Shiraz
O13 P220 Burgundy CB111 Seacoast Distillers 5/3/2010
P100 Cabernet Sauvignon
P10 White Zinfandel
O14 P20 White Zinfandel CB135 The Wine Cave 4/1/2010
P150 Chardonnay
P80 Merlot
O15 P50 Pinot Noir CB668 Best Cellars 9/8/2009
P70 Shiraz
P80 Merlot
P200 Pink Zinfandel
O16 P55 Pinot Noir CI140 Scott Phillips 9/23/2009
O17 P60 Shiraz CI150 George Madison 9/30/2009
O18 P80 Merlot CI100 Robert Jones 8/15/2009
O19 P100 Cabernet Sauvignon CI110 Martha Rogers 7/4/2009
O20 P105 Cabernet Sauvignon CI120 Mary McCarthy 8/1/2009
O21 P70 Shiraz CI130 William Luce 6/3/2009
O22 P80 Merlot CI140 Scott Phillips 6/15/2009
O23 P150 Chardonnay CI150 George Madison 5/14/2009
O24 P160 Port CI160 Paul Newman 9/15/2009
O25 P180 Pink Zinfandel CI170 Lisa Simpson 9/28/2009
O26 P40 Pinot Noir CI180 Corina Smith 10/1/2009
O27 P70 Shiraz CI190 Cynthia Summers 10/14/2009
O28 P90 Merlot CB329 Harvard Wine Company 10/6/2008
P190 Pink Zinfandel
P30 White Zinfandel
O29 P140 Chardonnay CB135 The Wine Cave 10/4/2008
P220 Burgundy
P70 Shiraz
O30 P160 Port CB668 Best Cellars 9/8/2008
P50 Pinot Noir
O31 P200 Pink Zinfandel CI120 Mary McCarthy 9/4/2008
O32 P210 Burgundy CI130 William Luce 10/7/2008
O33 P10 White Zinfandel CB734 Amherst Wine Cellar 8/7/2008
P60 Shiraz
P80 Merlot
O34 P50 Pinot Noir CB432 Espirit Du Vin 9/5/2008
P100 Carbernet Sauvignon
P190 Pink Zinfandel
O35 P55 Pinot Noir CB329 Harvard Wine Company 7/7/2008
P70 Shiraz
P210 Burgundy
O36 P70 Shiraz CB111 Seacoast Distillers 6/8/2008
P40 Pinot Noir
P140 Chardonnay
O37 P80 Merlot CB135 The Wine Cave 6/9/2008
P210 Burgundy
P100 Cabernet Saugvignon
O38 P100 Cabernet Sauvignon CB668 Best Cellars 6/9/2008
P70 Shiraz
P140 Chardonnay
O39 P115 Cabernet Sauvignon CI180 Corina Smith 5/8/2008
O40 P40 Pinot Noir CI190 Cynthia Summers 4/2/2010
O41 P70 Shiraz CI100 Robert Jones 10/8/2008
O42 P80 Merlot CI110 Martha Rogers 11/5/2008
O43 P140 Chardonnay CI120 Mary McCarthy 11/17/2008
O44 P160 Port CI130 William Luce 12/5/2008
O45 P190 Pink Zinfandel CI140 Scott Phillips 9/8/2008
O46 P210 Burgundy CI150 George Madison 8/8/2008
O47 P150 Chardonnay CI160 Paul Newman 7/4/2008
O48 P170 Port CI170 Lisa Simpson 3/6/2010
O49 P180 Pink Zinfandel CI180 Corina Smith 2/28/2010
O50 P220 Burgundy CI190 Cynthia Summers 3/31/2010
Quantity Status
4 Pending
4 Pending
10 Pending
5 Pending
10 Pending
10 Pending
5 Pending
5 Pending
5 Pending
5 Pending
10 Pending
10 Pending
8 Shipped
10 Shipped
10 Shipped
6 Shipped
10 Shipped
10 Shipped
15 Shipped
1 Shipped
1 Shipped
2 Shipped
1 Shipped
2 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Pending
1 Pending
14 Shipped
10 Shipped
10 Shipped
5 Shipped
10 Shipped
10 Shipped
5 Shipped
10 Shipped
2 Shipped
1 Shipped
10 Shipped
10 Shipped
10 Shipped
10 Shipped
15 Shipped
10 Shipped
10 Shipped
10 Shipped
10 Shipped
5 Shipped
5 Shipped
10 Shipped
10 Shipped
10 Shipped
10 Shipped
10 Shipped
10 Shipped
10 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
1 Shipped
Purchase Order ID Ordered Date Vendor Bottle Type QtyOrdered Received
PO10 10/12/2009 Andler Bottle Co Bordeaux (Green ) 600
10/22/09
quantity
received: 600
Bordeaux (Green) 300
10/28/09
quantity
received: 200
PO12 4/1/2010 Saxco International Burgundy (Clear ) 600
P013 3/30/2010 Saxco International Burgundy (Clear) 300
PO14 1/5/2010 Andler Bottle Co Burgundy (Green) 200
Burgundy (Clear) 200
1/20/10
quantity
received: 200
PO15 3/15/2010 Chatham Glass Co. Bordeaux (Green) 200
3/25/10
quantity
received: 100
3/12/10
quantity
received: 100
PO16 3/31/2010 Chatham Glass Co. Burgundy (Green) 300
4/10/10
quantity
received: 300
Burgundy (Clear ) 500
3/22/10
quantity
received: 200
4/2/10
quantity
received: 200
PO18 3/8/2010 Andler Bottle Co Bordeaux (Green ) 500
3/18/10
quantity
received: 500
PO19 3/2/2010 Saxco International Burgundy (Clear ) 500
3/12/10
quantity
received: 500
Burgundy (Clear) 250
3/12/10
quantity
received: 250
PO22 1/7/2010 Andler Bottle Co Bordeaux (Green) 250
1/17/10
quantity
received: 250
Burgundy (Green) 250
1/17/10
quantity
received: 250
Bordeaux (Green ) 500
1/17/10
quantity
received: 500
Bordeaux (Green) 300
1/15/10
quantity
received: 300
PO25 12/18/2009 Chatham Glass Co. Burgundy (Green) 300
Price Back Order
$0.65 Yes
$1.35
$0.85 Yes
$1.25 Yes
$1.45 Yes
$1.25
$1.35 No
$1.45 Yes
$0.85
$0.65 No
$0.85 No
$1.25
$1.35 No
$1.45
$0.65
$1.35 No
$1.45 Yes