Corrective Action Plans

Finding 402593 (2023-036)

Significant Deficiency 2023

State of Michigan

MI

Matching / Level of Effort / Earmarking Allowable Costs / Cost Principles Special Tests & Provisions

Finding 2023-036 CCDF Cluster, ALN 93.575 and 93.596 - Provider Health and Safety Requirements Management Views The Department of Licensing and Regulatory Affairs (LARA) and MiLEAP agree with the finding. The Child Care and Development Fund (CCDF) Cluster transferred from MDE to MiLEAP, and the chi...

Finding 2023-036 CCDF Cluster, ALN 93.575 and 93.596 - Provider Health and Safety Requirements Management Views The Department of Licensing and Regulatory Affairs (LARA) and MiLEAP agree with the finding. The Child Care and Development Fund (CCDF) Cluster transferred from MDE to MiLEAP, and the child care licensing responsibilities transferred from LARA to MiLEAP per Executive Order No. 2023-6 on December 1, 2023. Planned Corrective Action LARA and MiLEAP have been working to expand child care capacity across the State to meet the growing demand for care, which significantly increases the workload of licensing consultants. Also, more duties have been placed on licensing consultants to meet federal health and safety standards and monitoring requirements. Federal standards require the ratio of licensing consultants to child care providers and facilities is maintained at a level sufficient to enable the State to conduct effective inspections on a timely basis. To adhere to these federal ratio standards, health and safety standards, and timeliness of annual inspections, best practices recommend limiting each consultant’s caseload to a goal of 50 to 60 licensed facilities. The fiscal year 2025 executive budget recommendation includes an additional 30 Full-Time Equivalent positions as a significant step toward reaching case load best practices. After the audit period, the Child Care Licensing Bureau completed inspections of all facilities that were due by September 30, 2023, where the applicable health and safety requirements were reviewed. Additionally, LARA and MiLEAP launched the Child Care Hub Information Records Portal (CCHIRP) information technology system in September 2023. CCHIRP allows consultants to access information in a mobile format during onsite inspections, make real time updates to records, and confirm all applicable information with the provider while onsite. The new system supports a streamlined licensing process and additional efficiency for inspectors to perform inspections timely. Anticipated Completion Date October 1, 2025 Responsible Individual(s) Emily Laidlaw, MiLEAP

View Audit 309982

Finding 402592 (2023-035)

Significant Deficiency 2023

State of Michigan

MI

Questioned Costs Matching / Level of Effort / Earmarking § 200.516

Finding 2023-035 CCDF Cluster, ALN 93.575 and 93.596 - Client Eligibility Management Views MiLEAP and MDHHS agree with the finding. Planned Corrective Action MDHHS Public Assistance Operations (PAO), within ESA, will continue assisting the local office staff and Business Service Center (BSC) staf...

Finding 2023-035 CCDF Cluster, ALN 93.575 and 93.596 - Client Eligibility Management Views MiLEAP and MDHHS agree with the finding. Planned Corrective Action MDHHS Public Assistance Operations (PAO), within ESA, will continue assisting the local office staff and Business Service Center (BSC) staff by providing guidance on updated policies and processes. ESA will inform the local office staff and BSC staff of policy changes or noted trends during PAO’s Bridges Bits and Bytes communications sessions. ESA and MDE implemented a checklist on May 9, 2023, for local office staff to ensure documentation supports eligibility determinations. MDHHS will continue to use the finalized checklist at eligibility determination. Also, MDE launched a Child Development and Care case review SharePoint site on May 1, 2023, to share information with MDE and MDHHS staff, reduce errors, and promote integrity efforts for the program. These practices will continue to be carried out by MDHHS and MiLEAP moving forward, including the continuation of monthly meetings to discuss Child Development and Care errors. Anticipated Completion Date MDHHS assistance and guidance for local office and BSC staff is ongoing. Responsible Individual(s) Mariah Schaefer, MDHHS Gayle Vail, MDHHS Lisa Brewer-Walraven, MiLEAP

View Audit 309982 Questioned Costs: $1

Finding 402591 (2023-034)

Material Weakness 2023

State of Michigan

MI

Questioned Costs Allowable Costs / Cost Principles

