Overview Budget Scenarios

	B	C	D	E	F	G	H	I	J	K	L	M
1
2	BUDGET		2016	2017			2018			2019
3				LOW	MEDIUM	HIGH	LOW	MEDIUM	HIGH	LOW	MEDIUM	HIGH
4		Income
5		Restricted		1,450,000£	1,650,000£	1,900,000£	1,420,000£	1,720,000£	2,120,000£	1,290,000£	1,940,000£	2,440,000£
6		Unrestricted		630,000£	1,250,000£	1,250,000£	750,000£	1,780,000£	1,980,000£	780,000£	1,830,000£	2,050,000£
7		Commercial		80,000£	80,000£	80,000£	100,000£	100,000£	100,000£	180,000£	200,000£	200,000£
8		Total	2,400,000£	2,160,000£	2,980,000£	3,230,000£	2,270,000£	3,600,000£	4,200,000£	2,250,000£	3,970,000£	4,690,000£
9		Growth Year of Year		-10%	24%	35%	5%	21%	30%	-1%	10%	12%
10		Expenditure
11		OKI Core Operations		#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
12		OKI Projects		1,320,000£	1,440,000£	1,490,000£	1,250,000£	1,630,000£	1,880,000£	1,030,000£	1,560,000£	2,000,000£
13		Reserve		0£	0£	0£	0£	130,000£	130,000£	0£	200,000£	200,000£
14		Total	2,400,000£	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
15		Growth Year of Year					#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
16
17	FTE		13.00	8.25	16.75	19.00	9.5	19.75	23.75	11.75	25	28.00
18				-37%	29%	46%	15%	18%	25%	24%	27%	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