ERRS_4_Pricing_Schedule_Dec._19.xlsx

XLSX spreadsheet 45 KB Posted

Attached to
Emergency and Rapid Response Services (ERRS) IV Federal contract opportunity
Solicitation number
SOL-R8-12-00003
Issued by
Environmental Protection Agency Region 8

About this file

Section B - Pricing Schedule in Excel Format. Reference Q 20-27 of the Q A. This spreadsheet must be submitted with offeror's proposal. The spreadsheet is provided for offeror's convenience in submitting requested pricing information. All calculations within cells must be viewable.

View the file

Other files for this federal contract opportunity

Other files attached to Emergency and Rapid Response Services (ERRS) IV, newest first.
File Type Posted
SOL-R8-12-00003_AMD_000001.pdf PDF
Master_Equipment_Number_Report_12-10-12.xlsx XLSX spreadsheet
Q A_for_ERRS_IV_12-19.pdf PDF
SOL-R8-12-00003.pdf PDF
ERRS_COI_Provisions_ _Clauses.pdf PDF

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

ERRS 4 Base Period

Pricing Schedule Years 1-7
Base Period - Years 1 & 2 of Contract
CLIN 001 Regular HoursCLIN 002FixedEstimated DailyCLINDescriptionCeiling
Personnel DescriptionEst. HoursFixed HourlyEst. HourlyRCMS #Item DescriptionDays/2yrDaily RateCosts1Personnel
RatesCosts01-120-001Truck-Boom-<6 tons532Equipment
Program Manager50001-168-018Truck-Dump-Articulated - 25 ton120273783Transportation and Disposal$708,800.00
Response Manager01-160-015Truck-Dump-15 yds<20 yds8501891414Travel$1,280,000.00
Level I26001-230-075Truck-Pickup-2 wheel drive-3/4 tons3177013645Subcontracts and other ODCs$8,552,000.00
Level II704001-235-075Truck-Pickup-4 wheel drive-3/4 tons838186454Including Materials
Foreman295001-285-001Truck-Stakebed/Flatbed-<6 ft.3290731302Total Base Period
Truck Driver1900001-140-010Truck-Car-Passenger681151102
Equipment Operator2285001-160-005Truck-Dump-5yds <10yds23051133
Project Administrative Specialist841001-160-010Truck-Dump-10yds <15yds30067130*Only One G & A Percentage is Allowed
Cleanup Tech1904201-230-050Truck-Pickup-1/2 ton5301181364
Chemist12001-235-050Truck-Pickup 4 wheel drive-1/2 ton30067454
IH/Health and Safety Officer10001-285-001Truck-Stake/Flatbed/Liftga-0 < 6 ft376083697
T & D Coordinator40001-285-006Truck-Stake/Flatbed/Liftga-6 < 12 ft2184868
Laborers352001-290-040Truck-SUV-4 wheel drive1533480
Subcontract Support10001-350-020Truck-Water-2K <3K gallons17940160
Sub-Total01-350-040Truck-Water-4K <5K gallons36080173
02-140-006Trailer-Lowboy/Eqp-6 <10 tons39087104
CLIN 001 Overtime Hours02-150-020Trailer-Office-20 < 25 ft2355258
Personnel DescriptionEst. HoursFixed HourlyEst. Overtime02-160-020Trailer-Storage/Box-20 <25 ft13129207
Overtime RatesCosts02-183-200Trailer-Vacuum HEPA-<200 HP46510315
Program Manager003-120-036Heavy Equipment-Bulldozer-36K<43K256193
Response Manager03-120-066Heavy Equipment-Bulldozer-66K<85K43597120
Level I12003-160-026Heavy Equipment-Excavator-26K<32K27060113
Level II301503-160-043Heavy Equipment-Excavator-43K<45K33574242
Foreman134003-160-080Heavy Equipment-Excavator-80K<90K545121251
Truck Driver1260003-210-026Heavy Equipment-Loader/Wheel-26K<30K800178156
Equipment Operator1100003-250-001Heavy Equipment-Skid Steer-Loaders<6K35078170
Project Administrative Specialist327003-160-Z10Heavy Equipment-Excavator-Attach-Compact Wheel40089200
Cleanup Tech1184003-160-Z40Heavy Equipment-Excavator-Attach-Trencher44910084
Chemist6003-255-080Heavy Equipment-Skid Steer-Loaders-8K <10K1904294
IH/Health and Safety Officer3003-255-Z20Heavy Equipment-Skid Steer-Ldr Multi-Attach Forks24053105
T & D Coordinator8007-215-200Field Equipment-Compressor/Air-> 200 -< 300 CFM10225
Laborers106007-210-040Field Equipment-Compactor-Roller18541153
Subcontract Support4007-300-020Field Equipment-Generator-20<25 KW34577268
Sub-Total07-320-010Field Equipment-Heating Unit-500111122
07-380-010Field Equipment-Field Equipment-Laser Level2746180
Total CLIN 00107-645-010Field Equipment-Welder-Fusion Pipe1814084
07-160-005Field Equipment-Boat/Motor/Trailer-12-16 ft <25HP1904246
07-300-025Field Equipment-Generator-25 < 30 KW27661113
07-410-060Field Equipment-Manlift Boom->= 60 FT25456113
08-245-002Pump-Trash/Sludge Gasoline-2 inch41392184
08-110-020Pump-Acid-2 inch36816
08-130-002Pump-Centrifugal Gasoline-2 in34076151
08-245-003Pump-Trash/Sludge Gasolin-3 in1884284
09-005-005Boom Harbour 6-12 in skirt/per 100 Ft Length501122
09-015-005Oil-Skimmer-Drum 10-20 bbls/hr31722

