Audit 20921

FY End
2022-12-31
Total Expended
$791,003
Findings
2
Programs
2
Organization: Fox Run Village, Inc. (MI)
Year: 2022 Accepted: 2023-09-14

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
20240 2022-001 - - L
596682 2022-001 - - L

Contacts

Name Title Type
C82MU7ZB9618 Dj Vail Auditee
4104022198 Victoria E. Brennan Auditor
No contacts on file

Notes to SEFA

Title: 3.Federal Emergency Management Agency COVID-19 Disaster Grants - Public As Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) summarizes the federal expenditures of Fox Run Village, Inc. (FRV) under programs of the federal government for the year ended December 31, 2022. The information in this 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 (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of FRV, it is not intended to and does not present the financial position, the results of its operations and the cash flows of FRV.For purposes of the Schedule, federal awards include all awards in the form of grants, contracts, and similar agreements entered into directly between FRV and agencies and departments of the federal government and non-federal pass-through entities. Federal Assistance Listing and pass-through identification numbers are included when available. De Minimis Rate Used: N Rate Explanation: For the purpose of the Schedule, expenditures for federal award programs are recognized on the accrual basis of accounting. FRV has not elected to use the 10% de minimis rate for indirect costs. Indirect costs are not applicable for FRVs expenditure reporting. In 2022, FRV received approval of their project related to Federal Emergency Management Agency Disaster Grants Public Assistance (Presidentially Declared Disasters) funding passed thru from the Michigan State Police Emergency Management and Homeland Security Division. As required by the OMB Compliance Supplement, non-federal entities must record expenditures on the Schedule when (1) FEMA has approved the non-federal entity's project, and (2) the non-federal entity has incurred the eligible expenditures. FRV, as such, recorded $62,800 in expenditures on the Schedule, all of which were incurred prior to 2022.
Title: 4.U.S. Department of Health and Human Services (HHS) Awards for the COVID- Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) summarizes the federal expenditures of Fox Run Village, Inc. (FRV) under programs of the federal government for the year ended December 31, 2022. The information in this 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 (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of FRV, it is not intended to and does not present the financial position, the results of its operations and the cash flows of FRV.For purposes of the Schedule, federal awards include all awards in the form of grants, contracts, and similar agreements entered into directly between FRV and agencies and departments of the federal government and non-federal pass-through entities. Federal Assistance Listing and pass-through identification numbers are included when available. De Minimis Rate Used: N Rate Explanation: For the purpose of the Schedule, expenditures for federal award programs are recognized on the accrual basis of accounting. FRV has not elected to use the 10% de minimis rate for indirect costs. Indirect costs are not applicable for FRVs expenditure reporting. The Schedule includes grant activity related to the Department of Health and Human Services ("HHS") COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Assistance Listing Number 93.498. As required based on guidance in the 2022 OMB Compliance Supplement, the Schedule includes all Period 3 funds received between January 1, 2021 and June 30, 2021 and expended by June 30, 2022 and all Period 4 Funds received between July 1, 2021 and December 31, 2021 and expended by December 31, 2022 as reported to Health Resources and Services Administration (HRSA) via the PRF Reporting Portal. The grant activity associated with this Assistance Listing # can include lost revenues and direct expenditures. The total amount recognized in the Schedule of $728,203 for the year ended December 31, 2022, included only lost revenues.

Finding Details

Finding 2022-001: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Reporting Cluster: Not applicable Federal Agency: Department of Health and Human Services (?HHS?) Award Name: Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Assistance Listing #: 93.498 Assistance Listing Title: COVID-19 - Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution ? Period 4 Award Year(s): January 1, 2020 ? December 31, 2022 Criteria Step Six of the Steps on Reporting on Use of Funds section of the June 11, 2021 Provider Relief Fund (?PRF?) General and Targeted Distribution Post-Payment Notice of Reporting Requirements requires recipients that apply PRF payments toward lost revenues to use one of the following three options for calculating lost revenues: ? Option (i): difference between actual patient care revenues and actuals for each quarter during the period of availability; ? Option (ii): difference between budgeted (budget approved prior to March 27, 2020) and actual patient care revenues for each quarter during the period of availability; or ? Option (iii): any reasonable method of estimating revenues Condition Through our prior year testing of FRV?s Periods 1 and 2 HRSA reporting portal submission, we identified discrepancies between the budgeted patient care revenue amounts input into the portal and the amounts approved by the Community?s Board of Directors on February 26, 2020, as part of the entity?s 5-year plan, which support FRV?s lost revenue calculation. Management went to correct the prior year lost revenue calculation and did not correctly update some formulas that were still pulling data from prior year inaccurate workpapers. Cause In reporting period 4, to correct the prior year error, management updated the lost revenue calculation that was reported via the HSRA portal for periods 1 and 2 to utilize the appropriate approved budget amounts. However, in management?s corrected calculation a portion of the revised lost revenue calculation was still pulling from the incorrect budgeted amounts due to a formula error within Management?s internal workpapers which was incorrectly pulling from the prior year budget workpaper. Although Management attempted to correct the lost revenue calculation, review over the updated calculation was not performed at a detailed enough level to have caught the formula issue. Effect Inputs into the lost revenue calculation were not complete and accurate and could have impacted the total lost revenue calculated by FRV. The amounts input incorrectly into the approved budgeted line did not have an impact on lost revenue that FRV could claim in the reporting period as FRV maintained sufficient capacity in amounts that qualified for use. The resulting total impact increased the lost revenue of FRV by $52,000. Questioned Costs There are no questioned costs associated with this finding as the exceptions noted relate to an aspect of reporting which would have increased the potential qualifying funds of FRV.
Finding 2022-001: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Reporting Cluster: Not applicable Federal Agency: Department of Health and Human Services (?HHS?) Award Name: Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Assistance Listing #: 93.498 Assistance Listing Title: COVID-19 - Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution ? Period 4 Award Year(s): January 1, 2020 ? December 31, 2022 Criteria Step Six of the Steps on Reporting on Use of Funds section of the June 11, 2021 Provider Relief Fund (?PRF?) General and Targeted Distribution Post-Payment Notice of Reporting Requirements requires recipients that apply PRF payments toward lost revenues to use one of the following three options for calculating lost revenues: ? Option (i): difference between actual patient care revenues and actuals for each quarter during the period of availability; ? Option (ii): difference between budgeted (budget approved prior to March 27, 2020) and actual patient care revenues for each quarter during the period of availability; or ? Option (iii): any reasonable method of estimating revenues Condition Through our prior year testing of FRV?s Periods 1 and 2 HRSA reporting portal submission, we identified discrepancies between the budgeted patient care revenue amounts input into the portal and the amounts approved by the Community?s Board of Directors on February 26, 2020, as part of the entity?s 5-year plan, which support FRV?s lost revenue calculation. Management went to correct the prior year lost revenue calculation and did not correctly update some formulas that were still pulling data from prior year inaccurate workpapers. Cause In reporting period 4, to correct the prior year error, management updated the lost revenue calculation that was reported via the HSRA portal for periods 1 and 2 to utilize the appropriate approved budget amounts. However, in management?s corrected calculation a portion of the revised lost revenue calculation was still pulling from the incorrect budgeted amounts due to a formula error within Management?s internal workpapers which was incorrectly pulling from the prior year budget workpaper. Although Management attempted to correct the lost revenue calculation, review over the updated calculation was not performed at a detailed enough level to have caught the formula issue. Effect Inputs into the lost revenue calculation were not complete and accurate and could have impacted the total lost revenue calculated by FRV. The amounts input incorrectly into the approved budgeted line did not have an impact on lost revenue that FRV could claim in the reporting period as FRV maintained sufficient capacity in amounts that qualified for use. The resulting total impact increased the lost revenue of FRV by $52,000. Questioned Costs There are no questioned costs associated with this finding as the exceptions noted relate to an aspect of reporting which would have increased the potential qualifying funds of FRV.