Corrective Action Plans

Condition: The College did not have a control system in place to monitor performance measures as outlined in the subrecipient and grant agreements. The College was also not completing any site visits of the subrecipients or requiring annual financial reporting be submitted. Planned Corrective Action: Below are three items implemented to address the subrecipient monitoring requirement: 1. To address the finding of noncompliant subrecipient agreements, Grand Rapids Community College has implemented a new Grants Administration Guide. This guide can be found on the Grand Rapids Community College website. 2. To address the finding of lack of progress monitoring, subrecipient partners have been given monthly metric reports which include planned vs actual outcomes as a means of outlining their progress. The reports also include historical data for each category. This information is broken down by month and to be reviewed with subrecipients on a bi-weekly basis. This bi-weekly monitoring will provide oversight and help manage performance. Each grant partner will submit quarterly outreach plans that will be balanced against planned vs actual outcomes. These outreach plans will consist of detailed information highlighting the purpose of the event, target audiences, and updates from previous events. 3. To address the finding of lack of subrecipient monitoring, Grand Rapids Community College has scheduled formal site visits with subrecipients. Within the meetings they will discuss the following topics: Narrative Visit Overview, Financial Status Discussions, Metrics Verification, Narrative Overview, Participant Records and Revenue and Evaluation. Contact person responsible for corrective action: C. Dennis Triggs II- Program. Manager – One Workforce Grant. Anticipated Completion Date: 7/31/2023

2023-002 Coronavirus State and Local Fiscal Recovery Funds – Assistance Listing No. 21.027 Recommendation: We recommend that the Organization review and follow the indirect cost rate guidance set out at 2 CFR section 200.414 within Uniform Guidance. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Management is in the process of updating it’s calculation of indirect costs to be in compliance with the indirect cost rate guidance set out at 2 CFR section 200.414 within Uniform Guidance. Name of the contact person responsible for corrective action: Shannon Marimón Planned completion date for corrective action plan: February 29, 2024

2023-002 - Noncompliance and Significant Deficiency in Internal Controls over Compliance for Subrecipient Monitoring Corrective Action Plan: Wellbeing Initiative has reviewed subrecipient monitoring criteria and updated the Internal Controls Policy and Procedure Manual to include the following policy. The appropriate measures have been taken to ensure these requirements are met in the coming years. Item 10.8.b.i-xv. Subrecipient monitoring requirements for pass-through entities, include the requirement that pass-through entities ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes but is not limited to: i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient's unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Subaward Period of Performance Start and End Date; v. Subaward Budget Period Start and End Date; vi. Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; vii. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; viii. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); ix. Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; x. Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; xi. Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. xii. All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; xiii. Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports; xiv. 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 xv. Appropriate terms and conditions concerning closeout of the subaward Anticipated Completion Date: Completed 11/16/2023 Responsible: Chief Executive Team: Danielle Smith and Sadie Thompson

The City will review the process for identifying federal awards to minimize the likelihood of errors in preparing the schedule of expenditures of federal awards to minimize the likelihood of errors in preparing the schedule of expenditures of federal awards. This will include inquiries of the Engineer’s Office.

Upon conducting the FY21 audit, TAS’ Director of Finance was informed that the inclusion of the Biological Expertise line item on federal budgets (approx. 7.5% additional uplift) was not allowable as it was currently being calculated. TAS is allowed a 10% de minimus rate on noted FY22 Federal awards some of which also included a Biological Expertise line item that is budgeted as an hourly rate. TAS had been calculating uplift amounts owed by simply adding the Biological Expertise (7.5%) to the de minimus rate (10%) for a total uplift of 17.5%. This was done at the direction and approval of our federal partners. However, due to Biological Expertise being entered in the federal and approved budgets as an hourly line item and not a percentage TAS was considered out of compliance by using this method of calculation. Moving forward TAS will be billing the de minimus rate (10%) as a percentage, unless otherwise noted in the agreement.