Total CLIN 002

Attachment 2-SOL-R8-12-00003 Section B - Pricing Schedule

ERRS 4 Option Period 1

Pricing Schedule Years 1-7
Option Period 1 - Years 3 & 4 of Contract
CLIN 001 Regular HoursCLIN 002FixedEstimated DailyCLINDescriptionCeiling
Personnel DescriptionEst. HoursFixed HourlyEst. HourlyEst. HourlyRCMS #Item DescriptionItem DescriptionDays/2yrDaily RateCosts1Personnel
RatesCostsCosts01-120-001Truck-Boom-<6 tonsTruck-Boom-<6 tons532Equipment
Program Manager50001-168-018Truck-Dump-Articulated - 25 ton120Truck-Dump-Articulated - 25 ton3783Transportation and Disposal$737,156.00
Response Manager01-160-015Truck-Dump-15 yds<20 yds850Truck-Dump-15 yds<20 yds1414Travel$1,331,208.00
Level I26001-230-075Truck-Pickup-2 wheel drive-3/4 tons317Truck-Pickup-2 wheel drive-3/4 tons13645Subcontracts and other ODCs$8,894,134.00
Level II704001-235-075Truck-Pickup-4 wheel drive-3/4 tons838Truck-Pickup-4 wheel drive-3/4 tons454Including Materials
Foreman295001-285-001Truck-Stakebed/Flatbed-<6 ft.3290Truck-Stakebed/Flatbed-<6 ft.302Total Option Period 1
Truck Driver1900001-140-010Truck-Car-Passenger681Truck-Car-Passenger102
Equipment Operator2285001-160-005Truck-Dump-5yds <10yds230Truck-Dump-5yds <10yds133
Proj Admin Specialist841001-160-010Truck-Dump-10yds <15yds300Truck-Dump-10yds <15yds130*Only One G & A Percentage is Allowed
Cleanup Tech1904201-230-050Truck-Pickup-1/2 ton530Truck-Pickup-1/2 ton1364
Chemist12001-235-050Truck-Pickup 4 wheel drive-1/2 ton300Truck-Pickup 4 wheel drive-1/2 ton454
IH/Health and Safety Officer10001-285-001Truck-Stake/Flatbed/Liftga-0 < 6 ft3760Truck-Stake/Flatbed/Liftga-0 < 6 ft97
T & D Coordinator40001-285-006Truck-Stake/Flatbed/Liftga-6 < 12 ft218Truck-Stake/Flatbed/Liftga-6 < 12 ft68
Laborers352001-290-040Truck-SUV-4 wheel drive153Truck-SUV-4 wheel drive80
Subcontract Support10001-350-020Truck-Water-2K <3K gallons179Truck-Water-2K <3K gallons160
Sub-Total01-350-040Truck-Water-4K <5K gallons360Truck-Water-4K <5K gallons173
02-140-006Trailer-Lowboy/Eqp-6 <10 tons390Trailer-Lowboy/Eqp-6 <10 tons104
CLIN 001 Overtime Hours02-150-020Trailer-Office-20 < 25 ft235Trailer-Office-20 < 25 ft58
Personnel DescriptionEst. HoursFixed HourlyEst. Overtime02-160-020Trailer-Storage/Box-20 <25 ft131Trailer-Storage/Box-20 <25 ft207
Overtime RatesCosts02-183-200Trailer-Vacuum HEPA-<200 HP465Trailer-Vacuum HEPA-<200 HP15
Program Manager003-120-036Heavy Equipment-Bulldozer-36K<43K25Heavy Equipment-Bulldozer-36K<43K193
Response Manager03-120-066Heavy Equipment-Bulldozer-66K<85K435Heavy Equipment-Bulldozer-66K<85K120
Level I12003-160-026Heavy Equipment-Excavator-26K<30K270Heavy Equipment-Excavator-26K<32K113
Level II301503-160-043Heavy Equipment-Excavator-42K<45K335Heavy Equipment-Excavator-43K<45K242
Foreman134003-160-080Heavy Equipment-Excavator-80K<90K545Heavy Equipment-Excavator-80K<90K251
Truck Driver1260003-210-026Heavy Equipment-Loader/Wheel-26K<30K800Heavy Equipment-Loader/Wheel-26K<30K156
Equipment Operator1100003-250-001Heavy Equipment-Skid Steer-Loaders<6K350Heavy Equipment-Skid Steer-Loaders<6K170
Proj Admin Specialist327003-160-Z10Heavy Equipment-Excavator400Heavy Equipment-Excavator-Attach-Compact Wheel200
Cleanup Tech1184003-160-Z40Heavy Equipment-Excavator-26K <30K449Heavy Equipment-Excavator-Attach-Trencher84
Chemist6003-255-080Heavy Equipment-Skid Steer-Loaders8K <10K190Heavy Equipment-Skid Steer-Loaders8K <10K94
IH/Health and Safety Officer3003-255-Z20Heavy Equipment-Skid Steer-Attach-Forks240Heavy Equipment-Skid Steer-Ldr Multi-Attach Forks105
T & D Coordinator8007-215-200Field Equipment-Compressor / Air-> 200 CFM10Field Equipment-Compressor/Air-> 200 -< 300 CFM25
Laborers106007-210-040Field Equipment-Compactor-Roller185Field Equipment-Compactor-Roller153
Subcontract Support4007-300-020Field Equipment-Generator-20<25 KW345Field Equipment-Generator-20<25 KW268
Sub-Total07-320-010Field Equipment-Heating Unit-500Field Equipment-Heating Unit-122
07-380-010Field Equipment-Field Equipment-Laser Level274Field Equipment-Field Equipment-Laser Level80
Total CLIN 00107-645-010Field Equipment-Welder-Fusion Pipe181Field Equipment-Welder-Fusion Pipe84
07-160-005Field Equipment-Boat/Motor/Trailer-12-16 ft <25HP190Field Equipment-Boat/Motor/Trailer-12-16 ft <25HP46
07-300-025Field Equipment-Generator-25 < 30 KW276Field Equipment-Generator-25 < 30 KW113
07-410-060Field Equipment-Manlift Boom->= 60 FT254Field Equipment-Manlift Boom->= 60 FT113
08-245-002Pump-Trash-2 inch413Pump-Trash/Sludge Gasoline-2 inch184
08-110-020Pump-Acid-2 inch36Pump-Acid-2 inch16
08-130-002Pump-Centrifugal Gasoline-2 in340Pump-Centrifugal Gasoline-2 in151
08-245-003Pump-Trash/Sludge Gasolin-3 in188Pump-Trash/Sludge Gasolin-3 in84
09-005-005Boom Harbour 6-12 in skirt50Boom Harbour 6-12 in skirt/per 100 Ft Length22
09-015-005Oil-Skimmer-Drum 10-20 bbls/hr31Oil-Skimmer-Drum 10-20 bbls/hr22

