MID-YEAR WORKSHEETS.XLSX

Sheriff's FY 2016 Mid-Year Grant Fund (251) Appropriation Adjustment
C-50-16
Current FY 2016
Revised New Revised (Fund Current Current
(Fund 251 Mid-Year Adjustment 251 All funding Forecast Forecast Forecast Forecast Forecast Current Revised Current Revised Current Revised Revised Revised
Org All Revenue) (Agenda) Sources) 0615 0620 0637 0645 0650 615 620 637 645 650
5040 664,308 (182,676) 481,632 29,910 451,582 140 34,308 630,000
5046 789,465 (2,155) 787,310 647,060 140,000 250 674,465 115,000
5053 45,748 26,402 72,150 60,000 12,150 45,748 - - - -
5056 3,000 (3,000) - - 3,000 -
5062 3,508,196 463,157 3,971,353 592,528 2,258,325 1,119,500 1000 611,528 2,296,568 600,000 100
5063 142,284 (8,453) 133,831 94,831 39,000 94,978 47,306
5073 25,000 (5,000) 20,000 20,000 25,000 -
5081 1,047,437 238,165 1,285,602 1,183,137 102,465 1,047,437 -
5084 86,708 (86,708) - - - - 86,708
5113 25,000 1,293 26,293 26,293 25,000 -
5126 209,585 - 209,585 209,585 209,585
5143 284,200 (63) 284,137 283,987 150 284,200 -
5930 354,054 (29,634) 324,420 168,500 155,520 400 201,054 153,000
$ 7,184,985 $ 411,328 $ 7,596,313 $ 3,315,831 $ 3,146,892 $ 1,119,500 $ 1,940 $ 12,150 3,256,303 3,328,582 600,000 100 - $ 7,184,985
Forecast 3,315,831 3,146,892 1,119,500 1,940 12,150 $ 7,596,313
Adjustment $ 59,528 $ (181,690) $ 519,500 $ 1,840 $ 12,150 $ 411,328
Check 59,528 (181,690) 519,500 1,840 12,150 $ 411,328
Org 5062 Detail
Amount Source
$ (19,000) 615 Grants
(38,243) 620 Intergovernmental
519,500 637 Fines/Forfeitures
900 645 Interest
$ 463,157
Prepared by: Capri M. Jungels 11/16/2015

