CWO_AREA_PRICE MODEL_21-R-00052_20210617.xlsx

XLSX spreadsheet 205 KB Posted Jul 9, 2021

Attached to: CONTRACT WEATHER OBSERVATION (CWO) SERVICES
Solicitation number: 6973GH-21-R-00052
Issued by: Department of Transportation Federal Aviation Administration Non-Franchise Acquisition Services

About this file

Written by GovTribe AI · Dec 30, 2023

This solicitation seeks proposals for contract weather observation services at selected airports throughout the United States. The Federal Aviation Administration intends to award eleven indefinite delivery/indefinite quantity contracts to small businesses for these services. Proposals are due by the date specified in the solicitation or any subsequent amendments. The principle North American Industry Classification System code for this effort is 541990. The services required include augmentation and backup for Automated Surface Observing Systems as well as manual observations as necessary. Responses must be submitted electronically to the contracting officer by the specified due date and include the solicitation number and company name in the email subject line. Questions are to be submitted to the contracting officer by close of business 12 calendar days after solicitation release. Award will be made to up to two groups per business.

View the file

Other files

File	Type	Posted
6973GH-21-R-00052-0008.pdf	PDF	Mar 28, 2022
6973GH-21-R-00052-0007.pdf	PDF	Jul 22, 2021
CWO_AREA_PRICE MODEL_21-R-00052_20210719.xlsx	XLSX spreadsheet	Jul 21, 2021
6973GH-21-R-00052-0006.pdf	PDF	Jul 21, 2021
CWO_AREA 11_PRICE MODEL_21-R-00052_20210720.xlsx	XLSX spreadsheet	Jul 21, 2021
TAL Pension Surcharge20210720_11524276.pdf	PDF	Jul 21, 2021
CWO Section C_20210715.docx	DOCX document	Jul 15, 2021
Questions and Answers 6973GH-21-R-00052-0004 -20210715.docx	DOCX document	Jul 15, 2021
6973GH-21-R-00052-0005.pdf	PDF	Jul 15, 2021
CMHsignedCBA.pdf	PDF	Jul 9, 2021
Questions and Answers 6973GH-21-R-00052-0004 -20210709.docx	DOCX document	Jul 9, 2021
6973GH-21-R-00052-0004.pdf	PDF	Jul 9, 2021
6973GH-21-R-00052-0003.pdf	PDF	Jun 10, 2021
CBA_Amendment 0003_ZipFile1.zip	ZIP file	Jun 10, 2021
Section J v28_20210602.docx	DOCX document	Jun 10, 2021
6973GH-21-R-00052-0003.pdf	PDF	Jun 10, 2021
CBA_Amendment 0003_ZipFile2.zip	ZIP file	Jun 10, 2021
CWO_AREA_PRICE MODEL_21-R-00052_20210602.xlsx	XLSX spreadsheet	Jun 10, 2021
6973GH-21-R-00052-0002.pdf	PDF	Jun 1, 2021
Questions and Answers 6973GH-21-R-00052 -20210525.docx	DOCX document	May 26, 2021
6973GH-21-R-00052-0001.pdf	PDF	May 26, 2021
CWO Section C_20210525.docx	DOCX document	May 26, 2021
Section J v27_20210525.docx	DOCX document	May 26, 2021
CWO_AREA_PRICE MODEL_21-R-00052_20210525.xlsx	XLSX spreadsheet	May 26, 2021
CWO_AREA_PRICE MODEL_6973GH-21-R-00052_20210504.xlsx	XLSX spreadsheet	May 4, 2021
J-16_CWO CBAs FILE 2-20210222.zip	ZIP file	May 4, 2021
J-15_CWO CBAs FILE 1-20210222.zip	ZIP file	May 4, 2021
Section J_6973GH-21-R-00052.docx	DOCX document	May 4, 2021
6973GH-21-R-00052.pdf	PDF	May 4, 2021

Show all 29

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Instructions for Completion of Price Bid Model

Note: The spreadsheets each contain the base year and the four option years. You must move down and ensure that you populate each of the five years for each area you choose to bid on. You are able to check that each option has been completed by checking the amounts on the Summary tab.

You must save each area by name (Area 1, Area 2, etc.) that you are bidding on. There should be one spreadsheet submitted for each area proposed. You MUST save each area as you complete it by its name BEFORE moving on to a new area.

There are five spreadsheets in the model:

