ESBD_415525_1746129826778_582-26-00021 - Solicitation - Budget Tables - Final.xlsx
XLSX spreadsheet 46 KB Posted
- 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: | |||
| Category | TCEQ Reimbursable Portion | Grantee Match Portion | Total |
| (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/Salary | Identify 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 Benefits | Identify an overall rate that will not be exceeded for the Contract. |
| Travel | Identify 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 |
| Supplies | Provide a list of anticipated supplies, broken out into as much detail as possible. |
| Equipment | Identify individual items with a unit acquisition cost of $10,000 or greater, and the estimated cost of the item. |
| Contractual | Only 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 | ||||||||
| Category | Total Amount | Justification (itemized expenses) | ||||||
| a. Personnel/Salary | ||||||||
| $37,992.96 | Staff Name and/or Position | Annual Salary | % of Time | Annual Cost | # of Years | Total Cost | ||
| Joe Smith, Project Manager | $52,768.00 | 24% | $12,664.32 | 3 | $37,992.96 | |||
| $0.00 | ||||||||
| $0.00 | ||||||||
| $0.00 | ||||||||
| Total Salary: | $12,664.32 | $37,992.96 | ||||||
| b. Fringe Benefits (%) | ||||||||
| $9,229.73 | Fringe Description | Fringe Rate | Total Salary | Total Fringe | ||||
| Fringe Rate for eligible students | 10.70% | $28,526.00 | $3,052.28 | |||||
| Fringe Rate for faculty and staff | 18.20% | $33,942.00 | $6,177.44 | |||||
| $0.00 | ||||||||
| Total Fringe Benefit: | $9,229.73 | |||||||
| c. Travel | ||||||||
| $4,216.50 | Trip Description | # of Trips | Distance | Cost per Mile | Total Cost | |||
| Work Group Meetings | 3 | 150 | $0.670 | $301.50 | ||||
| Watershed Meetings from College Station, TX to the Attoyac Bayou watershed | 15 | 300 | $0.670 | $3,015.00 | ||||
| $0.00 | ||||||||
| $0.00 | ||||||||
| Meal Costs: | # of Meals | Per Diem | ||||||
| 25 | $36.00 | $900.00 | ||||||
| Total Travel: | $4,216.50 | |||||||
| d. Supplies | ||||||||
| $5,000.00 | Supply Description | # of Units | Cost per Unit | Total Cost | ||||
| Office Supplies (pens, paper, binders, etc.) | 1 | $4,000.00 | $4,000.00 | |||||
| Envelopes for mailers | 2000 | $0.50 | $1,000.00 | |||||
| $0.00 | ||||||||
| Total Supplies: | $5,000.00 | |||||||
| e. Equipment | ||||||||
| $8,250.00 | Equipment Description | Total Cost | ||||||
| Water quality auto sampler | $8,250.00 |
| Total Equipment: | $8,250.00 | ||
| f. Contractual | $24,000.00 | Subcontractor Name and/or Description of Work | Total Cost |
| Bobby's Septic Pumping - 30 systems @ $800/system | $24,000.00 |
| Total Contractual: | $24,000.00 | ||
| g. Construction | $20,000.00 | Description of Work | Total Cost |
| Meadows Center will build 10 rain gardens @ $2,000 each | $20,000.00 |
| Total Construction: | $20,000.00 | ||
| h. Other | $4,700.00 | Description of Work | Total 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.19 | Description 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.03 | Description 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/Salary | Identify 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 Benefits | Identify an overall rate that will not be exceeded for the Contract. |
| Travel | Identify 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 |
| Supplies | Provide a list of anticipated supplies, broken out into as much detail as possible. |
| Equipment | Identify individual items with a unit acquisition cost of $10,000 or greater, and the estimated cost of the item. |
| Contractual | Only 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 | ||||||||
| Category | Total Amount | Justification (itemized expenses) | ||||||
| a. Personnel/Salary | $37,500.00 | Staff Name and/or Position | Annual Salary | % of Time | Annual Cost | # of Years | Total Cost | |
| Joe Smith, Director | $250,000.00 | 5% | $12,500.00 | 3 | $37,500.00 | |||
| $0.00 | ||||||||
| $0.00 | ||||||||
| $0.00 | ||||||||
| $0.00 | ||||||||
| Total Salary: | $12,500.00 | $37,500.00 | ||||||
| b. Fringe Benefits (%) | $6,825.00 | Fringe Description | Fringe Rate | Total Salary | Total Fringe | |||
| Fringe Rate for faculty and staff | 18.20% | $37,500.00 | $6,825.00 | |||||
| $0.00 | ||||||||
| $0.00 | ||||||||
| Total Fringe Benefit: | $6,825.00 | |||||||
| c. Travel | ||||||||
| $0.00 | Trip Description | # of Trips | Distance | Cost per Mile | Total Cost | |||
| $0.00 | ||||||||
| $0.00 | ||||||||
| $0.00 | ||||||||
| Meal Costs: | # of Meals | Per Diem | ||||||
| $0.00 | ||||||||
| Total Travel: | $0.00 | |||||||
| d. Supplies | ||||||||
| $0.00 | Supply Description | # of Units | Cost per Unit | Total Cost | ||||
| $0.00 | ||||||||
| $0.00 | ||||||||
| $0.00 | ||||||||
| Total Supplies: | $0.00 | |||||||
| e. Equipment | $0.00 | Equipment Description | Total Cost |
| Total Equipment: | $0.00 | ||
| f. Contractual | $0.00 | Subcontractor Name and/or Description of Work | Total Cost |
| Total Contractual: | $0.00 | ||
| g. Construction | $0.00 | Description of Work | Total Cost |
| Total Construction: | $0.00 | ||
| h. Other | $0.00 | Description of Work | Total Cost |
| Total Other: | $0.00 | ||
| i. Subtotal (sum a-h) | $44,325.00 | ||
| Subtotal for MTDC calculation | $44,325.00 | Description 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.31 | Description 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.30 | Name of Providing Entity and/or Description of Contribution | Total 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.61 | Description 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/Activity | TCEQ Reimbursable Portion | Grantee Match Portion | Total |
| (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.
| Category | Year 1 | Year 2 | Year 3 | Total |
| 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 .