Loading...
HomeMy WebLinkAboutFY 2018 Proposed Line Item BudgetCOUNTY and COUNTY SERVICE DISTRICT BUDGETS TABLE OF CONTENTS Fund Page Summary-Resources and Requirements .................................................... 001 General Fund 00 Revenue – Non-Departmental .............................................. 1 02 Assessor ............................................................................... 3 05 Clerk/Elections ..................................................................... 9 06 Board of Property Tax Appeals (BOPTA) ........................ .15 11 District Attorney ................................................................. 19 12 Medical Examiner .............................................................. 27 18 Finance/Tax ........................................................................ 29 23 Veterans’ Services .............................................................. 35 25 Property Management Administration ............................... 39 45 Non-Departmental Appropriations ..................................... 43 Special Revenue Funds 105 Economic Development ............................................................. 47 111 Court Technology Reserve. ........................................................ 49 114 Assessment/Tax/Clerk Reserve .................................................. 51 123 Justice Court ............................................................................... 53 125 Industrial Lands Proceeds .......................................................... 57 129 Humane Society of Redmond ..................................................... 59 130 Park Acquisition and Development ............................................ 61 132 Park Development Fees .............................................................. 63 135 PERS Reserve ............................................................................ 65 140 Project Development and Debt Reserve ..................................... 67 142 General County Projects ............................................................. 70 143 General Capital Reserve ............................................................. 73 145 County School ............................................................................ 75 150 Special Transportation ................................................................ 77 155 Taylor Grazing ........................................................................... 79 160 Transient Room Tax ................................................................... 81 165 Video Lottery ............................................................................. 84 170 Transient Room Tax-1% ............................................................ 86 205 Foreclosed Land Sales ................................................................ 82 Fund Page 212 Victims’ Assistance Program ..................................................... 91 215 Law Library ............................................................................... .95 218 County Clerk Records ................................................................. 98 230 Community Justice – Juvenile .................................................. 101 240 Court Facilities .......................................................................... 117 245 Deschutes County Communication System .............................. 119 255 Deschutes County Sheriff’s Office ........................................... 121 256 Communications System Reserve ............................................. 190 261 Public Health Reserve ............................................................... 193 270 Oregon Health Plan – Mental Health Services.......................... 195 274 Health Services ......................................................................... 197 276 Acute Care Services .................................................................. 209 280 Oregon Health Plan – Alcohol/Drug Services .......................... 211 290 Code Abatement ........................................................................ 213 295 Community Development ......................................................... 215 296 CDD-Groundwater Partnership ................................................. 225 297 Newberry Neighborhood ........................................................... 227 300 Community Development Reserve ........................................... 229 301 CDD Building Program Reserve ............................................... 231 302 CDD Electrical Program Reserve ............................................. 233 303 CDD Building Improvement Reserve ....................................... 235 305 GIS Dedicated ........................................................................... 237 325 Road .......................................................................................... 241 326 Natural Resource Protection ..................................................... 261 327 Federal Forest Title III .............................................................. 265 328 Surveyor .................................................................................... 251 329 Public Land Corner Preservation .............................................. 253 330 Road Building and Equipment .................................................. 255 336 Countywide Transportation SDC Improvement Fee ................. 257 340 Vehicle Maintenance and Replacement .................................... 259 350 Dog Control .............................................................................. 267 355 Adult Parole and Probation ....................................................... 109 Fund Page Capital Project Funds 462 North County Services Building .............................................. 270 463 Campus Improvement .............................................................. 272 465 Road CIP .................................................................................. 274 Debt Service Funds 530 CDD Building FF&C Ref Series 2004 ..................................... 276 535 Full Faith & Credit 2003/Ref 2012, Multiple County Bldgs .... 278 536 Full Faith & Credit 2005, Courthouse Remodel/Land ............. 280 538 Full Faith & Credit 2008, New OSP/911 Building .................. 282 539 Full Faith & Credit 2009A, Jamison Property .......................... 284 540 HHS/BJCC FF&C Ref Series 2005 .......................................... 286 541 Full Faith & Credit 2010-Secure Treatment Facility (STF) ..... 288 556 Jail Project Debt Service .......................................................... 290 575 PERS Debt Service, Series 2002/2004 ..................................... 292 590 Fairgrounds Debt Service ......................................................... 294 Proprietary Funds Enterprise 601 RV Park .................................................................................... 315 610 Solid Waste .............................................................................. 297 611 Landfill Closure ........................................................................ 306 612 Landfill Postclosure .................................................................. 308 613 Solid Waste Capital Projects .................................................... 310 614 Solid Waste Equipment Reserve .............................................. 312 617 Fair and Expo Center Capital Reserve ..................................... 319 618 Fair and Expo Center ................................................................ 321 619 Deschutes County Fair ............................................................. 330 Internal Service Funds 620 Facilities ................................................................................... 337 625 Administrative Services ........................................................... 343 628 Board of County Commissioners (BOCC) ............................... 349 630 Finance ..................................................................................... 355 631 Finance Reserve……………………………………………….361 Fund Page 640 Legal Counsel ........................................................................... 363 650 Human Resources ..................................................................... 369 660 Information Technology (IT) .................................................... 375 661 IT Reserve Fund ........................................................................ 381 670 Insurance ................................................................................... 383 675 Health Benefits Fund ................................................................ 389 County Service Districts 701 Countywide Law Enforcement District #1 ............................... 399 702 Rural Law Enforcement District #2 .......................................... 401 703 Countywide Law Enforcement District #1-Capital Reserve ..... 405 704 Rural Law Enforcement District #2-Capital Reserve ............... 407 705 Deschutes County 9-1-1 Service District .................................. 409 707 Deschutes County 9-1-1 Communications ................................ 417 710 Deschutes County 9-1-1 CSD-Equipment Reserve .................. 422 720 Deschutes County Extension/4-H Service District ................... 424 721 Extension/4-H Service District Reserve Fund .......................... 429 Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital 113,103,103 10,000,000 226,443 121,500 860,630 85,000 - Property Tax - Current Year 27,777,324 26,944,000 ----- Property Tax - Prior Year 360,000 350,000 ----- Revenue (excl. prop. taxes)181,389,603 5,554,332 34,000 2,000 13,500 531,500 - Transfers In 35,879,046 127,322 -32,000 120,000 70,000 - Total Revenues 245,405,973 32,975,654 34,000 34,000 133,500 601,500 - Total Resources 358,509,076 42,975,654 260,443 155,500 994,130 686,500 - REQUIREMENTS Salaries 67,086,774 6,792,754 ---300,754 - Life & Long Term Disability 314,692 31,149 ---1,352 - Health & Dental Insurance 19,319,644 1,941,948 ---99,343 - FICA/Medicare 5,139,788 510,420 ---22,605 - PERS 14,661,342 1,248,217 ---58,983 - Unemployment Insurance 334,840 34,096 ---1,410 - Workers' Compensation 1,241,718 64,837 ---2,645 - Personnel Services 108,098,798 10,623,421 ---487,092 - Materials & Services 94,115,488 4,972,340 260,443 75,000 -142,392 - Debt Principal 3,945,161 ------ Debt Interest 2,333,212 ------ Total Debt Service 6,278,373 ------ Capital Outlay 14,715,535 10,000 -80,500 --- Transfers Out 35,879,046 18,369,893 ----- Total Exp. & Transfers 259,087,240 33,975,654 260,443 155,500 -629,484 - Contingency 66,035,038 9,000,000 ---57,016 - Unapprop Ending Fund Bal / Reserve for Future Expenditures 33,386,800 ---994,130 -- Total Requirements 358,509,078 42,975,654 260,443 155,500 994,130 686,500 - FTE Change 5.20 (1.00)----- FTE - FY 2018 939.75 94.75 ---4.60 - FTE - FY 2017 934.55 95.75 ---4.60 - FY 2017 Budget As Revised 344,084,018 41,876,158 261,867 194,000 858,500 690,608 47,000 Inc (Dec) from FY 2017 14,425,060 1,099,496 (1,424)(38,500)135,630 (4,108)(47,000) TOTAL General (001) Economic Development Fund (105) Court Tech Reserve (111) Aseesment/Tax/ Clerk Reserve (114) Justice Court (123) Industrial Lands Proceeds (125) Special Revenue FundsGeneral Fund Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 (481,878)215,000 93,000 13,262,000 900,000 1,085,871 7,280,000 -----833,324 - -----10,000 - 538,000 302,000 2,800 165,000 811,441 153,750 109,200 ---2,000,000 300,000 -4,047,854 538,000 302,000 2,800 2,165,000 1,111,441 997,074 4,157,054 56,122 517,000 95,800 15,427,000 2,011,441 2,082,945 11,437,054 ------- ------- ------- ------- ---1,200,000 --- ------- ------- ---1,200,000 --- -96,500 95,800 -85,000 1,191,521 - ------- ------- ------- -230,500 --485,297 255,000 1,000,000 56,122 190,000 --1,441,144 -- 56,122 517,000 95,800 1,200,000 2,011,441 1,446,521 1,000,000 -----636,424 - ---14,227,000 --10,437,054 56,122 517,000 95,800 15,427,000 2,011,441 2,082,945 11,437,054 ------- ------- ------- 53,122 372,800 94,800 13,225,000 2,936,757 2,601,210 7,252,813 3,000 144,200 1,000 2,202,000 (925,316)(518,265)4,184,241 General County Projects (142) Humane Society of Redmond (129) General Capital Reserve (143) Park Acquisition & Development (130) Park Development Fees (132) PERS Reserve (135) Project Dev & Debt Reserve (140) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 -4,000 40,000 407,000 159,362 405,292 10,000 ------- ------- 267,600 817,200 5,500 5,890,000 702,500 847,000 58,900 ------- 267,600 817,200 5,500 5,890,000 702,500 847,000 58,900 267,600 821,200 45,500 6,297,000 861,862 1,252,292 68,900 ------- ------- ------- ------- ------- ------- ------- ------- 267,600 821,200 45,500 2,109,040 861,862 1,006,314 58,999 ------- ------- ------- ------- ---3,177,531 -245,978 - 267,600 821,200 45,500 5,286,571 861,862 1,252,292 58,999 ------9,901 ---1,010,429 --- 267,600 821,200 45,500 6,297,000 861,862 1,252,292 68,900 ------- ------- ------- 267,410 1,095,684 39,830 5,663,000 823,000 1,020,000 60,500 190 (274,484)5,670 634,000 38,862 232,292 8,400 Video Lottery (165) Transient Room Tax-1% (170) Foreclosed Land Sales (205) County School (145) Special Transportation (150) Taylor Grazing (155) Transient Room Tax-7% (160) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 95,000 450,000 334,960 1,200,000 28,000 -- ------- ------- 294,787 159,421 125,700 682,536 148,464 38,181,469 50,500 295,648 --5,597,643 -3,151,787 - 590,435 159,421 125,700 6,280,179 148,464 41,333,256 50,500 685,435 609,421 460,660 7,480,179 176,464 41,333,256 50,500 336,712 --3,319,132 -20,623,517 - 1,447 --15,781 -89,167 - 119,212 177 -932,389 -4,772,479 - 25,146 --249,428 -1,532,111 - 57,971 --664,575 -4,560,392 - 2,115 --16,674 -81,076 - 1,202 --138,650 -625,974 - 543,805 177 -5,336,629 -32,284,716 - 48,633 206,727 138,729 1,198,996 176,464 7,608,175 - ------- ------- ------- -----1,168,101 - -71,200 -69,000 -272,266 - 592,438 278,104 138,729 6,604,625 176,464 41,333,258 - 92,997 331,317 321,931 875,554 --- ------50,500 685,435 609,421 460,660 7,480,179 176,464 41,333,258 50,500 -----3.00 - 6.00 --46.90 -230.50 - 6.00 --46.90 -227.50 - 679,520 588,991 442,230 7,362,143 165,535 46,311,947 818,342 5,915 20,430 18,430 118,036 10,929 (4,978,689)(767,842) Sheriff's Office (255) Victims' Assistance Program (212) Law Library (215) County Clerk Records (218) Communications System Reserve (256) Community Justice - Juvenile (230) Court Facilities (240) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 285,459 4,917,083 8,434,473 894,594 2,040,697 58,794 1,640,386 ------- ------- 3,200 50,000 33,592,026 442,013 24,000 1,000 7,338,533 --4,584,193 ---- 3,200 50,000 38,176,219 442,013 24,000 1,000 7,338,533 288,659 4,967,083 46,610,692 1,336,607 2,064,697 59,794 8,978,919 --17,350,822 ---3,192,216 --91,738 ---14,403 --6,053,126 ---918,560 --1,430,842 ---240,601 --3,319,885 ---588,938 --111,224 ---15,863 --168,325 ---33,896 --28,525,962 ---5,004,477 100 2,900,161 12,913,779 535,374 516,705 59,794 1,319,280 ------- ------- ------- --1,020,000 ---- --490,320 ---926,888 100 2,900,161 42,950,061 535,374 516,705 59,794 7,250,645 -2,066,922 3,660,631 801,233 1,547,992 -1,728,274 288,559 ------ 288,659 4,967,083 46,610,692 1,336,607 2,064,697 59,794 8,978,919 --3.20 ---- --303.05 ---45.00 --299.85 ---45.00 343,369 4,250,988 41,280,586 1,423,729 2,872,076 83,105 8,320,357 (54,710)716,095 5,330,106 (87,122)(807,379)(23,311)658,562 OHP- Mental Health Services (270) Acute Care Services (276) OHP- Alcohol/Drug Services (280) Code Abatement (290) Community Development (295) Public Health Dept Reserve (261) Health Services (274) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 26,630 61,840 2,056,811 1,002,474 -75,841 107,307 ------- ------- 100 1,000 17,000 5,600 -700 301,220 --462,131 254,387 97,092 10,000 - 100 1,000 479,131 259,987 97,092 10,700 301,220 26,730 62,840 2,535,942 1,262,461 97,092 86,541 408,527 ------177,395 ------823 ------45,698 ------13,408 ------32,809 ------811 ------3,065 ------274,009 26,730 ----75,000 55,012 ---- ---- ------- ------- -55,111 ----- 26,730 55,111 ---75,000 329,021 -7,729 ----79,506 --2,535,942 1,262,461 97,092 11,541 - 26,730 62,840 2,535,942 1,262,461 97,092 86,541 408,527 ------- ------2.30 ------2.30 109,050 209,154 2,039,995 995,773 -75,041 377,039 (82,320)(146,314)495,947 266,688 97,092 11,500 31,488 Community Development Reserve (300) CDD Electrical Reserve (302) CDD Bldg Improvement Reserve (303) CDD Building Pgm Reserve (301) CDD- Groundwater Partnership (296) GIS Dedicated (305) Newberry Neighborhood (297) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 8,684,589 574,466 270,461 160,574 654,626 1,065,917 2,736,442 ------- ------- 19,877,279 1,242,000 2,500 194,650 491,000 10,000 780,000 -35,000 ---2,000,000 - 19,877,279 1,277,000 2,500 194,650 491,000 2,010,000 780,000 28,561,868 1,851,466 272,961 355,224 1,145,626 3,075,917 3,516,442 3,833,954 119,079 ----- 16,706 404 ----- 1,270,364 19,869 ----- 284,705 9,032 ----- 709,197 19,654 ----- 19,035 353 ----- 58,996 945 ----- 6,192,957 169,336 ----- 13,715,873 1,064,223 120,000 165,000 420,000 47,105 - ------- ------- ------- 228,000 ----1,231,000 - 6,000,000 37,400 ----1,275,400 26,136,830 1,270,959 120,000 165,000 420,000 1,278,105 1,275,400 2,425,038 580,507 152,961 190,224 725,626 1,797,812 2,241,042 ------- 28,561,868 1,851,466 272,961 355,224 1,145,626 3,075,917 3,516,442 ------- 54.00 1.00 ----- 54.00 1.00 ----- 30,124,340 1,662,239 316,538 321,690 1,054,882 2,313,435 2,180,426 (1,562,472)189,227 (43,577)33,534 90,744 762,482 1,336,016 Countywide Trans SDC Imprvmt Fee (336) Public Land Corner Preservation (329) Road Building & Equipment (330) Federal Forest Title III (327) Surveyor (328) Road (325) Natural Resource Protection (326) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 996,280 115,901 1,375,000 6,255,424 60,000 -113,000 ------- ------- 25,000 301,200 5,421,974 125,000 758,246 -754,519 528,070 73,718 451,189 5,275,400 694,797 234,158 - 553,070 374,918 5,873,163 5,400,400 1,453,043 234,158 754,519 1,549,350 490,819 7,248,163 11,655,824 1,513,043 234,158 867,519 --2,759,289 ---- --13,297 ---- --818,592 ---- --207,031 ---- --627,926 ---- --13,994 ---- --35,693 ---- --4,475,822 ---- 175,000 446,523 1,843,865 35,701 400 -400 ----943,863 201,809 485,000 ----508,780 32,349 283,549 ----1,452,643 234,158 768,549 700,000 --3,360,000 --- --44,000 ---- 875,000 446,523 6,363,687 3,395,701 1,453,043 234,158 768,949 -44,296 884,476 8,260,123 --- 674,350 ---60,000 -98,570 1,549,350 490,819 7,248,163 11,655,824 1,513,043 234,158 867,519 ------- --39.45 ---- --39.45 ---- 1,355,226 579,668 7,064,486 9,085,143 1,507,752 235,188 905,642 194,124 (88,849)183,677 2,570,681 5,291 (1,030)(38,123) Dog Control (350) Adult Parole & Probation (355) FF & C, 2008 OSP/9-1-1 Building (538) Road CIP (465) Capital Proj Funds Vehicle Maintenance & Replacement (340) FF & C, 2003/ Ref 2012 Multiple Bldgs (535) FF&C, 2005/ Ref 2015 Remodel/Land (536) Special Revenue Funds Debt Service Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 --300,000 -60,000 -225,000 ------- ------- --126,833 -1,173,538 -407,198 249,582 567,300 -544,532 --160,000 249,582 567,300 126,833 544,532 1,173,538 -567,198 249,582 567,300 426,833 544,532 1,233,538 -792,198 ------- ------- ------- ------- ------- ------- ------- ------- 400 500 400 400 --317,508 160,000 545,000 60,000 240,000 377,660 -190,587 89,182 21,800 34,309 304,132 805,878 -31,549 249,182 566,800 94,309 544,132 1,183,538 -222,136 ------- ------- 249,582 567,300 94,709 544,532 1,183,538 -539,644 ------252,554 --332,124 -50,000 -- 249,582 567,300 426,833 544,532 1,233,538 -792,198 ------- ------- ------- 250,084 572,175 403,951 546,582 1,183,216 2,633,925 787,320 (502)(4,875)22,882 (2,050)50,322 (2,633,925)4,878 PERS Series 2002/2004 Debt Service (575) Fairgrounds Debt Service (590) RV Park (601) FF & C, 2009A Jamison Property (539) FF&C, 2005 HHS/BJCC (540) Full Faith & Credit 2010-STF (541) Jail Project Debt Service (556) Debt Service Funds Enterprise Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 615,872 3,706,648 785,220 2,320,224 257,560 611,000 225,000 ------- ------- 10,657,799 20,000 9,000 20,000 900 14,000 2,097,570 -600,000 -1,600,000 350,000 351,430 685,825 10,657,799 620,000 9,000 1,620,000 350,900 365,430 2,783,395 11,273,671 4,326,648 794,220 3,940,224 608,460 976,430 3,008,395 1,357,365 -----747,751 6,289 -----3,284 447,044 -----216,067 101,725 -----55,661 262,866 -----151,087 7,978 -----3,834 32,682 -----14,054 2,215,949 -----1,191,738 4,909,217 566,500 1,000 315,068 9,316 -1,403,113 656,469 -----84,773 204,633 -----17,051 861,102 -----101,824 125,000 --3,100,000 340,000 976,430 15,000 2,580,000 -----105,452 10,691,268 566,500 1,000 3,415,068 349,316 976,430 2,817,127 582,403 3,760,148 -525,156 259,144 -191,268 --793,220 ---- 11,273,671 4,326,648 794,220 3,940,224 608,460 976,430 3,008,395 ------- 22.50 -----10.87 22.50 -----10.87 9,533,897 3,401,534 781,622 3,075,113 482,820 697,703 2,518,801 1,739,774 925,114 12,598 865,111 125,640 278,727 489,594 Landfill Postclosure (612) Solid Waste (610) Landfill Closure (611) Solid Waste Capital Projects (613) Solid Waste Equipment Reserve (614) Fair & Expo Ctr Capital Reserve (617) Fair & Expo Center (618) Enterprise Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 6,700 388,000 160,000 59,000 180,000 140,000 285,000 ------- ------- 1,538,344 3,387,720 1,257,469 409,753 1,890,982 263,000 955,754 --40,000 221,988 --- 1,538,344 3,387,720 1,297,469 631,741 1,890,982 263,000 955,754 1,545,044 3,775,720 1,457,469 690,741 2,070,982 403,000 1,240,754 96,702 1,464,805 708,746 277,102 879,183 -627,788 413 6,846 2,976 1,450 4,167 -2,506 22,357 536,453 134,113 59,606 206,965 -119,212 7,232 110,142 49,260 21,016 65,098 -44,732 21,826 274,929 140,038 44,641 190,847 -101,137 397 8,460 2,379 -3,526 -2,115 -22,063 4,987 4,785 5,380 -5,102 148,927 2,423,698 1,042,499 408,600 1,355,166 -902,592 966,036 1,030,545 248,931 216,876 572,291 203,293 146,611 ------- ------- ------- -----199,707 - 430,081 40,260 ----- 1,545,044 3,494,503 1,291,430 625,476 1,927,457 403,000 1,049,203 -281,217 166,039 65,265 143,525 -191,551 ------- 1,545,044 3,775,720 1,457,469 690,741 2,070,982 403,000 1,240,754 ------- 1.13 25.00 6.75 3.00 10.00 -6.00 1.13 25.00 6.75 3.00 10.00 -6.00 1,542,786 3,616,102 1,481,365 672,142 1,993,478 1,934,160 1,139,738 2,258 159,618 (23,896)18,599 77,504 (1,531,160)101,016 Finance Reserve (631) Finance (630) Board of County Commissioners (628) Administrative Services (625) Facilities (620) Deschutes County Fair (619) Legal (640) Enterprise Funds Internal Service Funds Summary - Resources and Requirements: All County Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital Property Tax - Current Year Property Tax - Prior Year Revenue (excl. prop. taxes) Transfers In Total Revenues Total Resources REQUIREMENTS Salaries Life & Long Term Disability Health & Dental Insurance FICA/Medicare PERS Unemployment Insurance Workers' Compensation Personnel Services Materials & Services Debt Principal Debt Interest Total Debt Service Capital Outlay Transfers Out Total Exp. & Transfers Contingency Unapprop Ending Fund Bal / Reserve for Future Expenditures Total Requirements FTE Change FTE - FY 2018 FTE - FY 2017 FY 2017 Budget As Revised Inc (Dec) from FY 2017 585,000 404,666 444,328 4,897,636 15,000,000 ----- ----- 991,331 2,336,521 240,000 3,371,531 22,011,500 -66,000 --- 991,331 2,402,521 240,000 3,371,531 22,011,500 1,576,331 2,807,187 684,328 8,269,167 37,011,500 541,492 1,359,272 -220,944 - 2,806 6,608 -1,080 - 178,818 342,679 -64,573 - 40,981 102,332 -16,280 - 91,547 252,850 -41,027 - 2,820 5,534 -1,146 - 4,628 11,657 -2,152 - 863,092 2,080,932 -347,202 - 334,598 511,134 29,500 2,390,699 22,038,292 ----- ----- ----- --191,000 -- ---1,000 - 1,197,690 2,592,066 220,500 2,738,901 22,038,292 378,641 215,121 -5,530,266 14,973,208 --463,828 -- 1,576,331 2,807,187 684,328 8,269,167 37,011,500 ----- 8.00 15.70 -3.25 - 8.00 15.70 -3.25 - 1,334,165 2,976,364 953,328 7,102,270 35,579,693 242,166 (169,177)(269,000)1,166,897 1,431,807 Health Benefit Fund (675) IT Reserve (661) Insurance (670) Information Technology (660) Human Resources (650) Internal Service Funds Summary - Resources and Requirements: County Service District Funds FY 2018 Proposed Budget RESOURCES Beginning Net Working Capital 21,631,000 5,073,000 6,040,000 6,600,000 3,200,000 185,000 533,000 Property Tax - Current Year 40,376,716 22,045,228 9,916,642 7,926,725 -488,121 - Property Tax - Prior Year 677,000 400,000 185,000 85,000 -7,000 - Revenue (excl. prop. taxes)1,897,568 80,000 61,300 1,702,119 40,000 11,649 2,500 Transfers In 1,819,863 --1,300,000 493,863 -26,000 Total Revenues 44,771,147 22,525,228 10,162,942 11,013,844 533,863 506,770 28,500 Total Resources 66,402,147 27,598,228 16,202,942 17,613,844 3,733,863 691,770 561,500 REQUIREMENTS Salaries 4,650,746 --4,650,746 --- Life & Long Term Disability 20,156 --20,156 --- Health & Dental Insurance 1,198,486 --1,198,486 --- FICA/Medicare 341,569 --341,569 --- PERS 836,393 --836,393 --- Unemployment Insurance 20,798 --20,798 --- Workers' Compensation 32,000 --32,000 --- Personnel Services 7,100,148 --7,100,148 --- Materials & Services 37,609,947 23,788,215 10,266,456 3,047,724 -507,552 - Debt Principal ------- Debt Interest ------- Total Debt Service ------- Capital Outlay 2,771,500 --2,210,000 --561,500 Transfers Out 1,819,863 --493,863 1,300,000 26,000 - Total Exp. & Transfers 49,301,458 23,788,215 10,266,456 12,851,735 1,300,000 533,552 561,500 Contingency 14,666,826 3,810,013 5,936,486 4,762,109 -158,218 - Unapprop Ending Fund Bal / Reserve for Future Expenditures 2,433,863 ---2,433,863 -- Total Requirements 66,402,147 27,598,228 16,202,942 17,613,844 3,733,863 691,770 561,500 FTE Change 1.00 --1.00 --- FTE - FY 2018 60.00 --60.00 --- FTE - FY 2017 59.00 --59.00 --- FY 2017 Budget As Revised 66,505,825 26,250,316 14,521,300 19,971,481 4,598,483 626,245 538,000 Inc (Dec) from FY 2017 (103,678)1,347,912 1,681,642 (2,357,637)(864,620)65,525 23,500 Extension/ 4-H CSD (720) Extension/ 4-H Reserve (721) Deschutes County 9-1-1 Service District (705/707) TOTAL Law Enforcement District - Countywide (701) Law Enforcement District - Rural (702) 9-1-1 CSD Eqp Reserve (710) Page 1 Page 2 Page 3 Page 4 Page 5 Page 6 Page 7 Page 8 Page 9 Page 10 Page 11 Page 12 Page 13 Page 14 Page 15 Page 16 Page 17 This page intentionally left blank. Page 18 Page 19 Page 20 Page 21 Page 22 Page 23 Page 24 Page 25 This page intentionally left blank. Page 26 Page 27 This page intentionally left blank. Page 28 Page 29 Page 30 Page 31 Page 32 Page 33 This page intentionally left blank. Page 34 Page 35 Page 36 Page 37 Page 38 Page 39 Page 40 Page 41 Page 42 Page 43 Page 44 Page 45 This page intentionally left blank. Page 46 Page 47 Page 48 Page 49 Page 50 Page 51 Page 52 Page 53 Page 54 Page 55 Page 56 Page 57 Page 58 Page 59 Page 60 Page 61 Page 62 Page 63 Page 64 Page 65 Page 66 Page 67 Page 68 Page 69 Page 70 Page 71 Page 72 Page 73 Page 74 Page 75 Page 76 Page 77 Page 78 Page 79 Page 80 Page 81 Page 82 Page 83 Page 84 Page 85 Page 86 Page 87 Page 88 Page 89 Page 90 Page 91 Page 92 Page 93 Page 94 Page 95 Page 96 Page 97 Page 98 Page 99 Page 100 Page 101 Page 102 Page 103 Page 104 Page 105 Page 106 Page 107 Page 108 Page 109 Page 110 Page 111 Page 112 Page 113 Page 114 Page 115 This page intentionally left blank. Page 116 Page 117 Page 118 Page 119 Page 120 Page 121 Page 122 Page 123 Page 124 Page 125 Page 126 Page 127 Page 128 Page 129 Page 130 Page 131 Page 132 Page 133 Page 134 Page 135 Page 136 Page 137 Page 138 Page 139 Page 140 Page 141 Page 142 Page 143 Page 144 Page 145 Page 146 Page 147 Page 148 Page 149 Page 150 Page 151 Page 152 Page 153 Page 154 Page 155 Page 156 Page 157 Page 158 Page 159 Page 160 Page 161 Page 162 Page 163 Page 164 Page 165 Page 166 Page 167 Page 168 Page 169 Page 170 Page 171 Page 172 Page 173 Page 174 Page 175 Page 176 Page 177 Page 178 Page 179 Page 180 Page 181 Page 182 Page 183 Page 184 Page 185 Page 186 Page 187 Page 188 Page 189 Page 190 Page 191 This page intentionally left blank. Page 192 Page 193 Page 194 Page 195 Page 196 Page 197 Page 198 Page 199 Page 200 Page 201 Page 202 Page 203 Page 204 Page 205 Page 206 Page 207 Page 208 Page 209 Page 210 Page 211 Page 212 Page 213 Page 214 Page 215 Page 216 Page 217 Page 218 Page 219 Page 220 Page 221 Page 222 Page 223 Page 224 Page 225 Page 226 Page 227 Page 228 Page 229 Page 230 Page 231 Page 232 Page 233 Page 234 Page 235 Page 236 Page 237 Page 238 Page 239 This page intentionally left blank. Page 240 Page 241 Page 242 Page 243 Page 244 Page 245 Page 246 Page 247 Page 248 Page 249 Page 250 Page 251 Page 252 Page 253 Page 254 Page 255 Page 256 Page 257 Page 258 Page 259 Page 260 Page 261 Page 262 Page 263 Page 264 Page 265 Page 266 Page 267 Page 268 Page 269 Page 270 Page 271 Page 272 Page 273 Page 274 Page 275 Page 276 Page 277 Page 278 Page 279 Page 280 Page 281 Page 282 Page 283 Page 284 Page 285 Page 286 Page 287 Page 288 Page 289 Page 290 Page 291 Page 292 Page 293 Page 294 Page 295 This page intentionally left blank. Page 296 Page 297 Page 298 Page 299 Page 300 Page 301 Page 302 Page 303 Page 304 Page 305 Page 306 Page 307 Page 308 Page 309 Page 310 Page 311 Page 312 Page 313 This page intentionally left blank. Page 314 Page 315 Page 316 Page 317 Page 318 Page 319 Page 320 Page 321 Page 322 Page 323 Page 324 Page 325 Page 326 Page 327 Page 328 Page 329 Page 330 Page 331 Page 332 Page 333 Page 334 Page 335 Page 336 Page 337 Page 338 Page 339 Page 340 Page 341 Page 342 Page 343 Page 344 Page 345 Page 346 Page 347 This page intentionally left blank. Page 348 Page 349 Page 350 Page 351 Page 352 Page 353 This page intentionally left blank. Page 354 Page 355 Page 356 Page 357 Page 358 Page 359 Page 360 Page 361 Page 362 Page 363 Page 364 Page 365 Page 366 Page 367 This page intentionally left blank. Page 368 Page 369 Page 370 Page 371 Page 372 Page 373 This page intentionally left blank. Page 374 Page 375 Page 376 Page 377 Page 378 Page 379 Page 380 Page 381 Page 382 Page 383 Page 384 Page 385 Page 386 Page 387 Page 388 Page 389 Page 390 Page 391 Page 392 Page 393 Page 394 Page 395 Page 396 Page 397 This page intentionally left blank. Page 398 Page 399 Page 400 Page 401 Page 402 Page 403 Page 404 Page 405 Page 406 Page 407 Page 408 Page 409 Page 410 Page 411 Page 412 Page 413 Page 414 Page 415 Page 416 Page 417 Page 418 Page 419 Page 420 Page 421 Page 422 Page 423 Page 424 Page 425 Page 426 Page 427 Page 428 Page 429 Page 430