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.
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
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
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
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
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
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
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
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
Department of Health and Human Services FFLA #93.087, 90CU0090, 9/30/2020 – 9/29/2023; 90CU0095, 9/30/2018 – 9/29/2024 Enhance Safety of Children Affected by Substance Abuse Matching Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. In addition, 2 CFR 200.306 establishes that matching funds be verifiable from the non-federal entity’s records and are allowable under Subpart E – Cost Principles and 2 CFR 200.403(g) establishes that costs be adequately documented. Condition: In our sample of expenditures selected for testing, we noted the following items: a) The number of hours an employee worked per the approved timesheet vs. the hours claimed in the match claim workbook resulted in a clerical error. (1 instance) b) Per review of the supporting timesheet and paystub, an employee had mobile crisis pay which was not accurately reduced in the calculation for match in the match claim workbook (2 instances). Cause: The secondary review of match claim workbook did not identify the clerical errors. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. The program was underallocated. Context: A total non-statistical sample of 25 match transactions were tested which accounted for $97,208 out of $488,366 of federal match direct program expenditures. Repeat Finding from Prior Year: No. Recommendation: We recommend management review the procedures and control processes involving the match claim workbook to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.