Corrective Action Plans

View of Responsible Officials The State largely concurs with the findings and recommendations and has either implemented procedures to address the identified conditions already or will do so. With regard to condition A(a) and (b), although the State illustrated that it includes clauses related to allowed costs in its subawards, including direct and indirect costs, it will work to ensure that agencies entering into such agreements clearly indicate the terms required by Uniform Guidance, including permitted indirect cost rates and whether the award is for R&D. With regard to condition B, the State agrees that risk assessments should have been completed and has since implemented a framework to help ensure that agencies are more consistently conducting and documenting subrecipient risk assessments. With regard to condition C, the State concurs and has already implemented an agency-wide framework to help ensure procedures and policies are in place concerning Uniform Guidance Report review and the issuance of any necessary management decision letters, to the extent required. It is worth noting that the State in most cases has timely conducted risk assessments of subrecipients and reviewed relevant Uniform Guidance Reports, but its corrective actions will result in better documentation and more consistent and timelier follow through. Anticipated Completion Date: The corrective actions indicated above relative to conditions B and C have already been implemented as of the date of this response. The State will work to address Condition A before the end of the current Fiscal Year. Contact Person: Chase Hagaman and Steve Giovinelli

Condition: For all four subawards selected for testing, the identification of the award being Research and Development (R&D) was not noted. Further, for two of the four subawards selected for testing, there was missing information from the subaward including (1) Recipient DUNS number (2) Unique Federal Award Identification Number (FAIN) (3) Assistance Listing number (4) Indirect Cost Rate. Lastly, one subaward did not include the following information: (a) Period of Performance of subaward (b) Amount of federal funds obligated and awarded (c) General terms and conditions of subaward (d) Federal award project description (e) Name of Federal awarding agency. Corrective Action Plan: EA recognizes that this required information must be provided to subrecipients. To prevent this error in the future, EA will design a cover page template including all required information. EA will confirm with Sikich that the form covers all requirements. EA will use this template for all subawards related to our grants. Responsible Person for Corrective Action Plan: Betsy Spore, Director of Finance and Accounting Implementation Date for Corrective Action Plan: 09/01/2023

Assistance Listings number and name 84.425F COVID-19 Education Stabilization Fund?Higher Education Emergency Relief Fund (HEERF) Institutional Portion Award number and years P425F201546-20B, May 6, 2020 through June 30, 2023 Federal agency U.S. Department of Education Compliance requirement(s) Allowable costs/cost principles Questioned costs $4,249,864 Name(s) of contact person: Ross Poppenberger Anticipated completion date: Q1 (January - March) 2023 The District misinterpreted its Federal Indirect Cost Rate (IDC) as it applies to HEERF funding. Although the District applied their prenegotiated IDC rate to the HEERF Grant, the District did not apply the rate to the correct program expenditures when calculating the IDC. The District updated its internal grants IDC calculation policies and procedures to ensure that indirect costs are properly calculated and reviewed for accuracy and written confirmation is obtained from the grantor for a new grant?s IDC calculation. Further, the District is working with the U.S. Department of Education to reappropriate the unallowable funds to allowable direct costs.

FINDING 2022-003 (Auditor Assigned Reference Number) Contact Person Responsible for Corrective Action: Jamie Arce, Controller Contact Phone Number: 574-322-4863 Views of Responsible Official: Management agrees with the finding. Description of Corrective Action Plan: The City will review its existing policies and procedures surrounding adequate supporting documentation and will update policy as required. Training on this requirement will be provided to all City Staff involved in procurement. Anticipated Completion Date: October 31, 2023

Finding # 2022-007 Title of Finding Subrecipient Monitoring Contact Person Brook Hinzman Anticipated Completion Date June 2023 Corrective Action planned to be taken: Will comply and monitor subrecipient spending going forward.

