Audit 13323

FY End
2023-06-30
Total Expended
$4.68M
Findings
4
Programs
14
Organization: Airport Community Schools (MI)
Year: 2023 Accepted: 2024-01-24

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
9643 2023-002 Material Weakness Yes N
9644 2023-002 Material Weakness Yes N
586085 2023-002 Material Weakness Yes N
586086 2023-002 Material Weakness Yes N

Contacts

Name Title Type
WJWWENEB46L1 Theresa Carrrell Auditee
7346544021 Nathan C. Baldermann, Cpa, Cgfm 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 Airport Community 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 or 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 following schedule reconciles federal sources reported in the financial statements to the expenditures reported on the schedule of expenditures of federal awards:
Title: PASS-THROUGH AGENCIES Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Airport Community 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 or 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:

Finding Details

2023-002 – Special Tests and Provisions – Wage Rate Requirements (Repeat) 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 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. While the contract contained the required Wage Rate Requirement provision, the District did not obtain the required certified payrolls for one out of the ten vendors selected for testing. Cause. The District does not have the proper internal controls in place to ensure that certified payrolls were being obtained for all construction contracts charged to the grant. Effect. The District did not follow federal requirements to obtain weekly certified payrolls. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $134,725. Recommendation. We recommend that the District reviews its policies to ensure certified payrolls are obtained whenever federal funds are used. View of Responsible Officials. District officials will ensure that weekly certified payrolls are obtained when required. Responsible Official. Chief Financial Officer Estimated Completion Date. June 30, 2024
2023-002 – Special Tests and Provisions – Wage Rate Requirements (Repeat) 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 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. While the contract contained the required Wage Rate Requirement provision, the District did not obtain the required certified payrolls for one out of the ten vendors selected for testing. Cause. The District does not have the proper internal controls in place to ensure that certified payrolls were being obtained for all construction contracts charged to the grant. Effect. The District did not follow federal requirements to obtain weekly certified payrolls. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $134,725. Recommendation. We recommend that the District reviews its policies to ensure certified payrolls are obtained whenever federal funds are used. View of Responsible Officials. District officials will ensure that weekly certified payrolls are obtained when required. Responsible Official. Chief Financial Officer Estimated Completion Date. June 30, 2024
2023-002 – Special Tests and Provisions – Wage Rate Requirements (Repeat) 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 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. While the contract contained the required Wage Rate Requirement provision, the District did not obtain the required certified payrolls for one out of the ten vendors selected for testing. Cause. The District does not have the proper internal controls in place to ensure that certified payrolls were being obtained for all construction contracts charged to the grant. Effect. The District did not follow federal requirements to obtain weekly certified payrolls. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $134,725. Recommendation. We recommend that the District reviews its policies to ensure certified payrolls are obtained whenever federal funds are used. View of Responsible Officials. District officials will ensure that weekly certified payrolls are obtained when required. Responsible Official. Chief Financial Officer Estimated Completion Date. June 30, 2024
2023-002 – Special Tests and Provisions – Wage Rate Requirements (Repeat) 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 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. While the contract contained the required Wage Rate Requirement provision, the District did not obtain the required certified payrolls for one out of the ten vendors selected for testing. Cause. The District does not have the proper internal controls in place to ensure that certified payrolls were being obtained for all construction contracts charged to the grant. Effect. The District did not follow federal requirements to obtain weekly certified payrolls. Questioned Costs. The total charges that were not supported by allowable documentation amounted to $134,725. Recommendation. We recommend that the District reviews its policies to ensure certified payrolls are obtained whenever federal funds are used. View of Responsible Officials. District officials will ensure that weekly certified payrolls are obtained when required. Responsible Official. Chief Financial Officer Estimated Completion Date. June 30, 2024