Audit 289375

FY End
2023-06-30
Total Expended
$122.21M
Findings
2
Programs
30
Year: 2023 Accepted: 2024-02-08

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
366538 2023-001 Significant Deficiency - N
942980 2023-001 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
84.425 Covid-19 - Education Stabilization Fund $39.21M Yes 1
84.063 Federal Pell Grant Program $25.84M - 0
84.268 Federal Direct Student Loans $13.72M - 0
84.048 Career and Technical Education -- Basic Grants to States $1.90M - 0
10.553 School Breakfast Program $1.89M Yes 0
84.424 Student Support and Academic Enrichment Program $1.42M - 0
84.367 Improving Teacher Quality State Grants $1.34M - 0
84.007 Federal Supplemental Educational Opportunity Grants $1.07M - 0
84.365 English Language Acquisition State Grants $1.03M - 0
10.555 National School Lunch Program $815,789 Yes 0
84.027 Special Education_grants to States $730,128 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $560,000 - 0
10.559 Summer Food Service Program for Children $389,803 Yes 0
84.002 Adult Education - Basic Grants to States $334,110 - 0
10.582 Fresh Fruit and Vegetable Program $296,650 Yes 0
17.268 H-1b Job Training Grants $212,731 - 0
84.173 Special Education_preschool Grants $189,249 - 0
84.033 Federal Work-Study Program $110,733 - 0
10.185 Local Food for School $84,210 - 0
93.778 Medical Assistance Program $46,066 - 0
93.310 Trans-Nih Research Support $45,057 - 0
93.859 Biomedical Research and Research Training $43,988 - 0
17.258 Wia Adult Program $30,728 - 0
81.117 Energy Efficiency and Renewable Energy Information Dissemination, Outreach, Training and Technical Analysis/assistance $30,092 - 0
84.215 Fund for the Improvement of Education $19,137 - 0
47.076 Education and Human Resources $18,016 - 0
84.010 Title I Grants to Local Educational Agencies $14,352 - 0
10.579 Child Nutrition Discretionary Grants Limited Availability $10,000 - 0
10.649 Covid-19 - Pandemic Ebt Administrative Costs $5,950 - 0
17.285 Apprenticeship USA Grants $226 - 0

Contacts

Name Title Type
MCNTVJKULZE1 Thomas Wall Auditee
3138270304 Jeffrey C. Higgins Auditor
No contacts on file

Notes to SEFA

