Corrective Action Plans

Finding 384773 (2023-003)

Significant Deficiency 2023

IL

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring § 200.403

Action taken in response to finding: • All costs charged to grants will be reviewed and verified. • Indirect costs will be checked and verified for all grants

View Audit 297887 Questioned Costs: $1

Finding 384764 (2023-001)

None 2023

Stryker Housing Development Fund Co., Inc.

NY

Subrecipient Monitoring Reporting § 200.512

Finding #2023-001 Prior Year Reporting Package and Data Collection Not Filed Timely: Recommendation: We recommend that management implement procedures to ensure that reporting packages and data collection forms are filed timely in the future. Action taken: Stryker Homes Apartments agrees with the...

Finding #2023-001 Prior Year Reporting Package and Data Collection Not Filed Timely: Recommendation: We recommend that management implement procedures to ensure that reporting packages and data collection forms are filed timely in the future. Action taken: Stryker Homes Apartments agrees with the auditor’s recommendations and will implement procedures to ensure timely filing in the future. For questions regarding this corrective action plan, please contact Kyle Lyskawa, Chief Financial Officer, at (315) 424-1821.

View Audit 297877

Finding 384753 (2023-013)

Material Weakness 2023

State of Kansas

KS

Subrecipient Monitoring § 200.303

Condition: Management did not track, determine or monitor the audit verification requirement for any subrecipients. Recommendation: We recommend that the agency review its procedures for monitoring of annual audits for subrecipients. Views of responsible officials: There is no disagreement with th...

Condition: Management did not track, determine or monitor the audit verification requirement for any subrecipients. Recommendation: We recommend that the agency review its procedures for monitoring of annual audits for subrecipients. Views of responsible officials: There is no disagreement with the audit finding. Action taken in response to finding: Effective immediately, audit letters will be sent to all subrecipients without regard to monetary thresholds. Name(s) of the contact person(s) responsible for corrective action: Jennifer Deal Planned completion date for corrective action plan: July 1, 2024

View Audit 297874

Finding 384752 (2023-012)

Material Weakness 2023

State of Kansas

KS

Subrecipient Monitoring § 200.303 § 200.331

Condition: Subaward agreements with subrecipients, including Assistance Listing Number (ALN) and title, subrecipient’s DUNS/UEI number, Federal Award Identification Number (FAIN), identification of whether the award is research and development, and indirect cost rate for federal award, were not incl...

Condition: Subaward agreements with subrecipients, including Assistance Listing Number (ALN) and title, subrecipient’s DUNS/UEI number, Federal Award Identification Number (FAIN), identification of whether the award is research and development, and indirect cost rate for federal award, were not included. Recommendation: We recommend that the agency review its procedures for communicating information to subrecipients and implement the procedures necessary to ensure information is included in the subrecipient award documents at time of funding. Views of responsible officials: There is no disagreement with the audit finding. Action taken in response to finding: KDEM is implementing a comprehensive compliance program. The program will oversee that appropriate communication is made to subrecipients as required to be in compliance with 2 CFR 200.331(a). Name(s) of the contact person(s) responsible for corrective action: Jennifer Deal Planned completion date for corrective action plan: July 1, 2024

View Audit 297874

Finding 384751 (2023-011)

Material Weakness 2023

State of Kansas

KS

Subrecipient Monitoring Reporting § 200.303

Condition: During testing, we noted that FFATA reports were not submitted timely, FFATA reports were not submitted at all, and there was not a documented review of the submitted reports Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Element...

Condition: During testing, we noted that FFATA reports were not submitted timely, FFATA reports were not submitted at all, and there was not a documented review of the submitted reports Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 33 14 33 14 not reported 14 not reported Dollar Amount of Tested Transactions Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements $2,775,992 $961,031 $2,775,992 $961,031 Not Reported $961,031 Not Reported Recommendation: We recommend that the agency implement controls to ensure subrecipients provide a UEI number before the subaward is entered into and implement procedures to ensure reports are submitted timely and formally reviewed. Views of responsible officials: There is no disagreement with the audit finding. Action taken in response to finding: KDEM is implementing a comprehensive compliance program. The program will oversee that the completed application is received which includes the UEI. The compliance officer will then ensure that all FFATA reporting is completed and documented timely. Name(s) of the contact person(s) responsible for corrective action: Jennifer Deal Planned completion date for corrective action plan: July 1, 2024

