Corrective Action Plans

Finding 403085 (2023-003)

None 2023

CA

Reporting Subrecipient Monitoring

A) El Proyecto will implement additional monitoring measures to ensure that preparation and the submission of grant expenditure reports by grant staff are submitted in a timely manner. Person Responsible: Yulin Lin Position of Responsible Party: Controller Completion Date: September 30, 2024 B) El P...

A) El Proyecto will implement additional monitoring measures to ensure that preparation and the submission of grant expenditure reports by grant staff are submitted in a timely manner. Person Responsible: Yulin Lin Position of Responsible Party: Controller Completion Date: September 30, 2024 B) El Proyecto will implement monitoring measures to ensure that only authorized personnel can review and submit reports. This also includes signing off on all needed contracts. Person Responsible: Yulin Lin Position of Responsible Party: Controller Completion Date: September 30, 2024

View Audit 310230

Finding 403083 (2023-001)

None 2023

El Proyecto Del Barrio, Inc.

CA

Subrecipient Monitoring Reporting

Ricardo Ornelas, Chief Financial Officer, reviewed the processes for preparation of the SEFA and incorporated additional procedures to ensure errors are identified and corrected prior to submission, including multiple levels of review for the prepared SEFA to ensure the information reported in the S...

Ricardo Ornelas, Chief Financial Officer, reviewed the processes for preparation of the SEFA and incorporated additional procedures to ensure errors are identified and corrected prior to submission, including multiple levels of review for the prepared SEFA to ensure the information reported in the SEFA agrees to the contract, amendment(s), payment confirmation, and underlying accounting records. In addition, management will adopt the recommendations above.

View Audit 310230

Finding 403079 (2023-002)

None 2023

El Proyecto Del Barrio, Inc.

CA

Questioned Costs Special Tests & Provisions Subrecipient Monitoring

El Proyecto will continue to implement the following measures to ensure compliance with the sliding fee discount program, and consistently assess patient income and family size. El Proyecto will continue to provide ongoing training to clinic staff who evaluate the sliding fee application at its clin...

El Proyecto will continue to implement the following measures to ensure compliance with the sliding fee discount program, and consistently assess patient income and family size. El Proyecto will continue to provide ongoing training to clinic staff who evaluate the sliding fee application at its clinic locations. The training will consist of reviewing sliding fee program policies and procedures along with all applicable patient forms, sliding fee scale, and patient eligibility. Person Responsible: Leticia Vasquez Position of Responsible Party: Billing Manager Completion Date: September 30, 2024

View Audit 310230 Questioned Costs: $1

Finding 403064 (2023-006)

Significant Deficiency 2023

Resilience: Advocates for Ending Violence

MI

Allowable Costs / Cost Principles Cash Management Internal Control / Segregation of Duties

Finding 2023-006: Crime Victim Assistance Documented Review and Approval Procedures U.S. Department of Justice Pass-through Entity: Michigan Department of Health and Human Services Assistance Listing Number: 16.575 Award Numbers: E20232575-00, E20233017-00, E20233431-00 Award Year End: Septemb...

Finding 2023-006: Crime Victim Assistance Documented Review and Approval Procedures U.S. Department of Justice Pass-through Entity: Michigan Department of Health and Human Services Assistance Listing Number: 16.575 Award Numbers: E20232575-00, E20233017-00, E20233431-00 Award Year End: September 30, 2023 Recommendation: The Organization should establish procedures to require the documented review and approval of all indirect cost calculations, cash management requests for funds, and reports by an individual with adequate skills, knowledge, and experience prior to submission. Action Taken: The Organization will establish the necessary policies and procedures to require the documented review and approval of all indirect calculations, cash management requests for funds and performance reports on a monthly basis prior to submission with documented approval. Responsible Person and Anticipated Completion Date: The Executive Director will oversee the implementation of this plan by September 30, 2024.

View Audit 310209

