Loading...
HomeMy WebLinkAboutResolutions - 2007.03.08 - 28481March 8, 2007 MISCELLANEOUS RESOLUTION # 07035 BY: Public Services Committee, Jeff Potter, Chairperson IN RE: SHERIFF'S OFFICE — CALENDAR YEAR 2007 AUTOMOBILE THEFT PREVENTION AUTHORITY (ATPA) GRANT ACCEPTANCE To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS the State of Michigan, Automobile Theft Prevention Authority (ATPA), awarded the Auto Theft Unit of the Sheriffs Office funding in the amount of $873,805 for the period of January 1, 2007 through December 31, 2007; and WHEREAS the Waterford, Pontiac and Farmington Hills Police Departments are included in the grant awarded to Oakland County; and WHEREAS Oakland County has been awarded $422,211 with a required $140737 local match, the Farmington Hills Police Department $84,685 with a required $28,228 local match, the Pontiac Police Department $62,480 with a required $20,827 local match, the Waterford Township Police Department $85,977 with a required $28,659 local match; and WHEREAS the Hazel Park Police Department and Wayne County Sheriffs Office will be requesting their own funding; and WHEREAS a twenty-five percent (25%) county local match in the amount of $140,737 is required and available in the non-departmental grant match account; and WHEREAS the award provAes full time funding for the following current positions with the Sheriffs Department one (1) Sergeant (10333) and four (4) Deputy II's (06108, 06109, 06147, 06148); and WHEREAS the acceptance of this grant does not obligate the County to any future commitment; and WHEREAS the continuation of the program is contingent upon future levels of grant funding. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners approves the Calendar Year 2007 Automobile Theft Prevention Authority Grant award in the amount of $873,805 and that the Board Chairperson. on behalf of the County of Oakland, is authorized to execute the grant amendment. 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 adoption of the foregoing resolution. PUBLIC SERVICES COMMITTEE Public Services Committee Vote: Motion carried unanimously on a roll call vote Page 1 of 2 ,y Fournier Greg Givens [givensg@oakgov.corn] Aent: Tuesday, January 23, 2007 10:37 AM To: 'Doyle, Larry': Fournier, Nancy; 'Kevin Banycky' Cc: 'Dale Cunningham': 'Worthington, Pam'; 'Candace Frederick': Greg Givens; 'Hanger, Helen': 'Johnston, Brenthy'; 'Mitchell, Sheryl': 'Pardee, Mary': 'Smith, Laverne': 'Wenzel, Nancy'; Guzzy, Scott Subject: GRANT REVIEW SIGN OFF - Sheriffs Office / ATPA GRANT REVIEW SIGN OFF — Sheriffs Office GRANT NAME: CY 2007 Oakland County Auto Theft Unit — ATPA Grant FUNDING AGENCY: Michigan Automobile Theft Prevention Authority DEPARTMENT CONTACT PERSON: Sgt Kevin Banycky / 8-5208 STATUS: Acceptance DATE: January 23, 2007 Pursuant to Misc. Resolution #01320, please be advised the captioned grant materials have completed internal grant review. Below are the returned review comments. The captioned grant materials and grant acceptance package (which should include the Board of Commissioners' Liaison Committee Resolution, the grant agreement/contract, Finance Committee Fiscal Note, and this Sign Off email containing grant review comments) may be requested to be placed on the appropriate Board of Commissioners' committee(s) for grant acceptance by Board resolution. DEPARTMENT REVIEW Please note the comments from Corporation Counsel. These issues should be considered before submission to the Board for acceptance. Department of Management and Budget: Approved. — Laurie Van Pelt (1/22/2007) Department of Human Resources: Approved. — Nancy Scarlet (1/18/2007) Risk Management and Safety: Approved By Risk Management — Julie Secontine Andrea Plotkowski (1/19/2007) Corporation Counsel: kfter reviewing the "ATPA Project Orientation Meeting Report", which serves as an addendum to the "grant," I found o legal issues to resolve before it is executed by Chairperson Bullard, However, please note that the name of the ;rantee should be "Oakland County" and not the "Oakland County Sheriff's Department" (as written in the addendum o the grant). The Oakland County Sheriff's Department is not a separate legal entity that can execute grant agreements )r in this case addendum's to a grant. Please let me know if you have any questions. — Jody Hall (1/18/2007) COMPLIANCE he grant award document references a specific state regulation. Below is a list of these specifically cited compliance related locuments for this grant. ifichigan Automobile Theft Prevention Authority; 1992 Act 174; Excerpt from 123/2007 STATE OF MICHIGAN AUTOMOBiLE THEFT PREVENTION AUTHORITY EAST LANSING JENNIFER M. GRANHOLM GOVERNOR COL. PETER C. MUNOZ DIRECTOR November 15, 2006 Capt, Mark Newman Oakland County Sheriffs Office 1201 North Telegraph Road Pontiac, Michigan 48341-1044 Dear Captain Newman: RE: Grant #08-07 Oakland County Auto Theft Unit I am pleased to inform you that on November 9, 2006, the Board of Directors of the Automobile Theft Prevention Authority (ATPA) approved your grant in the amount of $867,254, which is 75% of the total amount of $1,156,338. The budget detail for your project is enclosed. Prior to the release of funds, it will be necessary for the grant's project director and financial officer to attend an orientation meeting where grant objectives will be finalized, The overall management of your project, as well as reporting and grant payment procedures, will be reviewed. Your orientation meeting is scheduled for 3 p.m. on Monday, December 11, 2006, at MSP Special Investigation Division, 18050 Deering Road, Livonia, (734) 525-2560. Our best wishes for a successful program. VALD1S A. VITOLS Executive Director VAV:cs Enclosure cc: Lt. Mike Sutton Ms. Tammy Metric4 2007 fund letters.doc Col. Peter C. Munoz - Chair Ella Bully-Cummings, Warren Evans - Representing Law Enforcement Officials Patrck Dolan, Russell Kohler - Representing Purchasers of Automobile Insurance William Heemer, Steven Wagner - Representing Automobile Insurers 714 SOUTH HARRISON ROAD • EAST LANSING, MICHIGAN 48823 www michigan.gov/atpa • (517) 336-6197 Primed by members of 0 Iltau 08-07 ...•nn•n61, MSP-EX4d3-(12-96) Project No: 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 ATPA PROJECT ORIENTATION MEETING REPORT - PAGE 1 This report is a summary of the issues discussed during the orientation meetrig. It serves as an addendum to the grant, 1. NAME OF GRANTEE 2 ORIENTATION MEETING DATE Oakland County Sheriff Department December I I, 2006 3. PROJECT TITLE Oakland County Auto Theft Team 4. MEETING CONDUCTED BY Mr. Valdis Vitols, Ms. Chalouy "Newt" Shoup, and Mr. David Tjepkema 5. PROGRAM PERSONNEL ATTENDING (NAME AND RANK OR TITLE) 6. FINANCIAL PERSONNEL ATTENDING (NAME AND RANK OR TITLE) 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 UCFR 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.michigan.goviatpa.) 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 Funds: This fund is to be utilized solely for the benefit of auto theft prevention programs. H. All projects must maintain adequate support documentation for financial and 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. ATPA staff will make appointments with grant personnel in order to conduct on-site project and financial reviews. I. Membership in an ATPA Task Force: When an agency withdraws its officer from an ATPA Task Force, the approved budget for that position will remain with the task force. The Project Director needs to inform the ATPA when the withdrawal occurs, and the vacant position has to be replaced within the required time period. REPORTS REPORTING PERIOD DUE DATES Financial and Progress Reports (Form EX-36 & EX-37) 1-1-07 To 3-31-07 4-30-07 Financial and Progress Reports (Form EX-36 & EX-37) 4-1-07 To 6-30-07 7-31-07 Financial and Progress Reports (Form EX-36 & EX-37) 7-1-07 To 9-30-07 10-31-07 Financial and Progress Reports 10-1 -07 T 3 o 12-1-07 1-31-08 (Form EX-36 & EX-37) RETURN ONE COMPLETE SET WITH ORIGINAL SIGNATURES TO: Project No: 08-07 1 MSP-EX-43 (12-9) ATPA PROJECT ORIENTATION MEETING REPORT - PAGE 2 8, FINANCIAL REVIEW AND SUMMARY A. A separate project fund or account must be established for grant revenues ana 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, anc 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 shalt 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 2007 grants postmarked after January 31, 2008, will not be approved. F. Public communications materials or news releases that result from this grant mist 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. 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. SIG AT E 13, DATE 011-14-ek- Aleedir-r4,,) CA.,-71,1 ci / c. <,-e—r2.------- 14 ATPA EXECUTIVE DIRECTOR 15. SIG TURE .- 16. DATE _ Valdis Vitals December 8, 2006 PROGRAM ADDENDUM TO GRANT AWARD, PROJECT NO. ATTACHMENT TO ORIENTATION REPORT JANUARY I, 2007 PAGE lA 08-07 17. MEASURABLE OBJECTIVES: The measurable objectives submitted in the grant application are revised as follows: 1) Increase the prosecution for economic auto theft by making at least 25 motor vehicle related arrests per ATPA funded officer, and by focusing on the high point value arrests in the ATPA arrest ranking system. 2) Reduce the economic gain associated with auto theft by recovering at least 28 stolen vehicles or parts/equipment incidents per ATPA funded officer, and by constantly identifying possible insurance frauds. 3) Achieve a high rate of return on the investment of ATPA grant monies by, at a minimum, recovering more in stolen vehicles/parts/equipment value than the ATPA's total approved budget for the project. 4) Comply with all ATPA guidelines/policies/conditions, and those of the Uniform Crime Reporting System. 5) Maintain clear and reliable documentation for project's performance activity and financial expenditures 6) Report dollar amount deposited into forfeiture account following auction. 7) Act as prevention/apprehension training resource for project area agencies. 8) Attend regular meetings for area detectives and insurance investigators. 18. EVALUATION CRITERIA: . The evaluation criteria submitted in the grant -application are revised -asfollows-.-- - 1) Number 14 point MVT related arrests 2) Number 12 point MVT related arrests 3) Number 10 point MVT related arrests 4) Number 8 point MVT related arrests 5) Number 6 point MVT related arrests 6) Number 4 point MVT related arrests 7) Number 2 point MVT related arrests 8) Number passenger vehicles recovered 9) Dollar value of recovered passenger vehicles 10) Number other vehicles recovered 11) Dollar value of other vehicles recovered 12) Number parts recovery incidents 13) Dollar value of recovered parts/equipment 14) Dollar amount deposited into forfeiture account following auction 15) Number auto theft training sessions presented ATTACHMENT TO ORIENTATION REPORT FINANCIAL REQUIREMENTS FOR LAW ENFORCEMENT AND PROSECUTOR GRANTS PAGE 2A DISCUSSION AND EXPLANATION FOR ORIENTATION MEETING: ATPA Funds: This fund is to be utilized solely for the benefit of economic auto theft prevention programs, 2) Approved Budget Amount. See budget sheet. (Note I. Due to a short fall in the budget, the ATPA board of directors disallowed the following expenditures: Retirement Medical, Clothing/Cleaning/Gun Allowance, Lump Sum Holiday Pay, Lump Sum Vacation Pay, Lump Sum Longevity, Sick Time Buy Back, Sick Leave Incentive, Emergency Response Comp, Show lip Pay, Educational Incentive, Professional Insurance and Indirect Cost). 3) Authorized Grant Award/Actual Expenditures: The ATPA will reimburse only expenditures incurred during the grant period (January 1 - December 31, 2007). 4) Matching Funds is 25%: The ATPA will reimburse total actual expenditures up to 75% of the approved budget amount. 5) Time and Attendance: Payroll expenditures must be supported by time sheet/payroll register/earning history and duty log. These records should be retained in your file and made available to the ATPA auditor during a field audit. 6) Fringe Benefits and overtime: Retain a copy of vendor invoice or cost allocation for fringe benefits charged to the ATPA program in your file. Overtime hours cannot exceed 5% of total regular hours. 7) ATPA Budget Revision: The ATPA requires prior written notification to/and received approval from the ATPA for the purpose of transferring of funds between categories. The expenditures for individual categories cannot exceed the budget amount. Deadline for final financial modification request is January 31, 2008, and the ATPA must receive this request prior to the fourth quarter financial report. Any modification request postmarked after January 31, 2008, orxeceived by the ATPA after the fourth quartenfinancial report will.be-automatically-tlenied by the ATPA. 8) Vehicle Usage/Pm-Ital. funded activities activities and must be limited to ATPA approved budget amount. 9) Equipment Procurement Procedures/Consultant/Contractual Service . Grantee should follow agency's established guidelines. (Attach a copy of an invoice to your financial report as sunoortint , documentation for the - equipmentpurchase). - 1) 10) Program Income: Seizaire_property, fee.a,royaities.4..egiStratiOTJs. etr npratrtri by c(oryic-pc, Activitirs, provided through the grant project must be converted into funds for use in the activity funded by the grant. II) Financial/Progress Reports: Quarterly reports are due 30 days after the end of each quarter. A separate account is required for ATPA grant revenue/expenditures. 12) Payment Procedure: Reimbursement —with exception. (Note: New [first time grantees must be registered in the state's vendor file by completing a vendor packet.) 13) Membership in ATPA Task Force: The officer must be assigned to the task force. When an agency withdraws its officer from an ATPA Task Force, the approved budget for that position wi:1 remain with the task force. The Project Director needs to inform the ATPA when the withdrawal occurs, and the vacant position has to be replaced within the required time period. 14) Public communication materials or news releases must cite the ATPA as a source of funding. 15) Program modifications will not be considered after the first quarter. 16) Vacancy: If a position becomes vacant for more than 30 days, the total budget for this position will be reduced accordingly. Rev. 11/18/05 fn: add-fin.doc Page 1 of 2 Nancy Fournier From: Greg Givens [givensg@oakgov.com] Sent: Saturday, January 13, 2007 10:56 AM To: VanPelt, Laurie; Davis, Patric;a; Scarlet, Nancy; Secontine, Julie Cc: 'Dale Cunningham': 'Kevin Banycky'; Worthington, Pam; Bertram, Kevin; Cunningham, Judy; Doyle, Larry; Fournier, Nancy; Frederick, Candace; Greg Givens; Guzzy, Scott; Hanger, Helen; Johnston, Brenthy; Mason, Jennifer; Mitchell, Sheryl; Pardee, Mary; Plotkowski, Andrea; Ross, Dave; Shortley, Joellen; Smith, Laverne; Wenzel, Nancy; 'Johnson, Sandy'; 'Easterling' Subject: GRANT REVIEW - Sheriffs Office / ATPA GRANT REVIEW FORM TO: REVIEW DEPARTMENTS — Laurie Van Pelt — Nancy Scarlet — Julie Secontine — Pat Davis RE: GRANT REVIEW — Sheriffs Office CY 2007 Oakland County Auto Theft Unit — ATPA Grant Automobile Theft Prevention Authority Attached to this email please find the grant document(s) to be reviewed. Please provide your review stating your APPROVAL, APPROVAL WITH MODIFICATION, or DISAPPROVAL, with supporting comments, via reply (to all) of this email. Time Frame for Returned Comments: ASAP GRANT INFORMATION Date: January 12, 2007 Operating Department: Sheriff's Office Department Contact: Sgt. Kevin Banycky Contact Phone: 8-5208 Document Identification Number: G-08-07 REVIEW STATUS: Acceptance — Resolution Required (Application completed internal review on August 23, 2007 with all approvals) Funding Period: January 1, 2007 through December 31, 2007 New Facility / Additional Office Space Needs: None IT Resources (New Computer Hardware / Software Needs or Purchases): None M/WBE Requirements: No Funding Continuation/New: Continuation Application Total Project Amount: $584,948 (100% Oakland County share only) Prior Year Total Funding: $584,948 New Grant Funded Positions Request: None Changes to Current Positions: Continuation of Oakland County position #6108, 6109, 6147, 6148 and one SR position created under MR# 05021, 6 Non-county FTE's Grantor Funds: $867,253 ($422,211; Oakland County share only) Total Budget: $1,156,338 (100%; $562,948 Oakland County share only) Match and Source: 25% local match required. $289,084 total program match ($140,737; Oakland County share only). 1/17/2007 Page 2 of 2 PROJECT SYNOPSIS The Sheriffs Office Auto Theft Unit is a twelve member multi-jurisdictional task force comprised of officers from Oakland and Wayne Counties, the cities of Pontiac, Hazel Park Farmington Hills, and the Townships of Waterford. The unit focuses on auto theft and auto theft related crimes. In 2005 the unit recovered over $5,000,000 in stolen cars, parts and equipment and made 295 auto theft related arrests. 1/17/2007 FICA Retirement Hospital Insurance Life Insurance Worker's Comp Disability Insurance 24,846 18,635 6,212 90,294 67,721 22,574 41,821 31,366 10,455 1,296 972 324 8,194 6,146 2,049 1,462 1,097 366 Holiday Pay Blue Cross FACA Dental Insurance Life Insurance Waterford Twp PD: Unemployment Optical Insurance Farminton Hills PD-Officer: Worker's Comp Pension 680 510 170 19,624 14,718 4,906 13,091 9,818 3.273 int143f.-!--71.7.+1167 ,-”.11/6 925 694 231 125 94 31 647 485 162 492 369 123 11/10/20061:19 PM COUNTY OF OAKLAND SHERIFF DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD COMBINED BUDGET DETAIL G-8-07 2007 TOTAL ATPA GRANTEE APPROVED SHARE SHARE BUDGET 75% 25% SWORN EMPLOYEES Salaries & Wages: (4) Oakland Co. Deputies & (1) Sgt.: 324,751 243,563 81,188 Overtime 24,356 18,267 6,089 P. Officer-Farmington Hills PD 62,536 46,902 15,634 Overtime 4,690 3,518 1,173 P. Officer-Waterford Twp PD 60,178 45,134 15,045 Overtime 4,513 3,385 1,128 P. Officer-Hazel Park PD 56,358 42,269 14,090 Overtime 4,227 3,170 1,057 P. Officer-Pontiac PD 50,475 37,856 12,619 Overtime 3,785 2,839 946 (1) Wayne Co.SD-Sergeant 63,976 47,982 15,994 Overtime 853 640 213 (1) Wayne Co.SD-Deputy 50,125 37,594 12,531 Overtime 1,706 1,280 427 Employees Benefits: (4) Oakland Co. SD Deputies & (1) Sgt: Pension 17,446 13,085 4,362 Medical Insurance 20,000 15,000 5,000 Life Insurance 258 194 65 Dental Insurance 1,250 938 313 FICA 4,891 3,668 1,223 Hazel Park PD: Longevity - - - Holiday Pay - - - Uniform Allowance - - - Pension 9,958 7,469 2,490 Worker's Comp 1,514 1,136 379 BC/BS 9,976 7,482 2,494 Optical Insurance 130 98 33 Dental insurance 1,399 1,049 350 Life Insurance 114 86 29 Medicare 878 659 220 Pontiac Police Department: 1 30,500 6,100 6,100 6,100 12,200 _ - 67,100 1,400 1,400 50,325 16,775 1,050 350 1,050 350 TOTAL VEHICLES FIELD OPERATIONS Inv. Supplies-Oakland Co. SD TOTAL FIELD OPERATIONS 11/10/20061:19 PM COUNTY OF OAKLAND SHERIFF DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD COMBINED BUDGET DETAIL G-8-07 2007 TOTAL ATPA GRANTEE APPROVED SHARE SHARE BUDGET 75% 25% FICA-Medicare 787 590 197 Retirement 10,776 8,082 2,694 - Retirement-Medical - - Medical Insurance 10,100 7,575 2,525 Dental Insurance 825 619 206 Longevity - - - Worker's Comp 145 109 36 Lump Sum Holiday Pay - - - Hear/Optical Insurance 100 75 25 Life/Disability Ins. 214 161 54 (1) Wayne Co. SD-Sergeant: Unemployment FICA Health Insurance 34% Disability Insurance .55% Worker's Comp 1.32% Retirement 12% (1) Wayne Co. SD-Deputy: Unemployment FICA Health Insurance 34% Disability Insurance .55% Workers Comp 1.32% Retirement 12% X41.44MGRN=EM111.111Nali VEHICLES (5) Sheriff Vehicle Rental (1) Farmington Hills vehicle Usage (1) Waterford Twp Veh. Usage (1) Hazel Park Vehicle Usage (2) Wayne Co. SD Veh. Usage 0461ktehisseebiele1iserge 243 182 61 4,894 3,671 1,224 20,915 15,686 5,229 352 264 88 864 648 216 7,677 5,758 1,919 243 182 61 3,835 2,876 959 17,043 12,782 4,261 276 207 69 662 497 166 6,015 4,511 1,504 Ilterr4 -41)873t41=2697t84 22,875 7,625 4,575 1,525 4,575 1,525 4,575 1,525 9,150 3,050 OFFICE OPERATIONS Phone/Pager/Supplies 8,700 6,525 2,175 TOTAL OFFICE OPERATIONS 8,700 6,525 2,175 GRAND TOTAL 1,156,338 867,253 289,084 2 VEHICLES (5) Vehicle Rental/Usage 30,500 22,875 7,625 TOTAL VEHICLES 30,500 22,875 7,625 FIELD OPERATIONS etrIT'AtappliErSTOSIONPRIMIrS13 1,uu 350 350 1,400 1,050 TOTAL FIELD OPERATIONS OFFICE OPERATIONS Phone/Pager/Supplies TOTAL OFFICE OPERATIONS GRAND TOTAL 8,700 6,525 2,175 8,700 6,525 2,175 562,948 422,211 140,737 11/10/20061:27 PM COUNTY OF OAKLAND SHERIFF DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-07 2007 TOTAL ATPA GRANTEE APPROVED SHARE SHARE BUDGET 75% 25% SWORN EMPLOYEES Salaries & Wages: (4) Oakland Co. Deputies & (1) Sgt.: Overtime Employees Benefits: (4) Oakland Co. SD Deputies & (1) Sgt: FICA Retirement Hospital Insurance Life Insurance Worker's Comp Disability Insurance Dental Insurance Unemployment Optical Insurance 324,751 243,563 81,188 24,356 18,267 6,089 24,846 18,635 6,212 90,294 67,721 22,574 41,821 31,366 10,455 1,296 972 324 8,194 6,146 2,049 1,462 1,097 366 4,189 3,142 1,047 647 485 162 492 369 123 TOTAL SWORN EMPLOYEES 522,348 391,761 130,587 6,100 VEHICLES (1) Vehicle Rental/ Usage 4,575 1,525 6,100 TOTAL VEHICLES GRAND TOTAL 4,575 1,525 112,914 84,685 28,228 11/10/20061:32 PM FARMINGTON HILLS POLICE DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-07 2007 TOTAL ATPA GRANTEE APPROVED SHARE SHARE BUDGET 75% 25% SWORN EMPLOYEES Salaries & Wages: Police Officer/Detective 62,536 46,902 15,634 Overtime 4,690 3,518 1,173 Employees Benefits: Worker's Comp 680 510 170 Pension 19,624 14,718 4,906 - Holiday Pay - - Blue Cross 13,091 9,818 3,273 FICA 5,143 3,857 1,286 Dental Insurance 925 694 231 Life Insurance 125 94 31 TOTAL SWORN EMPLOYEES 106,814 80,110 26,703 6,100 VEHICLES (1) Vehicle Rental/Usage 4.575 t,g7g 6,100 90,654 TOTAL VEHICLES GRAND TOTAL 4,575 1,525 67,990 22,663 11/10/20061:41 PM HAZEL PARK POLICE DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-07 2007 TOTAL ATPA GRANTEE APPROVED SHARE SHARE BUDGET 75% 25% SWORN EMPLOYEES Salaries & Wages: Police Officer/Detective 56,358 42,269 14,090 Overtime 4,227 3,170 1,057 Employees Benefits: - Longevity - - Holiday Pay - Uniform Allowance - - - Pension 9,958 7,469 2,490 Worker's Comp 1,514 1,136 379 EICIBS 9,976 7,482 2,494 Optical Insurance 130 98 33 Dental Insurance 1,399 1,049 . 350 Life Insurance 114 86 29 Medicare 878 659 220 TOTAL SWORN EMPLOYEES 84,554 63,415 21,138 TOTAL VEHICLES GRAND TOTAL 83,307 62,480 20,827 6,100 4,575 1,525 11/10/20061:44 PM PONTIAC POLICE DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-07 2007 TOTAL ATPA GRANTEE APPROVED SHARE SHARE BUDGET 75% 25% SWORN EMPLOYEES Salaries & Wages: Police Officer/Detective 50,475 37,856 12,619 Overtime 3,785 2,839 946 Employees Benefits: FICA-Medicare 787 590 197 Retirement 10,776 8,082 2,694 Retirement-Medical - - - Medical Insurance 10,100 7,575 2,525 Dental Insurance 825 619 206 Longevity - - . Worker's Comp 145 109 36 Lump Sum Holiday Pay - - - Hear/Optical Insurance 100 75 25 Life/Disability Ins. 214 161 54 TOTAL SWORN EMPLOYEES 77,207 57,905 19,302 VEHICLES (1) Vehicle Rental/Usage IS,Iflfl 11/10/20061:51 PM WAYNE COUNTY SHERIFF DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-07 2007 TOTAL ATPA GRANTEE APPROVED SHARE SHARE BUDGET 75% 25% SWORN EMPLOYEES Salaries & Wages: (1) Sheriff Dept. Sergeant Overtime (1) Sheriff Deputy Overtime Employees Benefits: (1) Wayne Co. SD-Sergeant: Unemployment FICA Health Insurance 34% Disability Insurance .55% Worker's Comp 1.32% Retirement 12% (1) Wayne Co. SD-Deputy: Unemployment FICA Health Insurance 34% Disability Insurance .55% Worker's Comp 1.32% Retirement 12% TOTAL SWORN EMPLOYEES VEHICLES (2)Vehicle Rental/Usage 63,976 47,982 15,994 853 640 213 50,125 37,594 12,531 1,706 1,280 427 243 182 61 4,894 3,671 1,224 20,915 15,686 5,229 352 264 88 864 648 216 7,677 5,758 1,919 243 182 61 3,835 2,876 959 17,043 12,782 4,261 276 207 69 _ g2 497 166 6,015 4,511 1,504 179,679 134,759 44,920 9,150 3,050 12,200 12,200 9,150 3,050 GRAND TOTAL 191,879 143,909 47,970 SWORN EMPLOYEES Salaries & Wages: Police Officer/Detective Overtime Employees Benefits: Pension Medical Insurance Life Insurance Dental Insurance FICA 17,446 13,085 4,362 20,000 15,000 5,000 258 194 65 1,250 938 313 4,891 3,668 1,223 60,178 45,134 15,045 4,513 3,385 1,128 TOTAL SWORN EMPLOYEES 108,536 81,402 27,134 VEHICLES (1) Vehicle Rental/Usage 6,100 4,575 1,525 TOTAL VEHICLES GRAND TOTAL 114,636 85,977 28,659 6,100 4,575 1,525 11/10/20061:37 PM WATERFORD TOWNSHIP POLICE DEPARTMENT OAKLAND COUNTY AUTO THEFT SQUAD BUDGET DETAIL G-8-07 2007 TOTAL ATPA GRANTEE APPROVED SHARE SHARE BUDGET 75% 25% 8,037 $ 35,206 $ 3,698 $ 46,941 $ 19,234 $ 1,442 $ 11,471 14,794 $ -0- $ -0- $ - 0- c 46,941 $140,737 $655,354 $ 77,714 $873,805 $324,751 $ 24,356 $173,241 $310,857 8,700 30,500 $ 1,400 $873,805 FISCAL NOTE (MISC. 107035) March 8, 2007 BY: Finance committee, Mike Rogers, Chairperson IN RE: SHERIFF'S OFFICE - CALENDAR YEAR 2007 AUTOMOBILE THEFT PREVENTION AUTHORITY (ATPA) 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) awarded the Sheriff's Office, Auto Theft Unit, funding in the amount of $873,805. 2. The Waterford, Pontiac and Farmington Hills Police Departments are included in the award amount. The Oakland County award is $422,211 with a $140,737 local match, the Waterford award is $85,977 with a $28,659 local match, the Pontiac award is $62,480 with a S20,827 local match and the Farmington Hills award is $84,685 with a $28,228 local match. 3. The twenty-five percent (25%) County local match in the amount of $140,737 is available in the non-departmental grant match account. 4. The grant continues funding for four (4) Deputy II positions and one (1) Sergeant position. There are no changes in personnel from the previous award. 5. A Special Revenue Fund budget amendment is recommended as follows: Adopted Change Amended FY 2007 FY 2007 FY 2007 GENERAL FUND #10100 Expenditures 9090101-196030-730800 Grant Match 4030901-116270-788001-27310 Transfer Out Total General Fund Expenses SPECIAL REVENUE FUND #27310 Revenue 4030901-116270-695500-10100 Trf In $132,700 4030901-116270-615571 Grants-State$620,148 4030901-116270-625558 Local Match $ 74,016 $826,864 Salary $305,517 Overtime $ 22,914 Fringe Ben. $161,770 Contract Srv$296,063 Telephone $ 8,700 Motor Pool $ 30,500 Deputy Supl.$ 1,400 $826,864 Expenditures 4030901-116270-702010 4030901-116270-712020 4030901-116270-722740 4030901-116270-730373 4030901-116270-778675 4030901-116270-776661 4 030 90 1-11627 0-7 5007 0 ($140,737) $140,737 $ -0- FINANCE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Zack absent. Roth JOh-rigo-n, County Clerk Resolution #07035 March 8, 2007 Moved by Rogers supported by Gershenson the resolutions (with fiscal notes attached) on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Burns, Coleman, Coulter, Crawford, Douglas, Gershenson, Gingell, Gosselin, Gregory, Greimel, Hatchett, Jacobsen, KowaII, Long, Middleton, Nash, Potter, Potts, Rogers, Scott, Spector, Suarez, Wcodward, Zack, Bullard. (25) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent Agenda, were adopted (with accompanying reports being accepted). (21'7 I HEREBY APPROVE fHE FOREGOING RESOLUTION ACTING PURSUANT 10 1973 PA 1/ STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Ruth Johnson, 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 8, 2007, with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 8th day of March, 2007.