View Audit 297874

Finding 384749 (2023-010)

Significant Deficiency 2023

State of Kansas

KS

Reporting Subrecipient Monitoring Matching / Level of Effort / Earmarking § 200.303

Condition: During testing, we noted that FFATA reports were not submitted timely and there was not a documented review of the submitted reports. Also, we noted that the State also has submitted FFATA Reports to FSRS for vendors when this reporting is not required for vendors. Transactions Tested Su...

Condition: During testing, we noted that FFATA reports were not submitted timely and there was not a documented review of the submitted reports. Also, we noted that the State also has submitted FFATA Reports to FSRS for vendors when this reporting is not required for vendors. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 6 0 6 0 0 Dollar Amount of Tested Transactions Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements $2,291,464 $0 $2,291,464 0 0 Recommendation: We recommend that the agency implement controls to ensure reports are reviewed before submission, that a process is updated to ensure that reports are submitted timely, and that a process is implemented to ensure only subawards are reported to FSRS. Views of responsible officials: There is no disagreement with the audit finding. Action taken in response to finding: The agency has put a review/approval workflow process in place for reports. The report will be entered into FSRS.gov and sent to a reviewer. Once the report has been reviewed and approved, an email will be sent to Fiscal Analyst as proof the reports have been reviewed/approved. The email will be retained for audit reviews. Name(s) of the contact person(s) responsible for corrective action: Joy Duncan Planned completion date for corrective action plan: The review process will begin immediately in March 2024.

View Audit 297874

Finding 384747 (2023-009)

Significant Deficiency 2023

State of Kansas

KS

Reporting Subrecipient Monitoring Matching / Level of Effort / Earmarking § 200.303

Condition: During testing it was discovered that management did not document the review of the submitted reports. Also, we noted that the State also has submitted FFATA Reports to FSRS for vendors when this reporting is not required for vendors. Transactions Tested Subaward Not Reported Report Not T...

Condition: During testing it was discovered that management did not document the review of the submitted reports. Also, we noted that the State also has submitted FFATA Reports to FSRS for vendors when this reporting is not required for vendors. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 1 0 0 0 0 Dollar Amount of Tested Transactions Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements $41,680 0 0 0 0 Recommendation: We recommend that the agency implement controls to ensure reports are reviewed before submission and that a process is implemented to ensure only subawards are reported to FSRS. Views of responsible officials: There is no disagreement with the audit finding. Action taken in response to finding: The agency has put a review/approval workflow process in place for reports. The report will be entered into FSRS.gov and sent to a reviewer. Once the report has been reviewed and approved, an email will be sent to Fiscal Analyst as proof the reports have been reviewed/approved. The email will be retained for audit reviews. Name(s) of the contact person(s) responsible for corrective action: Joy Duncan Planned completion date for corrective action plan: The review process will begin immediately in March 2024.

View Audit 297874

Finding 384745 (2023-008)

Significant Deficiency 2023

State of Kansas

KS

Procurement, Suspension & Debarment Subrecipient Monitoring § 200.303

Condition: During our testing of twenty-seven covered transactions (twelve vendors and fifteen subrecipients), we noted that management was not able to provide supporting documentation for one vendor that suspension and debarment procedures were performed before the start of the procurement contract...

Condition: During our testing of twenty-seven covered transactions (twelve vendors and fifteen subrecipients), we noted that management was not able to provide supporting documentation for one vendor that suspension and debarment procedures were performed before the start of the procurement contract. Recommendation: We recommend the agency either obtain certifications from vendors stating their organization is not suspended, debarred, or otherwise excluded from participation in federal assistance programs or document the procedures performed to verify the vendor is not identified as suspended or debarred on the SAM website. We recommend that the agency have proper procedures in place to ensure that all contractual documentation is maintained and able to be located. Views of responsible officials: Management disagrees with the audit finding. Verification is completed at the time the contract is signed by KDHE so the date of signature corresponds with the date of SAM verification. Action taken in response to finding: KDHE has implemented a new contract system which will include steps for verifying suspension and debarment status for all contracts and sub-recipient agreements which KDHE is a party to. Name(s) of the contact person(s) responsible for corrective action: Kelly Chilson Planned completion date for corrective action plan: October 2023

