Corrective Action Plans

Finding 374662 (2023-001)

Significant Deficiency 2023

Spring Meadows II- Village of Spring Meadows II 047-Ee047

MI

Internal Control / Segregation of Duties HUD Housing Programs Reporting

Condition: There was a lack of timely reconciliation performed by the Organization of the replacement reserve account activity. The Organization received approval in 2019 from HUD for a $22,427 loan advance to be repaid to the replacement reserve when the January 2019 voucher payment was received. O...

Condition: There was a lack of timely reconciliation performed by the Organization of the replacement reserve account activity. The Organization received approval in 2019 from HUD for a $22,427 loan advance to be repaid to the replacement reserve when the January 2019 voucher payment was received. Of this amount, $6,740 was received and deposited back into the replacement reserve in 2019. The remaining $15,687 was received by the Organization on February 6, 2023, however, this amount was not deposited back to the replacement reserve until after year end, on August 16, 2023. Planned Corrective Action: Management acknowledges the significant deficiency in internal control over compliance that resulted in the late deposit back into the replacement reserve account as required and has taken measures to improve internal control over compliance. Contact person responsible for corrective action: Bruce Blalock, Sr. VP of Finance and Obligated Group Operations Anticipated Completion Date: August 16, 2023

View Audit 294335

Finding 374658 (2023-002)

Significant Deficiency 2023

Hillside Apartments Phase Ii, Inc.

MI

Internal Control / Segregation of Duties HUD Housing Programs Reporting

Finding Number: 2023-002 Condition: There was a lack of timely reconciliation performed by the Organization to ensure all withdrawals from the replacement reserve account had proper HUD approval, all required monthly deposits were made, and HUD approved loans were repaid timely The Organization rece...

Finding Number: 2023-002 Condition: There was a lack of timely reconciliation performed by the Organization to ensure all withdrawals from the replacement reserve account had proper HUD approval, all required monthly deposits were made, and HUD approved loans were repaid timely The Organization received approval from HUD for a $35,000 loan advance to be repaid to the replacement reserve when unpaid voucher payments were received (October 31, 2022); however, the loan was not repaid until December 13, 2022. Planned Corrective Action: Management acknowledges the significant deficiency in internal control over compliance and has taken measures to improve internal control over compliance Management also acknowledges that it did not repay the replacement reserve timely with voucher funds subsequently received, but it did repay the $35,000 advance to the replacement reserve account on December 13, 2022. Contact person responsible for corrective action: Bruce Blalock, Sr. VP of Finance and Obligated Group Operations Anticipated Completion Date: December 13, 2022

View Audit 294332

Finding 374656 (2023-002)

Significant Deficiency 2023

Piloted Schools of Indiana, Inc.

IN

Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties § 200.329

Finding 2023-002 - Reporting Transitions in operations positions over the course of the first years of ESSER distributions and reimbursements, combined with the first round of data collection resulted in discrepancies between state reports and internal records. A thorough review of past reports and ...

Finding 2023-002 - Reporting Transitions in operations positions over the course of the first years of ESSER distributions and reimbursements, combined with the first round of data collection resulted in discrepancies between state reports and internal records. A thorough review of past reports and data will be completed to identify errors by the School Principal (Jennica Adkins) and future reports will be completed in conjunction with Bookkeeping Plus (Tina Spencer) to ensure accuracy. This will be completed before the next round of ESSER reports due April 2024.

View Audit 294330

Finding 374651 (2023-004)

Significant Deficiency 2023

Seward County Community College

KS

Student Financial Aid Reporting Matching / Level of Effort / Earmarking

2023-004 – Student Financial Assistance Cluster – Special Tests and Provisions – NSLDS Enrollment Reporting Condition During testing, it was determined that six of the 20 students tested for enrollment status changes did not have those changes properly reflected within their NSLDS records. Recommend...

