North Miami Community Schools

EIN: 356006582

UEI: JAZNZL9A9MM5

2
Audit Years
4
Total Findings
0
Repeat Findings

FY 2024-06-30

2024-002
Activities Allowed or Unallowed / Cost Allowability
QUESTIONED COSTS
Condition

Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.430 states in part: Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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 activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: $1,375 (Known questioned costs) Context: For 4 selections, in a sample of 40 payroll transactions, the School Corporation did not have time and effort logs to support the portion of the employees’ time charged to the grant. The employees’ time was split with a non-federal fund; however, the School Corporation did not have support for the allocation of the time charged to the ESSER III fund. The sample amount charged to the grant for split-funded employees without time and effort logs was $1,375. Identification as a repeat finding: No. Recommendation: We recommend management ensure time and effort logs are maintained for all employees not charged at 100% to support work performed and charged to the grant awards. We recommend management establish a documented review by management of time and effort logs to ensure time charged to grant awards is allowable and allocable based on work performed in accordance with grant requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.

Corrective Action Plan

Context: For 4 selections, in a sample of 40 payroll transactions, the School Corporation did not have time and effort logs to support the portion of the employees’ time charged to the grant. The employees’ time was split with a non-federal fund; however, the School Corporation did not have support for the allocation of the time charged to the ESSER III fund. The sample amount charged to the grant for split-funded employees without time and effort logs was $1,375. Contact Person Responsible for Corrective Action: Serena Francis, Business Manager Contact Phone Number: 765-985-3891 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: We will implement time and effort logs for all split-funded employees. Currently we do not have any split funded employees. Anticipated Completion Date: 3/1/2025

2024-003
Special Tests & Provisions
MATERIAL WEAKNESS
Condition

Information on the federal program: Subject: Education Stabilization Fund – Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Material Noncompliance, Qualified Opinion Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) 29 CFR 5.5 states in part: (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics… (3)(ii)(A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). 2 CFR 200 Appendix II states in part: In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non-Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, “Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction”). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week.. . .” 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 Special Tests and Provisions – Wage Rate Requirements compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to design and implement an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Special Tests and Provisions – Wage Rate Requirements compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: For the two projects sampled for Davis-Bacon requirements, the School Corporation did not obtain the weekly payroll reports certifications from the company that performed renovations on the School Corporation. Therefore, no review was performed to ensure that pay rates complied with the federal wage rate requirements. Additionally, the School Corporation did not have contracts with the company that included the clause for the federal wage rate requirements. The amount disbursed and reported on the SEFA during the audit period is $447,034 and the labor portion was not determinable by the School Corporation. Identification as a repeat finding: No. Recommendation: We recommend the School Corporation implement a formal process to ensure the required weekly payroll reports certifications are collected and reviewed to ensure compliance with the wage rate requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.

Corrective Action Plan

Context: For the two projects sampled for Davis-Bacon requirements, the School Corporation did not obtain the weekly payroll reports certifications from the company that performed renovations on the School Corporation. Therefore, no review was performed to ensure that pay rates complied with the federal wage rate requirements. Additionally, the School Corporation did not have contracts with the company that included the clause for the federal wage rate requirements. The amount disbursed and reported on the SEFA during the audit period is $447,034 and the labor portion was not determinable by the School Corporation. Contact Person Responsible for Corrective Action: Serena Francis, Business Manager Contact Phone Number: 765-985-3891 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: If NMCS enters into contractual agreements where Davis-Bacon rules will apply we make arrangements before the contract is signed to meet all of the necessary requirements. Anticipated Completion Date: 3/1/2025

2024-004
Equipment & Real Property
MATERIAL WEAKNESS
Condition

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.425U Federal Award Numbers: S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness Criteria: 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. (4) Adequate maintenance procedures must be developed to keep the property in good condition. . . ." 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 Equipment and Real Property Management Requirements compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: For the 2 sample items tested, the School Corporation expended $396,100 on building renovations which was charged to the ESSER III (84.425U) grant award. It was noted these capital asset acquisitions were not reported on the capital asset listing for the School Corporation as of June 30, 2024. Additionally, we noted the School Corporation’s capital asset listing did not contain all the required information, including the source of funding for the property, outlined in the criteria above. Identification as a repeat finding: No. Recommendation: We recommend the School Corporation update the capital asset listing at least annually to include all equipment and real property acquisitions and review for potential capital asset dispositions. Additionally, we recommend the School Corporation update the capital asset listing to include all the required information, including the source of funding for the property, outlined in the criteria above. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.

