FA521524R0006 - Appendix E TEP Proposal Format (DRAFT).xlsx

XLSX spreadsheet 106 KB Posted

Attached to
Preproposal Conference dates, Q&A dates, Site Visit information, and Draft RFP for Alaska Radar System Operations and Maintenance
Solicitation number
FA521524R0006
Issued by

About this file

This document appears to be a pricing template (Appendix E) for a draft Request for Proposal (RFP) for the Alaska Radar System (ARS) Operations and Maintenance contract. The ARS requirement consists of operations and maintenance of 15 geographically separated long-range radar sites, three remote radio sites, and the Maintenance Control and Communications Center (MC3) activities of the Regional Air Operations Center (RAOC). The contract supports the North American Aerospace Defense Command (NORAD) and United States Northern Command (USNORTHCOM) mission for air sovereignty within Alaska. The pricing template includes labor categories, labor hours, other direct costs, and cost for contract line items such as contractor-acquired parts, fuel, and transportation. No specific proposal submission or award dates are provided. The template appears to cover a base period and multiple option years.

View the file

Other files

File Type Posted
ARS Questions and Answers_7 June 24.pdf PDF
Solicitation - FA521524R0006.pdf PDF
3D DBA WD AK20240002 20240105.pdf PDF
FA521524R0006 - Appendix B Self Scoring Matrix.xlsx XLSX spreadsheet
FA521524R0006 - Appendix D SBPCD template.docx DOCX document
3A SCA WD 2015-5681 Rev 19 20231226.pdf PDF
3B SCA WD 2015-5687 Rev 21 20231226.pdf PDF
FA521524R0006 - Draft Section L.docx DOCX document
4 ARCTEC_2021-2024_CBA.pdf PDF
FA521524R0006 - Draft Section M.docx DOCX document
FA521524R0006 - Appendix A Past Technical Experience (PTE) Cover Sheet.docx DOCX document
3C DBA WD AK20240001 20240223.pdf PDF
FA521524R0006 - Appendix C Teaming Structure Format.xlsx XLSX spreadsheet
ARS Questions and Answers_20 May 24.pdf PDF
Final ARS Industry Day Handout 20240503.pdf PDF
Final ARS Industry Day 20240503.pdf PDF
ARS SAR.pdf PDF
Revised Site Visit and Industry Day Instructions.docx DOCX document
Oliktok GFP Attachment Apr 2021.xlsx XLSX spreadsheet
FA521524R0006 - Appendix C Cross Reference Matrix.xlsx XLSX spreadsheet
Gfp Tin City 26 July 2022.xlsx XLSX spreadsheet
Murphy Dome GFP Attachment Mar 2021.xlsx XLSX spreadsheet
Point Barrow GFP Attachment Feb 2021.xlsx XLSX spreadsheet
Site Visit and Industry Day Instructions.docx DOCX document
Cape Lisburne GFP Attachment Sep 2021.xlsx XLSX spreadsheet
FA521524R0006 - Draft Section L.docx DOCX document
FA521524R0006 - Appendix A Work Sample Cover Sheet.docx DOCX document
FA521524R0006 - Appendix B Self Scoring Matrix.xlsx XLSX spreadsheet
Sparrevohn FCA (Final).docx DOCX document
Cape Newenham GFP Attachment Sep 2021.xlsx XLSX spreadsheet
King Salmon ARS GFP Attachment 6 Apr 2023.xlsx XLSX spreadsheet
Cold Bay GFP Attachment Mar 2021.xlsx XLSX spreadsheet
ARS SAR.pdf PDF
FA521524R0006 - Draft Section M.docx DOCX document
Indian Mountain GFP Attachment 9 Sep 2022.xlsx XLSX spreadsheet
FA521524R0006 - Draft Section H.docx DOCX document
Kotzebue GFP Attachment Apr 2021.xlsx XLSX spreadsheet
Tatalina GFP Attachment Aug 2021.xlsx XLSX spreadsheet
DRAFT RFP ARS PWS 4.3.24.pdf PDF
FA521524R0006 - Appendix D Team Structure Format.xlsx XLSX spreadsheet
Fort Yukon GFP Attachment May 2022.xlsx XLSX spreadsheet
Barter Island GFP Attachment May 2021.xlsx XLSX spreadsheet
Cape Romanzof FCA (Final).docx DOCX document
FA521524R0006 - Appendix E SBPCD template.docx DOCX document
FA521524R0006 - Appendix F Sample Subcontractor or Team Member Consent Letter.docx DOCX document
Show all 45

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

