Rev.2 Attachment 1_Price Schedule Workbook (Supplement to the SF 1442).xlsx
XLSX spreadsheet 33 KB Posted
- Solicitation number
- 47PL0122R0050
About this file
This document provides details for a federal solicitation seeking job order construction services in Alaska. The General Services Administration Region 10 is soliciting proposals for indefinite delivery indefinite quantity construction contracts in three zones covering interior, south central, and southeast Alaska. Offerors may propose on one or more zones. The contracts will have a one year base period and two five-year option periods, with a maximum value of $4 million per zone per year. Task orders will range from $10,000 to $150,000 and will include new construction, repairs, and alterations of federal buildings. Proposals are due December 22nd and awards will be made on or around February 25th. Offerors must be registered in SAM and follow Buy American Act requirements. Projects will involve controlled unclassified information and require homeland security clearances.
View the file
Other files
Show all 36
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
Instructions
| Instructions for Users | ||
| Reference Area / Item | Instructions | Example |
| Overall | Reference The Solicitation document section II.C Evaluation Factors, Factor 5 Price for coefficient factors and multiplier application | |
| Overall | Users are instructed to complete the price schedule Workbook in its entirety. | |
| Overall | Enter two decimal place markup percent for all cells | 10% markup equals 0.10, 2% equals 0.02, 5% deduction equals -0.05 |
| Overall | Coefficient Multiplier used as overall markup multiplier to direct costs from Express Menu and RS Means Facilities Cost of Construction (FCC) line items. | Reference The Solicitation document section II.C Evaluation Factors, Factor 5 Price Item h) Coefficent Definitions and Example. |
| Coefficient Summary Tab | Values calculated to respective tabs for based year and options. USER RESPONSIBLE FOR CONFIRMING ACCURACY OF CALCULATIONS. | |
| National Average Adjustment | Values based on percentage mark up or down from national average values in RS Means FCC. | Adjustments equal to national average insert 0.00, Values less than national average insert negative decimal (e.g. - 0.02), values great than national average insert positive decimal (e.g. 0.02) |
| Base and Option Year Tabs | "Division 1 Breakouts for Prime Contractor" line is for header of following sub items. No markup need to grey cells in line. | |
| Base and Option Year Tabs | "Total Coefficient" line calculation based on a 100% markup (1.00) with totals from cells above adding or deducting to that value. USER RESPONSIBLE FOR CONFIRMING ACCURACY OF CALCULATIONS. |
Instructions: Offerors are to complete the price schedule for each applicable zone. Offerors submitting a price proposal for multiple zones are required to complete the price schedule for each zone.
Coefficient Summary Tab
| Description | Total Coefficient Multiplier | ||||
| Zone 1 (Interior Alaska (AK)) | Base Year | OPY 1 | OPY 2 | OPY 3 | OPY 4 |
| Fairbanks, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Tok, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| ALCAN Land Port of Entry (LPOE), AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Kotzebue, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Nome, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Total Zone 1 (average) | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Zone 2 (South Central Alaska (AK)) | Base Year | OPY 1 | OPY 2 | OPY 3 | OPY 4 |
| Anchorage, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Palmer, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Wasilla, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Seward, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Soldotna, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Homer, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Total Zone 2 (average) | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Zone 3 (Southeast Alaska (AK)) | Base Year | OPY 1 | OPY 2 | OPY 3 | OPY 4 |
| Juneau, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Ketchikan, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Haines LPOE, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Skagway, AK | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Total Zone 3 (average) | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
Base Year Coefficent Breakdown
| Line Item Description | Zone 1 | Totals (average) | |||||
| Location | Fairbanks, AK | Tok, AK | ALCAN LPOE | Kotzebue, AK | Nome, AK | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | ERROR:#DIV/0! | |||||
| Materials & Equipment | - | ERROR:#DIV/0! | |||||
| Mobilization / Demobilization | - | ERROR:#DIV/0! | |||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | ERROR:#DIV/0! | |||||
| Transportation of materials, equipment, crew. | - | ERROR:#DIV/0! | |||||
| Labor Adjustment | - | ERROR:#DIV/0! | |||||
| General Conditions Overhead | - | ERROR:#DIV/0! | |||||
| General Conditions Profit | - | ERROR:#DIV/0! | |||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | ERROR:#DIV/0! | |||||
| Payment & Performance Bonds | - | ERROR:#DIV/0! | |||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | - | 1.00 |
| Line Item Description | Zone 2 | Totals (average) | |||||
| Location | Anchorage, AK | Palmer, AK | Wasilla, AK | Seward, AK | Soldotna, AK | Homer, AK | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | ERROR:#DIV/0! | ||||||
| Materials & Equipment | ERROR:#DIV/0! | ||||||
| Mobilization / Demobilization | ERROR:#DIV/0! | ||||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | ERROR:#DIV/0! | ||||||
| Transportation of materials, equipment, crew. | ERROR:#DIV/0! | ||||||
| Labor Adjustment | ERROR:#DIV/0! | ||||||
| General Conditions Overhead | ERROR:#DIV/0! | ||||||
| General Conditions Profit | ERROR:#DIV/0! | ||||||
| FICA, FUTA, SUTA costs for prime contractor employees | ERROR:#DIV/0! | ||||||
| Payment & Performance Bonds | ERROR:#DIV/0! | ||||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Line Item Description | Zone 3 | Totals (average) | |||||
| Location | Juneau, AK | Ketchikan, AK | Haines LPOE | Skagway LPOE | - | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | - | ERROR:#DIV/0! | ||||
| Materials & Equipment | - | - | ERROR:#DIV/0! | ||||
| Mobilization / Demobilization | - | - | ERROR:#DIV/0! | ||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | - | ERROR:#DIV/0! | ||||
| Transportation of materials, equipment, crew. | - | - | ERROR:#DIV/0! | ||||
| Labor Adjustment | - | - | ERROR:#DIV/0! | ||||
| General Conditions Overhead | - | - | ERROR:#DIV/0! | ||||
| General Conditions Profit | - | - | ERROR:#DIV/0! | ||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | - | ERROR:#DIV/0! | ||||
| Payment & Performance Bonds | - | - | ERROR:#DIV/0! | ||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | - | - | 1.00 |
Option Year 1 Coefficent Breakd
| Line Item Description | Zone 1 | Totals (average) | |||||
| Location | Fairbanks, AK | Tok, AK | ALCAN LPOE | Kotzebue, AK | Nome, AK | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | ERROR:#DIV/0! | |||||
| Materials & Equipment | - | ERROR:#DIV/0! | |||||
| Mobilization / Demobilization | - | ERROR:#DIV/0! | |||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | ERROR:#DIV/0! | |||||
| Transportation of materials, equipment, crew. | - | ERROR:#DIV/0! | |||||
| Labor Adjustment | - | ERROR:#DIV/0! | |||||
| General Conditions Overhead | - | ERROR:#DIV/0! | |||||
| General Conditions Profit | - | ERROR:#DIV/0! | |||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | ERROR:#DIV/0! | |||||
| Payment & Performance Bonds | - | ERROR:#DIV/0! | |||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | - | 1.00 |
| Line Item Description | Zone 2 | Totals (average) | |||||
| Location | Anchorage, AK | Palmer, AK | Wasilla, AK | Seward, AK | Soldotna, AK | Homer, AK | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | ERROR:#DIV/0! | ||||||
| Materials & Equipment | ERROR:#DIV/0! | ||||||
| Mobilization / Demobilization | ERROR:#DIV/0! | ||||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | ERROR:#DIV/0! | ||||||
| Transportation of materials, equipment, crew. | ERROR:#DIV/0! | ||||||
| Labor Adjustment | ERROR:#DIV/0! | ||||||
| General Conditions Overhead | ERROR:#DIV/0! | ||||||
| General Conditions Profit | ERROR:#DIV/0! | ||||||
| FICA, FUTA, SUTA costs for prime contractor employees | ERROR:#DIV/0! | ||||||
| Payment & Performance Bonds | ERROR:#DIV/0! | ||||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Line Item Description | Zone 3 | Totals (average) | |||||
| Location | Juneau, AK | Ketchikan, AK | Haines LPOE | Skagway LPOE | - | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | - | ERROR:#DIV/0! | ||||
| Materials & Equipment | - | - | ERROR:#DIV/0! | ||||
| Mobilization / Demobilization | - | - | ERROR:#DIV/0! | ||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | - | ERROR:#DIV/0! | ||||
| Transportation of materials, equipment, crew. | - | - | ERROR:#DIV/0! | ||||
| Labor Adjustment | - | - | ERROR:#DIV/0! | ||||
| General Conditions Overhead | - | - | ERROR:#DIV/0! | ||||
| General Conditions Profit | - | - | ERROR:#DIV/0! | ||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | - | ERROR:#DIV/0! | ||||
| Payment & Performance Bonds | - | - | ERROR:#DIV/0! | ||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | - | - | 1.00 |
Option Year 2 Coefficent Breakd
| Line Item Description | Zone 1 | Totals (average) | |||||
| Location | Fairbanks, AK | Tok, AK | ALCAN LPOE | Kotzebue, AK | Nome, AK | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | ERROR:#DIV/0! | |||||
| Materials & Equipment | - | ERROR:#DIV/0! | |||||
| Mobilization / Demobilization | - | ERROR:#DIV/0! | |||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | ERROR:#DIV/0! | |||||
| Transportation of materials, equipment, crew. | - | ERROR:#DIV/0! | |||||
| Labor Adjustment | - | ERROR:#DIV/0! | |||||
| General Conditions Overhead | - | ERROR:#DIV/0! | |||||
| General Conditions Profit | - | ERROR:#DIV/0! | |||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | ERROR:#DIV/0! | |||||
| Payment & Performance Bonds | - | ERROR:#DIV/0! | |||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | - | 1.00 |
| Line Item Description | Zone 2 | Totals (average) | |||||
| Location | Anchorage, AK | Palmer, AK | Wasilla, AK | Seward, AK | Soldotna, AK | Homer, AK | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | ERROR:#DIV/0! | ||||||
| Materials & Equipment | ERROR:#DIV/0! | ||||||
| Mobilization / Demobilization | ERROR:#DIV/0! | ||||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | ERROR:#DIV/0! | ||||||
| Transportation of materials, equipment, crew. | ERROR:#DIV/0! | ||||||
| Labor Adjustment | ERROR:#DIV/0! | ||||||
| General Conditions Overhead | ERROR:#DIV/0! | ||||||
| General Conditions Profit | ERROR:#DIV/0! | ||||||
| FICA, FUTA, SUTA costs for prime contractor employees | ERROR:#DIV/0! | ||||||
| Payment & Performance Bonds | ERROR:#DIV/0! | ||||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Line Item Description | Zone 3 | Totals (average) | |||||
| Location | Juneau, AK | Ketchikan, AK | Haines LPOE | Skagway LPOE | - | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | - | ERROR:#DIV/0! | ||||
| Materials & Equipment | - | - | ERROR:#DIV/0! | ||||
| Mobilization / Demobilization | - | - | ERROR:#DIV/0! | ||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | - | ERROR:#DIV/0! | ||||
| Transportation of materials, equipment, crew. | - | - | ERROR:#DIV/0! | ||||
| Labor Adjustment | - | - | ERROR:#DIV/0! | ||||
| General Conditions Overhead | - | - | ERROR:#DIV/0! | ||||
| General Conditions Profit | - | - | ERROR:#DIV/0! | ||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | - | ERROR:#DIV/0! | ||||
| Payment & Performance Bonds | - | - | ERROR:#DIV/0! | ||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | - | - | 1.00 |
Option Year 3 Coefficent Breakd
| Line Item Description | Zone 1 | Totals (average) | |||||
| Location | Fairbanks, AK | Tok, AK | ALCAN LPOE | Kotzebue, AK | Nome, AK | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | ERROR:#DIV/0! | |||||
| Materials & Equipment | - | ERROR:#DIV/0! | |||||
| Mobilization / Demobilization | - | ERROR:#DIV/0! | |||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | ERROR:#DIV/0! | |||||
| Transportation of materials, equipment, crew. | - | ERROR:#DIV/0! | |||||
| Labor Adjustment | - | ERROR:#DIV/0! | |||||
| General Conditions Overhead | - | ERROR:#DIV/0! | |||||
| General Conditions Profit | - | ERROR:#DIV/0! | |||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | ERROR:#DIV/0! | |||||
| Payment & Performance Bonds | - | ERROR:#DIV/0! | |||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | - | 1.00 |
| Line Item Description | Zone 2 | Totals (average) | |||||
| Location | Anchorage, AK | Palmer, AK | Wasilla, AK | Seward, AK | Soldotna, AK | Homer, AK | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | ERROR:#DIV/0! | ||||||
| Materials & Equipment | ERROR:#DIV/0! | ||||||
| Mobilization / Demobilization | ERROR:#DIV/0! | ||||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | ERROR:#DIV/0! | ||||||
| Transportation of materials, equipment, crew. | ERROR:#DIV/0! | ||||||
| Labor Adjustment | ERROR:#DIV/0! | ||||||
| General Conditions Overhead | ERROR:#DIV/0! | ||||||
| General Conditions Profit | ERROR:#DIV/0! | ||||||
| FICA, FUTA, SUTA costs for prime contractor employees | ERROR:#DIV/0! | ||||||
| Payment & Performance Bonds | ERROR:#DIV/0! | ||||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Line Item Description | Zone 3 | Totals (average) | |||||
| Location | Juneau, AK | Ketchikan, AK | Haines LPOE | Skagway LPOE | - | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | - | ERROR:#DIV/0! | ||||
| Materials & Equipment | - | - | ERROR:#DIV/0! | ||||
| Mobilization / Demobilization | - | - | ERROR:#DIV/0! | ||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | - | ERROR:#DIV/0! | ||||
| Transportation of materials, equipment, crew. | - | - | ERROR:#DIV/0! | ||||
| Labor Adjustment | - | - | ERROR:#DIV/0! | ||||
| General Conditions Overhead | - | - | ERROR:#DIV/0! | ||||
| General Conditions Profit | - | - | ERROR:#DIV/0! | ||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | - | ERROR:#DIV/0! | ||||
| Payment & Performance Bonds | - | - | ERROR:#DIV/0! | ||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | - | - | 1.00 |
Option Year 4 Coefficent Breakd
| Line Item Description | Zone 1 | Totals (average) | |||||
| Location | Fairbanks, AK | Tok, AK | ALCAN LPOE | Kotzebue, AK | Nome, AK | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | ERROR:#DIV/0! | |||||
| Materials & Equipment | - | ERROR:#DIV/0! | |||||
| Mobilization / Demobilization | - | ERROR:#DIV/0! | |||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | ERROR:#DIV/0! | |||||
| Transportation of materials, equipment, crew. | - | ERROR:#DIV/0! | |||||
| Labor Adjustment | - | ERROR:#DIV/0! | |||||
| General Conditions Overhead | - | ERROR:#DIV/0! | |||||
| General Conditions Profit | - | ERROR:#DIV/0! | |||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | ERROR:#DIV/0! | |||||
| Payment & Performance Bonds | - | ERROR:#DIV/0! | |||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | - | 1.00 |
| Line Item Description | Zone 2 | Totals (average) | |||||
| Location | Anchorage, AK | Palmer, AK | Wasilla, AK | Seward, AK | Soldotna, AK | Homer, AK | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | ERROR:#DIV/0! | ||||||
| Materials & Equipment | ERROR:#DIV/0! | ||||||
| Mobilization / Demobilization | ERROR:#DIV/0! | ||||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | ERROR:#DIV/0! | ||||||
| Transportation of materials, equipment, crew. | ERROR:#DIV/0! | ||||||
| Labor Adjustment | ERROR:#DIV/0! | ||||||
| General Conditions Overhead | ERROR:#DIV/0! | ||||||
| General Conditions Profit | ERROR:#DIV/0! | ||||||
| FICA, FUTA, SUTA costs for prime contractor employees | ERROR:#DIV/0! | ||||||
| Payment & Performance Bonds | ERROR:#DIV/0! | ||||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Line Item Description | Zone 3 | Totals (average) | |||||
| Location | Juneau, AK | Ketchikan, AK | Haines LPOE | Skagway LPOE | - | - | |
| Division 1 Breakouts for Prime Contractor | |||||||
| Superintendent / Site Labor | - | - | ERROR:#DIV/0! | ||||
| Materials & Equipment | - | - | ERROR:#DIV/0! | ||||
| Mobilization / Demobilization | - | - | ERROR:#DIV/0! | ||||
| Divisions 2-52 National Average Adjustment (locality adjustment of total O&P line item) | - | - | ERROR:#DIV/0! | ||||
| Transportation of materials, equipment, crew. | - | - | ERROR:#DIV/0! | ||||
| Labor Adjustment | - | - | ERROR:#DIV/0! | ||||
| General Conditions Overhead | - | - | ERROR:#DIV/0! | ||||
| General Conditions Profit | - | - | ERROR:#DIV/0! | ||||
| FICA, FUTA, SUTA costs for prime contractor employees | - | - | ERROR:#DIV/0! | ||||
| Payment & Performance Bonds | - | - | ERROR:#DIV/0! | ||||
| Total Coefficient Multiplier | 1.00 | 1.00 | 1.00 | 1.00 | - | - | 1.00 |
File details come from the government source that posted it. Updated .