ESBD_415525_1746129826778_582-26-00021 - Solicitation - Budget Tables - Final.xlsx

XLSX spreadsheet 46 KB Posted

Attached to
Federal Fiscal Year (FFY) 2026 Clean Water Act (CWA) Section 319(h) Grant
Solicitation number
582-26-00021
Issued by
Texas

About this file

This document is a budget spreadsheet for a Texas Commission on Environmental Quality (TCEQ) grant opportunity, specifically a budget proposal for a project involving water quality and watershed management. The project appears to be a three-year initiative with a total budget of $223,351.83, split into a federal portion (60% or $134,046.22) and a grantee match portion (40% or $89,305.61). The budget covers various project categories including personnel, fringe benefits, travel, supplies, equipment, contractual services, construction, and other expenses, with specific line items such as a water quality auto sampler, septic system work, and rain garden construction.

The budget includes an 18.25% indirect cost rate and incorporates in-kind contributions of $36,891.30 from the Texas Stream Team for volunteer hours. The project's federal reimbursable costs are itemized in detail, with specific allocations for activities like watershed meetings, office supplies, and communication services. Matching funds are primarily derived from staff time and in-kind contributions, with no additional external matching funds identified. The budget demonstrates a comprehensive approach to tracking project expenses, with careful attention to federal cost regulations and precise cost categorization across multiple budget lines.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Table 32

Table 32: Budget Summary
All costs and activities associated with the project must be allowable and in accordance with 2 Code of Federal Regulations (CFR) Part 200. TCEQ will evaluate the extent to which the Budget presents estimated costs for each budget category and whether the costs are reasonable and necessary.

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.

Name of Project:
CategoryTCEQ Reimbursable PortionGrantee Match PortionTotal
(Federal)(Non-Federal)
a. Personnel/Salary$37,992.96$37,500.00$75,492.96
b. Fringe Benefits$9,229.73$6,825.00$16,054.73
c. Travel$4,216.50$0.00$4,216.50
d. Supplies$5,000.00$0.00$5,000.00
e. Equipment$8,250.00$0.00$8,250.00
f. Contractual$24,000.00$0.00$24,000.00
g. Construction$20,000.00$0.00$20,000.00
h. Other$4,700.00$0.00$4,700.00
i. Subtotal: Total Direct Costs (sum a-h)$113,389.19$44,325.00$157,714.19
Subtotal for MTDC$113,189.19$44,325.00$157,514.19
j. Indirect Costs (% rate)$20,657.03$8,089.31$28,746.34
k. Other In-kind/Third Party$36,891.30$36,891.30
l. Total Project Costs (sum i, j, & k)$134,046.22$89,305.61$223,351.83
calculate to 2nd decimal

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 H. Please check to be sure all numbers add correctly and that total amounts match values in Table 32.

Examples are given in grey italics in the table below, these examples should be deleted when filling in the table with your itemizations.
Instructions for each Budget Category
Personnel/SalaryIdentify all staff positions by correct title, annual salary, and the percentage of time each position will be assigned to the project. Adjust the formula in Total Cost column only if project period is not three years.
Fringe BenefitsIdentify an overall rate that will not be exceeded for the Contract.
TravelIdentify the number of trips, reasons for and destination of trips, number of travelers, and the estimated cost per trip. All travel costs must not exceed the State of Texas travel reimbursement rates: https://fmx.cpa.texas.gov/fmx/travel/textravel/rates/current.php
SuppliesProvide a list of anticipated supplies, broken out into as much detail as possible.
EquipmentIdentify individual items with a unit acquisition cost of $10,000 or greater, and the estimated cost of the item.
ContractualOnly include a vendor or subcontractor that is providing goods and/or services under a competitive process. Subcontracts with a political subdivision of the state (e.g., universities, cities, counties) belong in the “Other” category.

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.

calculate to 2nd decimal
CategoryTotal AmountJustification (itemized expenses)
a. Personnel/Salary
$37,992.96Staff Name and/or PositionAnnual Salary% of TimeAnnual Cost# of YearsTotal Cost
Joe Smith, Project Manager$52,768.0024%$12,664.323$37,992.96
$0.00
$0.00
$0.00
Total Salary:$12,664.32$37,992.96
b. Fringe Benefits (%)
$9,229.73Fringe DescriptionFringe RateTotal SalaryTotal Fringe
Fringe Rate for eligible students10.70%$28,526.00$3,052.28
Fringe Rate for faculty and staff18.20%$33,942.00$6,177.44
$0.00
Total Fringe Benefit:$9,229.73
c. Travel
$4,216.50Trip Description# of TripsDistanceCost per MileTotal Cost
Work Group Meetings3150$0.670$301.50
Watershed Meetings from College Station, TX to the Attoyac Bayou watershed15300$0.670$3,015.00
$0.00
$0.00
Meal Costs:# of MealsPer Diem
25$36.00$900.00
Total Travel:$4,216.50
d. Supplies
$5,000.00Supply Description# of UnitsCost per UnitTotal Cost
Office Supplies (pens, paper, binders, etc.)1$4,000.00$4,000.00
Envelopes for mailers2000$0.50$1,000.00
$0.00
Total Supplies:$5,000.00
e. Equipment
$8,250.00Equipment DescriptionTotal Cost
Water quality auto sampler$8,250.00
Total Equipment:$8,250.00
f. Contractual$24,000.00Subcontractor Name and/or Description of WorkTotal Cost
Bobby's Septic Pumping - 30 systems @ $800/system$24,000.00
Total Contractual:$24,000.00
g. Construction$20,000.00Description of WorkTotal Cost
Meadows Center will build 10 rain gardens @ $2,000 each$20,000.00
Total Construction:$20,000.00
h. Other$4,700.00Description of WorkTotal Cost
Communication Services$4,500.00
Facility Rental (not included in MTDC)$200.00
Total Other:$4,700.00
i. Subtotal (sum a-h)$113,389.19
Subtotal for MTDC calculation$113,189.19Description of Items included in MTDC calculation
Update the formula in the cell to the left so it calculates MTDC and add your description here. (e.g., MTDC includes all costs except facility rental)
j. Indirect Costs (% rate)$20,657.03Description of Indirect Cost Rate
Update the percentatge in the cell to the right with your negotiated IDC rate (or the 15% de minimus) and add your description here.18.25%
Total (sum i & j)$134,046.22

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 H. Please check to be sure all numbers add correctly and that total amounts match values in Table 32.

