CWO_AREA_PRICE MODEL_21-R-00052_20210602.xlsx

XLSX spreadsheet 216 KB Posted Jun 10, 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 at selected airports across the United States. Offerors must propose to provide weather observer personnel in accordance with the statement of work. Proposals are set aside for small businesses with a size standard of $16.5 million. Responses must be received by the due date of June 2, 2021. Questions are due by May 21, 2021 and must be submitted to the contracting officer via email.

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
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
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 hours and rates for each airport in the group, including Night and Sunday differentials. 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 Six
Year	Monthly	Annual

Base	$ 379,795.04	$ 4,557,540.49
Option 1	$ 379,795.04	$ 4,557,540.49
Option 2	$ 379,795.04	$ 4,557,540.49
Option 3	$ 379,795.04	$ 4,557,540.49
Option 4	$ 379,795.04	$ 4,557,540.49

TOTAL CONTRACT VALUE $ 22,787,702.45

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 Six

BASE YEAR

CLIN

6001

6002

6003

6004

6005

6006

6007

6008

6009

6010

6011

6012

6013

6014

6015

6016

6017

6018

BUF

CAK

CLE

CMH

CRW

CVG

DAY

DTW

FWA

GRR

IND

MKG

PIT

PTK

ROC

SDF

TVC

YNG

Element of Cost

Site

Buffalo-Niagara Int’l. Arpt.

Akron-Washington County

Cleveland-Hopkins Int’l. Arpt.

Port Columbus Int’l

Yeager

Cincinnati/Northern Kentucky Int’l

James M. Cox Dayton International Airport

Detroit Metropolitan Wayne County

Fort Wayne Int’l

Gerald R. Ford Int'l Arpt.

Indianapolis Int’l

Muskegon County

Pittsburgh Int’l

Oakland County Int'l, Pontiac

Greater Rochester Int’l

Louisville Intl. Standiford Field

Cherry Capital Arpt

ERROR:#N/A

Direct Labor (Table B) $325,657.44 $296,280.20 $294,324.02 $281,426.80 $311,102.80 $278,536.40 $235,318.00 $259,892.40 $235,788.58 $179,700.85 $257,884.08 $166,618.70 $391,392.12 $232,414.29 $351,320.84 $315,214.00 $144,668.97 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 $325,657.44 $296,280.20 $294,324.02 $281,426.80 $311,102.80 $278,536.40 $235,318.00 $259,892.40 $235,788.58 $179,700.85 $257,884.08 $166,618.70 $391,392.12 $232,414.29 $351,320.84 $315,214.00 $144,668.97 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 $325,657.44 $296,280.20 $294,324.02 $281,426.80 $311,102.80 $278,536.40 $235,318.00 $259,892.40 $235,788.58 $179,700.85 $257,884.08 $166,618.70 $391,392.12 $232,414.29 $351,320.84 $315,214.00 $144,668.97 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 $325,657.44 $296,280.20 $294,324.02 $281,426.80 $311,102.80 $278,536.40 $235,318.00 $259,892.40 $235,788.58 $179,700.85 $257,884.08 $166,618.70 $391,392.12 $232,414.29 $351,320.84 $315,214.00 $144,668.97 $0.00

BASE YEAR TOTAL Area Six $4,557,540.49

Option Year 1 Pricing

CLIN

6001

6002

6003

6004

6005

6006

6007

6008

6009

6010

6011

6012

6013

6014

6015

6016

6017

6018

BUF

CAK

CLE

CMH

CRW

CVG

DAY

DTW

FWA

GRR

IND

MKG

PIT

PTK

ROC

SDF

TVC

YNG

Element of Cost

Site

Buffalo-Niagara Int’l. Arpt.

Akron-Washington County

Cleveland-Hopkins Int’l. Arpt.

Port Columbus Int’l

Yeager

Cincinnati/Northern Kentucky Int’l

James M. Cox Dayton International Airport

Detroit Metropolitan Wayne County

Fort Wayne Int’l

Gerald R. Ford Int'l Arpt.

Indianapolis Int’l

Muskegon County

Pittsburgh Int’l

Oakland County Int'l, Pontiac

Greater Rochester Int’l

Louisville Intl. Standiford Field

Cherry Capital Arpt

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

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

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

OPTION 1 TOTAL Area Six $4,557,540.49

Option Year 2 Pricing

CLIN

6001

6002

6003

6004

6005

6006

6007

6008

6009

6010

6011

6012

6013

6014

6015

6016

6017

6018

BUF

CAK

CLE

CMH

CRW

CVG

DAY

DTW

FWA

GRR

IND

MKG

PIT

PTK

ROC

SDF

TVC

YNG

Element of Cost

Site

Buffalo-Niagara Int’l. Arpt.

Akron-Washington County

Cleveland-Hopkins Int’l. Arpt.

Port Columbus Int’l

Yeager

Cincinnati/Northern Kentucky Int’l

James M. Cox Dayton International Airport

Detroit Metropolitan Wayne County

Fort Wayne Int’l

Gerald R. Ford Int'l Arpt.

Indianapolis Int’l

Muskegon County

Pittsburgh Int’l

Oakland County Int'l, Pontiac

Greater Rochester Int’l

Louisville Intl. Standiford Field

Cherry Capital Arpt

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

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

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

OPTION 2 TOTAL Area Six $4,557,540.49

Option Year 3 Pricing

CLIN

6001

6002

6003

6004

6005

6006

6007

6008

6009

6010

6011

6012

6013

6014

6015

6016

6017

6018

BUF

CAK

CLE

CMH

CRW

CVG

DAY

DTW

FWA

GRR

IND

MKG

PIT

PTK

ROC

