Audit 26017

FY End
2022-06-30
Total Expended
$11.44M
Findings
12
Programs
24
Year: 2022 Accepted: 2022-12-13

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
36446 2022-001 - - B
36447 2022-001 - - B
36448 2022-001 - - B
36449 2022-001 - - B
36450 2022-001 - - B
36451 2022-001 - - B
612888 2022-001 - - B
612889 2022-001 - - B
612890 2022-001 - - B
612891 2022-001 - - B
612892 2022-001 - - B
612893 2022-001 - - B

Programs

ALN Program Spent Major Findings
10.555 National School Lunch Program $6.42M Yes 1
10.553 School Breakfast Program $1.21M Yes 1
84.425 Covid-19 Elementary and Secondary School Emergency Relief (esser Ii) Fund $809,528 Yes 0
84.027 Special Education_grants to States $556,454 - 0
10.555 Commodities- Noncash $392,592 Yes 1
10.559 Summer Food Service Program for Children $223,366 Yes 1
10.555 Commodities- Noncash, Department of Defense $197,999 Yes 1
84.367 Supporting Effective Instruction State Grants- Federal Teacher Quality Program $119,938 - 0
84.027 Covid-19 Special Education_grants to States $85,846 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $72,540 - 0
84.425 Covid-19 Rethink K-12 Education Models Discretionary Grants $65,985 Yes 0
84.425 Covid-19 Elementary and Secondary School Emergency Relief (arp-Esser) Fund $58,131 Yes 0
10.555 Covid-19 National School Lunch Program $53,733 Yes 1
84.048 Career and Technical Education -- Basic Grants to States $48,061 - 0
10.575 Farm to School Grant Program $30,131 - 0
93.575 Covid-19 Child Care and Development Block Grant $19,524 - 0
84.365 English Language Acquisition State Grants $17,500 - 0
84.424 Student Support and Academic Enrichment Program $16,649 - 0
84.425 Covid-19 Arp-Elementary and Secondary School Emergency Relief- Homeless Youth $10,299 Yes 0
84.010 Title I Grants to Local Educational Agencies $8,985 - 0
10.649 Covid-19 Pandemic Ebt Administrative Costs $3,063 - 0
84.425 Covid-19 Governor's Emergency Education Relief (geerf) Fund $1,154 Yes 0
10.579 Child Nutrition Discretionary Grants Limited Availability $1,000 - 0
10.310 Agriculture and Food Research Initiative (afri) $250 - 0

Contacts

Name Title Type
YNDEYEVL8PS7 Sarah Kautz Auditee
5159875161 Mia Frommelt Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Note 1. Basis of PresentationThe accompanying schedule of expenditures of federal awards includes the federal grant activity ofWaukee Community School District under programs of the federal government for the year ended June30, 2022. The information in this schedule is presented in accordance with the requirements of Title 2U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, andAudit Requirements for Federal Awards (Uniform Guidance). Because the schedule presents only aselected portion of the operations of the District, it is not intended to and does not present the financialposition, changes in net position or cash flows of the District.Note 2. Significant Accounting PoliciesExpenditures reported on the schedule of expenditures of federal awards are reported on the modifiedaccrual or accrual basis of accounting based on the fund type of the program. Such expenditures arerecognized following the cost principles contained in the Uniform Guidance, wherein certain types ofexpenditures are not allowable or are limited as to reimbursement. Revenue from federal awards isrecognized when the District has done everything necessary to establish its right to revenue. Forgovernmental funds, revenue from federal awards is recognized when it is both measurable andavailable. Expenditures of federal awards are recognized in the accounting period when the liability isincurred. Revenue from federal awards is recognized when the District has done everything necessary toestablish its right to revenue. For governmental funds, revenue from federal awards is recognized when itis both measurable and available. Expenditures of federal awards are recognized in the accountingperiod when the liability is incurred. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.
Finding: The District overcharged the program for indirect costs. Criteria: The federal criteria for indirect costs and allocations is established in 2 Code of Federal Regulations (CFR) Part 200, Appendix VII: ??Base means the accumulated direct costs (normally either total direct salaries and wages or total direct costs exclusive of any extraordinary or distorting expenditures) used to distribute indirect costs to individual Federal awards. The direct cost base selected should result in each Federal award bearing a fair share of the indirect costs in reasonable relation to the benefits received from the costs.? ??The distribution base may be (1) total direct costs (excluding capital expenditures and other distorting items, such as pass-through funds, subcontracts in excess of $25,000, participant support costs, etc.), (2) direct salaries and wages, or (3) another base which results in an equitable distribution.? The Iowa Department of Education criteria was established in the Iowa Department of Education Local Education Agency Federal Indirect Cost Rate Proposal dated December 2019 and Guidance for State Agencies, Public School District School Food Authorities dated March 29, 2013. Guidance to Iowa School Food Authorities was updated in September 2022 to clarify the earlier memos and guidance the department had issued. The March 29, 2013 document states in the section How to Apply the Indirect Cost Rate, ?..The federal grant amount to which the rate may be applied is the total expenditures in the federal grant excluding the same unallowed or excluded costs that were unallowed or excluded within the state plan.? The Iowa Department of Education provided the worksheet calculation to school districts which requires districts to compare total direct base cost expenditures and total federal revenues and to use the lesser of the two totals for the calculation. Condition: The District charged the program for indirect costs using a calculation based on total federal revenue rather than the direct cost base expenditures which were less than total federal revenue for the fiscal year.Cause: The calculation for the indirect costs charged to the program has historically been based on total federal revenues due to direct cost base expenditures exceeding federal revenues received in prior years. However, due to the COVID-19 pandemic funding to the program in the current year, federal revenues exceeded the direct cost base expenditures. The District charged the program using the same calculation as the prior year instead of adjusting the calculation for the lesser of the two base amounts. Effect: The Child Nutrition Cluster program was overcharged for indirect costs. Questioned Costs: Known questioned costs are $151,885. Context: Indirect costs represent 1.8 percent of total program expenditures reported on the Schedule of Expenditures of Federal Awards. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District revise the indirect cost calculation to include a comparison of federal revenues and direct cost base expenditures and use the lesser of the two totals for the annual adjustment. We recommend the District use the Iowa Department of Education template.