2026APSAfterschool Dashboard.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	2026 APS Afterschool Dashboard
2
3	Category	August	September	October	November	December	January	February	March	April	May	June	July	Total
4	Beginning Balance	$ 9,000.00
5
6	CLUB REVENUE
7	Afterschool Cares	$ 1,575.00	$ 2,280.00	$ 4,210.00	$ 4,025.00	$ 2,895.00	$ 4,240.00	$ 3,215.00	$ 4,080.00	$ 3,315.00	$ 2,525.00			$ 32,360.00
8	Afterschool Art	$ 520.00	$ 1,350.00	$ 1,350.00	$ 1,180.00	$ 950.00	$ 1,235.00	$ 820.00	$ 575.00	$ 545.00	$ 305.00			$ 8,830.00
9
10
11	Total Revenue	$ 2,095.00	$ 3,630.00	$ 5,560.00	$ 5,205.00	$ 3,845.00	$ 5,475.00	$ 4,035.00	$ 4,655.00	$ 3,860.00	$ 2,830.00	$ -	$ -	$ 41,190.00
12
13	SALARIES
14	Afterschool Cares	$ -	$ 1,280.00	$ 1,240.00	$ 1,560.00	$ 1,160.00	$ 920.00	$ 1,320.00	$ 1,120.00	$ 1,280.00	$ 1,560.00			$ 11,440.00
15	Afterschool Art	$ -	$ 1,200.00	$ 1,240.00	$ 1,320.00	$ 1,080.00	$ 800.00	$ 880.00	$ 760.00	$ 1,240.00	$ 640.00			$ 9,160.00
16
17	Total Salaries	$ -	$ 2,480.00	$ 2,480.00	$ 2,880.00	$ 2,240.00	$ 1,720.00	$ 2,200.00	$ 1,880.00	$ 2,520.00	$ 2,200.00		$ -	$ 20,600.00
18
19	FIXED COSTS
20	Retirement (3%)	$ -	$ 74.40	$ 74.40	$ 86.40	$ 67.20	$ 51.60	$ 66.00	$ 35.40	$ 75.60	$ 66.00			$ 597.00
21	FICA (7.65 %)	$ -	$ 189.72	$ 189.72	$ 220.32	$ 171.36	$ 131.58	$ 168.30	$ 143.82	$ 192.78	$ 168.30			$ 1,575.90
22	Medicare (1.45%)	$ -	$ 35.96	$ 35.96	$ 41.76	$ 32.48	$ 24.94	$ 31.90	$ 27.26	$ 36.54	$ 31.90			$ 298.70
23	Total Fixed Costs	$ -	$ 300.08	$ 300.08	$ 348.48	$ 271.04	$ 208.12	$ 266.20	$ 206.48	$ 304.92	$ 266.20		$ -	$ 2,471.60
24
25	SUPPLIES
26	General Supplies (Snacks, etc.)	$ 114.78	$ 146.61	$ -	$ 184.23	$ 95.38	$ 212.14	$ -	$ 182.79	$ 307.16	$ 310.88			$ 1,553.97
27	Total Supplies	$ 114.78	$ 146.61	$ -	$ 184.23	$ 95.38	$ 212.14	$ -	$ 182.79	$ 307.16	$ 310.88			$ 1,553.97
28
29	Total Expenses	$ 114.78	$ 2,926.69	$ 2,780.08	$ 3,412.71	$ 2,606.42	$ 2,140.26	$ 2,466.20	$ 2,269.27	$ 3,132.08	$ 2,777.08		$ -	$ 24,625.57
30
31	Net	$ 1,980.22	$ 703.31	$ 2,779.92	$ 1,792.29	$ 1,238.58	$ 3,334.74	$ 1,568.80	$ 2,385.73	$ 727.92	$ 52.92		$ -	$ 16,564.43
32	Net %	0.9452124105	0.1937493113	0.4999856115	0.3443400576	0.3221274382	0.6090849315	0.3887980173	0.51250913	0.1885803109	0.01869964664		0	0.4021468803
33
34	Ending Balance	$ 10,980.22	$ 11,683.53	$ 14,463.45	$ 16,255.74	$ 17,494.32	$ 20,829.06	$ 22,397.86	$ 24,783.59	$ 25,511.51	$ 25,564.43	$ 25,564.43	$ 25,564.43	$ 25,564.43
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