Details for BOARD OF SUPERVISORS/COCO COUN - Ad from 2021-06-10

Legal No. 338 Coconino County Other Financing Sources/(Uses) and Interfund Transfers Fiscal year 2022 Coconino County Summary Schedule of Estimated Revenues and Expenditures/Expenses Fiscal year 2022 Fiscal year Funds S c h L i n e Special Revenue Fund General Fund Debt Service Fund Capital Projects Fund Permanent Fund Enterprise Funds Adopted/Adjusted Budgeted Expenditures/Expenses* E 1 65,446,931 99,402,993 18,160,000 2,981,210 0 0 185,991,134 2021 Actual Expenditures/Expenses** E 2 63,675,502 93,318,065 18,160,000 2,645,634 0 0 177,799,201 2022 Fund Balance/Net Position at July 1*** 3 32,439,404 90,457,285 41,929 5,151,070 0 0 128,089,688 2022 Primary Property Tax Levy B 4 10,274,633 0 0 2022 Secondary Property Tax Levy B 5 0 14,732,354 0 0 2022 Estimated Revenues Other than Property Taxes C 6 68,345,175 123,660,558 0 100,954 0 0 192,106,687 2022 Other Financing Sources D 7 0 0 0 0 0 0 0 2022 Other Financing (Uses) D 8 0 0 0 0 0 0 0 2022 Interfund Transfers In D 9 2,718,419 15,628,186 1,018,352 137,532 0 0 19,502,489 2022 Interfund Transfers (Out) Line 11: Reduction for Fund Balance Reserved for Future Budget Year Expenditures D 10 13,403,068 6,014,343 41,929 43,149 0 0 19,502,489 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 100,374,563 238,464,040 1,018,352 5,346,407 0 0 345,203,362 13 100,374,563 173,874,471 1,018,352 1,365,818 0 0 276,633,204 2022 Maintained for Future Debt Retirement Maintained for Future Capital Projects 11 Maintained for Future Financial Stability 2022 Total Financial Resources Available 2022 Budgeted Expenditures/Expenses E 1 2 3 4 5 6 * ** *** 0 10,274,633 14,732,354 Expenditure Limitation Comparison Budgeted expenditures/expenses Add/subtract: estimated net reconciling items Budgeted expenditures/expenses adjusted for reconciling items Less: estimated exclusions Amount subject to the expenditure limitation EEC expenditure limitation $ $ $ 2021 185,991,134 $ (36,828,906) 149,162,228 81,332,796 67,829,432 $ 67,829,432 $ 2022 276,633,204 (38,761,855) 237,871,349 170,205,429 67,665,920 67,665,920 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). 3/21 Arizona Auditor General SCHEDULE A Official County Budget Forms Coconino County Tax Levy and Tax Rate Information Fiscal year 2022 2021 1. Maximum allowable primary property tax levy. A.R.S. §42-17051(A) $ $ 10,274,633 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 Coconino County Library District Coconino County Flood Control District Public Health Services District 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 $ $ 10,214,030 $ 10,274,633 $ 4,932,375 3,857,330 4,824,310 $ 5,069,877 4,703,677 4,958,800 $ $ 13,614,015 23,828,045 $ $ 14,732,354 25,006,987 $ 10,104,030 110,000 10,214,030 $ B. Secondary property taxes (1) Current year's levy (2) Prior years’ levies (3) Total secondary property taxes C. Total property taxes collected $ 5. Property tax rates A. County tax rate (1) Primary property tax rate (2) Secondary property tax rate Coconino County Library District Coconino County Flood Control District Public Health Services District (3) Total county tax rate B. Special assessment district tax rates Secondary property tax rates 0.5293 0.5180 0.2556 0.2280 0.2500 0.2556 0.2620 0.2500 1.2629 1.2856 * 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. 3/21 Arizona Auditor General SCHEDULE B Official County Budget Forms Coconino County Revenues Other than Property Taxes Fiscal year 2022 Estimated revenues 2021 Source of revenues General Fund Taxes County Sales Tax Interest and Penalties on Delinquent Taxes Other Taxes $ Licenses and permits Board of Supervisors Clerk of Superior Court Community Development Sheriff Estimated revenues 2022 Actual revenues* 2021 14,636,973 738,000 110,000 $ 18,625,000 547,210 110,000 $ 18,952,000 738,000 110,000 50,000 38,000 2,217,400 2,500 50,000 35,000 1,839,022 0 50,000 40,000 1,648,500 0 Intergovernmental State Shared Sales Tax State Shared Vehicle License Tax Federal Grants and Aid State Grants and Aid Other Intergovernmental 20,494,575 4,343,000 3,788,987 621,462 579,829 28,300,000 4,848,225 6,673,438 886,631 610,000 28,560,000 4,605,800 3,737,161 885,462 200,000 Charges for services Assessor Clerk of Superior Court Community Development Constables County Attorney Health and Human Services Information Technology Justice Courts Legal Defender Non-Departmental: Indirect Costs Parks and Recreation Public Defender Public Fiduciary Recorder Sheriff Superior Court 150 125,000 500 25,000 10,000 0 5,000 503,000 6,500 3,907,112 416,250 63,123 80,000 660,000 537,854 9,250 0 105,000 75 10,000 2,050 230,400 2,000 661,000 6,500 4,270,500 46,195 70,000 80,000 1,028,000 472,636 8,400 150 110,000 100 25,000 5,000 300,000 2,000 670,000 6,500 4,570,800 194,050 65,000 100,000 745,000 450,000 9,250 Fines and forfeits Clerk of Superior Court Justice Courts Other Fines & Forfeits 40,000 1,131,350 11,000 Investments Interest and Investment Income Miscellaneous Other Total General Fund $ 30,000 967,914 7,304 32,000 1,220,350 20,000 344,395 110,980 83,270 0 6,269 6,000 161,575 646,917 203,782 Contributions Voluntary contributions 55,657,785 $ 71,286,666 $ 68,345,175 * 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. 3/21 Arizona Auditor General SCHEDULE C Sources Flood Control District Sedona Flood Control Road Maintenance Sales Tax Public Works Superior Crt State Fill the Ga Court Enhancement Fund Law Library Probate Enhancement Fees Attorney Enhancement Anti-Racketeering Drug Prosecution 16.579 Victim Restitution Victim Restitutions Interest CJ Records Impv 16.579 State Aid SB1013 SB11-539 VOCA-Victims of Crimes LWCF Grant-Bike Park & Restrm Parks Partnership Projects Public Def State Fill the Gap Legal Def State Fill the Gap 5% Local Fill The Gap ACJC Flag Improvement Grant Flag JC Enhancement Fund County Library Fund Title I National Forest Fees Anasazi Trails CID Debt Servic Anasazi Trails CID Construction Total Special Revenue Funds $ $ Total Special Revenue Funds $ Estimated revenues 2022 Actual revenues* 2021 3,208,889 0 155,110 861,498 1,160,350 11,400 15,414,813 270,646 0 882,000 14,427,244 362,560 48,417 153,570 111,461 3,017,773 46,680 513,911 1,377,302 88,309 20,561,761 781,192 1,336,088 4,647,888 592,101 17,750 0 $ 70,048,713 $ 3,221,086 14,000,000 153,715 304,486 927,186 11,400 18,745,565 237,062 0 62,788 12,142,771 283,131 34,525 86,575 106,338 2,985,359 100,229 464,296 967,732 137,895 30,137,786 847,733 918,154 4,229,106 511,229 17,750 0 $ 91,633,897 $ 3,483,635 14,000,000 146,382 1,833,633 1,059,038 11,400 20,068,216 270,646 0 6,000 9,687,761 322,560 46,505 96,350 98,915 2,802,711 28,350 233,022 887,481 100,400 26,912,750 166,500 1,232,700 4,312,055 549,909 17,750 35,285,889 123,660,558 0 18,160,000 $ 250 18,160,000 $ 0 0 Total Debt Service Funds $ 18,160,000 $ 18,160,250 $ 0 Capital Projects Funds $ 0 34,014 24,940 92,000 $ 200 47,831 744,393 75,000 $ 0 38,014 940 62,000 Total Capital Projects Funds $ 150,954 $ 867,424 $ 100,954 Total all Funds $ 144,017,452 $ 181,948,237 $ 192,106,687 * 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. 3/21 Arizona Auditor General SCHEDULE C Official County Budget Forms Coconino County Other Financing Sources/(Uses) and Interfund Transfers Fiscal year 2022 Other financing 2022 Fund Sources 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $ Special Revenue Funds General Fund Special Districts Billing Metro Unit Statewide Gang Task Force County Jail District 0 0 0 0 0 $ 3/21 Arizona Auditor General $ $ SCHEDULE D 0 0 0 $ $ $ $ 0 0 $ 0 $ 0 $ $ 0 $ $ 1,018,352 0 1,018,352 $ $ 0 137,532 0 137,532 $ $ 19,502,489 $ 0 8,017 0 3,712,601 245,744 0 124,666 18,420 0 0 68,990 0 1,500 6,979 70,016 7,159 62,218 0 59,865 6,652 0 13,324 0 0 0 0 0 6,014,343 General Fund Adult Probation $ Assessor Board of Supervisors Clerk of Superior Court Community Development Community Initiatives Constables County Administration County Attorney Emergency Management Facilities Management Finance Health and Human Services Human Resources Information Technology Justice Courts - Flagstaff Justice Courts - Fredonia Justice Courts - Page Justice Courts - Williams Juvenil Court Services Legal Defender Non-Departmental Parks and Recreation Public Defender Public Fiduciary Recorder Sheriff Superintendent of Schools Superior Court Treasurer Total General Fund $ 1,995,987 2,290,969 2,028,524 1,498,307 2,413,528 278,028 139,870 2,905,699 4,349,711 4,500 4,445,568 1,538,596 518,164 2,234,316 4,548,156 1,456,303 227,258 496,513 490,444 3,482,237 1,383,493 2,855,844 1,689,305 3,027,563 827,636 2,852,714 12,063,369 552,236 4,275,885 813,813 67,684,536 $ Special Revenue Funds Adult Probation Assessor Board of Supervisors Clerk of Superior Court Community Development County Administration County Attorney County Improvement Districts County Jail District County Library District Emergency Management Facilities Management Finance Flood Control District Health and Human Services Justice Courts - Flagstaff Justice Courts - Fredonia Justice Courts - Page Justice Courts - Williams Juvenile Court Services Legal Defender 3,620,675 26,260 0 136,000 0 0 1,424,912 11,400 25,055,602 4,810,195 499,292 11,000 3,750 6,657,609 20,784,862 252,527 43,214 177,199 130,554 2,987,765 3,684 $ $ 3/21 Arizona Auditor General $ (11,000) $ (828) (354,464) (2,000) 60,818 18,396 (1,260) 270,695 0 0 (474,985) 406 2,607,140 (90,363) 127,249 (8,500) (1,425) 0 (1,750) (10,000) 150,000 (4,932,463) (44,524) 0 (6,000) (7,300) (415,247) 0 889,800 0 (2,237,605) $ 1,986,464 $ 2,017,527 1,518,271 1,407,291 2,248,168 189,665 137,510 2,417,180 4,349,711 2,500 3,829,730 1,376,460 3,629,649 1,882,005 4,503,917 1,381,487 225,124 495,831 489,547 3,493,501 1,522,273 (516,174) 1,391,366 2,780,647 756,694 2,704,321 11,110,431 528,918 5,056,933 758,554 63,675,502 $ 108,345 $ 0 0 0 0 420,527 70,446 0 (3,804,099) 0 0 5,286 0 (2,137,920) 3,832,940 5,000 1,812 56,220 7,546 295,319 54,371 3,319,449 23,000 0 150,332 0 304,486 1,221,672 11,400 19,878,543 4,810,195 362,063 5,286 2,565 4,370,766 22,797,231 250,415 8,130 1,706 88,100 3,171,323 56,071 3,994,829 330,000 223,327 4,548,156 Justice Courts - Flagstaff: General Fund $ Flag JC Enhancement Fund $1 Judicial Productivity Units Department Total $ 1,456,303 228,527 24,000 1,708,830 Justice Courts - Fredonia: General Fund $ Fredonia JC Court Enhancement Court Security Improvements $1 Judicial Productivity Units Department Total $ 227,258 40,614 0 2,600 270,472 $ 496,513 171,099 0 6,100 673,712 $ 20,078 21,851 41,929 Justice Courts - Page: General Fund $ Page JC Court Enhancement Court Security Improvements $1 Judicial Productivity Units Department Total $ 1,000 0 42,149 43,149 Justice Courts - Williams: General Fund $ Court Security Improvements Williams JC Court Enhancement $1 Judicial Productivity Units Department Total $ 490,444 0 123,454 7,100 620,998 $ 3,482,237 12,901 143,361 197,950 604,540 143,613 155,968 39,226 653,696 24,529 41,766 114,459 0 25,542 50,000 706,575 31,932 41,707 $ 19,502,489 SCHEDULE E 2,047,904 2,267,829 1,625,612 1,599,321 2,463,685 264,298 142,627 3,280,752 4,484,688 4,500 4,098,266 2,321,685 2,188,032 2,512,482 4,494,371 1,481,385 223,824 514,059 513,888 3,555,994 1,428,283 35,589,165 1,725,250 3,022,585 833,072 2,055,747 10,232,686 540,424 4,030,923 831,226 100,374,563 $ 3,884,304 25,000 28,000,000 105,061 0 1,766,817 1,362,350 11,400 23,208,703 5,098,324 471,795 11,000 101,016 4,858,405 23,129,194 298,302 43,421 333,435 150,902 3,077,822 30,810 Official County Budget Forms Coconino County Expenditures/Expenses by Fund Fiscal year 2022 Fund/Department Non-Departmental Parks and Recreation Public Defender Public Works Recorder Sheriff Superintendent of Schools Superior Court Treasurer Unawarded Grants Total Special Revenue Funds $ Expenditure/ Expense adjustments approved 2021 Adopted Budgeted Expenditures/ Expenses 2021 0 536,116 29,375 27,306,836 368,868 1,823,774 3,527,010 1,236,200 31,000 17,209,222 118,704,901 19,513 (209,895) 70,435 (2,509,963) 681,233 (419,778) 1,261,684 98,292 0 (17,209,222) (19,301,908) $ $ Budgeted Expenditures/ Expenses 2022 Actual Expenditures/ Expenses* 2021 0 210,937 64,147 24,557,461 848,952 861,705 4,743,827 1,167,302 31,000 0 93,318,065 23,077 769,562 70,354 34,639,539 501,868 1,636,308 3,726,539 1,222,274 31,000 35,285,889 173,874,471 $ Debt Service Funds PSPRS Debt Service $ Total Debt Service Funds $ 0 0 $ $ 18,160,000 18,160,000 $ $ 18,160,000 18,160,000 $ $ 1,018,352 1,018,352 Capital Projects Funds Facilities Management $ Parks and Recreation Superintendent of Schools Total Capital Projects Funds $ 1,425,268 2,599,286 36,200 4,060,754 $ 263,307 2,325,767 56,560 2,645,634 $ $ (1,111,181) $ 31,637 0 (1,079,544) $ $ 1,312,742 7,076 46,000 1,365,818 Total all Funds $ 190,450,191 $ (4,459,057) $ 177,799,201 $ 276,633,204 * 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. 3/21 Arizona Auditor General SCHEDULE E Adult Probation: General Fund ACESF Grant Adult Probation St Enhancement Adult Intensive Probation Work Furlough Program Interstate Compact Program Drug Treatment & Education Deferred Prosecution Community Punishment Program Adult Probation Services Department Total Assessor: General Fund Assessor Storage/Retrieval Department Total $ 0 0 0 0 0 $ $ 1,032,258 0 95,997 0 0 0 0 0 0 0 0 0 0 0 0 1,250,000 81,315 0 0 0 0 0 0 0 0 0 0 46,150 0 13,214 0 0 0 0 0 0 178,407 652 865 7,256 11,305 0 0 1,000 2,718,419 11,118,929 0 0 0 15,356 $ Official County Budget Forms $ $ 0 384,053 0 223,327 81,506 101,700 337,669 97,270 25,000 45,703 17,297 9,742 47,486 148,712 7,894 2,766,525 0 204,580 130,000 46,491 22,453 64,257 3,198 6,895 41,687 12,709 18,489 0 819,931 0 4,965,972 616,081 177,358 584,553 10,000 228,646 0 0 0 0 0 1,018,352 137,532 0 13,403,068 1,569,086 3,750 20,000 15,356 0 Official County Budget Forms 1,995,987 0 1,204,718 1,170,030 50,876 8,500 155,932 286,289 204,308 540,022 5,616,662 $ 2,290,969 26,260 2,317,229 $ Actual Expenditures/ Expenses* 2021 1,986,464 98,000 1,203,660 1,137,312 15,599 7,750 134,438 169,607 195,481 357,602 5,305,913 $ (828) $ 0 (828) $ 2,017,527 23,000 2,040,527 Board of Supervisors: General Fund $ American Rescue Plan Department Total $ 2,028,524 $ 0 2,028,524 $ (354,464) $ 0 (354,464) $ Clerk of Superior Court: General Fund $ Probate Enhancement Fees Spousal Maintenance Fund DES IV-D Grant Clerk's Forfeiture Fund 13.431 Clerks Storage & Retrieval Department Total $ 1,498,307 42,135 2,176 9,000 54,107 28,582 1,634,307 Community Development: General Fund $ Department Total $ $ $ $ $ $ Budgeted Expenditures/ Expenses 2022 $ $ $ 2,047,904 0 1,301,784 1,199,591 66,738 8,500 164,599 318,557 210,763 613,772 5,932,208 $ 2,267,829 25,000 2,292,829 1,518,271 $ 0 1,518,271 $ 1,625,612 28,000,000 29,625,612 1,407,291 40,153 2,157 38,472 52,711 16,839 1,557,623 $ $ (2,000) $ 0 0 0 0 0 (2,000) $ $ 1,599,321 43,402 0 11,930 33,374 16,355 1,704,382 2,413,528 2,413,528 $ $ 60,818 60,818 $ $ 2,248,168 2,248,168 $ $ 2,463,685 2,463,685 $ Department Total $ 278,028 278,028 $ $ 18,396 18,396 $ $ 189,665 189,665 $ $ 264,298 264,298 $ Department Total $ 139,870 139,870 $ $ (1,260) $ (1,260) $ 137,510 137,510 $ $ 142,627 142,627 County Administration: General Fund $ GF: Financial Management System WIOA Department Total $ 2,533,699 372,000 0 2,905,699 $ 643,195 $ (372,500) 420,527 691,222 $ 2,379,447 37,733 304,486 2,721,666 $ 3,280,752 0 1,766,817 5,047,569 County Attorney: General Fund ACESF Grant Attorney Enhancement Atty VRIA:Victm Rghts 1761/179 Anti-Racketeering Drug Prosecution 16.579 Victim Restitution Victim Restitutions Interest CJ Records Impv 16.579 State Aid SB1013 SB11-539 4,349,711 0 16,217 62,628 585,150 171,977 45,000 4,162 27,292 74,386 $ 4,349,711 23,346 16,227 98,502 585,150 170,477 40,000 2,000 26,113 73,386 $ Community Initiatives: General Fund Constables: General Fund $ $ 0 46,692 0 35,874 0 0 0 0 6,418 0 $ SCHEDULE F $ 4,484,688 23,346 16,217 111,139 585,150 168,335 45,000 4,000 60,664 76,223 Official County Budget Forms Expenditure/ Expense adjustments approved 2021 Department/Fund Federal Anti-Racketeering Victim Compensation Pretrial Intervention VOCA-Victims of Crimes Department Total $ Adopted Budgeted Expenditures/ Expenses 2021 93,141 144,160 148,370 52,429 5,774,623 $ County Improvement Districts: Tusayan Special District $ Department Total $ 11,400 11,400 $ $ County Jail District: County Jail District $ Jail District Repair & Repl Detention Officers Retention Department Total $ 18,219,150 5,461,452 1,375,000 25,055,602 $ County Library District: County Library Fund $ Department Total $ 4,810,195 4,810,195 $ $ 0 0 Emergency Management: General Fund $ Emergency Services Emergency Svcs-Supplies 20.703 State & Local Assistance Department Total $ 4,500 3,000 9,500 486,792 503,792 $ 0 0 0 0 0 Facilities Management: General Fund $ GF: Asset Repair & Repl Reserve EECBG Formula Coconino County-Space Plan Department Total $ 3,521,929 923,639 11,000 1,425,268 5,881,836 $ Finance: General Fund $ GF: Financial Management System Special Districts Billing American Rescue Plan Department Total $ 1,538,596 0 3,750 0 1,542,346 $ $ Flood Control District: Flood Control District $ Department Total $ 6,657,609 6,657,609 $ $ 518,164 0 2,531,840 1,780,594 125,520 11,647,941 1,649,587 129,303 226,138 823,585 195,408 1,352,562 12,700 10,000 299,684 $ Health and Human Services: General Fund ACESF Grant Federal Grants State Grants Private Grants Health District WIOA Community Services ADOH Housing Senior Services Home Care Social Services Individual Development Acct Career Center Self-funded Programs 3/21 Arizona Auditor General $ Juvenile Court Services: General Fund Family Counseling Juvenile Probation Service CASA-Special Advocate Juv Treatment Services Diversion-Consequences Juvenile Probation State Aid USDA Food Grant Diversion-Intake Juvenile Victim's Rights Impl Juvenile Diversion Fees Fund Probation Fees Over $40. Diversion Fees Over $40. CASA VOCA PIC Act Juvenile Intensive Probation Model Court-State Funds JCRF Step Up Proctor Homes $ 3/21 Arizona Auditor General $ Actual Expenditures/ Expenses* 2021 10,000 114,542 10,000 51,929 5,571,383 $ Budgeted Expenditures/ Expenses 2022 93,141 114,542 10,000 54,593 5,847,038 $ $ 11,400 11,400 $ $ 11,400 11,400 (1,707,674) $ (888,206) (1,208,219) (3,804,099) $ 16,203,225 3,645,318 30,000 19,878,543 $ $ 20,861,882 2,246,821 100,000 23,208,703 $ $ 4,810,195 4,810,195 $ $ 5,098,324 5,098,324 $ $ $ 2,500 3,000 3,167 355,896 364,563 4,500 3,000 4,849 463,946 476,295 (140,133) $ (334,852) 5,286 (1,111,181) (1,580,880) $ 3,304,908 524,822 5,286 263,307 4,098,323 $ $ $ 1,336,460 40,000 2,565 0 1,379,025 $ 1,626,904 694,781 3,750 97,266 2,422,701 (2,137,920) $ (2,137,920) $ 4,370,766 4,370,766 $ $ 4,858,405 4,858,405 2,607,140 $ 7,746 290,907 (196,290) 0 347,325 (1,045,527) (59,189) (24,330) 10,509 0 1,287,561 0 0 0 3,629,649 7,746 2,647,742 1,430,768 105,347 11,479,137 563,032 3,775 99,829 736,627 190,507 2,368,458 0 10,000 164,081 $ 2,188,032 0 3,364,013 1,715,504 94,619 11,756,909 843,759 115,900 248,950 816,791 180,858 1,475,513 20,000 10,000 275,838 0 (19,038) 0 500 70,446 $ 0 0 $ SCHEDULE F 406 0 0 0 406 $ $ $ 3,367,502 730,764 11,000 1,312,742 5,422,008 Official County Budget Forms $ $ $ $ $ $ $ $ $ (90,093) $ (270) 0 (90,363) $ 1,808,347 23,658 50,000 1,882,005 $ 155,249 $ (28,000) 0 127,249 $ 4,121,611 158,979 223,327 4,503,917 $ (8,500) $ 5,000 0 (3,500) $ 1,381,487 238,341 12,074 1,631,902 $ (1,425) $ 0 1,812 0 387 $ 225,124 5,800 1,812 518 233,254 $ 0 0 56,220 0 56,220 $ $ 495,831 701 0 1,005 497,537 (1,750) $ 7,546 0 0 5,796 $ 489,547 7,546 79,954 600 577,647 $ (10,000) $ 3,160 (23,000) 8,662 275,324 33,693 0 (169) 0 0 0 (37,000) 71,000 7,687 (50,000) 43,659 0 (41,000) 3,493,501 16,061 77,212 180,801 879,864 162,279 151,930 4,831 611,832 24,529 22,649 88,570 71,000 121,940 2,000 723,893 31,932 0 $ $ Budgeted Expenditures/ Expenses 2022 2,210,540 25,317,226 $ 2,053,982 314,500 144,000 2,512,482 $ 4,271,044 0 223,327 4,494,371 $ 1,481,385 234,302 64,000 1,779,687 $ 223,824 40,821 0 2,600 267,245 $ 514,059 271,139 56,196 6,100 847,494 $ 513,888 0 143,802 7,100 664,790 $ 3,555,994 15,990 124,461 201,853 695,952 144,560 150,083 39,226 648,461 25,295 37,236 29,000 0 104,411 50,000 736,743 32,844 41,707 Official County Budget Forms Coconino County Expenditures/Expenses by Department Fiscal year 2022 Adopted Budgeted Expenditures/ Expenses 2021 Department/Fund Juv Court Security Improvement Department Total $ 0 6,470,002 Legal Defender: General Fund $ GF: Legal Def Fees for Svc ARS11-5 ACESF Grant Dependency AZ Title IV-E LD Legal Defender Train ARS 12-11 Department Total $ 1,337,131 46,362 0 0 3,684 1,387,177 Non-Departmental: General Fund $ PSPRS Contingency Debt Service Road Maintenance Sales Tax Department Total $ 2,855,844 0 0 2,855,844 Parks and Recreation: General Fund $ Fair Non-Interest P&R Grants RTP Grant-Ft Tuthill Trail Sys LWCF Grant-Bike Park & Restrm State Grants - P&R Miller Natural Resource Mgmt Parks Capital Projects Department Total $ 1,689,305 462,786 0 0 73,330 0 0 2,599,286 4,824,707 Public Defender: General Fund $ GF: Public Def Fees Svc ARS 11-584 BJA COVID-19 Emergency Funding Public Defender Training Public Def State Fill the Gap Dependency AZ Title IV-E PD Department Total $ 2,938,023 89,540 0 22,590 6,785 0 3,056,938 $ Department Total $ 827,636 827,636 Public Works: ACESF Grant $ Road Maintenance Sales Tax Public Works Solid Waste Vehicle License Tax Department Total $ Recorder: General Fund $ GF: Elections Warehouse Recorder's Storage & Retrieval HAVA Block Grant Recorder Private Grants Department Total $ Public Fiduciary: General Fund Sheriff: General Fund GF: Law Enforcement Retention Prog ACESF Grant $ $ $ Actual Expenditures/ Expenses* 2021 $ $ 0 6,633,816 $ 1,487,131 35,142 10,041 44,330 1,700 1,578,344 $ 1,381,919 46,364 0 27,126 3,684 1,459,093 (516,174) $ 18,160,000 0 17,643,826 $ 35,589,165 1,018,352 23,077 36,630,594 $ (4,932,463) $ 18,160,000 19,513 13,247,050 $ $ $ Budgeted Expenditures/ Expenses 2022 0 6,664,824 $ 150,000 0 10,041 44,330 0 204,371 $ $ 1,391,366 144,187 0 66,750 0 0 0 2,325,767 3,928,070 $ 0 $ 0 10,000 0 (4,693) 65,128 70,435 $ 2,718,647 62,000 10,000 18,940 1,492 33,715 2,844,794 $ 2,932,945 89,640 0 22,590 0 47,764 3,092,939 $ $ (6,000) $ (6,000) $ 756,694 756,694 $ $ 833,072 833,072 0 7,095,845 19,745,126 465,865 0 27,306,836 $ 18,380 $ (1,868,065) (716,240) 55,962 0 (2,509,963) $ 18,380 5,044,465 19,008,866 485,750 0 24,557,461 $ 0 9,779,052 24,031,404 483,080 346,003 34,639,539 2,743,714 109,000 368,868 0 0 3,221,582 $ 0 $ (7,300) 0 66,541 614,692 673,933 $ 2,605,658 98,663 167,720 66,541 614,692 3,553,273 255,734 $ (670,981) 43,069 11,058,431 52,000 16,800 $ $ $ $ 11,243,369 820,000 0 3/21 Arizona Auditor General Expenditure/ Expense adjustments approved 2021 3,303 285,319 (44,524) $ (257,147) 0 76,740 (73,330) 38,674 5,168 31,637 (222,782) $ $ SCHEDULE F $ 1,725,250 504,419 7,337 9,669 135,548 99,853 12,736 7,076 2,501,888 $ $ $ $ 1,954,047 101,700 501,868 0 0 2,557,615 $ $ 10,162,686 70,000 26,269 Official County Budget Forms Coconino County Expenditures/Expenses by Department Fiscal year 2022 Expenditure/ Expense adjustments approved 2021 Department/Fund Sheriff's Outside Pay Metro Unit Boat Patrol Sheriff Donations Sheriff State Grants Gov Ofc Hgwy Safety Grants 20. BJA-LLEBG 97LBVX4434 Statewide Gang Task Force State Homeland Security Grant COPS Methamphetamine Grant DUI Impound Fees Officer Safety Equipment Officer Equipment ARS 41-1724 Jail Enhancement Inmate Welfare Attorney General LE Funding Department Total $ Adopted Budgeted Expenditures/ Expenses 2021 22,175 115,127 213,303 22,000 0 0 20,000 235,496 4,220 153,569 111,214 9,000 70,000 444,539 403,131 0 13,887,143 Superintendent of Schools: General Fund $ County School Fund CCRASD#99 Title I National Forest Fees Classroom Site - CCRASD#99 Department Total $ 552,236 827,010 2,700,000 0 36,200 4,115,446 $ Superior Court: General Fund $ BJA COVID-19 Emergency Funding ACESF Grant Superior Crt State Fill the Gap IV-D Case Process Enhanc 93.56 AOC Adult Drug Court Grant Az License Plate Grant - Page Forest Highlands Foundation ADR Grant - Court Admin Court Enhancement Fund Conciliation Court AOC - DEA/DGVCCP Grant Law Library Court Security Improvement Department Total $ 4,275,885 0 0 503,863 29,456 80,000 3,000 6,000 51,818 170,529 70,369 41,877 237,872 41,416 5,512,085 $ Treasurer: General Fund $ Taxpayer Information Fund Department Total $ 813,813 31,000 844,813 $ 17,209,222 17,209,222 $ $ Unawarded Grants: Budget Planning $ Department Total $ All Functional Areas Actual Expenditures/ Expenses* 2021 5,208 67,163 237,055 3,000 0 1,123 379 53,298 46,026 0 30,000 5,000 22,064 177,559 181,030 16,000 11,972,136 0 (14,068) 0 0 10,000 2,404 0 (161,749) 73,346 (16,406) (26,792) 0 0 (206,582) (150,000) 27,000 (835,025) $ $ 0 139,821 0 1,121,863 0 1,261,684 $ $ $ $ $ 528,918 921,964 2,700,000 1,121,863 56,560 5,329,305 889,800 $ 48,008 46,692 (34,263) 0 34,263 0 0 0 10,000 0 0 (6,408) 0 988,092 $ 5,056,933 48,008 46,692 417,394 27,455 68,000 1,095 0 51,159 141,778 65,353 38,665 220,263 41,440 6,224,235 $ 0 0 0 $ 540,424 1,081,539 2,645,000 0 46,000 4,312,963 $ 4,030,923 0 0 497,394 24,340 100,000 3,000 4,516 53,220 176,717 71,771 39,772 251,544 0 5,253,197 $ $ $ 758,554 31,000 789,554 $ 831,226 31,000 862,226 (17,209,222) $ (17,209,222) $ 0 0 $ $ 35,285,889 35,285,889 $ $ Budgeted Expenditures/ Expenses 2022 17,635 88,786 190,036 22,000 0 0 20,000 204,943 73,346 0 70,000 9,000 70,000 403,039 414,254 27,000 11,868,994 (4,459,057) 190,450,191 177,799,201 276,633,204 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 Official County Budget Forms Coconino County Full-Time Employees and Personnel Compensation Fiscal year 2022 Full-Time Equivalent (FTE) 2022 Fund General Fund General Fund GF: Asset Repair & Repl Reserve GF: Legal Def Fees for Svc ARS 11-5 Total General Funds 553.09 0.70 0.00 553.79 Special Revenue Funds Recorder's Storage & Retrieval American Rescue Plan Adult Probation St Enhancement Adult Intensive Probation Work Furlough Program Drug Treatment & Education Deferred Prosecution Community Punishment Program Adult Probation Services Sheriff's Outside Pay Metro Unit Boat Patrol Statewide Gang Task Force Inmate Welfare County Jail District Flood Control District Public Works Solid Waste Superior Crt State Fill the Ga IV-D Case Process Enhance 93.56 ADR Grant - Court Admin Court Enhancement Fund Conciliation Court AOC - DEA/DGVCCP Grant Law Library Probate Enhancement Fees DES IV-D Grant Clerk's Forfeiture Fund 13.431 Juvenile Probation Service CASA-Special Advocate Juvenile Treatment Services Diversion-Consequences Juvenile Probation State Aid Diversion-Intake Juvenile Victim's Rights Impl Juvenile Diversion Fees Fund 0.00 1.00 14.50 14.10 0.54 1.00 3.30 0.50 6.00 0.00 0.50 2.00 2.50 4.00 184.50 4.17 111.15 0.50 3.12 0.23 0.50 0.00 0.50 0.29 1.75 0.60 0.66 0.55 1.56 2.75 7.12 1.45 1.78 7.30 0.50 0.68 $ Employee Salaries and Hourly Costs Retirement Costs Healthcare Costs Other Benefit Costs Total Estimated Personnel Compensation 2022 2022 2022 2022 2022 34,610,061 $ 41,729 8,800 34,660,590 $ $ $ 4,940 65,405 791,099 758,264 25,376 82,775 179,734 24,734 319,715 14,800 38,141 124,306 135,120 214,903 9,798,172 312,477 6,643,864 33,938 184,227 13,366 34,544 25,000 34,544 21,660 88,124 36,069 9,965 21,682 64,870 136,755 504,613 92,707 92,259 442,251 17,491 23,788 3/21 Arizona Auditor General $ $ Actual Expenditures/ Expenses* 2021 2,990,182 26,426,880 SCHEDULE F 3/21 Arizona Auditor General Coconino County Expenditures/Expenses by Department Fiscal year 2022 (Out) $ Expenditure/ Expense adjustments approved 2021 (11,000) $ 98,000 0 0 0 5,000 (5,500) 0 10,845 0 97,345 $ 3/21 Arizona Auditor General In 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Adopted Budgeted Expenditures/ Expenses 2021 $ Information Technology: General Fund $ GF: Financial Management System GF: Computer Lease/Buy Project Department Total $ Budgeted Expenditures/ Expenses 2022 Actual Expenditures/ Expenses* 2021 0 21,303,026 1,907,316 183,000 144,000 2,234,316 Official County Budget Forms Expenditure/ Expense adjustments approved 2021 Adopted Budgeted Expenditures/ Expenses 2021 Department/Fund COVID-19 Grants Department Total $ Human Resources: General Fund $ GF: Employee Benefit Trust GF: Self Insurance Trust Fund Department Total $ Coconino County Expenditures/Expenses by Fund Fiscal year 2022 Interfund transfers 2022 (Uses) General Fund General Fund $ GF: Employee Benefit Trust GF: Benefits Contingency GF: Computer Lease/Buy Project GF: Asset Repair & Repl Reserve GF: Elections Warehouse GF: PSPRS Contingency Reserve Fund American Rescue Plan Assessor Storage/Retrieval Adult Probation St Enhancement Adult Intensive Probation Drug Treatment & Education Deferred Prosecution Adult Probation Services Statewide Gang Task Force County Jail District Public Works Solid Waste Superior Crt State Fill the Ga ADR Grant - Court Admin Law Library DES IV-D Grant Family Counseling Juvenile Victim's Rights Impl Juvenile Intensive Probation Model Court-State Funds Atty VRIA:Victm Rghts 1761/179 Fair Parks Partnership Projects Legal Def State Fill the Gap Health District Senior Services Home Care Social Services Career Center State & Local Assistance Title III National Forest Fees KVID Paving Debt Service '92 Kachina Trail CID Debt Service Linda Lane Debt Service Anasazi Trails CID Debt Service PSPRS Contingency Debt Service Coconino County-Space Plan Anasazi Trails CID Construction Total General Fund $ $ $ SCHEDULE D Department/Fund $ County Improvement Districts Facilities Management Parks and Recreation Superintendent of Schools $ 8,017 0 3,303,507 3,750 0 18,420 0 0 14,138 88,990 0 1,500 0 0 0 0 0 62,218 59,865 0 322,412 0 13,324 124,666 409,094 21,851 42,149 15,628,186 Coconino County Expenditures/Expenses by Department Fiscal year 2022 Debt Service Funds County Improvement Districts Non-Departmental 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Expenditure/ Expense adjustments approved 2021 3,214,228 6,440,080 Adopted Budgeted Expenditures/ Expenses 2021 (Out) Official County Budget Forms Estimated revenues 2021 Adult Probation Board of Supervisors Clerk of Superior Court County Administration County Attorney County Improvement Districts County Jail District Emergency Management Finance Flood Control District Health and Human Services Justice Courts - Flagstaff Justice Courts - Fredonia Justice Courts - Page Justice Courts - Williams Juvenil Court Services Legal Defender Non-Departmental Parks and Recreation Public Defender Public Works Recorder Sheriff Superintendent of Schools Superior Court Treasurer Unawarded Grants In 0 0 0 3/21 Arizona Auditor General Coconino County Revenues Other than Property Taxes Fiscal year 2022 Source of revenues Special Revenue Funds 0 0 0 Total all Funds $ Interfund transfers 2022 (Uses) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Capital Projects Funds General Fund $ GF: Huffer Lane Escrow Account Title I National Forest Fees Total Capital Projects Funds $ Fund/Department 13,469,015 145,000 13,614,015 23,828,045 $ $ Fund Debt Service Funds General Fund $ Title I National Forest Fees Total Debt Service Funds $ 2022 10,214,030 Other financing 2022 Total All Funds 2021 Coconino County Expenditures/Expenses by Department Fiscal year 2022 5,295,061 $ 5,178 5,300,239 $ $ 0 8,114 291,020 239,560 3,996 29,774 54,387 3,070 115,003 1,551 2,909 12,728 13,282 21,150 975,717 38,941 801,818 4,235 46,760 4,588 4,286 0 4,287 13,347 10,495 4,477 1,200 2,691 12,499 17,002 60,878 17,023 27,727 87,206 2,170 2,953 $ 6,019,011 $ 8,605 6,027,616 $ 2,973,319 $ 3,475 764 2,977,558 $ 48,897,452 58,987 9,564 48,966,003 0 8,434 152,680 137,496 15,524 15,187 50,117 0 77,616 0 4,217 23,621 36,699 53,995 1,964,874 55,244 1,262,553 4,216 31,064 1,940 4,216 0 4,218 4,405 8,821 0 0 7,407 7,754 19,695 79,769 19,996 12,678 76,976 4,217 8,640 428 5,313 66,985 64,271 1,842 6,863 14,319 1,959 26,438 1,284 4,467 14,981 17,342 24,106 1,107,401 27,185 712,493 3,684 13,238 696 2,774 2,167 2,772 360 7,163 2,856 765 1,594 5,581 11,231 41,692 7,334 7,822 36,506 1,417 1,855 5,368 87,266 1,301,784 1,199,591 46,738 134,599 298,557 29,763 538,772 17,635 49,734 175,636 202,443 314,154 13,846,164 433,847 9,420,728 46,073 275,289 20,590 45,820 27,167 45,821 39,772 114,603 43,402 11,930 33,374 90,704 184,683 686,952 137,060 140,486 642,939 25,295 37,236 $ SCHEDULE G $ Official County Budget Forms Coconino County Full-Time Employees and Personnel Compensation Fiscal year 2022 Fund Full-Time Equivalent (FTE) Employee Salaries and Hourly Costs Retirement Costs Healthcare Costs Other Benefit Costs Total Estimated Personnel Compensation 2022 2022 2022 2022 2022 2022 CASA VOCA Juvenile Intensive Probation Model Court-State Funds Attorney Enhancement Atty VRIA:Victm Rghts 1761/179 Drug Prosecution 16.579 CJ Records Impv 16.579 State Aid SB1013 SB11-539 VOCA-Victims of Crimes Fair Dependency AZ Title IV-E PD Dependency AZ Title IV-E LD Federal Grants State Grants Private Grants Health District WIOA Senior Services Home Care Social Services Self-funded Programs COVID-19 Grants Fredonia JC Court Enhancement Page JC Court Enhancement Williams JC Court Enhancement Flag JC Enhancement Fund State & Local Assistance County School Fund Total Special Revenue Funds 1.58 6.80 0.40 2.00 1.50 1.00 1.00 1.00 2.45 0.24 0.40 26.33 16.03 1.00 49.88 10.04 9.92 2.80 8.30 1.28 0.00 0.00 0.00 0.25 2.25 4.00 5.14 537.19 $ Capital Projects Funds Coconino County-Space Plan Total Capital Projects Funds 2.00 2.00 $ $ Internal Service Funds Mechanical Services Total Internal Service Fund 10.20 10.20 $ $ 525,664 525,664 Total all Funds 1,103.18 $ 67,772,189 $ 3/21 Arizona Auditor General 63,734 406,074 21,908 4,800 75,185 126,819 37,037 47,581 37,037 184,279 20,244 22,059 1,463,428 824,988 62,547 3,366,951 612,946 476,535 103,777 432,340 90,148 1,629,380 4,001 18,000 29,613 125,166 285,249 507,561 32,491,065 $ 94,870 $ 94,870 $ $ $ SCHEDULE G 7,909 130,505 2,719 0 9,331 15,738 4,596 5,309 4,596 17,509 2,512 2,738 170,652 101,828 7,762 402,698 67,118 49,945 12,880 46,172 11,203 0 0 0 1,193 11,809 34,558 33,528 4,091,652 $ 11,773 $ 11,773 $ 65,734 65,734 $ $ 9,469,398 $ 15,187 80,060 3,374 0 8,821 14,340 15,187 8,434 8,434 29,039 0 155 224,418 173,680 8,434 569,743 118,846 67,472 32,055 60,661 15,985 0 0 0 2,109 24,042 46,804 32,055 5,713,604 $ 30,374 $ 30,374 $ 114,730 114,730 $ $ 11,886,324 $ 4,733 33,909 1,763 417 6,366 9,938 2,844 3,899 3,026 17,462 1,618 1,774 115,675 67,064 5,009 266,096 47,301 40,243 9,235 33,543 6,612 46,806 320 1,439 2,387 9,785 23,919 37,133 3,049,500 $ 7,545 $ 7,545 $ 50,337 50,337 $ $ 6,084,940 $ 91,563 650,548 29,764 5,217 99,703 166,835 59,664 65,223 53,093 248,289 24,374 26,726 1,974,173 1,167,560 83,752 4,605,488 846,211 634,195 157,947 572,716 123,948 1,676,186 4,321 19,439 35,302 170,802 390,530 610,277 45,345,821 144,562 144,562 756,465 756,465 95,212,851 Official County Budget Forms June 10, 17, 2021 338

Welcome to the discussion.

Keep it Clean. Please avoid obscene, vulgar, lewd, racist or sexually-oriented language.
PLEASE TURN OFF YOUR CAPS LOCK.
Don't Threaten. Threats of harming another person will not be tolerated.
Be Truthful. Don't knowingly lie about anyone or anything.
Be Nice. No racism, sexism or any sort of -ism that is degrading to another person.
Be Proactive. Use the 'Report' link on each comment to let us know of abusive posts.
Share with Us. We'd love to hear eyewitness accounts, the history behind an article.