Federal Schedule Audit Comment: County Response Emergency Rental Assistance Program Timely Reporting: The County made every attempt through communications with the Treasury to upload annual reports for ERA 1, without being able to do so by the due date. The County did submit the documents manually by e-mail through dumps of the system. County staff worked with the US Treasury to address these issues. A resolution to the problem did not occur until second quarter of 2023. The Final report for ERA 1 has been submitted through the portal. Cumulative Expenditure/ Obligation Amounts: There was some misinterpretation on the part of County staff on whether the cumulative amounts to be reported was for the quarter or cumulatively for the grant program. It is to be noted that amounts in the County system were properly recorded and no exceptions were noted in the actual expenses/ obligations being for a valid grant purposes. Corrected on Final Report for ERA 1. State/ Local Federal Relief Funds Program Cumulative Expenditures/ Obligations Incorrectly Reported: There was some misinterpretation on the part of County staff on reporting the election of the $10,000,000.00 Revenue Replacement Funds for the SLFRF. It was thought that you could only show the $10,000,000.00 as obligated and expended once the election was made. This resulted in a net overstatement of obligations for any revenue replacements funds that were not yet obligated by resolution by the Board of Mahoning County Commissioners. The County tracked the individual projects by notes in the Treasury system to note the actual obligations. The County?s financial system tracks grants by fund, department and project codes. The funds in the County?s financial system were and are correctly obligated and tracked. The County will make the necessary corrections to the 2023 second quarter report to make sure the report agrees with the County?s financial system. It is to be noted that no exceptions were noted in funds being used for the stated purposes of the grant. Senior management will provide additional oversight to the reports prior to submitting to the US Treasury.

2022-004 ? Allowable Costs/Activities Allowed or Unallowed: Indirect Cost Name of Responsible Individual(s): Pamela Aguilera, Chief Financial Officer. Corrective Action: Safe & Sound?s Finance team implemented policies and procedures to ensure the indirect cost rate is calculated based on modified total direct costs, which excludes amounts over $25,000 for subawards. We updated our formulas to ensure that we properly calculated indirect costs on a monthly basis, ensuring the exclusion of subawards over $25,000. Date Completed: 7/31/2023

DPH agrees with the finding and recommendations. DPH will notify its subrecipients about their subawards and include any changes in subsequent subaward modifications. DHSP will strengthen its review processes to complete and include the Notice of Federal Subaward Information form as part of the contract copy at the time of the contract execution.

Individuals Responsible for Corrective Action Plan: Jason Penegar, BGCA Vice President ? Controller Shelby Mahoney, Accounting Manager - State Alliances Corrective Action: Management will review grant agreements to confirm whether expenditures from pass-through entities are related to federal or state grants, and appropriately include applicable federal grants in the SEFA. Anticipated Completion Date: December 31, 2023

The City of Boston?s Age Strong Commission has revised the addendum that is attached to their award letters to include whether or not the award is R&D and a section on indirect cost rate. Anticipated Completion Date: June 30, 2022 Responsible Contact Person: Scott Finn, Assistant City Auditor, Grants Monitoring Unit scott.finn@boston.gov

Department of Health and Human Services 2022-002 Immunization Research, Demonstration, Public Information and Education, Training and Clinical Skills Improvement Projects - Assistance Listing No. 93.185 Recommendation: We recommend the Foundation attend training, review federal requirements, and fully understand the requirements over indirect costs Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action planned/taken in response to finding: CFGF will engage with external firm to assist with fully understanding requirements related to indirect costs and federal requirements. CFGF will also work with external firm to assist in the identification and selection of additional training opportunities for staff who work on federal programs. Name(s) of the contact person(s) responsible for corrective action: Brett Hunkins Planned completion date for corrective action plan: December 31, 2023

The County agrees with the finding and recommendation. On September 12, 2022, the County issued the ?Notice of Federal Subaward Information Template and Subrecipient Monitoring? memo, which provided departments with a template to communicate the 14 subrecipient reporting requirements from 2 CFR ?200.332(a) to their subrecipients at the time of the subaward. The memo also reminded departments to provide all the required elements from 2 CFR ?200.332(a) to existing CRF subrecipients that were not initially provided all the requirements. In addition, the memo reminded departments that subrecipient agreements must include detailed expectations for periodic reporting and timing of reporting submission. On January 12, 2023, the County issued the ?CARES and ARP Act Funds Subrecipient Monitoring? memo, which reminded departments that subrecipient agreements must include data encryption requirements. The memo also reminded departments that existing subrecipient agreements without data encryption requirements will need to be amended by departments. In May 2023, during the Single Audit Kick-off annual meeting, the County will include the issued ?Notice of Federal Subaward Information Template? on the presentation slides and remind departments that the template should be used to communicate the 14 subrecipient reporting requirements. The County will also reiterate that departments need to maintain documentation that the template was provided to subrecipients at the time of the subaward and existing subrecipients that were not initially provided all the subaward requirements.

Management?s Response: Effective fiscal year 2022-23, the Association will follow section 2 of the CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. The costs, for which the benefit can be directly identified, will be charged to the benefiting grant and category. Shared/Joint costs will be charged based on employees? time reported (timesheet and labor distribution), units of services (meals, care management units, number of-participants, hours of service, etc.), square footage, or other method that will result in an equitable allocation of costs. Currently, direct-shared costs for the Child Care and the Senior Services Programs are pooled by program area. The direct-shared cost pool and pooled facilities costs are then allocated to each funder within the respective program. We have immediately implemented a change in procedures to recalculate our Cost Allocation Plan on a quarterly basis, based on using the previous quarter's payroll labor distribution report by program to calculate the FTE for the upcoming quarter cost allocation. However, if a funder disallows a particular expense item, after the determination of their portion, it is applied to Unallowable and paid with unrestricted funds of program or agency.

