CITY OF LANSING, MICHIGAN SINGLE AUDIT For the Year Ended June 30, 2008 CITY OF LANSING, MICHIGAN Single Audit Table of Contents For the Year Ended June 30, 2008 PAGE Schedule of Expenditures of Federal Awards ................................................................... 1-2 Notes to Schedule of Expenditures of Federal Awards .................................................... 3 Independent Auditors’ Report on Internal Control over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards ............................................................................ 4-5 Independent Auditors’ Report on Compliance With Requirements Applicable to Each Major Program and Internal Control Over Compliance in Accordance With OMB Circular A-133 ............................................................................................. 6-8 Schedule of Findings and Questioned Costs ..................................................................... 9-17 * * * * * CITY OF LANSING, MICHIGANSchedule of Expenditures of Federal AwardsFor the Year Ended June 30, 2008Federal/Pass-through CurrentFederal/Pass-through Grantor CFDA Grantor YearNumber xProgram Title Number x ExpendituresU.S. Department of Housing and Urban ...
CITY OF LANSING, MICHIGAN SINGLE AUDIT For the Year Ended June 30, 2008
CITY OF LANSING, MICHIGAN Single Audit Table of Contents For the Year Ended June 30, 2008
Schedule of Expenditures of Federal Awards ................................................................... Notes to Schedule of Expenditures of Federal Awards .................................................... Independent Auditors’ Report on Internal Control over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards ............................................................................ Independent Auditors’ Report on Compliance With Requirements Applicable to Each Major Program and Internal Control Over Compliance in Accordance WithOMBCircularA-133............................................................................................. Schedule of Findings and Questioned Costs .....................................................................
* * * * *
PAGE
1-2
3
4-5
6-8
9-17
CITY OF LANSING, MICHIGA Schedule of Expenditures of Federal Awards For the Year Ended June 30, 2008
Federal/Pass-through Grantor Program Title U.S. Department of Housing and Urban Developmen Direct programs: Community Development Block Grant: 2004 Entitlement 2005 Entitlement 2006 Entitlement 2007 Entitlement Total Community Development Block Grant Emergency Shelter: 2006 Grant 2007 Grant Total Emergency Shelter Grant Supportive Housing Program: Advent House - 07/08 Ballentine - 07/08 Gateway Community Services - 04/07 Gateway Community Services - 07/08 Haven House - 05/08 Haven House - 08/09 C.A.C.S - 07/08 C.A.C.S - HPP 07/08 Greater Lansing Housing Coalition - 08/09 Greater Lansing Housing Coalition - 07/10 National Council Alcoholism - 06/08 Salvation Army - 05/07 Salvation Army (PSH III)- 06/08 St. Vincent Catholic Charities (PSH II) 2008 H.M.I.S. - 07/08 H.M.I.S. - 03/06 H.M.I.S. - 05/06 Total Supportive Housing Program Home Investment Partnerships Program: 2002 Grant Year 2003 Grant Year 2004 Grant Year 2005 Grant Year 2006 Grant Year 2007 Grant Year Total Home Investment Partnerships Program Lead Hazard Reduction Demonstration Grant Program Total U.S. Department o Housing and Urban Developmen U.S. Department of Justic Direct programs: Local Law Enforcement Block Grant: 2005 Grant Year 2006 Grant Year 2007 Grant Year Total Local Law Enforcement Block Grant COPS: Criminal Intelligence Database Bulletproof Vest Partnership Program Gang Resistance Education and Training Interoperable Communications Total COPS
CITY OF LANSING, MICHIGA Schedule of Expenditures of Federal Awards For the Year Ended June 30, 2008
Federal/Pass-through Grantor CFDA Program Title Number U.S. Department of Justice (concluded) Passed-through the State of Michigan Department of Community Health: Capital Area Response Effort - Year Twelve 16.575 Capital Area Response Effort - Year Eleven 16.575 Metro Conspiracy Investigations 16.579 Metro Conspiracy Investigations 16.579 Total passed-through the State of Michigan Department of Community Health Total U.S. Department of Justic U.S. Department of Transportatio Passed-through the State of Michigan Department of Transportation: Pennsylvania Avenue Bridge (MDOT 03-5122) 20.205 High Priority Projects Program (MDOT 00-5228) 20.205 Traffic Signal Control Integration 20.205 IPACE (MDOT 77195) 20.205 Southwest Signal (MDOT 06-5570) 20.205 Penn. / Mich. Signal (MDOT 06-5571) 20.205 Downtown Signal (MDOT 06-5572) 20.205 Total U.S. Department of Transportatio Environmental Protection Agenc Direct programs: Brownfield Assessment and Cleanup Brownfield Hazardous Substance Grant 66.818 Brownfild Petrol Grant 66.818 Brownfield BCRLF Grant 66.818 Total Brownfield Assessment and Cleanup Passed-through the State of Michigan Department of Environmental Quality: State Revolving Loan Funds (SRF) 66.458 Total Environmental Protection Agenc U.S. Department of Homeland Securit Passed-through the State of Michigan Department of State Police: FEMA - Hurricane Katrina 97.036 Emergency Management Performance Grant FY 2007 97.042 2006 Community Emergency Response Team (CERT) 97.067 2006 State Homeland Security Grant Program: 2006 State Homeland Security Program 97.067 2006 Law Enforcement Terrorism Prevention Program 97.067 Total U.S. Department of Homeland Securit Total Expenditures of Federal Awards
See accompanying notes to the Schedule of Expenditures of Federal Awards
-2-
Federal/ Pass-through Grantor Number x 20457-11V05 20457-10V04 70901-7-07-B 70901-8-08-B
CITY OF LANSING, MICHIGAN Notes to Schedule of Expenditures of Federal Awards GENERAL The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal awards programs of the City of Lansing, Michigan (the “City). Federal awards received directly from federal agencies, as well as federal awards passed through other government agencies, are included on this schedule. The information in this schedule is presented in accordance with the requirements of OMB Circular A-133, Audits of States, Local Governments, and Non-Profit Organizations . Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The City of Lansing reporting entity is defined in Note I of the City’s basic financial statements.
SUBRECIPIENTS The City administers certain federal awards programs through subrecipients. Those subrecipients are not considered part of the City of Lansing reporting entity. Of the federal expenditures presented in the schedule, the City of Lansing provided federal awards to subrecipients as follows: Federal CFDA Amount Provided Program Title Number to Subrecipients Community Development Block Grant 14.218 $ 359,671 Emergency Shelter 14.231 83,783 Supportive Housing Program 14.235 1,461,880 Home Investment Partnerships Program 14.239 43,000 METRO Conspiracy Investigations 16.579 290,256 COPS Interoperable Communications 16.710 514,956 2006 State Homeland Security Grant 97.067 2,340,285 FEMA Hurricane Katrina 97.036 23,783 Total $ 5,117,614
* * * * *
-3-
INDEPENDENT AUDITORS’ REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS December 19, 2008
Honorable Mayor and Members of the City Council City of Lansing, Michigan We have audited the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the City of Lansing, Michigan as of and for the year ended June 30, 2008, which collectively comprise the City’s basic financial statements as listed in the table of contents, and have issued our report thereon dated December 19, 2008. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Internal Control Over Financial Reporting In planning and performing our audit, we considered the City of Lansing, Michigan’s internal control over financial reporting as a basis for designing our auditing procedures for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City of Lansing, Michigan’s internal control over financial reporting. Accordingly, we do not express an opinion on the effectiveness of the City of Lansing, Michigan’s internal control over financial reporting. Our consideration of internal control over financial reporting was for the limited purpose described in the preceding paragraph and would not necessarily identify all deficiencies in internal control over financial reporting that might be significant deficiencies or material weaknesses. However, as discussed below, we identified certain deficiencies in internal control over financial reporting that we consider to be significant deficiencies.
675 Robinson Road P.O. Box 449 Jackson MI 49204 Phone 517.787.6503 FAX 517.788.8111 www.rehmann.com4--
A control deficiency exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent or detect misstatements on a timely basis. A significant deficiency is a control deficiency, or combination of control deficiencies, that adversely affects the entity’s ability to initiate, authorize, record, process, or report financial data reliably in accordance with generally accepted accounting principles such that there is more than a remote likelihood that a misstatement of the entity’s financial statements that is more than inconsequential will not be prevented or detected by the entity’s internal control. We consider the deficiency described in the accompanying schedule of findings and questioned costs as item 2008-1 to be a significant deficiency in internal control over financial reporting. A material weakness is a significant deficiency, or combination of significant deficiencies, that results in more than a remote likelihood that a material misstatement of the financial statements will not be prevented or detected by the entity’s internal control. Our consideration of the internal control over financial reporting was for the limited purpose described in the first paragraph of this section and would not necessarily identify all deficiencies in the internal control that might be significant deficiencies and, accordingly, would not necessarily disclose all significant deficiencies that are also considered to be material weaknesses. However we consider the significant deficiency described above to be a material weakness. Compliance and Other Matters As part of obtaining reasonable assurance about whether the City of Lansing, Michigan’s financial statements are free of material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards. We noted certain matters that we reported to management of the City of Lansing, Michigan, in a separate letter dated December 19, 2008. The City of Lansing, Michigan’s response to the finding identified in our audit is described in the accompanying schedule of findings and questioned costs. We did not audit the City of Lansing, Michigan’s response and, accordingly, we express no opinion on it. This report is intended solely for the information and use of the audit committee, the governing board, management, others within the organization, and federal awarding agencies and pass-through entities, and is not intended to be and should not be used by anyone other than these specified parties.
-5-
INDEPENDENT AUDITORS’ REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 December 19, 2008 Ho norable Mayor and Members o f the City Council Cit y of Lansing, Michigan Co mpliance We have audited the compliance of the City of Lansing, Michigan with the types of compliance requirements described in the U.S. Office of Management and Budget (OMB) Circular A-133 Compliance Supplement that are applicable to each of its major federal programs for the year ended June 30, 2008. The City of Lansing, Michigan’s major federal programs are identified in the summary of auditors’ results section of the accompanying Schedule of Findings and Questioned Costs. Compliance with the requirements of laws, regulations, contracts and grants applicable to each of its major federal programs is the responsibility of the City of Lansing, Michigan’s management. Our responsibility is to express an opinion on the City of Lansing, Michigan’s compliance based on our audit. We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and OMB Circular A-133, Audits of States, Local Governments, and Non-Profit Organizations . Those standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on major federal programs occurred. An audit includes examining, on a test basis, evidence about the City of Lansing, Michigan’s compliance with those requirements and performing such other procedures, as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal determination on the City of Lansing, Michigan’s compliance with those requirements. In our opinion, the City of Lansing, Michigan complied, in all material respects, with the requirements referred to above that are applicable to each of its major federal programs for the year ended June 30, 2008. However, the results of our auditing procedures disclosed instances of noncompliance with those requirements, which are required to be reported in accordance with OMB Circular A-133 and which are described in the accompanying schedule of findings and questioned costs as items 2008-2 and 2008-3, 2008-4 and 2008-5. 675 Robinson Road P.O. Box 449 Jackson MI 49204 Phone 517.787.6503 FAX 517.788.8111 www.rehmann.com-6-
Internal Control Over Compliance The management of the City of Lansing, Michigan is responsible for establishing and maintaining effective internal control over compliance with the requirements of laws, regulations, contracts and grants applicable to federal programs. In planning and performing our audit, we considered the City of Lansing, Michigan’s internal control over compliance with the requirements that could have a direct and material effect on a major federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance, but not for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, we do not express an opinion on the effectiveness of the City of Lansing, Michigan’s internal control over compliance. Our consideration of internal control over compliance was for the limited purpose described in the preceding paragraph and would not necessarily identify all deficiencies in the City’s internal control that might be significant deficiencies or material weaknesses as defined below. However, as discussed below, we identified certain deficiencies in internal control over compliance that we consider to be significant deficiencies. A control deficiency in an entity’s internal control over compliance exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent or detect noncompliance with a type of compliance requirement of a federal program on a timely basis. A significant deficiency is a control deficiency, or combination of control deficiencies, that adversely affects the entity’s ability to administer a federal program such that there is more than a remote likelihood that noncompliance with a type of compliance requirement of a federal program that is more than inconsequential will not be prevented or detected by the entity’s internal control. We consider the deficiencies in internal control over compliance described in the accompanying schedule of findings and questioned costs as items 2008-2, 2008-3, 2008-4, 2008-5, 2008-6 and 2008-7 to be significant deficiencies. A material weakness is a significant deficiency, or combination of significant deficiencies, that results in more than a remote likelihood that material noncompliance with a type of compliance requirement of a federal program will not be prevented or detected by the entity’s internal control. We did not consider any of the deficiencies noted above to be material weaknesses. The City of Lansing, Michigan’s responses to the findings identified in our audit are described in the accompanying schedule of findings and questioned costs. We did not audit the City of Lansing, Michigan’s responses and, accordingly, we express no opinion on them.
-7-
Schedule of Expenditures of Federal Awards We have audited the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the City of Lansing, Michigan as of and for the year ended June 30, 2008, and have issued our report thereon dated December 19, 2008. Our audit was performed for the purpose of forming opinions on the financial statements that collectively comprise the City’s basic financial statements. The accompanying schedule of expenditures of federal awards is presented for purposes of additional analysis as required by OMB Circular A-133 and is not a required part of the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and, in our opinion, is fairly stated, in all material respects, in relation to the basic financial statements taken as a whole. This report is intended solely for the information and use of the audit committee, management, others within the organization, the City Council, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties.
-8-
CITY OF LANSING, MICHIGAN Schedule of Findings and Questioned Costs For the Year Ended June 30, 2008
SECTION I - SUMMARY OF AUDITORS’ RESULTS Financial Statements Type of auditors’ report issued: Internal control over financial reporting: Material weakness(es) identified? Significant deficiency(s) identified not considered to be material weaknesses? Noncompliance material to financial statements noted? Federal Awards Internal Control over major programs: Material weakness(es) identified? Significant deficiency(s) identified not considered to be material weaknesses? Type of auditors’ report issued on compliance for major programs: Any audit findings disclosed that are required to be reported in accordance with Circular A-133, Section 510(a)?