HomeMy WebLinkAboutWA Five year forecast General Fund FIY�YEAF + # CAST-NOT'ESA ASSUMPTIONS DETAIL,
FY Q8=0J based on estimated year-end numbers.
FY 08-10 based on preliiminary budget numbers_
REVENUES
TEA State€unding is based'on the following assumed student population witlr a 96°%o average daily attendance:
FY 09-10 Years
% Grade 12 .. 26 36
Grades 341 . 38 38.
Grades 1-2' . ,36
Kindergarten % 33 33
Total 473 483
Future Year Grade 12 has beenincreased by 10 based on FY 09-10 Grade 11 enrollment,
Upo i%graduation of first%Sr.class;,estimated to obtain atieast$20K to grants annually.
Blacksmith Apprentice;contributions are flat for FY 2009-29'10 and are based on en the current average of .
Interest earned is,estimated%at an increase of.05°/.for FY 99-10 and 1%in subsequent years using;Fund Balance.
State Fundln€t
TEA State funds are based on the updated Charter School template with above assumed student counts. High School%
allotment,funds are now being distributed with fiheMate t ouhdation funds and recorded 16 the General Fund. G�%% + '
„ Education population is calou6ted using current year-end information plus projected Kindergarten statistics foe FY 09-10. '
Based on projected enrollment lhut reduced'by the HB 3646 of$63,8263 in subsequent years
OBJECT CODE 6JXX-PAYROLL AgSTS
Additional personnel fori t(i9 1U;none in future years
FTE
F rimary=Strings/Special Ed
Secor9dar �Ciassroorta' 3.0 '
Information Technology 1.0
Administrative Staff _0.5
Staff salaries are estlrnated si a 2.41%increase(including%H$3646 and step adjustments);F1'09-10,
Increa
6f2%the
Trrtai above will-nbt directly correlate with the yeai forecast variancerdue to changes in the current,staff duties to.include
additional responsibildies.
'Estimate approxiiziataly$70K in Stimulus funding; Crie S P_al Education teacher and a portion of a Special Education
Aides,salaries'has been allocated to:a separate fund for FY 09-11;Added back to GF in subsequentyears.
OBJECT CODE 62XX-COIdT'RACTELI Stkyldm
Due to the operiing of,the Arts&Scienres Center;amities have been increased by appeoximateiy,$221<, Legal€ees,
have been reduced by$60K for FY 09-10,and the janitorial service was reduced by$i 6K because the day porter's
position that was, janitorial service company is.nov an employee of theAcademy A 3%increase
has been been projected in subsequent years.
OBJECT CODE 63XX-SUPPUI SIRi/tTERIALS?
FY 08=09 increased by$124,487 to properly set up capital lease for computers. The total amount'is offset:by Ilothar
Resources°which represerlts;the lease proceeds vithApple for.computers> FY 09-10 total has been decreased by this
amount and an additional$40K has beery estimated for the start-up supplied needed for the opening of the Arts&Sciences
Center. Total expense for the start-up includes$40K from the General Fund.plus$38.5K from the High fiord(HS)allotment
funding which will be recorded in the Generaf Fund in future yens. The HS Allotment represents$275/HS student.
The FYI 0-11 budget was decreased by the$40K 30/.increase has been estimated for subsequent;years,
OBJECT CODE 84XX-OTHER OIPERA71NG COSTS
Included in FY Off-10 is an increase of insurance related to the the Arts and Science Center,liability,and student
'insurance:
Expenditures were increased for,expenses related to first graduating class,postage for DP exams,IB registration and
yarns,additional 18 training and software license's for-library.
increase of,'3°la in subsequent years.
OTHER RESOURCESPJSES
Includes total of$100,000 transfer out to Municipal budget for Finance1Hl31Facilities support.
General Fund Beginning Fund Balance $ 634,454 $ 471,129 $ 625,965 $ 840,157 $ 971,868 $ 965,039
REVENUES:
Local Revenue
Westlake Foundation reimbursement for Salary 65,136 64,858 64,858 64,858 64,858 64,858
Westlake Foundation Grants 20,000 20;000 20,000 20,000 20,000
Miscellaneous gifts and donations 3,025
WAF,WARE,Grants,Scrip,Other Local Rev 17,500 11,400 60,000 i 60,000 60,000 60,000
Blacksmith Apprentice Program 420,000 420,000 486,381 486,381, 486,381 486,$81
Interest Earned 5,500 3,000 3,130 8,402 9,719 9,850
Food Services 5,750 8,600 8,858 9;124 9,397 9;679
Athletic Activities '44,444 48,006 49,446 50,930 52,457 54,031
Total Local Revenue 581,355 555,464 692,673 699,694 702,813 704,800
State revenue
TEA Foundation funds 2,935,315 3,443,120 3,441,718 3,441,718 3,441,718 3,441,718
TRS On-behalftMedicare Part B (Offset in Salary exp) 154,638 ! 174,285 176,697 180,231 183,835 187,512
TOTAL REVENUES 3,671,308 4,172,869 4,311,088 4,321,642 4,328,366 4,334,Q30
EXPENDITURES;
Object Cade 61XX-Salaries
Salaries 2,478,470 2,662,568 . 2,787,219 ! 2,842,964 2!,899,823 2,957,819
Health Insurance$3001mo contribution rate/employee 103,935 134,999 137,699 140,453 143,262' 146,127
Other Payroll exp(Inc.offset to TRS on-behalf in rev) 154,638 173,232 176,697. 180,231 183,835 187,512
Object Code 62XX-'Professlonal Contracted Services
Professional Contracts&Services{3%) 358,239 292,150 300,915 i 309,942 319,240 328,817
Janitorial Services(3%) 67,500 51,450 52;994 54,583 56,221; 57,907
Utilities(a6%) 141,394 162,690 167,571 172,598 177,776! 183,109
Object Code,6 XX-Supplies&Materials
Supplies/Materials(3%), 227,093 220,051 185,453 191,016 226,747 202,649
Object Code 64XX-Other Operating Costs
Insurance(Liability,Property,Student) (5%) 49,413 54„499 57,224 60,085 63,089 66,244
Other Operating Costs'(3%) 95,447 124,384 128,126 131,970 135,929 140,007
Object Coale 66XX-Debt Service
Capital Lease 82,991 ' 42,000 - - -
TOTAL EXPE€3ITURES 3,759,12#1 3,918,033 3,993,896 4,083,841 4,205,922'' 4,270,192
OTHER RESOURCESIUSES
Other Resources(Setting up capital lease for computers) 136,987 -
Transfers Out 212,500 100,000 103,000 106,09E1 109,273 112,551
Excessl2everiasee0ere ,{ClnderjXtt€ae , ; t3, 2Q . 114836 .214,9$2 . 13fi, 41 13,171 {4t3, 9.3j
ENDING FUND BALANCE 471,129 625,965, 840,157 971,868 985,039 936,326
Designated Fund Balance 20,993 142,920 150,670 158;420 136,1701 143,920
ENDING FUND,BALANCE Undeslgna€ed) $ 450,136 ;$ 483,'04 6 $ 689,487 $ 813,448 $ ;848,869 $ 792,406
$$Per;Operating Day $ 9,958 '$ 10,734 $ 10,942 11,189 $ 11,523' $ 11,699
of Cleratrrg Mays 1l2aselsrt 365)
Key Assumptions:
A State Funding teased on current FY 08-09 funding formula for all five years
B Number of students includes an additional 13°7a(56 students)for FY 09-10;additional 3%(10 students)for FY 10-�11,,flat thereafter
C i FY 09-10 includes four(3)new Secondaryteachers,1 IT and 1 administrative:staff
D 2.4%market increase,in Salary for FY 09-10(step increases and HB'3646 only);2%increase in subsequent years
E Includes$1 00th administrative transfer to Town,,
F Designated fund balance reflects the portion being held for equipmentlunifom replacement as well as FF&E and technology equip.{.{
Uniforms and equipment will be replaced in FY 12/13