Audit 10647

FY End
2023-06-30
Total Expended
$23.19M
Findings
2
Programs
26
Year: 2023 Accepted: 2024-01-10

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
8094 2023-002 Material Weakness - N
584536 2023-002 Material Weakness - N

Programs

ALN Program Spent Major Findings
84.425U Covid-19 - Education Stabilization Fund, Arp Esser $5.82M Yes 0
84.010 Title I Grants to Local Educational Agencies $4.57M Yes 1
10.555 National School Lunch Program $4.03M - 0
84.027 Special Education_grants to States $2.62M - 0
10.553 School Breakfast Program $1.14M - 0
32.009 Covid-19: Emergency Connectivity Fund Program $1.05M Yes 0
84.060A Title Vi Indian Ed Formula Grant $796,347 - 0
84.425D Covid-19 - Education Stabilization Fund, Esser II $501,959 Yes 0
10.555 Supply Chain Assistance $337,840 - 0
84.367 Improving Teacher Quality State Grants $333,798 - 0
15.130 Indian Education_assistance to Schools $322,732 - 0
84.287C Twenty-First Century Commuity Learning Centers $313,272 - 0
84.424 Student Support and Academic Enrichment Program $214,127 - 0
10.582 Fresh Fruit and Vegetable Program $184,179 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $163,787 - 0
84.048 Career and Technical Education -- Basic Grants to States $138,605 - 0
84.027x Covid-19: Special Education Grants to States $137,236 - 0
84.425U Covid-19 - Education Stabilization Fund, Arp Esser III $122,796 Yes 0
84.041 Impact Aid - General Fund $99,885 - 0
84.365 English Language Acquisition State Grants $82,787 - 0
84.173 Special Education_preschool Grants $65,028 - 0
84.041 Impact Aid - Indian Education $52,386 - 0
84.425W Covid-19 - Education Stabilization Fund, Arp Homeless Children and Youth II $34,099 Yes 0
84.425W Covid-19 - Education Stabilization Fund, Esser III Homeless Children and Youth $32,218 Yes 0
84.196 Education for Homeless Children and Youth $15,000 - 0
84.041 Impact Aid -Special Education $3,626 - 0

Contacts

Name Title Type
F9K3UXV5ARB1 Bobbi Newland Auditee
5053249840 Alan D. Bowers, Jr. Auditor
No contacts on file

Notes to SEFA

Title: Loans Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal grant activity of the Farmington Municipal School District No. 5 and is presented on the modified accrual basis of accounting, which is the same basis as was used to prepare the fund financial statements. The information in this Schedule is presented in accordance with the requirements of Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of the financial statements. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the allowed 10% indirect cost rate. The District did not expend federal awards related to loans or loan guarantees during the year.
Title: Federally Funded Insurance Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal grant activity of the Farmington Municipal School District No. 5 and is presented on the modified accrual basis of accounting, which is the same basis as was used to prepare the fund financial statements. The information in this Schedule is presented in accordance with the requirements of Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of the financial statements. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the allowed 10% indirect cost rate. See table on page 285

Finding Details

2023-002 – Special Test and Provision – Annual Report Card, High School Graduation Rate – Material Weakness in Internal Control over Compliance/Material Noncompliance ALN and Title: 84.010 Title I Grants to Local Educational Agencies Pass-Through Entity: NM Public Education Department Identifying Number: 24101 Award Year: 2022-23 School Year Condition: The District was not obtaining proper written documentation to substantiate the correct student withdrawal codes for 33 of 40 students tested. The withdrawal form did not have the signature of the school official and contained a different withdrawal code on the withdrawal form than the sample listed in 6 of 40 students tested. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award 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). Per the May 2023 Compliance Supplement, to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort (ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))). Per Farmington Municipal School District Board Policy, Section J Students, J-1300 Student Withdrawal from School, a withdrawal form shall be presented to the parent or legal guardian of a student who may or must withdraw from school. The withdrawal form shall include space for the reason for withdrawal and the signature of an official of the school from which the student has withdrawn. Questioned Costs: None noted. Effect: District’s reported High School Graduation Rate for the 2022-2023 school year cannot be verified due to lack of written documentation for students removed from cohort. Cause: A deficiency in the internal control system to properly train and monitor the personnel who are assigned to maintain the accuracy of student records and ensure the District obtain all the necessary written documentation for student’s files.
2023-002 – Special Test and Provision – Annual Report Card, High School Graduation Rate – Material Weakness in Internal Control over Compliance/Material Noncompliance ALN and Title: 84.010 Title I Grants to Local Educational Agencies Pass-Through Entity: NM Public Education Department Identifying Number: 24101 Award Year: 2022-23 School Year Condition: The District was not obtaining proper written documentation to substantiate the correct student withdrawal codes for 33 of 40 students tested. The withdrawal form did not have the signature of the school official and contained a different withdrawal code on the withdrawal form than the sample listed in 6 of 40 students tested. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award 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). Per the May 2023 Compliance Supplement, to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort (ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))). Per Farmington Municipal School District Board Policy, Section J Students, J-1300 Student Withdrawal from School, a withdrawal form shall be presented to the parent or legal guardian of a student who may or must withdraw from school. The withdrawal form shall include space for the reason for withdrawal and the signature of an official of the school from which the student has withdrawn. Questioned Costs: None noted. Effect: District’s reported High School Graduation Rate for the 2022-2023 school year cannot be verified due to lack of written documentation for students removed from cohort. Cause: A deficiency in the internal control system to properly train and monitor the personnel who are assigned to maintain the accuracy of student records and ensure the District obtain all the necessary written documentation for student’s files.