Federal Program Information Federal Agencies: United States Department of Homeland Security Awards: Assistance Listing Number 97.036 – COVID-19 – Disaster Grants - Public Assistance (Presidentially Declared Disasters) Award Periods: January 20, 2020 – May 11, 2023 Description: Preparation of Schedule of Expenditures of Federal Awards Type of Finding: Material Weakness in Internal Control Over Compliance Criteria The Uniform Guidance 2 CFR section 200.303 states, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare the Schedule for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.” Condition The System omitted the obligated expenditures related to the Assistance Listing Number 97.036 – COVID-19 – Disaster Grants - Public Assistance (Presidentially Declared Disasters) (“FEMA”) in the Schedule. Cause The System misinterpreted the FEMA Public Assistance Grant Program guidance for reporting Assistance Listing 97.036 expenditures in the Schedule, which is based on when (1) FEMA has approved (i.e., obligated) the non-federal entity’s project worksheet (PW), and (2) the non-federal entity has incurred the eligible expenditures. The System interpreted the date the PW is approved (i.e., obligated) as the date the Virginia Department of Emergency Management will authorize disbursement and appropriate of the funds from the Department of Planning and Budget rather than the date FEMA obligated the PW. Effect or potential effect The Schedule prepared by the System was misstated but was subsequently corrected. A misstated Schedule could result in the improper selection of federal award major programs or an incorrect percentage of coverage being calculated resulting in a restatement of a previously issued Uniform Guidance report. Questioned costs None. Identification of a repeat finding This is not a repeat finding. Context Expenditures for Assistance Listing 97.036 of $31,631,420 were excluded from the Schedule. These expenditures related to PWs obligated in 2022 and expenditures incurred in previous fiscal years and consequently should have been recorded in the 2022 Schedule. Recommendation The System should update its policies and procedures and internal controls, specifically the process to accumulate and report FEMA expenditures of federal awards to be in accordance with the FEMA Schedule requirements outlined above. View of responsible officials The System agrees with the comment and has developed a plan to correct the finding.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The District’s internal control procedures did not identify $1,943,931 of expenses in the Schedule of Expenditures of Federal Awards related to the Highway Planning and Construction funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The District’s internal control procedures did not identify $1,943,931 of expenses in the Schedule of Expenditures of Federal Awards related to the Highway Planning and Construction funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The District’s internal control procedures did not identify $1,943,931 of expenses in the Schedule of Expenditures of Federal Awards related to the Highway Planning and Construction funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Township did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Township and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Township review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Township did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Township and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Township review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Township did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Township and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Township review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Finding 2022-003 Inaccurate SEFA – Reporting – Material Weakness Name of Federal Agency: U.S Department of Housing and Urban Development Federal Program Name: HOME Investments Partnership Program and CDBG Entitlement Grants Cluster Assistance Listing Number: 14.239 and 14.218 Federal Award Identification Number and Year: Identification number unavailable. Program years 2010, 2012, 2015, 2019, 2020, 2022. Name of Pass-through Entity (if applicable): Rhode Island Housing and Mortgage Finance Corporation and the City of Providence, Rhode Island. Criteria: In accordance with 2 CFR 200.302 (Financial Management), a grant recipient’s financial management system must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. In addition, 2 CFR 200.510 (Financial Statements), states in part that the auditee must prepare a schedule of expenditures of Federal awards (“SEFA”) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2CFR 200.502. At a minimum, the schedule must include: -All individual Federal programs by Federal agency. -For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. -Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. -Include the total amount provided to subrecipients from each Federal program. Condition / Context: The Organization management’s review and approval process did not detect the errors that were identified during the audit procedures performed. The errors detected consisted of the understatement of Federal Assistance Listing Numbers 14.239 and 14.218 in the amounts of $1,260,748 and $295,000, respectively, for a total understatement of $1,555,748. Cause: The Organization’s internal controls over the preparation and review of the SEFA were not operating effectively. Material audit adjustments were proposed during the course of the audit that lead to material changes to the SEFA. Effect or Potential Effect: Inadequate controls over the preparation of the SEFA could result in financial misstatements or potential noncompliance. Questioned Costs: None Identification as a Repeat Finding: This is not a repeat finding. Recommendation: We recommend the Organization strengthen its policies, procedures, and controls for the identification of federal awards to ensure a complete and accurate SEFA is prepared in a timely manner. Views of Responsible Officials: Management agrees with the finding and is in the process of revising internal controls to address SEFA preparation.
Finding 2022-003 Inaccurate SEFA – Reporting – Material Weakness Name of Federal Agency: U.S Department of Housing and Urban Development Federal Program Name: HOME Investments Partnership Program and CDBG Entitlement Grants Cluster Assistance Listing Number: 14.239 and 14.218 Federal Award Identification Number and Year: Identification number unavailable. Program years 2010, 2012, 2015, 2019, 2020, 2022. Name of Pass-through Entity (if applicable): Rhode Island Housing and Mortgage Finance Corporation and the City of Providence, Rhode Island. Criteria: In accordance with 2 CFR 200.302 (Financial Management), a grant recipient’s financial management system must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. In addition, 2 CFR 200.510 (Financial Statements), states in part that the auditee must prepare a schedule of expenditures of Federal awards (“SEFA”) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2CFR 200.502. At a minimum, the schedule must include: -All individual Federal programs by Federal agency. -For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. -Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. -Include the total amount provided to subrecipients from each Federal program. Condition / Context: The Organization management’s review and approval process did not detect the errors that were identified during the audit procedures performed. The errors detected consisted of the understatement of Federal Assistance Listing Numbers 14.239 and 14.218 in the amounts of $1,260,748 and $295,000, respectively, for a total understatement of $1,555,748. Cause: The Organization’s internal controls over the preparation and review of the SEFA were not operating effectively. Material audit adjustments were proposed during the course of the audit that lead to material changes to the SEFA. Effect or Potential Effect: Inadequate controls over the preparation of the SEFA could result in financial misstatements or potential noncompliance. Questioned Costs: None Identification as a Repeat Finding: This is not a repeat finding. Recommendation: We recommend the Organization strengthen its policies, procedures, and controls for the identification of federal awards to ensure a complete and accurate SEFA is prepared in a timely manner. Views of Responsible Officials: Management agrees with the finding and is in the process of revising internal controls to address SEFA preparation.
Finding 2022-003 Inaccurate SEFA – Reporting – Material Weakness Name of Federal Agency: U.S Department of Housing and Urban Development Federal Program Name: HOME Investments Partnership Program and CDBG Entitlement Grants Cluster Assistance Listing Number: 14.239 and 14.218 Federal Award Identification Number and Year: Identification number unavailable. Program years 2010, 2012, 2015, 2019, 2020, 2022. Name of Pass-through Entity (if applicable): Rhode Island Housing and Mortgage Finance Corporation and the City of Providence, Rhode Island. Criteria: In accordance with 2 CFR 200.302 (Financial Management), a grant recipient’s financial management system must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. In addition, 2 CFR 200.510 (Financial Statements), states in part that the auditee must prepare a schedule of expenditures of Federal awards (“SEFA”) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2CFR 200.502. At a minimum, the schedule must include: -All individual Federal programs by Federal agency. -For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. -Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. -Include the total amount provided to subrecipients from each Federal program. Condition / Context: The Organization management’s review and approval process did not detect the errors that were identified during the audit procedures performed. The errors detected consisted of the understatement of Federal Assistance Listing Numbers 14.239 and 14.218 in the amounts of $1,260,748 and $295,000, respectively, for a total understatement of $1,555,748. Cause: The Organization’s internal controls over the preparation and review of the SEFA were not operating effectively. Material audit adjustments were proposed during the course of the audit that lead to material changes to the SEFA. Effect or Potential Effect: Inadequate controls over the preparation of the SEFA could result in financial misstatements or potential noncompliance. Questioned Costs: None Identification as a Repeat Finding: This is not a repeat finding. Recommendation: We recommend the Organization strengthen its policies, procedures, and controls for the identification of federal awards to ensure a complete and accurate SEFA is prepared in a timely manner. Views of Responsible Officials: Management agrees with the finding and is in the process of revising internal controls to address SEFA preparation.
Finding 2022-003 Inaccurate SEFA – Reporting – Material Weakness Name of Federal Agency: U.S Department of Housing and Urban Development Federal Program Name: HOME Investments Partnership Program and CDBG Entitlement Grants Cluster Assistance Listing Number: 14.239 and 14.218 Federal Award Identification Number and Year: Identification number unavailable. Program years 2010, 2012, 2015, 2019, 2020, 2022. Name of Pass-through Entity (if applicable): Rhode Island Housing and Mortgage Finance Corporation and the City of Providence, Rhode Island. Criteria: In accordance with 2 CFR 200.302 (Financial Management), a grant recipient’s financial management system must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. In addition, 2 CFR 200.510 (Financial Statements), states in part that the auditee must prepare a schedule of expenditures of Federal awards (“SEFA”) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2CFR 200.502. At a minimum, the schedule must include: -All individual Federal programs by Federal agency. -For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. -Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. -Include the total amount provided to subrecipients from each Federal program. Condition / Context: The Organization management’s review and approval process did not detect the errors that were identified during the audit procedures performed. The errors detected consisted of the understatement of Federal Assistance Listing Numbers 14.239 and 14.218 in the amounts of $1,260,748 and $295,000, respectively, for a total understatement of $1,555,748. Cause: The Organization’s internal controls over the preparation and review of the SEFA were not operating effectively. Material audit adjustments were proposed during the course of the audit that lead to material changes to the SEFA. Effect or Potential Effect: Inadequate controls over the preparation of the SEFA could result in financial misstatements or potential noncompliance. Questioned Costs: None Identification as a Repeat Finding: This is not a repeat finding. Recommendation: We recommend the Organization strengthen its policies, procedures, and controls for the identification of federal awards to ensure a complete and accurate SEFA is prepared in a timely manner. Views of Responsible Officials: Management agrees with the finding and is in the process of revising internal controls to address SEFA preparation.
Finding Number: 2022-003 Finding Type: Federal award finding and financial statement finding Federal Assistance Listing No.: 14.239 Program Name: HOME investment Partnership Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: Portland Housing Bureau Grant Numbers: 311020 Federal Award Year: 2022 Control Deficiency Type: Significant deficiency in internal controls over compliance Instance of Noncompliance: Yes Compliance Requirement: Reporting Questioned Costs: None Repeat Finding: No Criteria: 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, and §200.302 (b), Financial Management. Identification, in its accounts, of all federal awards received and expended and the federal program under which they were received. Federal program and federal award identification must include, as applicable, the CFDA title and number, federal award identification number, name of the federal agency, and name of the pass-through entity, if any. Additional criteria: 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F – Audit Requirements, §200.510, Financial Statements. Schedule of Expenditures of Federal Awards – The auditee also must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements, which must include the total federal awards expended, as determined in accordance with §200.502, Basis for Determining Federal Awards Expended. At a minimum, the schedule must provide total federal awards expended for each individual federal program and the CFDA number or other identifying number when the CFDA information is not available. For a cluster of programs, also provide the total for the cluster. Condition: During the audit, we noted that the organization did not maintain a complete schedule of expenditures of federal awards. Cause: The organization did not adequately track federal expenditures and the required information needed to prepare a schedule of expenditures of federal awards. Effect: Failure to prepare an accurate and complete schedule of expenditures of federal awards results in noncompliance with 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, §200.302, Financial Management, and Subpart F – Audit Requirements, §200.510, Financial Statements. Audit Recommendation: We recommend that the organization document and implement policies and procedures to ensure the schedule of expenditures of federal awards is accurate and complete in accordance with 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, §200.302, Financial Management and Subpart F – Audit Requirements, §200.510, Financial Statements, in order to obtain accurate calculations of major federal programs for the single audit and to ensure the organization is in compliance with all of the reporting requirements as to identify the source and application of funds for federally-funded activities. Management’s Response: The SEFA was assigned to be prepared internally, but unfortunately was not submitted due to staff turnover during the course of the audit. This oversight will be corrected by improving procedures around internal task assignments when employee turnover is experienced in the Fiscal department during the course of the audit.
Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Environmental Protection Agency Federal Program: Capitalization Grants for Clean Water State Revolving Fund Assistance Listing Number: 66.458 Pass-Through Agency: NYS Environmental Facilities Corporation Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee's financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor's identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 16.554 National Criminal History Improvement Program (NCHIP) 2. ALN 20.600 State and Community Highway Safety 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.044 Assistance to Firefighters Grant 6. ALN 97.067 Homeland Security Grant Program Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it received. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $892,160. Repeat Finding: This finding is a repeat of finding 2021-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding and will develop a method for accurately tracking federal expenditures.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. Subsequent to the original issuance of the 2022 audit report dated November 17, 2023, with the assistance of the pass-through entity, it was determined that the City omitted a federally funded program under the Highway Planning and Construction Cluster (Highway Planning and Construction - AUG CR 25A 3.29 - ALN 20.205). The related expenditures of $1,484,064, were excluded from the City’s originally provided SEFA. The City failed to properly identify/communicate the federal designation of the project. Inaccurate completion of the SEFA could lead to inaccurate reporting of federal expenditures by the City and could jeopardize future federal funding. The City’s originally provided SEFA for 2022 was materially misstated by the exclusion of the Highway Planning and Construction Cluster (Highway Planning and Construction - AUG CR 25A 3.29 - ALN 20.205), in the amount of $1,484,064. We recommend that the City review the process for identifying federal awards to minimize the likelihood of errors in the reporting process. Officials Response: See Corrective Action Plan
Type of Finding: (B) Significant Deficiency in Internal Control Over Financial Reporting NEW SPACE NEXUS SCHEDULE OF FINDINGS AND QUESTIONED COSTS For the Year Ended December 31, 2022 38 Federal Award Information Funding Agency: U.S. Department of Defense, passed through the Air Force Research Laboratory Title: New Space New Mexico Small Satellite Manufacturing and Innovation Hub (iHub) AL #: 12.599 Award #: FA9453-21-3-1001 Compliance Requirement: Reporting Award Period: 06/01/2021-05/31/2026 Questioned Costs: None Noted Condition During our audit, we identified errors and inconsistencies in the Schedule of Expenditures of Federal Awards (SEFA). Specifically, the SEFA was not prepared accurately and did not fully reconcile to the underlying accounting records. In addition, the SEFA was prepared without evidence of an independent review to ensure completeness and accuracy prior to submission. Criteria New Space must prepare a SEFA for the period covered by the financial statements and include total federal awards expended as determined under 2 CFR 200.502. New Space must establish, document, and maintain effective internal control over federal awards to provide reasonable assurance of compliance with statutes, regulations, and award terms. Effect SEFA inaccuracies increase the risk of material misstatement in required supplementary information and may contribute to improper major federal program selection under the risk-based approach, resulting in a substandard Single Audit. Cause New Space does not have documented SEFA preparation processes and no independent review control assigned to a separate reviewer. Recommendation New Space management should implement a documented SEFA process that (1) prepares the SEFA from the general ledger and grant support, (2) performs and retains a line-by- NEW SPACE NEXUS SCHEDULE OF FINDINGS AND QUESTIONED COSTS For the Year Ended December 31, 2022 39 line reconciliation, and (3) requires an independent reviewer (title) to evidence review/approval before the SEFA is finalized. Views of Responsible Officials and Planned Corrective Action Management concurs and will implement a documented SEFA preparation process that prepares the SEFA directly from the general ledger and grant support schedules. A line-by-line reconciliation will be performed independently by the financial advisor and reviewed prior to finalization by the executive director, with documentation retained to support accuracy and completeness. Owned by: Financial Analyst By: December 31, 2023
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.
Assistance Listing Number, Federal Agency, and Program Name ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) ALN 10.557, U.S. Department of Agriculture, Supplemental Nutrition Program for Women, Infants, and Children (WIC) ALN 93.994, U.S. Department of Health and Human Services, Maternal and Child Health Services Block Grants to the State (MCHS) ALN 93.658, U.S. Department of Health and Human Services, Foster Care Title IV E (FCT) ALN 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program (ESG) ALN 97.042, U.S. Department of Homeland Security, Emergency Management Performance Grant (EMP) ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants ALN 17.258, 17.259, 17.278 U.S. Department of Labor, WIOA Cluster (WIOA), All Programs Federal Award Identification Number and Year All grants under the ALNs are impacted (direct and indirect). Pass through Entity ALN 97.036 Not applicable ALN 10.557 Michigan Department of Health and Human Services ALN 93.994 Michigan Department of Health and Human Services ALN 93.658 Michigan Department of Health and Human Services ALN 14.231 Not applicable ALN 97.042 Michigan Department of State Police Emergency Management and Homeland Security Division ALN 14.218 Not applicable ALN 17.258, 17.259, 17.278 Michigan Department of Labor and Economic Opportunity Workforce Development Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b) The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) initially presented for audit was not complete and accurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2022, the County expended approximately $86 million of federal funding. The funding was received by various departments within the County from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: $7,423,511 of expenditures were added to ALN 97.036 (FEMA) $1,400,310 of expenditures were removed from ALN 10.557 (WIC) $442,466 of expenditures were added to ALN 93.994 (MCHS) $349,148 of expenditures were added to ALN 93.658 (FCT) $311,271 of expenditures were added to ALN 14.231 (ESG) $125,758 of expenditures were added to ALN 97.042 (EMP) $94,744 of expenditures were added to ALN 14.218 (CDBG) $86,918 of expenditures were added to ALN 17.258, 17.259, 17.278 (WIOA) These cumulative errors resulted in the County presenting the auditors with several different versions of the SEFA to audit. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate, and, as a result, the errors had the following impact: ALN 97.036, FEMA, was understated, impacting major program determination ALN 10.557, WIC, was overstated, impacting major program determination. ALN 93.994, MCHS, ALN 93.658, FCT, ALN 14.231, ESG, ALN 97.042, EMP, ALN 14.218, CDBG, and ALNs 17.258, 17.259, 17.278, WIOA, were understated. There was no impact on major program determination. These errors have been corrected on the SEFA. Recommendation The County should implement a process to ensure the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The County agrees with the finding. A new report in Workday is being created to ensure all expenditures for federal awards are included.