Unit Program Planner_Example.xlsx

	A	B	C	D	E	F
1	Please download this sheet to be able to customize it for your unit
2	Unit Program Planner
3
4	1. Enter all your activities and costs under each month.			Pack/Troop		100
5	2. Enter your number of Scouts and unit commission %.			Number of Scouts in Unit		20
6	3. Fill in the five shaded fields at the bottom of the sheet.			Unit Commission %		32%
7
8	September		October		November
9	Activities	Cost	Activities	Cost	Activities	Cost
10	Popcorn Sale Kick Off	$100	Magician	$75	Pack Meeting Supplies	$100
11
12
13
14
15
16	Total Cost	$100	Total Cost	$75	Total Cost	$100
17
18	December		January		February
19	Activities	Cost	Activities	Cost	Activities	Cost
20	Holiday Party	$200	Winter Fun Day	$50	Blue & Gold Dinner	$500
21
22
23
24
25
26	Total Cost	$200	Total Cost	$50	Total Cost	$500
27
28	March		April		May
29	Activities	Cost	Activities	Cost	Activities	Cost
30	Pinewood Derby	$500	Activity	$50	Spring Family Picnic	$300
31
32
33
34
35
36	Total Cost	$500	Total Cost	$50	Total Cost	$300
37
38	June		July		August
39	Activities	Cost	Activities	Cost	Activities	Cost
40	Day Camp Fees	$1,000	Activity	$75	Fall Kick Off	$150
41
42
43
44
45
46	Total Cost	$1,000	Total Cost	$75	Total Cost	$150
47
48	$80	Annual National Membership Fee
49	$12	Council Insurance Fee		Total Activity Cost & Expenses		$5,980
50	$15	Scout's Life		Other Unit Expenses		$0
51	$12	Advancements		Unit Sales Goal		$18,688
52	$25	Joining Fee (new members only)		Scout Sales Goal		$934
53	$2,880	Total Expenses		Unit Commission		$5,980
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