Finding 2022-005 – Indirect Cost Allocations In response to the finding, GEM will improve program costs allocation documentation by instituting the following controls and procedures. GEM will allocate indirect costs and charges to the NSF program based on incurred costs and monthly allocations approved by the program administrator. These indirect costs will be separately reported in the accounting records. Anticipated date of completion: Monthly journal entry is set up with calculations for determining the dollar amount. The date of completion was October 2022 and have been updated since then. Responsible party: Jamie D. Hicks, Senior Accounting Manager

Management agrees with the finding and is implementing the accompanying corrective action plan. Views of Responsible Officials: Jacy Hyde, Executive Director Joel Rusco, Chief Financial and Administrative Officer Jessica Martinez, Deputy Director Contact Person: Jessica Martinez, Deputy Director Joel Rusco, Chief Financial and Administrative Officer Corrective Action Plan: In response to FY21 Corrective Action Plan, CFSC implemented an updated Reporting Policy in June 2024 to strengthen internal controls prior to review and submission of invoices and drawdown/payment requests to funders. To ensure further compliance with 2 CFR 200.414(c), 2 CFR 200.403(d), and 2 CFR 200.302(b)(3), CFSC will implement the following corrective actions: 1.Verification of Indirect Cost Rate Before Submission: a.CFSC will require that all invoices, including indirect costs, be reviewed by the CFAO to confirm that the rate used is in accordance with an approved provisional or final NICRA agreement. b.Any invoice for federal funding lacking an approved indirect cost rate will be flagged and returned for correction before submission. 2.Pre-Submission Approval Process for Invoicing Indirect Costs: a.All invoice requests containing indirect costs must be reviewed and approved by the CFAO prior to submission. b.The Finance Department will verify and document that the rate applied is consistent across all federal awards and matches the NICRA. 3.Indirect Cost Rate Agreement Tracking & Documentation: a.CFSC Finance will establish an Indirect Cost Rate Agreement tracker to ensure that: i.All provisional and final indirect cost rate agreements are maintained on file. ii.Indirect cost rates used on invoices are consistently aligned with approved agreements. 4.Quarterly Internal Audits of Indirect Cost Rate Compliance: CFSC Finance Department will conduct quarterly reviews of a sample of drawdown/payment request invoices to confirm: a.The correct indirect cost rate was applied b.The rate was consistently applied across all federal awards Anticipated Completion Date: These corrective actions will be fully implemented by the end of Quarter 2 of FY25

Consortium’s Fiscal Agent will ensure that supporting documentation will be maintained for all expenditures to ensure that each expenditure charged to the program is for an allowable activity/cost. In addition, Fiscal Agent will complete corrective action for 2022-005 & 2022-006

The Township Fiscal Officer will prepare the SEFA or contract with a CPA firm to have the SEFA prepared going forward.

Finding 2022-005 – Indirect Cost Allocations In response to the finding, GEM will improve program costs allocation documentation by instituting the following controls and procedures. GEM will allocate indirect costs and charges to the NSF program based on incurred costs and monthly allocations approved by the program administrator. These indirect costs will be separately reported in the accounting records. Anticipated date of completion: Monthly journal entry is set up with calculations for determining the dollar amount. The date of completion was October 2022 and have been updated since then. Responsible party: Jamie D. Hicks, Senior Accounting Manager

Internal communication processes for direct pay projects were used in conjunction with ODOT reports to capture these offsetting revenues and expenditures as well as the additions to capital assets in 2023.

The School District will review the Uniform Guidance requirements and ensure all expenditures are accurately reported on the School District’s federal schedule.

Finding 2022-010 U.S Department of Agriculture Special Supplemental Nutrition Program for Women, Infants, and Childre – 10.557 Award number 202222W100643 Management’s Response: Management agrees it is imperative to foster collaboration for successful award management. Finance leads the annual effort working with an outside consultant to calculate the indirect rate using information supplied by Unified Government of Wyandotte County & Kansas City KS. The annual indirect rate will be calculated annually for use by all departments in the spring and available by July 1 each fiscal year. This will be used consistently across all departments unless the State of Kansas rate is permitted by the grant. Finance will work to find the best way to make the information easily accessible to grant program managers embedded in departments. After the audit, management received an authorization letter from the Kansas Department of Health and Environment (KDHE) that supported the indirect rate we used for Jul2022-Dec2022, however because the letter was dated in 2024, we are still subject to this finding. Views of Responsible Officials and Corrective Action: Management will work internally to complete the annual calculation of the indirect rate and develop a solution, a shared document solution to provide indirect rate information to departments in a consistent and timely manner. Management will ensure this is addressed by December 31, 2024. Responsible Official: Dr. Shelley Kneuvean Chief Financial Officer Unified Government of Wyandotte County & Kansas City KS