FY 2016 Mid Year Adjustment --Fund 251 Object 0615
Dept: 50
Fund: 251
FY 2016 Original FY2016 Mid Year
Grant Source Grant Start Date End Date Org Activity Rptg Cat Adjustment
Submission Forcast
State DUI Enforcement Abatement Council 6/1/2015 5/31/2016 5046 PATR ABT6 130,000 50,000 (80,000)
State DUI Enforcement Abatement Council 11/1/2015 6/30/2015 5046 PATR ABT7 - 30,100 30,100
Federal GOHS Speed/STEP Enforcement/Equipment 10/2/2014 9/30/2015 5046 PATR AGR5 25,829 27,048 1,219
Federal GOHS Speed/STEP Enforcement/Equipment 10/1/2015 9/30/2016 5046 PATR AGR6 35,000 25,260 (9,740)
State AZ Game & Fish Boating Law Enforcement FY14 7/1/2014 6/30/2015 5046 PATR BLE5 20,000 - (20,000)
State AZ Game & Fish Boating Law Enforcement FY15 7/1/2015 6/30/2016 5046 PATR BLE6 300,000 360,000 60,000
Federal Homeland Security - Incident Communication 10/1/2015 9/30/2016 5081 DSTR COM5 - 20,000 20,000
Federal GOHS DRE Certification 10/1/2015 9/30/2016 5073 TRAG DRE6 25,000 20,000 (5,000)
Federal GOHS DUI Detention Support 10/1/2014 9/30/2015 5113 INTR DSO5 5,000 6,293 1,293
Federal GOHS DUI Detention Support 10/1/2015 9/30/2016 5113 INTR DSO6 20,000 20,000 -
Federal GOHS DUI Task Force Enforcement 10/1/2014 9/30/2015 5046 PATR DUI5 31,636 31,760 124
Federal GOHS DUI Task Force Enforcement 10/1/2015 9/30/2016 5046 PATR DUI6 30,000 50,000 20,000
Federal GOHS Underage Drinking Enforcement 10/1/2015 9/30/2016 5046 PATR UDE6 - 20,000 20,000
Federal Part B-IDEA Entitlement 7/1/2014 6/30/2015 5930 IEPA ENT5 38,720 5,100 (33,620)
Federal Part B-IDEA Entitlement 7/1/2015 6/30/2016 5930 IEPA ENT6 140,000 140,000 -
Federal Homeland Security - EOD Reallocation 4/1/2015 7/31/2015 5081 DSTR EOD5 - 53,550 53,550
Federal Homeland Security - Emergency Operatons Room 10/1/2014 9/30/2015 5081 DSTR EOR4 82,500 69,215 (13,285)
Federal GOHS DUI Enforcement (Warrant Apprehension) 10/1/2014 9/30/2015 5063 INVT EWA5 13,667 16,970 3,303
Federal GOHS DUI Enforcement (Warrant Apprehension) 10/1/2015 9/30/2016 5063 INVT EWA6 17,133 20,000 2,867
Federal GOHS Fatality Collision Inv & Reconstruction Training 10/1/2014 9/30/2015 5063 INVT FCI5 27,178 26,700 (478)
Federal GOHS Fatality Collision Inv & Equipment 10/1/2015 9/30/2016 5063 INVT FCI6 27,000 27,000 -
Federal UASI-RRT Storage Facility Generator 6/1/2014 5/31/2015 5081 DSTR GEN5 46,340 89,000 42,660
Federal UASI-RRT Storage Facility Generator Supplement 2/1/2015 7/31/2015 5081 DSTR GEN6 25,000 23,300 (1,700)
Federal HIDTA - MCDST 1/1/2014 12/31/2015 5062 INVT HID5 36,000 2,000 (34,000)
Federal HIDTA - MCDST 1/1/2015 12/31/2016 5062 INVT HID6 300,000 205,000 (95,000)
Federal HIDTA - MCDST 1/1/2016 12/31/2017 5062 INVT HID7 200,000 270,000 70,000
Federal GOHS DUI Task Force Equipment 10/1/2015 9/30/2016 5046 PATR IMP6 35,000 - (35,000)
Federal HIDTA Intelligence Support Center FY14 1/1/2014 12/31/2015 5062 INVT ISC5 38,801 38,801 -
Federal HIDTA Intelligence Support Center FY15 1/1/2015 12/31/2016 5062 INVT ISC6 36,727 36,727 -
Federal BJA - INET 10/1/2015 9/30/2018 5062 INVT JAG5 - 40,000 40,000
State AATA - Law Enforcement - Auto Theft 7/1/2014 6/30/2015 5063 INVT LEP6 10,000 4,161 (5,839)
Federal Homeland Security SHSGP - AZLink Maintenance 10/1/2013 8/31/2015 5081 DSTR LNK3 120,000 100,000 (20,000)
Federal Homeland Security SHSGP - AZLink Maintenance 10/1/2014 9/30/2015 5081 DSTR LNK5 120,000 120,000 -
Federal PREA MCSO Demenstration grant 10/1/2014 9/30/2016 5126 MANS PRE5 209,585 209,585 -
Federal Homeland Security - Interoperability 10/1/2014 9/30/2015 5081 DSTR RAD5 105,000 102,000 (3,000)
Federal Rapid Response Team Sustainment 10/1/2014 9/30/2015 5081 DSTR RRC4 110,000 96,000 (14,000)
Federal Rapid Response Team Sustainment 10/1/2015 9/30/2016 5081 DSTR RRC5 100,000 100,000 -
Federal Residential Substance Abuse Alpha Program 1/1/2015 12/31/2015 5053 IARP RSA5 22,874 30,000 7,126
Federal Residential Substance Abuse Alpha Program 1/1/2016 12/31/2016 5053 IARP RSA6 22,874 30,000 7,126
Federal Secure Care 10/1/2014 9/30/2015 5930 IEPA SEC5 12,334 3,400 (8,934)
Federal Secure Care 10/1/2015 9/30/2016 5930 IEPA SEC6 10,000 20,000 10,000
Federal GOHS Speed/STEP Enforcement/Equipment 10/1/2014 9/30/2015 5046 PATR STC5 10,000 6,200 (3,800)
Federal GOHS Speed/STEP Enforcement/Equipment 10/1/2013 9/30/2014 5046 PATR STP5 47,000 37,992 (9,008)

