SPR_Duty_Sheets_August_Rates.xlsx

	B	C	D	G	H	I	J	K	O	P
1
2
3					FILL THIS IN				YOUR DUTY RATES
4	D	discount expressed in £ per litre of pure alcohol
5	C	cumulative discount for that band (found in lookup table)			Product	Qty (hL)	% abv	SPR hLpa	All Packaged Below 3.5%	£0.00
6	M	marginal discount for that band (found in lookup table)		1	Mild		4.5%	0.00	All Draught Below 3.5%	£0.00
7	P	production amount in hLpa (hectolitres pure alcohol) in previous year		2	Bitter	9	4.2%	0.38	Packaged Beer	£2.10
8	S	start threshold for that band (found in lookup table)		3	Stout	7.36	4.8%	0.35	Draught Beer	£1.91
9				4	Old Ale	9	4.6%	0.41	Packaged Cider	£0.00
10				5	Ol'Ivan's Goodnigh Cap	6.95	4.1%	0.28	Draught Cider	£0.00
11	Formula:	D = (( C + (M x ( P - S )) )/ P		6				0.00	Sparkling Cider/Wines/Spirits	£0.00
12				7				0.00	Draught Cider/Wine/Spirits	£0.00
13				8				0.00
14		Annual Production (hL):	32.31	9				0.00
15		SPR hLpa:	1.43	10				0.00
16				11				0.00
17				12				0.00
18				13				0.00
19		Packaged / Base Rates	(£ per litre pure alcohol)	14				0.00
20		Low Strength 1.2% to 3.4%	£9.27	15				0.00
21		Still Cider, Sparkling Cider 3.5% up to 5.5%	£9.67	16				0.00
22		Beer 3.5% to 8.4%	£21.01	17				0.00
23		Spirits, Wines and other fermented products 3.5% to 8.4%	£24.77	18				0.00
24		High Strength 8.5% to 22%	£25.80	19				0.00
25		Exceeding 22%	£31.64	20				0.00
26					Total:	32.31		1.43
27		Draught Rates
28		Low Strength 1.2% to 3.4%	8.42
29		Still Cider, Sparkling Cider 3.5% up to 5.5%	£8.78
30		Beer, spirits, wine and other fermented products 3.5% to 8.4%	£19.08
31		Sparkling cider 5.6% to 8.4%	19.08
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