CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not comply with the laws and regulations related to its participation in it’s various federal grant program reporting requirements. Personnel did not complete and submit the required ‘quarterly cash on hand reports’ and ‘final expenditure report’ (FER) for the grant programs based on supporting accurate general ledger expenditures as required by Section 2 CFR 200.403(g) of the Uniform Guidance. This is a repeat finding from (2022-002) from the previous fiscal year.
CRITERIA: The PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance requires the completion and submission of a ‘quarterly cash on hand report’ quarterly as needed and a ‘final expenditure report’ (FER) at the conclusion of each grant program year (including any carryover period) based on information contained in the School District’s financial management system and supported by all underlying documentation.
EFFECT: The District was not in compliance with the PA Department of Education (PDE) and Section 2 CFR 200.403(g) of the Uniform Guidance financial reporting requirements relative to its participation the ESSER and ARP ESSER grant programs that require submission of ‘quarterly cash on hand reports’ and a ‘final expenditure report’ (FER) based on supporting accurate financial management system expenditures.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District re-file the required federal program ‘final expenditure reports’, if possible, based on accurate financial information obtained from the District’s financial management system after any corrections are made, in order to 1) comply with PDE and Uniform Guidance reporting requirements for the District’s applicable federal programs, and 2) to avoid any sanctions from PDE as a result of not filing these reports properly with accurate general ledger detail in a timely manner. All further federal grant reporting should be completed based on accurate general ledger expenditures.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year.
CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 2) accurate, current and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329 of the Uniform Guidance.
EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance.
CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above.
QUESTIONED COST: None
RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that either 1) three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000 were obtained, 2) competitive bidding was performed for the purchases of goods over $22,500 or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors: Saving Ourselves ($30,000), AGI Repair ($16,216), IXL ($19,218), Learning Systems Associates LLC ($25,425), AGC Education Inc. ($11,644), Apple ($163,505), Germ Solutions LLC ($160,070), Graham Security ($12,025), Curriculum Designers, Inc. ($27,875), RJ Rhodes Transit, Inc. ($24,845).
CRITERIA: As specified in 2 CFR 200 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented and over $22,500 formal bidding procedures must be utilized. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, or 4) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
QUESTIONED COST: $490,823 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, and 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding.
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: During my review of Aliquippa School District’s compliance with the requirements of the Public School Code and the Uniform Guidance for procurement of goods and services, the District was unable to provide documentation or other evidence that 1) competitive bidding was performed for the purchases of goods or services over $22,500 and 2) a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000), or 3) the vendor met the requirements of a ‘sole source provider’ with documentation to support such designation, for the following vendors –– Houghton Mifflin-Harcourt ($509,919), Beaver Valley Intermediate Unit ($419,826), and Smart Solutions ($449,303).
CRITERIA: As specified in 2 CFR 200. 318(i) of the Uniform Guidance, the District 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. In addition, small purchase procedures per 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PA Statue 8.807.1, there should be three quotes that are either written or well documented. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
CAUSE: District officials responsible for federal procurement did not adhere to District, state and federal policies and regulations regarding the expenditure of federal funds.
EFFECT: The District did not comply with 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, or 4) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
QUESTIONED COST: $1,379,048 RECOMMENDATION: I recommend that for all future purchases of goods and/or services utilizing federal funds, that the District adhere to the requirements of 1) the District’s Procurement Policy for Federal Programs, 2) the 24 PA Statute 8.807.1, 3) Section 2 CFR 200.318(i) of the Uniform Guidance regarding maintaining records sufficient to detail the history of procurement which includes rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price, 4) Section 2 CFR 200.300(a)(2)(i) of the Uniform Guidance regarding obtaining three price or rate quotations for the purchase of goods between $10,000 and $22,500, and services between $10,000 and $250,000, and as applicable, 5) Section 2 CFR 200.318(i) and Section 2CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement using federal funding, and 5) Section CFR 200.324(a) of the Uniform Guidance regarding the requirement to perform a cost or price analysis for purchases in excess of the Simplified Acquisition Threshold ($250,000).
VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan