0% found this document useful (0 votes)
46 views3 pages

Total Sold of Jan 2018

1. The document is an inventory report from a wine store listing various wines in stock, sales, and costs from January to February 2018. 2. It includes details on 56 different wines such as quantity in stock, sales, total costs, and expenses. 3. The summary at the bottom shows total quantities in stock, added, sold, returned, and current stock levels.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
46 views3 pages

Total Sold of Jan 2018

1. The document is an inventory report from a wine store listing various wines in stock, sales, and costs from January to February 2018. 2. It includes details on 56 different wines such as quantity in stock, sales, total costs, and expenses. 3. The summary at the bottom shows total quantities in stock, added, sold, returned, and current stock levels.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Location Store Date :1-January, 2018 Insert Inv. Cre.

For February 2018


* List wine ( consignment ) order to Auskhmer
STOCK ON HAND (ENDING) OF January 2018 (BEGINNING) OF Febraury 2018
No Name Description Code Beg. Added Total Returned St. ZL Garden H Last P. Cr-note Q.Sold Total cost Cr-note cost T.Expense
01 Orpale GRAND CRU Vintage 1998 70102-BC0809 7.00 7.00 5 2 $ 79.00 7.00 0 $ 553.00 $ 553.00 $ -
02 Champagne de Saint Gall Premier Cru NV 70102-BC0803 0.00 0.00 $ 30.00 0.00 0 $ - $ - $ -
03 Domaine Paul Blank Riesling 70301-BD0538 5.00 5.00 3 2 $ 16.50 5.00 0 $ 82.50 $ 82.50 $ -
04 Domaine Paul Blank Pinot Gris 70301-BD0537 4.00 2 6.00 4 2 $ 18.70 6.00 0 $ 112.20 $ 112.20 $ -
05 Domaine Fournier " Les Belles Vignes" Sencere 70306-BD0524 5.00 5.00 5 $ 20.90 5.00 0 $ 104.50 $ 104.50 $ -
06 Domaine Berthiers Cuvee d ' Eve Sauvignon Blace 70306-BD0501 3.00 3.00 1 2 $ 24.00 3.00 0 $ 72.00 $ 72.00 $ -
07 Chateau Reynon Blanc 70303-BC0933 1.00 1.00 1 $ 12.50 1.00 0 $ 12.50 $ 12.50 $ -
08 Pierre Andre Le Meursault 70305-BP0116 2.00 2.00 2 $ 42.00 2.00 0 $ 84.00 $ 84.00 $ -
09 Cuilleron Viognier 70307-BD0516 0.00 0.00 $ 17.50 0.00 0 $ - $ - $ -
10 Cuilleron Marsanne 70307-BD0509 5.00 5.00 3 2 $ 12.70 5.00 0 $ 63.50 $ 63.50 $ -
11 Mad Fish Semillon / Sauvignon Blanc 70404-BM0107 6.00 6.00 4 2 $ 13.80 6.00 0 $ 82.80 $ 82.80 $ -
12 Mussel Bay Sauvignon Blanc 71001-BM1501 5.00 5.00 3 2 $ 10.00 5.00 0 $ 50.00 $ 50.00 $ -
13 Vigna Dogarina Pinot Grigio 70501-BV0403 11.00 11.00 9 2 $ 9.90 11.00 0 $ 108.90 $ 108.90 $ -
14 Bava, Cor de Chasse-Gavi di GaVi 70501-BB0703 7.00 7.00 5 2 $ 16.00 7.00 0 $ 112.00 $ 112.00 $ -
15 Vallformosa La Vina blanco 70601-BV0109 3.00 3.00 1 2 $ 4.70 3.00 0 $ 14.10 $ 14.10 $ -
16 Domaine Cuilleron Terres Sombres -Cote Rotie 70307-BD0515 5.00 5.00 3 2 $ 64.90 5.00 0 $ 324.50 $ 324.50 $ -
17 Cuilleron Syrah 70307-BD0514 9.00 9.00 7 2 $ 12.10 9.00 0 $ 108.90 $ 108.90 $ -
18 Chateau vieux perey saint emilion 70304-BC0949 3.00 3.00 2 $ 16.00 2.00 1 $ 48.00 $ 32.00 $ 16.00
19 Norton Privida Malbec 70701-BN0611 3.00 3.00 3 $ 21.50 3.00 0 $ 64.50 $ 64.50 $ -
20 Trentham la famiglia Sangiovese rose 70403-BT0706 9.00 9.00 7 2 $ 10.50 9.00 0 $ 94.50 $ 94.50 $ -
21 Howard Park 'Abercrombie' Cabernet Sauvignon 70404-BH0401 4.00 4.00 2 2 $ 62.10 4.00 0 $ 248.40 $ 248.40 $ -
22 Oyster Bay Pinot Noir 71001-BO0602 8.00 8.00 6 2 $ 20.90 8.00 0 $ 167.20 $ 167.20 $ -
23 Monkey bay merlot 71001-BM1301 7.00 7.00 5 2 $ 16.80 7.00 0 $ 117.60 $ 117.60 $ -
24 Ata Rangi Pinot Noir 71001-BA1301 4.00 4.00 2 2 $ 50.00 4.00 0 $ 200.00 $ 200.00 $ -
25 Anakena Single Vineyard Carmenere 70801-BA0606 7.00 7.00 5 1 $ 10.70 6.00 1 $ 74.90 $ 64.20 $ 10.70
26 Bava, 'Libera' 70501-BB0723 3.00 4 7.00 5 2 $ 14.00 7.00 0 $ 98.00 $ 98.00 $ -
27 Bava controvento Dolcetto 70501-BB0722 7.00 7.00 5 2 $ 14.00 7.00 0 $ 98.00 $ 98.00 $ -
28 Vallformosa Livius Garnacha (2006) 70601-BV0113 7.00 7.00 5 2 $ 41.00 7.00 0 $ 287.00 $ 287.00 $ -
31 Southern Right Pinotage 71101-BS1302 1.00 1.00 $ 21.00 0.00 1 $ 21.00 $ - $ 21.00
32 Firefinch Cabernet Sauvignon Blenc 71101-BF0401 4.00 4.00 2 2 $ 7.00 4.00 0 $ 28.00 $ 28.00 $ -
37 Anakena Chardonnay 70801-BA0603 0.00 0.00 $ 7.70 0.00 0 $ - $ - $ -
38 Anakena Sauvingon Blanc 70801-BA0612 32.00 32.00 20 $ 8.00 20.00 12 $ 256.00 $ 160.00 $ 96.00
39 Anakena Birbman Merlot 70801-BA0615 0.00 0.00 $ 7.70 0.00 0 $ - $ - $ -
40 Anakena Cabernet Sauvignon 2008 (750ml) 70801-BA0601 69.00 69.00 40 $ 7.70 40.00 29 $ 531.30 $ 308.00 $ 223.30
41 Katnook Estate Prodidgy Shiraz 70401-BK0206 5.00 5.00 3 2 $ 56.40 5.00 0 $ 282.00 $ 282.00 $ -
42 Katnook Estate Odyssey Cabernet Sauvignon 70401-BK0205 5.00 5.00 3 2 $ 56.40 5.00 0 $ 282.00 $ 282.00 $ -
43 Esprit de Pavie BE0401 2.00 2.00 2 $ 32.00 2.00 0 $ 64.00 $ 64.00 $ -
44 Chateau Lalande 70304-BC0962 7.00 7.00 5 2 $ 29.90 7.00 0 $ 209.30 $ 209.30 $ -
45 Chateau Grange Neuve 70304-BC2502 6.00 6.00 4 2 $ 29.90 6.00 0 $ 179.40 $ 179.40 $ -
46 Chateau Escot 70304-BC0966 3.00 2 5.00 1 2 $ 19.80 3.00 2 $ 99.00 $ 59.40 $ 39.60
47 Chateau Les Chaumes 70304-BC0915 5.00 5.00 3 2 $ 16.60 5.00 0 $ 83.00 $ 83.00 $ -
48 Chateau Clou du Pin BC0983 2.00 2.00 2 $ 14.00 2.00 0 $ 28.00 $ 28.00 $ -
49 Bird in Hand Sauvignon Blanc 70401-BB1105 3.00 3.00 1 2 $ 14.90 3.00 0 $ 44.70 $ 44.70 $ -
50 Freixenet Cordon Negro Brut 750mlx6 BF0502 0.00 0.00 $ 10.80 0.00 0 $ - $ - $ -
51 Le Grand Nor (Nov- Dec-17 ) 70308-BL0204 14.00 0.00 14 $ 9.00 0.00 0 $ - $ - $ -
52 Le Grand Nor Sauvignon Blanc(Nov- Dec-17 ) 70308-BL0208 8.00 0.00 8 $ 9.00 0.00 0 $ - $ - $ -
53 Menhir Negoamaro (Sept-Oct-17) 70501-BM1008 11.00 0.00 11 $ 8.50 0.00 0 $ - $ - $ -
54 Manyara Sauvignon Blenc (Sept-Oct-17) 70401-BM0201 13.00 0.00 13 $ 8.50 0.00 0 $ - $ - $ -
55 Orbiel Frers Merlot (Jan-Feb 18 ) 70308-B00403 47.00 47.00 33 $ 8.50 33.00 14 $ 399.50 $ 280.50 $ 119.00
56 Orbiel Freres Sauvignon Blanc ( Jan-Feb 18 ) 70308-B00404 24.00 24.00 15 $ 8.50 15.00 9 $ 204.00 $ 127.50 $ 76.50
Total 401.00 8 363.00 46 122 172 0 $ 1,074.50 294.00 69 $ 6,094.70 $ 5,492.60 $ 602.10

