The URL can be used to link to this page

Home My WebLink About2018 04 18 Regular 502 Year to Date Budget ReviewTUSCAWILLA LIGHTING AND BEAUTIFICATION DISTRICT ADVISORY COMMITTEE AGENDA ITEM ITEM 502 April 18, 2018 Meeting REQUEST: Consent Information Public Hearin Regular X The Finance And Administrative Services Department Requests That The Tuscawilla Lighting And Beautification District Advisory Committee Receive A Year To Date Budget Review And Enter Into A Discussion. ATTACHMENTS(S): A. TLBD FY 17/18 Budget B. TLBD FY 17/18 Expenditure Report Special Assessment - TLBD Maint 160 Assess Rate/Unit - Legal Maximum Account Number $120 - $128 Account Description $120 FY 15/16 Actual $120 FY 16/17 Actual $120 Original FY 17/18 Budget $120 Revised FY 17/18 Budget SOURCES 325200 Charges for Services $509,565 $509,452 $507,549 $507,549 361100/361300 Investment $3,585 $2,712 $875 $875 Total Revenues $513,150 $514,564 $508,424 $508,424 381262 From TLBD II DS $0 $0 $0 $1,861 Total Transfers $0 $0 $0 $0 TOTAL SOURCES $513,150 $514,564 $508,424 $508,424 APPLICATIONS 530340 Other Svcs $2,533 $2,532 $2,700 $2,700 530341 Other Svcs - Contract / Admin $9,300 $9,007 $9,840 $9,840 540430 Utilities $47,823 $38,439 $48,720 $50,720 540434 Streetlights $217,595 $228,522 $230,400 $230,400 545210 R&M Infra - Stormwater $19,183 $22,954 $17,820 $17,820 545270 R&M Infra - Grounds $159,905 $206,610 $181,679 $179,679 555480 Promotional / Advertising $0 $0 $150 $150 Total Operating $456,339 $508,064 $491,309 $491,309 591001 To General Fund $36,495 $36,415 $38,855 $38,855 591410 To Water Sewer Utility $23,143 $25,485 $25,680 $25,680 Total Transfers $59,638 $61,900 $64,535 $64,535 Total Capital $0 $0 $0 $0 TOTAL APPLICATIONS $515,977 $569,964 $555,844 $555,844 CHANGE IN FUND BALANCE FUND BALANCE - October 1 $313,751 $310,924 $196,827 $255,524 Appropriation TO (FROM) Fund Balance ($2,827) ($55,400) ($47,420) ($47,420) FUND BALANCE - September 30 $310,924 $255,524 $149,407 $208,104 Special Assessment - TLBD I Capital/DS 261 BB&T Bank Note Final Year FY 2030 Assess Rate/Unit - $36 Legal Maximum - $43 Account Number Account Descr SOURCES 325100 Capital Improvement 325300 Prepayments 369900 Misc Revenue 361100/361300 Investment $8,061 Total Revenues Total Transfers TOTAL SOURCES APPLICATIONS $43 $36 $36 $36 Original Revised FY 15/16 FY 16/17 FY 17/18 FY 17/18 Actual Actual Budaet Budaet $81,326 $85,506 $138,655 $138,655 $372 $0 $0 $0 $8,061 $6,525 $0 $0 $51,050 $48,040 $420 $420 $140,809 $140,071 $139,075 $139,075 $0 $0 $0 $0 $140,809 $140,071 $139,075 $139,075 530314 Consulting $0 $0 $1,250 $1,250 530340 Other Svcs $691 $691 $825 $825 530341 Other Svcs - Contract / Admin $3,566 $3,293 $3,850 $3,850 Total Operating $4,257 $3,984 $5,925 $5,925 591001 To General Fund $500 $500 $500 $500 Total Transfers $500 $500 $500 $500 570710 Principal $81,328 $85,506 $89,572 $89,572 570720 Interest $49,872 $47,161 $44,325 $44,325 Total Debt Service $131,200 $132,667 $133,897 $133,897 560631 Improvements $30,457 $0 $0 $0 560640 Machinery & Equipment $0 $0 $0 $0 560650 Construction In Progress $22,143 $20,993 $50,000 $50,000 Total Capital $52,600 $20,993 $50,000 $50,000 TOTAL APPLICATIONS $188,557 $158,144 $190,322 $190,322 CHANGE IN FUND BALANCE FUND BALANCE - October 1 Appropriation TO (FROM) Fund Balance FUND BALANCE - September 30 CIP: Landscape upgrades $189,959 $142,211 $121,933 $124,138 ($47,748) ($18,073) ($51,247) ($51,247) $142,211 $124,138 $70,686 $72,891 $50,000 TLBD Maintenance Fund #160 Grounds Activity YTD at 3.31.18 Check Account Vendor Number Day 540430- Utilities 540434 - Streetlights 545210.001 - R&M Infra - Stormwater, Ponds 4419 - SEMINOLE COUNTY WATER & 10/30/2017 26538 SEWER UTILITY 25992 10/17/2017 27070 26335 11/13/2017 03/06/2018 26696 12/18/2017 26542 27011 01/16/2018 12/18/2017 27528 02/27/2018 27001 27889 03/13/2018 5354 - CITY OF WINTER SPRINGS 1478 10/13/2017 1,175.02 1484 10/24/2017 286.28 1490 11/17/2017 926.87 1495 11/22/2017 1,042.00 1507 12/18/2017 1,536.07 1511 12/27/2017 1,039.64 1520 01/17/2018 1,329.13 1522 01/19/2018 1,589.21 1533 02/15/2018 1,103.13 1535 02/21/2018 1,245.99 1544 03/14/2018 2,291.61 1546 03/21/2018 716 - DUKE ENERGY FLORIDA 26206 10/30/2017 2,363.44 26538 11/28/2017 2,436.64 26741 12/22/2017 1,953.41 27070 01/23/2018 1,744.90 27699 03/06/2018 0.00 27873 03/28/2018 716 - DUKE ENERGY FLORIDA 26206 10/30/2017 26538 11/28/2017 26741 12/22/2017 27070 01/23/2018 27699 03/06/2018 27873 03/28/2018 17591 - TOM EVANS ENVIRONMENTAL INC 27365 02/12/2018 pending pending 9507 - FOUNTAIN DOCTORS LLC 26072 10/23/2017 26209 11/06/2017 26432 11/16/2017 26542 12/05/2017 26679 12/18/2017 26917 01/04/2018 27001 01/12/2018 27332 02/12/2018 27706 03/13/2018 Transaction Amount 50,720.00 FY18 Budget 84.25 32.41 31.66 45.76 48.77 42.94 795.06 1,150.31 1,175.02 286.28 926.87 1,042.00 1,536.07 1,039.64 1,329.13 1,589.21 1,103.13 1,245.99 2,291.61 2,186.32 2,363.44 2,436.64 1,953.41 1,744.90 26,480.82 YTD Actuals 0.00 Encumbered 24,239.18 Remaining Budget 230,400.00 FY18 Budget 19,198.87 19,198.87 19,198.87 19,367.50 19,367.50 19,368.17 115,699.78 YTDActuals 0.00 Encumbered 114,700.22 Remaining Budget 17,820.00 FY18 Budget 518.00 3,568.00 663.00 663.00 150.00 663.00 15.00 663.00 15.00 663.00 738.00 8,319.00 YTD Actuals 8,196.00 Encumbered 1,305.00 Remaining Budget Check Transaction Account Vendor Number Day Amount 545270.004 - R&M Infra - Grounds, Signs / Walls 14,000.00 FY18 Budget 18061 - ALL SERVICE ELECTRIC OF ORLANDO INC 26905 01/05/2018 541.00 26986 01/16/2018 308.00 27316 02/12/2018 902.00 27581 03/06/2018 1,215.00 20296 - SEMPER FI PRESSURE WASHING, LLC 27782 03/15/2018 500.00 39-HOME DEPOT 27596 02/27/2018 10.671 3,476.67 YTDActuals 2,173.33 Encumbered 8,350.00 Remaining Budget 545270 - R&M Infra - Grounds 165,679.00 FY18 Budget 20546 - BRIGHTVIEW LANDSCAPE SERVICES, INC. 26117 10/23/2017 9,433.25 26278 10/30/2017 3,026.00 26890 01/04/2018 28,533.09 27037 01/23/2018 8,081.72 27128 01/30/2018 25,245.00 27302 02/12/2018 10,598.72 20546 - BRIGHTVIEW LANDSCAPE SERVICES, INC. 26279 11/14/2017 1,857.58 26378 11/16/2017 7,923.25 2642 -A BUDGETTREE SERVICE INC 26664 12/19/2017 1,800.00 96,498.61 YTDActuals 49,634.86 Encumbered 19,545.53 Remaining Budget