Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017 Proposed Budget
CITY OF WEST UNIVERSITY PLACE 2017 DRAFT Proposed Opera Ɵ ng Budget GENERAL FUND GENERAL FUND STATEMENT OF REVENUES AND EXPENDITURES BY DEPARTMENT ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: AD VALOREM TAXES8,600,509 $ 9,336,883 $ 9,953,080 $ 9,958,080 $ 10,956,827 $ SALES TAXES1,051,890 1,117,336 1,150,000 1,112,700 1,115,300 FRANCHISE TAXES1,214,227 1,204,795 1,165,700 1,134,700 1,149,700 OTHER TAXES15,713 17,625 16,500 16,500 16,500 TOTAL TAXES 10,882,338 11,676,639 12,285,280 12,221,980 13,238,327 PERMITS, LICENSES AND FEES666,887 602,956 519,770 490,800 498,200 CHARGES FOR SERVICES2,448,489 2,606,792 2,145,750 2,452,740 2,155,050 FINES AND FORFEITURES176,117 185,853 187,300 116,600 118,300 INVESTMENT EARNINGS43,663 66,894 66,800 65,000 65,000 OTHER REVENUE271,936 363,152 353,756 365,826 352,646 TRANSFERS IN1,560,000 1,560,000 1,560,000 1,560,000 559,400 TOTAL REVENUES 16,049,430 17,062,286 17,118,656 17,272,946 16,986,923 EXPENDITURES BY DEPARTMENT: ADMINISTRATION1,172,416 1,529,563 1,405,564 1,014,020 1,319,365 FINANCE1,914,563 1,917,009 2,110,844 2,022,827 2,274,630 POLICE3,476,354 3,883,760 4,412,421 4,188,100 5,072,150 FIRE2,796,086 3,112,529 3,250,633 3,277,606 3,482,950 PUBLIC WORKS2,277,843 2,449,669 3,216,701 3,075,450 3,272,800 PARKS & RECREATION2,775,782 2,864,669 3,664,400 3,602,645 3,739,900 TRANSFERS OUT423,004 79,300 500,000 500,000 500,000 TOTAL EXPENDITURES 14,836,048 15,836,500 18,560,563 17,680,648 19,661,795 NET REVENUES (EXPENDITURES)1,213,382 1,225,787 (1,441,907) (407,702) (2,674,872) BEGINNING FUND BALANCE 4,455,899 5,669,281 4,064,499 6,895,068 6,487,366 ENDING FUND BALANCE 5,669,281 6,895,068 2,622,592 6,487,366 3,812,494 ASSIGNED*210,000 210,000 210,000 116,000 119,000 RESTRICTED**163,999 202,862 237,200 273,200 273,200 UNASSIGNED FUND BALANCE 5,295,282 $ 6,482,206 $ 2,175,392 $ 6,098,166 $ 3,420,294 $ * Assigned for City Manager's Contract ** Restricted for PEG fees ADMINISTRATION 6.71% FINANCE 11.57% POLICE 25.80% FIRE 17.71% PUBLIC WORKS 16.65% PARKS & RECREATION 19.02% TRANSFERS OUT 2.54% 2017 Budget by Department GENERAL FUND STATEMENT OF REVENUES AND EXPENDITURES BY ACCOUNT ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: AD VALOREM TAXES 8,600,509 $ 9,336,883 $ 9,953,080 $ 9,958,080 $ 10,956,827 $ SALES TAXES 1,051,890 1,117,336 1,150,000 1,112,700 1,115,300 FRANCHISE TAXES 1,214,227 1,204,795 1,165,700 1,134,700 1,149,700 OTHER TAXES 15,713 17,625 16,500 16,500 16,500 TOTAL TAXES 10,882,338 11,676,639 12,285,280 12,221,980 13,238,327 PERMITS, LICENSES AND FEES 666,887 602,956 519,770 490,800 498,200 FINES AND FORFEITURES 176,117 185,853 187,300 116,600 118,300 CHARGES FOR SERVICES 2,448,489 2,606,792 2,145,750 2,452,740 2,155,050 INVESTMENT EARNINGS 43,663 66,894 66,800 65,000 65,000 OTHER REVENUE 271,936 363,152 353,756 365,826 352,646 TRANSFERS IN 1,560,000 1,560,000 1,560,000 1,560,000 559,400 TOTAL REVENUES 16,049,430 $ 17,062,286 $ 17,118,656 $ 17,272,946 $ 16,986,923 $ EXPENDITURES: REGULAR WAGES $ 5,880,800 $ 6,695,981 $ 7,075,083 $ 6,383,700 $ 7,416,700 PART-TIME WAGES 383,996 355,044 448,600 471,800 526,300 ON CALL 20,805 20,778 26,800 19,200 26,100 OVERTIME 604,978 597,883 551,800 627,500 547,000 LONGEVITY 42,605 45,094 52,500 44,400 53,050 HEALTH & DENTAL 826,947 881,678 1,114,800 943,700 1,361,900 TMRS 674,905 895,108 928,100 942,100 1,116,000 FICA 507,594 552,764 618,100 572,300 654,400 WORKERS COMPENSATION 73,563 76,051 93,450 86,600 100,700 ALLOWANCES 77,413 77,755 81,300 81,170 79,320 RETIREE BENEFITS 189,996 190,000 209,000 209,000 240,400 OTHER BENEFITS 396,566 337,885 334,050 334,600 395,100 EMPLOYEE RELATIONS 22,571 24,076 22,500 21,550 22,300 EMPLOYEE TUITION - - - - - THIRD PARTY ADMINISTRATOR - - - - - RECRUITING & HIRING 200 - - - - PERSONNEL 9,702,939 10,750,096 11,556,083 10,737,620 12,539,270 OFFICE SUPPLIES 40,787 44,530 46,100 42,900 40,100 PRINTING - - - - - APPREHENSION & JAILING 273 1,699 1,000 1,000 1,000 OPERATING SUPPLIES 198,789 176,513 209,900 222,500 234,000 CONSTRUCTION MATERIALS - - - - - FUEL 86,638 55,208 83,400 58,300 86,300 EMERGENCY GENERATOR FUEL 2,319 3,684 - 3,700 3,70 0 TREATMENT CHEMICALS 26,321 26,979 31,600 31,510 31,800 MISCELLANEOUS - - - - - EQUIPMENT MAINTENANCE 90,477 88,424 98,500 93,430 89,000 VEHICLE MAINTENANCE 77,386 67,816 73,500 73,900 69,000 BUILDING & GROUNDS MAINTENANCE 188,398 155,064 173,000 163,000 152,000 SWIMMING POOL MAINTENANCE 97,004 68,043 118,300 107,375 82,600 DRAINAGE MAINTENANCE 10,677 22,077 20,000 20,000 20,000 STREET MAINTENANCE 51,643 51,294 50,000 70,000 75,000 TRAFFIC CONTROL MAINTENANCE 23,576 21,914 30,000 25,000 27,500 COMMUNICATION 86,101 125,977 110,700 96,100 99,500 ELECTRIC SERVICE 304,682 348,763 351,000 345,100 347,900 STREET LIGHTING - ELECTRIC SERVICE 76,030 84,639 83,800 83,800 83,800 GENERAL FUND STATEMENT OF REVENUES AND EXPENDITURES BY ACCOUNT ActualActualBudgetEstimatedBudget 20142015201620162017 NATURAL GAS SERVICE 41,808 25,890 33,000 29,000 29,500 OTHER UTILITIES - - - - - CONSULTANTS 17,227 84,162 92,400 80,000 61,000 LEGAL 167,222 163,510 145,000 145,000 185,000 EQUIPMENT LEASE/RENTAL 41,293 43,512 46,700 44,550 43,300 PROFESSIONAL DUES 27,521 28,526 33,740 31,550 33,600 PUBLICATIONS 5,871 16,172 18,050 12,800 12,895 TRAVEL & TRAINING 127,901 135,661 180,845 179,700 177,300 CREDIT CARD FEES - - 42,100 36,530 44,500 OTHER CONTRACTED SERVICES 847,837 839,894 928,820 933,820 926,780 INSTRUCTOR FEES 364,366 331,218 374,800 373,000 374,700 TRI-SPORTS 80,000 125,000 125,000 125,000 125,000 GENERAL LIABILITY INSURANCE 10,171 9,787 13,000 13,000 15,000 ERRORS & OMISSIONS 23,555 23,728 26,000 26,000 30,000 LAW ENFORCEMENT LIABILITY 14,717 14,161 16,000 16,000 16,000 CRIME COVERAGE FIDELITY 1,642 1,667 1,800 1,800 2,400 AUTO LIABILITY 29,837 30,962 35,000 35,000 40,000 AUTO PHYSICAL DAMAGE 17,011 18,133 20,000 20,000 25,000 UNDERGROUND STORAGE LIABILITY 749 771 800 827 850 REAL & PERSONAL PROPERTY 74,188 71,584 110,000 110,000 120,000 BOILER & MACHINERY - - - - - DEDUCTIBLE 4,917 1,369 10,000 10,000 10,000 COMMUNITY RELATIONS 33,726 30,143 51,700 49,000 47,300 BOARDS AND COMMITTEES 3,397 4,007 4,000 4,000 4,000 ELECTION EXPENSE - 11,465 13,000 13,000 13,000 LOSS ON DISPOSAL OF CITY PROPERTY - - - - - BAD DEBT EXPENSE - - - - - FURNITURE & EQUIP < $5000 12,260 46,860 58,500 85,805 35,700 FURNITURE & FIXTURES - - - - - TRUCKS 4,858 - 3,600 - - OTHER EQUIPMENT 39,743 25,550 63,625 53,625 231,400 CONSTRUCTION COSTS - 7,251 - - 30,00 0 OTHER CONSTRUCTION COSTS - - - - 16,000 TRANSFER TO FIRE SPECIAL REVENUE 4,000 - - 206 - TRANSFER TO CAPITAL PROJECT FUND 252,500 - - - - TRANSFER TO CAPITAL RESERVE FUND 215,004 79,300 500,000 500,000 500,000 TRANSFER TO VEHICLE REPLACEMENT FUND 214,500 332,000 336,000 336,000 331,300 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 1,033,500 1,152,500 1,330,600 1,330,600 1,301,100 TRANSFER TO EQUIPMENT REPLACEMENT FUND 55,500 89,000 866,000 866,000 851,700 CONTINGENCY 5,185 - 43,600 43,600 45,000 OPERATING 5,133,108 $ 5,086,404 $ 7,004,480 $ 6,943,028 $ 7,122,525 $ TOTAL EXPENDITURES 14,836,048 15,836,500 $ 18,560,563 $ 17,680,648 $ 19,661,795 $ AD V A L O R E M T A X E S 64 % SA L E S T A X E S 7% FR A N C H I S E T A X E S 7% OTHER TAXES 0%PERMITS, LICENSES AND FEES 3%CHARGES FOR SERVICES 13%FINES AND FORFEITURES 1% IN V E S T M E N T EA R N I N G S 0% OT H E R R E V E N U E 2% TR A N S F E R S I N 3% 20 1 7 P r o j e c t e d G e n e r a l F u n d R e v e n u e PE R S O N N E L 63 . 7 7 % IN S U R A N C E 1. 3 2 % EL E C T R I C I T Y & N A T U R A L GA S 2. 3 5 % VE H I C L E RE P L A C E M E N T 1. 8 1 % TE C H N O L O G Y MA N A G E M E N T 6. 6 2 % EQ U I P M E N T RE P L A C E M E N T 4. 3 3 % MA I N T E N A N C E 2. 6 2 % FU E L 0. 4 4 % OT H E R O P E R A T I N G 11 . 0 5 % TR A N S F E R S 4. 2 3 % CA P I T A L 1. 5 9 % 20 1 7 G e n e r a l F u n d E x p e n d i t u r e s b y T y p e ActualActualBudgetEstimatedBudget Account Description20142015201620162017 Administration Personnel765,648$ 1,087,688 $ 923,474 $ 536,720 $ 797,470 $ Operating charges 208,321 234,287 280,150 283,800 288,795 Capital - - - - - Total 973,969 1,321,976 1,203,624 820,520 1,086,265 Council Personnel 15,613 15,868 15,600 15,000 15,600 Operating charges 182,835 191,719 186,340 178,500 217,500 Total 198,448 207,587 201,940 193,500 233,100 Total Department 1,172,416$ 1,529,563 $ 1,405,564 $ 1,014,020 $ 1,319,365 $ Administration Department Staffing Schedule 2016 2017 POSITION GRADEBUDGETBUDGETMINIMUMMAXIMUM Administration City Manager VI 1 1 HR Director II 1 1 103,232 154,847 City Secretary I 1 1 98,316 147,474 Communications Manager 112 1 - 83,531 125,296 Executive Assistant/Deputy City Secretary 207 1 1 51,418 71,984 HR Generalist 205 1 1 40,830 57,162 Total Administration Department 6 5 ADMINISTRATION DEPARTMENT SALARY RANGE Determined by Council ADMINISTRATION DEPARTMENT Administration Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 560,380 $ 839,439 $ 667,874 $ 363,900 $ 554,800 PART-TIME WAGES 9,420 9,916 15,000 15,000 15,000 ON CALL 345 - - - - OVERTIME 769 3,494 3,500 2,700 3,500 LONGEVITY 2,129 1,385 2,200 2,200 2,550 HEALTH & DENTAL 55,648 48,597 61,100 35,800 61,800 TMRS 60,164 104,928 83,200 51,800 80,200 FICA 37,297 44,056 52,200 30,700 44,100 WORKERS COMPENSATION 1,207 1,127 1,600 900 1,500 ALLOWANCES 24,555 20,768 25,000 22,920 22,920 OTHER BENEFITS 4,539 4,643 4,300 3,300 3,600 EMPLOYEE RELATIONS 8,997 9,334 7,500 7,500 7,500 RECRUITING & HIRING 200 - - - - PERSONNEL 765,648 1,087,688 923,474 536,720 797,470 OFFICE SUPPLIES 7,769 10,068 5,000 5,000 7,000 COMMUNICATION 38,364 77,731 50,000 50,000 50,000 CONSULTANTS 1,512 - 1,400 3,000 5,000 EQUIPMENT LEASE/RENTAL 8,159 9,097 11,000 11,000 10,000 PROFESSIONAL DUES 6,114 7,201 6,350 6,350 7,250 PUBLICATIONS 1,936 3,758 3,000 1,650 1,245 TRAVEL & TRAINING 22,370 13,403 32,700 32,700 25,600 OTHER CONTRACTED SERVICES 25,610 - - - - COMMUNITY RELATIONS 2,105 1,178 1,600 5,000 5,000 ELECTION EXPENSE - 150 - - - TRANSFER TO TECHNOLOGY MANAGEMENT FUND 89,196 111,700 125,500 125,500 132,700 CONTINGENCY 5,185 - 43,600 43,600 45,000 OPERATIN G 208,321 234,287 280,150 283,800 288,795 ADMINISTRATION DIVISION TOTA L 973,969 $ 1,321,976 $ 1,203,624 $ 820,520 $ 1,086,265 $ ADMINISTRATION DEPARTMENT City Council Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description20142015201620162017 REGULAR WAGES $ 14,453 $ 14,741 $ 14,400 $ 13,900 $ 14,400 FICA 1,106 1,128 1,100 1,100 1,100 WORKERS COMPENSATION - - 100 - 100 EMPLOYEE RELATIONS 55 - - - - PERSONNEL 15,613 15,868 15,600 15,000 15,600 COMMUNICATION 1,147 - - - - LEGAL 167,222 163,510 145,000 145,000 185,000 PROFESSIONAL DUES 855 1,183 4,040 2,500 2,500 PUBLICATIONS 641 5,201 6,800 3,000 3,000 TRAVEL & TRAINING 3,274 6,081 10,000 10,000 9,000 COMMUNITY RELATIONS 9,697 4,429 7,500 5,000 5,000 ELECTION EXPENSE - 11,315 13,000 13,000 13,000 OPERATING 182,835 191,719 186,340 178,500 217,500 CITY COUNCIL DIVISION TOTAL 198,448 $ 207,587 $ 201,940 $ 193,500 $ 233,100 $ ActualActualBudgetEstimatedBudget Account Description20142015201620162017 Finance Personnel380,072$ 416,188 $ 457,500 $ 413,100 $ 500,100 $ Operating charges 363,672 390,081 433,915 421,720 435,730 Capital - 1,200 - 500 - Total 743,744 807,469 891,415 835,320 935,830 Municipal Court Personnel 214,664 225,876 246,879 231,000 249,500 Operating charges 15,586 14,915 28,850 15,580 28,850 Total 230,250 240,791 275,729 246,580 278,350 City-Wide Charges Operating charges 940,569 868,750 943,700 940,927 1,060,450 Total 940,569 868,750 943,700 940,927 1,060,450 Total Department 1,914,563$ 1,917,009 $ 2,110,844 $ 2,022,827 $ 2,274,630 $ Finance Department Staffing Schedule 2016 2017 POSITION GRADEBUDGETBUDGETMINIMUMMAXIMUM Finance Accounting Finance Director III 1 1 108,393 162,590 Controller 112 1 1 83,531 125,296 Treasurer 112 1 1 83,531 125,296 Accounting Specialist2041 1 36,985 51,780 Municipal Court Court Clerk2081 1 56,232 78,724 Total Finance 5 5 FINANCE DEPARTMENT SALARY RANGE Finance Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 277,301 $ 300,262 $ 321,200 $ 294,500 $ 340,300 PART-TIME WAGES 9,029 9,705 23,400 12,000 23,400 LONGEVITY 730 910 1,100 800 900 HEALTH & DENTAL 29,108 31,188 33,500 31,300 46,900 TMRS 29,332 36,990 39,400 39,000 47,800 FICA 21,843 23,299 26,200 23,100 27,900 WORKERS COMPENSATION 545 622 700 700 800 ALLOWANCES 6,869 6,897 6,900 6,600 6,900 OTHER BENEFITS 2,563 2,652 2,100 2,100 2,200 EMPLOYEE RELATIONS 2,752 3,664 3,000 3,000 3,000 PERSONNEL 380,072 416,188 457,500 413,100 500,100 OFFICE SUPPLIES 5,602 5,820 5,000 5,000 5,000 EQUIPMENT MAINTENANCE 465 - 500 500 500 COMMUNICATION 2,867 8,486 11,500 2,000 2,000 EQUIPMENT LEASE/RENTAL 4,082 5,844 6,000 4,000 4,000 PROFESSIONAL DUES 1,742 2,543 2,000 2,100 2,700 PUBLICATIONS 493 461 200 200 400 TRAVEL & TRAINING 15,679 4,751 12,295 11,500 11,500 OTHER CONTRACTED SERVICES 244,446 262,776 268,420 268,420 273,630 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 88,296 99,400 128,000 128,000 136,000 OPERATIN G 363,672 390,081 433,915 421,720 435,730 FURNITURE & EQUIP <$5000 - 1,200 - 500 - CAPITAL OUTLA Y - 1,200 - 500 - FINANCE DIVISION TOTAL 743,744 $ 807,469 $ 891,415 $ 835,320 $ 935,830 $ FINANCE DEPARTMENT Municipal Court Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description20142015201620162017 REGULAR WAGES $ 160,680 $ 162,518 $ 174,079 $ 132,000 $ 120,200 PART-TIME WAGES 124 4,131 - 42,200 50,600 OVERTIME 4,448 8,255 8,000 7,400 8,000 LONGEVITY 2,320 2,440 2,600 1,600 2,700 HEALTH & DENTAL 21,072 18,497 23,900 15,700 27,100 TMRS 12,008 15,275 20,500 17,800 23,200 FICA 12,228 12,952 14,000 12,400 13,900 WORKERS COMPENSATION 333 349 400 400 400 OTHER BENEFITS 1,451 1,459 3,400 1,500 3,400 PERSONNEL 214,664 225,876 246,879 231,000 249,500 OFFICE SUPPLIES 1,917 489 2,500 500 2,500 COMMUNICATION 295 315 1,500 200 1,500 PROFESSIONAL DUES 413 520 600 600 600 PUBLICATIONS 231 610 750 750 750 TRAVEL & TRAINING 2,968 4,001 3,000 3,000 3,000 CREDIT CARD FEES - - 10,000 30 10,000 OTHER CONTRACTED SERVICES 9,761 8,980 10,500 10,500 10,500 OPERATING 15,586 14,915 28,850 15,580 28,850 MUNICIPAL COURT DIVISION TOTA L 230,250 $ 240,791 $ 275,729 $ 246,580 $ 278,350 $ FINANCE DEPARTMENT City-Wide Division Budget Detail by Line Item ActualActualBudgetEstimatedBudget Account Description20142015201620162017 RETIREE BENEFITS $ 189,996 $ 190,000 $ 209,000 $ 209,000 $ 240,400 OTHER BENEFITS 328,800 266,000 266,300 266,300 325,000 ELECTRIC SERVICE 141,865 168,174 166,000 163,200 166,000 STREET LIGHTING - ELECTRIC SERVICE 76,030 84,639 83,800 83,800 83,800 NATURAL GAS SERVICE 41,808 1,937 2,000 2,000 2,000 GENERAL LIABILITY INSURANCE 10,171 9,787 13,000 13,000 15,000 ERRORS & OMISSIONS 23,555 23,728 26,000 26,000 30,000 CRIME COVERAGE FIDELITY 1,642 1,667 1,800 1,800 2,400 AUTO LIABILITY 29,837 30,962 35,000 35,000 40,000 AUTO PHYSICAL DAMAGE 17,011 18,133 20,000 20,000 25,000 UNDERGROUND STORAGE LIABILITY 749 771 800 827 850 REAL & PERSONAL PROPERTY 74,188 71,584 110,000 110,000 120,000 DEDUCTIBLE 4,917 1,369 10,000 10,000 10,000 CITY-WIDE DIVISION TOTAL 940,569 $ 868,750 $ 943,700 $ 940,927 $ 1,060,450 $ FINANCE DEPARTMENT ActualActualBudgetEstimatedBudget Account Description20142015201620162017 Patrol Personnel2,021,603$ 2,315,906 $ 2,763,975 $ 2,584,000 $ 3,093,700 $ Operating charges714,890 721,060 791,250 803,000 790,850 Capital6,437 - 5,000 5,000 205,000 Total 2,742,930 3,036,966 3,560,225 3,392,000 4,089,550 Support Services Personnel732,200 846,119 849,696 793,600 979,800 Operating charges1,225 675 2,500 2,500 2,800 Total733,425 846,794 852,196 796,100 982,600 Total Department 3,476,354$ 3,883,760 $ 4,412,421 $ 4,188,100 $ 5,072,150 $ Police Department Staffing Schedule 2016 2017 POSITION GRADEBUDGETBUDGETMINIMUMMAXIMUM Police Department Patrol Police Chief III1 1 108,393 162,590 Police Captain P-61 1 93,934 126,811 Police Sergeant P-45 5 74,635 100,758 Police Officer P-217 19 58,549 79,042 Support Services Supervisor 2081 1 56,232 78,724 Support Services Administrative Assistant 2052 2 40,830 57,162 Emergency Dispatcher 2058 9 40,830 57,162 Total Police 35 38 POLICE DEPARTMENT SALARY RANGE ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 1,269,809 $ 1,422,730 $ 1,776,425 $ 1,549,500 $ 1,950,900 OVERTIME 248,815 301,170 245,000 321,000 245,000 LONGEVITY 7,597 8,195 9,800 5,500 10,200 HEALTH & DENTAL 176,936 190,086 270,800 228,300 346,000 TMRS 158,081 212,050 245,000 266,800 304,500 FICA 113,287 129,139 154,300 154,400 168,900 WORKERS COMPENSATION 23,165 27,032 35,400 32,200 38,000 ALLOWANCES 6,671 6,848 8,900 6,600 8,900 OTHER BENEFITS 15,237 16,356 15,850 17,200 18,800 EMPLOYEE RELATIONS 2,006 2,300 2,500 2,500 2,500 PERSONNEL 2,021,603 2,315,906 2,763,975 2,584,000 3,093,700 OFFICE SUPPLIES 8,127 8,200 8,600 8,600 8,600 APPREHENSION & JAILING 273 1,699 1,000 1,000 1,000 OPERATING SUPPLIES 72,622 43,093 35,000 55,000 55,000 FUEL 49,670 33,563 48,600 35,000 49,000 EQUIPMENT MAINTENANCE 186 6,529 5,000 5,000 5,000 VEHICLE MAINTENANCE 20,091 25,072 26,000 30,000 25,000 COMMUNICATION 1,399 1,266 2,000 2,000 2,000 CONSULTANTS 10,138 18,358 6,000 7,000 6,000 EQUIPMENT LEASE/RENTAL 6,551 7,213 6,000 6,000 6,000 PROFESSIONAL DUES 2,408 1,753 2,050 2,400 2,050 PUBLICATIONS 144 4,219 5,000 5,000 5,000 TRAVEL & TRAINING 17,447 35,578 35,000 35,000 35,000 LAW ENFORCEMENT LIABILITY 14,717 14,161 16,000 16,000 16,000 COMMUNITY RELATIONS 1,023 854 1,000 1,000 1,000 TRANSFER TO CAPITAL PROJECT FUND 15,000 - - - - TRANSFER TO VEHICLE REPLACEMENT FUND 102,000 98,000 103,000 103,000 99,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 393,096 421,500 491,000 491,000 475,200 OPERATING 714,890 721,060 791,250 803,000 790,850 FURNITURE & EQUIP <$5000 - - 5,000 5,000 5,000 OTHER EQUIPMENT 6,437 - - - 200,000 CAPITAL 6,437 - 5,000 5,000 205,000 PATROL DIVISION TOTAL 2,742,930$ 3,036,966$ 3,560,225$ 3,392,000$ 4,089,550$ POLICE DEPARTMENT Patrol Division Line Item Budget Support Services Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description20142015201620162017 REGULAR WAGES $ 455,307 $ 512,756 $ 539,796 $ 468,000 $ 601,600 ON CALL 767 2,400 5,500 800 5,500 OVERTIME 95,059 112,545 80,000 113,500 80,000 LONGEVITY 3,665 4,339 4,900 4,900 5,400 HEALTH & DENTAL 67,445 78,087 85,800 75,700 128,800 TMRS 57,425 77,333 75,100 77,100 94,700 FICA 41,989 47,776 47,400 45,000 52,600 WORKERS COMPENSATION 1,070 1,231 1,300 1,600 1,500 ALLOWANCES 2,049 2,057 2,100 2,100 2,100 OTHER BENEFITS 7,426 7,595 7,800 4,900 7,600 PERSONNEL 732,200 846,119 849,696 793,600 979,800 TRAVEL & TRAINING 1,225 675 2,500 2,500 2,800 OPERATING 1,225 675 2,500 2,500 2,800 COMMUNICATIONS DIVISION TOTAL 733,425$ 846,794$ 852,196$ 796,100$ 982,600$ POLICE DEPARTMENT ActualActualBudgetEstimatedBudget Account Description20142015201620162017 Fire Personnel2,355,669 $ 2,510,367 $ 2,626,108 $ 2,666,400 $ 2,863,200 $ Operating charges410,256 584,437 586,900 583,806 597,350 Capital30,161 17,725 37,625 27,400 22,400 Total2,796,086 3,112,529 3,250,633 3,277,606 3,482,950 Total Department 2,796,086 $ 3,112,529 $ 3,250,633 $ 3,277,606 $ 3,482,950 $ Fire Department Staffing Schedule 20162017 POSITIONGRADEBUDGETBUDGETMINIMUMMAXIMUM Fire Department Fire ChiefIII1 1 108,393 162,590 Fire Marshal/Assistant Chief 1131 1 88,153 132,228 Fire CaptainF-43 3 86,594 103,914 Fire LieutenantF-33 3 74,652 103,120 Firefighter/ParamedicF-115 15 54,745 75,547 Total Fire Department 23 23 FIRE DEPARTMENT SALARY RANGE Fire Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 1,506,011 $ 1,668,388 $ 1,702,608 $ 1,780,600 $ 1,828,600 OVERTIME 224,016 135,661 170,000 140,000 170,000 LONGEVITY 13,200 14,145 15,500 15,500 16,700 HEALTH & DENTAL 252,480 282,359 321,000 304,900 365,400 TMRS 180,670 222,758 226,900 235,800 278,100 FICA 128,590 133,633 142,900 135,000 154,200 WORKERS COMPENSATION 22,124 23,885 22,100 25,400 24,900 ALLOWANCES 8,917 8,954 8,900 8,600 8,900 OTHER BENEFITS 16,622 18,242 13,700 18,100 13,900 EMPLOYEE RELATIONS 3,039 2,342 2,500 2,500 2,500 PERSONNEL 2,355,669 2,510,367 2,626,108 2,666,400 2,863,200 OFFICE SUPPLIES 1,544 2,675 3,000 3,000 3,000 OPERATING SUPPLIES 33,128 41,611 42,000 42,000 45,000 FUEL 10,790 7,859 12,800 7,000 10,500 EQUIPMENT MAINTENANCE 10,511 15,495 16,000 16,000 16,000 VEHICLE MAINTENANCE 38,436 28,566 25,000 28,000 28,000 COMMUNICATION 370 215 500 500 500 PROFESSIONAL DUES 5,236 4,798 4,800 4,800 4,800 PUBLICATIONS 1,304 1,378 1,500 1,500 1,500 TRAVEL & TRAINING 30,500 26,671 26,000 26,000 33,700 OTHER CONTRACTED SERVICES 42,906 35,498 33,800 33,300 34,550 COMMUNITY RELATIONS 2,428 3,471 4,000 4,000 4,000 TRANSFER TO FIRE SPECIAL REVENUE 4,000 - - 206 - TRANSFER TO VEHICLE REPLACEMENT FUND 33,996 159,000 159,000 159,000 158,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 139,608 168,200 196,000 196,000 210,400 TRANSFER TO EQUIPMENT REPLACEMENT FUND 55,500 89,000 62,500 62,500 47,400 OPERATING 410,256 584,437 586,900 583,806 597,350 FURNITURE & EQUIP <$5000 - - 1,500 1,275 - OTHER EQUIPMENT 30,161 17,725 36,125 26,125 22,400 CAPITAL 30,161 17,725 37,625 27,400 22,400 FIRE DIVISION TOTAL 2,796,086 $ 3,112,529 $ 3,250,633 $ 3,277,606 $ 3,482,950 $ FIRE DEPARTMENT ActualActualBudgetEstimatedBudget Account Description20142015201620162017 Public Works Administration Personnel236,684 $ 272,385 $ 240,619 $ 234,200 $ 256,500 $ Operating charges105,293 188,668 158,600 157,000 151,600 Capital- - - - - Total341,977 461,053 399,219 391,200 408,100 Development Services Personnel 332,170 369,447 421,839 392,300 451,700 Operating charges 17,257 25,568 26,650 25,500 25,300 Capital - - - - 2,000 Total 349,427 395,015 448,489 417,800 479,000 Streets & Drainage Personnel 110,561 53,141 138,500 125,300 141,900 Operating charges 88,962 100,595 278,700 296,700 307,700 Capital - - - - 4,000 Total 199,523 153,736 417,200 422,000 453,600 Facilities Maintenance Personnel 176,282 188,039 209,056 209,800 207,400 Operating charges 412,301 408,140 606,900 607,800 590,900 Capital - 7,825 27,500 27,500 21,000 Total 588,583 604,004 843,456 845,100 819,300 General Services Personnel 368,592 401,811 424,864 368,800 445,700 Operating charges 162,879 149,599 327,500 309,400 292,000 Capital 11,835 7,251 - - 30,000 Total 543,306 558,661 752,364 678,200 767,700 Planning Personnel 193,946 196,881 213,973 200,950 224,700 Operating charges 61,081 78,691 142,000 120,200 110,400 Capital - 1,627 - - 10,000 Total 255,026 277,200 355,973 321,150 345,100 Total Department 2,277,843 $ 2,449,669 $ 3,216,701 $ 3,075,450 $ 3,272,800 $ PUBLIC WORKS DEPARTMENT Public Works Staffing Schedule (General Fund) 2016 2017 POSITION GRADEBUDGETBUDGETMINIMUMMAXIMUM Public Works Public Works Administration Asst. City Manager\Public Works Dir IV 1 - 113,813 170,719 Public Works Director III - 1 108,393 162,590 Administrative Assistant 205 1 1 40,830 57,162 Development Services Chief Building Official 112 1 1 83,531 125,296 Building Inspector 206 2 2 45,644 63,902 Permit Technician 204 2 2 36,985 51,780 Operations Maintenance Worker III 204 1 1 36,985 51,780 Maintenance Worker I 202 1 1 30,635 42,889 Facilities Maintenance Facilities Maintenance Mgr 111 1 1 70,568 105,852 Facilities Maintenance Tech 205 1 1 40,830 57,162 General Services Asst Director - Public Works113 1 - 88,153 132,228 General Services Superintendent112 - 1 83,531 125,296 Lead Traffic Technician 206 1 1 45,644 63,902 Lead Mechanic 207 1 1 51,418 71,984 Mechanic 204 1 1 36,985 51,780 Traffic Technician 203 1 1 33,141 46,397 Planning City Planner 112 1 1 83,531 125,296 Code Enforcement/ACO 205 1 1 40,830 57,162 Total Public Works 18 18 SALARY RANGE PUBLIC WORKS DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 177,956 $ 204,934 $ 165,019 $ 174,300 $ 174,200 OVERTIME 371 538 2,000 - - LONGEVITY 1,000 1,120 1,300 1,300 1,800 HEALTH & DENTAL 13,180 12,337 24,100 6,600 27,300 TMRS 19,203 26,017 20,800 23,700 25,200 FICA 12,512 13,459 12,700 13,900 13,500 WORKERS COMPENSATION 393 429 400 400 400 ALLOWANCES 6,869 7,097 6,900 7,800 6,900 OTHER BENEFITS 1,706 1,786 1,400 1,200 1,400 EMPLOYEE RELATIONS 3,494 4,668 6,000 5,000 5,800 PERSONNEL 236,684 272,385 240,619 234,200 256,500 OFFICE SUPPLIES 7,967 10,411 11,000 9,500 3,000 OPERATING SUPPLIES 789 1,953 1,300 1,300 2,300 EQUIPMENT MAINTENANCE - - 1,000 - - COMMUNICATION 716 54 3,000 2,000 3,000 ELECTRIC SERVICE 6,525 6,239 7,000 6,500 6,500 CONSULTANTS 5,577 64,902 35,000 35,000 35,000 EQUIPMENT LEASE/RENTAL 6,802 7,345 7,200 7,200 7,200 PROFESSIONAL DUES 2,229 2,424 2,100 2,000 2,000 PUBLICATIONS 365 - - - - TRAVEL & TRAINING 731 3,857 8,500 8,000 6,500 CREDIT CARD FEES - - 8,000 9,500 9,500 OTHER CONTRACTED SERVICES 270 23,420 23,500 25,000 20,000 COMMUNITY RELATIONS 722 64 1,000 1,000 500 TRANSFER TO CAPITAL RESERVE FUND 15,000 - - - - TRANSFER TO TECHNOLOGY MANAGEMENT FUND 57,600 68,000 50,000 50,000 56,100 OPERATING 105,293 188,668 158,600 157,000 151,600 PUBLIC WORKS ADMINISTRATION DIVISION TOTAL 341,977 $ 461,053 $ 399,219 $ 391,200 $ 408,100 $ Public Works Administration Division Line PUBLIC WORKS DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 248,501 $ 270,030 $ 299,189 $ 285,400 $ 306,000 OVERTIME 3,853 5,614 4,900 6,800 3,500 LONGEVITY 2,349 2,505 2,800 1,800 2,000 HEALTH & DENTAL 28,269 29,629 48,200 31,100 66,900 TMRS 26,464 34,095 37,100 38,400 43,100 FICA 16,849 21,012 23,300 22,400 23,800 WORKERS COMPENSATION 846 1,026 1,150 800 1,200 ALLOWANCES 1,964 2,057 2,100 2,000 2,100 OTHER BENEFITS 3,003 3,481 3,100 3,600 3,100 EMPLOYEE RELATIONS 73 - - - - PERSONNEL 332,170 369,447 421,839 392,300 451,700 OFFICE SUPPLIES 1,387 909 1,000 1,000 1,000 OPERATING SUPPLIES 2,315 3,998 3,400 3,000 3,000 FUEL 1,332 1,029 1,300 1,100 1,500 VEHICLE MAINTENANCE 1,489 417 1,500 1,000 1,200 COMMUNICATION 366 1,101 1,000 1,000 1,000 EQUIPMENT LEASE/RENTAL 1,565 1,595 1,800 1,800 1,800 PROFESSIONAL DUES 664 492 800 800 800 PUBLICATIONS 116 150 300 300 500 TRAVEL & TRAINING 3,031 2,371 6,550 6,500 6,500 OTHER CONTRACTED SERVICES 452 8,363 700 700 700 COMMUNITY RELATIONS 41 644 3,300 3,300 2,300 TRANSFER TO VEHICLE REPLACEMENT FUND 4,500 4,500 5,000 5,000 5,000 OPERATING 17,257 25,568 26,650 25,500 25,300 FURNITURE & EQUIP <$5000 - - - - 2,000 CAPITAL - - - - 2,000 DEVELOPMENT SERVICES DIVISION TOTAL 349,427 $ 395,015 $ 448,489 $ 417,800 $ 479,000 $ Development Services Division Line Item PUBLIC WORKS DEPARTMENT Streets & Drainage Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 68,471 $ 31,158 $ 78,700 $ 72,600 $ 79,600 ON CALL 3,167 1,587 3,800 2,300 3,300 OVERTIME 10,174 5,026 10,000 6,500 8,000 LONGEVITY 502 200 400 300 400 HEALTH & DENTAL 10,488 6,201 24,100 23,500 27,300 TMRS 8,483 4,620 10,800 10,600 12,400 FICA 6,245 2,879 6,800 6,100 6,900 WORKERS COMPENSATION 1,793 833 2,200 2,000 2,300 OTHER BENEFITS 1,200 637 1,700 1,400 1,700 EMPLOYEE RELATIONS 40 - - - - PERSONNEL 110,561 53,141 138,500 125,300 141,900 OPERATING SUPPLIES 504 996 1,000 1,500 1,500 FUEL 3,614 1,608 3,500 2,500 4,100 EQUIPMENT MAINTENANCE - 90 500 500 500 DRAINAGE MAINTENANCE 10,677 22,077 20,000 20,000 20,000 STREET MAINTENANCE 51,643 51,294 50,000 70,000 75,000 MAINTENANCE - - - - 1,000 COMMUNICATION - - 1,500 1,000 500 TRAVEL & TRAINING - - 300 300 300 SERVICES 14,520 15,657 12,500 12,500 15,000 COMMUNITY RELATIONS - 873 2,000 1,000 1,000 TRANSFER TO VEHICLE REPLACEMENT FUND 8,004 8,000 8,000 8,000 8,000 TRANSFER TO EQUIPMENT REPLACEMENT FUND - - 179,400 179,400 180,800 OPERATING 88,962 100,595 278,700 296,700 307,700 OTHER EQUIPMENT - - - - 4,000 CAPITAL - - - - 4,000 DIVISION TOTAL 199,523$ 153,736$ 417,200$ 422,000$ 453,600$ PUBLIC WORKS DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 118,345 $ 124,976 $ 135,956 $ 133,700 $ 135,900 PART-TIME WAGES - - 6,000 - - ON CALL 2,771 2,721 2,800 2,700 2,800 OVERTIME 4,045 2,854 4,000 3,000 3,000 LONGEVITY 670 790 900 900 600 HEALTH & DENTAL 21,256 23,305 24,000 33,400 27,200 TMRS 13,191 16,249 17,100 18,500 19,600 FICA 9,393 9,800 11,200 10,500 11,200 WORKERS COMPENSATION 2,812 3,038 3,200 3,600 3,200 ALLOWANCES 2,049 2,057 2,100 2,000 2,100 OTHER BENEFITS 1,484 1,533 1,800 1,500 1,800 EMPLOYEE RELATIONS 267 715 - - - PERSONNEL 176,282 188,039 209,056 209,800 207,400 OFFICE SUPPLIES - 122 400 200 400 OPERATING SUPPLIES 1,301 2,018 4,000 4,000 3,800 FUEL 1,154 570 900 500 600 EMERGENCY GENERATOR FUEL 2,319 3,684 - 3,700 3,700 EQUIPMENT MAINTENANCE 45,320 45,936 55,000 53,500 52,500 VEHICLE MAINTENANCE 714 463 1,500 1,000 1,100 BUILDING & GROUNDS MAINTENANCE 59,016 58,189 58,000 58,000 48,000 PROFESSIONAL DUES 546 620 700 500 500 TRAVEL & TRAINING 6,186 5,346 5,400 5,400 5,000 OTHER CONTRACTED SERVICES 274,936 270,492 281,000 281,000 270,000 TRANSFER TO VEHICLE REPLACEMENT FUND 9,504 8,000 8,000 8,000 8,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 11,304 12,700 19,500 19,500 23,300 TRANSFER TO EQUIPMENT REPLACEMENT FUND - - 172,500 172,500 174,000 OPERATING 412,301 408,140 606,900 607,800 590,900 OTHER EQUIPMENT - 7,825 27,500 27,500 5,000 OTHER CONSTRUCTION COSTS - - - - 16,000 CAPITAL - 7,825 27,500 27,500 21,000 FACILITY MAINTENANCE TOTAL 588,583 $ 604,004 $ 843,456 $ 845,100 $ 819,300 $ Facility Maintenance Division Line Item Budget PUBLIC WORKS DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 240,201 $ 259,445 $ 272,264 $ 237,300 $ 284,700 ON CALL 10,946 11,415 11,000 10,600 11,000 OVERTIME 7,402 8,634 8,000 9,700 6,000 LONGEVITY 1,950 2,040 3,000 1,600 2,000 HEALTH & DENTAL 50,526 51,515 57,000 41,200 65,200 TMRS 27,075 34,840 36,500 34,300 40,200 FICA 18,826 20,665 23,100 19,700 22,400 WORKERS COMPENSATION 5,806 5,293 8,300 4,900 8,500 ALLOWANCES 2,049 4,657 2,100 6,600 2,100 OTHER BENEFITS 3,234 3,306 3,600 2,900 3,600 EMPLOYEE RELATIONS 578 - - - - PERSONNEL 368,592 401,811 424,864 368,800 445,700 OFFICE SUPPLIES 397 192 600 500 500 OPERATING SUPPLIES 10,409 11,177 13,000 10,000 9,500 FUEL 9,902 3,846 6,000 5,500 11,000 EQUIPMENT MAINTENANCE 4,238 9,250 7,500 4,000 4,000 VEHICLE MAINTENANCE 12,953 7,259 13,000 10,000 10,000 TRAFFIC CONTROL MAINTENANCE 23,576 21,914 30,000 25,000 26,500 ELECTRIC SERVICE 4,497 4,877 4,800 4,500 4,500 NATURAL GAS SERVICE - 834 1,000 1,000 1,000 EQUIPMENT LEASE/RENTAL 711 664 800 800 800 PROFESSIONAL DUES 2,450 1,953 4,300 3,500 4,100 PUBLICATIONS 521 395 500 400 500 TRAVEL & TRAINING 6,974 12,639 13,500 8,000 10,000 OTHER CONTRACTED SERVICES 23,254 14,099 50,500 55,000 33,000 COMMUNITY RELATIONS 93 - 5,800 5,000 3,000 TRANSFER TO VEHICLE REPLACEMENT FUND 33,504 32,000 31,000 31,000 31,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 29,400 28,500 32,500 32,500 28,900 TRANSFER TO EQUIPMENT REPLACEMENT FUND - - 112,700 112,700 113,700 OPERATING 162,879 149,599 327,500 309,400 292,000 FURNITURE & EQUIP <$5000 8,690 - - - - OTHER EQUIPMENT 3,145 - - - - CONSTRUCTION COSTS - 7,251 - - 30,000 CAPITAL 11,835 7,251 - - 30,000 GENERAL SERVICES DIVISION TOTAL 543,306 $ 558,661$ 752,364$ 678,200$ 767,700 $ General Services Division Line Item Budget PUBLIC WORKS DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 144,106 $ 147,825 $ 160,473 $ 151,000 $ 164,900 PART-TIME WAGES 1,724 - - - - OVERTIME 147 705 1,000 800 1,000 LONGEVITY 1,330 1,450 1,600 1,600 1,700 HEALTH & DENTAL 16,825 13,867 16,000 12,600 18,000 TMRS 15,141 18,406 19,600 20,100 23,200 FICA 11,101 11,389 12,300 11,700 12,800 WORKERS COMPENSATION 494 439 500 400 500 ALLOWANCES 1,205 1,210 1,200 1,150 1,300 OTHER BENEFITS 1,872 1,589 1,300 1,600 1,300 PERSONNEL 193,946 196,881 213,973 200,950 224,700 OFFICE SUPPLIES 800 203 300 300 500 OPERATING SUPPLIES 2,723 2,868 7,700 7,000 5,200 FUEL 3,272 2,045 3,200 2,200 3,000 CONSULTANTS - 902 50,000 35,000 15,000 VEHICLE MAINTENANCE 1,725 1,654 1,500 1,400 1,200 COMMUNICATION 1,516 5,661 5,600 3,800 4,000 ELECTRIC SERVICE - - 900 900 900 PROFESSIONAL DUES 426 373 1,000 1,000 1,000 PUBLICATIONS 121 - - - - TRAVEL & TRAINING 577 764 3,400 2,000 4,900 OTHER CONTRACTED SERVICES 44,425 57,469 60,400 60,400 66,400 COMMUNITY RELATIONS - 1,253 3,000 1,200 3,000 TRANSFER TO VEHICLE REPLACEMENT FUND 5,496 5,500 5,000 5,000 5,300 OPERATING 61,081 78,691 142,000 120,200 110,400 FURNITURE & EQUIP <$5000 - 1,627 - - 10,000 CAPITAL - 1,627 - - 10,000 PLANNING DIVISION TOTAL 255,026 $ 277,200 $ 355,973 $ 321,150 $ 345,100 $ Planning Division Line Item Budget PUBLIC WORKS DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 P&R Administration Personnel 335,673$ 377,729$ 385,700$ 378,300$ 512,200 $ Operating charges 160,017 211,185 231,700 227,800 218,900 Capital - - - - - Total 495,690 588,914 617,400 606,100 731,100 Senior Services Personnel 177,095 189,990 211,300 199,350 233,600 Operating charges 106,227 106,367 130,300 125,900 137,900 Capital - - - - - Total 283,323 296,357 341,600 325,250 371,500 Recreation Center Personnel 471,263 515,717 560,700 543,300 606,000 Operating charges 656,618 608,898 877,600 874,605 817,000 Capital - 44,033 28,000 55,030 12,700 Total 1,127,881 1,168,648 1,466,300 1,472,935 1,435,700 Parks Maintenance Personnel 147,970 170,637 215,000 194,300 217,200 Operating charges 364,961 298,609 424,800 409,000 436,400 Capital 4,858 - 3,600 - - Total 517,789 469,246 643,400 603,300 653,600 Colonial Park Personnel 148,438 140,305 176,000 175,900 177,600 Operating charges 199,090 201,198 395,700 395,160 364,400 Capital 3,570 - 24,000 24,000 6,000 Total 351,099 341,504 595,700 595,060 548,000 Total Department 2,775,782$ 2,864,669$ 3,664,400$ 3,602,645$ 3,739,900 $ Parks and Recreation Department Staffing Schedule 20162017 POSITION GRADEBUDGETBUDGETMINIMUMMAXIMUM Parks and Recreation Community Building Parks and Recreation DirectorIII 1 1 108,393 162,590 Assistant Parks & Recreation Director 112 1 1 83,531 125,296 Administrative Manager 111 - - 70,568 105,852 Executive Director FWUP 109 1 1 60,076 84,107 Senior Services Senior Services Manager 110 1 1 63,921 89,488 Recreation Specialist 205 1 1 40,830 57,162 Recreation Center Recreation Manager 111 1 1 70,568 105,852 Assistant Recreation Mgr 206 1 1 45,644 63,902 Recreation Specialist 205 2 2 40,830 57,162 Parks Maintenance Park Maintenance Supervisor207 1 1 51,418 71,984 Crew Leade r 205 - - 40,830 57,162 Parks Technician 201 2 2 29,250 40,951 Total Parks and Recreation Department 12 12 PARKS & RECREATION DEPARTMENT SALARY RANGE ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 247,484 $ 275,888 $ 282,400 $ 271,300 $ 369,100 LONGEVITY 2,550 2,730 3,000 3,000 2,400 HEALTH & DENTAL 27,131 30,958 31,100 34,100 47,400 TMRS 26,709 35,009 35,100 36,400 52,300 FICA 18,207 20,002 21,500 20,800 28,400 WORKERS COMPENSATION 918 576 600 600 600 ALLOWANCES 8,917 8,954 8,900 8,600 8,900 OTHER BENEFITS 2,486 2,559 2,100 2,500 2,100 EMPLOYEE RELATIONS 1,271 1,052 1,000 1,000 1,000 PERSONNEL 335,673 377,729 385,700 378,300 512,200 OFFICE SUPPLIES 1,100 957 1,000 1,000 1,000 OPERATING SUPPLIES 3,010 2,784 2,700 2,700 2,700 SWIMMING POOL MAINTENANCE 45 - - - - COMMUNICATION 27,910 23,628 23,000 23,000 24,000 ELECTRIC SERVICE 10,337 11,160 11,400 10,000 10,000 NATURAL GAS SERVICE - 2,284 5,000 2,500 2,500 EQUIPMENT LEASE/RENTAL 3,681 4,226 4,000 4,000 4,000 PROFESSIONAL DUES 3,454 2,785 3,100 3,100 3,400 TRAVEL & TRAINING 4,205 5,650 5,700 5,700 5,700 TRI-SPORTS 80,000 125,000 125,000 125,000 125,000 COMMUNITY RELATIONS 3,067 4,611 4,500 4,500 4,500 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 23,208 28,100 46,300 46,300 36,100 OPERATING 160,017 211,185 231,700 227,800 218,900 PARKS AND RECREATION ADMINISTRATION DIVISION TOTAL 495,690$ 588,914$ 617,400$ 606,100$ 731,100$ Parks and Recreation Administration Division PARKS AND RECREATION DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 112,062 $ 116,232 $ 124,700 $ 117,000 $ 129,500 PART-TIME WAGES 24,385 28,096 36,600 36,000 48,000 OVERTIME 764 1,419 1,700 800 1,200 LONGEVITY 1,180 1,300 1,400 1,400 1,600 HEALTH & DENTAL 14,481 15,408 16,600 15,900 18,600 TMRS 11,757 14,483 15,300 15,600 18,200 FICA 10,093 10,820 12,500 10,400 13,800 WORKERS COMPENSATION 914 755 1,200 700 1,400 OTHER BENEFITS 1,458 1,477 1,300 1,500 1,300 EMPLOYEE RELATIONS - - - 50 - PERSONNEL 177,095 189,990 211,300 199,350 233,600 OFFICE SUPPLIES 472 748 1,000 1,000 1,000 OPERATING SUPPLIES 2,826 2,218 5,500 2,000 5,500 FUEL 2,117 1,094 1,600 1,300 1,800 VEHICLE MAINTENANCE 299 1,339 2,000 1,500 1,500 COMMUNICATION 8,321 6,628 8,500 8,000 8,500 EQUIPMENT LEASE/RENTAL 962 981 1,200 1,200 1,200 PROFESSIONAL DUES 225 506 300 300 300 TRAVEL & TRAINING 1,085 1,023 1,700 1,200 1,700 CREDIT CARD FEES - - 1,500 2,400 2,400 INSTRUCTOR FEES 31,376 32,156 32,000 32,000 32,000 COMMUNITY RELATIONS 14,551 12,765 18,000 18,000 18,000 BOARDS AND COMMITTEES 3,397 4,007 4,000 4,000 4,000 TRANSFER TO VEHICLE REPLACEMENT FUND 9,000 8,700 9,000 9,000 9,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 31,596 34,200 38,500 38,500 46,200 TRANSFER TO EQUIPMENT REPLACEMENT FUND - - 5,500 5,500 4,800 OPERATING 106,227 106,367 130,300 125,900 137,900 SENIOR SERVICES DIVISION TOTAL 283,323$ 296,357$ 341,600$ 325,250$ 371,500$ Senior Services Division Line Item Budget PARKS AND RECREATION DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 193,587 $ 231,793 $ 231,000 $ 216,500 $ 239,800 PART-TIME WAGES 189,691 179,096 201,000 201,000 221,300 ON CALL 1,191 1,032 1,700 1,300 1,700 OVERTIME 3,819 8,794 10,500 11,400 12,400 LONGEVITY 1,183 1,175 1,400 1,400 1,600 HEALTH & DENTAL 21,026 24,011 36,600 25,200 41,400 TMRS 20,040 27,974 29,600 39,800 35,400 FICA 28,317 30,505 33,800 33,100 36,300 WORKERS COMPENSATION 6,196 4,398 8,500 6,500 9,500 ALLOWANCES 4,097 4,114 4,100 4,100 4,100 OTHER BENEFITS 2,115 2,826 2,500 3,000 2,500 PERSONNEL 471,263 515,717 560,700 543,300 606,000 OFFICE SUPPLIES 2,353 2,366 4,400 5,000 4,300 OPERATING SUPPLIES 56,493 34,003 62,000 62,000 61,700 TREATMENT CHEMICALS 11,647 9,975 14,000 14,000 14,300 EQUIPMENT MAINTENANCE 28,786 9,936 8,700 9,630 6,200 SWIMMING POOL MAINTENANCE 23,184 21,140 37,600 26,675 26,500 COMMUNICATION 2,319 774 1,900 1,900 1,700 ELECTRIC SERVICE 83,899 91,713 94,600 95,000 95,000 NATURAL GAS SERVICE - 17,870 21,000 20,000 20,000 EQUIPMENT LEASE/RENTAL 7,996 5,909 7,800 7,800 7,500 PROFESSIONAL DUES 759 1,375 1,600 1,600 1,600 TRAVEL & TRAINING 7,784 9,976 10,300 17,300 11,600 CREDIT CARD FEES - - 20,200 22,000 20,200 INSTRUCTOR FEES 332,002 299,062 342,800 341,000 342,700 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 99,396 104,800 122,100 122,100 85,500 TRANSFER TO EQUIPMENT REPLACEMENT FUND - - 128,600 128,600 118,200 OPERATING 656,618 608,898 877,600 874,605 817,000 FURNITURE & EQUIP <$5000 - 44,033 28,000 55,030 12,700 CAPITAL - 44,033 28,000 55,030 12,700 RECREATION CENTER DIVISION TOTAL 1,127,881$ 1,168,648$ 1,466,300$ 1,472,935$ 1,435,700$ Recreation Center Division Line Item Budget PARKS AND RECREATION DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 86,636 $ 106,296 $ 129,000 $ 122,200 $ 122,200 PART-TIME WAGES 15,548 4,829 6,000 5,000 6,000 ON CALL 1,620 1,623 2,000 1,500 1,800 OVERTIME 1,296 3,148 3,200 3,900 5,400 LONGEVITY 250 370 600 600 500 HEALTH & DENTAL 21,076 25,632 41,000 28,400 46,600 TMRS 9,163 14,081 16,100 16,400 17,900 FICA 7,816 8,708 10,500 9,800 10,200 WORKERS COMPENSATION 1,992 2,121 2,700 2,400 2,700 ALLOWANCES 1,205 2,085 2,100 2,100 2,100 OTHER BENEFITS 1,370 1,744 1,800 2,000 1,800 PERSONNEL 147,970 170,637 215,000 194,300 217,200 OFFICE SUPPLIES 261 290 300 300 300 OPERATING SUPPLIES 2,526 4,481 5,200 5,000 5,200 FUEL 4,787 3,594 5,500 3,200 4,800 EQUIPMENT MAINTENANCE 637 1,001 1,300 1,300 1,300 VEHICLE MAINTENANCE 1,679 3,047 3,000 1,000 1,000 BUILDING & GROUNDS MAINTENANCE 129,383 96,874 115,000 105,000 104,000 ELECTRIC SERVICE 18,671 20,207 19,400 18,000 18,000 TRAVEL & TRAINING 3,864 2,875 4,000 4,600 4,500 OTHER CONTRACTED SERVICES 167,256 143,140 187,500 187,000 203,000 TRANSFER TO CAPITAL PROJECT FUND 14,500 - - - - TRANSFER TO VEHICLE REPLACEMENT FUND 8,496 8,300 8,000 8,000 8,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 12,900 14,800 16,200 16,200 20,000 TRANSFER TO EQUIPMENT REPLACEMENT FUND - - 59,400 59,400 66,300 OPERATING 364,961 298,609 424,800 409,000 436,400 TRUCKS 4,858 - 3,600 - - 4,858 - 3,600 - - PARKS MAINTENANCE DIVISION TOTAL 517,789$ 469,246$ 643,400$ 603,300$ 653,600$ Parks Maintenance Division Line Item Budget PARKS AND RECREATION DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ (488) $ 6,572 $ - $ - $ - PART-TIME WAGES 134,075 119,270 160,600 160,600 162,000 OVERTIME - 27 - - - FICA 11,897 11,541 12,300 12,200 12,400 WORKERS COMPENSATION 2,955 2,896 3,100 3,100 3,200 PERSONNEL 148,438 140,305 176,000 175,900 177,600 OFFICE SUPPLIES 1,091 1,079 2,000 2,000 2,000 OPERATING SUPPLIES 10,144 25,313 27,100 27,000 33,600 TREATMENT CHEMICALS 14,674 17,005 17,600 17,510 17,500 EQUIPMENT MAINTENANCE 335 187 3,000 3,000 3,000 SWIMMING POOL MAINTENANCE 73,775 46,903 80,700 80,700 56,100 COMMUNICATION 512 117 700 700 800 ELECTRIC SERVICE 38,888 46,393 46,900 47,000 47,000 NATURAL GAS SERVICE - 2,965 4,000 3,500 4,000 EQUIPMENT LEASE/RENTAL 784 637 900 750 800 CREDIT CARD FEES - - 2,400 2,600 2,400 INSTRUCTOR FEES 988 - - - - TRANSFER TO TECHNOLOGY MANAGEMENT FUND 57,900 60,600 65,000 65,000 50,700 TRANSFER TO EQUIPMENT REPLACEMENT FUND - - 145,400 145,400 146,500 OPERATING 199,090 201,198 395,700 395,160 364,400 FURNITURE & EQUIP < $5000 3,570 - 24,000 24,000 6,000 CAPITAL 3,570 - 24,000 24,000 6,000 COLONIAL PARK DIVISION TOTAL 351,099$ 341,504$ 595,700$ 595,060$ 548,000$ PARKS AND RECREATION DEPARTMENT Colonial Park Division Line Item Budget Transfers ActualActualBudgetEstimatedBudget Account Description20142015201620162017 TRANSFER FROM WATER & SEWER FUND 1,250,004 1,250,000 1,250,000 1,250,000 500,000 TRANSFER FROM SOLID WASTE FUND 309,996 310,000 310,000 310,000 59,400 TRANSFERS IN 1,560,000 $ 1,560,000 $ 1,560,000 $ 1,560,000 $ 559,400 $ TRANSFER TO CAPITAL PROJECT FUND 223,000 - - - - TRANSFER TO CAPITAL RESERVE FUND 200,004 79,300 500,000 500,000 500,000 TRANSFERS OUT 423,004 $ 79,300 $ 500,000 $ 500,000 $ 500,000 $ GENERAL FUND DEBT SERVICE FUND DEBT SERVICE FUND STATEMENT OF REVENUES AND EXPENDITURES ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: CURRENT YEAR PROPERTY TAXES 7,738,872 $ 8,063,004 $ 8,034,500 $ 8,034,500 $ 7,713,715 $ PRIOR YEAR PROPERTY TAXES 11,866 22,606 10,000 10,000 10,000 PENALTY AND INTEREST 35,656 35,269 25,000 35,000 35,000 EARNINGS ON INVESTMENTS 3,415 5,214 2,500 3,000 2,500 TRANSFER FROM WATER & SEWER FUND 378,504 383,800 383,950 1,193,563 1,193,554 GENERAL OBLIGATION BOND PROCEEDS - - - 3,170,000 - TOTAL REVENUES 8,168,313 8,509,893 8,455,950 12,446,063 8,954,769 EXPENDITURES: BOND PRINCIPAL 6,190,000 6,420,000 6,580,000 7,370,000 7,485,000 INTEREST ON BONDS 1,891,944 1,676,905 1,513,800 2,263,888 1,422,468 FISCAL AGENT FEES 15,000 13,750 16,250 17,000 16,250 ISSUANCE COSTS - - - 91,300 - PAYMENT TO REFUNDED BOND ESCROW - - - 3,117,900 - TOTAL EXPENDITURES 8,096,944 8,110,655 8,110,050 12,860,088 8,923,718 NET REVENUES 71,369 399,238 345,900 (414,025) 31,051 BEGINNING BALANCE 95,669 167,038 503,737 566,276 152,251 ENDING BALANCE 167,038 $ 566,276 $ 849,637 $ 152,251 $ 183,302 $ PrincipalPrincipal AmountOutstanding Outstanding Series Obligationof IssueJanuary 1, 2017PrincipalInterestTotalDecember 31, 2017 2001 Certificates of Obligation 3,325,000 $ 590,000 $ 590,000 $ 12,980 $ 602,980 $ -$ 2009 Permanent Improvement & Refunding 11,740,000 8,615,000 495,000 348,900 843,900 8,120,000 2009 Certificates of Obligation 1,295,000 1,065,000 45,000 43,431 88,431 1,020,000 2010 Permanent Improvement 5,000,000 4,760,000 75,000 177,350 252,350 4,685,000 2010 Permanent Improvement Refunding 11,145,000 6,050,000 1,170,000 188,200 1,358,200 4,880,000 2010 Certificates of Obligation 6,900,000 6,505,000 110,000 242,563 352,563 6,395,000 2010A Certificates of Obligation 1,660,000 1,195,000 80,000 42,800 122,800 1,115,000 2011 Permanent Improvement Refunding 4,790,000 1,640,000 425,000 40,700 465,700 1,215,000 2011 Certificates of Obligation 910,000 810,000 20,000 17,825 37,825 790,000 2012 Permanent Improvement Refunding 8,555,000 7,185,000 760,000 136,100 896,100 6,425,000 2013 Permanent Improvement Refunding 16,360,000 12,110,000 3,305,000 140,190 3,445,190 8,805,000 2016 General Obligation Refunding 3,170,000 2,380,000 410,000 31,429 441,429 1,970,000 52,905,000 $ 7,485,000 $ 1,422,468 $ 8,907,468 $ 45,420,000 $ CITY OF WEST UNIVERSITY PLACE GENERAL LONG TERM DEBT SCHEDULE OF FISCAL YEAR REQUIREMENTS Principal & Interest Requirements for 2017 Fiscal YearPrincipalInterest Due 2/1Interest Due 8/1InterestTotal 20177,485,000 747,279 675,189 1,422,468 8,907,468 20187,655,000 675,189 595,696 1,270,885 8,925,885 20197,815,000 595,696 513,979 1,109,674 8,924,674 20207,965,000 513,979 427,130 941,108 8,906,108 20213,375,000 427,130 370,878 798,007 4,173,007 20223,345,000 370,878 313,150 684,028 4,029,028 20232,500,000 313,150 267,263 580,413 3,080,413 20242,345,000 267,263 219,163 486,425 2,831,425 20252,445,000 219,163 167,750 386,913 2,831,913 20262,550,000 167,750 114,125 281,875 2,831,875 20272,660,000 114,125 58,175 172,300 2,832,300 20282,765,000 58,175 - 58,175 2,823,175 52,905,000 $ 4,469,774 $ 3,722,495 $ 8,192,269 $ 61,097,269 $ CITY OF WEST UNIVERSITY PLACE GENERAL LONG TERM DEBT PRINCIPAL AND INTEREST REQUIREMENTS As of January 1, 2017 $‐ $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 $10,000,000 20 1 7 20 1 8 20 1 9 20 2 0 20 2 1 20 2 2 20 2 3 20 2 4 20 2 5 20 2 6 20 2 7 20 2 8 Annual Debt Service Requirements Principal Interest WATER & SEWER FUND WATER AND SEWER UTILITY FUND STATEMENT OF REVENUES AND EXPENDTURES ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REVENUES: WATER SERVICE 4,564,375 $ 4,641,229 $ 4,700,000 $ 4,879,000 $ 4,880,000 $ SEWER SERVICE 2,140,771 2,165,608 2,134,500 2,235,000 2,220,000 PENALTIES 51,263 93,526 50,000 55,000 55,000 CONNECTION FEE 106,740 79,006 60,000 82,000 80,000 EARNINGS ON INVESTMENTS 2,357 55 1,100 - - MISCELLANEOUS 4,985 6,927 5,000 9,810 5,000 TRANSFER FROM WATER & SEWER CAPITAL PROJECTS FUND 1,353,111 259,456 - - - TOTAL REVENUE 8,223,601 7,245,808 6,950,600 7,260,810 7,240,000 EXPENDITURES BY DEPARTMENT: DEBT SERVICE 1,805,906 1,201,738 1,226,300 1,193,563 1,193,554 FINANCE 279,404 248,732 334,224 337,410 276,400 PUBLIC WORKS 3,611,581 4,002,945 4,096,636 4,162,900 4,204,600 TRANSFER TO GENERAL FUND 1,250,004 1,250,000 1,250,000 1,250,000 500,000 TRANSFER TO 2010 CERTIFICATES OF OBLIGATION FUND - - - - - TRANSFER TO WATER & SEWER CAPITAL PROJECTS 1,899,996 1,200,000 955,000 955,000 - TOTAL EXPENDITURES 8,846,891 7,903,415 7,862,160 7,898,873 6,174,554 NET REVENUES (EXPENDITURES)(623,290) (657,607) (911,560) (638,063) 1,065,446 BEGINNING WORKING CAPITAL 1,599,580 976,290 1,606,891 318,682 (319,381) ENDING WORKING CAPITAL 976,290 $ 318,682 $ 695,331 $ (319,381)$ 746,065 $ working capital days 40 15 32 (15) 44 Reserve Requirement (10% of Revenue)822,360.13 724,580.76 695,060.00 726,081.00 724,000.00 Fund Balance over (under) reserve requirement 153,929.37 (405,898.36) 271.00 (1,045,461.60) 22,065.40 OPERATIONS 68.10% FINANCE 4.48% DEBT SERVICE 19.33% TRANSFERS 8.10% Water & Sewer Fund Expenditures by Department WATER AND SEWER UTILITY FUND STATEMENT OF REVENUES AND EXPENDTURES ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REVENUES: WATER SERVICE $ 4,564,375 $ 4,641,229 $ 4,700,000 $ 4,879,000 $ 4,880,000 SEWER SERVICE 2,140,771 2,165,608 2,134,500 2,235,000 2,220,000 PENALTIES 51,263 93,526 50,000 55,000 55,000 CONNECTION FEE 106,740 79,006 60,000 82,000 80,000 EARNINGS ON INVESTMENTS 2,357 55 1,100 - - MISCELLANEOUS 4,985 6,927 5,000 9,810 5,000 TRANSFER FROM WATER & SEWER CAPITAL PROJECTS FUND 1,353,111 259,456 - - - TOTAL REVENUE 8,223,601 7,245,808 6,950,600 7,260,810 7,240,000 EXPENDITURES: REGULAR WAGES 607,410 740,565 699,540 747,000 710,200 PART-TIME WAGES 386 1,657 - - - ON CALL 12,783 15,849 13,800 12,000 13,800 OVERTIME 99,203 95,817 80,000 66,900 80,000 LONGEVITY 7,391 7,990 7,700 7,700 8,400 HEALTH & DENTAL 112,224 137,297 139,500 145,500 158,300 TMRS 74,483 105,860 95,300 108,000 110,600 FICA 53,152 63,183 59,900 62,400 61,000 WORKERS COMPENSATION 10,230 11,329 11,600 11,300 12,200 ALLOWANCES 4,786 6,171 6,200 6,100 6,200 OTHER BENEFITS 8,428 9,929 8,700 10,000 8,600 EMPLOYEE RELATIONS 1,089 696 1,700 1,500 1,700 ACCRUED VACATION 48,781 1,128 - - - OFFICE SUPPLIES 2,250 1,591 2,200 2,200 2,200 OPERATING SUPPLIES 28,024 26,079 16,000 21,000 19,000 FUEL 13,511 11,623 19,000 12,000 16,500 TREATMENT CHEMICALS 93,454 83,700 92,000 90,000 107,000 EQUIPMENT MAINTENANCE 17,252 18,918 37,000 24,000 28,000 VEHICLE MAINTENANCE 15,383 9,488 20,000 20,000 20,000 BUILDING & GROUNDS MAINTENANCE 62,288 41,889 62,000 60,000 62,000 WATER SYSTEM MAINTENANCE 151,786 127,126 115,000 135,000 120,000 SEWER SYSTEM MAINTENANCE 169,166 228,671 124,000 165,000 130,000 COMMUNICATION 2,512 1,521 400 400 400 ELECTRIC SERVICE 426,446 466,204 407,400 450,000 450,000 SURFACE WATER 1,245,343 1,427,356 1,500,000 1,500,000 1,500,000 NATURAL GAS SERVICE 386 287 400 300 300 EQUIPMENT LEASE/RENTAL 6,396 5,609 5,600 4,860 4,800 PROFESSIONAL DUES 700 966 2,100 2,100 2,500 PUBLICATIONS - - - 65 - TRAVEL & TRAINING 20,632 24,032 26,000 24,065 30,000 SLUDGE REMOVAL 56,227 38,000 62,000 45,000 55,000 CREDIT CARD FEES - - 20,400 26,500 28,800 OTHER CONTRACTED SERVICES 354,628 328,521 368,920 368,920 324,000 COMMUNITY RELATIONS 9,954 10,497 26,000 22,000 20,000 FURNITURE & EQUIP <$5000 - 3,013 2,000 2,000 5,000 OTHER EQUIPMENT 1,803 26,715 182,000 130,000 185,000 BOND PRINCIPAL 875,004 675,000 725,000 - - INTEREST ON BONDS 160,935 132,404 115,600 - - FISCAL AGENT FEES 1,000 - 1,750 - - ISSUANCE COSTS 7,363 10,533 - - - TRANSFER TO DEBT SERVICE FUND 761,604 383,800 383,950 1,193,563 1,193,554 TRANSFER TO GENERAL FUND 1,250,004 1,250,000 1,250,000 1,250,000 500,000 WATER AND SEWER UTILITY FUND STATEMENT OF REVENUES AND EXPENDTURES ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 TRANSFER TO WATER & SEWER CAPITAL PROJECTS 1,899,996 1,200,000 955,000 955,000 - TRANSFER TO VEHICLE REPLACEMENT FUND 80,004 74,000 79,000 79,000 76,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 92,496 98,400 137,500 137,500 123,500 TOTAL EXPENDITURES 8,846,891 7,903,415 7,862,160 7,898,873 6,174,554 NET REVENUES (EXPENDITURES)(623,290) (657,607) (911,560) (638,063) 1,065,446 BEGINNING FUND BALANCE 1,599,580 976,290 1,606,891 318,682 (319,381) ENDING FUND BALANCE 976,290 $ 318,682 $ 695,331 $ (319,381)$ 746,065 $ PERSONNEL 18.96% EQUIPMENT, VEHICLE, BUILDING & GROUNDS MAINTENANCE 1.78% WATER SYSTEM MAINTENANCE 1.49% SEWER SYSTEM MAINTENANCE 2.11% ELECTRIC SERVICE 5.59% SURFACE WATER 24.29% DEBT SERVICE 19.33% TRANSFER TO GENERAL FUND 15.53% TRANSFER TO W&S CAPITAL RESERVE FUND 0.00% VEHICLE REPLACEMENT 1.23% TECHNOLOGY MANAGEMENT 2.00% OTHER OPERATING 12.96% Water & Sewer Fund Expenditures by Type ActualActualBudgetEstimatedBudget Account Description20142015201620162017 Utility Billing & Customer Service Personnel160,603 $ 169,482 $ 157,904 $ 156,800 $ 166,600 $ Operating charges118,801 78,421 174,320 178,610 107,800 Capital- 829 2,000 2,000 2,000 Transfers Out- - - - - Total279,404 248,732 334,224 337,410 276,400 Total Department 279,404 $ 248,732 $ 334,224 $ 337,410 $ 276,400 $ Finance Department Staffing Schedule (W&S Fund) 20162017 POSITIONGRADEBUDGETBUDGETMINIMUMMAXIMUM Finance - Utility Billing Sr. Customer Service Representative 2071 1 51,418 71,984 Accounting Specialist 2041 1 36,985 51,780 Total Finance (W&S Fund)2 2 FINANCE DEPARTMENT SALARY RANGE ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 REGULAR WAGES $ 101,290 $ 106,201 $ 108,104 $ 107,600 $ 112,200 ON CALL 884 - - - - OVERTIME 13,841 20,799 10,000 10,000 10,000 LONGEVITY 770 890 1,100 1,100 1,200 ACCRUED VACATION 9,605 2,334 - - - HEALTH & DENTAL 11,703 12,349 13,200 12,600 14,700 TMRS 12,045 15,567 14,300 14,300 17,000 FICA 8,828 9,676 9,100 9,100 9,400 WORKERS COMPENSATION 222 243 300 300 300 OTHER BENEFITS 1,417 1,423 1,300 1,300 1,300 EMPLOYEE RELATIONS - - 500 500 500 PERSONNEL 160,603 169,482 157,904 156,800 166,600 OFFICE SUPPLIES 699 383 1,000 1,000 1,000 COMMUNICATION 625 - - - - EQUIPMENT LEASE/RENTAL 5,727 4,817 4,000 4,060 4,000 PUBLICATIONS - - - 65 - TRAVEL & TRAINING - - 2,000 65 2,000 CREDIT CARD FEES - - 20,400 26,500 28,800 OTHER CONTRACTED SERVICES 111,750 73,221 146,920 146,920 72,000 OPERATIONS 118,801 78,421 174,320 178,610 107,800 FURNITURE & EQUIP <$5000 - 829 2,000 2,000 2,000 CAPITAL - 829 2,000 2,000 2,000 FINANCE DIVISION TOTAL 279,404 $ 248,732 $ 334,224 $ 337,410 $ 276,400 $ WATER AND SEWER FUND FINANCE DEPARTMENT Finance Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description20142014201620162017 W&S Fund Operations Personnel840,566 $ 1,029,195 $ 966,036 $ 1,021,600 $ 1,004,400 $ Operating charges2,730,036 2,946,056 2,948,600 3,011,300 3,012,200 Capital1,803 28,899 182,000 130,000 188,000 Total3,572,405 4,004,151 4,096,636 4,162,900 4,204,600 Total Department 3,572,405 $ 4,004,151 $ 4,096,636 $ 4,162,900 $ 4,204,600 $ Public Works Department Staffing Schedule (W&S Fund) 20162017 POSITIONGRADEBUDGETBUDGETMINIMUMMAXIMUM Public Works - Operations Operations Superintendent1121 1 83,531 125,296 Field Services Supervisor2071 1 51,418 71,984 Plant Supervisor2071 1 51,418 71,984 Crew Leader2052 2 40,830 57,162 Plant Operator2043 3 36,985 51,780 Driver/Equipment Operator2031 1 33,141 46,397 Maintenance Worker I2022 2 30,635 42,889 Total Public Works (W&S Fund)11 11 PUBLIC WORKS DEPARTMENT SALARY RANGE ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 401-5050-71002REGULAR WAGES $ 506,119 $ 634,364 $ 591,436 $ 639,400 $ 598,000 401-5050-71003PART-TIME WAGES 386 1,657 - - - 401-5050-71004ON CALL 11,900 15,849 13,800 12,000 13,800 401-5050-71009OVERTIME 85,362 75,019 70,000 56,900 70,000 401-5050-71010LONGEVITY 6,621 7,100 6,600 6,600 7,200 401-5050-71221HEALTH & DENTAL 100,521 124,948 126,300 132,900 143,600 401-5050-71222TMRS 62,438 90,293 81,000 93,700 93,600 401-5050-71223FICA 44,325 53,506 50,800 53,300 51,600 401-5050-71224WORKERS COMPENSATION 10,009 11,086 11,300 11,000 11,900 401-5050-71225ALLOWANCES 4,786 6,171 6,200 6,100 6,200 401-5050-71227OTHER BENEFITS 7,011 8,506 7,400 8,700 7,300 401-5050-71240EMPLOYEE RELATIONS 1,089 696 1,200 1,000 1,200 PERSONNEL 840,566 1,029,195 966,036 1,021,600 1,004,400 401-5050-72001OFFICE SUPPLIES 1,552 1,207 1,200 1,200 1,200 401-5050-72011OPERATING SUPPLIES 28,024 26,079 16,000 21,000 19,000 401-5050-72020FUEL 13,511 11,623 19,000 12,000 16,500 401-5050-72030TREATMENT CHEMICALS 93,454 83,700 92,000 90,000 107,000 401-5050-73001EQUIPMENT MAINTENANCE 17,252 18,918 37,000 24,000 28,000 401-5050-73011VEHICLE MAINTENANCE 15,383 9,488 20,000 20,000 20,000 401-5050-73015BUILDING & GROUNDS MAINTENANCE 62,288 41,889 62,000 60,000 62,000 401-5050-73040WATER SYSTEM MAINTENANCE 151,786 127,126 115,000 135,000 120,000 401-5050-73045SEWER SYSTEM MAINTENANCE 169,166 228,671 124,000 165,000 130,000 401-5050-74001COMMUNICATION 1,886 1,521 400 400 400 401-5050-74002ELECTRIC SERVICE 426,446 466,204 407,400 450,000 450,000 401-5050-74004SURFACE WATER 1,245,343 1,427,356 1,500,000 1,500,000 1,500,000 401-5050-74005NATURAL GAS SERVICE 386 287 400 300 300 401-5050-74015EQUIPMENT LEASE/RENTAL 669 792 1,600 800 800 401-5050-74020PROFESSIONAL DUES 700 966 2,100 2,100 2,500 401-5050-74040TRAVEL & TRAINING 20,632 24,032 24,000 24,000 28,000 401-5050-74051SLUDGE REMOVAL 56,227 38,000 62,000 45,000 55,000 401-5050-74090OTHER CONTRACTED SERVICES 242,877 255,299 222,000 222,000 252,000 401-5050-75001COMMUNITY RELATIONS 9,954 10,497 26,000 22,000 20,000 401-5050-91501TRANSFER TO VEHICLE REPLACEMENT FUND 80,004 74,000 79,000 79,000 76,000 401-5050-91502TRANSFER TO TECHNOLOGY MANAGEMENT FUND 92,496 98,400 137,500 137,500 123,500 OPERATING 2,730,036 2,946,056 2,948,600 3,011,300 3,012,200 401-5050-80001FURNITURE & EQUIP <$5000 - 2,184 - - 3,000 401-5050-84065OTHER EQUIPMENT 1,803 26,715 182,000 130,000 185,000 CAPITAL 1,803 28,899 182,000 130,000 188,000 OPERATIONS DIVISION TOTAL 3,572,405 $ 4,004,151 $ 4,096,636 $ 4,162,900 $ 4,204,600 $ Operations Division Line Item Budget WATER AND SEWER FUND PUBLIC WORKS DEPARTMENT PrincipalPrincipal AmountOutstanding Outstanding SeriesObligationof IssueJanuary 1, 2017PrincipalInterestTotalDecember 31, 2017 2010 Perm Improv Refunding Bonds (W&S Portion)*5,080,000 3,920,000 625,000 127,125 752,125 3,295,000 2016 GO Refunding Bonds (W&S Portion)*3,170,000 2,380,000 410,000 31,429 441,429 1,970,000 6,300,000 $ 1,035,000 $ 158,554 $ 1,193,554 $ 5,265,000 $ * Portion of debt is transferred to General Debt Service Fund CITY OF WEST UNIVERSITY PLACE WATER & SEWER DEBT SERVICE SCHEDULE OF FISCAL YEAR REQUIREMENTS Principal & Interest Requirements for 2017 Fiscal YearPrincipal * Interest Due 2/1 * Interest Due 8/1 *InterestTotal 20171,035,000 85,446 73,108 158,554 1,193,554 20181,070,000 73,108 57,138 130,246 1,200,246 20191,095,000 57,138 43,900 101,038 1,196,038 20201,110,000 43,900 30,283 74,183 1,184,183 20211,050,000 30,283 14,137 44,420 1,094,420 2022940,000 14,137 - 14,137 954,137 6,300,000 $ 304,012 $ 218,566 $ 522,578 $ 6,822,578 $ CITY OF WEST UNIVERSITY PLACE WATER & SEWER DEBT SERVICE PRINCIPAL AND INTEREST REQUIREMENTS As of January 1, 2016 * Includes amount transferred to General Debt Service Fund for W&S portion of 2010 Permanent Improvement Refunding Bonds. $‐ $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 20 1 7 20 1 8 20 1 9 20 2 0 20 2 1 20 2 2 Annual Debt Service Requirements Principal Interest SOLID WASTE FUND SOLID WASTE FUND STATEMENT OF REVENUES AND EXPENDITURES ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: SOLID WASTE COLLECTION1,419,494 $ 1,395,233 $ 1,835,100 $ 1,650,000 $ 1,650,000 $ SOLID WASTE SPECIAL COLLECTION1,989 925 1,000 500 1,000 SALE OF RECYCLABLES91,950 14,961 - 1,500 3,000 EARNINGS ON INVESTMENTS99 194 - 20 - RECOVERED BAD DEBT WRITEOFFS- - - - - MISCELLANEOUS437 581 - 480 - TRANSFER FROM VEHICLE REPLACEMENT FUND 198,000 - - - - TOTAL REVENUE 1,711,969 1,411,894 1,836,100 1,652,500 1,654,000 EXPENDITURES BY DIVISION: CURBSIDE SOLID WASTE903,272 917,137 1,051,500 874,800 998,700 RECYCLING FACILITY17,385 19,229 24,800 23,300 8,900 CURBSIDE RECYCLING305,150 285,595 291,000 311,900 294,400 CURBSIDE GREEN WASTE RECYCLING- - 191,000 143,030 191,800 TRANSFER TO GENERAL FUND309,996 310,000 310,000 310,000 59,400 TOTAL EXPENDITURES 1,535,803 1,531,960 1,868,300 1,663,030 1,553,200 NET REVENUES (EXPENDITURES)176,166 (120,066) (32,200) (10,530) 100,800 BEGINNING WORKING CAPITAL 19,057 195,223 41,643 75,157 64,627 ENDING WORKING CAPITAL 195,223 $ 75,157 $ 9,443 $ 64,627 $ 165,427 $ SOLID WASTE FUND STATEMENT OF REVENUES AND EXPENDITURES ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: 0 000 SOLID WASTE COLLECTION $ 1,419,494 $1,395,233 $1,835,100 $1,650,000 $1,650,000 0 000 SOLID WASTE SPECIAL COLLECTION 1,989 925 1,000 500 1,000 0 000 SALE OF RECYCLABLES 91,950 14,961 - 1,500 3,000 0 000 EARNINGS ON INVESTMENTS 99 194 - 20 - 0 000 MISCELLANEOUS 437 581 - 480 - 0 000 TRANSFER FROM VEHICLE REPLACEMENT FUND 198,000 - - - - TOTAL REVENUE 1,711,969 1,411,894 1,836,100 1,652,500 1,654,000 EXPENDITURES: REGULAR WAGES 260,381 273,715 326,940 245,200 324,800 OVERTIME 26,542 22,659 23,900 16,730 25,700 LONGEVITY 3,125 3,485 3,900 3,900 2,800 HEALTH & DENTAL 50,642 53,934 65,400 62,400 81,600 TMRS 29,919 36,570 43,200 34,800 48,600 FICA 21,191 21,919 27,100 19,800 27,000 WORKERS COMPENSATION 11,248 12,283 15,200 10,700 15,400 OTHER BENEFITS 4,107 4,148 4,300 4,400 4,300 EMPLOYEE RELATIONS 865 609 1,200 500 1,000 ACCRUED VACATION 13,778 4,286 - - - OFFICE SUPPLIES - - 200 200 200 OPERATING SUPPLIES 8,164 9,159 13,000 11,500 13,000 FUEL 46,994 29,199 55,600 29,700 44,400 EQUIPMENT MAINTENANCE 806 1,847 3,200 2,000 2,500 VEHICLE MAINTENANCE 82,117 31,200 53,000 49,500 45,000 ELECTRIC SERVICE 880 779 800 800 800 PROFESSIONAL DUES - 100 900 900 900 TRAVEL & TRAINING 573 2,734 6,500 4,000 5,500 DISPOSAL FEE 220,875 223,813 268,300 250,000 240,000 LANDFILL MAINTENANCE 10,130 9,670 12,000 12,000 12,000 OTHER CONTRACTED SERVICES 222,842 222,814 344,160 311,000 317,000 COMMUNITY RELATIONS 19,030 10,639 32,500 27,500 31,500 OTHER EQUIPMENT 5,556 6,886 7,000 7,000 9,500 CONSTRUCTION COSTS - - 2,500 1,000 2,500 TRANSFER TO GENERAL FUND 309,996 310,000 310,000 310,000 59,400 TRANSFER TO VEHICLE REPLACEMENT FUND 143,004 191,000 191,000 191,000 192,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 42,996 48,400 56,500 56,500 45,800 TOTAL EXPENDITURES 1,535,803 1,531,960 1,868,300 1,663,030 1,553,200 NET REVENUES (EXPENDITURES)176,166 (120,066) (32,200) (10,530) 100,800 BEGINNING FUND BALANCE 19,057 195,223 41,643 75,157 64,627 ENDING FUND BALANCE 195,223 $ 75,157 $ 9,443 $ 64,627 $ 165,427 $ CURBSIDE SOLID WASTE 64.30% RECYCLING FACILITY 0.57% CURBSIDE RECYCLING 18.95%CURBSIDE GREEN WASTE RECYCLING 12.35% TRANSFER TO GENERAL FUND 3.82% Solid Waste Fund Expenditures by Function PERSONNEL 35.22% SOLID WASTE DISPOSAL FEE 15.91%LANDFILL MAINTENANCE 0.80% OTHER CONTRACTED SERVICES 21.02% TRANSFER TO GENERAL FUND 3.94% VEHICLE REPLACEMENT 12.73% TECHNOLOGY MANAGEMENT 3.04% COMMUNITY RELATIONS 2.09% OTHER OPERATING 5.26% Solid Waste Fund Expenditures by Type ActualActualBudgetEstimatedBudget Account Description20142015201620162017 Curbside Solid Waste Personnel326,962 $ 334,001 $ 382,900 $ 264,700 $ 395,600 $ Operating charges886,305 893,136 978,600 920,100 660,000 Capital- - - - 2,500 Total1,213,268 1,227,137 1,361,500 1,184,800 1,058,100 Recycling Facility Personnel8 $ -$ -$ -$ -$ Operating charges17,376 19,229 22,300 22,300 6,400 Capital- - 2,500 1,000 2,500 Total17,385 19,229 24,800 23,300 8,900 Curbside Recycling Personnel94,868 $ 99,567 $ 72,000 $ 88,400 $ 73,800 $ Operating charges204,726 179,142 212,000 216,500 213,600 Capital5,556 6,886 7,000 7,000 7,000 Total305,150 285,595 291,000 311,900 294,400 Curbside Green Waste Recycling Personnel-$ -$ 56,240 $ 45,330 $ 61,800 $ Operating charges- - 134,760 97,700 130,000 Total- - 191,000 143,030 191,800 Total Department 1,535,803 $ 1,531,960 $ 1,868,300 $ 1,663,030 $ 1,553,200 $ Public Works Department Staffing Schedule (Solid Waste Fund) 20162017 POSITIONGRADEBUDGETBUDGETMINIMUMMAXIMUM Public Works Curbside Solid Waste Crew Chief2061 1 45,644 63,902 Crew Leader2051 1 40,830 57,162 Driver/Equipment Operator2033 3 33,141 46,397 Curbside Recycling Driver/Equipment Operator2031 1 33,141 46,397 Curbside Green Waste Recycling Driver/Equipment Operator2031 1 33,141 46,397 TOTAL SOLID WASTE FUND 7 7 PUBLIC WORKS SOLID WASTE SALARY RANGE Curbside Solid Waste Line Item Budget ActualActualBudgetEstimatedBudget Account Description20142015201620162017 REGULAR WAGES $ 198,334 $ 208,371 $ 242,000 $ 160,000 $ 238,300 OVERTIME 20,188 17,089 19,000 11,000 18,000 LONGEVITY 2,159 2,435 3,100 3,100 1,800 HEALTH & DENTAL 41,881 44,662 51,300 44,300 66,700 TMRS 22,757 27,796 31,800 22,700 35,500 FICA 16,047 16,591 20,100 12,900 19,700 WORKERS COMPENSATION 8,680 9,466 11,500 7,400 11,500 OTHER BENEFITS 3,143 3,175 3,100 2,800 3,100 EMPLOYEE RELATIONS 793 570 1,000 500 1,000 ACCRUED VACATION 12,946 5,560 - - - PENSION EXPENSE - (1,681) - - - PERSONNEL 326,962 334,001 382,900 264,700 395,600 OFFICE SUPPLIES - - 200 200 200 OPERATING SUPPLIES 7,762 8,360 11,500 10,000 11,500 FUEL 40,922 25,174 44,500 25,000 37,000 EQUIPMENT MAINTENANCE 806 1,492 2,100 1,000 1,500 VEHICLE MAINTENANCE 67,736 27,547 33,000 33,000 27,000 ELECTRIC SERVICE - 103 - - - PROFESSIONAL DUES - 100 900 900 900 TRAVEL & TRAINING 573 2,734 6,500 4,000 5,500 DISPOSAL FEE 220,875 223,813 233,000 200,000 200,000 LANDFILL MAINTENANCE 10,130 9,670 12,000 12,000 12,000 OTHER CONTRACTED SERVICES 119,032 123,593 149,900 149,000 145,000 COMMUNITY RELATIONS 4,373 3,750 15,500 15,500 14,500 TRANSFER TO GENERAL FUND 309,996 310,000 310,000 310,000 59,400 TRANSFER TO VEHICLE REPLACEMENT FUND 89,004 140,000 140,000 140,000 123,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 15,096 16,800 19,500 19,500 22,500 OPERATING 886,305 893,136 978,600 920,100 660,000 OTHER EQUIPMENT - - - - 2,500 CAPITAL - - - - 2,500 GENERAL SERVICES DIVISION TOTAL 1,213,268 $ 1,227,137 $ 1,361,500 $ 1,184,800 $ 1,058,100 $ PUBLIC WORKS DEPARTMENT ActualActualBudgetEstimatedBudget Account Description 20142015201620162017 TMRS 8 - - - - PERSONNEL 8 - - - - VEHICLE MAINTENANCE 6 - - - - ELECTRIC SERVICE 880 676 800 800 800 OTHER UTILITIES - 153 - - - OTHER CONTRACTED SERVICES 86 - - - - TRANSFER TO TECHNOLOGY MANAGEMENT FUND 16,404 18,400 21,500 21,500 5,600 OPERATING 17,376 19,229 22,300 22,300 6,400 CONSTRUCTION COSTS - - 2,500 1,000 2,500 CAPITAL - - 2,500 1,000 2,500 RECYCLING FACILITY DIVISION TOTAL 17,385 $ 19,229 $ 24,800 $ 23,300 $ 8,900 $ PUBLIC WORKS DEPARTMENT Recycling Facility Division Line Item Budget Curbside Recycling Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description20142015201620162017 REGULAR WAGES $ 62,046 $ 65,344 $ 46,400 $ 57,500 $ 46,800 OVERTIME 6,353 5,571 4,900 4,900 4,700 LONGEVITY 966 1,050 800 800 900 HEALTH & DENTAL 8,761 9,272 6,600 8,600 7,400 TMRS 7,154 8,774 6,300 8,300 7,200 FICA 5,143 5,328 4,000 4,800 4,000 WORKERS COMPENSATION 2,568 2,817 2,100 2,600 2,200 OTHER BENEFITS 964 974 700 900 600 EMPLOYEE RELATIONS 72 39 200 - - ACCRUED VACATION 832 938 - - - PENSION EXPENSE - (531) - - - PERSONNEL94,868 99,567 72,000 88,400 73,800 OPERATING SUPPLIES 402 800 1,500 1,500 1,500 FUEL 6,072 4,025 6,900 3,500 4,400 EQUIPMENT MAINTENANCE - 355 1,100 1,000 1,000 VEHICLE MAINTENANCE 14,375 3,653 17,000 15,000 14,000 DISPOSAL FEE - - 15,000 30,000 20,000 OTHER CONTRACTED SERVICES 103,724 99,221 87,000 87,000 87,000 COMMUNITY RELATIONS 14,657 6,888 17,000 12,000 17,000 TRANSFER TO VEHICLE REPLACEMENT FUND 54,000 51,000 51,000 51,000 51,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 11,496 13,200 15,500 15,500 17,700 OPERATING 204,726 179,142 212,000 216,500 213,600 OTHER EQUIPMENT 5,556 6,886 7,000 7,000 7,000 CAPITAL5,556 6,886 7,000 7,000 7,000 CURBSIDE RECYCLING DIVISION TOTAL 305,150 $ 285,595 $ 291,000 $ 311,900 $ 294,400 $ PUBLIC WORKS DEPARTMENT Curbside Green Waste Recycling Division Line Item Budget ActualActualBudgetEstimatedBudget Account Description20142015201620162017 REGULAR WAGES $ - $ - $ 38,540 $ 27,700 $ 39,700 OVERTIME - - - 830 3,000 LONGEVITY - - - - 100 HEALTH & DENTAL - - 7,500 9,500 7,500 TMRS - - 5,100 3,800 5,900 FICA - - 3,000 2,100 3,300 WORKERS COMPENSATION - - 1,600 700 1,700 OTHER BENEFITS - - 500 700 600 PERSONNEL- - 56,240 45,330 61,800 FUEL - - 4,200 1,200 3,000 VEHICLE MAINTENANCE - - 3,000 1,500 4,000 DISPOSAL FEE - - 20,300 20,000 20,000 OTHER CONTRACTED SERVICES - - 107,260 75,000 85,000 TRANSFER TO VEHICLE REPLACEMENT FUND - - - - 18,000 OPERATING - - 134,760 97,700 130,000 CAPITAL- - - - - CURBSIDE RECYCLING DIVISION TOTAL -$ -$ 191,000 $ 143,030 $ 191,800 $ PUBLIC WORKS DEPARTMENT INTERNAL SERVICE FUND S Employee Benefits Fund Technology Fund EMPLOYEE BENEFIT FUND STATEMENT OF REVENUES AND EXPENDITURES ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: CHARGES TO OPERATING FUNDS: ER - HEALTH $ 973,449 1,063,012 $ 1,471,000 $ 1,471,000 $ 1,777,300 $ ER - DENTAL 49,284 52,477 68,500 68,500 75,100 ER - LIFE 18,913 17,891 22,000 22,000 24,000 ER - DISABILITY 25,096 29,726 24,000 24,000 26,600 ER - WORKER'S COMPENSATION 96,161 101,026 115,000 115,000 126,500 ER - RETIREES - 190,000 209,000 209,000 240,400 ER - OTHER BENEFITS 571,906 321,139 266,300 319,900 325,000 EMPLOYEE CONTRIBUTIONS: EE - HEALTH 161,424 181,133 221,000 221,000 266,000 EE - DENTAL 16,647 17,369 22,500 22,500 25,000 EE - VISION 12,589 12,862 13,000 13,000 15,000 EE-PPACA CONTRIBUTIONS 40,253 31,654 75,000 75,000 75,000 COBRA CONTRIBUTIONS 40,234 27,404 50,000 50,000 50,000 EARNINGS ON INVESTMENTS 1,615 3,395 1,000 4,000 1,000 MISCELLANEOUS 23,281 - - - - TOTAL REVENUES 2,030,852 2,049,088 2,558,300 2,614,900 3,026,900 EXPENDITURES: WORKERS COMPENSATION - 1,600 - - - MEDICAL PREMIUMS - ACTIVE 1,057,770 1,259,720 1,692,000 1,692,000 2,043,300 MEDICAL PREMIUMS - RETIRED 148,706 158,351 209,000 209,000 240,400 MEDICAL PREMIUMS - COBRA - - 10,000 10,000 10,000 DENTAL PREMIUMS - ACTIVE 68,188 73,814 91,000 91,000 100,100 VISION PREMIUMS - ACTIVE 11,538 14,849 13,000 13,000 15,000 WORKER'S COMPENSATION 94,351 85,687 115,000 115,000 126,500 LIFE & AD&D, DISABILITY 39,828 42,577 46,000 46,000 50,600 UNEMPLOYMENT CLAIMS 65 - 10,000 10,000 10,000 OTHER ADMINSTRATIVE COST 11,733 7,907 23,300 23,300 20,000 MEDICAL PREMIUMS - RETIREE DEPENDENT 3,768 - 40,000 40,000 40,000 HEALTH CARE REFORM UNFUNDED MANDATE 39,764 35,908 75,000 75,000 75,000 WELLNESS PROGRAM 3,578 8,885 25,000 25,000 25,000 ACCUMULATED SICK LEAVE - - 80,000 80,000 80,000 ACCRUED VACATION - - 40,000 40,000 40,000 RECRUITING & HIRING 14,441 11,746 15,000 15,000 15,000 EVENTS 14,883 17,300 20,000 20,000 20,000 AWARDS 1,961 2,449 3,000 3,000 3,000 TUITION 14,283 14,508 25,000 25,000 47,500 INCENTIVES - - 5,000 5,000 5,000 SOFTWARE LICENSES 25,870 - - - 7,000 CONSULTANTS 39,102 6,022 10,000 10,000 54,500 TRAVEL & TRAINING 1,463 - 10,000 10,000 10,000 TOTAL EXPENDITURES 1,591,292 1,741,324 2,557,300 2,557,300 3,037,900 NET REVENUES (EXPENDITURES)439,560 307,764 1,000 57,600 (11,000) BEGINNING BALANCE 116,331 555,891 557,391 863,656 921,256 ENDING BALANCE 555,891 $ 863,656 $ 558,391 $ 921,256 $ 910,256 $ ActualActualBudgetEstimatedBudget Account Description20142015201620162017 Administration Personnel352,967 $ 449,973 $ 506,300 $ 489,900 $ 533,400 $ Operating charges1,103,827 890,510 995,700 1,039,335 908,380 Total Department 1,456,795 $ 1,340,483 $ 1,502,000 $ 1,529,235 $ 1,441,780 $ Administration Staffing Schedule (Technology Management Fund) 20162017 POSITIONGRADEBUDGETBUDGETMINIMUMMAXIMUM Technology Management Information Technology DirectorII1 1 103,232 154,847 Network Administrator2101 1 63,921 89,488 I T Technician2092 2 60,076 84,107 Total Technology Management Fund4 4 TECHNOLOGY MANAGEMENT FUND SALARY RANGE ADMINISTRATION DEPARTMENT ActualActualBudgetEstimatedBudget 20142015201620162017 TRANSFER FROM GENERAL FUND 1,033,500 $ 1,152,500 $ 1,316,600 $ 1,330,600 $ 1,301,100 $ TRANSFER FROM CAPITAL RESERVE FUND - - - 50,000 - TRANSFER FROM WATER & SEWER FUND 92,496 98,400 137,500 137,500 123,500 TRANSFER FROM SOLID WASTE FUND 42,996 48,400 56,500 56,500 45,800 EARNINGS ON INVESTMENTS 588 147 - 300 - TOTAL REVENUE S 1,169,580 1,299,447 1,510,600 1,574,900 1,470,400 REGULAR WAGES 245,424 $ 310,452 $ 351,100 $ 333,800 $ 360,500 $ ON CALL 5,258 5,310 5,500 5,200 5,500 OVERTIME 7,251 8,099 7,500 8,700 8,500 LONGEVITY 1,325 1,505 1,700 1,800 1,900 HEALTH & DENTAL 31,680 42,581 51,500 49,400 58,400 TMRS 27,873 41,069 44,500 46,500 52,800 FICA 19,804 24,493 27,200 26,700 28,400 WORKERS COMPENSATION 911 1,273 1,600 1,600 1,700 ALLOWANCES 10,966 12,116 13,000 12,800 13,000 OTHER BENEFITS 2,476 3,074 2,700 3,400 2,700 PERSONNE L 352,967 449,973 506,300 489,900 533,400 EQUIPMENT MAINTENANCE 8,294 27,767 38,500 38,500 20,000 HARDWARE & SOFTWARE MAINTENANCE CONTRACTS 403,275 448,303 510,100 510,100 500,580 TELE-COMMUNICATIONS & DATA & RADIO 234,554 299,147 241,600 241,600 270,000 SOFTWARE LICENSES 15,743 753 - 900 - CONSULTANTS 16,855 12,077 20,000 20,000 15,000 TRAVEL & TRAINING 7,265 2,462 5,800 12,000 12,800 OTHER CONTRACTED SERVICES 115 - - 35 - TECHNOLOGY PROJECTS 320,340 28,238 122,400 122,400 - HIGH TECHNOLOGY REPLACEMENTS 97,386 71,763 57,300 93,800 90,000 OPERATIONS 1,103,827 890,510 995,700 1,039,335 908,380 TOTAL EXPENDITURE S 1,456,795 1,340,483 1,502,000 1,529,235 1,441,780 NET REVENUES (EXPENDITURES )(287,215) (41,036) 8,600 45,665 28,620 BEGINNING BALANCE 253,967 (33,248) (8,348) (74,283) (28,618) ENDING BALANC E (33,248)$ (74,283)$ 252 $ (28,618)$ 2 $ REVENUES: EXPENDITURES: CHARGES TO OPERATING FUNDS: STATEMENT OF REVENUES AND EXPENDITURES TECHNOLOGY MANAGEMENT FUND SPECIAL REVENUE FUND S Parks Fund Court Technology Fund Tree Replacement Fund Court Security Fund METRO Grant Fund Police Forfeited Property Fund Police Training Fund Fire Training Fund Good Neighbor Fund PARKS DONATION FUND ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: EARNINGS ON INVESTMENTS86 $ 120 $ -$ 100 $ -$ DONATIONS9,285 5,368 5,000 36,500 236,500 TOTAL REVENUES 9,371 5,488 5,000 36,600 236,500 EXPENDITURES: OPERATING SUPPLIES2,031 5,861 7,000 18,500 217,500 TOTAL EXPENDITURES 2,031 5,861 7,000 18,500 217,500 NET REVENUES (EXPENDITURES)7,339 (373) (2,000) 18,100 19,000 BEGINNING BALANCE 14,459 21,798 12,459 21,425 39,525 ENDING BALANCE 21,798 21,425 10,459 39,525 58,525 STATEMENT OF REVENUES AND EXPENDITURES FRIENDS OF WEST UNIVERSITY PLACE PARKS DONATION FUN D ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: FRIENDS OF WEST U PARKS211,664 $ 20,199 $ -$ 355,000 $ 350,000 $ EARNINGS ON INVESTMENTS- 1 - - - TOTAL REVENUES 211,664 20,200 - 355,000 350,000 EXPENDITURES: CONSTRUCTION COSTS209,879 19,590 - 355,000 350,000 TOTAL EXPENDITURES 209,879 19,590 - 355,000 350,000 NET REVENUES (EXPENDITURES)1,785 610 - - - BEGINNING BALANCE (1,784) 1 - 611 611 ENDING BALANCE 1 611 - 611 611 STATEMENT OF REVENUES AND EXPENDITURES ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: MUNICIPAL COURT FINES6,419 $ 6,339 $ 6,000 $ 3,500 $ 3,000 $ EARNINGS ON INVESTMENTS2 - - - - TOTAL REVENUES 6,421 6,339 6,000 3,500 3,000 EXPENDITURES: HARDWARE & SOFTWARE MAINTENACE CONTRACTS 8,389 50 - - ‐ OTHER CONTRACTED SERVICES 4,387 5,689 8,000 - ‐ FURNITURE & EQUIP <$5000- - - - - TOTAL EXPENDITURES 12,776 5,689 8,000 - - NET REVENUES (EXPENDITURES)(6,354) 650 (2,000) 3,500 3,000 BEGINNING BALANCE 1,472 (4,882) 2,372 (4,232) (732) ENDING BALANCE (4,882)$ (4,232)$ 372 $ (732)$ 2,268 $ STATEMENT OF REVENUES AND EXPENDITURES COURT TECHNOLOGY FUND ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: OTHER FEES AND PERMITS 44,268 $ 62,133 $ 25,000 $ 35,000 $ 30,000 $ EARNINGS ON INVESTMENTS 607 938 - 900 - TOTAL REVENUES 44,875 63,072 25,000 35,900 30,000 EXPENDITURES: TREE REPLACEMENT OPERATING EXPENDITURES 19,186 23,782 60,000 33,000 30,000 TOTAL EXPENDITURES 19,186 23,782 60,000 33,000 30,000 NET REVENUES (EXPENDITURES)25,689 39,290 (35,000) 2,900 - BEGINNING BALANCE 120,991 146,680 111,411 185,970 188,870 ENDING BALANCE 146,680 $ 185,970 $ 76,411 $ 188,870 $ 188,870 $ STATEMENT OF REVENUES AND EXPENDITURES TREE REPLACEMENT FUND COURT SECURITY FUND ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: MUNICPAL COURT FINES 4,811 $ 4,699 $ 4,500 $ 4,800 $ 4,500 $ EARNINGS ON INVESTMENTS 160 237 - 200 - TOTAL REVENUES 4,972 4,935 4,500 5,000 4,500 EXPENDITURES: FURNITURE & EQUIP <$5000 - 510 15,000 10,000 15,000 TOTAL EXPENDITURES - 510 15,000 10,000 15,000 NET REVENUES (EXPENDITURES)4,972 4,425 (10,500) (5,000) (10,500) BEGINNING BALANCE 32,237 37,209 31,838 41,634 36,634 ENDING BALANCE 37,209 $ 41,634 $ 21,338 $ 36,634 $ 26,134 $ STATEMENT OF REVENUES AND EXPENDITURES METRO GRANT FUND ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: METRO 145,819 $ 558,668 $ 500,000 $ 525,000 $ 500,000 $ EARNINGS ON INVESTMENTS 478 446 300 600 300 TOTAL REVENUES 146,296 559,114 500,300 525,600 500,300 EXPENDITURES: TRANSFER TO TRANSPORTATION IMPROVEMENT FUND 258,996 500,000 500,000 500,000 500,000 TOTAL EXPENDITURES 258,996 500,000 500,000 500,000 500,000 NET REVENUES (EXPENDITURES)(112,700) 59,114 300 25,600 300 BEGINNING BALANCE 259,197 146,497 497 205,611 231,211 ENDING BALANCE 146,497 $ 205,611 $ 797 $ 231,211 $ 231,511 $ STATEMENT OF REVENUES AND EXPENDITURES ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: FORFEITED PROPERTY 1,925 $ -$ -$ 3,500 $ -$ EARNINGS ON INVESTMENTS 21 19 20 - 20 TOTAL REVENUES 1,946 19 20 3,500 20 EXPENDITURES: OPERATING SUPPLIES 2,743 1,295 4,000 1,300 4,000 TOTAL EXPENDITURES 2,743 1,295 4,000 1,300 4,000 NET REVENUES (EXPENDITURES)(796) (1,276) (3,980) 2,200 (3,980) BEGINNING BALANCE 7,039 6,243 6,224 4,967 7,167 ENDING BALANCE 6,243 $ 4,967 $ 2,244 $ 7,167 $ 3,187 $ STATEMENT OF REVENUES AND EXPENDITURES POLICE FORFEITED PROPERTY FUND POLICE TRAINING FUND ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: STATE GRANT 2,066 $ 2,048 $ 2,000 $ 2,100 $ 2,000 $ EARNINGS ON INVESTMENTS 70 99 50 - 50 CLASS FEES - 1,950 - - - TOTAL REVENUES 2,135 4,097 2,050 2,100 2,050 EXPENDITURES: TRAINING SUPPLIES - 3,223 3,000 3,000 3,000 TRAVEL & TRAINING - - - 1,250 - TOTAL EXPENDITURES - 3,223 3,000 4,250 3,000 NET REVENUES (EXPENDITURES)2,135 873 (950) (2,150) (950) BEGINNING BALANCE 13,398 15,533 9,518 16,406 14,256 ENDING BALANCE 15,533 $ 16,406 $ 8,568 $ 14,256 $ 13,306 $ STATEMENT OF REVENUES AND EXPENDITURES FIRE TRAINING FUND ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: STATE GRANT 16,000 $ 150 $ -$ -$ -$ SETRAC - 3,391 - 2,325 - EARNINGS ON INVESTMENTS - 5 - - - DONATIONS - 10,000 - - - MISCELLANEOUS 301 - - - - TRANSFER FROM GENERAL FUND 4,000 - - 206 - TOTAL REVENUES 20,301 13,546 - 2,531 - EXPENDITURES: OVERTIME - - - - - OPERATING SUPPLIES 15,374 3,597 - - - TRAVEL & TRAINING - 150 - - - TECHNOLOGY PROJECTS - - - - - HEAVY EQUIPMENT - 7,500 - 2,500 - OTHER EQUIPMENT - - - 2,325 - TOTAL EXPENDITURES 15,374 11,247 - 4,825 - NET REVENUES (EXPENDITURES)4,927 2,299 - (2,294) - BEGINNING BALANCE (4,838) 89 - 2,388 94 ENDING BALANCE 89 $ 2,388 $ -$ 94 $ 94 $ STATEMENT OF REVENUES AND EXPENDITURES GOOD NEIGHBOR FUND ActualActualBudgetEstimatedBudget 20142015201620162017 REVENUES: EARNINGS ON INVESTMENTS 11 $ 15 $ -$ 16 $ -$ DONATIONS - 110 - 300 - TOTAL REVENUES 11 125 - 316 - EXPENDITURES: COMMUNITY RELATIONS - - 2,500 - 2,500 BOARDS AND COMMITTEES - 14 - - - TOTAL EXPENDITURES - 14 2,500 - 2,500 NET REVENUES (EXPENDITURES)11 111 (2,500) 316 (2,500) BEGINNING BALANCE 2,469 2,480 2,479 2,591 2,907 ENDING BALANCE 2,480 2,591 (21) 2,907 407 STATEMENT OF REVENUES AND EXPENDITURES