PEDU 625 Budget Development Project Worksheet-2021-22_Dr.J.Ulises_Reveles.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Regular Instruction		100	Operating Budget
2		Classroom Instruction
3
4	Activity	Object	Cost Center	Program	Code	Description	F/P time	Notes	Personal	Salary	2021-2022	Personal2	Salary3	2022-2023	Change
5	61100	1120	200	100	100	Inst. Sal - Midsouth Elem	F		40	40000	1,600,000	41	40,800	1672800	72,800
6	61100	1151	200	100	100	Admin. Sal - Midsouth Elem	F		2	70000	140,000	2	71,400	142800	2,800
7	61100	1520	200	100	100	Aide Sal - Midsouth Elem	F		5	20000	100,000	5	20,400	102000	2,000
8	61100	1521	200	100	100	Substitute Sal - Midsouth Elem	P		2	15000	30,000	2	17,000	34000	4,000
9	61100	1620	200	100	100	Homebound - Midsouth Elem	F				7,500			7500	0
10	61100	1621	200	100	100	FICA *0.0765		Inst., Admin., Aide, Subst, and Home b. get FICA			143628.75			149871.15	6,242
11	61100	1622	200	100	100	VRS *0.1189		Inst., Admin., and Aide get VRS			218,776			228002.64	9,227
12	61100	2100	200	100	100	VRS - Hybrid ICMA *0.003 (approx)		Inst.,Admin, and Aide get VRS - Hybrid ICMA			5,520			5,753	233
13	61100	2210	200	100	100	HMP					368,063			368,063	0
14	61100	2220	200	100	100	GLI *0.0131		Inst., Admin., and Aide get GLI			24,104			25,121	1,017
15	61100	2300	200	100	100	Disbility Ins. Premium-Hybrid					500			500	0
16	61100	2400	200	100	100	Unemployment Ins.					4000			4000	0
17	61100	2500	200	100	100	Workers Comp.					5000			5000	0
18	61100	2510	200	100	100	Retiree Health Care Credit *0.0107		Inst., Admin., and Aide get Retiree Health Care			19688			20518.32	830
19	61100	2600	200	100	100	Other Fringe Benefits					500			500	0
20	61100	2700	200	100	100	Purchased Services					10000			10000	0
21	61100	2750	200	100	100	Professional Development					400			400	0
22	61100	2800	200	100	100	Travel - Midsouth Elem					500			500	0
23	61100	2801	200	100	100	Materials and Supplies					2000			2391	391
24	61100	3000	200	100	100	Textbooks					43000			43000	0
25	61100	3003	200	100	100	Testing Supplies					1000			1000	0
26	61100	5500	200	100	100	SOL Materials					100			280	180
27	61100	6000	200	100	100	ESL Materials					100			280	180
28	61100	6020	200	100	100	School Instructional Supplies					7500			7600	100
29	61100	6030	200	100	100	Repair and Replace Instructional Equipment					1000			1000	0
30						Total - Midsouth Elementary School					$2,732,880			$2,832,879	$100,000
31
32
33	Note 1 : FICA comes out of all checks (full or part-time). VRS, Group Life Insurance (GLI), Health Medical Premiums (HMP) and Retiree Health Care Credit would be based only on full-time employees.
34
35	Note 2: We did not include a percentage for HMP since this varies widely by division. For the purpose of this assignment, we will leave this as a fixed amount.
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