Att 9 Pricing Matrix LCAT 10-25-23.xlsx
XLSX spreadsheet 53 KB Posted
- Attached to
- DRAFT Solicitation for Base Operations and Maintenance Services, Fort Huachuca, Arizona 20231115
- Solicitation number
- W9124A23R0005
About this file
This pricing matrix template is to be completed by offerors responding to a solicitation for base operations and maintenance services at Fort Huachuca, Arizona. Offerors must provide fully burdened fixed rates for multiple exempt and non-exempt labor categories across several contract line item numbers for facilities engineering, solid waste management, grounds maintenance, snow and ice removal, facilities maintenance, medical facilities maintenance, surfaced and unsurfaced area maintenance, heating and cooling services, water services, waste water services, utility services, environmental services, and pest management. Rates must be provided for a base period and four option periods, and must include overtime calculations. Accompanying the pricing matrix, offerors must submit supporting documentation clearly outlining the methodology used to derive direct and indirect labor rates. Subcontractor information including labor categories, rates and percentage costs must also be included if applicable.
View the file
Other files
Show 40 more
Latest 50 of 90 listed here. See the rest on GovTribe.
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
1. Instructions
Each Offeror shall complete each tab in the Pricing Matrix LCAT in response to the solicitation. The Offeror shall show the rate build up for each labor category for the full five year option periods, to include overtime rates (Tabs 4-8).
Accompanying the Pricing Matrix LCAT shall be back-up rationale that clearly identifies the methodology used to arrive at the fully loaded rates. Offeror shall depict how direct and indirect rates were derived for all fully burdened labor rates.
The offeror will need to add rows to propose Exempt, Collective Bargaining Agreement (CBA) covered non-exempt, Service Contract Agreement (SCA) covered non-exempt, and Davis-Bacon Act (DBA) covered non-exempt labor categories for each CLIN.
Include the applicable Area Wage Determination's occupation code along with SCA labor categories.
Although some formulas are provided in the spreadsheet cells it is the responsibility of the offeror to make sure all formulas are correct.
Spreadsheets must be completed for each contract period.
Should a contract be issued to the Offeror, the proposed fully burdened (Tabs 4 - 8), fixed price labor rates for all labor categories for each Contract Years provided on this Pricing Matrix LCAT will be binding and incorporated into the resultant contract. These rates shall be the fully burdened, fixed-price labor rates allowable for the proposed labor category.
Adjustments to fully burdened Exempt labor rates will be subject to downward negotiation only.
Each Exempt labor category provided shall include a description of duties (Tab 10).
2. Worksheet Contents
| WORKSHEET CONTENTS |
| WORKSHEET TABS |
| TAB 1 -Instructions |
| TAB 2 - Worksheet Contents |
| TAB 3 - Rate Summary |
| TAB 4 - Base Year Fringe and Direct Labor Calculations |
| TAB 5 - Option Year 1 Fringe and Direct Labor Calculations |
| TAB 6 - Option Year 2 Fringe and Direct Labor Calculations |
| TAB 7 - Option Year 3 Fringe and Direct Labor Calculations |
| TAB 8 - Option Year 4 Fringe and Direct Labor Calculations |
| TAB 9 - Teaming Information |
| TAB 10 - Exempt Labor Categories Descriptions |
3. Rate Summary
| RATE SUMMARY | ||
| A. Labor Escalation Rate | ||
| MGMT/ | SCA | |
| OPTION PERIOD | SCA EXEMPT | |
| Option Period 1 | ||
| Option Period 2 | ||
| Option Period 3 | ||
| Option Period 4 |
| Rate Buildup Summary | FRINGE | OH | G&A | PROFIT | MATERIAL HANDLING FEE |
| Base Period | |||||
| Option Period 1 | |||||
| Option Period 2 | |||||
| Option Period 3 | |||||
| Option Period 4 |
4. Base Period
| Fringe and Direct Labor Calculations | ||||||||||||||||||||||||||
| Base Period | 2080 Hours* | |||||||||||||||||||||||||
| * Note - The Base Period shall be established based on 2080 hours per year, however this period includes 11 months of full performance and 30 days of phase-in | ||||||||||||||||||||||||||
| EXAMPLE: | ||||||||||||||||||||||||||
| Base | Rate | Escal. | Holiday | VACATION | SICK | H&W | FICA | FUTA | SUTA | WORK | OTHER | Total | OH | G&A | Fee | Total Annual Price | Fully Burdened | |||||||||
| FT/PT | Labor Category | Exmpet, SCA Labor Category, CBA Labor Category, DBA Labor Category | Title/Description | Total H&W Hours | Vac. | Hol. | Sick | Man Hours | Pay | Diff | 0.00% | 3.35 | 7.65% | 7000*0.8% | COMP | FRINGE | Fringe | 4.05% | 9.14% | 6% | Cost | Hourly Rate | ||||
| FT | Ex. Program Manger | Exempt | Site Manager | 2080 | 160 | 80 | 0.0 | 1920 | $32.01 | $2,560.80 | $5,121.60 | $0.00 | $54.26 | $56.00 | $952.00 | $849.00 | $0.00 | $17,169.00 | $3,184.44 | $7,477.68 | $5,357.42 | $94,647.73 | $49.30 | |||
| PT | Ex. GFEBS Clerk | SCA - General Clerk | GFEBS Clerk | 1040 | $21.33 | $0.00 | $1,706.40 | $6,432.00 | $3,886.08 | $56.00 | $952.00 | $849.00 | $0.00 | $15,343.38 | $2,280.03 | $5,353.94 | $3,835.86 | $67,766.80 | $35.30 |
CLIN 0001 LABOR - Overarching BASOPS - Program Management
CLIN 0002 LABOR - Annex P - Facilities Engineering Services Management OWO
CLIN 0005 LABOR - Annex E- Solid Waste Management PMO and OWO
CLIN 0006 - LABOR - Annex F - Maintenance - Grounds PMO and OWO
CLIN 0007 LABOR - Annex G - Snow, Ice and Sand Removal PMO and OWO
| CLIN 0008 LABOR - Annex H - Facilities Maintenance |
| CLIN 0011 LABOR - Annex Q -Facilities Maintenance - Medical/Hospital |
| CLIN 0012 LABOR - Annex J - Maintenance - Surfaced and Unsurfaced Areas |
| CLIN 0014 LABOR - Annex K -Heating/Cooling Services |
| CLIN 0015 LABOR - Annex R -Water Services |
| CLIN 0016 LABOR - Annex L - Waste Water Services |
| CLIN 0017 LABOR - Annex S - Other Utility Services |
| CLIN 0018 LABOR - Annex T -Environmental Services |
| CLIN 0019 LABOR - Annex M - Pest Management |
| CLIN 0020 LABOR - PWO-Non Recurring IJOs |
| CLIN 0021 LABOR - Phase in (30 days) |
5. Option Period 1
| Fringe and Direct Labor Calculations | |
| Option Period 1 | 2080 Hours |
| EXAMPLE: | ||||||||||||||||||||||||||
| Base | Rate | Escal. | Holiday | VACATION | SICK | H&W | FICA | FUTA | SUTA | WORK | OTHER | Total | OH | G&A | Fee | Total Annual Price | Fully Burdened | |||||||||
| FT/PT | Labor Category | Exmpet, SCA Labor Category, CBA Labor Category, DBA Labor Category | Title/Description | Total H&W Hours | Vac. | Hol. | Sick | Man Hours | Pay | Diff | 0.00% | 3.35 | 7.65% | 7000*0.8% | COMP | FRINGE | Fringe | 4.05% | 9.14% | 6% | Cost | Hourly Rate | ||||
| FT | Ex. Program Manger | Exempt | Site Manager | 2080 | 160 | 80 | 0.0 | 1920 | $32.01 | $2,560.80 | $5,121.60 | $0.00 | $54.26 | $56.00 | $952.00 | $849.00 | $0.00 | $17,169.00 | $3,184.44 | $7,477.68 | $5,357.42 | $94,647.73 | $49.30 | |||
| FT | Ex. GFEBS Clerk | SCA - General Clerk | GFEBS Clerk | 2080 | 80 | 80 | 0 | 1920 | $21.33 | $1,706.40 | $1,706.40 | $6,432.00 | $3,886.08 | $56.00 | $952.00 | $849.00 | $0.00 | $15,343.38 | $2,280.03 | $5,353.94 | $3,835.86 | $67,766.80 | $35.30 |
CLIN 0001 LABOR - Overarching BASOPS - Program Management
CLIN 0002 LABOR - Annex P - Facilities Engineering Services Management OWO
CLIN 0005 LABOR - Annex E- Solid Waste Management PMO and OWO
CLIN 0006 - LABOR - Annex F - Maintenance - Grounds PMO and OWO
CLIN 0007 LABOR - Annex G - Snow, Ice and Sand Removal PMO and OWO
| CLIN 0008 LABOR - Annex H - Facilities Maintenance |
| CLIN 0011 LABOR - Annex Q -Facilities Maintenance - Medical/Hospital |
| CLIN 0012 LABOR - Annex J - Maintenance - Surfaced and Unsurfaced Areas |
| CLIN 0014 LABOR - Annex K -Heating/Cooling Services |
| CLIN 0015 LABOR - Annex R -Water Services |
| CLIN 0016 LABOR - Annex L - Waste Water Services |
| CLIN 0017 LABOR - Annex S - Other Utility Services |
| CLIN 0018 LABOR - Annex T -Environmental Services |
| CLIN 0019 LABOR - Annex M - Pest Management |
| CLIN 0020 LABOR - PWO-Non Recurring IJOs |
6. Option Period 2
| Fringe and Direct Labor Calculations | |
| Option Period 2 | 2080 Hours |
| EXAMPLE: | ||||||||||||||||||||||||||
| Base | Rate | Escal. | Holiday | VACATION | SICK | H&W | FICA | FUTA | SUTA | WORK | OTHER | Total | OH | G&A | Fee | Total Annual Price | Fully Burdened | |||||||||
| FT/PT | Labor Category | Exmpet, SCA Labor Category, CBA Labor Category, DBA Labor Category | Title/Description | Total H&W Hours | Vac. | Hol. | Sick | Man Hours | Pay | Diff | 0.00% | 3.35 | 7.65% | 7000*0.8% | COMP | FRINGE | Fringe | 4.05% | 9.14% | 6% | Cost | Hourly Rate | ||||
| FT | Ex. Program Manger | Exempt | Site Manager | 2080 | 160 | 80 | 0.0 | 1920 | $32.01 | $2,560.80 | $5,121.60 | $0.00 | $54.26 | $56.00 | $952.00 | $849.00 | $0.00 | $17,169.00 | $3,184.44 | $7,477.68 | $5,357.42 | $94,647.73 | $49.30 | |||
| FT | Ex. GFEBS Clerk | SCA - General Clerk | GFEBS Clerk | 2080 | 80 | 80 | 0 | 1920 | $21.33 | $1,706.40 | $1,706.40 | $6,432.00 | $3,886.08 | $56.00 | $952.00 | $849.00 | $0.00 | $15,343.38 | $2,280.03 | $5,353.94 | $3,835.86 | $67,766.80 | $35.30 |
CLIN 0001 LABOR - Overarching BASOPS - Program Management
CLIN 0002 LABOR - Annex P - Facilities Engineering Services Management OWO
CLIN 0005 LABOR - Annex E- Solid Waste Management PMO and OWO
CLIN 0006 - LABOR - Annex F - Maintenance - Grounds PMO and OWO
CLIN 0007 LABOR - Annex G - Snow, Ice and Sand Removal PMO and OWO
| CLIN 0008 LABOR - Annex H - Facilities Maintenance |
| CLIN 0011 LABOR - Annex Q -Facilities Maintenance - Medical/Hospital |
| CLIN 0012 LABOR - Annex J - Maintenance - Surfaced and Unsurfaced Areas |
| CLIN 0014 LABOR - Annex K -Heating/Cooling Services |
| CLIN 0015 LABOR - Annex R -Water Services |
| CLIN 0016 LABOR - Annex L - Waste Water Services |
| CLIN 0017 LABOR - Annex S - Other Utility Services |
| CLIN 0018 LABOR - Annex T -Environmental Services |
| CLIN 0019 LABOR - Annex M - Pest Management |
| CLIN 0020 LABOR - PWO-Non Recurring IJOs |
7. Option Period 3
| Fringe and Direct Labor Calculations | |
| Option Period 3 | 2080 Hours |
| EXAMPLE: | ||||||||||||||||||||||||||
| Base | Rate | Escal. | Holiday | VACATION | SICK | H&W | FICA | FUTA | SUTA | WORK | OTHER | Total | OH | G&A | Fee | Total Annual Price | Fully Burdened | |||||||||
| FT/PT | Labor Category | Exmpet, SCA Labor Category, CBA Labor Category, DBA Labor Category | Title/Description | Total H&W Hours | Vac. | Hol. | Sick | Man Hours | Pay | Diff | 0.00% | 3.35 | 7.65% | 7000*0.8% | COMP | FRINGE | Fringe | 4.05% | 9.14% | 6% | Cost | Hourly Rate | ||||
| FT | Ex. Program Manger | Exempt | Site Manager | 2080 | 160 | 80 | 0.0 | 1920 | $32.01 | $2,560.80 | $5,121.60 | $0.00 | $54.26 | $56.00 | $952.00 | $849.00 | $0.00 | $17,169.00 | $3,184.44 | $7,477.68 | $5,357.42 | $94,647.73 | $49.30 | |||
| FT | Ex. GFEBS Clerk | SCA - General Clerk | GFEBS Clerk | 2080 | 80 | 80 | 0 | 1920 | $21.33 | $1,706.40 | $1,706.40 | $6,432.00 | $3,886.08 | $56.00 | $952.00 | $849.00 | $0.00 | $15,343.38 | $2,280.03 | $5,353.94 | $3,835.86 | $67,766.80 | $35.30 |
CLIN 0001 LABOR - Overarching BASOPS - Program Management
CLIN 0002 LABOR - Annex P - Facilities Engineering Services Management OWO
CLIN 0005 LABOR - Annex E- Solid Waste Management PMO and OWO
CLIN 0006 - LABOR - Annex F - Maintenance - Grounds PMO and OWO
CLIN 0007 LABOR - Annex G - Snow, Ice and Sand Removal PMO and OWO
| CLIN 0008 LABOR - Annex H - Facilities Maintenance |
| CLIN 0011 LABOR - Annex Q -Facilities Maintenance - Medical/Hospital |
| CLIN 0012 LABOR - Annex J - Maintenance - Surfaced and Unsurfaced Areas |
| CLIN 0014 LABOR - Annex K -Heating/Cooling Services |
| CLIN 0015 LABOR - Annex R -Water Services |
| CLIN 0016 LABOR - Annex L - Waste Water Services |
| CLIN 0017 LABOR - Annex S - Other Utility Services |
| CLIN 0018 LABOR - Annex T -Environmental Services |
| CLIN 0019 LABOR - Annex M - Pest Management |
| CLIN 0020 LABOR - PWO-Non Recurring IJOs |
8. Option Period 4
| Fringe and Direct Labor Calculations | |
| Option Period 4 | 2080 Hours |
| EXAMPLE: | ||||||||||||||||||||||||||
| Base | Rate | Escal. | Holiday | VACATION | SICK | H&W | FICA | FUTA | SUTA | WORK | OTHER | Total | OH | G&A | Fee | Total Annual Price | Fully Burdened | |||||||||
| FT/PT | Labor Category | Exmpet, SCA Labor Category, CBA Labor Category, DBA Labor Category | Title/Description | Total H&W Hours | Vac. | Hol. | Sick | Man Hours | Pay | Diff | 0.00% | 3.35 | 7.65% | 7000*0.8% | COMP | FRINGE | Fringe | 4.05% | 9.14% | 6% | Cost | Hourly Rate | ||||
| FT | Ex. Program Manger | Exempt | Site Manager | 2080 | 160 | 80 | 0.0 | 1920 | $32.01 | $2,560.80 | $5,121.60 | $0.00 | $54.26 | $56.00 | $952.00 | $849.00 | $0.00 | $17,169.00 | $3,184.44 | $7,477.68 | $5,357.42 | $94,647.73 | $49.30 | |||
| FT | Ex. GFEBS Clerk | SCA - General Clerk | GFEBS Clerk | 2080 | 80 | 80 | 0 | 1920 | $21.33 | $1,706.40 | $1,706.40 | $6,432.00 | $3,886.08 | $56.00 | $952.00 | $849.00 | $0.00 | $15,343.38 | $2,280.03 | $5,353.94 | $3,835.86 | $67,766.80 | $35.30 |
CLIN 0001 LABOR - Overarching BASOPS - Program Management
CLIN 0002 LABOR - Annex P - Facilities Engineering Services Management OWO
CLIN 0005 LABOR - Annex E- Solid Waste Management PMO and OWO
CLIN 0006 - LABOR - Annex F - Maintenance - Grounds PMO and OWO
CLIN 0007 LABOR - Annex G - Snow, Ice and Sand Removal PMO and OWO
| CLIN 0008 LABOR - Annex H - Facilities Maintenance |
| CLIN 0011 LABOR - Annex Q -Facilities Maintenance - Medical/Hospital |
| CLIN 0012 LABOR - Annex J - Maintenance - Surfaced and Unsurfaced Areas |
| CLIN 0014 LABOR - Annex K -Heating/Cooling Services |
| CLIN 0015 LABOR - Annex R -Water Services |
| CLIN 0016 LABOR - Annex L - Waste Water Services |
| CLIN 0017 LABOR - Annex S - Other Utility Services |
| CLIN 0018 LABOR - Annex T -Environmental Services |
| CLIN 0019 LABOR - Annex M - Pest Management |
| CLIN 0020 LABOR - PWO-Non Recurring IJOs |
9. Teaming Information Subcontractor - XYZ Company CAGE - A12345 DUNS - 00099988 Size Standard - Small Performance Cost - $40,000 Percentage Cost - 30% Labor Category PWS Performance Area Exempt/ Non-Exempt Wage Determination Location (if applicable) Hourly Rate Fully Burdened Rate Opt Yr 1 Hourly Rate Opt Yr 1 Fully Burdened Rate Opt Yr 2 Hourly Rate Opt Yr 2 Fully Burdened Rate Opt Yr 3 Hourly Rate Opt Yr 3 Fully Burdened Rate Opt Yr 4 Hourly Rate Opt Yr 4 Fully Burdened Rate
Subcontractor - ACME LLC CAGE - X01234 DUNS - 11122233 Size Standard - Large Performance Cost - $20,000 Percentage Cost - 10% Labor Category PWS Performance Area Exempt/ Non-Exempt Wage Determination Location Hourly Rate Fully Burdened Rate Opt Yr 1 Hourly Rate Opt Yr 1 Fully Burdened Rate Opt Yr 2 Hourly Rate Opt Yr 2 Fully Burdened Rate Opt Yr 3 Hourly Rate Opt Yr 3 Fully Burdened Rate Opt Yr 4 Hourly Rate Opt Yr 4 Fully Burdened Rate
Subcontractor - ABC Company CAGE - B54321 DUNS - 99900055 Size Standard - Small Performance Cost - $15,000 Percentage Cost - 5% Labor Category PWS Performance Area Exempt/ Non-Exempt Wage Determination Location Hourly Rate Fully Burdened Rate Opt Yr 1 Hourly Rate Opt Yr 1 Fully Burdened Rate Opt Yr 2 Hourly Rate Opt Yr 2 Fully Burdened Rate Opt Yr 3 Hourly Rate Opt Yr 3 Fully Burdened Rate Opt Yr 1 Hourly Rate Opt Yr 3 Fully Burdened Rate
| Additional Notes: Proposals containing subcontractors shall adhere to the provisions of FAR Clause 52.219-14, Limitations on Subcontracting. |
| If the rates are the same for each contract period, provide one schedule and state that the schedule applies to all contract periods. If the rates are different for each contract period, unhide columns H through O for each contract period. |
10.ExemptLabor Cat Descriptions
LABOR CATEGORY DESCRIPTION
File details come from the government source that posted it. Updated .