Title: Adjustments and Transfers Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of School District of the City of Dearborn, Michigan (the “School District”) 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 (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of the School District, it is not intended to and does not present the financial position, changes in net position, or cash flows of the School District. Expenditures reported in the Schedule are reported on the same basis of accounting as the basic financial statements. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The pass through entity identifying numbers are presented where available. The School District has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. As allowable and in accordance with federal regulations issued by the U.S. Department of Education, the School District carried forward $51,112 of the 2021‑2022 Federal Supplemental Educational Opportunity Grants (SEOG) (84.007) award, which it spent in the 2022‑2023 award year. The School District also carried forward $68,738 of the 2022‑2023 SEOG award, which will be spent in the 2023‑2024 award year. In addition, the School District transferred $404,824 of the 2022‑2023 Federal Work‑Study Program (84.033) award to the SEOG award, which it expended in the 2022‑2023 award year.
Title: Grant Auditor Report Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of School District of the City of Dearborn, Michigan (the “School District”) 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 (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of the School District, it is not intended to and does not present the financial position, changes in net position, or cash flows of the School District. Expenditures reported in the Schedule are reported on the same basis of accounting as the basic financial statements. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The pass through entity identifying numbers are presented where available. The School District has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Management has utilized the Michigan Department of Education NexSys Grant Auditor Report (GAR) in preparing the schedule of expenditures of federal awards. Differences, if any, between the GAR and the schedule of expenditures of federal awards relate to the timing of payments and the fiscal year to which the payments relate.
Title: Noncash Assistance Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of School District of the City of Dearborn, Michigan (the “School District”) 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 (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of the School District, it is not intended to and does not present the financial position, changes in net position, or cash flows of the School District. Expenditures reported in the Schedule are reported on the same basis of accounting as the basic financial statements. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The pass through entity identifying numbers are presented where available. The School District has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The value of the noncash assistance received was determined in accordance with the provisions of the Uniform Guidance and is reported on the schedule of federal expenditures.

Finding Details

Assistance Listing Number, Federal Agency, and Program Name 84.425U, U.S. Department of Education, COVID 19 ARP ESSER III Funds Formula Federal Award Identification Number and Year 213713 Pass through Entity Michigan Department of Education Finding Type Significant deficiency and material noncompliance with laws and regulations Repeat Finding No Criteria Approved construction projects must comply with applicable Uniform Guidance requirements, as well as the department’s regulations regarding construction at 34 CFR § 76.600. As is the case with all remodeling or construction contracts using laborers and mechanics financed by federal education funds, an LEA that uses ESSER or GEER funds for minor remodeling, renovation, repair, or construction contracts over $2,000 must meet all Davis Bacon prevailing wage requirements and include language in the contracts that all contractors or subcontractors must pay wages that are no less than those established for the locality of the project (prevailing wage rates). (See 20 U.S.C. 1232b Labor Standards.) (See also FAQ B 6.) Condition During testing of the grant, we noted the School District utilized funds from the Education Stabilization Funds (ESF) for minor remodeling and renovations of the school buildings. Per the 2023 Compliance Supplement, recipients and subrecipients that use ESF for minor remodeling, renovation, or construction contracts that are over $2,000 and use laborers and mechanics must meet Davis Bacon prevailing wage requirements. We noted the School District expended approximately $168,000 in ESSER funds that related to repairs and renovations out of a total of approximately $11,800,000 in ESSER construction funds that did not include the prevailing wage requirement within the contract’s language. This was one contract during changeover of construction administration that missed the bid language, however, was paid at prevailing wages. Questioned Costs None Identification of How Questioned Costs Were Computed N/A No questioned costs Context We noted one of three samples tested for repairs and renovation contracts charged to the ESSER III grant did not include prevailing wage language. The omission occurred during a transition period in the procurement process. The School District verified that the referenced contract prevailing wages were actually paid. Cause and Effect Excluding the prevailing wage rate language in contracts could cause contractors using federal dollars to not pay appropriate wages to their employees. The School District not receiving or reviewing the certified payroll reports from contractors could lead to nondetection of contractors not paying their employees at prevailing wage rates or in accordance with contract provisions. Recommendation We recommend the School District ensure contracts with vendors that are performing repairs, construction, renovations, etc. include the prevailing wage rate language in the contract and that the School District have a process and control in place to ensure that certified payroll reports from the contractors are being received and reviewed by the School District timely. Views of Responsible Officials and Corrective Action Plan As it pertains to the use of any federal funds for construction projects in the School District, when said funds will be used to compensate for labor for any construction project, the School District will stipulate Davis Bacon requirements for prevailing wages as it relates to the use of laborers and mechanics for all projects over $2,000.
Assistance Listing Number, Federal Agency, and Program Name 84.425U, U.S. Department of Education, COVID 19 ARP ESSER III Funds Formula Federal Award Identification Number and Year 213713 Pass through Entity Michigan Department of Education Finding Type Significant deficiency and material noncompliance with laws and regulations Repeat Finding No Criteria Approved construction projects must comply with applicable Uniform Guidance requirements, as well as the department’s regulations regarding construction at 34 CFR § 76.600. As is the case with all remodeling or construction contracts using laborers and mechanics financed by federal education funds, an LEA that uses ESSER or GEER funds for minor remodeling, renovation, repair, or construction contracts over $2,000 must meet all Davis Bacon prevailing wage requirements and include language in the contracts that all contractors or subcontractors must pay wages that are no less than those established for the locality of the project (prevailing wage rates). (See 20 U.S.C. 1232b Labor Standards.) (See also FAQ B 6.) Condition During testing of the grant, we noted the School District utilized funds from the Education Stabilization Funds (ESF) for minor remodeling and renovations of the school buildings. Per the 2023 Compliance Supplement, recipients and subrecipients that use ESF for minor remodeling, renovation, or construction contracts that are over $2,000 and use laborers and mechanics must meet Davis Bacon prevailing wage requirements. We noted the School District expended approximately $168,000 in ESSER funds that related to repairs and renovations out of a total of approximately $11,800,000 in ESSER construction funds that did not include the prevailing wage requirement within the contract’s language. This was one contract during changeover of construction administration that missed the bid language, however, was paid at prevailing wages. Questioned Costs None Identification of How Questioned Costs Were Computed N/A No questioned costs Context We noted one of three samples tested for repairs and renovation contracts charged to the ESSER III grant did not include prevailing wage language. The omission occurred during a transition period in the procurement process. The School District verified that the referenced contract prevailing wages were actually paid. Cause and Effect Excluding the prevailing wage rate language in contracts could cause contractors using federal dollars to not pay appropriate wages to their employees. The School District not receiving or reviewing the certified payroll reports from contractors could lead to nondetection of contractors not paying their employees at prevailing wage rates or in accordance with contract provisions. Recommendation We recommend the School District ensure contracts with vendors that are performing repairs, construction, renovations, etc. include the prevailing wage rate language in the contract and that the School District have a process and control in place to ensure that certified payroll reports from the contractors are being received and reviewed by the School District timely. Views of Responsible Officials and Corrective Action Plan As it pertains to the use of any federal funds for construction projects in the School District, when said funds will be used to compensate for labor for any construction project, the School District will stipulate Davis Bacon requirements for prevailing wages as it relates to the use of laborers and mechanics for all projects over $2,000.