I.B.08 Attachment 18 - Estimated Quantities.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- FRP Pacific Region MATOC Federal contract opportunity
- Solicitation number
- W912DY20R0034
About this file
This document contains an estimated quantities spreadsheet and instructions for a multiple award task order contract solicitation for facilities reduction and demolition services. The solicitation seeks to establish indefinite delivery/indefinite quantity contracts with multiple awardees to perform services including facility demolition, abatement of contaminants like asbestos and lead, environmental assessments, waste transportation and disposal. Services will be ordered through fixed-price task orders over five one-year ordering periods. The spreadsheet templates require offerors to provide binding maximum fully burdened labor rates for home office and field positions along with assumptions for labor hours by labor category and location for the base year and four option years.
View the file
Other files for this federal contract opportunity
Show all 25
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
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% |
| 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 .