SDF

TVC

YNG

Element of Cost

Site

Buffalo-Niagara Int’l. Arpt.

Akron-Washington County

Cleveland-Hopkins Int’l. Arpt.

Port Columbus Int’l

Yeager

Cincinnati/Northern Kentucky Int’l

James M. Cox Dayton International Airport

Detroit Metropolitan Wayne County

Fort Wayne Int’l

Gerald R. Ford Int'l Arpt.

Indianapolis Int’l

Muskegon County

Pittsburgh Int’l

Oakland County Int'l, Pontiac

Greater Rochester Int’l

Louisville Intl. Standiford Field

Cherry Capital Arpt

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

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

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

OPTION 3 TOTAL Area Six $4,557,540.49

Option Year 4 Pricing

CLIN

6001

6002

6003

6004

6005

6006

6007

6008

6009

6010

6011

6012

6013

6014

6015

6016

6017

6018

BUF

CAK

CLE

CMH

CRW

CVG

DAY

DTW

FWA

GRR

IND

MKG

PIT

PTK

ROC

SDF

TVC

YNG

Element of Cost

Site

Buffalo-Niagara Int’l. Arpt.

Akron-Washington County

Cleveland-Hopkins Int’l. Arpt.

Port Columbus Int’l

Yeager

Cincinnati/Northern Kentucky Int’l

James M. Cox Dayton International Airport

Detroit Metropolitan Wayne County

Fort Wayne Int’l

Gerald R. Ford Int'l Arpt.

Indianapolis Int’l

Muskegon County

Pittsburgh Int’l

Oakland County Int'l, Pontiac

Greater Rochester Int’l

Louisville Intl. Standiford Field

Cherry Capital Arpt

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

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

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

OPTION 4 TOTAL Area Six $4,557,540.49

Section L, Attachment L-1

Table B - Labor

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 direct labor amounts on Table B should match the direct labor amounts on Table A.
			3) If the offeror proposes to pay a labor rate in excess of the rate requried by the CBA/WD, insert the additional rate per hour in these cells (i.e., if the CBA rate is $20 and the offeror proposes to pay $21, insert the additional $1 here)
			4) The offeror may increase the differential paid by increasing the percentage in cells D25 - D28
TABLE B
Direct Labor (Excludes Applicable Fringe Benefits, Other Indirect Costs, and Profit)
Group	Area Six

BASE YEAR	CLIN		6001			6002			6003			6004			6005			6006			6007			6008			6009			6010			6011			6012			6013			6014			6015			6016
			BUF			CAK			CLE			CMH			CRW			CVG			DAY			DTW			FWA			GRR			IND			MKG			PIT			PTK			ROC			SDF
	SITE	Buffalo-Niagara Int’l. Arpt.			Akron-Washington County			Cleveland-Hopkins Int’l. Arpt.			Port Columbus Int’l			Yeager			Cincinnati/Northern Kentucky Int’l			James M. Cox Dayton International Airport			Detroit Metropolitan Wayne County			Fort Wayne Int’l			Gerald R. Ford Int'l Arpt.			Indianapolis Int’l			Muskegon County			Pittsburgh Int’l			Oakland County Int'l, Pontiac			Greater Rochester Int’l			Louisville Intl. Standiford Field
		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly
		Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost
CBA/WD LABOR RATE
CWO, Excluding Differential		7,052	$32.72	$230,741.44	7,052	$29.60	$208,739.20	7,052	$29.51	$208,104.52	7,052	$28.40	$200,276.80	7,052	$31.40	$221,432.80	7,052	$28.20	$198,866.40	7,052	$24.00	$169,248.00	7,052	$26.20	$184,762.40	7,052	$23.79	$167,767.08	4,857	$24.17	$117,399.73	7,052	$26.04	$183,634.08	4,492	$23.84	$107,095.24	7,052	$39.56	$278,977.12	4,857	$31.35	$152,274.79	7,052	$35.42	$249,781.84	7,052	$32.00	$225,664.00
CWO Senior Excluding Differential		1,900	$37.04	$70,376.00	1,900	$34.39	$65,341.00	1,900	$33.73	$64,087.00	1,900	$31.50	$59,850.00	1,900	$34.80	$66,120.00	1,900	$30.80	$58,520.00	1,900	$25.30	$48,070.00	1,900	$29.20	$55,480.00	1,900	$26.41	$50,179.00	1,900	$26.87	$51,053.00	1,900	$28.80	$54,720.00	1,900	$26.11	$49,609.00	1,900	$43.55	$82,745.00	1,900	$34.50	$65,550.00	1,900	$39.46	$74,974.00	1,900	$34.50	$65,550.00

ADDITIONAL LABOR RATE (note 3)
CWO, Excluding Differential	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	4,492	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	3,635
CWO Senior Excluding Differential	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900

Total Direct Labor, Excluding Differential $301,117.44 $274,080.20 $272,191.52 $260,126.80 $287,552.80 $257,386.40 $217,318.00 $240,242.40 $217,946.08 $168,452.73 $238,354.08 $156,704.24 $361,722.12 $217,824.79 $324,755.84 $291,214.00 $136,852.48 ERROR:#N/A ERROR:#REF!

