Finding 29374 (2022-005)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-03-30

AI Summary

  • Core Issue: Lack of internal controls to document approval of employee pay rates, leading to uncertainty about compliance with federal guidelines.
  • Impacted Requirements: 2 CFR 200.430(a)(3) requires that personal services be supported by a system ensuring charges are accurate and allowable.
  • Recommended Follow-Up: DESC should implement a system to maintain current personnel files and ensure all pay rate approvals are documented and accessible.

Finding Text

Assistance Listing Number, Federal Agency, and Program Name - ALN 17.207 Employment Service Cluster and ALN 17.258, 17.259, and 17.278 WIOA Cluster Federal Award Identification Number and Year - Various Pass-through Entity - Michigan Department of Labor and Economic Opportunity - Workforce Development Agency Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.430(a)(3) indicates that personal services are allowable to the extent they are determined and supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition - An internal control was not in place to document that the current rates of pay were approved. During our testing of payroll, we determined that actual pay was charged to the federal grants tested. However, there was no documentation (within personnel files or other means) to support that the rates of pay were approved. Questioned Costs - Not applicable Identification of How Questioned Costs Were Computed - Not applicable Context - Five of the six personnel files that were provided as support for pay rates appeared to contain outdated information. Cause and Effect - DESC did not have a control in place to maintain current payrates in personnel files or to provide alternative documentation to support that pay rates were approved. As a result, we were not able to determine if the rates of pay were approved by management. Recommendation - DESC should maintain up-to-date personnel information to support that the rates of pay for employees are approved. Views of Responsible Officials and Planned Corrective Actions - DESC was unable to locate evidence due to turnover with the HR department. We have hired a new director of human resources (the "Director"), who has implemented an employee filing system that incorporates up-to-date employee information and salary information. This information is noted in offer letters, promotion letters, and salary increase letters. All payroll updates are required in writing to evidence approval of the Director and another executive team member's authorization (president or CFO). This confidential information is stored in the Director?s locked office.

Categories

