Audit 42458

FY End
2022-12-31
Total Expended
$100.14M
Findings
0
Programs
64
Year: 2022 Accepted: 2023-09-22

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $32.71M Yes 0
93.498 Provider Relief Fund $2.65M - 0
93.210 Tribal Self-Governance Program: Ihs Compacts/funding Agreements $1.92M Yes 0
93.665 Emergency Grants to Address Mental and Substance Use Disorders During Covid-19 $1.42M - 0
11.300 Investments for Public Works and Economic Development Facilities $1.40M - 0
93.237 Special Diabetes Program for Indians_diabetes Prevention and Treatment Projects $1.29M - 0
15.042 Indian School Equalization Program $1.03M - 0
15.047 Indian Education Facilities, Operations, and Maintenance $478,819 - 0
11.804 Mbda Business Center - American Indian and Alaska Native $306,033 - 0
10.912 Environmental Quality Incentives Program $290,456 - 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $271,014 Yes 0
84.010 Title I Grants to Local Educational Agencies $265,505 - 0
15.022 Tribal Self-Governance $261,297 Yes 0
93.788 Opioid Str $248,788 - 0
15.046 Administrative Cost Grants for Indian Schools $224,565 - 0
66.605 Performance Partnership Grants $190,920 - 0
15.044 Indian Schools_student Transportation $178,845 - 0
16.608 Tribal Court Assistance Program $159,341 - 0
93.575 Child Care and Development Block Grant $132,613 Yes 0
84.027 Special Education_grants to States $124,901 - 0
16.575 Crime Victim Assistance $118,238 - 0
93.441 Indian Self-Determination $117,296 - 0
84.425 Education Stabilization Fund $114,870 - 0
16.582 Crime Victim Assistance/discretionary Grants $99,796 - 0
16.841 Voca Tribal Victim Services Set-Aside Program $94,139 - 0
10.558 Child and Adult Care Food Program $93,442 - 0
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $87,251 - 0
66.419 Water Pollution Control State, Interstate, and Tribal Program Support $86,328 - 0
10.567 Food Distribution Program on Indian Reservations $76,694 - 0
16.587 Violence Against Women Discretionary Grants for Indian Tribal Governments $72,891 - 0
93.594 Tribal Work Grants $69,904 - 0
93.556 Promoting Safe and Stable Families $60,262 - 0
93.889 National Bioterrorism Hospital Preparedness Program $59,344 - 0
15.639 Tribal Wildlife Grants Program $48,205 - 0
93.569 Community Services Block Grant $43,300 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $43,225 - 0
93.762 A Comprehensive Approach to Good Health and Wellness in Indian County ? Financed Solely by Prevention and Public Health $42,514 - 0
84.336 Teacher Quality Partnership Grants $41,905 - 0
15.662 Great Lakes Restoration $41,329 - 0
97.067 Homeland Security Grant Program $40,732 - 0
16.750 Support for Adam Walsh Act Implementation Grant Program $39,587 - 0
15.630 Coastal Program $36,267 - 0
93.558 Temporary Assistance for Needy Families $36,224 - 0
15.151 Education Program Enhancements $33,397 - 0
11.307 Economic Adjustment Assistance $26,408 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $22,792 - 0
93.047 Special Programs for the Aging_title Vi, Part A, Grants to Indian Tribes_part B, Grants to Native Hawaiians $20,842 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $19,959 - 0
10.664 Cooperative Forestry Assistance $19,917 - 0
17.265 Native American Employment and Training $19,553 - 0
45.308 Native American/native Hawaiian Museum Services Program $17,678 - 0
84.181 Special Education-Grants for Infants and Families $17,102 - 0
16.024 Tribal Sexual Assault Services Program $14,648 - 0
93.600 Head Start $13,927 - 0
14.231 Emergency Solutions Grant Program $13,040 - 0
93.587 Promote the Survival and Continuing Vitality of Native American Languages $12,466 - 0
93.568 Low-Income Home Energy Assistance $10,241 - 0
66.038 Training, Investigations, and Special Purpose Activities of Federally-Recognized Indian Tribes Consistent with the Clean Air Act (caa), Tribal Sovereignty and the Protection and Management of Air Quality $9,386 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $5,260 - 0
16.583 Children's Justice Act Partnerships for Indian Communities $1,818 - 0
16.710 Public Safety Partnership and Community Policing Grants $1,167 - 0
93.581 Improving the Capability of Indian Tribal Governments to Regulate Environmental Quality $956 - 0
45.311 Native American and Native Hawaiian Library Services $833 - 0
93.053 Nutrition Services Incentive Program $175 - 0