Finding 2023-034 CCDF Cluster, ALN 93.575, and 93.596 - Child Care Stabilization Grant Management Views MiLEAP agrees with the finding. The Child Care and Development Fund (CCDF) Cluster transferred to MiLEAP by Executive Order No. 2023-6 on December 1, 2023 and is no longer part of MDE. Planned C...

Finding 2023-034 CCDF Cluster, ALN 93.575, and 93.596 - Child Care Stabilization Grant Management Views MiLEAP agrees with the finding. The Child Care and Development Fund (CCDF) Cluster transferred to MiLEAP by Executive Order No. 2023-6 on December 1, 2023 and is no longer part of MDE. Planned Corrective Action There is no additional child care stabilization grant funding expected for fiscal year 2024 or in future years. However, should federal or state funding become available, MiLEAP will review and update its procedures to include additional monitoring activities to ensure providers submit adequate documentation to support grant funds were used on authorized activities. Anticipated Completion Date Not applicable Responsible Individual(s) Lisa Brewer-Walraven, MiLEAP

View Audit 309982 Questioned Costs: $1

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 402558 (2023-033)

Significant Deficiency 2023

State of Michigan

MI

Matching / Level of Effort / Earmarking

Finding 2023-033 Title I Grants to Local Educational Agencies, ALN 84.010 - Supplement Not Supplant Monitoring Procedures Management Views MDE agrees with the finding. Planned Corrective Action For fiscal year 2024, MDE’s Office of Educational Supports resumed its full federal programs monitoring ...

Finding 2023-033 Title I Grants to Local Educational Agencies, ALN 84.010 - Supplement Not Supplant Monitoring Procedures Management Views MDE agrees with the finding. Planned Corrective Action For fiscal year 2024, MDE’s Office of Educational Supports resumed its full federal programs monitoring of LEAs to ensure they have a written methodology to demonstrate compliance with Title I, Part A supplement not supplant requirements. From February 2024 through May 2024, MDE conducted 29 on-site monitoring reviews with LEAs across the State and will continue completing the remaining on-site monitoring reviews, including close out activities, with the remaining LEAs. Anticipated Completion Date June 30, 2025 Responsible Individual(s) Michael Powell, MDE Shoua Vang, MDE

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 402552 (2023-031)

Significant Deficiency 2023

State of Michigan

MI

Reporting Internal Control / Segregation of Duties § 200.303

Finding 2023-031 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Workfront Change Management Process Management Views DTMB agrees with the finding. Planned Corrective Action DTMB has created an enhancement tracker to track key documentation throughout the change management process...

Finding 2023-031 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Workfront Change Management Process Management Views DTMB agrees with the finding. Planned Corrective Action DTMB has created an enhancement tracker to track key documentation throughout the change management process. This will ensure that DTMB maintains documentation of testing results at all stages and authorization and completion of all change order requests. DTMB has also enhanced documentation for meetings between program management and development teams. Anticipated Completion Date Completed Responsible Individual(s) Jennifer Edmonds, DTMB

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 402550 (2023-029)

Significant Deficiency 2023

State of Michigan

MI

Procurement, Suspension & Debarment § 200.214

Finding 2023-029 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Suspension and Debarment Process Management Views MDE agrees with the finding. Planned Corrective Action MDE and MiLEAP will update all grant agreements to include specific suspension and debarment language to comply ...

Finding 2023-029 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Suspension and Debarment Process Management Views MDE agrees with the finding. Planned Corrective Action MDE and MiLEAP will update all grant agreements to include specific suspension and debarment language to comply with 2 CFR 200.214. Anticipated Completion Date October 1, 2024 Responsible Individual(s) Spencer Simmons, MDE Juan Suasto, MDE Richard Lower, MiLEAP

View Audit 309982

Finding 402549 (2023-028)

Significant Deficiency 2023

State of Michigan

MI

Procurement, Suspension & Debarment § 200.327

Finding 2023-028 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Lack of Required Contract Provisions Management Views DTMB agrees with the finding. Planned Corrective Action The DTMB Design and Construction Division (DCD) provided a copy of the federal provisions to the vendor on...

