Accounting 2
help2014
charter_school_budget_sheet.xlsSheet1
| Number of Students | 120 | 100 | 66 |
| Revenue | |||
| General Revenue (@ $ 3,546 per student) | 425,520 | 354,600 | 234,036 |
| Compensatory revenue (@ $ 1,775 per student) | 213,000 | 177,500 | 117,150 |
| Transportation Revenue (@ $ 170 per student) | 20,400 | 17,000 | 11,220 |
| TRA Reduction (@ $ (-) 42.44 per student) | -5,093 | -4,244 | -2,801 |
| Food Reimbursement (@ $ 246.50 per student) | 29,580 | 24,650 | 16,269 |
| Federal Title I Funds (@ $ 368 per student) | 44,160 | 36,800 | 24,288 |
| Grants | |||
| Federal Charter School S96 | 50,000 | 50,000 | 50,000 |
| Technology Enhancement | 10,000 | 10,000 | 10,000 |
| St Paul Foundation | 5,000 | 5,000 | 5,000 |
| Bigelow Foundation | 10,000 | 10,000 | 10,000 |
| Total Revenue | 802,567 | 681,306 | 475,162 |
| Revenue Per Student | 6,688 | 6,813 | 7,199 |
| Expenses | |||
| Advertising | 3,000 | 3,000 | 3,000 |
| Computer Equip | 25,000 | 25,000 | 25,000 |
| Staff Development (@ $ 100 per student) | 12,000 | 10,000 | 6,600 |
| Field Trips (@ $ 40 per student) | 4,800 | 4,000 | 2,640 |
| Instructional Material & Equipment (@ $ 150 per student) | 18,000 | 15,000 | 9,900 |
| Instructional Supplies (@ $ 60 per student) | 7,200 | 6,000 | 3,960 |
| Dues and Subscriptions | 1,000 | 1,000 | 1,000 |
| Office/General Supplies | 4,000 | 4,000 | 4,000 |
| Payroll & Salaries | 200,600 | 200,600 | 200,600 |
| Benefits | 35,566 | 35,566 | 35,566 |
| Professional Fees (Accounting & Legal) | 3,000 | 3,000 | 3,000 |
| Principal/Business Mgr Contract | 15,000 | 15,000 | 15,000 |
| Contract Services | 2,000 | 2,000 | 2,000 |
| Printing and Copying (@ $ 98 per student) | 11,760 | 9,800 | 6,468 |
| Internet Access | 1,000 | 1,000 | 1,000 |
| Building Lease | 102,471 | 102,471 | 102,471 |
| Utilities - Water, Electric etc | 21,000 | 21,000 | 21,000 |
| Cleaning Services | 6,000 | 6,000 | 6,000 |
| Maintenance & Repairs | 2,000 | 2,000 | 2,000 |
| Telephone | 5,180 | 5,180 | 5,180 |
| Insurance (Property & Liability) | 4,000 | 4,000 | 4,000 |
| Grass Removal | 4,000 | 4,000 | 4,000 |
| Transportation | 17,000 | 17,000 | 17,000 |
| Food Service (@ $ 246.50 per student) | 29,580 | 24,650 | 16,269 |
| Technology Enhancement | 7,000 | 7,000 | 7,000 |
| Total Expenses | 542,157 | 528,267 | 504,654 |
| Total Expenses Per Student | 4,518 | 5,283 | 7,646 |
| Revenue Less Expenses | 260,410 | 153,039 | -29,492 |
| Schedule A:- Startup Costs | |||
| Capital Equipment and Improvements | 120,000 | 100,000 | 66,000 |
| Office & Classroom Furniture | 24,000 | 20,000 | 13,200 |
| Playground Equipment and Facilities | 10,000 | 10,000 | 10,000 |
| Total Startup Costs | 154,000 | 130,000 | 89,200 |
| Schedule B:- Operating Assumptions | |||
| Number of Students, Reg-K | 25 | 20 | 23 |
| Number of Students, 1-6 | 95 | 80 | 43 |
| Total Students | 120 | 100 | 66 |
| Number of School Days | 170 | 170 | 170 |
| Number of Teachers | 3.60 | 3.00 | 3.00 |
| Number of Special Ed Teachers | 0.50 | 0.50 | 0.50 |
| Number of LEP Teachers | 0.50 | 0.50 | 0.50 |
| Number of Health Service Workers | 0.20 | 0.20 | 0.20 |
| Number of Paraprofessionals | 4.80 | 3.30 | 3.30 |
| Number of Secretaries | 1.00 | 1.00 | 1.00 |
| Number of Custodians | 0 | 0 | 0 |
| Number of Clerks | 0 | 0 | 0 |
| Per Student Instructional Material | $150.00 | $150.00 | $150.00 |
| Per Student Instructional Supplies | $60.00 | $60.00 | $60.00 |
| Per Student General Revenue | $3,546.00 | $3,546.00 | $3,546.00 |
| Per Student Compensatory revenue | $1,775.00 | $1,775.00 | $1,775.00 |
| Percentage of Students on AFDC | 26.47 | 26.47 | 26.47 |
| Per Student Transport Revenue | $170.00 | $170.00 | $170.00 |
| Per Student Transportation Reduction | -$42.44 | -$42.44 | -$42.44 |
| Per Student Food Reimbursement | $246.50 | $246.50 | $246.50 |
| Per Student Federal Title I Funds | $368.00 | $368.00 | $368.00 |
| Schedule C:- Salaries | |||
| Teachers | 88,000 | 88,000 | 88,000 |
| Paraprofessionals | 52,800 | 52,800 | 52,800 |
| Secretary | 24,000 | 24,000 | 24,000 |
| Health Service Workers | 4,800 | 4,800 | 4,800 |
| Contract | 16,000 | 16,000 | 16,000 |
| Competancy- Based Salarary Increases | 15,000 | 15,000 | 15,000 |
| Total Salaries | 200,600 | 200,600 | 200,600 |
| Schedule D:- Benefits | |||
| FICA (7.65%) | 15,346 | 15,346 | 15,346 |
| Retirement (8.14%) | 16,329 | 16,329 | 16,329 |
| Life & Disability (0.9%) | 1,805 | 1,805 | 1,805 |
| Health & Other Insurance (0.7%) | 1,404 | 1,404 | 1,404 |
| Workman Compensation (.34%) | 682 | 682 | 682 |
| Total Benefits (17.73%) | 35,566 | 35,566 | 35,566 |
| ***It is a modified verison of a sample charter school budget available on National Charter School Resource Center website (http://www.charterschoolcenter.org/)*** |
&C&"Calibri,Bold"&11Sample Budget for A Charter School
School Year 2XXX-2XXX
&C&"Calibri,Bold"Page &P of &N
