Sample_Project_2_Template_CPFF_R0005.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Northwestern Division Regional $75M Section 8(a) SB Set-Aside IDIQ MATOC for Preplaced Remedial Action Contract (PRAC)
Solicitation number
W912DW-17-R-0003
Issued by

About this file

From the source

Sample Project 2 Template CPFF_R0005

View the file

Other files

File Type Posted
R0006.pdf PDF
R0005.pdf PDF
Sample_Project_1_Template_FFP_R0005.xlsx XLSX spreadsheet
R0004.pdf PDF
R0003.pdf PDF
R0002.pdf PDF
Pre-Award_Information.pdf PDF
R0001.pdf PDF
RFP_W912DW-17-R-0003.pdf PDF
Sample_Project_2_Template_CPFF.xlsx XLSX spreadsheet
Sample_Project_1_Template_FFP.xlsx XLSX spreadsheet
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Sample Project 2 SAMPLE PROJECT 2 (See Section J, Att 2 in Solicitation) - for PCB-contaminated soil excavation (cost reimbursable; cost plus fixed fee)

INSTRUCTIONS

1. Red = example information for the offeror to write over.

2. Fill in your direct and marked-up unit costs; some cells are pre-populated with information from the RFP.

3. Below the table, provide examples of how markups are applied to direct costs

4. Insert hours or qty for each line item as appropriate for each bid item.

5. Add rows as necessary. Please double check the formulas if you do so.

6. Enter your profit or fee in Cell Y8.

7. Please double check all calculations before submitting your proposal!Bid Item 1Bid Item 2Bid Item 3Bid Item 4Bid Item 5Bid Item 6Bid Item 7Bid Item 8Bid Item 9Bid Item 10Bid Item 11TOTAL
Pre-Construction Submittals (PRE-DETERMINED)General Conditions
(9 months)Mobilization and Demobilization (LS)Soil Excavation, Sampling and Stockpiling (includes stripped topsoil); BCY = 65,300Load Out, Transportation & Disposal of TSCA Material (Subtitle C facility; 14,500 tons
Load Out, Transportation & Disposal of non-TSCA Material (Subtitle D facility); 28,000 tonsSample Collection (LS)Backfill, Place and Compact; 60,400 BCYPlace Topsoil (4900 BCY) and seeding; 6 acresCloseout Report (PRE-DETERMINED)Fixed Fee
Labor:$ - 0$ 6,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0Labor:$ 6,000
Other costs:$ 75,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 75,000Other costs:$ 150,000
Sub-total$ 75,000$ 6,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 75,000Sub-total:$ 156,000
Travel:$ - 0$ 2,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0Travel:$ 2,000
Fixed Fee% - use max fee proposed in RFP Section B, Table 3:n/an/an/an/an/an/an/an/an/an/a1%$ 1,560Fixed Fee$ 1,560
BID ITEM TOTAL$ 75,000$ 8,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 75,000$ 1,560Bid Total$ 159,560
Labor CategoryBase RateBurdened
RateUnitHoursMarked-Up CostHoursMarked-Up CostHoursMarked-Up CostHoursMarked-Up CostHoursMarked-Up CostHoursMarked-Up CostHoursMarked-Up CostHoursMarked-Up CostHoursMarked-Up CostHoursMarked-Up CostHoursCostTotal HoursMarked-Up Cost
---Use Your Section B Professional Rates
Pro Labor 1$1.00$1,000.00HR1$ 1,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 1,000
Pro Labor 2$1.00$1,000.00HR1$ 1,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 1,000
Pro Labor 3$1.00$1,000.00HR1$ 1,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 1,000
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
---Use Davis-Bacon rates from Sample Project in RFP, as necessary
DBA Labor 1$1.00$1,000.00HR1$ 1,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 1,000
DBA Labor 2$1.00$1,000.00HR1$ 1,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 1,000
DBA Labor 3$1.00$1,000.00HR1$ 1,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 1,000
0$ - 0
SUBTOTAL Labor0$ - 06$ 6,0000$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 06$ 6,000$6,000.00Sum is OK
Other Costs (Materials, Equipment, Subs, Incidentals) - list itemsDirect Unit CostMarked-Up
Unit CostUnitQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostTotal QtyTotal Marked-Up Cost
Costs provided in RFP
Pre-Work SubmittalsN/A$75,000.00LS1$ 75,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 75,000
Closeout ReportN/A$75,000.00LS$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 75,0001$ 75,000
Materials
XXXX$1.00$1.00EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
Add rows as necessary…$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
Equipment
XXXX$1.00$1.00HR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
XXXX$1.00$1.00HR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
Add rows as necessary…$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
Subcontractors
T&D: Subtitle C (Provided in RFP)$380.00$1.00TON$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
T&D: Subtitle D (Provided in RFP)$120.00$1.00TON$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
Imported Backfill (Provided in RFP)$15.00$1.00TON$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
Add rows as necessary…$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
Incidentals
XXXXmo$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
XXXXmo$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
Add rows as necessary…$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
0$ - 0
SUBTOTAL Other Costs$ 75,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 75,000$ - 00$ 150,000$150,000.00Sum is OK
Travel CostsDirect Unit CostMarked-Up
Unit CostUnitQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostQtyMarked-Up CostTotal QtyTotal Marked-Up Cost
Airfare$1.00$1,000.00ea1$ 1,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 1,000
Per Diem$1.00$1,000.00day1$ 1,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01$ 1,000
Add rows as necessary…$1.00$1.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
SUBTOTAL Travel Costs$ - 0$ 2,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ 2,000$2,000.00Sum is OK

Example Calculations of Indirect Costs

&D

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