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.
FINDING 2024-004 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Procurement and Suspension and Debarment Federal Agency: U.S. Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Numbers and Years (or Other Identifying Numbers): Contract #65873, SLT-3157 Pass-Through Entity: Indiana Department of Natural Resources Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-004. Condition and Context Procurement The County did adopt an applicable federal purchasing policy. The Lake County Indiana Purchasing Manual for Supplies, Services, and Public Works states on page 19 that "Federal funds less than $25,000 will obtain 3 quotes by telephone or fax and obtain board approval. . . ." The Lake County Indiana Purchasing Manual for Supplies, Services, and Public Works also states on page 19 that "Federal funds more than $25,000 but less than $50,000 will invite 3 quotes at an open public meeting." The federal procurement requirement, per the Code of Federal Regulations section 200.320, states that for small purchases, price or rate quotations must be obtained from an adequate number of qualified sources. In 2024, the County had two vendors. One was paid $27,963, and one was paid $12,970 for a total of $40,933 from the COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF) under Contract #65873 from the Indiana Department of Natural Resources. However, the County did not obtain price or rate quotes for the applicable vendors under the small purchase threshold as required per its purchasing policy or the federal requirements. Suspension and Debarment Prior to entering into subawards and covered transactions with the SLFRF award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000 and all subawards. The verification is to be done by checking the Excluded Parties List System (EPLS), collecting a certification from that person or entity, or adding a clause or condition to the covered transaction with that person or entity. The County did not have policies or procedures in place related to the suspension and debarment requirements for the SLFRF funds. Three covered transactions totaling $7,530,563 paid from the SLFRF funds were identified. Documentation to show that suspension and debarment was verified prior to entering into contracts with these three vendors could not be provided by the County. The amounts for which suspension and debarment were not verified for Contract #65873 from the Indiana Department of Natural Resources and the SLT-3157 directly from the U.S. Department of the Treasury were $27,963 and $7,502,600, respectively. The lack of internal controls and noncompliance were isolated to the transactions identified above. 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.318(i) states: "The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: Rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price." 2 CFR 200.320 states in part: "The non-Federal entity must have and use document procurement procedures, consistent with the standards of this section and §§200.317, 200.318, and 200.319 for any of the following methods of procurement used for the acquisition of property or services required under a Federal award or sub-award. (a) Informal procurement methods. When the value of the procurement for property or services under a Federal award does not exceed the simplified acquisition threshold (SAT), as defined in § 200.1, or a lower threshold established by a non-Federal entity, formal procurement methods are not required. The non-Federal entity may use informal procurement methods to expedite the completion of its transactions and minimize the associated administrative burden and cost. The informal methods used for procurement of property or services at or below the SAT include: . . . (2) Small purchases — (i) Small purchase procedures. The acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause The County's purchasing policy does not provide procedures on how the County will ensure the appropriate number of quotes will be obtained for small purchases or how the County will ensure compliance with the suspension and debarment requirements. Effect Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the repayment or loss of future federal funding to the County. Questioned Costs There were no questioned costs identified. Recommendation Management of the County should develop procedures to ensure the appropriate procurement methods are used for items or services procured that are within the small purchase threshold and to ensure vendors are not suspended or debarred when expending federal funds. Appropriate documentation should be maintained to ensure compliance with procurement and suspension and debarment. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: U.S. Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): SLT-3157 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-005. Condition and Context Recipients are required to submit quarterly or annual Project and Expenditure (P&E) reports to the U.S. Department of the Treasury (Treasury). The reporting periods, as well as the respective due dates, are based upon type of recipient and its population as well as the recipient's allocation amount. Information to be reported includes projects funded, expenditures, and contracts for the appropriate reporting period. The County was classified as a county with a population that exceeds 250,000 residents. As such, the County was required to submit quarterly P&E reports in 2024. The amounts submitted for three of the four quarterly P&E reports were not supported by the County's records and contained the following errors: The 2024 Quarter 1 P&E report period and cumulative expenditures were each overstated by $333,424. The 2024 Quarter 2 P&E report period and cumulative expenditures were understated by $842,954 and $509,530, respectively. The 2024 Quarter 3 P&E report period and cumulative expenditures were understated by $239,925 and $749,455, respectively. Additionally, the current period obligations and cumulative obligations amounts reported in all quarterly reports could not be verified as supporting documentation was not provided for audit. The lack of internal controls and noncompliance was a systemic issue throughout the audit period. 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). . . ." Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds, page 13 states in part: ". . . 13. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary or her delegate, as applicable, periodic reports providing detailed accounting of the uses of funds, . . ." Cause All quarterly P&E reports were prepared and submitted by a consultant without an oversight or review process in place to prevent, or detect and correct, errors prior to submission. Effect Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the repayment or loss of future federal funding to the County. 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 Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.