Corrective Action Plans

FINDING 2022-005 Finding: Internal controls were not in place/effective in relation to the Title I Annual Expenditure Reports filed during the audit period. Subsequently, the 20-21 Title I Annual Expenditure Report did not agree with School Corporation?s ledgers. $578,452 of expenditures were reported the Annual Expenditure Report and $677,514 from Fund 4121 on the ledgers. Contact Person Responsible for Corrective Action: Carrie McGuire Contact Phone Number: (574) 875-5161 Views of Responsible Official: We concur with the finding Description of Corrective Action Plan: When required annual federal grant reports are completed for submission, they will be reviewed by the treasurer for accuracy. Both the treasurer and the grants coordinator will sign off on the reports. In order to address the issue related to earmarking and set-asides within Title I not be completed, Concord Community Schools created a Grants and Assessment Coordinator position in May 2022. A person was hired to fill this position starting on July 1, 2022. One of the essential functions of this position is maintaining current and accurate records related to federal and state grants. Starting in January 2023, in addition to the Grants and Assessment Coordinator, a member of the business department will be a second reviewer and sign the semi-annual certifications. Anticipated Completion Date: December 31, 2023

OCFO concurs with the finding. In the compilation and reconciliation of the SEFA, the PAYGO ARPA Local Revenue Replacement expenditures component was inadvertently included in the draft District FY 2022 SEFA presented to the external auditors. The District SEFA Compilation Worksheet will be updated to include guidance on treatment of PAYGO FY 2023 ARPA Local Revenue Replacement expenditures (if any) to ensure they are not included in the draft FY 2023 SEFAs presented to the external auditors. See Corrective Action Plan for chart/table

FINDING 2022-006 Contact Person Responsible for Corrective Action: Tyler C. Osenbaugh Contact Phone Number: 260-336-0217 Views of Responsible Official: Agree with the finding Description of Corrective Action Plan: Meal counts differed from the Meal Magic generated Z report and the Chartwells Profit and Loss statement. These meal counts are reconciled by dividing the a la carte purchases by $2.70 to equate to a meal served. Future Z reports will have the a la carte meal equivalents indicated. These figures will be reviewed and validated during the monthly meeting between School Food Authority and Food Service Director (Chartwells? Director of Dining Services). Anticipated Completion Date: April 2023

FINDING 2022-003 Subject: COVID-19 ? Education Stabilization Fund - Reporting Person Responsible for Corrective Action: Tammy Whisenant ? 219-962-1159 Views of Responsible Official: We concur with the finding. I have viewed and acknowledge the discrepancies listed. However, as I am new to my position, I am unable to determine the cause of the discrepancies. Personnel responsible for these areas assumed responsibilities just prior to and/or after this audit period commenced. Description of Corrective Action Plan: The corrective action will include: 1) Assess current assignments and identify opportunities to implement multiple level of review and verification. 2) Continue improved training, education and professional development of personnel responsible for financial transactions and reporting relating to federal programs. 3) Improved use of technology-based financial systems to ensure effectiveness and accuracy of financial transactions and reporting for federal programs. Anticipated Completion Date: An assessment of actions, needs and a plan will be completed by April 30, 2023; with an implementation to occurring by June 30, 2023. ________________________________ Tammy Whisenant, Director of Finance/Treasurer Lake Station Community Schools February 28, 2023

FINDING 2022-006 CONTACT PERSON RESPONSIBLE FOR CORRECTIVE ACTION: Ralph Shrader/Jim Beyer CONTACT PHONE NUMBER: 765-762-3364 VIEWS OF RESPONSIBLE OFFICIAL: We concur with the finding. DESCRIPTION OF CORRECTIVE ACTION PLAN: Information reported via Jotform will be produced by the Superintendent and verified by the Assistant Superintendent with documentation maintained. ANTICIPATED COMPLETION DATE: March 2023

Finding Summary: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Responsible Individual: Kathryn Lynch, Town Administrator Corrective Action Plan: The Town will be updating the Town?s procedures and policies to incorporate the requirements of Part 200 of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Anticipated Completion Date: June 30, 2023

Management agrees with the recommendation and has incorporated policy updates within the September 2023 updated policies and procedures to ensure compliance with required regulations. AALV will continue to update its policies to meet regulatory requirements.

OSF is currently redesigning key components of its accounting system to clearly identify federal expenditures with minimal adjustments. Anticipated Completing Date October 31, 2023

FINDING 2022-002 Information on the federal program: Subject: Education Stabilization Fund - Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition: The School Corporation did not have a documented review control in place to ensure the annual data report was reviewed by someone other than the preparer. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Additionally, the ESSER II Year 1 Annual Data Report submitted to the Indiana Department of Education did not disclose any expenditures and was therefore, understated by approximately $394,000. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and will take the following corrective action. The Annual Data Report will be reviewed, approved and signed by the Superintendent before it is submitted. Responsible party and timeline for completion: The Corporation Treasurer will be responsible effective immediately.

