Troop Budget Planning Sheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
Yearly Budget Planning Sheet
6
Instructions:Troop:GA-0110
7
1) Plug in the number of Trailmen (youth & adult) participating this yearYear:2018-2019
8
2) For each month below, plug in the anticipated activity and cost per person.Youth:25
9
3) At the bottom, plug in additional costs that may not apply to each person. Adults:12
10
4) The cells highlighted in GREEN are the only ones you should need to plug information in!Total:37
11
12
JulyAugustSeptember
13
ActivitiesCostActivitiesCostActivitiesCost
14
Troop Swimming Party - Food$3.00Troop Field Day$3.00Campout Costs$8.00
15
Breakfast - See You at the Pole$3.00
16
17
18
19
20
Total Cost$3.00Total Cost$3.00Total Cost$11.00
21
22
OctoberNovemberDecember
23
ActivitiesCostActivitiesCostActivitiesCost
24
Campout Costs$12.00Service Project Lunch$4.00Court of Honor - Awards$10.00
25
Court of Honor - Food$6.00
26
27
28
29
30
Total Cost$12.00Total Cost$4.00Total Cost$16.00
31
32
JanuaryFebruaryMarch
33
ActivitiesCostActivitiesCostActivitiesCost
34
Troop Lock In - Food$5.00Cathedral Caverns Trip$10.00Camp Sunrise Encampment$60.00
35
Troop Lock In - Materials$3.00$12.00
36
37
38
39
40
Total Cost$8.00Total Cost$10.00Total Cost$72.00
41
42
AprilMayJune
43
ActivitiesCostActivitiesCostActivitiesCost
44
Spring Service Project - Lunch$4.00Court of Honor - Awards$10.00Eco-Center Trip$4.00
45
Campout Costs$12.00Court of Honor - Food$6.00
46
47
48
49
50
Total Cost$16.00Total Cost$16.00Total Cost$4.00
51
52
Single Trailman Annual Activity Cost$175
53
54
Non-Activity Expenses:
55
Cost:NumberTotalNotes
56
Membership Fees$26.0037$962.00Annual Membership Fee (National)
57
Yearly Troop Dues (per Youth)$12.0044$528.00Annual Dues (Local, where applicable)
58
Adult Uniform$45.005$225.00Cost of Troop determined Uniform, where applicable
59
Youth Uniform$10.0044$440.00Cost of Troop determined Uniform, where applicable
60
Recharter Fee$195.001$195.00Annual Recharter Fee (National)
61
Program Support Fee$20.0025$500.00Cost determined by Active Youth
62
Handbooks for new Trailmen$17.5010$175.00
63
Summer Adventure$200.006$1,200.00
64
Christmas Parade Entry Fee$50.001$50.00
65
Total Other Expenses:$4,275.00
66
67
Total Activity Expenses (Youth Only$4,375(This ONLY accounts for Youth expenses. Update the formula from cell F8 to cell F10 if your Troop pays for Adults as well!)
68
Total Non-Activity Expenses$4,275
69
Total Expenses:$8,650
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
Loading...
Main menu