IC-Restaurant-Food-Inventory-Template_Google_Sheets

	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1

2	RESTAURANT FOOD INVENTORY TEMPLATE						https://www.smartsheet.com/try-it?trp=12363&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Restaurant+Inventory+Spreadsheet-google-sheet-12363&lpa=Restaurant+Inventory+Spreadsheet+google-sheet+12363
3	RESTAURANT NAME	Main Street Café
4	ADDRESS	123 Main Street, City, State xxxxx
5	MANAGER	Henry McNeal
6	DATE OF INVENTORY	MM/DD/YY
7	PREPARED BY	Fiorella Fitzgerald
8
9	ITEM LOCATION	ITEM CATEGORY	ITEM NAME	NECESSARY AS PART OF THE CURRENT MENU?	ITEM NUMBER	STOCK DATE	STOCK QUANTITY	MAX QUANTITY	REORDER	INVENTORY VALUE	UNIT PRICE	VENDOR	VENDOR POINT OF CONTACT	VENDOR CONTACT INFORMATION
10	Stock room	Grains	Wheat bread	NO	123	MM/DD/YY	12	24	12	$ 33.00	$ 2.75	Bakery Alpha	Dana D.	Phone, email
11	Pantry	Grains	Macaroni pasta	YES	234	MM/DD/YY	5	6	1	$ 30.00	$ 6.00	Pasta Inc.	Tony B.	Phone, email
12	Pantry	Baking needs	Wheat flour	NO	345	MM/DD/YY	2	4	2	$ 6.00	$ 3.00	Bakery Alpha	Dana D.	Phone, email
13	Pantry	Baking needs	All-purpose flour	YES	456	MM/DD/YY	1	1	0	$ 3.50	$ 3.50
14	Pantry	Baking needs	Bread flour	YES		MM/DD/YY	2	3	1	$ 7.00	$ 3.50
15	Pantry	Baking needs	Rice flour	YES		MM/DD/YY	1	1	0	$ -	$ -
16	Fridge	Dairy	Rice milk	NO		MM/DD/YY	2	2	0	$ -	$ -
17	Fridge	Dairy	2% milk	NO		MM/DD/YY	2	3	1	$ -	$ -
18	Freezer 1	Meat and poultry	Ground beef	NO		MM/DD/YY	1	1	0	$ -	$ -
19	Freezer 2			NO		MM/DD/YY			0	$ -	$ -
20				NO					0	$ -
21				NO					0	$ -
22				NO					0	$ -
23				NO					0	$ -
24				NO					0	$ -
25				NO					0	$ -
26				NO					0	$ -
27				NO					0	$ -
28				NO					0	$ -
29				NO					0	$ -
30				NO					0	$ -
31				NO					0	$ -
32				NO					0	$ -
33				NO					0	$ -
34				NO					0	$ -
35				NO					0	$ -
36				NO					0	$ -
37				NO					0	$ -
38				NO					0	$ -
39				NO					0	$ -
40				NO					0	$ -
41				NO					0	$ -
42				NO					0	$ -
43				NO					0	$ -
44				NO					0	$ -
45				NO					0	$ -
46				NO					0	$ -
47
48	CLICK HERE TO CREATE IN SMARTSHEET
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100