TEP Roll-up

Fill-in In-Direct Rate Titles and % in Row 4
(Add/Delete Columns as needed)Profit %
Performance YearPhase-in/Phase-outLaborTravelODCIDC-AIDC-BIDC-CIDC-DProfit $$Total Proposal minus COST CLINSNTE Cost CLINS TotalOverall Contract Total
Phase-in$ - 0XXXXXXXXXXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0XXXX$ - 0
Option 1XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option 2XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option 3XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option 4XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option 5XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option 6XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option 7XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option 8XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option 9XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option 10XXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Phase-out$ - 0XXXXXXXXXXXX$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Section L, 2.7.1(f)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0XXXX$ - 0

Option Year Breakout

CLINDESCRIPTIONBase
Phase-InOption 1Option 2Option 3Option 4Option 5Option 6Option 7Option 8Option 9Option 10Option 12

Phase-Out 0001 Phase-In XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX

XX01O&M Barter IslandXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX02O&M OliktokXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX03O&M Point BarrowXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX04O&M Cape LisburneXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX05O&M NewenhamXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX06O&M Cape RomanzofXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX07O&M Cold BayXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX08O&M Fort YukonXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX09O&M Indian MountainXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX10O&M King SalmonXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX11O&M KotzebueXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX12O&M Murphy DomeXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX13O&M SparrevohnXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX14O&M TatalinaXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX15O&M Tin CityXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX16O&M MAINTENANCE CONTROL & COMM CENTER (MC3)XXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX17O&M REGION AIR OPERATION CENTER (RAOC)XXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX18O&M COMPANY HEADQUARTERS (PHQ)XXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs
XX19O&M RADIO RELAY SITESXXXXXXXX
Labor (Exempt and Non-Exempt)
Travel
Other Direct Costs

XX20 CONTRACTOR ACQUIRED PARTS (CAP) XXXX $ 3,000,000.00 $ 3,109,011.73 $ 3,221,984.65 $ 3,339,062.69 $ 3,460,395.03 $ 3,586,136.25 $ 3,716,446.56 $ 3,851,491.98 $ 3,991,444.59 $ 4,136,482.68 XXXX

XX21 CONTRACTOR ACQUIRED FUEL XXXX $ 3,000.00 $ 3,109.01 $ 3,221.98 $ 3,339.06 $ 3,460.40 $ 3,586.14 $ 3,716.45 $ 3,851.49 $ 3,991.44 $ 4,136.48 XXXX

XX22 CONTRACTOR ACQUIRED TRANSPORTATION XXXX $ 1,000,000.00 $ 1,036,337.24 $ 1,073,994.88 $ 1,113,020.90 $ 1,153,465.01 $ 1,195,378.75 $ 1,238,815.52 $ 1,283,830.66 $ 1,330,481.53 $ 1,378,827.56 XXXX

XX23 GOVERNMENT / THIRD PARTY SUPPORT XXXX $ 500,000.00 $ 518,168.62 $ 536,997.44 $ 556,510.45 $ 576,732.50 $ 597,689.37 $ 619,407.76 $ 641,915.33 $ 665,240.76 $ 689,413.78 XXXX

XX24OVER & ABOVE PROJECTSXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
1101Phase-OutXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Base
Phase-InOption 1Option 2Option 3Option 4Option 5Option 6Option 7Option 8Option 9Option 10Phase-Out
Labor (Exempt and Non-Exempt)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
COST CLINS (set by Government)$ 4,503,000.00$ 4,666,626.61$ 4,836,198.96$ 5,011,933.10$ 5,194,052.94$ 5,382,790.51$ 5,578,386.28$ 5,781,089.46$ 5,991,158.32$ 6,208,860.50
Phase-In/Phase-Out$ - 0$ - 0
Total for Option (no in-direct rates or profit)
$ - 0$ 4,503,000.00$ 4,666,626.61$ 4,836,198.96$ 5,011,933.10$ 5,194,052.94$ 5,382,790.51$ 5,578,386.28$ 5,781,089.46$ 5,991,158.32$ 6,208,860.50$ - 0

Non-Exempt Labor Breakout