CWO Night Differential	10%	4,380	$3.27	$14,331.36	4,380	$2.96	$12,964.80	4,380	$2.95	$12,925.38	4,380	$2.84	$12,439.20	4,380	$3.14	$13,753.20	4,380	$2.82	$12,351.60	4,380	$2.40	$10,512.00	4,380	$2.62	$11,475.60	4,380	$2.38	$10,420.02	2,281	$2.42	$5,513.78	4,380	$2.60	$11,405.52	1,916	$2.38	$4,568.34	4,380	$3.96	$17,327.28	2,281	$3.14	$7,151.72	4,380	$3.54	$15,513.96	4,380	$3.20	$14,016.00
CWO Sunday Differential	25%	1,248	$8.18	$10,208.64	1,248	$7.40	$9,235.20	1,248	$7.38	$9,207.12	1,248	$7.10	$8,860.80	1,248	$7.85	$9,796.80	1,248	$7.05	$8,798.40	1,248	$6.00	$7,488.00	1,248	$6.55	$8,174.40	1,248	$5.95	$7,422.48	949	$6.04	$5,734.33	1,248	$6.51	$8,124.48	897	$5.96	$5,346.12	1,248	$9.89	$12,342.72	949	$7.84	$7,437.79	1,248	$8.86	$11,051.04	1,248	$8.00	$9,984.00
CWO Senior Night Differential	10%	- 0	$3.70	$0.00	- 0	$3.44	$0.00	- 0	$3.37	$0.00	- 0	$3.15	$0.00	- 0	$3.48	$0.00	- 0	$3.08	$0.00	- 0	$2.53	$0.00	- 0	$2.92	$0.00	- 0	$2.64	$0.00	- 0	$2.69	$0.00	- 0	$2.88	$0.00	- 0	$2.61	$0.00	- 0	$4.36	$0.00	- 0	$3.45	$0.00	- 0	$3.95	$0.00	- 0	$3.45	$0.00
CWO Senior Sunday Differential	25%	- 0	$9.26	$0.00	- 0	$8.60	$0.00	- 0	$8.43	$0.00	- 0	$7.88	$0.00	- 0	$8.70	$0.00	- 0	$7.70	$0.00	- 0	$6.33	$0.00	- 0	$7.30	$0.00	- 0	$6.60	$0.00	- 0	$6.72	$0.00	- 0	$7.20	$0.00	- 0	$6.53	$0.00	- 0	$10.89	$0.00	- 0	$8.63	$0.00	- 0	$9.87	$0.00	- 0	$8.63	$0.00
Total Differential				$24,540.00			$22,200.00			$22,132.50			$21,300.00			$23,550.00			$21,150.00			$18,000.00			$19,650.00			$17,842.50			$11,248.11			$19,530.00			$9,914.46			$29,670.00			$14,589.51			$26,565.00			$24,000.00

BASE YEAR DIRECT LABOR				$325,657.44			$296,280.20			$294,324.02			$281,426.80			$311,102.80			$278,536.40			$235,318.00			$259,892.40			$235,788.58			$179,700.85			$257,884.08			$166,618.70			$391,392.12			$232,414.29			$351,320.84			$315,214.00
OPTION YEAR 1	CLIN		6001			6002			6003			6004			6005			6006			6007			6008			6009			6010			6011			6012			6013			6014			6015			6016
			BUF			CAK			CLE			CMH			CRW			CVG			DAY			DTW			FWA			GRR			IND			MKG			PIT			PTK			ROC			SDF
	SITE	Buffalo-Niagara Int’l. Arpt.			Akron-Washington County			Cleveland-Hopkins Int’l. Arpt.			Port Columbus Int’l			Yeager			Cincinnati/Northern Kentucky Int’l			James M. Cox Dayton International Airport			Detroit Metropolitan Wayne County			Fort Wayne Int’l			Gerald R. Ford Int'l Arpt.			Indianapolis Int’l			Muskegon County			Pittsburgh Int’l			Oakland County Int'l, Pontiac			Greater Rochester Int’l			Louisville Intl. Standiford Field
		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly
		Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost
CBA/WD LABOR RATE
CWO, Excluding Differential		7,052	$32.72	$230,741.44	7,052	$29.60	$208,739.20	7,052	$29.51	$208,104.52	7,052	$28.40	$200,276.80	7,052	$31.40	$221,432.80	7,052	$28.20	$198,866.40	7,052	$24.00	$169,248.00	7,052	$26.20	$184,762.40	7,052	$23.79	$167,767.08	4,857	$24.17	$117,399.73	7,052	$26.04	$183,634.08	4,492	$23.84	$107,095.24	7,052	$39.56	$278,977.12	4,857	$31.35	$152,274.79	7,052	$35.42	$249,781.84	7,052	$32.00	$225,664.00
CWO Senior Excluding Differential		1,900	$37.04	$70,376.00	1,900	$34.39	$65,341.00	1,900	$33.73	$64,087.00	1,900	$31.50	$59,850.00	1,900	$34.80	$66,120.00	1,900	$30.80	$58,520.00	1,900	$25.30	$48,070.00	1,900	$29.20	$55,480.00	1,900	$26.41	$50,179.00	1,900	$26.87	$51,053.00	1,900	$28.80	$54,720.00	1,900	$26.11	$49,609.00	1,900	$43.55	$82,745.00	1,900	$34.50	$65,550.00	1,900	$39.46	$74,974.00	1,900	$34.50	$65,550.00

ADDITIONAL LABOR RATE (note 3)
CWO, Excluding Differential	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	4,492	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	3,635
CWO Senior Excluding Differential	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900

