ABCDEFGHIJKLMNOPQRSTU
1
Calculate at begin of FebCalc at end of Feb, get dues mid FebCalculate at end of Feb / begin of Mar
2
February 2013 (Budgeted)February 2013 ActualMarch 2013 (Budgeted)April 2013May 2013June 2013July 2013
3
Monthly Overheadminmax
4
Rent$1,000$1,680$1,500$1,500$1,500$1,500$1,500$1,500$1,500
5
Utilities-$200$420$160$160$165$170$175$180$185
6
Services$0$100$50$50$50$50$50$50$50
7
Total Fixed Cost$800$2,200$1,710$1,710$1,715$1,720$1,725$1,730$1,735
8
Contribution to standing funds
9
10
Target Standing Rent / Utility Fund Balance$5,130$5,130$5,145$5,160$5,175$5,190$5,205
11
Existing Standing Rent / Utility Fund Balance$4,800$4,965$5,048$5,145$5,215$5,215$5,215
12
%full93.57%96.78%98.10%99.71%100.77%100.48%100.19%
13
Contribution to Standing Rent / Utility Fund($)$70$1,000$165$83$98$70$0$0$0
14
15
16
Target Rainy Day Fund$3,000$3,000$3,000$3,000$3,000$3,000$3,000
17
Existing Rainy Day Fund$300$800$1,300$2,300$3,000$3,070$3,070
18
%full10.00%26.67%43.33%76.67%100.00%102.33%102.33%
19
Contribution to Raindy Day Fund ($)$70$1,000$500$500$1,000$700$70$0$0
20
21
22
Target Maintenance Fund$2,000$2,000$2,000$2,000$2,000$2,000$2,000
23
Existing Maintenance Fund$0$500$1,000$1,000$1,500$750$1,250
24
%full0.00%25.00%50.00%50.00%75.00%37.50%62.50%
25
Contribution to Maintenance Fund ($)$70$1,000$500$500$500$500$250$500$375
26
Expenditures from Maintenance Fund($)$500.00$1,000.00
27
28
29
Target Operations Fund$500$550$600$650$700$750$800
30
Existing Operations Fund$0$250$250$425$538$538$644
31
%full0.00%45.45%41.67%65.38%76.79%71.67%80.47%
32
Contribution to Operations fund ($)$7010002500175112.50106.2578.125
33
34
TOTAL FUND CONTRIBUTION$1,415$1,083$1,773$1,383$320$606$453
35
TOTAL ALLOCATED$3,125$2,793$3,488$3,103$2,045$2,336$2,188
36
37
Total Costs of Running Sudoroom (incl. contributions to standing funds)$3,125.00$2,792.50$3,487.50$3,102.50$2,045.00$2,336.25$2,188.13
38
Add in: risk-premium extra (%)5.00%5.00%5.00%5.00%5.00%5.00%5.00%
39
Add in: risk-premium extra ($)$156.25$139.63$174.38$155.13$102.25$116.81$109.41
40
Less: Alternative Funding Sources (%)20.00%17.91%14.34%16.12%24.45%21.40%22.85%
41
Less: Alternative Funding Sources ($)$450.00$500.00$500.00$500.00$500.00$500.00$500.00
42
Cost borne by membership dues (%)90.60%87.09%90.66%88.88%80.55%83.60%82.15%
43
Cost borne by membership dues ($)$2,831.25$2,432.125$3,161.875$2,757.625$1,647.25$1,953.0625$1,797.53125
44
Membership42434550607080
45
Total per Member (%)2.16%2.03%2.01%1.78%1.34%1.19%1.03%
46
Total per Member ($)$74.40$64.94$77.50$62.05$34.08$33.38$27.35
47
48
Dues at $60/person2520258027003000360042004800
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