INVENTARIO PRODUCTO NEW.xlsx

	A	C	D	E	F	G	H	I	J
1
2	INVENTARIO BEBIDAS
3
4
5
6	Producto	Provedor	ML	Precio und	Nevera 1	Nevera 2	Bodega	TOTAL	PRECIO POR PRODUCTO
7	Cervezas
8	ClUB COLOMBIA BOTELLA	DISLICORES - BAV	330 ml		21			21	$0
9	ClUB COLOMBIA LATA	DISLICORES - BAV	330 ml		2			2	$0
10	CORONITA 210 ML	DISLICORES - BAV	210 ml		12			12	$0
11	CORONA 0	DISLICORES - BAV	330 ml		4			4	$0
12	CORONA	DISLICORES - BAV	330 ml		18			18	$0
13	STELLA ARTOIS	DISLICORES - BAV	300 ml		13			13	$0
14	HEINEKEN 330 ML	DISLICORES - BAV	330 ml		6			6	$0
15	ROSE - 3 CORDILLERAS	POSTOBON	330 ml			16		16	$0
16	SIN LICOR
17	Producto	Provedor	ML	Precio und	Nevera 1	Nevera 2	Bodega	TOTAL	PRECIO POR PRODUCTO
18	GINGER ALE SCHWPPES	FEMSA	400ml	$1,464		15	24	39	$57,096
19	TONICA ALE SCHWPPES	FEMSA	300 ml	$1,680		16	24	40	$67,200
20	COCA- COLA 400 ML	FEMSA	400 ml	$2,283		8		8	$18,264
21	COCA-COLA ZERO 400 ML	FEMSA	400 ml	$2,166		13	5	18	$38,988
22	AGUA MANANTIAL SIN GAS	FEMSA	300 ml	$1,516		5		5	$7,580
23	AGUA MANANTIAL CON GAS	FEMSA	300 ml	$1,516		19		19	$28,804
24	JUNIPER CAFÉ	JHD	200 ml	$5,300		12		12	$63,600
25	JUNIPER TORONJA	JHD	200 ml	$5,474		10		10	$54,740
26	JUNIPER CIDRA ROSAS	JHD	200 ml	$5,474		10		10	$54,740
27	JUNIPER TÓNICA	JHD	200 ml	$5,474		12		12	$65,688
28	AGUA HATSU 300 Ml	POSTOBON	300ml	$1,232		14	3	17	$20,944
29	SODA BRETAÑA 300 ML	POSTOBON	300ml	$1,484		14		14	$20,776
30	SODA SANDIA Y ALBA	POSTOBON	300ml	$2,089		2		2	$4,178
31	SMIRNOFF ICE	MEICO	250 ml	$7,130		8		8	$57,040
32	GINGER BEER - MIL 976	DISLICORES	200 ml			19		19	$0
33	PULPAS
34	Producto	Provedor	UND PAQ	Precio und	Nevera 1	Nevera 2	Bodega	TOTAL	PRECIO POR PRODUCTO
35	COCO	SURTIPULPAS	10	3600	7			7	$25,200
36	MARACUYA	SURTIPULPAS	10	3600	9			9	$32,400
37	FRESA	SURTIPULPAS	10	3600	3			3	$10,800
38	CEREZA	SURTIPULPAS	10	3600	2			2	$7,200
39	MANGO	SURTIPULPAS	10	3600	4			4	$14,400
40	MANDARINA	SURTIPULPAS	10	3600	3			3	$10,800
41	VINOS
42	Producto	Provedor	TRAGOS BOTELLA	Precio und	TRAGOS		Bodega	TOTAL	PRECIO POR COPAS
43	QUINTA . TINTO	D1	6	$16,950	2			2	$5,650
44	QUINTA - BLANCO	D1	6	$16,950	6			6	$16,950
45	QUINTA CABRAS - BRUT	D1	12	$24,950	1			1	$2,079
46	HITO TEMPRANILLO (750 ml)		6		6			6
47	DON LUIS MERLOT (750 ml)		6		6			6
48	DESTILADOS
49	Producto	Provedor	TRAGOS BOTELLA	Precio und	TRAGOS		Bodega	TOTAL	PRECIO POR TRAGOS
50	JOHNNIE WALKER DUBLE BLACK (700 ml)	DIAGEO	11	$160,782	8			8
51	JOHNNIE WALKER SWING (750 ml)	DIAGEO	12		12			12
52	JOHNNIE WALKER WINE CASK BLEND (750 Ml)	DIAGEO	12		8			8
53	JOHNNIE WALKER RED LABEL ( 1 LT)	DIAGEO	16	$79,912	13			13
54	JOHNNIE WALKER BLACK LABEL (700 Ml)	DIAGEO	11	$130,173	6			6
55	JACKS DANIELS TENNESI (750 ml)	GLOBAL WINE	12		5			5
56	BUCHANANS DELUXE 12 AÑOS (750 ml)	DIAGEO	12	$140,000	13			13
57	BUCHANANS MÁSTER (750 ml)	DIAGEO	12	$164,956	11			11
58	OLD PARR 12 (750 ml)	DIAGEO	12	$124,000	1			1
59	CHIVAS REGAL 18 (700 ml)	INVERTEK	11		6			6
60	CHIVAS REGAL EXTRA 13 (700 ml)	INVERTEK	11		11			11
61	TEQUILA OLMECA REPOSADO ( 700 ml)	INVERTEK	11	$67,800	8			8
62	DON JULIO 70 ( 700 ml)	DIAGEO	11	$337,457	10			10
63	DON JULIO REPOSADO (700 ml)	DIAGEO	11	$241,564	3			3
64	1800 AÑEJO (750 ml)	DISLICORES	12		6			6
65	TEQUILA JIMADOR BLANCO (700 ml)		11		1			1
66	RON DIPLOMÁTICO MANTUANO (700ml)		11		11			11
67	RON PAMPERO ANIVERSARIO (700ml)		11		11			11
68	RON ZACAPA ÁMBAR 12 (750 ml)	MEICO	12	$117,651	7			7
69	RON PAMPERO AÑEJO (700ml)		11		6			6
70	RON VIEJO DE CALDAS BLANCO (750ml)		12		3			3
71	RON MEDELLÍN (375 ml)		6		6			6
72	HENNESY COGNAC (700ml)		11		7			7
73	GORDONS PINK (700ml)	DIAGEO	11	$65,000	2			2
74	TANQUERAY (700ml)	DIAGEO	11	$125,564	3			3
75	VODKA SMIRNOFF (700ml)	DIAGEO	11	$79,303	9			9
76	VODKA SMIRNOFF SPICY TAMARINDO (700ml)	DIAGEO	11	$41,833	10			10
77	APEROL (750 ml)	BOGA	12	$87,516	9			9
78	CAMPARI (750 ml)	BOGA	12	$105,500	9			9
79	MARTINY BIANCO (750 ml)	DISLICORES	12		10			10
80	MARTINY ROSSO (750 ml)	DISLICORES	12		7			7
81	TRIPLE SEC CONVIER (750 ml)	DISLICORES	12		5			5
82	CACAO CONVIER (750 ml)	DISLICORES	12		12			12
83	MONIN ROSAS (750 ml)	MEICO	12	$52,440	9			9	$39,330
84	MONIN FLOR DE SAÚCO (750 ml)	MEICO	12	$52,440	10			10	$43,700
85	BAILEYS (700 ml)	DIAGEO	11	$69,825	4			4
86
87
88	VALOR TOTAL DEL INVENTARIO EN PRODUCTOS EXISTENTES		$713,407
89
90
91
92
93
94
95
96
97
98
99
100