The URL can be used to link to this page

FY19 Budget File Upload to Website as of 120718CITY OF SHERIDAN Revenue & Expenditures by Fund FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget FUND FUNDNAME Type FY15 FY16 FY17 FY18 FY2019 10 General Fund Revenue 11,153,048 11,423,249 10,607,987 11,917,239 12,238,850 Personnel 7,710,737 7,916,863 8,020,396 8,072,144 8,913,412 Contract/Occupancy 750,261 675,998 641,691 645,204 563,480 Ops/Comm Supp/Capital 2,115,557 2,285,503 2,078,725 1,947,354 3,460,243 Transfers Out 844,049 149,798 915,321 173,348 111,948 Revenues over Expenditures (267,556) 395,087 (1,048,146) 1,079,188 (810,233) 10 11 One Cent Revenue 3,632,502 3,394,273 3,173,241 3,414,092 3,400,000 Personnel 29,484 34,271 23,294 9,703 42,300 Contract/Occupancy 202,573 315,932 108,567 70,389 78,987 Ops/Comm Supp/Capital 1,907,513 1,198,844 1,836,031 1,844,860 3,391,316 Transfers Out 1,871,026 1,738,640 1,569,849 1,259,582 1,228,889 Revenues over Expenditures (378,093) 106,586 (364,500) 229,558 (1,341,492) 11 20 Special Rev Revenue 18,605,192 15,499,909 24,907,248 22,214,552 23,869,833 Personnel 181,121 181,728 128,755 326,544 418,327 Contract/Occupancy 374,363 229,993 298,026 202,728 236,651 Ops/Comm Supp/Capital 16,955,147 12,548,283 23,382,028 22,730,817 24,178,889 Transfers Out 107,770 996,910 1,403,761 1,178,646 210,000 Revenues over Expenditures 986,791 1,542,994 (305,322) (2,224,183) (1,174,034) 20 21 Cap Tax Revenue 3,308,564 3,247,092 3,033,123 3,260,007 3,100,000 Contract/Occupancy - - - - - Ops/Comm Supp/Capital 31,724 (101,004) - - - Transfers Out 4,738,532 3,439,388 2,992,000 3,288,214 3,160,007 Revenues over Expenditures (1,461,693) (91,292) 41,123 (28,207) (60,007) 21 22 Public Benefit Revenue - - 949,846 998,058 900,000 Contract/Occupancy - - 33,274 - - Transfers Out - - 866,726 949,846 998,058 Revenues over Expenditures - - 49,846 48,213 (98,058) 22 Notes: 10 -Appropriated $835,000 from cash reserves for purchase of C&C property in FY19. 11 - 20 - 21 -Additional revenue of $60,007 received over FY18 budget to be spent in FY19. 22 -Additional revenue of $98,058 received over FY18 budget to be spent in FY19. $1 million of extra spending over revenues represents funds collected in prior years for the Aquatic Center. The final payments amounting to $2 million dollars of the $4 million that the City committed to comes due during FY19. $1 million will be collected from one cent funds in FY19 and the other $1 million was collected in prior years from one cent funds and held in cash reserves. Additional FY18 revenue received over budget of $214,092 and unspent FY18 funds of $127,400 to be reappropriated in FY19. Unspent FY18 direct distribution funds of 296,605 and net project funds of $849,899 being reappropriated to FY19. Additional spending of $27,530 over revenues relates to extra advertising the Sheridan Travel & Tourism Dept wishes to spend in FY19. There is over $400k in cash reserves collected from lodging taxes over the years that is allocated to Travel & Tourism. This extra advertising spending will come out of those designated cash reserves. CITY OF SHERIDAN Revenue & Expenditures by Fund FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget FUND FUNDNAME Type FY15 FY16 FY17 FY18 FY2019 50 Sewer Revenue 2,309,262 2,351,260 2,576,157 2,629,692 2,662,980 Personnel 697,931 801,572 998,147 984,239 958,050 Contract/Occupancy 200,417 206,256 200,604 235,382 191,670 Ops/Comm Supp/Capital 512,037 383,317 630,718 689,665 920,472 Transfers Out - - 602,500 628,858 408,858 Revenues over Expenditures 898,877 960,115 144,189 91,549 183,930 51 Water Revenue 6,938,909 7,304,286 4,860,584 4,762,450 4,909,195 Personnel 2,437,502 2,605,448 1,587,333 1,608,978 1,440,600 Contract/Occupancy 534,123 546,175 333,118 332,153 250,694 Ops/Comm Supp/Capital 2,531,760 1,928,390 1,126,531 1,340,258 2,094,645 Transfers Out 3,515,336 1,180,391 1,307,633 1,142,500 1,123,000 Revenues over Expenditures (2,079,812) 1,043,882 505,970 338,561 256 52 Sanitation Revenue 4,598,434 4,559,832 4,863,097 4,879,010 5,155,448 Personnel 1,589,742 1,843,634 1,937,042 1,850,745 1,863,100 Contract/Occupancy 372,195 313,990 146,644 276,281 170,110 Ops/Comm Supp/Capital 3,491,665 2,745,750 1,853,410 1,761,910 2,657,166 Transfers Out 704,000 445,280 520,000 595,000 722,000 Revenues over Expenditures (1,559,169) (788,822) 406,001 395,073 (256,928) 52 53 Golf Course Revenue 1,130,125 525,564 524,469 622,954 505,700 Contract/Occupancy 364,044 386,031 401,084 412,985 427,900 Ops/Comm Supp/Capital 837,197 127,672 111,129 209,955 77,800 Transfers Out 11,800 12,000 12,200 - - Revenues over Expenditures (82,915) (139) 56 14 - 54 Weed & Pest Revenue 149,120 158,480 174,056 172,286 185,250 Personnel - 28,617 114,274 84,550 87,100 Contract/Occupancy 130,162 65,609 3,075 3,697 3,110 Ops/Comm Supp/Capital 162 129,098 41,777 40,161 44,240 Transfers Out 3,600 3,600 3,600 22,000 35,850 Revenues over Expenditures 15,196 (68,443) 11,330 21,877 14,950 60 Debt Service Revenue 213,527 174,701 119,004 125,116 106,348 Ops/Comm Supp/Capital 159,961 250,759 333,808 106,051 106,348 Revenues over Expenditures 53,566 (76,058) (214,804) 19,065 - Notes: 52 -Sanitation Truck budgeted for in FY18 but didn't arrive until FY19. Reappropriated $257,632 from FY18 to FY19. Detail by Fund and Department ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #FUNDNAME DEPT# DEPTNAME FY15 FY16 FY17 FY18 FY2019 1 General Fund 1100 Mayor/City Council 53,841 58,229 61,871 84,790 154,720 2 General Fund 1200 Municipal Court 117,106 136,441 130,822 141,383 196,900 3 General Fund 1300 Human Resources 226,694 231,539 229,945 234,762 298,707 4 General Fund 1310 Administration 156,613 166,358 293,837 270,875 245,930 5 General Fund 1320 Clerk 248,376 175,975 174,525 180,167 194,180 6 General Fund 1330 Treasurer 286,440 425,896 462,306 448,515 547,685 7 General Fund 1340 Information Technology 158,537 127,762 120,514 125,972 216,080 8 General Fund 1350 Attorney 103,005 45,977 62,875 121,948 95,000 9 General Fund 1360 City Hall 78,558 80,637 72,068 81,026 922,080 10 General Fund 1370 Other General 211,204 127,990 132,416 50,611 58,410 11 General Fund 1905 Travel & Tourism 43,017 56,001 60,748 51,702 66,000 12 General Fund 2400 Police 2,767,488 2,997,592 3,424,303 2,696,330 2,951,302 13 General Fund 2430 Police Communications 591,253 599,115 596,097 592,464 631,950 14 General Fund 2500 Fire & Rescue 1,596,841 1,615,587 1,580,607 1,586,298 1,613,120 15 General Fund 3647 Cemetery 93,836 155,623 164,904 146,988 149,720 16 General Fund 4610 PW Administration 106,266 90,167 88,998 200,080 - 17 General Fund 4620 Engineering 397,186 415,148 401,202 306,858 460,560 18 General Fund 4630 Planning 202,294 214,114 212,559 197,605 224,380 19 General Fund 4631 GIS 59,900 55,117 49,050 44,905 50,000 20 General Fund 4632 Building: Permits/Inspections 419,335 426,790 406,480 417,235 443,740 21 General Fund 4640 Streets 1,674,640 1,759,797 1,600,143 1,518,537 1,629,648 22 General Fund 4641 Snow Removal 405,408 180,735 506,234 443,295 451,760 23 General Fund 4644 City Service Shop 189,759 245,891 255,916 270,601 273,470 24 General Fund 4662 Customer Service - - 169 2,658 509,721 25 General Fund 5646 Parks 438,881 373,970 337,487 331,162 431,460 26 General Fund 5690 Recreation District 128,410 131,709 120,356 149,883 152,560 27 General Fund 5692 Golf Course 665,715 134,000 109,700 141,400 80,000 28 Total General Fund 11,420,603 11,028,162 11,656,133 10,838,051 13,049,083 29 30 One Cent 1100 Mayor/City Council 795 - - - - 31 One Cent 1310 Administration 2,719 - - - - 32 One Cent 1330 Treasurer - - - - - 33 One Cent 1340 Information Technology 64,787 113,921 47,355 - 492 34 One Cent 1370 Other General 898,082 885,944 1,759,017 1,709,386 2,954,806 35 One Cent 1905 Travel & Tourism 25,013 17,760 - - - 36 One Cent 2400 Police 112,923 431,681 428,415 348,521 309,166 37 One Cent 2450 Animal Shelter 74,986 96,919 92,455 87,173 98,883 38 One Cent 2500 Fire & Rescue 277,233 61,171 48,058 24,738 177,864 39 One Cent 4620 Engineering 4,476 - - - 30,000 40 One Cent 4630 Planning 2,810 - - - 23,339 41 One Cent 4632 Building: Permits/Inspections 6,834 35,267 24,733 - - 42 One Cent 4640 Streets 2,085,731 1,105,531 705,274 241,889 826,889 43 One Cent 4644 City Service Shop 22,569 - - - - 44 One Cent 5646 Parks 401,637 522,970 398,992 741,926 287,052 45 One Cent 5690 Recreation District - 16,523 33,442 30,901 33,000 46 One Cent 5692 Golf Course 30,000 - - - - 47 Total One Cent Fund 4,010,595 3,287,687 3,537,741 3,184,534 4,741,492 48 CITY OF SHERIDAN Fiscal Year 2019 Budget Detail by Fund and Department ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #FUNDNAME DEPT# DEPTNAME FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget 49 Direct Distribution1100 Mayor/City Council 12,897 7,481 7,352 9,128 - 50 Direct Distribution1300 Human Resources 13,880 - 5,545 29,186 27,915 51 Direct Distribution1310 Administration 2,330 3,597 4,464 18,318 12,500 52 Direct Distribution1320 Clerk - 227 49,773 254 97,746 53 Direct Distribution1330 Treasurer 25,000 2,611 - - 3,402 54 Direct Distribution1340 Information Technology - - 28,580 54,601 37,550 55 Direct Distribution1360 City Hall 122,916 140,422 70,545 16,125 49,678 56 Direct Distribution1370 Other General 117,682 175,700 340,466 379,263 141,800 57 Direct Distribution2400 Police 197,521 439,289 774,046 338,861 389,009 58 Direct Distribution2500 Fire & Rescue 29,746 38,646 20,015 48,299 31,201 59 Direct Distribution3647 Cemetery 146,543 257,825 97,744 42,070 38,330 60 Direct Distribution4610 PW Administration - 2,179 - - - 61 Direct Distribution4620 Engineering 55,527 87,614 53,393 161,689 50,000 62 Direct Distribution4630 Planning 79,638 33,794 52,685 41,530 77,486 63 Direct Distribution4631 GIS 29,000 24,000 29,450 29,450 55,000 64 Direct Distribution4640 Streets 307,197 928,996 592,907 411,505 648,461 65 Direct Distribution4641 Snow Removal 48,999 - 101,598 154,424 155,576 66 Direct Distribution4644 City Service Shop 19,762 16,608 16,045 12,183 21,817 67 Direct Distribution5646 Parks 23,034 66,605 106,143 105,624 116,652 68 Direct Distribution5692 Golf Course 100,000 50,000 100,000 100,000 100,000 69 Total Special Rev Fund - Direct Distribution 1,331,673 2,275,597 2,450,749 1,952,510 2,054,123 70 71 Projects 1370 Other General 164,323 348,830 68,533 162,331 99,469 72 Projects 1645 Trolley 16,799 14,110 23,236 9,973 17,450 73 Projects 1905 Travel & Tourism 682,353 583,177 571,832 546,497 633,530 74 Projects 2400 Police 275,078 591,195 2,571,483 356,209 242,160 75 Projects 2450 Animal Shelter - 25,000 - - - 76 Projects 2500 Fire & Rescue 4,915 - 340 - 182,425 77 Projects 3647 Cemetery - 671,222 156,512 5,800 12,176 78 Projects 4620 Engineering 189,218 469,133 3,138,922 1,458,482 2 79 Projects 4630 Planning 43,240 148,176 157,180 94,501 42,192 80 Projects 4632 Building: Permits/Inspections - - 19,276 30,724 25,000 81 Projects 4640 Streets 402,880 98,738 19,223 35,597 56,399 82 Projects 5646 Parks 726,063 68,687 495,677 1,336,878 489,213 83 Projects 5690 Recreation District - 91,500 - - - 84 Projects 8000 Parks 13,781,860 8,571,551 15,539,607 18,449,233 21,189,728 85 Total Special Revenue Fund - Projects 16,286,728 11,681,318 22,761,820 22,486,225 22,989,744 86 Total Special Revenue Fund 17,618,401 13,956,915 25,212,570 24,438,735 25,043,867 87 100 Cap Tax 4640 Streets 4,740,076 3,150,000 2,992,000 2,953,214 3,110,007 102 Cap Tax 5646 Parks 30,180 188,384 - 335,000 50,000 105 Total Cap Tax Fund 4,770,256 3,338,384 2,992,000 3,288,214 3,160,007 106 113 Public Benefit 2400 Police - - 60,000 - - 119 Public Benefit 4640 Streets - - 200,000 575,000 565,000 121 Public Benefit 5646 Parks - - 606,726 374,846 433,058 122 Public Benefit 5690 Recreation District - - 33,274 - - 124 Total Public Benefit Fund - - 900,000 949,846 998,058 CITY OF SHERIDAN One Cent Fund FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Sales Tax 1% - In State 1,844,501 1,749,979 1,668,692 1,726,724 1,730,000 2 Use Tax 1% - In State/Out of State 341,767 375,988 251,882 302,232 320,000 3 Sales Tax 1% - Out of State 1,265,555 1,263,861 1,244,798 1,368,576 1,350,000 6 Interest 2,347 4,445 7,870 16,560 - 8 Transfer from General Fund 178,333 - - - - 9 Total One Cent Fund Revenue 3,632,502 3,394,273 3,173,241 3,414,092 3,400,000 10 11 Salaries and Wages 11,927 13,739 9,258 4,482 15,000 12 Salaries and Wages 9,503 11,048 7,374 3,349 14,000 13 Overtime 671 139 52 - 700 14 Overtime 588 574 176 29 600 15 Payroll Taxes 174 182 121 61 500 16 Payroll Taxes 141 158 107 48 200 17 Retirement 1,464 1,613 1,082 521 2,000 18 Retirement 1,173 1,350 877 392 1,400 19 Unemployment and Worker's comp 251 252 389 61 500 20 Unemployment and Worker's comp 203 210 316 46 400 21 Employee Insurance 2,493 3,709 2,509 484 4,000 22 Employee Insurance 896 1,298 1,033 228 3,000 24 Contractual Services 29,258 4,094 6,355 - - 25 Contractual Services 126,640 215,150 - - - 26 Contractual Services 32,778 47,867 24,000 24,339 - 27 Contractual Services 26,726 25,000 25,000 28 Outside Services - 35,267 24,733 - - 30 Utilities 11,120 10,602 14,136 12,531 13,000 31 Utilities - Tennis Bubble 6,716 5,901 8,000 32 Repairs & Maint. - Buildings/grounds - - - - 9,077 33 Repairs & Maint. - Buildings/grounds 3,411 - 20,000 34 Insurance Property 307 373 419 447 1,610 35 Telephone & Internet 2,471 2,580 2,071 2,172 2,300 37 Repairs & Maint. Vehicles/Equip.15,737 - 20,000 39 Repairs & Maint. - Other 12,551 11,777 7,335 14,400 11,988 40 Repairs & Maint. - Other 12,450 3,807 11,255 14,479 15,789 41 Repairs & Maint. - Other 1,289 4,124 4,829 1,024 10,973 42 Repairs & Maint. - Other 10,698 11,675 3,665 9,850 12,764 43 Repairs & Maint. - Other 12,874 1,503 - - - 44 Equipment Non-capitalized 23,885 11,205 16,083 14,654 15,000 46 Computer Hardware 795 - - - - 47 Computer Hardware 2,719 - - - - 48 Computer Hardware 288 - - - - 49 Computer Hardware 4,476 - - - - 50 Computer Hardware 2,358 - - - - 51 Computer Hardware 6,834 - - - - 52 Software Expense - 67,216 41,000 - 492 55 Supplies 24 1,022 563 937 1,000 56 PD Range 20,445 16,951 - - - 57 PD Lab 5,209 5,885 (134) - - 58 Professional Services 13,080 1,920 - - - 59 Professional Services - - - - 38,000 62 Professional Services - - - 234 7,100 64 Professional Services 452 - - - 23,339 65 Professional Services 157,247 93,666 - - - 67 Professional Services - 23,098 24,233 22,052 70 Publications Advertising and Printing 963 1,481 1,512 453 1,500 71 Professional services 7,164 10,328 8,340 174 17,278 72 Housing/Comm Dev. - Abatement 480 875 1,055 1,977 19,919 73 Juvenile Justice JPB 130,000 130,000 115,556 115,556 115,556 CITY OF SHERIDAN One Cent Fund FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 74 Sheridan Arts Council 2,835 1,500 1,333 1,333 1,333 75 Advocacy and Resource Center 7,500 7,500 6,667 6,667 6,667 76 Affordable Housing 10,000 10,000 8,889 8,889 8,889 77 Economic Dev.- 29,221 - 78 Promotional Activities (Chamber of Commerce) 20,000 20,000 17,778 17,778 17,778 79 Economic Development (Forward Sheridan) 20,000 20,000 17,778 17,778 17,778 80 Main Street (Downtown Sheridan Assoc) 30,000 30,000 26,667 26,667 26,667 81 Historic Preservation (Museum) 22,000 22,000 19,556 19,556 19,556 83 Sheridan Community Land Trust 15,000 15,000 13,333 13,333 13,333 84 North Main Association 50,000 50,000 44,444 44,444 44,444 85 Economic Dev. - CAST - 150,000 250,000 86 University of WY Office of Sponsored Programs - - - - 80,000 87 NE WY Growth Alliance - - - - 46,000 88 Economic Dev. - Aquatic Center 1,000,000 1,000,000 2,000,000 89 Economic Dev.25,013 17,760 - - - 90 Mental Health 5,000 5,000 4,444 4,444 4,444 91 VOA 5,000 5,000 4,444 4,444 4,444 92 Child Development Center 7,500 7,500 6,667 6,667 6,667 93 Public Health 5,000 5,000 4,444 4,444 4,444 94 Free Clinic 4,000 4,000 3,556 3,556 3,556 95 Senior Center 90,000 90,000 80,000 80,000 80,000 96 CASA 7,500 7,500 6,667 6,667 6,667 97 Seniors Contingency - 5,000 - - - 98 Economic Development Contingency 218,563 164,445 107,234 120,000 - 99 Public Health/Community Programs Contingency - - - - - 100 Contingency 24,429 (1,000) 122,766 10,000 106,898 103 Dog and Cat Shelter Support 59,800 75,000 71,000 71,000 71,000 104 Capital Outlay - Land (153) - - - - 105 Capital Outlay - Aquatic Center - - - - - 107 Capital Outlay - Improvements 4,241 - - - 112 Capital Outlay - Improvements 385 - - - - 117 Capital Outlay - Improvements 109,794 474 - - - 124 Capital Outlay - Improvements Park Projects 168,733 117,118 - - - 125 Capital Outlay - Improvements 134,298 - - - - 126 Capital Outlay - Improvements 7,500 - - - - 127 Capital Outlay - Improvements - 9,307 - 10,000 129 Capital Outlay - Improvements - 16,523 - - - 131 Capital Outlay - Machinery and Equip. 22,162 40,692 - - - 132 Capital Outlay - Machinery and Equip. 12,556 - - - 142,000 133 Capital Outlay - Machinery and Equip. 3,817 38,291 9,162 - 56,000 134 Debt Service Principal - Sales Tax Payback 75,933 46,866 - - - 135 Debt Service Principal 229,669 - - - - 137 Debt Service Principal 78,233 - - - - 138 Debt Service Interest 9,164 - - - - 140 Transfer to General Fund - 300,000 100,000 141 Transfer to Special Revenue Fund - 20,688 - - 142 Transfer to Special Revenue Fund - 12,766 - - 143 Transfer to Special Revenue Fund - 86,546 - - 144 Transfer to Special Revenue Fund - 7,989 - - 145 Transfer to Special Revenue Fund - - - - - 147 Transfer to Special Revenue Fund 322,900 370,000 - - 148 Transfer to Special Revenue Fund - - - - 47,000 149 Transfer to Special Revenue Fund 1,005,630 400,000 400,000 200,000 438,000 150 Transfer to Special Revenue Fund 320,502 - - - - 151 Transfer to Special Revenue Fund 25,000 101,600 - - - 153 Transfer to Special Revenue Fund 200,000 - - - - 154 Transfer to Special Revenue Fund 145,558 48,200 16,889 24,889 190,000 CITY OF SHERIDAN One Cent Fund FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 155 Transfer to Special Revenue Fund 78,385 - - 156 Transfer to Special Revenue Fund - - 17,000 - 157 Transfer to Special Revenue Fund 28,500 300,000 210,000 - - 158 Transfer to Special Revenue Fund - 100,000 - - - 159 Transfer to Special Revenue Fund - - - - 100,000 160 Transfer to Special Revenue Fund 93,268 - - - - 161 Transfer to Special Revenue Fund - 11,391 - - - 162 Transfer to Special Revenue Fund 200 - - - 163 Transfer to Special Revenue Fund - - - - 48,889 164 Transfer to Special Revenue Fund - 50,000 - - - 165 Transfer to Special Revenue Fund - - - - 50,000 166 Transfer to Special Revenue Fund 22,569 - - - - 168 Transfer to Special Revenue Fund - 25,000 25,000 169 Transfer to Special Revenue Fund - 304,349 40,000 - - 170 Transfer to Special Revenue Fund - 199,087 122,000 125,000 171 Transfer to Special Revenue Fund - - - - 25,000 172 Transfer to Special Revenue Fund - 100,000 - 10,000 - 173 Transfer to Special Revenue Fund - 70,000 85,000 - 174 Transfer to Special Revenue Fund - 50,000 290,000 - 175 Transfer to Special Revenue Fund - - 35,000 50,000 176 Transfer to Special Revenue Fund - 100,000 - 177 Transfer to Special Revenue Fund - 40,000 - 178 Transfer to Special Revenue Fund - - - - 30,000 179 Transfer to Special Revenue Fund - 7,500 - - 180 Transfer to Special Revenue Fund - - - - 181 Transfer to Other Projects - - - 10,693 - 182 Transfer to Golf 30,000 - - - - 183 Total One Cent Fund Expenditures 4,010,595 3,287,687 3,537,741 3,184,534 4,741,492 184 Revenues over Expenditures (378,093) 106,586 (364,500) 229,558 (1,341,492) Project Index #11 #2401 - School Resource Officer #12 #2412 - COPS Hiring Grant #13 #2401 - School Resource Officer #14 #2412 - COPS Hiring Grant #15 #2401 - School Resource Officer #16 #2412 - COPS Hiring Grant #17 #2401 - School Resource Officer #18 #2412 - COPS Hiring Grant #19 #2401 - School Resource Officer #20 #2412 - COPS Hiring Grant #21 #2401 - School Resource Officer #22 #2412 - COPS Hiring Grant #24 IT #25 Other General - Contingency #26 Police - Safe Rides #27 Recreation District #28 #5311 - Downtown Dev Initiative #30 Dog & Cat Shelter #31 Recreation District #32 Police #33 Roof membrane and concrete repair at Fire Station #34 Dog & Cat Shelter #35 Dog & Cat Shelter #39 #5304 - Sculpture/ Public Arts #40 Police CITY OF SHERIDAN One Cent Fund FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 #41 Dog & Cat Shelter #42 Fire #43 Parks #44 Fire #46 Mayor/City Council #47 Administration #48 IT #49 Engineering #50 Planning #51 Building: Permits/Inspections #52 IT #55 #5304 - Sculpture/ Public Arts #56 Police #57 Police #58 IT #59 SEEDA Administrator Contribution #64 Planning #65 #5705 - Army Corps of Engineers Study #67 #5712 - Park Improvements #70 #5304 - Sculpture/ Public Arts #71 #5304 - Sculpture/ Public Arts #77 NE WY Growth Alliance #105 #5320 - Aquatic Center #107 #5711 - Dog & Cat Shelter Improvements #112 #4725 - West Downtown #117 #4730 - 319 Funding #118 #4742 - Loucks St & Waterline Replacement #124 #5712 - Park Improvements #125 #5727 - Community Drainage #126 Recreation District #128 IT #129 Police #130 Fire #132 Fire #134 Parks #135 Fire #137 Police - Refund General Fund cash reserves #138 Seniors Contingency #139 Economic Development Contingency #140 Unbudgeted Contingency #141 Public Safety Contingency #142 Police #143 #2412 - COPS Hiring Grant #144 #2450 - Police Dept Remodel #145 #4701 - Street Overlay Program #146 #4703 - Wyo/Park Street #147 #4704 - Lewis Street #148 #2502 - Exhaust Capture System & Gearing Cleaning Eqpt #150 #4726 - Illinois #151 #4729 - N. Sheridan Interchange #152 #4730 - 319 Funding #153 #4740 - East Downtown Improvements #154 #4742 - Loucks St & Waterline Replacement #155 #4747 - Holloway St Construction #156 #4853 - North West Water Loop #157 #4860 - Downtown Parking Development #158 #4861 - Traffic Striping & Sign Updates CITY OF SHERIDAN One Cent Fund FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 #159 #4759 - E 5th St Corridor #160 #5701 - Pathways #161 #4702 - Service Center #162 Parks #163 #4801 - City Crushing Project #164 #5701 - Pathways #165 #5705 - Army Corps of Engineers Study #166 #5708 - Cemetery Building #167 #5709 - W 5th St Park #168 #5710 - Kendrick Park Improvements #169 #5712 - Park Improvements #170 #5714 - Fishing Pond #171 #5716 - Sheridan Multi-Use Pathway Connection #172 #5726 - North Park Stream Improvements #173 Recreation District #178 #5717 - Kendrick Pool Design/Engineering Assessment #181 #5712 - Park Improvements CITY OF SHERIDAN Cap Tax Fund FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Capital Facilities Tax 3,304,408 3,244,793 3,029,917 3,252,142 3,100,000 2 Interest 4,155 2,299 3,206 7,865 - 3 Total Cap Tax Fund Revenue 3,308,564 3,247,092 3,033,123 3,260,007 3,100,000 4 7 Capital Outlay - Infrastructure 1,545 (101,004) - - - 16 Capital Outlay - Improvements 30,180 - - - - 22 Transfer to Special Revenue Fund 100,000 - - - - 23 Transfer to Special Revenue Fund 796,232 100,000 - - - 24 Transfer to Special Revenue Fund 1,086,654 325,000 - - - 25 Transfer to Special Revenue Fund 272,747 - - - 27 Transfer to Special Revenue Fund - 50,000 115,000 300,000 175,000 28 Transfer to Special Revenue Fund 2,705,645 - - - - 29 Transfer to Special Revenue Fund - 403,258 177,000 915,000 2,490,000 30 Transfer to Special Revenue Fund - - - 20,000 - 31 Transfer to Special Revenue Fund - - 80,000 - 32 Transfer to Special Revenue Fund - 650,000 1,900,000 1,638,214 160,007 33 Transfer to Special Revenue Fund 50,000 13,332 - - - 34 Transfer to Special Revenue Fund - 300,000 450,000 - - 35 Transfer to Special Revenue Fund 50,000 - - - 36 Transfer to Special Revenue Fund - 450,000 350,000 - - 37 Transfer to Special Revenue Fund 225,000 - - - 38 Transfer to Special Revenue Fund - 361,668 - - - 39 Transfer to Special Revenue Fund 50,000 - - - 40 Transfer to Special Revenue Fund - - - - 285,000 41 Transfer to Special Revenue Fund - 100,000 - - - 42 Transfer to Special Revenue Fund - 50,000 - - - 43 Transfer to Special Revenue Fund - 38,384 - 335,000 50,000 44 Total Cap Tax Fund Expenditures 4,770,256 3,338,384 2,992,000 3,288,214 3,160,007 45 Revenues over Expenditures (1,461,693) (91,292) 41,123 (28,207) (60,007) Project Index #7 #4706 - North Main #16 Kendrick Park Creek Stabilization #22 #4701 - Street Overlay Program #23 #4703 - Wyo/Park Street #24 #4704 - Lewis Street #25 #4706 - North Main #26 #4724 - S. Downtown Neighborhood #27 #4725 - West Downtown #28 #4726 - Illinois #29 #4729 - N. Sheridan Interchange #30 #4730 - 319 Funding #31 #4740 - East Downtown Improvements #32 #4742 - Loucks St & Waterline Replacement #33 #4746 - 5th & Long Intersection #34 #4747 - Holloway St Construction #35 #4748 - E 5th St Infrastructure #36 #4750 - W 5th St Reconstruction SUSAC #37 #4751 - 5th St Waterline Replacement #38 #4752 - High School Access to Mydland Rd #39 #4754 - N. End Infrastructure Extension #40 #5317 - Hillslide Stabilization Project #41 #5701 - Pathways #42 #5709 - W 5th St Park #43 #5710 - Kendrick Park Improvements CITY OF SHERIDAN Public Benefit Fund FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Franchise Tax - 949,846 998,058 900,000 2 Total Public Benefit Fund Revenue - - 949,846 998,058 900,000 3 4 Contractual Services 33,274 - - 5 Transfer to General Fund - 100,000 100,000 6 Transfer to Special Revenue Fund 60,000 - - 7 Transfer to Special Revenue Fund - 200,000 185,000 200,000 8 Transfer to Special Revenue Fund - - 390,000 150,000 9 Transfer to Special Revenue Fund - - - - 25,000 10 Transfer to Special Revenue Fund - - - - 100,000 11 Transfer to Special Revenue Fund - - - - 90,000 12 Transfer to Special Revenue Fund - - - - 50,000 13 Transfer to Special Revenue Fund - 22,000 - - 14 Transfer to Special Revenue Fund - - 40,000 125,000 15 Transfer to Special Revenue Fund - 45,000 - - 16 Transfer to Special Revenue Fund 55,000 - 100,000 17 Transfer to Special Revenue Fund - 50,000 90,000 50,000 18 Transfer to Special Revenue Fund - 241,726 50,000 - 19 Transfer to Special Revenue Fund - 94,846 8,058 20 Transfer to Special Revenue Fund - 15,000 - - 21 Transfer to Special Revenue Fund 178,000 - - 23 Total Public Benefit Fund Expenditures - - 900,000 949,846 998,058 24 Revenues over Expenditures - - 49,846 48,213 (98,058) Project Index #6 #2450 - Police Dept Remodel #7 #4701 - Street Overlay Program #8 #4729 - N. Sheridan Interchange #9 #4740 - East Downtown Improvements #10 #4742 - Loucks St & Waterline Replacement #11 #4759 - E 5th St Corridor #12 #5700 - Parks & Recreation Master Plan #13 #5701 - Pathways #14 #5705 - Army Corps of Engineers Study #15 #5708 - Cemetery Building #16 #5709 - Blacktooth Park #17 #5710 - Kendrick Park Improvements #18 #5712 - Park Improvements #19 #5713 - DoubleDay Sports Complex #20 #5714 - North Park Habitat Enhancement #21 #5716 - Sheridan Multi-Use Pathway Connection CITY OF SHERIDAN Direct Distribution Funds FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Supplemental 1,990,141 2,202,788 1,980,333 1,744,913 1,762,809 2 Transfer from Other Projects 7,461 - - 3 Total Supplemental Revenue 1,990,141 2,202,788 1,987,794 1,744,913 1,762,809 4 5 Other Employee Exp - Safety - 5,545 3,686 27,915 6 Contractual Services - 215 12,294 12,500 8 Contractual Services - 77,700 73,176 129,000 9 Outside Services 135,869 23,853 - - - 10 Repairs & Maint. - Buildings/grounds - 16,147 2,201 12 Utilities - Other than Building 203,197 - - - - 13 Repairs & Maint. Vehicles/Equip 31 52,968 55,104 50,000 14 Repairs & Maint. - Other 10,503 - 6,790 16,125 9,678 15 Repairs & Maint. - Irrigation - - 15,890 - - 16 Concrete Repair - 43,348 44,728 60,000 17 Equipment Rentals - - - - 30,000 18 Equipment Rentals - - 33,341 85,672 75,000 19 Equipment Non-capitalized - 15,090 - - - 20 Computer Hardware - 993 - 4,300 21 Computer Hardware - 13,036 13,790 6,000 22 Computer Hardware - 2,241 2,441 4,000 23 Computer Hardware 970 - - - 24 Computer Hardware 2,179 - - - 25 Computer Hardware - - - - 2,000 26 Computer Hardware 1,074 - - - - 27 Software Expense - 13,000 - 6,250 28 Software Expense - - - - 1,000 29 Software Expense - - - 2,500 30 Supplies 443 82 2,780 416 - 31 Supplies 6,428 39,696 5,487 - 5,000 32 Supplies 48,999 - 68,257 68,753 80,576 33 Supplies 14,553 16,608 13,999 11,964 21,817 34 Supplies 13,674 26,669 31,512 15,157 30,000 35 Gasoline Oil Diesel Supplies 50,042 - - - - 36 Gasoline Oil Diesel Supplies 7,981 5,069 2,377 - - 37 Gasoline Oil Diesel Supplies 4,246 2,596 4,064 4,800 - 38 Gasoline Oil Diesel Supplies 9,360 6,699 8,372 8,292 - 39 PD Range - - 15,868 16,347 17,000 40 PD Lab - - 5,278 4,925 6,000 41 Professional Services 13,880 - - 25,500 - 42 Professional Services - 227 49,773 254 97,746 43 Professional Services 25,000 - - - - 44 Professional Services 90 10,190 12,698 - - 45 Professional Services 19,250 50,000 170,000 120,000 120,000 46 Professional Services - 25,028 32,862 30,000 47 Professional Services - 12,924 27,224 22,000 48 Professional Services - - 21,216 14,673 10,000 49 Professional Services 55,527 87,614 53,393 13,861 50,000 50 Professional Services 71,371 33,794 27,685 - 50,486 51 Professional Services 29,000 24,000 29,450 29,450 55,000 52 Professional Services 4,134 - 2,047 219 - 53 Professional Services 1,720 52,941 46,755 40,000 54 Travel, Training & Memberships 12,454 7,399 4,572 8,712 - 55 Travel, Training & Memberships 2,330 3,597 4,249 6,024 - 56 Travel, Training & Memberships 2,611 - - - 58 Publications Advertising and Printing 22,499 20,700 18,600 19,263 21,800 59 Public Safety - 2,472 2,487 3,000 60 Other - Supplemental Contingency - - - - 3,402 CITY OF SHERIDAN Direct Distribution Funds FY2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 61 Capital Outlay - Improvements - - - - - 62 Capital Outlay - Improvements 112,323 130,232 51,058 - 40,000 63 Capital Outlay - Improvements - - - 24,303 29,009 64 Capital Outlay - Improvements 21,765 18,488 - - - 66 Capital Outlay - Improvements - - - 240 - 67 Capital Outlay - Improvements - 68,583 15,800 12,445 - 68 Capital Outlay - Improvements 31,517 13,317 - - 69 Capital Outlay - Machinery and Equip - - 14,587 54,601 27,000 70 Capital Outlay - Machinery and Equip 147,360 83,428 105,458 51,354 121,000 71 Capital Outlay - Machinery and Equip - 51,087 22,597 23,330 72 Capital Outlay - Machinery and Equip 103,999 460,413 258,759 254,332 518,961 74 Capital Outlay - Machinery and Equip - - - 35,420 46,652 75 Debt Service Principal - Sales Tax Payback 75,933 105,000 151,866 - - 77 Transfer to Special Revenue Project - 240,000 - 78 Transfer to Special Revenue Project 355,830 478,711 67,000 - 79 Transfer to Special Revenue Project - 190,711 - - - 80 Transfer to Special Revenue Project - - - 147,589 - 81 Transfer to Special Revenue Project 7,770 - 25,000 41,530 25,000 82 Transfer to Special Revenue Project - 400,000 275,000 100,000 37,000 83 Transfer to Golf Course 100,000 50,000 100,000 100,000 100,000 84 Total Supplemental Expenditures 1,331,056 2,275,597 2,450,749 1,952,510 2,054,123 85 Revenues over Expenditures 659,085 (72,809) (462,956) (207,597) (291,314) #8 Spillman Contract, Motorola, Cleaning offices, Promotion testing #10 Repairs to concrete and tile #12 Utilities for City-wide street lighting FY15 #15 Raw water irrigation pump replacement in FY17 #22 Replace computers #31 Initial costs to supply new cemetery building #34 Pathway repairs, playground equipment repairs/upgrades #41 Potential pay study #42 Election Costs in FY17 - FY19 Election Costs $63k & Website Redesign $30k #45 Rocky Mountain Ambulance #47 Annual physicals & doctor contract #51 FY19 Additional $25k requested to complete aerial photography for City boundary #53 Janitorial services, contract mowing, portable toilets #58 Social Media #59 Public education supplies, pamphlets #63 New gate and fence, electrical, insulation, & gravel road #70 New tasers, AEDs #71 FY18 upgraded to better mower #72 FY18 Snow plow, durapatcher, 1 ton dump truck, crack sealer #72 FY19 sweeper, 5yd dump truck w/ plow, bldg dept truck, leasing equipment instead of buying #74 Part of mower replacement plan #77 CAST & WYO Theater roof repair #78 FY18 - Furniture, body cam grant match #80 FY18 - #81 Downtown Initiative Program #82 Rotomill Overlay Page 50 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 33,231 35,862 36,254 59,308 108,300 3 Payroll Taxes 2,084 2,220 2,540 4,476 8,300 4 Retirement - 4,900 5 Unemployment and Worker's comp 335 361 682 547 2,000 6 Employee Insurance - - 458 - 10,100 8 Insurance Property 3,656 4,446 5,003 5,331 - 9 Telephone & Internet 1,572 1,705 331 359 1,000 10 Repairs & Maint. Vehicles/Equip.224 2,500 11 Copier & Printer Costs - 9 - 242 200 12 Computer Hardware - 220 - 900 13 Supplies - - - 500 14 Insurance Liability 12,963 13,627 16,384 14,303 1,020 15 Travel, Training & Memberships - - - - 12,000 16 Publications Advertising and Printing - - - - 3,000 17 Total General Fund 53,841 58,229 61,871 84,790 154,720 18 19 One Cent Fund 20 Computer Hardware 795 - - - 21 Total One Cent Fund 795 - - - - 22 23 Special Revenue Fund - Direct Distribution 24 Supplies 443 82 2,780 416 - 25 Travel, Training & Memberships 12,454 7,399 4,572 8,712 - 26 Total Special Rev Fund - Direct Distribution 12,897 7,481 7,352 9,128 - #2-6 FY19 - moved executive assistant to Mayor's budget from Administration budget #8 FY19 - New allocation formula for insurance #10 Maintenance for Mayor's vehicle #12 New computer for Mayor #14 FY19 - New allocation formula for insurance #15 FY19 - moved from direct distribution #16 FY19 - costs originally included with exec/admin budget, but are splitting into the separate departments going further #25 FY19 - moved to general fund CITY OF SHERIDAN Fiscal Year 2019 Budget Mayor/City Council Page 93 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 24,330 35,112 35,996 36,072 37,300 4 Overtime 90 200 264 351 300 5 Payroll Taxes 1,803 2,576 2,561 2,576 2,900 6 Retirement 2,121 3,394 3,490 3,323 3,800 7 Unemployment and Worker's comp 577 650 1,241 903 1,100 8 Employee Insurance 2,877 5,673 11,521 13,750 16,000 9 Contractual Services 2,547 2,523 - - - 10 Telephone & Internet 596 301 713 773 750 11 Computer Hardware 939 - - 1,313 - 12 Software Expense - - - - 50,000 13 Supplies 179 - - - 14 Office Supplies 2,075 4,122 1,761 2,055 2,650 15 Professional Services 79,003 81,097 73,125 79,916 81,200 16 Insurance Liability - 350 17 Travel, Training & Memberships 148 569 150 31 550 18 Job Recruitment Costs 282 - 19 Miscellaneous 46 - 38 - 20 Total General Fund 117,106 136,441 130,822 141,383 196,900 #4 FY18 up due to catch-up needed from Full Court system being down periodically and scanning and shredding catch-up #9 All expenses historically paid for from this account in FY17 to present are placed under line #14. #11 New desktop in FY18. No replacements scheduled for FY19. #12 Proposed municipal court software program. Estimate: - $50k in year one; $5k/yr thereafter. #13 All supplies are typically office supplies with exception to FY16. No other supplies needed in FY19. #14 Various forms and office supplies -$1500 , Statute and Court Rules annual volumes $450, postage $700. #15 Increase $7,600 for Judge & Attorney expenses ($77,600) due to more "must appear" citiations, Scan/shred services $3600 #15 FY18 expenditures up - attorney's Ordinance Change work (Jan-Mar '18) - no FY19 expenses of this nature expected. #16 FY19 - New allocation formula for insurance #17 State Municipal Court Conference is in early May. New Clerk will not be attending in FY18. Will use funds in FY19 #19 FY18 expense was a reimbursement for a restitution overpayment CITY OF SHERIDAN Fiscal Year 2019 Budget Municipal Court Page 14 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 133,580 141,544 140,642 134,660 141,200 3 Payroll Taxes 9,695 10,522 10,763 10,559 10,800 4 Retirement 11,861 13,634 13,536 12,563 14,300 5 Unemployment and Worker's comp 3,054 2,616 4,832 3,379 4,000 6 Employee Insurance 16,748 16,865 16,848 22,289 28,000 7 Other Employee Expenses - - 211 - - 8 Other Employee Exp - Wellness 12,635 15,700 18,182 20,083 25,000 9 Other Employee Exp - Safety 12,563 1,015 - - 10,000 11 Contractual Services 11,199 11,423 11,411 13,190 12,000 12 Telephone & Internet 1,530 2,274 2,508 2,489 2,300 13 Copier & Printer Costs - 836 1,010 1,471 1,000 14 Computer Hardware 951 - 350 663 - 15 Software Expense - - - - 387 16 Supplies 270 - - - - 17 Office Supplies 2,508 2,715 2,040 2,178 1,900 19 Professional Services - - - - 5,000 20 Insurance Liability - 1,320 21 Travel, Training & Memberships 9,257 12,025 7,365 9,291 9,000 22 Job Recruitment Costs - 1,514 32,000 23 Publications Advertising and Printing 847 370 247 432 500 24 Total General Fund 226,694 231,539 229,945 234,762 298,707 25 26 Special Revenue Fund - Direct Distribution 27 Other Employee Exp - Safety - 5,545 3,686 27,915 28 Professional Services 13,880 - - 25,500 - 29 Publications Advertising and Printing - - - - - 30 Total Special Rev Fund - Direct Distribution 13,880 - 5,545 29,186 27,915 #8 At the present time 45 employees participate in the wellness program #9 FY 15, FY17 & FY18 in direct distribution; other years in general fund - FY15 was spent on Safety Jackpot program #11 MSEC, EAP, Employers Unity, BCBS Flex Fee #16 Combined with Office Supplies #17 FMLA paperwork now sent by certified mail #19 FY19 Training and Consulting Services; was included in employee travel and training in previous years #20 FY19 - New allocation formula for insurance #22 City consolidated all job recruitment costs into one line item in the HR budget in FY19 #27 Safety BBQ $1500; National Safety Program $700 #27 FY17 & FY18 in direct distribution; other years in general fund #28 FY18 - Condrey pay study CITY OF SHERIDAN Human Resources Fiscal Year 2019 Budget Page 52 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 80,458 87,992 162,436 188,064 158,100 3 Part-time/Seasonal Wages 31,620 23,169 18,246 6,955 - 4 Overtime 814 399 1,310 5 - 5 Payroll Taxes 8,326 8,145 14,007 13,876 12,100 6 Retirement 6,955 8,503 14,598 18,607 16,000 7 Unemployment and Worker's comp 1,564 1,232 4,929 4,955 4,400 8 Employee Insurance 13,527 12,243 13,339 15,892 6,600 9 Employee Allowance - Housing/Car - 6,150 4,800 4,800 10 Contractual Services 3,896 133 - 4,350 24,650 11 Telephone & Internet 1,576 2,624 3,608 3,951 2,800 13 Computer Hardware - 2,796 - - 14 Software Expense - 2,388 - 16 Office Supplies 3,866 4,739 6,236 4,819 2,500 17 Gasoline Oil Diesel Supplies 92 - - 18 Professional Services 3,206 11,643 15,711 1,481 5,000 19 Insurance Liability - - - - 1,480 20 Travel, Training & Memberships 99 - - - 6,500 21 Job Recruitment Costs - 27,073 342 - 22 Publications Advertising and Printing 706 5,535 3,305 390 1,000 23 Total General Fund 156,613 166,358 293,837 270,875 245,930 24 25 One Cent Fund 26 Computer Hardware 2,719 - - - - 27 Total One Cent Fund 2,719 - - - - 28 29 Special Revenue Fund - Direct Distribution 30 Contractual Services - 215 12,294 12,500 31 Travel, Training & Memberships 2,330 3,597 4,249 6,024 - 32 Total Special Rev Fund - Direct Distribution 2,330 3,597 4,464 18,318 12,500 #2-8 FY19 - moved executive assistant to Mayor's budget from Administration budget #10 FY18 - Fire services study #15 Combined with office supplies #16 Moved supplies line item to this account #18 Fees for consultant visits, etc #19 FY19 - New allocation formula for insurance #21 Job recruiting costs for City Administrator #30 FY18 - Agenda management software and training ($9,400) CITY OF SHERIDAN Fiscal Year 2019 Budget Administration Page 56 Page 57 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 112,572 83,657 99,048 87,182 93,700 3 Part-time/Seasonal Wages 10,159 - - 6,941 - 4 Overtime 3,861 894 224 41 400 5 Payroll Taxes 9,460 6,494 7,393 6,862 7,200 6 Retirement 9,091 8,134 9,054 7,150 9,500 7 Unemployment and Worker's comp 2,963 1,532 7,374 10,672 2,600 8 Employee Insurance 11,254 5,771 4,480 10,372 12,300 9 Employee Allowance - Housing/Car - 2,198 - - - 10 Contractual Services - 250 - - 11 Telephone & Internet 2,251 3,617 1,249 1,259 2,300 12 Repairs & Maint. - Other 300 - - - - 13 Computer Hardware 2,118 - 188 - 1,200 14 Software Expense - - - - 9,300 15 Supplies 5,794 3,477 2,687 2,349 - 16 Office Supplies 3,314 1,925 2,000 2,061 4,800 17 Gasoline Oil Diesel Supplies 281 145 48 17 - 18 Professional Services 37,807 25,758 20,019 18,037 17,500 19 Insurance Liability - 880 20 Travel, Training & Memberships 13,342 6,720 2,029 6,984 7,500 21 Job Recruitment Costs 668 342 - 22 Publications Advertising and Printing 23,810 25,655 17,813 19,900 25,000 23 Total General Fund 248,376 175,975 174,525 180,167 194,180 24 25 Special Revenue Fund - Direct Distribution 26 Professional Services - 227 49,773 254 97,746 27 Total Special Rev Fund - Direct Distribution - 227 49,773 254 97,746 #2 Includes FTE - Administrative Asst. #2-8 Variance is due to staff changes #14 Agenda Management Software and Laserfiche - Moved from Professional Services #15 FY19 combined with office supplies #16 FY19 combined supplies into this line item #18 Laserfiche and Election Costs in FY15, Finance Director Search in FY16 #19 FY19 - New allocation formula for insurance #20 Increased costs to obtain CMC Certification for City Clerk & clerk training for admin assistant #22 Critial line item which covers costs for City legal advertising #26 FY19 - Election Costs ($63k) and Website Redesign ($30k); FY17 - Election costs CITY OF SHERIDAN Fiscal Year 2019 Budget Clerk Page 16 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 145,024 222,333 265,120 248,257 299,900 3 Part-time/Seasonal Wages - - - - - 4 Overtime 2,971 3,056 883 1,158 1,400 5 Payroll Taxes 10,832 17,065 19,725 18,382 23,000 6 Retirement 13,129 21,682 25,589 22,212 30,400 7 Unemployment and Worker's comp 3,366 4,106 9,115 5,764 8,400 8 Employee Insurance 17,363 24,038 27,938 27,967 45,100 9 Employee Allowance - Housing/Car - 2,198 - - - 10 Telephone & Internet 2,250 2,351 1,763 2,406 2,600 11 Copier & Printer Costs 1,085 1,536 1,393 2,307 1,700 12 Computer Hardware - 2,642 1,015 - 900 13 Software Expense - 1,449 325 325 14 Supplies 5,564 6,562 5,185 4,915 5,000 16 Professional services 75,480 112,084 99,305 108,340 120,000 17 Insurance Liability 510 483 563 566 2,810 18 Travel, Training & Memberships 4,649 5,760 3,243 5,915 6,100 19 Publications Advertising and Printing 4,214 - 20 - 50 20 Total General Fund 286,440 425,896 462,306 448,515 547,685 21 27 Special Revenue Fund - Direct Distribution 28 Professional Services 25,000 - - - - 29 Travel and Training - 2,611 - - - 30 Other - Supplemental Contingency - - - - 3,402 31 Total Special Rev Fund - Direct Distribution 25,000 2,611 - - 3,402 #2-8 Full-time Treasurer position added - instead of 50% Treasurer and 50% Clerk #14 Postage, year end tax forms (W2s & 1099s), paper, envelopes, and other office supplies #16 Audit fees, software annual maintenance costs, banking fees #17 FY19 - New allocation formula for insurance #28 Some professional services were paid out of Direct Distribution funds in FY15 instead of general fund #29 Some travel & training costs were paid out of Direct Distribution funds in FY16 instead of general fund CITY OF SHERIDAN Fiscal Year 2019 Budget Treasurer Page 90 Page 91 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages - 78,100 3 Payroll Taxes - 6,000 4 Retirement - 7,900 5 Unemployment and Worker's comp - 2,200 6 Employee Insurance - 16,400 7 Contractual Services 146,504 115,013 118,005 120,429 - 8 Telephone & Internet 602 4,619 2,173 1,139 2,000 9 Computer Hardware - - - 74 6,100 10 Software Expense - - - 2,580 59,100 11 Supplies - - - - 500 12 Office Supplies - - - - 250 13 Professional services 11,431 8,130 336 1,750 35,800 14 Insurance Liability - - - - 730 15 Travel, Training & Memberships - - - - 1,000 17 Total General Fund 158,537 127,762 120,514 125,972 216,080 18 19 One Cent Fund 20 Contractual Services 29,258 4,094 6,355 - - 22 Computer Hardware 288 - - - - 23 Software Expense - 67,216 41,000 - 492 24 Professional Services 13,080 1,920 - - - 25 Capital Outlay - Machinery and Equip. 22,162 40,692 - - - 26 Total One Cent Fund 64,787 113,921 47,355 - 492 27 28 Special Revenue Fund - Direct Distribution 29 Computer Hardware - 993 - 4,300 30 Software Expense - 13,000 - 6,250 32 Capital Outlay - Machinery and Equip - - 14,587 54,601 27,000 33 Total Special Rev Fund - Direct Distribution - - 28,580 54,601 37,550 34 35 Total IT 223,324 241,684 196,449 180,573 254,122 #2-6 New Position Request - IT Manager salary and benefits #7 Budget not needed. Budget moved & proposed to be funded from lines #1-#5 ($115K) and line #10 ($11,400) #8 FY 19 includes annual costs for phone and internet ($1,150) plus $850 cell phone stipend for IT Manager position. #9 Signal Booster ($1,300), fiber connector ($1,300), New cameras in Council Chamber ($3,500) #10 Google 1 year renewal - $27,350 , Microsoft server licensing ($25K), firewall renewal ($5K), Antivirus 3 yr ($3.5K) #13 Swagit Council recording and indexing ($11.4k), Council mtg/ Planning Comm. audio -video ($14.4k), Misc. IT support ($10k) #14 FY19 - New allocation formula for insurance #20 FY 18 roll-over of unexpended funds. No expense expected for FY 18. #23 FY16 & FY17 expenses were for Google implementation and 3-yr licensing; FY18 budgeted represents unexpended funds. #25 One time costs for Swagit video recording equipment and annuall service fees in FY 15 and FY16 #32 Replace Laytronics TV Broadcasting box ($15k), replace Kendrick Park cameras & install City Hall security cameras ($12k) CITY OF SHERIDAN Fiscal Year 2019 Budget Information Technology Page 54 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Outside Services - Arbitration 51,446 3,332 1,498 - - 3 Professional services 51,560 42,645 61,377 121,948 95,000 4 Total General Fund 103,005 45,977 62,875 121,948 95,000 CITY OF SHERIDAN Fiscal Year 2019 Budget Attorney Page 28 City Hall ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 3 Utilities 22,004 18,048 19,947 21,847 17,000 4 Insurance Property - 10,790 5 Repairs & Maint. Vehicles/Equip. - 421 - - 6 Repairs & Maint. - Other 15,938 19,873 15,325 18,099 19,000 7 Supplies 2,547 2,454 2,653 3,778 3,700 8 Professional Services 37,296 39,420 32,727 36,386 36,500 9 Insurance Vehicle 177 216 243 259 90 10 Insurance Liability 596 626 753 657 - 11 Capital Outlay - Buildings - - - - 835,000 12 Total General Fund 78,558 80,637 72,068 81,026 922,080 13 14 Special Revenue Fund - Direct Distribution 15 Repairs & Maint. - Other 10,503 - 6,790 16,125 9,678 16 Professional Services 90 10,190 12,698 - - 18 Capital Outlay - Improvements 112,323 130,232 51,058 - 40,000 19 Total Special Rev Fund - Direct Distribution 122,916 140,422 70,545 16,125 49,678 #4 FY19 - New allocation formula for insurance #6 City Hall maintenance - elevator, sprinkler & generator maintenance #8 Building cleaning and floor mats - new bi-annual bid for cleaning services in FY19 #9 FY19 - New allocation formula for insurance #10 FY19 - New allocation formula for insurance #11 FY19 - Purchase of C&C Property #18 New carpet and chamber improvements CITY OF SHERIDAN Fiscal Year 2019 Budget Page 18 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Other Employee Expenses 10,658 8,533 9,982 11,622 10,500 5 Insurance Property - 15,010 6 Professional Services 22,212 22,434 22,434 22,210 22,900 8 Economic Dev.- 100,000 16,779 10,000 9 Capital Outlay - Land 97,023 - - - 10 Transfer to One Cent 178,333 - - - - 11 Total General Fund 211,204 127,990 132,416 50,611 58,410 12 13 One Cent Fund 14 Contractual Services 126,640 215,150 - - - 15 Repairs & Maint. - Other 12,551 11,777 7,335 14,400 11,988 16 Supplies 24 1,022 563 937 1,000 17 Professional Services - - - - 38,000 19 Publications Advertising and Printing 963 1,481 1,512 453 1,500 20 Professional services 7,164 10,328 8,340 174 17,278 21 Housing/Comm Dev. - Abatement 480 875 1,055 1,977 19,919 22 Juvenile Justice JPB 130,000 130,000 115,556 115,556 115,556 23 Sheridan Arts Council 2,835 1,500 1,333 1,333 1,333 24 Advocacy and Resource Center 7,500 7,500 6,667 6,667 6,667 25 Affordable Housing 10,000 10,000 8,889 8,889 8,889 26 Economic Dev.- 29,221 - 27 Promotional Activities (Chamber of Commerce)20,000 20,000 17,778 17,778 17,778 28 Economic Development (Forward Sheridan) 20,000 20,000 17,778 17,778 17,778 29 Main Street (Downtown Sheridan Assoc) 30,000 30,000 26,667 26,667 26,667 30 Historic Preservation (Museum) 22,000 22,000 19,556 19,556 19,556 32 Sheridan Community Land Trust 15,000 15,000 13,333 13,333 13,333 33 North Main Association 50,000 50,000 44,444 44,444 44,444 34 Economic Dev. - CAST - 150,000 250,000 35 University of WY Office of Sponsored Programs - - - - 80,000 36 NE WY Growth Alliance - - - - 46,000 37 Economic Dev. - Aquatic Center 1,000,000 1,000,000 2,000,000 38 Mental Health 5,000 5,000 4,444 4,444 4,444 39 VOA 5,000 5,000 4,444 4,444 4,444 40 Child Development Center 7,500 7,500 6,667 6,667 6,667 41 Public Health 5,000 5,000 4,444 4,444 4,444 42 Free Clinic 4,000 4,000 3,556 3,556 3,556 43 Senior Center 90,000 90,000 80,000 80,000 80,000 44 CASA 7,500 7,500 6,667 6,667 6,667 45 Seniors Contingency - 5,000 - - - 46 Economic Development Contingency 218,563 164,445 107,234 120,000 - 47 Public Health/Community Programs Contingency - - - - - 48 Contingency 24,429 (1,000) 122,766 10,000 106,898 51 Debt Service Principal - Sales Tax Payback 75,933 46,866 - - - 52 Transfer to Special Revenue Fund - 20,688 - - 53 Transfer to Special Revenue Fund - 12,766 - - 54 Transfer to Special Revenue Fund - 86,546 - - 55 Transfer to Special Revenue Fund - 7,989 - - 56 Total One Cent Fund 898,082 885,944 1,759,017 1,709,386 2,954,806 57 58 Special Revenue Fund - Direct Distribution 61 Professional Services 19,250 50,000 170,000 120,000 120,000 62 Publications Advertising and Printing 22,499 20,700 18,600 19,263 21,800 63 Debt Service Principal - Sales Tax Payback 75,933 105,000 151,866 - - 64 Transfer to Special Revenue Project - 240,000 - 65 Total Special Rev Fund - Direct Distribution 117,682 175,700 340,466 379,263 141,800 66 CITY OF SHERIDAN Fiscal Year 2019 Budget Other General ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Other General 67 Special Revenue Fund - Projects 69 Economic Dev. - CAST - - - 100,000 - 70 Capital Outlay - Improvements 13,750 348,830 68,533 50,931 99,469 71 Professional Services - - - 11,400 - 73 Improvements - WYO Theatre 150,573 - - - - 74 Total Special Revenue Fund - Projects 164,323 348,830 68,533 162,331 99,469 75 Total Special Revenue Fund 282,005 524,530 408,999 541,594 241,269 #2 Drug Screens, Sick Leave Awards, Employee Recognition Party #5 FY19 - New allocation formula for insurance #6 WAM Membership Dues #8 FY17 CAST support; FY18 NE WY Growth Alliance; FY19 Estimated costs to hold WAM convention in Sheridan, WY #10 FY15 - Payoff Tax-Exempt Lease with General Funds #17 FY19 - SEEDA Administrator Contribution #26 FY18 - NE WY Growth Alliance #46 FY18 - Incubator services & SAGE #48 FY18 - Incubator services #61 Rocky Mountain Ambulance #62 Social Media Contract Project Index #15 #5304 - Sculpture/Public Arts #16 #5304 - Sculpture/Public Arts #18 #5304 - Sculpture/Public Arts #19 #5304 - Sculpture/Public Arts #20 #5304 - Sculpture/Public Arts #52 Seniors Contingency #53 Economic Development Contingency #54 Contingency #55 Public Safety Contingency #64 CAST $100k & WYO Theatre $140k #70 #5304 - Sculpture/Public Arts #71 #5304 - Sculpture/Public Arts Page 21 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Special Revenue Fund 2 Salaries and Wages 344 - - - - 3 Part-time/Seasonal Wages 8,926 8,867 8,012 7,259 9,900 4 Payroll Taxes 709 678 613 555 700 5 Unemployment and Worker's Comp 369 341 259 154 350 6 Other Employee Expenses 90 135 90 - 100 7 Repairs & Maint. Vehicles/Equip 3,612 2,187 12,399 374 4,100 8 Gasoline Oil Diesel Supplies 2,748 1,902 1,863 1,631 2,300 11 Total Special Revenue Fund 16,799 14,110 23,236 9,973 17,450 The Trolley expenditures are 100% reimbursed by the Chamber of Commerce. #7 FY17 - Replaced engine $10k CITY OF SHERIDAN Fiscal Year 2019 Budget Trolley Car Page 23 Page 24 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Economic Dev. 43,017 56,001 60,748 51,702 66,000 4 Total General Fund 43,017 56,001 60,748 51,702 66,000 5 10 Special Revenue Fund 11 Salaries and Wages - - - 133,513 154,000 12 Part-time/Seasonal Wages - - - 17,684 - 13 Overtime - 1,050 500 14 Payroll Taxes - - - 11,469 11,800 15 Retirement - - - 12,824 15,600 16 Unemployment and Worker's Comp - - - 3,628 4,300 17 Employee Insurance - - - 19,647 22,600 18 Contractual Services 176,970 199,036 192,987 59,924 54,000 19 Telephone & Internet 1,975 3,190 3,473 2,912 3,800 20 Repairs & Maint. - Other 615 - 113 - 500 21 Office Supplies 6,723 12,154 8,283 3,952 10,000 22 Insurance Liability 16 20 22 24 1,430 23 Publications Advertising and Printing 293,515 226,277 222,534 188,307 255,000 24 Miscellaneous 2,142 2,094 2,731 3,392 5,000 25 Economic Dev. 200,397 140,408 141,689 88,172 95,000 26 Total Special Revenue Fund 682,353 583,177 571,832 546,497 633,530 #2 Mayor's Economic Development #11 Travel & Tourism Director, Film Coordinator, Admin Assistant #12 Part-time position converted to full-time position #18 Represents past ST&T independent contractor agreements; currently one contract position and copier lease #22 FY19 - New allocation formula for insurance #24 Support supplies for Tourism Center #25 Marketing for Fly Sheridan and community event grants and sponsorships CITY OF SHERIDAN Fiscal Year 2019 Budget Travel and Tourism Page 77 Page 78 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 PD Contributions - Safe Ride 12,017 9,814 12,771 15,670 14,000 2 Total General Fund PD Contributions 12,017 9,814 12,771 15,670 14,000 3 4 K-9 Unit Contributions - - 10,050 - - 6 Shop with a Cop / Other Contributions/Old K-9 Unit 5,800 2,500 2,210 3,373 3,000 7 Total Special Revenue PD Contributions 5,800 2,500 12,260 3,373 3,000 8 9 General Fund 10 Salaries and Wages 1,802,741 1,923,991 1,761,083 1,805,975 1,929,312 11 Part-time/Seasonal Wages - 5,348 16,750 13,387 - 12 Overtime 35,700 31,688 38,764 30,489 34,000 13 Overtime 153 66 115 - 14 Payroll Taxes 42,920 44,288 42,164 43,026 47,600 15 Payroll Taxes 2 1 2 - 16 Retirement 197,962 213,552 201,684 201,843 218,100 17 Retirement 18 8 13 - 18 Unemployment and Worker's comp 42,017 36,279 61,424 54,109 53,100 19 Unemployment and Worker's comp 3 2 3 - 20 Employee Insurance 301,265 319,466 324,706 351,639 395,300 21 Other Employee Expenses - - - - - 22 Employee Allowance - Housing/Car 5,400 5,400 5,400 5,400 5,400 23 Contractual Services 91,007 99,090 18,463 - - 24 Utilities 25,894 24,078 22,098 26,931 20,000 25 Insurance Property 5,260 6,395 7,197 7,668 8,400 26 Telephone & Internet 32,412 36,548 30,983 31,025 30,000 27 Utilities - Other than Building 1,912 - 531 - - 28 Repairs & Maint. Vehicles/Equip. 50,054 64,468 - - - 29 Repairs & Maint. - Radio 2,267 253 549 - 1,500 30 Computer Hardware 31,942 10,119 (599) - - 31 Supplies 18,823 18,675 15,354 15,536 18,000 32 Office Supplies 10,461 12,899 9,897 8,583 9,500 33 Uniform Supplies 11,280 10,863 10,533 12,302 13,000 34 Gasoline Oil Diesel Supplies - 42,232 42,772 48,991 41,000 35 Range - 13,182 731 - - 37 Crime Prevention 1,113 5,592 4,724 6,515 30,000 38 Professional Services 23,291 22,734 45 220 - 39 Insurance Vehicle 6,392 7,299 8,446 8,300 1,920 40 Insurance Liability 99 105 126 110 22,670 41 Insurance - Claims 8,842 1,291 - - 42 Travel, Training & Memberships 23,410 24,715 22,072 21,195 35,000 43 Travel, Training & Memberships - 6,333 - - - 44 Job Recruitment Costs - 2,473 1,572 - 45 Publications Advertising and Printing 3,865 2,982 895 1,379 2,000 48 Capital Outlay - Machinery and Equip. - - - - 35,500 50 Transfer to Special Revenue Fund - 773,673 - - 51 Total General Fund 2,767,488 2,997,592 3,424,303 2,696,330 2,951,302 52 53 One Cent Fund 54 Contractual Services 32,778 47,867 24,000 24,339 - 56 Repairs & Maint. - Buildings/grounds - - - - 9,077 57 Repairs & Maint. - Other 12,450 3,807 11,255 14,479 15,789 59 PD Range 20,445 16,951 - - - 60 PD Lab 5,209 5,885 (134) - - 63 Capital Outlay - Machinery and Equip. 12,556 - - - 142,000 64 Transfer to General Fund - 300,000 100,000 65 Transfer to Special Revenue Fund - - - - - 66 Salaries and Wages 11,927 13,739 9,258 4,482 15,000 67 Overtime 671 139 52 - 700 68 Payroll Taxes 174 182 121 61 500 CITY OF SHERIDAN Fiscal Year 2019 Budget Police ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Police 69 Retirement 1,464 1,613 1,082 521 2,000 70 Unemployment and Worker's comp 251 252 389 61 500 71 Employee Insurance 2,493 3,709 2,509 484 4,000 72 Salaries and Wages 9,503 11,048 7,374 3,349 14,000 73 Overtime 588 574 176 29 600 74 Payroll Taxes 141 158 107 48 200 75 Retirement 1,173 1,350 877 392 1,400 76 Unemployment and Worker's comp 203 210 316 46 400 77 Employee Insurance 896 1,298 1,033 228 3,000 79 Transfer to Special Revenue Fund - 322,900 370,000 - - 80 Total One Cent Fund 112,923 431,681 428,415 348,521 309,166 81 82 Special Revenue Fund - Direct Distribution 84 Telephone & Internet 119 - - - - 86 Contractual Services - 77,700 73,176 129,000 87 Repairs & Maint. Vehicles/Equip 31 52,968 55,104 50,000 88 Computer Hardware - 13,036 13,790 6,000 89 Software Expense - - - - 1,000 90 Gasoline Oil Diesel Supplies 50,042 - - - - 91 PD Range - - 15,868 16,347 17,000 92 PD Lab - - 5,278 4,925 6,000 93 Professional Services - 25,028 32,862 30,000 94 Capital Outlay - Improvements - - - 24,303 29,009 95 Capital Outlay - Machinery and Equip 147,360 83,428 105,458 51,354 121,000 97 Transfer to Special Revenue Project 355,830 478,711 67,000 - 98 Total Special Rev Fund - Direct Distribution 197,521 439,289 774,046 338,861 389,009 99 100 Special Revenue Fund - Projects 102 Salaries and Wages 44,823 44,630 44,799 45,224 46,000 103 Overtime 747 313 793 672 500 104 Payroll Taxes 619 598 611 612 700 105 Retirement 5,295 5,222 5,298 5,264 5,300 106 Unemployment and Worker's Comp 1,048 836 1,568 1,241 1,300 107 Employee Insurance 11,099 9,897 8,811 8,788 10,000 108 Miscellaneous - K-9 Unit - 29,712 216 5,122 110 Uniform Supplies - Bullet Proof Vests - 3,796 2,675 2,000 4,199 114 Other - Shop with a Cop 2,694 2,500 1,092 2,800 4,797 115 Overtime 22,329 22,005 17,054 14,571 17,912 116 Payroll Taxes 311 311 238 201 300 117 Retirement 2,595 2,304 1,454 1,246 1,350 118 Unemployment and Worker's Comp 526 407 591 291 400 119 Employee Insurance 4,133 872 22 - 200 121 Contractual Services 6,815 3,915 4,375 7,550 9,150 122 Travel, Training & Memberships 353 - - - - 123 Capital Outlay - Machinery and Equip - - - 6,537 10,350 125 Overtime 1,485 1,144 848 1,106 5,000 127 Payroll Taxes 21 16 12 15 100 129 Retirement 173 133 73 95 400 131 Unemployment and Worker's comp 34 21 29 30 100 133 Employee Insurance 91 154 - 17 400 135 Miscellaneous 1,060 880 1,361 970 2,500 136 Overtime 2,559 4,498 2,120 1,504 5,000 137 Payroll Taxes 36 63 30 21 100 138 Retirement 297 523 182 129 400 139 Unemployment and Worker's Comp 59 84 55 56 100 140 Employee Insurance 252 626 6 15 400 142 Miscellaneous 1,610 1,540 1,090 1,900 2,500 148 Salaries and Wages 35,461 36,045 5,410 7,531 33,700 149 Overtime 1,059 487 104 3 - ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Police 150 Payroll Taxes 505 503 79 106 500 151 Retirement 4,244 4,245 641 875 4,000 152 Unemployment and Worker's Comp 866 680 190 206 1,000 153 Employee Insurance 4,224 3,941 457 1,101 6,400 154 Professional Services - - - 11,950 - 156 Capital Outlay - Machinery and Equip 11,196 6,597 15,114 8,162 27,776 157 Overtime 19,929 24,432 20,029 21,384 22,500 158 Payroll Taxes 280 341 281 300 1,000 159 Retirement 2,316 2,724 1,723 1,806 3,000 160 Unemployment and Worker's Comp 457 441 695 582 1,500 161 Employee Insurance 2,810 3,212 35 83 1,000 162 Contractual Services - - - - 1,000 163 Repairs & Maint. Vehicles/Equip 9,532 17,264 - - - 164 Capital Outlay - Machinery and Equip - 298,301 - - 165 Capital Outlay - Machinery and Equip 71,136 18,411 - - - 166 Capital Outlay - Machinery and Equip - 75,438 862 167 Capital Outlay - Improvements 364,584 1,999,807 99,396 3,343 168 Capital Outlay - Machinery and Equip - 103,719 24,213 - 169 Total Special Revenue Fund - Projects 275,078 591,195 2,571,483 356,209 242,160 170 Total Special Revenue Fund 472,599 1,030,483 3,345,529 695,070 631,168 171 172 Public Benefit Fund 173 Transfer to Special Revenue Fund - - 60,000 - - 174 Total Public Benefit Fund - - 60,000 - - #11 combined this position with PT dispatch into 1 FTE #13 DRE - Drug Recognition Expert #23 moved to Direct Distribution #24 new remodel efficiencies #27 not used anymore #28 moved to Direct Distribution #29 portable radio repairs varies #30 moved to Direct Distribution #31 building supplies, paper towles, cleaning supplies, HDMI cables, blood kits, postage #32 printer cartridges, office paper, notebooks, pens #33 min. 3 new officers #37 24k safe rides 75% return in revenue, 6k regular C.P. #38 moved to Direct Distribution #39 FY19 - New allocation formula for insurance #40 FY19 - New allocation formula for insurance #42 increase of $10k for Staff & Command School - 2 to 3 personnel #54 Safe ride #57 Drainage repair #59 moved to Direct Distribution #63 Police in car cameras $136k plus install of $6k #64 Payback of General Fund cash reserves used for the PD remodel #86 Spillman Contract, Motorola, Cleaning offices, Promotion testing #90 moved to General Fund #91 Annual 17k ammo and targets #93 Chemical Testing - Drugs $5k, Tows variable, sex assault kits $8k #94 FY19 - Rotomill the range parking lot / FY18 - New gate and fence, electrical, insulation #95 $90k for 2 vehicles and upfits, 21k Admin phones, 10k BWC, MDC, AED storage furniture, received no vehicles in 2018 #97 FY18 - Furniture, body cam grant match Project Index #4 K9 #5 Shop w/Cop/E911 Training/Misc Donations ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Police #6 Shop w/Cop/E911 Training/Misc Donations #13 DRE - Drug Recognition Expert #15 DRE - Drug Recognition Expert #17 DRE - Drug Recognition Expert #19 DRE - Drug Recognition Expert #43 Crisis Intervention Team #50 Police Dept Remodel #66 School Resource Officer #67 School Resource Officer #68 School Resource Officer #69 School Resource Officer #70 School Resource Officer #71 School Resource Officer #72 COPS Hiring Grant #73 COPS Hiring Grant #74 COPS Hiring Grant #75 COPS Hiring Grant #76 COPS Hiring Grant #77 COPS Hiring Grant #79 Police Dept Remodel #102 School Resource Officer #103 School Resource Officer #104 School Resource Officer #105 School Resource Officer #106 School Resource Officer #107 School Resource Officer #108 K9 #109 Bullet Proof Vest #110 Bullet Proof Vest #112 Shop w/Cop/E911 Training/Misc Donations #114 Shop w/Cop/E911 Training/Misc Donations #115 EUDL - Enforcing Underage Drinking #116 EUDL - Enforcing Underage Drinking #117 EUDL - Enforcing Underage Drinking #118 EUDL - Enforcing Underage Drinking #119 EUDL - Enforcing Underage Drinking #121 EUDL - Enforcing Underage Drinking #122 EUDL - Enforcing Underage Drinking #125 Tobacco Grant #126 Tobacco Grant #127 Tobacco Grant #129 Tobacco Grant #131 Tobacco Grant #133 Tobacco Grant #135 Tobacco Grant #136 Alcohol Inspection #137 Alcohol Inspection #138 Alcohol Inspection #139 Alcohol Inspection #140 Alcohol Inspection #142 Alcohol Inspection #148 COPS Hiring Grant #149 COPS Hiring Grant #150 COPS Hiring Grant #151 COPS Hiring Grant #152 COPS Hiring Grant #153 COPS Hiring Grant #154 Homeland Security #156 Homeland Security ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Police #157 Speed Enforcement Grant/HWY Safety #158 Speed Enforcement Grant/HWY Safety #159 Speed Enforcement Grant/HWY Safety #160 Speed Enforcement Grant/HWY Safety #161 Speed Enforcement Grant/HWY Safety #163 Speed Enforcement Grant/HWY Safety #164 Speed Enforcement Grant/HWY Safety #165 Emergency Vehicle and Equipment #166 Body Cameras Grant #167 Police Dept Remodel #168 Police Dept Remodel #173 Police Dept Remodel ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 362,830 365,436 356,359 368,060 404,000 3 Part-time/Seasonal Wages 22,214 21,160 20,203 13,347 - 4 Overtime 26,738 25,248 28,577 29,527 30,000 5 Payroll Taxes 32,755 29,569 28,990 29,624 30,900 6 Retirement 44,915 44,721 43,993 44,435 47,000 7 Unemployment and Worker's comp 1,252 924 1,663 1,382 2,300 8 Employee Insurance 88,145 104,165 106,357 102,187 104,500 9 Contractual Services 116 330 3,000 - 3,000 10 Telephone & Internet 745 819 436 489 1,000 11 Computer Hardware 2,817 - - - 1,000 13 Supplies 2,604 1,267 2,171 1,645 2,250 14 Travel, Training & Memberships 6,123 5,477 4,348 1,768 6,000 15 Total General Fund 591,253 599,115 596,097 592,464 631,950 #3 PT position combined with PT records position to be a full-time position #4 Expect 3 openings in dispatch - will require OT to fill in #14 new positions will require sending them to additional training CITY OF SHERIDAN Fiscal Year 2019 Budget Police Communications Page 85 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Utilities 11,120 10,602 14,136 12,531 13,000 3 Insurance Property 307 373 419 447 1,610 4 Telephone & Internet 2,471 2,580 2,071 2,172 2,300 6 Repairs & Maint. - Other 1,289 4,124 4,829 1,024 10,973 8 Dog and Cat Shelter Support 59,800 75,000 71,000 71,000 71,000 9 Capital Outlay - Improvements 4,241 - - - 10 Total One Cent Fund 74,986 96,919 92,455 87,173 98,883 11 12 Special Revenue Fund - Projects 13 Capital Outlay - Improvements - 25,000 - - - 14 Total Special Revenue Fund - Projects - 25,000 - - - Project Index #9 #5711 - Dog & Cat Shelter Improvements #14 #5711 - Dog & Cat Shelter Improvements CITY OF SHERIDAN Fiscal Year 2019 Budget Animal Shelter Page 87 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 1,065,991 1,071,866 1,065,902 1,070,361 1,076,400 3 Overtime 48,536 35,495 42,461 36,779 42,500 4 Payroll Taxes 18,503 18,477 18,449 18,226 18,800 5 Retirement 132,866 131,706 129,227 127,363 128,300 6 Unemployment and Worker's comp 25,559 20,408 38,066 27,716 29,900 7 Employee Insurance 176,024 180,859 173,814 177,806 179,400 8 Contractual Services 5,573 6,893 7,079 6,139 7,600 9 Utilities 15,396 12,311 13,965 14,591 12,500 10 Repairs & Maint. - Buildings/grounds 4,811 11,185 1,629 8,819 7,400 11 Insurance Property 2,485 3,021 3,400 3,622 5,580 12 Telephone & Internet 8,992 10,168 10,637 10,667 8,500 13 Repairs & Maint. Vehicles/Equip. 16,049 20,017 4,400 20,791 17,500 14 Repairs & Maint. - Other (146) - - - - 15 Computer Hardware 4,236 2,548 - - - 16 Software Expense - 1,552 2,868 2,944 3,500 17 Supplies 14,109 9,414 15,656 15,113 15,000 18 Office Supplies 4,126 3,885 3,493 2,385 3,800 19 Uniform Supplies 7,512 7,519 7,550 7,072 8,500 20 Gasoline Oil Diesel Supplies - - 3,179 6,688 5,900 21 EMS Supplies 5,328 5,570 5,325 7,424 7,300 22 Professional Services 11,633 22,599 - - - 23 Insurance Vehicle 4,681 5,426 6,236 6,254 2,670 24 Insurance Liability 2,580 2,712 3,261 2,847 10,070 25 Travel, Training & Memberships 16,245 26,368 18,434 6,461 15,000 26 Publications Advertising and Printing 852 1,237 978 1,145 1,000 27 Public Safety 2,516 1,696 - - - 28 CPR 2,382 2,655 4,600 5,084 6,000 29 Total General Fund 1,596,841 1,615,587 1,580,607 1,586,298 1,613,120 30 31 One Cent Fund 32 Repairs & Maint. - Buildings/grounds 3,411 - 20,000 33 Repairs & Maint. Vehicles/Equip.15,737 - 20,000 34 Repairs & Maint. - Other 10,698 11,675 3,665 9,850 12,764 35 Equipment Non-capitalized 23,885 11,205 16,083 14,654 15,000 36 Professional Services - - - 234 7,100 37 Capital Outlay - Machinery and Equip. 3,817 38,291 9,162 - 56,000 38 Debt Service Principal 229,669 - - - - 39 Debt Service Interest 9,164 - - - - 40 Transfer to Special Revenue Fund - - - - 47,000 41 Total One Cent Fund 277,233 61,171 48,058 24,738 177,864 42 43 Special Revenue Fund - Direct Distribution 44 Repairs & Maint. - Buildings/grounds - 16,147 2,201 45 Equipment Non-capitalized - 15,090 - - - 46 Computer Hardware - 2,241 2,441 4,000 47 Gasoline Oil Diesel Supplies 7,981 5,069 2,377 - - 48 Professional Services - 12,924 27,224 22,000 49 Public Safety - 2,472 2,487 3,000 50 Capital Outlay - Improvements 21,765 18,488 - - - 51 Total Special Rev Fund - Direct Distribution 29,746 38,646 20,015 48,299 31,201 52 53 Special Revenue Fund - Projects 55 Public Safety 4,915 - 340 - 425 56 Capital Outlay - Machinery and Equip - - - 57 Capital Outlay - Machinery and Equip - - - - 182,000 58 Total Special Revenue Fund - Projects 4,915 - 340 - 182,425 59 Total Special Revenue Fund 34,661 38,646 20,355 48,299 213,626 CITY OF SHERIDAN Fiscal Year 2019 Budget Fire ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Fire #8 Alarm contract, oxygen tank rentals #13 Increased Maintenance on aging apparatus #22 Moved to Direct Distribution- Medical Director and Physician fees #23 FY19 - New allocation formula for insurance #24 FY19 - New allocation formula for insurance #25 Increase of $5k towards support in bringing in Regional NFA classes #27 Moved to Direct Distribution #28 Increased card costs from AHA. Offset by fee increase. #32 Roof membrane replacement, lighting, and concrete work #33 Vehicle regenetive exhaust replacement, apparatus tire replacement E-1 and E-2 #34 PPE- Bunker replacement plan #35 Replace hose, nozzles, misc equipment #36 Promotional Testing #37 FY19 Self Contained Breathing Apparatus $25k grant match & Radios $56k; FY16 generator; FY17 mobile radios for station #40 FY19 - Exhaust Capture System & Gearing Cleaning Equipment #44 FY19 - Station repair- moved to one cent fund; FY18 - repairs to concrete & tile #45 FY16 - hoses and thermal imaging equipment #46 Replace computers #48 Medical Director Contract and Annual Physician fees. #49 Public education supplies, pamphlets #50 FY15 - Replaced overhead doors; FY16 - fire hoses & safety enclosures/gates for fire poles #55 Smoke detectors #56 FY18 - Grant Funding for Fire Dept Radios - was not available in FY18 #57 FY19 - Exhaust Capture System & Gearing Cleaning Equipment Page 43 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 37,585 41,431 38,247 47,362 47,500 3 Part-time/Seasonal Wages 4,754 13,752 21,490 21,093 22,300 4 Overtime 705 2,477 929 1,688 1,500 5 Payroll Taxes 3,126 4,280 4,500 5,284 5,400 6 Retirement 3,396 3,642 3,628 4,649 4,800 7 Unemployment and Worker's comp 973 2,967 2,995 1,662 2,000 8 Employee Insurance 8,847 8,974 10,239 8,461 8,400 9 Temporary Services Labor 38,644 18,395 8,000 11 Utilities 10,866 11,475 12,415 13,965 13,000 12 Repairs & Maint. - Buildings/grounds - 3,684 762 2,000 13 Insurance Property 121 147 166 176 960 14 Telephone & Internet 2,080 2,972 2,339 2,446 2,300 15 Repairs & Maint. Vehicles/Equip. 4,159 3,637 8,977 3,137 3,000 16 Repairs & Maint. - Irrigation 9,600 17,206 4,939 9,519 11,000 17 Equipment Non-capitalized - 7,549 4,836 7,000 18 Supplies 7,172 12,816 2,495 2,127 5,000 19 Office Supplies - 340 321 500 20 Gasoline Oil Diesel Supplies - - - - 3,400 21 Professional Services - 19,327 419 - - 22 Insurance Vehicle 305 321 385 337 210 23 Insurance Liability 149 156 188 164 450 24 Travel, Training & Memberships 234 - 605 1,000 25 Job Recruitment Costs 339 - - 26 Capital Outlay - Improvements - 9,811 - - - 28 Total General Fund 93,836 155,623 164,904 146,988 149,720 29 30 Special Revenue Fund - Direct Distribution 31 Outside Services 135,869 23,853 - - - 32 Repairs & Maint. - Irrigation - - 15,890 - - 33 Computer Hardware 970 - - - 34 Supplies 6,428 39,696 5,487 - 5,000 35 Gasoline Oil Diesel Supplies 4,246 2,596 4,064 4,800 - 36 Professional Services - - 21,216 14,673 10,000 38 Capital Outlay - Machinery and Equip - 51,087 22,597 23,330 39 Transfer to Special Revenue Project - 190,711 - - - 40 Total Special Rev Fund - Direct Distribution 146,543 257,825 97,744 42,070 38,330 41 42 Special Revenue Fund - Projects 43 Capital Outlay - Buildings - 671,222 112,027 - - 44 Capital Outlay - Improvements - 37,024 5,800 12,176 45 Transfer to Supplemental 7,461 - - 46 Total Special Revenue Fund - Projects - 671,222 156,512 5,800 12,176 47 Total Special Revenue Fund 146,543 929,048 254,256 47,870 50,506 #13 FY19 - New allocation formula for insurance #16 Raw water irrigation pump replacement in FY17 #18 Previous year costs contained more than just supplies - have charged correct accounts going forward #20 Was in Direct Distribution in prior years #21 Survey new plots, tree trimming, cemetery software, and landscaping - funding moved to Direct Distribution line #34 #22 FY19 - New allocation formula for insurance #23 FY19 - New allocation formula for insurance #32 Raw water irrigation pump replacement in FY17 #34 FY16 - Initial costs to supply new cemetery building #35 FY19 - moved to General Fund #36 Custodial costs, cemetery software, tree trimming, survey new plots, landscaping #38 FY18 upgraded to better mower; FY19 new V plow for truck, broom for tool cat CITY OF SHERIDAN Fiscal Year 2019 Budget Cemetery ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Cemetery Project Index #43 #5708 - Cemetery Building #44 #5708 - Cemetery Improvements #45 #5708 - Cemetery Improvements Page 65 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 326,658 324,584 322,419 315,507 288,900 3 Part-time/Seasonal Wages 8,994 4,646 1,374 2,758 6,500 4 Overtime 294 230 217 257 300 5 Payroll Taxes 24,267 23,606 22,983 22,894 23,200 6 Retirement 29,038 31,247 31,038 28,031 29,300 7 Unemployment and Worker's comp 7,700 6,099 11,103 7,972 8,200 8 Employee Insurance 60,296 62,883 62,956 55,672 57,900 9 Temporary Services Labor - - - 5,016 - 10 Contractual Services 5,735 13,119 7,657 6,552 10,000 11 Telephone & Internet 6,851 7,158 5,617 5,489 6,250 12 Repairs & Maint. Vehicles/Equip. 993 150 1,335 1,484 1,000 13 Repairs & Maint. - Other - - - - 400 14 Supplies 15,049 12,895 7,955 9,313 12,000 15 Office Supplies 1,303 985 314 223 1,000 16 Gasoline Oil Diesel Supplies 868 767 928 959 1,000 Professional Services - - - 25,070 - 17 Insurance Vehicle 624 709 822 802 100 18 Insurance Liability 1,439 1,513 1,819 1,588 2,710 19 Travel, Training & Memberships 13,334 14,347 10,781 6,862 10,000 20 Job Recruitment Costs - - 297 9,739 - 21 Publications Advertising and Printing 9 375 585 749 1,800 22 Total General Fund 503,452 505,315 490,199 506,938 460,560 23 24 One Cent Fund 25 Computer Hardware 4,476 - - - - 26 Professional Services - - - - 30,000 27 Total One Cent Fund 4,476 - - - 30,000 28 29 Special Revenue Fund - Direct Distribution 31 Computer Hardware - 2,179 - - - 32 Professional Services 55,527 87,614 53,393 13,861 50,000 33 Capital Outlay - Improvements - - - 240 - Transfer to Special Revenue Project - - - 147,589 - 34 Capital Outlay - Improvements - - - - - 35 Total Special Rev Fund - Direct Distribution 55,527 89,793 53,393 161,689 50,000 36 37 Special Revenue Fund - Projects 38 Capital Outlay - Land 149,993 - - - - 39 Capital Outlay - Buildings 39,225 433,503 329,661 - 1 40 Capital Outlay - Buildings - - 2,628,549 1,458,482 - 41 Capital Outlay - Improvements - 35,630 180,711 - 1 43 Total Special Revenue Fund - Projects 189,218 469,133 3,138,922 1,458,482 2 44 Total Special Revenue Fund 244,745 558,926 3,192,314 1,620,171 50,002 In FY19 the PW Administration Department was combined with the Engineering Department #10 Copier lease & large document printing #14 Supplies for engineering, building, and planning depts #17 FY19 - New allocation formula for insurance #18 FY19 - New allocation formula for insurance #32 FY19 - Engineering Traffic Design Studies, Parks and Rec Masterplan & Capital Improvement Plan (CIP) Project Index #38 #5308 - Senior Center - Daybreak #39 #5308 - Senior Center - Daybreak #40 #5312 - Senior Center - Food Service Area #41 #5312 - Senior Center - Food Service Area CITY OF SHERIDAN PW Administration & Engineering Fiscal Year 2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 73,028 61,925 60,757 141,841 3 Overtime 5 - - 257 4 Payroll Taxes 5,373 4,608 4,520 10,552 5 Retirement 6,491 5,957 5,845 11,446 6 Unemployment and Worker's comp 1,687 1,143 2,082 3,557 7 Employee Insurance 11,142 8,001 7,939 19,715 8 Telephone & Internet 490 420 421 665 9 Repairs & Maint. Vehicles/Equip. 621 139 155 1,078 11 Supplies 2,108 348 1,373 8 12 Office Supplies 1,303 985 314 223 13 Gasoline Oil Diesel Supplies - - - - 14 Travel, Training & Memberships 3,954 6,264 5,216 250 15 Job Recruitment Costs - 9,739 16 Publications Advertising and Printing 64 375 375 749 17 Total General Fund 106,266 90,167 88,998 200,080 - 18 19 Special Revenue Fund - Direct Distribution 20 Computer Hardware 2,179 - - - 21 Capital Outlay - Improvements - - - - - 22 Total Special Rev Fund - Direct Distribution - 2,179 - - - In FY19 the PW Administration Department was combined with the Engineering Department CITY OF SHERIDAN Fiscal Year 2019 Budget PW Administration ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 253,631 262,659 261,662 173,666 288,900 3 Part-time/Seasonal Wages 8,994 4,646 1,374 2,758 6,500 4 Overtime 288 230 217 - 300 5 Payroll Taxes 18,894 18,998 18,463 12,343 23,200 6 Retirement 22,547 25,290 25,193 16,586 29,300 7 Unemployment and Worker's comp 6,013 4,956 9,021 4,415 8,200 8 Employee Insurance 49,155 54,882 55,017 35,957 57,900 9 Temporary Services Labor - 5,016 - 10 Contractual Services 5,735 13,119 7,657 6,552 10,000 11 Telephone & Internet 6,361 6,738 5,196 4,824 6,250 12 Repairs & Maint. Vehicles/Equip. 372 10 1,180 406 1,000 13 Repairs & Maint. - Other - - - - 400 14 Supplies 12,940 12,547 6,582 9,305 12,000 16 Gasoline Oil Diesel Supplies 868 767 928 959 1,000 17 Professional Services - - - 25,070 - 18 Insurance Vehicle 624 709 822 802 100 19 Insurance Liability 1,439 1,513 1,819 1,588 2,710 20 Travel, Training & Memberships 9,380 8,083 5,565 6,612 10,000 21 Job Recruitment Costs 297 - - 22 Publications Advertising and Printing (55) - 210 - 1,800 23 Total General Fund 397,186 415,148 401,202 306,858 460,560 24 25 One Cent Fund 26 Computer Hardware 4,476 - - - 27 Professional Services - - - - 30,000 28 Total One Cent Fund 4,476 - - - 30,000 29 30 Special Revenue Fund - Direct Distribution 31 Professional Services 55,527 87,614 53,393 13,861 50,000 32 Capital Outlay - Improvements - - - 240 - 33 Transfer to Special Revenue Project - - - 147,589 - 34 Total Special Rev Fund - Direct Distribution 55,527 87,614 53,393 161,689 50,000 35 36 Special Revenue Fund - Projects 37 Capital Outlay - Land 149,993 - - - - 38 Capital Outlay - Buildings 39,225 433,503 329,661 - 1 39 Capital Outlay - Buildings - 2,628,549 1,458,482 - 40 Capital Outlay - Improvements 35,630 180,711 - 1 42 Total Special Revenue Fund - Projects 189,218 469,133 3,138,922 1,458,482 2 43 Total Special Revenue Fund 244,745 556,747 3,192,314 1,620,171 50,002 In FY19 the PW Administration Department was combined with the Engineering Department #31 Engineering Traffic Design Studies/Drainage study $30k & truck route study $20k Project Index #37 #5308 - Senior Center - Daybreak #38 #5308 - Senior Center - Daybreak #39 #5312 - Senior Center - Food Service Area #40 #5312 - Senior Center - Food Service Area CITY OF SHERIDAN Fiscal Year 2019 Budget Engineering Page 30 Page 31 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 126,686 131,026 130,510 125,755 130,600 3 Part-time/Seasonal Wages - 4,500 4 Overtime 210 600 93 132 200 5 Payroll Taxes 9,511 9,678 9,556 9,285 10,400 6 Retirement 11,268 12,662 12,564 9,894 13,300 7 Unemployment and Worker's comp 2,905 2,430 4,475 3,145 3,800 8 Employee Insurance 15,991 25,203 27,979 22,620 29,000 9 Employee Allowance - Housing/Car - 1,368 - 10 Contractual Services 22,841 17,684 15,868 3,512 20,000 11 Telephone & Internet 2,412 2,545 1,502 1,278 2,000 12 Repairs & Maint. Vehicles/Equip. 682 855 1,399 455 2,000 14 Supplies 166 - 15 - - 16 Gasoline Oil Diesel Supplies 382 536 534 429 700 17 Insurance Vehicle - 50 18 Insurance Liability - 1,230 19 Travel, Training & Memberships 3,805 4,129 2,503 3,894 3,600 20 Job Recruitment Costs - 11,600 - 21 Publications Advertising and Printing 4,285 3,802 2,902 2,211 3,000 22 Economic Dev.1,150 2,965 2,659 1,932 - 23 Total General Fund 202,294 214,114 212,559 197,605 224,380 24 25 One Cent Fund 26 Computer Hardware 2,358 - - - - 28 Professional Services 452 - - - 23,339 29 Total One Cent Fund 2,810 - - - 23,339 30 31 Special Revenue Fund - Direct Distribution 32 Capital Outlay - Improvements 498 - - - - 33 Computer Hardware - - - - 2,000 34 Professional Services 71,371 33,794 27,685 - 50,486 35 Transfer to Special Revenue Project 7,770 - 25,000 41,530 25,000 36 Total Special Rev Fund - Direct Distribution 79,638 33,794 52,685 41,530 77,486 37 38 Special Revenue Fund - Projects 39 Professional services 4,758 - - - - 40 Professional services 14,785 5,215 - - - 41 Professional services 23,697 142,960 157,180 68,276 7,887 42 Professional services - 26,225 34,305 44 Total Special Revenue Fund - Projects 43,240 148,176 157,180 94,501 42,192 45 Total Special Revenue Fund 122,878 181,970 209,865 136,031 119,679 #3 New Line for Part-time Intern Summer of 2019 #9 Moving expenses for new community development director #10 Minutes consultant, minor studies, consulting services, technical and software services #14 Supplies all run through Engineering Dept #17 FY19 - New allocation formula for insurance #18 FY19 - New allocation formula for insurance #22 FY19 moved expenses to Contract Services #34 No new large study in FY19 Project Index #35 #5311 - Downtown Development Iniative CITY OF SHERIDAN Fiscal Year 2019 Budget Planning Page 69 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Contractual Services 36,006 - - - - 3 Supplies - 725 - - - 4 Professional Services 23,894 54,392 49,050 44,905 50,000 5 Total General Fund 59,900 55,117 49,050 44,905 50,000 6 7 Special Revenue Fund - Direct Distribution 8 Professional Services 29,000 24,000 29,450 29,450 55,000 9 Total Special Rev Fund - Direct Distribution 29,000 24,000 29,450 29,450 55,000 #8 FY19 Additional $25k requested to complete aerial photography for City boundary CITY OF SHERIDAN Fiscal Year 2019 Budget GIS Page 26 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 264,600 274,125 256,222 271,887 276,900 3 Part-time/Seasonal Wages 10,490 - - - - 4 Overtime 2,091 1,623 2,548 1,909 2,000 5 Payroll Taxes 19,603 19,682 18,894 19,998 21,200 6 Retirement 22,912 25,672 24,894 26,036 28,100 7 Unemployment and Worker's comp 6,118 5,133 8,781 6,834 7,700 8 Employee Insurance 46,072 47,079 49,864 52,082 55,800 10 Outside Services - PayPal 1,734 2,040 1,120 1,131 1,200 12 Telephone & Internet 8,202 9,184 7,706 8,392 8,000 13 Repairs & Maint. Vehicles/Equip. 1,907 2,354 1,433 964 1,500 14 Repairs & Maint. - Other - 136 907 - 500 15 Computer Hardware - 663 4,900 16 Supplies 3,576 2,936 4,658 2,389 2,400 17 Office Supplies - 268 - 18 Gasoline Oil Diesel Supplies 3,076 2,447 1,899 2,343 2,750 19 Professional Services 22,572 19,055 15,651 12,751 16,000 20 Insurance Vehicle 1,094 1,209 1,420 1,333 200 21 Insurance Liability - 2,590 22 Travel, Training & Memberships 4,371 9,848 8,485 6,306 7,500 23 Staff Licenses & Certifications - - - - 2,500 24 Publications Advertising and Printing 918 4,268 1,996 1,948 2,000 25 Total General Fund 419,335 426,790 406,480 417,235 443,740 26 27 One Cent Fund 28 Outside Services - 35,267 24,733 - - 29 Computer Hardware 6,834 - - - - 30 Total One Cent Fund 6,834 35,267 24,733 - - 31 32 Special Revenue Fund - Projects 33 Outside Services - 19,276 30,724 25,000 34 Total Special Revenue Fund - Projects - - 19,276 30,724 25,000 #10 Lower government rate started in FY17 #20 FY19 - New allocation formula for insurance #21 FY19 - New allocation formula for insurance #23 FY19 - costs were originally shown in Travel, Training & Memberships #24 Code Books Project Index #28 #5311 - Downtown Development Iniative #33 #5311 - Downtown Development Iniative CITY OF SHERIDAN Fiscal Year 2019 Budget Building: Permits/Inspections Page 33 Page 34 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Other Miscellaneous - Street Repairs - 7,912 5,000 2 Total General Fund Street Repair Revenue - - - 7,912 5,000 3 4 General Fund 5 Salaries and Wages 559,823 602,773 551,190 527,365 513,200 6 Part-time/Seasonal Wages 776 354 7,385 4,446 8,100 7 Overtime 4,665 3,580 5,335 11,388 5,500 8 Payroll Taxes 41,073 44,294 40,958 39,540 39,700 9 Retirement 47,333 58,128 53,306 50,172 51,700 10 Unemployment and Worker's comp 14,559 11,169 22,346 13,380 14,400 11 Employee Insurance 117,911 131,028 135,141 130,871 141,900 12 Temporary Services Labor - - - 3,621 - 13 Contractual Services 19 6,391 - - - 14 Utilities 34,166 27,577 37,396 4,177 34,000 15 Repairs & Maint. - Buildings/grounds - 8,651 43,176 10,000 16 Insurance Property 3,563 4,332 4,875 5,195 1,370 17 Telephone & Internet 6,248 6,847 7,406 7,427 6,500 19 Utilities - Other than Building - 202,948 209,136 226,179 230,000 20 Repairs & Maint. Vehicles/Equip. 154,493 109,671 87,422 105,732 95,000 21 Repairs & Maint. - Infrastructure 26,450 - - - - 22 Repairs & Maint. - Traffic/Signs 42,216 58,065 59,498 59,367 62,000 23 Hot Plant Aggregate (fuel/oil/rock) 57,349 76,733 59,491 53,934 65,000 25 Concrete Repair 124,954 41,471 - - - 26 Storm Sewer/Flood Control 108,253 5,374 36,401 - 30,000 27 Chip Seal 130,906 166,633 79,094 38,928 140,000 28 Durapatcher Aggregate (Chips/Oil) 28,877 15,517 20,241 28,445 32,000 29 Copier & Printer Costs - 2,841 2,600 30 Equipment Rentals 723 - 650 9,450 10,000 31 Equipment Non-capitalized - 1,965 476 3,000 32 Computer Hardware 2,817 4,292 868 399 1,000 33 Software Expense - 126 395 - - 34 Supplies 10,773 14,888 9,973 6,464 10,500 35 Office Supplies 2,512 1,958 5,869 2,191 2,000 36 Gasoline Oil Diesel Supplies 62,962 41,157 43,081 43,231 48,000 37 Professional Services 42,231 45,634 18,668 16,360 22,000 38 Insurance Vehicle 11,911 13,710 15,807 15,702 6,710 39 Insurance Liability 26,985 28,369 34,107 29,776 6,020 40 Insurance - Claims 1,300 1,617 - 41 Travel, Training & Memberships 8,338 4,446 9,002 1,667 4,500 42 Job Recruitment Costs - 1,088 2,757 - 43 Publications Advertising and Printing 1,756 1,547 150 315 1,000 44 Miscellaneous - - - - - 45 Capital Outlay - Improvements - 14,989 - - - 53 Transfer to Debt Service Fund 15,798 31,948 31,948 31,948 54 Total General Fund 1,674,640 1,759,797 1,600,143 1,518,537 1,629,648 55 56 One Cent Fund 57 Professional Services 157,247 93,666 - - - 58 Capital Outlay - Land (153) - - - - 63 Capital Outlay - Improvements 385 - - - - 68 Capital Outlay - Improvements 109,794 474 - - - 74 Transfer to Special Revenue Fund 1,005,630 400,000 400,000 200,000 438,000 75 Transfer to Special Revenue Fund 320,502 - - - - 76 Transfer to Special Revenue Fund 25,000 101,600 - - - 78 Transfer to Special Revenue Fund 200,000 - - - - 79 Transfer to Special Revenue Fund 145,558 48,200 16,889 24,889 190,000 80 Transfer to Special Revenue Fund 78,385 - - 81 Transfer to Special Revenue Fund - - 17,000 - CITY OF SHERIDAN Fiscal Year 2019 Budget Streets ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Streets 82 Transfer to Special Revenue Fund 28,500 300,000 210,000 - - 83 Transfer to Special Revenue Fund - 100,000 - - - 84 Transfer to Special Revenue Fund - - - - 100,000 85 Transfer to Special Revenue Fund 93,268 - - - - 86 Transfer to Special Revenue Fund - 11,391 - - - 87 Transfer to Special Revenue Fund 200 - - - 88 Transfer to Special Revenue Fund - - - - 48,889 89 Transfer to Special Revenue Fund - 50,000 - - - 90 Transfer to Special Revenue Fund - - - - 50,000 91 Total One Cent Fund 2,085,731 1,105,531 705,274 241,889 826,889 92 93 Special Revenue Fund - Direct Distribution 97 Utilities - Other than Building 203,197 - - - - 98 Concrete Repair - 43,348 44,728 60,000 99 Equipment Rentals - - - - 30,000 100 Software Expense - - - 2,500 101 Capital Outlay - Improvements - 68,583 15,800 12,445 - 102 Capital Outlay - Machinery and Equip 103,999 460,413 258,759 254,332 518,961 103 Transfer to Special Revenue Project - 400,000 275,000 100,000 37,000 104 Total Special Rev Fund - Direct Distribution 307,197 928,996 592,907 411,505 648,461 105 106 Special Revenue Fund - Projects 111 Capital Outlay - Infrastructure 98,455 995 - - - 119 Capital Outlay - Improvements 284,989 79,707 19,223 35,597 56,399 121 Capital Outlay - Improvements 19,436 18,036 - - - 129 Total Special Revenue Fund - Projects 402,880 98,738 19,223 35,597 56,399 130 Total Special Revenue Fund 710,077 1,027,734 612,130 447,102 704,860 131 132 Cap Tax Fund 134 Capital Outlay - Infrastructure 1,545 (101,004) - - - 142 Transfer to Special Revenue Fund 100,000 - - - - 143 Transfer to Special Revenue Fund 796,232 100,000 - - - 144 Transfer to Special Revenue Fund 1,086,654 325,000 - - - 145 Transfer to Special Revenue Fund 272,747 - - - 147 Transfer to Special Revenue Fund - 50,000 115,000 300,000 175,000 148 Transfer to Special Revenue Fund 2,705,645 - - - - 149 Transfer to Special Revenue Fund - 403,258 177,000 915,000 2,490,000 150 Transfer to Special Revenue Fund - - - 20,000 - 151 Transfer to Special Revenue Fund - - 80,000 - 152 Transfer to Special Revenue Fund - 650,000 1,900,000 1,638,214 160,007 153 Transfer to Special Revenue Fund 50,000 13,332 - - - 154 Transfer to Special Revenue Fund - 300,000 450,000 - - 155 Transfer to Special Revenue Fund 50,000 - - - 156 Transfer to Special Revenue Fund - 450,000 350,000 - - 157 Transfer to Special Revenue Fund 225,000 - - - 158 Transfer to Special Revenue Fund - 361,668 - - - 159 Transfer to Special Revenue Fund 50,000 - - - 160 Transfer to Special Revenue Fund - - - - 285,000 161 Total Cap Tax Fund 4,740,076 3,150,000 2,992,000 2,953,214 3,110,007 162 163 Public Benefit Fund 164 Transfer to Special Revenue Fund - 200,000 185,000 200,000 165 Transfer to Special Revenue Fund - - 390,000 150,000 166 Transfer to Special Revenue Fund - - - - 25,000 167 Transfer to Special Revenue Fund - - - - 100,000 168 Transfer to Special Revenue Fund - - - - 90,000 169 Total Public Benefit Fund - - 200,000 575,000 565,000 170 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Streets 171 Debt Service Fund 173 Miscellaneous 700 700 700 700 700 174 Miscellaneous 1,000 1,000 1,000 1,000 1,000 175 Debt Service Principal - CAT Leases 9,386 20,080 20,754 21,450 178 Debt Service Principal 75,000 130,000 210,000 15,000 24,800 179 Debt Service Principal 40,000 65,000 60,000 35,000 26,800 180 Debt Service Interest - CAT Leases 6,412 11,868 11,194 10,498 183 Debt Service Interest 30,851 26,524 19,911 12,983 12,300 184 Debt Service Interest 12,410 11,738 10,249 9,420 8,800 185 Total Debt Service Fund 159,961 250,759 333,808 106,051 106,348 #7 Streets overtime mainly occurs in Snow Removal Dept #16 FY19 - New allocation formula for insurance #19 Utilities for City-wide street lighting #22 WYDOT traffic signals to move to City maintenance, replace cracked decorative light bases #25 Moved to Direct Distribution #30 FY18 rented excavator for hillslide maintenance #37 Custodial service, rug cleaning, locates, yearly health, uniforms #38 FY19 - New allocation formula for insurance #39 FY19 - New allocation formula for insurance #41 FY18 - training limited due to long winter #45 Moved to Direct Distribution #57 #5705 - ACOE 1135 Study #97 Utilities for City-wide street lighting FY15 #102 Durapatcher, one ton dump truck, and street sweeper Project Index #57 #5705 - ACOE 1135 Study #63 #4725 - West Downtown #68 #4730 - 319 Funding #73 #5727 - Community Drainage #74 #4701 - Street Overlay Program - R&O #75 #4703 - Wyo/Park Street #76 #4704 - Lewis Street #78 #4726 - Illinois #79 #4729 - N. Sheridan Interchange #80 #4730 - 319 Funding #81 #4740 - East Downtown Improvements #82 #4742 - Loucks St & Waterline Replacement #83 #4747 - Holloway St Construction #84 #4759 - E 5th St Corridor #85 #4853 - North West Water Loop #86 #4860 - Downtown Parking Development #87 #4861 - Traffic Striping & Sign Updates #88 #5318 - Capital Improvement Program #89 #5701 - Pathways #90 #5727 - Community Drainage #111 #4706 - North Main #119 #4730 - 319 Funding #121 #4736 - Dust Suppression #134 #4706 - North Main #142 #4701 - Street Overlay Program - R&O #143 #4703 - Wyo/Park Street #144 #4704 - Lewis Street #145 #4706 - North Main #146 #4724 - S. Downtown Neighborhood #147 #4725 - West Downtown #148 #4726 - Illinois ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Streets #149 #4729 - N. Sheridan Interchange #150 #4730 - 319 Funding #151 #4740 - East Downtown Improvements #152 #4742 - Loucks St & Waterline Replacement #153 #4746 - 5th & Long Intersection #154 #4747 - Holloway St Construction #155 #4748 - E 5th St Infrastructure #156 #4750 - W 5th St Reconstruction SUSAC #157 #4751 - 5th St Waterline Replacement #158 #4752 - High School Access to Mydland Rd #159 #4754 - N. End Infrastructure Extension #160 #5317 - Hillslide Stabilization Project #164 #4701 - Street Overlay Program - R&O #165 #4729 - N. Sheridan Interchange #166 #4740 - East Downtown Improvements #167 #4742 - Loucks St & Waterline Replacement #168 #4759 - E 5th St Corridor #173 #4877 - SID #77 #174 #4878 - SID #78 #175 Street CAT Leases #178 #4877 - SID #77 #179 #4878 - SID #78 #180 Street CAT Leases #183 #4877 - SID #77 #184 #4878 - SID #78 Page 39 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 87,473 39,209 98,850 101,636 136,700 3 Overtime 13,987 3,952 9,569 23,868 30,000 4 Payroll Taxes 7,353 3,134 7,830 9,143 10,300 5 Retirement 8,987 4,152 9,984 12,015 13,600 6 Unemployment and Worker's comp 2,333 800 3,714 3,398 3,800 7 Employee Insurance 22,127 10,681 27,429 29,570 40,800 8 Insurance Property - - - - - 9 Telephone & Internet 10 37 84 38 - 10 Repairs & Maint. Vehicles/Equip. 30,104 30,137 20,984 34,334 34,000 11 Repairs & Maint. - Other 1,750 - - - 12 Equipment Rentals 103,515 19,901 89,773 79,703 80,000 13 Supplies 97,206 27,293 72,958 112,136 65,000 14 Gasoline Oil Diesel Supplies 27,677 8,113 19,898 31,242 25,000 15 Professional Services 25,090 14,520 5,294 12,000 16 Insurance Vehicle 153 186 210 223 560 17 Insurance - Claims 4,484 - 1,382 695 - 18 Capital Outlay - Machinery and Equip. 6,300 129,049 - - 19 Total General Fund 405,408 180,735 506,234 443,295 451,760 20 21 Special Revenue Fund - Direct Distribution 22 Equipment Rentals - - 33,341 85,672 75,000 23 Supplies 48,999 - 68,257 68,753 80,576 25 Total Special Rev Fund - Direct Distribution 48,999 - 101,598 154,424 155,576 CITY OF SHERIDAN Fiscal Year 2019 Budget Snow Removal Page 41 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 120,868 149,017 155,419 165,489 164,200 3 Overtime 1,623 2,487 2,641 3,950 3,000 4 Payroll Taxes 8,944 10,816 11,318 12,343 12,400 5 Retirement 8,979 12,940 13,545 14,511 13,600 6 Unemployment and Worker's comp 2,801 2,781 5,406 4,221 4,500 7 Employee Insurance 24,540 33,368 32,713 36,324 37,600 8 Temporary Services Labor 5,754 - - 9 Contractual Services - 12,824 - - - 10 Utilities 19,446 17,333 17,830 17,986 19,000 11 Insurance Property - 660 12 Repairs & Maint. - Other (54) - - - 13 Equipment Non-capitalized - Tools - 5,298 7,639 7,000 14 Computer Hardware - 349 928 - - 15 Software Expense - 1,232 2,712 4,350 3,500 17 Office Supplies - 245 374 500 18 Professional Services - 85 2,570 2,500 19 Insurance Liability - 1,510 20 Travel, Training & Memberships 1,190 1,592 1,170 145 2,000 21 Job Recruitment Costs 331 - - 22 Publications Advertising and Printing 1,370 1,206 520 701 1,500 23 Total General Fund 189,759 245,891 255,916 270,601 273,470 24 25 One Cent Fund 28 Transfer to Special Revenue Fund 22,569 - - - - 29 Total One Cent Fund 22,569 - - - - 30 31 Special Revenue Fund - Direct Distribution 32 Computer Hardware 1,074 - - - - 33 Supplies 14,553 16,608 13,999 11,964 21,817 34 Professional Services 4,134 - 2,047 219 - 37 Total Special Rev Fund - Direct Distribution 19,762 16,608 16,045 12,183 21,817 #11 FY19 - New allocation formula for insurance #15 Update diagnostic software for vehicles #18 Uniform laundry service & testing the underground fuel tanks #19 FY19 - New allocation formula for insurance Project Index #28 #4702 - Service Center CITY OF SHERIDAN Fiscal Year 2019 Budget City Service Shop Page 95 Page 96 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 139,837.83 163,255.12 161,354.96 160,198.49 164,300.00 3 Part-time/Seasonal Wages 23,850.61 11,909.99 0.00 0.00 0.00 4 Overtime 3,499.22 2,342.38 2,597.77 2,814.94 2,350.00 5 Payroll Taxes 12,674.20 12,849.57 11,960.78 11,993.32 12,600.00 6 Retirement 14,079.39 15,583.29 15,476.99 15,377.24 16,700.00 7 Unemployment and Worker's comp 3,909.75 3,209.03 5,545.03 4,037.48 4,600.00 8 Employee Insurance 26,594.19 27,458.12 23,536.88 23,674.03 24,300.00 9 Temporary Services Labor 0.00 0.00 0.00 1,279.46 7,680.00 11 Outside Services 0.00 1,110.88 1,895.42 321.37 0.00 12 Telephone & Internet 1,667.42 1,542.10 1,656.04 1,793.83 1,840.00 13 Repairs & Maint. - Other 0.00 0.00 0.00 0.00 0.00 14 Copier & Printer Costs 0.00 254.26 516.76 1,365.42 1,350.00 15 Equipment Non-capitalized 0.00 0.00 0.00 0.00 0.00 16 Computer Hardware 2,376.00 3,680.99 1,818.99 1,454.99 3,750.00 17 Software Expense 27,584.57 5,636.02 18,757.09 20,014.20 65,311.00 18 Supplies - Passports 0.00 0.00 169 2,658 1,800 19 Office Supplies 6,682.26 6,061.19 4,997.41 3,400.00 5,000.00 20 Professional services 139,185.65 138,592.12 146,973.00 171,676.89 190,200.00 21 Insurance Liability 165.40 156.60 182.49 183.51 1,540.00 22 Travel, Training & Memberships 280.40 713.17 313.50 207.50 4,000.00 23 Publications Advertising and Printing 2,831.42 388.00 59.00 1,076.22 2,400.00 24 Uncollectible Accounts 604.18- 1,602.09 1,468.11 1,354.00- 0.00 25 Total General Fund 404,614 396,345 399,279 422,379 509,721 FY15 thru FY18 these costs were included in the Water & Sewer Funds in FY19 the customer service department was moved to the General Fund #9 12 weeks of Temp Service wages - necessary during CS Rep on maternity leave #11 First aid cabinet, records shredding, custom reports for billing - moved to professional services line #20 in FY19 #17 Increased need of $47,000/year for Meter reading software and hosting of data #18 Passport Supplies - postage, envelopes, black pens #20 Increased banking fees by $35k for new banking agreement - this is off-set by increase in interest income #20 Slight increase in each: Credit Card Services, IVR, web payment services, bill printing/mailing service etc. #20 Moved in FY19 outside services line #11 - first aid cabinet, records shredding, custom reports for billing #21 FY19 - New allocation formula for insurance #22 Mueler Training for 2 employees in FY19. Same was budgeted in FY 18 but training will not occur. CITY OF SHERIDAN Customer Service - General Fund Page 46 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Salaries and Wages 170,918 114,871 116,994 110,648 155,300 3 Part-time/Seasonal Wages 51,772 50,277 41,065 41,717 49,450 4 Part-time/Seasonal Wages - Parks Internship - Fore 2,637 884 - - 6,250 5 Overtime 581 647 1,319 1,670 1,000 6 Payroll Taxes 16,493 12,236 11,924 11,527 16,000 7 Payroll Taxes 202 68 - - 250 8 Retirement 16,875 13,520 13,749 12,980 18,400 9 Unemployment and Worker's comp 8,154 11,580 13,974 11,369 5,800 10 Unemployment and Worker's comp 80 18 - - 100 11 Employee Insurance 43,901 30,836 19,721 18,979 39,200 12 Utilities 14,532 15,432 17,589 19,042 18,000 13 Repairs & Maint. - Buildings/grounds - 33,148 35,321 36,000 14 Insurance Property 774 942 1,060 1,129 1,480 15 Telephone & Internet 1,927 3,003 3,479 3,622 3,500 16 Repairs & Maint. Vehicles/Equip. 15,182 13,892 14,774 11,332 15,000 17 Repairs & Maint. - Irrigation 33,669 26,753 6,184 3,018 4,000 18 Equipment Non-capitalized - 8,372 5,690 6,000 19 Computer Hardware 4,514 2,673 - - 1,000 20 Software Expense - 126 - - - 21 Supplies 33,226 25,721 3,449 34,052 33,000 22 Office Supplies - 317 1,134 1,500 23 Gasoline Oil Diesel Supplies - - - - 14,000 24 Professional Services 18,345 33,033 13,268 - - 25 Insurance Vehicle 177 194 228 212 530 26 Insurance Liability 844 887 1,066 931 1,700 27 Travel, Training & Memberships 4,080 3,404 3,107 2,258 3,000 28 Job Recruitment Costs 233 1,483 - 29 Publications Advertising and Printing - 481 2,465 50 1,000 30 Capital Outlay - Improvements - 1,791 - - - 31 Capital Outlay - Improvements 3,000 - 3,000 - 32 Capital Outlay - Improvements - 10,000 - - 33 Capital Outlay - Machinery and Equip. 7,704 - - - 34 Total General Fund 438,881 373,970 337,487 331,162 431,460 35 36 One Cent Fund 37 Repairs & Maint. - Other 12,874 1,503 - - - 40 Professional Services - 23,098 24,233 22,052 41 Capital Outlay - Improvements Park Projects 168,733 117,118 - - - 42 Capital Outlay - Improvements 134,298 - - - - 43 Capital Outlay - Improvements 7,500 - - - - 44 Capital Outlay - Improvements - 9,307 - 10,000 46 Debt Service Principal 78,233 - - - - 48 Transfer to Special Revenue Fund - 25,000 25,000 49 Transfer to Special Revenue Fund - 304,349 40,000 - - 50 Transfer to Special Revenue Fund - 199,087 122,000 125,000 51 Transfer to Special Revenue Fund - - - - 25,000 52 Transfer to Special Revenue Fund - 100,000 - 10,000 - 53 Transfer to Special Revenue Fund - 70,000 85,000 - 54 Transfer to Special Revenue Fund - 50,000 290,000 - 55 Transfer to Special Revenue Fund - - 35,000 50,000 56 Transfer to Special Revenue Fund - 100,000 - 57 Transfer to Special Revenue Fund - 40,000 - 58 Transfer to Special Revenue Fund - - - - 30,000 59 Transfer to Special Revenue Fund - 7,500 - - 60 Transfer to Other Projects - - - 10,693 - 61 Total One Cent Fund 401,637 522,970 398,992 741,926 287,052 62 CITY OF SHERIDAN Fiscal Year 2019 Budget Parks ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Parks 63 Special Revenue Fund - Direct Distribution 66 Supplies 13,674 26,669 31,512 15,157 30,000 67 Gasoline Oil Diesel Supplies 9,360 6,699 8,372 8,292 - 68 Professional Services 1,720 52,941 46,755 40,000 69 Capital Outlay - Improvements 31,517 13,317 - - 70 Capital Outlay - Machinery and Equip - - - 35,420 46,652 71 Total Special Rev Fund - Direct Distribution 23,034 66,605 106,143 105,624 116,652 72 73 Special Revenue Fund - Projects 74 Capital Outlay - Improvements 3,468 - - - - 75 Capital Outlay - Improvements Public Benefit Fund 622,595 - - - - 76 Capital Outlay - Improvements Grant Funded 100,000 - - - - 77 Capital Outlay - Improvements - 1,515 3,990 6,472 5,291 78 Capital Outlay - Improvements - 8,695 - - - 79 Capital Outlay - Improvements - 29,853 96,853 183,037 179,674 80 Capital Outlay - Improvements - 24,563 91,622 965,038 32,161 81 Capital Outlay - Improvements - 4,062 267,950 63,199 70,577 82 Capital Outlay - Improvements 21,550 119,132 222 83 Capital Outlay - Improvements - 13,712 - 201,288 84 Total Special Revenue Fund - Projects 726,063 68,687 495,677 1,336,878 489,213 85 Total Special Revenue Fund 749,097 135,292 601,820 1,442,502 605,865 86 87 Cap Tax Fund 88 Capital Outlay - Improvements 30,180 - - - - 89 Transfer to Special Revenue Fund - 100,000 - - - 90 Transfer to Special Revenue Fund - 50,000 - - - 91 Transfer to Special Revenue Fund - 38,384 - 335,000 50,000 92 Total Cap Tax Fund 30,180 188,384 - 335,000 50,000 93 94 Public Benefit Fund 95 Transfer to General Fund - 100,000 100,000 96 Transfer to Special Revenue Fund - - - - 50,000 97 Transfer to Special Revenue Fund - 22,000 - - 98 Transfer to Special Revenue Fund - - 40,000 125,000 99 Transfer to Special Revenue Fund - 45,000 - - 100 Transfer to Special Revenue Fund 55,000 - 100,000 101 Transfer to Special Revenue Fund - 50,000 90,000 50,000 102 Transfer to Special Revenue Fund - 241,726 50,000 - 103 Transfer to Special Revenue Fund - 94,846 8,058 104 Transfer to Special Revenue Fund - 15,000 - - 105 Transfer to Special Revenue Fund 178,000 - - 106 Total Public Benefit Fund - - 606,726 374,846 433,058 #3 FY19 additional seasonal worker #4 FY19 includes Forestry Grant $3000 and matching funds for summer intern #13 Grounds maintenance for all city parks #14 FY19 - New allocation formula for insurance #21 General supplies - restrooms, shop, parks, safety supplies, hardware, etc.. #23 Was in Direct Distribution line #65 in prior years #24 Funding moved to Direct Distribution line #66 #25 FY19 - New allocation formula for insurance #26 FY19 - New allocation formula for insurance #27 FY19 minimum to keep current certifications #40 City arborist - pruning, technical removals #66 Pathway repairs, playground equipment repairs/upgrades #67 FY19 - moved to General Fund line #23 #68 Janitorial services, contract mowing, portable toilets #70 Part of mower replacement plan ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Parks Project Index #31 #3001 - Forestry Grant - Internship #32 #3002 - Forestry Grant - Tree Planting #40 #5712 - Contract Arborist #42 #5701 - Pathways #43 #5706 - Water Trail Project #44 #5712 - Park Improvements #46 Mavrakis Park Paving #47 Rec District Contract & Tennis Bubble Utilities #48 #4801 - City Crushing Project #49 #5701 - Pathways #50 #5705 - ACOE 1135 Study #51 #5707 - Gateway Park #52 #5708 - Cemetery Building #53 #5709 - 5th Street Park #54 #5710 - Kendrick Park Improvements #55 #5712 - Park Improvements #56 #5714 - North Park Pond #57 #5716 - Sheridan Multi-Use Pathway Connection #58 #5717 - Kendrick Pool Design/Engineering Assessment #59 #5726 - North Park Stream Improvements #60 #5712 - Park Improvements #74 #4710 - Safe Routes to School #75 #5701 - Pathways #76 #5701 - Pathways #77 #5703 - Mill/Crook #78 #5704 - Kendrick Park Arboretum #79 #5709 - 5th Street Park #80 #5710 - Kendrick Park Improvements #81 #5712 - Park Improvements #82 #5713 - DoubleDay Sports Complex #83 #5714 - North Park Pond #89 #5701 - Pathways #90 #5709 - 5th Street Park #91 #5710 - Kendrick Park Improvements #96 #5700 - Parks & Recreation Master Plan #97 #5701 - Pathways #98 #5705 - ACOE 1135 Study #99 #5708 - Cemetery Building #100 #5709 - 5th Street Park #101 #5710 - Kendrick Park Improvements #102 #5712 - Park Improvements #103 #5713 - DoubleDay Sports Complex #104 #5714 - North Park Pond #105 #5716 - Sheridan Multi-Use Pathway Connection Page 59 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 General Fund 2 Contractual Services 125,250 122,500 117,500 146,500 146,500 3 Utilities - Tennis Bubble 5,835 - - - 4 Insurance Property - 2,560 5 Telephone & Internet 3,160 3,374 2,856 3,383 3,500 8 Total General Fund 128,410 131,709 120,356 149,883 152,560 9 10 One Cent Fund 11 Contractual Services 26,726 25,000 25,000 12 Utilities - Tennis Bubble 6,716 5,901 8,000 13 Capital Outlay - Improvements - 16,523 - - - 15 Total One Cent Fund - 16,523 33,442 30,901 33,000 16 22 Special Revenue Fund 25 Kendrick Park Pool Improvements - 91,500 - - - 26 Total Special Revenue Fund - 91,500 - - - 27 28 Public Benefit Fund 29 Contractual Services - - 33,274 - - 31 Total Public Benefit Fund - - 33,274 - - #4 FY19 - New allocation formula for insurance CITY OF SHERIDAN Fiscal Year 2019 Budget Recreation District Page 71 Page 72 Page 73 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Special Revenue Fund - Projects 2 Contractual Services 52,615 - - - - 3 Equipment Non-capitalized 1,350 37,927 22,893 9,180 4 Professional Services - 70,363 - 51,567 5 Professional Services - - - - 78,889 6 Professional Services - - - - 90,533 7 Professional Services - 145,182 18,700 447,205 8 Capital Outlay - Land - 124,000 - - 9 Capital Outlay - Infrastructure 1,097,493 786,403 - - - 10 Capital Outlay - Infrastructure 2,052,026 36,861 - - - 11 Capital Outlay - Infrastructure - - - 73,000 12 Capital Outlay - Infrastructure 181,829 1,558,191 2,323,859 1,848,870 1,757,301 13 Capital Outlay - Infrastructure 20,758 - 4,855 - - 14 Capital Outlay - Infrastructure - 34,318 75,340 83,742 6,601 15 Capital Outlay - Infrastructure - 64,895 505,929 165,040 14,524 16 Capital Outlay - Infrastructure 1,141,228 173,265 - - - 17 Capital Outlay - Buildings - - - - 18 Capital Outlay - Buildings 2,198,309 95,672 10,998 - 4,002 19 Capital Outlay - Buildings - 211,000 - - 20 Capital Outlay - Improvements 17,223 163,369 2,217,872 156,230 695,306 21 Capital Outlay - Improvements - 361,050 1,910,616 742,734 69,879 22 Capital Outlay - Improvements - 280,155 175,129 3,440,043 825,082 23 Capital Outlay - Improvements - 69,562 3,653 1,785 24 Capital Outlay - Improvements 1,284,662 1,005,352 554,600 821,815 578,232 25 Capital Outlay - Improvements 32,954 - - - - 26 Capital Outlay - Improvements 232,886 217,675 5,506 - - 27 Capital Outlay - Improvements 1,515,335 214,306 21,083 (12,372) 65,642 28 Capital Outlay - Improvements 1,629,201 221,676 289,156 231,285 8,899 29 Capital Outlay - Improvements - - - - 30 Capital Outlay - Improvements - 1,342 79,986 186,743 909,648 31 Capital Outlay - Improvements 206,042 11,648 - - - 32 Capital Outlay - Improvements 181,585 194,651 1,532,664 5,857,996 1,815,223 33 Capital Outlay - Improvements - 112,077 23,923 34 Capital Outlay - Improvements - 81,216 465,829 138,075 2,881 35 Capital Outlay - Improvements - 25,000 - - - 36 Capital Outlay - Improvements - 361,668 - - - 37 Capital Outlay - Improvements - 40,511 56,516 178,856 4,146,417 38 Capital Outlay - Improvements - - - - 390,000 Capital Outlay - Improvements - - - - 190,000 39 Capital Outlay - Improvements 1,621 334 - - - 40 Capital Outlay - Improvements - 119,516 102,922 - 13,953 41 Capital Outlay - Improvements - 140,577 3,250 - 15,682 42 Capital Outlay - Improvements - 1,340,314 1,526,096 1 43 Capital Outlay - Improvements - - - 196,243 7,273,757 Capital Outlay - Improvements - 452,449 38,439 7,475 44,286 Capital Outlay - Improvements - - - - 25,000 44 Capital Outlay - Improvements - - - - 100,000 45 Capital Outlay - Improvements - - - - 100,000 46 Capital Outlay - Improvements - - - - 50,000 47 Capital Outlay - Improvements 19,334 - - 48 Capital Outlay - Improvements - - - - 30,000 49 Capital Outlay - Improvements - - - 26,685 81,064 50 Capital Outlay - Improvements - 21,285 - 7,154 51 Capital Outlay - Improvements - - - - 50,000 52 Capital Outlay - Improvements Public Benefit Fund - 597,581 90,501 - 6,850 53 Capital Outlay - Machinery and Equip 1,830 15,677 - 54 Capital Outlay - Machinery and Equip - 32,372 493,324 46 55 Capital Outlay - Water Lines 860 88,178 390,825 820,113 17,356 CITY OF SHERIDAN Fiscal Year 2019 Budget Capital Projects ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Capital Projects 56 Capital Outlay - Water Lines 188,661 60,889 - - - 57 Capital Outlay - Water Lines 336,787 16,233 - - - 58 Capital Outlay - Water Lines - 42,524 43,045 64,431 59 Capital Outlay - Water Lines 16,490 604,294 1,349,676 671,446 727,819 60 Capital Outlay - Water Lines - 207,155 100,721 1,465 61 Capital Outlay - Water Lines - 424,763 492,651 69,501 2,145 62 Capital Outlay - Water Lines 2,577 115,811 969 - - 63 Capital Outlay - Water Lines 668,564 1,846 - - - 64 Capital Outlay - Sewer Lines 236,706 8,792 - - - 65 Capital Outlay - Sewer Lines 177,259 6,906 - - - 66 Capital Outlay - Sewer Lines - - - 275,000 67 Capital Outlay - Sewer Lines 308,188 2,440 - - - 68 Transfer to Other Projects 370 110,000 - - Transfer to Other Projects - - - 120,643 - 69 Transfer to Other Projects - 44,540 - - 70 Transfer to Other Projects - 140,000 - - 71 Transfer to Other Projects - 55,000 2,500 - 72 Transfer to Other Projects - 10,660 - - Transfer to Other Projects - - - - 34,000 73 Transfer to Other Projects - 37,718 - 74 Transfer to Other Projects 50,000 98,000 14,000 75 Transfer to Other Projects - 65,000 - 76 Transfer to Other Projects 385 - - 77 Transfer to Other Projects 7,004 - - 78 Transfer to Other Projects - 100,000 - - Transfer to Other Projects 0.00 0.00 0.00 158,666.30 - 79 Total Special Revenue Fund - Projects 13,781,860 8,571,551 15,539,607 18,449,233 21,189,728 80 85 Cap Tax Fund 86 Capital Outlay - Improvements - - - - - 91 Total Cap Tax Fund - - - - - Project Index #2 #4717 - South Side Sewer Interceptor #3 #4861 - Traffic Striping & Sign Updates #4 #4801 - City Crushing Project #5 #5318 - Capital Improvement Program #6 #5700 - Parks & Recreation Master Plan #7 #5705 - Army Corps of Engineers Study #8 #5316 - WYO Hallmark Phase I Renovation #9 #4703 - Wyo/Park Street #10 #4726 - Illinois #11 #4740 - East Downtown Improvements #12 #4742 - Loucks St & Waterline Replacement #13 #4746 - 5th & Long Intersection #14 #4748 - E 5th St Infrastructure #15 #4750 - W 5th St Reconstruction SUSAC #16 #4853 - North West Waterloop #17 #4509 - BGWTP Upgrades #18 #4702 - Service Center #19 #5316 - WYO Hallmark Phase I Renovation #20 #4502 - 4MG Tank Repairs #21 #4504 - WWTP Dewatering Improvements #22 #4507 - Meter Replacement #23 #4509 - BGWTP Upgrades #24 #4701 - Street Overlay Program #25 #4702 - Service Center ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Capital Projects #26 #4703 - Wyo/Park Street #27 #4704 - Lewis Street #28 #4716 - Conventional WTP Upgrades #29 #4724 - S. Downtown Neighborhood #30 #4725 - West Downtown #31 #4726 - Illinois #32 #4729 - N. Sheridan Interchange #33 #4744 - Mydland-Dome PRV's #34 #4747 - Holloway St Construction #35 #4749 - Alleys #36 #4752 - High School Access to Mydland Rd #37 #4754 - N. End Infrastructure Extension #38 #4757 - BGWTP Utilidor #39 #4853 - North West Waterloop #40 #4860 - Downtown Parking Development #41 #4861 - Traffic Striping & Sign Updates #42 #5316 - WYO Hallmark Phase I Renovation #43 #5317 - Hillslide Stabilization Project #44 #5701 - Pathways #45 #5707 - Gateway Park #46 #5709 - Blacktooth Park #47 #5710 - Kendrick Park Improvements #48 #5712 - Park Improvements #49 #5716 - Sheridan Multi-Use Pathway Connection #50 #5726 - North Park Stream Improvements #51 #5727 - Community Drainage #52 #5701 - Pathways #53 #4507 - Meter Replacement #54 #4508 - WWTP Emergency Generator #55 #4552 - Sheridan Hydropower #56 #4703 - Wyo/Park Street #57 #4726 - Illinois #58 #4740 - East Downtown Improvements #59 #4741 - Leopard St Waterline Replacement #60 #4743 - W&S Creek Crossing Replacements #61 #4751 - 5th St Waterline Replacement #62 #4753 - W 5th St Waterlines Project #63 #4853 - North West Waterloop #64 #4703 - Wyo/Park Street #65 #4726 - Illinois #66 #4756 - Sanitary Sewer Creek Crossing Replacements #67 #4853 - North West Waterloop #68 #4504 - WWTP Dewatering Improvements #69 #4703 - Wyo/Park Street #70 #4704 - Lewis Street #71 #4716 - Conventional WTP Upgrades #72 #4726 - Illinois #73 #4746 - 5th & Long Intersection #74 #4747 - Holloway St Construction #75 #4750 - W 5th St Reconstruction SUSAC #76 #4753 - W 5th St Waterlines Project #77 #4853 - North West Water Loop #78 #5701 - Pathways Page 98 Page 99 Page 100 Page 101 CITY OF SHERIDAN Sewer Fund Fiscal Year 2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget FY15 FY16 FY17 FY18 FY2019 Line # 1 Sewer Revenue 2,309,262 2,351,260 2,576,157 2,629,692 2,662,980 2 3 Sewer Admin - - 986,252 991,835 962,580 4 Customer Service - - 152,212 161,350 - 5 WW Collection 472,506 426,540 396,116 441,874 490,720 6 WW Treatment 937,879 964,604 897,388 943,084 1,025,750 7 Total Sewer Expenses 1,410,385 1,391,145 2,431,968 2,538,143 2,479,050 8 9 Revenues over Expenses 898,877 960,115 144,189 91,549 183,930 FY15 & FY16 Water & Sewer Funds were combined. #4 FY19 moved Customer Service to General Fund ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Grease/Septage Fees 66,075 69,259 50,542 48,708 69,000 2 Sewer Fees 2,236,987 2,271,801 2,334,127 2,344,854 2,407,980 3 Sewer Inspection Fees 6,200 10,200 3,700 5,668 6,500 4 PIFF - 180,990 212,682 160,000 5 Interest - 5,800 17,781 19,500 6 Other Miscellaneous - 997 - - 7 Total Sewer Fund Revenue 2,309,262 2,351,260 2,576,157 2,629,692 2,662,980 FY15 & FY16 Water & Sewer Funds were combined. #2 Overprojected FY 2018 by $50K; FY19 includes a $15k increase due to growth and #2 a $34K increase due to proposed rate increase of 2.75% which would go into effect January '19 if approved #4 Based on project increase of 64 units and proposed lowering sewer PIF to $2,500 #5 New interest earned projections due to banking change CITY OF SHERIDAN Fiscal Year 2019 Budget Sewer Fund Revenue ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages - 120,042 102,687 115,100 2 Part-time/Seasonal Wages - 441 - - 3 Overtime - 57 5 200 4 Payroll Taxes - 8,709 7,557 8,900 5 Retirement - 11,480 9,816 11,700 6 Unemployment and Worker's comp - 4,149 2,615 3,200 7 Employee Insurance - 23,213 19,548 21,500 8 Outside Services - 857 6,343 - 9 Insurance Property - 1,546 1,647 - 10 Telephone & Internet - 1,917 2,042 1,950 11 Repairs & Maint. Vehicles/Equip.- 145 73 648 13 Copier & Printer Costs - 1,516 1,042 1,300 14 Computer Hardware - - 2,270 200 15 Software Expense - 14,249 13,767 22,075 16 Supplies - 623 932 1,580 17 Office Supplies - 544 990 684 18 Uniform Supplies - 101 - 282 19 Gasoline Oil Diesel Supplies - 763 896 820 20 Professional Services - 23,647 33,340 25,000 21 Insurance Vehicle - - - 40 22 Insurance Liability - - - 1,080 23 Insurance - Claims - - 2,000 - 24 Travel, Training & Memberships - 1,277 1,026 2,600 25 Job Recruitment Costs - - - 98 - 26 Publications Advertising and Printing - 146 515 325 27 Total Sewer Admin Operations - - 215,420 209,208 219,184 28 29 Capital Outlay - Machinery and Equip. - - 13,402 - 30 Total Sewer Admin Capital - - - 13,402 - 31 32 Principal - CAT Leases - 4,963 5,156 - 33 Principal - CWSRF109 - 61,961 61,961 61,961 34 Principal - CWSRF 47 - 57,027 58,183 59,321 35 Principal - CWSRF Loans - - - 202,063 36 Principal - JPA Loans - 11,820 - - 37 Interest - CAT Leases - 2,931 2,737 - 38 Interest - CWSRF47 - 13,487 12,331 11,193 40 Interest - JPA Loans - 16,144 - - 41 Total Sewer Admin Debt - - 168,332 140,368 334,538 42 43 Transfer to General Fund - 190,000 243,000 373,000 44 Transfer to Special Revenue Fund - 187,500 - - 45 Transfer to Special Revenue Fund - - 200,000 - 46 Transfer to Special Revenue Fund - 100,000 - - 47 Transfer to Special Revenue Fund - 125,000 150,000 - 48 Transfer to Water Fund - - - 35,858 35,858 49 Total Sewer Admin Transfer - - 602,500 628,858 408,858 50 51 Total Sewer Admin - - 986,252 991,835 962,580 FY15 & FY16 Water & Sewer Funds were combined. #1 PW Director reallocation in FY2018 to General Fund #2 Intern moved to General Fund in Engineering Dept FY19 #3 Historically Water & Sewer Admin overtime not allocated specifically to sewer fund #3 - will be in FY19 at 40% of Admin overtime costs of $500/yr #8 $5900 document scanning in FY18; combined expenses with line #20 Professional Services in FY19 #9 FY19 - New allocation formula for insurance CITY OF SHERIDAN Fiscal Year 2019 Budget Administration Dept - Sewer ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Administration Dept - Sewer #15 Software; Increase due to MS Applications; Adobe Maintenace Fees and acrobat pro; #16 Includes $880 - new chairs for 1st floor conference room #20 Cityworks development $14K, system hydraulic modeling services $6k, miscellaneous consultant services $5K #21 FY19 - New allocation formula for insurance #22 FY19 - New allocation formula for insurance #29 FY 18 contains 40% of a pending work truck purchase - cost split 60/40 between Water & Sewer Funds #35 Principal and Interest for CWSRF #152 - WWTP Dewatering Improvements #43 Increased allocation transfers to the General Fund - established as 14% of sewer revenues #47 Transfer to Water Fund to pay their portion of JPA Loan and Excavator Lease Project Index #44 #4508 - WWTP Emergency Generator #45 #4725 - West Downtown #46 #4742 - Loucks St & Waterline Replacement #48 #4756 - Sanitary Sewer Creek Crossing Replacements ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages - 61,637 63,247 - 3 Overtime - (62) 561 - 4 Payroll Taxes - 4,487 4,694 - 5 Retirement - 5,844 6,018 - 6 Unemployment and Worker's comp - 2,088 1,573 - 7 Employee Insurance - 8,915 9,298 - 8 Temporary Services Labor - - - 512 - 9 Outside Services - 718 206 - 10 Telephone & Internet - 662 718 - 11 Copier & Printer Costs - 235 570 - 12 Computer Hardware - 540 582 - 13 Software Expense - 7,428 8,006 - 15 Office Supplies - 1,670 1,354 - 16 Professional services - 57,565 63,421 - 17 Insurance Liability - 73 73 - 18 Travel, Training & Memberships - 100 31 - 19 Publications Advertising and Printing - - 430 - 20 Uncollectible Accounts - 312 54 - 21 Total Customer Service Operations - - 152,212 161,350 - FY15 & FY16 Water & Sewer Funds were combined. FY19 moved Customer Service to General Fund #13 Increased need of $18,800 Meter reading software and data hosting fees added #16 Slight increase in each: Credit Card Services, IVR, web payment services, bill printing/mailing service etc. #16 Increased by $14K for 40% of increased Banking fees - Off-set by gains in earned interest to W & S funds. CITY OF SHERIDAN Fiscal Year 2019 Budget Customer Service - Sewer ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 130,124 147,968 146,770 137,318 166,800 2 Part-time/Seasonal Wages - 18,312 11,133 11,265 11,100 3 Overtime 9,040 6,750 9,455 10,973 8,750 4 Payroll Taxes 9,878 12,415 12,089 11,376 13,400 5 Retirement 12,056 15,483 15,284 14,012 16,800 6 Unemployment and Worker's comp 3,133 3,156 5,711 3,951 4,900 7 Employee Insurance 37,402 44,154 39,648 36,183 43,000 8 Contractual Services 486 - - 123 - 9 Contractual Services - 27,250 - - - 11 Outside Services 1,134 1,243 1,345 4,301 - 12 Utilities 7,672 7,506 7,017 9,096 7,300 13 Repairs & Maint. - Buildings/grounds - 1,776 1,143 1,487 2,500 14 Insurance Property - 1,510 15 Telephone & Internet 3,222 2,568 3,120 2,927 2,800 16 Repairs & Maint. Vehicles/Equip. 14,063 6,033 14,131 16,304 15,000 17 Repairs & Maint. - Infrastructure 6,094 5,933 10,742 480 7,500 18 Copier & Printer Costs - 1,980 697 237 1,000 19 Equipment Non-capitalized 10,711 6,836 8,783 2,321 8,000 20 Computer Hardware - 148 - 357 1,000 21 Software Expense 1,980 1,846 2,500 5,177 4,000 22 Supplies 5,760 3,855 5,826 1,834 6,000 23 Office Supplies 663 1,165 682 66 900 24 Uniform Supplies 2,058 3,220 2,714 3,298 3,200 25 Gasoline Oil Diesel Supplies 5,805 4,149 3,916 5,359 7,000 26 Professional Services 75,828 85,603 80,398 75,418 88,220 27 Insurance Vehicle 1,267 1,540 1,733 1,846 800 28 Insurance Liability 596 626 753 657 1,640 29 Insurance - Claims - 9,499 6,806 8,000 30 Travel, Training & Memberships 7,114 1,891 1,028 4,575 4,000 31 Total WW Collection Operations 346,085 413,406 396,116 367,747 435,120 32 33 Capital Outlay - Buildings - - - 25,600 34 Capital Outlay - Machinery and Equip. 126,421 13,134 - 74,127 30,000 38 Total WW Collection Capital 126,421 13,134 - 74,127 55,600 39 40 Total WW Collection 472,506 426,540 396,116 441,874 490,720 #9 Specific budget item for Southside Sewer Interceptor Project costs in FY16 #11 FY19 moved to line #26 Professional Services #14 FY19 - New allocation formula for insurance #16 Increased $7,000 due to historical trends and FY18 year end projections #17 Repairs to manhole covers,collars, rings, lift station repairs. Most expenses will occur in spring to early summer in FY18. #19 Small power tools, hand tools, picks, shovels, #20 40% of two desktops ($1,800) and one laptop ($800) split 60/40 between water and sewer funds #21 increased by $1500 - annual cost of Rockwell SCADA software #22 decreased based on historical trends #26 Sewer Chemical Root Control($75k), lift station diagnostics $2.5k, UM facility cleaning ($2k), comtronix alarm monitoring #27 FY19 - New allocation formula for insurance #28 FY19 - New allocation formula for insurance #29 Increased to be able to pay out two sewer back-up claims (1 to 2 claims/yr is typical) #33 UM Concrete paving - Service Center - 40% of cost #34 Hydrohammer - $18,000 (40% of cost) & Replace Unit 2-25 - $12,000 (40% sewer, 60% water) fleet plan CITY OF SHERIDAN Fiscal Year 2019 Budget WW Collection ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 348,617 390,992 338,123 363,375 361,700 3 Overtime 396 313 343 445 600 4 Payroll Taxes 25,904 27,806 24,375 25,878 27,500 5 Retirement 31,566 35,121 32,789 34,305 36,400 6 Unemployment and Worker's comp 8,679 6,980 11,967 8,996 10,000 7 Employee Insurance 81,136 92,121 99,461 98,542 96,500 9 Outside Services 28,609 20,731 14,941 15,614 - 10 Utilities 135,429 122,580 141,057 164,121 150,000 11 Repairs & Maint. - Buildings/grounds 6,248 669 3,671 2,209 3,800 12 Insurance Property 10,842 13,182 14,835 15,807 13,810 13 Telephone & Internet 6,775 8,750 7,774 8,230 8,000 15 Repairs & Maint. Vehicles/Equip. 12,123 4,557 3,748 6,693 4,000 16 Repairs & Maint. - Infrastructure 64,306 64,967 58,936 46,703 55,000 17 Equipment Rentals - 32 145 - 300 18 Equipment Non-capitalized 1,000 887 1,110 858 1,500 19 Computer Hardware - 1,143 - 788 2,000 20 Software Expense 1,186 3,692 495 - 4,000 21 Supplies 13,881 10,081 11,798 9,572 9,000 22 Office Supplies 899 2,302 1,632 1,218 2,000 23 Uniform Supplies 1,518 889 2,103 1,336 2,000 24 Gasoline Oil Diesel Supplies 9,359 8,204 7,478 7,321 8,500 25 Chemical and Material Supplies 86,814 84,201 83,615 87,728 85,000 26 Professional services 15,268 17,722 12,786 19,891 31,500 27 Insurance Vehicle 1,039 1,195 1,378 1,367 780 28 Insurance Liability 2,232 2,347 2,822 2,463 3,360 29 Insurance - Claims - 3,351 - - 30 Travel, Training & Memberships 5,120 3,375 718 1,598 3,000 31 Job Recruitment Costs - 284 - - 32 Publications Advertising and Printing 276 418 - - - 33 Total WW Treatment Operations 899,222 925,257 881,732 925,056 920,250 34 35 Capital Outlay - Infrastructure - 14,136 8,685 - - 36 Capital Outlay - Buildings 38,657 25,212 6,971 5,666 22,500 37 Capital Outlay - Improvements - - - - - 38 Capital Outlay - Machinery and Equip. - - - 12,362 83,000 39 Total WW Treatment Capital 38,657 39,347 15,657 18,028 105,500 40 41 Total WW Treatment 937,879 964,604 897,388 943,084 1,025,750 #9 FY19 - moved to line #26 Professional Services - rug cleaning and SCADA costs #10 Adjustment for the addition of 6 new electric jet aeration sytems. #12 FY19 - New allocation formula for insurance #16 R&M costs trending down due to new updated pumps, motors, equipment and specifically the Belt Press #18 Hand tools, welding equipment #19 Windows tablet ($1,200) and lap top ($800) per the computer replacement plan #20 SCADA & Rockwell software #21 Reduction due to fewer supplies needed for cleaning services - now being done in-house. #26 EPA lab assessment ($3.5k); mowing services ($6k), HACH Service contract ($6k), Lab Services ($5k), #26 rug cleaning service and SCADA costs; misc. consulting/contract services ($11K) #27 FY19 - New allocation formula for insurance #28 FY19 - New allocation formula for insurance #36 Heating & cooling unit in Admin ($10k est) FY18 budgeted expense performed and paid under WWTP dewatering project. #38 Replace 1 of 4 raw sewage pumps ($40K) along with 3 VFD's and PLC ($43K) CITY OF SHERIDAN Fiscal Year 2019 Budget WW Treatment Page 109 Page 110 Page 111 Page 112 Page 113 Page 114 CITY OF SHERIDAN Water Fund Fiscal Year 2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget FY15 FY16 FY17 FY18 FY2019 Line # 1 Water Revenue 6,938,909 7,304,286 4,860,584 4,762,450 4,909,195 2 3 Water Admin 4,911,285 2,161,556 1,986,517 1,959,891 2,536,699 4 Customer Service 404,614 396,345 246,898 258,371 - 5 Source of Supply 222,112 225,313 206,391 209,874 208,800 6 Water Distribution 634,955 574,046 540,345 622,474 623,480 7 SAWS 216,440 270,708 251,046 228,435 259,280 8 Sheridan WTP 711,842 749,820 617,048 643,242 733,820 9 Big Goose WTP 507,089 491,471 506,369 501,602 546,860 10 WW Collection 472,506 426,540 11 WW Treatment 937,879 964,604 12 Total Water Expenses 9,018,721 6,260,404 4,354,614 4,423,889 4,908,939 13 14 Revenues over Expenses (2,079,812) 1,043,882 505,970 338,561 256 FY15 & FY16 Water & Sewer Funds were combined. #4 FY19 moved Customer Service to General Fund ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 9 SAWS Contribution - Watershed Control Plan 2,042 - - - - 11 Other County 801,497 883,670 773,194 851,932 875,982 12 Grease/Septage Fees 66,075 69,259 - - - 13 Water sales 3,185,504 3,474,557 3,704,460 3,422,510 3,553,761 14 Water Taps 34,659 35,220 32,941 51,005 32,000 15 Water Card /Hydrant Sales 104,320 77,613 90,496 89,540 95,000 16 Sewer Fees 2,236,987 2,271,801 - - - 17 Sewer Inspection Fees 6,200 10,200 - - - 18 Hydropower Revenue - 4,803 43,350 19 PIFF 438,544 390,170 186,043 218,955 227,418 20 Interest 11,515 21,581 33,695 44,452 45,826 21 Interest Income - SAWS 6,127 - - - - 22 Appreciation/Depreciation 18 492 (1,341) (1,474) - 23 Other Miscellaneous 2,771 2,675 1,496 4,313 - 24 Sale of Fixed Assets 3,050 27,448 - 956 - 26 Transfer from Solid Waste 36,000 36,000 36,000 36,000 - 27 Transfer from Sewer - - - 35,858 35,858 28 Transfer from Weed & Pest 3,600 3,600 3,600 3,600 - 29 30 Total Water Fund Revenue 6,938,909 7,304,286 4,860,584 4,762,450 4,909,195 FY15 & FY16 Water & Sewer Funds were combined. #11 SAWS reimbursement of operating expenses #12 In Sewer Fund now #13 No rate increase, slight increase ($27K) projected for growth (no increase accounted for new, more accurate meters) #14 Water tap revenues represent fees charged for each new water service covering the meter, corporation stop, #14 and labor to make the service tap #16 In Sewer Fund now #17 In Sewer Fund now #18 Hydropower in FY 18 will generate revenue for only 3 months and not peak months. #18 FY19 projections are based on 1 MW of power generation and 50% rated capacity (avg. monthly) for capacity payments #19 PIF's at $3,000 for 3/4" equivalent #20 Projected increase due to new banking higher interest returns (1.5% vs. .5%) #26 This transfer will now go directly to the GF for customer service allocations to Solid Waste #27 Transfer from Sewer Fund to pay their portion of JPA Loan and Excavator Lease #28 This transfer will now go directly to the GF for customer service allocations to Weed & Pest CITY OF SHERIDAN Fiscal Year 2019 Budget Water Fund Revenue ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 256,412 302,432 189,114 178,685 172,800 2 Part-time/Seasonal Wages - 3,125 4,864 3,708 - 3 Overtime 273 472 361 282 300 4 Payroll Taxes 18,504 21,725 14,070 13,424 13,300 5 Retirement 21,882 28,613 18,295 16,436 17,500 6 Unemployment and Worker's comp 5,793 5,498 6,666 4,596 4,800 7 Employee Insurance 41,341 55,354 36,453 32,474 30,900 9 Outside Services 12,634 2,250 3,367 12,391 - 10 Insurance Property 2,825 3,434 2,319 2,471 - 11 Telephone & Internet 2,715 2,945 3,217 3,142 2,784 12 Repairs & Maint. Vehicles/Equip. 1,460 159 169 109 200 13 Repairs & Maint. - Other 80 - - - - 14 Copier & Printer Costs 3,242 3,602 2,454 1,563 1,900 16 Computer Hardware - 2,739 - 3,405 300 17 Software Expense 14,617 36,069 22,613 33,409 35,000 18 Supplies 1,619 1,342 1,488 2,800 2,700 19 Office Supplies 1,752 1,608 1,027 1,523 1,100 20 Uniform Supplies 120 126 151 - 425 21 Gasoline Oil Diesel Supplies 2,571 1,929 1,157 1,378 1,300 22 Professional Services 174,613 73,162 61,995 60,539 81,000 23 Professional Services 24,079 - - - - 24 Insurance Vehicle - - - - 60 25 Insurance Liability - - - - 1,620 26 Insurance - Claims 5,000 1,372 - - - 27 Travel, Training & Memberships 3,837 4,879 2,502 2,913 3,900 Job Recruitment Costs - - - 359 - 28 Publications Advertising and Printing 353 1,125 1,921 1,139 1,000 30 Total Water Admin Operations 595,718 553,960 374,204 376,744 372,889 31 33 Capital Outlay - Flouride Addition 30,563 - - - - 34 Capital Outlay 10,000 - 907 11 50,000 36 Capital Outlay 131,840 - - - - 37 Capital Outlay 44,609 - - - - 39 Capital Outlay 27,379 - - - - 54 Capital Outlay 345 - - - - 58 Capital Outlay - Improvements 32,576 - - - - 60 Capital Outlay - Machinery and Equip. - - - 20,102 - 61 Capital Outlay - Water Lines 43,270 - - - - 62 Capital Outlay - Water Lines 35,446 - - - - 64 Total Water Admin Capital 356,028 - 907 20,113 50,000 65 66 Debt Service Principal - DWSRF37 29,678 30,734 32,019 32,230 32,888 67 Debt Service Principal - DWSRF-110 73,635 75,445 78,135 82,251 81,012 68 Principal - 20" Big Goose 47,863 49,060 50,286 51,543 52,832 69 Principal - PMTF Loan 14,747 15,111 15,483 15,865 16,256 70 Principal - CWSRF109 61,961 61,961 - - - 71 Principal - DWSRF 101 18,120 18,280 18,502 18,910 18,773 72 Principal - CWSRF 47 53,579 55,144 - - - 73 Debt Service Principal 11,563 - - - - 74 Debt Service Principal - CAT Leases - 7,444 7,735 13,394 76 Principal - DWSRF Loans 17,685 16,009 28,473 53,140 165,247 77 Principal - JPA Loans - 31,178 17,730 31,242 32,441 78 Debt Service Interest - DWSRF37 9,416 8,360 7,075 6,864 3,206 79 Debt Service Interest - DWSRF-110 37,557 35,746 33,056 28,941 30,180 80 Interest - 20" Big Goose 21,457 20,260 19,034 17,777 16,488 81 Interest - PMTF Loan 11,024 10,660 10,288 9,906 9,515 82 Interest - DWSRF 101 3,576 3,416 3,194 2,786 2,924 83 Interest - CWSRF47 16,935 15,369 - - - CITY OF SHERIDAN Fiscal Year 2019 Budget Administration Dept - Water ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Administration Dept - Water 84 Debt Service Interest 460 - - - - 85 Debt Service Interest - CAT Leases - 4,396 4,106 6,341 86 Interest - DWSRF Loans 14,948 9,372 33,075 18,572 471,844 87 Interest - JPA Loans - 31,100 24,216 38,668 37,469 88 Total Water Admin Debt 444,203 487,206 382,406 420,534 990,810 89 90 Transfer to General Fund 550,000 555,000 275,000 455,000 683,000 91 Transfer to Special Revenue Fund 510,505 - - - - 92 Transfer to Special Revenue Fund 50,000 - - - - 93 Transfer to Special Revenue Fund - 195,391 - - - Transfer to Special Revenue Fund - - - 15,000 - 94 Transfer to Special Revenue Fund 94,818 50,000 50,000 50,000 50,000 95 Transfer to Special Revenue Fund 780,000 - - - - 96 Transfer to Special Revenue Fund 150,000 - - - - 97 Transfer to Special Revenue Fund 230,000 - - - - 98 Transfer to Special Revenue Fund 52,615 - - - - 99 Transfer to Special Revenue Fund - 100,000 200,000 - - 100 Transfer to Special Revenue Fund 300,000 - - - - 101 Transfer to Special Revenue Fund 45,000 - - - - 102 Transfer to Special Revenue Fund - 50,000 85,000 - 103 Transfer to Special Revenue Fund 17,000 - 16,500 35,000 - 104 Transfer to Special Revenue Fund - 140,000 387,500 387,500 - 105 Transfer to Special Revenue Fund - 250,000 - - 106 Transfer to Special Revenue Fund - 115,000 - 107 Transfer to Special Revenue Fund 2,577 80,000 - - - 108 Transfer to Special Revenue Fund - - - - 390,000 109 Transfer to Special Revenue Fund 732,822 - - - - 111 Total Water Admin Transfer 3,515,336 1,120,391 1,229,000 1,142,500 1,123,000 112 113 Total Water Admin 4,911,285 2,161,556 1,986,517 1,959,891 2,536,699 FY15 & FY16 Water & Sewer Funds were combined. #9 Consolidated expenses to line #22 $42K for payment to SAWS for Sheridan Commercial Annexation #10 FY19 - New allocation formula for insurance #11 Telephone; Increased to match invoicing for FY18 #17 CityWorks, WaterGEMS modeling software, ESRI GIS, Connect Sheridan App, Flow master, #17 and XC2 software for backflow, Microsoft Office Suite #18 Increased by $1,300 for new Chairs in conference room #22 Payment to SAWS ($42k), CityWorks Development ($21k), water modeling support ($9k), misc consulting & association dues ($9k) #24 FY19 - New allocation formula for insurance #25 FY19 - New allocation formula for insurance #34 Watershed Control Plan Implementation - no expenses generated in FY 18, but will in FY 19 #60 60% of Fleet pick-up for Utility Services - awarded and will be expensed in FY 18 #76 DWSRF#135 $17,098, DWSRF#148 $11,668, DWSRF#166 $15,393 & #76 1st year's payment hydropower, $31,575, 5th Street Water Main $24,057, 4MG Tank $33,087, Leopard Waterline $32,369 #86 DWSRF#135 $8,284, DWSRF#148 $6,384, DWSRF#166 $8,650, Interest on Conventional Upgrades DWSRF#123 $448,526 #90 Increase in transfers to GF for Administration (14% of revenues) #94 Transfers to the annual Rotomill and Overlay project to pay for fire hydrant relocations coordinated with this annual project. #108 Project to replace failing underground utility corridor at the BGWTP ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Administration Dept - Water Project Index #34 #4501 - Watershed Control #91 #4500 - Flouride Addition #92 #4502 - 4MG Tank Repairs #93 #4504 - WWTP Dewatering Improvements ##4552 - Sheridan Hydropower #94 #4701 - Street Overlay Program #95 #4702 - Service Center #96 #4703 - Wyo/Park Street #97 #4704 - Lewis Street #98 #4717 - South Side Sewer Interceptor #99 #4725 - West Downtown #100 #4726 - Illinois #101 #4729 - N. Sheridan Interchange #102 #4740 - East Downtown Improvements #103 #4741 - Leopard Street Waterline Replacement #104 #4742 - Loucks St & Waterline Replacement #105 #4743 - W&S Creek Crossing Replacements #106 #4744 - Mydland-Dome PRV's #107 #4753 - W 5th St Waterlines Project #108 #4757 - BGWTP Utilidor #109 #4853 - North West Water Loop ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 139,838 163,255 99,718 96,951 - 2 Part-time/Seasonal Wages 23,851 11,910 - - - 3 Overtime 3,499 2,342 2,660 2,253 - 4 Payroll Taxes 12,674 12,850 7,474 7,299 - 5 Retirement 14,079 15,583 9,633 9,359 - 6 Unemployment and Worker's comp 3,910 3,209 3,457 2,464 - 7 Employee Insurance 26,594 27,458 14,622 14,376 - 8 Temporary Services Labor - - - 768 - 10 Outside Services - 1,111 1,177 321 - 11 Telephone & Internet 1,667 1,542 994 1,076 - 13 Copier & Printer Costs - 254 282 795 - 15 Computer Hardware 2,376 3,681 1,279 873 - 16 Software Expense 27,585 5,636 11,329 12,009 - 17 Supplies 338 - - - - 18 Office Supplies 6,344 6,061 3,328 2,046 - 19 Professional services 139,186 138,592 89,408 108,256 - 20 Insurance Liability 165 157 109 110 - 21 Travel, Training & Memberships 280 713 214 176 - 22 Publications Advertising and Printing 2,831 388 59 646 - 23 Uncollectible Accounts (604) 1,602 1,156 (1,408) - 24 Total Customer Service Operations 404,614 396,345 246,898 258,371 - FY15 & FY16 Water & Sewer Funds were combined. FY19 moved Customer Service to General Fund #10 First aid cabinet, records shredding, custom reports for billing #16 Increased need of $28,200/ yr for Meter reading software and hosting #19 Increased by $21K for 60% of Banking fees - Off-set by gains in earned interest to W & S funds. CITY OF SHERIDAN Fiscal Year 2019 Budget Customer Service - Water ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 74,090 77,564 61,667 78,055 76,900 2 Part-time/Seasonal Wages - 1,749 6,035 8,645 8,400 3 Overtime 2,316 2,036 1,504 1,263 1,600 4 Payroll Taxes 5,316 5,549 5,206 6,291 6,600 5 Retirement 6,962 7,445 6,261 8,004 8,400 6 Unemployment and Worker's comp 1,803 1,436 2,469 (2,334) 2,400 7 Employee Insurance 18,834 14,383 12,971 18,597 18,100 8 Outside Services 17,358 23,540 41,250 20,386 - 9 Utilities 10,006 8,963 6,833 7,642 8,500 10 Repairs & Maint. - Buildings/grounds 2,921 2,475 7,517 6,648 8,500 11 Insurance Property 2,218 2,697 3,035 3,234 4,150 12 Telephone & Internet 2,266 2,225 2,357 3,217 2,300 13 Repairs & Maint. Vehicles/Equip. 1,554 1,410 2,349 5,159 1,950 14 Repairs & Maint. - Infrastructure 11,231 53,856 12,062 21,492 20,000 16 Equipment Non-capitalized 1,173 1,195 1,666 3,073 1,200 17 Computer Hardware - - 1,018 - 18 Supplies 1,562 4,404 2,348 2,694 2,250 19 Office Supplies 261 311 330 229 350 20 Uniform Supplies 580 385 804 683 650 21 Gasoline Oil Diesel Supplies 1,179 1,119 1,218 1,049 1,200 22 Professional Services 12,073 2,525 1,395 4,720 27,000 23 Insurance Vehicle 242 294 331 353 50 24 Insurance Liability - - - - 800 25 Travel, Training & Memberships 3,166 1,752 1,781 2,219 2,500 26 Total Source of Supply Operations 177,112 217,313 181,391 202,336 203,800 27 28 Capital Outlay - Infrastructure 45,000 - - 7,538 - 29 Capital Outlay - Buildings - 8,000 - - - 30 Capital Outlay - Improvements - - - - 5,000 31 Total Source of Supply Capital 45,000 8,000 - 7,538 5,000 32 33 Transfer to Special Revenue Fund 25,000 - - 34 Total Source of Supply Transfer - - 25,000 - - 35 36 Total Source of Supply 222,112 225,313 206,391 209,874 208,800 #8 Consolidated expenses to line #22 #10 Planned electrical upgrades and repairs to office building, security fence repair, gravel for road #11 FY19 - New allocation formula for insurance #13 Adjust to typical average - FY18 had an $1,866 vehicle expense that was not typical #14 Increase for Vortex grit unit repair and screening gearboxes #16 Small tools, monitoring and sampling equipment #18 Consumptive Shop, plant supplies, laboratory supplies, and safety supplies #22 Cost share of KVAR study ($3K), HACH lab eqpt calibration ($2.5k), Electrical/SCADA work ($5k), mowing ($2k), Testing ($12.5k) #23 FY19 - New allocation formula for insurance #24 FY19 - New allocation formula for insurance #28 FY18 - Stream gauges #30 Weather Station / Security Cam at Twin Lakes Project Index #29 #4716 - Conventional WTP Upgrades CITY OF SHERIDAN Fiscal Year 2019 Budget Source of Supply ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 218,728 220,329 229,129 245,667 213,500 2 Part-time/Seasonal Wages - 8,092 9,259 9,359 10,700 3 Overtime 12,263 11,342 18,145 21,407 16,000 4 Payroll Taxes 16,568 17,044 18,228 19,743 16,900 5 Retirement 20,202 22,417 23,634 25,283 21,500 6 Unemployment and Worker's comp 6,871 7,110 8,643 6,837 6,200 7 Employee Insurance 60,692 60,912 55,657 59,234 55,300 8 Contractual Services 404 - - 163 - 9 Outside Services 4,275 3,448 2,670 7,691 - 10 Utilities 15,410 24,268 23,483 28,315 25,000 11 Repairs & Maint. - Buildings/grounds 4,336 1,398 1,251 1,728 2,500 12 Insurance Property 323 392 442 470 2,260 13 Telephone & Internet 7,284 11,354 7,464 9,106 8,600 14 Utilities - Other than Building 666 - - - 15 Repairs & Maint. Vehicles/Equip. 7,869 11,030 12,315 9,086 8,000 16 Repairs & Maint. - Infrastructure 39,465 49,627 54,697 48,770 47,000 17 Copier & Printer Costs - - 483 312 800 18 Equipment Non-capitalized 3,375 7,105 3,711 9,704 6,500 19 Computer Hardware 10,315 140 1,009 536 1,600 20 Software Expense 3,757 4,258 4,943 3,301 15,700 21 Supplies 31,963 36,472 30,888 47,856 33,000 22 Office Supplies 717 1,437 907 765 900 23 Uniform Supplies 2,156 760 2,880 3,284 3,000 24 Gasoline Oil Diesel Supplies 18,824 14,192 14,655 17,135 16,500 25 Professional services 12,545 9,324 4,341 943 12,000 26 Insurance Vehicle 2,261 2,527 2,953 2,818 1,200 27 Insurance Liability - - - - 2,070 28 Insurance - Claims - 3,141 - 5,000 29 Travel, Training & Memberships 7,932 6,815 5,414 5,147 7,500 30 Job Recruitment Costs - - - 673 - 31 Publications Advertising and Printing - 818 - - 850 32 Total Water Distribution Operations 508,534 533,278 540,345 585,336 540,080 33 34 Capital Outlay - Infrastructure - 27,190 - - - 35 Capital Outlay - Buildings 445 - - 38,400 38 Capital Outlay - Machinery and Equip. 126,421 13,134 - 37,138 45,000 46 Total Water Distribution Capital 126,421 40,768 - 37,138 83,400 47 48 Total Water Distribution 634,955 574,046 540,345 622,474 623,480 #3 Increase of $3000 based on historical trends and projected year end FY 18 #9 Consolidated expenses to line #25 #10 Increase of $5000 due to projected average and higher at hydrower #11 Increase of $1500 for West Fence repair/install #12 FY19 - New allocation formula for insurance #13 Increase of $3100 for current average and projections and new SCADA lines #16 Repair of water mains, valve replacements, fire hydrant repairs, prv repairs, reservior repairs #18 Metal locator, small power tools, tapping eqpt, submersible pumps, hand tools, sledge hammers, valve keys, air monitors, data loggers #19 60% of Two desktops ($1,800) and one laptop ($800) split 60/40 between water and sewer fund #20 Increase of $14,100 for Mueler Software/Hardware Support #21 Meters ($10K), endpoints ($5k), tapping saddles, cleanining supplies, safety supplies #25 SCADA Maint. ($5k), Lawn Care ($1K), janitorial/rug cleanining ($3K), locates, Khrone meter calibration ($2.5K) #26 FY19 - New allocation formula for insurance #27 FY19 - New allocation formula for insurance #28 Covers City's deductible for one significant water damage claim #35 Concrete paving at UM Building (60% water, 40% sewer) #38 Hydrahammer at 60% - $27,000 & Replacing unit 2-25 (40/60) $18000 for 60% CITY OF SHERIDAN Fiscal Year 2019 Budget Water Distribution ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 100,226 100,014 109,743 102,198 105,700 2 Part-time/Seasonal Wages - 207 7,941 8,656 10,700 3 Overtime 3,167 2,901 4,641 4,511 4,500 4 Payroll Taxes 7,384 7,286 8,840 8,300 9,000 5 Retirement 8,979 9,707 11,114 10,195 10,900 6 Unemployment and Worker's comp 2,331 1,819 4,220 2,803 3,300 7 Employee Insurance 26,283 27,213 27,316 24,689 27,400 8 Contractual Services 1,859 15,180 - - - 9 Outside Services 253 5,851 2,698 6,988 - 10 Utilities 25,901 24,847 27,214 23,818 21,000 11 Repairs & Maint. - Buildings/grounds 1,478 2,005 1,987 1,639 7,300 12 Insurance Property 7,110 8,645 9,728 10,366 2,540 13 Telephone & Internet 794 1,568 2,849 605 1,750 14 Repairs & Maint. Vehicles/Equip.- 642 800 15 Repairs & Maint. - Infrastructure 13,467 19,152 18,077 11,561 21,500 17 Equipment Non-capitalized - - - 1,500 - 18 Software Expense 1,186 - - - - 19 Supplies 11,006 19,955 8,109 8,918 11,500 20 Chemical and Material Supplies - 1,246 742 933 1,100 21 Professional Services 5,016 1,474 2,684 113 9,200 22 Insurance Liability - - - - 1,090 23 Insurance - Claims - 3,141 - - 25 Total SAWS Operations 216,440 249,069 251,046 228,435 249,280 26 27 Capital Outlay - Infrastructure - 21,194 - - - 28 Capital Outlay - Buildings - 445 - - 10,000 29 Total SAWS Capital - 21,639 - - 10,000 30 31 Total SAWS 216,440 270,708 251,046 228,435 259,280 #9 Consolidated expenses to line #21 #10 Project lower electrical costs, pump station retrofits with more efficient pumps and motors #11 Replace 2 heaters at $2500 #12 FY19 - New allocation formula for insurance #13 Centurylink SCADA lines #14 generator maintenance #15 Leak repairs and planned hydrant replacements #19 Meters ($5K), endpoints ($2.5k), tapping saddles, cleanining supplies, safety equipment #21 SCADA repairs ($3k), mowing ($3k), plumbing, electrical, generator service ($3K), locates ($200) #22 FY19 - New allocation formula for insurance #28 Replace roof $10K for Big Horn Pump CITY OF SHERIDAN Fiscal Year 2019 Budget SAWS ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 220,032 210,292 185,191 200,015 192,300 2 Part-time/Seasonal Wages 4,892 18,192 7,833 9,160 8,000 3 Overtime 5,772 6,262 7,268 8,340 6,300 4 Payroll Taxes 16,200 16,652 14,819 15,580 15,400 5 Retirement 18,279 21,855 19,614 20,359 20,100 6 Unemployment and Worker's comp 4,897 4,311 7,099 5,412 5,600 7 Employee Insurance 50,323 58,158 50,659 51,988 51,400 10 Outside Services 24,761 21,029 20,117 23,669 - 11 Utilities 77,130 57,187 53,826 58,990 55,000 12 Repairs & Maint. - Buildings/grounds 14,903 5,893 19,190 10,828 12,000 13 Insurance Property 6,671 8,112 9,128 9,726 12,370 14 Telephone & Internet 9,293 11,900 10,976 11,141 12,000 16 Repairs & Maint. Vehicles/Equip. 5,925 4,636 5,903 7,399 6,000 17 Repairs & Maint. - Infrastructure 41,073 45,213 26,076 34,147 28,000 19 Copier & Printer Costs - 20 - - 900 20 Equipment Non-capitalized 5,734 5,848 18,873 6,418 7,500 21 Computer Hardware 2,817 599 - 1,375 2,700 22 Software Expense 1,581 2,043 1,907 2,176 1,600 23 Supplies 8,068 11,268 10,415 12,737 12,000 24 Office Supplies 3,558 1,802 2,501 2,123 2,500 25 Uniform Supplies 756 1,213 1,705 973 1,250 26 Gasoline Oil Diesel Supplies 4,525 3,675 3,803 4,094 3,700 27 Chemical and Material Supplies 90,022 161,397 118,265 97,375 125,000 28 Professional services 27,503 14,388 9,391 6,539 34,000 29 Insurance Vehicle 436 519 589 612 320 30 Insurance Liability 5,506 5,788 6,959 6,076 1,880 31 Travel, Training & Memberships 3,839 3,338 1,936 2,862 4,200 32 Job Recruitment Costs - 159 478 - 33 Publications Advertising and Printing 220 1,871 2,846 3,530 1,800 35 Total Sheridan WTP Operations 654,716 703,461 617,048 614,121 623,820 36 37 Capital Outlay - Infrastructure 29,625 23,900 - - 80,000 38 Capital Outlay - Buildings - 14,003 - - - 40 Capital Outlay - Machinery and Equip. 27,500 8,456 - 29,121 30,000 41 Total Sheridan WTP Capital 57,125 46,359 - 29,121 110,000 42 43 Total Sheridan WTP 711,842 749,820 617,048 643,242 733,820 #10 Consolidated expenses to line #28 #11 Less pumping costs due to filling high pressure zone tank with gravity fed water from the Big Goose Water Plant #12 General repairs and maintenance included plus specific costs to cover roof drain repairs #13 FY19 - New allocation formula for insurance #14 Decreased to reflect FY18 projections with no changes anticipated for FY19, includes SCADA #17 Increased projections by $9k to reflect hiring a contract electrician to troubleshoot and repair electrical items. #19 Expense billed annually at end of FY in June #20 Tools, small pumps & motors, chemical feed equipment, lab equipment #21 Three desktop replacements ($2700) #22 MS OFFICE $280, rockwell tech support ($1k), WIN911 software ($250) #23 Consumptive Shop, plant supplies, cleaning supplies, safety supplies ($4k), laboratory supplies ($8k), #27 Decreased due to NW tank now filling from BGWTP. BGWTP chemicals budget are subsequently up. #28 UCMR4 testing and instrument service agreement ($7k), HACH instrument compliance testing ($6.4k), mowing ($2k), #28 laboratory services ($11.7k), electrician work ($5k) #29 FY19 - New allocation formula for insurance #30 FY19 - New allocation formula for insurance #32 Expenses for job postings and advertising included in budget line item #33 #33 Expenses for FY18 will be realized primarily in June for EPA Consumer Confidence Report (split with BGWTP) #37 Replace cracking hypochlorite tanks #40 Replace 2-85 Half ton 4x4 CITY OF SHERIDAN Fiscal Year 2019 Budget SWTP ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 178,591 137,620 169,134 160,897 169,500 2 Part-time/Seasonal Wages - - 5,935 8,336 8,000 3 Overtime 7,915 6,623 4,533 3,659 5,500 4 Payroll Taxes 14,019 10,864 12,377 12,342 13,600 5 Retirement 17,050 14,236 16,454 16,109 17,800 6 Unemployment and Worker's comp 4,402 10,605 5,932 4,287 5,000 7 Employee Insurance 31,535 27,827 40,472 42,782 48,500 8 Other Employee Expenses 4,000 - - - - 11 Outside Services 16,517 33,294 10,052 4,683 - 12 Utilities 43,294 34,082 37,786 38,719 36,000 13 Repairs & Maint. - Buildings/grounds 8,297 6,819 8,430 9,355 9,500 14 Insurance Property 4,098 4,983 5,607 5,975 10,790 15 Telephone & Internet 4,705 6,483 6,153 6,881 5,850 16 Repairs & Maint. Vehicles/Equip. 3,814 5,022 7,497 3,238 7,000 17 Repairs & Maint. - Infrastructure 19,349 26,350 15,754 47,378 18,500 19 Equipment Non-capitalized 8,032 8,823 14,017 9,226 9,000 20 Computer Hardware 2,667 62 - - 900 21 Software Expense 1,186 2,043 1,907 2,176 1,700 22 Supplies 8,726 7,100 6,992 9,391 7,000 23 Office Supplies 779 558 316 261 600 24 Uniform Supplies 1,147 1,902 1,184 1,616 1,600 25 Gasoline Oil Diesel Supplies 2,532 2,520 2,485 1,931 2,500 26 Chemical and Material Supplies 49,418 32,403 44,562 62,638 80,000 27 Professional Services 10,865 12,985 13,241 9,563 24,500 28 Insurance Vehicle - 160 29 Insurance Liability 5,506 5,788 6,959 6,076 1,660 30 Travel, Training & Memberships 6,157 1,700 3,489 4,552 4,200 31 Job Recruitment Costs - 397 639 - 32 Publications Advertising and Printing - 1,905 - - 1,500 33 Total Big Goose WTP Operations 454,603 402,596 441,664 472,709 490,860 34 35 Capital Outlay - Infrastructure 11,450 - - 28,893 - 36 Capital Outlay - Buildings 10,851 - 11,072 - 56,000 37 Capital Outlay - Machinery and Equip. 28,500 28,875 - - - 38 Capital Outlay - Water Lines 1,684 - - - - 39 Total Big Goose WTP Capital 52,485 28,875 11,072 28,893 56,000 40 41 Transfer to Special Revenue Fund 60,000 - - - 42 Transfer to Special Revenue Fund 53,633 - - 43 Total Big Goose WTP Transfer - 60,000 53,633 - - 44 45 Total Big Goose WTP 507,089 491,471 506,369 501,602 546,860 #11 Consolidated expenses to line #27 #14 FY19 - New allocation formula for insurance #17 Repair raw water pumps ($9k), valve rebuilds ($2,100), Trac Vac repairs ($1,300), flow meter repairs ($2,500) #20 Desktop replacement ($900) #21 MS Office applications ($280), WIN911 ($250) and portion of Rockwell Software Tech Support ($1k) #22 Consumptive Shop, plant supplies, cleaning supplies, safety supplies ($3k), laboratory supplies ($4k), #26 Increase of $30k due to BGWTP providing water to NW tank that was once done by the SWTP #26 - SWTP budget reduced same amount as increase #27 KVAR Study ($3k), mowing ($2k), HACH Instrumentation Compliance ($6.4k), laboratory services ($3k), #27 SCADA and Electrical work ($9.3k), pest control services ($750) #28 FY19 - New allocation formula for insurance #29 FY19 - New allocation formula for insurance #31 Expenses for job postings moved to line #31 in FY19 #32 Job postings, EPA Consumer Confidence Report expensed in June of each FY - Will see an unbudgeted expense in FY18 in June. #36 Repair of siding & staining the BGWTP. $30k in FY18 will not be expensed as single bid of $56k was over budget. FY19 request $56k CITY OF SHERIDAN Fiscal Year 2019 Budget BGWTP ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget BGWTP Project Index #38 #4721 - BGWTP Clearwell #41 #4509 - BGWTP Upgrades #42 #4716 - Conventional WTP Upgrades Page 127 Page 128 Page 129 Page 130 Page 131 CITY OF SHERIDAN Solid Waste Fund Fiscal Year 2019 Budget ACTUAL ACTUAL ACTUAL ACTUAL Budget FY15 FY16 FY17 FY18 FY2019 Line # 1 Solid Waste Revenue 4,598,434 4,559,832 4,863,097 4,879,010 5,155,448 2 3 Solid Waste Admin 2,726,980 1,577,036 1,701,212 1,637,669 2,069,668 4 Waste Collection 691,329 1,141,867 734,400 849,826 1,324,340 5 Landfill 1,322,614 1,261,253 1,161,034 1,134,952 1,124,030 6 Recycling 1,416,679 1,368,499 860,449 861,490 894,338 7 Total Solid Waste Expenses 6,157,602 5,348,654 4,457,096 4,483,937 5,412,376 8 9 Revenues over Expenses (1,559,169) (788,822) 406,001 395,073 (256,928) #4 FY19 includes a new collection truck ($280k) #6 FY15 & FY16 figures include startup costs for curbside recycling program ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 SRF Landfill Cell 9 106,119 - - - - 2 Landfill - Public 1,225,656 1,049,862 1,014,936 959,643 1,158,716 3 Sanitation 2,950,378 2,971,531 3,237,333 3,346,332 3,379,921 4 Interest 6,326 5,488 9,369 29,305 33,476 5 Appreciation/Depreciation 55 (123) (450) (353) - 6 Recycling Commodity Sales 129,935 132,942 204,891 171,949 185,000 9 Recycling other - Landfill 145,980 75,865 100,750 75,139 108,500 10 Recycling Center Fees - 6,998 12,017 2,681 - 11 Curbside Recycling Fees - 201,322 247,258 249,646 248,895 12 Recycling Container Rent 28,224 28,834 34,093 36,283 35,000 13 Other Miscellaneous 5,760 9,564 2,495 6,369 5,940 14 Sale of Fixed Assets 77,550 405 2,017 - 15 16 Total Solid Waste Fund Revenue 4,598,434 4,559,832 4,863,097 4,879,010 5,155,448 #2 Includes proposed 3.5% tipping fee rate increase, effective July 1, 2018 #3 Includes proposed 2.5% residential and commercial rate increase, effective July 1, 2018 #4 Projection based on greater interest earned through new bank #9 Metal recycling and compost mulch CITY OF SHERIDAN Fiscal Year 2019 Budget Solid Waste Revenue ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 144,273 144,206 173,320 133,794 140,800 2 Overtime 1,951 1,785 795 640 1,200 3 Payroll Taxes 9,867 10,334 12,081 9,864 10,800 4 Retirement 12,472 13,998 16,187 13,195 14,300 5 Unemployment and Worker's comp 3,215 2,683 5,744 3,496 4,000 6 Employee Insurance 33,290 35,547 38,410 34,830 35,700 7 Landfill Closure/Postclosure Fund - - - - - 8 Telephone & Internet 1,017 1,050 1,246 1,068 1,200 9 Copier & Printer Costs 1,428 5,322 5,677 4,634 5,000 10 Computer Hardware 80 540 40 814 250 11 Software Expense 2,880 2,953 2,909 1,214 1,890 12 Office Supplies 775 611 573 683 600 13 Professional Services 150,393 15,454 31,631 - 58,000 14 Insurance Liability - 1,320 15 Insurance - Claims - 3,471 5,597 1,000 7,000 16 Travel, Training & Memberships 893 945 2,814 2,566 4,400 17 Publications Advertising and Printing 46,606 33,429 24,760 16,472 15,000 18 Total Solid Waste Admin Operations 409,139 272,328 321,784 224,270 301,460 19 21 Capital Outlay - Infrastructure 53,205 - - - - 24 Capital Outlay - Improvements 49,922 - - - - 25 Capital Outlay - Improvements 133,930 - - - - 29 Capital Outlay - Improvements 19,250 - - - - 30 Capital Outlay - Improvements - - - - 125,000 31 Total Solid Waste Admin Capital 256,306 - - - 125,000 32 33 Debt Service Principal - Grinder/Excavator US Bank 121,763 123,952 126,182 87,236 88,797 34 Debt Service Principal - CWSRF-086 268,379 276,089 282,385 289,283 296,296 35 Debt Service Principal - CWSRF 083 69,368 71,285 71,216 72,951 74,484 36 Debt Service Principal - Caterpillar 627G Scraper 358,181 - - - - 37 Debt Service Principal - tax exempt lease 133,768 - - - - 40 Debt Service Principal - Cat 930K Loader 21,185 21,757 22,344 22,947 47,809 41 Debt Service Principal - CAT Leases 94,198 96,742 99,354 102,036 148,129 42 Debt Service Principal - CWSRF Loans 178,903 183,001 188,887 191,173 196,359 43 Debt Service Interest - Grinder/Excavator US Bank 9,251 7,061 4,832 2,748 1,188 44 Debt Service Interest - CWSRF 086 35,223 27,513 21,216 14,319 7,306 45 Debt Service Interest - CWSRF 083 6,953 5,036 5,105 3,370 1,837 46 Debt Service Interest - tax exempt 5,338 - - - - 49 Debt Service Interest - Cat 930K Loader 4,976 4,404 3,817 3,213 14,400 50 Debt Service Interest - CAT Leases 16,676 14,132 11,520 8,838 29,505 51 Debt Service Interest - CWSRF Loans 33,374 28,455 22,570 20,284 15,098 52 Total Solid Waste Admin Debt 1,357,535 859,428 859,428 818,399 921,208 53 54 Transfer to General Fund 268,000 409,280 484,000 559,000 722,000 55 Transfer to Special Revenue Fund 400,000 - - - - 56 Transfer to Water Fund 36,000 36,000 36,000 36,000 - 57 Total Solid Waste Admin Transfer 704,000 445,280 520,000 595,000 722,000 58 59 Total Solid Waste Admin 2,726,980 1,577,036 1,701,212 1,637,669 2,069,668 CITY OF SHERIDAN Fiscal Year 2019 Budget Solid Waste Administration ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Solid Waste Administration #9 Owned a copier in FY15, lease copier since FY16 #11 Adobe $90; MS Office $800; ESRI $1000 #13 Financial Plan Update and rate study SW Enterprise #14 FY19 - New allocation formula for insurance #15 Deductible ($5K) for one insurance claim and $2,000 for any small claims #16 Increase for Charles and Shawn - $2000 for SWANA Manager of Landfill Operations Re-certifications #16 Staff SWANA recerts for 40 hr hazwopper #30 Expense budget for cost share of landfill remediation program corrective measure #40 Addition of CAT 930K Loader Lease Principal and Interest 1st year payment #41 Addition of CAT Dozer Lease principal and interest 1st year payment #49 Addition of CAT 930K Loader Lease Principal and Interest 1st year payment #50 Addition of CAT Dozer Lease principal and interest 1st year payment #54 Increase Transfers to GF to be 14% of revenue #56 Transfer no longer needed - covered by line #54 transfer Project Index #7 #4712 - Landfill Closure #21 #4551 - HHW Improvements #22 #4014 - Demo Cell Reserve #23 #4702 - Service Center #24 #4712 - Landfill Closure #25 #4714 - Landfill Cell 9 #26 #4734 - C&D Cell #27 #4735 - HHW/Recycling #28 #4737 - Landfill Cell 10 #29 #4738 - Landfill AgBag System #30 #4739 - Landfill Remediation & Investigation #55 #4702 - Service Center ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 312,027 316,958 333,102 358,293 358,600 2 Part-time/Seasonal Wages 5,305 20,381 27,657 49,835 - 3 Overtime 13,450 20,789 10,493 11,928 12,000 4 Payroll Taxes 23,754 26,031 27,228 30,706 27,500 5 Retirement 28,669 32,251 33,517 34,003 36,300 6 Unemployment and Worker's comp 7,459 6,551 12,894 10,559 10,000 7 Employee Insurance 42,702 53,253 73,065 82,329 77,500 8 Other Employee Expenses 230 376 20 460 - 10 Outside Services 19,557 20,918 2,320 11,148 - 12 Utilities - 684 575 13 Repairs & Maint. - Buildings/grounds - 2,748 2,403 2,500 14 Telephone & Internet 128 746 1,409 1,489 1,200 15 Building Rent 5,831 - - - - 16 Repairs & Maint. Vehicles/Equip. 114,203 107,275 89,528 117,890 107,133 17 Repairs & Maint. - Other 1,655 95 - - - 18 Copier & Printer Costs 473 413 843 647 600 19 Equipment Non-capitalized 13,230 4,405 15,622 16,555 29,870 20 Equipment Non-capitalized - 11,225 - - - 21 Computer Hardware - 99 35 375 22 Software Expense - 5,422 3,563 6,300 23 Supplies 4,053 6,673 6,791 5,032 6,000 24 Office Supplies 241 151 221 241 350 25 Uniform Supplies 2,087 986 2,608 7,367 5,950 26 Gasoline Oil Diesel Supplies 74,187 51,758 58,846 73,166 65,000 27 Professional Services 1,188 5,434 16,047 18,491 34,565 28 Insurance Vehicle 8,415 9,663 11,154 11,044 3,380 29 Insurance Liability 199 209 251 219 3,360 30 Travel, Training & Memberships 636 234 664 678 1,200 31 Job Recruitment Costs - 405 543 450 32 Uncollectible Accounts 135 1,112 1,447 518 1,000 33 Total Waste Collection Operations 679,815 697,889 734,400 849,826 791,708 34 35 Capital Outlay - Machinery and Equip. 11,514 443,978 - - 532,632 37 Total Waste Collection Capital 11,514 443,978 - - 532,632 38 39 Total Waste Collection 691,329 1,141,867 734,400 849,826 1,324,340 #1 Requesting one PT (32 hr) benefited position to be converted to one FTE position #2 Requesting two (32 hr) part time positions be coverted to full time and move one to recycling #2 (Est. $39.7K increase to salaries and wages within each budget, and $0 budget needed for line #2 in FY19) #10 Combined with professional services in line #27 #12 FY18 first year allocating utility costs for recycling center and UM service center to Waste Collection #15 Building rent for vehicle storage - not needed after FY16 due to UM service center providing storage #19 Lower costs on 90 gal. and 300 gal container replacements in FY 18. Project up again in FY19 #21 Time Clock (1/2 paid for by Recycling) #22 Zonar $5500; MS Office $800.00 #27 Tree trimming $15k; Alley snow removal $10k; Towing $1500; Postage $200, credit card $10k, and rug services $2k, Misc $4k #28 FY19 - New allocation formula for insurance #29 FY19 - New allocation formula for insurance #35 New collection truck - fleet replacement plan. FY 18 expense truck ordered, not yet received. CITY OF SHERIDAN Fiscal Year 2019 Budget Waste Collection ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 311,929 308,116 313,982 324,355 325,400 2 Part-time/Seasonal Wages 41,161 50,359 57,695 52,992 54,100 3 Overtime 20,864 20,284 16,356 20,936 17,500 4 Payroll Taxes 26,941 27,374 26,691 28,242 29,100 5 Retirement 31,146 32,686 32,949 34,334 35,000 6 Unemployment and Worker's comp 8,530 7,164 14,598 9,872 10,600 7 Employee Insurance 84,038 105,107 114,526 99,725 103,600 8 Other Employee Expenses 995 975 523 185 500 9 Temporary Services Labor 4,752 6,128 4,500 11 Outside Services 304,548 56,125 24,568 18,830 - 13 Utilities 9,266 8,808 9,742 10,413 8,843 14 Repairs & Maint. - Buildings/grounds 55,026 6,367 4,795 4,500 15 Insurance Property 1,928 2,344 2,638 2,811 920 16 Telephone & Internet 4,056 4,627 4,415 4,777 3,774 17 Repairs & Maint. Vehicles/Equip. 89,452 95,955 82,035 141,308 125,000 18 Repairs & Maint. - Other 10,234 5,323 995 80 - 19 Copier & Printer Costs 2,027 1,407 1,467 1,615 2,244 21 Equipment Non-capitalized 6,954 15,330 19,117 8,474 8,500 22 Computer Hardware 130 - 200 1,015 3,000 23 Software Expense 22,188 2,200 2,409 2,260 2,989 24 Supplies 58,030 18,469 13,483 22,290 27,610 25 Office Supplies 1,448 3,995 2,883 4,009 3,800 26 Uniform Supplies 3,313 3,871 4,680 5,584 4,350 27 Gasoline Oil Diesel Supplies 110,712 67,196 79,896 96,072 81,000 28 Professional Services 160 338,883 301,692 212,744 257,000 29 Insurance Vehicle 1,226 1,491 1,678 1,788 4,050 30 Insurance Liability 105 100 116 117 3,550 31 DEQ reclamation premium - - - - - 32 Travel, Training & Memberships 4,485 2,675 4,152 3,216 2,000 33 Job Recruitment Costs - 402 1,230 600 34 Total Landfill Operations 1,155,864 1,235,890 1,145,008 1,120,196 1,124,030 35 38 Capital Outlay - Machinery and Equip. 166,750 25,363 16,026 14,756 - 39 Total Landfill Capital 166,750 25,363 16,026 14,756 - 40 41 Total Landfill 1,322,614 1,261,253 1,161,034 1,134,952 1,124,030 #9 Temporary labor when we have staff roll-over and need added support for Landfill litter clean-up to comply with permit #9 FY 18 budget for temp labor in line #11 #11 Combined budget with line #28 Professional Services #14 FY 18 budgeted expenses in error. FY 19 projections for unanticipated $1,500 & litter fence repair $3K #15 FY19 - New allocation formula for insurance #17 FY 18 - $28K in non-typical repairs to compost screen. Upward trend anticpated in FY 19 but less than FY18 levels. #18 All historical expenses now moved to #14 and #17. Lantech gas monitor calibration spent in FY18. #18 No longer needed in FY19 and beyond. #21 Tools, compost probes ($1.5K), AED ($2k), Freon extraction pumps ($2k), weather station ($500) #22 Computer Replacements: 2 Scale House; 1 HHW; 1 Timeclock #23 Carolina Software $2200.00; Monnit $389.00; MS Office $400.00 #24 HHW drums $8.7k, Ag Bags $12k, Janitorial supplies $2.2k, Methane testing supplies, lithium batter disposal boxes $2k #26 Reduce by $600 - heavy coats not needed in FY 19 #27 Projections for use of gas/diesel plus expected 10% increase #28 Ground water monitoring and reporting contract ($170K), lifetime permit design ($50K), credit card fees ($10K), #28 $50K HHW disposal, tire recycling ($8K), oil disposal, compost testing ($7K), rug service, Misc. Consulting ($10K) #29 FY19 - New allocation formula for insurance #30 FY19 - New allocation formula for insurance #31 Payment into WDEQ State Closure/Post Closure Insurance Fund - no payments expected #32 Lowered due to Charles and Shawn SWANA training covered under admin budget CITY OF SHERIDAN Fiscal Year 2019 Budget Landfill ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Salaries and Wages 262,408 364,144 349,382 327,538 365,000 2 Part-time/Seasonal Wages 45,272 36,466 59,577 3,576 - 3 Overtime 12,380 32,350 17,757 19,106 16,900 4 Payroll Taxes 22,767 30,518 29,847 25,445 28,000 5 Retirement 23,867 37,124 33,789 33,816 37,000 6 Unemployment and Worker's comp 7,169 7,833 14,418 9,009 10,200 7 Employee Insurance 51,424 97,652 90,311 87,433 101,300 8 Other Employee Expenses 185 339 128 251 200 9 Temporary Services Labor 61,555 144,480 125,000 11 Outside Services 11,206 12,233 7,263 16,188 - 12 Outside Services 2,803 140,097 - - - 13 Utilities 2,130 10,601 11,326 12,188 10,823 15 Repairs & Maint. - Buildings/grounds 2,684 - 4,953 38,144 5,500 16 Telephone & Internet 1,213 1,416 1,341 1,421 1,350 17 Building Rent 5,831 - - - - 18 Repairs & Maint. Vehicles/Equip. 42,542 44,932 40,149 48,814 43,450 20 Copier & Printer Costs 588 333 843 652 700 21 Equipment Non-capitalized 4,004 14,614 3,760 2,415 2,850 22 Equipment Non-capitalized 334,494 81,940 - - - 23 Computer Hardware 753 397 20 39 - 24 Software Expense - - 12,497 10,793 7,900 25 Supplies 14,664 14,996 13,134 9,379 11,500 26 Office Supplies 229 502 233 282 250 27 Uniform Supplies 3,586 2,557 3,631 7,713 6,000 28 Gasoline Oil Diesel Supplies 31,021 29,728 36,609 41,414 36,000 29 Gasoline Oil Diesel Supplies - - - - - 30 Professional Services 1,041 5,018 35,670 19,514 21,565 31 Insurance Vehicle 395 481 541 576 1,980 32 Insurance Liability - 3,420 33 Travel, Training & Memberships 2,260 4,784 595 820 1,100 34 Job Recruitment Costs - 445 350 35 Publications Advertising and Printing 236 250 25 - - 36 Uncollectible Accounts 111 39 - 37 Total Recycling Operations 887,152 971,303 829,464 861,490 838,338 38 39 Capital Outlay - Improvements - - - - 56,000 40 Capital Outlay - Improvements 213,259 26,164 - - - 41 Capital Outlay - Machinery and Equip. 34,194 22,464 30,985 - - 42 Capital Outlay - Machinery and Equip 282,074 348,568 - - - 43 Total Recycling Capital 529,526 397,196 30,985 - 56,000 44 45 Total Recycling 1,416,679 1,368,499 860,449 861,490 894,338 #1 Requesting one full time position, by converting one part-time (32hr) position in sanitation to full time in recycling; Est $39.7k increase #2 FY18 Part-time position not expensed from recycling budget #9 Temp labor for sorting line operations (4 full time temps) #11 Combined expenses with line #30 #12 Budget # for curbside recycling only - FY 15 and FY 16 expenses were for temporary labor - budget # no longer needed. #15 FY18 - expenses increased for Brundage Lane Drop site ($30K). FY19 - 2 garage doors at recycling center #22 Budget # established for Curbside Recycling only - FY 15 and FY 16 expenses for container purchases - budget # no longer needed #25 Baler wire ($8K), bale tags, hand tools, cleaning supplies ($2.5K) #28 Expected increase for FY 2019 #30 Tree trimming $15k; Alley Snow removal $10k; Glass hauling $7.2k; Towing $1.5k; Rug Service $1.3k (expenses combined w/line#11) #31 FY19 - New allocation formula for insurance #32 FY19 - New allocation formula for insurance #33 SWANA; WARM; HAZWOPER;WSWRA training #39 Paving for Brundage Lane drop site CITY OF SHERIDAN Fiscal Year 2019 Budget Recycling ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 CITY OF SHERIDAN Fiscal Year 2019 Budget Recycling Project Index #12 #4550 - Curbside Recycling #14 #4550 - Curbside Recycling #22 #4550 - Curbside Recycling #29 #4550 - Curbside Recycling #40 #4550 - Curbside Recycling #42 #4550 - Curbside Recycling Page 61 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 WY Dept of Agriculture - Emergency Insect Mgmt Gra - - - - 6,000 1 Weed & Pest Control Tax 130,162 139,339 154,829 152,865 160,000 2 Mosquito Control 18,958 19,140 19,227 19,421 19,250 3 Interest - - - - - 4 Total Weed & Pest Fund Revenue 149,120 158,480 174,056 172,286 185,250 5 6 Salaries and Wages 12,862 61,831 46,789 38,800 7 Part-time/Seasonal Wages 6,397 17,763 10,802 22,900 8 Overtime 2,515 356 1,050 - 9 Payroll Taxes 1,450 5,479 4,423 4,800 10 Retirement 1,124 5,749 4,460 4,000 11 Unemployment and Worker's comp 312 2,620 1,415 1,800 12 Employee Insurance 3,957 20,477 15,610 14,800 13 Contractual Services 130,162 64,059 - - - 14 Utilities 930 1,195 1,301 1,200 15 Repairs & Maint. - Buildings/grounds - 468 - 16 Insurance Property - - - 110 17 Telephone & Internet 620 1,880 1,929 1,800 18 Repairs & Maint. Vehicles/Equip. 2,092 4,661 4,589 2,250 19 Repairs & Maint. - Other 1,278 - - - 20 Equipment Non-Capitalized - 1,760 3,068 2,000 21 Supplies 26,654 27,065 1,806 2,500 22 Office Supplies - 136 197 600 23 Gasoline Oil Diesel Supplies 433 1,396 1,459 2,000 24 Chemical and Material Supplies - 23,098 25,000 Chemical and Material Supplies - - - - 6,000 25 Professional Services 37 860 894 1,000 26 Insurance Vehicle 161 196 221 235 20 27 Insurance Liability - 370 28 Travel, Training & Memberships 169 554 893 1,000 29 Publications Advertising and Printing 2,352 5,124 3,922 1,500 30 Uncollectible Accounts 1 1 0 1 - 31 Capital Outlay - Improvements 34,066 - - - 32 Capital Outlay - Machinery and Equip. 61,819 - - - 33 Transfer to General Fund - 18,400 35,850 34 Transfer to Water Fund 3,600 3,600 3,600 3,600 - 35 Total Weed & Pest Fund Expenses 133,924 226,923 162,726 150,409 170,300 #16 FY19 - New allocation formula for insurance #21 Moved Chemicals to line #24 in FY18 #24 Chemicals were included in line #21 in FY16 & FY17 #26 FY19 - New allocation formula for insurance #27 FY19 - New allocation formula for insurance #31 Holly Ponds Floating Island & mobile spray logger #32 Used Dodge Ram Truck, ATV side by side with spray equipment #34 FY19 Customer Service moved to General Fund so this Admin Fee allocation is no longer needed CITY OF SHERIDAN Fiscal Year 2019 Budget Weed & Pest Page 63 ACTUAL ACTUAL ACTUAL ACTUAL Budget Line #ACCOUNT DESCRIPTION FY15 FY16 FY17 FY18 FY2019 1 Driving Range 16,043 16,446 16,318 17,588 16,000 2 Golf Cart Rent 63,378 65,504 54,165 57,563 60,000 3 Golf Course Fees 245,564 255,899 238,340 234,202 246,000 4 Other charges 667 890 3,086 1,329 - 5 Interest 2,833 - - - - 6 Golf Cart Barn Rent 4,425 2,825 2,360 1,747 3,200 7 Rents 1,500 - 500 500 500 9 Sale of Fixed Assets - 68,625 - 10 Transfer from General Fund 665,715 134,000 109,700 141,400 80,000 11 Transfer from 1 Cent 30,000 - - - - 12 Transfer from Special Revenue 100,000 - - - - 13 Transfer from Supplemental - 50,000 100,000 100,000 100,000 14 Total Golf Fund Revenue 1,130,125 525,564 524,469 622,954 505,700 15 16 Contractual Services 340,250 364,515 378,505 388,033 393,600 17 Utilities 21,217 18,632 16,942 19,112 20,000 18 Repairs & Maint. - Buildings/grounds - 3,021 2,605 10,000 19 Insurance Property 500 608 684 729 1,410 20 Telephone & Internet 2,076 2,275 1,930 2,507 2,890 21 Repairs & Maint. - Other 10,529 562 - - - 22 Supplies - 16,890 16,281 7,400 23 Gasoline Oil Diesel Supplies 3,314 16,404 15,045 5,200 24 Professional Services 3,663 15,430 21,959 23,963 15,200 25 Insurance Vehicle 451 527 604 612 600 26 Insurance Liability 506 531 638 559 - 27 Publications Advertising and Printing 30 30 64 87 2,000 28 Miscellaneous 1,546 1,546 1,546 (6,184) 1,600 29 Capital Outlay - Improvements - 78,180 27,259 67,200 10,000 30 Capital Outlay - Machinery and Equip. - 1,785 - - 7,500 31 Debt Service Principal 725,000 - - - - 33 Debt Service Principal 22,417 22,890 23,373 90,492 26,200 34 Debt Service Interest 69,705 - - - - 36 Debt Service Interest 3,349 2,876 2,393 1,900 2,100 37 Transfer to General Fund 11,800 12,000 12,200 - - 38 Total Golf Fund Expenses 1,213,041 525,703 524,413 622,940 505,700 39 41 General Fund 42 Transfer to Golf 665,715 134,000 109,700 141,400 80,000 43 Total General Fund 665,715 134,000 109,700 141,400 80,000 44 45 One Cent Fund 46 Transfer to Golf 30,000 - - - - 47 Total One Cent Fund 30,000 - - - - 48 49 Special Revenue Fund - Direct Distribution 50 Transfer to Golf Course 100,000 50,000 100,000 100,000 100,000 51 Total Special Rev Fund - Direct Distribution 100,000 50,000 100,000 100,000 100,000 #16 Professional contract, proshop, restaurant #18 FY19 includes $7k repair of roof and $3k shop heater #19 FY19 - New allocation formula for insurance #21 Irrigation pump repair, and ground care chemicals; accounted for in supplies now #22 Fertilizer, insecticide, chemical weed spray, other ground care chemicals #24 Turf consultant #25 FY19 - New allocation formula for insurance #26 FY19 - New allocation formula for insurance #28 FY19 refund of previous years sales tax payments ($7,730) on golf cart lease #29 FY18 Replace golf tee boxes; FY19 $10k for cart path paving #30 FY19 $7.5k new mower CITY OF SHERIDAN Fiscal Year 2019 Budget Golf Course