Audit 320389

FY End
2023-12-31
Total Expended
$2.49M
Findings
2
Programs
3
Organization: Town of Cambridge City (IN)
Year: 2023 Accepted: 2024-09-23

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
497615 2023-003 Material Weakness - I
1074057 2023-003 Material Weakness - I

Contacts

Name Title Type
M2VAEJP7FVP1 Sherry Ervin Auditee
7654783522 Beth Kelley, Cpa, Cfe Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Note 1. Summary of Significant Accounting Policies A. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal grant activity of the Town under programs of the federal government for the year ended December 31, 2023. The information in the SEFA is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the SEFA presents only a select portion of the operations of the Town, it is not intended to and does not present the financial position of the Town. B. Other Significant Accounting Policies Expenditures reported on the SEFA are reported on the cash basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles in OMB Circular A-87, Cost Principles for State, Local, and Indian Tribal Governments, or the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. When federal grants are received on a reimbursement basis, the federal awards are considered expended when the reimbursement is received. De Minimis Rate Used: N Rate Explanation: Note 2. Indirect Cost Rate The Town has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

FINDING 2023-003 Subject: Drinking Water State Revolving Fund (DWSRF) Cluster - Procurement Federal Agency: Environmental Protection Agency Federal Program: Drinking Water State Revolving Fund Assistance Listings Number: 66.468 Federal Award Number (or Other Identifying Number): DW22168902 Pass-Through Entity: Indiana Finance Authority Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context Federal regulations allow for informal procurement methods when the value of the procurement for property or services does not exceed the simplified acquisition threshold, which is set at $250,000 unless a lower, more restrictive threshold is set by a nonfederal entity. As Indiana Code has set a more restrictive threshold of $150,000, informal procurement methods are permitted when the value of the procurement does not exceed $150,000. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micropurchase threshold but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. The Town did not obtain price or rate quotes for the two vendors identified and tested that were less than the simplified acquisition threshold of $150,000 but exceeded the $10,000 micro-purchase threshold. The micro-purchase threshold may be increased, but the Town did not provide documentation that the threshold had been increased. Documentation detailing the history of procurement, which must include the reason for the procurement method used, was not available for audit. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.320 states in part: "The non-Federal entity must have and use documented 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. INDIANA STATE BOARD OF ACCOUNTS 18 TOWN OF CAMBRIDGE CITY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." Cause The Town was unable to provide documentation to demonstrate it had properly procured services. The Town noted they were unaware professional services agreements for consultants were required to follow small purchase procurement guidelines. Effect Without the proper implementation of an effectively designed system of internal controls, the Town could not demonstrate it had obtained an adequate number of price or rate quotations prior to selecting a vendor. Therefore, the Town could have overpaid for the services obtained. Questioned Costs There were no questioned costs identified. Recommendation We recommend that management of the Town strengthen its system of internal controls to ensure that an adequate number of price or rate quotations are obtained for small purchases. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. INDIANA STATE
FINDING 2023-003 Subject: Drinking Water State Revolving Fund (DWSRF) Cluster - Procurement Federal Agency: Environmental Protection Agency Federal Program: Drinking Water State Revolving Fund Assistance Listings Number: 66.468 Federal Award Number (or Other Identifying Number): DW22168902 Pass-Through Entity: Indiana Finance Authority Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context Federal regulations allow for informal procurement methods when the value of the procurement for property or services does not exceed the simplified acquisition threshold, which is set at $250,000 unless a lower, more restrictive threshold is set by a nonfederal entity. As Indiana Code has set a more restrictive threshold of $150,000, informal procurement methods are permitted when the value of the procurement does not exceed $150,000. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micropurchase threshold but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. The Town did not obtain price or rate quotes for the two vendors identified and tested that were less than the simplified acquisition threshold of $150,000 but exceeded the $10,000 micro-purchase threshold. The micro-purchase threshold may be increased, but the Town did not provide documentation that the threshold had been increased. Documentation detailing the history of procurement, which must include the reason for the procurement method used, was not available for audit. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.320 states in part: "The non-Federal entity must have and use documented 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. INDIANA STATE BOARD OF ACCOUNTS 18 TOWN OF CAMBRIDGE CITY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." Cause The Town was unable to provide documentation to demonstrate it had properly procured services. The Town noted they were unaware professional services agreements for consultants were required to follow small purchase procurement guidelines. Effect Without the proper implementation of an effectively designed system of internal controls, the Town could not demonstrate it had obtained an adequate number of price or rate quotations prior to selecting a vendor. Therefore, the Town could have overpaid for the services obtained. Questioned Costs There were no questioned costs identified. Recommendation We recommend that management of the Town strengthen its system of internal controls to ensure that an adequate number of price or rate quotations are obtained for small purchases. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. INDIANA STATE