2023-004 – Student Financial Assistance Cluster – Special Tests and Provisions – NSLDS Enrollment Reporting Condition During testing, it was determined that six of the 20 students tested for enrollment status changes did not have those changes properly reflected within their NSLDS records. Recommendation We recommend that the College review its control policies to ensure that reporting is completed accurately and timely. Wherever possible, any technological errors discovered should be pursued with the responsible party in order to try to determine a cause, and a solution or preventative measure should be implemented to prevent future errors from occurring. Comments on the Finding The oversite has been acknowledged by management and we will try our hardest to make sure that the process is addressed. Actions Taken Starting October 15, 2023, the Registrar will review the error reports from NSLDS in a timely manner to make sure that issues are resolved. There are quarterly training or consultations with Ellucian to verify best practices. On January 23, 2024, we received notification from NSLDS that we have been removed from “G for Degree Status” so that all awards will be recognized instead of an G Status for awards. Starting February 2024, student samples will be taken from submissions to NSLDS to review for accuracy before submissions.

View Audit 294326

Finding 374628 (2023-002)

Significant Deficiency 2023

School District of Belleville

WI

Questioned Costs Procurement, Suspension & Debarment Subrecipient Monitoring

Finding #2023-002: ESSER II #84.425D COVID-19 – Education Stabilization Fund and ESSER III #84.425U COVID-19 – Education Stabilization Fund Federal Grantor: U.S. Department of Education Pass-through Award Numbers: 2022-252646-DPI-ESSERFII-163 and 2022-252646-DPI-ESSERFIII-165 Pass-throug...

Finding #2023-002: ESSER II #84.425D COVID-19 – Education Stabilization Fund and ESSER III #84.425U COVID-19 – Education Stabilization Fund Federal Grantor: U.S. Department of Education Pass-through Award Numbers: 2022-252646-DPI-ESSERFII-163 and 2022-252646-DPI-ESSERFIII-165 Pass-through Entity: Wisconsin Department of Public Instruction Condition: There were five Education Stabilization Fund construction projects performed by contractors/subcontractors. None of the contracts included prevailing wage language clauses and certified payrolls were not obtained by the District during the fiscal year expended. Not all contractors/subcontractors were able to provide certified payrolls when requested as part of the compliance testing. Criteria: Wage rate requirements apply to the Education Stabilization Fund when laborers and mechanics employed by contractors or subcontractors work on construction contracts more than $2,000. Laborers must be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their contracts subject to wage rate requirements a provision that the contractor or subcontractor comply with those requirements and the DOL regulations. This includes a requirement for the contractor or subcontractor to submit to the District weekly payrolls and a statement of compliance (certified payrolls). Cause: There was turnover in the business office and the contracts were secured and approved prior to the current business manager. The District was not aware of the applicable requirements related to these projects. Effect: A reimbursement request was made for expenditures that did not comply with wage rate requirements. Questioned Costs: $78,300 (Amount for which certified payrolls were not subsequently provided) Recommendation: Establish procedures and controls to comply with wage rate requirements related to the Education Stabilization Fund. Obtain verification from contractors that prevailing wage rates were paid on the projects submitted for costs reimbursed by the grant. Response: The District became aware of the prevailing wage rate requirements after finishing the projects. Before bidding future construction projects more than $2,000, that may be funded with federal grant dollars, the request for bid and contract will include a prevailing wage rate clause. Certified payrolls will be received from contractors or subcontractors. Additionally, the district has obtained payroll data from all each contractor to provide support for wage rates paid if necessary. Contact Person: Erik Farrar Anticipated Completion: March 15, 2024

View Audit 294304 Questioned Costs: $1

Finding 374610 (2023-001)

Significant Deficiency 2023

Concordia University, Nebraska

NE

Questioned Costs Student Financial Aid Significant Deficiency

Student Financial Assistance Cluster – Assistance Listing No. Various Recommendation: We recommend the University evaluate its procedures and a policy around how level of education is determined and verified when packaging and awarding students. Explanation of disagreement with audit finding: There ...

