July 2022 Budget Vs. Actuals.xlsx

	A	B	C	D	E	F	G	H
1	Budget vs. Actuals - July 2022 - Revised 09/13/2022
2	Percent of Year Complete: 8%	2022-2023 Combined Budget	THIS YEAR combined Actuals through 07/31/2022	Percent through 07/31/2022	LAST YEAR combined Actuals through 07/31/2021	Notes	NHEP Actuals	CGHS Actuals

3	Development Revenue:
4	Individual Gifts/Annual Appeal	500,000	10,596	2%	20,330		10,596
5	Event Income
6	Feast from the Fields	75,000	5,000	7%	2,000		5,000
7	Rock to Rock	40,000	0
8	Small/Other Event Income	-	0
9
10	Total Business/Coprorate Contributions	13,900	2,002	14%	1,040		2,002
11
12	Private Foundations per Development Budget	312,620	20,000	6%			20,000
13
14	Competitive Government per Development Budget	298,446	0	0%
15	Total Development Revenue	1,239,966	37,598	3%	23,370		37,598
16
17	Non-Competitive Government Grants/Funding
18	Child Nutrition Grants	5,000	0	0%
19	Title 1	129,810	0	0%
20	Title 2 PD	14,859	0	0%
21	Title 3	1,425	0	0%
22	Title 4	10,000	0	0%
23	Breakfast	12,000	0	0%
24	Lunch	97,000	0	0%
25	USAC	15,871	0	0%
26	State Per Pupil Reimbursement (230 x $12,157)	2,796,110	699,143	25%				699,143
27	ARP ESSER	270,766	16,427	6%				16,427
28	ARP ASP	253,698	0	0%
29	City of New Haven/USDA Compost Grant	25,000	0	0%
30	Total Non-Competive Government Grants/Funding	3,631,539	715,570	20%	654,131		0	715,570
31
32	Fee Income
33	Program Fees	1,305,040	471,139	36%	213,715		471,139
34	Produce Sales	37,100	7,067	19%			7,067
35	Cornell Scott Hill Health Center/Mary Wade	2,780	0	0%
36	Seedling Sale	18,000	0	0%	13,350
37	Sub-contracts	-	1,300				1,300
38	Facility Use	-	0
39	Total Fee Income	1,362,920	479,506	35%	227,065		479,506
40
41	Other Income							-
42	CGHS/NHEP	495,896	0	0%
43	Interest	200	10	5%	15		6	4
44	Special Ed Fees from Other Districts	360,000	0	0%
45	Student Activities (swag & activities)	750	0	0%
46	Misc Revenue	750	0	0%	307
47	Product Sales	4,700	0	0%
48	Chromebook/Equipment Fees	7,000	25	0%	1,215			25
49	Total Other Income	869,296	35	0%	1,537		6	29
50
51	Total Revenue	7,103,721	1,232,709	17%	906,103		517,110	715,599
52
53	RNA Per Development Budgetet	413,500	429,298	104%			46,170	383,128
54
55	TOTAL AVAILABLE FUNDS	7,517,221	1,662,007	22%	906,103		563,280	1,098,727
56
57	EXPENSES
58	Personnel Expenses
59	Salaries	4,177,590	146,120	3%	140,825		83,075	63,045
60	Wages	672,613	133,701	20%	110,593		119,003	14,698
61	Total Salaries and Wages	4,850,203	279,821	6%	251,418		202,078	77,743
62
63	Benefits and Taxes
64	Health Insurance	769,300	20,520	3%	29,608		3,582	16,938
65	Life Insurance	3,264	227	7%	220		57	170
66	Dental Insurance	48,255	2,806	6%	2,867		620	2,186
67	Disability	13,079	800	6%	1,536		236	564
68	Medicare	64,266	6,306	10%	6,236		2,864	3,442
69	Social Security	152,955	18,233	12%	15,413		12,246	5,987
70	Total Benefits and Taxes	1,051,119	48,892	5%	55,880		19,605	29,287
71
72	Other Payroll Expense
98	Benefits Pool Fee	20,814	0	0%
99	Payroll Administration	54,000	2,558	5%	8,785		1,721	837
100	Unemployment	15,000	2,000	13%			2,000
101	Total Other Payroll Expense	89,814	4,558	5%	8,785		3,721	837
102
103	TOTAL PAYROLL EXPENSE	5,579,010	333,271	6%	316,083	Always higher than budget because of camp wages in July and Aug	225,404	107,867
104
105	Contract Services	-
106	Accountant	32,580	1,280	4%			640	640
107	Legal	50,000	6,775	14%				6,775
108	Outside Contract Services	238,455	6,199	3%	13,993		718	5,481
109	CGHS/NHEP	495,896	0	0%
110	Purchased Svs/Other Purchased Svs	57,606	0	0%	3,145
111	Advertising, Printing, Publicity	13,352	1,096	8%	766		708	388
112	Total Contract Services	887,889	15,350	2%	17,904		2,066	13,284
113
114	IT Expense
115	CEN	8,820	0	0%
116	Internal Connections Maintenance	13,300	0	0%
117	Hardware Leases and Purchases	55,000	0	0%
118	Software	-	0
119	Total IT Expense	77,120	0	0%	0
120
121	Office Expense	-
122	Office Supplies	9,400	-57	-1%	2,425		-136	79
123	Cleaning/Rest Room supplies	7,800	871	11%	877		80	791
124	Products for Sale (swag, calculators)	9,770	142	1%			142
125	Food/Meeting Expenses	2,500	414	17%	693			414