Finding 2023-028 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Lack of Required Contract Provisions Management Views DTMB agrees with the finding. Planned Corrective Action The DTMB Design and Construction Division (DCD) provided a copy of the federal provisions to the vendor on May 1, 2024. DCD modified the contract to include the provisions on May 20, 2024. Furthermore, DCD is systematically reviewing all active contracts of this type, and completing contract modifications as necessary, to ensure all contracts include all applicable federal provisions as a proactive measure in the event federal funding is used in the future. Anticipated Completion Date June 28, 2024 Responsible Individual(s) Kristi Zakrzewski, DTMB

View Audit 309982

Finding 402548 (2023-027)

Significant Deficiency 2023

State of Michigan

MI

Allowable Costs / Cost Principles Internal Control / Segregation of Duties Period of Performance § 200.303

Finding 2023-027 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Insufficient Respite Payment Controls Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS began performing weekly reconciliations of the Medical Services Administration Manual Payment Syste...

Finding 2023-027 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Insufficient Respite Payment Controls Management Views MDHHS agrees with the finding. Planned Corrective Action MDHHS began performing weekly reconciliations of the Medical Services Administration Manual Payment System (MSAPay) payment details and Home Help beneficiary applications during February 2024, to ensure only approved outstanding applications are paid. In addition, MDHHS implemented additional steps in the MSAPay approval process during May 2024 to prevent duplicate payments, including a review process to verify the beneficiary did not receive previous payments related to the respite grant, prior to creating a new payment voucher. Anticipated Completion Date Completed Responsible Individual(s) Crystal Kline, MDHHS Jessica Bowen, MDHHS Elaina Brown, MDHHS

View Audit 309982

Finding 402547 (2023-026)

Significant Deficiency 2023

State of Michigan

MI

Allowable Costs / Cost Principles Cash Management Eligibility § 200.303

Finding 2023-026 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Grant Reimbursement Approval Procedures Management Views EGLE agrees with the finding. Planned Corrective Action EGLE’s Water Resources Division’s Administration staff reviewed the existing process with staff conducti...

Finding 2023-026 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027 - Grant Reimbursement Approval Procedures Management Views EGLE agrees with the finding. Planned Corrective Action EGLE’s Water Resources Division’s Administration staff reviewed the existing process with staff conducting the administrative review to ensure the technical review will be completed in advance of making any payment. If Administration staff have received a request for payment without the technical review, Administration staff will forward all documents received to the project manager to obtain the technical review. Once the technical review has been completed, Administration staff will conduct the administrative review and process the payment request. Additionally, EGLE subsequently reviewed the reimbursement request noted in the finding to ensure that the cumulative totals requested have been for projects that are consistent with the grant award. Anticipated Completion Date Completed Responsible Individual(s) Phil Argiroff, EGLE Amy Hicks, EGLE

View Audit 309982

Finding 402538 (2023-060)

None 2023

State of Michigan

MI

Special Tests & Provisions Allowable Costs / Cost Principles Reporting

Finding 2023-060 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-003.

View Audit 309982

Finding 402537 (2023-059)

None 2023

State of Michigan

MI

Special Tests & Provisions

Finding 2023-059 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-002.

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 402529 (2023-025)

Significant Deficiency 2023

State of Michigan

MI

Equipment & Real Property Management § 200.313

Finding 2023-025 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626 - Inaccurate Inventory of Equipment Management Views DNR agrees with the finding. Planned Corrective Action DNR sent an email communication on May 7, 2024, to the Department Budget Control Team as a reminder to all divisio...

Finding 2023-025 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626 - Inaccurate Inventory of Equipment Management Views DNR agrees with the finding. Planned Corrective Action DNR sent an email communication on May 7, 2024, to the Department Budget Control Team as a reminder to all divisions that the division inventory liaison will ensure that all capitalized equipment assets or special memo assets acquired have been tagged and recorded in the department inventory system. On a quarterly basis, the “Purchased Equipment Report” in BI will be used to identify purchases of equipment and verify that they have been recorded in the inventory system. Anticipated Completion Date Completed Responsible Individual(s) Jennifer Houle, DNR

View Audit 309982

Finding 402528 (2023-024)

Significant Deficiency 2023

State of Michigan

MI

Matching / Level of Effort / Earmarking Allowable Costs / Cost Principles Internal Control / Segregation of Duties § 200.303 § 200.306