Finding 403063 (2023-005)

Material Weakness 2023

Resilience: Advocates for Ending Violence

MI

Subrecipient Monitoring Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Finding 2023-005: MATERIAL WEAKNESS—Uniform Guidance Written Internal Control Procedures U.S. Department of Justice Pass-through Entity: Michigan Department of Health and Human Services Assistance Listing Number: 16.575 Award Numbers: E20232575-00, E20233017-00, E20233431-00 Award Year End: Sep...

Finding 2023-005: MATERIAL WEAKNESS—Uniform Guidance Written Internal Control Procedures U.S. Department of Justice Pass-through Entity: Michigan Department of Health and Human Services Assistance Listing Number: 16.575 Award Numbers: E20232575-00, E20233017-00, E20233431-00 Award Year End: September 30, 2023 Recommendation: The Organization should establish procedures to require the documented review and approval of all indirect cost calculations, cash management requests for funds, and reports by an individual with adequate skills, knowledge, and experience prior to submission. Action Taken: The Organization will establish the necessary policies and procedures for managing its federal awards in compliance with federal requirements. Responsible Person and Anticipated Completion Date: The Executive Director will oversee the implementation of this plan by September 30, 2024.

View Audit 310209

Finding 402905 (2023-003)

Material Weakness 2023

Mayo Clinic

MN

Subrecipient Monitoring

Federal Program Information Federal Agencies: U.S. Department of Health and Human Services and U.S. Department of Defense Federal Cluster: Research and Development (R&D) Assistance Listing Nos.: 12.RDC, 12.300, 93.393, 93.396, 93.847, 93.853, 93.859 Award Numbers: Various Award Periods: Various Co...

Federal Program Information Federal Agencies: U.S. Department of Health and Human Services and U.S. Department of Defense Federal Cluster: Research and Development (R&D) Assistance Listing Nos.: 12.RDC, 12.300, 93.393, 93.396, 93.847, 93.853, 93.859 Award Numbers: Various Award Periods: Various Corrective Action Planned Monthly/quarterly reviews, including completion of subaward monitoring checklists, resumed in January 2024. Management's expectations have been communicated to those responsible for the control process regarding timely checklist completion and retention of documentation. Persons Responsible for Corrective Action Susan Norby, Division Chair - Financial and Accounting Services, Research Finance Sarah Ward, Vice Chair - Financial and Accounting Services, Research Finance Target Completion Date January 31, 2024

View Audit 310163

Finding 402814 (2023-002)

Material Weakness 2023

Housing Authority of the City of Greenville

NC

HUD Housing Programs Subrecipient Monitoring Eligibility

Finding 2023-002 - Continuumof Care Tenant Files - Eligibility - Internal Control over Tenant Files - Noncomplianceand Material Weakness Corrective Action Plan: The Housing Authority of the City of Greenville (HACG) has implemented and/or will implement the follow ing by our fiscal year-end Septemb...

Finding 2023-002 - Continuumof Care Tenant Files - Eligibility - Internal Control over Tenant Files - Noncomplianceand Material Weakness Corrective Action Plan: The Housing Authority of the City of Greenville (HACG) has implemented and/or will implement the follow ing by our fiscal year-end September 30, 2024: a. Program Coordinators will maintain all Contin uum of Care Tenant files in individual file folders designated by special purpose voucher programs. All loosedocuments will be anchored in tenant files. b. An action plan has been developed for the Continuum of Care programs to ensure that all program files are HUD, State, and GHA compliant starting with October l, 2023, files through the current. c. Continuum of Care fiscal year 2024 (October 2023-September 2024) re exams and interim s will be caught up and complete as they become effective. All tenant files will be reviewed and compliant by FYE2024. d. All la te/overdue re-exams will be compliant by FYE2024. e. During FYE2024, the Deputy Executive Director/COOwill perform qualit y controls on all Continuum of Care tenant files processed each month prior to ini tialization c2_5th 3olh of each month). f. File checklist sheets will be placed in each file upon quality control review to be signed off by the Deputy Executive Director/COO. g. Additional training will be required and ongoing for Program Coordinators. h. Other internal control measures will be implemented to elim inate future audit findings. Person Responsible: Shanetta Moye, Deputy Executive Director/COO Anticipated Completion Date: September 30, 2024