2022-006 Program: WIOA Cluster Federal Financial Assistance Listing Number: 17.258, 17.259, 17.277, 17.278 Federal Grantor: U.S. Department of Labor Pass-Through: California Department of Employment Development Award No. and Year: AA011008 and 2019 Compliance Requirements: Subrecipient Monitoring Type of Finding: Material Weakness Management’s or Department’s Response: Imperial County Workforce Development Office (ICWDO) agrees with the finding. Views of Responsible Officials and Corrective Action Plan: The questions from finding 2021-008 relate to a formalization of the fiscal processes and protocols. ICWDO operates under WIOA guidelines and follows Imperial County’s fiscal policies. Internal policy will be formally updated to reflect compliance with WIOA regulations, as well as Imperial County policies. These policies will include formal controls and procedures to evaluate each subrecipient’s risk of noncompliance. Once the formal procedure is drafted, it will go through the ICWDO Policy Committee for comment and direction, and then finally reviewed and approved for implementation by the full Workforce Development Board. Additionally, for any future Memorandums of Understanding (MOUs) between this Imperial County department and any outside agency, there will be an additional step to include review by Imperial County Counsel to reflect that recital around the funding source will specify the following required information: • Federal Award Identification Number • Federal award date of award to recipient by the Federal agency • Name of Federal awarding agency • CFDA Number • Specific identification of whether the award is research and development ICWDO will develop internal policies for formalizing all subrecipient monitoring process. ICWDO operates under WIOA guidelines for monitoring; therefore a formal internal policy for future contracts will be developed and implemented using the usual review and approval procedures followed by the department. ICWDO will develop a formal internal documentation system, with appropriate checks and signatures, for the evaluation and assessment of each subrecipient’s risk of noncompliance. ICWDO will utilize this formal process to properly document the risk assessment of all subrecipients. ICWDO anticipates to implement the corrective action by December 31, 2023. Name of Responsible Person: Priscilla A Lopez, ICWDB Director Implementation Date: December 31, 2023

Responsible: Denice Hairston, Chief Quality, Compliance and Accountability Officer Corrective Actions: Update subrecipient award agreements to ensure the final approved scope of work or project description is specified. Completion Date: March 29, 2023 Explanation: Policies and procedures were updated in 2023 in response to an OJJDP/OCFO recommendation to ensure subaward files contain the requisite components for the award agreement. In addition to these updates, which include a master file checklist, National CASA/GAL has updated the subrecipient Terms & Conditions agreement to include CFR requirements as recommended.

All future federal expenditures will be reconciled to the disbursement ledger.

The Organization has taken steps to ensure that the calculation of indirect costs is executed properly and reviewed for compliance in accordance with the contract agreement. Management brought the error in the contracted indirect rate to the funders attention initially, but unfortunately a misstep back to the original contract terms was made before close-out. The development and application of indirect rates will be conducted by the Sr. Director of Finance with oversight by the Chief Financial & Operating Officer and is in place as of the date of this corrective action plan.

