Corrective Action Plans

Finding 2023-003 – Indirect Cost Allocations In response to the finding, GEM will improve program costs allocation documentation by instituting the following controls and procedures: GEM allocated indirect costs to the NSF program based on actual expenses incurred and monthly allocations approved by the program administrator. These indirect costs are recorded separately in the accounting system. Formal written procedures are now in place, and we will maintain active oversight to ensure full adherence to all established policies. 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

Finding Number 2023-006 Subject Heading (Financial) or AL no. and program name (Federal) 93.658 – Foster Care Planned Corrective Action The risk assessment cannot be completed until we have actual data and performance needed to make that assessment. Subrecipient risk assessments are completed at the beginning of the fiscal year based on prior year data and performance. The changes to all of the subrecipient agreements identified have been in process and were completed during State fiscal years 2024 and 2025. Additional findings are expected for the 2024 audit since the audit timing is currently almost two years in arrears. Anticipated Completion Date February 2025 Responsible Contact Person Kevin Haddock

Finding Number 2023-096 Subject Heading (Financial) or AL no. and program name (Federal) ALN: 21.019 Federal Program name: Coronavirus Relief Fund (CRF) Planned Corrective Action The State agrees with this finding. Within OMES, oversight and management of Federal grants has been transferred to the OMES Grant Management Office (OMES-GMO) which is staffed with individuals with several years of grant experience. OMES-GMO has a multi-level system of internal controls for grant management and oversight that includes routine monitoring, desk review, and site visits for all projects and associated project/administrative expenditures to ensure allowability, accuracy, and assist in the detection of fraud. Finally, OMES Finance has developed processes which provide for a more thorough coding of expenditures and proper review of expenditures when reporting on their GAAP Z. The State disagrees with the finding. The State had two Grant Award Notifications in place with the Boys and Girls Club which reflects the monies awarded to be used on the capital improvements and Club on the Go Mobile Clubhouses. This indicates the funds were obligated during the covered period. Per the email from the Keri for Jill Geiger Consulting, no signatures on the GANs were required and the Uniform Guidance does not require the GAN to be signed. Anticipated Completion Date September 2022 Responsible Contact Person Brandy Manek

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.

The School District will review the Uniform Guidance requirements and ensure all expenditures are accurately reported on the School District’s Schedule of Expenditures of Federal Awards.

VIEWS OF RESPONSIBLE OFFICIALS ADSEF will provide training to personnel on the requirements and regulations related to subrecipient monitoring. Recommendation to management will be implemented, internal controls and compliance measures that allow for the identification, reporting, and monitoring of subrecipient activities Prevention Activities/TANF. IMPLEMENTATION DATE During Fiscal Year 2025-2026. RESPONSIBLE PERSON Administration for Socioeconomic Development of the Family (ADSEF, by its Spanish Acronym)

2023-006 Management Response: Management respectfully disagrees with this Finding. • Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). • Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. • Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. • Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. • Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. • Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.

Plan: BCPN confirms that indirect costs are calculated in accordance with government guidelines outlined in 2 CFR Part 200. Anticipated Date of Completion: 4/26/2025 Name of Contact Persons: Ieesha Jones Management Response: Due to adopting to use a calendar year instead of a fiscal year, BCPN's indirect costs for FY24 will be reflected in the financial statements for the period ending June 30, 2024, rather than December 31, 2023. We confirm that the indirect costs are being billed and spent in compliance with the guidelines outlined in the government contract and there is no need for funds to be returned.

Public Health agrees with the recommendation. Public Health will develop a process for conducting risk assessments of subrecipient funding, develop and implement procedures for obtaining single audit reports from subrecipients, as well as a system to monitor and track compliance with the single audit mandate among subrecipients. Public Health will ensure each subaward includes all requirements imposed on the subrecipient so that the federal award is used in accordance with Federal Statutes, regulations, and terms of conditions of the federal award. Estimated Implementation Date: May 2025 Contact: Melissa Relles, Assistant Deputy Director Division of Operations, Center for Preparedness and Response California Department of Public Health

California Department of Transportation (Caltrans) has determined that federal award information is not always disseminated to the project managers. Caltrans will review current policies and procedures of each division and revise, if necessary, so that best practices are followed. Caltrans Internal Audits Office will be working with Local Assistance’s single audit report monitoring process and take on the responsibility to monitor for all Caltrans divisions. Estimated Implementation Date: June 2025 Contact: Ben Shelton, Chief – Caltrans Internal Audits Office Division of Risk and Strategic Management

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.

The Village Treasurer will start preparing the Schedule of Expenditures of Federal Awards each year or contract with a CPA firm for assistance in preparing the Schedule of Expenditures of Federal Awards each year.

Management acknowledges that the organization operated with provisional rates in 2023 and did not update to actual indirect rates. Management has calculated actual rates for 2023, will update its NICRA for new provisional rates for 2025 and will institute a policy of updated rates on an annual basis including computing actual indirect cost rates at the conclusion of each audit. Anticipated Completion Date: 3/31/2025 Responsible Contact Person: Tony Ricciardella, Interim Chief Financial Officer and Alison Roca, Controller

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

