Attachment 18 - Estimated Quantities Rev 02.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- FRP MATOC NORTH EAST REGION W912DY-18-R-0063
- Solicitation number
- W912DY18R0063
About this file
This document package includes an estimated quantities spreadsheet, proposed maximum indirect rates spreadsheet, and solicitation for a facilities reduction program multiple award task order contract for the North East Region.
The estimated quantities spreadsheet outlines the labor categories and estimated hours needed over the five-year period for home office and field positions. Pricing is in fully burdened hourly rates, with assumptions that the contractor will work continuously and subcontract all work other than home office labor. The proposed maximum indirect rates spreadsheet lists the proposed escalation, overhead, G&A, and loaded hourly labor rates for the base period and four option periods. The solicitation seeks demolition and abatement services for small to very large facilities and associated contaminants. The Army Corps of Engineers is seeking these services to support its facilities reduction program in the North East Region through the award of indefinite delivery/indefinite quantity contracts.
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
Build Up of FBLRs
| Attachment 18 - Estimated Quantities | Offerors shall enter data in yellow highlighted cells | BINDING MAXIMUM FULLY BURDENED LABOR RATES | |||||||||
| Offeror: | Offerors should verify formulas within these cells are consistent with the Offerors standard accounting practice | ||||||||||
| Enter data only in yellow highlighted cells | Enter data only in yellow highlighted cells | Enter data only in yellow highlighted cells | Enter data only in yellow highlighted cells | ||||||||
| Base Period | Opton Period 1 | Opton Period 2 | Opton Period 3 | ||||||||
| Proposed Escalation Factor (% increase from prior year) >>> | >>>>>>>>>>>>>>>>>>>>>>>> | >>>>>>>>>>>>>>>>>>>>>>>> | >>>>>>>>>>>>>>>>>>>>>>>> | ||||||||
| Labor ID# | Labor Category/ | ||||||||||
| Skill Level | Labor Category Type | ||||||||||
| (Exempt, Non-Exempt, Wage) | Location | Direct Hourly Labor Rate ($/hr) | Overhead and Fringe Benefits (Home) | Overhead and Fringe Benefits (Field) | G&A ($/hr) |
Gray Rider: Instructions to Offerors: The calculations for G&A assume a Total Cost Input G&A base. Each contractor should verify that the calculations in this spreadsheet match the contractors standard accounting practice Loaded Hourly Labor Rate ($/hr) Gray Rider: Instructions to Offerors:
Loaded hourly Labor Rates shall NOT include profit or fee. Profit or fee will be negotiated when task orders are issued. Direct Hourly Labor Rate ($/hr) Overhead and Fringe Benefits (Home) Overhead and Fringe Benefits (Field) G&A ($/hr) Gray Rider: Instructions to Offerors:
The calculations for G&A assume a Total Cost Input G&A base. Each contractor should verify that the calculations in this spreadsheet match the contractors standard accounting practice Loaded Hourly Labor Rate ($/hr) Gray Rider: Instructions to Offerors:
Loaded hourly Labor Rates shall NOT include profit or fee. Profit or fee will be negotiated when task orders are issued. Direct Hourly Labor Rate ($/hr) Overhead and Fringe Benefits (Home) Overhead and Fringe Benefits (Field) G&A ($/hr) Gray Rider: Instructions to Offerors:
The calculations for G&A assume a Total Cost Input G&A base. Each contractor should verify that the calculations in this spreadsheet match the contractors standard accounting practice Loaded Hourly Labor Rate ($/hr) Gray Rider: Instructions to Offerors:
Loaded hourly Labor Rates shall NOT include profit or fee. Profit or fee will be negotiated when task orders are issued. Direct Hourly Labor Rate ($/hr) Overhead and Fringe Benefits (Home) Overhead and Fringe Benefits (Field) G&A ($/hr) Gray Rider: Instructions to Offerors:
The calculations for G&A assume a Total Cost Input G&A base. Each contractor should verify that the calculations in this spreadsheet match the contractors standard accounting practice Gray Rider: Instructions to Offerors: The calculations for G&A assume a Total Cost Input G&A base. Each contractor should verify that the calculations in this spreadsheet match the contractors standard accounting practice Loaded Hourly Labor Rate ($/hr) Gray Rider: Instructions to Offerors:
Loaded hourly Labor Rates shall NOT include profit or fee. Profit or fee will be negotiated when task orders are issued.
Gray Rider: Instructions to Offerors:
| Loaded hourly Labor Rates shall NOT include profit or fee. Profit or fee will be negotiated when task orders are issued. | 100 | Principal | Home | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 101 | Corporate Contracts Manager | Home | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 102 | Program Manager (PgM) | Home | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 103 | Corporate Safety Manager | Home | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 104 | Contractor Quality Control (CQC) Manager | Home | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 105 | Regulatory Specialist | Home | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 106 | Certified Industrial Hygienist (CIH) | Home | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 107 | Waste Manager | Home | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 108 | Project Manager (PM) | Field | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 109 | Site Safety/Health Officer (SSHO) | Field | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 110 | Site Superintendant (SS) | Field | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 111 | Site Contractor Quality Control (CQC) Manager | Field | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| For Official Use Only |
| SOURCE SELECTION INFORMATION – FAR 2.101 & 3.104 |
Note to Offerors:
The following rates will be maximum binding rates for the contract:
Direct Hourly Labor Rates Escalation Overhead and Fringe (Home) Overhead and Fringe (Field) General and Administrative (G&A) Loaded Hourly Labor Rates
Labor Rates
| ATTACHMENT 18 | ||||
| BINDING MAXIMUM FULLY BURDENED LABOR RATES | ||||
| FULLY BURDENED LABOR RATE PER HOUR | FULLY BURDENED LABOR RATE PER HOUR | FULLY BURDENED LABOR RATE PER HOUR | FULLY BURDENED LABOR RATE PER HOUR | |
| DIRECT LABOR CATEGORY | BASE PERIOD | OPTION YEAR #1 | OPTION YEAR #2 | OPTION YEAR #3 |
| Principal | $0.00 | $0.00 | $0.00 | $0.00 |
| Corporate Contracts Manager | $0.00 | $0.00 | $0.00 | $0.00 |
| Program Manager (PgM) | $0.00 | $0.00 | $0.00 | $0.00 |
| Corporate Safety Manager | $0.00 | $0.00 | $0.00 | $0.00 |
| Contractor Quality Control (CQC) Manager | $0.00 | $0.00 | $0.00 | $0.00 |
| Regulatory Specialist | $0.00 | $0.00 | $0.00 | $0.00 |
| Project Manager (PM) | $0.00 | $0.00 | $0.00 | $0.00 |
| Site Safety/Health Officer (SSHO) | $0.00 | $0.00 | $0.00 | $0.00 |
| Site Superintendant (SS) | $0.00 | $0.00 | $0.00 | $0.00 |
| Site Contractor Quality Control (CQC) Manager | $0.00 | $0.00 | $0.00 | $0.00 |
| Certified Industrial Hygienist (CIH) | $0.00 | $0.00 | $0.00 | $0.00 |
| Waste Manager | $0.00 | $0.00 | $0.00 | $0.00 |
| Assumptions: | ||||
| * Fully-burdened labor rate is your full cost of an hour's worth of work. It includes all payroll taxes and any other costs related to labor; such as vacation pay, health insurance, and any other benefites or expenses related to employment shall be included. Fully burdened rates should include direct labor and all applicable fringe, labor overhead, and G&A applied to labor. | ||||
| ** Fully-burdened labor rates should NOT include profit; since, profit will be negotiated when task orders are issued | ||||
| *** Fully-burdened labor rates in this tab are the binding maximum fully burdened rates and shall be traceable to the build-up of Fully Burdened Labor Rates (FBLRs) in the spreadsheet tab titled "Build-up of FBLRs" | ||||
| *** Fully-burdened labor rates in this tab are the binding maximum fully burdened rates and shall be traceable to the build-up of rates in the spreadsheet tab titled "Estimated Quantities" | ||||
| For Official Use Only | ||||
| SOURCE SELECTION INFORMATION – FAR 2.101 & 3.104 |
Estimated Quantities
| BINDING MAXIMUM FULLY BURDENED LABOR RATES | |
| ASSUMPTIONS | |
| 1 | Contractor is working continuously for FRP |
| 2 | The task orders start on the first day of the MATOC |
| 3 | The task orders complete closeout the last day of the MATOC |
| 4 | Two projects (2 crews are needed to complete volume of work in a year) |
| 5 | 50 WKS per year are working WKS |
| 6 | Contractor requires more home office time to start and close task orders |
| 7 | All other work on the Task Orders is sub-contracted |
| 8 | $/HR rate shall be traceable to the Binding Maximum Rates on the spreadsheet tab titled "Labor Rates" |
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | ||||||||||||||||||||
| YEAR 1 | YEAR 1 | YEAR 2 | YEAR 2 | YEAR 3 | YEAR 3 | YEAR 4 | YEAR 4 | YEAR 5 | YEAR 5 | ||||||||||||||
| POSITION | LOCATION | WK/YEAR | HR/YEAR | $/HR | EXTENSTION | WK/YEAR | HR/YEAR | $/HR | EXTENSTION | WK/YEAR | HR/YEAR | $/HR | EXTENSTION | WK/YEAR | HR/YEAR | $/HR | EXTENSTION | WK/YEAR | HR/YEAR | $/HR | EXTENSTION | ||
| Principal | Home | 4 | 160 | $0.00 | $0.00 | 2 | 80 | $0.00 | $0.00 | 2 | 80 | $0.00 | $0.00 | 2 | 80 | $0.00 | $0.00 | 5 | 200 | $0.00 | $0.00 | ||
| Corporate Contracts Manager | Home | 16 | 640 | $0.00 | $0.00 | 8 | 320 | $0.00 | $0.00 | 8 | 320 | $0.00 | $0.00 | 8 | 320 | $0.00 | $0.00 | 20 | 800 | $0.00 | $0.00 | ||
| Program Manager (PgM) | Home | 50 | 2000 | $0.00 | $0.00 | 25 | 1000 | $0.00 | $0.00 | 25 | 1000 | $0.00 | $0.00 | 25 | 1000 | $0.00 | $0.00 | 50 | 2000 | $0.00 | $0.00 | ||
| Corporate Safety Manager | Home | 13 | 520 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 16.25 | 650 | $0.00 | $0.00 | ||
| Contractor Quality Control (CQC) Manager | Home | 13 | 520 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 16.25 | 650 | $0.00 | $0.00 | ||
| Regulatory Specialist | Home | 26 | 1040 | $0.00 | $0.00 | 13 | 520 | $0.00 | $0.00 | 13 | 520 | $0.00 | $0.00 | 13 | 520 | $0.00 | $0.00 | 32.5 | 1300 | $0.00 | $0.00 | ||
| Certified Industrial Hygienist (CIH) | Home | 13 | 520 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 16.25 | 650 | $0.00 | $0.00 | ||
| Waste Manager | Home | 13 | 520 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 6.5 | 260 | $0.00 | $0.00 | 16.25 | 650 | $0.00 | $0.00 | ||
| TOTAL | $0.00 | TOTAL | $0.00 | TOTAL | $0.00 | TOTAL | $0.00 | TOTAL | $0.00 | ||||||||||||||
| SUB-TOTAL | $0.00 | ||||||||||||||||||||||
| Project Manager (PM) | Field | 100 | 4000 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 40 | 1600 | $0.00 | $0.00 | ||
| Site Safety/Health Officer (SSHO) | Field | 70 | 2800 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 40 | 1600 | $0.00 | $0.00 | ||
| Site Superintendant (SS) | Field | 70 | 2800 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 40 | 1600 | $0.00 | $0.00 | ||
| Site Contractor Quality Control (CQC) Manager | Field | 60 | 2400 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 100 | 4000 | $0.00 | $0.00 | 40 | 1600 | $0.00 | $0.00 | ||
| TOTAL | $0.00 | TOTAL | $0.00 | TOTAL | $0.00 | TOTAL | $0.00 | TOTAL | $0.00 | ||||||||||||||
| SUB-TOTAL | $0.00 | ||||||||||||||||||||||
| For Official Use Only | |||||||||||||||||||||||
| SOURCE SELECTION INFORMATION – FAR 2.101 & 3.104 |
Proposed Maximum Indirect Rates
| Proposed Maximum Binding Rates: | ||||
| Rate Category | Base Period | Option Period 1 | Option Period 2 | Option Period 3 |
| Escalation | 0.00% | 0.00% | 0.00% | 0.00% |
| OH1 | 0.00% | 0.00% | 0.00% | 0.00% |
| OH2 | 0.00% | 0.00% | 0.00% | 0.00% |
| G&A | 0.00% | 0.00% | 0.00% | 0.00% |
The rates in this spreadsheet represent the proposed maximum binding indirect rates from the spreadsheet titled "Build Up of FBLR."
| &D | For Official Use Only |
| SOURCE SELECTION INFORMATION – FAR 2.101 & 3.104 | &T |
&F &A
File details come from the government source that posted it. Updated .