Audit 13421

FY End
2023-06-30
Total Expended
$2.91M
Findings
8
Programs
14
Organization: Bedford Public Schools (MI)
Year: 2023 Accepted: 2024-01-24

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
9671 2023-001 Material Weakness - N
9672 2023-001 Material Weakness - N
9673 2023-001 Material Weakness - N
9674 2023-001 Material Weakness - N
586113 2023-001 Material Weakness - N
586114 2023-001 Material Weakness - N
586115 2023-001 Material Weakness - N
586116 2023-001 Material Weakness - N

Contacts

Name Title Type
CJSDFEVMMAR1 Chrissie Bruckney Auditee
7348506011 Daniel Clark, CPA Auditor
No contacts on file

Notes to SEFA

Title: RECONCILIATION TO BASIC FINANCIAL STATEMENTS Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Bedford Public Schools (the “District”) under programs of the federal government for the year ended June 30, 2023. The information in this Schedule 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 Schedule presents only a selected portion of the operations of the District, it is not intended to and does not present the financial position, changes in net position or cash flows of the District. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting, which is described in Note 1 to the District's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and other applicable guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule, if any, represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been incurred and all grant requirements have been met. The Schedule has been arranged to provide information on both actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue, and accounts payable items at both the beginning and end of the fiscal year have been reported. Expenditures are in agreement with amounts reported in the financial statements and the financial reports. The amounts reported on the Grant Auditor Report reconcile with this Schedule. De Minimis Rate Used: N Rate Explanation: For purposes of charging indirect costs to federal awards, the District has not elected to use the 10 percent de minimis cost rate as permitted by §200.414 of the Uniform Guidance. A reconciliation of revenues from federal sources per governmental funds financial statements and expenditures per single audit act compliance schedule of expenditures of federal awards is as follows: "See the Notes to the SEFA for chart/table".
Title: PASS-THROUGH AGENCIES Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Bedford Public Schools (the “District”) under programs of the federal government for the year ended June 30, 2023. The information in this Schedule 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 Schedule presents only a selected portion of the operations of the District, it is not intended to and does not present the financial position, changes in net position or cash flows of the District. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting, which is described in Note 1 to the District's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and other applicable guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule, if any, represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been incurred and all grant requirements have been met. The Schedule has been arranged to provide information on both actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue, and accounts payable items at both the beginning and end of the fiscal year have been reported. Expenditures are in agreement with amounts reported in the financial statements and the financial reports. The amounts reported on the Grant Auditor Report reconcile with this Schedule. De Minimis Rate Used: N Rate Explanation: For purposes of charging indirect costs to federal awards, the District has not elected to use the 10 percent de minimis cost rate as permitted by §200.414 of the Uniform Guidance. The District receives certain federal grants as subawards from non-federal entities. Pass-through entities, where applicable, have been identified in the Schedule with an abbreviation, defined as follows: "See the Notes to the SEFA for chart/table".

Finding Details

