Audit 310284

FY End
2023-06-30
Total Expended
$5.72M
Findings
2
Programs
15
Organization: Town of Westford (MA)
Year: 2023 Accepted: 2024-06-27
Auditor: Marcum LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
403155 2023-001 Significant Deficiency - I
979597 2023-001 Significant Deficiency - I

Contacts

Name Title Type
LNE8KJMZ1328 Jesse Beyer Auditee
9783924450 Scott McIntire Auditor
No contacts on file

Notes to SEFA

Title: DONATED PERSONAL PROTECTIVE EQUIPMENT (PPE) (UNAUDITED) Accounting Policies: • The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of the Town of Westford, Massachusetts (the Town) under programs of the federal government for the year ended June 30, 2023. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Town, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Town. • Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited to reimbursement. • The amounts reported for the National School Lunch Program – Non-Cash Assistance represent the fair value of commodities received. • Expenditures awarded from the Federal Emergency Management Agency (FEMA), must be presented on the Schedule when; 1) FEMA has approved the Town’s project worksheet and 2) the Town has incurred the eligible expenditures. The $31,055 reported for Disaster Grants – Public Assistance (Presidentially Declared Disasters), AL 97.036, represents expenditures incurred in prior years that were approved by FEMA during fiscal year 2023. De Minimis Rate Used: N Rate Explanation: The Town has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance During fiscal year 2023, the Town did not receive donated PPE from federal sources.

Finding Details

2023-001 Improve Controls and Documentation Over Procurement Federal Agency: U.S. Department of the Treasury Cluster/Program: COVID-19 – Coronavirus State and Local Fiscal Recovery Fund AL Numbers: 21.027 Award Year: 2023 Compliance Requirement: Procurement and Suspension and Debarment Type of Finding Compliance Internal Control over Compliance - Significant Deficiency Criteria or Specific Requirement Non-federal entities other than states, including those operating federal programs as subrecipients of states, must follow the procurement standards set out at 2 CFR sections 200.318 through 200.326. They must use their own documented procurement procedures, which reflect applicable state and local laws and regulations, provided that the procurements conform to applicable federal statutes and the procurement requirements identified in 2 CFR Part 200. Local municipalities are also required to use the same state procurement policies and procedures for federal funds as for non-federal funds, the Town is required to follow Massachusetts General Laws, Chapter (MGL) 30(b). MGL 30(b) requires the solicitation of three written or oral quotes for procurements of supplies between $10,000 and $49,999 and sealed bids or proposals for procurements of supplies $50,000 and over. Management of the Town is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal program. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. Condition and Context There was no evidence to support that one disbursement properly followed the procurement process before payments for services were made to the vendor. Cause Weaknesses in the design and operation of controls. 2023-001 Improve Controls and Documentation Over Procurement (Continued) Effect or Potential Effect Due to the weaknesses in internal controls noted above, there is a risk that procurements may be awarded to vendors in a manner that is not consistent with federal procurement requirements. Known questioned costs are reported equal to $82,800, as follows: AL Questioned Number(s) Name of Federal Program or Cluster Costs 21.027 COVID-19 – Coronavirus State and Local Fiscal Recovery Fund $82,800 Recommendation The Town should address the weaknesses in internal controls noted above in order to ensure that federal procurements are conducted in accordance with federal and state requirements. Views of Responsible Official Management agrees with the finding. Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2023-001 Improve Controls and Documentation Over Procurement Federal Agency: U.S. Department of the Treasury Cluster/Program: COVID-19 – Coronavirus State and Local Fiscal Recovery Fund AL Numbers: 21.027 Award Year: 2023 Compliance Requirement: Procurement and Suspension and Debarment Type of Finding Compliance Internal Control over Compliance - Significant Deficiency Criteria or Specific Requirement Non-federal entities other than states, including those operating federal programs as subrecipients of states, must follow the procurement standards set out at 2 CFR sections 200.318 through 200.326. They must use their own documented procurement procedures, which reflect applicable state and local laws and regulations, provided that the procurements conform to applicable federal statutes and the procurement requirements identified in 2 CFR Part 200. Local municipalities are also required to use the same state procurement policies and procedures for federal funds as for non-federal funds, the Town is required to follow Massachusetts General Laws, Chapter (MGL) 30(b). MGL 30(b) requires the solicitation of three written or oral quotes for procurements of supplies between $10,000 and $49,999 and sealed bids or proposals for procurements of supplies $50,000 and over. Management of the Town is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal program. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. Condition and Context There was no evidence to support that one disbursement properly followed the procurement process before payments for services were made to the vendor. Cause Weaknesses in the design and operation of controls. 2023-001 Improve Controls and Documentation Over Procurement (Continued) Effect or Potential Effect Due to the weaknesses in internal controls noted above, there is a risk that procurements may be awarded to vendors in a manner that is not consistent with federal procurement requirements. Known questioned costs are reported equal to $82,800, as follows: AL Questioned Number(s) Name of Federal Program or Cluster Costs 21.027 COVID-19 – Coronavirus State and Local Fiscal Recovery Fund $82,800 Recommendation The Town should address the weaknesses in internal controls noted above in order to ensure that federal procurements are conducted in accordance with federal and state requirements. Views of Responsible Official Management agrees with the finding. Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.