Student Financial Assistance Cluster – Assistance Listing No. Various Recommendation: We recommend the University evaluate its procedures and a policy around how level of education is determined and verified when packaging and awarding students. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The Student Financial Aid Office will add an additional step to the policy for verifying and reviewing student loan levels. In addition to reviewing loan level reports before the beginning of the academic year, we will also review loan levels after the census date of the first semester of the academic year. This added step will catch any changes that were made to student packaging up to the census date. Name(s) of the contact person(s) responsible for corrective action: David L Kumm, Executive VP CFO/COO Planned completion date for corrective action plan: 7/1/2023

View Audit 294279 Questioned Costs: $1

Finding 374579 (2023-006)

Material Weakness 2023

City of Olean, New York

NY

Matching / Level of Effort / Earmarking

Auditor’s Recommendation: We recommend that asset and liability accounts be reconciled by the City Auditor’s office on a regular and routine basis. Further, reconciliations should be reviewed by management to ensure their accurate and timely completion. ...

Auditor’s Recommendation: We recommend that asset and liability accounts be reconciled by the City Auditor’s office on a regular and routine basis. Further, reconciliations should be reviewed by management to ensure their accurate and timely completion. City’s Response: The City Auditor, Lens Martial, will take the necessary steps to remedy this issue during the year ending May 31, 2024. A reconciliation of all asset and liability balances will be performed on a monthly basis by the City Auditor. Additionally, the City will take the necessary steps to ensure the general ledger packages reconcile and agree to one and other on a regular basis.

View Audit 294247

Finding 374513 (2023-001)

Significant Deficiency 2023

Soka University of America

CA

Student Financial Aid Eligibility Reporting

Management’s Corrective Action Plan Soka University acknowledges the finding and the recommendation regarding improving procedures. Finding 2023-001 - Special Tests and Provisions – Enrollment Reporting: Significant Deficiency in Internal Control over Compliance After addressing the identified defic...

Management’s Corrective Action Plan Soka University acknowledges the finding and the recommendation regarding improving procedures. Finding 2023-001 - Special Tests and Provisions – Enrollment Reporting: Significant Deficiency in Internal Control over Compliance After addressing the identified deficiency in our enrollment reporting process, a thorough evaluation was conducted to rectify the issue and prevent its recurrence. We recognized that alterations in students' academic plans, prompted by the COVID-19 pandemic, led to delays in fulfilling mandatory graduation requirements such as study abroad requirements, resulting in delays in posting study abroad grades to the Soka transcript. Consequently, during end-of-term degree audits by the Office of the Registrar, students with pending study abroad grades or incomplete grades in their final term were inadvertently not updated to a withdrawn status, thereby failing to trigger updates to the National Student Clearinghouse and subsequently National Student Loan Data System (NSLDS). In collaboration with the Office of the Registrar, robust internal controls have been implemented to mitigate this issue going forward. Following the conclusion of each term, the Registrar will generate a comprehensive report listing all students who have applied for degree completion. This report will be annotated to identify students who have fulfilled all degree requirements, enabling their degrees to be conferred promptly. Additionally, students with incomplete grades will be flagged, and their status will be promptly changed to withdrawn. In both scenarios, enrollment status updates will be transmitted to the clearinghouse and subsequently NSLDS. The Registrar will inform the Office of Financial Aid of graduates and students with updated statuses for NSLDS reporting, and Financial Aid will request an ad hoc enrollment request on NSLDS. To ensure accuracy, a manual spot-checking process will be conducted in NSLDS on 20% of the updated student records in NSLDS. Upon notification of completed incomplete grades, the Registrar will promptly update transcripts, review degree requirements, and confer degrees where applicable. Following this update, the Registrar will manually update the clearinghouse and ask the Office of Financial Aid to request an Ad hoc enrollment report on NSLDS, ensuring timely and accurate reporting. This manual request will be verified on NSLDS after the ad hoc report has been run. Students failing to meet degree requirements due to failed coursework and are enrolled to return in subsequent terms will not be updated to withdrawn status unless they fail to return as scheduled. These measures aim to enhance the integrity and accuracy of our enrollment reporting process, ensuring compliance with regulatory requirements and minimizing the risk of future deficiencies. Anticipated Completion Date: February 2024 Scott Brandos Director of Financial Aid Soka University of America 949-480-4048