2023-001 – Special Tests and Provisions – Wage Rate Requirementss Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. Federal program(s) U.S. Department of Education - COVID-19 - Education Stabilization Fund (ALN 84.425D and 84.425U); Passed through the Michigan Department of Education; All project numbers. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on minor remodeling, renovation or construction contracts in excess of $2,000 financed by federal assistance funds be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their construction contracts subject to the wage rate requirements a provision that the contractor or subcontractor comply with those requirements and the DOL regulations, which include a requirement to obtain weekly certified payrolls from contractors. Condition. The one contract selected for testing that was subject to the wage rate requirements did not include the required provision and the District did not obtain the required certified payrolls.. Cause. The District does not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. The District did not follow federal requirements to include the prevailing wage rate provision in its contract. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $119,700. Recommendation. We recommend that the District reviews its policies to ensure that applicable prevailing wage requirements are included in construction contracts whenever federal funds are used and certified payrolls are obtained. View of Responsible Officials. District officials will ensure that construction contracts contain these requirements during the bid process. Responsible Official. Executive Director of Business Services Estimated Completion Date. June 30, 2024
2023-001 – Special Tests and Provisions – Wage Rate Requirementss Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. Federal program(s) U.S. Department of Education - COVID-19 - Education Stabilization Fund (ALN 84.425D and 84.425U); Passed through the Michigan Department of Education; All project numbers. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on minor remodeling, renovation or construction contracts in excess of $2,000 financed by federal assistance funds be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their construction contracts subject to the wage rate requirements a provision that the contractor or subcontractor comply with those requirements and the DOL regulations, which include a requirement to obtain weekly certified payrolls from contractors. Condition. The one contract selected for testing that was subject to the wage rate requirements did not include the required provision and the District did not obtain the required certified payrolls.. Cause. The District does not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. The District did not follow federal requirements to include the prevailing wage rate provision in its contract. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $119,700. Recommendation. We recommend that the District reviews its policies to ensure that applicable prevailing wage requirements are included in construction contracts whenever federal funds are used and certified payrolls are obtained. View of Responsible Officials. District officials will ensure that construction contracts contain these requirements during the bid process. Responsible Official. Executive Director of Business Services Estimated Completion Date. June 30, 2024
2023-001 – Special Tests and Provisions – Wage Rate Requirementss Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. Federal program(s) U.S. Department of Education - COVID-19 - Education Stabilization Fund (ALN 84.425D and 84.425U); Passed through the Michigan Department of Education; All project numbers. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on minor remodeling, renovation or construction contracts in excess of $2,000 financed by federal assistance funds be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their construction contracts subject to the wage rate requirements a provision that the contractor or subcontractor comply with those requirements and the DOL regulations, which include a requirement to obtain weekly certified payrolls from contractors. Condition. The one contract selected for testing that was subject to the wage rate requirements did not include the required provision and the District did not obtain the required certified payrolls.. Cause. The District does not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. The District did not follow federal requirements to include the prevailing wage rate provision in its contract. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $119,700. Recommendation. We recommend that the District reviews its policies to ensure that applicable prevailing wage requirements are included in construction contracts whenever federal funds are used and certified payrolls are obtained. View of Responsible Officials. District officials will ensure that construction contracts contain these requirements during the bid process. Responsible Official. Executive Director of Business Services Estimated Completion Date. June 30, 2024
2023-001 – Special Tests and Provisions – Wage Rate Requirementss Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. Federal program(s) U.S. Department of Education - COVID-19 - Education Stabilization Fund (ALN 84.425D and 84.425U); Passed through the Michigan Department of Education; All project numbers. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on minor remodeling, renovation or construction contracts in excess of $2,000 financed by federal assistance funds be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their construction contracts subject to the wage rate requirements a provision that the contractor or subcontractor comply with those requirements and the DOL regulations, which include a requirement to obtain weekly certified payrolls from contractors. Condition. The one contract selected for testing that was subject to the wage rate requirements did not include the required provision and the District did not obtain the required certified payrolls.. Cause. The District does not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. The District did not follow federal requirements to include the prevailing wage rate provision in its contract. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $119,700. Recommendation. We recommend that the District reviews its policies to ensure that applicable prevailing wage requirements are included in construction contracts whenever federal funds are used and certified payrolls are obtained. View of Responsible Officials. District officials will ensure that construction contracts contain these requirements during the bid process. Responsible Official. Executive Director of Business Services Estimated Completion Date. June 30, 2024
2023-001 – Special Tests and Provisions – Wage Rate Requirementss Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. Federal program(s) U.S. Department of Education - COVID-19 - Education Stabilization Fund (ALN 84.425D and 84.425U); Passed through the Michigan Department of Education; All project numbers. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on minor remodeling, renovation or construction contracts in excess of $2,000 financed by federal assistance funds be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their construction contracts subject to the wage rate requirements a provision that the contractor or subcontractor comply with those requirements and the DOL regulations, which include a requirement to obtain weekly certified payrolls from contractors. Condition. The one contract selected for testing that was subject to the wage rate requirements did not include the required provision and the District did not obtain the required certified payrolls.. Cause. The District does not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. The District did not follow federal requirements to include the prevailing wage rate provision in its contract. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $119,700. Recommendation. We recommend that the District reviews its policies to ensure that applicable prevailing wage requirements are included in construction contracts whenever federal funds are used and certified payrolls are obtained. View of Responsible Officials. District officials will ensure that construction contracts contain these requirements during the bid process. Responsible Official. Executive Director of Business Services Estimated Completion Date. June 30, 2024
2023-001 – Special Tests and Provisions – Wage Rate Requirementss Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. Federal program(s) U.S. Department of Education - COVID-19 - Education Stabilization Fund (ALN 84.425D and 84.425U); Passed through the Michigan Department of Education; All project numbers. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on minor remodeling, renovation or construction contracts in excess of $2,000 financed by federal assistance funds be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their construction contracts subject to the wage rate requirements a provision that the contractor or subcontractor comply with those requirements and the DOL regulations, which include a requirement to obtain weekly certified payrolls from contractors. Condition. The one contract selected for testing that was subject to the wage rate requirements did not include the required provision and the District did not obtain the required certified payrolls.. Cause. The District does not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. The District did not follow federal requirements to include the prevailing wage rate provision in its contract. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $119,700. Recommendation. We recommend that the District reviews its policies to ensure that applicable prevailing wage requirements are included in construction contracts whenever federal funds are used and certified payrolls are obtained. View of Responsible Officials. District officials will ensure that construction contracts contain these requirements during the bid process. Responsible Official. Executive Director of Business Services Estimated Completion Date. June 30, 2024
2023-001 – Special Tests and Provisions – Wage Rate Requirementss Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. Federal program(s) U.S. Department of Education - COVID-19 - Education Stabilization Fund (ALN 84.425D and 84.425U); Passed through the Michigan Department of Education; All project numbers. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on minor remodeling, renovation or construction contracts in excess of $2,000 financed by federal assistance funds be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their construction contracts subject to the wage rate requirements a provision that the contractor or subcontractor comply with those requirements and the DOL regulations, which include a requirement to obtain weekly certified payrolls from contractors. Condition. The one contract selected for testing that was subject to the wage rate requirements did not include the required provision and the District did not obtain the required certified payrolls.. Cause. The District does not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. The District did not follow federal requirements to include the prevailing wage rate provision in its contract. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $119,700. Recommendation. We recommend that the District reviews its policies to ensure that applicable prevailing wage requirements are included in construction contracts whenever federal funds are used and certified payrolls are obtained. View of Responsible Officials. District officials will ensure that construction contracts contain these requirements during the bid process. Responsible Official. Executive Director of Business Services Estimated Completion Date. June 30, 2024
2023-001 – Special Tests and Provisions – Wage Rate Requirementss Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. Federal program(s) U.S. Department of Education - COVID-19 - Education Stabilization Fund (ALN 84.425D and 84.425U); Passed through the Michigan Department of Education; All project numbers. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on minor remodeling, renovation or construction contracts in excess of $2,000 financed by federal assistance funds be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their construction contracts subject to the wage rate requirements a provision that the contractor or subcontractor comply with those requirements and the DOL regulations, which include a requirement to obtain weekly certified payrolls from contractors. Condition. The one contract selected for testing that was subject to the wage rate requirements did not include the required provision and the District did not obtain the required certified payrolls.. Cause. The District does not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. The District did not follow federal requirements to include the prevailing wage rate provision in its contract. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $119,700. Recommendation. We recommend that the District reviews its policies to ensure that applicable prevailing wage requirements are included in construction contracts whenever federal funds are used and certified payrolls are obtained. View of Responsible Officials. District officials will ensure that construction contracts contain these requirements during the bid process. Responsible Official. Executive Director of Business Services Estimated Completion Date. June 30, 2024