Loading...
HomeMy WebLinkAbout2017 04 19 Regular 500 Year to Date and General Budget ReviewTUSCAWILLA LIGHTING AND BEAUTIFICATION DISTRICT ADVISORY COMMITTEE AGENDA ITEM ITEM 500 April 19, 2017 Regular Meeting REQUEST: Informational Consent Public Hearings Regular I X The Public Works/Utility Departments — Urban Beautification Division Requests That The Tuscawilla Lighting And Beautification District Advisory Committee Receive A Year To Date Budget Review And Discuss The Fiscal Year 2017 Proposed Budget. ATTACHMENT(S): A. Year to Date Budget Review (4 Pages) B. TLBD Adopted Budget FY16 -17 (3 Pages) Attachment A TLBD YTD Monthly Expenditures FY2017 Account Vendor Date Amount Description Fountains Beginning Balance $37,800.00 Tom Evans Seal kit for south fountain Environmental 03/24/2017 $291.00 motor. October monthly maintenance. Replaced Fountain Doctors 10/21/2016 $730.50 fountain bulbs. November monthly maintenance. Replaced 11/29/2016 $695.50 fountain bulb. December monthly maintenance and installation of colored lenses for 01/01/2017 $730.50 Christmas. January monthly maintenance. Replaced 01/17/2017 $670.50 fountain bulbs. February monthly maintenance. Replaced 02/21/2017 $655.50 fountain bulbs. March monthly maintenance. 03/24/2017 $730.50 Replaced fountain bulbs. YTD Expense Total $4,504.00 Encumbered $10,310.00 End Balance $22,986.00 Grounds Beginning Balance $209,300.00 Car accident damaged 4 ligustrums on WSB near Sam Insurance Money $2,400.00 Smith Park Amended Beginning Balance $ 211,700.00 October monthly Power Ex 11/29/2016 $868.00 maintenance November monthly 1/1/2017 $868.00 maintenance BrightView 01/10/2017 $1,110.00 Install winter annuals Irrigation repair various 1/10/2017 $845.00 medians Irrigation time Vistawilla and 02/06/2017 $532.00 valve for zone 86 02/06/2017 $27,000.00 Annual Mulching December landscape 02/06/2017 $7,923.25 maintenance Medians 1 -9 landscape 102/06/20171 $16,346.38 improvements 1 January landscape 02/06/2017 $7,923.25 maintenance Replace valves at medians 12, 02/06/2017 $1,984.00 20 and Seneca Install sod where trees were 02/06/2017 $1,225.80 removed medians 6, 8, and 14 Irrigation repair various 02/14/2017 $2,477.75 medians February landscape 02/21/2017 $7,923.25 maintenance Landscape improvements medians 10 -14, Seneca, and 02/23/2017 $19,113.60 Vistawilla 03/10/2017 $1,300.00 Prune larger crape myrtles Remove dead tree south of 03/10/2017 $550.00 fountain March landscape 03/10/2017 $7,923.25 maintenance A Budget Tree Removal of dying /hazardous Service 01/10/217 $5,300.00 trees from WSB Removed dying laurel oaks 2/21/2017 $2,600.00 median 2 October monthly Eastwood 10/21/2016 $5,486.65 maintenance 10/21/2016 $567.40 Additional irr repair 11/01/2016 $1,415.17 Additional irr repair 11/21/2016 $3,208.45 Additional irr repair November monthly 11/29/2016 $5,486.65 maintenance Clean up of area south of 01/01/2017 $1,200.00 fountains Irrigation supplies for dripline installed for trees south of SiteOne 01/24/2017 $500.00 fountain YTD Expense Total $131,677.85 Encumbered $54,323.93 End Balance $25,698.22 Signs / Walls Beginning Balance $20,000.00 Replaced 5 floodlights for flag at entrance, relocated All Service transformer at Vistawilla Electric 11/01/2016 $1,760.00 entrance Wiring and photocell repairs 12/13/2016 $190.00 at fountains Wiring /lighting at Tuscora 03/10/2017 $185.00 entrance Materials to fix fence panel damaged during tree Home Depot 10/21/2016 $121.42 removals south of fountain Supplies for painting fence 02/14/2017 $738.38 south of fountains YTD Expense Total $2,994.80 Encumbered $2,965.00 End Balance $14,040.20 Contract Admin Beginning Balance $9,895.00 Services to levy assessment NBS 01/10/2017 $1,793.69 fees Services to levy assessment NBS 03/24/2017 $1,793.69 fees YTD Expense Total $3,587.38 Encumbered $3,587.37 End Balance $2,720.25 Beginning Balance Utilities $50,100.00 Irrigation for Howell Crk /Deer Seminole County 10/17/2016 $48.95 Rn October Irrigation for Howell Crk /Deer 11/14/2016 $41.73 Rn November Irrigation for Howell Crk /Deer 12/13/2106 $41.92 Rn December Irrigation for Howell Crk /Deer 01/18/2017 $44.51 Rn January Irrigation for Howell Crk /Deer 02/10/2017 $42.85 Rn February Irrigation for Howell Crk /Deer 03/13/2017 $45.43 Rn March Irrigation: Vistawilla- Tuscora- City of Winter Trotwood- Fountain Potable - Springs 10/12/2016 $807.79 October Irrigation: Seneca-Shetland- Dyson- Medians 21, 22, 23- 10/19/2016 $431.97 Fountains - October Irrigation: Vistawilla- Tuscora- Trotwood- Fountain Potable - 11/09/2016 $315.50 November Irrigation: Seneca-Shetland- Dyson- Medians 21, 22, 23- 11/16/2016 $421.63 Fountains - November Irrigation: Vistawilla- Tuscora- Trotwood- Fountain Potable - 12/07/2016 $354.04 December Irrigation: Seneca-Shetland- Dyson- Medians 21, 22, 23- 12/15/2016 $289.64 Fountains - December Irrigation: Vistawilla- Tuscora- Trotwood- Fountain Potable - 01/11/2017 $430.58 January Irrigation: Seneca-Shetland- Dyson- Medians 21, 22, 23- 01/18/2017 $493.62 Fountains - January Irrigation: Vistawilla- Tuscora- Trotwood- Fountain Potable - 02/15/2017 $393.72 February Irrigation: Seneca-Shetland- Dyson- Medians 21, 22, 23- 02/22/2017 $507.05 Fountains - February Irrigation: Vistawilla- Tuscora- Trotwood- Fountain Potable - 03/16/2017 $413.53 March Irrigation: Seneca-Shetland- Dyson- Medians 21, 22, 23- 03/23/2017 $495.97 Fountains -March Low voltage entrance lighting - Duke Energy 10/27/2016 $1,958.03 October Low voltage entrance lighting - 11/21/2016 $2,187.60 November Low voltage entrance lighting - 12/22/2016 $2,074.65 December Low voltage entrance lighting - 01/24/2017 $2,244.35 January Low voltage entrance lighting - 02/22/2017 $2,333.24 February Low voltage entrance lighting - 03/24/2017 $1,810.53 March YTD Expense Total $18,228.83 Encumbered $0.00 End Balance $31,871.17 Streetlights Beginning Balance $230,400.00 Duke Energy 10/27/2016 $18574.57 Streetlights- October 11/21/2016 $18,574.57 Streetlights- November 12/22/2016 $18,612.43 Streetlights- December 01/24/2017 $19,172.56 Streetlights- January 02/22/2017 $19,193.05 Streetlights- February 03/24/2017 $19,190.67 Streetlights -March YTD Expense Total $113,317.85 Encumbered $0.00 CITY OF WINTER SPRINGS Fiscal Year 2016 -2017 Budget Assess Rate /Unit - $120 Legal Maximum - $128 Attachment B Special Assessment - TLBD Maint 160 TOTAL SOURCES $510,845 $512,385 $508,538 $510,576 $508,149 APPLICATIONS 530340 $120 $120 $120 $2,700 $120 $2,700 530341 Other Svcs - Contract / Admin Original Revised $9,971 Account FY 13/14 FY 14/15 FY 15/16 FY 15/16 FY 16/17 Number Account Description Actual Actual Budget Budget Budget $231,541 $235,200 $235,200 $230,400 545210 R &M Infra - Stormwater SOURCES $21,981 $37,800 $24,770 $37,800 545270 325200 Charges for Services $509,755 $509,091 $507,663 $507,663 $507,549 361100/361300 Investment $1,090 $3,294 $875 $875 $600 Total Revenues $510,845 $512,385 $508,538 $510,576 $508,149 Total Transfers $0 $0 $0 $0 $0 TOTAL SOURCES $510,845 $512,385 $508,538 $510,576 $508,149 APPLICATIONS 530340 Other Svcs $2,526 $2,525 $2,700 $2,700 $2,700 530341 Other Svcs - Contract / Admin $9,094 $9,095 $9,971 $9,971 $9,895 540430 Utilities $43,334 $55,646 $54,462 $54,462 $50,100 540434 Streetlights $231,743 $231,541 $235,200 $235,200 $230,400 545210 R &M Infra - Stormwater $13,099 $21,981 $37,800 $24,770 $37,800 545270 R &M Infra - Grounds $136,969 $113,467 $172,400 $187,468 $229,300 555480 Promotional /Advertising $0 $0 $150 $150 $150 Total Operating $436,765 $434,255 $512,683 $514,721 $560,345 591001 To General Fund $67,429 $53,560 $36,495 $36,495 $36,415 591410 To Water Sewer Utility $0 $0 $23,143 $23,143 $25,485 Total Transfers $67,429 $53,560 $59,638 $59,638 $61,900 Total Capital $0 $0 $0 $0 $0 TOTAL APPLICATIONS $504,194 $487,815 $572,321 $574,359 $622,245 CHANGE IN FUND BALANCE FUND BALANCE - October 1 $282,529 $289,180 $301,871 $313,750 $249,967 Appropriation TO (FROM) Fund Balance $6,651 $24,570 ($63,783) ($63,783) ($114,096) FUND BALANCE - September 30 $289,180 $313,750 $238,088 $249,967 $135,871 I[$k] CITY OF WINTER SPRINGS Special Assessment - TLBD II Capital /DS 262 Fiscal Year 2016 -2017 Budget $26,263 Wells Fargo Bank Note $26,242 325300 Prepayments Final Year FY 2017 Assess Rate /Unit - $11 $0 $0 Legal Maximum - $17 369900 Misc Revenue $8,673 $0 $17 $11 $11 $11 $0 Original Revised Account FY 13/14 FY 14/15 FY 15/16 FY 15/16 FY 16/17 Number Account Description Actual Actual Budaet Budaet Budaet SOURCES 325100 Capital Improvement $27,625 $22,882 $26,263 $26,263 $26,242 325300 Prepayments $0 $0 $0 $0 $0 369900 Misc Revenue $8,673 $0 $0 $0 $0 361100/361300 Investment $4,604 $3,655 $60 $60 $25 Total Revenues $40,902 $26,537 $26,323 $26,323 $26,267 Total Transfers $0 $0 $0 $0 $0 TOTAL SOURCES $40,902 $26,537 $26,323 $26,323 $26,267 570720 Interest $4,508 $3,374 $2,245 APPLICATIONS $1,025 Total Debt Service $32,134 $31,724 530340 Other Svcs $202 $134 $260 $252 $225 530341 Other Svcs - Contract / Admin $795 $779 $803 $811 $845 $22,832 Total Operating $997 $913 $1,063 $1,063 $1,070 591001 To General Fund $500 $500 $500 $500 $500 Total Transfers $500 $500 $500 $500 $500 570710 Principal $27,626 $28,350 $29,100 $29,100 $29,890 570720 Interest $4,508 $3,374 $2,245 $2,245 $1,025 Total Debt Service $32,134 $31,724 $31,345 $31,345 $30,915 560650 Construction In Progress $0 $0 $0 $0 $10,000 Total Capital $0 $0 $0 $0 $10,000 TOTAL APPLICATIONS $33,631 $33,137 $32,908 $32,908 $42,485 CHANGE IN FUND BALANCE FUND BALANCE - October 1 $22,161 $29,432 $22,544 $22,832 $16,247 Appropriation TO (FROM) Fund Balance $7,271 ($6,600) ($6,585) ($6,585) ($16,218) FUND BALANCE - September 30 $29,432 $22,832 $15,959 $16,247 $29 Capital project to be determined in consensus with TLBD Board Ism CITY OF WINTER SPRINGS Fiscal Year 2016 -2017 Budget Assess Rate /Unit - $36 Legal Maximum - $43 Special Assessment - TLBD I Capital /DS 261 BB &T Bank Note Final Year FY 2030 $43 $36 $36 $36 Original Revised Account FY 13/14 FY 14/15 FY 15/16 FY 15/16 FY 16/17 Number Account Description Actual Actual Budget Budget Budget $0 $0 SOURCES $0 325100 Capital Improvement $77,812 $82,124 $138,724 $138,724 $138,655 325300 Prepayments $0 $0 $0 $0 $0 369900 Misc Revenue $33,466 $4,365 $0 $0 $0 361100/361300 Investment $55,748 $53,779 $350 $350 $160 Total Revenues $167,026 $140,268 $139,074 $139,074 $138,815 Total Transfers $0 $0 $0 $0 $0 TOTAL SOURCES $167,026 $140,268 $139,074 $139,074 $138,815 APPLICATIONS 530314 Consulting $0 $0 $0 $0 $1,250 530340 Other Svcs $824 $696 $825 $825 $825 530341 Other Svcs - Contract / Admin $3,504 $3,504 $3,829 $3,829 $3,850 Total Operating $4,328 $4,200 $4,654 $4,654 $5,925 591001 To General Fund $500 $500 $500 $500 $500 Total Transfers $500 $500 $500 $500 $500 570710 Principal $77,812 $82,124 $81,328 $81,328 $85,506 570720 Interest $55,127 $52,528 $49,873 $49,873 $47,161 Total Debt Service $132,939 $134,652 $131,201 $131,201 $132,667 560631 Improvements $0 $0 $0 $30,457 $0 560640 Machinery & Equipment $0 $3,865 $0 $0 $0 560650 Construction In Progress $67,214 $33,528 $159,435 $78,978 $70,000 Total Capital $67,214 $37,393 $159,435 $109,435 $70,000 TOTAL APPLICATIONS $204,981 $176,745 $295,790 $245,790 $209,092 CHANGE IN FUND BALANCE FUND BALANCE - October 1 $264,389 $226,434 $186,434 $189,957 $83,241 Appropriation TO (FROM) Fund Balance ($37,955) ($36,477) ($156,716) ($106,716) ($70,277) FUND BALANCE - September 30 $226,434 $189,957 $29,718 $83,241 $12,964 Capital: Fountain Pump Station recoating $20,000 Landscape upgrades $50,000 $70,000 Is[$]