View Audit 294224

Finding 374491 (2023-001)

Significant Deficiency 2023

Cairn University

PA

Reporting Student Financial Aid Significant Deficiency

Views of Responsible Officials and Planned Corrective Actions: The University agrees with this recommendation and will ensure that staff with reporting compliance responsibilities are appropriately trained during periods of transition.

View Audit 294192

Finding 374446 (2023-001)

Significant Deficiency 2023

Young Harris College

GA

Student Financial Aid Matching / Level of Effort / Earmarking Special Tests & Provisions § 200.303

Finding 2023-001: Special Test and Provisions: Enrollment Reporting Context/Condition: Of the 37 students selected for enrollment reporting testing, 5 students within the sample were reported to NSLDS outside the maximum 60-day window. Recommendation: The auditor recommended that the College revie...

Finding 2023-001: Special Test and Provisions: Enrollment Reporting Context/Condition: Of the 37 students selected for enrollment reporting testing, 5 students within the sample were reported to NSLDS outside the maximum 60-day window. Recommendation: The auditor recommended that the College review and update internal controls to ensure student enrollment status in the National Student Loan Data System (NSLDS) is updated in a timely manner to ensure compliance with Federal Requirements. Persons Responsible for Corrective Action: Tammy Gibson, Registrar Planned Corrective Action: Additional dates will be added to the National Student Clearinghouse submission schedule to capture December graduates. In addition, Registrar's Office staff will be instructed to update individual student records, as needed, to account for changes outside of the submission schedule to avoid reporting outside of the maximum 60-day window. Anticipated Completion Date: December 8, 2023

View Audit 294103

Finding 374445 (2023-003)

Significant Deficiency 2023

West Lyon Community School District

IA

Internal Control / Segregation of Duties Significant Deficiency Matching / Level of Effort / Earmarking

Finding 2023‐003 Special Tests – Wage Rate Requirement Significant Deficiency Finding Summary: The District did not sure proper and timely inclusion of prevailing wage clauses in one construction contract issued in the prior year and still in effect this year. Responsible Individuals: Shawn Kreman, ...

Finding 2023‐003 Special Tests – Wage Rate Requirement Significant Deficiency Finding Summary: The District did not sure proper and timely inclusion of prevailing wage clauses in one construction contract issued in the prior year and still in effect this year. Responsible Individuals: Shawn Kreman, Superintendent Corrective Action Plan: The District will include prevailing requirements in contracts utilizing federal dollars. Anticipated Completion Date: Ongoing

View Audit 294102

Finding 374438 (2023-006)

Material Weakness 2023

Lawrenceburg Community School Corporation

IN

Matching / Level of Effort / Earmarking Allowable Costs / Cost Principles § 200.208 § 200.303 § 200.403

FINDING 2023-006 Finding Subject: Special Education Cluster (IDEA) – Earmarking Summary of Finding: The Non-Public Proportionate Share expenditures for the 21611-048-PN01 grant award could not be verified for the individual member schools. The non-public school share funds for the participating memb...

