Area 9 FCT Template (beta) v 0.5.xlsx

XLSX spreadsheet 34 KB Posted

Attached to
FAA Contract Tower Program Federal contract opportunity
Solicitation number
Clindsay062322
Issued by
Department of Transportation Federal Aviation Administration Enroute Terminal Contracts

View the file

Other files for this federal contract opportunity

Other files attached to FAA Contract Tower Program, newest first.
File Type Posted
FCT Market Survey Q and A 7.22.22.pdf PDF
FCT Area Map FINAL.pdf PDF
Area 4 FCT Template (beta) v 0.5.xlsx XLSX spreadsheet
2022 FCT SIR Section H FINAL.pdf PDF
2022 FCT SIR Section B FINAL.pdf PDF
2022 FCT SIR Section E FINAL.pdf PDF
Area 5 FCT Template (beta) v 0.5.xlsx XLSX spreadsheet
Area 1 FCT Template (beta) v 0.5.xlsx XLSX spreadsheet
2022 FCT SIR Section K FINAL.pdf PDF
2022 FCT SIR Section M FINAL.pdf PDF
2022 FCT SIR Section F FINAL.pdf PDF
Business Declaration 6.23.2022.doc DOC document
Area 8 FCT Template (beta) v 0.5.xlsx XLSX spreadsheet
Area 6 FCT Template (beta) v 0.5.xlsx XLSX spreadsheet
Area 7 FCT Template (beta) v 0.5.xlsx XLSX spreadsheet
Area 10 FCT Template (beta) v 0.5.xlsx XLSX spreadsheet
2022 FCT SIR Section I FINAL.pdf PDF
2022 FCT SIR Section G FINAL.pdf PDF
Section J-3 5-06-22.xlsx XLSX spreadsheet
Area 3 FCT Template (beta) v 0.5.xlsx XLSX spreadsheet
Area 2 FCT Template (beta) v 0.5.xlsx XLSX spreadsheet
2022 FCT SIR Section C FINAL vs2.pdf PDF
2022 FCT SIR Section L FINAL.pdf PDF
2022 FCT SIR Section D FINAL.pdf PDF
2022 FCT SIR Section J FINAL.pdf PDF
Show all 25

On GovTribe

Work with this file on GovTribe

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

Text version

FAA Area 9 Intro Sheet

Solicitation:FCT-Draft
OFFERORS: Utilize this pricing workbook to provide your pricing for Area 9. Editable cells are indicated by yellow highlighting and red borders. Your OH, G&A, and Profit/Fee should be loaded into the "Rates" sheet and will be converted into percentages. Your Prime Fee (if applicable) may be entered as percentage or flat fee. On each CLIN sheet, please select which CBA is applicable, if any, from the drop-down menu at Cell D2. NOTE: All CLIN monthly rates will be added together and rounded up to the next dollar for a whole dollar monthly contract rate on the Summary Sheet. That whole dollar total monthly contract rate will be multiplied by 12 for a whole dollar total annual contract rate and will be visible on the Summary Sheet.

Summary Sheet

Solicitation:FCT-Draft
CLINLOCIDDirect Labor TotalFringe Benefits TotalOverhead TotalODCs TotalTotal CostMonthly RateOne-Time Phase-In Costs (if applicable)
0901ADQ$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0902AKN$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0903BET$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0904ENA$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00
TOTAL CONTRACT
Rounded Monthly$0.00
Annual Contract Value$0.00

Rates

Data TypeInput ValueNote:
OHPercentage
G&APercentage
Profit/FeePercentage
Prime Fee, if applicablePercentage or flat rate

CLIN 0901 ADQ

CLIN 0901ADQSolicitation #FCT-Draft
CBA:None
DIRECT LABORHOURSRATETOTAL
ATCM$0.00
ATC$0.00
Overtime$0.00
Total Direct Labor$0.00
Fringe BenefitsQuantity/RateUnit Value
ATCM Holiday$0.00
ATC Holiday$0.00
Night Diff$0.00
Sunday Diff$0.00
ATCM Vacation$0.00
ATC Vacation$0.00
ATCM Personal$0.00
ATC Personal$0.00
ATCM Sick$0.00
ATC Sick$0.00
ATCM Jury$0.00
ATC Jury$0.00
ATCM Funeral$0.00
ATC Funeral$0.00
FICA$0.00
H&W$0.00
FUTA$0.00
SUTA$0.00
Worker's Comp$0.00
Other (see Line 52 for input)$0.00
Total Fringe Benefits$0.00
OH Labor
Technical Support0.000%$0.00$0.00

ODCs (provide breakout at Line 65) Total: $0.00

Total Labor, Fringe, OH, & ODCs$0.00
G&A0.000%$0.00$0.00
Profit/Fee0.000%$0.00$0.00
Prime Fee, if applicable0$0.00
Total Cost$0.00$0.00
$0.00
Monthly Price$0.00
One-time Phase In Costs, if applicable
Site HeadcountRate Per EmployeeTotal
Other Fringe (define line items):Quantity/RateUnit Value (use formulas)Extended Rate
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Other Fringe:$0.00
ODCs:Quantity/RateUnit ValueExtended Rate
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total ODCs:$0.00

CLIN 0902 AKN

