| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Unrestricted Funds - Budget/Forecast 2018 | BUDGET | BUDGET | BUDGET | BUDGET | BUDGET | BUDGET | BUDGET | BUDGET | BUDGET | BUDGET | BUDGET | BUDGET | |||
2 | This spreadsheet was prepared at the end of 2017, and is the fixed budget for 2018. | TOTALS | Jan 2018 | Feb 2018 | Mar 2018 | Apr 2018 | May 2018 | Jun 2018 | Jul 2018 | Aug 2018 | Sep 2018 | Oct 2018 | Nov 2018 | Dec 2018 | ||
3 | Income | LINK DATA | PLANNED BUDGET TOTALS | \ | ||||||||||||
4 | Equity on Balance Sheet (Opening Position) | INCSUB | £0 | |||||||||||||
5 | Donations received + Other Misc inc | INC-D | £1,860 | £155 | £155 | £155 | £155 | £155 | £155 | £155 | £155 | £155 | £155 | £155 | £155 | |
6 | Overheads from grants(VAT dertermined) | INC-G | £12,000 | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
7 | Overheads from Commercial (VAT) | INC-C | £33,624 | £12,255 | £11,453 | £4,530 | £4,530 | £107 | £107 | £107 | £107 | £107 | £107 | £107 | £107 | |
8 | Other Income | INCSUB | £47,484 | £12,410 | £11,608 | £4,685 | £4,685 | £262 | £262 | £2,262 | £2,262 | £2,262 | £2,262 | £2,262 | 2000 | |
9 | Services Forecasted Income | £160,000 | 0 | 0 | 0 | 0 | 20000 | 10000 | 40000 | 5000 | 20000 | 50000 | 10000 | 5000 | ||
10 | Commission Surplus's | £53,000 | 0 | 0 | 0 | 0 | 0 | 5000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | ||
11 | Commercial surplus' | INCSUB | £213,000 | 0 | 0 | 0 | 0 | 20000 | 15000 | 48000 | 13000 | 28000 | 58000 | 18000 | 13000 | |
12 | Sigrid Rausing Trust Grant | £96,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | ||
13 | Omidyar Core Dev Grant 2017-2018 ($750K per yr) | £590,000 | £49,000 | £49,000 | £51,000 | £49,000 | £49,000 | £49,000 | £49,000 | £49,000 | £49,000 | £49,000 | £49,000 | £49,000 | ||
14 | Hewlett GOS | £296,000 | £24,000 | £24,000 | £24,000 | £24,000 | £32,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | ||
15 | Unrestricted Grant funds | INCSUB | £982,000 | £81,000 | £81,000 | £83,000 | £81,000 | £89,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | |
16 | ||||||||||||||||
17 | Total Income | £1,242,484 | £93,410 | £92,608 | £87,685 | £85,685 | £109,262 | £96,262 | £131,262 | £96,262 | £111,262 | £141,262 | £101,262 | £96,000 | ||
18 | Expenditure | LINK DATA | ||||||||||||||
19 | Fixed Administrative costs WP02 | |||||||||||||||
20 | Professional Services (Legal, Accountancy, Fees etc) | FA01 | £30,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
21 | Staff Benefits | |||||||||||||||
22 | IT Services (external costs) | FA02 | £84,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
23 | Operating costs (Org wide summits) | FA03 | £60,000 | £0 | £0 | £20,000 | £0 | £0 | £0 | £20,000 | £0 | £0 | £0 | £20,000 | £0 | |
24 | F2F Planning meetings of Fixed staff (LT) (OPS) | FA04 | £24,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
25 | Office Space - Israel | FA11 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
26 | Travel (Fundraising) | FA07 | £4,980 | £415 | £415 | £415 | £415 | £415 | £415 | £415 | £415 | £415 | £415 | £415 | £415 | |
27 | Recruitment (Advertising & Agency Fees) | FA08 | £1,500 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
28 | Payroll Fees (UK & International) | FA09 | £26,120 | £1,030 | £2,750 | £2,750 | £1,030 | £2,750 | £2,750 | £1,030 | £2,750 | £2,750 | £1,030 | £2,750 | £2,750 | |
29 | Sundry | FA10 | £6,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
30 | Fixed Operating costs | EXSUB | £236,600 | £13,570 | £15,290 | £35,290 | £13,570 | £15,290 | £15,290 | £33,570 | £15,290 | £15,290 | £13,570 | £35,290 | £15,290 | |
31 | Fixed staff costs WP01 | |||||||||||||||
32 | Staff Costs - Leadership Team | FS01 | £162,600 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | |
33 | Staff Costs - Operations | FS02 | £253,079 | £21,704 | £20,425 | £20,425 | £20,425 | £20,425 | £20,425 | £23,775 | £20,425 | £20,425 | £20,425 | £20,425 | £23,775 | |
34 | Staff Costs - Biz Dev / Funding | FS03 | £83,500 | £0 | £3,500 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
35 | Staff Costs - Biz Dev Commision | £16,000 | £0 | £0 | £0 | £0 | £2,000 | £1,000 | £4,000 | £500 | £2,000 | £5,000 | £1,000 | £500 | ||
36 | Capacity Team | FS06 | £216,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
37 | Staff Costs - Meetings & Summit attendance by whole team | FS04 | £33,000 | £0 | £0 | £11,000 | £0 | £0 | £0 | £11,000 | £0 | £0 | £0 | £11,000 | £0 | |
38 | Staff Training & development | FS05 | £6,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
39 | Increase Pensions regulatory employer contr) | FS08 | £4,635 | £0 | £0 | £0 | £515 | £515 | £515 | £515 | £515 | £515 | £515 | £515 | £515 | |
40 | Increase Salaries (Role based rises & Cost of living increases) | FS09 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
41 | Stephen - Paternity | £4,154 | £0 | £1,350 | £100 | £100 | £2,604 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
42 | Research for Leadership by Danny & Jonathan | FS10 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
43 | Product Group (Team Lead and Engineering Lead) | FS11 | £9,900 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | |
44 | Fixed staff costs | EXSUB | £788,868 | £54,579 | £58,150 | £72,400 | £61,915 | £66,419 | £62,815 | £80,165 | £62,315 | £63,815 | £66,815 | £73,815 | £65,665 | |
45 | Grant Projects (CLOSED)with unbudgeted cost overruns/surpluses | |||||||||||||||
46 | Allowance forecasting only. figures not confirmed | LT01 | £36,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
47 | Restricted Grant Projects losses | EXSUB | £36,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
48 | Final Adjustments (BOARD)? | |||||||||||||||
49 | Foreign Currency Gains & Losses | LT08 | £54,000 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | |
50 | Less money set aside for Reserve building From Current Board Requirement | LT09 | £0 | |||||||||||||
51 | Less money set aside for Reserve building during 2017 | LT10 | £50,000 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | |
52 | Board Adjustments | EXSUB | £104,000 | £8,667 | £8,667 | £8,667 | £8,667 | £8,667 | £8,667 | £8,667 | £8,667 | £8,667 | £8,667 | £8,667 | £8,667 | |
53 | Unrestricted Project allocations | |||||||||||||||
54 | Events | |||||||||||||||
70 | TOTAL Internal Team Budgets | EXSUB | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
71 | TOTAL EXPENDITURE | £1,165,468 | £79,816 | £85,107 | £119,357 | £87,152 | £93,376 | £89,772 | £125,402 | £89,272 | £90,772 | £92,052 | £120,772 | £92,622 | ||
72 | REMAINING SURPLUS | 77,016 | 13,594 | 7,501 | -31,672 | -1,467 | 15,886 | 6,490 | 5,860 | 6,990 | 20,490 | 49,210 | -19,510 | 3,378 | ||
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 | ||||||||||||||||
101 | ||||||||||||||||
102 | ||||||||||||||||
103 | ||||||||||||||||
104 | ||||||||||||||||
105 | ||||||||||||||||
106 | ||||||||||||||||
107 | ||||||||||||||||
108 | ||||||||||||||||
109 | ||||||||||||||||
110 | ||||||||||||||||
111 | ||||||||||||||||
112 | ||||||||||||||||
113 | ||||||||||||||||
114 | ||||||||||||||||
115 |