Finding 386690 (2023-004)

Material Weakness
Requirement
E
Questioned Costs
-
Year
2023
Accepted
2024-03-28
Audit: 299007
Organization: City of Peabody (MA)

AI Summary

  • Core Issue: The City failed to provide timely documentation for determining school eligibility and allocations for Title I grants.
  • Impacted Requirements: Compliance with eligibility criteria and proper ranking of schools based on poverty measures was not met.
  • Recommended Follow-Up: Implement internal controls to ensure documentation is organized, retained, and readily available for audits.

Finding Text

U.S. DEPARTMENT OF EDUCATION Passed through Massachusetts Department of Elementary and Secondary Education Title I Grants to Local Educational Agencies Title I Grants to Local Educational Agencies Federal Assistance Listing No. 84.010 2023-004: Eligibility of Schools and Allocations to Schools Compliance Requirement: Eligibility Type of Finding: Compliance and Material Weakness in Internal Control Over Compliance Criteria or Specific Requirement: Grantees must determine which schools or school attendance areas are eligible to participate in the program. When determining eligibility, grantees must select a poverty measure from among one of the allowable data sources. Grantees must serve eligible schools or attendance areas in rank order according to their percentage of poverty. Grantees must also provide equitable services to eligible private school students and homeless students prior to allocating funds to eligible public schools using similar allowable data sources. Condition: The City was required to determine which schools or school attendance areas, including private school students and homeless students, were eligible to participate in the grant program. The City was also required to ensure that eligible schools or school attendance areas were served in rank order in accordance with their percentage of poverty. The supporting documentation was not available upon request and was not provided in a timely manner. The information required to perform this testing was requested in May 2023, and was not provided until January 2024, after several repeated requests were made throughout that time. Context: The City did not provide sufficient documentation to demonstrate the compliance of its eligibility determinations or allocations to schools in a timely manner. Effect: The City has not complied with the grant requirements. Cause: Management has not established guidelines and procedures to ensure that documentation regarding eligibility determinations and allocations is retained and filed in an organized manner that is made readily available for inspection during the audit. Questioned Costs: None reported. Recommendation: The City should implement internal control procedures to ensure compliance with all grant requirements including the completion and retention of all documentation regarding eligibility determinations and allocations to schools. The documentation should be filed in an organized manner and should be readily available for inspection during the audit. Views of Responsible Officials and Planned Corrective Actions: The School District will implement internal control procedures to ensure that the required documentation is completed, retained and maintained in an organized manner. Management plans to implement these procedures in 2024.

Categories

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

