ESBD_515675_1778788550665_582-27-00033 - Solicitation - Budget Tables.xlsx

Table 32

Applicants must provide documentation of their current indirect cost rate from a cognizant agency or a state single audit coordinating agency. Entities who have never received a negotiated indirect cost rate may elect to use a de minimis rate of 15% of modified total direct costs (MTDC).

Provide the costs by budget category.

THIS TABLE WILL AUTOPOPULATE WITH VALUES FROM TABLES 33 AND 34, BUT PLEASE CHECK TO BE SURE THEY ARE CORRECT.

Federal and Match portions need to be an EXACT 60/40 split of the Total.

Dollar amounts need to be to two decimal points. Please do not round.

Blue shaded cells contain formulas that will auto-summate your entered costs, but please check to be sure all numbers add correctly from top to bottom and left to right.

Table 33 Table 33: TCEQ Reimbursable Project Costs (Federal portion must be 60% of overall project costs)

Provide estimated federal reimbursable costs in each budget category, the basis for the costs, and a breakdown of the costs (itemized expenses) under each budget category. Insert more rows to each category when necessary.

Provide adequate detail in the justification (itemized expenses) sections to account for the full cost of each category.

Blue shaded cells contain formulas that will auto-summate your entered costs. The Total Amount column will auto-populate with the totals calcuated in column I. Please check to be sure all numbers add correctly and that total amounts match values in Table 32.

Construction The construction category should only be used if construction activities are conducted in-house by the project lead organization (subcontracted construction goes under contractual). List major components of the construction activities and the associated costs.

Other Provide a list of other anticipated costs and any subawards to a political subdivision of the state (e.g., universities, cities, counties). Costs may also include such items as postage, printing, or stipends allocable to the project.

Subtotal for Modified Total Direct Costs If your Indirect Cost rate (IDC) is calculated based on a Modified Total Direct Cost (MTDC), please provide the FORMULA used to obtain the subtotal and a detailed description of what costs went into the MTDC.

Indirect Costs For calculating the full costs of the project, use your approved, audited indirect rate and applicable direct costs as the base (e.g., MTDC). If you do not have an indirect rate, you may use a default rate of 15% of MTDC. State the rate and identify the base direct costs.

Table 34 Table 34: Matching Project Costs provided by the Grantees (Non-Federal portion must equal 40% of overall project costs)

Provide the estimated matching costs in each budget category and the basis for the costs, breaking down the costs (itemized expenses) under each budget category. Matching funds may not come from federal sources and must be allowable costs under federal regulations. These may include state funds, local funds, or in-kind contributions.

Match should be available for billing purposes beginning in quarter two. If this will not be feasible, provide an explanation in the Application.

Provide adequate detail in the justification (itemized expenses) sections to account for the full cost of each category.

Blue shaded cells contain formulas that will auto-summate your entered costs. The Total Amount column will auto-populate with the totals calcuated in column I. Please check to be sure all numbers add correctly and that total amounts match values in Table 32.

Construction The construction category should only be used if construction activities are conducted in-house by the project lead organization (subcontracted construction goes under contractual). List major components of the construction activities and the associated costs.

Other Provide a list of other anticipated costs and any subawards to a political subdivision of the state (e.g., universities, cities, counties). Costs may also include such items as postage, printing, or stipends allocable to the project.

Subtotal for Modified Total Direct Costs If your Indirect Cost rate (IDC) is calculated based on a Modified Total Direct Cost (MTDC), please provide the FORMULA used to obtain the subtotal and a detailed description of what costs went into the MTDC.

Indirect Costs For calculating the full costs of the project, use your approved, audited indirect rate and applicable direct costs as the base (e.g. MTDC). If you do not have an indirect rate, you may use a default rate of 15% of MTDC. State the rate and identify the base direct costs.

In-Kind In-kind contributions are services rendered at no charge by a third party (a party other than the applicant). Estimate a reasonable value for each in-kind service provided; the basis for estimating these values must be documented. In-kind services must be provided at the fair market value. In-kind costs are not reimbursable.

Total Identify the source of match to be utilized. The match source must be state or local funds that are not being counted towards other federal or state cost sharing requirements. Identify whether program income costs are being utilized.

Table 35

Blue shaded cells contain formulas that will auto-summate your entered costs, but please check to be sure all numbers add correctly from top to bottom and left to right, and that the total amounts at bottom of table match values in Table 32.

Table 36

Responses only showing one-third of the total for each year are not acceptable.

An original QAPP routinely takes four months to receive final approval.

Blue shaded cells contain formulas that will auto-summate your entered costs, but please check to be sure all numbers add correctly from top to bottom and left to right, and that the total amounts in Column F match values in Table 32.