FINDING 2023-006 Finding Subject: Special Education Cluster (IDEA) – Earmarking Summary of Finding: The Non-Public Proportionate Share expenditures for the 21611-048-PN01 grant award could not be verified for the individual member schools. The non-public school share funds for the participating member schools were allocated based on the yearly budget for certified staff instead of time charged to the non-public schools. These allocations were the amounts reported to IDOE. As such, we were unable to identify which expenditures were for each school in order to verify the minimum amount per the grant award was expended and properly reported to IDOE as required. Contact Person Responsible for Corrective Action: Julie Dudley Contact Phone Number and Email Address: 812.537.7205 jdudley@lburg.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Expenses for non-public schools are tracked and charged to the appropriate corporation. Staff record time spent at each non-public school, sign and date the form and turn it into the treasurer. The expenses are then moved to the correct expense line on the grant after receiving this information. Materials that are purchased are charged to the correct expense account when paid. ROD’s treasurer will prepare a report showing compliance with the earmarking requirement on a monthly basis. These reports will be provided to the ROD board for review, and our Superintendent is a member of that board. Anticipated Completion Date: July 1, 2023

View Audit 294097

Finding 374433 (2023-004)

Material Weakness 2023

Lawrenceburg Community School Corporation

IN

Equipment & Real Property Management Internal Control / Segregation of Duties Matching / Level of Effort / Earmarking § 200.303

FINDING2023-004 Finding Subject: COVID-19 Emergency Connectivity Fund Program - Equipment, Special Tests and Provisions - Restricted Purpose Summary of Findings: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the gra...

FINDING2023-004 Finding Subject: COVID-19 Emergency Connectivity Fund Program - Equipment, Special Tests and Provisions - Restricted Purpose Summary of Findings: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management and Special Tests and Provisions - Restricted Purpose compliance requirements. Equipment Management A listing of equipment purchased with program funds was maintained, however, there was no documented oversight or review process to ensure the listing was accurate and complete. Special Tests and Provisions - Restricted Purpose There was no documented control process in place to ensure that each student or staff member received only one device, as required by the per-user limitations in the grant award. Officials stated that the Asset Management system would not have allowed the same student to register multiple devices, however, there was no documented oversight or review to ensure that the user limitations in the system were in place during the audit period, and operating effectively. Contact Person Responsible for Corrective Action: Julie Dudley Contact Phone Number and Email Address: 812.537.7205 jdudley@lburg.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Beginning with the 2024-2025 school year, the technology department will provide each building principal with a list that includes all students and asset tag numbers. The principals will then have each student sign next to their information acknowledging that information is accurate. Anticipated Completion Date: August 2024

View Audit 294097

Finding 374429 (2023-002)

Material Weakness 2023

Lawrenceburg Community School Corporation

IN

School Nutrition Programs Internal Control / Segregation of Duties Eligibility § 200.303

FINDING 2023-002 Finding Subject: Child Nutrition Cluster - Eligibility Summary of Findings: An effective internal control system, which would include segregation of duties, was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Elig...

FINDING 2023-002 Finding Subject: Child Nutrition Cluster - Eligibility Summary of Findings: An effective internal control system, which would include segregation of duties, was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Eligibility compliance requirement. The free and reduced-price applications were completed online by the applicants, and the information was automatically uploaded into the School Corporation's nutrition program software system. The software system then calculated the student's eligibility for free and reduced-price meals based on the parameters in the system. There was no documented oversight, review, or approval process to ensure the parameters in the system were correct and that the eligibility determination made complied with the requirements of the programs. The lack of internal controls was a systematic issue throughout the audit period. Contact Person Responsible for Corrective Action: Julie Dudley Contact Phone Number and Email Address: 812.537.7205 jdudley@lburg.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The Food Service Director and Business Manager have added the verification of every 30th Free/Reduce application that is submitted during the school year to their monthly checklists. Beginning with the 2024-25 school year, the Food Service Director will enter the eligibility parameters into the school nutrition software. Once entered the Food Service Director will provide a copy of the prices entered into the system to be reviewed and approved by the Business Manager or Superintendent. Anticipated Completion Date: January 2024/July 2024

View Audit 294097

Finding 374412 (2023-003)