LABOR CATEGORYElectricianFacilities EngineerFacilities Engineer (EIT)Senior AccountantAccounting StaffDrafterHAZMAT SpecialistHealth, Fire, Safety SpecialistHelp Desk SpecialistLogistics ExpeditorsLogistics BuyersMaterials CoordinatorProject CoordinatorQC AuditorRadar SpecialistService TechStation TechData Specialist - System AdminFacilities HelperRAOC SpecialistStation MechFacilities QC
Job Code42555695905065602786858029751517102845304043
Bargaining UnitIBEWIBEWIBEWIBEW-ACCTIBEW-ACCTIBTIBTIBTIBTIBTIBTIBTIBTIBTIBTIBTIBTIBTIUOEIUOEIUOEIUOE
Primary Site Assigned
# of Full Time EquivalentsMust be whole numbers
CBA Base Wage RateStraight Time Rate
Overtime Rate0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
CBA Rate - Lead (As applicable)Station Chief
Department Leads
Sector Leads
MC3 Lead
Electrician Lead
RAOC Lead
Project/Field Lead
CBA Rate Differential (As applicable)Height
Shift
Total S/T Wage0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Total O/T Wage0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Labor HoursStraight time
Over time
Labor DollarsStraight Time Labor Costs0000000000000000000000
Overtime Labor Costs0000000000000000000000
Total Direct Labor Cost0000000000000000000000
Non-productive Labor HoursHoliday0000000000000000000000
Vacation0000000000000000000000
Sick0000000000000000000000
Non-productive Labor Hours Total0000000000000000000000
Non-productive Labor Cost0000000000000000000000
Total labor hours.0000000000000000000000
Total Labor Costs0000000000000000000000
Tax PercentSalary Cap Amount
Social Security0000000000000000000000
Medicare0000000000000000000000
FUI0000000000000000000000
ESC0000000000000000000000
Workers Compensation

Labor Taxes 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Pension Cost0000000000000000000000
Health & Welfare0000000000000000000000
Training0000000000000000000000
Annuity(IBEW only)0000000000000000000000
Legal(IBEW only)0000000000000000000000
Fringe Benefits0000000000000000000000
NON-DIRECT LABOUR COSTS0000000000000000000000
TOTAL LABOR,TAXES & BURDEN COST0000000000000000000000
Fringe rates per the CBAPension Rate
Health & Welfare Rate
Training Rate
Annuity (IBEW only)
Legal (IBEW only)
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

SCA FY22

&D

Exempt Labor Breakout

Exempt - Title of PositionSite AssignedAssociated CLINBase SalaryFringeOtherTaxesTotalPhase-InOption 1Escalation Factor
Option 2Option 2Escalation Factor
Option 3Option 3Escalation Factor
Option 4Option 4Escalation Factor
Option 5Option 5Escalation Factor
Option 6Option 6Escalation Factor
Option 7Option 7Escalation Factor
Option 8Option 8Escalation Factor
Option 9Option 9Escalation Factor
Option 10Option 10Phase-Out
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

XX23 TPS Rate

LABOR CATEGORY - one FTEColumn1Column2Column5Column14
Job Code
Union
Base Labor Rate Rate
Add any additional increase w/ description - one increase per row (add rows as needed)

Total Labor Rate (before burdens) $ - 0 $ - 0 $ - 0 $ - 0

Total Fringe
Taxes
Assoiated Indirect Costs (add title and percentage)

(Must be the same as the overall proposal) (add line as needed)

Total TPS Labor Rate (not including profit)

Profit (Percentage must be the same as the overall proposal)

Total Labor Rate for one (1) FTE $ - 0 $ - 0 $ - 0 $ - 0

Average Rate of All TPS Proposed Labor Categories $ - 0

SCA FY22

&D

Drop Down breakout for Tabs

Site BreakoutCLIN Breakout
Barter IslandXX01
OliktokXX02
Point BarrowXX03
Cape LisburneXX04
Cape NewenhamXX05
Cape RomanzofXX06
Cold BayXX07
Fort YukonXX08
Indian MountainXX09
King SalmonXX10
KotzebueXX11
Murphy DomeXX12
SparrevohnXX13
TatalinaXX14
Tin CityXX15
Maintenance Control and Communications Center (MC3)XX16
Regional Air Operations Center (RAOC)XX17
Program Headquarters (PHQ)XX18
Radio RelayXX19

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