Examples are given in grey italics in the table below, these examples should be deleted when filling in the table with your itemizations.
Instructions for each Budget Category
Personnel/SalaryIdentify all staff positions by correct title, annual salary, and the percentage of time each position will be assigned to the project. Adjust the formula in Total Cost column only if project period is not three years.
Fringe BenefitsIdentify an overall rate that will not be exceeded for the Contract.
TravelIdentify the number of trips, reasons for and destination of trips, number of travelers, and the estimated cost per trip. All travel costs must not exceed the State of Texas travel reimbursement rates: https://fmx.cpa.texas.gov/fmx/travel/textravel/rates/current.php
SuppliesProvide a list of anticipated supplies, broken out into as much detail as possible.
EquipmentIdentify individual items with a unit acquisition cost of $10,000 or greater, and the estimated cost of the item.
ContractualOnly include a vendor or subcontractor that is providing goods and/or services under a competitive process. Subawards with a political subdivision of the state (e.g. universities, cities, counties) belong in the “Other” category.

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.

calculate to 2nd decimal
CategoryTotal AmountJustification (itemized expenses)
a. Personnel/Salary$37,500.00Staff Name and/or PositionAnnual Salary% of TimeAnnual Cost# of YearsTotal Cost
Joe Smith, Director$250,000.005%$12,500.003$37,500.00
$0.00
$0.00
$0.00
$0.00
Total Salary:$12,500.00$37,500.00
b. Fringe Benefits (%)$6,825.00Fringe DescriptionFringe RateTotal SalaryTotal Fringe
Fringe Rate for faculty and staff18.20%$37,500.00$6,825.00
$0.00
$0.00
Total Fringe Benefit:$6,825.00
c. Travel
$0.00Trip Description# of TripsDistanceCost per MileTotal Cost
$0.00
$0.00
$0.00
Meal Costs:# of MealsPer Diem
$0.00
Total Travel:$0.00
d. Supplies
$0.00Supply Description# of UnitsCost per UnitTotal Cost
$0.00
$0.00
$0.00
Total Supplies:$0.00
e. Equipment$0.00Equipment DescriptionTotal Cost
Total Equipment:$0.00
f. Contractual$0.00Subcontractor Name and/or Description of WorkTotal Cost
Total Contractual:$0.00
g. Construction$0.00Description of WorkTotal Cost
Total Construction:$0.00
h. Other$0.00Description of WorkTotal Cost
Total Other:$0.00
i. Subtotal (sum a-h)$44,325.00
Subtotal for MTDC calculation$44,325.00Description of Items included in MTDC calculation
Update the formula in the cell to the left so it calculates MTDC and add your description here. (e.g., MTDC includes all costs except facility rental)
j. Indirect Costs (% rate)$8,089.31Description of Indirect Cost Rate
Update the percentatge in the cell to the right with your negotiated IDC rate (or the 15% de minimus) and add your description here.18.25%
k. In-kind$36,891.30Name of Providing Entity and/or Description of ContributionTotal Contribution
Contribution of volunteer hours from Texas Stream Team$36,891.30
Total In-kind:$36,891.30
Total (sum i, j, & k)$89,305.61Description of Source of Matching Funds

Table 35

Table 35: Budget by Task
Provide the estimated costs for each Task. Tasks shown here must match Tasks in Application Sections 8 and 31. Insert or delete rows as necessary.

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.

Task/ActivityTCEQ Reimbursable PortionGrantee Match PortionTotal
(Federal)(Non-Federal)
Project Administration$0.00$0.00$0.00
Quality Assurance$0.00$0.00$0.00
$0.00$0.00$0.00
$0.00$0.00$0.00
$0.00$0.00$0.00
$0.00$0.00$0.00
$0.00$0.00$0.00
$0.00$0.00$0.00
Final Report$0.00$0.00$0.00
Total$0.00$0.00$0.00

Table 36

Table 36: Total Budget by Year
Provide an estimate of the total costs per year (federal and match) of the project according to expected activities and expenses.

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.

CategoryYear 1Year 2Year 3Total
a. Personnel/Salary$0.00$0.00$0.00$0.00
b. Fringe Benefits$0.00$0.00$0.00$0.00
c. Travel$0.00$0.00$0.00$0.00
d. Supplies$0.00$0.00$0.00$0.00
e. Equipment$0.00$0.00$0.00$0.00
f. Contractual$0.00$0.00$0.00$0.00
g. Construction$0.00$0.00$0.00$0.00
h. Other$0.00$0.00$0.00$0.00
i. Subtotal: Total Direct Costs (sum a-h)$0.00$0.00$0.00$0.00
Subtotal for MTDC
i. Indirect Costs$0.00$0.00$0.00$0.00
j. Other In-kind/Third Party$0.00$0.00$0.00$0.00
Total (sum i, j, & k)$0.00$0.00$0.00$0.00
Federal Reimbursement by Year (60%)$0.00$0.00$0.00$0.00

File details come from the government source that posted it. Updated .