The URL can be used to link to this page

Agenda Packet TC 06/28/2016 - Supplemental ItemsSupplemental Item June 28, 2016 AGENDA ITEM NO. 9 Receive an update from Tim McClure with Northwest Independent School District regarding NISD growth; discussion of same (Staff). What Does It Mean To Be Fast Growth? June 28th, 2016 Northw"""' e-s-t INDEPENDENT SCHOOL DISTRICT www.n 1 s-dik.org I -P =20 �M C m 1 °._� _ • UR_ I .. _ • �. Orr E , � w r 'd7' Y ^S �I l 0 ,mi Sp `( PY:a ppprrr !�17).t AP wr 4— s'� `gid � "� �' � � `� - � "_ ` •�.- � I IN � pro AfZ www.nis-dix.org • Ah , 1 17 4 a rJr I l( •I � � � 'Y " Yui c INDEPENDENT SCHOOL www.nis-dix.org urtanvveo IENDENT SCHOOL al' Northwest ISD Aerials Northw"""' s''t INDEPENDENT SCHOOL DISTRICT 0 fi r 64 ri ILI ,mi SIL � � `' 'fry �' •{r .,. t r I d I a ITI M www.n1s-dix.org 0 177 L.!Mull a ri n we IENDENT SCHOOL Di m dmkl. 4e JI a ri n we IENDENT SCHOOL Di m dmkl. Fast Growth Districts • Texas has over 500,000 new residence each year • Over 1,000 school districts in Texas. • 80% of new student enrollment growth is in 100 districts • 76 districts are currently considered fast growth — Enrollment of at least 2,500 students in the previous year; and — Enrollment growth over the previous five years of at least 10%; or — A net increase of 3,500 or more students over the previous five years • Growth rate is not factored into state funding Northw"""' '` s'' INDEPENDENT SCHOOL DISTRICT Fast Growth Districts • 5 Year Growth —over 5,700 students (2nd) • 5 Year Growth Rate — 40% • Current Enrollment — 21,000+ • 5 Year Projection — 26,700+ • 10 Year Projection — 33,800+ r �- CCOKE Is.ana W Gbdwdvppw L:ndur 1; kwffl ., siaftsthwj Lra ralsv V -1r v AFwr Plhat rant CIA- IDE N TO N GeSiWr �i uhruy a Ilrid�rart Um tnn WISE Iredr.11rn Paradi— lakelianas Ar�lr L..w;MP. B.gd MurrlrwrR Podxilln KA& Cary Gratrwd 3pringown Arts Grape— EM&Mt. SErha- Lrll.fvJtr M MIJWdis P00,61" Lk. tAb.� esr, Pa�nfSertn T�rsw� wbitw%aWar , TARRAN'r PALO PINTO M wwth"ifru I-twarm r rU. ii77t9 gr9a Aird. 1- X .,ft;. k � ih'asaA �dRl 8urlegut Lip" Cranbury �osf�ua MugauNO HOOD B&di�ak Toby (;.d6y JOHNSON Ya0 U&u— .Ak-ArJAe r. .MoorG-45dvn&w R:u^ficea rria Thr"Way Std ERATH Uubibn .r 0 I I1 IIE W N INVEPENDENT SCHOOL DISTRICT Fast Growth Districts Rank District Name Frisco ISD Annual Starts 2,841 Annual Closings 2,757 VDL 4,327 Future 1 7,716 2 Denton 15D 2,093 1,799 2,647 16,832 3 Prosper ISD Lewisville 15D 1,942 1,369 1,475 3,769 29,339 4 1,180 2,204 2,855 5 Northwest ISD 1,305 1,140 2,183 24,048` 6 Dallas ISD 1,305 1,078 2,323 5,777 7 Keller ISD 947 960 895 2,157 8 Little Elm ISD 1,289 957 1,175 4,897 9 Eagle Nit. -Saginaw ISD 945 903 1,216 19,610 1D Rockwall ISD 835 712 686 1,837 8,203 11 Mansfield 15D 569 1,095 5,329 12 Wylie ISD 593 545 1,112 4,73.5 13 McKinney ISD 660 504 1,434 5,954 14 Crowley ISD 533 491 1,049 7,831 15 Forney ISD 502 470 536 15,090 16 Allen ISD 510 455 1,180 1,521 17 Midlothian ISD 550 453 1,168 20,855 18 Budeson 15D 481 446 605 3,282 19 Plano ISD 488 446 1,067 2,729 20 HEB ISD 459 432 369 4,892 Nort INDEPENDENT h I m tnP!4 � ribOP I �slti w . SCHOOL DISTRICT Annual Closing Distribution I 16 MVEN KILLS 1 ' _I i I r4 SND£ ECA RANCH Mlfilll�rw Ridges E3. Ehorado itanak. ATFIELD Ryf7i Top 10 SLibd+w+sicns - 1Q16 Ranked h Annul Closin a Rank Subdivision Annual Clovings Quarter Closings VOL 1 Dorado Ranch '129 17 4 ? rnnhy [-.luh:/Highlinrlt at {R,-rk) Rq '4] }q 3 h illow Ridge Uates (Ft. Worth) 78 14 8 4 Aiohland.% Glen GR 16 a 5 endera Ranch Thompm) 63 27 25 armnn Ranch 62 6 212 7 iaruest Mead ours (NWISD) 57 77 95 $ qeata Meadows 57 7 b 9 Iriarwyck(Hu;jnoke) 52 15 15 20 illages Woodland win s/Wfoodlands .5i S TOTALS 707 165 3891 Vacant Developed Lots 1Q16 � I lib r �l,i PFklr`if I -IF 11' - I i HAMELD BENCH �-il¢El�'fE 1>r • < 100 101 - 215 0-215 i V14 Top 10 Subdivisions -1Q,16 {Ranked by re m aining VDL Annual Kwilk :Subdivisson Closings VOL. i1F.M..TFR hl + ti' - a 1 2 an 4n rally ihlort akcl Berkshire 59 0 315 299 4�, 451 3 Yrails of Fossil Creek 47 230 3w A armcn Ranch 62 212 210 5 airway Ranch 44 129 248 b iuers-(#e Place U 108 0 7 davvest Meadows (NINISD) 57 95 401 $ endera Ranch {Sendera Ranch) 9 al 4,2o*3 9 Rruphy Club/Canterbury Hills 29 fib 0 1U �ighland!3, The (riorthlakc) U 55 TOTALS X07 11,603 163 6,912 Future Lots 1Q16 r,rWn 1 y s' L. ! te SENDIERAL TUNCH ii `k-jILIT II R c 900 ti.� ACL 1,975 s i Top10 Subdivisions- 1Q16 Ranked b Future Inventor Flank Subdivision VDL Future I Sendera Ranch Serdera Ranch 81 4,309 3 Tradition i+r1cF.IveyRanch 0 0 2,984 2,000 4 Nendera Ranch Tharrr 5on 75 1955 'ellin ton (Ft. Worth) 0 1,700 nds Ranch/Bonds Ranch NWIS 0 1.162 qa am ions CirclefCak Creek Trails 4 822 nynn Falls iNortt�lakej 316 689 ale Creek 1 600 10 Elizabeth Creek Estates 0 SS39 TOTALS 1 42316p7i60 verall Housing Data Rv Fle-rnentnry Attendance lone Elementary Zone Annual Starts Quarter Starts Annual Closings Qu Closings Inventory Vacant aev. Lots Future Lots BLCIC 66 10 164 50 14 37 102 _LARA LOVE 1 n I 132 [l it 0 321 Cox 148 .38 32- 87 246 773 GRANGER 38 5 52 8 15 1 0 H ASLET 118 48 97 1.1 56 267 1,532 HATFIELD 2 2 16 2 0 1 6,630 HUGHES 61 38 4 4 57 149 .29 JUSTIN 211 66 130_ 53 104 307' 992 LAKEVIEW 35 8 41 103 1 315 NANCE 40 0 50 11 5 535 1,328 PETERSON PRAIRIE VIEW 39 4 1 0 65 1 7 0 8 4 0 21 75 786 ROANOKE 154 34 102 43,7 68 351 3,[ 55 CHLUTER 153 16 209 2.7 1 40 22 3,564 SENDERA RANCH 2 f7 8 0 4 81 4#309 EVEN HILLS 11 2 11 1 9 37 282 HOMPSON 1073 1 12 1 63 Z7 58 1,140 282 57D 25 1,955 rand Total 1,305 311 2,183 24,046 Highest activity in the category Second highest activity in the category Third highest activity in the categoryNorthm"""" INDEPENDENT SCH003L DISTRICT i� �. � I1 Irl "-.�T -;-e � ,� •� j1�ll �• Y.� AF^ nb.'i� �1 f . 4_4�'C biJR,iNGG b8 j--s..� - f .l._rp1.r1F? N 5Z�,t71�I. _ �w M471R EAEiE11�� t y � Z. J ~y •'' - •�1]4.iJ:15dSlt'#+-IYA IS -43 •blies' IX4 L].15 [}12 - LN PL Ir y � _��i.+ira RLLIwT, Sfr+�8^"f:EkIJ +I'0"i�, +� � �' • a F ♦ ' •- s - 06 _- it. •-' h'LiE?•!-5-ewr--tiLi 14.7 mum �rdp V7¢ r Project Blizzard A RE4iE:F -� -°�, • Fullwood Mixed rise development 275 single family lets f ^ Project -Ill be complewd ill 5 phases � r Zoning has been approved Construction not antic:ipated to start until 3Q l b FC ^ Lakcvlcw Elementary A Ilk, s M 1 11# www.rr 1 s -dtx.oi g Ten Year Forecast By Elementary Campus rt INDEPENDENT 1!1T, h w 0 st' SCHOOL DISTRICT Current ENROLLMENT PROJECTIONS Cam us Capacity 2015/16 2016/j72EO17/18 12019/19 2019120 2020/21 2021/22 2022/23 2023/24 2024/25 2025126 Beck Elernent2rV 850 756 761 802 712 827 b98 i 845 715 839 714 843 702 845 700 846 705 845 714 349 720 849 727 Clara Love Elementary 850 Cox Elementary 950 850 486 535 655 796 972 1,157 1,380 1,647 1,828 2,004 2,231 Granger EIementary 9,36 910 910 900 979 994 996 902 909 917 926 Haslet Elementary 650 577 617 635 678 685 112 697 711 723 742 759 Hatfield Elementary 450 420 470 491 519 551 5$4 EGR 777 WS 1,08s 1,270 Hughes Elementary Justin Elements ry 650 552 564 565 573 567 570 598 5921 �6, 643 644 1 667 669 688 698 711 650 539 535 556 569 588 622 Lakeview Elementary 650 595 665 667 675 Sao 685 695 710 Nance Elementary 650 497 526 563 602 679 726 769 815 858 910 PeteMn lleMentaFV 850 607 72O 754 794 -639—, 834 852 878 881 E377 883 892 Prairie View Elementary 650 413 438 446 453 479 493 515 539 559 579 603 Roanoke Elementary 850 660 70-1 71S 723 716 107 743 782 826 973 922 Schluter Elementary 650 623 707 778 846 927 1,009 1,095 1,192 1,275 1., .166 1,457 Sendera Ranch EItrmL-fltary 650 585 �56 42 10,136 574 593 600 644 649 689 729 773 818 862 Seven Hills Elementary 650 552 559 552 555 559 576 587 609 631 647 Thai nn Efernentaty 'ELEMENTARY SCHOOLTOTALS ELE M E NITA R Y A B SO LUTE G ROWTH 1950 576 113,540. 610 10,994 637 11,439 658 694 724 758 13,763 794 14�,467 837 15,215 984 15,058 12,050 11,912 12,369 13,022 404 444 455 473 457 653 741 704 749 943 FLEMEWARY PERCENTGROWTH 3.99% 4.21% 4-14% 4A3% 3,949' 5.29% 5,69% 5.12% 5-17% S,S49V.— rt INDEPENDENT 1!1T, h w 0 st' SCHOOL DISTRICT Texas Education Code §25.112 Sec. 25.112. CLASS SIZE. (a) Except as otherwise authorized by this section, a school district may not enroll more than 22 students in a kindergarten, first, second, third, or fourth grade class. That limitation does not apply during: (1) any 12 -week period of the school year selected by the district, in the case of a district whose average daily attendance is adjusted under Section 42.005(c); or (2) the last 12 weeks of any school year in the case of any other district. (b) Not later than the 30th day after the first day of the 12 -week period for which a district whose average daily attendance is adjusted under Section 42.005(c) is claiming an exemption under Subsection (a), the district shall notify the commissioner in writing that the district is claiming an exemption for the period stated in the notice. (c) In determining the number of students to enroll in any class, a school district shall consider the subject to be taught, the teaching methodology to be used, and any need for individual instruction. (d) On application of a school district, the commissioner may except the district from the limit in Subsection (a) if the commissioner finds the limit works an undue hardship on the district. An exception expires at the end of the school year for which it is granted. (e) A school district seeking an exception under Subsection (d) shall notify the commissioner and apply for the exception not later than the later of: (1) October 1; or (2) the 30th day after the first school day the district exceeds the limit in Subsection (a). (f) If a school district repeatedly fails to comply with this section, the commissioner may take any appropriate action authorized to be taken by the commissioner under Section 39.131. (g) Expired. N o r t hw'' e-s§'ti INDEPENDENT SCHOOL DISTRICT Beck Elementary School Optimal Close Cvunt2 33 ol—lasunorrs • t854 capac[W -j F1' lnrl N... J,.r# rr1 1 kf Y�racje :r n � I r. r.,�. � t.• 1 w Gr ... J—i, 1:K? Sl.akn.tc f i� Sa �i Gl.•„ ix Y FF32 Stuelen4s — � Stur9cniD � 3ttfdma4H ]d 4TIJfwnRS 1 1 ?.Z? studwM ?'7 �S[U4fE+f7f i trrl Ararir dlh AridRH. 43rAd3 YiA SE3aul.-..i„ 1 SS Sii sY�lti. 115a St ... I"..1i 22 Stu ddffbL Z2 Studft — ]5 Studeni.& 22 SludenL% 22 Sumleml 22 Mudnnls 22 Stud 23 94ULI - hls 22 Siudcnt�; 22 3tudcuts Z2 StuRic au 22 :9tudcnts 22 studenim 2$ st odants 22 Studmnft 22S 21 Sttldowts u sfud■nat a2 -wdswW 25Saude+tte 3� StuRenRs 7. Stiruelats 92 SPPdefm - Txswd nis 2? sntewtles 2s StUPElane8 22 Studonta 22 , tudenls Even Dimrlbution 854 Students (38 Classrooms) Northw"""' 1! s''t INDEPENDENT SCHOOL DISTRICT Fleck FIemen#ary 5dc-hool zags -2017 Pr, j seal MAW. C..ut1 38 Classmoms - (a5a eapaclt}) i IC[xdefgartcry 1st do and Croda 3rd Grade: 4th -Grade Sth 6r3de las tood*rft I" StUddWl. 73.r`rtud■wK,; 1 b t-h4d.0"K yit a'r[rio[ " 11fl[1 22 Studerms �d Stti�arrfs 22 3ludt!FP[!5 22 Studendu .•l `�11.fI1r57T lir vulamorm �.-. �I�p 'SFtudc.Fts �U SSCIitPnLS. r- 20 Stvdepta �') tLIJ!lhttt ti! StuJ��ats !8 i[vJw.an ab Students 2� SruAann l? atuJlr►L iKpku~# m 211 ILL —I—L, 20 ST ud arta 20 studeFlt!q 11 students 2, 5 -lad eei is .21 %tudentr - It1r i65nretae�[s iQ 51 u rnte i 20 M Lid do[u 1 5 5l uden is 1 d Student: I rt iTud rnT: f5 Stladrnt® 44 fRLo*m 32 C.Tudmnfb: 23 SM..udw>x 21 rituden+ts R-1- studen r Projected Distribution = 345 Students (41 Classrooms) Northwest�, F,.e.. INDEPENDENT SCHOOL DISTRICT I a Rte" I ;✓� L _ 46`w, arm 1 I =ir- f N I ` 1+ - --- — - r avw - �. .�_,. Rp.c eumrrLxw m�nv.+w�w-env c+v�o.ro n..J II :l ELEMENTARY dGiOGLa A77CfW1NCC S01L! 1,..... •�' .. _..L:w. 2003 Fsamun BEpI ELEAE,YTIRY ram � HAWLEFE EMENTARY I!1 —Jill mai�saea"'n HATE ELD ELEMENTARY— I az ,NIST N ELEMEJTAAY f+ wwn TM.r.w ❑ �c.r.ww. � w �wrry._-. {y nerm...r.o.r LAREVEWELEPAENIARY __� .. ✓ aenra PAA REVIEW ELEMENTARY _ U r s..c.. ❑,r... raiw�.rx S.r..ew..ryrwr �^ r..r ROANOKF FiEIBl�ARY - E, Pexx rw+te...sen vT. .aa.rwna.a S, e..ae.rdnp ..n.r w.w a.yw SEYBi HELS E3EiA�RARY � exs�ah .�'a rv. u�u� ,w �.�� aaia gar Fr��ima pt�nsne. Thank You Iort INDEPENDENT west SCHOOL DISTRICT Supplemental Item June 28, 2016 AGENDA ITEM NO. 10 Receive presentation andprovide direction to Town Staff regarding Fiscal Year 2017 General Fund Expenditures and Supplemental Items; discussion of same (Staff). General Fund Expenditures Fiscal Year 2017 ----------------------------------------------------------------------------------------- 0 ------------------------------------------------------------------------------------------ TOWN OF TROPHY CLUB ol WYE rlF r rrrrr� e I� 1 ■ Overview • Capital (174.92% Increase from FY 16 Budget) : 0 88.25% is an increase in scheduled capital replacement 0 86.67% of increase is related to supplemental items x $5,000 — Portable Sound System x $40,000 — Shade Structure for Splash Pad x $15,000 — Backup Police Department Data Storage x $36,000 — Wrought iron fence at Lakeview and Harmony Parks x $28,000 — Independence Park West Scoreboards x $1o,000 — Top Dresser x $12,500 — Ditch Witch Trencher x $25,000 — Freedom Park Automatic Gate System x $40,000 — Shade Structure for Playground — Independence Park West x $25,000 — Work Truck for Supplemental Building Inspector / Maintenance Technician Overview • Services/ Supplies (24.33% Increase from FY 16 Budget): o Eliminated positions in lieu of professional services (PIO & Town Attorney) 0 7.93% of increase is related to supplemental items x $77,500 - Comprehensive Plan (Half of total cost, remainder in FY18) x $3,700 - Jeff Ellis and Associates Risk Management Program for Aquatics Facility (Ongoing) x $20,000 — Online Security Evaluation (Ongoing - $15,000) x $1,000 — Tools for supplemental Building Inspector/Maintenance Tech. x $12,500 — Cash and Process Control Evaluation and Monitoring (Every other year) x $8,375 — InCode Accounts Receivable Module (Ongoing - $1,400) x $4,000 - EZ Transparency (Ongoing) x $4,000 - STARS Report (Ongoing) x $19998 - NeoGov (Ongoing - $8,903) x $6,000 - Procurement Card Monitoring/ Governance Support (Ongoing) x $7,500 - Bank RFA Consultation x $5,000 — Customer Relationship Management Mobile App Overview Personnel (3.19% Increase from FY 2016 Budget): o Supplemental Recreation and Tourism Coordinator o Supplemental Investigative Assistant for Police o Supplemental Administrative Assistant for ATM/CFO, HR, Finance, IT, Court, Parks, and Recreation o Supplemental Building Inspector/ Building Maintenance Technician o Stipend dependent on quality of work based on prior two reviews (if only one review is available would be eligible for half) o Merit Pool of $125,000 ($10,000 less than prior year) that will be distributed based on the point/performance based merit distribution Of up to 2% per employee/ evaluation on October 1st and April 1st Personnel Adjustments • Moved 30% of Street Maintenance Worker covered by General Fund in prior years to fully funded by Street Maintenance Sales Tax due to increased collections • Eliminated direct funding of personnel that participate in TMRS by the Storm Drainage Fund and Trophy Club Park fund o Proposed due to GASB 68 implications with recognizing pension liabilities within the financial statements o Storm Drainage Fund will now transfer $40,000 per year to cover General Fund Administrative Costs o Trophy Club Park will now transfer $20,000 per year to cover General Fund Administrative Costs Personnel Adjustments Eliminated transfer from Hotel Occupancy Tax to cover employee cost related to Hotel Occupancy Tax funded events and tourism promotion and added employee direct cost to Hotel Occupancy Fund o Recreation Superintendent split 75/25 between the General Fund/HOT o Special Event and Social Media Manager split 50/5o between General Fund/HOT (increased to 25/75 with supplemental Recreation and Tourism Coordinator) o Supplemental Recreation and Tourism Coordinator split 75/25 between the General Fund/HOT ® Special Events and Social Media Manager will perform some duties of prior PIO with professional services as a supplement and also help manage special events Replaced Town Attorney as an employee and increased professional services to provide those services Fiscal Year 2017 Capital and Equipment Replacement General Fund Department Item Amount Description Replace ICC irrigation system due to Parks ACC Irrigation System $ 20,000 obsolescence with ACC Irrigation System at new Town Hall Parks Irrigation Work Truck (Ford F-250) $ 38,969 Replaces 2000 Ford F-150 Parks Parks Crew Work Truck (Ford F-150) $ 27,447 Replaces 1999 Ford Ranger Parks Sand Pro 3040 $ 20,986 Replaces unrepairable Sand Pro Sandblast and repaint exterior, refinish Parks Independence Park West Facility $ 140,000 bathrooms fixtures, and add new and correct Improvements plumbing issues within building Police Ford Patrol Vehicle (Fully Equipped) $ 36,000 Replaces 2012 Chevrolet Tahoe Repaint spray pad features, replace ADA chair, Recreation Aquatics facility $ 45,300 replace pool grates, replace men's restroom and annual replacement entrance flooring, and replace pool pump room wiring Information Server Replacement $ 8,500 Scheduled IT replacement. Services Information Computer Replacement $ 14,613 Scheduled IT replacement. Services Information Printer and Copier Replacement $ 9,100 Scheduled IT replacement. Services Information Infrastructure Replacement. $ 15,000 Scheduled IT replacement. Services Information Software Replacement $ 2,250 Scheduled IT replacement. Services Information SAN Replacement $ 65,000 Scheduled IT replacement. Services Information Toughbook for Animal Control Officer $ 5,500 Scheduled IT replacement. Services EMS Fire Chief's Vehicle $ 33,000 Replace with Ford SUV EMS I Physio Control Lifepak 15 $ 32,000 Replaces the Lifepak 12 Fiscal Year 2017 Capital and Equipment Replacement General Fund Department Item Amount Description Supplemental Recreation Portable Sound System $ 5,000 New portable sound system for recreation and special events Recreation Shade Structure for Splash Pad $ 40,000 Adds a shade structure to decking outside of splash pad area at Town aquatics facility. Community Work Truck Ford F-150 $ 25,000 Purchase work truck for supplemental Building Development Inspector/Facility Maintenance Technician Information Backup PD Data $ 15,000 Increased backup data storage for the Police Services Department related to HD video. Replace chain link fence at Harmony Park with Parks Harmony Park and Lakeview Park $ 36,000 wrought iron and add wrought iron fence to Wrought Iron Fence Lakeview Park creek border Adds four scoreboards for baseball fields at Parks Independence Park West Scoreboards $ 28,000 Independence Park West (reimbursed from baseball association) Parks Top Dresser $ 10,000 Purchase top dresser for Maintenance Crew Purchase Ditch Witch trencher for irrigation Parks Ditch Witch Trencher $ 12,500 crew (Initial Cost of $12,500 is offset by $3,500 savings in annual rentals) Parks Freedom Park Automatic Gate System $ 25,000 Add automatic gate system at Freedom Dog Park Parks Shade Structure for Playground - $ 40,000 Add a shade structure to playground at Independence Park West Independence Park West. General Fund Total $ 750,165 Fiscal Year 2017 Supplemental Items (One -Time Expenditures) General Fund Department Item Amount Description Replace chain link fence at Harmony Park Parks Harmony Park and Lakeview $ 36,000 with wrought iron and add wrought iron Park Wrought Iron Fence fence to Lakeview Park creek border Parks Independence Park West $ 40,000 Add a shade structure to playground at Shade Structure Independence Park West. Adds four scoreboards for baseball fields at Parks Independence Park West $ 28,000 Independence Park West from (reimbursed Scoreboards baseball association) Parks Top Dresser $ 10,000 Purchase top dresser for Maintenance Crew Purchase Ditch Witch trencher for irrigation Parks Ditch Witch Trencher $ 9,000 crew (Initial Cost of $12,500 is offset by $3,500 savings in annual rentals) Parks Freedom Park Automatic GateY $ 25,000 Add automatic gate system at Freedom Dog System Park Engage consultant to perform bank RFA Finance Bank RFA Consultation $ 7,500 process to include evaluation of needs, consultation, engage banks, and negotiate a new banking contract (every five years). Purchase work truck and tools for Community Work Truck Ford F-150 and $ 26,000 supplemental Building Inspector/Facility Development tools Maintenance Technician Community Comprehensive Plan $ 77,500 New comprehensive plan with a total cost of Development $155,000 over two years. Information Backup PD Data $ 15,000 Increased backup data storage for the Police Services Department related to HD video. Recreation Portable Sound System $ 5,000 New portable sound system for recreation and special events Recreation Shade Structure for Splash Pad $ 40,000 Adds a shade structure to decking outside of splash pad area at Town aquatics facility. Total General Fund Supplemental Items $ 319,000 (One -Time Expenditures) Note: Supplemental items represent new or upgraded programs, personnel, or equipment to the Town. Fiscal Year 2017 Supplemental Items (Ongoing Expenditures) General Fund Department Item Description FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Recreation and Recreation and Tourism Coordinator to assist in Recreation Tourism coordinating recreation programs, sports associations, $ 25,948 $ 27,202 $ 27,768 $ 28,352 $ 28,953 Coordinator tourism, and special events. Jeff Ellis and To provide training, audit, evaluation, and risk Recreation Associates Risk management consultation services to the Town aquatics $ 3,700 $ 3,600 $ 3,800 $ 4,000 $ 4,200 Management facility. Program Purchase EZ Transparency online government Finance EZ Transparency transparency suite to provide user friendly up-to-date $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 financial information. Purchase STARS report to have confidential sales tax data Finance Stars Report analyzed to provide data to assist in predicting future $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 sales tax revenue, meet sales tax based economic development incentives, and allocate TIRZ #1 sales tax. Procurement Card Procurement card monitoring setup and training and Finance Monitoring/ training for management staff on fiduciary responsibility, $ 6,000 $ 4,000 $ 4,000 $ 6,000 $ 4,000 Governance ethics and integrity, internal control, finance transactions, Support and governance. Provide evaluation of cash processes and controls and Cash and Process Finance Control Evaluation provide corrective measures if needed. Evaluate critical $ 12,500 $ $ 12,500 $ $ 12,500 - - cash collection points and improve efficiency and cash and Monitoring controls (refresh every two years). Comprehensive online security evaluation of all internet Information Online Security facing network connections to attempt to stay ahead of $ 20,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 Services Evaluation emerging security threats. Information InCode Accounts To provide method of invoicing and tracking progress of $ 8,375 $ 1,400 $ 1,425 $ 1,450 $ 1,475 Services Receivable Module invoice payments beyond Microsoft Excel. Customer Mobile Device Application that allows residents to submit Information Relationship requests for service, get updates, and view Town $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 Services Management information. Application Fiscal Year 2017 Supplemental Items (Ongoing Expenditures) General Fund Department Item Description FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 NeoGov Insight, Onboard, and Perform provides paperless Human Resources NeoGov applicant tracking, paperless employee onboarding, $ 19,998 $ 8,903 $ 8,903 $ 8,903 $ 8,903 paperless performance evaluations, and access to over 1.5M applicants. Human Resources, Administrative Assistant to provide administrative support Finance, Court, Administrative to Assistant Town Manager/CFO, Human Resources, Parks, Recreation, $ 55,910 $ 58,280 $ 59,942 $ 61,580 $ 63,242 Assistant Finance, Court, Parks, Recreation, and Information Information Services. Services Building Community Inspector/Building Adds a backup building inspector to include duties of $ 58,487 $ 61,058 $ 62,907 $ 64,732 $ 66,615 Development Maintenance building maintenance of all Town facilities. Technician Police Investigative Add full-time investigative assistant to assist criminal $ 54,111 $ 56,403 $ 57,798 $ 59,230 $ 60,704 Assistant linvestigation division. Total General Fund Supplemental Items (Ongoing Expenditures) Note: Supplemental items represent new or upgraded programs, personnel, or equipment to the Town. $278,029 1 $248,846 1 $267,043 1 $262,247 1 $278,592 Manager's Office 0 ----------------------------------------------------------------------------------------- I I ----- I -.--I Financial Summary FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change (Bud. vs. ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED Pro) Personnel $ 562,769 $ 682,554 $ 910,155 $ 689,144 $ 661,441 $ 619,427 -10% Services & Supplies 144,397 147,049 120,822 154,385 167,117 228,270 48% TOTAL $ 707,166 $ 829,603 $ 1,030,977 $ 843,529 $ 828,558 $ 847,697 0% Personnel: Decrease due to removal of the Public Information Officer Services & Supplies: Increase due to professional services related to marketing and public information I Legal Personnel: Decrease due to removal of the Town Attorney as an employee Services & Supplies: Increase due to professional services related to Town Attorney services 7c* Change FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 Financial Summary (Bud. vs. ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED Pro) Personnel $ 147,427 $ 155,337 $ 160,259 $ 165,480 $ 220,325 $ - -100% Services & Supplies 23,731 41,183 16,125 31,492 85,386 150,663 378% TOTAL $ 171,157 $ 196,520 $ 176,384 $ 196,972 $ 305,711 $ 150,663 -24% Personnel: Decrease due to removal of the Town Attorney as an employee Services & Supplies: Increase due to professional services related to Town Attorney services 7c* Police ---------------------------------------------------------------------------------------------------------------- 0 ----------------------------------------------------------------------------------------- ------------ Financial Summary FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change (Bud. vs. ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED Pro) Personnel $ 1,595,503 $ 1,785,362 $ 1,707,897 $ 2,022,142 $ 1,992,320 $ 2,090,645 3% Services & Supplies 376,205 230,562 262,540 284,929 252,441 266,370 -7% Capital 96,601 49,105 4,160 45,800 39,450 36,000 -21% TOTAL $ 2,068,309 $ 2,065,029 $ 1,974,597 $ 2,352,871 $ 2,284,211 $ 2,393,015 2% Personnel: Increase due supplemental investigative assistant Services/Supplies: Decrease is due to fuel and small equipment EMS W-0 Personnel: Increase is due to full year of additional firefighter and merit Services/Supplies: Increase is due to small equipment, uniforms, equipment maintenance, and professional outside services Capital: Increase is due to replacement chief's vehicle and lifepak replacement T(:*: FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change Financial Summary ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Bud. vs. Pro) Personnel $ 658,407 $ 711,887 $ 745,108 $ 793,590 $ 778,029 $ 847,252 7% Services & Supplies 63,919 64,208 79,772 104,469 106,211 148,979 43% Ca pita 1 46,041 32,693 40,818 18,000 18,800 65,000 261% TOTAL $ 768,367 $ 808,788 $ 865,699 $ 916,059 $ 903,040 $ 1,061,231 16% Personnel: Increase is due to full year of additional firefighter and merit Services/Supplies: Increase is due to small equipment, uniforms, equipment maintenance, and professional outside services Capital: Increase is due to replacement chief's vehicle and lifepak replacement T(:*: Streets ----------------------------------------------------------------------------------------------------------------- 0 ---------------------------------------------------------------------------------------------------------------- FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change Financial Summary ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Bud. vs. Pro) Personnel $ 401,150 $ 234,485 $ 188,757 $ 220,656 $ 200,700 $ 255,131 16% Services & Supplies 365,261 169,383 153,831 199,464 169,069 181,138 -9% Capital - - 55,181 - - - N/A TOTAL $ 766,411 $ 403,868 $ 397,770 $ 420,120 $ 369,769 $ 436,269 4% Personnel: Increase is due to full year of streets supervisor offset by transfer of 30% of one employee to Street Maintenance Sales Tax Services/Supplies: Decrease is due to electricity for street lights being lower than anticipated Medians Financial Summary FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Bud. vs. Pro) Personnel $ - $ 145,412 $ 154,672 $ - $ - $ - N/A Services & Supplies - 148,930 168,766 - - - N/A TOTAL $ - $ 294,342 $ 323,438 $ - $ - $ - N/A Medians is combined with Parks in FY 2016 Parks ---------------------------------------------------------------------------------------------------------------- 0 ---------------------------------------------------------------------------------------------------------------- FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change Financial Summary ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Bud. vs. Pro) Personnel $ 549,715 $ 601,121 $ 590,919 $ 786,327 $ 753,319 $ 853,760 9% Services & Supplies 299,313 382,801 325,893 522,868 482,386 566,217 8% Capital 98,708 36,083 52,106 79,600 80,188 398,902 401% TOTAL $ 947,736 $ 1,020,004 $ 968,919 $ 1,388,795 $ 1,315,893 $ 1,818,879 31% • Personnel: Increase is due to additional part-time hours to cover nights, portion of supplemental admin assistant, and merit • Services/Supplies: Increase is due to property maintenance to replace water f6untains in park system, bench replacement at Harmony Park, and Lakeview Park coming online along with independent labor for bathroom cleaning and passive area mowing. • Caital: Increase due to supplemental capital totaling $151,500 an capital replacement of $247,402 Recreation ---------------------------------------------------------------------------------------------------------------- 0 ---------------------------------------------------------------------------------------------------------------- FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change Financial Summary ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Bud. vs. Pro) Personnel $ 346,991 $ 357,015 $ 368,548 $ 417,042 $ 386,135 $ 425,100 2% Services & Supplies 149,397 146,358 152,432 161,605 164,438 171,592 6% Ca pita I - - - 80,000 80,000 90,300 13% TOTAL $ 496,388 $ 503,373 $ 520,979 $ 658,647 $ 630,573 $ 686,992 4% • Personnel: Increase is due to merit, supplemental recreation and tourism coordinator, portion of supplemental administrative assistant, offset by reduction in lifeguards and movement of personnel costs to HOT • Services/ Supplies: Increase is due to supplemental Ellis Risk Management Program and utilities • Capital: Increase due to scheduled pool equipment replacement and supplemental shade structure at pool Communi Events ---------------------------------------------------------------------------------------------------------------- 0 ---------------------------------------------------------------------------------------------------------------- FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 Financial Summary FY 2017 % Change (Bud. vs. ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED Pro) Services & Supplies $ 47,374 $ 38,805 $ 19,008 $ 31,881 $ 33,604 $ 46,178 45% TOTAL $ 47,374 $ 38,805 $ 19,008 $ 31,881 $ 33,604 $ 46,178 45% Increase is due to shifting portion paid in prior years by TCP of Fall Festival and Back to Nature to the General Fund and addition of Kite Fest Planning and Zoning FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change Financial Summary (Bud. vs. ACTUAL ACTUAL ESTIMATE PROPOSED PROPOSED PROPOSED Pro) Personnel $ 104,932 $ 125,871 $ - $ - $ - $ - N/A Services & Supplies 152,206 135,068 - - - - N/A TOTAL $ 257,138 $ 260,939 $ - $ - $ - $ - N/A Combined with Community Development in FY 2015 Community Development Financial Summary FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Bud. vs. Pro) Personnel $ 287,778 $ 302,809 $ 384,291 $ 451,227 $ 454,833 $ 573,763 27% Services & Supplies 31,390 24,013 131,745 131,499 131,614 220,459 68% Ca pita I - - 46,461 - - 25,000 N/A TOTAL $ 319,168 $ 326,821 $ 562,496 $ 582,726 $ 586,447 $ 819,222 41% Personnel: Increase is due to merit, supplemental Building Insector/Maintenance Technician, and eliminating Sirect funding of staff by drainage fund Services/Supplies: Increase is due supplemental comprehensive plan and increased engineering Ca ital: Increase is due to vehicle for supplemental Bul ding Inspector/Maintenance Technician Finance ----------------------------------------------------------------------------------------------------------------- 0 ---------------------------------------------------------------------------------------------------------------- Financial Summary FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Bud. vs. Pro) Personnel $ 254,187 $ 267,197 $ 238,167 $ 285,126 $ 275,830 $ 300,897 6% Services & Supplies 108,978 125,023 1071608 125,293 125,813 163,608 31% Capital 9,650 - - - - - N/A TOTAL $ 372,816 $ 392,220 $ 345,775 $ 410,419 $ 401,643 $ 464,505 13% Personnel: Increase is due to merit and supplemental admin assistant. Services/Supplies: Increase is due to supplemental STARS Reports, Bank RFA, EZ Transparency, Procurement Card Monitoring/ Governance Support, and Cash and Process Control Evaluation and Monitoring. Municipal Court ---------------------------------------------------------------------------------------------------------------- 0 ---------------------------------------------------------------------------------------------------------------- FY 2013 FY 2014 FY 2015 Financial Summary FY 2016 FY 2016 FY 2017 % Change (Bud. vs. ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED Pro) Personnel $ 55,108 $ 71,725 $ 72,993 $ 77,388 $ 70,643 $ 84,896 10% Services & Supplies 13,623 7,848 7,762 9,689 7,980 9,054 -7% TOTAL $ 68,731 $ 79,573 $ 80,754 $ 87,077 $ 78,623 $ 93,950 8% Personnel: Increase is due to merit and supplemental admin assistant. Human Resources ----------------------------------------------------------------------------------------------------------------- 0 ---------------------------------------------------------------------------------------------------------------- FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change Financial Summary ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Bud. vs. Pro) Personnel $ 97,595 $ 70,840 $ 96,766 $ 119,557 $ 130,070 $ 156,234 31% Services & Supplies 5,176 3,442 3,096 4,315 25,800 58,873 1264% TOTAL $ 102,771 $ 74,282 $ 99,862 $ 123,872 $ 155,870 $ 215,107 74% Personnel: Increase is due to supplemental admin assistant and staff promotion. Services/Supplies: Increase is due to addition of insurance broker and supplemental NeoGov software for applicant tracking, performance evaluations, and onboarding Information Services ---------------------------------------------------------------------------------------------------------------- 0 ---------------------------------------------------------------------------------------------------------------- 1p FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change Financial Summary ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Bud. vs. Pro) Personnel $ 181,544 $ 186,288 $ 188,142 $ 218,142 $ 213,033 $ 237,950 9% Services & Supplies 124,270 139,203 212,723 263,657 227,970 299,571 14% Ca pita 1 36,506 8,278 108,437 49,463 47,500 134,963 173% TOTAL $ 342,319 $ 333,769 $ 509,301 $ 531,262 $ 488,503 $ 672,484 27% • Personnel: Increase is due to merit and supplemental admin assistant • Services/Supplies: Increase is due to supplemental online security evaluation, InCode accounts receivable module, and customer relationship mobile app • Capital: Increase due to more planned replacement in FY17 and supplemental PD backup Facility Management Financial Summary FY 2013 FY 2014 FY 2015 ACTUAL ACTUAL ACTUAL FY 2016 FY 2016 BUDGET ESTIMATE FY 2017 % Change PROPOSED (Bud. vs. Pro) Services & Supplies $ 75,344 $ 81,550 $ 108,065 $ 112,079 $ 99,951 $ 146,871 31% TOTAL $ 75,344 $ 81,550 $ 108,065 $ 112,079 $ 99,951 $ 146,871 31% Increase is utilities at due to partial year new Town Hall cleaning services and Other Sources/Uses Transfers In: $40,000 from the Drainage Fund $20,000 from Trophy Club Park $3,000 from the Court Security Fund Transfers Out: 0 $250,000 to Capital Projects Fund (Town Hall) Expenditure Summary Financial Summary FY 2013 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 % Change % Change ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE PROPOSED (Est. vs. Pro) (Bud. vs. Pro) Personnel $ (5,243,103) $ (5,697,900) $ (5,806,672) $ (6,245,821) $ (6,136,678) $ (6,445,055) 5.03% 3.19% Services & Supplies (1,980,583) (1,885,425) (1,870,187) (2,137,625) (2,079,780) (2,657,843) 27.79% 24.34% Capital (287,506) (126,160) (307,163) (272,863) (265,938) (750,165) 182.08% 174.92% TOTAL $ (7,511,192) $ (7,709,486) $ (7,984,022) $ (8,656,309) $ (8,482,396) $ (9,853,063) 16.16% 13.83% Total budget increase of 13.83% o 6.o6% of increase is related to supplemental items 2.97% of increase is related to capital replacement Financial Summary Beginning Fund Balance Revenue Expenditures Personnel Services Services & Supplies Capital Total Expenditures Other Sources (Uses) Net Increase (Decrease) Ending Fund Balance Fund Balance as % of General Fund Expenditures Budget Summary FY 2013 ACTUAL $ 3,131,102 7,678,917 (5,243,103) (1,980,583) (287,506) (71511,191) (768,434) (600,708) $2,530,394 33.69% FY 2014 ACTUAL $2,530,394 8,223,930 (5,697,900) (1,885,425) (126,160) (71709,485) 182 514,626 $ 3,045,020 39.50% FY 2015 ACTUAL $ 31045,018 8,619,077 (5,806,672) (1,870,187) (307,163) (71984,022) 11,000 646,055 $ 3,691,073 46.23% FY 2016 BUDGET $ 31691,073 9,013,800 (6,245,821) (2,137,625) (272,863) (81656,309) (274,000) 83,491 $ 31774,564 43.60% FY 2016 ESTIMATE $ 31691,073 91076,192 (6,136,678) (2,079,780) (265,938) (81482,396) (514,000) 79,796 $ 31770,869 44.46% FY 2017 PROPOSED $ 31770,869 9,661,926 (6,445,055) (2,657,843) (750,165) (91853,063) (187,000) (378,137) $ 31392,732 34.43% Town of Trophy Club - Five -Year Forecast General Fund FY 16 Estimate $ 3,691,073 1 $ 3,770,869 1 $ 3,392,732 1 $ 3,345,186 1 $ 3,782,540 1 $ 3,859,814 5,809,044 6,484,856 6,757,508 7,035,475 7,243,081 7,362,580 969,193 972,398 984,636 996,822 994,011 991,362 793,228 872,775 914,058 986,307 1,088,401 1,115,118 604,500 552,200 344,476 333,326 200,250 196,745 335,322 342,339 345,614 348,640 352,020 355,953 272,291 279,964 284,943 290,040 295,258 300,600 26,000 30,000 35,000 37,500 40,000 42,500 266,614 127,394 137,667 138,462 139,282 141,718 9.076.192 9.661.926 9.803.902 10.166.572 10.352.303 10.506.576 6,1361678 6,445,055 6,678,588 6,922,823 7,175,628 7,439,488 2,079,780 2,657,843 2,551,994 2,539,595 2,573,988 2,643,032 265,938 750,165 683,866 329,800 588,413 253,337 8,482,396 9,853,063 9,914,448 9,792,218 10,338,028 10,335,857 111,000 63,000 63,000 63,000 63,000 63,000 (625,000) (250,000) - - - - (514,000) (187,000) 63,000 63,000 63,000 63,000 79,796 (378,137) (47,546) 437,354 77,275 233,719 $ 3,770,869 j $ 3,392,732 j $ 3,345,186 j $ 3,782,540 j $ 3,859,814 j $ 4,093,534 44.46% 34.43% 33.74% 38.63% 37.34% 39.61%