Membership cost forecasting

	A	B	C	D	E	F	G	H
1	Pot 1: Provisional fixed costs (without insurance!!)			9604.8
2	Pot 2: Everything else
3
4	POT 1 membership costs
5
6	Scenario 1			Scenario 2				thoughts
7	100 adult memberships			100 adult memberships				children are all under 18s or just up to 16 / some other age?
8	all same price			10% self-certified low-income tickets at half price				i.e. nest has a reduced price membership for 15 - 18 year olds
9	entirely on fixed costs			entirely on fixed costs				presume children free but not discussed this
10	10 - 15 children no cost but booked for numbers			10 - 15 children no cost but booked for numbers				children / sleeping spaces? different conversation but worth noting
11	Cost pp.	96.05		Cost pp. full	101.10
12				Cost pp. low-income	50.55
13				total	9604.8
14
15	Scenario 3			Scenario 4
16	100 adult memberships			100 adult memberships
17	15% self-certified low-income memberships at half price			10% self-certified low-income memberships at half price
18	entirely on fixed costs			5% self-certified low-income at 1/4 price
19	10 - 15 children no cost but booked for numbers			entirely on fixed costs
20	Cost pp. full	103.84		10 - 15 children no cost but booked for numbers	n	%£	individual ticket cost
21	Cost pp. low-income	51.92		Cost pp. full	85	100	105.26
22	total	9604.8		Cost pp. low-income	10	50	52.63
23				Cost pp. low-income 1/4	5	25	26.31
24							9604.8
25
26
27	Pot 2 size predictions with different low-income numbers, assuming no pot 2 contribution from low cost memberships
28		average contribution (£)
29		25	50	75	100
30		pot 2 size (£)
31	100 people	2500	5000	7500	10000
32	90 people	2250	4500	6750	9000
33	85 people	2125	4250	6375	8500
34
35	Total costs for memberships (full cost memberships - pot 1 + self-selected pot 2 contribution) under different pot 1 scenarios, presuming no pot 2 from low-income
36	full cost memberships
37	£ contribution to pot 2:	25	50	75	100
38
39	Scenario 1	121.05	146.05	171.05	196.05
40	Scenario 2	126.10	151.10	176.10	201.10
41	Scenario 3	128.84	153.84	178.84	203.84
42	Scenario 4	130.26	155.26	180.26	205.26
43
44	Low cost membership costs:	£
45	Scenario 1	NA
46	Scenario 2	50.55
47	Scenario 3	51.92
48	Scenario 4 - standard low cost	52.63
49	Scenario 4 - very low cost	26.31
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