Total CLIN 002

ERRS 4 Option Period 2

Pricing Schedule Years 1-7
Option Period 2 - Years 5 & 6 of Contract
CLIN 001CLIN 002FixedEstimated DailyCLINDescriptionCeiling
Personnel DescriptionEst. HoursFixed HourlyEst. HourlyRCMS #Item DescriptionDays/2yrDaily RateCosts1Personnel
RatesCosts01-120-001Truck-Boom-<6 tons532Equipment
Program Manager50001-168-018Truck-Dump-Articulated - 25 ton120273783Transportation and Disposal$766,646.00
Response Manager01-160-015Truck-Dump-15 yds<20 yds8501891414Travel$1,384,463.00
Level I26001-230-075Truck-Pickup-2 wheel drive-3/4 tons3177013645Subcontracts and other ODCs$9,249,941.00
Level II704001-235-075Truck-Pickup-4 wheel drive-3/4 tons838186454Including Materials
Foreman295001-285-001Truck-Stakebed/Flatbed-<6 ft.3290731302Total Option Period 2
Truck Driver1900001-140-010Truck-Car-Passenger681151102
Equipment Operator2285001-160-005Truck-Dump-5yds <10yds23051133
Proj Admin Specialist841001-160-010Truck-Dump-10yds <15yds30067130*Only One G & A Percentage is Allowed
Cleanup Tech1940201-230-050Truck-Pickup-1/2 ton5301181364
Chemist12001-235-050Truck-Pickup 4 wheel drive-1/2 ton30067454
IH/Health and Safety Officer10001-285-001Truck-Stake/Flatbed/Liftga-0 < 6 ft376083697
T & D Coordinator40001-285-006Truck-Stake/Flatbed/Liftga-6 < 12 ft2184868
Laborers352001-290-040Truck-SUV-4 wheel drive1533480
Subcontract Support10001-350-020Truck-Water-2K <3K gallons17940160
Sub-Total01-350-040Truck-Water-4K <5K gallons36080173
02-140-006Trailer-Lowboy/Eqp-6 <10 tons39087104
Personnel DescriptionEst. HoursFixed Hourly02-150-020Trailer-Office-20 < 25 ft2355258
Overtime RatesEst. Overtime02-160-020Trailer-Storage/Box-20 <25 ft13129207
Program Manager0Costs02-183-200Trailer-Vacuum HEPA-<200 HP46510315
Response Manager03-120-036Heavy Equipment-Bulldozer-36K<43K256193
Level I12003-120-066Heavy Equipment-Bulldozer-66K<85K43597120
Level II301503-160-026Heavy Equipment-Excavator-26K<32K27060113
Foreman134003-160-043Heavy Equipment-Excavator-43K<45K33574242
Truck Driver1260003-160-080Heavy Equipment-Excavator-80K<90K545121251
Equipment Operator1100003-210-026Heavy Equipment-Loader/Wheel-26K<30K800178156
Proj Admin Specialist327003-250-001Heavy Equipment-Skid Steer-Loaders<6K35078170
Cleanup Tech1184003-160-Z10Heavy Equipment-Excavator-Attach-Compact Wheel40089200
Chemist6003-160-Z40Heavy Equipment-Excavator-Attach-Trencher44910084
IH/Health and Safety Officer3003-255-080Heavy Equipment-Skid Steer-Loaders8K <10K1904294
T & D Coordinator8003-255-Z20Heavy Equipment-Skid Steer-Ldr Multi-Attach Forks24053105
Laborers106007-215-200Field Equipment-Compressor/Air-> 200 -< 300 CFM10225
Subcontract Support4007-210-040Field Equipment-Compactor-Roller18541153
Sub-Total07-300-020Field Equipment-Generator-20<25 KW34577268
07-320-010Field Equipment-Heating Unit-500111122
Total CLIN 00107-380-010Field Equipment-Field Equipment-Laser Level2746180
07-645-010Field Equipment-Welder-Fusion Pipe181Field Equipment-Welder-Fusion Pipe84
07-160-005Field Equipment-Boat/Motor/Trailer-12-16 ft <25HP190Field Equipment-Boat/Motor/Trailer-12-16 ft <25HP46
07-300-025Field Equipment-Generator-25 < 30 KW276Field Equipment-Generator-25 < 30 KW113
07-410-060Field Equipment-Manlift Boom->= 60 FT254Field Equipment-Manlift Boom->= 60 FT113
08-245-002Pump-Trash/Sludge Gasoline-2 inch413Pump-Trash-3 inch184
08-110-020Pump-Acid-2 inch36Pump-Acid-2 inch16
08-130-002Pump-Centrifugal Gasoline-2 in340Pump-Centrifugal Gasoline-2 in151
08-245-003Pump-Trash/Sludge Gasolin-3 in188Pump-Trash/Sludge Gasolin-3 in84
09-005-005Boom Harbour 6-12 in skirt/per 100 Ft Length50Boom Harbour 6-12 in skirt22
09-015-005Oil-Skimmer-Drum 10-20 bbls/hr31Oil-Skimmer-Drum 10-20 bbls/hr22

