Category |
Assumptions |
Multiplier |
BUDGET |
JUL |
AUG |
SEP |
OCT |
NOV |
DEC |
JAN |
FEB |
MAR |
APR |
MAY |
JUN |
YTD |
|
|
|
|
Actual |
Actual |
Actual |
Actual |
Actual |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
|
8000 INCOME |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2002-03 P-2 ADA |
49.7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enrollment |
70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
P-1 ADA |
56.97 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Estimated 2003-04 End of Year ADA |
62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Principal Apportionment calculation/ADA |
|
3052 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In-Lieu of tax calculation/ADA |
|
2407 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8011 Principal Apportionment |
|
|
173872 |
9262 |
16699 |
13866 |
11552 |
11552 |
11552 |
12135 |
29085 |
14542 |
14542 |
14542 |
14542 |
173872 |
8012 Jun 03 Apportionment |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
8780 In Lieu of Taxes |
|
|
137127 |
|
6412 |
11263 |
9571 |
9571 |
9571 |
9570 |
9570 |
23866 |
11933 |
11933 |
11933 |
125194 |
8781 July 03 In-Lieu of Tax Payment |
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
0 |
8160 ECIA/ESEA/IASA |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
8161 Title 1 |
|
122 |
|
|
|
|
|
|
|
|
|
0 |
|
|
0 |
0 |
8162 Title 2 |
|
43 |
|
|
1665 |
|
|
|
|
|
|
|
|
|
0 |
1665 |
8163 Title 4 |
|
17 |
|
|
|
|
|
1108 |
|
|
|
|
|
|
0 |
1108 |
8416 Library |
|
0.58 |
33 |
|
|
|
|
|
|
|
|
|
|
33 |
|
33 |
8417 Instructional Materials |
|
|
0 |
|
|
|
|
|
|
|
|
|
0 |
|
|
0 |
8419 Staff Development |
|
23 |
1310 |
|
|
|
|
|
|
|
|
|
|
1310 |
|
1310 |
8560 Lottery |
|
120 |
5964 |
|
|
|
|
|
|
|
|
|
|
5964 |
|
5964 |
8480 Block Grant 9-12 |
|
189 |
10767 |
0 |
1691 |
0 |
752 |
752 |
752 |
751 |
2023 |
1011 |
1011 |
1011 |
1011 |
10767 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL MONTHLY NET INCOME |
|
|
|
9262 |
26467 |
25129 |
21875 |
22983 |
21875 |
22456 |
40678 |
39420 |
27487 |
34794 |
27487 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL INCOME JULY 2003-JUNE 2004 |
|
|
329074 |
|
|
|
|
|
|
|
|
|
|
|
|
319914 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1000 - 3000 SALARIES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1100 Teachers (3.5) |
|
|
109232 |
|
5382 |
10142 |
10412 |
10412 |
9692 |
10412 |
10412 |
10412 |
10412 |
10412 |
10412 |
108512 |
1105 Teacher's Aide (0) |
|
|
0 |
|
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1110 Substitute (10 days) |
|
|
570 |
|
|
0 |
0 |
0 |
0 |
95 |
95 |
95 |
95 |
95 |
95 |
570 |
2200 Administrative |
|
|
45000 |
3750 |
3750 |
3750 |
3750 |
3750 |
3751 |
3750 |
3750 |
3750 |
3750 |
3750 |
3750 |
45001 |
2300 Clerical |
|
|
26004 |
|
2364 |
2364 |
2364 |
2364 |
2364 |
2364 |
2364 |
2364 |
2364 |
2364 |
2364 |
26004 |
3000 Employee Benefits |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
3900 Payroll Benefits Total |
|
|
22180 |
815 |
868 |
1723 |
2924 |
1390 |
1763 |
2066 |
2066 |
2066 |
2066 |
2066 |
2066 |
21878 |
3400 Health Benefits Plan |
|
|
9998 |
-333 |
478 |
1499 |
0 |
2754 |
-351 |
800 |
800 |
800 |
800 |
800 |
800 |
8847 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
SUB-TOTAL SALARIES |
|
|
212984 |
4232 |
12842 |
19478 |
19450 |
20670 |
17219 |
19487 |
19487 |
19487 |
19487 |
19487 |
19487 |
210812 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
4000 BOOKS AND SUPPLIES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
4100 - Instructional Supplies |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
4120 - Books (non-textbooks) |
|
|
1050 |
|
1050 |
|
|
|
|
|
|
|
|
|
|
1050 |
4135 - Classroom Supplies |
|
75 |
3500 |
|
0 |
1486 |
115 |
698 |
135 |
150 |
150 |
150 |
150 |
150 |
150 |
3334 |
4400 Postage and Delivery |
|
100 |
1300 |
222 |
222 |
0 |
30 |
37 |
74 |
100 |
100 |
100 |
100 |
100 |
100 |
1185 |
4410 Printing |
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
0 |
4510 Office Supplies |
|
65 |
700 |
0 |
0 |
0 |
171 |
0 |
|
65 |
65 |
65 |
65 |
65 |
65 |
561 |
4520 Janitorial Supplies |
|
65 |
1000 |
31 |
146 |
181 |
155 |
0 |
120 |
65 |
65 |
65 |
65 |
65 |
65 |
1023 |
4590 Miscellaneous |
|
|
200 |
30 |
0 |
6 |
0 |
55 |
30 |
20 |
20 |
20 |
20 |
20 |
|
221 |
4600 Office Equipment |
|
|
150 |
|
0 |
|
|
|
|
|
|
150 |
|
|
|
150 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
SUB-TOTAL BOOKS AND SUPPLIES |
|
|
7900 |
283 |
1418 |
1673 |
471 |
790 |
359 |
400 |
400 |
550 |
400 |
400 |
380 |
7524 |
5000 - OTHER OPERATING EXPENSES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
5200 Travel and Conferences |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0 |
5210 Automobile Expense |
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
5220 Dues and Membership |
|
|
300 |
125 |
|
62 |
|
|
|
|
|
115 |
|
|
|
302 |
5280 Other Services and Operating Expenses |
|
|
100 |
|
|
0 |
0 |
0 |
|
10 |
10 |
10 |
10 |
10 |
10 |
60 |
5440 Liability Insurance |
|
|
5244 |
5246 |
|
|
|
|
|
|
|
|
|
|
|
5246 |
5500 Utilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
5510 Telephone |
|
|
1550 |
142 |
0 |
158 |
0 |
14 |
|
150 |
150 |
150 |
150 |
150 |
150 |
1214 |
5520 Gas and Electric |
|
|
12000 |
0 |
832 |
964 |
1027 |
2038 |
|
2000 |
1000 |
1000 |
1000 |
1000 |
1000 |
11861 |
5530 Water |
|
475 |
2400 |
44 |
442 |
0 |
0 |
480 |
|
|
475 |
|
475 |
|
475 |
1916 |
5540 Internet Access |
|
300 |
3600 |
149 |
0 |
0 |
598 |
299 |
299 |
300 |
300 |
300 |
300 |
300 |
300 |
3145 |
5550 Alarm Monitoring |
|
350.2 |
4202 |
0 |
0 |
0 |
350 |
0 |
350 |
350 |
350 |
350 |
350 |
350 |
350 |
2801 |
5601 Utilities - Propane |
|
575 |
1725 |
|
|
0 |
|
|
|
|
|
575 |
|
|
575 |
1150 |
5602 Utilities - Trash |
|
90 |
1080 |
173 |
0 |
0 |
0 |
173 |
|
90 |
90 |
90 |
90 |
90 |
90 |
886 |
5610 Building Rent |
|
|
73848 |
6154 |
6154 |
6154 |
6154 |
6154 |
6154 |
6154 |
6154 |
6154 |
6154 |
6154 |
6154 |
73848 |
5620 Equipment Rental |
|
|
0 |
|
|
|
0 |
|
|
|
0 |
|
|
|
|
0 |
5640 Repairs |
|
|
1300 |
|
|
38 |
461 |
66 |
85 |
|
|
|
650 |
|
|
1300 |
5801 Legal Fees |
|
|
1200 |
|
|
0 |
0 |
0 |
|
200 |
200 |
200 |
200 |
200 |
200 |
1200 |
5802 Accounting |
|
|
2500 |
0 |
0 |
250 |
0 |
0 |
500 |
250 |
250 |
250 |
250 |
250 |
250 |
2250 |
5804 Auditor |
|
|
3120 |
0 |
1000 |
1808 |
312 |
|
|
|
|
|
|
|
|
3120 |
5810 Professional Fees Curriculum Devel. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
5820 Maintenance Services |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
5840 Advertising |
|
|
500 |
477 |
0 |
|
|
|
|
|
|
|
|
|
|
477 |
5860 Payroll Expense - SDCOE |
|
|
5000 |
|
|
|
|
|
|
2500 |
2500 |
|
|
|
|
5000 |
5870 Employee Screen and Test |
|
|
300 |
|
0 |
32 |
|
|
|
|
|
|
|
|
|
32 |
5880 Employee Recruitment Expense |
|
|
338 |
|
338 |
|
|
|
|
|
|
|
|
|
|
338 |
5950 Fundraising Expense |
|
|
|
|
|
|
|
|
695 |
|
|
|
|
|
|
695 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
SUB-TOTAL OPERATING EXPENSES |
|
|
120307 |
12510 |
8766 |
9466 |
8902 |
9224 |
8083 |
12004 |
11479 |
9194 |
9629 |
8504 |
9554 |
117316 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6000 CAPITAL OUTLAY |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
6250 Tenant Improvements |
|
|
400 |
291 |
|
|
|
|
|
109 |
|
|
|
|
|
400 |
6400 Equipment - Other |
|
|
500 |
|
333 |
248 |
|
|
|
|
|
167 |
|
|
|
748 |
6440 Software (capitalized) |
|
|
17771 |
17711 |
0 |
|
|
|
|
|
|
|
|
|
|
17711 |
6450 Computer Equipment |
|
|
800 |
|
|
|
|
|
|
800 |
|
|
|
|
|
800 |
6540 Software replacement |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
6550 Computer Equipment Replacement |
|
|
325 |
|
0 |
|
|
|
|
|
|
163 |
|
|
|
163 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
SUB-TOTAL CAPITAL OUTLAY |
|
|
19796 |
18002 |
333 |
248 |
0 |
0 |
0 |
909 |
0 |
329 |
0 |
0 |
0 |
19822 |
7000 OTHER EXPENSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
7310 Revolving Loan Repayment |
|
|
49883 |
|
|
|
|
|
|
|
12471 |
12471 |
12471 |
12471 |
|
49883 |
7320 Private Party Loan Repay |
|
|
3109 |
|
|
0 |
3109 |
|
|
|
|
|
|
|
|
3109 |
7322 Brumfield Loan Repay |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0 |
7325 Other Expense - Cash Flow Loan Repay |
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
7330 Hewlett Packard Payments |
|
|
12363 |
951 |
0 |
1902 |
951 |
1902 |
951 |
951 |
951 |
951 |
951 |
951 |
951 |
12363 |
7332 Wordware Payments |
|
|
4476 |
398 |
0 |
796 |
0 |
796 |
1592 |
398 |
398 |
398 |
398 |
398 |
398 |
5970 |
7350 1% District Oversight |
|
|
3291 |
|
|
|
|
|
|
|
|
|
|
|
3291 |
3291 |
7360 Special Ed Contract |
|
|
15237 |
|
|
|
1693 |
1693 |
1693 |
1693 |
1693 |
1693 |
1693 |
1693 |
1693 |
15237 |
7370 Principal Apportionment Adjustment |
|
|
11726 |
781 |
1562 |
0 |
1041 |
1041 |
1041 |
1043 |
1043 |
1043 |
1043 |
1043 |
1043 |
11724 |
7380 In-Lieu of Taxes Adjustment |
|
|
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
0 |
7390 Block Grant Adjustment |
|
|
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
0 |
7410 Accounts Payable 2002-03 |
|
|
16583 |
-2921 |
-444 |
5301 |
1374 |
1972 |
47 |
|
|
|
|
|
11301 |
16630 |
7410 Lunch Expense |
|
|
34182 |
270 |
100 |
819 |
473 |
1567 |
1705 |
3418 |
3418 |
3418 |
3418 |
3418 |
3418 |
25443 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SUB-TOTAL OTHER EXPENSE |
|
|
150849 |
-521 |
1218 |
8818 |
8641 |
8971 |
7029 |
7503 |
19974 |
19974 |
19974 |
19974 |
22095 |
143650 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9000 OTHER RECEIPTS - NON INCOME |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9200 Carry Over |
|
|
5537 |
5537 |
20374 |
25421 |
16502 |
29624 |
18148 |
13864 |
2360 |
4542 |
6846 |
2387 |
7359 |
5537 |
9270 Student Lunch |
|
600 |
34182 |
|
|
930 |
1112 |
870 |
701 |
3418 |
3418 |
3418 |
3418 |
3418 |
3418 |
24123 |
9700 Revolving Loan - Original loan |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
9701 Revolving Loan - Addendum |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
9702 Private Party Loan |
|
|
15000 |
15000 |
|
|
|
|
|
|
|
|
|
|
|
15000 |
9703 Cash Flow Loan - S.D. Co. Treasurer |
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
9704 Salary Deferal - Executive Director |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
9705 Other Receipts - Special Ed. Adjustment |
|
|
2603 |
0 |
|
2603 |
|
|
|
|
|
|
|
|
|
2603 |
9706 Accounts Receivable from 2002-03 |
|
|
18900 |
18900 |
0 |
|
|
|
|
|
|
|
|
|
|
18900 |
9707 Accounts Receivable - July 04 In-Lieu Taxes |
|
|
11933 |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
9708 Accounts Receivable - 2003-04 ADA Adjust. |
|
|
27459 |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
9708 Sub-lease Church |
|
|
6825 |
|
|
2100 |
|
|
1575 |
|
|
1575 |
|
|
1575 |
6825 |
9709 Sub-Lease Karate Studio |
|
|
1050 |
|
|
|
|
|
|
175 |
175 |
175 |
175 |
175 |
175 |
1050 |
Interest income |
|
|
43 |
4 |
33 |
2 |
4 |
|
4 |
|
|
|
|
|
|
47 |
Yearbook Revenue |
|
|
284 |
|
284 |
|
|
|
|
|
|
|
|
|
|
284 |
9710 Contributions |
|
|
51063 |
|
|
|
27595 |
3900 |
3468 |
2250 |
6250 |
2250 |
1950 |
1950 |
1450 |
51063 |
9710 Other - Grants, Donations, Fund Raisers |
|
|
56727 |
6177 |
2840 |
|
|
426 |
784 |
500 |
3000 |
5000 |
12000 |
13000 |
13000 |
56727 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SUB-TOTAL OTHER RECEIPTS - NON INCOME |
|
|
231606 |
45618 |
23531 |
31056 |
45213 |
34820 |
24679 |
20207 |
15204 |
16960 |
24389 |
20930 |
26978 |
182158 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL EXPENSES |
|
|
511837 |
34506 |
24577 |
39683 |
37464 |
39655 |
32690 |
40303 |
51340 |
49534 |
49490 |
48365 |
51516 |
499123 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ENDING BALANCE |
|
|
48843 |
20374 |
25421 |
16502 |
29624 |
18148 |
13864 |
2360 |
4542 |
6846 |
2387 |
7359 |
2949 |
2949 |