The URL can be used to link to this page

Home My WebLink About2018 11 19 Consent 305 Final Budget Amendment FY2018 &200,66,21$*(1'$ ,QIRUPDWLRQDO &RQVHQW ; ,7(0 3XEOLF+HDULQJV 5HJXODU 1RYHPEHU.66% 5HJXODU0HHWLQJ&LW\0DQDJHU'HSDUWPHQW 5(48(67 )LQDQFHDQG$GPLQLVWUDWLYH6HUYLFHVLVUHTXHVWLQJWKDWWKH&RPPLVVLRQFRQVLGHUDSSURYDO RI5HVROXWLRQDPHQGLQJWKH)LVFDO<HDU 7KLVEXGJHWDPHQGPHQWDOORZVIRUWUDQVIHUWR6ROLG:DVWH)XQGWRUHSOHQLVKWKH HPHUJHQF\VWRUPUHVHUYHDIWHUSDUWLDOGHSOHWLRQDVVRFLDWHGZLWK+XUULFDQH ,UPD . WUDQVIHUWRWKH3HUN8S3DUNV&DSLWDO3URMHFW)XQGIRUWKHSURSRVHG ILHOGKRXVH . WUDQVIHUWR$UERU)XQGIRUODUJHWUHHUHSODQWLQJWKURXJKRXWWKH &LW\ . WUDQVIHUWR&DSLWDO3URMHFW)XQGIRUHQGRIOLIHDVVHWUHSODFHPHQWDW&LW\ +DOO . WUDQVIHUWR3HUN8S3DUNV&DSLWDO3URMHFW)XQGIRUSOD\JURXQGV 0 DQGDQDGGLWLRQDOFRQWULEXWLRQWRUHGXFHEHQHILWOLDELOLWLHV . 6KRZQLQ$WWDFKPHQWDUHWKHILQDOEXGJHWHGHQGLQJIXQGEDODQFHVIRUDOOIXQGVUHTXLULQJ DPHQGPHQWIRUWKHIRUWKH*HQHUDO3XEOLFDQGSRVWHGDWVL[ GLIIHUHQWORFDWLRQVDURXQGWKH &LW\)XUWKHUPRUHWKLVLQIRUPDWLRQLVDOVRDYDLODEOHWRDQ\LQGLYLGXDOUHTXHVWRUV&LW\6WDII LVDOZD\VZLOOLQJWRGLVFXVVWKLV$JHQGD,WHPRUDQ\$JHQGD,WHPZLWKDQ\LQWHUHVWHG LQGLYLGXDOV :LWKLQILYHGD\VRIDSSURYDODQGDGRSWLRQRI5HVROXWLRQ1RWKH)LQDO%XGJHWIRU )LVFDO<HDU RESOLUTION 2018-22 A RESOLUTION OF THE CITY COMMISSION OF THE CITY OF WINTER SPRINGS FLORIDA, AMENDING THE FISCAL YEAR 2017-2018 BUDGET; PROVIDING FOR SEVERABILITY, REPEAL OF PRIOR INCONSISTENT RESOLUTIONS, AND AN EFFECTIVE DATE. WHEREAS, Section 7.05 of the City Charter provides that the annual City budget may be amended by Resolution duly adopted by the Commission; and WHEREAS, the City Commission of the City of Winter Springs deems that this Resolution is in the best interests of the public health, safety, and welfare of the citizens of Winter Springs. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COMMISSION OF THE CITY OF WINTER SPRINGS, SEMINOLE COUNTY, FLORIDA, AS FOLLOWS: Section 1. Incorporation of Recitals. The foregoing recitals are deemed true and correct and are hereby fully incorporated by this reference. Section 2. That the Fiscal Year 2017-2018 City Budgets are amended as provided in Attachments 2 and 3 attached hereto. Section 3. Repeal of Prior Inconsistent Resolutions. All prior resolutions or parts of resolutions in conflict herewith are hereby repealed to the extent of the conflict. Section 4. Severability. If any section, subsection, sentence, clause, phrase, word, or portion of this Resolution is for any reason held invalid or unconstitutional by any court of competent jurisdiction, such portion shall be deemed a separate, distinct and independent provision and such holding shall not affect the validity of the remaining portion hereto. Section 5. Effective Date. This Resolution shall become effective immediately upon adoption by the City Commission of the City of Winter Springs, Florida. RESOLVED by the City Commission of the City of Winter Springs, Florida, in a th regular meeting assembled on the 19 day of November, 2018. ___________________________________ CHARLES LACEY , Mayor ATTEST: City of Winter Springs, Florida Resolution 2018-22 Page 1 of 2 ________________________________________ ANDREA LORENZO-LUACES , City Clerk Approved as to legal form and sufficiency for the City of Winter Springs only: _______________________________________ ANTHONY A. GARGANESE , City Attorney City of Winter Springs, Florida Resolution 2018-22 Page 2 of 2 Attachment 2 - Budget Amendment Detail 11/19/18; Consent 305; Resolution 2018-22 General Fund Funds not included in this summary do not require budget amendment Difference in Beg HELPFUL TOOLS: Comprehensive Annual Financial Report for the year ended September 30, 2016 as approved by City Commission on 3/27/2017 Regular Fund Bal Actual Beg Fund 500; Fiscal Year 2016-2017 Original Budget As approved by City Commission on 9/25/17 Public Hearing 501. Projected to Balance 9/30/17 ActualCAFR General Fund #001: As approved by City Commission on 9/25/17 Public Hearing Item 501: 10/1/17 Budgeted Beginning Fund Balance$8,499,465$6,818$8,506,283 FY 2018 Budgeted Appropriation to (FROM ) Fund Balance$2,953 9/30/18 Budgeted Ending Fund Equity[[1726,897,1888,929][7][B,I,][Times New Roman]]$8,502,418 Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance FROM projected to actual as shown in 9/30/17 CAFR [[1775,1017,1888,1050][7][,I,][Times New Roman]]$6,818 [[215,1089,492,1127][8][B,I,][Times New Roman]]Revenue Neutral: Community Events: Community Event Revenue - Spring Festival$8,020mid-yr Community Event Expenditure - Spring Festival (7400)($8,020)mid-yr Community Event Revenue - Winter Wonderland$7,360mid-yr Community Event Expenditure - Winter Wonderland (7400)($7,360)mid-yr Community Event Revenue - Hometown Harvest$6,150mid-yr Community Event Expenditure - Hometown Harvest (7400)($6,150)mid-yr Community Event Revenue - July 4th$23,315final Community Event Expenditure - July 4th (7400)($23,315)final $0 Insurance/Recycling/Trade-In: Insurance proceeds - traffic accident$1,954mid-yr Expenditure budget for property damage (4110)($1,954)mid-yr Insurance proceeds - traffic accident$5,297mid-yr Expenditure budget for property damage (2100)($5,297)mid-yr $0 [[216,1772,343,1810][8][B,I,][Times New Roman]]Other: Reduce revenue transfer budget from Water and Sewer - meter reading no longer contracted out($125,000)mid-yr Reduce contract budget in Utility Billing (1360)$125,000mid-yr Summer Camp revenue to increase due to add'l week, registrants$10,000final Summer Camp expenditure budget to increase due to extended week and add'l registrants (7240)($10,000)final Increase General Fund revenue budget (various - grants, investment incoome, etc)$283,000final Establish transfer budget to Solid Waste ($250K Irma) remainder to PW Dep't expend budget (4110)($283,000)final Increase General Fund revenue budget (Code)$55,000final Establish transfer budget to Capital Project Fund #305 - end-of-life asset replacements (1900)($55,000)final Increase General Fund revenue budget (multiple - Elect tax/franch, misc, CST, invst)$1,218,000final Establish transfer budget to Capital Project Fund #303 for field house, park playgrounds (7230(($1,218,000)final $0 FY 18 Final Budget Amendment November 19, 2018 Consent 305 Attachment 2 Attachment 2 - Budget Amendment Detail 11/19/18; Consent 305; Resolution 2018-22 General Fund Funds not included in this summary do not require budget amendment Difference in Beg HELPFUL TOOLS: Comprehensive Annual Financial Report for the year ended September 30, 2016 as approved by City Commission on 3/27/2017 Regular Fund Bal Actual Beg Fund 500; Fiscal Year 2016-2017 Original Budget As approved by City Commission on 9/25/17 Public Hearing 501. Projected to Balance 9/30/17 ActualCAFR [[215,729,649,767][8][B,I,][Times New Roman]]Inter-departmental transfers: Inter-departmental transfer FROM Dep't 19 Gen Gov't - contingency reduction (1900)$22,038mid-yr Inter-departmental transfer TO Dep't 15 Com Dev - urban beautification (1520)($22,038)mid-yr Inter-departmental transfer FROM Dep't 19 Gen Gov't - labor relations (1400)$10,000mid-yr Inter-departmental transfer TO Dep't 72 Parks - City banners (7230)($10,000)mid-yr Inter-departmental transfer FROM Dep't 19 Gen Gov't - contingency reduction (1900)$95,162mid-yr Inter-departmental transfer TO multiple divisions - sick-leave buy-back (see attachment 3)($95,162)mid-yr Inter-departmental transfer FROM Dep't 19 Gen Gov't - labor relations (1400)$40,000mid-yr Inter-departmental transfer TO Dep't 15 Com Dev - urban beautification (1520) ($40,000)mid-yr Inter-departmental transfer FROM Dep't 13 Finance - vacancy (1300)$110,000final Inter-departmental transfer TO Dep't 15 Com Dev - urban beautification (1520) ($110,000)final Inter-departmental transfer FROM Dep't 21 Police - vacancies (2100)$93,555final Inter-departmental transfer TO Dep't 72 - Winding Hollow Park (7230)($93,555)final Inter-departmental transfer FROM Dep't 19 Gen Gov't - contingency reduction (1900)$69,670final Inter-departmental transfer TO Dep't 41 Public Works - City Hall building repairs/improvements (1930) ($69,670)final Inter-departmental transfer FROM Dep't 13 Finance - vacancy (1300)$100,000final Inter-departmental transfer FROM Dep't 21 Police - vacancies (2100)$12,500final Inter-departmental transfer TO Dep't 15 Com Dev - transfer to Arbor Fund (1520) ($112,500)final Inter-departmental transfer FROM Dep't 21 Police - vacancies (2100)$767,000final Inter-departmental transfer TO Dep't 12 City Manager - computer, misc (1200)($2,000)final Inter-departmental transfer TO Dep't 72 for field house, park playgrounds (7230)($765,000)final Inter-departmental transfer FROM Dep't 16 Info Svcs - vacancy (1600)$75,000final Inter-departmental transfer TO Dep't 19 Gen Gov't - transfer to EICSI Cap Proj Fund (1900) ($75,000)final Inter-departmental transfer FROM Dep't 19 Gen Gov't - contingency reduction (1900)$6,330final Inter-departmental transfer TO Dep't 12 City Clerk - Windows data center (1200)($6,330)final $0 Revisions to Original Budgeted Appropriation to (FROM ) Fund Balance[[1824,1747,1888,1780][7][,I,][Times New Roman]]$0 REVISED 9/30/18 Budgeted Ending Fund Balance[[1726,1835,1888,1867][7][B,I,][Times New Roman]]$8,509,236 FY 18 Final Budget Amendment November 19, 2018 Consent 305 Attachment 2 Attachment 2 - Budget Amendment Detail 11/19/18; Consent 305; Resolution 2018-22 Other Governmental Funds HELPFUL TOOLS: Comprehensive Annual Financial Report for the year ended September 30, 2017 as approved by City Commission on 3/19/2018 Difference in Beg Actual Beg Fund Regular 501; Fiscal Year 2017-2018 Original Budget as approved by City Commission on 9/25/17 Public Hearing 501. Fund Bal Projected Balance 9/30/17 to ActualCAFR Special Law Enforcement Fund - Local #102 As approved by City Commission on 9/25/17 Public Hearing Item 501: $9,307$25,274 10/1/17 Budgeted Beginning Fund Balance$15,967 FY 2018 Budgeted Appropriation to (from) Fund Balance($9,275) $32 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $15,967 Increase confiscated property revenues to reflect YTD actuals$4,500mid-yr Revisions to Original Budgeted Appropriation to (from) Fund Balance$20,467 REVISED 9/30/18 Budgeted Ending Fund Balance$20,499 Special Law Enforcement Trust Fund - Federal #103 As approved by City Commission on 9/25/17 Public Hearing Item 501: $35,478$47,376 10/1/17 Budgeted Beginning Fund Balance$11,898 FY 2018 Budgeted Appropriation to (from) Fund Balance($35,203) $275 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $11,898 Increase confiscated property revenues to reflect YTD actuals (DOJ)$7,525mid-yr Increase confiscated property revenues to reflect YTD actuals (DOJ)$23,725final Revisions to Original Budgeted Appropriation to (from) Fund Balance$43,148 REVISED 9/30/18 Budgeted Ending Fund Balance$43,423 Road Improvements Fund #121 As approved by City Commission on 9/25/17 Public Hearing Item 501: $4,307,499$4,957,190 10/1/17 Budgeted Beginning Fund Balance$649,691 FY 2018 Budgeted Appropriation to (from) Fund Balance($2,211,214) $2,096,285 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $649,691 Consent 303; 12.11.17; Consent 301; 5.14.18 - street resurfacing($178,110)final CRA Reimbursement receipt deferred to FY 2019($344,786)final Reduce capital budget - Field House to be deferred to FY 2019$2,850,000final Reduce capital budget - Town Center parking lot to be deferred to FY 2019$195,000final Transfer to the 1999 Construction Fund to be deferred - Magnolia Amphitheater$212,000final $3,383,795 Revisions to Original Budgeted Appropriation to (from) Fund Balance REVISED 9/30/18 Budgeted Ending Fund Balance$5,480,080 FY 18 Final Budget Amendment November 19, 2018 Consent 305 Attachment 2 Attachment 2 - Budget Amendment Detail 11/19/18; Consent 305; Resolution 2018-22 Other Governmental Funds HELPFUL TOOLS: Comprehensive Annual Financial Report for the year ended September 30, 2017 as approved by City Commission on 3/19/2018 Difference in Beg Actual Beg Fund Regular 501; Fiscal Year 2017-2018 Original Budget as approved by City Commission on 9/25/17 Public Hearing 501. Fund Bal Projected Balance 9/30/17 to ActualCAFR Solid Waste/Recycling Fund #130 As approved by City Commission on 9/25/17 Public Hearing Item 501: $1,805,205$1,853,858 10/1/17 Budgeted Beginning Fund Balance$48,653 FY 2018 Budgeted Appropriation to (from) Fund Balance($156,583) $1,648,622 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $48,653 Emergency/recovery expenditure budget - Hurricane Irma debris management($675,000)mid-yr Transfer from General Fund for Storm Reserve$250,000final Revisions to Original Budgeted Appropriation to (from) Fund Balance($376,347) REVISED 9/30/18 Budgeted Ending Fund Balance$1,272,275 Arbor Fund #140 As approved by City Commission on 9/25/17 Public Hearing Item 501: $133,937$289,601 10/1/17 Budgeted Beginning Fund Balance$155,664 FY 2018 Budgeted Appropriation to (from) Fund Balance($85,620) $48,317 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $155,664 Increase arbor revenue budget to reflect YTD actuals$88,000mid-yr FY 2018 tree maintenance/removal expenditure budget($20,000)mid-yr Memorial Tree Planting revenue$650mid-yr Memorial Tree Planting expenditure($650)mid-yr Transfer from General Fund for urban beautification$250,000final Increase arbor fine revenue budget$25,000final $498,664 Revisions to Original Budgeted Appropriation to (from) Fund Balance REVISED 9/30/18 Budgeted Ending Fund Balance$546,981 Transportation Impact Fee Fund #150 As approved by City Commission on 9/25/17 Public Hearing Item 501: $934,946$1,035,724 10/1/17 Budgeted Beginning Fund Balance$100,778 FY 2018 Budgeted Appropriation to (from) Fund Balance($898,600) $36,346 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $100,778 Increase impact fee revenue budget to reflect YTD actuals (residential and commercial) $66,600mid-yr Defer multiple project budgets to FY 2019 $650,000final Revisions to Original Budgeted Appropriation to (from) Fund Balance$817,378 REVISED 9/30/18 Budgeted Ending Fund Balance$853,724 FY 18 Final Budget Amendment November 19, 2018 Consent 305 Attachment 2 Attachment 2 - Budget Amendment Detail 11/19/18; Consent 305; Resolution 2018-22 Other Governmental Funds HELPFUL TOOLS: Comprehensive Annual Financial Report for the year ended September 30, 2017 as approved by City Commission on 3/19/2018 Difference in Beg Actual Beg Fund Regular 501; Fiscal Year 2017-2018 Original Budget as approved by City Commission on 9/25/17 Public Hearing 501. Fund Bal Projected Balance 9/30/17 to ActualCAFR Police Impact Fee Fund #151 As approved by City Commission on 9/25/17 Public Hearing Item 501: $378,284$530,282 10/1/17 Budgeted Beginning Fund Balance$151,998 FY 2018 Budgeted Appropriation to (from) Fund Balance$1,900 $380,184 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $151,998 Increase impact fee revenue budget to reflect YTD actuals (residential and commercial) $7,500mid-yr Revisions to Original Budgeted Appropriation to (from) Fund Balance$159,498 REVISED 9/30/18 Budgeted Ending Fund Balance$539,682 Fire Impact Fee Fund #152 As approved by City Commission on 9/25/17 Public Hearing Item 501: $2,197,368$2,404,140 10/1/17 Budgeted Beginning Fund Balance$206,772 FY 2018 Budgeted Appropriation to (from) Fund Balance$11,000 $2,208,368 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $206,772 Increase impact fee revenue budget to reflect YTD actuals (residential and commercial)$5,950mid-yr Revisions to Original Budgeted Appropriation to (from) Fund Balance$212,722 REVISED 9/30/18 Budgeted Ending Fund Balance$2,421,090 Park Impact Fee Fund #153 As approved by City Commission on 9/25/17 Public Hearing Item 501: $1,098,330$1,473,312 10/1/17 Budgeted Beginning Fund Balance$374,982 FY 2018 Budgeted Appropriation to (from) Fund Balance($246,200) $852,130 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $374,982 Consent 301; 4.9.18 Trotwood pavilion; supplemental appropriation ($150,000)mid-yr Increase impact fee revenue budget to reflect YTD actuals$26,000mid-yr Revisions to Original Budgeted Appropriation to (from) Fund Balance$250,982 REVISED 9/30/18 Budgeted Ending Fund Balance$1,103,112 FY 18 Final Budget Amendment November 19, 2018 Consent 305 Attachment 2 Attachment 2 - Budget Amendment Detail 11/19/18; Consent 305; Resolution 2018-22 Other Governmental Funds HELPFUL TOOLS: Comprehensive Annual Financial Report for the year ended September 30, 2017 as approved by City Commission on 3/19/2018 Difference in Beg Actual Beg Fund Regular 501; Fiscal Year 2017-2018 Original Budget as approved by City Commission on 9/25/17 Public Hearing 501. Fund Bal Projected Balance 9/30/17 to ActualCAFR TLBD Maintenance Fund #160 As approved by City Commission on 9/25/17 Public Hearing Item 501: $196,827$255,524 10/1/17 Budgeted Beginning Fund Balance$58,697 FY 2018 Budgeted Appropriation to (from) Fund Balance($47,420) $149,407 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $58,697 Residual equity transfer from TLBD DS Fund #262 - debt now fully retired$1,861mid-yr Revisions to Original Budgeted Appropriation to (from) Fund Balance$60,558 REVISED 9/30/18 Budgeted Ending Fund Balance$209,965 TLBD II Debt Service Fund #262 As approved by City Commission on 9/25/17 Public Hearing Item 501: $424$1,846 10/1/17 Budgeted Beginning Fund Balance$1,422 FY 2018 Budgeted Appropriation to (from) Fund Balance$0 $424 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $1,422 Residual equity transfer to TLBD Maint Fund #160; debt now fully retired($1,861)mid-yr Recognize investment earnings YTD$15mid-yr Revisions to Original Budgeted Appropriation to (from) Fund Balance($424) REVISED 9/30/18 Budgeted Ending Fund Balance$0 1999 Construction Capital Project Fund #301 As approved by City Commission on 9/25/17 Public Hearing Item 501: $826,162$844,259 10/1/17 Budgeted Beginning Fund Balance$18,097 FY 2018 Budgeted Appropriation to (from) Fund Balance($821,000) $5,162 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $18,097 Defer transfer budget from Road Imp Fund - Magnolia Park ($212,000)final Defer capital expenditure budget - Magnolia Park $1,015,000final Revisions to Original Budgeted Appropriation to (from) Fund Balance$821,097 REVISED 9/30/18 Budgeted Ending Fund Balance$826,259 FY 18 Final Budget Amendment November 19, 2018 Consent 305 Attachment 2 Attachment 2 - Budget Amendment Detail 11/19/18; Consent 305; Resolution 2018-22 Other Governmental Funds HELPFUL TOOLS: Comprehensive Annual Financial Report for the year ended September 30, 2017 as approved by City Commission on 3/19/2018 Difference in Beg Actual Beg Fund Regular 501; Fiscal Year 2017-2018 Original Budget as approved by City Commission on 9/25/17 Public Hearing 501. Fund Bal Projected Balance 9/30/17 to ActualCAFR Public Facilities Capital Project Fund #303 As approved by City Commission on 9/25/17 Public Hearing Item 501: $0$568,934 10/1/17 Budgeted Beginning Fund Balance$568,934 FY 2018 Budgeted Appropriation to (from) Fund Balance$0 $0 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $568,934 Transfer from the General Fund for park playgrounds$1,500,000final Transfer from the General Fund for proposed field house project$550,000final Revisions to Original Budgeted Appropriation to (from) Fund Balance$2,618,934 REVISED 9/30/18 Budgeted Ending Fund Balance$2,618,934 Utility/Public Works Facility Capital Project Fund #304 As approved by City Commission on 9/25/17 Public Hearing Item 501: $104,493$194,036 10/1/17 Budgeted Beginning Fund Balance$89,543 FY 2018 Budgeted Appropriation to (from) Fund Balance($104,000) $493 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $89,543 Increase transfer budget to Capital Project #305 Fund for City Hall Improvements($95,349)mid-yr Recognize investment earnings YTD $313mid-yr Reduce small tools budget$5,000mid-yr Revisions to Original Budgeted Appropriation to (from) Fund Balance($493) REVISED 9/30/18 Budgeted Ending Fund Balance$0 Excellence in Customer Service Initiative CP Fund #305$1,305,466 at 9.30.17 Receivable($1,085,000) As approved by City Commission on 9/25/17 Public Hearing Item 501: $204,248$220,466 10/1/17 Budgeted Beginning Fund Balance$16,218 FY 2018 Budgeted Appropriation to (from) Fund Balance($237,228)Spendable' FB ($32,980) 9/30/18 Budgeted Ending Fund Balance Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $16,218 Recognize revenue budget for loan repayment$120,000mid-yr Increase transfer budget from #304 - PW/Utility CP Fund - residual equity$95,349mid-yr Increase CIP budget for various capital projects (City Hall commission chambers, kiosk, etc.) ($95,349)mid-yr Consent 301; 2.12.18; City Hall improvements (excludes contingency)($9,400)mid-yr Supplemental approp for multiple City Hall improvements (e-sign, lobby enhancements, etc.)($59,200)final Increase transfer budget from General Fund for end-of-life asset replacements (City Hall) $350,000final Revisions to Original Budgeted Appropriation to (from) Fund Balance$417,618 REVISED 9/30/18 Budgeted Ending Fund Balance$384,638 FY 18 Final Budget Amendment November 19, 2018 Consent 305 Attachment 2 Attachment 2 - Budget Amendment Detail 11/19/18; Consent 305; Resolution 2018-22 Enterprise Funds Difference in Beg Actual Ending Fund HELPFUL TOOLS: Comprehensive Annual Financial Report for the year ended September 30, 2017 as approved by City Commission on 3/19/2018 Regular 501; Fiscal Year 2017-2018 Original Budget as approved by City Commission on 9/25/17 Public Net Capital, Fund Bal - Projected Equity 9/30/17 Restricted, NPLto ActualCAFR Hearing 501. Water and Sewer Operating Fund #410 As approved by City Commission on 9/25/17 Public Hearing Item 501: $6,507,943$17,142,707$22,342,618 10/1/17 Budgeted Beginning Fund Balance($1,308,032) FY 2018 Budgeted Appropriation to (from) Fund Equity($696,951) $5,810,992 9/30/18 Budgeted Ending Fund Equityplus W&S Svc Avail Fund$4,840,479 $27,183,097 Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR ($1,308,032) Partial PO Rollovers #2017-1786 CPH; waste water master plan; $85,031 available to roll only utilizing $10,500($10,500)mid-yr Insurance proceeds - WTP #2 Irma damage$6,380mid-yr Expenditure budget - WTP #2 Irma damage($6,380)mid-yr Remainder of PO Rollovers #2017-1786 CPH; waste water master plan($74,531)final Revisions to Original Budgeted Fund Equity($1,393,063) REVISED 9/30/18 Budgeted Ending Fund Equity$4,417,929 (excl of net capital, restricted, NPL) Stormwater Utility Fund #411 As approved by City Commission on 9/25/17 Public Hearing Item 501: $398,309$6,806,249 10/1/17 Budgeted Beginning Fund Equity($7,204,558) FY 2018 Budgeted Appropriation to (from) Fund Equity($115,411) $282,898 9/30/18 Budgeted Ending Fund Equity REVISED 9/30/18 Budgeted Ending Fund Equity Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Equity for budgeting purposes projected to actual ($7,204,558) Establish NRCS Emergency Watershed grant revenue for initial consulting (100% reimbursement)$143,057final Establish NRCS Emergency Watershed grant expenditure budget for initial consulting costs($143,057)final Revisions to Original Budgeted Appropriation to (from) Fund Equity($7,061,501) REVISED 9/30/18 Budgeted Ending Fund Equity ($6,778,603) (excl of net capital, restricted, NPL) Development Services Fund #420 As approved by City Commission on 9/25/17 Public Hearing Item 501: $1,997,872($106,460)$2,778,462 10/1/17 Budgeted Beginning Fund Equity$887,050 FY 2018 Budgeted Appropriation to (from) Fund Equity$529,511 $2,527,383 9/30/18 Budgeted Ending Fund Equity Amendments to be approved tonight to Original FY 2017-2018 Budget (as approved on 9/25/17): Difference in Beginning Fund Balance from projected to actual as shown in 9/30/17 CAFR $887,050 Consent 301; 2.12.18; City Hall improvements ($132,600)mid-yr Consent 302; 10.8.18; Universal Engineering($46,180)final Revisions to Original Budgeted Fund Equity$708,270 REVISED 9/30/18 Budgeted Ending Fund Equity (excl of net capital, restricted, NPL)$3,235,653 FY 18 Final Budget Amendment November 19, 2018 Consent 305 Attachment 2 Attachment 3 - General Fund Budget Amendment Summary 11/19/18; Consent 305; Resolution 2018-22 HELPFUL TOOLS: Comprehensive Annual Financial Report for the year ended September 30, 2017 as approved by City Commission on 3/19/2018 Regular 501; Fiscal Year 2017-2018 Original Budget as approved by City Commission on 9/25/17 Public Hearing 501. [[1375,517,1490,553][8][B,I,][Times New Roman]]FY 18 [[2076,517,2191,553][8][B,I,][Times New Roman]]FY 18 [[1360,558,2212,594][8][B,I,][Times New Roman]]OriginalRevenueInter/Intra Amended [[1363,599,2206,635][8][B,I,][Times New Roman]]AnnualNeutralDepartmentalAnnual [[1116,640,1285,676][8][B,I,][Times New Roman]]Division # [[1368,640,1504,676][8][B,I,][Times New Roman]]Budget [[1593,640,1746,676][8][B,I,][Times New Roman]]Changes [[1803,640,1969,676][8][B,I,][Ti mes New Roman]]Transfers [[2067,640,2203,676][8][B,I,][Times New Roman]]Budget [[216,722,757,758][8][B,I,][Times New Roman]]General Fund Revenues & Transfers: [[1303,722,1353,758][8][B,I,][Times New Roman]]$ [[1387,722,1565,758][8][B,I,][Times New Roman]]17,572,116 [[1995,722,2045,758][8][B,I,][Times New Roman]]$ [[2095,722,2273,758][8][B,I,][Times New Roman]]17,572,116 Summer camp revenue - expanded season$10,000$10,000 Community Event revenue budget$44,845$44,845 Increase revenue budgets (multiple)$338,000$338,000 Reduce transfer from W&S - insource meter-reading $(125,000)$(125,000) Increase elect tax/franch, misc (CRA), CST$1,218,000$1,218,000 Inusrance proceeds$7,251$7,251 [[216,1090,744,1126][8][B,I,][Times New Roman]]General Fund Revenues & Transfers [[1304,1090,1354,1126][8][B,I,][Times New Roman]]$ [[1387,1090,1565,1126][8][B,I,][Times New Roman]]17,572,116 [[1563,1090,1613,1127][8][,I,][Times New Roman]]$ [[1615,1090,1777,1127][8][,I,][Times New Roman]]1,493,096 [[1774,1090,1790,1127][8][,I,][Times New Roman]]$ [[1790,1090,1798,1127][8][,I,][Times New Roman]] [[1798,1090,1806,1127][8][,I,][Times New Roman]] [[1806,1090,1814,1127][8][,I,][Times New Roman]] [[1814,1090,1822,1127][8][,I,][Times New Roman]] [[1822,1090,1830,1127][8][,I,][Time s New Roman]] [[1830,1090,1838,1127][8][,I,][Times New Roman]] [[1838,1090,1846,1127][8][,I,][Times New Roman]] [[1846,1090,1854,1127][8][,I,][Times New Roman]] [[1854,1090,1862,1127][8][,I,][Tim es New Roman]] [[1862,1090,1870,1127][8][,I,][Times New Roman]] [[1870,1090,1878,1127][8][,I,][Times New Roman]] [[1878,1090,1886,1127][8][,I,][Times New Roman]] [[1886,1090,1894,1127][8][,I,][Ti mes New Roman]] [[1894,1090,1902,1127][8][,I,][Times New Roman]] [[1902,1090,1910,1127][8][,I,][Times New Roman]] [[1910,1090,1918,1127][8][,I,][Times New Roman]] [[1922,1090,1933,1127][8][,I,][T imes New Roman]]- [[1996,1090,2046,1126][8][B,I,][Times New Roman]]$ [[2096,1090,2274,1126][8][B,I,][Times New Roman]]19,065,212 [[216,1218,638,1254][8][B,I,][Times New Roman]]General Fund Expenditures: City Commission1100$112,661$1,200$113,861 City Manager1200$284,077$9,914$293,991 City Clerk1210$255,060$11,485$266,545 General Government - Legal Services1400$296,000$(68,000)$228,000 General Government - General 1900$1,820,635$55,000$(179,050)$1,696,585 Finance & Admin Services - General1300$664,984$(89,088)$575,896 Finance & Admin Services - Human Resources1310$150,117$889$151,006 Finance & Admin Services - Utility Billing1360$700,040$(125,000)$1,826$576,866 Finance & Admin Services - Risk Management1920$440,300$(1,450)$438,850 Information Systems - General1600$907,752$(68,068)$839,684 Information Systems - City Hall1910$25,786$25,786 Comm Development - Administration1500$274,778$(57,916)$216,862 Comm Development - Planning1510$78,218$(32,800)$45,418 Comm Development - Urban Beautification1520$600,252$271,038$871,290 Comm Development - Streetlighting1530$484,428$484,428 Police - Chief2100$6,578,559$5,297$(757,497)$5,826,359 Police - Criminal Investigations2110$46,095$(22,825)$23,270 Police - Operations Support2120$14,000$(500)$13,500 Police - Operations 2130$125,095$545$125,640 Police - Special Operations2135$7,900$1,800$9,700 Police - Information Services2140$546,120$16,910$563,030 Police - Code Enforcement2150$11,155$(500)$10,655 Fire - Operations2200$69,000$3,108$72,108 Public Works - Facilities1930$171,511$13,000$69,674$254,185 Public Works - Fleet1940$204,966$4,296$209,262 Public Works - Administration4100$138,664$115$138,779 Public Works - Roads & ROW4110$479,435$271,954$4,551$755,940 P&R - Administration7200$230,288$5,478$235,766 P&R - Athletics7210$192,326$(181,707)$10,619 P&R - Athletics Partnerships7220$22,620$3,176$25,796 P&R - Parks & Grounds7230$1,125,518$1,218,000$1,054,974$3,398,492 P&R - Programs7240$230,958$10,000$5,848$246,806 P&R - Seniors7250$259,865$(7,426)$252,439 P&R - Community Events7400$20,000$44,845$64,845 [[216,2693,625,2729][8][B,I,][Times New Roman]]General Fund Expenditures [[1392,2693,1570,2729][8][B,I,][Times New Roman]]17,569,163 [[1563,2693,1613,2730][8][,I,][Times New Roman]]$ [[1615,2693,1777,2730][8][,I,][Times New Roman]]1,493,096 [[1774,2693,1790,2730][8][,I,][Times New Roman]]$ [[1790,2693,1798,2730][8][,I,][Times New Roman]] [[1798,2693,1806,2730][8][,I,][Times New Roman]] [[1806,2693,1814,2730][8][,I,][Times New Roman]] [[1814,2693,1822,2730][8][,I,][Times New Roman]] [[1822,2693,1830,2730][8][,I,][Times New Roman]] [[1830,2693,1838,2730][8][,I,][Time s New Roman]] [[1838,2693,1846,2730][8][,I,][Times New Roman]] [[1846,2693,1854,2730][8][,I,][Times New Roman]] [[1854,2693,1862,2730][8][,I,][Times New Roman]] [[1862,2693,1870,2730][8][,I,][Tim es New Roman]] [[1870,2693,1878,2730][8][,I,][Times New Roman]] [[1878,2693,1886,2730][8][,I,][Times New Roman]] [[1886,2693,1894,2730][8][,I,][Times New Roman]] [[1894,2693,1902,2730][8][,I,][Ti mes New Roman]] [[1902,2693,1910,2730][8][,I,][Times New Roman]] [[1910,2693,1918,2730][8][,I,][Times New Roman]] [[1922,2693,1933,2730][8][,I,][Times New Roman]]- [[1996,2693,2046,2729][8][B,I,][ Times New Roman]]$ [[2096,2693,2274,2729][8][B,I,][Times New Roman]]19,062,259 FY 18 Final Budget Amendment November 19, 2018 Consent 305 Attachment 3