Total CLIN 002

ERRS 4 Option Period 3

Pricing Schedule Years 1-7
Option Period 3 - Year 7 of Contract
CLIN 0001CLIN 002FixedEstimated DailyCLINDescriptionCeiling
Personnel DescriptionEst. HoursFixed HourlyEst. HourlyRCMS #Item DescriptionDays/1yrDaily RateCosts1Personnel
RatesCosts01-120-001Truck-Boom-<6 tons272Equipment
Program Manager25001-168-018Truck-Dump-Articulated - 25 ton120271893Transportation and Disposal$390,985.00
Response Manager01-160-015Truck-Dump-15 yds<20 yds850189714Travel$706,068.00
Level I13001-230-075Truck-Pickup-2 wheel drive-3/4 tons317706825Subcontracts and other ODCs$4,717,415.00
Level II352001-235-075Truck-Pickup-4 wheel drive-3/4 tons838186227Including Materials
Foreman147501-285-001Truck-Stakebed/Flatbed-<6 ft.3290731151Total Option Period 3
Truck Driver950001-140-010Truck-Car-Passenger68115151
Equipment Operator1142501-160-005Truck-Dump-5yds <10yds2305167
Proj Admin Specialist420501-160-010Truck-Dump-10yds <15yds3006765
Cleanup Tech952101-230-050Truck-Pickup-1/2 ton530118682
Chemist6001-235-050Truck-Pickup 4 wheel drive-1/2 ton30067227
IH/Health and Safety Officer5001-285-001Truck-Stake/Flatbed/Liftga-0 < 6 ft376083649
T & D Coordinator20001-285-006Truck-Stake/Flatbed/Liftga-6 < 12 ft2184834
Laborers176001-290-040Truck-SUV-4 wheel drive1533440
Subcontract Support5001-350-020Truck-Water-2K <3K gallons1794080
Sub-Total01-350-040Truck-Water-4K <5K gallons3608086
02-140-006Trailer-Lowboy/Eqp-6 <10 tons3908752
Personnel DescriptionEst. HoursFixed Hourly02-150-020Trailer-Office-20 < 25 ft2355229
Overtime RatesEst. Overtime02-160-020Trailer-Storage/Box-20 <25 ft13129104
Program Manager0Costs02-183-200Trailer-Vacuum HEPA-<200 HP4651038
Response Manager03-120-036Heavy Equipment-Bulldozer-36K<43K25697
Level I6003-120-066Heavy Equipment-Bulldozer-66K<85K4359760
Level II150703-160-026Heavy Equipment-Excavator-26K<32K2706057
Foreman67003-160-043Heavy Equipment-Excavator-43K<45K33574121
Truck Driver630003-160-080Heavy Equipment-Excavator-80K<90K545121126
Equipment Operator550003-210-026Heavy Equipment-Loader/Wheel-26K<30K80017878
Proj Admin Specialist160503-250-001Heavy Equipment-Skid Steer-Loaders<6K3507885
Cleanup Tech592003-160-Z10Heavy Equipment-Excavator-Attach-Compact Wheel40089100
Chemist3003-160-Z40Heavy Equipment-Excavator-Attach-Trencher44910042
IH/Health and Safety Officer1503-255-080Heavy Equipment-Skid Steer-Loaders8K <10K1904247
T & D Coordinator4003-255-Z20Heavy Equipment-Skid Steer-Ldr Multi-Attach Forks2405353
Laborers53007-215-200Field Equipment-Compressor/Air-> 200 -< 300 CFM10212
Subcontract Support2007-210-040Field Equipment-Compactor-Roller1854176
Sub-Total07-300-020Field Equipment-Generator-20<25 KW34577134
07-320-010Field Equipment-Heating Unit-50011161
Total CLIN 00107-380-010Field Equipment-Field Equipment-Laser Level2746140
07-645-010Field Equipment-Welder-Fusion Pipe1814042
07-160-005Field Equipment-Boat/Motor/Trailer-12-16 ft <25HP1904223
07-300-025Field Equipment-Generator-25 < 30 KW2766156
07-410-060Field Equipment-Manlift Boom->= 60 FT2545656
08-245-002Pump-Trash/Sludge Gasoline-2 inch4139292
08-110-020Pump-Acid-2 inch3688
08-130-002Pump-Centrifugal Gasoline-2 in3407676
08-245-003Pump-Trash/Sludge Gasolin-3 in1884242
09-005-005Boom Harbour 6-12 in skirt/per 100 Ft Length501111
09-015-005Oil-Skimmer-Drum 10-20 bbls/hr31711

Total CLIN 002

Total Estimated Costs for ERRS

Total Capacity for Years 1-7 of Contract:
Contract PeriodEstimated Costs
Base Period - Years 1-2 (CLIN 001-CLIN 005)
1st Option Period - Years 3-4 (CLIN 001-CLIN 005)
2st Option Period - Years 5-6 (CLIN 001-CLIN 005)
Last Option Period - Year 7 (CLIN 001-CLIN 005)
Total for Base Period and Option Periods
Total for Diaster Relief (33% of Years 1-7)
Grand Total for Base, Option Periods, and Diaster Relief

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