Finding 628541 (2022-001)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-07-17
Audit: 48921
Organization: Reno County, Kansas (KS)
Auditor: Adamsbrown LLC

AI Summary

  • Core Issue: Errors in allocating expenditures between grants and summarizing mileage data led to misstatements in financial records.
  • Impacted Requirements: Internal controls were inadequate, resulting in potential miscalculations of indirect costs and uncorrected errors.
  • Recommended Follow-Up: Review and strengthen procedures to ensure accurate calculation and booking of expenditures.

Finding Text

Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ? 93.323 and Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) ? 10.557 Criteria or specific requirement Internal controls should be in place to ensure that expenditures are correctly charged as to account, amount, and period. Condition During testing, it was discovered that errors were made while allocating expenditures between grants. In addition, errors were made when summarizing mileage data that was then used in the allocation process. Cause A sufficient review process was not in place to catch and correct errors in a timely manner. Effect Additional errors may have been made that were not caught and corrected. In addition, indirect costs may be calculated using an incorrect cost pool. Context Payroll in the amount of $144 was improperly allocated amongst budget items within the WIC grant, and estimated total allocation errors are $4,995. Due to a data entry error during the allocation process, ELC payroll was understated in the amount of $13, and estimated total errors are $25. Actual mileage logs for December were less than the total calculated by 6 miles. Actual mileage logs for November were higher than the total calculated by 138 total miles. Actual mileage logs for October were higher than the total calculated by 114 total miles, and no logs were scanned for two vehicles for the month. Actual mileage logs for September were higher than the total calculated by 61 total miles. Actual mileage logs for July were higher than the allocation calculation by 114 total miles. Due to these errors, WIC expenses allocated according to these amounts were overstated by $2, and estimated total allocation errors are $57. An invoice that included the purchase of items for multiple grant programs did not allocate the shipping costs accordingly ? the full $5 cost was charged to the ELC grant. The estimated total allocation errors are $9. Recommendation We recommend that the County review its procedures and implement controls to ensure that expenditures are properly calculated and booked. Views of responsible officials and planned corrective actions See corrective action plan.

Categories

Procurement, Suspension & Debarment Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 52099 2022-001
    Significant Deficiency
  • 52100 2022-002
    Significant Deficiency
  • 52101 2022-001
    Significant Deficiency
  • 628542 2022-002
    Significant Deficiency
  • 628543 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.509 Formula Grants for Rural Areas and Tribal Transit Program $703,423
16.838 Comprehensive Opioid Abuse Site-Based Program $284,097
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $105,837
93.268 Immunization Cooperative Agreements $85,640
10.555 National School Lunch Program $44,975
93.778 Medical Assistance Program $40,000
93.217 Family Planning_services $26,688
93.994 Maternal and Child Health Services Block Grant to the States $24,299
21.027 Coronavirus State and Local Fiscal Recovery Funds $21,958
93.069 Public Health Emergency Preparedness $20,676
16.034 Coronavirus Emergency Supplemental Funding Program $15,744
93.991 Preventive Health and Health Services Block Grant $9,628
93.575 Child Care and Development Block Grant $6,847
20.616 National Priority Safety Programs $6,071
93.052 National Family Caregiver Support, Title Iii, Part E $4,900
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $4,670
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $3,176
10.664 Cooperative Forestry Assistance $2,927
16.607 Bulletproof Vest Partnership Program $2,308
10.559 Summer Food Service Program for Children $2,119
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $1,120
93.945 Assistance Programs for Chronic Disease Prevention and Control $1,044
93.136 Injury Prevention and Control Research and State and Community Based Programs $950
20.600 State and Community Highway Safety $333