CWO Night Differential	10%	4,380	$3.27	$14,331.36	4,380	$2.96	$12,964.80	4,380	$2.95	$12,925.38	4,380	$2.84	$12,439.20	4,380	$3.14	$13,753.20	4,380	$2.82	$12,351.60	4,380	$2.40	$10,512.00	4,380	$2.62	$11,475.60	4,380	$2.38	$10,420.02	2,281	$2.42	$5,513.78	4,380	$2.60	$11,405.52	1,916	$2.38	$4,568.34	4,380	$3.96	$17,327.28	2,281	$3.14	$7,151.72	4,380	$3.54	$15,513.96	4,380	$3.20	$14,016.00
CWO Sunday Differential	25%	1,248	$8.18	$10,208.64	1,248	$7.40	$9,235.20	1,248	$7.38	$9,207.12	1,248	$7.10	$8,860.80	1,248	$7.85	$9,796.80	1,248	$7.05	$8,798.40	1,248	$6.00	$7,488.00	1,248	$6.55	$8,174.40	1,248	$5.95	$7,422.48	949	$6.04	$5,734.33	1,248	$6.51	$8,124.48	897	$5.96	$5,346.12	1,248	$9.89	$12,342.72	949	$7.84	$7,437.79	1,248	$8.86	$11,051.04	1,248	$8.00	$9,984.00
CWO Senior Night Differential	10%	- 0	$3.70	$0.00	- 0	$3.44	$0.00	- 0	$3.37	$0.00	- 0	$3.15	$0.00	- 0	$3.48	$0.00	- 0	$3.08	$0.00	- 0	$2.53	$0.00	- 0	$2.92	$0.00	- 0	$2.64	$0.00	- 0	$2.69	$0.00	- 0	$2.88	$0.00	- 0	$2.61	$0.00	- 0	$4.36	$0.00	- 0	$3.45	$0.00	- 0	$3.95	$0.00	- 0	$3.45	$0.00
CWO Senior Sunday Differential	25%	- 0	$9.26	$0.00	- 0	$8.60	$0.00	- 0	$8.43	$0.00	- 0	$7.88	$0.00	- 0	$8.70	$0.00	- 0	$7.70	$0.00	- 0	$6.33	$0.00	- 0	$7.30	$0.00	- 0	$6.60	$0.00	- 0	$6.72	$0.00	- 0	$7.20	$0.00	- 0	$6.53	$0.00	- 0	$10.89	$0.00	- 0	$8.63	$0.00	- 0	$9.87	$0.00	- 0	$8.63	$0.00
Total Differential				$24,540.00			$22,200.00			$22,132.50			$21,300.00			$23,550.00			$21,150.00			$18,000.00			$19,650.00			$17,842.50			$11,248.11			$19,530.00			$9,914.46			$29,670.00			$14,589.51			$26,565.00			$24,000.00

OPTION YEAR 1 DIRECT LABOR				$325,657.44			$296,280.20			$294,324.02			$281,426.80			$311,102.80			$278,536.40			$235,318.00			$259,892.40			$235,788.58			$179,700.85			$257,884.08			$166,618.70			$391,392.12			$232,414.29			$351,320.84			$315,214.00
OPTION YEAR 2	CLIN		6001			6002			6003			6004			6005			6006			6007			6008			6009			6010			6011			6012			6013			6014			6015			6016
			BUF			CAK			CLE			CMH			CRW			CVG			DAY			DTW			FWA			GRR			IND			MKG			PIT			PTK			ROC			SDF
	SITE	Buffalo-Niagara Int’l. Arpt.			Akron-Washington County			Cleveland-Hopkins Int’l. Arpt.			Port Columbus Int’l			Yeager			Cincinnati/Northern Kentucky Int’l			James M. Cox Dayton International Airport			Detroit Metropolitan Wayne County			Fort Wayne Int’l			Gerald R. Ford Int'l Arpt.			Indianapolis Int’l			Muskegon County			Pittsburgh Int’l			Oakland County Int'l, Pontiac			Greater Rochester Int’l			Louisville Intl. Standiford Field
		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly
		Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost
CBA/WD LABOR RATE
CWO, Excluding Differential		7,052	$32.72	$230,741.44	7,052	$29.60	$208,739.20	7,052	$29.51	$208,104.52	7,052	$28.40	$200,276.80	7,052	$31.40	$221,432.80	7,052	$28.20	$198,866.40	7,052	$24.00	$169,248.00	7,052	$26.20	$184,762.40	7,052	$23.79	$167,767.08	4,857	$24.17	$117,399.73	7,052	$26.04	$183,634.08	4,492	$23.84	$107,095.24	7,052	$39.56	$278,977.12	4,857	$31.35	$152,274.79	7,052	$35.42	$249,781.84	7,052	$32.00	$225,664.00
CWO Senior Excluding Differential		1,900	$37.04	$70,376.00	1,900	$34.39	$65,341.00	1,900	$33.73	$64,087.00	1,900	$31.50	$59,850.00	1,900	$34.80	$66,120.00	1,900	$30.80	$58,520.00	1,900	$25.30	$48,070.00	1,900	$29.20	$55,480.00	1,900	$26.41	$50,179.00	1,900	$26.87	$51,053.00	1,900	$28.80	$54,720.00	1,900	$26.11	$49,609.00	1,900	$43.55	$82,745.00	1,900	$34.50	$65,550.00	1,900	$39.46	$74,974.00	1,900	$34.50	$65,550.00

ADDITIONAL LABOR RATE (note 3)
CWO, Excluding Differential	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	4,492	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	3,635
CWO Senior Excluding Differential	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900

