Finding 404922 (2023-002)

Material Weakness
Requirement
L
Questioned Costs
$1
Year
2023
Accepted
2024-07-01

AI Summary

  • Core Issue: The Health Department failed to accurately allocate wages, fringe benefits, and general expenditures in their general ledger for federal programs.
  • Impacted Requirements: This noncompliance affects the substantiation of eligible costs, leading to material misstatements in grant reports.
  • Recommended Follow-Up: Update procedures for federal awards, review cost allocation methods, and establish a reliable system for maintaining source information.

Finding Text

GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (ALLOWABLE COSTS/COST PRINCIPLES). PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 404910 2023-001
    Material Weakness
  • 404911 2023-001
    Material Weakness
  • 404912 2023-001
    Material Weakness
  • 404913 2023-001
    Material Weakness
  • 404914 2023-001
    Material Weakness
  • 404915 2023-001
    Material Weakness
  • 404916 2023-001
    Material Weakness
  • 404917 2023-001
    Material Weakness
  • 404918 2023-002
    Material Weakness
  • 404919 2023-002
    Material Weakness
  • 404920 2023-002
    Material Weakness
  • 404921 2023-002
    Material Weakness
  • 404923 2023-002
    Material Weakness
  • 404924 2023-002
    Material Weakness
  • 404925 2023-002
    Material Weakness
  • 981352 2023-001
    Material Weakness
  • 981353 2023-001
    Material Weakness
  • 981354 2023-001
    Material Weakness
  • 981355 2023-001
    Material Weakness
  • 981356 2023-001
    Material Weakness
  • 981357 2023-001
    Material Weakness
  • 981358 2023-001
    Material Weakness
  • 981359 2023-001
    Material Weakness
  • 981360 2023-002
    Material Weakness
  • 981361 2023-002
    Material Weakness
  • 981362 2023-002
    Material Weakness
  • 981363 2023-002
    Material Weakness
  • 981364 2023-002
    Material Weakness
  • 981365 2023-002
    Material Weakness
  • 981366 2023-002
    Material Weakness
  • 981367 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $66,847
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $49,951
93.788 Opioid Str $42,065
93.235 Affordable Care Act (aca) Abstinence Education Program $29,084
93.069 Public Health Emergency Preparedness $17,989
93.217 Family Planning_services $7,673
93.917 Hiv Care Formula Grants $4,906
93.994 Maternal and Child Health Services Block Grant to the States $4,597
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $3,169
93.268 Immunization Cooperative Agreements $2,887
66.468 Capitalization Grants for Drinking Water State Revolving Funds $1,469
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $469
93.778 Medical Assistance Program $403