Action taken in response to finding: Trilogy submitted an application to apply for a new indirect cost rate in January 2024, we also received provisional approval from the federal agency to continue use of our prior approved indirect cost rate. Since then, Trilogy has clearly defined compliance requirements for maintaining an up-to-date indirect cost rate. This includes developing a timeline of responsibilities, documents and steps needed for approval. This also includes the development of an annual calendar for Finance to be proactive about expiring NICRA agreements. Name(s) of the contact person(s) responsible for corrective action: Richard Powell, Shunita Rhodes Planned completion date for corrective action plan: August 2023 and January 2024.

Views of Responsible Officials: Prior to receiving this finding, HIPS was not in the practice of saving documentation of financial or programmatic reporting submission. Staff responsible for submissions are now documenting submission of reports as of 2024. Incorrect application of the de minimis rate was due to an error in the funder-provided spreadsheet. HIPS Finance Manager has been tasked with checking all spreadsheet calculations prior to submissions of financial reporting.

The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.

The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.

The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.

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 recorded. • Within Workday we are able to track grant performance period, CFDA, manage and capture grant related expenditures and calculate automated billing to sponsors on recoverable costs Business processes have been developed and implemented in Workday’s grant management module to include: Definition of the grant funding source by creating a system-generated grant work tag (identifier) upon receipt of the Sponsor’s Notice of Award; populated fields in Workday with passthrough award data with Prime Sponsor and Bill to sponsor Billing data, and modification of the create award process to add the Grants Management Office to final approval. In FY 24 the City implemented a citywide Grants Management Committee coordinated by the Mayor's Office of Performance and Innovation. Through feedback from this workgroup we identified an expanded scope of responsibility for the Grants Management Office; including oversight and compliance, technology, training and budget monitoring. In the short term a new Grants Director position was created and onboarding is to occur in the first quarter of FY25. Contact Person: Michael Moiseyev, Chief Financial Officer, Baltimore City. Completion Date: June 2024

The Treasurer will review the Schedule of Expenditures of Federal Awards to ensure all federal awards are being reported and the expenditures are properly reported.

Individuals Responsible for Corrective Action Plan: BGCA Fiscal Team-Shelby Mahoney; Alliance Director Corrective Action: Review all federal grant contracts to determine if any separate funding sources should be listed for total funds received. Anticipated Completion Date: December 31, 2024

Individuals Responsible for Corrective Action Plan: BGCA Fiscal Team – Shelby Mahoney, Senior Accounting Manager Corrective Action: Alliance team will enhance procedures and internal controls with respect to preparation and review of the SEFA by reviewing detail of expenses included in prior year with current year expenses, to prevent duplicate entries being reported. Anticipated Completion Date: December 31, 2024

REFERENCE # 2023-001 Rail and Transit Security Grant Program (ALN # 97.075) - Deficiency-Non-Compliance Agency: U.S. Department of Homeland Security Criteria: Subrecipient Monitoring - As stated in Uniform Grant Guidance - §200.331 Requirements for pass-through entities, all pass-through entities must: 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: • Subrecipient name (which must match the name associated with its unique entity identifier); • Subrecipient’s unique entity identifier; • Federal Award Identification Number (FAIN); • Assistance Listing Number (ALN) Number and Name; the pass-through entity must identify the dollar amount made available under each Federal award and the ALN number at time of disbursement; • Identification of whether the award is Research & Development; and • Indirect cost rate for the Federal award (including if the de minimis rate is charged per §200.414 Indirect (F&A) costs); Condition/Context: Metropolitan Transportation Authority (“MTA”) has subrecipient monitoring procedures in place. MTA has corporate policies and procedures regarding subrecipient contracts. We reviewed Rail and Transit Security Grant Program’s subrecipient monitoring compliance. This program had one subrecipient. Based on our review of the subrecipient contract for this program, we noted that the subrecipient contract did not have all the required elements as stated in §200.331. Recommendation: We recommend that MTA implement policies and procedures to communicate the federal grant information to all subrecipients in accordance with Uniform Grant Guidance CFR 200.331 Subrecipient Requirements. Corrective Action Plan The MTA Office of Security has updated it Sub-recipient contract to include the ALN Number – 97.075, Identification of whether the award is R&D and Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414 as per the checklist. Action date March 31, 2025 Final Implementation Date March 31, 2025 Name And Phone Number Of Person Responsible For Implementation Daemion De Vonish Work Ph# 212-878-4768

All three of the subawards selected for testing, the recipient’s UEI number was missing from the subaward. Recommendation: ACT evaluates policies and procedures to ensure all required information is communicated with the subrecipient. Views of Responsible Officials and Planned Corrective Action: ACT accepts the auditors’ recommendation. We will review and update policies and procedures to ensure all required information is included in subaward agreements and communicated to subrecipients, including the recipient’s UEI numbe