CWO Night Differential	10%	4,380	$3.27	$14,331.36	4,380	$2.96	$12,964.80	4,380	$2.95	$12,925.38	4,380	$2.84	$12,439.20	4,380	$3.14	$13,753.20	4,380	$2.82	$12,351.60	4,380	$2.40	$10,512.00	4,380	$2.62	$11,475.60	4,380	$2.38	$10,420.02	2,281	$2.42	$5,513.78	4,380	$2.60	$11,405.52	1,916	$2.38	$4,568.34	4,380	$3.96	$17,327.28	2,281	$3.14	$7,151.72	4,380	$3.54	$15,513.96	4,380	$3.20	$14,016.00
CWO Sunday Differential	25%	1,248	$8.18	$10,208.64	1,248	$7.40	$9,235.20	1,248	$7.38	$9,207.12	1,248	$7.10	$8,860.80	1,248	$7.85	$9,796.80	1,248	$7.05	$8,798.40	1,248	$6.00	$7,488.00	1,248	$6.55	$8,174.40	1,248	$5.95	$7,422.48	949	$6.04	$5,734.33	1,248	$6.51	$8,124.48	897	$5.96	$5,346.12	1,248	$9.89	$12,342.72	949	$7.84	$7,437.79	1,248	$8.86	$11,051.04	1,248	$8.00	$9,984.00
CWO Senior Night Differential	10%	- 0	$3.70	$0.00	- 0	$3.44	$0.00	- 0	$3.37	$0.00	- 0	$3.15	$0.00	- 0	$3.48	$0.00	- 0	$3.08	$0.00	- 0	$2.53	$0.00	- 0	$2.92	$0.00	- 0	$2.64	$0.00	- 0	$2.69	$0.00	- 0	$2.88	$0.00	- 0	$2.61	$0.00	- 0	$4.36	$0.00	- 0	$3.45	$0.00	- 0	$3.95	$0.00	- 0	$3.45	$0.00
CWO Senior Sunday Differential	25%	- 0	$9.26	$0.00	- 0	$8.60	$0.00	- 0	$8.43	$0.00	- 0	$7.88	$0.00	- 0	$8.70	$0.00	- 0	$7.70	$0.00	- 0	$6.33	$0.00	- 0	$7.30	$0.00	- 0	$6.60	$0.00	- 0	$6.72	$0.00	- 0	$7.20	$0.00	- 0	$6.53	$0.00	- 0	$10.89	$0.00	- 0	$8.63	$0.00	- 0	$9.87	$0.00	- 0	$8.63	$0.00
Total Differential				$24,540.00			$22,200.00			$22,132.50			$21,300.00			$23,550.00			$21,150.00			$18,000.00			$19,650.00			$17,842.50			$11,248.11			$19,530.00			$9,914.46			$29,670.00			$14,589.51			$26,565.00			$24,000.00

OPTION YEAR 2 DIRECT LABOR				$325,657.44			$296,280.20			$294,324.02			$281,426.80			$311,102.80			$278,536.40			$235,318.00			$259,892.40			$235,788.58			$179,700.85			$257,884.08			$166,618.70			$391,392.12			$232,414.29			$351,320.84			$315,214.00
OPTION YEAR 3	CLIN		6001			6002			6003			6004			6005			6006			6007			6008			6009			6010			6011			6012			6013			6014			6015			6016
			BUF			CAK			CLE			CMH			CRW			CVG			DAY			DTW			FWA			GRR			IND			MKG			PIT			PTK			ROC			SDF
	SITE	Buffalo-Niagara Int’l. Arpt.			Akron-Washington County			Cleveland-Hopkins Int’l. Arpt.			Port Columbus Int’l			Yeager			Cincinnati/Northern Kentucky Int’l			James M. Cox Dayton International Airport			Detroit Metropolitan Wayne County			Fort Wayne Int’l			Gerald R. Ford Int'l Arpt.			Indianapolis Int’l			Muskegon County			Pittsburgh Int’l			Oakland County Int'l, Pontiac			Greater Rochester Int’l			Louisville Intl. Standiford Field
		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly
		Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost
CBA/WD LABOR RATE
CWO, Excluding Differential		7,052	$32.72	$230,741.44	7,052	$29.60	$208,739.20	7,052	$29.51	$208,104.52	7,052	$28.40	$200,276.80	7,052	$31.40	$221,432.80	7,052	$28.20	$198,866.40	7,052	$24.00	$169,248.00	7,052	$26.20	$184,762.40	7,052	$23.79	$167,767.08	4,857	$24.17	$117,399.73	7,052	$26.04	$183,634.08	4,492	$23.84	$107,095.24	7,052	$39.56	$278,977.12	4,857	$31.35	$152,274.79	7,052	$35.42	$249,781.84	7,052	$32.00	$225,664.00
CWO Senior Excluding Differential		1,900	$37.04	$70,376.00	1,900	$34.39	$65,341.00	1,900	$33.73	$64,087.00	1,900	$31.50	$59,850.00	1,900	$34.80	$66,120.00	1,900	$30.80	$58,520.00	1,900	$25.30	$48,070.00	1,900	$29.20	$55,480.00	1,900	$26.41	$50,179.00	1,900	$26.87	$51,053.00	1,900	$28.80	$54,720.00	1,900	$26.11	$49,609.00	1,900	$43.55	$82,745.00	1,900	$34.50	$65,550.00	1,900	$39.46	$74,974.00	1,900	$34.50	$65,550.00

ADDITIONAL LABOR RATE (note 3)
CWO, Excluding Differential	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	4,492	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	3,635
CWO Senior Excluding Differential	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900

