ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This is intended to help event stewards plan. The Exchequer's office should update the attendance and cost information yearly, using the approved budget data numbers.
2
Change data in green cells ONLY on the Budget Sheet!
3
4
1. in cells B2 and C2 of the Budget Sheet, select the event and year. For example, "October Crown, 2019".
5
This will then populate the budgeted adult attendance (usually using 90% of the 3-year average) as well as the maximum for that event in the previous three years.
6
This also gives you the average and maximum cost, not adjusted by 90%, of the site and privy/dumpsters for the last three years.
7
8
2. Enter any other event income and expenses in the green cells in column B. Expenses should be entered as negative numbers.
9
10
3. Enter any changes to the budgeted numbers in column D.
11
Example: budgeted attendance is 219, you want to see what happens if you assume 250 adults and a $1500 site charge.
12
13
4. Event profit/loss is calculated in cell B32 and D32.
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
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