Finding 1220078 (2024-003)

Material Weakness Repeat Finding
Requirement
F
Questioned Costs
-
Year
2024
Accepted
2026-06-29
Audit: 405251
Organization: Lake County (IN)

AI Summary

  • Core Issue: The County failed to include a $734,389 right-of-way purchase in its capital asset listing, violating federal requirements for equipment and property management.
  • Impacted Requirements: Noncompliance with 2 CFR 200.303 and 2 CFR 200.313(d) regarding internal controls and property record maintenance could lead to federal fund repayment.
  • Recommended Follow-Up: Establish effective internal controls to ensure all federally funded capital assets are properly recorded and managed.

Finding Text

FINDING 2024-003 Subject: Highway Planning and Construction - Equipment and Real Property Management Federal Agency: Department of Transportation Federal Program: Highway Planning and Construction Assistance Listings Number: 20.205 Federal Award Number and Year (or Other Identifying Number): DES #9981680 Pass-Through Entity: Indiana Department of Transportation Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context A property record or capital asset listing is required to be maintained for all equipment, property improvements, and property purchased with the Highway Planning and Construction grant awards to ensure adequate safeguards are in place to prevent loss or damage of items. In addition, a complete physical inventory of the property must be taken every two years and reconciled with the detailed listing. The capital asset listing is to include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, 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 sales price of the property. The County purchased $734,389 of right-of-way for the Veterans Memorial Trail project. The project had a 20 percent local match; thus, the Highway Planning and Construction grant portion was $587,511. The right-of-way purchase should have been recorded as capital assets purchased with 80 percent federal funding. However, the County did not include the right-of-way purchased in the capital asset listing. The lack of internal controls and noncompliance were isolated to DES #9981680. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) 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). . . ." 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 dunking for the property (including the federal award identification number), who holds title, the acquisition date, 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 sales 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. . . ." Cause Effective internal controls were not in place to ensure that all capital assets purchased with federal funds, including rights-of-ways, were added to the County's capital asset listing. Effect Noncompliance with the grant agreement and the compliance requirement could result in the repayment of federal funds. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the County's management establish a proper system of internal controls that would ensure compliance with the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Corrective Action Plan

FINDING 2024-003 Finding Subject: Highway Planning and Construction - Equipment and Real Property Management Contact Person Responsible for Corrective Action: Craig Zandstra Contact Phone Number and Email Address: 219-945-0543 Ext 234, craigz@lakecountyparks.com Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The County will implement a process of better tracking of asset purchases paid with the Highway Planning and Construction grant. Will ensure that the list is updated every year. Anticipated Completion Date: December 2026

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 1220079 2024-004
    Material Weakness Repeat
  • 1220080 2024-004
    Material Weakness Repeat
  • 1220081 2024-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $7.83M
93.563 CHILD SUPPORT SERVICES $4.34M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $1.56M
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $251,263
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $163,767
93.940 HIV PREVENTION AND SURVEILLANCE ACTIVITIES-HEALTH DEPARTMENT BASED $151,285
97.067 HOMELAND SECURITY GRANT PROGRAM $128,960
66.469 GEOGRAPHIC PROGRAMS - GREAT LAKES RESTORATION INITIATIVE $114,932
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $107,078
90.404 HAVA ELECTION SECURITY GRANTS $89,570
93.788 OPIOID STR $81,250
16.U01 Domestic Cannabis Eradication and Suppression $77,800
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $76,911
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $75,000
16.575 CRIME VICTIM ASSISTANCE $64,585
10.555 NATIONAL SCHOOL LUNCH PROGRAM $45,474
16.922 EQUITABLE SHARING PROGRAM $34,089
16.609 PROJECT SAFE NEIGHBORHOODS $30,588
10.553 SCHOOL BREAKFAST PROGRAM $24,685
93.747 ELDER ABUSE PREVENTION INTERVENTIONS PROGRAM $16,923
15.662 GREAT LAKES RESTORATION $9,800
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $7,500
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $6,034
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $5,826
93.946 COOPERATIVE AGREEMENTS TO SUPPORT STATE-BASED SAFE MOTHERHOOD AND INFANT HEALTH INITIATIVE PROGRAMS $4,852