TOTAL SOLD OF January 2018


No Name Description Code Beg. Added Total Returned St. ZL G.H Last P. Cr-note Q.Sold Total cost Cr-note cost T.Expense
01 Chateau vieux perey saint emilion 70304-BC0949 3.00 3.00 2 $ 16.00 2.00 1 $ 48.00 $ 32.00 $ 16.00
02 Anakena Single Vineyard Carmenere 70801-BA0606 7.00 7.00 5 1 $ 10.70 6.00 1 $ 74.90 $ 64.20 $ 10.70
03 Southern Right Pinotage 71101-BS1302 1.00 1.00 $ 21.00 0.00 1 $ 21.00 $ - $ 21.00
04 Anakena Sauvingon Blanc 70801-BA0612 32.00 32.00 20 $ 8.00 20.00 12 $ 256.00 $ 160.00 $ 96.00
05 Anakena Cabernet Sauvignon 2008 (750ml) 70801-BA0601 69.00 69.00 40 $ 7.70 40.00 29 $ 531.30 $ 308.00 $ 223.30
06 Chateau Escot 70304-BC0966 3.00 2 5.00 1 2 $ 19.80 3.00 2 $ 99.00 $ 59.40 $ 39.60
07 Orbiel Frers Merlot (Jan-Feb 18 ) 70308-B00403 47.00 47.00 33 $ 8.50 33.00 14 $ 399.50 $ 280.50 $ 119.00
08 Orbiel Freres Sauvignon Blanc ( Jan-Feb 18 ) 70308-B00404 24.00 24.00 15 $ 8.50 15.00 9 $ 204.00 $ 127.50 $ 76.50
09
10
11
12
13
14
69 $ 602.10
Prepared By:
Mr. MUTH NARITH
New Order

No. Detail Code Require U/M


1 Chateau Reynon Blanc 70303-BC0933 3 Btl
2 Cuilleron Viognier 70307-BD0516 3 Btl
3 Cuilleron Marsanne 70307-BD0509 3 Btl
4 Chateau vieux perey saint emilion 70304-BC0949 3 Btl
5 Southern Right Pinotage 71101-BS1302 3 Btl
6 Chateau Escot 70304-BC0966 3 Btl
7 Chateau Clou du Pin BC0983 3 Btl
8 Bird in Hand Sauvignon Blanc 70401-BB1105 3 Btl

You might also like