Significant Deficiency 2023

Warren Rural Electric Cooperative Corporation INC

KY

Questioned Costs Allowable Costs / Cost Principles Period of Performance § 200.303

Criteria and Condition: 2 CFR 200.303 requires the non-federal entity to establlish and maintain effective internal controls over compliance with Federal statues, regulations, and the terms and conditions of the Federal award including proper tracking of grant expenditures or compliance. Certain int...

Criteria and Condition: 2 CFR 200.303 requires the non-federal entity to establlish and maintain effective internal controls over compliance with Federal statues, regulations, and the terms and conditions of the Federal award including proper tracking of grant expenditures or compliance. Certain internal controls were not in place to prevent costs from outside the period of performance from being charged to the grant. Action taken: In regard to 2023-003, Management will provide a 2nd review of project worksheets before submission. The designated FEMA Coordinator will be responsible for this corrective action and anticipates completion of corrective action before October 1, 2023.

View Audit 294076 Questioned Costs: $1

Finding 374411 (2023-001)

Significant Deficiency 2023

York College of Pennsylvania

PA

Student Financial Aid Reporting Subrecipient Monitoring

Corrective Action Planned: The College has noted the issue and it has since been rectified and has re-ran the process to provide the proper effective dates for withdrawn students to the National Student Clearinghouse. The College does report to the National Student Clearinghouse every 30 days. The C...

Corrective Action Planned: The College has noted the issue and it has since been rectified and has re-ran the process to provide the proper effective dates for withdrawn students to the National Student Clearinghouse. The College does report to the National Student Clearinghouse every 30 days. The College has reviewed their policies and procedures to ensure proper reporting requirement procedures to NSC and NSLDS. Training has been provided to those responsible for manual adjustments to records having extenuating circumstances. Name(s) of Contact Person(s) Responsible for Corrective Action: Eric Dinsmore, Senior Director of Financial Aid Anticipated Completion Date: As of January 2024, withdrawal student status change effective dates have been corrected. The College has reviewed reporting policies and procedures and has provided training to responsible parties for manual reporting whenever extenuating circumstances occur. The College will implement any additional necessary changes in 2024 fiscal year.

View Audit 294058

Finding 374399 (2023-001)

Material Weakness 2023

Nineveh-Hensley-Jackson United School Corporation

IN

Equipment & Real Property Management Internal Control / Segregation of Duties Procurement, Suspension & Debarment § 200.303 § 200.313

FINDING 2023-001 Finding Subject: COVID-19 – Education Stabilization Fund – Equipment and Real Property Management Summary of Finding: An effective internal control system, which would include segregation of duties, was not in place at the School Corporation in order to ensure compliance with requir...

FINDING 2023-001 Finding Subject: COVID-19 – Education Stabilization Fund – Equipment and Real Property Management Summary of Finding: An effective internal control system, which would include segregation of duties, was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the following compliance requirements: Equipment and Real Property Management. The School Corporation presented the equipment and real property records for the ESF grant equipment: however, the records failed to include a description (including serial number or other identification number), source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, location, use, and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR 200.313(d)(1)). Contact Person Responsible for Corrective Action: Jacob Heuchan Contact Phone Number and Email Address: (317)-878-2100; jheuchan@nhj.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The Business Manager will work with the Technology Director and the respective departments to ensure the appropriate information is being entered into the Corporation’s equipment and real property records for items purchased through ESF/federal funds. A physical inventory of the property will be taken and the results reconciled with the property records at least once every two years. Anticipated Completion Date: Immediate.

View Audit 293990

Finding 374388 (2023-004)

Significant Deficiency 2023

Bethany College

KS

Questioned Costs Student Financial Aid Eligibility

Corrective Action Plan 2023-004: The College concurs with the finding and has reviewed and where appropriate made updates to the processes used to package loans when there is an annual or aggregate loan limit reached. Completion Date: August 2023 Contact Person: Haley Wesley, Vice President of Enr...