Other Findings in this Audit

  • 386679 2023-002
    Material Weakness Repeat
  • 386680 2023-002
    Material Weakness Repeat
  • 386681 2023-002
    Material Weakness Repeat
  • 386682 2023-002
    Material Weakness Repeat
  • 386683 2023-002
    Material Weakness Repeat
  • 386684 2023-002
    Material Weakness Repeat
  • 386685 2023-003
    Material Weakness Repeat
  • 386686 2023-003
    Material Weakness Repeat
  • 386687 2023-003
    Material Weakness Repeat
  • 386688 2023-003
    Material Weakness Repeat
  • 386689 2023-004
    Material Weakness
  • 386691 2023-004
    Material Weakness
  • 386692 2023-004
    Material Weakness
  • 386693 2023-005
    Material Weakness
  • 386694 2023-005
    Material Weakness
  • 386695 2023-005
    Material Weakness
  • 386696 2023-005
    Material Weakness
  • 386697 2023-006
    Material Weakness Repeat
  • 386698 2023-006
    Material Weakness Repeat
  • 386699 2023-006
    Material Weakness Repeat
  • 386700 2023-006
    Material Weakness Repeat
  • 386701 2023-006
    Material Weakness Repeat
  • 386702 2023-006
    Material Weakness Repeat
  • 386703 2023-006
    Material Weakness Repeat
  • 386704 2023-006
    Material Weakness Repeat
  • 386705 2023-007
    Material Weakness
  • 386706 2023-007
    Material Weakness
  • 386707 2023-007
    Material Weakness
  • 386708 2023-007
    Material Weakness
  • 386709 2023-007
    Material Weakness
  • 386710 2023-007
    Material Weakness
  • 386711 2023-007
    Material Weakness
  • 386712 2023-007
    Material Weakness
  • 386713 2023-008
    Material Weakness
  • 386714 2023-008
    Material Weakness
  • 386715 2023-008
    Material Weakness
  • 386716 2023-008
    Material Weakness
  • 386717 2023-008
    Material Weakness
  • 386718 2023-008
    Material Weakness
  • 386719 2023-008
    Material Weakness
  • 386720 2023-008
    Material Weakness
  • 963121 2023-002
    Material Weakness Repeat
  • 963122 2023-002
    Material Weakness Repeat
  • 963123 2023-002
    Material Weakness Repeat
  • 963124 2023-002
    Material Weakness Repeat
  • 963125 2023-002
    Material Weakness Repeat
  • 963126 2023-002
    Material Weakness Repeat
  • 963127 2023-003
    Material Weakness Repeat
  • 963128 2023-003
    Material Weakness Repeat
  • 963129 2023-003
    Material Weakness Repeat
  • 963130 2023-003
    Material Weakness Repeat
  • 963131 2023-004
    Material Weakness
  • 963132 2023-004
    Material Weakness
  • 963133 2023-004
    Material Weakness
  • 963134 2023-004
    Material Weakness
  • 963135 2023-005
    Material Weakness
  • 963136 2023-005
    Material Weakness
  • 963137 2023-005
    Material Weakness
  • 963138 2023-005
    Material Weakness
  • 963139 2023-006
    Material Weakness Repeat
  • 963140 2023-006
    Material Weakness Repeat
  • 963141 2023-006
    Material Weakness Repeat
  • 963142 2023-006
    Material Weakness Repeat
  • 963143 2023-006
    Material Weakness Repeat
  • 963144 2023-006
    Material Weakness Repeat
  • 963145 2023-006
    Material Weakness Repeat
  • 963146 2023-006
    Material Weakness Repeat
  • 963147 2023-007
    Material Weakness
  • 963148 2023-007
    Material Weakness
  • 963149 2023-007
    Material Weakness
  • 963150 2023-007
    Material Weakness
  • 963151 2023-007
    Material Weakness
  • 963152 2023-007
    Material Weakness
  • 963153 2023-007
    Material Weakness
  • 963154 2023-007
    Material Weakness
  • 963155 2023-008
    Material Weakness
  • 963156 2023-008
    Material Weakness
  • 963157 2023-008
    Material Weakness
  • 963158 2023-008
    Material Weakness
  • 963159 2023-008
    Material Weakness
  • 963160 2023-008
    Material Weakness
  • 963161 2023-008
    Material Weakness
  • 963162 2023-008
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $5.34M
14.239 Home Investment Partnerships Program $2.33M
10.555 National School Lunch Program $1.62M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $510,404
10.553 School Breakfast Program $304,229
97.036 Covid-19 Disaster Grants - Public Assistance (presidentially Declared Disasters) $249,639
10.555 Covid-19 National School Lunch Program $168,352
93.959 Block Grants for Prevention and Treatment of Substance Abuse $134,765
93.959 Covid-19 Block Grants for Prevention and Treatment of Substance Abuse $125,000
14.218 Covid-19 Community Development Block Grants/entitlement Grants $123,185
84.027 Covid-19 Special Education_grants to States $110,945
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $89,477
84.173 Special Education_preschool Grants $65,425
97.044 Assistance to Firefighters Grant $49,750
20.600 State and Community Highway Safety $47,173
84.425 Covid-19 Education Stabilization Fund $40,190
97.042 Emergency Management Performance Grants $27,941
84.371 Striving Readers - Comprehensive Literacy Development Grants $27,500
84.173 Covid-19 Special Education_preschool Grants $26,236
84.010 Title I Grants to Local Educational Agencies $21,500
84.048 Career and Technical Education -- Basic Grants to States $19,610
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $16,018
16.738 Edward Byrne Memorial Justice Assistance Grant Program $14,060
84.196 Education for Homeless Children and Youth $10,000
14.218 Community Development Block Grants/entitlement Grants $5,722
16.922 Equitable Sharing Program $5,100
45.310 Grants to States - State Library Program $4,200
84.424 Student Support and Academic Enrichment Program $3,800
84.027 Special Education_grants to States $2,500
10.559 Summer Food Service Program for Children $2,468
16.607 Bulletproof Vest Partnership Program $2,437
84.367 Supporting Effective Instruction State Grants $1,879
93.645 Stephanie Tubbs Jones Child Welfare Services Program $1,873
84.365 English Language Acquisition State Grants $1,350