View Audit 309996

Finding 402813 (2023-001)

Significant Deficiency 2023

Housing Authority of the City of Greenville

NC

HUD Housing Programs Subrecipient Monitoring Eligibility

Finding 2023-001 - Housing Choice Voucher Tenant Files - Eligibility - Internal Control over Tenant Files - Noncompliance andSignificant Deficiency Corrective Action Plan: The Housing Authority of the City of Greenville (HACG) has implemented and/or will implement the following by our fisca l year-...

Finding 2023-001 - Housing Choice Voucher Tenant Files - Eligibility - Internal Control over Tenant Files - Noncompliance andSignificant Deficiency Corrective Action Plan: The Housing Authority of the City of Greenville (HACG) has implemented and/or will implement the following by our fisca l year-end September 30, 2024: a. Hous ing Choice Voucher tenant files will be reviewed and quality controlled each mo nth prior to initiali za tio n (25t 11- 30 111 of each month) by the Deputy Executive Director/COO. b. An action pla n has been develo ped for the Housing Choice Voucher department to ensure that all Housing Choice Voucher files are HUD and GHA compliant starting with October 1, 2023 files through the cun-e nt. c. Hous ing Choice Voucher calendar-year 2024 (October 2023-September 2024) re-exams are substantially complete, as they become effective. All tenant files will be reviewedand HUD-co mpliant by FYE2024. d. During FYE2024, the Deputy Executive Director/COO will perform 40% quality controls of the monthly re-exams processed by the Housing Specialists. e. File checklist sheets will be placed in each file upon quality control review to be signed off by the Deputy Executive Director/COO. f. Additional training has been and will be made available as necessary. g. Other interna l control measures will be implemented as deemed necessary by the Deputy Executive Director/COO, to eliminate future audit findings. Person Responsible: Shanetta Moye, Deputy Executive Director/COO Anticipated Completion Date: September 30, 2024

View Audit 309996

Finding 402762 (2023-057)

Material Weakness 2023

State of Michigan

MI

Questioned Costs Eligibility Subrecipient Monitoring § 200.516

Finding 2023-057 Low-Income Home Energy Assistance, ALN 93.568 - Eligibility Determinations Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS implemented quarterly case reads beginning in fiscal year 2023, and during April 2023, MDHHS began monthly meetings with BSCs ...

Finding 2023-057 Low-Income Home Energy Assistance, ALN 93.568 - Eligibility Determinations Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS implemented quarterly case reads beginning in fiscal year 2023, and during April 2023, MDHHS began monthly meetings with BSCs to discuss common errors, answer questions, provide guidance, and on a quarterly basis discuss the results of the SER case reads. In addition, based on the results of the quarterly case reads, MDHHS updated SER policy on October 1, 2023 to require additional verification sources. MDHHS will continue to communicate with BSCs and local offices regarding the requirements to obtain adequate verification and maintain sufficient documentation to support SER processing. MDHHS will also continue to provide direct SER guidance and clarification through the SER mailbox. Anticipated Completion Date Ongoing Responsible Individual(s) Nicole Denson-Sogbaka, MDHHS Kent Schulze, MDHHS Julie McLaughlin, MDHHS Nick Sakon, MDHHS Erich Holzhausen, MDHHS

View Audit 309982 Questioned Costs: $1

Finding 402754 (2023-055)

Material Weakness 2023

State of Michigan

MI

Subrecipient Monitoring

