Budget - hub concept - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Amounts in AUD			Conference committee			Hub 1			Hub 2			Hub 3			Hub 4			Hub 5
2			Attendees	-			20			30			40			50			75
3	E/R	Category	Item	Unit cost	#	Amount	Unit cost	#	Amount	Unit cost	#	Amount	Unit cost	#	Amount	Unit cost	#	Amount	Unit cost	#	Amount	TOTAL

4	Expense	On site	Venue hire	-	-	0	-	-	500	-	-	200	-	-	0	-	-	500	-	-	1000	2200
5	Expense	On site	A/V	-	-	0	-	-	100	-	-	50	-	-	0	-	-	100	-	-	0	250
6	Expense	On site	Catering	-	-	0	30	20	600	20	30	600	40	40	1600	20	50	1000	20	75	1500	5300
7	Expense	On site	Post-conf social event	-	-	0	10	10	100	15	15	225	0	20	0	20	25	500	10	38	380	1205
8	Expense	On site	Office supplies	-	-	0	-	-	30	-	-	30	-	-	30	-	-	30	-	-	30	150
9	Expense	On site	Signage	-	-	0	-	-	20	-	-	20	-	-	20	-	-	20	-	-	20	100
10	Expense	Swag etc	T shirts	25	122	3050	-	-	0	-	-	0	-	-	0	-	-	0	-	-	0	3050
11	Expense	Swag etc	Other swag	-	-	1000	-	-	0	-	-	0	-	-	0	-	-	0	-	-	0	1000
12	Expense	Swag etc	Volunteer appreciation	20	50	1000	-	-	0	-	-	0	-	-	0	-	-	0	-	-	0	1000
13	Expense	Swag etc	Speaker gifts	20	50	1000	-	-	0	-	-	0	-	-	0	-	-	0	-	-	0	1000
14	Expense	Swag etc	Program design	-	-	300	-	-	0	-	-	0	-	-	0	-	-	0	-	-	0	300
15	Expense	Misc	Shipping	-	-	1500	-	-	0	-	-	0	-	-	0	-	-	0	-	-	0	1500
16	Expense	Misc	??any online services??	-	-	200	-	-	0	-	-	0	-	-	0	-	-	0	-	-	0	200
17	Expense	Registration costs	Stripe/Tito/etc	-	-	137	-	-	0	-	-	0	-	-	0	-	-	0	-	-	0	137
18			Total expenses			8187			1350			1125			1650			2150			2930	17392
19
20	Revenue	Registration	Full price	-	-	0	50	10	500	40	20	800	30	20	600	0	0	0	20	25	500	2400
21	Revenue	Registration	Discounted	-	-	0	20	5	100	10	5	50	10	10	100	0	0	0	5	25	125	375
22	Revenue	Registration	Complementary	0	100	0	0	5	0	0	5	0	0	10	0	0	50	0	0	25	0	0
23	Revenue	Registration	T shirts	25	72	1800	-	-	0	-	-	0	-	-	0	-	-	0	-	-	0	1800
24	Revenue	Sponsorship	Sponsorship	-	-	10000	-	-	1000	-	-	500	-	-	100	-	-	0	-	-	0	11600
25			Total income			11800			1600			1350			800			0			625	16175
26
27
28
29