Finding 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626 - Inappropriate Telecommunication Expenditures Management Views DNR agrees with the finding. Planned Corrective Action DNR sent an email communication on May 7, 2024, to the Department Budget Control Team as a reminder to u...

Finding 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626 - Inappropriate Telecommunication Expenditures Management Views DNR agrees with the finding. Planned Corrective Action DNR sent an email communication on May 7, 2024, to the Department Budget Control Team as a reminder to use the monthly DTMB telecom billing detail to verify all employees coded to fish and wildlife activities are valid. The monitoring of these charges will continue to occur as part of the interim quarterly assessments. Anticipated Completion Date Completed Responsible Individual(s) Jennifer Houle, DNR

View Audit 309982

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

Finding 402526 (2023-022)

Material Weakness 2023

State of Michigan

MI

Eligibility Allowable Costs / Cost Principles Material Weakness § 200.516

Finding 2023-022 Pandemic EBT Food Benefits, ALN 10.542 - Lack of Documentation for School Modality Data Reviews Management Views MDHHS disagrees that not formally documenting the review details on the log rises to the level of a material weakness and material noncompliance. MDHHS selects a sampl...

Finding 2023-022 Pandemic EBT Food Benefits, ALN 10.542 - Lack of Documentation for School Modality Data Reviews Management Views MDHHS disagrees that not formally documenting the review details on the log rises to the level of a material weakness and material noncompliance. MDHHS selects a sample of schools that submitted data and verifies the accuracy of Pandemic EBT (P-EBT) school modality data reported, documenting the schools reviewed within a log. Following the written business process, P-EBT staff first identify public information available to verify the school’s modality data such as the school’s calendar or news articles, and then reach out to school administration if public information is not available. If additional steps are required to reconcile the data, P-EBT staff document the support and results, sign off on the reconciliation, and forward to a supervisor for review. For this review period, no discrepancies were identified between what the school reported, and school websites. Since no discrepancies were noted, staff verbally communicated the review results to the manager and the log of sample items reviewed were kept within a shared drive. Planned Corrective Action MDHHS has no corrective action planned at this time as P-EBT benefit issuance ended as of May 11, 2023. No additional benefits will be issued in fiscal year 2024. Anticipated Completion Date Not applicable Responsible Individual(s) Kathy Cornell, MDHHS

View Audit 309982

Finding 402493 (2023-007)

Significant Deficiency 2023

State of Michigan

MI

Internal Control / Segregation of Duties § 200.303

Finding 2023-007 MDE, Change Management Process Management Views MDE agrees with the finding. Planned Corrective Action MDE and DTMB will work to implement a regular review of DevOps tickets to ensure documentation is maintained at all stages of the process, that change order requests are closed, ...

Finding 2023-007 MDE, Change Management Process Management Views MDE agrees with the finding. Planned Corrective Action MDE and DTMB will work to implement a regular review of DevOps tickets to ensure documentation is maintained at all stages of the process, that change order requests are closed, and the completion is documented in a timely manner. Anticipated Completion Date October 1, 2024 Responsible Individual(s) Monica Butler, MDE Sean Strom, DTMB

View Audit 309982

Finding 402492 (2023-006)

Significant Deficiency 2023

State of Michigan

MI

Subrecipient Monitoring Cash Management Reporting § 200.303

Finding 2023-006 MDE, Security Management and Access Controls Management Views The Michigan Department of Education (MDE) agrees with the finding. Planned Corrective Action For part a., as part of the Michigan Nutrition Data (MiND) 2.0 Implementation Project, MDE will institute a mechanism to capt...

Finding 2023-006 MDE, Security Management and Access Controls Management Views The Michigan Department of Education (MDE) agrees with the finding. Planned Corrective Action For part a., as part of the Michigan Nutrition Data (MiND) 2.0 Implementation Project, MDE will institute a mechanism to capture the person to whom the access has been delegated. MDE will review the policies and procedures with department staff that is responsible for security access controls for the Next Generation Grant, Application and Cash Management System (NexSys) to ensure proper access control policies are followed. For part b., MDE will update policies and procedures to ensure review of all accounts on a semi-annual basis. For parts c. and d., MDE will continue to work with DTMB to find more efficient ways to ensure all non-privileged users are recertified and improve the technical solution to deactivate users after 18 months of inactivity. For part e., as part of the movement of the grants management unit at MDE to a different office, MDE is reviewing the policies around high-risk transactions and will update the policies to meet established standards. Anticipated Completion Date October 1, 2024 Responsible Individual(s) David Judd, MDE