CLIN 0902AKNSolicitation #FCT-Draft
CBA:None
DIRECT LABORHOURSRATETOTAL
ATCM$0.00
ATC$0.00
Overtime$0.00
Total Direct Labor$0.00
Fringe BenefitsQuantity/RateUnit Value
ATCM Holiday$0.00
ATC Holiday$0.00
Night Diff$0.00
Sunday Diff$0.00
ATCM Vacation$0.00
ATC Vacation$0.00
ATCM Personal$0.00
ATC Personal$0.00
ATCM Sick$0.00
ATC Sick$0.00
ATCM Jury$0.00
ATC Jury$0.00
ATCM Funeral$0.00
ATC Funeral$0.00
FICA$0.00
H&W$0.00
FUTA$0.00
SUTA$0.00
Worker's Comp$0.00
Other (see Line 52 for input)$0.00
Total Fringe Benefits$0.00
OH Labor
Technical Support0.000%$0.00$0.00

ODCs (provide breakout at Line 65) Total: $0.00

Total Labor, Fringe, OH, & ODCs$0.00
G&A0.000%$0.00$0.00
Profit/Fee0.000%$0.00$0.00
Prime Fee, if applicable0$0.00
Total Cost$0.00$0.00
$0.00
Monthly Price$0.00
One-time Phase In Costs, if applicable
Site HeadcountRate Per EmployeeTotal
Other Fringe (define line items):Quantity/RateUnit Value (use formulas)Extended Rate
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Other Fringe:$0.00
ODCs:Quantity/RateUnit ValueExtended Rate
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total ODCs:$0.00

CLIN 0903 BET

CLIN 0903BETSolicitation #FCT-Draft
CBA:None
DIRECT LABORHOURSRATETOTAL
ATCM$0.00
ATC$0.00
Overtime$0.00
Total Direct Labor$0.00
Fringe BenefitsQuantity/RateUnit Value
ATCM Holiday$0.00
ATC Holiday$0.00
Night Diff$0.00
Sunday Diff$0.00
ATCM Vacation$0.00
ATC Vacation$0.00
ATCM Personal$0.00
ATC Personal$0.00
ATCM Sick$0.00
ATC Sick$0.00
ATCM Jury$0.00
ATC Jury$0.00
ATCM Funeral$0.00
ATC Funeral$0.00
FICA$0.00
H&W$0.00
FUTA$0.00
SUTA$0.00
Worker's Comp$0.00
Other (see Line 52 for input)$0.00
Total Fringe Benefits$0.00
OH Labor
Technical Support0.000%$0.00$0.00

ODCs (provide breakout at Line 65) Total: $0.00

Total Labor, Fringe, OH, & ODCs$0.00
G&A0.000%$0.00$0.00
Profit/Fee0.000%$0.00$0.00
Prime Fee, if applicable0$0.00
Total Cost$0.00$0.00
$0.00
Monthly Price$0.00
One-time Phase In Costs, if applicable
Site HeadcountRate Per EmployeeTotal
Other Fringe (define line items):Quantity/RateUnit Value (use formulas)Extended Rate
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Other Fringe:$0.00
ODCs:Quantity/RateUnit ValueExtended Rate
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total ODCs:$0.00

CLIN 0904 ENA

CLIN 0904ENASolicitation #FCT-Draft
CBA:None
DIRECT LABORHOURSRATETOTAL
ATCM$0.00
ATC$0.00
Overtime$0.00
Total Direct Labor$0.00
Fringe BenefitsQuantity/RateUnit Value
ATCM Holiday$0.00
ATC Holiday$0.00
Night Diff$0.00
Sunday Diff$0.00
ATCM Vacation$0.00
ATC Vacation$0.00
ATCM Personal$0.00
ATC Personal$0.00
ATCM Sick$0.00
ATC Sick$0.00
ATCM Jury$0.00
ATC Jury$0.00
ATCM Funeral$0.00
ATC Funeral$0.00
FICA$0.00
H&W$0.00
FUTA$0.00
SUTA$0.00
Worker's Comp$0.00
Other (see Line 52 for input)$0.00
Total Fringe Benefits$0.00
OH Labor
Technical Support0.000%$0.00$0.00

ODCs (provide breakout at Line 65) Total: $0.00

Total Labor, Fringe, OH, & ODCs$0.00
G&A0.000%$0.00$0.00
Profit/Fee0.000%$0.00$0.00
Prime Fee, if applicable0$0.00
Total Cost$0.00$0.00
$0.00
Monthly Price$0.00
One-time Phase In Costs, if applicable
Site HeadcountRate Per EmployeeTotal
Other Fringe (define line items):Quantity/RateUnit Value (use formulas)Extended Rate
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Other Fringe:$0.00
ODCs:Quantity/RateUnit ValueExtended Rate
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total ODCs:$0.00

Version History

Version NumberChanges
0.0Origin
0.1corrects omission of an editable OH field
0.2removed Excise Tax fields, gave borders to certain fields, added text to Intro Sheet, added Version History sheet
0.3removed references to rounding on CLIN sheets, modified formula for total/monthly, separate CLIN# and LOCID on summary sheet, made a notation for offerors to define "other fringe"
0.4updated instructions to reflect whole dollar rounding note; summary sheet updated to include total rounded monthly/annual price; each CLIN sheet has hidden rounding math

File details come from the government source that posted it. Updated .