1. Excess indirect cost billing Three contracts identified with excess indirect cost billing will be corrected on the next invoice and prior to contract ending date. Assistance Listing (AL) No. 93.268 or 2103 CBO Contract and No. 93.391 or 2103 Health Equity Contract are ending by November 2023 and May 2024 respectively. Hawaii Public Health Institute (HIPHI) will submit up to date billing with corrections. As recommended by the auditors, the HIPHI team will 1) create a written procedure that describes in detail the process to prepare and review program billings, and 2) implement guidelines on how to record indirect costs. For all federally awarded programs, the Director of Finance and Operations and the program's lead manager, with direct knowledge of the requirements for the grants, will review the billing prior to submission to the funder. The Finance and Accounting Manager and/or other trained Finance and Operations staff will prepare the billings, provide financial reports as requested, and include any supporting documentation used, for the reviewers.

Name of Responsible Individual(s): Jason Penegar, BGCA Vice President ? Controller Shelby Mahoney, Accounting Manager - State Alliances Corrective Action: Management will review grant agreements to confirm whether funding received from private entities are federal funds that should be reported on the SEFA. Anticipated Completion Date: December 31, 2023

Individuals Responsible for Corrective Action Plan Jeff Scaccia, CPA (Vice President for Finance and Administration) Libby Shull, CPA (Controller) April Baur, (Director of Student Financial Aid) The SEFA as prepared by management did not originally include one federal grant with federal expenditures to be reported with the 2022 SEFA. Corrective Action Plan: The grant included in the finding was received from a local government entity which did not communicate any reporting requirements associated with the grant. The College will be more vigilant in future years in assessing any grants received for inclusion on the SEFA. Anticipated Completion Date: March 1, 2023.

DEPARTMENT OF ELEMENTARY AND SECONDARY EDUCATION 2022-004 Child and Adult Care Food Program ? Assistance Listing No. 10.558 Action taken in response to the finding: The Office for Food and Nutrition Programs (FNP) has moved from a paper based permanent agreement to a web form that exists on the DESE Security Portal. All existing and new Child Nutrition Sponsors will continue to sign off on the document via the web-based portal allowing for a more efficient collection and document retention process. The identified sponsors with missing permanent agreements for the time period selected now have signed permanent agreements via the web-based form. FNP will add the applicable FAIN numbers to the Financial Management portion of FNP?s public website. FNP will review and update these numbers annually as applicable. FNP, in conjunction with DESE?s Federal Accounting Unit, have embarked on a process to provide all Child Nutrition sponsors instructions and collect information related to UEIs. FNP will continue the process and outreach until all UEIs have been collected. Name of the contact person responsible for corrective action: Robert Leshin, Director of Nutrition, Jeffrey Benbenek, Director of Audit & Compliance Planned completion date for corrective action plan: July 1, 2023

2022-002 ? CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS ? NONCOMPLIANCE WITH SUBRECIPIENT GRANT AGREEMENT REQUIREMENTS ? ALN 21.027 ? OTHER NONCOMPLIANCE Condition: Burleigh County did not communicate and document all of the elements as outlined in 2 CFR 200.332(a) for the subrecipients of the Coronavirus State and Local Fiscal Recovery Funds program. During testing, we noted the following elements were not included: ? subrecipient's unique entity identifier ? federal award identification number ? federal award date (see definition of Federal award date ? 200.1) of award to the recipient by the Federal agency ? subaward period of performance start and end date ? name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity ? Assistance Listings number and Title ? identification of whether the award is Research and Development ? indirect cost rate for the Federal award (including if the de minimis rate is charged) per ?200.414 ? a requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient's records and financial statements as necessary for the pass-through entity to meet the requirements of this part, and appropriate terms and conditions concerning closeout of the subaward Corrective Action Plan: We agree with the recommendation. Burleigh County has implemented new policies and procedures in 2023 regarding subrecipient monitoring. Anticipated Completion Date: FY 2023

