Finding 58987 (2022-001)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-08-24
Audit: 49560
Organization: The Nemours Foundation (FL)
Auditor: Kpmg LLP

AI Summary

  • Core Issue: Payroll expenditures exceeded allowable amounts due to inaccuracies in employee effort allocation, totaling $5,783 in questioned costs.
  • Impacted Requirements: Compliance with 2 CFR 200.430(i) and 2 CFR 200.303 regarding accurate compensation records and effective internal controls.
  • Recommended Follow-up: Standardize and automate effort allocation updates, implement periodic reviews, and establish a process to ensure accuracy in correcting entries and cost transfers.

Finding Text

Federal Program Research and Development Cluster Pass-through Entities University of Delaware Federal Agency U.S. Department of Health and Human Services Federal Award Number and Award Year 93.732 2M01HP31317-05 9/1/21-6/30/22 93.859 59449 7/1/21-6/30/22 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: a) is reasonable for the services rendered and conforms to the established written policy of the non-federal entity consistently applied to both federal and non-federal activities; b) follows an appointment made in accordance with the non-federal entity?s rules or written policies and meets the requirements of federal statute, where applicable; and c) 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. Per 2 CFR 200.303, a non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal Award. Condition and Context We identified four of 60 payroll expenditure samples where the amount recorded and submitted as an allowable expenditure under the grant exceeded the amount that should have been recorded based on the records and inputs detailing the work performed by the employees on the related programs. The value of the errors was $5,783 and the value of the sample items tested was $66,269. Possible Cause and Effect As a result of the implementation of a new payroll system in 2022, payroll expenditures of employees working on these programs were allocated via a manual process to the applicable cost centers (activity codes) based on documented time and effort allocation rates. Allocation rates were updated throughout the year as employee effort changed via multiple forms of communication including the submission of support tickets and email follow ups. Due to the manual nature of this process, increased risk of differences between recorded allocations and actual work performed arose requiring subsequent adjustment. While the Foundation recorded correcting entries and cost transfers in some instances to subsequently update certain issues that arose, there is a missing control to ensure all such entries were made completely and accurately. The effect is that potentially unallowable costs are submitted to the granting agencies as certain corrections were not made accurately and completely. Questioned Costs Known questioned costs of $5,783. Statistically Valid Sample The sample was not intended to be, and was not, a statistically valid sample. Repeat of Prior Finding No Recommendations The Foundation should standardize, centralize, and potentially automate the process by which updates to effort allocation percentages of employees working on federally funded programs are communicated and recorded. Additionally, a periodic review of these rates by the employees to which they relate, or their direct supervisors, should be implemented to detect any issues or changes that need to be made. Lastly, a process to follow up on and review the completeness and accuracy of correcting entries and cost transfers to validate all required entries are recorded appropriately should be implemented. View of Responsible Official Management agrees with the noted finding.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 58986 2022-001
    Material Weakness
  • 635428 2022-001
    Material Weakness
  • 635429 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $2.65M
93.859 Biomedical Research and Research Training $572,334
93.172 Human Genome Research $294,530
32.006 Covid-19 Telehealth Program $293,171
93.399 Cancer Control $205,276
93.994 Maternal and Child Health Services Block Grant to the States $175,659
93.286 Discovery and Applied Research for Technological Innovations to Improve Human Health $158,790
93.732 Mental and Behavioral Health Education and Training Grants $146,760
93.121 Oral Diseases and Disorders Research $138,336
16.575 Crime Victim Assistance $135,113
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $121,707
93.889 National Bioterrorism Hospital Preparedness Program $94,607
93.396 Cancer Biology Research $82,698
93.493 Community Project Funding/congressional Directives $77,685
93.225 National Research Service Awards_health Services Research Training $75,377
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $56,537
93.847 Diabetes, Digestive, and Kidney Diseases Extramural Research $40,384
84.305 Education Research, Development and Dissemination $40,271
93.865 Child Health and Human Development Extramural Research $39,055
93.837 Cardiovascular Diseases Research $37,715
93.113 Environmental Health $30,451
93.153 Coordinated Services and Access to Research for Women, Infants, Children, and Youth $22,174
93.092 Affordable Care Act (aca) Personal Responsibility Education Program $20,000
93.103 Food and Drug Administration_research $18,321
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $16,167
93.839 Blood Diseases and Resources Research $15,749
93.110 Maternal and Child Health Federal Consolidated Programs $15,532
93.393 Cancer Cause and Prevention Research $13,100
93.266 Health Systems Strengthening and Hiv/aids Prevention, Care and Treatment Under the President's Emergency Plan for Aids Relief $12,732
93.395 Cancer Treatment Research $12,650
93.136 Injury Prevention and Control Research and State and Community Based Programs $12,500
93.173 Research Related to Deafness and Communication Disorders $10,070
47.070 Computer and Information Science and Engineering $9,596
93.867 Vision Research $9,011
93.838 Lung Diseases Research $7,095
93.855 Allergy, Immunology and Transplantation Research $5,625
93.310 Trans-Nih Research Support $4,785
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $4,700
12.420 Military Medical Research and Development $2,694
93.853 Extramural Research Programs in the Neurosciences and Neurological Disorders $2,626
93.846 Arthritis, Musculoskeletal and Skin Diseases Research $1,000
93.080 Blood Disorder Program: Prevention, Surveillance, and Research $753
93.945 Assistance Programs for Chronic Disease Prevention and Control $450
93.394 Cancer Detection and Diagnosis Research $-1,182