Finding 1171871 (2025-001)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2025
Accepted
2026-02-02
Audit: 384843
Organization: Central Texas Food Bank (TX)

AI Summary

  • Core Issue: An error in the allocation spreadsheet led to TEFAP's administrative costs being overstated by $188,459 due to double-counting of CCC amounts.
  • Impacted Requirements: Costs must be necessary, reasonable, and properly documented as per 2 CFR §200.403 and §200.405.
  • Recommended Follow-up: Revise the allocation methodology to prevent double-counting and implement a secondary review of the spreadsheet before finalizing allocations.

Finding Text

U.S. Department of Agriculture/Passed-through Texas Department of Agriculture Food Distribution Cluster Federal Assistance Listing Number 10.565 – Commodity Supplemental Food Program (Administrative Costs), 10.568 – Emergency Food Assistance Program (Administrative Costs) Award Number: 01576 Criteria or Specific Requirement: Activities Allowed or Unallowable and Allowable Costs/Cost Principles – Costs charged to Federal awards must be necessary, reasonable, consistently treated, adequately documented, and allocable to the program in proportion to the benefits received. (2 CFR §200.403 and §200.405) Condition: During testing of administrative cost allocations for the Food Distribution Cluster, we identified an error in the entity’s allocation spreadsheet used to distribute administrative costs among Texas Emergency Food Assistance Program (TEFAP), Commodity Credit Corp (CCC)-funded TEFAP operations, and Commodity Supplemental Food Program (CSFP). This error caused TEFAP's share of administrative costs to be overstated by $188,459. Reimbursement requests for these overstated amounts were submitted between October and January. Although TEFAP reimbursement caps prevented any actual overpayment for the nine-month period, the early over‑allocation exhausted TEFAP funds sooner, leaving later allowable costs unreimbursed. Cause: A formula error in the allocation spreadsheet double-counted CCC amounts in the TEFAP base, inflating TEFAP’s percentage of shared administrative costs. Effect or Potential Effect: The error caused TEFAP to be assigned more in shared administrative costs than warranted by program benefit. Although reimbursement caps prevented an actual overpayment for the fiscal year, the misallocation exhausted TEFAP funds earlier, leaving later allowable costs unreimbursed. Without correction, the entity could continue to recognize TEFAP administrative and operational reimbursements earlier than warranted in future periods. Questioned Costs: Assistance Listing Number 10.568 – $188,459. Calculated difference between TEFAP funds billed versus actual allocated cost that should have been billed between October and January. Context: The allocation spreadsheet design error caused CCC amounts to be doublecounted in the TEFAP base, inflating TEFAP’s share of pooled administrative costs. Repeat Finding: No Recommendation: Correct the allocation methodology to ensure CCC amounts are not double-counted in TEFAP bases and that each program bears costs in proportion to benefit per 2 CFR §200.405. Implement a documented secondary review of the monthly allocation spreadsheet before posting. Views of Responsible Officials and Planned Corrective Actions: Management concurs with the finding and recommendation. While the misallocation resulted in overstated TEFAP administrative costs by $188,459, the program’s reimbursement cap and the entity’s actual incurred costs prevented any overbilling or excess Federal draw. See further information on the corrective action plan provided by management.

Corrective Action Plan

Finding Reference: 2025-001 – Activities Allowed or Unallowed Costs/Cost Principles — Food Distribution Cluster (TEFAP/CCC/CSFP) — Questioned Costs: 188,459 Responsible Person: Todd Frease, CFO Planned Actions & Timelines: 1. Allocation Methodology Correction (by 30 days from report issuance): We will redesign our administrative cost allocation model to remove the CCC double-counting and ensure each program’s share is based on documented, reasonable measures of benefit, consistent with 2 CFR §200.405. The revised workbook will include locked formulas and version control. 2. Secondary Review Control (effective next monthly close): We will implement a two-step review: preparer signs off on the allocation workbook, and an independent reviewer validates sources, bases, and formula ranges before posting entries or submitting claims. Evidence of review will be retained in monthly share drive by indicating approval through email. Anticipated Completion Date: Within 60 days of report issuance

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1171870 2025-001
    Material Weakness Repeat
  • 1171872 2025-002
    Material Weakness Repeat
  • 1171873 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.569 EMERGENCY FOOD ASSISTANCE PROGRAM (FOOD COMMODITIES) $8.32M
10.187 THE EMERGENCY FOOD ASSISTANCE PROGRAM (TEFAP) COMMODITY CREDIT CORPORATION ELIGIBLE RECIPIENT FUNDS $2.28M
10.182 PANDEMIC RELIEF ACTIVITIES: LOCAL FOOD PURCHASE AGREEMENTS WITH STATES, TRIBES, AND LOCAL GOVERNMENTS $1.90M
10.565 COMMODITY SUPPLEMENTAL FOOD PROGRAM $840,401
10.568 EMERGENCY FOOD ASSISTANCE PROGRAM (ADMINISTRATIVE COSTS) $762,488
10.558 CHILD AND ADULT CARE FOOD PROGRAM $471,107
10.551 SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $434,767
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $374,700
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $373,244
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $280,945
10.177 REGIONAL FOOD SYSTEM PARTNERSHIPS $53,059