Loading...
HomeMy WebLinkAboutResolutions - 2004.03.04 - 27578MISCELLANEOUS RESOLUTION 104049 March 4, 2004 BY: Public Services Committee, Hugh D. Crawford, Chairperson IN RE: SHERIFF'S OFFICE - CY2004 AND CY2005 AUTOMOBILE THEFT PREVENTION AUTHORITY GRANT ACCEPTANCE To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS the Automobile Theft Prevention Authority (ATPA) has awarded the Auto Theft Unit of the Oakland County Sheriff's Office grant funding in the amount of $431,139 for the period January 1, 2004 through December 31, 2004, and $432,722 for the period January 1, 2005 through December 31, 2005 which is $6,498 less than the application amount for CY 2004 and $6,747 less than the application amount for CY 2005; and WHEREAS this is the eighteenth (18) and nineteenth (19) years of funding requests to ATPA; and WHEREAS the police departments of Waterford and Pontiac have been included in the grant awarded to Oakland County, while the police departments for Madison Heights and Hazel Park will be requesting their own funding; and WHEREAS Oakland County has been awarded $297,956, with a required $99,318 in County match, the Waterford Police Department has been awarded $73,013, with a required Local Jurisdiction match of $24,337 and the Pontiac Police Department has been awarded $60,170, with a required Local Jurisdiction match of $20,057 for a total program cost of $574,851 for CY 2004; and WHEREAS Oakland County has been awarded $295,796, with a required $98,598 in County match, the Waterford Police Department has been awarded $75,366, with a required Local Jurisdiction match of $25,122 and the Pontiac Police Department has been awarded $61,560, with a required Local Jurisdiction match of $20,520 for a total program cost of $576,962 for CY 2005; and WHEREAS Oakland County receives grant funding from the Automobile Theft Prevention Authority (ATPA) under provisions of Public Act 10 of 1986; and WHEREAS the grant conditions issued by the ATPA allow for funds received or generated as a result of automobile theft activities. The funds may be used to enhance automobile theft prevention programs; and WHEREAS funding in the amount of $20,295 is available as of February 1, 2004 from the confiscation and sale of stolen vehicles through the efforts of the Oakland County Automobile Theft Prevention Unit; and WHEREAS the Sheriff's Office is requesting a portion of these funds be utilized to provide County match requirements on the purchase of one (1) GPS unit during the CY 2004 grant year operation; and WHEREAS the estimated cost of the County match equals $2,450; and WHEREAS the staffing level is the same as the CY 2003 program year and no personnel changes were requested with the CY 2004 award with funding covering four (4) Deputy II positions as follows: Position numbers #6108, #6109, #6147 and #6148 located in Division 439 Unit 15 Sheriff Special Teams; and WHEREAS funds are available in the Non-Departmental Grant Match line-item (#90-101-290000-25000-2872) to cover the balance of the required county match of $96,868 ($99,318 - $2,450) for CY 2004 and $98,598 for CY 2005; and WHEREAS acceptance of this grant does not obligate the County to any future commitment; and WHEREAS the grant agreement has been approved through the County Executive's Contract Review Process. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners accepts the CY 2004 Automobile Theft Prevention Grant in the amount of Public Services Committee Vote: Motion carried on a roll call vote with Potter absent. $431,139 ($297,956 Oakland County Sheriff's Department, $73,013 Waterford Police Department, $60,170 Pontiac Police Department) with a County match of $99,318 and a participating jurisdiction match of $24,337 (Waterford) and $20,057 (Pontiac) BE IT FURTHER RESOLVED that the Oakland County Board of Commissioners accepts the CY 2005 Automobile Theft Prevention Grant in the amount of $432,722 ($295,796 Oakland County Sheriff's Office, $75,366 Waterford Police Department, $61,560 Pontiac Police Department with a County match of $98,596 and a participating jurisdiction match of $25,122 (Waterford) and $20,520 (Pontiac). BE IT FURTHER RESOLVED that the Oakland County Board of Commissioners authorizes the use of $2,450 of forfeited funds from the Sheriff Department's Auto Theft Prevention Funds account for County match purposes in the purchase of one (1) GPS unit. BE IT FURTHER RESOLVED that the agreement and to approve grant modifications and extensions, within fifteen (15) percent of the original award, consistent with the grant agreement approved. BE IT FURTHER RESOLVED that the future level of service, including personnel, is contingent upon continued grant funding for this program. Chairperson, on behalf of the Public Services Committee, I move the adoption of the foregoing resolution. PUBLIC SERVICES COMMITTEE Joe Matkosky From: Greg Givens [givensgRco.oakland,mi.us] Sent: Tuesday, February 17, 2004 10:48 AM To: Wedell, Harvey; Banycky, Kevin Cc: cumminghamd@co.oakland.mi,us; Matkosky, Joe; Smith, Laverne; Frederick, Candace; Worthington, Pam Subject: CONTRACT REVIEW — Sheriffs Department C,)hTkACT REVIEW ::,iieritt's Deportment MME: Al_lt.Q Theft Prevention Gran': (G-08-04) !illIDING AGENCY: Michigan Automobile Prevention Autnulitif DEPARTMENT CORTA.0 PERSON: Sgt. :Kevin. Banycky / B52OR SiATUS: Acceptande DATE: February 17, 2034 HJ:d-51Jant lo Misc. P,esolution ii02320, please be advised the captioneo dr:J:1r materia -H hAve completed internal contract review. 2elow ate 'Pe comments returned by review departmens. Review comments were also received from IT and listed below. These cormnents require no oontl ict or project chances. dopertment oil Mo:lacement and Budget: Approved. - Lauri Van Pelt (2/5/2004) :dasdtseel Depattm ,,:at: Approved. - Ed Poisson (2/4/20 Rianagemen:. aud Approved by Risk hkwagemerit. - Julie Gecontine (2/10/20 1 )1) Corporation Counsel: Atter revIewinc the 2004-200:3 Aura Theft Prevention AuthoLity Gran', there are no legal issues that must be resolved betore the grant is iccopted. Please let: me know it you have any further questions. - Oody :;chffer (2/10/2004) Additional Comment tree: IT: After reviewing the information provided, we understand that this soltion includes 6 GIS softwalc interface (MapInto) for the dispJac and anoiysis of the intdrmation received from the UPS tracking device. The Lntertace is not software Chit the GS Utility supports, but gdon 'hit it is included and interfaced in the package, it appears to Oct an efteotive option for the applic,ation. - Tarmtd Shepherd (2/17/2004) REPORTS REPORTING PERIOD DUE DATES Financial and Progress Reports (Form EX-36 & EX-37) 1 -1 -04 To 3-31-04 4-30-04 Financial and Progress Reports (Form EX-36 & EX-37) 4-1 -04 To 6-30-04 7-31-04 Financial and Progress Reports (Form EX-35 & EX-37) 7-1 -04 To 9-30-04 10-31-04 Financial and Progress Reports 'on EX-36 & EX-37) 10-1-04 To 12-31-04 1-31-05 Note: Retain a copy for your files. Automobile Theft Prevention Authority 714 South Harrison Road East Lansing, MI 48823 Phone: (517) 336-6197 AUTHORITY 1992 PA 174 COMPLIANCE: Required PENALTY: Cancellation of grant/loss of funds, MSP-EX-43 (12-96) ATPA PROJECT ORIENTATION MEETING REPORT - PAGE 1 is report is a summary of the issues discussed during the orientation meeting. It serves as an addendum to the grant. — 1. NAME OF GRANTEE 2. ORIENTATION MEETING DATE Oakland County Sheriff Department December 9, 2003 3. PROJECT TITLE Oakland County Auto Theft Unit 4. MEETING CONDUCTED BY _ Mr, Valdis Vitols, Ms. Chalouy "Newt" Shoup, and Mr. David Tjepkema 5, PRO,QRAM,PSONO .EL 4TT,0101ING (NAME AND RANK OR TITLE) ,AP7.4A4-)6<:e.W44.,7 ,5 )/L/0/. 6. FINANCIAL PERSONNEL ATTENDING (NAME AND RANK OR TITLE) MO AWX/eW j,-4,/2c-6-7 7. PROGRAM AND FINANCIAL SUMMARY A. The project number written above must be included on all correspondence addressed to the ATPA regarding this grant. B. Change in project director, financial officer, authorizing official, or participating agency requires written notification to the ATPA. C. All funded jurisdictions must comply with ucR requirements, Any jurisdiction not in compliance will be ineligible for grant funds. D. Grant reporting forms were discussed. The ATPA will supply a packet of reporting forms containing program progress reports (Form EX-37), financial reports (Form EX-36), and project modification request forms (Form EX-34) with instructions. (These forms can be downloaded from the ATPA Website - www.miatpa.org) The grantee agrees to submit reports in accordance with the report schedule provided below, E. Grantees will be required to provide an overview of grant activity in December. An annual summary of arrest charges and arrest locations is required of law enforcement grants. F. The project's measurable objectives and evaluation criteria, as stated in the original grant application, were reviewed and modifications are indicated on attachment page 1A. The grantee agrees not to make any modification of the approved project without the written approval of the ATPA. Program modifications will not be considered after the first quarter. G. ATPA staff will make appointments with grant personnel in order to conduct on-site project and financial reviews. H. All projects must maintain adequate documentation for performance activity reported to the ATPA. Failure to provide evidence supporting the grant's activity may adversely affect current year reimbursements and/or future funding requests. Project No: 08 -04 RETURN ONE COMPLETE SET WITH ORIGINAL SIGNATURES TO: MSP EX 43 (12 96) Project No: ATPA PROJECT ORIENTATION MEETING REPORT - PAGE 2 08-04 8. FINANCIAL REVIEW AND SUMMARY A. A separate project fund or account must be established for grant revenues and expenditures. B. All payments for salaries and wages must be supported by payroll records and daily activity logs. Retain documentation in your files. Overtime hours may not exceed five percent of the total regular hours reported. C. All payments for expenditures such as utilities, office rental, copier use, vehicle rental, furniture and equipment purchases, etc., must be supported by an actual invoice or the method of determining cost. Supporting documentation must be included with the financial report. D. All overnight out-of-state travel requires prior notification to ATPA staff, and the ATPA will only reimburse salary expenses. E. The grantee agrees not to make any budget modification of the approved project without written approval of the ATPA. Budget modifications shall be submitted to the ATPA in writing in advance of the need for change. All requests for budget modifications must be received prior to the submission of the fourth quarter financial report. Any budget modifications for 2004 grants postmarked after Jan Jary 31. 2005, will not be approved. F. Public communications materials or news releases that result from this grant must cite the "Automobile Theft Prevention Authority' as the source of funding and copies of the materials or news releases must be sent to the ATPA. The ATPA also has the royalty-free right to copy, publish and distribute any data or material associated with this grant. G. Any funds received or generated as a result of auto theft activities shall be used to enhance currently funded and/or future auto theft prevention programs. Funds received include, but are not limited to, forfeiture of cash and receipts from sale of property. If project enhancement activities are terminated, the unexpended revenues shall be promptly returned to the Automobile Theft Prevention Authority, 714 S. Harrison Road, East Lansing, MI 48823. 9. PRIOR TO DISBURSEMENT OF FUNDS, THE FOLLOWING MUST BE COMPLIED WITH: A. A complete set of the ATPA Project Orientation Meeting Report must be returned to the ATPA. B. A signed advance agreement must be returned to the ATPA. 10. AGREEMENT The undersigned has the authority to accept the terms of this report as an addendum to the grant. 11. PRINT NAME AND RANK OR TITLE 12. SIGNATURE 13. DATE 14. ATPA EXECUTIVE DIRECTOR 15. SIGNATU , 16. DATE , Valdis Vitols ti4 , 7°) December 1, 2003 11/7/2003 3:18 PM OAKLAND COUNTY SHERIFF DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD COMBINED BUDGET DETAIL G-8-04 2004 PROGRAM 2005 PROGRAM TOTAL ATPA GRANTEE TOTAL ATPA GRANTEE TOTAL APPROVED SHARE SHARE APPROVED SHARE SHARE 2004 AND BUDGET 75% 25% BUDGET 75% 25% 2005 SWORN EMPLOYEES Salaries & Wages: (4) Sheriff Deputies 227,919 170,939 56,980 232,477 174,358 58,119 460,396 Overtime 17,093 12,820 4,273 17,435 13,076 4,359 34,528 P. Officer-Waterford Twp PD 68,000 43,500 14,500 60,320 45,240 15,080 118,320 Overtime 4,350 3,263 1,088 4,524 3,393 1,131 8,874 P.Officer-Madison Heights PD 53,514 40,136 13,379 55,119 41,339 13,780 108,633 Overtime 4,014 3,011 1,004 4,134 3,101 1,034 8,148 P. Officer-Hazel Park PD 55,202 41,402 13,801 56,855 42,641 14,214 112,057 Overtime 4,140 3,105 1,035 4,264 3,198 1,066 8,404 P. Officer-Pontiac PD 49,005 36.754 12,251 50,475 37,856 12,619 99,480 Overtime 3,675 2,756 919 3,785 2.839 946 7,460 Employees Benefits: (4) Sheriff Deputies: FICA 17,436 13,077 4,359 17,784 13,338 4,446 35,220 Retirement 55,042 41,282 13,761 56,143 42,107 14,036 111,185 Hospital Insurance 25,652 19,239 6,413 25,652 19,239 6,413 51,304 Life Insurance 821 616 205 837 628 209 1,658 Worker's Comp 6,252 4,689 1,563 6,377 4,783 1,594 12,629 Disability Insurance 1,071 803 268 1,093 820 273 2,164 Dental Insurance 2,835 2,126 709 2,835 2,126 709 5,670 Unemployment 410 308 103 418 314 105 828 Optical Insurance 343 257 86 343 257 86 686 Waterford Twp PD: Pension 11,325 8,494 2,831 11,778 8,834 2,945 23,103 Medical Insurance 11,500 8,625 2,875 11,500 8,625 2,875 23,000 Life Insurance 275 206 69 286 215 72 561 Dental Insurance 900 675 225 900 675 225 1,800 FICA 4,500 3,375 1,125 4,680 3,510 1,170 9,180 Hazel Park PD: Longevity - - - - - - . Holiday Pay - - • - - _ - Uniform Allowance - - _ - - . Premium 875 656 219 992 677 226 1,777 Pension 10,116 7,587 2,529 10,419 7,814 2,605 20,535 Worker's Comp 1,525 1,144 381 1,571 1,178 393 3,096 BC/BS 4,834 3,626 1,209 5,559 4,169 1,390 10,393 Optical Insurance 186 140 47 186 140 47 372 Dental Insurance 631 473 158 694 521 174 1,325 Life Insurance 175 131 44 175 131 44 350 Medicare 941 706 235 969 727 242 1,910 Madison Heights PD: COLA 728 546 182 728 546 182 1,456 Longevity . - - . . Holiday Pay - _ - _ , . . FICA-Medicare 838 629 219 863 647 216 1,701 Worker's Comp 520 390 130 535 401 134 1,055 Life Insurance 144 108 36 144 108 36 288 Dental Insurance 941 706 235 941 706 235 1,882 Health Insurance 9,879 7,409 2,470 9,879 7,409 2,470 19,758 Optical Insurance 95 71 24 95 71 24 190 1 11/7/2003 3:18 PM OAKLAND COUNTY SHERIFF DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD COMBINED BUDGET DETAIL G-8-04 2004 PROGRAM 2005 PROGRAM TOTAL ATPA GRANTEE TOTAL ATPA GRANTEE TOTAL APPROVED SHARE SHARE APPROVED SHARE SHARE 2004 AND BUDGET 75% 25% BUDGET 75% 25% 2005 510/LTD 862 647 216 887 665 222 1,749 Pension 10,002 7,502 2,501 10,302 7,727 2,576 20,304 Pontiac Police Department: FICA 798 599 200 822 617 206 1,620 Retirement 6,397 4,798 1,599 6,589 4,942 1,647 12986 Retirement-Medical - . - - - • . Medical Insurance 10,000 7,500 2,500 10,000 7,500 2,500 20,000 Dental Insurance 1,130 848 283 1,130 848 283 2,260 Longevity 1,895 1,421 474 1,952 1,464 488 3,847 Worker's Comp 425 319 106 425 319 106 850 . Lump Sum Holiday Pay . - . - .. _ Hear/Optical Insurance 100 75 25 100 75 25 200 Life/Disability Ins. 302 227 76 302 227 76 604 TOTAL SWORN EMPLOYEES 679,613 509,710 169,903 696,183 522,137 174,046 1,375,796 VEHICLES (4) Sheriff Vehicle Rental 26,000 19,500 6,500 26,000 19,500 6,500 52,000 (1) Waterford Twp Veh. Usage 6,500 4,875 1,625 6,500 4,875 1,625 13,000 (1) Hazel Park Vehicle Usage 6,500 4,875 1,625 6,500 4,875 1,625 13,000 (1) Madison Heights Veh, Usage 6,500 4,875 1,625 6,500 4,875 1,625 13,000 (1) Pontiac PD Vehicle Usage 6,500 4,875 1,625 6,500 4,875 1,625 13,000 TOTAL VEHICLES 52,000 39,000 13,000 52,000 39,000 13,000 104,000 FIELD OPERATIONS Investigative Supplies 1,000 750 250 1,400 1,050 350 2,400 GPS Tracking System 9,800 7,350 2,450 . - - 9,800 TOTAL FIELD OPERATIONS 10,800 8,100 2,700 1,400 1,050 350 12,200 OFFICE OPERATIONS Phone/Pager/Supplies 5,600 4,200 1,400 5,600 4,200 1,400 11,200 TOTAL OFFICE OPERATIONS 5,600 4,200 1,400 5,600 4,200 1,400 11,200 GRAND TOTAL 748,013 561,010 187,003 755,183 566,387 188,796 1,503,196 2 11/7/2003 3:25 PM OAKLAND COUNTY SHERIFF DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-04 2004 PROGRAM 2005 PROGRAM TOTAL ATPA GRANTEE TOTAL ATPA GRANTEE TOTAL APPROVED SHARE SHARE APPROVED SHARE SHARE 2004 AND BUDGET 75% 25% BUDGET 75% 25% 2005 SWORN EMPLOYEES Salaries & Wages: (4) Sheriff Deputies 227,919 170,939 56,980 232,477 174,358 58,119 460,396 Overtime 17,093 12,820 4,273 17,435 13,076 4,359 34,528 Employees Benefits: (4) Sheriff Deputies: FICA 17,436 13,077 4,359 17,784 13,338 4,446 35,220 Retirement 55,042 41,282 13,761 56,143 42,107 14,036 111,185 Hospital Insurance 25,652 19,239 6,413 25,652 19,239 6,413 51,304 Life Insurance 821 616 205 837 628 209 1,658 Worker's Comp 6,252 4,689 1,563 6,377 4,783 1,594 12,629 Disability Insurance 1,071 803 268 1,093 820 273 2,164 Dental Insurance 2,835 2,126 709 2,835 2,126 709 5,670 Unemployment 410 308 103 418 314 105 828 Optical Insurance 343 257 86 343 257 86 686 nTAL SWORN EMPLOYEES 354,874 266,166 88,719 361,394 271,046 90,349 716,268 VEHICLES (4) Sheriff Vehicle Rental 26,000 19,500 TOTAL VEHICLES 26,000 19,500 6,500 26,000 19,500 6,500 52,000 6,500 26,000 19,500 6,500 52,000 FIELD OPERATIONS Investigative Supplies 1,000 750 250 1,400 1,050 350 2,400 GPS Tracking System 9,800 7,350 2,450 - - - 9,800 TOTAL FIELD OPERATIONS 10,800 8,100 2,700 1,400 1,050 350 12,200 OFFICE OPERATIONS Phone/Pager/Supplies 5,600 4,200 1,400 5,600 4,200 1,400 11,200 TOTAL OFFICE OPERATIONS 5,600 4,200 1,400 5,600 4,200 1,400 11,200 GRAND TOTAL 397,274 297,956 99,319 394,394 295,796 98,599 791 ,668 11/7/2003 3:44 PM WATERFORD TOWNSHIP POLICE DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-04 2004 PROGRAM 2005 PROGRAM TOTAL ATPA GRANTEE TOTAL ATPA GRANTEE TOTAL APPROVED SHARE SHARE APPROVED SHARE SHARE 2004 AND BUDGET 75% 25% BUDGET 75% 25% 2005 SWORN EMPLOYEES Salaries & Wages: Police Officer 58,000 43,500 14,500 60,320 45,240 15,080 118,320 Overtime 4,350 3,263 1,088 4,524 3,393 1,131 8,874 Employees Benefits: Pension 11,325 8,494 2,831 11,778 8,834 2,945 23,103 Medical Insurance 11,500 8,625 2,875 11,500 8,625 2,875 23,000 Life Insurance 275 206 69 286 215 72 561 Dental Insurance 900 675 225 900 675 225 1,800 FICA 4,500 3,375 1,125 4,680 3,510 1,170 9,180 TOTAL SWORN EMPLOYEES 90,850 68,138 22,713 93,988 70,491 23,497 184,838 VEHICLES Vehicle Usage(Rental 6,500 4,875 1,625 6,500 4,875 1,625 13,000 TAL VEHICLES 6,500 4,875 1,625 6,500 4,875 1,625 13,000 AND TOTAL 97,350 73,013 24,338 100,488 75,366 25,122 197,838 11/712003 3:52 PM MADISON HEIGHTS POLICE DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-04 2004 PROGRAM 2005 PROGRAM TOTAL ATPA GRANTEE TOTAL ATPA GRANTEE TOTAL APPROVED SHARE SHARE APPROVED SHARE SHARE 2004 AND BUDGET 75% 25% BUDGET 75% 25% 2005 SWORN EMPLOYEES Salaries & Wages: Police Offier 53,514 40,136 13,379 55,119 41,339 13,780 108,633 Overtime 4,014 3,011 1,004 4,134 3,101 1,034 8,148 Employees Benefits: COLA 728 546 182 728 546 182 1,456 - Longevity - - - - - - Holiday Pay - - - - - - - RCA-Medicare 838 629 210 863 647 216 1,701 Worker's Comp 520 390 130 535 401 134 1,055 Life Insurance 144 108 36 144 108 36 288 Dental Insurance 941 706 235 941 706 235 1,882 Health Insurance 9,879 7,409 2,470 9,879 7,409 2,470 19,758 ltical Insurance 95 71 24 95 71 24 190 . D/LTD 862 647 216 887 665 222 1,749 Pension 10,002 7,502 2,501 10,302 7,727 2,576 20,304 TOTAL SWORN EMPLOYEES 81,537 61,153 20,384 83,627 62,720 20,907 165,164 VEHICLES Vehicle Usage/Rental 6,500 4,875 1,625 6,500 4,875 1,625 13,000 TOTAL VEHICLES 6,500 4,875 1,625 6,500 4,875 1,625 13,000 GRAND TOTAL 88,037 66,028 22,009 90,127 67,595 22,532 178,164 11/7/2003 4:03 PM PONTIAC POLICE DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-04 2004 PROGRAM 2005 PROGRAM TOTAL ATPA GRANTEE TOTAL ATPA GRANTEE TOTAL APPROVED SHARE SHARE APPROVED SHARE SHARE 2004 AND BUDGET 75% 25% BUDGET 75% 25% 2005 SWORN EMPLOYEES Salaries & Wages: Police Officer 49,005 36,754 12,251 50,475 37,856 12,619 99,480 Overtime 3,675 2,756 919 3,785 2,839 946 7,460 Employees Benefits: FICA 798 599 200 822 617 206 1,620 Retirement 6,397 4,798 1,599 6,589 4,942 1,647 12,986 Retirement-Medical - - - - - . - Medical Insurance 10,000 7,500 2,500 10,000 7,500 2,500 20,000 Dental Insurance 1,130 848 283 1,130 848 283 2,260 Longevity 1,895 1,421 474 1,952 1,464 488 3,847 Worker's Comp 425 319 106 425 319 106 850 Lump Sum Holiday Pay - - - . . - Hear/Optical Insurance 100 75 25 100 75 25 200 Life/Disability Ins, 302 227 76 302 227 76 604 JTAL SWORN EMPLOYEES 73,727 55,295 18,432 75,580 56,685 18,895 149,307 VEHICLES Vehicle Usage/Rental 6,500 4,875 1,625 6,500 4,875 1,625 13,000 TOTAL VEHICLES 6,500 4,875 1,625 6,500 4,875 1,625 13,000 GRAND TOTAL 80,227 60,170 20,057 82,080 61,560 20,520 162,307 11/7/2003 3:56 PM HAZEL PARK POLICE DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-04 2004 PROGRAM 2005 PROGRAM TOTAL ATPA GRANTEE TOTAL ATPA GRANTEE TOTAL APPROVED SHARE SHARE APPROVED SHARE SHARE 2004 AND BUDGET 75% 25% BUDGET 75% 25% 2005 SWORN EMPLOYEES Salaries & Wages: Police Officer 55,202 41,402 13,801 56,855 42,641 14,214 112,057 Overtime 4,140 3,105 1,035 4,264 3,198 1,066 8,404 Employees Benefits: - - - - , - Longevity - Holiday Pay - - - - - - - Uniform Allowance - - - - - - - Premium 875 656 219 902 677 226 1,777 Pension 10,116 7,587 2,529 10,419 7,814 2,605 20,535 Worker's Comp 1,525 1,144 381 1,571 1,178 393 3,096 SC/BS 4,834 3,626 1,209 5,559 4,169 1,390 10,393 Optical Insurance 186 140 47 186 140 47 372 Nntal Insurance 631 473 158 694 521 174 1,325 e Insurance 175 131 44 175 131 44 350 Medicare 941 706 235 969 727 242 1,910 TOTAL SWORN EMPLOYEES 78,625 58,969 19,656 81,594 61,196 20,399 160,219 VEHICLES Vehicle Usage 6,500 4,875 1,625 6,500 4,875 1,625 13,000 TOTAL VEHICLES 6,500 4,875 1,625 6,500 4,875 1,625 13,000 GRAND TOTAL 85,125 63,844 21,281 88,094 66,071 22,024 173,219 OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL CY 2003 AWARD VS. CY 2004 and CY 2005 AWARD Schedule A Variance Variance 2003 2004 2004 2004 Award 2005 2005 2005 Award Award Application Award vs 2003 Award Application Award vs 2003 Award Positions 4 4 4 0 4 4 0 Expenditures Salaries $ 227,367 $ 227,919 $227,919 $ 552 $ 232,477 $ 232,477 $ 5,110 Overtime 17,052 17,093 17,093 41 17,435 17,435 383 Fringe Benefits 93,981 1O9 ,8 109,862 15,881 111,482 111,482 17,501 Total Personnel $ 338,400 $ 354,874 $354,874 $ 16,474 $ 361,394 $ 361,394 $ 22,994 Leased Vehicles $ 24,400 $ 24,400 26,000 1,600 $ 24,400 $ 26,000 1 600 Total Vehicles $24,400 $24,400 $26,000 1,600 $ 24,400 $ 26,000 1,600 Pager Rental $1,092 $1,000 $0 (1,092) $0 0 ($1,092) Investigation Supplies 1,400 9,800 1,000.00 (400) 1,400 $ 1,400 o GPS 0 0 9,800.00 9,800 0 0 0 Total Field Operations $2,492 $10,800 $10,800 $ 8,308 $ 1,400 $ 1,400 $ (1,092) Telephone $ 4,508 $ 5,600 5,600 $ 1,092 $ 5,600 $ 5,600 $ 1,092 Total Office Operations $ 4,508 $5,600 5,600 1,092 $ 5,600 $ 5,600 1,092 Total Expenditures $369 800 $395,674 $397,274 $27,474 $392,794 $394,394 $24,594 Funding Source Grant Funding $ 277,350 75% $ 296,756 75% 297,956 75% $ 20,606 75% $ 294,595 $ 295,796 75% $ 18,446 County Match 92,450 25% 98,918 25% 99,318 25% 6,868 25% 98,199 98,598 25% 6,148 Total Funding for County $ 369,800 $ 395,674 $ 397,274 27.4 §___122,E94 $ 394,394 $_______ 24,594• OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL CY 2003 AWARD VS. CY 2004 and CY 2005 AWARD Variance Variance 2003 2004 2004 2004 Award 2005 2005 2005 Award Award Application Award vs 2003 Award Application Award vs 2003 Award Participating Police Units Waterford Police Dept. $ 96,336 $96,950 *** $97,350 $ 1,014 $100,088 $100,488 *** $ 4,152 Pontiac Police Dept. 75,735 90,892 *** 80,227 4,492 93,077 82,080 *** 6,345 Madison Heights 0 0 *** 0 0 0 - 0 Hazel Park Police Dept. 0 0 *** 0 0 0 *- 0 Total Participating Police U$ 172,071 $ 187,842 $ 177,577 5,506 $193,165 $182,568 $ 10,497 Funding Source Grant Funding Local Jurisdiction Match Total Grant $ 129,053 75% $ 140,881 75% $133,183 75% $ 4,130 $ 144,874 $ 136,926 75% $ 7,873 43,018 25% 46,961 25% 44394 25% . 1,376 48,291 45,642 25% 2 ,624 $172 071 __. _ $ 187,842 $ 177,577 §5,506 $ 193I 165 _ $ 182,568 $ 10,497 $ 541,871 $ 583,516 *** $ 574,851 32,980 $ 585,959 $ 576,962 *** $ 35,091 ***Oakland County will be requesting funds for the Sheriff Dept, Pontiac Police and Waterford Police only. Madison Heights and Hazel Park will be doing their own requests. Prepared by Fiscal Services Division FISCAL NOTE (MISC. 104049) March 4, 2004 BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON IN RE: SHERIFF'S OFFICE- CY 2004 AND CY 2005 AUTOMOBILE THEFT PREVENTION AUTHORITY GRANT ACCEPTANCE TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: Pursuant to Rule XII-C of this Board, the Finance Committee has reviewed the above referenced resolution and finds: 1. The Automobile Theft Prevention Authority (ATPA) has awarded the Auto Theft Unit of the Oakland County Sheriff's Department grant funding in the amount of $431,139 for the period January 1, 2004 through December 31, 2004 and $432,722 for the period January 1, 2005 through December 31, 2005. 2. For CY 2004 Oakland County has been awarded $297,956 with a required $99,318 in County match, the Waterford Police Department has been awarded $73,013 with a required $24,337 in Jurisdiction match and the Pontiac Police Department has been awarded $60,170 with a required $20,057 in Jurisdictional match for a total program cost of $574,851. 3. For CY 2005 Oakland County has been awarded $295,796 with a required $98,598 in County match, the Waterford Police Department has been awarded $75,366 with a required $25,122 in Jurisdiction match and the Pontiac Police Department has been awarded $61,560 with a required $20,520 in Jurisdictional match for a total program cost of $576,962. 4. Auto Theft Prevention Forfeiture funds are available in account 43- 101-013901-44200-2203-60055 to fund the County match portion of a GPS unit purchase for CY 2004 only. 5. Funds are available in the Non-Departmental Grant Match line item (#90-101-290000-25000-2872) to cover the required County match. 6. Staffing level is the same as the CY 2003 program year and no personnel changes were requested with the CY 2004 and CY 2005 grant awards. 7. The Waterford Police Department will cover its own required match of $24,337 for CY 2004 and $25,122 for CY 2005. 8. The Pontiac Police Department will cover its own required match of $20,057 for CY 2004 and $20,520 for CY 2005. 9. A budget amendment is required for Forfeiture Funds and to appropriate grant match funds from Non-Departmental to the Sheriff's Department in the General Fund. 10. A budget amendment is required in the Special Revenue Funds to adjust amounts to reflect acceptance of the grant as detailed below. CY2004 CY2005 Fund Dept OCA PCA Object Revenue 272 43120104(5) 44200 0167 Grant Match $99,318 $98,598 272 43 120104(5) 44200 0171 Grants-State 431,139 432,722 272 43 120104(5) 44200 0218 Local Match 44,394 45,642 $574,851 6576,962 FINANCE COMMITTEE: Motion carried unanimously on a roll call vote with Palmer and Long absent. Expend 272 43 220104(5) 44200 2001 Salaries $227,919 $232,477 272 43 220104(5) 44200 2002 OT 17,093 17,435 272 43 220104(5) 44200 2074 F.B. 109,862 111,482 272 43 220104(5) 44200 2572 Contractual Services 177,577 182,568 272 43 220104(5) 44200 6675 Telephone 5,600 5,600 272 43 220104(5) 44200 6661 Motor Pool 26,000 26,000 272 43 220104(5) 44200 4044 Deputy Supply 1,000 1,400 272 43 220104(5) 44200 4100 Expend Equip 9,800 0 _ Revenue $574,851 $576,962 101 43 023901 44000 1568 Enhance $ 2,450 $ 0 Expend Total Rev. $ 2,450 101 90 290000 25000 2872 Grant Match ($96,868) ($98,598) 101 43 023901 44200 3128 Grant Match 99,318 98,598 Total Exp. $ 2,450 $ 0 $ 0 $ 0 FINANCE COMMITTEE '3 11 1 Lt G. William Caddell, County Clerk Resolution #04049 March 4, 2004 Moved by Long supported by Coleman the resolutions on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Coleman, Coulter, Crawford, Douglas, Gregory, Hatchett, Jamian, Knollenberg, KowaII, Law, Long, McMillin, Middleton, Moffitt, Moss, Palmer, Patterson, Rogers, Scott, Suarez, Wilson, Zack, Bullard. (23) NAYS: None. A sufficient majority having voted therefore, the resolutions on the Consent Agenda were adopted (with accompanying reports being accepted). plnnn STATE OF MICHIGAN) COUNTY OF OAKLAND) I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on March 4, 2004 with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of tDia County of Oakland at Pontiac, Michigan this 4th day of March, 2004.