Wine Costing

	A	B	D	E	F	G	H	J	K	L
1
2	WINE COSTING PER BOTTLE		Quantity per Bottle (ML)	Cost per Bottle (RM)	Selling Price (RM)	Margin		In Stock	Display	Total Stock
3	WINE COSTING PER BOTTLE		Quantity per Bottle (ML)	Cost per Bottle (RM)	Selling Price (RM)	Margin		In Stock	Display	Total Stock
4	WHITE WINE	Rapaura Springs Marlborough Sau-Blanc	700	114	180	0.37		9	1	10
5		Fault Line Sauvignon Blanc 21	700	94	150	0.37		8	1	9
6		Joseph Drouhin Chablis Reserve Domaine De Voudon	700	142	220	0.35		5	1	6
7		Villa Maria Private Bin Sauvignon Blanc	700	120	200	0.40		-	-	-
8		Domaine Jean Marc Brocard Chablis Premier Cru Vau De Vey 2020	700	294	450	0.35		-	-	-
9		Domaine Jean Marc Brocard Chablis Premier Cru Claire 2022	700	196	350	0.44		12	-	-
10	RED WINE	Cuvee 16 Vino Rosso	700	135	200	0.33		6	2	8
11		Ca Vittoria Appassimento	700	122	220	0.45		9	2	11
12		Torbreck Woodcutter Shiraz	700	120	220	0.45		7	2	9
13		La la land Pinot Noir	700	72	140	0.49		-	-	-
14		Michel Lynch Prestige Saint Emillion	700	110	170	0.35		-	-	-
15		Kaiken Ultra Las Rocas Malbec	700	129.9	190	0.32		-	-	-
16		Rocca Di Frassinello Maremma Toscana 2017 (Super Tuscan)	700	361	520	0.31		-	-	-
17		Rocca Di Frassinello Maremma Toscana 2019	700	310	510	0.39		12	-	12
18
19	WINE COSTING PER GLASS		Per UOM (cost per ml)	UOM	Quantity per glass (ml)	Cost per glass (RM)	Selling Price per glass (ml)	Margin
20	WINE COSTING PER GLASS		Per UOM (cost per ml)	UOM	Quantity per glass (ml)	Cost per glass (RM)	Selling Price per glass (ml)	Margin
21	WHITE WINE	Rapaura Springs Marlborough Sau-Blanc	0.16	ml	250	40.71	55.00	0.26
22		Fault Line Sauvignon Blanc 21	0.13	ml	250	33.57	45.00	0.25
23		Joseph Drouhin Chablis Reserve Domaine De Voudon	0.20	ml	250	50.71	65.00	0.22
24		Villa Maria Private Bin Sauvignon Blanc	0.17	ml	250	42.86	55.00	0.22
25		Domaine Jean Marc Brocard Chablis Premier Cru Vau De Vey 2020	0.42	ml	250	105.00	135.00	0.22
26		Domaine Jean Marc Brocard Chablis Premier Cru Claire 2022	0.28	ml	250	70.00	90.00	0.22
27	RED WINE	Cuvee 16 Vino Rosso	0.19	ml	250	48.21	60.00	0.20
28		Ca Vittoria Appassimento	0.17	ml	250	43.57	60.00	0.27
29		Torbreck Woodcutter Shiraz	0.17	ml	250	42.86	60.00	0.29
30		La la land Pinot Noir	0.10	ml	250	25.71	35.00	0.27
31		Michel Lynch Prestige Saint Emillion	0.16	ml	250	39.29	55.00	0.29
32		Kaiken Ultra Las Rocas Malbec	0.19	ml	250	46.39	60.00	0.23
33		Rocca Di Frassinello Maremma Toscana 2017 (Super Tuscan)	0.52	ml	250	128.93	165.00	0.22
34		Rocca Di Frassinello Maremma Toscana 2019	0.44	ml	250	110.71	155.00	0.29
35
36
37
38
39
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