Northwest Allen County SchoolsLocal Government

FINDING 2025-001 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program Assistance Listings Numbers: 10.553, 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 23-24, FY 24-25 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Significant Deficiency INDIANA STATE BOARD OF ACCOUNTS 15 NORTHWEST ALLEN COUNTY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-002. Condition and Context Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation and inspection of supporting documentation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, it was identified that the School Corporation did not have internal controls in place to ensure that its policies and procedures over suspension and debarment were completed. The lack of effective internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause A proper system of internal controls was not designed and implemented by management of the School Corporation. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. INDIANA STATE BOARD OF ACCOUNTS 16 NORTHWEST ALLEN COUNTY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls to ensure that its policies and procedures over suspension and debarment were completed. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2023-001 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY 21-22, FY 22-23 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. Eligibility Any child enrolled in a participating school who meets the applicable program's definition of "child," may receive meals under the applicable program. In the case of the National School Lunch Program and School Breakfast Program, children belonging to households meeting nationwide income eligibility requirements may receive meals at no charge or at reduced price. As a general rule, a child's eligibility for free or reduced-price meals under a Child Nutrition Cluster program may be established by the submission of an annual application or statement which furnishes such information as family income and family size. Additionally, a child may be direct certified. For a direct certification, annual eligibility determinations are based on the child's household receiving benefits under SNAP, FDPIR, the Head Start Program (ALN 93.600), or, under most circumstances, the TANF program (ALN 93.558). A household may furnish documentation of its participation in one of these programs; or the school may obtain the information directly from the state or local agency that administers these programs. Direct certified households do not need to complete an application. The Food Service Assistant Director downloaded the direct certification import files from the Indiana Department of Education's CNP website and imported them directly into the School Corporation's POS system that tracks student eligibility statuses for free and reduced-price meals. The direct certification import files were then saved on a drive where the Food Service Director could access them; however, there was no review or approval process over the direct certification import process to ensure data was properly imported. Reporting The School Corporation must submit monthly sponsor claims for reimbursement (claims) for meals and snacks served to eligible students within 60 days following the last day of the month covered by the claim. Claims were submitted to the Indiana Department of Education as required; however, the claims were prepared by one employee without a review or approval process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2023-002 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY 21-22, FY22-23 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context Procurement When the value of goods or services exceeds the simplified acquisition threshold, the proper purchasing method would be the bidding process, unless the purchase meets certain other qualifications. Federal regulations allow for informal procurement methods when the value of the procurement for goods or services does not exceed the simplified acquisition threshold, which is customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds: micro-purchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micropurchase threshold but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. If it is determined a single source provider can be used for a small purchase, documentation must be retained supporting the determination. During fiscal year 2022-2023, the School Corporation purchased five ovens, totaling $311,705, from one vendor. As the cost of the ovens was in excess of $150,000, the proper procurement method would have been the formal bid process; however, the School Corporation only obtained quotes. Additionally, there was no contract between the School Corporation and this vendor. The lack of effective internal controls and noncompliance was isolated to the purchase noted above. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed that the Food Service Director obtained verification from the vendors to ensure they are not suspended or debarred prior to entering into covered transaction. There were ten covered transactions, totaling $830,842, that equaled or exceeded $25,000 identified. Two covered transactions were selected for testing. For one of the two covered transactions tested, totaling $69,560, the School Corporation had not performed procedures that ensured the vendor was not suspended or debarred or otherwise excluded or disqualified from participating in federal assistance programs. The identified lack of internal controls and noncompliance was isolated to 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.318 states in part: "(a) The non-Federal entity must have and use documented procurement procedures, consistent with State, local, and tribal laws and regulations and the standards of this section, for the acquisition of property or services required under a Federal award or subaward. The non-Federal entity's documented procurement procedures must conform to the procurement standards identified in §§ 200.317 through 200.327. . . . (i) The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: Rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. . . ." 2 CFR 200.320 states in part: "The non-Federal entity must have and use documented procurement procedures, consistent with the standards of this section and §§ 200.317, 200.318, and 200.319 for any of the following methods of procurement used for the acquisition of property or services required under a Federal award or sub-award. (a) Informal procurement methods. When the value of the procurement for property or services under a Federal award does not exceed the simplified acquisition threshold (SAT), as defined in § 200.1, or a lower threshold established by a non-Federal entity, formal procurement methods are not required. The non-Federal entity may use informal procurement methods to expedite the completion of its transactions and minimize the associated administrative burden and cost. . . . (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with § 200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non- Federal entity determines to be appropriate: (1) Sealed bids. A procurement method in which bids are publicly solicited and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bids method is the preferred method for procuring construction, if the conditions. (i) In order for sealed bidding to be feasible, the following conditions should be present: (A) A complete, adequate, and realistic specification or purchase description is available; (B) Two or more responsible bidders are willing and able to compete effectively for the business; and (C) The procurement lends itself to a firm fixed price contract and the selection of the successful bidder can be made principally on the basis of price. (ii) If sealed bids are used, the following requirements apply: (A) Bids must be solicited from an adequate number of qualified sources, providing them sufficient response time prior to the date set for opening the bids, for local, and tribal governments, the invitation for bids must be publicly advertised; (B) The invitation for bids, which will include any specifications and pertinent attachments, must define the items or services in order for the bidder to properly respond; (C) All bids will be opened at the time and place prescribed in the invitation for bids, and for local and tribal governments, the bids must be opened publicly; (D) A firm fixed price contract award will be made in writing to the lowest responsive and responsible bidder. Where specified in bidding documents, factors such as discounts, transportation cost, and life cycle costs must be considered in determining which bid is lowest. Payment discounts will only be used to determine the low bid when prior experience indicates that such discounts are usually taken advantage of; and (E) Any or all bids may be rejected if there is a sound documented reason. (2) Proposals. A procurement method in which either a fixed price or costreimbursement type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. They are awarded in accordance with the following requirements: (i) Requests for proposals must be publicized and identify all evaluation factors and their relative importance. Proposals must be solicited from an adequate number of qualified offerors. Any response to publicized requests for proposals must be considered to the maximum extent practical; (ii) The non-Federal entity must have a written method for conducting technical evaluations of the proposals received and making selections; (iii) Contracts must be awarded to the responsible offeror whose proposal is most advantageous to the non-Federal entity, with price and other factors considered; and (iv) The non-Federal entity may use competitive proposal procedures for qualifications-based procurement of architectural/engineering (A/E) professional services whereby offeror's qualifications are evaluated, and the most qualified offeror is selected, subject to negotiation of fair and reasonable compensation. The method, where price is not used as a selection factor, can only be used in procurement of A/E professional services. It cannot be used to purchase other types of services though A/E firms that are a potential source to perform the proposed effort. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the improper procurement method was utilized for one vendor and a vendor to whom payments equal to or in excess of $25,000 were made was not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that the proper procurement method is used for purchase and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any contracts or subawards. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2021-001 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles and Program Income Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, COVID-19 - School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years or Other Identifying Numbers: FY 19-20, FY 20-21, FY 2020-2021 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Allowable Costs/Cost Principles, Program Income Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles and the Program Income compliance requirements. The School Corporation paid for employee salary and benefits from the Child Nutrition Cluster programs without adequate documentation to support that the amount paid was an allowable cost of the federal program. Documentation supporting the employee time charged for custodians, secretaries, and aides was not properly maintained. All transactions related to employees' salaries and benefits paid from Fund 800, the School Lunch fund, were reviewed. Each employee had a specific percentage of their pay charged without documentation of a proper time study or actual hours worked on the program. The same percentage was used each pay period. In addition, fringe benefits that were directly associated with the payroll were paid. The amount of questioned costs identified was $220,931, which was the entire amount paid for the noted employees' salaries and benefits by the School Lunch fund. Additionally, the School Corporation paid for trash removal services from the Child Nutrition Cluster programs without adequate documentation to support the amount paid was an allowable cost of the federal program. All transactions related to trash removal services paid from Fund 800, the School Lunch fund, were reviewed. In all cases, the amount paid was based on a percentage from a time study; however, the documentation for the time study was insufficient. The amount of questioned costs identified was $23,815, which was the entire amount paid for trash removal services by the Child Nutrition Cluster programs. Because these were not allowable costs, it is also not a proper use of Program Income. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for documentation of Personnel Expenses (1) 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 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 (for IHE, this per the IHE's definition of IBS); . . . (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. . . ." 2 CFR 200.307(e) states in part: "Use of program income. If the Federal awarding agency does not specify in its regulations or the terms and conditions of the Federal award, or give prior approval for how program income is to be used, paragraph (e)(1) of this section must apply. For Federal awards made to IHEs and nonprofit research institutions, if the Federal awarding agency does not specify in its regulations or the terms and conditions of the Federal award how program income is to be used, paragraph (e)(2) of this section must apply. In specifying alternatives to paragraphs (e)(1) and (2) of this section, the Federal awarding agency may distinguish between income earned by the recipient and income earned by subrecipients and between the sources, kinds, or amounts of income. When the Federal awarding agency authorizes the approaches in paragraphs (e)(2) and (3) of this section, program income in excess of any amounts specified must also be deducted from expenditures. (1) Deduction. Ordinarily program income must be deducted from total allowable costs to determine the net allowable costs. Program income must be used for current costs unless the Federal awarding agency authorizes otherwise. Program income that the non-Federal entity did not anticipate at the time of the Federal award must be used to reduce the Federal award and non-Federal entity contributions rather than to increase the funds committed to the project. . . ." Cause Management had not developed a system of internal control that would have ensured compliance with the grant agreement and the compliance requirements listed above. Effect The failure to establish an effective internal control system enabled noncompliance with the grant agreement and the Allowable Costs/Cost Principles and the Program Income compliance requirements. Questioned Costs Questioned costs identified are $244,746. Recommendation We recommended that the School Corporation's management establish a system of internal control to ensure compliance and comply with the Allowable Costs/Cost Principles and the Program Income compliance requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2019-001 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies CFDA Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A160014, S010A170014, S010A180014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Annual Report Card, High School Graduation Rate Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 13 NORTHWEST ALLEN COUNTY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirement. There was a lack of internal control in place to ensure that real time enrollment reports accurately represented the student population of the School Corporation. For fiscal year 2017-2018, there were four students tested where the system reported the student as transferred out of the School Corporation, but were actually still enrolled in or had graduated from the School Corporation. For 2018-2019, the Indiana Department of Education tested the real-time reports and stated that six students lacked proper documentation supporting their enrollment status. These reports are used for various statistical purposes. The lack of controls and noncompliance was a systemic problem, occurring throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 34 CFR 200.19(b) states in part: "High schools? (1) Graduation rate. Consistent with paragraphs (b)(4) and (b)(5) of this section regarding reporting and determining AYP, respectively, each State must calculate a graduation rate, defined as follows, for all public high schools in the State: (i)(A) A State must calculate a 'four-year adjusted cohort graduation rate,' defined as the number of students who graduate in four years with a regular high school diploma divided by the number of students who form the adjusted cohort for that graduating class . . . (ii) The term 'adjusted cohort' means the students who enter grade 9 (or the earliest high school grade) and any students who transfer into the cohort in grades 9 through 12 minus any students removed from the cohort. (A) The term 'students who transfer into the cohort' means the students who enroll after the beginning of the entering cohort's first year in high school, up to and including in grade 12.

GSA_MIGRATION

GSA_MIGRATION