Atch 3 - Bid Schedule FY25 Striping Rubber Removal.xlsx
XLSX spreadsheet 58 KB Posted
- Solicitation number
- FA449725R0007
About this file
This is a pricing bid schedule template in Excel format for a FY25 Airfield Striping and Rubber Removal project at Dover Air Force Base, DE (Project No. FJXT 210073). The template includes division sheets for contractors to input costs, with specific focus on Division 1 (General Requirements) and Division 32 (Exterior Improvements).
The bid schedule template requires contractors to provide pricing for 475 hours of Restricted Area Badge Holder/Escort services, paint removal for 10,000 SF, reflective pavement markings (Type I) for 225,000 SF, non-reflective pavement markings for 65,000 SF, and rubber removal for 1,064,000 SF. The template includes sections for labor, materials, and equipment costs, with automated calculations for overhead, profit, risk/bonding, and design costs. Contractors must complete areas marked "Fill Here" in the summary tab, and the template allows for adjustments to overhead and profit percentages for both prime and subcontractors.
View the file
Other files
Show all 19
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 Striping & Rubber Removal | ||||
| LOCATION | PROJECT NO. | FJXT 210073 | ||
| 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 |
DIVISION 49 RESERVED ERROR:#REF! ERROR:#REF!
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.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
| PROJECT | BASIS FOR ESTIMATE | ||
| FY25 Airfield Striping & Rubber Removal | 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 210073 | ||
| DRAWING NO. | ESTIMATOR | CHECKED BY |
| QUANTITY | LABOR | EQUIPMENT | |||||
| ITEM DESCRIPTION | NO. UNITS | UNIT MEAS. | PER UNIT | TOTAL | PER UNIT | TOTAL | TOTAL COST |
| GENERAL REQUIREMENTS | |||||||
| Restricted Area Badge Holder/Escort | 475 | HR | - 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
| PROJECT | BASIS FOR ESTIMATE | ||
| FY25 Airfield Striping & Rubber Removal | 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 210073 | ||
| DRAWING NO. | ESTIMATOR | CHECKED BY |
| QUANTITY | LABOR | MATERIAL | |||||
| ITEM DESCRIPTION | NO. UNITS | UNIT MEAS. | PER UNIT | TOTAL | PER UNIT | TOTAL | TOTAL COST |
| EXTERIOR IMPROVEMENTS | |||||||
| Paint Removal | 10,000 | SF | $0.00 | $0.00 | |||
| Pavement Markings, Reflective (Type I) | 225,000 | SF | $0.00 | $0.00 | |||
| Pavement Markings, Reflective(Type III) | SF | $0.00 | $0.00 | ||||
| Pavement Markings, Non-Reflective | 65,000 | SF | $0.00 | $0.00 | $0.00 | ||
| Rubber Removal | 1,064,000 | SF | $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 | |||||
| (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 .