Loading...
HomeMy WebLinkAboutFive-Year Budget Forecast - 06022014AuditedAdoptedEstimated Year-to-Date Proposed PY Estimated vs Proposed FY 13/14Projected ProjectedProjectedProjected FY 12/13FY 13/14FY 13/14FY 13/14FY 14/15VarianceFY 15/16FY 16/17FY 17/18FY 18/19 1 GENERAL FUND BEG. BALANCE $ 814,487 959,238$ 959,238$ 959,238$ $ 1,139,147 $ (56,822) $ 1,122,158 $ 1,030,506 $ 914,269 $ 900,859 2 REVENUES 3 Local Revenues 4 WAF Salary Reimbursement44,200 47,600 47,600 31,001 48,790 1,190 49,766 60,849 62,066 63,307 5 Other Local Revenue 28,546 20,000 20,000 4,369 32,500 12,500 33,475 65,280 67,238 69,256 6 WAF Donation 740,416 1,079,000 1,079,000 777,829 1,100,000 21,000 1,100,000 1,170,928 1,170,928 1,170,928 8 WAF Fund-an-Item 82,066 50,000 50,000 - 50,000 - 50,000 50,000 50,000 50,000 9 Interest Earned 1,594 2,500 2,500 982 1,515 (985) 2,278 1,438 2,061 1,829 10 Food Services 3,150 3,000 3,000 3,000 6,000 3,000 6,000 6,000 6,180 6,365 11 Town Contribution - 90,000 282,000 37,500 15,000 (267,000) 15,000 15,000 15,000 15,000 12 Town Contribution - Westlake Reserve- - - 15,000 300,000 300,000 300,000 300,000 300,000 300,000 13 Athletic Activities 56,298 67,350 67,350 49,855 64,000 (3,350) 65,280 66,586 67,917 69,276 14 Transportation/Parking36,010 50,000 50,000 17,835 41,000 (9,000) 41,820 42,656 43,510 44,380 15 Total Local Revenues 992,281 1,409,450 1,601,450 937,371 1,658,805 57,355 1,663,619 1,778,737 1,784,900 1,790,340 16 State Revenue 17 TEA - FSP Funds 4,416,962 4,638,701 4,774,227 2,985,856 5,453,806 679,579 5,453,806 6,893,557 7,026,253 7,158,949 18 TRS On-behalf/Medicare Part B231,687 259,796 259,796 - 328,286 68,490 335,943 421,905 421,905 421,905 19 Total State Revenues 4,648,649 4,898,497 5,034,023 2,985,856 5,782,092 748,069 5,789,748 7,315,463 7,448,159 7,580,855 20 TOTAL REVENUES 5,640,930 6,307,947 6,635,473 3,923,226 7,440,897 805,424 7,453,367 9,094,200 9,233,059 9,371,195 21 EXPENDITURES by FUNCTION 22 Function 11 - Instructional 3,278,769 3,513,062 3,749,449 2,941,874 4,298,325 548,876 23 Function 12 - Resources & Media 57,784 60,785 61,385 49,803 64,806 3,421 24 Function 13 - Curriculum & Staff Development 89,084 75,170 80,799 59,158 104,089 23,290 25 Function 21 - Instructional Leadership 93,965 185,339 185,539 148,174 189,138 3,599 26 Function 23 - School Leadership 332,693 456,515 523,515 370,132 675,989 152,474 27 Function 31 - Guidance & Counseling 241,791 238,786 275,317 215,665 269,859 (5,458) 28 Function 33 - Health Services 58,208 58,620 59,865 51,356 64,292 4,427 29 Function 35 - Food Services - 15,116 15,116 - 15,408 292 30 Function 36 - Co/Extracurricular Activities 96,063 161,087 165,242 102,494 176,711 11,469 31 Function 41 - Administrative 358,311 362,289 380,917 303,998 384,293 3,376 32 Function 51 - Maintenance & Operations 614,042 674,110 690,110 447,659 930,833 240,723 33 Function 53 - Data Processing 160,695 247,721 172,721 132,138 188,413 15,692 34 Function 61 - Community Services 86,844 92,089 95,589 68,738 95,731 142 35 Function 71 - Debt Service - - - - - - 36 Function 81 - Facility Acquisition/Construction 27,930 - - - - - 37 TOTAL EXPENDITURES5,496,179 6,140,689 6,455,564 4,891,188 7,457,886 1,002,322 - - - - 38 EXPENDITURES by OBJECT 39 Object Code 61XX - Salaries4,216,064 4,695,758 4,842,092 3,808,334 5,544,044 701,952 5,599,044 7,031,758 7,031,758 7,031,758 40 Object Code 62XX - Prof. Contracted Services811,285 822,229 906,402 615,781 1,057,339 150,937 1,078,486 1,100,055 1,122,057 1,144,498 41 Object Code 63XX - Supplies & Materials215,449 332,714 405,490 261,945 484,390 78,900 491,656 649,031 658,766 668,648 42 Object Code 64XX - Other Operating Costs253,380 289,988 301,580 205,128 372,113 70,533 375,834 429,592 433,888 438,227 43 Object Code 65XX - Debt Service- - - - - - - - - - 44 Object Code 66XX - Capital Assets- - - - - - - - - - 45 TOTAL EXPENDITURES5,496,179 6,140,689 6,455,564 4,891,188 7,457,886 1,002,322 7,545,019 9,210,437 9,246,469 9,283,131 46 OTHER RESOURCES (USES) 47 Other Resources - Local40,959 45,000 45,000 - 45,000 - 45,000 45,000 45,000 45,000 48 Other Resources - Lawsuit - - - - - - - - - 49 Other Uses - Local (40,959) (45,000) (45,000) - (45,000) - (45,000) (45,000) (45,000) (45,000) 50 Other Uses - Water Damage - - - - - - - - - 51 Other uses - Insurance - - - - - - - - - 52 Net -Other Resources (Uses)- - - - - - - - - - 53 Excess Revenues Over (Under) Expenditures144,751 167,258 179,909 (967,962) (16,989) (196,898) (91,652) (116,237) (13,410) 88,064 54 GENERAL FUND ENDING BALANCE 959,238 1,126,496 1,139,147 (8,724) 1,122,158 2,261,305 1,030,506 914,269 900,859 988,923 55 Assigned - Technology/FFE- - - - - - - - - - 56 Assigned - Uniform/Equipment Replacement - - - - - - - - - - 57 Assigned - Insurance - - - - - - - - - - 58 Assigned - Prepaid - - - - - - - - - - 59 ENDING FUND BALANCE (Unassigned)959,238 1,126,496 1,139,147 (8,724) 1,122,158 71,368 1,030,506 914,269 900,859 988,923 60 # of Operating Days (365)67 64 (1) 55 50 36 36 39 61 Students Enrolled 62 Primary 320 346 346 324 324 528 528 528 63 Secondary 330 353 353 498 498 511 531 551 64 Total Students Enrolled 650 698 699 822 822 1,039 1,059 1,079 65 TEA Funding/Student 6,817$ 6,840$ 6,840$ 6,840$ 6,840$ 6,840$ 6,840$ 6,840$ Five Year Financial Forecast - FY 2014-15 thru FY 2019-20 Westlake Academy - General Fund