CWO Night Differential	10%	4,380	$3.27	$14,331.36	4,380	$2.96	$12,964.80	4,380	$2.95	$12,925.38	4,380	$2.84	$12,439.20	4,380	$3.14	$13,753.20	4,380	$2.82	$12,351.60	4,380	$2.40	$10,512.00	4,380	$2.62	$11,475.60	4,380	$2.38	$10,420.02	2,281	$2.42	$5,513.78	4,380	$2.60	$11,405.52	1,916	$2.38	$4,568.34	4,380	$3.96	$17,327.28	2,281	$3.14	$7,151.72	4,380	$3.54	$15,513.96	4,380	$3.20	$14,016.00
CWO Sunday Differential	25%	1,248	$8.18	$10,208.64	1,248	$7.40	$9,235.20	1,248	$7.38	$9,207.12	1,248	$7.10	$8,860.80	1,248	$7.85	$9,796.80	1,248	$7.05	$8,798.40	1,248	$6.00	$7,488.00	1,248	$6.55	$8,174.40	1,248	$5.95	$7,422.48	949	$6.04	$5,734.33	1,248	$6.51	$8,124.48	897	$5.96	$5,346.12	1,248	$9.89	$12,342.72	949	$7.84	$7,437.79	1,248	$8.86	$11,051.04	1,248	$8.00	$9,984.00
CWO Senior Night Differential	10%	- 0	$3.70	$0.00	- 0	$3.44	$0.00	- 0	$3.37	$0.00	- 0	$3.15	$0.00	- 0	$3.48	$0.00	- 0	$3.08	$0.00	- 0	$2.53	$0.00	- 0	$2.92	$0.00	- 0	$2.64	$0.00	- 0	$2.69	$0.00	- 0	$2.88	$0.00	- 0	$2.61	$0.00	- 0	$4.36	$0.00	- 0	$3.45	$0.00	- 0	$3.95	$0.00	- 0	$3.45	$0.00
CWO Senior Sunday Differential	25%	- 0	$9.26	$0.00	- 0	$8.60	$0.00	- 0	$8.43	$0.00	- 0	$7.88	$0.00	- 0	$8.70	$0.00	- 0	$7.70	$0.00	- 0	$6.33	$0.00	- 0	$7.30	$0.00	- 0	$6.60	$0.00	- 0	$6.72	$0.00	- 0	$7.20	$0.00	- 0	$6.53	$0.00	- 0	$10.89	$0.00	- 0	$8.63	$0.00	- 0	$9.87	$0.00	- 0	$8.63	$0.00
Total Differential				$24,540.00			$22,200.00			$22,132.50			$21,300.00			$23,550.00			$21,150.00			$18,000.00			$19,650.00			$17,842.50			$11,248.11			$19,530.00			$9,914.46			$29,670.00			$14,589.51			$26,565.00			$24,000.00

OPTION YEAR 3 DIRECT LABOR				$325,657.44			$296,280.20			$294,324.02			$281,426.80			$311,102.80			$278,536.40			$235,318.00			$259,892.40			$235,788.58			$179,700.85			$257,884.08			$166,618.70			$391,392.12			$232,414.29			$351,320.84			$315,214.00
OPTION YEAR 4	CLIN		6001			6002			6003			6004			6005			6006			6007			6008			6009			6010			6011			6012			6013			6014			6015			6016
			BUF			CAK			CLE			CMH			CRW			CVG			DAY			DTW			FWA			GRR			IND			MKG			PIT			PTK			ROC			SDF
	SITE	Buffalo-Niagara Int’l. Arpt.			Akron-Washington County			Cleveland-Hopkins Int’l. Arpt.			Port Columbus Int’l			Yeager			Cincinnati/Northern Kentucky Int’l			James M. Cox Dayton International Airport			Detroit Metropolitan Wayne County			Fort Wayne Int’l			Gerald R. Ford Int'l Arpt.			Indianapolis Int’l			Muskegon County			Pittsburgh Int’l			Oakland County Int'l, Pontiac			Greater Rochester Int’l			Louisville Intl. Standiford Field
		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly
		Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost
CBA/WD LABOR RATE
CWO, Excluding Differential		7,052	$32.72	$230,741.44	7,052	$29.60	$208,739.20	7,052	$29.51	$208,104.52	7,052	$28.40	$200,276.80	7,052	$31.40	$221,432.80	7,052	$28.20	$198,866.40	7,052	$24.00	$169,248.00	7,052	$26.20	$184,762.40	7,052	$23.79	$167,767.08	4,857	$24.17	$117,399.73	7,052	$26.04	$183,634.08	4,492	$23.84	$107,095.24	7,052	$39.56	$278,977.12	4,857	$31.35	$152,274.79	7,052	$35.42	$249,781.84	7,052	$32.00	$225,664.00
CWO Senior Excluding Differential		1,900	$37.04	$70,376.00	1,900	$34.39	$65,341.00	1,900	$33.73	$64,087.00	1,900	$31.50	$59,850.00	1,900	$34.80	$66,120.00	1,900	$30.80	$58,520.00	1,900	$25.30	$48,070.00	1,900	$29.20	$55,480.00	1,900	$26.41	$50,179.00	1,900	$26.87	$51,053.00	1,900	$28.80	$54,720.00	1,900	$26.11	$49,609.00	1,900	$43.55	$82,745.00	1,900	$34.50	$65,550.00	1,900	$39.46	$74,974.00	1,900	$34.50	$65,550.00

ADDITIONAL LABOR RATE (note 3)
CWO, Excluding Differential	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	4,492	$0.00	$0.00	7,052	$0.00	$0.00	4,857	$0.00	$0.00	7,052	$0.00	$0.00	7,052	$0.00	$0.00	3,635
CWO Senior Excluding Differential	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900	$0.00	$0.00	1,900