Contacts

Name Title Type
PMNWBLLRNMM3 Robert Schulte Auditee
9066356050 Trina Ochs Auditor
No contacts on file

Notes to SEFA

Accounting Policies: NOTE A - BASIS OF PRESENTATIONThe accompanying Schedule of Expenditures of Federal Awards includes the Federal grant activity of theSault Ste. Marie Tribe of Chippewa Indians, and is presented on the modified accrual basis of accounting.The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code ofFederal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and AuditRequirements for Federal Awards ("Uniform Guidance"). Therefore, some amounts presented in thisschedule may differ from amounts presented in, or used in the preparation of, the basic financialstatements.NOTE B - COST REPORTSManagement has reported that expenditures in the Schedule of Expenditures of Federal Awards are equalto or derived from amounts reported in the annual or final cost reports. Unallowed differences, if any,have been disclosed to the auditor.NOTE C - PROVIDER RELIEF FUNDSThe amount reported on the Schedule of Expenditures of Federal Awards for Provider Relief Funds isbased upon the January 1, 2021 to December 31, 2021 Provider Relief Fund reporting.NOTE D - FINANCIAL REPORTSThe financial reports including claims for advances and reimbursements and amounts claimed or used formatching, are timely, complete, accurate and contain information that is supported by the books andrecords from which the basic financial statements have been prepared.NOTE E - PASS-THROUGH SUBAWARDSThe Tribe receives certain federal grants as subawards from non-federal entities. The Pass-throughNumber represents the facility's provider I.D. number. Some of these numbers were either not availableor not provided by state or local administering agencies for the program reported in the accompanyingschedule. Pass-through entities, where applicable, have been identified in the Schedule with anabbreviation, defined as follows:Pass-through AgencyAbbreviation Pass-through Agency NameCCC Commodity Credit CorporationMDE Michigan Department of EducationMDHHS Michigan Department of Health and Human ServicesMSP Michigan State PoliceSOM State of MichiganUPAAA Upper Peninsula Area Agency on AgingNOTE F - INDIAN HEALTH SERVICE ("IHS") BUYBACKS FOR PURCHASED SERVICESPurchased services are reported in the schedule at the fair value of the services rendered. The estimatedvalue of purchased services for the year ended December 31, 2022, totaled $795,355 for the IHSprograms.NOTE G - FOOD DISTRIBUTIONNon-monetary assistance is reported in the schedule at fair market value of the commodities received anddisbursed.NOTE H - RELATED PARTIESThroughout the normal course of operations, various funds of the Tribe interact with fund transfers, sales,expenses and taxes. These transactions are approved as a part of the system of internal control.Specifically, the Tribe contracts a significant portion of its construction projects provided by Federalfunds to Sault Tribe Construction, an internal service fund of the Tribe, and purchases of fixed assetsfrom Gitchi Auto, Home and Recreation. Northern Travel, an internal service fund of the Tribe, controlstravel accommodations, airfare, etc. for some programs. The Self Insurance Fund provides significantcoverages recorded as Federal grant expenditures. The Tribal Centers, Building and Equipment Fundleases space to programs.NOTE I - DE-MINIMIS INDIRECT COST RATEThe Tribe did not use the 10% de-minimis indirect cost rate under the Uniform AdministrativeRequirements.NOTE J - UNEARNED REVENUE ANALYSISSelf-GovernanceProgramUnearnedRevenue(AccountsReceivable)BeginningReceipts/Adjustments ExpendituresUnearnedRevenue(AccountsReceivable)EndingBIA - 2010 $ 4,531 $ - $ - $ 4,531BIA - 2011 37,237 - - 37,237BIA - 2012 29,411 - - 29,411BIA - 2013 30,158 - - 30,158BIA - 2014 121,271 - - 121,271BIA - 2015 32,519 - - 32,519BIA - 2016 87,553 - (28,162) 59,391BIA - 2017 123,488 - (10,731) 112,757BIA - 2018 216,074 - (177,398) 38,676BIA - 2019 427,8 De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.