Audit 7151

FY End
2023-06-30
Total Expended
$2.14M
Findings
8
Programs
11
Organization: Hesperia Community Schools (MI)
Year: 2023 Accepted: 2023-12-18

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
4926 2023-005 Significant Deficiency - B
4927 2023-005 Significant Deficiency - B
4928 2023-006 Material Weakness - B
4929 2023-006 Material Weakness - B
581368 2023-005 Significant Deficiency - B
581369 2023-005 Significant Deficiency - B
581370 2023-006 Material Weakness - B
581371 2023-006 Material Weakness - B

Programs

ALN Program Spent Major Findings
84.425 Education Stabilization Fund $1.15M Yes 2
84.010 Title I Grants to Local Educational Agencies $202,828 - 0
10.553 School Breakfast Program $139,075 - 0
84.027 Special Education_grants to States $67,164 - 0
84.367 Improving Teacher Quality State Grants $23,770 - 0
84.358 Rural Education $17,476 - 0
84.424 Student Support and Academic Enrichment Program $10,109 - 0
10.185 Local Food for Schools $3,576 - 0
10.555 National School Lunch Program $635 - 0
10.649 Pandemic Ebt Administrative Costs $628 - 0
10.665 Schools and Roads - Grants to States $225 - 0

Contacts

Name Title Type
MNLBTDYVKJD9 Pat Budde Auditee
2318546185 Kim Lindsay, Cpa, Cgma Auditor
No contacts on file

Notes to SEFA

Title: ADJUSTMENT Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Hesperia 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. 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% de minimis cost rate as permitted by §200.414 of the Uniform Guidance. The COVID-19 - ARP ESSER II Formula grant revenue has been adjusted by $18,336 to account for prior year grant expenditures not reported on the prior year Schedule. This adjustment has been recorded as revenue on the current year Schedule and the financial statements.