View Audit 297874

Finding 384743 (2023-007)

Material Weakness 2023

State of Kansas

KS

Subrecipient Monitoring § 200.303 § 200.331

Condition: During our testing, we noted subrecipients had required information omitted from the sub agreements to the subrecipients including Assistance Listing Number (ALN) and title, subrecipient’s DUNS/UEI number, Federal Award Identification Number (FAIN), identification of whether the award is ...

Condition: During our testing, we noted subrecipients had required information omitted from the sub agreements to the subrecipients including Assistance Listing Number (ALN) and title, subrecipient’s DUNS/UEI number, Federal Award Identification Number (FAIN), identification of whether the award is R&D, and indirect cost rate for federal award. Recommendation: We recommend that the agency review its procedures for communicating information to subrecipients and implement the procedures necessary to ensure information is included in the subrecipient award documents at time of funding. Views of responsible officials: There is no disagreement with the audit finding. Action taken in response to finding: A cover sheet with the required information to be provided to the subrecipients has been created. Name(s) of the contact person(s) responsible for corrective action: Program personnel Planned completion date for corrective action plan: Implementation will begin immediately in March 2024.

View Audit 297874

Finding 384740 (2023-005)

Significant Deficiency 2023

State of Kansas

KS

Reporting Subrecipient Monitoring Matching / Level of Effort / Earmarking § 200.303

Condition: During testing of the Federal Funding Accountability and Transparency Act (FFATA) reports, it was noted that the reports were not filed timely or not filed at all for the fiscal year. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Ke...

Condition: During testing of the Federal Funding Accountability and Transparency Act (FFATA) reports, it was noted that the reports were not filed timely or not filed at all for the fiscal year. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 8 1 8 0 0 Dollar Amount of Tested Transactions Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements $ 6,046,626 $ 166,455 $ 6,046,626 $ 0 $ 0 Recommendation: We recommend that KDCF continue with the process implemented during the fiscal year, that includes tracking the timely submission of the FFATA reports. Views of responsible officials: There is no disagreement with the audit finding. Action taken in response to finding: KDCF hired a dedicated person in May 2023 to complete the FFATA reporting process. This employee received access to the FSRS website in July 2023 and began entering the FFATA information for new awards. The information captured on the FFATA Checklist and FFATA-5 forms will be used to enter subrecipient information into the FSRS website. Previously, these forms were not always accurate in listing the correct FAIN and amount for each federal award. KDCF has revised this form to include a separate listing for each federal amount awarded and the information will be verified during the concurrence approval process for accuracy. Once concurrence has been completed and any corrections identified, the FFATA reporting details will be added to the FFATA tracking worksheet. KDCF has created a separate tracking worksheet for each state fiscal year which includes separate tabs for each DCF program. This information will be entered into the FSRS website in the reporting month of the award date under each FAIN identified within the required due date. The FFATA information entered will be reviewed on the USA Spending public site for accuracy and corrected as needed. KDCF staff will continue working on updating prior year FFATA information throughout the year identified in previous audits. Name(s) of the contact person(s) responsible for corrective action: Brian Carlgren, Deputy Director of Fiscal Services Addie O’Connell, Grant and Contract Specialist Planned completion date for corrective action plan: July 2024

View Audit 297874

Finding 384738 (2023-004)

Significant Deficiency 2023

State of Kansas

KS

Reporting Subrecipient Monitoring Matching / Level of Effort / Earmarking § 200.303

Condition: During testing of the Federal Funding Accountability and Transparency Act (FFATA) report, it was noted that the one report tested was not filed timely. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 1 0 1 0 0 Dollar Amou...