Finding 2022-003 ? Education Stabilization Fund - Reporting Contact Person Responsible for Corrective Action: David Stashevsky Contact Phone Number: 765-378-3329 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The assistant superintendent will manage the grant with the superintendent providing oversight. The assistant superintendent will coordinate the receipts and expenditures of funds with the corporation treasurer. The superintendent will review all financial reports and approve them in writing with notification sent to the assistant superintendent and treasurer. Anticipated Completion Date: The corrections will be made on the next annual report whenever that is due.

FINDING 2022-004 Contact Person Responsible for Corrective Action: John Szabo, Director of Business Affairs Contact Phone Number: 812-443-4461 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Director of Business Affairs (currently John Szabo) will compile information and complete the Annual Reports, which will be reviewed and signed-off on by Assistant Superintendent (currently Tim Rayle) to ensure accuracy of information being submitted. Anticipated Completion Date: Immediately, as of the next required report submission.

FINDINGS AND QUESTIONED COSTS - MAJOR FEDERAL AWARD PROGRAMS AUDIT 2022-002 U.S. Department of Environment Protection ? Assistance Listing # 66.468 Capitalization Grants for Drinking Water State Revolving Fund (Drinking Water State Revolving Fund Cluster) Lack of Required Written Policies & Procedures ? Compliance Condition & Criteria: The Authority does not currently have all the written policies and procedures in place as required by the Uniform Guidance as it relates to financial management and determining allowability of costs for the federal program (Title 2 U.S. Code of Federal Regulations (CFR) 200.302 & 200.305). In addition CFR sections 200.318, 200.319, and 200.320 require there to be written policies and procedures regarding procurement and conflicts of interest. Planned Corrective Action: This is the Authority?s first time subject to the requirements of the Uniform Guidance as we have not had any significant grant funding since 2004. The Authority does have a set of informal policies and procedures that are followed as it relates to financial management, allowability of costs, procurement, and conflicts of interest, and have been very careful to carry out all federal program activities in accordance with established regulations; however, the Authority was simply not aware of the requirement that these polices and procedures be documented in writing. The Authority will begin immediately to get these policies and procedures as they relate to federal programs documented in writing. The Authority is currently working with their consultants to have the written polices established and plan to have this completed within the next fiscal year. If the U.S. Department of Environmental Protection has questions regarding this plan, please contact: Mr. Kenneth Bost, Authority Chairman Alexandria Borough Water Authority PO Box 336 Alexandria, PA 16611 Phone: 814-669-4441

Finding 2022-003 ? Education Stabilization Fund - Reporting Contact Person Responsible for Corrective Action: Christopher deBruyn Contact Phone Number: (219) 785-2239 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The ESSER and GEER Grant Awards Annual Report was correctly completed, but did not have a verified review. Moving forward the review will be conducted by forwarding the completed to another member of the corporation team and a response email be sent back, only after the Annual Report has been understood and independently reviewed. Anticipated Completion Date: The next ESSER and GEER Grant Awards Annual Report

U.S. Department of Housing and Urban Development Susanne Corporation respectfully submits the following corrective action plan for the year ended June 30, 2022. Name and address of independent public accounting firm: KPM CPAs, PC 1445 E Republic Road Springfield, Missouri 65804 Audit period: July 1, 2021 through June 30, 2022 The findings from the June 30, 2022 schedule of findings and questioned costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule. Findings ? Financial Statement Audit Significant Deficiency 2022-001 Financial Reporting Recommendation: Management should review and update monthly and year-end closing procedures to ensure controls over financial reporting are sufficient for financial statements to be prepared in accordance with accounting principles generally accepted in the United States of America. Action Taken: Management agrees with the finding and year end closing procedures will be changed to reflect appropriate accounting principles. Findings ? Major Federal Award Program Audit Significant Deficiency 2022-002 Written Uniform Guidance Policies and Procedures Recommendation: We recommend Susanne Corporation draft and adopt written procedures in accordance with Uniform Guidance requirements. Action Taken: Management agrees with the finding and is in the process of drafting and implementing written procedures for cash management and determining the allowability of costs in accordance with Subpart E ? Cost Principals. If the U.S. Department of Housing and Urban Development has questions regarding this plan, please call Joey Wilke at 417-366-3440.

Finding # 2022-001: Type: Federal award, Significant Deficiency over Schedule of Expenditures of Federal Awards (SEFA) Finding The Organization?s initial schedule of expenditures of federal awards (SEFA) presented for the audit did not identify all federal awards. The SEFA excluded a new award and required adjustments. Recommendation: The Organization should implement additional procedures to review the preparation of the SEFA presented for the audit to accurately capture all activity under federal awards. Corrective Action: We will instill additional levels of review prior to submitting draft schedules to the auditor. Anticipated Completion Date: 6/30/2023

