Finding 20583 (2022-002)

-
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-03-30
Audit: 20254
Organization: Tuskegee University (AL)
Auditor: Warren Averett

AI Summary

  • Core Issue: An employee's salary was incorrectly allocated, leading to an overcharge of $1,138, which is about 1% of the total salaries tested.
  • Impacted Requirements: Compliance with 2 CFR Section 200.430(i) regarding accurate documentation and allocation of employee compensation costs for federal awards.
  • Recommended Follow-Up: Strengthen the review process for salary allocations to ensure all calculations are accurate and compliant.

Finding Text

Finding 2022-002 ? Allowable Cost/ Cost Principles Information on the federal program: ALN #10.512-Agriculture Extension at 1890 Land-Grant Institutions Program Criteria: In accordance with the documentation standards of 2 CFR Section 200.430(i), costs of compensation for personal services are allowable to the extent the total compensation for individual employees is determined and supported as provided in 2 CFR Section 200.430(i), including that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Condition: The University has a system in place that allocates annual salaries based on the percentage of time worked on grants as documented and approved on the personnel action form. The approval is a key control ensuring that time coded to a federal award is allowable under the terms of that award. For one employee of 23 tested, we noted that the salary was incorrectly allocated resulting in an overcharge of $1,138 for the payroll period selected. Context: The total salaries tested in the sample of 23 employees was approximately $81,000. The overcharge of $1,138 was, therefore, approximately 1% of the salaries tested. Of the $3.3 million in expenditures coded to ALN # 10.512 award for the year ended June 30, 2022, approximately $1.7 million represented salary costs. Cause/Effect: The University has an established process and control procedures for approval of employee?s costs charged to federal awards, but that process did not detect the over allocation for one employee tested. Questioned Costs: Salary costs were over allocated to the federal award by $7,849 for the entire fiscal year. Auditor?s Recommendation: We recommend the University strengthen its review process over salary allocations and ensure all allocations are correctly calculated. View of Responsible Official: Management agrees with this finding. See Corrective Action Plan at the end of the report.

Corrective Action Plan

