Kaslo_Heartwood_physical activity_math and science games.xlsx

	A	B	C	D	E	F	G	H	I
1	5 Steps to Your Budget
2	Step 1: Following the examples, fill in the white boxes (cells) with expense details for your project. Enter the costs you want the PAC to pay for in the column marked "PAC Grant Request."
3	Step 2: Grey cells in columns have formulas to help you. Do not delete them. The numbers you enter in the white cells should produce the correct numbers in the corresponding grey cells. If a figure in a grey cell doesn't look correct, click it to see what white cells are feeding the formula (e.g. F9-G9). Correct those white cells.
4	Step 3: Erase the examples in the white cells. When you do, the linked grey cells will empty and related calculations will reduce by the corresponding amounts.
5	Project Expenses	Quantity	Quantity Descriptor	Unit Cost	Unit Descriptor	Subtotal	PAC Grant Request	Remaining Costs	Notes
6	Project Expenses	Quantity	Quantity Descriptor	Unit Cost	Unit Descriptor	Subtotal	PAC Grant Request	Remaining Costs	Notes
7	Gymnastics class for kids	8	per session	$ 80.00	Teacher fee	$ 640.00	$ 640.00	$ -
8	Gym Rental	8	per session	$ 50.00	per session	$ 400.00	$ -	$ 400.00	In Kind
9	Fitness Class for kids	12	per session	$ 60.00	Teacher fee	$ 720.00	$ 720.00	$ -
10	Gym Rental	12	per session	$ 50.00	per session	$ 600.00	$ 600.00	$ -
11	Equipment Rental	12	per session	$ 20.00	per session	$ 240.00		$ 240.00	In Kind
12	Nelson Youth Centre Visit	5	per visit	$ 100.00	Center rental fee	$ 500.00	$ 500.00	$ -
13	Math and Science Games	8	per session	$ 60.00		$ 480.00	$ 480.00	$ -
14	Theatre Rental	8	per session	$ 50.00		$ 400.00	$ 400.00	$ -
15						$ -		$ -
16					Subtotal	$ 3,980.00	$ 3,340.00	$ 640.00
17
18	Step 4: You will see the "Total" (cell F21) figure duplicated in the Notes column (cell I22) as confirmation that you have completed the columns correctly. If your "Total" is not repeated, check your "PAC Grant Request" and "Remaining Cost" columns for errors.				Tax
19					Fees			$ -
20					Other ( e.g. contingency)
21					Total	$ 3,980.00	$ 3,340.00	$ 640.00	$ 3,980.00
22	Project Details		Notes
23	# of Participating Students (if estimating, select a mid range attendance # and write range in notes)	17			Cost per student partcipating		$ 196.47
24	Estimated Program hrs	58	2 hours per session for 20 sessions		Cost per student per program hour		$ 3.39
25					% of Expenses paid by PAC Grant Request		83.9%
26
27	Step 5: Confirm the "Total PAC Funding Request" below is correct, if not check your figures above.
28	TOTAL PAC FUNDING REQUEST		$ 3,340.00
29	TOTAL PAC FUNDING REQUEST		$ 3,340.00
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