2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number: S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation purchased the following items during the audit period: an HVAC system in the amount of $1,420,440; paving for a traffic improvement project in the amount of $1,069,051; and a dehumidification unit for the pool in the amount of $328,076. The dehumidification unit for the pool was added to the capital asset listing; however, the source of the funding, who holds title, percentage of federal participation in the project costs for the federal award, and the condition of property were not noted. The HVAC system and the traffic improvement project were not included on the asset listing. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." INDIANA STATE BOARD OF ACCOUNTS 18 NORTH ADAMS COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d)(1) states: "Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, assets purchased with federal dollars were not properly added to the School Corporation's asset listing. In addition, the one asset added did not have all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and new assets are added. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number: S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation purchased the following items during the audit period: an HVAC system in the amount of $1,420,440; paving for a traffic improvement project in the amount of $1,069,051; and a dehumidification unit for the pool in the amount of $328,076. The dehumidification unit for the pool was added to the capital asset listing; however, the source of the funding, who holds title, percentage of federal participation in the project costs for the federal award, and the condition of property were not noted. The HVAC system and the traffic improvement project were not included on the asset listing. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." INDIANA STATE BOARD OF ACCOUNTS 18 NORTH ADAMS COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d)(1) states: "Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, assets purchased with federal dollars were not properly added to the School Corporation's asset listing. In addition, the one asset added did not have all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and new assets are added. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.