Corrective Action Plan 2023-004: The College concurs with the finding and has reviewed and where appropriate made updates to the processes used to package loans when there is an annual or aggregate loan limit reached. Completion Date: August 2023 Contact Person: Haley Wesley, Vice President of Enrollment Management & Marketing

View Audit 293985 Questioned Costs: $1

Finding 374374 (2023-003)

Material Weakness 2023

Merrillville Community School Corporation

IN

Matching / Level of Effort / Earmarking Special Tests & Provisions § 200.303

FINDING 2023-003 Finding Subject: COVID-19 Education Stabilization Fund – Special Tests and Provisions – Wage Rate Requirements Summary of Finding: Material Weakness, Modified Opinion Contact Person Responsible for Corrective Action: Debbie Van Slyke Contact Phone Number and Email Address: 219-650-5...

FINDING 2023-003 Finding Subject: COVID-19 Education Stabilization Fund – Special Tests and Provisions – Wage Rate Requirements Summary of Finding: Material Weakness, Modified Opinion Contact Person Responsible for Corrective Action: Debbie Van Slyke Contact Phone Number and Email Address: 219-650-5300 x7563, dvanslyke@mvsc.k12.in.us Views of Responsible Officials: We concur with the finding. We learned of this new requirement after the projects were started and some had already been completed. Once the guidance was released to the school districts we implemented the plan below. Description of Corrective Action Plan: The School Corporation plans to take the following action: 􀁸 Davis Bacon wage rate requirement clauses will be included in all future ESSER funded construction contracts. 􀁸 Certified payrolls will be obtained as required for all future ESSER funded construction projects. Anticipated Completion Date: 􀁸 Davis Bacon wage rate requirement clauses will be included in future ESSER funded construction contracts. A completion date is not available as we do not expect any additional construction projects to be funded through ESSER. 􀁸 Certified payrolls will be obtained as required for ESSER funded construction projects. A completion date is not available as we do not expect any additional construction projects to be funded through ESSER.

View Audit 293984

Finding 374372 (2023-002)

Material Weakness 2023

Merrillville Community School Corporation

IN

Matching / Level of Effort / Earmarking Allowable Costs / Cost Principles § 200.208 § 200.303 § 200.403

FINDING 2023-002 Finding Subject: Special Education Cluster - Earmarking Summary of Finding: Material Weakness, Modified Opinion Contact Person Responsible for Corrective Action: Meghan Damron Contact Phone Number and Email Address: 219-650-5300 x5361 Views of Responsible Officials: We concur with t...

FINDING 2023-002 Finding Subject: Special Education Cluster - Earmarking Summary of Finding: Material Weakness, Modified Opinion Contact Person Responsible for Corrective Action: Meghan Damron Contact Phone Number and Email Address: 219-650-5300 x5361 Views of Responsible Officials: We concur with the finding. We have taken the audit finding, conclusions and recommendations and created a corrective action plan to correct our earmarking for the future. Description of Corrective Action Plan: As a member of the Northwest Indiana Special Education Cooperative (NISEC), Merrillville Community School Corporation reported their proportionate share based on a percentage of expenditures, and had successful audits in doing so. When Merrillville Community School Corporation was notified that this process was no longer acceptable, we immediately implemented an internal control process with NISEC which included a detailed reporting of staff work hours for nonpublic schools related to only our school corporation. The report is then reviewed and signed by the NISEC staff working for the nonpublic school and their supervisor. The employee detailed time and effort report are then provided to the NISEC finance department for a second review and signature before being provided to payroll. NISEC payroll then charges the proportionate share to the IDEA Part B grant in the payroll system bi-weekly based on the time and effort report pertinent to just Merrillville Community School Corporation. The time and effort reports are then used to submit the reimbursement request to the Department of Education for Merrillville Community School Corporation’s proportionate share. Additionally, any IDEA Part B nonpublic material expense is broken out in detail with Merrillville Community School Corporation proportionate share for approval by the NISEC finance office prior to vendor payment and the reimbursement request is submitted to the Department of Education. 􀀃􀀃 Anticipated Completion Date: The Northwest Indiana Special Education Cooperatives Chief Financial Officer stopped reporting nonpublic proportionate share expenditures by percentage as of the 2022-2023 school year. An internal control procedure to report nonpublic proportionate share expenditures by detailed time and effort work and expenditures were implemented as of the 2023-2024 school year.