FINDING # 2022-010No finding in prior yearAs recommended, the DCA will review current procedures to ensure that all subaward information required by the federal Uniform Guidance is included in all subaward contracts and grant agreements. The DCA has also reviewed its current subrecipient monitoring procedures for standard subawards made by the agency and has determined that no internal control enhancements are required. The HAF award was a unique grant relationship for DCA in that the entire award was passed through to another New Jersey State government agency that is a direct affiliate of the Department. Monitoring procedures were determined based on the close working relationship with our affiliate organization and the fact that less than 1 percent of the grant award was expended through June 30, 2022. Current procedures included a risk assessment of the subrecipient and performance of the single audit desk review of the independent audit report. In addition, the Director of Audit, and the Executive Director of the subgrantee affiliate participate in weekly meetings where updates on the program status can be determined. DCA?s subrecipient monitoring plan also includes the hiring of an Integrity Monitor to oversee and monitor the use of the HAF funds as well as compliance with all HAF program reporting requirements. As program disbursement activity is continuing to increase with the HAF program(s) created more fully up and running, DCA is currently targeting the Integrity Monitor hire to take place sometime within the next three to six months.COMPLETION DATE/CONTACT PERSON Fiscal Years 2023 and 2024John Alexy(609) 913.4385John.Alexy@dca.nj.gov

The District will review the Uniform Guidance requirements and ensure all expenditures are accurately reported on the Districts federal schedule.

Action taken in response to finding: Management has refined our processes and controls over indirect costs to more closely monitor whether indirect costs being allocated to a grant are based on its current federally negotiated indirect cost rate. We have identified the expiration date of the current indirect cost rate during the grant budget preparation process and have submitted a new indirect cost rate proposal. Name(s) of the contact person(s) responsible for corrective action: Karen Wesley, Director of Internal Control and Fiscal Management. Planned completion date for corrective action plan: Completed.

View of Responsible Officials The Department of Energy recognizes the need to include all required information to be communicated to sub-recipients, and that all sub-recipients? risk assessments are thoroughly completed. In addition, uniform guidance reports need to be collected and reviewed to ensure that management letters be issued within the required timeframe. Anticipated Completion Date: Ongoing Contact Person Eileen Smiglowski, NH LIHEAP Administrator