Other Target Corporation 7/1/2014 6/30/2015 5056 ENFO TBP6 3,000 - (3,000)
Federal GOHS Buckle Up AZ (Click it or Ticket) 5/1/2015 6/30/2015 5046 PATR TIC5 10,000 8,700 (1,300)
Federal GOHS Buckle Up AZ (Click it or Ticket) 5/1/2016 6/30/2016 5046 PATR TIC6 - - -
Federal TLO Sustainment 10/1/2013 8/31/2015 5081 DSTR TLO4 56,562 34,000 (22,562)
Federal TLO Sustainment 10/1/2014 9/30/2015 5081 DSTR TLO6 195,963 240,000 44,037
Federal TLO Sustainment 12/1/2014 7/31/2015 5081 DSTR TLO7 86,072 86,072 -
Federal TLO Sustainment 10/1/2015 9/30/2016 5081 DSTR TLO8 - 50,000 50,000
Federal ADOT Highway Safety Improvement Program 2/1/2014 6/30/2015 5040 PATR TRC4 34,308 29,910 (4,398)
State Victim's Rights Program 7/1/2015 6/30/2016 5143 IIAR VIC6 284,200 283,987 (213)
State Victim's Rights Program 7/1/2014 6/30/2015 5143 IIAR VIC5 - - -
TOTAL GRANT REVENUE 3,256,303 3,315,831 59,528
615 3,256,303 3,315,831 59,528
620 3,328,582 3,146,892 (181,690)
637 600,000 1,119,500 519,500
645 100 1,940 1,840
650 - 12,150 12,150
Revenue Total 7,184,985 7,596,313 411,328

FY 2016 Mid Year Adjustment --Fund 251 Object 0620
Dept: 50
Fund: 251
Fund Func Org Rptg Cat Activity Description Start Date End Date Revenue Source Description
251 0000 5062 CTF5 INVT Customs Enforcement 10/1/2014 9/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 CTF6 INVT Customs Enforcement 10/1/2015 9/30/2016 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 DEA5 INVT DEA Task Force 10/1/2014 9/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 DEA6 INVT DEA Task Force 10/1/2015 9/30/2016 0620 - OTHER INTERGOVERNMENTAL
251 0000 5084 DLO5 JIAS Detention Liaison Officer 7/1/2014 6/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5084 DLO6 JIAS Detention Liaison Officer 7/1/2015 6/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5046 FSE5 PATR Coop Law Enforcement 10/1/2014 9/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5046 FSE6 PATR Coop Law Enforcement 10/1/2015 9/30/2016 0620 - OTHER INTERGOVERNMENTAL
251 0000 5063 FTF5 INVT Fugitive Task Force (1 people) 10/1/2014 9/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5063 FTF6 INVT Fugitive Task Force (2 people) 10/1/2015 9/30/2016 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 GTM5 INVT Drug Smuggling (State Appropriation) 7/1/2015 6/30/2016 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 GTM6 INVT Drug Smuggling (State Appropriation) 7/1/2015 6/30/2016 0620 - OTHER INTERGOVERNMENTAL
Law Enforcement Safety Equipment (State
251 0000 5040 LES6 PATR Appropriation) 7/1/2015 6/30/2016 0620 - OTHER INTERGOVERNMENTAL
Law Enforcement Safety Equipment (State
251 0000 5040 LES5 PATR Appropriation) 0620 - OTHER INTERGOVERNMENTAL
Law Enforcement Safety Equipment (State
251 0000 5040 LES4 PATR Appropriation) 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 IRS5 INVT IRS Task Force 10/1/2014 9/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 IRS6 INVT IRS Task Force 10/1/2015 9/30/2016 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 OCE5 INVT DEA Task Force Organized Crime Drug Enforcemen 10/1/2014 9/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 OCE6 INVT DEA Task Force Organized Crime Drug Enforcemen 10/1/2015 9/30/2016 0620 - OTHER INTERGOVERNMENTAL
5073 PST1 TRAG E-Learning Network Overtime 0620 - OTHER INTERGOVERNMENTAL
251 0000 5930 STE4 IEPA State Entitlement 7/1/2013 6/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5930 STE5 IEPA State Entitlement 7/1/2014 6/30/2016 0620 - OTHER INTERGOVERNMENTAL
251 0000 5930 STE6 IEPA State Entitlement 7/1/2014 6/30/2016 0620 - OTHER INTERGOVERNMENTAL
251 0000 5084 SWG5 JIAS Statewide Gang Task Force 7/1/2014 6/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5084 SWG6 JIAS Statewide Gang Task Force 7/1/2015 6/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 TUC5 INVT DEA Phoenix Task Force/Tucson 10/1/2014 9/30/2015 0620 - OTHER INTERGOVERNMENTAL
251 0000 5062 TUC6 INVT DEA Phoenix Task Force/Tucson 10/1/2015 9/30/2016 0620 - OTHER INTERGOVERNMENTAL

