Event Budget Calculator 2024.xlsx

	A	B	C	D	E	F	G	H
1		RACO CC 2024 BUDGET ESTIMATES
2		Event Name		Variable field
3		73
4		Item:	Unit Cost:	Competitors:	Cost:	Notes:	Budget:	Comments:
5				40
6
7	1	Printing - Maps	R 19.00		R 760.00	Waterproof paper	R 760.00
8	2	Printing - other	R 100.00		R 100.00		R 100.00
9	3	SAOF Levies	R 30.00	40	R 1,200.00	Est. On 40 competitors	R 1,200.00
10	4	Emit Hire Levies	R 25.00	40	R 1,000.00	Est. On 40 competitors	R 1,000.00	Recoverable
11	5	Medical Services	R 0.00		R 0.00		R 0.00
12	6	Venue Levy (per competitor)			R 0.00	Conservancy Fee	R 0.00
13	7	OriEnter Admin Fees (estimate)			R 428.00	5% per entry	R 428.00
14	8	Unforeseen expenses	R 100.00		R 100.00		R 100.00
15	9	Mapping						New map only
16	10	Planner	R 1,100.00		R 1,100.00		R 1,100.00
17	11	Controller	R 900.00		R 900.00		R 900.00
18	12	Prizes	R 500.00		R 500.00		R 500.00
19		EXPENSES:		TOTAL:	R 5,088.00		R 5,088.00
20
21		ENTRY FEE INCOME :	Entry:
22	1	Seniors (50%) - Member	R 160.00	20	R 3,200.00	Suggested entry fee
23	2	Juniors (20%) - Non-Member	R 120.00	8	R 960.00	Suggested entry fee
24	3	Seniors (20%) - Non-Member	R 180.00	8	R 1,440.00	Suggested entry fee
25	4	Juniors (10%) - Non-Member	R 140.00	4	R 560.00	Suggested entry fee
26	5	Emit Hire (std estimate)	R 25.00	40	R 1,000.00			Recoverable
27	6	Groups (Max 2) - Member	R 200.00	4	R 800.00	Suggested entry fee
28	7	Groups (Max 2) - Non Member	R 220.00	6	R 1,320.00	Suggested entry fee
29	8	Group Extra (More than 2)	R 70.00	4	R 280.00	Suggested entry fee
30		INCOME:		TOTAL:	R 8,560.00		R 8,560.00
31
32		PROFIT/LOSS (-):			R 3,472.00		R 3,472.00
33		NOTES:
34	1.	Member vs non-member ratio is rough estimate, from historical data
35	2.
36	3.
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