Corrective Action Plans

Corrective Action Plan Organization: Weingart Center Association Date: July 26, 2024 Weingart Center Association respectfully submits the following corrective action plan (“CAP”) for the year ended April 30, 2022. Name and address of independent public accounting firm: Armanino, LLP 11766 Wilshire B...

Corrective Action Plan Organization: Weingart Center Association Date: July 26, 2024 Weingart Center Association respectfully submits the following corrective action plan (“CAP”) for the year ended April 30, 2022. Name and address of independent public accounting firm: Armanino, LLP 11766 Wilshire Blvd. 9th Floor Los Angeles, CA 90025 Audit period: April 30, 2022 The findings from the April 30, 2022 schedule of findings and questioned costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule. Findings – Federal awards SIGNIFICANT DEFICIENCY 2022-007 – Procurement process Auditor Recommendation: Management should revise its documentation system to allow for centralized and accessible storage of support for its vendor procurement process. Action Taken: Management will implement a process to formally document vendor selections. Name of responsible person: Kevin Matthews, Consultant CFO Anticipated completion date: The new policy will be implemented in August 2024.

View Audit 325003

Finding 503014 (2022-003)

Significant Deficiency 2022

Southern Avenue Charter Elementary School of Academic Excellence and Creative Arts

TN

The Academy will close out accounting records in accordance with State regulations and statutes.

View Audit 324961

Finding 503013 (2022-002)

Significant Deficiency 2022

Southern Avenue Charter Elementary School of Academic Excellence and Creative Arts

TN

The Academy will place written procedures for cash balances and obtain the necessary insurance if the cash balances exceed the FDIC limits

View Audit 324961

Finding 503012 (2022-001)

Significant Deficiency 2022

Southern Avenue Charter Elementary School of Academic Excellence and Creative Arts

TN

SACS Officials will obtain repayment of funds by Payroll Specialist

View Audit 324961

Finding 502984 (2022-003)

Material Weakness 2022

Elverado Community Unit School District

CO

Internal Control / Segregation of Duties

The District will segregate duties to the best of its ability and ensure proper oversight by management.

View Audit 324931

Finding 502983 (2022-002)

Material Weakness 2022

Elverado Community Unit School District

CO

Internal Control / Segregation of Duties

The District will implement internal controls procedures and consider hiring a trained individual to ensure complete and accurate financial statements.

View Audit 324931

Finding 502982 (2022-001)

Material Weakness 2022

Elverado Community Unit School District

CO

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

The District will establish policies and procedures to be followed to ensure proper review, approval and recording of federal expenditures.

View Audit 324931

Finding 502919 (2022-001)

Significant Deficiency 2022

Astronomical Scoiety of the Pacific

CA

Reporting Equipment & Real Property Management Matching / Level of Effort / Earmarking

Views of Responsible Officials and Corrective Actions: Astronomical Society of the Pacific has retained an accounting firm LTD Global to review and revise our accounting system to better conform to current accounting practices.

View Audit 324909

Finding 502747 (2022-001)

None 2022

Opera San Jose, Incorporated

CA

§ 200.512

Due to the complex nature of the federal regulations associated with the SVOG and the evolving guidance, we were not aware that an audit was required in accordance with 2 CFR section 200.512. Future audits required by 2 CFR section 200.512 will be completed timely.

View Audit 324815

Finding 502683 (2022-006)

Significant Deficiency 2022

Town of Limestone, Maine

ME

§ 200.512

CORRECTIVE ACTION PLAN (Concerning Finding 2022-006) Contact Person Responsible for Corrective Action: Alan D. Mulherin, Town Manager Corrective Action: The town will work to ensure timely filing of required reports in the future. Anticipated Completion Date: June 30, 2025

View Audit 324710

Finding 502635 (2022-001)

Significant Deficiency 2022

Fundacion De Desarollo Comunal De Puerto Rico

PR

Reporting § 200.512

FUNDACION DE DESARROLLO COMUNAL DE PUERTO RICO, INC. FUNDESCO acknowledges the findings identified during the single audit regarding reporting requirements stemming from a lack of personnel. However, FUNDACION DE DESARROLLO COMUNAL DE PUERTO RICO, INC. FUNDESCO has already contracted capable personn...

