Audit 3208

FY End
2023-06-30
Total Expended
$1.22M
Findings
8
Programs
8
Organization: Black River Public School (MI)
Year: 2023 Accepted: 2023-11-15

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1843 2023-003 Material Weakness - N
1844 2023-004 Significant Deficiency - F
1845 2023-003 Material Weakness - N
1846 2023-004 Significant Deficiency - F
578285 2023-003 Material Weakness - N
578286 2023-004 Significant Deficiency - F
578287 2023-003 Material Weakness - N
578288 2023-004 Significant Deficiency - F

Programs

ALN Program Spent Major Findings
84.425 Education Stabilization Fund $489,243 Yes 2
84.027 Special Education_grants to States $276,365 - 0
84.010 Title I Grants to Local Educational Agencies $93,063 - 0
84.367 Improving Teacher Quality State Grants $17,427 - 0
10.553 School Breakfast Program $12,797 - 0
84.424 Student Support and Academic Enrichment Program $10,000 - 0
10.555 National School Lunch Program $8,418 - 0
10.649 Pandemic Ebt Administrative Costs $614 - 0

Contacts

Name Title Type
C1N3VF855UN5 John Zoellner Auditee
6163550055 Paul Matz, Cpa, Cgfm Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Black River Public School (the "School") 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 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 School, it is not intended to and does not present the financial position, or changes in net position of the School. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting, which is described in Note 1 to the School's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. 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: N/A

Finding Details