agreement. View of Responsible Officials A. We concur with this finding. The Department utilized an internally available copy of the Management Log, which lists vendor?s determinations. This is a copy of the log, not the original, official copy. There is a delay in updating this copy from the original, and incorrect information had been initially entered. The Department is moving this log to software which allows all Department employees to view the same log, while limiting the number of individuals who have access to make changes. Implementation has been completed as of March 2023. B. We concur with this finding. However, we believe this was an isolated incident as the TANF CFDA number (93.558) used was very similar to correct CFDA number (93.778) that should have been documented. C. 200.332 requirements a. We do not concur with this finding. The contract for Mt Prospect became effective 8/4/21, prior to the 4/22 inception of the UEI. The DUNS number, as in effect at that time, is noticed in Exhibit J of the contract. b. We concur with three of the four findings. Two of the four contracts pre-date the template update requiring the notice an indirect cost rate. Indirect cost rate for federal awards (including if the de minimis rate is charged per 2 CFR section 200.414) were added to Exhibit C of the Department?s contracts in April 2020. One of the contracts did not indicate an indirect cost rate as required. One of the contracts notes the indirect cost rate in the Notes of their financial details. c. One of the two contracts pre-dates the template update requiring the notice the identification of R&D. R&D identifications for federal awards were added to Exhibit C of the Department?s contracts in April 2020 One of the two contracts did not identify whether the contract was R&D as required. D. Subrecipient Risk Assessment ? We concur with the finding. We consider the finding to be fully resolved through Department policy Department policy and Department wide implementation. However, it should be noted full compliance will not be achieved for one to two contact cycles due to timing. The Department began addressing the issue of Subrecipient Monitoring issue in June 2017 when the first Grants Administrator was hired. The Department finalized the Subrecipient Monitoring Policy, which encompasses the financial and programmatic risk assessments as well as the subrecipient monitoring, on June 1, 2018. The Department provided user training on the subject in February and September 2018, training over one hundred forty-six staff. However, only brand new procurements utilized this policy during the initial roll out of this policy. The Department hired a new Grants Administrator in May 2019. The full Subrecipient Monitoring policy rolled out to all procurements, including sole source, amendments, and renewals, effective August 1, 2020. The Contracts Unit received specialized subrecipient monitoring training on May 13 and October 28, 2020. Department wide training to all staff occurred weekly between September 8 and November 3, 2020. The Grants Office provided additional targeted training to Program staff through team meetings. Over one hundred fifty Program and Finance staff received training. Annual training will be held in September each year. Refresher training or training for new staff is available upon request from the Grants Office. The Grants Office website offers Program, Finance, and Contracts Bureau staff access to the subrecipient monitoring policy, as well as training modules, slides, and tools. The training has also been recorded and is available on this site. The Subrecipient Monitoring Policy requires Program to determine whether any vendor which receives funds in exchange for goods or services is a Contractor or Subrecipient. Determined subrecipients receive a Management Questionnaire, which includes a ten question questionnaire and requirements for submitting financial data. This information is used to populate the Risk Assessment Tool, which shows any risks pertinent to a subrecipient and the subaward. Based on the risks shown, Program chooses monitoring activities to mitigate the risks and the Contracts Bureau memorializes these choices in the contract. The Grants Office continues to work closely with the Contracts Bureau to ensure compliance with the Subrecipient Monitoring policy. C. and D. It is also important to note that between April 2020 and June 2022 the Department was involved in the State?s strategic response to the COVID-19 pandemic. During this time, New Hampshire was under a state of emergency (Executive Order 2020-04), processes were rapidly converted to fully digital overnight, the State?s standard approval processes were suspended and non-standard templates, which did not include the required notifications under 200.332, were utilized to respond to the COVID-19 pandemic. The Department worked with other State Departments and the National Guard to create a record number of amendments, contracts, and other agreements (approximately 200% more than standard). The Department is in the process of instituting a new contract life cycle management solution that will utilize conditional logic to include the required notifications for agreements involving federal funds in order to ensure compliance. Implementation is anticipated to be complete in July 2023. As the COVID-19 pandemic strategic response has wound down, the Department has not suspended its regular standard approval or subrecipient risk assessment and monitoring processes and has not used non-standard templates to award federal funding. E. We concur there was no formal documentation of any monitoring activity. Due to staff turnover a new administrator has been hired and unable to furnish the monitoring that took place during FY22. However, a program site review during FY23 was performed and financial monitoring of invoices has also taken place. Anticipated Completion Date: July, 2023 Contact Person: Melissa Kelleher, Administrator Rejoinder As documented above in Bullet B of the condition found, the Department did not properly communicate all required award information to the subrecipient. Once aware of the noncompliance, the Department should have timely communicated this information to its subrecipients.

Finding Number: 2022-012 Federal Program, Assistance Listing Number and Name: ALN 21.027, Department of Treasury, COVID-19 Coronavirus State and Local Fiscal Recovery Fund (CSLFRF) Condition: Original Finding Description: The CSLFRF subrecipient agreements did not include the CSLFRF assistance Listing Number (ALN) as required per 2 CFR 200.332 (a)(1)(xii). Contact Person Responsible for Corrective Action: Sandra Yu Stahl and Terri Daniels Anticipated completion date: July 2023 Planned Corrective Action: The City has implemented a process to ensure that all subrecipient agreements contain the Federal ALN as required by 2 CFR 200.332. All subrecipient agreements will include a new exhibit as an attachment in the agreement that will include the ALN and any other required grant elements.

Program: AL 21.026 ? COVID-19 Homeowner Assistance Fund ? Subrecipient Monitoring Corrective Action Plan: N/A Contact: Major General Daryl Bohac Anticipated Completion Date: N/A

View of Responsible Officials The Department acknowledges the misinterpretation of the agreement as a subaward has led to a failure to comply with 2 CFR section 200.332(a). Underlying this misinterpretation was the Department?s failure to differentiate between entering into agreements with other state agencies and entities recognized as component units of state government such as the NH Business Finance Authority; noting agreements between state agencies would not require such compliance. Accordingly, the Department will review existing policies and procedures related to subawarding and subrecipient monitoring to ensure agreements with component units of state government are properly considered. Additionally, the Department will amend the existing agreement to ensure required award information is communicated and ensure all other subrecipient monitoring protocols are applied to the subaward. Anticipated Completion Date: June 30, 2023 Contact Person: Taylor Caswell