Finding 2023-055 Refugee and Entrant Assistance State/Replacement Designee Administered Programs, ALN 93.566 - Subrecipient Audits and Subaward Information Management Views LEO agrees with the finding. Planned Corrective Action For part a., the LEO Internal Controls unit has hired a compliance mo...

Finding 2023-055 Refugee and Entrant Assistance State/Replacement Designee Administered Programs, ALN 93.566 - Subrecipient Audits and Subaward Information Management Views LEO agrees with the finding. Planned Corrective Action For part a., the LEO Internal Controls unit has hired a compliance monitoring manager, who will implement a process to identify and document subrecipients that require a single audit. The manager’s team will be responsible for conducting subrecipient monitoring activities for LEO agencies that lack staffing resources to conduct them; and will provide guidance and oversight to newly established agency monitoring units. For part b., the grant cover sheets contained the correct FAIN at the time the agreement was established, but changed as they were amended and/or transcended multiple fiscal years. Going forward, the LEO Office of Global Michigan will ensure that accurate subaward information is provided to subrecipients by working with the LEO Procurement unit and Finance unit on updating procedures to ensure that amendments include updated cover sheets with the current FAINs as federal grants are updated with additional annual funding. Anticipated Completion Date December 31, 2024 Responsible Individual(s) a. Allen Williams, LEO b. Ben Cabinaw, LEO

View Audit 309982

Finding 402753 (2023-054)

Material Weakness 2023

State of Michigan

MI

Subrecipient Monitoring Material Weakness Reporting

Finding 2023-054 Refugee and Entrant Assistance State/Replacement Designee Administered Programs, ALN 93.566 - FFATA Reporting Management Views LEO agrees with the finding. Planned Corrective Action LEO FSD will implement a policy and procedure and will assign the tasks outlined in the policy and ...

Finding 2023-054 Refugee and Entrant Assistance State/Replacement Designee Administered Programs, ALN 93.566 - FFATA Reporting Management Views LEO agrees with the finding. Planned Corrective Action LEO FSD will implement a policy and procedure and will assign the tasks outlined in the policy and procedure to staff to ensure that FFATA reporting is completed on a monthly basis. Anticipated Completion Date June 30, 2024 Responsible Individual(s) Dawn Lake, LEO Lora MacKay, LEO

View Audit 309982

Finding 402751 (2023-052)

Material Weakness 2023

State of Michigan

MI

Questioned Costs Allowable Costs / Cost Principles Eligibility

Finding 2023-052 Refugee and Entrant Assistance State/Replacement Designee Administered Programs, ALN 93.566 - Assistance to Ineligible Refugees Management Views LEO and MDHHS agree with the finding. Planned Corrective Action For part a., MDHHS will issue a memo to BSCs and local offices and provi...

Finding 2023-052 Refugee and Entrant Assistance State/Replacement Designee Administered Programs, ALN 93.566 - Assistance to Ineligible Refugees Management Views LEO and MDHHS agree with the finding. Planned Corrective Action For part a., MDHHS will issue a memo to BSCs and local offices and provide training to local office staff regarding the requirements to maintain sufficient documentation to support Refugee and Entrant Assistance State/Replacement Designee Administered Programs eligibility. For part b., MDHHS corrected the reporting defect and properly adjusted the accounting records. MDHHS already had a process in place to identify the reporting defect and make necessary accounting adjustments. MDHHS will ensure that accounting adjustments are prioritized for any future reporting defects. Anticipated Completion Date a. September 30, 2024 b. Completed Responsible Individual(s) a. Mariah Schaefer, MDHHS b. Trish Bouck, MDHHS

View Audit 309982 Questioned Costs: $1

Finding 402750 (2023-051)

Significant Deficiency 2023

State of Michigan

MI

Subrecipient Monitoring Allowable Costs / Cost Principles Period of Performance

