Page 228 - City of Westlake FY20 Budget

Utility Fund 500

Program Summary
Fiscal Year 2019/2020
Adopted Estimated Adopted FY 19/20 Adopted
Actuals Budget Budget Budget vs
FY 17/18 FY 18/19 FY 18/19 FY 19/20 FY 18/19 Estimated

REVENUES & OTHER SOURCES
General Sales Tax $ - $ - $ - $ - $ - 0%
Property Tax - - - - - 0%
Charge for Service 5,493,195 4,570,925 4,570,925 5,322,662 751,737 16%
Hotel Occupancy Tax - - - - - 0%
Beverage Tax - - - - - 0%
Franchise Fees - - - - - 0%
Permits & Fees Other - - - - - 0%
Permits & Fees Building - - - - - 0%
Permits & Fees Utility 306,066 274,441 229,241 255,841 26,600 12%
Fines & Forfeitures - - - - - 0%
Investment Earnings 55,153 55,300 55,300 55,300 - 0%
Contributions - - - - - 0%
Misc Income (4,443) 21,835 21,835 16,225 (5,610) -26%
Total Revenues 5,849,970 4,922,501 4,877,301 5,650,028 772,727 16%
Transfers In - - - - - 0%
Other Sources - 2,600,000 2,100,000 - (2,100,000) -100%
Total Other Sources - 2,600,000 2,100,000 - (2,100,000) -100%
TOTAL REVENUES & OTHER SOURCES $ 5,849,970 $ 7,522,501 $ 6,977,301 $ 5,650,028 $ (1,327,273) -19%
EXPENDITURES & OTHER USES
Payroll Salaries $ 19,698 $ - $ 9,195 $ 9,195 $ - 100%
Payroll Transfers In - - - - - 0%
Total Payroll and Related 19,698 - 9,195 9,195 - 0%
Debt 887,151 303,786 303,786 408,027 104,241 34%
Economic Development - - - - - 0%
Leases and Rentals - 500 500 1,500 1,000 200%
Payroll Transfers Out 456,849 559,024 547,472 522,424 (25,048) -5%
Repair & Maintenance 168,607 161,065 161,065 161,065 - 0%
Rent & Utilities 117,659 177,544 177,544 179,721 2,177 1%
Services 3,853,108 3,306,055 3,307,293 3,465,118 157,825 5%
Supplies 7,667 7,040 7,040 7,040 - 0%
Travel & Training 4,039 7,795 7,795 7,795 - 0%
Total Operations & Maintenance 5,495,081 4,522,810 4,512,496 4,752,690 240,194 5%
TOTAL OPERATING EXPENDITURES 5,514,779 4,522,810 4,521,691 4,761,885 240,194 5%
Capital Project Funds 907,166 1,711,840 1,996,332 - (1,996,332) -100%
Capital Outlay 27,228 31,055 31,055 31,055 - 0%
Maintenance & Replacment Funds - - - - - 0%
Total Capital and M&R Projects 934,394 1,742,895 2,027,387 31,055 (1,996,332) -98%
Transfers Out 77,716 81,539 81,539 82,225 686 1%
Other Sources - - - - - 0%
Total Other Uses 77,716 81,539 81,539 82,225 686 1%
TOTAL NON-OPERATING EXPENDITURES 1,012,111 1,824,434 2,108,926 113,280 (1,995,646) -95%
TOTAL EXPENDITURES & OTHER USES 6,526,890 6,347,244 6,630,617 4,875,165 (1,755,452) -26%

SUMMARY
Excess Revenues over(under) Expenditures (676,919) 1,175,257 346,684 774,863 428,179 -124%

Beginning Fund Balance 779,124 (424,904) (424,904) (78,220) 346,684 -82%
Prior Period Adjustment (TWDB) - - - 1,952,082 1,952,082 100%
RESTATED BEGINNING FUND BALANCE 779,124 (424,904) (424,904) 1,873,862 2,298,766 -541%
FUND BALANCE, ENDING 102,205 750,353 (78,220) 2,648,725 2,726,945 -3486%
Restricted/Assigned/Committed Funds 1,093,296 1,074,130 1,074,130 1,074,130 - 0%
UNASSIGNED FUND BALANCE, ENDING $ (991,091) $ (323,777) $ (1,152,350) $ 1,574,595 $ 2,726,945 -237%
RESTRICTED/ASSIGNED/COMMITED FUNDS
Hillwood $ 907,166 $ 888,000 $ 888,000 $ 888,000 $ - 0%
Deposits 186,130 186,130 186,130 186,130 $ - 0%

TOTAL RESTRICTED/ASSIGNED/COMMITTED FUNDS $ 1,093,296 $ 1,074,130 $ 1,074,130 $ 1,074,130 $ - 0%

216