FUNDACION DE DESARROLLO COMUNAL DE PUERTO RICO, INC. FUNDESCO acknowledges the findings identified during the single audit regarding reporting requirements stemming from a lack of personnel. However, FUNDACION DE DESARROLLO COMUNAL DE PUERTO RICO, INC. FUNDESCO has already contracted capable personnel to assist in the finance department to comply with financial reports.

View Audit 324610

Finding 502552 (2022-002)

Significant Deficiency 2022

Puerto Rico Health Insurance Administration

PR

Allowable Costs / Cost Principles Reporting

The PRHIA was proactive to ensure compliance in submitting the 2022 Single Audit Report by due date, maximizing the human resources available, in collaboration with auditors. However, we were unable to comply with the due date, mainly, because of the employees turnover as part of the aftermath of ...

The PRHIA was proactive to ensure compliance in submitting the 2022 Single Audit Report by due date, maximizing the human resources available, in collaboration with auditors. However, we were unable to comply with the due date, mainly, because of the employees turnover as part of the aftermath of the Coronavirus Pandemic as it relates to maintaining up to date its accounting records.

View Audit 324550

Finding 502550 (2022-001)

Material Weakness 2022

Puerto Rico Health Insurance Administration

PR

Internal Control / Segregation of Duties

ASES contracted a Cybersecurity expert to review the Disaster Recovery Plan draft, including the security policies and standards of information systems. The work plan includes the following: 1. Preparation of the Business Impact Analysis: a) Separate meetings with all managers to identify departm...

ASES contracted a Cybersecurity expert to review the Disaster Recovery Plan draft, including the security policies and standards of information systems. The work plan includes the following: 1. Preparation of the Business Impact Analysis: a) Separate meetings with all managers to identify departments' data retention, RTO, BAT and RPO needs. b) This document will provide a better guide for the IT department of the needs of the departments and thus implement or acquire the necessary solutions for the protection, and DRP of the departments and the agency. 2. Perform an internal Risk Assessment which will help identify and remedy the vulnerabilities in the agency. 3. Establish responsibility to the directors of the agency's departments for their processes and the data they handle.4. Update the DRP based on departmental needs and the current capabilities of the agency's information systems. The IT department is in advanced discussions with PRITS for the purchase of the licensing of Azure Site Recovery and Azure Backup to meet the needs of the agency and mitigate the possible loss of data and applications in case of an incident such as ransomware attacks and events such as hurricanes or events related to hardware failures (servers, computers, etc.). This is a high priority for the Executive Director. In the coming months ASES will start the use of OneDrive tools for users to save their documents in this application and SharePoint for departmental files and documents. This implementation will help mitigate the risk that users lose their information due to security incidents or hardware failures. The Backup, Disaster Recovery and Security posture is expected to improve in the next 6 months if the above solutions are implemented.

View Audit 324550

Finding 502528 (2022-001)

Significant Deficiency 2022

Harlem Center for Education, Inc.

NY

Questioned Costs Eligibility Significant Deficiency

The Organization accepts the recommendation of the auditor. In the future, the Organization will implement an additional internal control regarding the verification of eligibility for Educational Opportunity Centers' participants. Specifically, in cases where the staff member who signed the "Verific...

The Organization accepts the recommendation of the auditor. In the future, the Organization will implement an additional internal control regarding the verification of eligibility for Educational Opportunity Centers' participants. Specifically, in cases where the staff member who signed the "Verification of Eligibility and Acceptance" form does not check off the citizenship status or need areas on the form, the data entry specialist will return the participant folder to that staff member to obtain the required eligibility information before including the participant in the database. In the event that the eligibility information is unobtainable, the participant will not be input into the database nor counted as a participant. In addition, more periodic testing of files will be undertaken to identify any participants who do not have the necessary eligibility information, with corrective action taken as needed.

View Audit 324518 Questioned Costs: $1

Finding 502434 (2022-008)

Material Weakness 2022

Dakota Rural Water District

ND

Allowable Costs / Cost Principles Material Weakness Reporting

Department of the Treasury, Passed through North Dakota State Water Commission Federal Financial Assistance Listing 21.027 COVID-19 - Coronavirus State and Local Discal Recovery Funds Other Material Weakness in Internal Control Over Compliance Finding Summary: The District does not have an internal ...