Finding 2023-051 Refugee and Entrant Assistance State/Replacement Designee Administered Programs, ALN 93.566 - Salesforce Security Management and Access Controls Management Views LEO agrees with the finding. Planned Corrective Action The LEO Office of Global Michigan will update established proced...

Finding 2023-051 Refugee and Entrant Assistance State/Replacement Designee Administered Programs, ALN 93.566 - Salesforce Security Management and Access Controls Management Views LEO agrees with the finding. Planned Corrective Action The LEO Office of Global Michigan will update established procedures and tracking logs to ensure compliance with SOM Technical Standard 1340.00.020.01. The LEO Internal Controls unit is in the process of establishing a grants compliance team that will perform validation of the ongoing reviews. Anticipated Completion Date December 31, 2024 Responsible Individual(s) Ben Cabinaw, LEO Allen Williams, LEO

View Audit 309982

Finding 402740 (2023-049)

Significant Deficiency 2023

State of Michigan

MI

Subrecipient Monitoring

Finding 2023-049 Temporary Assistance for Needy Families, ALN 93.558 - Risk Assessment and During-the-Award Monitoring Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS monitors financial and programmatic reports submitted by the grantee and communicates with the gran...

Finding 2023-049 Temporary Assistance for Needy Families, ALN 93.558 - Risk Assessment and During-the-Award Monitoring Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS monitors financial and programmatic reports submitted by the grantee and communicates with the grantee on a consistent basis. MDHHS will evaluate the risk assessment results to determine if additional monitoring is needed. MDHHS will also develop a program template to document monitoring activities, including follow-up action related to deficiencies noted during monitoring. Anticipated Completion Date July 31, 2024 Responsible Individual(s) Jessica Altenbernt, MDHHS Amber Troupe, MDHHS

View Audit 309982

Finding 402737 (2023-046)

Significant Deficiency 2023

State of Michigan

MI

Matching / Level of Effort / Earmarking Subrecipient Monitoring Allowable Costs / Cost Principles

Finding 2023-046 Temporary Assistance for Needy Families, ALN 93.558 - MARS User Access Management Views The Department of Labor and Economic Opportunity (LEO) agrees with the finding. The Management of Awards to Recipients System (MARS) is an older legacy system that does not automatically deactiv...

Finding 2023-046 Temporary Assistance for Needy Families, ALN 93.558 - MARS User Access Management Views The Department of Labor and Economic Opportunity (LEO) agrees with the finding. The Management of Awards to Recipients System (MARS) is an older legacy system that does not automatically deactivate user accounts after 60 days of inactivity. The LEO Finance unit continues to experience challenges related to staffing shortages and competing priorities. Accordingly, the LEO Internal Controls unit will assist the LEO Finance unit in the interim with implementing corrective action until this legacy application is replaced, and new procedures are implemented. Planned Corrective Action LEO has received a Technical Review Board exception from SOM Technical Standard 1340.00.020.01 (Access Control Standard). The exception allows MARS inactive accounts to remain open for up to 90 days - an interval at which Michigan Works! Agency administrators make quarterly approvals (sometimes their only activity on the system). The exception was granted on April 12, 2024, and is valid through October 9, 2024, but may be extended. LEO staff has begun manually pulling an inactive users report monthly and manually deactivating accounts that were not accessed during the previous 90-day period. LEO is currently working on a request for proposal to replace MARS and anticipates that the new system will be able to automatically deactivate user accounts in accordance with the SOM Technical Standard. The LEO Finance unit has updated its procedures to reflect its interim process and will further revise them once the MARS replacement system goes live. Anticipated Completion Date September 30, 2026 Responsible Individual(s) Lora MacKay, LEO Allen Williams, LEO

View Audit 309982

Finding 402736 (2023-045)

Significant Deficiency 2023

State of Michigan

MI

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Eligibility