CWO Night Differential	10%	4,380	$3.27	$14,331.36	4,380	$2.96	$12,964.80	4,380	$2.95	$12,925.38	4,380	$2.84	$12,439.20	4,380	$3.14	$13,753.20	4,380	$2.82	$12,351.60	4,380	$2.40	$10,512.00	4,380	$2.62	$11,475.60	4,380	$2.38	$10,420.02	2,281	$2.42	$5,513.78	4,380	$2.60	$11,405.52	1,916	$2.38	$4,568.34	4,380	$3.96	$17,327.28	2,281	$3.14	$7,151.72	4,380	$3.54	$15,513.96	4,380	$3.20	$14,016.00
CWO Sunday Differential	25%	1,248	$8.18	$10,208.64	1,248	$7.40	$9,235.20	1,248	$7.38	$9,207.12	1,248	$7.10	$8,860.80	1,248	$7.85	$9,796.80	1,248	$7.05	$8,798.40	1,248	$6.00	$7,488.00	1,248	$6.55	$8,174.40	1,248	$5.95	$7,422.48	949	$6.04	$5,734.33	1,248	$6.51	$8,124.48	897	$5.96	$5,346.12	1,248	$9.89	$12,342.72	949	$7.84	$7,437.79	1,248	$8.86	$11,051.04	1,248	$8.00	$9,984.00
CWO Senior Night Differential	10%	- 0	$3.70	$0.00	- 0	$3.44	$0.00	- 0	$3.37	$0.00	- 0	$3.15	$0.00	- 0	$3.48	$0.00	- 0	$3.08	$0.00	- 0	$2.53	$0.00	- 0	$2.92	$0.00	- 0	$2.64	$0.00	- 0	$2.69	$0.00	- 0	$2.88	$0.00	- 0	$2.61	$0.00	- 0	$4.36	$0.00	- 0	$3.45	$0.00	- 0	$3.95	$0.00	- 0	$3.45	$0.00
CWO Senior Sunday Differential	25%	- 0	$9.26	$0.00	- 0	$8.60	$0.00	- 0	$8.43	$0.00	- 0	$7.88	$0.00	- 0	$8.70	$0.00	- 0	$7.70	$0.00	- 0	$6.33	$0.00	- 0	$7.30	$0.00	- 0	$6.60	$0.00	- 0	$6.72	$0.00	- 0	$7.20	$0.00	- 0	$6.53	$0.00	- 0	$10.89	$0.00	- 0	$8.63	$0.00	- 0	$9.87	$0.00	- 0	$8.63	$0.00
Total Differential				$24,540.00			$22,200.00			$22,132.50			$21,300.00			$23,550.00			$21,150.00			$18,000.00			$19,650.00			$17,842.50			$11,248.11			$19,530.00			$9,914.46			$29,670.00			$14,589.51			$26,565.00			$24,000.00

OPTION YEAR 4 DIRECT LABOR $325,657.44 $296,280.20 $294,324.02 $281,426.80 $311,102.80 $278,536.40 $235,318.00 $259,892.40 $235,788.58 $179,700.85 $257,884.08 $166,618.70 $391,392.12 $232,414.29 $351,320.84 $315,214.00 $144,668.97 ERROR:#N/A

Section L, Attachment L-1

Table C - Fringe

INSTRUCTIONS:

The Offeror may not alter the pricing model format.

Enter your proposal data in the blue highlighed cells on each sheet

TABLE B
Direct Labor (Excludes Applicable Fringe Benefits, Other Indirect Costs, and Profit)
Group	Area One

BASE YEAR		CLIN		6001			6002			6003			6004			6005			6006			6007			6008			6009			6010			6011			6012			6013			6014			6015			6016
				BUF			CAK			CLE			CMH			CRW			CVG			DAY			DTW			FWA			GRR			IND			MKG			PIT			PTK			ROC			SDF
		SITE	Buffalo-Niagara Int’l. Arpt.			Akron-Washington County			Cleveland-Hopkins Int’l. Arpt.			Port Columbus Int’l			Yeager			Cincinnati/Northern Kentucky Int’l			James M. Cox Dayton International Airport			Detroit Metropolitan Wayne County			Fort Wayne Int’l			Gerald R. Ford Int'l Arpt.			Indianapolis Int’l			Muskegon County			Pittsburgh Int’l			Oakland County Int'l, Pontiac			Greater Rochester Int’l			Louisville Intl. Standiford Field
			Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly
			Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate
Fringe Benefits
Health and Welfare (H&W)				$5.50	$0.00		$4.82	$0.00		$4.82	$0.00		$7.00	$0.00		$5.00	$0.00		$6.20	$0.00		$6.00	$0.00		$6.00	$0.00		$4.82	$0.00		$4.22	$0.00		$4.82	$0.00		$4.22	$0.00		$6.00	$0.00		$7.00	$0.00		$7.35	$0.00		$6.20
Holidays
	CWO			$32.72	$0.00		$29.60	$0.00		$29.51	$0.00		$28.40	$0.00		$31.40	$0.00		$28.20	$0.00		$24.00	$0.00		$26.20	$0.00		$23.79	$0.00		$24.17	$0.00		$26.04	$0.00		$23.84	$0.00		$39.56	$0.00		$31.35	$0.00		$35.42	$0.00		$32.00
	CWO Senior			$37.04	$0.00		$34.39	$0.00		$33.73	$0.00		$31.50	$0.00		$34.80	$0.00		$30.80	$0.00		$25.30	$0.00		$29.20	$0.00		$26.41	$0.00		$26.87	$0.00		$28.80	$0.00		$26.11	$0.00		$43.55	$0.00		$34.50	$0.00		$39.46	$0.00		$34.50
Vacation
	CWO			$32.72	$0.00		$29.60	$0.00		$29.51	$0.00		$28.40	$0.00		$31.40	$0.00		$28.20	$0.00		$24.00	$0.00		$26.20	$0.00		$23.79	$0.00		$24.17	$0.00		$26.04	$0.00		$23.84	$0.00		$39.56	$0.00		$31.35	$0.00		$35.42	$0.00		$32.00
	CWO Senior			$37.04	$0.00		$34.39	$0.00		$33.73	$0.00		$31.50	$0.00		$34.80	$0.00		$30.80	$0.00		$25.30	$0.00		$29.20	$0.00		$26.41	$0.00		$26.87	$0.00		$28.80	$0.00		$26.11	$0.00		$43.55	$0.00		$34.50	$0.00		$39.46	$0.00		$34.50