Condition: During testing of the Federal Funding Accountability and Transparency Act (FFATA) report, it was noted that the one report tested was not filed timely. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 1 0 1 0 0 Dollar Amount of Tested Transactions Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements $ 5,850,379 $ 0 $ 5,850,379 $ 0 $ 0 Recommendation: We recommend that KDCF continue with the process implemented during the fiscal year, which includes tracking the timely submission of the FFATA reports. Views of responsible officials: There is no disagreement with the audit finding. Action taken in response to finding: KDCF hired a dedicated person in May 2023 to complete the FFATA reporting process. This employee received access to the FSRS website in July 2023 and began entering the FFATA information for new awards. The information captured on the FFATA Checklist and FFATA-5 forms will be used to enter subrecipient information into the FSRS website. Previously, these forms were not always accurate in listing the correct FAIN and amount for each federal award. KDCF has revised this form to include a separate listing for each federal amount awarded and the information will be verified during the concurrence approval process for accuracy. Once concurrence has been completed and any corrections identified, the FFATA reporting details will be added to the FFATA tracking worksheet. KDCF has created a separate tracking worksheet for each state fiscal year which includes separate tabs for each DCF program. This information will be entered into the FSRS website in the reporting month of the award date under each FAIN identified within the required due date. The FFATA information entered will be reviewed on the USA Spending public site for accuracy and corrected as needed. KDCF staff will continue working on updating prior year FFATA information throughout the year identified in previous audits. Name(s) of the contact person(s) responsible for corrective action: Brian Carlgren, Deputy Director of Fiscal Services Addie O’Connell, Grant and Contract Specialist Planned completion date for corrective action plan: July 2024

View Audit 297874

Finding 384729 (2023-004)

Significant Deficiency 2023

Puerto Rico Public Housing Administration

PR

Subrecipient Monitoring Internal Control / Segregation of Duties

PRPHA has a provider with vast experience in this program and is currently serving other government authorities in the mainland that are entitled with this program. We have assured that they are following the regulations that are set forth by the Treasury Department. However, because of the shor...

PRPHA has a provider with vast experience in this program and is currently serving other government authorities in the mainland that are entitled with this program. We have assured that they are following the regulations that are set forth by the Treasury Department. However, because of the short period of time that we have had this program in Puerto Rico we have had to adapt the practices that have been adopted in the other agencies as the formal procedures as a start up implementation. We are establishing more procedures as the program evolves in the island. This is an on going action plan.

View Audit 297868

Finding 384725 (2023-002)

Material Weakness 2023

Southern Ohio Medical Center and Subsidiaries

OH

Reporting Subrecipient Monitoring Material Weakness

Finding Number: 2023-002 Condition: SOMC Medical Care Foundation, Inc. (MCF) received $1.28M of ARP funding during period 4. As the recipient entity, MCF used the ARP funding in accordance with the terms and conditions, however the reporting on the use of MCF's ARP distributions was not properly c...

Finding Number: 2023-002 Condition: SOMC Medical Care Foundation, Inc. (MCF) received $1.28M of ARP funding during period 4. As the recipient entity, MCF used the ARP funding in accordance with the terms and conditions, however the reporting on the use of MCF's ARP distributions was not properly completed. The parent company, Southern Ohio Medical Center, completed a consolidated period 4 report, which is appropriate based on the reporting requirements, however the expenses that were reported for the use of the $1.28M received by MCF were expenses of the parent company, not expenses of MCF. Planned Corrective Action: The Management of Southern Ohio Medical Center (SOMC) and its subsidiaries are committed to complying with all terms, conditions, and reporting requirements related to funds received. Management will carefully read and follow all notices relating to reporting requirements and terms and conditions for each type of future funds awarded, paying particular attention to requirements as they pertain to Parent and Subsidiary reporting. In addition, SOMC will ensure that any and all updated guidance provided after the receipt of funds are reviewed and included in the application of used funds. Although SOMC incorrectly reported the use funds received for the subsidiary MCF on the consolidated period 4 report, it is important to note that the ARP funds were used and applied to more than $1.3m of lost revenue during the expense and lost revenue period. SOMC Management cannot amend the period 4 report to reflect this, but Management has updated the detailed internal records identifying the use of funds by applying $1.28m of MCF lost revenue to use of funds for the appropriate periods. Contact person responsible for corrective action: Kara Plummer, CFO Anticipated Completion Date: 3/31/2024

View Audit 297865

Finding 384675 (2023-003)

Significant Deficiency 2023

La Habra City School District

CA

Reporting Subrecipient Monitoring

The District will verify reporting dates and ranges prior to completion reports.

View Audit 297777

Finding 384658 (2023-001)

Significant Deficiency 2023

Waukesha County Area Technical College District

WI

