Bid Schedule FY25 Airfield Preventative Maintenance.xlsx
XLSX spreadsheet 61 KB Posted
- Attached to
- FY 25 Airfield Preventative Maintenance
- Solicitation number
- FA449725R0012
About this file
This document is a comprehensive Bid Schedule Excel spreadsheet for the FY25 Airfield Preventative Maintenance project at Dover Air Force Base. The solicitation, numbered FA449725R0012, is valued between $250,000 and $500,000 and involves critical airfield infrastructure repairs for the 436th Civil Engineering unit. Specific project requirements include crack sealing 30,000 linear feet of asphalt pavement, installing 4,146 linear feet of preformed elastomeric joint seal, repairing manhole structures, excavating as needed, repairing 1,000 square feet of concrete spalls, paving with 5 tons of FAA Mix (PG 76-22 binder), and reseeding disturbed areas.
The bid schedule provides a detailed 50-division Construction Specifications Institute (CSI) cost estimate format, allowing contractors to input labor, material, and equipment costs across various project divisions. Contractors are instructed to complete "Fill Here" areas in the summary tab, with the spreadsheet automatically calculating totals. The document includes provisions for contractors to add missing items, suggest alternative elements, and input overhead, profit, and bonding percentages. The project is sponsored by the Department of the Air Force Air Mobility Command and is scheduled for implementation on August 6, 2024.
View the file
Other files
Show all 11
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 Use the information from the prefilled division sheets below to complete the 50 Divisions Cost Estimate CSI* Format tool to build your proposal. The information from the prefilled division sheets may not be all inclusive. The contractor is allowed to include any missing items from each division and is allowed to fill in other divisions that are not listed in the prefilled division sheets. If there is a disagreement with the prefilled division sheets, the contractor should not delete the element(s), but instead leave it blank and then include their suggested element(s) at the bottom of that division tab. Please note that on the summary page there is a place to fill in overhead and profit percentages for both the prime and the subcontractor that will self-populate the summary page and all the division tabs.
Exceptions:
(1) if each subcontractor has a different overhead and profit rates than the percentage placed on the summary page, an adjustment will have to be made to that specific division page. The spreadsheet will still calculate correctly.
(2) If the prime is self-performing the work for that division then the profit and overhead will need to be zeroed for that particular division, because the primes overhead and profit is already captured on the summary page.
The ktr is required to complete the areas marked "Fill Here" in the summary tab. The rest of the information in the summary tab will automatically tabulate from the individual division tabs except for the few exceptions listed above.
Divisions 1, 2, and 3 show sample inputs to illustrate how the spreadsheet works.
* CSI = Construction Specifications Institute
&"Verdana,Bold"Construction Cost Estimate
&P of &N
Summary
| Bid Schedule | |
| 6-Aug-24 | |
| COMPANY | |
| 436th Civil Engineering |
| PROJECT | ||||
| FY25 Airfield Preventative Maintenance | ||||
| LOCATION | PROJECT NO. | FJXT 210077 | ||
| DOVER AIR FORCE BASE, DE | ||||
| DIVISION | DESCRIPTION | % by | ||
| Division | Division Total |
| DIVISION 1 | General Requirements | ERROR:#DIV/0! | $0.00 | |
| DIVISION 32 | Exterior Improvements | ERROR:#DIV/0! | $0.00 | |
| FILL IN AS REQUIRED (this will link to the entire document) |
davisjam: davisjam:
Percentages listed are place fillers. Please complete as required
| GC Overhead |
| GC Profit |
| Risk/Bonding |
| Design |
| This spreadsheet contains many formulas... please save a copy prior to editing in case you make a mistake. All shaded areas are either linked or contain formulas |
| 2 |
| 2 |
Select Area Cost Factor Type:
| DIVISION 36 | RESERVED |
| DIVISION 37 | RESERVED |
| DIVISION 38 | RESERVED |
| DIVISION 39 | RESERVED |
| DIVISION 46 | RESERVED |
| DIVISION 47 | RESERVED |
HARD COST TOTAL ERROR:#DIV/0! $0.00
| PRIME GENERAL CONTRACT OFFICE OVERHEAD (Fill in%) | 0% | $0.00 |
| SUBTOTAL | $0.00 | |
| PRIME GENERAL CONTRACTOR'S PROFIT(Fill in%) | 0% | $0.00 |
| SUBTOTAL | $0.00 | |
| 0 | $0.00 | |
| SUBTOTAL | $0.00 | |
| BUILDER'S RISK / PERFORMANCE BONDS (Fill in%) | 0.0% | $0.00 |
| CONTRACT TOTAL | $ - 0 |
&"Verdana,Bold"Construction Cost Estimate
Sustainment Repair/Const ACF Already Factored
Div1
| Bid Schedule | DATE | |||
| August 6, 2024 | ||||
| PROJECT | BASIS FOR ESTIMATE | |||
| FY25 Airfield Preventative Maintenance | CODE A (No design completed) | |||
| LOCATION | CODE B (Preliminary design) | |||
| DOVER AIR FORCE BASE, DE | CODE C (Final design) | |||
| COMPANY | PROJECT NO. | OTHER (Specify) | ||
| 436th Civil Engineering | FJXT 210077 | |||
| DRAWING NO. | ESTIMATOR | CHECKED BY |
| QUANTITY | LABOR | EQUIPMENT | |||||
| ITEM DESCRIPTION | NO. UNITS | UNIT MEAS. | PER UNIT | TOTAL | PER UNIT | TOTAL | TOTAL COST |
| GENERAL REQUIREMENTS | |||||||
| Site Superintendent | HR | $75.00 | - 0 | - 0 | - 0 | ||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | ||||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| TOTAL LABOR/MATERIALS | - 0 | - 0 | |||||
| SUBTOTAL | - 0 | ||||||
| - 0 | |||||||
| - 0 | |||||||
| - 0 | |||||||
| TOTAL | $ - 0 |
&"Verdana,Bold"Construction Cost Estimate
Div32
| Bid Schedule | DATE | |||
| August 6, 2024 | ||||
| PROJECT | BASIS FOR ESTIMATE | |||
| FY25 Airfield Preventative Maintenance | CODE A (No design completed) | |||
| LOCATION | CODE B (Preliminary design) | |||
| DOVER AIR FORCE BASE, DE | CODE C (Final design) | |||
| COMPANY | PROJECT NO. | OTHER (Specify) | ||
| 436th Civil Engineering | FJXT 210077 | |||
| DRAWING NO. | ESTIMATOR | CHECKED BY |
| QUANTITY | LABOR | MATERIAL | |||||
| ITEM DESCRIPTION | NO. UNITS | UNIT MEAS. | PER UNIT | TOTAL | PER UNIT | TOTAL | TOTAL COST |
| EXTERIOR IMPROVEMENTS | |||||||
| Remove Existing Asphalt, Full Depth | 100 | SY-IN | $0.00 | $0.00 | |||
| Saw Cutting, Asphalt Pavement | 200 | LF-IN | $0.00 | $0.00 | |||
| Earthwork Excavation | 20 | CY | $0.00 | $0.00 | |||
| Manhole Adjustment | 1 | EA | $0.00 | $0.00 | $0.00 | ||
| Spall Repair, Concrete | 1000 | SF-IN | $0.00 | $0.00 | $0.00 | ||
| Preformed Elastomeric Joint Seal | 4116 | LF | $0.00 | $0.00 | $0.00 | ||
| Crack Sealing Bituminous Pavement | 30000 | LF | $0.00 | $0.00 | $0.00 | ||
| Seeding | 100 | SY | $0.00 | $0.00 | $0.00 | ||
| Bituminous Concrete Pavement | 5 | TN | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | |||||
| (02580/1.4 & 1.5) | $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 | |||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||
| $0.00 | |||||||
| (02680/1.3.1 & 1.4.1) | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| $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 | |||||
| TOTAL LABOR/MATERIALS | $0.00 | $0.00 | $0.00 | ||||
| SUBTOTAL | $0.00 | ||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| TOTAL | $0.00 |
&"Verdana,Bold"Construction Cost Estimate
File details come from the government source that posted it. Updated .