Finding 1130529 (2024-004)

-
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-04-04
Audit: 352733
Organization: Town of Brunswick Maine (ME)

AI Summary

  • Core Issue: An employee's MainePERS retirement contribution was miscalculated due to outdated rates in the payroll system.
  • Impacted Requirements: Contributions for federally and non-federally funded teachers must be prorated correctly based on their activity allocation.
  • Recommended Follow-Up: Review all employees' payroll allocations and establish policies for annual rate updates and proper application during changes.

Finding Text

2024-004 U.S. Department of Education, Assistance Listing #84.027/84.173 Special Education Cluster (IDEA) for the period July 1, 2023 through June 30, 2024 Criteria: Brunswick School Department teachers participate in the MainePERS retirement program. Teacher salaries and benefits, including the employer portion of MainePERS contributions, are charged to the Special Education Cluster (IDEA). Teacher employer contribution rates for the MainePERS retirement system were 4.47% for non-Federally funded teachers, and 19.57% for federally funded teachers during fiscal year 2024. Employees allocated to federal and non-federal activities should have their contributions prorated using the non-Federal and Federal rates based on the percentage of time allocated to each activity. Condition: We performed a payroll test of two employees charged to the Special Education Cluster (IDEA). One of the two employees tested had an incorrect MainePERS retirement contribution calculation. Cause: The employee tested was allocated 9% to the Federal grant and 91% to non-Federal activities. The contribution rates were not updated in the payroll system to reflect the correct allocation of Federal and non-Federal rates. Effect: As a result, the Special Education Cluster (IDEA) grant was overcharged for the employer portion of MainePERS contributions. Known Questioned Costs: $386 Likely Questioned Costs: $3,205 Recommendation: We recommend all employees charged to both Federal and non-Federal activities be reviewed in the payroll system to ensure the system is calculating the correct Federal and non-Federal rates. We also recommend developing policies to ensure that the correct rates are updated in the system each year and rates are properly applied when employee additions or allocation changes are made.

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 554080 2024-002
    Significant Deficiency
  • 554081 2024-002
    Significant Deficiency
  • 554082 2024-002
    Significant Deficiency
  • 554083 2024-003
    Significant Deficiency
  • 554084 2024-003
    Significant Deficiency
  • 554085 2024-003
    Significant Deficiency
  • 554086 2024-004
    -
  • 554087 2024-004
    -
  • 554088 2024-004
    -
  • 554089 2024-001
    Material Weakness
  • 554090 2024-001
    Material Weakness
  • 554091 2024-001
    Material Weakness
  • 1130522 2024-002
    Significant Deficiency
  • 1130523 2024-002
    Significant Deficiency
  • 1130524 2024-002
    Significant Deficiency
  • 1130525 2024-003
    Significant Deficiency
  • 1130526 2024-003
    Significant Deficiency
  • 1130527 2024-003
    Significant Deficiency
  • 1130528 2024-004
    -
  • 1130530 2024-004
    -
  • 1130531 2024-001
    Material Weakness
  • 1130532 2024-001
    Material Weakness
  • 1130533 2024-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.027 Special Education State Grants $838,966
21.027 State and Local Fiscal Recovery Funds - Covid-19 $812,019
15.916 Land and Water Conservation Fund Grant $627,768
84.425 Elementary and Secondary School Emergency Relief 3 - Covid-19 $601,837
84.010 Title Ia $492,824
10.555 National School Lunch Program - Subsidized Hot Lunch $384,803
10.553 Breakfast Program $133,425
21.027 State and Local Fiscal Recovery Funds Extended Learning Opportunities - Covid-19 $130,687
14.228 Community Development Block Grants $100,000
84.027 Arp Local Entitlement - Covid-19 $88,450
21.027 State and Local Fiscal Recovery Funds Prek - Covid-19 $83,524
10.555 Food Distribution/food Donation Program $80,069
10.555 State Administrative Expenses for Child Nutrition: Supply Chain Assistance $55,569
84.425 Arp Elementary and Secondary School Emergency Relief - Covid-19 $49,060
84.367 Title Iia - Supporting Effective Instruction $46,561
20.325 Consolidated Rail Infrastructure and Safety Improvements $46,043
16.710 Public Safety Partnership and Community Policing Program $45,000
20.205 Highway Planning and Construction $38,789
66.460 Nonpoint Source Implementation Grants $35,522
97.067 Homeland Security Grant $26,606
84.424 Title Iva - Student Support and Academic Enrichment $24,784
84.425 Arp Elementary and Secondary School Emergency Relief - Learning Loss - Covid-19 $15,641
84.425 Arp Homeless Children & Youth I - Covid-19 $13,736
84.173 Preschool 619 $11,882
20.600 High Visibility Enforcement $10,538
20.600 Dre - Forensic Phlebotomy $9,280
16.738 Edward Byrne Memorial Justice Assistance Grant $8,680
84.365 English Language Acquisition $8,600
15.605 Sport Fish Restoration Program $7,499
20.600 Distracted Driving $5,213
84.425 Elementary and Secondary School Emergency Relief 2 - Covid-19 $3,209
10.649 Pandemic Ebt Administrative Costs: Snap - Covid-19 $2,612
16.607 Bulletproof Vest Partnership Program $1,399
16.015 Missing Alzheimer's Disease Patient Assistance Program $1,072