Corrective Action Plan

Context: For the 2 sample items tested, the School Corporation expended $396,100 on building renovations which was charged to the ESSER III (84.425U) grant award. It was noted these capital asset acquisitions were not reported on the capital asset listing for the School Corporation as of June 30, 2024. Additionally, we noted the School Corporation’s capital asset listing did not contain all the required information, including the source of funding for the property, outlined in the criteria above. Contact Person Responsible for Corrective Action: Serena Francis, Business Manager Contact Phone Number: 765-985-3891 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: NMCS is in the process of updating our capital asset plan. As we move forward we will report all capital improvements and large purchases to this schedule as they occur. Anticipated Completion Date: 11/1/2025

FY 2022-06-30

2022-002
Procurement & Suspension/Debarment
MATERIAL WEAKNESS
Condition

FINDING 2022-002 Information on the federal program: Subject: Child Nutrition Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Modified Opinion, Noncompliance Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." 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 Procurement compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: There were two small purchase method procurements selected for sample testing for the audit period. One procurement was performed by the School?s Service Center, Wilson Education Center (Service Center). During the 2020-2021 school year, the Service Center solicited, evaluated, and awarded a bid for the milk on behalf of its members that School Corporation used. The Service Center was not audited for the 2020-2021 school year. During our testing of procurement and suspension and debarment for 2020-2021, it was noted that the School Corporation was not have a review control in place to monitor that the Service Center performed all necessary procedures to maintain compliance with federal regulations surrounding procurement and suspension and debarment. For 2020-2021, the School Corporation obtained procurement documents from the Service Center supporting procurements performed during the audit period. There was no documented review control in place at the School Corporation to ensure proper monitoring of the Service Center activities occur to verify federal procurement regulations were followed by the Service Center. There was one vendor that exceeded the $10,000 threshold for the School Corporation during fiscal year 2020-2021 that would require a procurement check. The error in the sample procurement performed by the Service Center selected for testing was isolated to fiscal year 2020-2021. The amount paid to the vendor for 2020-2021 was $22,211. The vendor did not met the suspension and debarment threshold ($25,000) for fiscal year 2020-2021. Proper controls over the same vendor selected for procurement and debarment and suspension were in place for the fiscal year 2021-2022 The second procurement selected for testing was a small purchase performed by the School Corporation for food purchases totaling $103,671 in fiscal year 2020-2021 and $142,368 in fiscal year 2021-2022. We noted that the School Corporation did not obtain three quotes from separate vendors. Additionally, the School Corporation did not perform a suspension and debarment check on the vendor sampled for fiscal years 2020-2021 and 2021-2022. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish controls to ensure compliance with Procurement and Suspension and Debarment compliance requirement. We recommend that management meet periodically with the Wilson Education Center and review and maintain procurement contract files as evidence of proper periodic monitoring of the Service Center. Additionally, we recommended that the School Corporation's management establish a system of internal controls related to ensure that 3 quotes are obtained as required for small purchase method procurements and to ensure the vendors are not debarred or suspended for small purchases procurements performed by the School Corporation. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.

Corrective Action Plan

Finding 2022-002 ? Child Nutrition Cluster ? Procurement and Suspension and Debarment Contact Person Responsible for Corrective Action: Serena Francis, Business Manager Contact Phone Number: (765) 226-0603 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: We have joined the Food 2 School consortium beginning with 2022-2023 school year. Both our Food Service Director and our Business Manager receive all emails and communication. This will allow internal control and oversight to ensure that the consortium is compliment with all state and federal procedures. We also have moved all of our small purchases into this purchasing consortium system. Anticipated Completion Date: August 1, 2023

Data source: This information comes from the Federal Audit Clearinghouse, the official repository of Single Audit data. All data is public domain. Verify this organization's audit history at fac.gov.

Are you this organization?

Track your findings and corrective action plans across audit cycles.

Start tracking findings →

Do you fund this organization?

Monitor subrecipient audit findings and compliance status.

Start monitoring →

Single Audit Intelligence is an independent tool powered by Federal Audit Clearinghouse data. Not affiliated with GSA, OMB, or any federal agency.