IC-Bar-Inventory-Template-with-Sample-Data_Google_Sheet

	B	C	D	E	F	G	H	I	J	K
1

2	BAR INVENTORY TEMPLATE WITH SAMPLE DATA						https://www.smartsheet.com/try-it?trp=11652&utm_source=integrated-content&utm_campaign=/content/excel-bar-liquor-inventory-template&utm_medium=Bar+Inventory+Template+with+Sample+Data+google+sheets+11652&lpa=Bar+Inventory+Template+with+Sample+Data+google+sheets+11652
3	LOCATION			PREPARED BY		DATE
4	Freestyles Inn			Ben B.		MM/DD/YYYY
5
6	LOCATION: FRONT BAR
7	CATEGORY	ORDER BY		ITEMS / UNIT DETAILS		COST PER ITEM	STOCK QUANTITY	REORDER LEVEL	REORDER (auto-fill)	ITEM REORDER QUANTITY
8	CATEGORY	UNIT	COST	QTY/UNIT	ITEM SIZE	COST PER ITEM	STOCK QUANTITY	REORDER LEVEL	REORDER (auto-fill)	ITEM REORDER QUANTITY
9	BOTTLED BEER
10	Heineken	Case	$ 35.00	24	12 oz bottle	$ 1.46	200	50	OK	100
11	Iron City	Case	$ 23.00	24	12 oz bottle	$ 0.96	12	24	REORDER	50
12	Coors Light	Case	$ 22.00	24	12 oz bottle	$ 0.92	17	24	REORDER	50
13	KEG BEER
14	Heineken	.5 barrel	$ 185.00	62	16 oz pint	$ 2.98	15	12	OK	100
15	Guinness	.5 barrel	$ 165.00	62	16 oz pint	$ 2.66	5	5	REORDER	50
16	Lagunitas	.5 barrel	$ 207.00	62	16 oz pint	$ 3.34	12	11	OK	50
17	WINE
18	Cabernet	750 ml	$ -	24	7 oz	$ -	35	50	REORDER	100
19	Merlot	750 ml	$ -	24	7 oz	$ -	22	24	REORDER	50
20	Pinot Grigio	750 ml	$ -	24		$ -	20	15	OK	50
21	Prosecco	750 ml	$ -	0			12	12	REORDER	0
22	LIQUOR
23	Bourbon		$ -	24	2 oz	$ -	200	50	OK	100
24	Vodka		$ -	24	2 oz	$ -	12	24	REORDER	50
25	Gin		$ -	24		$ -	12	24	REORDER	50
26	Tequila		$ -	0			12	12	REORDER	0
27	Other
28	Tonic		$ -	24		$ -	200	50	OK	100
29	Club soda		$ -	24		$ -	12	24	REORDER	50
30	Lime juice		$ -	24		$ -	12	24	REORDER	50
31
32	LOCATION: BACK BAR
33	CATEGORY	ORDER BY		ITEMS / UNIT DETAILS		COST PER ITEM	STOCK QUANTITY	REORDER LEVEL	REORDER (auto-fill)	ITEM REORDER QUANTITY
34	CATEGORY	UNIT	COST	QTY/UNIT	ITEM SIZE	COST PER ITEM	STOCK QUANTITY	REORDER LEVEL	REORDER (auto-fill)	ITEM REORDER QUANTITY
35	BOTTLED BEER
36	Heineken	Case	$ 35.00	24	12 oz bottle	$ 1.46	200	50	OK	100
37	Iron City	Case	$ 23.00	24	12 oz bottle	$ 0.96	12	24	REORDER	50
38	Coors Light	Case	$ 22.00	24	12 oz bottle	$ 0.92	17	24	REORDER	50
39	KEG BEER
40	Heineken	.5 barrel	$ 185.00	62	16 oz pint	$ 2.98	15	12	OK	100
41	Guinness	.5 barrel	$ 165.00	62	16 oz pint	$ 2.66	5	5	REORDER	50
42	Lagunitas	.5 barrel	$ 207.00	62	16 oz pint	$ 3.34	12	11	OK	50
43	WINE
44	Cabernet	750 ml	$ -	24	7 oz	$ -	35	50	REORDER	100
45	Merlot	750 ml	$ -	24	7 oz	$ -	22	24	REORDER	50
46	Pinot Grigio	750 ml	$ -	24		$ -	20	15	OK	50
47	Prosecco	750 ml	$ -	0			12	12	REORDER	0
48	LIQUOR
49	Bourbon		$ -	24	2 oz	$ -	200	50	OK	100
50	Vodka		$ -	24	2 oz	$ -	12	24	REORDER	50
51	Gin		$ -	24		$ -	12	24	REORDER	50
52	Tequila		$ -	0			12	12	REORDER	0
53	Other
54	Tonic		$ -	24		$ -	200	50	OK	100
55	Club soda		$ -	24		$ -	12	24	REORDER	50
56	Lime juice		$ -	24		$ -	12	24	REORDER	50
57
58	LOCATION: BEER FRIDGE
59	CATEGORY	ORDER BY		ITEMS / UNIT DETAILS		COST PER ITEM	STOCK QUANTITY	REORDER LEVEL	REORDER (auto-fill)	ITEM REORDER QUANTITY
60	CATEGORY	UNIT	COST	QTY/UNIT	ITEM SIZE	COST PER ITEM	STOCK QUANTITY	REORDER LEVEL	REORDER (auto-fill)	ITEM REORDER QUANTITY
61	BOTTLED BEER
62	Heineken	Case	$ 35.00	24	12 oz bottle	$ 1.46	200	50	OK	100
63	Iron City	Case	$ 23.00	24	12 oz bottle	$ 0.96	12	24	REORDER	50
64	Coors Light	Case	$ 22.00	24	12 oz bottle	$ 0.92	17	24	REORDER	50
65	KEG BEER
66	Heineken	.5 barrel	$ 185.00	62	16 oz pint	$ 2.98	15	12	OK	100
67	Guinness	.5 barrel	$ 165.00	62	16 oz pint	$ 2.66	5	5	REORDER	50
68	Lagunitas	.5 barrel	$ 207.00	62	16 oz pint	$ 3.34	12	11	OK	50
69	WINE
70	Cabernet	750 ml	$ -	24	7 oz	$ -	35	50	REORDER	100
71	Merlot	750 ml	$ -	24	7 oz	$ -	22	24	REORDER	50
72	Pinot Grigio	750 ml	$ -	24		$ -	20	15	OK	50
73	Prosecco	750 ml	$ -	0			12	12	REORDER	0
74	LIQUOR
75	Bourbon		$ -	24	2 oz	$ -	200	50	OK	100
76	Vodka		$ -	24	2 oz	$ -	12	24	REORDER	50
77	Gin		$ -	24		$ -	12	24	REORDER	50
78	Tequila		$ -	0			12	12	REORDER	0
79	Other
80	Tonic		$ -	24		$ -	200	50	OK	100
81	Club soda		$ -	24		$ -	12	24	REORDER	50
82	Lime juice		$ -	24		$ -	12	24	REORDER	50
83
84	LOCATION: LIQUOR STORAGE
85	CATEGORY	ORDER BY		ITEMS / UNIT DETAILS		COST PER ITEM	STOCK QUANTITY	REORDER LEVEL	REORDER (auto-fill)	ITEM REORDER QUANTITY
86	CATEGORY	UNIT	COST	QTY/UNIT	ITEM SIZE	COST PER ITEM	STOCK QUANTITY	REORDER LEVEL	REORDER (auto-fill)	ITEM REORDER QUANTITY
87	BOTTLED BEER
88	Heineken	Case	$ 35.00	24	12 oz bottle	$ 1.46	200	50	OK	100
89	Iron City	Case	$ 23.00	24	12 oz bottle	$ 0.96	12	24	REORDER	50
90	Coors Light	Case	$ 22.00	24	12 oz bottle	$ 0.92	17	24	REORDER	50
91	KEG BEER
92	Heineken	.5 barrel	$ 185.00	62	16 oz pint	$ 2.98	15	12	OK	100
93	Guinness	.5 barrel	$ 165.00	62	16 oz pint	$ 2.66	5	5	REORDER	50
94	Lagunitas	.5 barrel	$ 207.00	62	16 oz pint	$ 3.34	12	11	OK	50
95	WINE
96	Cabernet	750 ml	$ -	24	7 oz	$ -	35	50	REORDER	100
97	Merlot	750 ml	$ -	24	7 oz	$ -	22	24	REORDER	50
98	Pinot Grigio	750 ml	$ -	24		$ -	20	15	OK	50
99	Prosecco	750 ml	$ -	0			12	12	REORDER	0
100	LIQUOR