FY 2016
FY2016 Mid
Original Adjustment
Year Forcast
Sub Revenue Source Description Submission
00 - OTHER INTERGOVERNMENTAL 8,000 13,000 5,000
00 - OTHER INTERGOVERNMENTAL 20,000 30,000 10,000
00 - OTHER INTERGOVERNMENTAL 6,000 1,810 -4,190
00 - OTHER INTERGOVERNMENTAL 15,000 40,000 25,000
00 - OTHER INTERGOVERNMENTAL 4,130 4,810 680
00 - OTHER INTERGOVERNMENTAL 38,478 48,000 9,522
00 - OTHER INTERGOVERNMENTAL 75,000 90,000 15,000
00 - OTHER INTERGOVERNMENTAL 40,000 50,000 10,000
00 - OTHER INTERGOVERNMENTAL 8,601 13,000 4,399
00 - OTHER INTERGOVERNMENTAL 38,705 26,000 -12,705
00 - OTHER INTERGOVERNMENTAL 0 0 0
00 - OTHER INTERGOVERNMENTAL 1,600,000 1,600,000 0
00 - OTHER INTERGOVERNMENTAL 630,000 100,000 -530,000
00 - OTHER INTERGOVERNMENTAL 0 197,447 197,447
00 - OTHER INTERGOVERNMENTAL 0 154,135 154,135
00 - OTHER INTERGOVERNMENTAL 3,498 5,015 1,517
00 - OTHER INTERGOVERNMENTAL 15,000 10,500 -4,500
00 - OTHER INTERGOVERNMENTAL 229,070 210,000 -19,070
00 - OTHER INTERGOVERNMENTAL 350,000 335,000 -15,000
0 0 0
00 - OTHER INTERGOVERNMENTAL 0 0 0
00 - OTHER INTERGOVERNMENTAL 0 0 0
00 - OTHER INTERGOVERNMENTAL 153,000 155,520 2,520
00 - OTHER INTERGOVERNMENTAL 4,100 1,655 -2,445
00 - OTHER INTERGOVERNMENTAL 40,000 48,000 8,000
00 - OTHER INTERGOVERNMENTAL 10,000 13,000 3,000
00 - OTHER INTERGOVERNMENTAL 40,000 0 -40,000
620 3,328,582 3,146,892 (181,690)

FY 2016 Mid Year Adjustment --Fund 251 Object 0637/0645/0650
Dept: 50
Fund: 251
FY 2016 Original FY2016 Mid Year
Adjustment
Submission Forcast
Fund Func Org Rptg Cat Activity Description Start Date End Date Revenue Source Description Sub Revenue Source Description
251 0000 5062 HPI6 INVT HIDTA-MCDST Forfeiture Funds 1/1/2015 12/31/2016 0637 - FINES AND FORFEITS 00 - FINES & FORFEITS 600,000 1,100,000 500,000
251 0000 5062 HPI4 INVT HIDTA-MCDST Forfeiture Funds 1/1/2014 12/31/2015 0637 - FINES AND FORFEITS 00 - FINES & FORFEITS 0 19,500 19,500
251 0000 5040 LES6 PATR DPS - Public Safety 7/1/2015 6/30/2017 0645 - INTEREST EARNINGS 00 - INTEREST EARNINGS 0 140 140
251 0000 5046 BLE6 PATR Boating Law Enforcement 7/1/2015 12/31/2016 0645 - INTEREST EARNINGS 00 - INTEREST EARNINGS 0 250 250
251 0000 5062 VAR INVT Various funding 7/1/2015 12/31/2016 0645 - INTEREST EARNINGS 00 - INTEREST EARNINGS 100 1,000 900
251 0000 5143 VIC6 IIAR Victims' Rights Program 7/1/2015 6/30/2016 0645 - INTEREST EARNINGS 00 - INTEREST EARNINGS 0 150 150
251 0000 5930 STE6 IEPA Jail Education Program 7/1/2015 6/30/2017 0645 - INTEREST EARNINGS 00 - INTEREST EARNINGS 0 400 400
251 0000 5053 PET5 ISTP PetSmart Charities 6/1/2015 9/30/2015 0650 - MISC EARNINGS 00 - MISC EARNINGS 0 12,150 12,150
637 600,000 1,119,500 519,500
645 100 1,940 1,840
650 - 12,150 12,150