Hangyo<>Eatclub RM Summary

	A	B	C	D	E	F	J	K	L	N	O	P	Q	R	S	T	U	V	W
1	140 ml Code	550 ml Code	Flavour Name	140 ml	550 ml	Qty of Icecream	Qty of WB-12	Qty of WB-15	Qty of CB	Recipe item	Category	Total qty as per ideal recipe	adding %age of wastage and allowance	Total Consumption Qty	Opening Stock	GRN Qty	Ideal Closing	Actual Closing	Varience
2	11	51	Real Vanilla Bean	2384	1600	745.6		733.6		Prigel Vanilla Paste	Inventory	11	2	11.22	10.3	12	11.08	6.8	4.28
3	12	52	Almond Butterscotch	5005	1501	939.5	823.5			Givudan Vanilla Essence	Inventory	4.6	2	4.69	0	6.4	1.71	2	-0.29
4	13	53	Nutella Heaven	0	0	0.0	0.0		0.0	Ice Cream Container 140 ml	Inventory	66365		66365	73510		7145	12105	-4960
5	14	54	Choco-Cookies & Creme	5976	1497	1022.4	896.1			Caramel Sauce	Intermediate Product	133.8	2	136.48	0		-136.48	40	-176.48
6	15	55	Chocolate Hazelnut	4008	0	347.6	183.4		117.3	Butterscotch Essence	Inventory	3.4	2	3.47	6		2.53	0	2.53
7	16	56	Fine Chocolate Silk	4160	1500	865.9			831.3	Chocolate Cookie	Inventory	382.6	5	401.73	16	470	84.27	242.4	-158.13
8	17	57	Red Velvet Cheesecake	5704	599	696.4	612.9			Roasted Hazelnut	Inventory	15.6	2	15.91	10	10	4.09	6	-1.91
9	18	58	Blueberry Cheesecake	2392	600	409.5	313.3			Hazelnut Paste - Double Roasted	Intermediate Product	15.6	2	15.91	0	30	14.09	15.2	-1.11
10	19	59	Chocolate Brownie Fudge	5240	748	706.4			586.3	Red Velvet Cookie	Inventory	69.9	5	73.4	10	80	16.61	49.5	-32.9
11	20	60	Coffee Mocha Fudge	6016	2237	1275.1	1077.4			MEC3 Quark Powder	Intermediate Product	22.2	2	22.64	2	30	9.36	25	-15.64
12	22	62	Wild Forest Berries	4640	600	604.5		517.4		Blueberry Paste	Intermediate Product	89.5	2	91.29	0		-91.29	90	-181.29
13	24	64	100% Saffron & Pistacchio	3264	648	501.3		448.5		Cheese Cookie	Intermediate Product	49.4	5	51.87	67.5	60	75.63	52	23.63
14	25	65	Dry Fruit Overload Kulfi	6504	1300	1001.9		300.6		Chocolate Fudge Sauce	Intermediate Product	135.9	2	138.62	0		-138.62	40	-178.62
15	26	66	Alphonso Mango	3024	0	262.3		201.9		Nescafe Coffee	Intermediate Product	19.3	2	19.69	2	24	6.31	5.5	0.81
16	27	67	Triple Chocolate Overload	2400	1200	612.2			514.3	Cranberries Dried	Inventory	18.2	5	19.11	9	17	6.89	10.5	-3.61
17	28	68	Death by Chocolate	6304	2179	1280.5			1011.6	Black Current Dried	Inventory	18.2	5	19.11	6	20	6.89	10	-3.11
18	29	69	Salted Caramel Cheesecake	0	0	0.0	0.0			Baby Saffron	Inventory	0.2	2	0.2	0.04	0.25	0.09	0.08	0.01
19				67021	16209	11271.2	3906.6	2202.0	3060.8	Pista Slices	Inventory	25.1	5	26.36	0	29	2.65	5	-2.36
20										Firmenich Mango Flavour	Inventory	0	0	0	2.5		2.5	2.5	0
21										Morde Dark Chocolate Chips	Inventory	80.1	5	84.11	95		10.9	9.5	1.4
22										Morde White Compound Chips	Inventory	80.1	5	84.11	20	80	15.9	25.3	-9.4
23										Ice cream container 550 ml	Inventory	16209	0	16209	18789		2580	2750	-170
24										Fresh Cream	Inventory	1382.9	2	1410.56			-1410.56	16.6	-1427.16
25										Ice Cream Milk	Inventory	5658.6	2	5771.77			-5771.77		-5771.77
26										Liquid Glucose	Inventory	411.1	2	419.32			-419.32		-419.32
27										Skimmed milk powder	Inventory	529.3	2	539.89			-539.89		-539.89
28										Stabilizer- Icepro 1001	Inventory	43.3	2	44.17	14	49	18.83	16.6	2.23
29										Cocoa Mass Olam (Ghana)	Inventory	39.5	2	40.29	7.2	50	16.91	52.3	-35.39
30										Cocoa Powder - Olam354	Inventory	204.1	2	208.18	9.5	275	76.32	116	-39.68
31										Sugar	Inventory	78.4	2	79.97			-79.97		-79.97
32										Butter- Unsalted	Inventory	39.2	2	39.98			-39.98		-39.98
33										Dira Frozen Blueberry	Inventory	49.2	2	50.18	168		117.82	169	-51.18
34										Danisco Pectin	Inventory	0.4	2	0.41	0		-0.41		-0.41
35										Citric Acid	Inventory	0.5	2	0.51	0		-0.51		-0.51
36										Prova Blueberry Flavour	Inventory	0.4	2	0.41	0.2	0.6	0.39	0.8	-0.41
37										Black Currant Colour	Inventory	1.3	2	1.33	0		-1.33		-1.33
38										Cocoa Powder - Olam500	Inventory	2.1	2	2.14	18		15.86	16	-0.14
39																	0		0
40
41
42
43
44
45
46
47
48
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