1.) Summary - this spreadsheet provides the monthly, annual, and five-year total price for the selected area. There are no required Offeror inputs, as the prices are calculated on the other sheets and transfer to the summary sheet.

2.) Table A - on the sheet named 'Table A', the Offeror must select the appropriate area it is choosing to bid on in cell B8, using the drop-down box. This selection will populate the columns with the appropriate airport locations. The only required inputs on Table A are:

a.) applicable overhead rate;

b.) applicable G&A rate;

c.) subcontractor costs, if applicable; and

d.) the G&A rate applicable to the subcontractor costs.

3.) Table B - this sheet is populated for rates for each airport in the group, including Night and Sunday differentials. The Offeror needs to populate the hours it is bidding for each location. The Offeror should not change the populated hourly rates. The Offeror needs only to populate Rows 20, 21, 43, 44, 66, 67, 89, 90, 112, and 113, if it chooses to pay an hourly rate higher than the Wage Determination (WD) or Collective Bargaining Agreement (CBA) rates. Note: There is no requirement to pay above the WD or CBA rates. The total direct labor amount will transfer to the appropriate airport location on Table A.

4.) Table C - this spreadsheet captures the fringe costs. The required Health and Welfare (H&W) benefit is already populated. The Offeror must populate Rows 16, 31, 46, 61, and 76 with the additional fringe amount over the H&W amount. These amounts will be multiplied by the number of hours for each location. This total amount will transfer to the appropriate airport location on Table A.

5.) Table D - the Offeror must populate any required other direct costs (ODC). Although there are examples already in the table, these are not necessarily required. The Offeror must determine the ODCs it considers necessary to fulfill the requirements of the Statement of Work and provide its price in total for the specific ODC. All ODCs will total and transfer to Table A.

Summary

PART 1 - THE SCHEDULE

SECTION B - SUPPLIES OR SERVICES AND PRICES/COSTS

Area Four
Year	Monthly	Annual

Base	$ - 0	$ - 0
Option 1	$ - 0	$ - 0
Option 2	$ - 0	$ - 0
Option 3	$ - 0	$ - 0
Option 4	$ - 0	$ - 0

TOTAL CONTRACT VALUE $ - 0

Table A

INSTRUCTIONS:
The Offeror may not alter the pricing model format.		Notes:	1) The offeror or subcontractor may not modify the format
Enter your proposal data in the blue highlighed cells on each sheet			2) The total cost should be the sum of: a) offeror's labor-related costs, b) subcontract costs, c) other direct
			costs, and d) G&A (or other indirect costs) applicable to the subcontracts and other direct costs.
			3) The offeror should include all estimated costs. The FAA will pay the contractor the prices in Section B
TABLE A			of the contract but will not reimburse the contractor for any additional incurred costs. Any adjustment to
Price Summary by Site and Year			the prices in section B will result from wage determinations or collective bargaining agreements.
Group #	Area Four

BASE YEAR

CLIN

4001

4002

4003

4004

4005

4006

4007

4008

4009

4010

4011

4012

4013

4014

4015

4016

4017

ERROR:#N/A

ABQ

AFW

AUS

CRP

DAL

DFW

ELP

HOU

IAH

LBB

MOB

MSY

OKC

PHX

SAT

SHV

TUL

ERROR:#N/A

Element of Cost

Site

Albuquerque Int’l Sunport Arpt

Fort Worth Alliance Arpt.

Robert Mueller Municipal Arpt.

Corpus Christi Int’l Arpt.

Dallas Love Field

Dallas/Fort Worth Int’l Arpt.

El Paso Int’l

William P. Hobby Arpt.

George Bush Intercontinental

Lubbock Int’l Arpt.

Mobile Regional Arpt.

Louis Armstrong New Orleans Int’l

Will Rogers World

Phoenix Sky Harbor Int’l Arpt.

San Antonio Int’l

Shreveport Regional Arpt.

Tulsa Int’l

ERROR:#N/A

Direct Labor (Table B) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#N/A

Fringe Benefits (Table C) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#N/A

Overhead % 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#N/A

Applicable G&A % 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#N/A

Offeror's Total Labor-Related Costs $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#N/A

Subcontract #1 [Name of Subcontractor] $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Subcontract #2 [Name of Subcontractor] $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Other Direct Costs (Table D) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

G&A Applicable to Subcontracts	0.00%	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
and Other Direct Costs

Total Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#N/A

Profit % 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#N/A

Total Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

BASE YEAR TOTAL Area Four $0.00

Option Year 1 Pricing