Event Budget

	B	C	E	F	G	H	I	J	M
1	Event Budget - Scout Camp								by Vertex42.com
2	Budget Summary		Summary of Expenses and Income						Start by entering expenses and income.
3		Total Expenses			Expenses
4		$3,675.00		Location	$650				← You can edit the labels for expense categories in cells F4:F7
5		Total Actual Income		Event	$500
6		$3,660.00		Food & Drink	$1,350				Note: All numbers in this example are completely made up. Do not use them as a guide for what to do or not to do.
7		Balance		Supplies	$500
8		($15.00)		Other	$675
10				Total	$3,675
11	https://www.vertex42.com/ExcelTemplates/event-budget-template.html						© 2015 Vertex42 LLC
17
18		Expenses
19		description		category		quantity	unit cost	amount
20		Site Rental (3 nights)		Location			650.00	650.00	← Enter expenses using the Quantity and Unit Cost columns
21		Staff		Event		5	100.00	500.00
22		Meals		Food & Drink		45	30.00	1,350.00	← Quantity is assumed to be 1 if left blank
23		Canopy Tents		Supplies		2	250.00	500.00
24		T-Shirts		Other		45	15.00	675.00
25								-
26								-
27								-
28								-
29								-
30								-	← Insert new rows ABOVE this line
31			[42]				Total Expenses	$ 3,675.00
32
33		Income / Funding
34		description		unit cost	estimate qty	estimate amt	actual qty	actual amount
35		Existing Budget		300.00		300.00		300.00
36		Troop 145		80.00	10	800.00	9	720.00
37		Troop 220		80.00	16	1,280.00	14	1,120.00
38		Troop 165		80.00	7	560.00	8	640.00
39		Troop 505		80.00	12	960.00	11	880.00
40					Total	$ 3,900.00	Total	$ 3,660.00
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
101
102
103
104
105
106