2023-003 - Wage Rate Requirements Finding Type: Material Noncompliance/Material Weakness in Internal Control over Compliance (Special Tests and Provisions). Program: Education Stabilization Fund; U.S. Department of Education; passed through the Michigan Department of Education; Assistance Listing Numbers 84.425D and 84.425U; Award Numbers 213712-2021 and 213713-2122. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on 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 School did not include the federal wage rate requirements in their contracts and did not obtain the required certified payrolls for its contractors subject to the federal rate requirements. Cause. The School did not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. As a result of this condition, the School 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 appropriate prevailing wage documentation amount to $489,293. Recommendation. We recommend that the School 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. Management concurs with the finding. Going forward, if Black River participates in a federally funded project, we will make sure that prevailing wage requirements will be included in the contract.
2023-004 - Equipment and Real Property Management Finding Type: Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Real Property and Equipment Management). Program: Education Stabilization Fund; U.S. Department of Education; passed through the Michigan Department of Education; Assistance Listing Numbers 84.425D and 84.425U; Award Numbers 213712-2021 and 213713-2122. Criteria. The Uniform Guidance requires entities that purchase equipment and real property to maintain records which indicate which of those assets were purchased with federal funds, and to conduct a physical inventory of equipment purchased with federal funds at least once every two years. Condition. The School has not conducted a physical inventory of equipment in accordance with the requirements of the Uniform Guidance. Cause. This condition was caused by a lack of complete understanding of the requirements associated with equipment and real property management. Effect. As a result of this condition, the School did not comply with the requirements of the Uniform Guidance, which could also result in further noncompliance if equipment and real property are disposed in future years as a result of not having completed the physical inventory. Questioned Costs. No costs have been questioned as a result of this finding inasmuch as no disallowed costs were identified. Recommendation. We recommend that the School take physical inventory counts of all equipment and real property purchased with federal funds at least once every two years. View of Responsible Officials. Management concurs with the finding. The School will perform an inventory of equipment purchased with federal funds. Since it is almost November 2023, will try to get this done by June 30, 2024 or definitely in 2024-25.
2023-003 - Wage Rate Requirements Finding Type: Material Noncompliance/Material Weakness in Internal Control over Compliance (Special Tests and Provisions). Program: Education Stabilization Fund; U.S. Department of Education; passed through the Michigan Department of Education; Assistance Listing Numbers 84.425D and 84.425U; Award Numbers 213712-2021 and 213713-2122. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on 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 School did not include the federal wage rate requirements in their contracts and did not obtain the required certified payrolls for its contractors subject to the federal rate requirements. Cause. The School did not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. As a result of this condition, the School 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 appropriate prevailing wage documentation amount to $489,293. Recommendation. We recommend that the School 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. Management concurs with the finding. Going forward, if Black River participates in a federally funded project, we will make sure that prevailing wage requirements will be included in the contract.
2023-004 - Equipment and Real Property Management Finding Type: Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Real Property and Equipment Management). Program: Education Stabilization Fund; U.S. Department of Education; passed through the Michigan Department of Education; Assistance Listing Numbers 84.425D and 84.425U; Award Numbers 213712-2021 and 213713-2122. Criteria. The Uniform Guidance requires entities that purchase equipment and real property to maintain records which indicate which of those assets were purchased with federal funds, and to conduct a physical inventory of equipment purchased with federal funds at least once every two years. Condition. The School has not conducted a physical inventory of equipment in accordance with the requirements of the Uniform Guidance. Cause. This condition was caused by a lack of complete understanding of the requirements associated with equipment and real property management. Effect. As a result of this condition, the School did not comply with the requirements of the Uniform Guidance, which could also result in further noncompliance if equipment and real property are disposed in future years as a result of not having completed the physical inventory. Questioned Costs. No costs have been questioned as a result of this finding inasmuch as no disallowed costs were identified. Recommendation. We recommend that the School take physical inventory counts of all equipment and real property purchased with federal funds at least once every two years. View of Responsible Officials. Management concurs with the finding. The School will perform an inventory of equipment purchased with federal funds. Since it is almost November 2023, will try to get this done by June 30, 2024 or definitely in 2024-25.
2023-003 - Wage Rate Requirements Finding Type: Material Noncompliance/Material Weakness in Internal Control over Compliance (Special Tests and Provisions). Program: Education Stabilization Fund; U.S. Department of Education; passed through the Michigan Department of Education; Assistance Listing Numbers 84.425D and 84.425U; Award Numbers 213712-2021 and 213713-2122. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on 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 School did not include the federal wage rate requirements in their contracts and did not obtain the required certified payrolls for its contractors subject to the federal rate requirements. Cause. The School did not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. As a result of this condition, the School 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 appropriate prevailing wage documentation amount to $489,293. Recommendation. We recommend that the School 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. Management concurs with the finding. Going forward, if Black River participates in a federally funded project, we will make sure that prevailing wage requirements will be included in the contract.
2023-004 - Equipment and Real Property Management Finding Type: Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Real Property and Equipment Management). Program: Education Stabilization Fund; U.S. Department of Education; passed through the Michigan Department of Education; Assistance Listing Numbers 84.425D and 84.425U; Award Numbers 213712-2021 and 213713-2122. Criteria. The Uniform Guidance requires entities that purchase equipment and real property to maintain records which indicate which of those assets were purchased with federal funds, and to conduct a physical inventory of equipment purchased with federal funds at least once every two years. Condition. The School has not conducted a physical inventory of equipment in accordance with the requirements of the Uniform Guidance. Cause. This condition was caused by a lack of complete understanding of the requirements associated with equipment and real property management. Effect. As a result of this condition, the School did not comply with the requirements of the Uniform Guidance, which could also result in further noncompliance if equipment and real property are disposed in future years as a result of not having completed the physical inventory. Questioned Costs. No costs have been questioned as a result of this finding inasmuch as no disallowed costs were identified. Recommendation. We recommend that the School take physical inventory counts of all equipment and real property purchased with federal funds at least once every two years. View of Responsible Officials. Management concurs with the finding. The School will perform an inventory of equipment purchased with federal funds. Since it is almost November 2023, will try to get this done by June 30, 2024 or definitely in 2024-25.
2023-003 - Wage Rate Requirements Finding Type: Material Noncompliance/Material Weakness in Internal Control over Compliance (Special Tests and Provisions). Program: Education Stabilization Fund; U.S. Department of Education; passed through the Michigan Department of Education; Assistance Listing Numbers 84.425D and 84.425U; Award Numbers 213712-2021 and 213713-2122. Criteria. The Uniform Guidance requires that all laborers and mechanics employed by contractors to work on 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 School did not include the federal wage rate requirements in their contracts and did not obtain the required certified payrolls for its contractors subject to the federal rate requirements. Cause. The School did not have the proper internal controls in place to ensure that all contracts awarded have complied with federal requirements. Effect. As a result of this condition, the School 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 appropriate prevailing wage documentation amount to $489,293. Recommendation. We recommend that the School 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. Management concurs with the finding. Going forward, if Black River participates in a federally funded project, we will make sure that prevailing wage requirements will be included in the contract.
2023-004 - Equipment and Real Property Management Finding Type: Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Real Property and Equipment Management). Program: Education Stabilization Fund; U.S. Department of Education; passed through the Michigan Department of Education; Assistance Listing Numbers 84.425D and 84.425U; Award Numbers 213712-2021 and 213713-2122. Criteria. The Uniform Guidance requires entities that purchase equipment and real property to maintain records which indicate which of those assets were purchased with federal funds, and to conduct a physical inventory of equipment purchased with federal funds at least once every two years. Condition. The School has not conducted a physical inventory of equipment in accordance with the requirements of the Uniform Guidance. Cause. This condition was caused by a lack of complete understanding of the requirements associated with equipment and real property management. Effect. As a result of this condition, the School did not comply with the requirements of the Uniform Guidance, which could also result in further noncompliance if equipment and real property are disposed in future years as a result of not having completed the physical inventory. Questioned Costs. No costs have been questioned as a result of this finding inasmuch as no disallowed costs were identified. Recommendation. We recommend that the School take physical inventory counts of all equipment and real property purchased with federal funds at least once every two years. View of Responsible Officials. Management concurs with the finding. The School will perform an inventory of equipment purchased with federal funds. Since it is almost November 2023, will try to get this done by June 30, 2024 or definitely in 2024-25.