Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022-001 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-001 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-001 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-001 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Information on the federal program: Subject: Child Nutrition Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Modified Opinion, Noncompliance Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 2 CFR 200.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Procurement compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: There were two small purchase method procurements selected for sample testing for the audit period. One procurement was performed by the School?s Service Center, Wilson Education Center (Service Center). During the 2020-2021 school year, the Service Center solicited, evaluated, and awarded a bid for the milk on behalf of its members that School Corporation used. The Service Center was not audited for the 2020-2021 school year. During our testing of procurement and suspension and debarment for 2020-2021, it was noted that the School Corporation was not have a review control in place to monitor that the Service Center performed all necessary procedures to maintain compliance with federal regulations surrounding procurement and suspension and debarment. For 2020-2021, the School Corporation obtained procurement documents from the Service Center supporting procurements performed during the audit period. There was no documented review control in place at the School Corporation to ensure proper monitoring of the Service Center activities occur to verify federal procurement regulations were followed by the Service Center. There was one vendor that exceeded the $10,000 threshold for the School Corporation during fiscal year 2020-2021 that would require a procurement check. The error in the sample procurement performed by the Service Center selected for testing was isolated to fiscal year 2020-2021. The amount paid to the vendor for 2020-2021 was $22,211. The vendor did not met the suspension and debarment threshold ($25,000) for fiscal year 2020-2021. Proper controls over the same vendor selected for procurement and debarment and suspension were in place for the fiscal year 2021-2022 The second procurement selected for testing was a small purchase performed by the School Corporation for food purchases totaling $103,671 in fiscal year 2020-2021 and $142,368 in fiscal year 2021-2022. We noted that the School Corporation did not obtain three quotes from separate vendors. Additionally, the School Corporation did not perform a suspension and debarment check on the vendor sampled for fiscal years 2020-2021 and 2021-2022. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish controls to ensure compliance with Procurement and Suspension and Debarment compliance requirement. We recommend that management meet periodically with the Wilson Education Center and review and maintain procurement contract files as evidence of proper periodic monitoring of the Service Center. Additionally, we recommended that the School Corporation's management establish a system of internal controls related to ensure that 3 quotes are obtained as required for small purchase method procurements and to ensure the vendors are not debarred or suspended for small purchases procurements performed by the School Corporation. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Information on the federal program: Subject: Child Nutrition Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Modified Opinion, Noncompliance Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 2 CFR 200.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Procurement compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: There were two small purchase method procurements selected for sample testing for the audit period. One procurement was performed by the School?s Service Center, Wilson Education Center (Service Center). During the 2020-2021 school year, the Service Center solicited, evaluated, and awarded a bid for the milk on behalf of its members that School Corporation used. The Service Center was not audited for the 2020-2021 school year. During our testing of procurement and suspension and debarment for 2020-2021, it was noted that the School Corporation was not have a review control in place to monitor that the Service Center performed all necessary procedures to maintain compliance with federal regulations surrounding procurement and suspension and debarment. For 2020-2021, the School Corporation obtained procurement documents from the Service Center supporting procurements performed during the audit period. There was no documented review control in place at the School Corporation to ensure proper monitoring of the Service Center activities occur to verify federal procurement regulations were followed by the Service Center. There was one vendor that exceeded the $10,000 threshold for the School Corporation during fiscal year 2020-2021 that would require a procurement check. The error in the sample procurement performed by the Service Center selected for testing was isolated to fiscal year 2020-2021. The amount paid to the vendor for 2020-2021 was $22,211. The vendor did not met the suspension and debarment threshold ($25,000) for fiscal year 2020-2021. Proper controls over the same vendor selected for procurement and debarment and suspension were in place for the fiscal year 2021-2022 The second procurement selected for testing was a small purchase performed by the School Corporation for food purchases totaling $103,671 in fiscal year 2020-2021 and $142,368 in fiscal year 2021-2022. We noted that the School Corporation did not obtain three quotes from separate vendors. Additionally, the School Corporation did not perform a suspension and debarment check on the vendor sampled for fiscal years 2020-2021 and 2021-2022. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish controls to ensure compliance with Procurement and Suspension and Debarment compliance requirement. We recommend that management meet periodically with the Wilson Education Center and review and maintain procurement contract files as evidence of proper periodic monitoring of the Service Center. Additionally, we recommended that the School Corporation's management establish a system of internal controls related to ensure that 3 quotes are obtained as required for small purchase method procurements and to ensure the vendors are not debarred or suspended for small purchases procurements performed by the School Corporation. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Information on the federal program: Subject: Child Nutrition Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Modified Opinion, Noncompliance Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 2 CFR 200.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Procurement compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: There were two small purchase method procurements selected for sample testing for the audit period. One procurement was performed by the School?s Service Center, Wilson Education Center (Service Center). During the 2020-2021 school year, the Service Center solicited, evaluated, and awarded a bid for the milk on behalf of its members that School Corporation used. The Service Center was not audited for the 2020-2021 school year. During our testing of procurement and suspension and debarment for 2020-2021, it was noted that the School Corporation was not have a review control in place to monitor that the Service Center performed all necessary procedures to maintain compliance with federal regulations surrounding procurement and suspension and debarment. For 2020-2021, the School Corporation obtained procurement documents from the Service Center supporting procurements performed during the audit period. There was no documented review control in place at the School Corporation to ensure proper monitoring of the Service Center activities occur to verify federal procurement regulations were followed by the Service Center. There was one vendor that exceeded the $10,000 threshold for the School Corporation during fiscal year 2020-2021 that would require a procurement check. The error in the sample procurement performed by the Service Center selected for testing was isolated to fiscal year 2020-2021. The amount paid to the vendor for 2020-2021 was $22,211. The vendor did not met the suspension and debarment threshold ($25,000) for fiscal year 2020-2021. Proper controls over the same vendor selected for procurement and debarment and suspension were in place for the fiscal year 2021-2022 The second procurement selected for testing was a small purchase performed by the School Corporation for food purchases totaling $103,671 in fiscal year 2020-2021 and $142,368 in fiscal year 2021-2022. We noted that the School Corporation did not obtain three quotes from separate vendors. Additionally, the School Corporation did not perform a suspension and debarment check on the vendor sampled for fiscal years 2020-2021 and 2021-2022. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish controls to ensure compliance with Procurement and Suspension and Debarment compliance requirement. We recommend that management meet periodically with the Wilson Education Center and review and maintain procurement contract files as evidence of proper periodic monitoring of the Service Center. Additionally, we recommended that the School Corporation's management establish a system of internal controls related to ensure that 3 quotes are obtained as required for small purchase method procurements and to ensure the vendors are not debarred or suspended for small purchases procurements performed by the School Corporation. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-001 Subject: Special Education Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-049-PN01, 20611-047-PN01, 19619-49-PN01, 20619-047-PN01, 20611-049-PN01, 21611-047-PN01, 20619-49-PN01, 21619-047- PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Other Matters 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 awards 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) " 2 CFR 200.303 states: ?When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: 1. Checking SAM Exclusions; or 2. Collecting a certification from that person; or 3. Adding a clause or condition to the covered transaction with that person.? 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement? ?(c) Procurement by sealed bids (formal advertising). Bids are publicly solicited, and a firm fixed price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bid method is the preferred method for procuring construction, if the conditions in paragraph (c)(1) of this section apply " Condition: The School Corporation is a member of the Cooperative School Services (Cooperative). The Cooperative operated the special education programs on behalf of the School Corporation and managed the special education grant funds. As the grant agreement was between the Indiana Department of Education and the School Corporation, the School Corporation was responsible for compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement ? Simplified Acquisition The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions. The Cooperative did not have adequate procedures in place to ensure procurements for simplified acquisitions were properly advertised and bids accepted. There were two vendors who met the Simplified Acquisition threshold during the audit period; neither were properly procured. Suspension and Debarment The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the Suspension and Debarment requirements. During school year 2020, the Cooperative did not have adequate procedures in place to ensure that applicable vendors who received federal funds were not suspended or debarred from participation in federal awards programs. There were three contracted vendors during the audit period; the unit did not perform procedures to ensure the vendors were not excluded or disqualified. During the 2021 school year, The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the suspension and debarment requirements. The Special Education Director obtained suspension and debarment certifications for contracted vendors over $25,000 without an oversight or review process. The lack of controls and noncompliance related to procurement were isolated to school year 2020-2021. The lack of controls related to suspension and debarment were systemic throughout the audit period; however, the noncompliance was isolated to school year 2020-2021. Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions or suspension and debarment requirements for all contracts. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-001 Subject: Special Education Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-049-PN01, 20611-047-PN01, 19619-49-PN01, 20619-047-PN01, 20611-049-PN01, 21611-047-PN01, 20619-49-PN01, 21619-047- PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Other Matters 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 awards 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) " 2 CFR 200.303 states: ?When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: 1. Checking SAM Exclusions; or 2. Collecting a certification from that person; or 3. Adding a clause or condition to the covered transaction with that person.? 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement? ?(c) Procurement by sealed bids (formal advertising). Bids are publicly solicited, and a firm fixed price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bid method is the preferred method for procuring construction, if the conditions in paragraph (c)(1) of this section apply " Condition: The School Corporation is a member of the Cooperative School Services (Cooperative). The Cooperative operated the special education programs on behalf of the School Corporation and managed the special education grant funds. As the grant agreement was between the Indiana Department of Education and the School Corporation, the School Corporation was responsible for compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement ? Simplified Acquisition The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions. The Cooperative did not have adequate procedures in place to ensure procurements for simplified acquisitions were properly advertised and bids accepted. There were two vendors who met the Simplified Acquisition threshold during the audit period; neither were properly procured. Suspension and Debarment The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the Suspension and Debarment requirements. During school year 2020, the Cooperative did not have adequate procedures in place to ensure that applicable vendors who received federal funds were not suspended or debarred from participation in federal awards programs. There were three contracted vendors during the audit period; the unit did not perform procedures to ensure the vendors were not excluded or disqualified. During the 2021 school year, The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the suspension and debarment requirements. The Special Education Director obtained suspension and debarment certifications for contracted vendors over $25,000 without an oversight or review process. The lack of controls and noncompliance related to procurement were isolated to school year 2020-2021. The lack of controls related to suspension and debarment were systemic throughout the audit period; however, the noncompliance was isolated to school year 2020-2021. Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions or suspension and debarment requirements for all contracts. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-001 Subject: Special Education Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-049-PN01, 20611-047-PN01, 19619-49-PN01, 20619-047-PN01, 20611-049-PN01, 21611-047-PN01, 20619-49-PN01, 21619-047- PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Other Matters 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 awards 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) " 2 CFR 200.303 states: ?When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: 1. Checking SAM Exclusions; or 2. Collecting a certification from that person; or 3. Adding a clause or condition to the covered transaction with that person.? 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement? ?(c) Procurement by sealed bids (formal advertising). Bids are publicly solicited, and a firm fixed price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bid method is the preferred method for procuring construction, if the conditions in paragraph (c)(1) of this section apply " Condition: The School Corporation is a member of the Cooperative School Services (Cooperative). The Cooperative operated the special education programs on behalf of the School Corporation and managed the special education grant funds. As the grant agreement was between the Indiana Department of Education and the School Corporation, the School Corporation was responsible for compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement ? Simplified Acquisition The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions. The Cooperative did not have adequate procedures in place to ensure procurements for simplified acquisitions were properly advertised and bids accepted. There were two vendors who met the Simplified Acquisition threshold during the audit period; neither were properly procured. Suspension and Debarment The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the Suspension and Debarment requirements. During school year 2020, the Cooperative did not have adequate procedures in place to ensure that applicable vendors who received federal funds were not suspended or debarred from participation in federal awards programs. There were three contracted vendors during the audit period; the unit did not perform procedures to ensure the vendors were not excluded or disqualified. During the 2021 school year, The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the suspension and debarment requirements. The Special Education Director obtained suspension and debarment certifications for contracted vendors over $25,000 without an oversight or review process. The lack of controls and noncompliance related to procurement were isolated to school year 2020-2021. The lack of controls related to suspension and debarment were systemic throughout the audit period; however, the noncompliance was isolated to school year 2020-2021. Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions or suspension and debarment requirements for all contracts. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-001 Subject: Special Education Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-049-PN01, 20611-047-PN01, 19619-49-PN01, 20619-047-PN01, 20611-049-PN01, 21611-047-PN01, 20619-49-PN01, 21619-047- PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Other Matters 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 awards 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) " 2 CFR 200.303 states: ?When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: 1. Checking SAM Exclusions; or 2. Collecting a certification from that person; or 3. Adding a clause or condition to the covered transaction with that person.? 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement? ?(c) Procurement by sealed bids (formal advertising). Bids are publicly solicited, and a firm fixed price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bid method is the preferred method for procuring construction, if the conditions in paragraph (c)(1) of this section apply " Condition: The School Corporation is a member of the Cooperative School Services (Cooperative). The Cooperative operated the special education programs on behalf of the School Corporation and managed the special education grant funds. As the grant agreement was between the Indiana Department of Education and the School Corporation, the School Corporation was responsible for compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement ? Simplified Acquisition The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions. The Cooperative did not have adequate procedures in place to ensure procurements for simplified acquisitions were properly advertised and bids accepted. There were two vendors who met the Simplified Acquisition threshold during the audit period; neither were properly procured. Suspension and Debarment The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the Suspension and Debarment requirements. During school year 2020, the Cooperative did not have adequate procedures in place to ensure that applicable vendors who received federal funds were not suspended or debarred from participation in federal awards programs. There were three contracted vendors during the audit period; the unit did not perform procedures to ensure the vendors were not excluded or disqualified. During the 2021 school year, The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the suspension and debarment requirements. The Special Education Director obtained suspension and debarment certifications for contracted vendors over $25,000 without an oversight or review process. The lack of controls and noncompliance related to procurement were isolated to school year 2020-2021. The lack of controls related to suspension and debarment were systemic throughout the audit period; however, the noncompliance was isolated to school year 2020-2021. Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions or suspension and debarment requirements for all contracts. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-001 Subject: Special Education Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-049-PN01, 20611-047-PN01, 19619-49-PN01, 20619-047-PN01, 20611-049-PN01, 21611-047-PN01, 20619-49-PN01, 21619-047- PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Other Matters 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 awards 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) " 2 CFR 200.303 states: ?When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: 1. Checking SAM Exclusions; or 2. Collecting a certification from that person; or 3. Adding a clause or condition to the covered transaction with that person.? 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement? ?(c) Procurement by sealed bids (formal advertising). Bids are publicly solicited, and a firm fixed price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bid method is the preferred method for procuring construction, if the conditions in paragraph (c)(1) of this section apply " Condition: The School Corporation is a member of the Cooperative School Services (Cooperative). The Cooperative operated the special education programs on behalf of the School Corporation and managed the special education grant funds. As the grant agreement was between the Indiana Department of Education and the School Corporation, the School Corporation was responsible for compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement ? Simplified Acquisition The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions. The Cooperative did not have adequate procedures in place to ensure procurements for simplified acquisitions were properly advertised and bids accepted. There were two vendors who met the Simplified Acquisition threshold during the audit period; neither were properly procured. Suspension and Debarment The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the Suspension and Debarment requirements. During school year 2020, the Cooperative did not have adequate procedures in place to ensure that applicable vendors who received federal funds were not suspended or debarred from participation in federal awards programs. There were three contracted vendors during the audit period; the unit did not perform procedures to ensure the vendors were not excluded or disqualified. During the 2021 school year, The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the suspension and debarment requirements. The Special Education Director obtained suspension and debarment certifications for contracted vendors over $25,000 without an oversight or review process. The lack of controls and noncompliance related to procurement were isolated to school year 2020-2021. The lack of controls related to suspension and debarment were systemic throughout the audit period; however, the noncompliance was isolated to school year 2020-2021. Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions or suspension and debarment requirements for all contracts. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-001 Subject: Special Education Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-049-PN01, 20611-047-PN01, 19619-49-PN01, 20619-047-PN01, 20611-049-PN01, 21611-047-PN01, 20619-49-PN01, 21619-047- PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Other Matters 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 awards 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) " 2 CFR 200.303 states: ?When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: 1. Checking SAM Exclusions; or 2. Collecting a certification from that person; or 3. Adding a clause or condition to the covered transaction with that person.? 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement? ?(c) Procurement by sealed bids (formal advertising). Bids are publicly solicited, and a firm fixed price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bid method is the preferred method for procuring construction, if the conditions in paragraph (c)(1) of this section apply " Condition: The School Corporation is a member of the Cooperative School Services (Cooperative). The Cooperative operated the special education programs on behalf of the School Corporation and managed the special education grant funds. As the grant agreement was between the Indiana Department of Education and the School Corporation, the School Corporation was responsible for compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement ? Simplified Acquisition The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions. The Cooperative did not have adequate procedures in place to ensure procurements for simplified acquisitions were properly advertised and bids accepted. There were two vendors who met the Simplified Acquisition threshold during the audit period; neither were properly procured. Suspension and Debarment The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the Suspension and Debarment requirements. During school year 2020, the Cooperative did not have adequate procedures in place to ensure that applicable vendors who received federal funds were not suspended or debarred from participation in federal awards programs. There were three contracted vendors during the audit period; the unit did not perform procedures to ensure the vendors were not excluded or disqualified. During the 2021 school year, The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the suspension and debarment requirements. The Special Education Director obtained suspension and debarment certifications for contracted vendors over $25,000 without an oversight or review process. The lack of controls and noncompliance related to procurement were isolated to school year 2020-2021. The lack of controls related to suspension and debarment were systemic throughout the audit period; however, the noncompliance was isolated to school year 2020-2021. Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions or suspension and debarment requirements for all contracts. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-001 Subject: Special Education Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-049-PN01, 20611-047-PN01, 19619-49-PN01, 20619-047-PN01, 20611-049-PN01, 21611-047-PN01, 20619-49-PN01, 21619-047- PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Other Matters 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 awards 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) " 2 CFR 200.303 states: ?When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: 1. Checking SAM Exclusions; or 2. Collecting a certification from that person; or 3. Adding a clause or condition to the covered transaction with that person.? 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement? ?(c) Procurement by sealed bids (formal advertising). Bids are publicly solicited, and a firm fixed price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bid method is the preferred method for procuring construction, if the conditions in paragraph (c)(1) of this section apply " Condition: The School Corporation is a member of the Cooperative School Services (Cooperative). The Cooperative operated the special education programs on behalf of the School Corporation and managed the special education grant funds. As the grant agreement was between the Indiana Department of Education and the School Corporation, the School Corporation was responsible for compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement ? Simplified Acquisition The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions. The Cooperative did not have adequate procedures in place to ensure procurements for simplified acquisitions were properly advertised and bids accepted. There were two vendors who met the Simplified Acquisition threshold during the audit period; neither were properly procured. Suspension and Debarment The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the Suspension and Debarment requirements. During school year 2020, the Cooperative did not have adequate procedures in place to ensure that applicable vendors who received federal funds were not suspended or debarred from participation in federal awards programs. There were three contracted vendors during the audit period; the unit did not perform procedures to ensure the vendors were not excluded or disqualified. During the 2021 school year, The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the suspension and debarment requirements. The Special Education Director obtained suspension and debarment certifications for contracted vendors over $25,000 without an oversight or review process. The lack of controls and noncompliance related to procurement were isolated to school year 2020-2021. The lack of controls related to suspension and debarment were systemic throughout the audit period; however, the noncompliance was isolated to school year 2020-2021. Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions or suspension and debarment requirements for all contracts. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-001 Subject: Special Education Cluster ? Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-049-PN01, 20611-047-PN01, 19619-49-PN01, 20619-047-PN01, 20611-049-PN01, 21611-047-PN01, 20619-49-PN01, 21619-047- PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness, Other Matters 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 awards 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) " 2 CFR 200.303 states: ?When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: 1. Checking SAM Exclusions; or 2. Collecting a certification from that person; or 3. Adding a clause or condition to the covered transaction with that person.? 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement? ?(c) Procurement by sealed bids (formal advertising). Bids are publicly solicited, and a firm fixed price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bid method is the preferred method for procuring construction, if the conditions in paragraph (c)(1) of this section apply " Condition: The School Corporation is a member of the Cooperative School Services (Cooperative). The Cooperative operated the special education programs on behalf of the School Corporation and managed the special education grant funds. As the grant agreement was between the Indiana Department of Education and the School Corporation, the School Corporation was responsible for compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement ? Simplified Acquisition The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions. The Cooperative did not have adequate procedures in place to ensure procurements for simplified acquisitions were properly advertised and bids accepted. There were two vendors who met the Simplified Acquisition threshold during the audit period; neither were properly procured. Suspension and Debarment The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the Suspension and Debarment requirements. During school year 2020, the Cooperative did not have adequate procedures in place to ensure that applicable vendors who received federal funds were not suspended or debarred from participation in federal awards programs. There were three contracted vendors during the audit period; the unit did not perform procedures to ensure the vendors were not excluded or disqualified. During the 2021 school year, The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the suspension and debarment requirements. The Special Education Director obtained suspension and debarment certifications for contracted vendors over $25,000 without an oversight or review process. The lack of controls and noncompliance related to procurement were isolated to school year 2020-2021. The lack of controls related to suspension and debarment were systemic throughout the audit period; however, the noncompliance was isolated to school year 2020-2021. Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have adequate internal controls in place to ensure the Cooperative complied with the procurement requirements for simplified acquisitions or suspension and debarment requirements for all contracts. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency 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 awards 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) " Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented, a documented system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual data collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without a documented oversight or review process in place to prevent, or detect and correct, errors. The lack of internal controls was systemic throughout the audit period. Cause: Management had not developed a system of internal controls that would have ensured compliance with the Reporting compliance requirement. Effect: The failure to design and implement an effective internal control system could have enabled noncompliance with the grant agreement and the Reporting compliance requirement. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: COVID-19 - Education Stabilization Fund - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number:84.425D Federal Award Number and Year (or Other Identifying Number): S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Modified Opinion Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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) " 29 CFR 5.5 states in part: ?(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in ?5.1, the following clauses? (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics? (3)(ii)(A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). . . .? 2 CFR 200 Appendix II states in part: In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non-Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, ?Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction?). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week ? Condition: An effective internal control system was not designed, nor implemented at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to their laborers and mechanics. Nonfederal entities are to include in their construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation did not have adequate policies or procedures to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause. Two constructions contract during the audit period were subject to the wage rate requirements; however, the contracts did not have the required prevailing wage rate clause included in the contract, nor were certified payrolls submitted by the contractor. The lack of internal controls and failure to maintain and provide adequate supporting documentation were systemic issues throughout the audit period. Cause: Management had not developed nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Effect: The failure to establish an effective internal control system and to retain and provide appropriate supporting documentation prevented the determination of the School Corporation?s compliance with the Special Tests and Provisions - Wage Rate Requirements. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not designed, nor implemented at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish internal controls, as well as retain appropriate supporting documentation, to ensure compliance and comply with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-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 Listing Number: 84.425D Federal Award Number and Year (or Other Identifying Number): S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Criteria: 2 CFR 200.303 states in part: ?The non-Federal entity must: ?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)??." 2 CFR 200.313(d) states in part: "(1) 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 federal award identification number), 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, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at lease once every two years. (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. ? Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and Equipment and Real Property Management compliance requirement. The School Corporation paid $154,279 for water tank improvements at two locations. These capital improvements were not added to a detailed listing of capital assets that 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), 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Cause: Management had not developed a system of internal controls that would have ensured compliance with the Equipment and Real Property Management compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and Equipment and Real Property Management compliance requirement. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency 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 awards 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) " Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented, a documented system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual data collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without a documented oversight or review process in place to prevent, or detect and correct, errors. The lack of internal controls was systemic throughout the audit period. Cause: Management had not developed a system of internal controls that would have ensured compliance with the Reporting compliance requirement. Effect: The failure to design and implement an effective internal control system could have enabled noncompliance with the grant agreement and the Reporting compliance requirement. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: COVID-19 - Education Stabilization Fund - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number:84.425D Federal Award Number and Year (or Other Identifying Number): S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Modified Opinion Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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) " 29 CFR 5.5 states in part: ?(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in ?5.1, the following clauses? (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics? (3)(ii)(A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). . . .? 2 CFR 200 Appendix II states in part: In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non-Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, ?Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction?). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week ? Condition: An effective internal control system was not designed, nor implemented at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to their laborers and mechanics. Nonfederal entities are to include in their construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation did not have adequate policies or procedures to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause. Two constructions contract during the audit period were subject to the wage rate requirements; however, the contracts did not have the required prevailing wage rate clause included in the contract, nor were certified payrolls submitted by the contractor. The lack of internal controls and failure to maintain and provide adequate supporting documentation were systemic issues throughout the audit period. Cause: Management had not developed nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Effect: The failure to establish an effective internal control system and to retain and provide appropriate supporting documentation prevented the determination of the School Corporation?s compliance with the Special Tests and Provisions - Wage Rate Requirements. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not designed, nor implemented at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish internal controls, as well as retain appropriate supporting documentation, to ensure compliance and comply with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-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 Listing Number: 84.425D Federal Award Number and Year (or Other Identifying Number): S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Criteria: 2 CFR 200.303 states in part: ?The non-Federal entity must: ?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)??." 2 CFR 200.313(d) states in part: "(1) 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 federal award identification number), 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, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at lease once every two years. (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. ? Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and Equipment and Real Property Management compliance requirement. The School Corporation paid $154,279 for water tank improvements at two locations. These capital improvements were not added to a detailed listing of capital assets that 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), 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Cause: Management had not developed a system of internal controls that would have ensured compliance with the Equipment and Real Property Management compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and Equipment and Real Property Management compliance requirement. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency 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 awards 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) " Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented, a documented system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual data collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without a documented oversight or review process in place to prevent, or detect and correct, errors. The lack of internal controls was systemic throughout the audit period. Cause: Management had not developed a system of internal controls that would have ensured compliance with the Reporting compliance requirement. Effect: The failure to design and implement an effective internal control system could have enabled noncompliance with the grant agreement and the Reporting compliance requirement. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency 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 awards 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) " Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented, a documented system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual data collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without a documented oversight or review process in place to prevent, or detect and correct, errors. The lack of internal controls was systemic throughout the audit period. Cause: Management had not developed a system of internal controls that would have ensured compliance with the Reporting compliance requirement. Effect: The failure to design and implement an effective internal control system could have enabled noncompliance with the grant agreement and the Reporting compliance requirement. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 2 CFR 200.313(d)(1), 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, 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. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.