FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626, Activities Allowed or Unallowed; Allowable Costs/Cost Principles; and Matching, Level of Effort, and Earmarking - Inappropriate Telecommunication Expenditures See Schedule of Findings and Questioned Costs for chart/table. Condition The Department of Natural Resources (DNR) did not ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster were incurred for fish and wildlife activities. We reviewed 1 sampled telecommunication transaction related to 196 employees. We sampled 20 of those employees and noted 2 (10%) employees did not work on fish and wildlife activities. Criteria Federal regulation 2 CFR 200.303 requires the auditee to establish and maintain effective internal control over federal awards that provides reasonable assurance the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Also, Subpart E of federal regulation 2 CFR 200 requires costs charged to federal programs be necessary and reasonable for the administration of the federal award and be in accordance with the relative benefits received by the program. In addition, federal regulation 2 CFR 200.306 requires costs used for matching be allowable costs to the federal award. Cause DNR informed us because of an oversight error, it did not timely identify these employees to be removed from the monthly telecommunication bill. Effect DNR charged the Fish and Wildlife Cluster for telecommunication expenditures related to employees who worked on non-fish and wildlife activities. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend DNR ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster are incurred for fish and wildlife activities. Management Views DNR agrees with the finding.
FINDING 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626, Activities Allowed or Unallowed; Allowable Costs/Cost Principles; and Matching, Level of Effort, and Earmarking - Inappropriate Telecommunication Expenditures See Schedule of Findings and Questioned Costs for chart/table. Condition The Department of Natural Resources (DNR) did not ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster were incurred for fish and wildlife activities. We reviewed 1 sampled telecommunication transaction related to 196 employees. We sampled 20 of those employees and noted 2 (10%) employees did not work on fish and wildlife activities. Criteria Federal regulation 2 CFR 200.303 requires the auditee to establish and maintain effective internal control over federal awards that provides reasonable assurance the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Also, Subpart E of federal regulation 2 CFR 200 requires costs charged to federal programs be necessary and reasonable for the administration of the federal award and be in accordance with the relative benefits received by the program. In addition, federal regulation 2 CFR 200.306 requires costs used for matching be allowable costs to the federal award. Cause DNR informed us because of an oversight error, it did not timely identify these employees to be removed from the monthly telecommunication bill. Effect DNR charged the Fish and Wildlife Cluster for telecommunication expenditures related to employees who worked on non-fish and wildlife activities. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend DNR ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster are incurred for fish and wildlife activities. Management Views DNR agrees with the finding.
FINDING 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626, Activities Allowed or Unallowed; Allowable Costs/Cost Principles; and Matching, Level of Effort, and Earmarking - Inappropriate Telecommunication Expenditures See Schedule of Findings and Questioned Costs for chart/table. Condition The Department of Natural Resources (DNR) did not ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster were incurred for fish and wildlife activities. We reviewed 1 sampled telecommunication transaction related to 196 employees. We sampled 20 of those employees and noted 2 (10%) employees did not work on fish and wildlife activities. Criteria Federal regulation 2 CFR 200.303 requires the auditee to establish and maintain effective internal control over federal awards that provides reasonable assurance the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Also, Subpart E of federal regulation 2 CFR 200 requires costs charged to federal programs be necessary and reasonable for the administration of the federal award and be in accordance with the relative benefits received by the program. In addition, federal regulation 2 CFR 200.306 requires costs used for matching be allowable costs to the federal award. Cause DNR informed us because of an oversight error, it did not timely identify these employees to be removed from the monthly telecommunication bill. Effect DNR charged the Fish and Wildlife Cluster for telecommunication expenditures related to employees who worked on non-fish and wildlife activities. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend DNR ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster are incurred for fish and wildlife activities. Management Views DNR agrees with the finding.
FINDING 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626, Activities Allowed or Unallowed; Allowable Costs/Cost Principles; and Matching, Level of Effort, and Earmarking - Inappropriate Telecommunication Expenditures See Schedule of Findings and Questioned Costs for chart/table. Condition The Department of Natural Resources (DNR) did not ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster were incurred for fish and wildlife activities. We reviewed 1 sampled telecommunication transaction related to 196 employees. We sampled 20 of those employees and noted 2 (10%) employees did not work on fish and wildlife activities. Criteria Federal regulation 2 CFR 200.303 requires the auditee to establish and maintain effective internal control over federal awards that provides reasonable assurance the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Also, Subpart E of federal regulation 2 CFR 200 requires costs charged to federal programs be necessary and reasonable for the administration of the federal award and be in accordance with the relative benefits received by the program. In addition, federal regulation 2 CFR 200.306 requires costs used for matching be allowable costs to the federal award. Cause DNR informed us because of an oversight error, it did not timely identify these employees to be removed from the monthly telecommunication bill. Effect DNR charged the Fish and Wildlife Cluster for telecommunication expenditures related to employees who worked on non-fish and wildlife activities. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend DNR ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster are incurred for fish and wildlife activities. Management Views DNR agrees with the finding.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
AL Numbers: 10.760, 93.575 Name of Federal Program or Cluster: Water and Waste Disposal Systems for Rural Communities, Xhild Care and Development Block Grant – CCDF Cluster and COVID-19 CCDF Cluster Award Number: Multiple, 21PANDCCDF,22PANDCCDD, 23PANDCCDD Award Year: 2021, 2022, 2023 Criteria – In accordance with the Tribe’s grant award requirements and the Uniform Guidance 2 CFR 200.306, the Tribe must have internal controls over and ensure compliance with any federal cost-sharing/matching and earmarking requirements. Additionally, for the CCDF Cluster program, Tribal lead agencies must spend at least 12% of the total CCDF program expenditures on quality improvement activities. Tribal lead agencies must spend 3% of the 12% on activities to increase the quality of care for infants and toddlers. Condition and context – We noted the following for each program: ALN 10.760 – The program was unable to provide us evidence of monitoring of or compliance with the Tribe’s cost-sharing contributions for the program’s operations. ALN 93.575 – The program did not meet the minimum threshold of 12% on quality improvement activities during the year ended September 30, 2023. Additionally, the program did not monitor expenditures against the 3% threshold on quality improvement activities to increase the quality of care for infants and toddlers. Cause – Inadequate internal controls over cost-sharing and earmarking requirements may have led to this finding. Questioned costs – There are no questioned costs to report related to this finding. Effect – The Tribe could be subject to repayment of funds for not meeting cost-sharing and earmarking requirements. Repeat finding – This is a repeat finding for the CCDF Cluster program and was reported in the prior year as finding 2022-004. Recommendation – The programs should establish and implement internal controls over cost-sharing and earmarking requirements and implement a supervisory review over these requirements. Views of responsible officials and planned corrective actions – ALN 10.760: The Program will work with the Finance Department to thoroughly review the grant award documentation for any cost-sharing contribution requirements. If identified, this requirement will be marked on the intake form and tracked by the Finance Department. ALN 93.575: The Program satisfied these matching requirements in fiscal year 2024. In future awards, the Program will ensure that the match requirements are met in the appropriate period of performance.
AL Numbers: 10.760, 93.575 Name of Federal Program or Cluster: Water and Waste Disposal Systems for Rural Communities, Xhild Care and Development Block Grant – CCDF Cluster and COVID-19 CCDF Cluster Award Number: Multiple, 21PANDCCDF,22PANDCCDD, 23PANDCCDD Award Year: 2021, 2022, 2023 Criteria – In accordance with the Tribe’s grant award requirements and the Uniform Guidance 2 CFR 200.306, the Tribe must have internal controls over and ensure compliance with any federal cost-sharing/matching and earmarking requirements. Additionally, for the CCDF Cluster program, Tribal lead agencies must spend at least 12% of the total CCDF program expenditures on quality improvement activities. Tribal lead agencies must spend 3% of the 12% on activities to increase the quality of care for infants and toddlers. Condition and context – We noted the following for each program: ALN 10.760 – The program was unable to provide us evidence of monitoring of or compliance with the Tribe’s cost-sharing contributions for the program’s operations. ALN 93.575 – The program did not meet the minimum threshold of 12% on quality improvement activities during the year ended September 30, 2023. Additionally, the program did not monitor expenditures against the 3% threshold on quality improvement activities to increase the quality of care for infants and toddlers. Cause – Inadequate internal controls over cost-sharing and earmarking requirements may have led to this finding. Questioned costs – There are no questioned costs to report related to this finding. Effect – The Tribe could be subject to repayment of funds for not meeting cost-sharing and earmarking requirements. Repeat finding – This is a repeat finding for the CCDF Cluster program and was reported in the prior year as finding 2022-004. Recommendation – The programs should establish and implement internal controls over cost-sharing and earmarking requirements and implement a supervisory review over these requirements. Views of responsible officials and planned corrective actions – ALN 10.760: The Program will work with the Finance Department to thoroughly review the grant award documentation for any cost-sharing contribution requirements. If identified, this requirement will be marked on the intake form and tracked by the Finance Department. ALN 93.575: The Program satisfied these matching requirements in fiscal year 2024. In future awards, the Program will ensure that the match requirements are met in the appropriate period of performance.
Finding 2023-001 Significant Deficiency – Matching Federal Assistance Listing No. 20.106 U.S. Department of Transportation Airport Improvement Program Criteria: All match funding must be provided in compliance with the requirements of 2 CFR Part 200.306. The Authority’s share of projects costs on an Airport Improvement Grant is defined in 49 USC 47109 and set forth in the grant agreement. The nonfederal share was 10 percent. Condition: Grant number 3-12-0053-040-2022 request for reimbursement number 4 included the nonfederal share for one invoice. Cause: The form used by the Authority contained a formula error that resulted in the Airport Improvement Program share to calculate at 100 percent instead of the required 90 percent. The error was not identified in the Authority’s review process of reimbursement number 4. It was subsequently identified by the Authority during the preparation of a subsequent grant draw. Effect: This condition resulted in an overpayment to the Authority of $62,469. If not corrected in future drawdowns, the grantor agency could deem the Authority to be non-compliant. Questioned Costs: Not applicable. Recommendation: We recommend that the Authority contact the grantor agency to correct the overpayment and also review its internal controls as it relates to complying with matching requirements.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626, Activities Allowed or Unallowed; Allowable Costs/Cost Principles; and Matching, Level of Effort, and Earmarking - Inappropriate Telecommunication Expenditures See Schedule of Findings and Questioned Costs for chart/table. Condition The Department of Natural Resources (DNR) did not ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster were incurred for fish and wildlife activities. We reviewed 1 sampled telecommunication transaction related to 196 employees. We sampled 20 of those employees and noted 2 (10%) employees did not work on fish and wildlife activities. Criteria Federal regulation 2 CFR 200.303 requires the auditee to establish and maintain effective internal control over federal awards that provides reasonable assurance the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Also, Subpart E of federal regulation 2 CFR 200 requires costs charged to federal programs be necessary and reasonable for the administration of the federal award and be in accordance with the relative benefits received by the program. In addition, federal regulation 2 CFR 200.306 requires costs used for matching be allowable costs to the federal award. Cause DNR informed us because of an oversight error, it did not timely identify these employees to be removed from the monthly telecommunication bill. Effect DNR charged the Fish and Wildlife Cluster for telecommunication expenditures related to employees who worked on non-fish and wildlife activities. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend DNR ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster are incurred for fish and wildlife activities. Management Views DNR agrees with the finding.
FINDING 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626, Activities Allowed or Unallowed; Allowable Costs/Cost Principles; and Matching, Level of Effort, and Earmarking - Inappropriate Telecommunication Expenditures See Schedule of Findings and Questioned Costs for chart/table. Condition The Department of Natural Resources (DNR) did not ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster were incurred for fish and wildlife activities. We reviewed 1 sampled telecommunication transaction related to 196 employees. We sampled 20 of those employees and noted 2 (10%) employees did not work on fish and wildlife activities. Criteria Federal regulation 2 CFR 200.303 requires the auditee to establish and maintain effective internal control over federal awards that provides reasonable assurance the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Also, Subpart E of federal regulation 2 CFR 200 requires costs charged to federal programs be necessary and reasonable for the administration of the federal award and be in accordance with the relative benefits received by the program. In addition, federal regulation 2 CFR 200.306 requires costs used for matching be allowable costs to the federal award. Cause DNR informed us because of an oversight error, it did not timely identify these employees to be removed from the monthly telecommunication bill. Effect DNR charged the Fish and Wildlife Cluster for telecommunication expenditures related to employees who worked on non-fish and wildlife activities. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend DNR ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster are incurred for fish and wildlife activities. Management Views DNR agrees with the finding.
FINDING 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626, Activities Allowed or Unallowed; Allowable Costs/Cost Principles; and Matching, Level of Effort, and Earmarking - Inappropriate Telecommunication Expenditures See Schedule of Findings and Questioned Costs for chart/table. Condition The Department of Natural Resources (DNR) did not ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster were incurred for fish and wildlife activities. We reviewed 1 sampled telecommunication transaction related to 196 employees. We sampled 20 of those employees and noted 2 (10%) employees did not work on fish and wildlife activities. Criteria Federal regulation 2 CFR 200.303 requires the auditee to establish and maintain effective internal control over federal awards that provides reasonable assurance the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Also, Subpart E of federal regulation 2 CFR 200 requires costs charged to federal programs be necessary and reasonable for the administration of the federal award and be in accordance with the relative benefits received by the program. In addition, federal regulation 2 CFR 200.306 requires costs used for matching be allowable costs to the federal award. Cause DNR informed us because of an oversight error, it did not timely identify these employees to be removed from the monthly telecommunication bill. Effect DNR charged the Fish and Wildlife Cluster for telecommunication expenditures related to employees who worked on non-fish and wildlife activities. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend DNR ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster are incurred for fish and wildlife activities. Management Views DNR agrees with the finding.
FINDING 2023-024 Fish and Wildlife Cluster, ALN 15.605, 15.611, and 15.626, Activities Allowed or Unallowed; Allowable Costs/Cost Principles; and Matching, Level of Effort, and Earmarking - Inappropriate Telecommunication Expenditures See Schedule of Findings and Questioned Costs for chart/table. Condition The Department of Natural Resources (DNR) did not ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster were incurred for fish and wildlife activities. We reviewed 1 sampled telecommunication transaction related to 196 employees. We sampled 20 of those employees and noted 2 (10%) employees did not work on fish and wildlife activities. Criteria Federal regulation 2 CFR 200.303 requires the auditee to establish and maintain effective internal control over federal awards that provides reasonable assurance the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Also, Subpart E of federal regulation 2 CFR 200 requires costs charged to federal programs be necessary and reasonable for the administration of the federal award and be in accordance with the relative benefits received by the program. In addition, federal regulation 2 CFR 200.306 requires costs used for matching be allowable costs to the federal award. Cause DNR informed us because of an oversight error, it did not timely identify these employees to be removed from the monthly telecommunication bill. Effect DNR charged the Fish and Wildlife Cluster for telecommunication expenditures related to employees who worked on non-fish and wildlife activities. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend DNR ensure that telecommunication expenditures charged to the Fish and Wildlife Cluster are incurred for fish and wildlife activities. Management Views DNR agrees with the finding.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
FINDING 2023-008 MDHHS, PACAP - Inappropriate PACAP Allocation See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not ensure it used the appropriate Public Assistance Cost Allocation Plan (PACAP) data to allocate expenditures to its federal programs. We noted: a. 2 (1%) of 203 statistic groups for which MDHHS used incorrect data to calculate the PACAP percentages, which affected 6 (40%) of 15 sampled cost pools. b. 2 (13%) of 16 Random Moment Time Studies, which MDHHS used to calculate PACAP percentages, did not have a complete population of participants, which affected 6 (40%) of 15 sampled cost pools. Criteria Federal regulation 45 CFR 95.507 and Appendix VI of federal regulation 2 CFR 200 state costs are allocable to a particular cost objective if the services involved are chargeable or assignable to such cost objective in accordance with relative benefits received. Federal regulation 45 CFR 95.517 requires MDHHS to claim federal financial participation for costs associated with a program only in accordance with its approved or amended (at its discretion) PACAP. Federal regulation 2 CFR 200.306 requires that costs used for matching be allowable costs to the federal award. Cause MDHHS informed us its current quality control processes did not detect the errors. Effect MDHHS incorrectly allocated expenditures to various federal programs. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs Undeterminable. Recommendation We recommend MDHHS ensure it uses the appropriate PACAP data to allocate expenditures to its federal programs. Management Views MDHHS disagrees the exceptions identified should rise to the level of a significant deficiency and noncompliance. The comprehensive set of quality control processes continue to operate as designed to identify any errors greater than 5.0% of the total difference of the given statistical group from the previous quarter and none of the errors identified in the finding fell outside of this range. For part a., the auditor's review included all related statistical records within each statistical group for the 15 sampled cost pools. This includes all statistics used in the cost allocation process for the entire fiscal year because the costs that originate in these cost pools are referenced in all other cost pools. After review of all fiscal year 2023 statistical data, 6 individual statistical records out of 6,548 were found to be in error. After recalculating the cost allocated amounts related to this error, we identified that approximately $15,346 was overclaimed to LIHEAP out of $1,732,426,561 (0.0009%) of costs allocated in fiscal year 2023 by MDHHS. The other program areas identified were underclaimed. For part b., MDHHS acknowledges the exclusion of a participant from two quarters (quarter three and quarter four) of the Family Independence Specialists/Eligibility Specialists (FIS/ES) Random Moment Time Study (RMTS) in the sample. Although the actual dollar value impact of excluding a participant is indeterminable, MDHHS concluded the impact would be immaterial because there are over 6,000 RMTS participants each quarter and RMTS results vary little from quarter to quarter from non-programmatic changes. Auditor's Comments to Management Views For part a., we calculated the cost allocated amounts related to the error and identified that approximately $17,317 was overclaimed to LIHEAP out of $141.0 million of second quarter expenditures. However, in combination with part b., we could not conclude overclaims for other federal programs were less than $25,000. For part b., MDHHS used incomplete data to allocate approximately $143.5 million of third quarter expenditures and $171.2 million of fourth quarter expenditures for a total of $314.6 million to various federal and State programs, which may have affected the percentages used to allocate these expenditures. MDHHS did not assess the impact of these incomplete records. Consequently, it has no basis for its "immaterial" statement. Given the errors noted in parts a. and b., we could not determine the combined known questioned costs; however, it is likely that the improper allocation related to the $455.7 million exceeds $25,000 for the federal programs identified. Federal regulation 2 CFR 200.516(a)(3) states that in evaluating the effect of questioned costs on the opinion on noncompliance, the auditor considers the best estimate of total questioned costs (likely questioned costs), not just the questioned costs specifically identified (known questioned costs). The auditor must also report audit findings for known questioned costs when likely questioned costs are greater than $25,000 for a type of compliance requirement for a major program. Therefore, the finding stands as written.
AL Numbers: 10.760, 93.575 Name of Federal Program or Cluster: Water and Waste Disposal Systems for Rural Communities, Xhild Care and Development Block Grant – CCDF Cluster and COVID-19 CCDF Cluster Award Number: Multiple, 21PANDCCDF,22PANDCCDD, 23PANDCCDD Award Year: 2021, 2022, 2023 Criteria – In accordance with the Tribe’s grant award requirements and the Uniform Guidance 2 CFR 200.306, the Tribe must have internal controls over and ensure compliance with any federal cost-sharing/matching and earmarking requirements. Additionally, for the CCDF Cluster program, Tribal lead agencies must spend at least 12% of the total CCDF program expenditures on quality improvement activities. Tribal lead agencies must spend 3% of the 12% on activities to increase the quality of care for infants and toddlers. Condition and context – We noted the following for each program: ALN 10.760 – The program was unable to provide us evidence of monitoring of or compliance with the Tribe’s cost-sharing contributions for the program’s operations. ALN 93.575 – The program did not meet the minimum threshold of 12% on quality improvement activities during the year ended September 30, 2023. Additionally, the program did not monitor expenditures against the 3% threshold on quality improvement activities to increase the quality of care for infants and toddlers. Cause – Inadequate internal controls over cost-sharing and earmarking requirements may have led to this finding. Questioned costs – There are no questioned costs to report related to this finding. Effect – The Tribe could be subject to repayment of funds for not meeting cost-sharing and earmarking requirements. Repeat finding – This is a repeat finding for the CCDF Cluster program and was reported in the prior year as finding 2022-004. Recommendation – The programs should establish and implement internal controls over cost-sharing and earmarking requirements and implement a supervisory review over these requirements. Views of responsible officials and planned corrective actions – ALN 10.760: The Program will work with the Finance Department to thoroughly review the grant award documentation for any cost-sharing contribution requirements. If identified, this requirement will be marked on the intake form and tracked by the Finance Department. ALN 93.575: The Program satisfied these matching requirements in fiscal year 2024. In future awards, the Program will ensure that the match requirements are met in the appropriate period of performance.
AL Numbers: 10.760, 93.575 Name of Federal Program or Cluster: Water and Waste Disposal Systems for Rural Communities, Xhild Care and Development Block Grant – CCDF Cluster and COVID-19 CCDF Cluster Award Number: Multiple, 21PANDCCDF,22PANDCCDD, 23PANDCCDD Award Year: 2021, 2022, 2023 Criteria – In accordance with the Tribe’s grant award requirements and the Uniform Guidance 2 CFR 200.306, the Tribe must have internal controls over and ensure compliance with any federal cost-sharing/matching and earmarking requirements. Additionally, for the CCDF Cluster program, Tribal lead agencies must spend at least 12% of the total CCDF program expenditures on quality improvement activities. Tribal lead agencies must spend 3% of the 12% on activities to increase the quality of care for infants and toddlers. Condition and context – We noted the following for each program: ALN 10.760 – The program was unable to provide us evidence of monitoring of or compliance with the Tribe’s cost-sharing contributions for the program’s operations. ALN 93.575 – The program did not meet the minimum threshold of 12% on quality improvement activities during the year ended September 30, 2023. Additionally, the program did not monitor expenditures against the 3% threshold on quality improvement activities to increase the quality of care for infants and toddlers. Cause – Inadequate internal controls over cost-sharing and earmarking requirements may have led to this finding. Questioned costs – There are no questioned costs to report related to this finding. Effect – The Tribe could be subject to repayment of funds for not meeting cost-sharing and earmarking requirements. Repeat finding – This is a repeat finding for the CCDF Cluster program and was reported in the prior year as finding 2022-004. Recommendation – The programs should establish and implement internal controls over cost-sharing and earmarking requirements and implement a supervisory review over these requirements. Views of responsible officials and planned corrective actions – ALN 10.760: The Program will work with the Finance Department to thoroughly review the grant award documentation for any cost-sharing contribution requirements. If identified, this requirement will be marked on the intake form and tracked by the Finance Department. ALN 93.575: The Program satisfied these matching requirements in fiscal year 2024. In future awards, the Program will ensure that the match requirements are met in the appropriate period of performance.
Per the terms of the award, PAX agreed to expend a share of the total program cost financed by PAX and others from non-federal funds in accordance with 2 CFR 200.306. PAX’s books and records did not contain the necessary information to verify whether this matching requirement was met.
Finding Number: 2023-020 Prior Year Finding Number: 2022-021 Compliance Requirement: Matching, Level of Effort, Earmarking Program: U.S. Department of Agriculture Government Department/Agency: Department of Human Services (DHS) Supplemental Nutrition Assistance Program Cluster (SNAP) ALN: 10.551, 10.561 Award #: Various Award Period: 10/01/21 - 09/30/22 10/01/22 – 09/30/23 Criteria – CFR Section 200.303, Internal Controls, (a) states DHS must establish and maintain effective internal control over federal awards that provides reasonable assurance that DHS is managing the federal awards in compliance with federal statutes, regulations, and terms and conditions of the federal award. Management is responsible for establishing and maintaining a system of internal control that should include controls over its matching process. Further, 2 CFR Section 200.306 provides detailed criteria for acceptable matching costs. The basic criteria for acceptable matching costs include costs that are necessary and reasonable for accomplishment of program objectives and are allowed under 2 CFR Part 200, Subpart E (Cost Principles). Condition – We found that DHS was unable to readily exhibit and provide evidence that it met the matching requirement or monitored compliance with the matching requirement. Questioned Costs – Not determinable. Context – This is a condition identified per review of DHS’ compliance with the specified requirements and general compliance principles. Effect – DHS is not in compliance with the stated provisions. Without adequate internal controls to ensure compliance with matching requirements, there is an increased risk that matching will not be properly applied and funding could be jeopardized. Cause – DHS does not appear to have adequate policies and procedures in place to ensure complete compliance with the matching requirement. Further, lack of monitoring of the match requirement appears to be the result of significant personnel turnover and lack of staffing. Recommendation – We recommend that DHS deploy resources that are given the responsibility to ensure periodic monitoring and compliance of the matching requirement throughout the fiscal year. Views of Responsible Officials – The Government concurs with the auditor’s findings and recommendations. While the ERP provides an overall expense report, a specific liquidation report has been developed to ensure that matching is completed with each report submission. The planned corrective actions are presented in the Government’s Corrective Action Plan attached as Appendix B to the Single Audit Report.
Finding Number: 2023-051 Prior Year Finding Number: 2022-047 Compliance Requirement: Matching, Level of Effort, Earmarking Program: U.S. Department of Education Government Department/Agency: Department of Education (VIDE) Special Education Cluster ALN: 84.027A, 84.027X Award #: Various Award Period: Various Criteria – The Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires that non-federal entities receiving Federal awards (i.e. auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, in accordance with the Uniform Guidance in 2 CFR Section 200.306, a State may not reduce the amount of State financial support for special education and related services for children with disabilities (or State financial support otherwise made available because of the excess costs of educating those children) below the amount of State financial support provided for the preceding fiscal year. The Secretary reduces the allocation of funds under 20 USC 1411 for any fiscal year following the fiscal year in which the State fails to comply with this requirement by the amount by which the State failed to meet the requirement. Additionally, an LEA can use not more than 15% of the amount of federal Part B funds the LEA receives for any fiscal year (less any amount by which it reduces its expenditures under 20 USC 1413(a)(2)(C)) (see III.G.2.1.b.(6) in this section), in combination with other funds, to develop and implement, early intervening services for children in kindergarten through grade 12 who have not been identified under IDEA but need additional academic and behavioral support to succeed in the general education environment (20 USC 1413(f); 34 CFR section 300.226). Condition – We reviewed the level of effort calculations and noted the following: - At the Local Education Agency (LEA) level, we noted that although the two LEAs appeared to meet the required financial support thresholds on the per child basis based on the level of effort compliance requirement, we were unable to verify the number of students for each LEA. - At the State Education Agency (SEA) level, we were unable to review documentation that included the approval /certification of the amounts in the Maintenance of Financial support at the State Education level. In addition, although the calculation shows that VIDE met the Maintenance of Effort at the State level, we were unable to review documentation that would allow us to verify the number of students served in the current year. We reviewed the earmarking documentation and noted the following: - At the State Education Agency (SEA) level, for the non-ARP grant, we were unable to verify the total numbers of students and the number of students in poverty. We were therefore unable to confirm that the allocation of the remaining funds to the LEA agreed with the relative numbers of children living in poverty. As a result, it does not appear that the controls in place are operating at a level of precision to ensure compliance with the level of effort and earmarking compliance requirement. Questioned Costs – Not determinable. Context – This is a condition identified per review of VIDE’s compliance with the specified requirements. Effect – VIDE is not in compliance with the stated provisions. Without adequate internal controls to ensure compliance with level of effort requirements and earmarking, there is an increased risk that level of effort and earmarking requirements will not be properly applied, and funding could be jeopardized. Cause – VIDE did not appear to have adequate policies and procedures in place to ensure consistent and systematic monitoring of the requirements. Recommendation – We recommend that VIDE improve internal controls to ensure adherence to federal regulations relating to the level of effort and earmarking requirements at the SEA and LEA levels by deploying resources that are given the responsibility to ensure periodic monitoring and compliance of the level of effort and earmarking requirements. Views of Responsible Officials – The Government concurs with the auditor’s findings and recommendations. VIDE will establish a team for quarterly reviews of documentation, report issues, and recommend corrective actions. The IDEA State Office will set procedures for verifying accuracy of data reported by LEAs. Comprehensive staff training will ensure understanding of new policies and procedures. The planned corrective actions are presented in the Government’s Corrective Action Plan attached as Appendix B to the Single Audit Report.
Federal Agency: U.S Department of Transportation Assistance Listing Program: 20.106 Airport Improvement Program Federal Award Nos.: 3-68-0001-020-2019, 3-68-0001-025-2022 Area: Matching, Level of Effort, and Earmarking Questioned Costs: $152,120 Criteria: All match funding must be provided in compliance with the requirements of 2 CFR Part 200.306. The grantee’s share of project costs on an AIP grant (also known as cost share) is defined in 49 USC 47109 and set forth in the grant award. The nonfederal share varies by airport size and is generally 25 percent for large and medium hub airports and 10 percent for all other airports. Acceptable match, whether cash or in-kind, must be allowable and eligible. In addition, match must be provided by the recipient; or provided as cash by a third party; or provided as in-kind by a third party; or any combination of cash and in-kind provided by the recipient and/or a third party. Condition: For 3 (or 34%) items tested, the Authority did not consider matching requirements upon request for reimbursement and submission of related signed/dated SF-270 or SF-271 to the Federal Aviation Administration. Consideration of matching requirements for these transactions were subsequently corrected only during the audit process. Cause: The Authority lacks internal control policies and procedures compliance with applicable matching, level of effort, earmarking requirements relative to matching requirements. Effect: The Authority is in noncompliance with applicable matching requirements. Total questioned costs amounted to $152,120. Recommendation: We recommend the Authority’s responsible personnel to establish internal control policies and procedures to require monitoring of matching requirements prior to the submission of request for reimbursement. Views of Responsible Officials and Corrective Action Plan: The Authority agrees with the finding and provides details in its Corrective Action Plan.
2023 – 002 INTERNAL CONTROLS OVER DISBURSEMENTS Significant Deficiency U.S. DEPARTMENTS OF EDUCATION Federal Assistance No. 84.425U COVID-19: ARP - Elementary and Secondary Schools Emergency Relief Passthrough Agency: New Mexico Public Education Department Award Period: July 1, 2022 – June 30, 2023 Allowable Costs/Cost Principles Condition: During the testing there was an invoice in the amount of $299,271 that was paid of twice during June 2023. The expenditure was submitted for reimbursement from federal funds. The District was notified by the vendor of the double payment while asking to use it as credit against a separate invoice. Criteria: PART 200—UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS § 200.303 Internal controls. The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). (b) Comply with the U.S. Constitution, Federal statutes, regulations, and the terms and conditions of the Federal awards. (c) Evaluate and monitor the non-Federal entity's compliance with statutes, regulations and the terms and conditions of Federal awards. (d) Take prompt action when instances of noncompliance are identified including noncompliance identified in audit findings. (e) Take reasonable measures to safeguard protected personally identifiable information and other information the Federal awarding agency or pass-through entity designates as sensitive or the non-Federal entity considers sensitive consistent with applicable Federal, State, local, and tribal laws regarding privacy and responsibility over confidentiality. § 200.403 Factors affecting allowability of costs. Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non- Federal entity. (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost. (e) Be determined in accordance with generally accepted accounting principles (GAAP), except, for state and local governments and Indian tribes only, as otherwise provided for in this part. (f) Not be included as a cost or used to meet cost sharing or matching requirements of any other federally-financed program in either the current or a prior period. See also § 200.306(b). (g) Be adequately documented. See also § 200.300 through 200.309 of this part. (h) Cost must be incurred during the approved budget period. The Federal awarding agency is authorized, at its discretion, to waive prior written approvals to carry forward unobligated balances to subsequent budget periods pursuant to § 200.308(e)(3). Cause: The facilities department submitted the invoice to the finance department for payment at the beginning of June and towards the end of June. The accounts payable clerk bypassed the system error that the invoice number had been entered previously. Questioned costs: $299,271 was the amount of the duplicate payment. The expenditure from the duplicate payment was not reported in the schedule of expenditures in federal awards and was reported as a receivable from the vendor in the financial statements for Fund 24330. Effect or potential effect: Expenditures could be overstated, as well as revenues, if invoices are paid more than once and then also reimbursed. As a result, a receivable and unearned income must be recognized. Recommendation: Training should be given to accounts payable staff regarding the importance system warnings and the need to monitor invoices form the vendors. A tracking system should be implemented for tracking major projects to ensure than invoices are not reported more than once. Invoices should be stamped received upon receipt, marked when applied to a major project, and marked recorded once entered into the accounting system. Management’s response: Executive Director of Finance: Management agrees with this finding. The school district converted to a new financial ERP system as of July 1, 2023. The new ERP system flags any duplicate invoice numbers that maybe entered. The Accounts Payable (A/P) staff will verify if payment has already been made. On occasion, payment requests do not have an invoice number. To prevent duplicate payments, the Accounts Payable staff require original invoices and uses a system generated invoice number, or a will use a manual entry numbering convention to prevent duplicate invoice numbers. The invoice data is entered by an Accounts Payable specialist and reviewed by the Accounts Payable Manager. On occasion, A/P must request corrected invoices from vendors who try and reuse invoice numbers. The A/P Manager reviews invoice numbers during the check run for accuracy. Purchasing and A/P will also periodically review the vendor database for duplicate vendors. For construction projects that list a pay application number instead of an invoice number, A/P will implement a consistent invoice numbering convention to avoid duplicate payments. The A/P specialists will also review the PO payment history prior to processing. Responsible party(ies) for corrective action(s): Accounts Payable Manager Corrective action(s) timeline: December 1, 2023