Loading...
HomeMy WebLinkAbout2017 10 18 Regular 500 Year-End Budget For Fiscal Year 2017 And Discuss Fiscal Year 2018TUSCAWILLA LIGHTING AND BEAUTIFICATION DISTRICT ADVISORY COMMITTEE AGENDA ITEM ITEM 500 October 18. 2017 REQUEST: Regular Meeting Informational Consent Public Hearings Regular X The Public Works/Utility Departments — Urban Beautification Division Requests That The Tuscawilla Lighting And Beautification District Advisory Committee Receive A Year -End Budget For Fiscal Year 2017 And Discuss Fiscal Year 2018 Budget. ATTACHMENT(S): A. Year to Date Budget Review (7 Pages) 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. April monthly maintenance. 04/18/2017 $700.50 Replaced 3 lightbulbs. Extra fountain cleaning. 05/16/2017 $240.00 Replaced 1 lightbulb. 06/13/2017 $655.50 May monthy maintenance. 05/31/2017 $320.00 Addtl maintenance. 06/01/2017 $650.00 June Monthly maintenance. Central Florida Parts for replacement of Liftstations 05/05/2017 $2,480.00 fountain pump check valves. Purchase check valves for PVC Corporation 05/30/2017 $1,756.12 fountain pumps. Stainless steel hardware for replacement of fountain Merit Fasteners 06/06/2017 $304.86 pump check valves. New motor for south TAW 05/05/2017 $1,726.86 fountain. Spare 7.5hp motor for 05/05/2017 $949.86 fountain waterfall. New motor for north 06/23/2017 $1,685.00 fountain. Ferguson Parts for replacement of Enterprises 05/18/2017 $736.00 fountain pump check valves. Harrington 6" PVC tee for fountain Industrial Plastics 05/23/2017 $104.52 repairs. YTD Expense Total $16,813.22 Encumbered $6,062.56 End Balance $14,924.22 0 0 Beginning Balance $209,300.00 Grounds 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 02/06/2017 $16,346.38 improvements 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 Monthly irr repairs from March's audit, spring annual 4/10/2017 $2,569.32 rotation 4/18/2017 $7,923.25 April monthly maintenance 5/5/2017 $2,043.00 Replace 2 irrigation valves 5/18/2017 $7,923.25 May monthly maintenance 6/13/2017 $2,338.05 Monthly irrigation repairs from May's audit 6/19/2017 $7,923.25 June Monthly maintenance 6/23/2017 $1,100.00 Troubleshoot and replace damaged irr module 6/23/2017 $550.00 Troubleshoot 16 fault alarms 7/11/2017 $450.00 Repair mainline break in median 13 A Budget Tree Service 01/10/217 $5,300.00 Removal of dying /hazardous trees from WSB 2/21/2017 $2,600.00 Removed dying laurel oaks median 2 Eastwood 10/21/2016 $5,486.65 October monthly 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 11/29/2016 $5,486.65 November monthly maintenance 01/01/2017 $1,200.00 Clean up of area south of fountains SiteOne 01/24/2017 $500.00 Irrigation supplies for dripline installed for trees south of fountain YTD Expense Total $164,497.97 Encumbered $26,241.86 End Balance $20,960.17 Signs / Walls �0 0 Beginning Balance $20,000.00 All Service Electric 11/01/2016 $1,760.00 Replaced 5 floodlights for flag at entrance, relocated transformer at Vistawilla entrance 12/13/2016 $190.00 Wiring and photocell repairs at fountains 03/10/2017 $185.00 Wiring /lighting at Tuscora entrance 05/18/2017 $2,680.00 Repair /replace low voltage decorative lights 07/11/2017 $730.00 Replaced lights that weren't working at monuments Home Depot 10/21/2016 $121.42 Materials to fix fence panel damaged during tree removals south of fountain 02/14/2017 $645.28 Supplies for painting fence south of fountains BrightView 07/11/2017 $2,520.00 Replace 4 decoders YTD Expense Total $8,831.70 Encumbered $2,223.00 End Balance $8,945.30 Contract Admin Beginning Balance $9,895.00 NBS 01/10/2017 $1,793.69 Services to levy assessment fees NBS 03/24/2017 $1,793.69 Services to levy assessment fees YTD Expense Total $3,587.38 Encumbered $3,587.37 End Balance $2,720.25 0 0 Utilities Beginning Balance $50,100.00 Seminole County 10/17/2016 $48.95 Irrigation for Howell Crk /Deer Rn October 11/14/2016 $41.73 Irrigation for Howell Crk /Deer Rn November 12/13/2106 $41.92 Irrigation for Howell Crk /Deer Rn December 01/18/2017 $44.51 Irrigation for Howell Crk /Deer Rn January 02/10/2017 $42.85 Irrigation for Howell Crk /Deer Rn February 03/13/2017 $45.43 Irrigation for Howell Crk /Deer Rn March 4/48/17 $46.73 Irrigation for Howell Crk /Deer Rn April 05/15/2017 $44.33 Irrigation for Howell Crk /Deer Rn May 06/12/2017 $46.92 Irrigation for Howell Crk /Deer Rn June City of Winter Springs 10/12/2016 $807.79 Irrigation: Vistawilla- Tuscora- Trotwood- Fountain Potable - 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 Irrigation: Vistawilla- Tuscora- Trotwood- Fountain Potable - 04/12/2017 $496.27 April Irrigation: Seneca-Shetland- Dyson- Medians 21, 22, 23- 04/19/2017 $807.86 Fountains -April Irrigation: Vistawilla- Tuscora- Trotwood- Fountain Potable - 05/10/2017 $420.85 May 05/24/2017 $814.95 Irrigation: Seneca-Shetland- Dyson- Medians 21, 22, 23- Fountains -May 06/14/2017 $473.34 Irrigation: Vistawilla- Tuscora- Trotwood- Fountain Potable - June 06/21/2017 $1,480.20 Irrigation: Seneca-Shetland- Dyson- Medians 21, 22, 23- Fountains -June Duke Energy 10/27/2016 $1,958.03 Low voltage entrance lighting - October 11/21/2016 $2,187.60 Low voltage entrance lighting - November 12/22/2016 $2,074.65 Low voltage entrance lighting - December 01/24/2017 $2,244.35 Low voltage entrance lighting - January 02/22/2017 $2,333.24 Low voltage entrance lighting - February 03/24/2017 $1,810.53 Low voltage entrance lighting - March 05/02/2017 $1,652.99 Low voltage entrance lighting - April 05/23/2017 $1,821.30 Low voltage entrance lighting - May 06/23/2017 $2,140.79 Low voltage entrance lighting - June YTD Expense Total $28,475.36 Encumbered $0.00 End Balance $21,624.64 Streetlights Beginning Balance $230,400.00 Duke Energy 10/27/2016 $18,574.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 05/02/2017 $19,198.87 Streetlights -April 05/23/2017 $19,198.87 Streetlights -May 06/23/2017 $19,198.87 Streetlights -June YTD Expense Total $170,914.46 Encumbered $0.00 End Balance $59,485.54 TLBD YTD Monthly Expenditures FY2018 Account Vendor Date Amount Description Fountains Beginning Balance $17,820.00 YTD Expense Total $0.00 Encumbered $0.00 End Balance $17,820.00 0 Grounds Beginning Balance $166,679.00 YTD Expense Total $0.00 Encumbered $0.00 Signs / Walls 0 End Balance Beginning Balance $166,679.00 0� $15,000.00 YTD Expense Total $0.00 Encumbered $0.00 End Balance $15,000.00 F-- 0 Contract Admin Beginning Balance $9,840.00 YTD Expense Total $0.00 Encumbered $0.00 End Balance $9,840.00 0 00 Utilities Beginning Balance $48,720.00 YTD Expense Total $0.00 Encumbered $0.00 End Balance $48,720.00 Beginning Balance $230,400.00 Streetlights YTD Expense Total $0.00 Encumbered $0.00 End Balance $230,400.00