Zen Cafe Inventory Register.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	ZEN CAFE — MASTER INVENTORY REGISTER
2	Complete asset & stock register \| Updated by Facility Manager when stock changes \| Reviewed by GM weekly
3
4	INSTRUCTIONS: Fill Qty on Hand by physically counting every item. Condition: Good / Damaged / Needs Repair / Missing. Expiry Date: perishables & consumables only. Par Level = minimum stock that must always be maintained.
5	#	ITEM NAME	SUBCATEGORY	CATEGORY	UNIT	PAR LEVEL	QTY ON HAND	CONDITION	LOCATION / NOTES	EXPIRY DATE	LAST UPDATED	UPDATED BY

6	KITCHEN — FOOD STOCK
7	1	Local Rice	Grains & Staples	FOOD STOCK	35300g	5000g		Good				Andrew
8	2	Basmati Rice	Grains & Staples	FOOD STOCK	32950g	5000g		Good				Andrew
9	3	Spagetti	Grains & Staples	FOOD STOCK	12000g	2000g		Good				Andrew
10	4	Linguine Pasta	Grains & Staples	FOOD STOCK	4500g	1000g		Good				Andrew
11	5	Penne Pasta	Grains & Staples	FOOD STOCK	7000	2000g		Good				Andrew
12	6	Flour - Golden penny	Grains & Staples	FOOD STOCK	22800g	5000g		Good		01-Jul-2026		Andrew
13	7	Flour - Golden medal	Grains & Staples	FOOD STOCK	10880g	5440g		Good		01-Mar-2027		Andrew
14	8	Eggs	Proteins	FOOD STOCK	20pcs	30pcs		Good				Andrew
15	9	Chicken (whole)	Proteins	FOOD STOCK	7pcs	2pcs		Good				Andrew
16	10	Chicken (breast)	Proteins	FOOD STOCK	10100g	5000g		Good				Andrew
17	11	Beef (minced)	Proteins	FOOD STOCK	10000g	3000g		Good				Andrew
18	12	Beef (cow)	Proteins	FOOD STOCK	29000g	5000g		Good				Andrew
19	13	Beef Sauasage	Proteins	FOOD STOCK	25pcs	10pcs		Good				Andrew
20	14	Fish - Croacker	Proteins	FOOD STOCK	12pcs	5pcs		Good				Andrew
21	15	Chicken Sauasage	Proteins	FOOD STOCK	0			Not available				Andrew
22	16	Pork Sauasage	Proteins	FOOD STOCK	35pcs	10pcs		Good				Andrew
23	17	Prawns/Shrimp	Proteins	FOOD STOCK	3700g	1000g		Good				Andrew
24	18	Tomatoes (fresh)	Vegetables	FOOD STOCK	27500g	5000g		Good				Andrew
25	19	Tomatoes (canned) - Gino	Vegetables	FOOD STOCK	9030g	2100g		Good				Andrew
26	20	Onions	Vegetables	FOOD STOCK
27	21	Peppers (fresh)	Vegetables	FOOD STOCK	2500g	1000g		Good				Andrew
28	22	Lettuce	Vegetables	FOOD STOCK	250g	50g		Good				Andrew
29	23	Cucumber	Vegetables	FOOD STOCK	0			Not available				Andrew
30	24	Cabbage White	Vegetables	FOOD STOCK	1200g	500g		Good				Andrew
31	25	Carrots	Vegetables	FOOD STOCK	600g	300g		Good				Andrew
32	26	Garlic	Vegetables	FOOD STOCK	1650g	500g		Good				Andrew
33	24	Ginger- Fresh	Vegetables	FOOD STOCK	2800g	500g		Good				Andrew
34	25	Mixed vegetables (frozen)	Vegetables	FOOD STOCK	0			Not available				Andrew
35	26	Butter -Golden penny	Dairy	FOOD STOCK	4500g	1800g		Good				Andrew
36	27	Cream Cheese	Dairy	FOOD STOCK	3210g	180g		Good				Andrew
37	28	Slice Cheese	Dairy	FOOD STOCK	288pcs	24pcs		Good				Andrew
38	29	Chedder Cheese	Dairy	FOOD STOCK	3700g	800g		Good				Andrew
39	30	Parmesan Chees	Dairy	FOOD STOCK	400g	100g		Good				Andrew
40	31	Cooking oil (vegetable)	Oils & Condiments	FOOD STOCK	52050g	15000g		Good				Andrew
41	32	Olive oil	Oils & Condiments	FOOD STOCK	1000g	1000g		Good				Andrew
42	33	Mayonnaise	Oils & Condiments	FOOD STOCK	7290g	1620g		Good				Andrew
43	34	Ketchup	Oils & Condiments	FOOD STOCK	5000g	1250g		Good				Andrew
44	35	Light Soy sauce	Oils & Condiments	FOOD STOCK	3125g	625g		Good				Andrew
45		Dark Soy Sauce	Oils & Condiments	FOOD STOCK	1920g	640g		Good				Andrew
46	36	Oyster Sauce	Oils & Condiments	FOOD STOCK	2820g	1400g		Good				Andrew
47	37	Salt	Seasonings	FOOD STOCK	2000g	1000g		Good				Andrew
48	38	Black pepper	Seasonings	FOOD STOCK	1112g	65g		Good				Andrew
49	39	Mixed spices	Seasonings	FOOD STOCK	0			Not available				Andrew
50	40	Curry powder	Seasonings	FOOD STOCK	1785g	255g		Good				Andrew
51	41	Thyme	Seasonings	FOOD STOCK	43g	43g		Good				Andrew
52	42	knorr cubes	Seasonings	FOOD STOCK	2000g	400g		Good				Andrew
53	43	Sugar (white)	Dry Goods	FOOD STOCK	5000g	2000g		Good				Andrew
54	44	Sugar (brown)	Dry Goods	FOOD STOCK	2800g	700g		Good				Andrew
55	45	Honey	Dry Goods	FOOD STOCK	500g	1000g		Good				Andrew
56	46	Baking powder	Dry Goods	FOOD STOCK	3600g	600g		Good				Andrew
57	47	Cocoa powder	Dry Goods	FOOD STOCK	500g	250g		Good				Andrew
58	48	Cornflour	Dry Goods	FOOD STOCK	2100g	300g		Good				Andrew
59	BAR & BEVERAGES
60	49	Coffee beans (Medium dark)	Coffee	BAR & BEVERAGES	4000g	1000g		Good				Andrew
61	50	Coffee beans (dark)	Coffee	BAR & BEVERAGES	0			Not available				Andrew
62	51	Ground coffee (espresso)	Coffee	BAR & BEVERAGES	0			Not available				Andrew
63	52	Decaf coffee	Coffee	BAR & BEVERAGES	72pcs	24pcs		Good				Andrew
64	53	Milk (DANO FULL CREAM)	Milk & Cream	BAR & BEVERAGES	56000ml	12000g		Good				Andrew
65	54	Milk (DANO LOW FAT )	Milk & Cream	BAR & BEVERAGES	0			Not available				Andrew
66	55	Whipping Cream Spray	Milk & Cream	BAR & BEVERAGES	3250g	500g		Good				Andrew
67	56	Oat milk	Milk & Cream	BAR & BEVERAGES	22704g	5675g		Good				Andrew
68	57	Almond milk	Milk & Cream	BAR & BEVERAGES	35002g	5675g		Good				Andrew
69	58	Whipping Cream Liquid	Milk & Cream	BAR & BEVERAGES	9000ml	2000g		Good				Andrew
70	59	Vanilla syrup	Syrups	BAR & BEVERAGES	1000ml	1000ml		Good				Andrew
71	60	Caramel syrup	Syrups	BAR & BEVERAGES	0			Not available				Andrew
72	61	Hazelnut syrup	Syrups	BAR & BEVERAGES	1500ml	750ml		Good				Andrew
73	62	Chocolate Sauce	Syrups	BAR & BEVERAGES	1360g	680g		Good				Andrew
74	63	Caramal Sauce	Syrups	BAR & BEVERAGES	4361g	623g		Good				Andrew
75	64	Matcha powder	Syrups	BAR & BEVERAGES	1816g	454g		Good				Andrew
76	65	Chai concentrate	Syrups	BAR & BEVERAGES	0			Not available				Andrew
77	66	Hot chocolate cadbury	Syrups	BAR & BEVERAGES	1620g	600g		Good				Andrew
78	67	Fruit juice (orange)	Juices & Cold	BAR & BEVERAGES	0			Not available				Andrew
79	68	Fruit juice (mango)	Juices & Cold	BAR & BEVERAGES	0			Not available				Andrew
80	69	Smoothie base/frozen fruits	Juices & Cold	BAR & BEVERAGES	0			Not available				Andrew
81	70	Nestle water	Bottled Drinks	BAR & BEVERAGES	18pcs	20pcs		Good				Andrew
82	71	Sparkling water (bottles)	Bottled Drinks	BAR & BEVERAGES	66pcs	12pcs		Good				Andrew
83	72	Coke	Can Drinks	BAR & BEVERAGES	60pcs	24pcs		Good				Andrew
84		Fanta	Can Drinks	BAR & BEVERAGES
85		Sprite	Can Drinks	BAR & BEVERAGES
86			Can Drinks	BAR & BEVERAGES
87			Can Drinks	BAR & BEVERAGES
88	73	Energy drinks - RedBull	Can Drinks	BAR & BEVERAGES	65pcs	12pcs		Good				Andrew
89	74	Liption Tea Bag	Tea	BAR & BEVERAGES	75pcs	25pcs		Good				Andrew
90	75	English Breakfast Tea bag	Tea	BAR & BEVERAGES	65pcs	25pcs		Good				Andrew
91	76	Green Mint Tea bag	Tea	BAR & BEVERAGES	25pcs	25pcs		Good				Andrew
92	77	Ice (bags)	Ice & Extras	BAR & BEVERAGES	0			Not Available				Andrew
93	PASTRY & DESSERT
94	78	Flour (pastry grade)	Baking Supplies	PASTRY & DESSERT	100
95	79	Butter (unsalted) - Opal	Baking Supplies	PASTRY & DESSERT	6000g	2000g		Good				Andrew
96	80	Icing sugar	Baking Supplies	PASTRY & DESSERT	0			Not Available				Andrew
97	81	Vanilla essence	Baking Supplies	PASTRY & DESSERT	336g	168g		Good				Andrew
98	82	Baking soda	Baking Supplies	PASTRY & DESSERT	1800g	600g		Good				Andrew
99	83	Gelatin	Baking Supplies	PASTRY & DESSERT	20g	10g		Good				Andrew
100	84	Food colouring (assorted)	Baking Supplies	PASTRY & DESSERT	0			Not Available				Andrew