Finding 2022-005 Contact Person Responsible for Corrective Action: Debbie Morton-Crum, County Auditor Contact Phone Number: 765-482-2940 View of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The County Commissioners are responsible for the American Rescue Plan project list along with that responsibility is to have a sub-recipient agreement in place with those outside entities that received American Rescue Plan grant monies from the County. An Internal Control is now in place that requires a sub-recipient agreement in place before a warrant can be paid to those outside entities. We will put procedures in place to ensure that money disbursed to sub-recipient is monitored. Anticipated Completion Date: October 1, 2023

Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Auditee?s Corrective Action Plan: The City has purchased Workday, an Enterprise Resource Planning (ERP) system, and implemented the software with the assistance of Accenture consultants. Although Workday is ?live? as of August 2022, the City is currently working to refine the software and fully utilize functionality. The Workday grants modules requires the grant funding source be defined prior to grant approval and fields are available for the AL titles and numbers and sub-recipients? information. The implementation of the Workday grants modules centralizes much of the grant management function by requiring the agencies to upload the grant documents into Workday. The City has: ? Held weekly meetings for two years with agency grant representatives to design and configure the Workday grant module. ? Uploaded the grant award, sponsor information and grant budget data into a Workday. ? Implemented a ?new grant? request which uses a Workday business process. ? In the process of reviewing and correcting recoverable costs per grant award so it is properly reported. Contact Person: Michael Moiseyev, Chief Financial Officer, Baltimore City. Completion Date: June 2024

Name of Responsible Individual(s): Jason Penegar, BGCA Vice President ? Controller Shelby Mahoney, Accounting Manager - State Alliances Corrective Action: The fiscal team will enhance its procedures and internal controls with respect to preparation and review of the SEFA. Grant agreements will be reviewed to confirm if expenditures from pass-through entities are related to federal or state grants, and appropriately include applicable federal grants and pass-through funds in the SEFA. Anticipated Completion Date: December 31, 2023

During 2023, the newly elected County Auditor took on an active role in tracking the Coronavirus State and Local Fiscal Recovery Funds by preparing and maintaining spreadsheets so that the Commissioners have the most current information for making decisions. The County Auditor attends or watches/listens to the Commissioners’ meetings to make sure that she is updating the spreadsheets with all action taken by the Commissioners. Before submitting the Schedule of Expenditures of Federal Awards for the 2023 audit, we will consult with the Commissioners’ Office and the County Auditor to make sure that we are reporting the transactions correctly based on the spreadsheets prepared and maintained for such purposes.

Views of Responsible Officials: Mary's Center now has a robust process where the agreed upon provisional indirect rate or (if applicable) the specific rate included in the final Grant agreement is the governing default rate used for each Grant. In any scenarios where a change in rate is being requested, the Program Manager alerts the Senior Grant Accountant assigned to the grant and provides supporting documentation from the Grant funder of an addendum to the existing Grant agreement. If for any reason the Finance team is using an upward or downward adjustment to the provisional indirect rate or what was agreed upon in the Grant agreement the EVP Finance and Director of Grants must approve this change and notify the EVPs of Health and Programs and Development prior to implementing this change. All changes are documented. In addition, to ensure the rate in the agreement is the same rate being used when invoicing Grant funders, the Finance team conducts a thorough reconciliation process during the year.

Individuals Responsible for Corrective Action Plan: Jason Penegar, BGCA Vice President – Controller Shelby Mahoney, Accounting Manager - State Alliances Corrective Action: The fiscal team will enhance its procedures and internal controls with respect to preparation and review of the SEFA. Grant agreements will be reviewed to confirm if expenditures from pass-through entities are related to federal or state grants, and appropriately include applicable federal grants and pass-through funds in the SEFA. Anticipated Completion Date: December 31, 2023

Agency: National Center for the Advancement of STEM Education, Inc. (nCASE) Person Responsible for Corrective Action: Name: Nancy Priselac Title: Executive Director Anticipated Completion Date: December 8, 2023 Response to Finding: Management concurs with audit recommendation. Correction Action to be Taken: nCASE has written policies and procedures that detail how management is to review and approve documentation relating to payroll and how reports are created that confirm charges are accurate, allowable, and properly allocated as well as allow for clear comparisons to estimates. Management created timekeeping documents to track employee labor, time and effort. nCASE’s accounting system matches charges listed to documentation used to collect and record time and effort by employees and apply designations to its respective project/label. The system can track direct, indirect, and fringe benefit designations. Accounting data now allows management to create clear reports on payroll. nCASE has implemented documentation that allows employees to track time and labor in detail of project. Management has written policies and procedures that direct employees on how to record time and labor. DoD has reviewed the matters covered in the audit report thoroughly, and the grant was closed out without any repayment of funds to DoD. Upon subsequent review and reconciliation, amounts were not overcharged.