Loading...
HomeMy WebLinkAboutFY 2018 Approved Line Item BudgetCOUNTY and COUNTY SERVICE DISTRICT BUDGETS TABLE OF CONTENTS Page Summary-Resources and Requirements .................................................... Fund 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 ................................................................. 18 12 Medical Examiner .............................................................. 25 18 Finance/Tax ........................................................................ 26 23 Veterans’ Services .............................................................. 30 25 Property Management Administration ............................... 34 45 Non-Departmental Appropriations ..................................... 38 Special Revenue Funds 105 Economic Development ............................................................. 41 111 Court Technology Reserve. ........................................................ 43 114 A and T Reserve ......................................................................... 45 123 Justice Court ............................................................................... 47 125 Industrial Lands Proceeds .......................................................... 51 129 Humane Society of Redmond ..................................................... 53 130 Park Acquisition and Development ............................................ 55 132 Park Development Fees .............................................................. 57 135 PERS Reserve ............................................................................ 59 140 Project Development and Debt Reserve ..................................... 61 142 General County Projects ............................................................. 64 143 General Capital Reserve ............................................................. 67 145 County School ............................................................................ 69 150 Special Transportation ................................................................ 71 155 Taylor Grazing ........................................................................... 73 160 Transient Room Tax ................................................................... 75 165 Video Lotter ............................................................................... 78 Fund Page 170 Transient Room Tax-1% ............................................................. 80 205 Foreclosed Land Sales ................................................................ 82 212 Victims’ Assistance Program ..................................................... 85 215 Law Library ................................................................................ 89 218 County Clerk Records ................................................................. 93 230 Community Justice – Juvenile .................................................... 96 240 Court Facilities .......................................................................... 104 245 Deschutes County Communication System .............................. 106 255 Deschutes County Sheriff’s Office ........................................... 110 256 Communications System Reserve ............................................. 179 260 HealthyStart Prenatal ................................................................ 180 261 Public Health Reserve ............................................................... 183 270 Oregon Health Plan – Mental Health Services.......................... 185 274 Health Services ......................................................................... 188 276 Acute Care Services .................................................................. 201 280 Oregon Health Plan – Alcohol/Drug Services .......................... 203 290 Code Abatement ........................................................................ 205 295 Community Development ......................................................... 207 296 CDD-Groundwater Partnership ................................................. 219 297 Newberry Neighborhood ........................................................... 221 300 Community Development Reserve ........................................... 223 301 CDD Building Program Reserve ............................................... 225 302 CDD Electrical Program Reserve ............................................. 227 303 CDD Building Improvement Reserve ....................................... 229 305 GIS Dedicated ........................................................................... 231 325 Road .......................................................................................... 235 326 Natural Resource Protection ..................................................... 245 327 Federal Forest Title III .............................................................. 249 328 Surveyor .................................................................................... 251 329 Public Land Corner Preservation .............................................. 253 330 Road Building and Equipment .................................................. 255 335 Road Improvement Reserve ...................................................... 257 336 Countywide Transportation SDC Improvement Fee ................. 259 Fund Page 340 Vehicle Maintenance and Replacement ................................... 261 350 Dog Control .............................................................................. 263 355 Adult Parole and Probation ...................................................... 266 Capital Project Funds 430 Local Improvement District ..................................................... 274 456 Jail Project ............................................................................... 276 462 North County Services Building .............................................. 280 463 Campus Improvement .............................................................. 282 464 Sisters Health Clinic ................................................................. 285 465 Road CIP .................................................................................. 287 Debt Service Funds 530 CDD Building FF&C Ref Series 2004 ..................................... 289 535 Full Faith & Credit 2003/Ref 2012, Multiple County Bldgs .... 291 536 Full Faith & Credit 2005, Courthouse Remodel/Land ............. 293 538 Full Faith & Credit 2008, New OSP/911 Building .................. 295 539 Full Faith & Credit 2009A, Jamison Property .......................... 297 540 HHS/BJCC FF&C Ref Series 2005 .......................................... 299 541 Full Faith & Credit 2010-Secure Treatment Facility (STF) ..... 301 556 Jail Project Debt Service .......................................................... 303 575 PERS Debt Service, Series 2002/2004 ..................................... 305 590 Fairgrounds Debt Service ......................................................... 307 Proprietary Funds Enterprise 601 RV Park .................................................................................... 309 610 Solid Waste .............................................................................. 313 611 Landfill Closure ........................................................................ 322 612 Landfill Postclosure .................................................................. 325 Fund Page 613 Solid Waste Capital Projects ..................................................... 327 614 Solid Waste Equipment Reserve ............................................... 329 617 Fair and Expo Center Capital Reserve ...................................... 331 618 Fair and Expo Center ................................................................ 333 619 Deschutes County Fair .............................................................. 342 Internal Service Funds 620 Building Services ...................................................................... 349 625 Administrative Services ............................................................ 355 628 Board of County Commissioners (BOCC) ............................... 360 630 Finance ...................................................................................... 364 631 Finance Reserve ........................................................................ 370 640 Legal Counsel ........................................................................... 372 650 Personnel ................................................................................... 377 660 Information Technology (IT) .................................................... 382 661 IT Reserve Fund ........................................................................ 388 670 Insurance ................................................................................... 390 675 Health Benefits Trust ................................................................ 396 County Service Districts 701 Countywide Law Enforcement District #1 ............................... 405 702 Rural Law Enforcement District #2 .......................................... 408 703 Countywide Law Enforcement District #1-Capital Reserve ..... 411 704 Rural Law Enforcement District #2-Capital Reserve ............... 413 705 Deschutes County 9-1-1 CSD ................................................... 415 707 Deschutes County 9-1-1 Communications ................................ 423 710 Deschutes County 9-1-1 CSD-Equipment Reserve .................. 428 720 Deschutes County Extension/4-H Service District ................... 430 721 Extension/4-H Service District Reserve Fund .......................... 435 Summary - Resources and Requirements: All County Funds FY 2018 Approved 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,129,324 26,296,000 ----- Property Tax - Prior Year 360,000 350,000 ----- Revenue (excl. prop. taxes)180,608,319 5,554,332 34,000 2,000 13,500 531,500 - Transfers In 34,968,400 127,322 -32,000 120,000 70,000 - Total Revenues 243,066,043 32,327,654 34,000 34,000 133,500 601,500 - Total Resources 356,169,146 42,327,654 260,443 155,500 994,130 686,500 - REQUIREMENTS Salaries 67,301,707 6,958,598 ---302,205 - Life & Long Term Disability 315,680 31,904 ---1,358 - Health & Dental Insurance 18,926,450 1,952,860 ---96,920 - FICA/Medicare 5,156,205 523,110 ---22,716 - PERS 14,724,814 1,275,516 ---59,217 - Unemployment Insurance 334,730 34,787 ---1,410 - Workers' Compensation 1,241,718 64,837 ---2,645 - Personnel Services 108,001,304 10,841,612 ---486,471 - Materials & Services 94,170,486 5,017,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 34,968,400 17,458,702 ----- Total Exp. & Transfers 258,134,098 33,327,654 260,443 155,500 -628,863 - Contingency 65,559,439 9,000,000 ---57,637 - Unapprop Ending Fund Bal / Reserve for Future Expenditures 32,475,609 ---994,130 -- Total Requirements 356,169,146 42,327,654 260,443 155,500 994,130 686,500 - FTE Change 9.20 2.00 ----- FTE - FY 2018 943.75 97.75 ---4.60 - FTE - FY 2017 934.55 95.75 ---4.60 - FY 2017 Budget As Revised 344,084,018 41,841,158 261,867 194,000 858,500 690,608 47,000 Inc (Dec) from FY 2017 12,085,128 486,496 (1,424)(38,500)135,630 (4,108)(47,000) General Fund 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 Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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 -3,136,663 538,000 302,000 2,800 2,165,000 1,111,441 997,074 3,245,863 56,122 517,000 95,800 15,427,000 2,011,441 2,082,945 10,525,863 ------- ------- ------- ------- ---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 --9,525,863 56,122 517,000 95,800 15,427,000 2,011,441 2,082,945 10,525,863 ------- ------- ------- 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)3,273,050 Park Acquisition & Development (130) Park Development Fees (132) PERS Reserve (135) Project Dev & Debt Reserve (140) Humane Society of Redmond (129) General Capital Reserve (143) General County Projects (142) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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 Approved 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 37,825,882 50,500 295,648 --5,597,643 -3,151,787 - 590,435 159,421 125,700 6,280,179 148,464 40,977,669 50,500 685,435 609,421 460,660 7,480,179 176,464 40,977,669 50,500 336,712 --3,319,132 -20,455,908 - 1,447 --15,781 -88,379 - 116,304 173 -909,650 -4,597,937 - 25,146 --249,428 -1,519,274 - 57,971 --664,575 -4,561,637 - 2,115 --16,647 -80,020 - 1,202 --138,650 -625,974 - 540,897 173 -5,313,863 -31,929,129 - 48,633 206,727 138,729 1,198,996 176,464 7,608,173 - ------- ------- ------- -----1,168,101 - -71,200 -69,000 -272,266 - 589,530 278,100 138,729 6,581,859 176,464 40,977,669 - 95,905 331,321 321,931 898,320 --- ------50,500 685,435 609,421 460,660 7,480,179 176,464 40,977,669 50,500 ------- 6.00 --46.90 -227.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 (5,334,278)(767,842) Victims' Assistance Program (212) Law Library (215) County Clerk Records (218) Communications System Reserve (256) Community Justice - Juvenile (230) Court Facilities (240) Sheriff's Office (255) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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,350,209 --91,738 ---15,154 --5,905,497 ---954,310 --1,430,842 ---252,687 --3,319,885 ---614,389 --110,168 ---16,921 --168,325 ---33,896 --28,377,277 ---5,237,566 100 2,900,161 12,913,779 535,374 516,705 59,794 1,329,280 ------- ------- ------- --1,020,000 ---- --490,320 ---926,888 100 2,900,161 42,801,376 535,374 516,705 59,794 7,493,734 -2,066,922 3,809,316 801,233 1,547,992 -1,485,185 288,559 ------ 288,659 4,967,083 46,610,692 1,336,607 2,064,697 59,794 8,978,919 --3.20 ---3.00 --303.05 ---48.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 Health Services (274) Public Health Dept Reserve (261) OHP- Alcohol/Drug Services (280) Code Abatement (290) Community Development (295) OHP- Mental Health Services (270) Acute Care Services (276) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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 ------44,583 ------13,408 ------32,809 ------811 ------3,065 ------272,894 26,730 ----75,000 55,012 ---- ---- ------- ------- -55,111 ----- 26,730 55,111 ---75,000 327,906 -7,729 ----80,621 --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 CDD Building Pgm Reserve (301) CDD- Groundwater Partnership (296) GIS Dedicated (305) Newberry Neighborhood (297) CDD Bldg Improvement Reserve (303) Community Development Reserve (300) CDD Electrical Reserve (302) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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,239,381 19,384 ----- 284,705 9,032 ----- 709,197 19,654 ----- 19,035 353 ----- 58,996 945 ----- 6,161,974 168,851 ----- 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,105,847 1,270,474 120,000 165,000 420,000 1,278,105 1,275,400 2,456,021 580,992 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 Federal Forest Title III (327) Surveyor (328) Road (325) Natural Resource Protection (326) Public Land Corner Preservation (329) Road Building & Equipment (330) Countywide Trans SDC Imprvmt Fee (336) Special Revenue Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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 ---- --798,630 ---- --207,031 ---- --627,926 ---- --13,994 ---- --35,693 ---- --4,455,860 ---- 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,343,725 3,395,701 1,453,043 234,158 768,949 -44,296 904,438 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,390,226 579,668 7,064,486 9,085,143 1,507,752 235,188 905,642 159,124 (88,849)183,677 2,570,681 5,291 (1,030)(38,123) FF & C, 2003/ Ref 2012 Multiple Bldgs (535) FF&C, 2005/ Ref 2015 Remodel/Land (536) Capital Proj Funds Vehicle Maintenance & Replacement (340) Dog Control (350) Adult Parole & Probation (355) FF & C, 2008 OSP/9-1-1 Building (538) Road CIP (465) Special Revenue Funds Debt Service Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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 Jail Project Debt Service (556) 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) Debt Service Funds Enterprise Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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 686,370 10,657,799 620,000 9,000 1,620,000 350,900 365,430 2,783,940 11,273,671 4,326,648 794,220 3,940,224 608,460 976,430 3,008,940 1,400,607 -----747,751 6,497 -----3,284 455,526 -----210,797 105,033 -----55,661 269,833 -----151,087 8,288 -----3,816 32,682 -----14,054 2,278,466 -----1,186,450 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,753,785 566,500 1,000 3,415,068 349,316 976,430 2,811,839 519,886 3,760,148 -525,156 259,144 -197,101 --793,220 ---- 11,273,671 4,326,648 794,220 3,940,224 608,460 976,430 3,008,940 1.00 ------ 23.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 490,139 Solid Waste Capital Projects (613) Solid Waste Equipment Reserve (614) Fair & Expo Ctr Capital Reserve (617) Fair & Expo Center (618) Landfill Postclosure (612) Solid Waste (610) Landfill Closure (611) Enterprise Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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 290,822 879,475 -627,788 413 6,846 2,976 1,506 4,167 -2,506 21,812 523,370 130,843 58,152 202,241 -116,304 7,232 110,142 49,260 22,071 65,102 -44,732 21,826 274,929 140,038 46,851 190,913 -101,137 397 8,448 2,379 -3,526 -2,115 -22,063 4,987 4,785 5,380 -5,102 148,382 2,410,603 1,039,229 424,187 1,350,804 -899,684 966,036 1,030,545 248,931 216,876 572,291 203,293 146,611 ------- ------- ------- -----199,707 - 430,626 40,260 ----- 1,545,044 3,481,408 1,288,160 641,063 1,923,095 403,000 1,046,295 -294,312 169,309 49,678 147,887 -194,459 ------- 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 Facilities (620) Deschutes County Fair (619) Legal (640) Finance Reserve (631) Finance (630) Board of County Commissioners (628) Administrative Services (625) Enterprise Funds Internal Service Funds Summary - Resources and Requirements: All County Funds FY 2018 Approved 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 21,585,803 -66,000 --- 991,331 2,402,521 240,000 3,371,531 21,585,803 1,576,331 2,807,187 684,328 8,269,167 36,585,803 541,492 1,359,272 -220,944 - 2,806 6,608 -1,080 - 174,457 334,321 -62,998 - 40,981 102,332 -16,280 - 91,547 252,850 -41,027 - 2,820 5,534 -1,146 - 4,628 11,657 -2,152 - 858,731 2,072,574 -345,627 - 334,598 511,134 29,500 2,390,699 22,038,292 ----- ----- ----- --191,000 -- ---1,000 - 1,193,329 2,583,708 220,500 2,737,326 22,038,292 383,002 223,479 -5,531,841 14,547,511 --463,828 -- 1,576,331 2,807,187 684,328 8,269,167 36,585,803 ----- 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,006,110 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 Approved 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,169,257 --1,169,257 --- 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,070,919 --7,070,919 --- Materials & Services 37,254,360 23,459,345 10,239,739 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 48,916,642 23,459,345 10,239,739 12,822,506 1,300,000 533,552 561,500 Contingency 15,051,642 4,138,883 5,963,203 4,791,338 -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 Page 18 Page 19 Page 20 Page 21 Page 22 Page 23 Page 24 Page 25 Page 26 Page 27 Page 28 Page 29 Page 30 Page 31 Page 32 Page 33 Page 34 Page 35 Page 36 Page 37 Page 38 Page 39 Page 40 Page 41 Page 42 Page 43 Page 44 Page 45 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 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 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 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 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 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 Page 348 Page 349 Page 350 Page 351 Page 352 Page 353 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 Page 368 Page 369 Page 370 Page 371 Page 372 Page 373 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 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 Page 431 Page 432 Page 433 Page 434 Page 435 Page 436