CWO_AREA_PRICE MODEL_21-R-00052_20210719.xlsx

XLSX spreadsheet 199 KB Posted Jul 21, 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 requests proposals for contract weather observation services. The Federal Aviation Administration seeks to award eleven contracts to provide augmentation and backup support to Automated Surface Observing Systems as well as manual weather observations as needed at selected airports throughout the United States. Proposals are due by the date specified in any amendments to the solicitation. The estimated contract value is $8,952,000 per year. This competitive set-aside opportunity is for small businesses only with a North American Industry Classification System code of 541990 and size standard of $16.5 million. Questions regarding the solicitation must be submitted to the contracting officer by close of business 12 calendar days following release. Proposals should be emailed to the point of contact provided.

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
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
CWO_AREA_PRICE MODEL_21-R-00052_20210617.xlsx	XLSX spreadsheet	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 21, 22, 45, 46, 69, 70, 93, 94, 117, and 118, 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 35, 64, 93, 122, and 151 with the additional fringe amount over the H&W amount. The total fringe benefit 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 Five
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 Five

BASE YEAR

CLIN

5001

5002

5003

5004

5005

5006

5007

5008

5009

5010

5011

5012

5013

5014

ERROR:#N/A

DLH

DSM

FSD

GFK

ICT

MCI

MDW

MKE

MSN

MSP

OMA

ORD

RFD

STL

ERROR:#N/A

Element of Cost

Site

Duluth Int’l Arpt

Des Moines Int’l Arpt

Joe Foss Field

Grand Forks International Airport

Wichita Mid-Continent Arpt.

Kansas City Int’l Arpt

Chicago Midway

Milwaukee Arpt.

Dane Co. Regional-Truax Field

Minneapolis – St. Paul Int’l

Eppley Airfield

Chicago O’Hare Int’l

Greater Rockford Arpt.

Lambert-St. Louis Int’l Arpt.

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 ERROR:#N/A ERROR:#N/A ERROR:#N/A 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 ERROR:#N/A ERROR:#N/A ERROR:#N/A 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 ERROR:#N/A ERROR:#N/A ERROR:#N/A 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 ERROR:#N/A ERROR:#N/A ERROR:#N/A 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 ERROR:#N/A ERROR:#N/A ERROR:#N/A 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 ERROR:#N/A ERROR:#N/A ERROR:#N/A 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 ERROR:#N/A ERROR:#N/A ERROR:#N/A 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 Five $0.00

Option Year 1 Pricing