Scouts BSA Troop Budget - Example.xlsx

	A	B	C	D	E	G
1	Annual Operating Budget					Instructions
2	Scouts BSA Troop #			1		1. Fill in all of the yellow areas with your unit specific information.
3						2. Add rows and copy the formulas down to newly added rows.
4	Program Expenses	About	Annual Cost per Scout/Unit	Number of Scouts / Adults	Total	3. Send finalized budgets to committee members, unit commissioners, and district professional staff.
5	Youth Registration Fees	# of Youth	$72	20	$1,440
6	Adult Registration Fees	# of Adults	$45	10	$450	Unit Detail
7	Charter Fee	Yearly Fee	$75	1	$75	Leader
8	Boys' Life Subscription	# of Youth	$12	20	$240	Assistant Leader:
9	Advancement	Average Cost per Year	$15	20	$300	Committee Chair:
10	Recognition	Thank you's / Veteran Awards	$15	20	$300	Treasurer:
11	Handbooks	1 for each new youth	$18	20	$360	Popcorn Chair:
12						Camp Card Chair:
13	Camping Trips / Activities	Location	Cost per Participant	# of Participants	Total
14	Camping Trip A	Troop Hike	$10.00	10	$100.00
15	Camping Trip B	Boat Trip	$10.00	10	$100.00
16	Camping Trip C	State Park	$10.00	15	$150.00
17	Camping Trip D	Local Park	$10.00	15	$150.00
18	Camping Trip E (Add more rows as needed)		$0.00	0	$0.00
19
20	District Events	Location	Cost per Participant	# of Participants	Total
21	Klondike	Camp	$12.00	15	$180.00
22	Spring Camporee	Camp	$18.00	10	$180.00
23
24	Summer Camp / Day Camp	Location	Summer Camp Fees	# of Participants	Total
25	Youth		$300.00	10	$3,000.00
26	Adults		$175.00	5	$875.00
27
28	Miscellaneous Expenses	About	Total Estimated Costs		Total
29	Program Materials	Ceremony supplies, den projects, camping items, etc.	$200.00	1	$200.00
30	Troop Equipment	Upgrades or replacement to troop equipment	$250.00	1	$250.00
31	Leader Training	IOLS Training for SMs / ASMs	$50.00	1	$50.00
32	Reserve Fund		$100.00	1	$100.00
33	Other Expenses		$100.00	1	$100.00
34	Total Budgeted Program Expenses				$8,600.00
35
36	Income		Per Scout Fees	Number of Scouts	Total
37	Annual Dues	(If your unit charges them)	$15.00	20	$300.00
38	Surplus from Prior Year	(Beginning fund balance)	$1,500.00	1	$1,500.00
39	Other Income	(Parent payments e.g. summer camp, etc.)	$0.00	0	$0.00
40	Income Subtotal				$1,800.00
41
42	Fundraising Needed				-$6,800.00
43
44
45	Fundraising Plan
46	How much of your fundraising do you want to come from the popcorn sale? (Percentage)			100%
47	How much of your fundraising do you want to come from the camp card sale? (Percentage)			0%
48	Popcorn
49	Need	-$6,800.00	Sales Goal	-$20,606.06	100%
50	Commission Rate	33%	# of Scouts	20
51	Troop Goal	-$20,606.06	Scout Goal	-$1,030.30
52
53	Camp Card Sale
54	Need	$0.00	Sales Goal	$0.00	0%
55	Commission Rate	50%	# of Scouts	1
56	Troop Goal	$0.00	Scout Goal	$0.00
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