Page 130 - City of Westlake FY20 Budget

FIVE YEAR FINANCIAL FORECAST

ALL MUNICIPAL FUNDS

Revision 06
ADOPTED ESTIMATED ADOPTED Projected Projected Projected Projected
FY 18‐19 FY 18‐19 FY 19‐20 FY 20‐21 FY 21‐22 FY 22‐23 FY 23‐24
#
# Citation Revenue dept 15 0% 620,789 475,003 475,003 475,250 475,496 475,743 475,990
# Citation Revenue dept 15 0% ‐ ‐ ‐ ‐ ‐ ‐ ‐
# Court Techology dept 15 0% 19,395 17,228 17,228 17,237 17,246 17,255 17,264
# Court Security dept 15 0% 14,492 12,927 12,927 12,934 12,940 12,947 12,954
# Warrant Fees dept 15 0% 41,820 39,338 39,338 39,358 39,379 39,399 39,420
# NSF Check Fees dept 15 0% 5,240 350 350 350 350 351 351
# Court Efficiency Fees dept 15 0% 1,879 2,580 2,580 2,581 2,583 2,584 2,585
# Law Enforcement Stds/Edu dept 15 0% 685 685 ‐ ‐ ‐ ‐ ‐
# Collection Fees dept 15 0% 11,245 ‐ ‐ ‐ ‐ ‐ ‐
# Court Fines and Forfeitures 715,545 548,111 547,426 547,710 547,994 548,279 548,563
#
# Beverage Tax dept 10 1% 62,500 62,500 62,500 63,125 63,756 64,394 65,038
# Entrada Hotel dept 10 1% ‐ ‐ ‐ ‐ 15,000 15,000 15,000
# Front 44 dept 10 1% ‐ ‐ ‐ ‐ ‐ 15,000 15,000
# Beverage Tax 62,500 62,500 62,500 63,125 78,756 94,394 95,038
#
# Interest Income dept 11 1% 175,339 275,000 275,000 277,750 280,528 283,333 286,166
# Interest Income dept 15 1% 3,616 3,616 3,616 3,652 3,689 3,726 3,763
# Interest Income 178,955 278,616 278,616 281,402 284,216 287,058 289,929
#
# Contributions dept 14 1% 12,240 12,240 ‐ ‐ ‐ ‐ ‐
# Contributions 12,240 12,240 ‐ ‐ ‐ ‐ ‐
#
# Transfer In ‐ UF 500 for Impact Fees linked to UF 66,539 66,539 67,225 6,181 6,305 6,431 6,560
# Transfers In 66,539 66,539 67,225 6,181 6,305 6,431 6,560
#
# TOTAL REVENUES 19,563,609 14,758,012 11,204,267 11,582,242 11,623,206 11,800,916 12,049,542
#
#
# Wages ‐ Full Time Salaries acct 41110 3% (3,472,786) (3,631,339) (4,041,078) (4,162,310) (4,287,179) (4,415,795) (4,548,269)
# Wages ‐ Part Time Salaries acct 41210 3% (290,025) (224,133) (125,924) (129,702) (133,593) (137,601) (141,729)
# Wages ‐ Overtime acct 41120 3% (121,725) (140,004) (149,015) (153,485) (158,090) (162,832) (167,717)
# Wages ‐ Premium Pay acct 41510 3% (21,476) (22,539) (23,382) (24,083) (24,806) (25,550) (26,317)
# Wages ‐ Fire Administrative acct 41620 0% ‐ ‐ ‐ ‐ ‐ ‐ ‐
# Wages ‐ Car Allowance acct 41640 0% (34,800) (28,200) (27,600) (27,600) (27,600) (27,600) (27,600)
# Wages ‐ Moving Allowance acct 41645 0% ‐ (14,215) ‐ ‐ ‐ ‐ ‐
# Wages ‐ Performance Pay acct 41647 0% (42,000) (42,500) (44,500) ‐ ‐ ‐ ‐
# Wages ‐ Phone Allowance acct 41641 0% (11,760) (12,609) (15,600) (15,600) (15,600) (15,600) (15,600)
# Other ‐ Transfers In VA & UF acct 42698 3% 1,114,192 1,158,443 1,087,303 1,119,922 1,153,520 1,188,125 1,223,769
# Payroll Salaries & Wages (2,880,380) (2,957,097) (3,339,795) (3,392,858) (3,493,348) (3,596,852) (3,703,462)
# Insurance ‐ Medical acct 42110 8% (711,266) (588,394) (728,373) (783,001) (841,726) (904,855) (972,719)
# Insurance ‐ Dental acct 42111 1% (32,862) (31,605) (33,742) (34,080) (34,421) (34,765) (35,112)
# Insurance ‐ Life acct 42130 0% (36,141) (26,860) (31,977) (32,135) (32,294) (32,454) (32,615)
# Taxes ‐ Social Security acct 42210 3% (247,663) (256,236) (272,505) (280,680) (289,101) (297,774) (306,707)
# Taxes ‐ Medicare acct 42220 3% (57,843) (59,447) (63,731) (65,643) (67,612) (69,640) (71,730)
# Taxes ‐ Unemployment acct 42510 1% (9,517) (9,430) (10,109) (10,210) (10,312) (10,415) (10,520)
# Taxes ‐ Workers Comp acct 42610 1% (33,966) (40,027) (54,906) (55,455) (56,009) (56,569) (57,135)
# Retirement ‐ TMRS acct 42310 3% (461,823) (511,491) (537,424) (553,547) (570,153) (587,258) (604,876)
# Retirement ‐ ICMA acct 42311 0% (24,270) (30,470) ‐ ‐ ‐ ‐ ‐
# Payroll Taxes, Insurance, Retirement (1,615,351) (1,553,959) (1,732,767) (1,814,751) (1,901,629) (1,993,731) (2,091,414)
# Total Payroll and Related (4,495,731) (4,511,055) (5,072,563) (5,207,609) (5,394,976) (5,590,584) (5,794,876)
#
# Planning & Development dept 12 0% (490) (750) (750) (750) (750) (750) (750)
# Fire Department dept 14 0% (27,900) (21,900) (71,900) (71,900) (71,900) (71,900) (71,900)
# Municipal Court dept 15 0% ‐ (1,500) (1,500) (1,500) (1,500) (1,500) (1,500)
# Public Works dept 16 0% (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000)
# Facilities dept 17 0% ‐ ‐ (7,800) (7,800) (7,800) (7,800) (7,800)
# Finance Department dept 18 0% (1,800) (1,800) (5,710) (5,710) (5,710) (5,710) (5,710)
# Parks & Recreations dept 19 0% (520) (520) (3,020) (3,020) (3,020) (3,020) (3,020)
# Total Capital Outlay (35,710) (31,470) (95,680) (95,680) (95,680) (95,680) (95,680)
#
# General Service Debt (thru 24/25) (BBP) acct 47120 0% (36,680) (36,680) (36,680) (36,680) (36,680) (36,680) (36,680)
# Westlake Reserve acct 47900 0% (315,000) (224,806) (219,750) (219,750) (219,750) (219,750) (219,750)
# Total Debt Expenditures (351,680) (261,486) (256,430) (256,430) (256,430) (256,430) (256,430)
#
# General Services dept 10 2% (6,160) (6,160) (6,160) (6,283) (6,409) (6,537) (6,668)
# Administrative dept 11 2% (295) (295) (295) (301) (307) (313) (319)
# Planning & Development dept 12 2% (1,134) (1,750) (1,750) (1,785) (1,821) (1,857) (1,894)
# Town Secretary dept 13 2% (2,705) (2,705) (2,705) (2,759) (2,814) (2,871) (2,928)
# Fire Department dept 14 2% (1,200) (1,200) (1,200) (1,224) (1,248) (1,273) (1,299)
# Municipal Court dept 15 2% (10,866) (10,866) (10,866) (11,083) (11,305) (11,531) (11,762)

118