Finding Details

Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Education Stabilization Fund; U.S. Department of Education; Assistance Listing Number 84.425; Passed through Michigan Department of Education (MDE); Project numbers 213782-2223 and 213713-2122. Criteria. Section 200.430(i)(1) of the Uniform Grant Guidance states that; Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; and (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition. During testing of payroll disbursements, it was noted that: 1) no documentation was found to support the $50.00 per run summer bus driver rate or the $500 stipend bonus paid to summer bus drivers, and 2) Two of the contracts selected were pro-rated for late start (total hours expected) and for number of pay periods spread). The amounts were eventually recalculated with available documents, but the initial calculation of the pro-ration was not retained by management. Cause. The cause of this condition appears to be that the former business manager did not take due care in making sure that documentation existed to support the salaries and wages being charged to the program. Effect. Certain of the District's federal expenditures were not documented in accordance with the Uniform Guidance. Questioned Costs. No costs were required to be questioned based on our testing. Recommendation. We recommend that the District staff in charge of payroll administration familiarize themselves with the documentation requirements of the Uniform Guidance and retain supporting documentation to support the payroll costs charged to federal awards. View of Responsible Officials. We concur with the audit assessment regarding this matter.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Education Stabilization Fund; U.S. Department of Education; Assistance Listing Number 84.425; Passed through Michigan Department of Education (MDE); Project numbers 213782-2223 and 213713-2122. Criteria. Section 200.430(i)(1) of the Uniform Grant Guidance states that; Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; and (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition. During testing of payroll disbursements, it was noted that: 1) no documentation was found to support the $50.00 per run summer bus driver rate or the $500 stipend bonus paid to summer bus drivers, and 2) Two of the contracts selected were pro-rated for late start (total hours expected) and for number of pay periods spread). The amounts were eventually recalculated with available documents, but the initial calculation of the pro-ration was not retained by management. Cause. The cause of this condition appears to be that the former business manager did not take due care in making sure that documentation existed to support the salaries and wages being charged to the program. Effect. Certain of the District's federal expenditures were not documented in accordance with the Uniform Guidance. Questioned Costs. No costs were required to be questioned based on our testing. Recommendation. We recommend that the District staff in charge of payroll administration familiarize themselves with the documentation requirements of the Uniform Guidance and retain supporting documentation to support the payroll costs charged to federal awards. View of Responsible Officials. We concur with the audit assessment regarding this matter.
Finding Type. Immaterial Noncompliance/Material Weakness in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Education Stabilization Fund; U.S. Department of Education; Assistance Listing Number 84.425; Passed through Michigan Department of Education (MDE); Project numbers 213782-2223 and 213713-2122. Criteria. Section 200.431(g) of the Uniform Grant Guidance states that; Pension plan costs which are incurred in accordance with the established policies of the non-Federal entity are allowable, provided that: (1) Such policies meet the test of reasonableness. (2) The methods of cost allocation are not discriminatory. (3) For entities using accrual based accounting, the cost assigned to each fiscal year is determined in accordance with GAAP. Condition. During testing of fringe benefit rates, as a percentage of total salaries and wages, we noted that the rate of retirement costs was significantly greater than the rate noted at the District-wide level. Management did not have a supporting calculation for the amount of retirement costs charge to the federal program. Cause. The cause of this condition appears to be that the former business manager did not take due care in making sure that documentation existed to support the fringe benefit costs being charged to the program. Effect. Certain of the District's federal expenditures were not documented in accordance with the Uniform Guidance. Questioned Costs. The amount charged to the program exceeded the estimated allowable cost by $36,019. Recommendation. We recommend that the District staff in charge of payroll administration familiarize themselves with the documentation requirements of the Uniform Guidance and retain supporting documentation to support the fringe benefit costs charged to federal awards. View of Responsible Officials. We concur with the audit assessment regarding this matter.
Finding Type. Immaterial Noncompliance/Material Weakness in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Education Stabilization Fund; U.S. Department of Education; Assistance Listing Number 84.425; Passed through Michigan Department of Education (MDE); Project numbers 213782-2223 and 213713-2122. Criteria. Section 200.431(g) of the Uniform Grant Guidance states that; Pension plan costs which are incurred in accordance with the established policies of the non-Federal entity are allowable, provided that: (1) Such policies meet the test of reasonableness. (2) The methods of cost allocation are not discriminatory. (3) For entities using accrual based accounting, the cost assigned to each fiscal year is determined in accordance with GAAP. Condition. During testing of fringe benefit rates, as a percentage of total salaries and wages, we noted that the rate of retirement costs was significantly greater than the rate noted at the District-wide level. Management did not have a supporting calculation for the amount of retirement costs charge to the federal program. Cause. The cause of this condition appears to be that the former business manager did not take due care in making sure that documentation existed to support the fringe benefit costs being charged to the program. Effect. Certain of the District's federal expenditures were not documented in accordance with the Uniform Guidance. Questioned Costs. The amount charged to the program exceeded the estimated allowable cost by $36,019. Recommendation. We recommend that the District staff in charge of payroll administration familiarize themselves with the documentation requirements of the Uniform Guidance and retain supporting documentation to support the fringe benefit costs charged to federal awards. View of Responsible Officials. We concur with the audit assessment regarding this matter.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Education Stabilization Fund; U.S. Department of Education; Assistance Listing Number 84.425; Passed through Michigan Department of Education (MDE); Project numbers 213782-2223 and 213713-2122. Criteria. Section 200.430(i)(1) of the Uniform Grant Guidance states that; Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; and (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition. During testing of payroll disbursements, it was noted that: 1) no documentation was found to support the $50.00 per run summer bus driver rate or the $500 stipend bonus paid to summer bus drivers, and 2) Two of the contracts selected were pro-rated for late start (total hours expected) and for number of pay periods spread). The amounts were eventually recalculated with available documents, but the initial calculation of the pro-ration was not retained by management. Cause. The cause of this condition appears to be that the former business manager did not take due care in making sure that documentation existed to support the salaries and wages being charged to the program. Effect. Certain of the District's federal expenditures were not documented in accordance with the Uniform Guidance. Questioned Costs. No costs were required to be questioned based on our testing. Recommendation. We recommend that the District staff in charge of payroll administration familiarize themselves with the documentation requirements of the Uniform Guidance and retain supporting documentation to support the payroll costs charged to federal awards. View of Responsible Officials. We concur with the audit assessment regarding this matter.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Education Stabilization Fund; U.S. Department of Education; Assistance Listing Number 84.425; Passed through Michigan Department of Education (MDE); Project numbers 213782-2223 and 213713-2122. Criteria. Section 200.430(i)(1) of the Uniform Grant Guidance states that; Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; and (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition. During testing of payroll disbursements, it was noted that: 1) no documentation was found to support the $50.00 per run summer bus driver rate or the $500 stipend bonus paid to summer bus drivers, and 2) Two of the contracts selected were pro-rated for late start (total hours expected) and for number of pay periods spread). The amounts were eventually recalculated with available documents, but the initial calculation of the pro-ration was not retained by management. Cause. The cause of this condition appears to be that the former business manager did not take due care in making sure that documentation existed to support the salaries and wages being charged to the program. Effect. Certain of the District's federal expenditures were not documented in accordance with the Uniform Guidance. Questioned Costs. No costs were required to be questioned based on our testing. Recommendation. We recommend that the District staff in charge of payroll administration familiarize themselves with the documentation requirements of the Uniform Guidance and retain supporting documentation to support the payroll costs charged to federal awards. View of Responsible Officials. We concur with the audit assessment regarding this matter.
Finding Type. Immaterial Noncompliance/Material Weakness in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Education Stabilization Fund; U.S. Department of Education; Assistance Listing Number 84.425; Passed through Michigan Department of Education (MDE); Project numbers 213782-2223 and 213713-2122. Criteria. Section 200.431(g) of the Uniform Grant Guidance states that; Pension plan costs which are incurred in accordance with the established policies of the non-Federal entity are allowable, provided that: (1) Such policies meet the test of reasonableness. (2) The methods of cost allocation are not discriminatory. (3) For entities using accrual based accounting, the cost assigned to each fiscal year is determined in accordance with GAAP. Condition. During testing of fringe benefit rates, as a percentage of total salaries and wages, we noted that the rate of retirement costs was significantly greater than the rate noted at the District-wide level. Management did not have a supporting calculation for the amount of retirement costs charge to the federal program. Cause. The cause of this condition appears to be that the former business manager did not take due care in making sure that documentation existed to support the fringe benefit costs being charged to the program. Effect. Certain of the District's federal expenditures were not documented in accordance with the Uniform Guidance. Questioned Costs. The amount charged to the program exceeded the estimated allowable cost by $36,019. Recommendation. We recommend that the District staff in charge of payroll administration familiarize themselves with the documentation requirements of the Uniform Guidance and retain supporting documentation to support the fringe benefit costs charged to federal awards. View of Responsible Officials. We concur with the audit assessment regarding this matter.
Finding Type. Immaterial Noncompliance/Material Weakness in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Education Stabilization Fund; U.S. Department of Education; Assistance Listing Number 84.425; Passed through Michigan Department of Education (MDE); Project numbers 213782-2223 and 213713-2122. Criteria. Section 200.431(g) of the Uniform Grant Guidance states that; Pension plan costs which are incurred in accordance with the established policies of the non-Federal entity are allowable, provided that: (1) Such policies meet the test of reasonableness. (2) The methods of cost allocation are not discriminatory. (3) For entities using accrual based accounting, the cost assigned to each fiscal year is determined in accordance with GAAP. Condition. During testing of fringe benefit rates, as a percentage of total salaries and wages, we noted that the rate of retirement costs was significantly greater than the rate noted at the District-wide level. Management did not have a supporting calculation for the amount of retirement costs charge to the federal program. Cause. The cause of this condition appears to be that the former business manager did not take due care in making sure that documentation existed to support the fringe benefit costs being charged to the program. Effect. Certain of the District's federal expenditures were not documented in accordance with the Uniform Guidance. Questioned Costs. The amount charged to the program exceeded the estimated allowable cost by $36,019. Recommendation. We recommend that the District staff in charge of payroll administration familiarize themselves with the documentation requirements of the Uniform Guidance and retain supporting documentation to support the fringe benefit costs charged to federal awards. View of Responsible Officials. We concur with the audit assessment regarding this matter.