Subrecipient Monitoring Significant Deficiency Internal Control / Segregation of Duties

Federal Program Name: Student Financial Aid Cluster Assistance Listing Number: 84.007, 84.033, 84.063, 84.268 Recommendation: We recommend the District review and update as necessary the written information security program(s) to include aspects required by regulations. Explanation of disagreement w...

Federal Program Name: Student Financial Aid Cluster Assistance Listing Number: 84.007, 84.033, 84.063, 84.268 Recommendation: We recommend the District review and update as necessary the written information security program(s) to include aspects required by regulations. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Management agrees with the finding and has taken action to update internal policy documentation to appropriately address the required safeguards. Name(s) of the contact person(s) responsible for corrective action: Shannon Ford, Executive Director Information Technology Systems Planned completion date for corrective action plan: June 30, 2024

View Audit 297755

Finding 384656 (2023-002)

Significant Deficiency 2023

City of St. Louis Municipal Library District

MO

Equipment & Real Property Management Special Tests & Provisions Subrecipient Monitoring

Finding No. 2023-002 Significant Deficiency Personnel Responsible for Corrective Action: Jim Slattery, Chief Financial Officer Anticipated Completion Date: March 31, 2024 Corrective Action Plan: Management for the St. Louis Public library will review all processes associated with checking out equipm...

Finding No. 2023-002 Significant Deficiency Personnel Responsible for Corrective Action: Jim Slattery, Chief Financial Officer Anticipated Completion Date: March 31, 2024 Corrective Action Plan: Management for the St. Louis Public library will review all processes associated with checking out equipment and make necessary revisions to processes and procedures to ensure all staff are properly trained to successfully execute all transactions

View Audit 297725

Finding 384655 (2023-001)

Significant Deficiency 2023

City of St. Louis Municipal Library District

MO

Equipment & Real Property Management Special Tests & Provisions Subrecipient Monitoring

Finding No. 2023-001 Significant Deficiency Personnel Responsible for Corrective Action: Jim Slattery, Chief Financial Officer Anticipated Completion Date: March 31, 2024 Corrective Action Plan: Management for the St. Louis Public library will review all processes associated with checking out equipm...

Finding No. 2023-001 Significant Deficiency Personnel Responsible for Corrective Action: Jim Slattery, Chief Financial Officer Anticipated Completion Date: March 31, 2024 Corrective Action Plan: Management for the St. Louis Public library will review all processes associated with checking out equipment and make necessary revisions to processes and procedures to ensure all staff are properly trained to successfully execute all transactions

View Audit 297725

Finding 384654 (2023-001)

Material Weakness 2023

Cordell Independent School District #78

OK

Procurement, Suspension & Debarment Subrecipient Monitoring Material Weakness

To address the specific points highlighted in your recommendation we will: 1. Insert Prevailing Wage Clauses - We will work closely with our legal and procurement teams to incorporate prevailing wage clauses consistently in all relevant contracts. This will be a standard practice for any construct...

To address the specific points highlighted in your recommendation we will: 1. Insert Prevailing Wage Clauses - We will work closely with our legal and procurement teams to incorporate prevailing wage clauses consistently in all relevant contracts. This will be a standard practice for any construction project that involves federal awards. 2. Effective Monitoring Process - We acknowledge the importance of a rigorous monitoring process. To this end, we will develop and implement a comprehensive system to monitor compliance with contractual obligations, including regular checks to ensure that federal wage rates and fringes are met. This monitoring process will involve thorough reviews of weekly certified payroll reports submitted by contractors and subcontractors. 3. Work Site Compliance - Recognizing the significance of visible compliance, we will mandate the posting of all relevant items, such as wage rates and project details, at prominent locations on the work site. This measure aims to enhance transparency and serves as a tangible demonstration of our commitment to Davis-Bacon Act compliance. We understand the critical nature of adhering to federal regulations and appreciate your guidance in strengthening our internal controls. We will initiate these changes promptly, ensuring that they are integrated into our standard operating procedures for all future construction projects involving federal awards. Additionally, we welcome any further guidance or collaboration in this regard and are open to periodic reviews to ensure ongoing compliance. Our commitment to upholding the principles of the Davis-Bacon Act aligns with our dedication to transparent and ethical practices. Thank you once again for your valuable recommendations, and we look forward to implementing these measures in collaboration with your guidance.