View Audit 309982

Finding 402477 (2023-021)

Material Weakness 2023

State of Michigan

MI

Special Tests & Provisions Procurement, Suspension & Debarment Cash Management § 200.516

Finding 2023-021 SNAP Cluster, ALN 10.551 and 10.561 - EBT Reconciliations Management Views MDHHS disagrees that a material weakness and material noncompliance exist. MDHHS federal reporting conducts a daily reconciliation of federal draws and authorizations to retailers based on vendor EBT reports...

Finding 2023-021 SNAP Cluster, ALN 10.551 and 10.561 - EBT Reconciliations Management Views MDHHS disagrees that a material weakness and material noncompliance exist. MDHHS federal reporting conducts a daily reconciliation of federal draws and authorizations to retailers based on vendor EBT reports. In addition, MDHHS conducts a monthly reconciliation between Bridges, Bridges data warehouse, and vendor EBT reports using daily data to ensure the client information in Bridges and Bridges data warehouse is accurate. The monthly reconciliation process does not impact the federal draw because the daily reconciliation of the vendor EBT report is used for this purpose. MDHHS provided detailed and accurate descriptions of MDHHS daily and monthly EBT reconciliations to the designated federal awarding agency contacts at the United States Department of Agriculture Food and Nutrition Service Agency that are familiar with MDHHS processes and received confirmation that the current reconciliation processes in place are sufficient to comply with federal regulations. Planned Corrective Action MDHHS disagrees with the finding and does not intend to take further action. Anticipated Completion Date Not applicable Responsible Individual(s) Sara Gross, MDHHS

View Audit 309982

Finding 402476 (2023-020)

Significant Deficiency 2023

State of Michigan

MI

Allowable Costs / Cost Principles Internal Control / Segregation of Duties Special Tests & Provisions

Finding 2023-020 SNAP Cluster, ALN 10.551 and 10.561 - System and Organization Controls Management Views MDHHS agrees with the finding. Planned Corrective Action For part a., the Electronic Benefits Transfer (EBT) service provider releases all SOC reports via an administrative view on the provide...

Finding 2023-020 SNAP Cluster, ALN 10.551 and 10.561 - System and Organization Controls Management Views MDHHS agrees with the finding. Planned Corrective Action For part a., the Electronic Benefits Transfer (EBT) service provider releases all SOC reports via an administrative view on the provider website. MDHHS will maintain documentation of the date the reports are pulled from the EBT service provider site. Additionally, MDHHS will modify the review process so that the individual completing the evaluation is different from the individual approving the evaluation to ensure segregation of duties is maintained. For parts b. and c., MDHHS will assess the current process and make improvements as needed to ensure subservice organizations are adequately evaluated. Based on the evaluation, MDHHS will perform reviews of sub-organization SOC reports where required. Anticipated Completion Date September 30, 2024 Responsible Individual(s) Andrew Piper, DHHS Dani Wager, DHHS

View Audit 309982

Finding 402475 (2023-008)

Significant Deficiency 2023

State of Michigan

MI

Questioned Costs Allowable Costs / Cost Principles § 200.306 § 200.516

Finding 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors...

Finding 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0 percent of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor’s review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to the Low-Income Home Energy Assistance Program (LIHEAP) out of $1,732,426,561 (0.0009 percent) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Planned Corrective Action For part a., MDHHS will ensure the vendor’s RMTS report is modified to resolve formatting issues related to trailing zeros in SIGMA codes. Additionally, the vendor and MDHHS staff will individually check to ensure accurate SIGMA codes for those with trailing zeros. For part b., MDHHS will implement additional quality control processes when gathering the participant list for the RMTS. MDHHS will modify the reports used to gather the participant list to eliminate filtered restrictions for sub-unit codes to ensure all eligible participants are included in the time studies. Anticipated Completion Date MDHHS will implement additional quality control measures effective July 2024. Responsible Individual(s) Suzanne Kyes, MDHHS Matt McCool, MDHHS

View Audit 309982 Questioned Costs: $1

Corrective Action Plans

Filters