INSTRUCTIONS BEFORE USING THE ENCLOSED SCHEDULES, PLEASE COMPLETE THE FOLLOWING: Completing the steps below will populate the heading for each of the attached schedules. 1. Select the County Name: 2. Select the Budget Year: GRAHAM COUNTY 2017 Protection/Unprotection of File: Each spreadsheet within the file has been protected to prevent accidental deletion of formulas. When the sheet is protected you can move from one cell to the next using the Tab key. A password was not assigned, so the sheets may be unprotected to make minor formatting changes such as row height, column width, and font size. To unprotect an individual spreadsheet, select Protect/Unprotect Sheet from the menu. You may need to add lines to Schedules C through G to accommodate all funds or departments involved. Remember to check all formulas in the subtotals and totals, to ensure that the additional lines are included, and make changes accordingly. Once changes have been made, the sheet should be re-protected by reversing the above process. Re-protecting the sheets will help ensure that formulas are not accidentally altered or deleted. Printing Tips: Schedule A can be printed on one page in landscape format with the "fit to 1 page wide by 1 page tall" option (Page Setup) selected. Schedules B through F can be printed in portrait format. Schedule G can be printed in landscape format. Schedules with multiple pages are formatted to print with the column headings on each page. 4/15 OFFICIAL COUNTY BUDGET FORMS GRAHAM COUNTY Fiscal Year 2017 4/15 GRAHAM COUNTY TABLE OF CONTENTS Fiscal Year 2017 Resolution for the Adoption of the Budget Schedule A—Summary Schedule of Estimated Revenues and Expenditures/Expenses Schedule B—Tax Levy and Tax Rate Information Schedule C—Revenues Other Than Property Taxes Schedule D—Other Financing Sources/ and Interfund Transfers Schedule E—Expenditures/Expenses by Fund Schedule F—Expenditures/Expenses by Department (as applicable) Schedule G—Full-Time Employees and Personnel Compensation 4/15 GRAHAM COUNTY Summary Schedule of Estimated Revenues and Expenditures/Expenses Fiscal Year 2017 FUNDS S c h Fiscal Year General Fund Special Revenue Fund Debt Service Fund 2016 Adopted/Adjusted Budgeted Expenditures/Expenses* E 17,582,984 15,193,882 1,601,215 2016 Actual Expenditures/Expenses** E 15,752,430 10,145,840 1,419,641 2017 Fund Balance/Net Position at July 1*** 1,054,705 4,928,766 141 2017 Primary Property Tax Levy B 4,749,641 188,397 2017 Secondary Property Tax Levy B 2017 Estimated Revenues Other than Property Taxes C 15,089,786 8,211,750 2017 Other Financing Sources 2017 Capital Projects Fund Permanent Fund Enterprise Funds Available Total All Funds 75,000 34,453,081 27,317,911 145 5,983,757 4,938,038 250 25,002,026 D 24,811,209 24,811,209 Other Financing (Uses) D 24,811,209 24,811,209 2017 Interfund Transfers In D 89,584 3,148,392 75,000 3,312,976 2017 Interfund Transfers (Out) D 3,051,597 261,379 2017 Reduction for Amounts Not Available: LESS: Amounts for Future Debt Retirement 2017 Total Financial Resources Available 17,932,119 16,215,926 1,700,381 75,395 35,923,821 2017 Budgeted Expenditures/Expenses 17,932,119 16,215,926 1,700,381 75,395 35,923,821 E 1,700,240 3,312,976 EXPENDITURE LIMITATION COMPARISON 1. Budgeted expenditures/expenses 2. Add/subtract: estimated net reconciling items 3. Budgeted expenditures/expenses adjusted for reconciling items 4. Less: estimated exclusions 5. Amount subject to the expenditure limitation 6. EEC expenditure limitation * ** *** $ 2016 34,453,081 $ $ 34,453,081 19,691,029 14,762,052 15,617,658 $ 2017 35,923,821 $ $ 35,923,821 20,889,539 15,034,282 15,898,378 Includes Expenditure/Expense Adjustments Approved in the current year from Schedule E. Includes actual amounts as of the date the proposed budget was prepared, adjusted for estimated activity for the remainder of the fiscal year. Amounts on this line represent Fund Balance/Net Position amounts except for amounts not in spendable form (e.g., prepaids and inventories) or legally or contractually required to be maintained intact (e.g., principal of a permanent fund). SCHEDULE A GRAHAM COUNTY Tax Levy and Tax Rate Information Fiscal Year 2017 2016 1. Maximum allowable primary property tax levy. A.R.S. §42-17051(A) $ 2017 5,093,975 $ 5,243,780 4,706,194 $ 4,749,641 2. Amount received from primary property taxation in the current year in excess of the sum of that year's maximum allowable primary property tax levy. A.R.S. §42-17102(A)(18) $ 3. Property tax levy amounts A. Primary property taxes B. Secondary property taxes General Fund - Override election County Flood Control District County Fire District Assistance Total secondary property taxes C. Total property tax levy amounts 4. Property taxes collected* A. Primary property taxes (1) Current year's levy (2) Prior years’ levies (3) Total primary property taxes B. Secondary property taxes (1) Current year's levy (2) Prior years’ levies (3) Total secondary property taxes C. Total property taxes collected $ $ $ 186,609 114,385 $ $ 300,994 5,007,188 $ 4,517,529 134,300 4,651,828 $ $ $ $ 5. Property tax rates A. County tax rate (1) Primary property tax rate (2) Secondary property tax rate General Fund - Override election County Flood Control District County Fire District Assistance (3) Total county tax rate B. Special assessment district tax rates Secondary property tax rates 188,397 116,085 $ $ 304,482 5,054,123 117,886 5,574 123,460 4,775,288 2.3071 2.4597 0.0953 0.0561 0.1017 0.0601 2.4585 2.6215 * Includes actual property taxes collected as of the date the proposed budget was prepared, plus estimated property tax collections for the remainder of the fiscal year. SCHEDULE B GRAHAM COUNTY Revenues Other Than Property Taxes Fiscal Year 2017 ESTIMATED REVENUES 2016 SOURCE OF REVENUES GENERAL FUND Taxes 3360 Sales Tax Revenue Sharing 3361 County Sales Tax 3367 Auto Lieu Tax 3611 Interest On Delinquent Taxes Licenses and permits 3221 Planning & Zoning Fees 3225 Flood Plain Permits Intergovernmental 3320 Forest Service 3322 Federal Juvenile Detention-BOP 3323 Juvenile School Lunch Program 3326 Federal Juvenile Detention-USM 3330 PILT (Federal in Lieu) 3343 Criminal Justice Enhancement 3345 Search & Rescue 3347 School Salary Reimbursement 3353 Justice of the Peace Salary Reimb. 3355 Emergency Services 3356 Public Defender Reimbursement 3362 Liquor License 3364 Legislative Appropriation 3365 Lottery 3385 University of Arizona Field Deputy Charges for services General Gov't 3212, 3401-3419, 3421-3483, 3935 3420 Administrative Cost Allocation 3392, 3394 City & Town Animal Shelter & Control Svcs 3271, 3272 Food Safety & Wastewater Inspection Fees 3386, 3387 Greenlee & Gila Co Juvenile Detention Svcs 3395, 3396 City & Town WAN/Dispatching Services 3489 Greenlee County Communications Services $ SCHEDULE C 4,000,000 2,000,000 949,241 149,032 ESTIMATED REVENUES 2017 ACTUAL REVENUES* 2016 $ 3,673,050 1,856,244 892,324 148,439 $ 4,000,000 2,000,000 1,000,000 150,000 50,000 5,000 49,531 600 55,000 5,000 15,000 200,000 30,000 100,000 3,056,184 125,000 5,000 130,000 35,000 111,310 15,000 6,500 500,000 550,000 30,000 49,500 142,630 15,170 35,190 3,020,172 111,115 7,857 108,243 32,737 113,461 15,608 5,488 500,000 550,050 28,728 15,000 100,000 30,000 100,000 2,831,520 125,000 10,000 130,000 35,000 246,950 476,930 120,248 70,000 250,000 607,048 20,400 245,265 476,922 119,671 63,894 250,000 615,048 20,400 275,450 533,222 131,193 100,000 800,000 682,827 20,400 20,000 6,500 850,000 550,050 30,000 GRAHAM COUNTY Revenues Other Than Property Taxes Fiscal Year 2017 ESTIMATED REVENUES 2016 SOURCE OF REVENUES Fines and forfeits 3510, 3511, 3521, 3522 Fines & Forfeits Investments 3610, 3612 Interest on Investments Rents, royalties, and commissions 3701 WIC Building, Senior Center & Cell Towers Contributions 3801 Voluntary Contributions Miscellaneous Misc. Revenues 3359, 3852, 3919, 3925, 3941, 3948, 3949 240,000 227,043 240,000 3,500 2,010 3,500 22,000 23,974 50,000 1,135 50,000 88,738 160,124 61,000 Total General Fund $ SPECIAL REVENUE FUNDS Road Funds (210): 3363, 3367 Highway User Revenue Funds (HURF) 3320, 3321 Forest Fees & Other Federal Revenue 3440, 3485, 3927 Transfer Site & Other County Reimb. 3701, 3919, 3925, 3948 Misc. & Auction Revenues 3399 City & Town IGA Work 3610 Interest Total Road Funds Health Services Funds: Public Health Emerg. Prep (Bio-Terrorism Grant) 267 WIC Program 270 Various Health Grants & Services 232-265, 268-269, 271-279 Total Health Services Funds Other Funds: LEPC/EMPG/GOYFF Grants 014-019 Court Funds 021-028, 031-039, 056-065, 113-114 Document & Storage Funds; Juv GED Test 040-042; 078 Assessor & Treasurer Information Funds 043-045 Sheriff Funds 120-150 Attorney Funds 161-178 ESTIMATED REVENUES 2017 ACTUAL REVENUES* 2016 14,180,343 $ 13,490,237 $ 15,089,786 3,106,081 516,283 105,000 49,000 30,000 10,000 3,816,364 $ 3,119,195 470,130 $ 3,294,847 516,000 $ $ $ $ $ SCHEDULE C 53,719 $ 192,652 232,176 725,982 1,150,810 $ 239,687 286,737 29,315 20,575 2,152,926 241,111 $ $ 14,337 3,657,381 $ 184,881 232,234 679,487 1,096,602 $ 122,908 316,308 32,132 34,398 495,806 189,441 $ $ 49,000 20,000 10,000 3,889,847 192,652 214,575 729,418 1,136,645 237,129 274,030 26,400 21,565 564,739 240,935 GRAHAM COUNTY Revenues Other Than Property Taxes Fiscal Year 2017 SOURCE OF REVENUES Waste Tire Facility 207 Flood Control District 218 Probation Funds 29, 300-346 Total Other Funds Total Special Revenue Funds DEBT SERVICE FUNDS Jail District Debt Service 150 Total Debt Service Funds CAPITAL PROJECTS FUNDS Capital Facilities 403 Jail District Construction 450 Total Capital Projects Funds PERMANENT FUNDS $ $ ESTIMATED REVENUES 2016 55,015 1,100 1,658,349 4,684,815 9,651,989 $ $ $ $ $ $ $ $ ACTUAL REVENUES* 2016 56,882 5,084 1,770,170 3,023,129 7,777,112 1,419,781 1,419,781 $ 100,000 100,000 $ $ $ $ $ $ $ ESTIMATED REVENUES 2017 57,015 1,200 1,762,245 3,185,258 8,211,750 1,700,240 1,700,240 $ 135 135 $ $ Total Permanent Funds $ $ $ $ $ $ Total Enterprise Funds $ $ $ $ $ 250 250 ENTERPRISE FUNDS TOTAL ALL FUNDS $ 23,932,332 $ 22,687,265 $ 25,002,026 * Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. SCHEDULE C GRAHAM COUNTY Other Financing Sources/ and Interfund Transfers Fiscal Year 2017 FUND GENERAL FUND 150 Jail District $ 403 Capital Outlay 178 Drug, Gang & Violent Crime 210 Highway Fund 025 Field Trainer 113 CASA 305 Juvenile Family Counseling 019 GOYFF Grant 024 Conciliation Court Fund 027 Indigent Defense 031 Fill-the-Gap Grants 060 Fill-the-Gap Sup. Ct. 062 Fill-the-Gap JP#1 267 PHEP Total General Fund $ HIGHWAY FUND 100 General Fund $ 100 General Fund 100 General Fund 147 Stonegarden 218 Flood Control District Total Highway Fund $ OTHER FINANCING 2017 SOURCES $ INTERFUND TRANSFERS 2017 IN $ $ $ $ $ $ $ $ 18,070 13,522 9,969 16,396 15,863 4,764 11,000 89,584 6,000 5,000 75,500 7,500 111,604 205,604 $ $ $ 2,872,677 75,000 12,500 86,500 1,135 2,034 1,751 3,051,597 OTHER FINANCING FUND SOURCES SPECIAL REVENUE FUNDS 019 GOYFF Grant $ 024 Conciliation Court Fund 025 Field Trainer Fund 026 Court Improvement Project 027 Indigent Defense 029 DEA 031 Fill-the-Gap Grants 060 Fill-the-Gap Sup. Ct. 062 Fill-the-Gap JP#1 113 CASA 138 ACJC Drug Task Force Grant 147 Stonegarden 16-17 150 Jai District 162 Victim Witness Other 166 Victim Restitution 172 RICO 178 Drug, Gang & Violent Crime 218 Flood Control District 232 Health Ed & Facility Improvement 267 PHEP 267 PHEP 270 WIC 272 TB Control 305 Juv Family Counseling 331 Adult Probation Fees Total Special Revenue Funds $ $ IN $ $ 9,969 13,099 16,396 15,863 4,764 2,034 10,892 7,500 2,872,677 200 200 10,892 12,500 111,604 22,500 11,000 6,000 22,500 6,000 1,751 $ $ $ $ $ $ $ 24,811,209 24,811,209 $ 24,811,209 24,811,209 2,942,788 $ $ 75,000 $ $ 75,000 $ $ $ $ ENTERPRISE FUNDS Total Enterprise Funds $ $ $ $ SCHEDULE D 24,811,209 $ 24,811,209 $ 13,099 261,379 $ $ PERMANENT FUNDS Total Permanent Funds $ TOTAL ALL FUNDS $ 18,070 13,522 1,135 DEBT SERVICE FUNDS 151 Jail District Debt Service $ Total Debt Service Funds $ CAPITAL PROJECTS FUNDS 403 Capital Outlay $ 450 Jail District Construction Total Capital Projects Funds $ INTERFUND TRANSFERS 3,312,976 $ 3,312,976 GRAHAM COUNTY Expenditures/Expenses by Fund Fiscal Year 2017 ADOPTED BUDGETED EXPENDITURES/ EXPENSES 2016 FUND/DEPARTMENT GENERAL FUND 002 - Assessor 004 - Attorney 005 - Victim Witness 006 - Indigent Attorney 007 - Board of Supervisors 008 - Overtime Salary 009 - Clerk of Superior Court 018 - Building Maintenance 019 - Electrical Mainentance 020 - Information Technology 021 - Elections 025 - Park and Recreation 029 - General Office Expenses 033 - JP #1 034 - JP #2 035 - Medical Examiner 040 - Planning & Zoning 042 - Probation 044 - Recorder 049 - Search & Rescue 051 - Sheriff 052 - Animal Shelter 053 - School Superintendent 055 - Superior Court Judge 056 - Regional Juvenile Detention Center 057 - Treasurer 059 - Miscellaneous 060 - Employment & Training 063 - Public Fiduciary 068 - Medical Indigent Health 070 - Health Administration 073 - Solid Waste Mgt. 089 - Capital Outlay 079 - Contingency Total General Fund SPECIAL REVENUE FUNDS Road Funds 210 Public Health Emerg. Prep 267 WIC Program 270 Health Grants/Svcs 232-265, 268-269, 271-279 LEPC/EMPG/GOYFF Grants 014-019 Court Funds 021-028, 031-039, 056-065, 113-114 Doc & Storage Funds; Juv GED 040-042; 078 Assessor & Treasurer Funds 043-045 Sheriff Funds 120-150 Attorney Funds 161-178 Waste Tire Facility 207 Flood Control District 218 Probation Funds 029, 300-346 Total Special Revenue Funds DEBT SERVICE FUNDS Jail District Debt Service 150 Total Debt Service Funds CAPITAL PROJECTS FUNDS Capital Facilities 403 Jail District Construction 450 Total Capital Projects Funds PERMANENT FUNDS EXPENDITURE/ EXPENSE ADJUSTMENTS APPROVED 2016 ACTUAL EXPENDITURES/ EXPENSES* 2016 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 642,174 1,162,591 13,571 488,000 786,626 12,000 526,473 193,107 9,031 1,371,160 216,204 387,162 273,000 369,750 213,718 66,600 256,229 163,021 272,520 17,066 3,227,737 250,342 217,102 955,699 1,387,829 379,446 512,829 80,200 89,734 1,993,400 262,418 108,500 300,000 377,745 17,582,984 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,425,589 226,080 214,575 851,817 241,890 391,368 104,898 97,913 5,205,638 528,635 55,019 457,238 2,106,241 16,906,901 $ $ $ $ $ (111,804) (1,601,215) $ $ $ (1,713,019) $ 1,601,215 1,601,215 $ $ 609,673 921,685 13,592 488,000 778,103 521,601 160,871 6,563 1,490,094 193,356 375,006 202,124 367,355 204,379 53,492 252,275 156,754 256,217 12,072 3,099,133 188,517 205,744 810,603 1,226,724 308,893 406,729 75,747 83,813 1,990,947 255,150 37,216 15,752,430 BUDGETED EXPENDITURES/ EXPENSES 2017 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 655,520 1,063,808 16,263 513,000 835,114 1,855 554,105 182,224 9,271 1,512,276 222,336 435,268 253,000 376,111 237,598 61,100 268,764 162,381 279,351 16,566 3,383,341 252,694 207,327 979,013 1,452,141 392,863 480,754 85,870 88,841 1,961,606 281,013 33,000 300,000 377,745 17,932,119 $ 3,212,144 149,211 169,373 667,234 148,647 198,720 42,425 39,745 3,252,135 156,193 56,883 132,449 1,920,681 10,145,840 $ 7,279,550 228,531 214,834 933,011 219,268 451,377 91,688 93,556 3,758,615 558,896 57,018 274,196 2,055,386 16,215,926 1,419,641 1,419,641 $ $ 1,700,381 1,700,381 75,000 395 75,395 $ 75,000 $ $ $ $ 75,000 $ $ $ $ $ $ $ $ $ $ Total Permanent Funds $ ENTERPRISE FUNDS $ $ $ $ $ $ $ Total Enterprise Funds $ 34,564,885 $ (111,804) $ 27,317,911 $ 35,923,821 TOTAL ALL FUNDS $ * Includes actual expenditures/expenses recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year. SCHEDULE E GRAHAM COUNTY Expenditures/Expenses by Department Fiscal Year 2017 DEPARTMENT/FUND Sheriff: General Fund $ Stonegarden GIITEM Ft Thomas Resource Officer Jail Revenue Fund JAG Grants Health Service Fee Jail Enhancement ACJC Drug Grant ARRA Interest Fund Forest Road Patrol BLM Patrol Grant Jail District Fund Jail District Debt Service Sheriff Total $ Attorney: General Fund $ Enhanced Collection Victim Witness Other Bad Check Fees Fill-the-Gap Victim Restitution Anti-Gang Enforcement ACJC Victim Witness Program ACJC Victim Compensation VOCA Juvenile Victim Advocate Anti-Racketeering - RICO Prosecution Fees Diversion Fund ADOPTED BUDGETED EXPENDITURES/ EXPENSES 2016 EXPENDITURE/ EXPENSE ADJUSTMENTS APPROVED 2016 3,244,803 97,197 56,909 130,136 15,654 5,760 256,187 28,000 12,288 20,501 51,467 4,531,542 8,450,444 $ 1,242,762 53,099 1,165 5,195 15,610 43,459 82 29,677 48,435 37,370 45,699 126,727 43,243 $ $ ACTUAL EXPENDITURES/ EXPENSES* 2016 3,244,803 97,197 56,909 130,136 15,654 5,760 256,187 28,000 12,288 20,501 51,467 2,930,327 1,601,215 8,450,444 $ 1,242,762 53,099 1,165 5,195 15,610 43,459 82 29,677 48,435 37,370 45,699 126,727 43,243 $ SCHEDULE F $ BUDGETED EXPENDITURES/ EXPENSES 2017 3,111,205 79,741 9,250 57,009 73,810 15,654 143,986 24,375 10,287 2,838,023 1,419,641 7,782,981 $ 988,770 1,831 326 4,466 2,926 29,677 15,230 37,296 8,649 638 3,965 $ $ 3,399,907 131,574 57,009 165,232 10,220 5,794 251,413 26,933 8,677 20,501 51,467 3,029,795 1,700,381 8,858,903 1,141,171 61,201 1,002 5,220 20,428 48,392 83 29,677 44,611 15,844 37,430 38,055 138,662 40,410 GRAHAM COUNTY Expenditures/Expenses by Department Fiscal Year 2017 ADOPTED BUDGETED EXPENDITURES/ EXPENSES DEPARTMENT/FUND 2016 Fair & Legal Employment Act 27,694 51,230 Drug, Gang & Violent Crime 1,771,447 Attorney Total $ Health Administration & Other: General Fund $ 2,255,818 107,079 Health Education/Facility Imp Prescrip. Drug Abuse Grant 136,153 Teen Pregnancy Prevention 27,000 Public Health Emergency 226,080 PHEP (Bio-Terrorism Grant) 60,270 Family Planning Public Health Accreditation 23,419 WIC 214,575 HIV Prevention 10,143 TB Control 12,177 95,153 Healthy AZ Population Initiative Immunization Action Plan 91,372 Tobacco Education 120,765 5,371 STD (Sexually Transm. Dis.) 72,922 Proposition 201/Smoke Free AZ Vital Records 89,993 3,548,290 Health Total $ Courts: General Fund $ 2,065,640 Law Library 17,393 19,546 Child Support/Visitation Domestic Relations Education 3,475 5,028 Concilliation Court Field Trainer 50,000.00 3,539 Court Improvement Project EXPENDITURE/ EXPENSE ADJUSTMENTS APPROVED 2016 27,694 51,230 $ 1,771,447 ACTUAL EXPENDITURES/ EXPENSES* 2016 51,188 $ 1,144,963 BUDGETED EXPENDITURES/ EXPENSES 2017 27,834 50,047 $ 1,700,067 $ 2,255,818 107,079 136,153 27,000 226,080 60,270 23,419 214,575 10,143 12,177 95,153 91,372 120,765 5,371 72,922 89,993 3,548,290 $ 2,246,097 55,957 96,252 8,050 149,211 49,005 71,298 169,373 6,681 17,293 50,241 79,659 116,947 157 56,888 58,805 3,231,915 $ 2,065,640 17,393 19,546 3,475 5,028 50,000 3,539 $ 1,903,939 18,443 11,069 50,000.00 3,539 $ $ $ SCHEDULE F $ $ 2,242,619 48,668 49,000 188,031 8,050 228,531 91,816 10,178 214,834 8,694 17,708 100,291 101,461 162,463 7,931 65,982 72,738 3,618,995 2,146,827 17,654 15,601 4,580 5,000 51,135 16,258 GRAHAM COUNTY Expenditures/Expenses by Department Fiscal Year 2017 ADOPTED BUDGETED EXPENDITURES/ EXPENSES DEPARTMENT/FUND 2016 Fill-the-Gap Indigent Defense Access & Visitation 8 JCEF Fill-the-Gap JCEF JP #2 3,750 13,759.00 Spousal Maint. Enforcement JCEF JP #1 40,644 Prosecution Fees 9,839 277,007.00 Courthouse Security JCEF Clerk of the Court 18,500 26,656 Doc Storage Clerk of the Court Interest Fund Clerk of the Court 8,764 Justice Court Recovery JP#1 76,414 14,930 Justice Court Recovery JP#2 3,016 Fill-the-Gap - Superior Court 3,016 Fill-the-Gap JP #1 3,922 Fill-the-Gap JP #2 45,628 Superior Court Enhancement CASA 28,719 2,535 Juvenile Emergency 2,741,728 Courts Total $ Probation: General Fund $ 163,021 DEA 37,294 Juvenile Diversion Fees 59,674 Juvenile Probation Fees 32,773 Juvenile Diversion Intake 97,636 Juvenile Diversion Consequence 39,925 Juvenile Programs 3,007 Juvenile Family Counseling 10,504 Juvenile Standard 209,978 EXPENDITURE/ EXPENSE ADJUSTMENTS APPROVED 2016 8 3,750 13,759 40,644 9,839 277,007 18,500 26,656 8,764 76,414 14,930 3,016 3,016 3,922 45,628 28,719 2,535 $ 2,741,728 $ $ $ SCHEDULE F 163,021 37,294 59,674 32,773 97,636 39,925 3,007 10,504 209,978 ACTUAL EXPENDITURES/ EXPENSES* 2016 2,000.00 8,226 8,666 107.85 9,506 21,027 1,628 21,798 621 2,702 2,702 3,750 16,562 39,027 2,125,314 156,754 36,102 15,535 17,703 97,025 40,646 10,307 214,128 BUDGETED EXPENDITURES/ EXPENSES 2017 5,720 12,920 36,667 1,522 45,165 18,451 13,114 7,267 92,240 34,767 3,933 3,933 9,086 54,159 20,034 2,552 $ 2,618,585 $ 162,381 41,012 42,582 25,795 101,683 33,522 3,833 10,511 227,837 GRAHAM COUNTY Expenditures/Expenses by Department Fiscal Year 2017 ADOPTED EXPENDITURE/ BUDGETED EXPENSE ACTUAL BUDGETED EXPENDITURES/ ADJUSTMENTS EXPENDITURES/ EXPENDITURES/ EXPENSES APPROVED EXPENSES* EXPENSES DEPARTMENT/FUND 2016 2016 2016 2017 Juvenile Intensive Supervision 107,506 107,506 114,295 111,327 Juvenile Service Treatment 139,622 139,622 138,411 133,761 Juvenile Drug Court 4,200.00 4,200 9,650.00 9,100 Extra Juvenile Probation 2,960 2,960 2,526 1,757 JCRF Grant 6,520 6,520 6,520 6,520 Life Skills-Juvenile 2,480.00 2,480 2,480.00 2,480 Adult UA Testing Reimb. 134,865 134,865 52,254 55,539 Juvenile UA Testing Reimb. 5,448 5,448 3,768 256 Adult Probation Fees 371,862 371,862 265,131 276,293 Adult Intensive Service 273,690 273,690 307,828 323,405 Adult Community Punishment 17,500 17,500 17,500 17,500 Adult State Aid Enhancement 340,394 340,394 369,019 396,478 Adult Drug Testing 3,439 3,439 1,163 3,865 Sex Offender Treatment 34,449 34,449 16,778 39,843 CJEF Sex Offender 23,625 23,625 23,625 23,635 Extra Adult Probation 9,979 9,979 10,808 7,119 Interstate Compact 30% 8,962 8,962 3,052 6,228 JCEF - Probation IPS Assist SAE Assist 122,649 122,649 141,959 149,411 Adult GPS 1,020 1,020 1,020 Adult MRT 1,742 1,742 1,564 604 Adult NCTI (Drug Education) 2,538 2,538 904 2,470 2,269,262 $ 2,269,262 $ 2,077,435 $ 2,217,767 Probation Total * Includes actual expenditures/expenses recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year. SCHEDULE F GRAHAM COUNTY Full-Time Employees and Personnel Compensation Fiscal Year 2017 FUND Employee Salaries and Hourly Costs 2017 Full-Time Equivalent (FTE) 2017 Retirement Costs 2017 Total Estimated Personnel Compensation 2017 Other Benefit Costs 2017 Healthcare Costs 2017 GENERAL FUND 148.6 $ 7,244,058 $ 1,211,765 $ 1,305,967 $ $ 9,761,790 SPECIAL REVENUE FUNDS Court Funds Probation Funds Jail District Fund Sheriff's Office Funds Attorney/Victim Witness Funds Highway Funds Health Funds Total Special Revenue Funds 2.5 25.5 39.5 1.7 1.8 30.3 12.8 114.1 $ 91,673 1,216,352 1,630,205 65,736 115,495 1,378,692 618,322 5,116,474 $ 9,136 219,289 132,163 14,886 7,976 152,583 70,075 606,107 $ 7,853 213,526 349,974 13,493 25,483 298,263 146,630 1,055,222 $ $ $ $ 108,663 1,649,167 2,112,341 94,115 148,954 1,829,538 835,027 6,777,804 $ $ $ DEBT SERVICE FUNDS Total Debt Service Funds $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ CAPITAL PROJECTS FUNDS Total Capital Projects Funds PERMANENT FUNDS Total Permanent Funds ENTERPRISE FUNDS Total Enterprise Funds INTERNAL SERVICE FUND Total Internal Service Fund TOTAL ALL FUNDS 262.7 $ 12,360,532 $ 1,817,873 SCHEDULE G $ 2,361,189 16,539,593