Revised_Budget_(11.8.24).xlsx
XLSX spreadsheet 89 KB Posted
- Solicitation number
- 25-058-RFP
- Issued by
- Yolo County, California
About this file
This is a comprehensive budget file from the City of West Sacramento, detailing a budget for a Well 22 Rehabilitation Project funded through the U.S. Bureau of Reclamation's WaterSMART Drought Response Program Grant. The project involves engineering design services to either rehabilitate an existing groundwater well at 964 Oak Street or design a replacement well if rehabilitation is not feasible. The total project budget is $3,937,276, evenly split between federal and non-federal funding sources, with $3,383,375 allocated to construction-related costs. The engineering design will focus on creating a well with stainless steel casing to meet current Maximum Contaminant Level (MCL) regulations, including production capacity testing and a Title 22 water quality analysis.
The budget breakdown includes personnel costs of $155,298, fringe benefits of $66,659, and indirect costs of $331,944, with no separate allocations for travel, equipment, or supplies. The construction costs encompass various elements such as mobilization, dewatering, borehole work, filtration and treatment systems, electrical work, building construction, inspection costs, and security fencing. The project aims to support approximately 53,600 residents who currently rely on a single surface water source, with an emphasis on supporting disadvantaged neighborhoods in the North Area of West Sacramento, specifically Broderick and Bryte. While no specific set-aside designations are mentioned, the project will likely require compliance with federal Disadvantaged Business Enterprise (DBE) participation requirements.
View the file
Other files
Show all 31
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
Instructions
| Budget Detail and Narrative |
| A thorough budget narrative will aid the administrative review and processing of a recommended award. Amounts included in a budget and budget narrative are estimates; in the event of an award, payments will be based on actual expenditures. The following is guidance for your use in preparing a thorough budget narrative. The budget narrative provides a discussion of, or explanation for, items included in the above budget items. The guidance follows the order of the budget items. This Budget Detail and Narrative template is a suggested format to present the breakdown of your estimated costs, by category, needed to accomplish project activities. |
| General Instructions |
| 1. Only fill in light blue cells, white cells contain instructions, headers, or summary calculations and should not be modified. |
2. Rows can be added as needed throughout tabs 6a. through 6j. If rows are added, formulas/calculations may need to be adjusted.
3. The Budget Summary will auto-fill when each Budget Object Class category (BOC) subsection is completed.
4. Rows can be added as needed throughout sections a. through j. If rows are added, formulas/calculations may need to be adjusted.
5. The information in the Budget Summary table must correspond to Section B of the SF-424A
6. The budget estimate should include all project costs, regardless if the costs will be paid with Federal or non-Federal funds or contributed by a third-party.
7. All costs in BOC sections 6a. through 6h. must be directly related to the project activities.
8. All costs must be allowable, allocable, and reasonable in accordance with the administrative requirements and applicable cost principles prescribed in 2 CFR 200.
9. Only non-construction related equipment purchases should be included within BOC subsection 6e. Equipment.
10. All costs for sub-recipients and contractual/consultant costs that are not related to construction activities should be included within BOC subsection 6f. Contractual.
11. All construction costs, including recipient-owned equipment use costs, equipment rental and purchase costs, supply costs, engineering services, and construction contract costs must be included under BOC subsection 6g. Construction.
12. All third-party in-kind contributions of goods and services, including services performed by volunteers must be included with BOC subsection 6h. Other.
13. All costs must comply with the cost principles of 2 CFR 200 Subpart E - Cost Principles and be allowable, allocable to the project, and reasonable in amount
| Links: | 2 CFR 200 Subpart E - Cost Principles |
| § 200.403 Factors affecting allowability of costs | |
| § 200.405 Allocable costs | |
| § 200.404 Reasonable costs |
| Cost Share Instructions |
| 1. The budget must include at least the minimum Federal to non-Federal required cost share if applicable. |
2. Cost share encompasses all contributions to the project incurred and paid for during the project. This includes payments for personnel, supplies, equipment, activities and items necessary for the project.
3. In-kind Cost Share encompasses all third party contributions to the project that do not involve a payment or reimbursement and represent donated items or services that are necessary to the performance of the project. This includes volunteer personnel hours, donated existing equipment, donated existing supplies, etc.
https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRed1f39f9b3d4e72/section-200.430https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRea20080eff2ea53/section-200.403https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRea20080eff2ea53/section-200.405https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRea20080eff2ea53/section-200.404 Budget Summary
Summary Figures in this summary table are calculated from entries made in subsequent categories, only blank white cells require data entry.
| 6. Budget Object Category | Total Cost | Federal Estimated Amount | Non-Federal Estimated Amount |
| a. Personnel | $155,298 |
tc={0E5C4E3C-0211-4B10-849D-EE03DE8B2BF5}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Is there a way to lock these so that they only pull from the other tabs and cannot be edited by the applicant?
Reply:
I am not sure
| b. Fringe Benefits | $66,659 | ||
| c. Travel | $0 | ||
| d. Equipment | $0 | ||
| e. Supplies | $0 | ||
| f. Contractual | $0 | ||
| g. Construction | $3,383,375 | ||
| h. Other Direct Costs | $0 | ||
| i. Total Direct Costs | $3,605,332 | ||
| i. Indirect Charges | $331,944 | ||
| Total Costs | $3,937,276 | $1,968,638 | $1,968,638 |
| Cost Share Percentage | 50% | 50% | |
| $4,825 |
Is there a way to lock these so that they only pull from the other tabs and cannot be edited by the applicant?
I am not sure
6a. Personnel
6a. Personnel This category includes salaries and wages of employees of the applicant organization that will be working directly on the project. Generally, salaries of administrative and/or clerical personnel are classified as indirect or overhead costs in your organization's accounting system included as a portion of the stated indirect costs. If these salaries can be adequately documented as direct costs, they can be included in this section; however, a justification must be included in the narrative. Recommend reviewing § 200.430 Compensation - personal services for more information on the specific requirements regarding compensation costs, including the Standards for Documentation of Personnel Expenses at §200.430(i).
Narrative: For key personnel such as the project manager or principal investigator, identify the name individual and position/title. Other personnel should be identified by position only. For all positions, identify the project tasks that will be performed. Compensation rates can be expressed as hourly rates and number of hours or annual salary and percentage effort that will be contributed to each task, but must be consistent with your organization’s accounting and timekeeping policies. Include estimated hours for compliance with reporting requirements, including the final project report and evaluation. For multi-year projects, identify the level of effort anticipated for each budget year and any estimates increases in compensation rates. Within the budget narrative, provide a certification that the labor rates included in the budget proposal represent the actual labor rates of the identified personnel/positions and are consistently applied to Federal and non-Federal activities. Note: The annual/hourly labor rate must not include fringe benefits.
Links: § 200.430 Compensation - personal services.
| Personnel | |||||
| Position Title | Time (Hrs or %) | Rate (Hr or Salary) | Total Cost | Rate Basis | Comments (as needed) |
| Senior Engineer (Y1) | 400 | $70 | $28,160 | City Salary Schedule | Salary converted to hourly rate |
| Senior Engineer (Y2) | 350 | $73 | $25,379 | City Salary Schedule Y1+3% | assumes 3% growth over previous year |
| Senior Engineer (Y3) | 150 | $75 | $11,203 | City Salary Schedule Y2+3% | assumes 3% growth over previous year |
| Construction Monitor | 200 | $75 | $14,937 | City Salary Schedule Y2+3% | Closest appropriate salary converted to hourly with 3% growth |
| Senior Water Treatment Plant Operator | 500 | $56 | $27,887 | City Salary Schedule Y2+3% | Salary converted to hourly rate with 3% growth |
| Principal Engineer (Y1) | 250 | $78 | $19,448 | City Salary Schedule | Salary converted to hourly rate |
| Principal Engineer (Y2) | 250 | $80 | $20,031 | City Salary Schedule Y1+3% | assumes 3% growth over previous year |
| Principal Engineer (Y3) | 100 | $83 | $8,253 | City Salary Schedule Y2+3% | assumes 3% growth over previous year |
| $0 | |||||
| Total | $155,298 | ||||
| Additional Narrative/Comments: Rates derived from current City Salary Schedules with 3% increase per year. Year 3 prorated to account for only 2 months of the year. Actual Salary rates and personell used may vary at the discretion of City Management. |
https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRed1f39f9b3d4e72/section-200.430 6b. Fringe Benefits
6b. Fringe Benefits Fringe benefits are allowances and services provided by employers to their employees as compensation in addition to regular salaries and wages. Fringe benefits include, but are not limited to, the costs of leave (vacation, family-related, sick or military), employee insurance, pensions, and unemployment benefit plans. Fringe costs should also include employer contributions required by law such as payroll taxes such as FICA, unemployment, and workers compensation. Fringe does not include federal income taxes, employee portion FICA, or other such costs. Recommend reviewing § 200.431 Compensation - fringe benefits for more information on the allowability and allocability of fringe benefits. Note: Car allowances and cars furnished to employees for personal and work use are unallowable as a fringe benefit, regardless of whether the costs is reported as taxable income, and must be excluded from fringe benefit rates.
Narrative: Fringe benefits can be expressed as an hourly rate or percentage of personnel costs, but must correspond to how the costs are documented in your organization's accounting system. In the narrative, identify the fringe benefit rates/amounts for each position. If the fringe benefit rate is less than 35% of the estimated employee compensation, no additional information is necessary. If the fringe benefit rate is more than 35%, provide a description and breakdown of the benefits. If the rate is established within a negotiated indirect cost rate agreement (NICRA), provide a copy of the agreement with the application. Do not combine the fringe benefit costs with direct salaries and wages in the personnel category.
Links: § 200.431 Compensation - fringe benefits
| Fringe Benefits | ||||
| Position Title | Compensation | Quantity | Total Cost | Comments (as needed) |
| Senior Engineer (Y1) | 27 | 400.00 | $10,982 | Rate basis 39% as noted below. |
| Senior Engineer (Y2) | 28 | 350.00 | $9,898 | Rate basis 39% as noted below. |
| Senior Engineer (Y3) | 29 | 150.00 | $4,369 | Rate basis 39% as noted below. |
| Construction Monitor | 29 | 200.00 | $5,826 | Rate basis 39% as noted below. |
| Senior Water Treatment Plant Operator | 30 | 500.00 | $15,059 | Rate basis 54% as noted below. |
| Principal Engineer (Y1) | 33 | 250.00 | $8,362 | Rate basis 43% as noted below. |
| Principal Engineer (Y2) | 34 | 250.00 | $8,613 | Rate basis 43% as noted below. |
| Principal Engineer (Y3) | 35 | 100.00 | $3,549 | Rate basis 43% as noted below. |
| $0 | ||||
| Total | $66,659 | |||
| Additional Narrative/Comments: The fringe benefits for each hour of Senior Engineer are as follows: Medical $4.93; Retirement (PERS) $18.26; 401A $0.99; OPEB $1.41; Medicare $1.02; Worker's Comp $0.92. The fringe benefits for each hour of Principal Engineer are as follows: Medical $9.98; Retirement (PERS) $18.90; 401A $1.09; OPEB $1.56; Medicare $1.13; Worker's Comp $0.93. The fringe benefits for each hour of Senior Water Treatment Plant Operator are as follows: Medical $12.83; Retirement (PERS) $13.48; OPEB $0.97; Medicare $0.79; Worker's Comp $1.56. |
https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRed1f39f9b3d4e72/section-200.431 6c. Travel
6c. Travel Travel costs are expenses incurred by personnel in the performance of project activities. Costs can be charged on an actual cost basis, on a per diem or mileage basis in lieu of actual costs incurred, or on a combination of the two, provided that the method used is applied to the entire trip and not to selected days of the trip. All charges must be consistent with those normally allowed under similar circumstances for non-Federally funded activities and any established travel policies. Recommend reviewing § 200.475 Travel costs
Narrative: Provide a narrative describing any travel employees are anticipated to perform. Include the purpose of the travel and how it relates to project tasks, the origin and destination of the trip, number of personnel traveling, length of stay and all travel costs including airfare, per diem, lodging, transportation, and miscellaneous travel expenses. Identify the basis for rates used, (e.g. GSA Per Diem Rates, published prices) and the total of each planned trip.
Links: § 200.475 Travel costs
| Travel | |||||||||
| Purpose | From/To | # of Days | # of Travelers | Lodging per Traveler | Flight per Traveler | Vehicle per Traveler | Per Diem per Traveler | Cost per Trip | Basis for Estimate |
| N/A | $0 | ||||||||
| $0 | |||||||||
| $0 | |||||||||
| $0 | |||||||||
| $0 | |||||||||
| Total | $0 | ||||||||
| Additional Narrative/Comments: No travel costs are included in the budget. All construction travel will be included in the construction cost bid and City travel costs do not apply as project is within city limits. |
https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRed1f39f9b3d4e72/section-200.475 6d. Equipment
6d. Equipment Equipment is defined in §200.1 as tangible personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the applicant organization for financial statement purposes, or $5,000. Recommend reviewing § 200.439 Equipment and other capital expenditures for additional information on the allowability of equipment costs and § 200.313 Equipment for information regarding the title, use, management and disposition requirements for equipment acquired under a Federal award.
Narrative: If equipment will be purchased, itemize all equipment valued at or greater than your organization's capitalization threshold for financial statement purposes. If your organization's capitalization threshold is greater than $5,000, identify all equipment valued at or greater than $5,000. For each item, identify why it is needed for the completion of the project and how the equipment was priced (published price, quote, etc.). Include in the narrative a comparison of rental and/or lease costs over the purchase of the equipment item. Note: Do not include equipment that will be purchased and/or installed as part of a construction- related activity. Construction costs must be included in Object Class Category 6g.
| Links: | §200.1 Definitions |
| § 200.313 Equipment | |
| § 200.439 Equipment and other capital expenditures |
| Equipment | ||||||
| Equipment Item | Quantity | Unit Cost | Total Cost | Basis of Cost | Purpose | Rental Comparison |
| N/A | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| Total | $0 | |||||
| Additional Narrative/Comments: No equipment costs are included as they will be subject to a competitve bid process and are accounted for in the Construction Cost Section. |
https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-A/subject-group-ECFR2a6a0087862fd2c/section-200.1https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-D/subject-group-ECFR8feb98c2e3e5ad2/section-200.313https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRed1f39f9b3d4e72/section-200.439 6e. Supplies
6e. Supplies Supplies is defined in §200.1 as all tangible personal property other than those described in the definition of equipment. A computing device is a supply if the acquisition cost is less than the lesser of the capitalization level established by your organization for financial statement purposes or $5,000, regardless of the length of its useful life. Recommend reviewing § 200.453 Materials and Supplies Costs, Including the Costs of Computing Devices, regarding the allowability of costs. Supply items must be direct costs to the project and not duplicative of supply costs in the indirect rate. For post-award requirements regarding supplies, recommend reviewing § 200.314 Supplies. For financial management requirements related to supplies, recommend reviewing § 200.302(b)(4)
Narrative: List all expendable supplies noting their purpose in the project and the basis of cost (e.g. vendor quotes, catalogue prices, prior invoices, etc.) For each item, provide the estimated unit cost, quantity, and total cost. General categories may be used, but if a category is viewed as too general or the associated amount is too high, further itemization may be requested.
| Links: | §200.1 Definitions | |
| § 200.453 Materials and Supplies Costs, Including the Costs of Computing Devices | ||
| § 200.314 Supplies | (post award requirements) | |
| § 200.302(b)(4) | (financial management requirements related to supplies) |
| Supplies | |||||
| Supply Item | Quantity | Unit Cost | Total Cost | Basis of Cost | Purpose |
| N/A | $0 | ||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| Total | $0 | ||||
| Additional Narrative/Comments: No supply costs are included as they will be subject to a competitive bid process and are accounted for in the Construction Cost Section. |
&"-,Bold"ATTACHMENT B
BUDGET REVIEW WORKSHEET
https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-A/subject-group-ECFR2a6a0087862fd2c/section-200.1https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRed1f39f9b3d4e72/section-200.453https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-D/subject-group-ECFR8feb98c2e3e5ad2/section-200.314https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-D/section-200.302 6f. Contractual
6f. Contractual Include all contracts and subawards, (other than those for construction activities) under this Budget Object Class Category. Per § 200.1, a contract means, for the purpose of Federal financial assistance, a legal instrument by which a recipient or subrecipient purchases property or services needed to carry out the project or program under a Federal award. The term as used in this part does not include a legal instrument, even if the non-Federal entity considers it a contract, when the substance of the transaction meets the definition of a subaward.
For additional information on subrecipient and contractor determinations, see § 200.331 Subrecipient and contractor determinations. Do not include construction contract costs in this subsection. Construction costs should be included in Budget Object Class Category 6g, Construction.
| Links: | § 200.1 Definitions |
| § 200.331 Subrecipient and contractor determinations. |
| Contracts |
| For each contract, regardless of dollar value, describe the services to be obtained and the applicability or necessity of each to the project. Identify the total estimated cost and the basis(es) used to develop the estimate. For each contract with an estimated amount meeting or exceeding $250,000 or represents 35% or more of the total project cost, provide a separate detailed description of the estimated costs. A detailed estimate can be included with the application in lieu of a description. For contracts with an estimated cost equal to or greater than the micro-purchase threshold (currently $10,000) identify the anticipated procurement method to be used and the basis of selection. |
NOTE: Only contracts for architectural/engineering services can be awarded using a qualifications-based procurement method. If a qualifications-based procurement method is used, profit must be negotiated as a separate element of the contract price. See §200.318 General Procurement Standards for additional information regarding procurements, including required contract content. The procurement method used must be compliant with § 200.319 Competition, and § 200.320 Methods of procurement to be followed. Recommend reviewing §200.459 Professional service costs.
| Links: | § 200.318 General procurement standards |
| § 200.319 Competition | |
| § 200.320 Methods of procurement to be followed. | |
| § 200.459 Professional service costs |
| Contractor Name | Purpose and Contracting Method | Total Cost | Description of costs | Basis of cost |
| N/A | $0 | |||
| $0 | ||||
| $0 | ||||
| $0 | ||||
| $0 | ||||
| $0 | ||||
| Subtotal | $0 | |||
| Additional Narrative/Comments: West Sacramento will contract for the construction through a competitive bid process. All construction related activities and their contracts are accounted for in the Construction tab. All contract budgets in this spreadsheet relate to project management and grant management and are not related to construction. |
| Subawards |
| If known, identify the recipient of each subaward. Describe the activities to be performed under each subaward and indicate the applicability or necessity of each to the project. Provide a separate detailed budget for each subaward, regardless of dollar value. A detailed estimate may be included with the application in lieu of a description of budgeted costs. Identify who prepared the estimate (subrecipient, applicant personnel, etc.) and indicate the basis used to estimate each cost. Include any indirect/overhead costs anticipated to be paid and the rate used. If the subrecipient has a Federal negotiated indirect cost rate agreement (NICRA), include a copy of the NICRA with the application. |
| Subrecipient Name | Description of Activites | Total Cost | Description of budgeted costs | Basis of Cost |
| $0 | ||||
| $0 | ||||
| $0 | ||||
| $0 | ||||
| Subtotal | $0 | |||
| Additional Narrative/Comments: |
TOTAL CONTRACTUAL $0
https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-A/subject-group-ECFR2a6a0087862fd2c/section-200.1https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-D/subject-group-ECFR031321e29ac5bbd/section-200.331file:///C:/bor-82-Financial-Assistance-Leadership-Team/Working%20Groups/§%20200.319%20Competitionhttps://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRed1f39f9b3d4e72/section-200.459https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-D/subject-group-ECFR45ddd4419ad436d/section-200.320https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-D/subject-group-ECFR45ddd4419ad436d/section-200.318 6g. Construction
g. Construction Construction costs are costs incurred in the construction, renovation, and/or equipping of a facility or structure. Costs include, engineering, design, permitting, demolition, acquisition of materials, and installation of improvements.
Identify all construction related costs other than personnel and fringe benefits costs, including, but not limited to applicant-owned equipment use, rental equipment, construction supplies, equipment that will be purchased and installed, construction contracts, permitting, and environmental compliance. Personnel and fringe benefits costs related to construction should be included in Budget Object Class Category 6a and 6b, as applicable.
| Recipient-Owned Equipment Use Costs |
| If you propose to use equipment that you own under the project, provide the use rates and hours for each piece of equipment owned and budgeted. These should be ownership rates developed by the recipient for each piece of equipment (do not include operator costs). If these rates are not available, the U.S. Army Corp of Engineer’s recommended equipment rates for the region are acceptable. Rates for your region can be found at the link below. |
Links: EP1110-1-8 Construction Equipment Ownership and Operating Expense Schedule
| Equipment Item | Hours | Rate | Total Cost | Basis of Cost | Purpose |
| N/A | $0 | ||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| Subtotal | $0 | ||||
| Additional Narrative or Comments: No City owned equipment will be used as construction will occur through a competitive bid process. |
| Construction Materials |
| Identify any construction materials and non-movable equipment that will be purchased from a vendor. Include estimated purchase price, quantity, total cost, and the basis used to estimate the cost (published prices, quotes, previous project, etc.) |
| Item | Quantity | Unit Cost | Total Cost | Basis of Cost | Comments (as needed) |
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| Subtotal | $0 | ||||
| Additional Narrative/Comments: |
| Contractual |
| For each contract, regardless of dollar value, describe the services to be obtained and the applicability or necessity of each to the project. Identify the total estimated cost and the basis(es) used to develop the estimate. For all construction contracts and each contract with an estimated amount meeting or exceeding $250,000 or representing 35% or more of the total project cost, provide a separate detailed description of the estimated costs. A detailed estimate can be included with the application in lieu of a description. For contracts with an estimated cost equal to or greater than the micro-purchase threshold (currently $10,000) identify the anticipated procurement method to be used and the basis of selection. |
NOTE: Only contracts for architectural/engineering services can be awarded using a qualifications-based procurement method. If a qualifications-based procurement method is used, profit must be negotiated as a separate element of the contract price. See §200.318 General Procurement Standards for additional information regarding procurements, including required contract content. The procurement method used must be compliant with § 200.319 Competition, and § 200.320 Methods of procurement to be followed. Recommend reviewing §200.459 Professional service costs.
| Links: | § 200.318 General procurement standards |
| § 200.319 Competition | |
| § 200.320 Methods of procurement to be followed. | |
| § 200.459 Professional service costs |
| Contractor Name | Description of Services | Total Cost | Description of cost estimate | Basis of Cost |
| TBD per bidding process | Mobilization, Demobilization, & Site Cleanup | $90,000 | Standard costs per engineering | |
| Dewatering | $10,000 | Standard costs per engineering | ||
| Borehole Work & Materials | $1,400,000 | $2000 per foot at 700 feet | The estimate is based on the prices and depths in line with other regional municipal wells. | |
| Filtration & Treatment Systems | $600,000 | From previous engineering estimates | The estimate is in line for recent costs for nearby wells to install chlorination and simple green sand ion exchange filtration. | |
| Electrical | $400,000 | From previous engineering estimates | ||
| Mechanical, Pipe, & Valves | $120,000 | From previous engineering estimates | ||
| CMU Buildings | $180,000 | $500 per square foot at 360 square feet | The estimate is based on a previous similar projects. This includes a single building to cover well equipment and electrical. | |
| Inspection Costs | $300,000 | From previous engineering estimates | This estimate includes construction specific inspection and startup costs to verify well operation. | |
| Security fencing | $263,375 | $235 per foot at 1,225 feet |
| Subtotal | $3,363,375 |
| Additional Narrative or Comments: Values in this table were derived from engineering estimates from multiple well projects within the region. Values were adjusted to account for inflation at the time of grant submission. |
| Other Construction-related costs |
| Identify any other construction-related costs (e.g. equipment rental, permitting, etc.) and indicate the applicability or necessity of each to the project. Include quantity, unit cost, total cost, and the basis for the estimate. |
Note: Do not include costs that are anticipated to be paid by a contractor under the terms of the contract. Those items should be included in the contract estimate.
| Item Description | Quantity | Unit Cost | Total Cost | Basis of Cost | Purpose |
| Permitting and Documentation | 1 | $20,000 | From previous engineering estimate | Legally required |
| $0 | |
| $0 | |
| Subtotal | $20,000 |
| Additional Narrative/Comments: |
TOTAL CONSTRUCTION COSTS $3,383,375
https://www.usace.army.mil/Cost-Engineering/EP1110-1-8/file:///C:/bor-82-Financial-Assistance-Leadership-Team/Working%20Groups/§%20200.319%20Competitionhttps://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRed1f39f9b3d4e72/section-200.459https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-D/subject-group-ECFR45ddd4419ad436d/section-200.320https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-D/subject-group-ECFR45ddd4419ad436d/section-200.318 6h. Other Direct Costs
6h. Other This category contains items not included in the previous categories, such as tuition remission, rental costs, etc. List items by type or nature of expense, breaking down costs by cost per unit, quantity, and total cost and identify the basis of cost (quote, invoice, etc.). Describe the necessity of the costs for successful completion of the project and exclude unallowable costs. Recommend reviewing § 200.420 through § 200.476, General Provisions for Selected Items of Cost.
Links: § 200.420 through § 200.476, General Provisions for Selected Items of Cost
| Other | |||||
| Item Description | Quantity | Unit Cost | Total Cost | Basis of Cost | Purpose |
| $0 | |
| $0 | |
| Total | $0 |
| Additional Narrative/Comments: |
| Third-Party Contributions |
| Identify any third-party services and donations (personnel costs, supplies, etc.) and include the name of the contributor. Indicate the applicability or necessity of each to the project and describe the basis(es) for the valuation. All third-party contributions must meet the requirements under § 200.306 Cost sharing or matching, including the valuation of the contribution. |
Links: § 200.306 Cost sharing or matching
| Third Party Contributor | Purpose | Value | Description of costs | Basis of Valuation |
| N/A | $0 | |||
| $0 | ||||
| $0 | ||||
| $0 | ||||
| $0 | ||||
| Subtotal | $0 | |||
| Additional Narrative/Comments: |
TOTAL OTHER $0
https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRed1f39f9b3d4e72/section-200.453https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-D/section-200.306 6j. Indirect Costs
6 j. Indirect Costs
Option 1: Show the rate reflected in the most recent Federal indirect cost rate agreement, cost base, and proposed amount for allowable indirect costs. If your organization has a current Federal negotiated indirect cost rate agreement, it must be included with your application.
Option 2: If your organization has never received a Federal negotiated indirect cost rate, the budget may include a 10 % de minimis rate of modified total direct costs. Per § 200.1 Definitions, Modified Total Direct Cost (MTDC) means all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $25,000 of each subaward (regardless of the period of performance of the subawards under the award). MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs and the portion of each subaward in excess of $25,000. For further information on modified total direct costs, refer to § 200.414 Indirect (F&A) costs.
Option 3: If your organization does not have a federally approved indirect cost rate agreement and is proposing a rate greater than the 10 % de minimis rate, include the computational basis for the indirect expense pool and corresponding allocation base for each rate. Note: If this option is selected, you will be required to submit an indirect cost rate proposal to your cognizant Federal agency within 3 months after the date the award is issued. Information on “Preparing and Submitting Indirect Cost Proposals” is available from Interior, the National Business Center, and Indirect Costs and Acquisition Audit Services at https://ibc.doi.gov/ICS/icrna.
Note: Construction costs are capital expenditures and must be excluded from the indirect cost base.
| Links: | § 200.1 Definitions |
| § 200.414 Indirect (F&A) costs. | |
| https://ibc.doi.gov/ICS/icrna |
| j. Indirect Costs | |||||
| Rate Type | Current Federal NICRA | Base Description | Base Total | Rate | Total Cost |
| ICRP | CIAO | Indirect Cost Rate Proposal | $231,562 | 143.35% | $331,944 |
| $0 | |||||
| $0 | |||||
| $0 | |||||
| Total | $331,944 | ||||
| Estimated amount of indirect costs to be paid with Federal funds | |||||
| Estimated amount of indirect costs to be paid with non-Federal funds |
https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-A/subject-group-ECFR2a6a0087862fd2c/section-200.1https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/subpart-E/subject-group-ECFRd93f2a98b1f6455/section-200.414https://ibc.doi.gov/ICS/icrna
File details come from the government source that posted it. Updated .