View Audit 293984

Finding 374368 (2023-006)

None 2023

Winslow Memorial Hospital D/b/a Little Colorado Medical Center

AZ

Special Tests & Provisions Matching / Level of Effort / Earmarking

Finding 2023-006 Federal Agency Name: United States Department of Agriculture Program Name: Community Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Compliance Requirement: Special Tests and Provisions Finding Summary: The Hospital’s operations did not generate suf...

Finding 2023-006 Federal Agency Name: United States Department of Agriculture Program Name: Community Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Compliance Requirement: Special Tests and Provisions Finding Summary: The Hospital’s operations did not generate sufficient financial results to be meet the 1.25 debt service coverage ratio. Responsible Individuals: John J Dempsey, Chief Executive Officer, Lona King, Chief Financial Officer Corrective Action Plan: Management will comply with the terms of the workout agreement entered on January 24, 2024, to avoid future compliance issues. Anticipated Completion Date: February 28, 2025 as indicated in the Workout Agreement

View Audit 293974

Finding 374357 (2023-004)

Significant Deficiency 2023

Central Consolidated School District

NM

Procurement, Suspension & Debarment Matching / Level of Effort / Earmarking Special Tests & Provisions

Specific corrective action plan for finding: Christi Walter, Coordinator, is working with a contracted law firm to review the current contract to include the Davis Bacon Act and the Copeland Compliance. The School District will offer training on EDGAR and CFR compliance including Wage Rate/Davis Bac...

Specific corrective action plan for finding: Christi Walter, Coordinator, is working with a contracted law firm to review the current contract to include the Davis Bacon Act and the Copeland Compliance. The School District will offer training on EDGAR and CFR compliance including Wage Rate/Davis Bacon Act Procurement, Construction, and Grants Staff Timeline for completion of corrective action plan: June 30, 2023 Employee position(s) responsible for meeting the timeline: Christi Walter, Coordinator, Herbie Ellison, Coordinator and Candice Thompson, Operations Director

View Audit 293969

Finding 374345 (2023-002)

Significant Deficiency 2023

Town of Bridgwater, Vermont

VT

Subrecipient Monitoring Significant Deficiency Matching / Level of Effort / Earmarking § 200.302

Update grant spreadsheet monthly

View Audit 293943

Finding 374344 (2023-001)

Significant Deficiency 2023

Town of Bridgwater, Vermont

VT

Subrecipient Monitoring Allowable Costs / Cost Principles Significant Deficiency § 200.302

Adopt suggested policies as outlined by auditor

View Audit 293943

Finding 374295 (2023-006)

Material Weakness 2023

Delphi Community School Corporation

IN

Internal Control / Segregation of Duties Material Weakness Reporting § 200.302 § 200.303 § 200.328 § 200.329

FINDING 2023-006 Finding Subject: Education Stabilization Fund - Reporting Summary of Finding: Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. The failure to establish an ef...

FINDING 2023-006 Finding Subject: Education Stabilization Fund - Reporting Summary of Finding: Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Contact Person Responsible for Corrective Action: Andrea Miller Contact Phone Number and Email Address: 765-564-2100, millera@delphi.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The treasurer will prepare all required reports, and the grant administrator will verify the information on the reports. Reports will be signed and dated by both parties. Anticipated Completion Date: July 2024

View Audit 293921

Corrective Action Plans

Filters