Finding 2023-045 Temporary Assistance for Needy Families, ALN 93.558 - MiSACWIS Security Management and Access Controls Management Views MDHHS agrees with the finding. Planned Corrective Action For parts a. and c., MDHHS will continue to provide training for local office security coordinators (LOS...

Finding 2023-045 Temporary Assistance for Needy Families, ALN 93.558 - MiSACWIS Security Management and Access Controls Management Views MDHHS agrees with the finding. Planned Corrective Action For parts a. and c., MDHHS will continue to provide training for local office security coordinators (LOSCs) via quarterly webinars to emphasize the appropriate procedures for granting access, reviewing, and comparing access. All new information related to security access is presented to the LOSCs during the webinars and one-on-one assistance is available as needed for additional support. For part b., MDHHS currently has a process in place to review the user narrative describing the incompatible role exceptions within the DSA Michigan Statewide Automated Child Welfare Information System (MiSACWIS) request as part of the approval process. MDHHS will continue to work on adding an incompatible role form in the DSA MiSACWIS request with automated routing for appropriate approval. Anticipated Completion Date a. and c. Corrective action is ongoing. b. MDHHS has not yet determined an anticipated completion date because implementation is dependent on funding, approval, and prioritization of other proposed system changes. Responsible Individual(s) Alana Lowe, MDHHS Deon Nelson, MDHHS

View Audit 309982

Finding 402721 (2023-043)

Significant Deficiency 2023

State of Michigan

MI

Special Tests & Provisions Subrecipient Monitoring Equipment & Real Property Management

Finding 2023-043 Immunization Cooperative Agreements, ALN 93.268 - MCIR User Access Controls Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS received approval for an exception allowing them to disable inactive accounts after 120 days instead of 60 days, which was i...

Finding 2023-043 Immunization Cooperative Agreements, ALN 93.268 - MCIR User Access Controls Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS received approval for an exception allowing them to disable inactive accounts after 120 days instead of 60 days, which was implemented May 8, 2024. The exception was requested and granted because the Michigan Care Improvement Registry (MCIR) users include non-SOM users that do not log in as frequently. MDHHS will develop and implement a manual process to deactivate users from the MDHHS sites in MCIR that have not been accessed in 120 days. Anticipated Completion Date September 30, 2024 Responsible Individual(s) Abigail Cheney, MDHHS Ryan Malosh, MDHHS Beatrice Salada, MDHHS

View Audit 309982

Finding 402719 (2023-042)

Significant Deficiency 2023

State of Michigan

MI

Subrecipient Monitoring

Finding 2023-042 Public Health Emergency Preparedness, ALN 93.069 - Risk Assessment and During-the-Award Monitoring Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS hired a financial analyst during May 2024 to assist with subrecipient monitoring. MDHHS evaluated the...

Finding 2023-042 Public Health Emergency Preparedness, ALN 93.069 - Risk Assessment and During-the-Award Monitoring Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS hired a financial analyst during May 2024 to assist with subrecipient monitoring. MDHHS evaluated the subrecipient monitoring plan and revised as needed. Although MDHHS conducts quarterly reviews of Financial Status Reports and requests supporting documentation based on reviews, MDHHS will annually consider if any additional monitoring activities are necessary based on the annual risk assessment results. Anticipated Completion Date Completed Responsible Individual(s) Jay Fiedler, MDHHS Brianna Briggs, MDHHS

View Audit 309982

Finding 402594 (2023-037)

Significant Deficiency 2023

State of Michigan

MI

Subrecipient Monitoring

Finding 2023-037 CCDF Cluster, ALN 93.575 and 93.596 - Subaward Information Management Views MiLEAP agrees with the finding. Planned Corrective Action MiLEAP will develop procedures for reviewing award documents, which will include verifying a unique entity identifier and federal award project d...

Finding 2023-037 CCDF Cluster, ALN 93.575 and 93.596 - Subaward Information Management Views MiLEAP agrees with the finding. Planned Corrective Action MiLEAP will develop procedures for reviewing award documents, which will include verifying a unique entity identifier and federal award project description are included on each award. Anticipated Completion Date October 1, 2024 Responsible Individual(s) Lisa Brewer Walraven, MiLEAP

View Audit 309982

Finding 402590 (2023-010)

Material Weakness 2023

State of Michigan

MI

Subrecipient Monitoring Reporting Material Weakness

Finding 2023-010 MDE - FFATA Reporting Management Views MDE and the Michigan Department of Lifelong Education, Advancement, and Potential (MiLEAP) agree with the finding. Planned Corrective Action For part a., MDE and MiLEAP, going forward, will verify all grants will be tracked for the Federal Fu...

Finding 2023-010 MDE - FFATA Reporting Management Views MDE and the Michigan Department of Lifelong Education, Advancement, and Potential (MiLEAP) agree with the finding. Planned Corrective Action For part a., MDE and MiLEAP, going forward, will verify all grants will be tracked for the Federal Funding Accountability and Transparency Act (FFATA), reviewing all systems the grants are awarded from. For part b.1., MDE and MiLEAP will continue to coordinate with the program offices to improve the FFATA reporting process in order to submit subaward information in accordance with FFATA and other applicable federal guidance. The corrective action will begin on October 1, 2024 with an anticipated completion date of October 31, 2025. For part b.2., MDE and MiLEAP have completed FFATA reporting using the actual expenditures for the purpose of verifying subrecipients have not exceeded the awarded amounts. To meet the requirements as outlined in 2 CFR 170, MDE and MiLEAP will update the reporting process to include all key data elements, including the net dollar amount of federal funds awarded to the subawardee, including modifications. Part b.3., MDE will work with all MDE program offices and MiLEAP to include the correct program descriptions in the FFATA reporting. Anticipated Completion Date a. Completed b.1. October 31, 2025 b.2. October 31, 2025 b.3. December 31, 2024 Responsible Individual(s) Spencer Simmons, MDE Bethanie Kramer, MiLEAP

View Audit 309982

Finding 402557 (2023-012)

Significant Deficiency 2023

State of Michigan

MI

Subrecipient Monitoring Internal Control / Segregation of Duties

Finding 2023-012 Title I Grants to Local Educational Agencies, ALN 84.010 and Supporting Effective Instruction State Grants, ALN 84.367 - Participation of Private School Children Management Views MDE agrees with the finding. Planned Corrective Action In spring 2023, the MDE Office of Educational S...

Finding 2023-012 Title I Grants to Local Educational Agencies, ALN 84.010 and Supporting Effective Instruction State Grants, ALN 84.367 - Participation of Private School Children Management Views MDE agrees with the finding. Planned Corrective Action In spring 2023, the MDE Office of Educational Supports developed a new system of support and created a new Local Education Agency (LEA) application and documentation collection process in the MDE Grant Electronic Monitoring System/Michigan Administrative Review System (GEMS/MARS) for fiscal year 2024. In September 2023, a new Equitable Services Ombudsman was hired to work collaboratively with leadership in the Office of Educational Supports to support LEAs and monitor the private school consultation process according to federal requirements. In January 2024, the LEA collection process in GEMS/MARS began for the Equitable Service Ombudsman to review LEAs consultation documents and provide ongoing technical assistance and support. MDE anticipates developing additional LEA resources and supports by June 30, 2025. Anticipated Completion Date June 30, 2025 Responsible Individual(s) Michael Powell, MDE Chanel DeGuzman, MDE

View Audit 309982

Finding 402553 (2023-032)

Significant Deficiency 2023

State of Michigan

MI

Subrecipient Monitoring § 200.332

Finding 2023-032 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Subaward Information Management Views MDHHS and MDE agree with the finding. Planned Corrective Action For part a., MDHHS updated the grantee profile in EGrAMS with the correct unique entity identifier (UEI). In additi...

Finding 2023-032 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Subaward Information Management Views MDHHS and MDE agree with the finding. Planned Corrective Action For part a., MDHHS updated the grantee profile in EGrAMS with the correct unique entity identifier (UEI). In addition, the MDHHS Federal Reporting Section will ensure all federal grant awards are recorded in SIGMA and included on the department’s Grants Received Report. The Grants Received Report will be maintained on the department’s SharePoint site for use by those within the department. All data elements required to comply with federal funding requirements, such as 2 CFR 200, will be included on the Grants Received Report. In the event data elements are missing from the report, the MDHHS Federal Reporting Section will follow up with the awarding agency, program area, or others to update the missing data elements within 30 days of receipt of the award. The Bureau of Grants and Purchasing will use the information from the Grants Received Report to communicate information to the subrecipients in accordance with 2 CFR 200. For part b., the grant award notification (GAN) recipient information is pulled directly from the Education Entity Master, including the UEI and the Federal Award Identification Number (FAIN). The GAN template is included as part of the grant requirement gathering process. Beginning with the 2024 fiscal year, MDE will require all grant awards using MDE Coronavirus State and Local Fiscal Recovery Funds to use this MDE GAN notification process. For those subrecipients whose grants continue past fiscal year 2023, MDE will evaluate any exceptions and determine whether subsequent communication can be made to the subrecipients to provide the correct subaward information. Anticipated Completion Date a. September 30, 2024 b. October 1, 2024 Responsible Individual(s) a. Jeanette Hensler and Steve Bendele, MDHHS b. Spencer Simmons, MDE Richard Lower, MiLEAP

View Audit 309982

Finding 402551 (2023-030)

Significant Deficiency 2023

State of Michigan

MI

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties § 200.303

Finding 2023-030 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Workfront Security Management and Access Controls Management Views DTMB agrees with the finding. Planned Corrective Action For part a., DTMB has implemented processes and documentation to track user access requests to...

Finding 2023-030 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Workfront Security Management and Access Controls Management Views DTMB agrees with the finding. Planned Corrective Action For part a., DTMB has implemented processes and documentation to track user access requests to support approval of the system role for all Workfront users. For part b., DTMB has updated processes to ensure it maintains documentation to support the review of all privileged Workfront accounts on a semiannual basis. Anticipated Completion Date Completed Responsible Individual(s) Jennifer Edmonds, DTMB

View Audit 309982

Finding 402536 (2023-058)

Material Weakness 2023

State of Michigan

MI

Questioned Costs Allowable Costs / Cost Principles Eligibility

Finding 2023-058 Unemployment Insurance, ALN 17.225 See Department of Labor and Economic Opportunity, Unemployment Insurance Agency - Unemployment Compensation Fund, Report on Expenditure of Federal Awards, Year Ended September 30, 2023, Corrective Action Plan, Finding 2023-001.

View Audit 309982 Questioned Costs: $1

Finding 402527 (2023-023)

Significant Deficiency 2023

State of Michigan

MI

Internal Control / Segregation of Duties Subrecipient Monitoring Reporting § 200.302

Finding 2023-023 Pandemic EBT Food Benefits, ALN 10.542 - Accuracy of Financial Reports Management Views MDHHS agrees with the finding. Planned Corrective Action The Food and Nutrition Service has ended the P-EBT program and there will be no additional expenses after February 2024. However, for th...

Finding 2023-023 Pandemic EBT Food Benefits, ALN 10.542 - Accuracy of Financial Reports Management Views MDHHS agrees with the finding. Planned Corrective Action The Food and Nutrition Service has ended the P-EBT program and there will be no additional expenses after February 2024. However, for the last report submitted during May 2024, MDHHS implemented a report review process prior to certification to ensure the P-EBT financial report information is accurate. Anticipated Completion Date Completed Responsible Individual(s) Bethany Cabanaw, MDHHS

View Audit 309982

Corrective Action Plans

Filters