Department of the Treasury, Passed through North Dakota State Water Commission Federal Financial Assistance Listing 21.027 COVID-19 - Coronavirus State and Local Discal Recovery Funds Other Material Weakness in Internal Control Over Compliance Finding Summary: The District does not have an internal control system designed to provide for a complete and accurate Schedule of Expenditures of Federal Awards, as required by Title 2 Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Responsible Individuals: General Manager (Vacant) and Jan Lee, Office Manager Corrective Action Plan: The District will implement procedures necessary to complete an accurate Schedule of Expenditures of Federal Awards. Anticipated Completion: December 31, 2024

View Audit 324447

Finding 502433 (2022-007)

Material Weakness 2022

Dakota Rural Water District

ND

Procurement, Suspension & Debarment Internal Control / Segregation of Duties § 200.318 § 200.326

Department of the Treasury, Passed through North Dakota State Water Commission Federal Financial Assistance Listing 21.027 COVID-19 - Coronavirus State and Local Discal Recovery Funds Procurement, Suspension, Debarment Material Weakness in Internal Control Over Compliance Finding Summary: The Distri...

Department of the Treasury, Passed through North Dakota State Water Commission Federal Financial Assistance Listing 21.027 COVID-19 - Coronavirus State and Local Discal Recovery Funds Procurement, Suspension, Debarment Material Weakness in Internal Control Over Compliance Finding Summary: The District did not have a written policy on procurement that satisfied the requirements of 2 CFR sections 200.318 through 200.326. Responsible Individuals: General Manager (Vacant) and Jan Lee, Office Manager Corrective Action Plan: The District will review the applicable 2 CFR 200 sections and implement procedures necessary to ensure compliance with all of these requirements Anticipated Completion: December 31, 2024

View Audit 324447

Finding 502272 (2022-003)

Material Weakness 2022

American Association of Physics Teachers, Inc.

MD

Cash Management Material Weakness Period of Performance § 200.302 § 200.508 § 200.510

Finding 2022-003: Reconciliation of Accounts Federal Program: Research and Development Cluster (Education and Human Resources)Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: ...

Finding 2022-003: Reconciliation of Accounts Federal Program: Research and Development Cluster (Education and Human Resources)Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1500529 (9/1/2015 – 8/31/2022), 1640791 (9/15/2016 – 8/31/2022) Condition: The year-end schedules for federal grants receivable, net assets, and for vacation payable were not reconciled and needed to be revised and updated. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $115,244 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO

View Audit 324376

Finding 502269 (2022-005)

Significant Deficiency 2022

American Association of Physics Teachers, Inc.

MD

Procurement, Suspension & Debarment § 200.317