Subrecipient Monitoring Allowable Costs / Cost Principles Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 29365 2022-002
    Significant Deficiency
  • 29366 2022-005
    Significant Deficiency
  • 29367 2022-002
    Significant Deficiency
  • 29368 2022-005
    Significant Deficiency
  • 29369 2022-002
    Significant Deficiency
  • 29370 2022-005
    Significant Deficiency
  • 29371 2022-003
    Material Weakness
  • 29372 2022-005
    Significant Deficiency
  • 29373 2022-003
    Material Weakness
  • 29375 2022-004
    Significant Deficiency
  • 29376 2022-005
    Significant Deficiency
  • 29377 2022-002
    Significant Deficiency
  • 29378 2022-003
    Material Weakness
  • 29379 2022-005
    Significant Deficiency
  • 29380 2022-003
    Material Weakness
  • 29381 2022-005
    Significant Deficiency
  • 29382 2022-003
    Material Weakness
  • 29383 2022-005
    Significant Deficiency
  • 29384 2022-003
    Material Weakness
  • 29385 2022-005
    Significant Deficiency
  • 29386 2022-003
    Material Weakness
  • 29387 2022-005
    Significant Deficiency
  • 29388 2022-003
    Material Weakness
  • 29389 2022-005
    Significant Deficiency
  • 29390 2022-003
    Material Weakness
  • 29391 2022-005
    Significant Deficiency
  • 29392 2022-005
    Significant Deficiency
  • 29393 2022-003
    Material Weakness
  • 29394 2022-005
    Significant Deficiency
  • 29395 2022-003
    Material Weakness
  • 29396 2022-005
    Significant Deficiency
  • 29397 2022-004
    Significant Deficiency
  • 29398 2022-005
    Significant Deficiency
  • 29399 2022-003
    Material Weakness
  • 29400 2022-005
    Significant Deficiency
  • 29401 2022-003
    Material Weakness
  • 29402 2022-005
    Significant Deficiency
  • 29403 2022-005
    Significant Deficiency
  • 29404 2022-003
    Material Weakness
  • 29405 2022-005
    Significant Deficiency
  • 29406 2022-003
    Material Weakness
  • 29407 2022-005
    Significant Deficiency
  • 29408 2022-003
    Material Weakness
  • 29409 2022-005
    Significant Deficiency
  • 29410 2022-003
    Material Weakness
  • 29411 2022-005
    Significant Deficiency
  • 29412 2022-003
    Material Weakness
  • 29413 2022-005
    Significant Deficiency
  • 29414 2022-003
    Material Weakness
  • 29415 2022-005
    Significant Deficiency
  • 29416 2022-005
    Significant Deficiency
  • 29417 2022-003
    Material Weakness
  • 29418 2022-005
    Significant Deficiency
  • 29419 2022-003
    Material Weakness
  • 29420 2022-005
    Significant Deficiency
  • 29421 2022-004
    Significant Deficiency
  • 29422 2022-005
    Significant Deficiency
  • 29423 2022-003
    Material Weakness
  • 29874 2022-005
    Significant Deficiency
  • 29875 2022-005
    Significant Deficiency
  • 29876 2022-003
    Material Weakness
  • 29877 2022-005
    Significant Deficiency
  • 29878 2022-003
    Material Weakness
  • 29879 2022-005
    Significant Deficiency
  • 29880 2022-003
    Material Weakness
  • 29881 2022-005
    Significant Deficiency
  • 29882 2022-003
    Material Weakness
  • 29883 2022-005
    Significant Deficiency
  • 29884 2022-003
    Material Weakness
  • 29885 2022-005
    Significant Deficiency
  • 29886 2022-003
    Material Weakness
  • 29887 2022-005
    Significant Deficiency
  • 29888 2022-005
    Significant Deficiency
  • 29889 2022-003
    Material Weakness
  • 29890 2022-005
    Significant Deficiency
  • 29891 2022-005
    Significant Deficiency
  • 29892 2022-005
    Significant Deficiency
  • 605807 2022-002
    Significant Deficiency
  • 605808 2022-005
    Significant Deficiency
  • 605809 2022-002
    Significant Deficiency
  • 605810 2022-005
    Significant Deficiency
  • 605811 2022-002
    Significant Deficiency
  • 605812 2022-005
    Significant Deficiency
  • 605813 2022-003
    Material Weakness
  • 605814 2022-005
    Significant Deficiency
  • 605815 2022-003
    Material Weakness
  • 605816 2022-005
    Significant Deficiency
  • 605817 2022-004
    Significant Deficiency
  • 605818 2022-005
    Significant Deficiency
  • 605819 2022-002
    Significant Deficiency
  • 605820 2022-003
    Material Weakness
  • 605821 2022-005
    Significant Deficiency
  • 605822 2022-003
    Material Weakness
  • 605823 2022-005
    Significant Deficiency
  • 605824 2022-003
    Material Weakness
  • 605825 2022-005
    Significant Deficiency
  • 605826 2022-003
    Material Weakness
  • 605827 2022-005
    Significant Deficiency
  • 605828 2022-003
    Material Weakness
  • 605829 2022-005
    Significant Deficiency
  • 605830 2022-003
    Material Weakness
  • 605831 2022-005
    Significant Deficiency
  • 605832 2022-003
    Material Weakness
  • 605833 2022-005
    Significant Deficiency
  • 605834 2022-005
    Significant Deficiency
  • 605835 2022-003
    Material Weakness
  • 605836 2022-005
    Significant Deficiency
  • 605837 2022-003
    Material Weakness
  • 605838 2022-005
    Significant Deficiency
  • 605839 2022-004
    Significant Deficiency
  • 605840 2022-005
    Significant Deficiency
  • 605841 2022-003
    Material Weakness
  • 605842 2022-005
    Significant Deficiency
  • 605843 2022-003
    Material Weakness
  • 605844 2022-005
    Significant Deficiency
  • 605845 2022-005
    Significant Deficiency
  • 605846 2022-003
    Material Weakness
  • 605847 2022-005
    Significant Deficiency
  • 605848 2022-003
    Material Weakness
  • 605849 2022-005
    Significant Deficiency
  • 605850 2022-003
    Material Weakness
  • 605851 2022-005
    Significant Deficiency
  • 605852 2022-003
    Material Weakness
  • 605853 2022-005
    Significant Deficiency
  • 605854 2022-003
    Material Weakness
  • 605855 2022-005
    Significant Deficiency
  • 605856 2022-003
    Material Weakness
  • 605857 2022-005
    Significant Deficiency
  • 605858 2022-005
    Significant Deficiency
  • 605859 2022-003
    Material Weakness
  • 605860 2022-005
    Significant Deficiency
  • 605861 2022-003
    Material Weakness
  • 605862 2022-005
    Significant Deficiency
  • 605863 2022-004
    Significant Deficiency
  • 605864 2022-005
    Significant Deficiency
  • 605865 2022-003
    Material Weakness
  • 606316 2022-005
    Significant Deficiency
  • 606317 2022-005
    Significant Deficiency
  • 606318 2022-003
    Material Weakness
  • 606319 2022-005
    Significant Deficiency
  • 606320 2022-003
    Material Weakness
  • 606321 2022-005
    Significant Deficiency
  • 606322 2022-003
    Material Weakness
  • 606323 2022-005
    Significant Deficiency
  • 606324 2022-003
    Material Weakness
  • 606325 2022-005
    Significant Deficiency
  • 606326 2022-003
    Material Weakness
  • 606327 2022-005
    Significant Deficiency
  • 606328 2022-003
    Material Weakness
  • 606329 2022-005
    Significant Deficiency
  • 606330 2022-005
    Significant Deficiency
  • 606331 2022-003
    Material Weakness
  • 606332 2022-005
    Significant Deficiency
  • 606333 2022-005
    Significant Deficiency
  • 606334 2022-005
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.558 Temporary Assistance for Needy Families $12.18M
17.245 Trade Adjustment Assistance $348,406
17.268 H-1b Job Training Grants $287,538
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $261,096
17.277 Workforce Investment Act (wia) National Emergency Grants $174,574
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $165,397
17.259 Wia Youth Activities $164,548
17.258 Wia Adult Program $154,529
17.207 Employment Service/wagner-Peyser Funded Activities $146,483
17.278 Wia Dislocated Worker Formula Grants $118,120
14.218 Community Development Block Grants/entitlement Grants $44,268
17.801 Jobs for Veterans State Grants $3,226
17.225 Unemployment Insurance $1,032
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $494
17.274 Youthbuild $-2,202