View Audit 297724

Finding 384619 (2023-005)

Material Weakness 2023

Lennox School District

CA

Subrecipient Monitoring Material Weakness Reporting

Due to staff turnover and key vacant positions, we were unable to locate supporting documentation. For all federal expenditure reports, the supporting documentation will now be kept on file for a minimum of three years.

View Audit 297696

Finding 384608 (2023-002)

Material Weakness 2023

Olustee-Eldorado Independent School District No. 40

OK

Subrecipient Monitoring Material Weakness Matching / Level of Effort / Earmarking

The Olustee-Eldorado Public School, being made aware of the requirements of the Davis-Bacon Act, will make sure the following steps are completed in a timely manner for any actions which might be deemed construction in the future that are funded with federal wages: 1. Documentation that prevailing ...

The Olustee-Eldorado Public School, being made aware of the requirements of the Davis-Bacon Act, will make sure the following steps are completed in a timely manner for any actions which might be deemed construction in the future that are funded with federal wages: 1. Documentation that prevailing wage and fringes are being paid as it relates to the prevailing wages for our area. 2. Detailed record keeping of required documents from contractors and subcontractors. 3. Apprenticeship program documents maintained when appropriate. 4. Certified weekly payroll reports reviewed and submitted in a timely manner. 5. Necessary and complete signage at the worksite related to Davis-Bacon and the applicable wage determination.

View Audit 297687

Finding 384607 (2023-001)

Material Weakness 2023

Olustee-Eldorado Independent School District No. 40

OK

Subrecipient Monitoring Material Weakness Matching / Level of Effort / Earmarking

The Olustee-Eldorado Public School, being made aware of the requirements of the Davis-Bacon Act, will make sure the following steps are completed in a timely manner for any actions which might be deemed construction in the future that are funded with federal wages: 1. Documentation that prevailing ...

The Olustee-Eldorado Public School, being made aware of the requirements of the Davis-Bacon Act, will make sure the following steps are completed in a timely manner for any actions which might be deemed construction in the future that are funded with federal wages: 1. Documentation that prevailing wage and fringes are being paid as it relates to the prevailing wages for our area. 2. Detailed record keeping of required documents from contractors and subcontractors. 3. Apprenticeship program documents maintained when appropriate. 4. Certified weekly payroll reports reviewed and submitted in a timely manner. 5. Necessary and complete signage at the worksite related to Davis-Bacon and the applicable wage determination.

View Audit 297687

Finding 384585 (2023-001)

Significant Deficiency 2023

Platte County School District #2

WY

Subrecipient Monitoring Internal Control / Segregation of Duties

Corrective Action Plan for Finding 2023-001 - Davis Bacon Wage Compliance The District will incorporate into their bid information and when requesting quotes for service of work over $2,000 that are federally funded to include information about the David Bacon prevailing wage requirements. Direct fo...

Corrective Action Plan for Finding 2023-001 - Davis Bacon Wage Compliance The District will incorporate into their bid information and when requesting quotes for service of work over $2,000 that are federally funded to include information about the David Bacon prevailing wage requirements. Direct follow up will take place before the work is started that the regulation/requirement is understood. Once the work has started the Buisness Office will follow up with the company weekly to make sure the federal wage form is being completed and return a copy to the Business Office. The Business Office is also working on past vendors to obtain this information for work completed with ESSER funds since inception of funds and hope to have completed before the end of this school year. Nikki Quynn - Business Manager

View Audit 297670

Finding 384571 (2023-008)

Material Weakness 2023

Wawasee Community School Corporation

IN

Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties Subrecipient Monitoring § 200.303

FINDING 2023-008 Finding Subject: Title I Grants to Local Educational Agencies – Matching, Level of Effort, Earmarking Summary of Finding: There was a material weakness, in that the School Corporation had not properly designed or implemented a system of internal controls, including appropriate seg...

