Audit 314469

FY End
2023-12-31
Total Expended
$10.79M
Findings
2
Programs
24
Year: 2023 Accepted: 2024-07-05

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
477862 2023-001 Material Weakness - I
1054304 2023-001 Material Weakness - I

Programs

ALN Program Spent Major Findings
93.563 Child Support Enforcement $388,235 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $386,455 - 0
84.305 Education Research Program $263,776 - 0
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $263,167 - 0
17.259 Wia Youth Activities $251,333 Yes 0
17.285 Apprenticeship USA Grants $136,508 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $78,666 - 0
17.225 Unemployment Insurance $60,952 - 0
11.307 Economic Adjustment Assistance $40,827 - 0
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $33,669 - 0
17.245 Trade Adjustment Assistance $27,689 - 0
93.558 Temporary Assistance for Needy Families $12,884 - 0
14.252 Section 4 Capacity Building for Community Development and Affordable Housing $12,846 - 0
21.027 Covid -19 - Coronavirus State and Local Fiscal Recovery Funds $12,500 - 0
84.126 Fy23 State Vocational Rehab Services (vr) - Py22 Infrastructure Funding Agreement $10,601 - 0
17.801 Jobs for Veterans State Grants $8,000 - 0
84.126 Fy24 Michigan Rehabilitative Services - Ifa - Py23 Infrastructure Funding Agreement $5,197 - 0
84.126 Fy23 State Vocational Rehab Services (vr) - Py23 Infrastructure Funding Agreement $4,647 - 0
47.041 Engineering $3,817 - 0
20.205 Highway Planning and Construction $2,091 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $1,452 - 0
17.258 Wia Adult Program $723 Yes 0
17.278 Wia Dislocated Worker Formula Grants $650 Yes 0
93.575 Child Care and Development Block Grant $541 - 0

Contacts

Name Title Type
JGDYGG7M6AA5 Kathy Breyfogle Auditee
2693850449 Christina Hardy Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of W.E. Upjohn Unemployment Trustee Corporation (the “Corporation”) under programs of the federal government for the year ended December 31, 2023. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of the Corporation, it is not intended to and does not present the balance sheet, statement of activities and changes in net assets, functional expenses, or cash flows of the Corporation. Expenditures reported in the Schedule are reported on an accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The pass‑through entity identifying numbers are presented where available. The Corporation has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The Corporation has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs as allowed under the Uniform Guidance.

Finding Details

Assistance Listing, Federal Agency, and Program Name 21.027, U.S. Department of Treasury, COVID 19 Coronavirus State & Local Fiscal Recovery Fund Federal Award Identification Number and Year 2023 Pass through Entity Not applicable Finding Type Material weakness and material noncompliance with laws and regulations Repeat Finding No Criteria Per 2 CFR 180.300, before entering into a covered transaction with another person, grant recipients must verify that the person with whom they intend to do business is not excluded or disqualified. This is done by (a) checking SAM exclusions, (b) collecting a certification from that person, or (c) adding a clause or condition to the covered transaction with that person. Condition The Corporation did not perform the suspension or debarment check for contractors, before entering into a contract with them Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context The Corporation entered into various contract agreements with 13 contractors during the year without verifying whether they were excluded or disqualified prior to entering into the contracts. Cause and Effect Controls in place did not ensure the Corporation verified contractors paid were not excluded or disqualified prior to entering into transactions with the contractors. The Corporation did perform the check after the fact and noted that none of the 13 contractors were identified as excluded or disqualified, therefore creating no questioned costs. Recommendation We recommend the Corporation establish a procedure for checking for excluded or disqualified persons prior to entering into contract agreements. Further, we recommend a periodic review process be established to ensure the procedure is implemented timely.
Assistance Listing, Federal Agency, and Program Name 21.027, U.S. Department of Treasury, COVID 19 Coronavirus State & Local Fiscal Recovery Fund Federal Award Identification Number and Year 2023 Pass through Entity Not applicable Finding Type Material weakness and material noncompliance with laws and regulations Repeat Finding No Criteria Per 2 CFR 180.300, before entering into a covered transaction with another person, grant recipients must verify that the person with whom they intend to do business is not excluded or disqualified. This is done by (a) checking SAM exclusions, (b) collecting a certification from that person, or (c) adding a clause or condition to the covered transaction with that person. Condition The Corporation did not perform the suspension or debarment check for contractors, before entering into a contract with them Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context The Corporation entered into various contract agreements with 13 contractors during the year without verifying whether they were excluded or disqualified prior to entering into the contracts. Cause and Effect Controls in place did not ensure the Corporation verified contractors paid were not excluded or disqualified prior to entering into transactions with the contractors. The Corporation did perform the check after the fact and noted that none of the 13 contractors were identified as excluded or disqualified, therefore creating no questioned costs. Recommendation We recommend the Corporation establish a procedure for checking for excluded or disqualified persons prior to entering into contract agreements. Further, we recommend a periodic review process be established to ensure the procedure is implemented timely.