Finding 2022-002 ? Allowable Cost/ Cost Principles Planned Corrective Action: In November 2022, the University removed all unallowable salary and related fringe benefits costs off the affected grants, returned funds to USDA through the ASAP drawdown process, and corrected the SEFA. Additionally, the Office of Human Resources (HR) and Office of Grants and Contracts (OGCA) have implemented and strengthen monthly review procedures for Personnel Action Forms. In January 2023, Human Resources granted the OGCA query and view access to the Person?s Pay Distribution Module for employees working on grants and contracts. This will allow the OGCA staff to compare the PAFs to HR and Payroll data and identify errors, if any, for correction. Upon receipt of PAFs in the OGCA, the following steps will occur: A. (1) Verify that the faculty and or staff can be specifically identified with the sponsored project; (2) Verified the position in the budget and/or have the prior written approval of the funding agency; (3) Compare the grant period to the personnel action form (PAF) start and end date; and (4) ensure that required approved signatures (Principal Investigator, Department Head and/or Dean) are present. C. Once the above conditions have been met, the Financial Analyst signs the PAF, forward to the Budget Officer and the VP for Business Affairs/CFO, for approval. The approved document is then submitted to the Office of the President and finally, Human Resources for review, approval, and compliance with university employment guidelines and policies. Once approved, HR enters the PAF into the Colleague System. An employment contract is generated as applicable. D. Monthly Review of the Grants General Ledger Summary Report (GLSA) and the General Ledger Trial Balance (GLTB) and or General Ledger Budget Status (GLBS) are completed by the Grants Financial Analysts. This monthly review is to verify that amounts charged are allowable and accurately posted to the correct departmental account and object codes. Payroll charges are compared to the PAFs. E. The OGCA, HR, and Payroll Offices collaborate on any discrepancies or errors and resolve immediately. Anticipated Date of Completion: Corrective action completed as of the date of this report. Person Responsible for Corrective Action Plan: Mr. Dexter Odom, Chief Financial Officer

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $35.33M
84.425 Covid-19 Education Stabilization Fund $10.99M
84.038 Federal Perkins Loan Program $8.27M
84.063 Federal Pell Grant Program $6.67M
84.031 Higher Education_institutional Aid $6.33M
10.205 Payments to 1890 Land-Grant Colleges and Tuskegee University $2.91M
93.137 Community Programs to Improve Minority Health Grant Program $2.59M
47.076 Education and Human Resources $1.67M
84.007 Federal Supplemental Educational Opportunity Grants $1.57M
93.397 Cancer Centers Support Grants $803,270
47.049 Mathematical and Physical Sciences $602,605
10.524 Scholarships for Students at 1890 Institutions (b) $511,755
84.033 Federal Work-Study Program $365,370
47.083 Integrative Activities $328,932
93.264 Nurse Faculty Loan Program (nflp) $326,370
10.202 Cooperative Forestry Research $276,217
93.978 Preventive Health Services_sexually Transmitted Diseases Research, Demonstrations, and Public Information and Education Grants $203,694
10.216 1890 Institution Capacity Building Grants $198,683
12.001 Air Force Jrotc $197,743
12.905 Cybersecurity Core Curriculum $183,524
10.307 Organic Agriculture Research and Extension Initiative $177,702
10.559 Summer Food Service Program for Children $157,734
47.070 Computer and Information Science and Engineering $153,110
12.431 Basic Scientific Research $152,791
10.443 Outreach and Assistance for Socially Disadvantaged and Veteran Farmers and Ranchers $145,461
93.658 Foster Care_title IV-E $131,745
10.179 Micro-Grants for Food Security Program $124,059
47.046 Education and Human Resources $121,078
10.025 Plant and Animal Disease, Pest Control, and Animal Care $119,286
93.838 Lung Diseases Research $105,657
43.RD Dynetics $89,355
12.420 Military Medical Research and Development $88,081
10.512 Agriculture Extension at 1890 Land-Grant Institutions $87,824
81.049 Office of Science Financial Assistance Program $86,842
10.513 1890 Facilities Grants Program $85,275
93.350 National Center for Advancing Translational Sciences $82,845
43.001 Science $78,175
10.514 Expanded Food and Nutrition Education Program $77,030
12.598 Centers for Academic Excellence $74,472
47.041 Engineering $70,128
93.395 Cancer Treatment Research $67,236
12.RD Johnsons Research and Development Co. $62,470
93.307 Minority Health and Health Disparities Research $57,085
47.074 Biological Sciences $53,176
45.024 Promotion of the Arts_grants to Organizations and Individuals $48,928
10.652 Forestry Research $43,651
20.313 Railroad Research and Development $41,479
93.859 Biomedical Research and Research Training $33,193
45.162 Promotion of the Humanities_teaching and Learning Resources and Curriculum Development $31,617
12.RD Georgia Technology Research Institute $31,430
10.217 Higher Education - Institution Challenge Grants Program $26,685
47.075 Social, Behavioral, and Economic Sciences $24,960
84.334 Gaining Early Awareness and Readiness for Undergraduate Programs $24,472
12.RD Emerging Materials for High-Speed Missile Applications $23,941
93.310 Trans-Nih Research Support $21,314
10.464 Socially Disadvantaged Farmers and Ranchers Policy Research Center $20,000
10.207 Animal Health and Disease Research $19,768
19.040 Public Diplomacy Programs $19,632
98.001 Usaid Foreign Assistance for Programs Overseas $18,003
93.866 Aging Research $17,923
10.515 Renewable Resources Extension Act and National Focus Fund Projects $16,684
10.310 Agriculture and Food Research Initiative (afri) $16,604
93.847 Diabetes, Digestive, and Kidney Diseases Extramural Research $16,040
19.009 Academic Exchange Programs - Undergraduate Programs $13,621
23.001 Appalachian Regional Development (see Individual Appalachian Programs) $13,055
10.664 Cooperative Forestry Assistance $9,779
12.U00 Science Application International Cooperation $9,533
43.008 Education $9,369
84.116 Fund for the Improvement of Postsecondary Education $7,665
93.351 Research Infrastructure Programs $6,656
10.215 Sustainable Agriculture Research and Education $5,931
15.904 Historic Preservation Fund Grants-in-Aid $5,245
10.523 Centers of Excellence at 1890 Institutions (b) $4,600
10.250 Agricultural and Rural Economic Research, Cooperative Agreements and Collaborations $4,364
12.630 Basic, Applied, and Advanced Research in Science and Engineering $4,350
10.500 Cooperative Extension Service $3,516
10.329 Crop Protection and Pest Management Competitive Grants Program $3,483
10.961 Scientific Cooperation and Research $2,177
21.019 Covid-19 Coronavirus Relief Fund $-30,385