Finding 2022-005: Procurement Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1431638 (9/1/2...

Finding 2022-005: Procurement Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1431638 (9/1/2014 – 8/31/2022), 1500529 (9/1/2015 – 8/31/2022), 1624185 (9/16/2016 – 8/31/2022), 1640791 (9/15/2016 – 8/31/2022), 1720869 (5/15/2017 – 4/30/2022), 1726113 (8/1/2017 – 9/30/2023), 1821462 (7/1/2018 – 6/30/2024), 1940925 (1/15/2020 – 12/31/2023), 1907950 (7/1/2019 – 6/30/2024), 2015205 (4/1/2020 – 3/31/2022), 2021059 (10/1/2020 – 9/30/2024), 2141745 (5/1/2022 – 4/30/2027), 2212807 (7/1/2022 – 6/30/2026) Federal Program: Research and Development Cluster (Mathematical and Physical Sciences) Assistance Listing Number and Title: 47.049 Mathematical and Physical Sciences Name of Federal Agency, Pass Through Entity, Award Number and Year: National Science Foundation: 1821372 (10/1/2018 – 9/30/2024 pass through entity American Physical Society), 1834530 (9/1/2018 – 8/31/2025 pass through entity American Physical Society), 1938815 (8/1/2020 – 7/31/2024) Federal Program: Research and Development Cluster (Science) Assistance Listing Number and Title: 43.001 Science Name of Federal Agency, Pass Through Entity: National Aeronautics and Space Administration: NNX16AR36A (8/24/2016 – 8/23/2021 pass through entity Temple University of the Commonwealth System of Higher Education), 80NSSC21K1560 (6/28/2021 – 6/27/2022 pass through entity Temple University of the Commonwealth System of Higher Education), 80NSSC22K1071 (5/23/2022 – 5/22/2023) Condition: AAPT did not consistently adhere to written policies with respect to the procurement process, as bids/quotes were not obtainable or the conclusion for selection was not documented. Views of Responsible Officials and Planned Corrective Actions: Management will update current policies and procedures and review and enforce the polices. Management will be responsible for proper documentation and confirmation that all policies and procedures are followed. Management will confirm that all agreements, mou’s and contracts are property, reviewed signed and documented. Management will require all departments to document all procurements for goods and services with written cost and price analysis based on AAPT's dollar thresholds. Anticipated Completion Date: November 2024 Responsible Official: Dr. Beth Cunningham CEO, Michael Brosnan CFO

View Audit 324376

Finding 502268 (2022-004)

Significant Deficiency 2022

American Association of Physics Teachers, Inc.

MD

Matching / Level of Effort / Earmarking Procurement, Suspension & Debarment Significant Deficiency § 200.303

Finding 2022-004: Payroll Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1431638 (9/1/2014 ...

Finding 2022-004: Payroll Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1431638 (9/1/2014 – 8/31/2022), 1500529 (9/1/2015 – 8/31/2022), 1624185 (9/16/2016 – 8/31/2022), 1726113 (8/1/2017 – 9/30/2023), 1907950 (7/1/2019 – 6/30/2024), 2141745 (5/1/2022 – 4/30/2027), 2212807 (7/1/2022 – 6/30/2026) Federal Program: Research and Development Cluster (Mathematical and Physical Sciences) Assistance Listing Number and Title: 47.049 Mathematical and Physical Sciences Name of Federal Agency, Pass Through Entity, Award Number and Year: National Science Foundation: 1821372 (10/1/2018 – 9/30/2024 pass through entity American Physical Society) Condition: Payroll approvals for individuals are not always made by individuals who are the employee’s supervisors or are otherwise knowledgeable about their level of effort during the payroll periods paid for. Of the 63 individual payroll payments tested to 12 separate individuals, totaling $105,046 charged to federal grants, we identified 38 total payments to 7 separate individuals, totaling $43,704, where the timesheet was approved by the CFO, who we do not consider to be knowledgeable of the employee’s activities during a given pay period. Five of these seven individuals were full-time employees and the other two were part-time employees. Views of Responsible Officials and Planned Corrective Actions: AAPT has made changes to correctly reflect the employee’s assigned supervisor based on the position and job duties of the employees. Anticipated Completion Date: 04/01/2024 Responsible Official: Michael Brosnan, CFO

View Audit 324376

Finding 502267 (2022-002)

Material Weakness 2022

American Association of Physics Teachers, Inc.

MD

Internal Control / Segregation of Duties Material Weakness Matching / Level of Effort / Earmarking § 200.303

Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1431638 (9/1/2014 – 8/31/2022), 1500529 (9/1...

Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1431638 (9/1/2014 – 8/31/2022), 1500529 (9/1/2015 – 8/31/2022), 1624185 (9/16/2016 – 8/31/2022), 1640791 (9/15/2016 – 8/31/2022), 1720869 (5/15/2017 – 4/30/2022), 1726113 (8/1/2017 – 9/30/2023), 1821462 (7/1/2018 – 6/30/2024), 1940925 (1/15/2020 – 12/31/2023), 1907950 (7/1/2019 – 6/30/2024), 2015205 (4/1/2020 – 3/31/2022), 2021059 (10/1/2020 – 9/30/2024), 2141745 (5/1/2022 – 4/30/2027), 2212807 (7/1/2022 – 6/30/2026) Federal Program: Research and Development Cluster (Mathematical and Physical Sciences) Assistance Listing Number and Title: 47.049 Mathematical and Physical Sciences Name of Federal Agency, Pass Through Entity, Award Number and Year: National Science Foundation: 1821372 (10/1/2018 – 9/30/2024 pass through entity American Physical Society), 1834530 (9/1/2018 – 8/31/2025 pass through entity American Physical Society), 1938815 (8/1/2020 – 7/31/2024) Federal Program: Research and Development Cluster (Science) Assistance Listing Number and Title: 43.001 Science Name of Federal Agency, Pass Through Entity: National Aeronautics and Space Administration: NNX16AR36A (8/24/2016 – 8/23/2021 pass through entity Temple University of the Commonwealth System of Higher Education), 80NSSC21K1560 (6/28/2021 – 6/27/2022 pass through entity Temple University of the Commonwealth System of Higher Education), 80NSSC22K1071 (5/23/2022 – 5/22/2023)Condition: The Chief Financial Officer is responsible for posting entries into the accounting system without a second level review, and obtaining all bank statements unopened while also having the ability to add or modify payees and unilaterally initiate and authorize electronic fund transfers such as automated clearing house payments. The CFO is also responsible for opening the mail which may contain payments by check, and can manually reduce receivable balances. Views of Responsible Officials and Planned Corrective Actions: AAPT has instituted the segregation of duties of submitting and approval of electronic payments. The senior accountant has been authorized to submit the ACH/Wire transfer requests. The CFO has the authorization of approval of submitted electronic payments. The change was activated during March, 2024 The staff will be trained on generating journal entries previously prepared by the CFO and supervised and approve by the CFO – completed date May 15, 2024 The administrative assistant of the CEO will come to AAPT twice weekly to process incoming mail and create an initial recordation log of checks or cash received. The administrative assistant will not have access in any system to enter/modify/delete any information related to checks that are received. Anticipated Completion Date: January 2025 Responsible Official: Michael Brosnan, CFO

View Audit 324376

Finding 502266 (2022-001)

Significant Deficiency 2022

American Association of Physics Teachers, Inc.

MD

Reporting Significant Deficiency

Finding 2022-001: State Audit Law and Single Audit Reporting Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Sci...

Finding 2022-001: State Audit Law and Single Audit Reporting Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1431638 (9/1/2014 – 8/31/2022), 1500529 (9/1/2015 – 8/31/2022), 1624185 (9/16/2016 – 8/31/2022), 1640791 (9/15/2016 – 8/31/2022), 1720869 (5/15/2017 – 4/30/2022), 1726113 (8/1/2017 – 9/30/2023), 1821462 (7/1/2018 – 6/30/2024), 1940925 (1/15/2020 – 12/31/2023), 1907950 (7/1/2019 – 6/30/2024), 2015205 (4/1/2020 – 3/31/2022), 2021059 (10/1/2020 – 9/30/2024), 2141745 (5/1/2022 – 4/30/2027), 2212807 (7/1/2022 – 6/30/2026) Federal Program: Research and Development Cluster (Mathematical and Physical Sciences) Assistance Listing Number and Title: 47.049 Mathematical and Physical Sciences Name of Federal Agency, Pass Through Entity, Award Number and Year: National Science Foundation: 1821372 (10/1/2018 – 9/30/2024 pass through entity American Physical Society), 1834530 (9/1/2018 – 8/31/2025 pass through entity American Physical Society), 1938815 (8/1/2020 – 7/31/2024) Federal Program: Research and Development Cluster (Science) Assistance Listing Number and Title: 43.001 Science Name of Federal Agency, Pass Through Entity: National Aeronautics and Space Administration: NNX16AR36A (8/24/2016 – 8/23/2021 pass through entity Temple University of the Commonwealth System of Higher Education), 80NSSC21K1560 (6/28/2021 – 6/27/2022 pass through entity Temple University of the Commonwealth System of Higher Education), 80NSSC22K1071 (5/23/2022 – 5/22/2023)Condition: AAPT did not timely file the audit with the annual financial report with the State of New York. AAPT did not timely file the single audit with the Federal Clearing House. Views of Responsible Officials and Planned Corrective Actions: AAPT has institute new policies and deadlines for staff to submit the required documentation in order for the accounting department to close the monthly books on a more timely and accurate financial statements. The polices include new staff repercussions for not following the new policies up to termination of employment. Anticipated Completion Date: October 15, 2024 Responsible Official: Michael Brosnan, CFO

View Audit 324376

Corrective Action Plans

Filters