FINDING 2023-008 Finding Subject: Title I Grants to Local Educational Agencies – Matching, Level of Effort, Earmarking Summary of Finding: There was a material weakness, in that the School Corporation had not properly designed or implemented a system of internal controls, including appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no oversight or review process in place to ensure monitoring of each required set aside within the Title I grant. The School Corporation did not provide documentation to show that set aside obligations were met or not met. The School Corporation did not have an oversight process in place to ensure that expenditures for vendors were posted to the correct fund, account and object codes and reported correctly on the Form 9 so that the IDOE could complete MOE calculations based on Form 9 data. Contact Person Responsible for Corrective Action: Rachel Moore Contact Phone Number and Email Address: 574-457-3188 x 1369, rmoore@wawasee.k12.in.us Views of Responsible Officials: Management concurs with the finding. Description of Corrective Action Plan: The Title I grant will be prepared and managed by the Grant Coordinator. The Treasurer will review and monitor the required set asides within the Title I grants to ensure obligations are met or transferred to the next grant award if not met. An internal sign-off form will be created and implemented to document the secondary review of the grant data. All vendor claims will be prepared by the Grant Coordinator or the Treasurer and reviewed for accuracy by a second person, with both signing the claims to document the review, to ensure that all expenditures are reported correctly on the Form 9 for accurate calculation of MOE data by the DOE. Anticipated Completion Date: The projected date of completion is April 2024.

View Audit 297652

Finding 384569 (2023-007)

Material Weakness 2023

Wawasee Community School Corporation

IN

Internal Control / Segregation of Duties Subrecipient Monitoring Eligibility § 200.303 § 200.334 § 200.77 § 200.78

FINDING 2023-007 Finding Subject: Title I Grants to Local Educational Agencies - Eligibility Summary of Finding: There was a material weakness, in that the School Corporation had not properly designed or implemented a system of internal controls, including appropriate segregation of duties, that wou...

FINDING 2023-007 Finding Subject: Title I Grants to Local Educational Agencies - Eligibility Summary of Finding: There was a material weakness, in that the School Corporation had not properly designed or implemented a system of internal controls, including appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. During the audit period, the School Corporation submitted two Title I Applications using the prior year’s Real Time Report data. The October 2021 Real Time Report used for the 2022-2023 Title I Application was not available for review to ensure compliance with the grant’s eligibility requirement. Contact Person Responsible for Corrective Action: Amanda Knipper Contact Phone Number and Email Address: 574-457-3188 x 1376, aknipper@wawasee.k12.in.us Views of Responsible Officials: Management concurs with the finding. Description of Corrective Action Plan: The Real Time Report data is pulled by Data Exchange directly from the School Corporation’s student management software system. The School Corporation will put a system in place to ensure that all student data within the student software system is accurate to ensure correct reporting of the Real Time data. The Grant Coordinator will review the Real Time report before submission with the information housed in the student management software and a second person will review the data for accuracy. An internal sign-off form will be created and implemented to document the secondary review of the report data. The Superintendent and the Treasurer will both sign off on the data digitally during the certification period as determined by IDOE. Anticipated Completion Date: The projected date of completion is August 2024.

View Audit 297652

Finding 384567 (2023-006)

Material Weakness 2023

Wawasee Community School Corporation

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.303

FINDING 2023-006 Finding Subject: Title I Grants to Local Educational Agencies – Internal Controls Summary of Finding: There was a material weakness, in that the School Corporation had not properly designed or implemented a system of internal controls, including appropriate segregation of duties, th...

FINDING 2023-006 Finding Subject: Title I Grants to Local Educational Agencies – Internal Controls Summary of Finding: There was a material weakness, in that the School Corporation had not properly designed or implemented a system of internal controls, including appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. Vendor claims were prepared by the Deputy Treasurer or Grant Coordinator and reviewed by the Corporation Treasurer to ensure compliance with allowable costs / cost principles compliance requirement. However, this review was not documented for 11 out of the 40 vendor claims tested. Contact Person Responsible for Corrective Action: Rachel Moore Contact Phone Number and Email Address: 574-457-3188 x 1369, rmoore@wawasee.k12.in.us Views of Responsible Officials: Management concurs with the finding. Description of Corrective Action Plan: The School Corporation will put a system in place to ensure that all vendor disbursement claims are reviewed by a secondary person and to ensure that the secondary reviewer signs off on all vendor disbursement claims. Anticipated Completion Date: The projected date of completion is April 2024.

View Audit 297652

Corrective Action Plans

Filters