Page 97 - City of Westlake FY20 Budget

ALL FUNDS - ALL SOURCES and USES

Combining Revenues, Expenditures and Fund Balance
Fiscal Year 2019/2020
Internal Special Debt Capital
General Enterprise Service Revenue Service Project MUNICIPAL Academic TOTAL ALL
Fund Funds TOTAL Funds FUNDS
Funds Funds Funds Funds
REVENUES AND OTHER SOURCES
General Sales Tax $ 5,437,500 $ - $ - $ 1,812,500 $ - $ - $ 7,250,000 $ - $ 7,250,000
Property Tax 1,634,916 - - - 666,221 - 2,301,137 - 2,301,137
Charge for Services - 5,336,812 - - - - 5,336,812 - 5,336,812
Hotel Occupancy Tax - - - 853,684 - - 853,684 - 853,684
Beverage Tax 62,500 - - - - - 62,500 - 62,500
Franchise Fees 316,924 - - - - - 316,924 - 316,924
Permits and Fees Other 197,235 - 6,000 - - - 203,235 - 203,235
Permits and Fees Building 2,635,325 - - - - - 2,635,325 - 2,635,325
Permits and Fees Utility - 255,841 - - - - 255,841 - 255,841
Fines & Forfeitures 547,426 - - - - - 547,426 - 547,426
Investment Earnings 278,616 60,900 44,469 15,641 - 199,526 599,152 - 599,152
Contributions - - - 280,000 - - 280,000 - 280,000
Misc Income 26,600 17,850 - 4,112 - - 48,562 - 48,562
Total Revenues 11,137,042 5,671,403 50,469 2,965,937 666,221 199,526 20,690,598 - 20,690,598
Transfers In 67,225 - 478,370 - 1,988,489 1,171,360 3,705,444 - 3,705,444
Other Sources - - - - - - - - -
Total Other Sources 67,225 - 478,370 - 1,988,489 1,171,360 3,705,444 - 3,705,444
GF Academic Revenues - - - - - - - 9,717,933 9,717,933
GF Academic Other Resources - - - - - - - 90,000 90,000
Total Academic - - - - - - - 9,807,933 9,807,933
TOTAL REVENUES AND OTHER SOURCES $ 11,204,267 $ 5,671,403 $ 528,839 $ 2,965,937 $ 2,654,710 $ 1,370,886 $ 24,396,042 $ 9,807,933 $ 34,203,975
EXPENDITURES AND OTHER USES
Payroll Salaries $ 4,427,098 $ 9,195 $ - $ - $ - $ - $ 4,436,293 $ - $ 4,436,293
Payroll Transfer Out - 522,424 - 564,879 - - 1,087,303 - 1,087,303
Payroll Transfer In (1,087,303) - - - - - (1,087,303) - (1,087,303)
Payroll Insurance 794,092 - - - - - 794,092 - 794,092
Payroll Taxes 401,251 - - - - - 401,251 - 401,251
Payroll Retirement 537,424 - - - - - 537,424 - 537,424
Total Payroll & Related 5,072,563 531,619 - 564,879 - - 6,169,061 - 6,169,061
Capital Outlay 95,680 31,055 - - - - 126,735 - 126,735
Debt 256,430 408,027 - - 2,694,080 - 3,358,537 - 3,358,537
Economic Development - - - 36,982 - - 36,982 - 36,982
Leases and Rentals 36,759 1,500 - - - - 38,259 - 38,259
Public Notices 26,862 - - 20,615 - - 47,477 - 47,477
Rent & Utilities 770,340 179,721 - 82,791 - - 1,032,852 - 1,032,852
Repair & Maintenance 401,116 165,565 - - - - 566,681 - 566,681
Services 2,561,647 3,481,382 - 268,625 3,610 - 6,315,264 - 6,315,264
Supplies 248,054 7,040 - 11,762 - - 266,856 - 266,856
Travel & Training 235,190 10,420 - 7,294 - - 252,904 - 252,904
Transfer Out Operating 175,989 - - - - - 175,989 - 175,989
Total Operations & Maintenance 4,808,067 4,284,710 - 428,069 2,697,690 - 12,218,536 - 12,218,536
TOTAL OPERATING EXPENDITURES 9,880,629 4,816,329 - 992,948 2,697,690 - 18,387,596 - 18,387,596
Maintenance & Replacement - - 932,438 - - - 932,438 - 932,438
Capital Project Funds - - - - - 2,385,749 2,385,749 - 2,385,749
Total Capital - - 932,438 - - 2,385,749 3,318,187 - 3,318,187
Transfers Out 1,354,730 82,225 - 2,092,500 - - 3,529,455 - 3,529,455
Other Uses - - - - - - - - -
Total Other Uses 1,354,730 82,225 - 2,092,500 - - 3,529,455 - 3,529,455
TOTAL NON-OPERATING EXPENDITURES 1,354,730 82,225 932,438 2,092,500 - 2,385,749 6,847,642 - 6,847,642
GF Academic Expenditures - - - - - - - 9,572,502 9,572,502
GF Academic Other Uses - - - - - - - 90,000 90,000
Total Academic - - - - - - - 9,662,502 9,662,502
TOTAL EXPENDITURES AND OTHER USES $ 11,235,359 $ 4,898,554 $ 932,438 $ 3,085,448 $ 2,697,690 $ 2,385,749 $ 25,235,238 $ 9,662,502 $ 34,897,740
SUMMARY
Excess Revenus over (under) Expenditures (31,092) 772,849 (403,599) (119,511) (42,980) (1,014,863) (839,196) 145,431 (693,765)

PY Beginning Fund Balance 9,761,849 (189,342) 1,434,482 2,275,657 31,249 7,245,405 (641,892) 1,105,605 20,559,301
PY Revenues/Transfers (estimated) 14,758,012 7,001,651 2,427,253 12,294,550 2,705,331 2,388,826 (641,892) 8,923,313 38,627,224
PY Expenses/Transfers (estimated) (12,404,565) (6,649,006) (1,340,869) (12,317,156) (2,693,600) (3,010,728) (641,892) (8,775,132) (36,419,592)
Prior Year Adjustment (TWDB) 1,952,082
BEGINNING FUND BALANCE 12,115,299 2,115,385 2,520,867 999,266 42,980 6,623,503 24,417,301 1,253,786 25,671,087
ENDING FUND BALANCE $ 12,084,207 $ 2,888,234 $ 2,117,268 $ 879,755 $ (0) $ 5,608,640 $ 23,578,105 $ 1,399,217 $ 24,977,319

85