AUDIT FINDING #2022-001 Condition: For 8 of 12 semi-annual Federal Financial Reports tested, the reported cash disbursements did not reconcile to the expenditures recorded in the general ledger. Unreconciled differences ranged from $30 to $104,174 and totaled approximately $199,000. CORRECTIVE ACTION Upon transmittal, revenue and total expenses matched the profit and loss reports for the 12 Federal Financial Reports referenced above. The 8 Federal Financial Reports noted above occurred in periods prior to the 2021-002 audit finding that was implemented in October 2022. The Council will continue to follow the 2021-002 corrective action finding. In addition, accruals for expenses paid in the current year for the previous year will be done on a monthly basis with the reversals being done on the first day of each following month. All entries and accruals will be completed prior to the filing of the Federal Financial Reports.

Views of Responsible Officials and Corrective Action: We are in the process of hiring a new bookkeeper/accountant to help manage these issues and develop policies to avoid future errors. We will also implement a process to make sure QuickBase and QuickBooks agree.

Material Weakness Reporting ? Major Programs, including COVID-19 funding Criteria and Condition: While the Organization has some written financial management procedures documentation, it does not meet all the recent specific requirements under 2 CFR 200.302 in the Uniform Grant Guidance. Context: The financial management requirements under 2 CFR 200.302 require each non-federal entity maintain effective control over, and accountability for all funds, property, and other assets, including having written procedures in place. Cause: The Organization did not comply with this requirement. Potential Effect: Errors could occur in financial reporting. Recommendation: We recommend the Organization update its existing policies to comply with the requirements under 2 CFR 200.302. Views of Responsible Officials and Planned Corrective Actions: Management understands the importance of defining and following the necessary policies and procedures to remain in compliance with the requirements under 2 CFR 200.302. Action Taken and Anticipated Completion: We will begin drafting the necessary policies in the 2023.

Views of Responsible Officials: The transition to the accounting system has been completed by the Accountant.

Views of Responsible Officials: The transition to the accounting system has been completed by the Accountant.

On May 3, 2021, the Grantee inform the Municipality about the determination to temporarily submit to a partial protective intervention the programmatic and administrative function of the delegated agency of Pe?uelas. As a direct consequence of such a determination, since May 3, 2021, up to July 31, 2022 (grant termination date), two employees of the Grantee had interference in all fiscal and programmatic transactions of the delegated agency, requiring their authorization for fiscal or programmatic transactions to be carried out. During this timeframe, key personnel of the delegated agency, such as the Program Director, the Program Accountant, the Property Manager, among others, resigned or were required to be replaced by the Grantee?s representatives, altering the programmatic and fiscal operations of the delegated agency. About the program year 2021-2022 closing, the Municipality of Pe?uelas return the funds surplus after the end of the period of liquidation of obligations, including the $3,288,516 related to Head Start Disaster Recovery program retained in the Program restricted cash account as instructed by a Grantee?s representative. Related to the program year prematurely terminated by the Grantee (program year 2022-2023), the Municipality?s Finance Department staff reconciled the program fiscal transactions registered in the Municipality?s computerized accounting system, with the grant awards, as amended, and prepare a liquidation report of each grant award. Such reports will be submitted to the Grantee to discuss the steps for liquidation of obligations with third parties, and the reimbursement of payroll and other expenditures financed by the Municipality?s General Fund. Implementation Date: August 31, 2023 Responsible Person: Mrs. Yadixa Ramos Finance Department Director

We gave instructions to the finance department accounting staff to strengthening internal procedures and controls to ensure accurate preparation and submission of financial reports. Implementation Date: August 31, 2023 Responsible Person: Mrs. Yadixa Ramos Finance Department Director

Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding. Crawford County Community School Corporation will continue submission of required data to the IDOE on federal spending with at least two people completing the curation. However, final drafts will be reviewed and then final reports will be signed by the at least two people who reviewed the final draft. This signed copy, if not required to be submitting to the IDOE, will be kept locally. Responsible party and timeline for completion: 1) Amy Belcher, Program Administrator, will ensure all final reports have been reviewed and signed by at least two people before submission to the IDOE immediately.

Response: Management notes that, as this is their first single audit and this was one-time emergency funding rather than an ongoing award, they do not have these procedures in writing. However, they followed SBA/SVOG guidelines for allowability of costs, which were researched early in the grant process, and assigned costs in accordance with those guidelines. The budget, which included all assigned costs and was approved by the Lakewood Board of Directors, was also submitted and cleared by the SVOG Compliance Team and they inquired about the allowability of any items over which the guidelines were unclear. Action to be taken: Management notes that, as this was one-time emergency funding rather than an ongoing award, they do not anticipate receiving federal funding in the future. As such, they do not intend to document these procedures in writing at this point. However, if they apply for federal funding again in the future, they will develop written procedures at that point. Responsible Person: Andrew Edwards, Executive Director

Finding 2022-003 ? Education Stabilization Fund - Reporting Contact Person Responsible for Corrective Action: Vicki Jones, Corporation Treasurer Contact Phone Number: 765-793-4877 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Education Stabilization Fund Reporting will be completed and submitted in a timely manner. The Education Stabilization Fund Reporting will be verified with a sign-off by the Superintendent. Anticipated Completion Date: Upon Request