Sick Leave
	CWO			$32.72	$0.00		$29.60	$0.00		$29.51	$0.00		$28.40	$0.00		$31.40	$0.00		$28.20	$0.00		$24.00	$0.00		$26.20	$0.00		$23.79	$0.00		$24.17	$0.00		$26.04	$0.00		$23.84	$0.00		$39.56	$0.00		$31.35	$0.00		$35.42	$0.00		$32.00
	CWO Senior			$37.04	$0.00		$34.39	$0.00		$33.73	$0.00		$31.50	$0.00		$34.80	$0.00		$30.80	$0.00		$25.30	$0.00		$29.20	$0.00		$26.41	$0.00		$26.87	$0.00		$28.80	$0.00		$26.11	$0.00		$43.55	$0.00		$34.50	$0.00		$39.46	$0.00		$34.50
Personal Days
	CWO			$32.72	$0.00		$29.60	$0.00		$29.51	$0.00		$28.40	$0.00		$31.40	$0.00		$28.20	$0.00		$24.00	$0.00		$26.20	$0.00		$23.79	$0.00		$24.17	$0.00		$26.04	$0.00		$23.84	$0.00		$39.56	$0.00		$31.35	$0.00		$35.42	$0.00		$32.00
	CWO Senior			$37.04	$0.00		$34.39	$0.00		$33.73	$0.00		$31.50	$0.00		$34.80	$0.00		$30.80	$0.00		$25.30	$0.00		$29.20	$0.00		$26.41	$0.00		$26.87	$0.00		$28.80	$0.00		$26.11	$0.00		$43.55	$0.00		$34.50	$0.00		$39.46	$0.00		$34.50
Payroll Taxes
FICA
FUTA
SUTA
Worker's Compensation
Other Fringe Benefits

BASE YEAR Fringe Benefits $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 ERROR:#REF!

OPTION YEAR 1		CLIN		6001			6002			6003			6004			6005			6006			6007			6008			6009			6010			6011			6012			6013			6014			6015			6016
				BUF			CAK			CLE			CMH			CRW			CVG			DAY			DTW			FWA			GRR			IND			MKG			PIT			PTK			ROC			SDF
		SITE	Buffalo-Niagara Int’l. Arpt.			Akron-Washington County			Cleveland-Hopkins Int’l. Arpt.			Port Columbus Int’l			Yeager			Cincinnati/Northern Kentucky Int’l			James M. Cox Dayton International Airport			Detroit Metropolitan Wayne County			Fort Wayne Int’l			Gerald R. Ford Int'l Arpt.			Indianapolis Int’l			Muskegon County			Pittsburgh Int’l			Oakland County Int'l, Pontiac			Greater Rochester Int’l			Louisville Intl. Standiford Field
			Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly		Labor	Hourly
			Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate
Fringe Benefits
Health and Welfare (H&W)				$5.50	$0.00		$4.82	$0.00		$4.82	$0.00		$7.00	$0.00		$5.00	$0.00		$6.20	$0.00		$6.00	$0.00		$6.00	$0.00		$4.82	$0.00		$4.22	$0.00		$4.82	$0.00		$4.22	$0.00		$6.00	$0.00		$7.00	$0.00		$7.35	$0.00		$6.20
Holidays
	CWO			$32.72	$0.00		$29.60	$0.00		$29.51	$0.00		$28.40	$0.00		$31.40	$0.00		$28.20	$0.00		$24.00	$0.00		$26.20	$0.00		$23.79	$0.00		$24.17	$0.00		$26.04	$0.00		$23.84	$0.00		$39.56	$0.00		$31.35	$0.00		$35.42	$0.00		$32.00
	CWO Senior			$37.04	$0.00		$34.39	$0.00		$33.73	$0.00		$31.50	$0.00		$34.80	$0.00		$30.80	$0.00		$25.30	$0.00		$29.20	$0.00		$26.41	$0.00		$26.87	$0.00		$28.80	$0.00		$26.11	$0.00		$43.55	$0.00		$34.50	$0.00		$39.46	$0.00		$34.50
Vacation
	CWO			$32.72	$0.00		$29.60	$0.00		$29.51	$0.00		$28.40	$0.00		$31.40	$0.00		$28.20	$0.00		$24.00	$0.00		$26.20	$0.00		$23.79	$0.00		$24.17	$0.00		$26.04	$0.00		$23.84	$0.00		$39.56	$0.00		$31.35	$0.00		$35.42	$0.00		$32.00
	CWO Senior			$37.04	$0.00		$34.39	$0.00		$33.73	$0.00		$31.50	$0.00		$34.80	$0.00		$30.80	$0.00		$25.30	$0.00		$29.20	$0.00		$26.41	$0.00		$26.87	$0.00		$28.80	$0.00		$26.11	$0.00		$43.55	$0.00		$34.50	$0.00		$39.46	$0.00		$34.50
Sick Leave
	CWO			$32.72	$0.00		$29.60	$0.00		$29.51	$0.00		$28.40	$0.00		$31.40	$0.00		$28.20	$0.00		$24.00	$0.00		$26.20	$0.00		$23.79	$0.00		$24.17	$0.00		$26.04	$0.00		$23.84	$0.00		$39.56	$0.00		$31.35	$0.00		$35.42	$0.00		$32.00

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Jun 10, 2021.