ABCDEFGHIJKLMNOPQRSTUV
1
Directions for use:
Step 1: Cost your cocktail and input in D3
Step 2: Input your selling price in E4
Step 3: Input your VAT in decimal format if tax is included in your selling price in J3
2
Cost Calculator Template
3
No.Cocktail NameCost Per Serve
Gross Selling Price
Net Selling Price
Cost %Input VAT %
(in decimal form)
Example: If 10% VAT is included in your selling price, input as 0.1
[If VAT is not included in your gross selling price, input 0]		0
4
1 1.00 30 30 3%
5
2 - #DIV/0!
6
3 - #DIV/0!
7
4 - #DIV/0!
8
5 - #DIV/0!
9
6 - #DIV/0!
10
AVG COST:#DIV/0!
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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