52.212-1 Attachment 5 CLIN Spreadsheet.xlsx

XLSX spreadsheet 43 KB Posted

Attached to
ACC Human Resources/Military Flight Personnel Support Services Federal contract opportunity
Solicitation number
FA489023R0032
Issued by
Department of the Air Force Air Combat Command

View the file

Other files for this federal contract opportunity

Other files attached to ACC Human Resources/Military Flight Personnel Support Services, newest first.
File Type Posted
QandA HRMPF 27 June 2023.pdf PDF
Solicitation Amendment FA489023R00320004 SF 30.pdf PDF
QandA HRMPF 26 June 2023.pdf PDF
Solicitation Amendment FA489023R00320003 SF 30.pdf PDF
QnA HRMPF 21 June 2023.xlsx XLSX spreadsheet
52.212-1 Attachment 5 CLIN Spreadsheet rev1.xlsx XLSX spreadsheet
QandA HRMPF 15 June 2023.pdf PDF
52.212-1 Attachment 3 PPQ rev1.docx DOCX document
Solicitation Amendment FA489023R00320002 SF 30.pdf PDF
HR MPF PWS FINAL Amendment 01 Track Changes.docx DOCX document
FA489023R0032 Draft DD254.pdf PDF
QandA HRMPF 06 Jun 23 - Amendment 01.pdf PDF
HR MPF PWS FINAL Amendment 01 Accepted Changes.pdf PDF
Solicitation Amendment FA489023R00320001 SF 30.pdf PDF
52.212-2 Addendum Evaluation.pdf PDF
52.212-1 Attachment 3 PPQ.docx DOCX document
PWS FA489023R0032 April 2023.pdf PDF
WD 2015-4439 Shaw AFB SC.pdf PDF
52.212-1 Addendum - Instructions to Offerors.pdf PDF
Solicitation - FA489023R0032.pdf PDF
WD 2015-5593 Nellis AFB NV.pdf PDF
WD 2015-5513 Mountain Home ID.pdf PDF
WD 2015-4341 Joint Base Langley-Eustis VA.pdf PDF
WD 2015-4379 Seymour Johnson AFB NC.pdf PDF
WD 2015-5473 Davis Monthan AFB AZ.pdf PDF
WD 2015-4493 Moody AFB GA.pdf PDF
52.212-1 Attachment 1 Q&A Submittal.xlsx XLSX spreadsheet
52.212-1 Attachment 4 Subcontracting Consent Letter.docx DOCX document
52.212-1 Attachment 2 Past Performace Information.docx DOCX document
Show all 29

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
Try for free Login

Text version

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

Instructions

Instructions

1. Offerors are requied to use this spreadsheet to propose CLIN pricing and calcuate Total Evaluated Price. Please input all unit costs in sheets 2-6, all others totals will populate, to inlcude the Smmay/Total Evaluated Price Sheet It is the offeror's responsibility to ensure all calculations and formulas are correct. If errors are found within the form, please make your Contracting Officer aware once discovered. DO NOT ADJUST ANY GOVERNMENT PROVIDED VALUES.

2. Please ensure all supporting price backup data requested IAW the RFP is provided in your pricing volume.

3. This worksheet shall be incorporated into the resulting contract award

MPF Base Year ITEM NO Human Resources (HR)/Military Personnel Flight (MPF) QTY UNIT UNIT PRICE TOTAL PRICE

TRANSITION Period of Performance: 1 November 2023- 30 November 2023
BASE YEAR Period of Performance: 1 December 2023-31 November 2024

0001 DAVIS-MONTHAN AFB, AZ Base Year – Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 11 MO $ - $ -

0002 LANGLEY AFB, VA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 11 MO $ - $ -

0003 MOODY AFB, GA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 11 MO $ - $ -

0004 MOUNTAIN HOME AFB, ID Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 11 MO $ - $ -

0005 NELLIS AFB, NV Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 11 MO $ - $ -

0006 SEYMOUR JOHNSON AFB, NC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 11 MO $ - $ -

0007 SHAW AFB, SC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 11 MO $ - $ -

0008 MPF SURGE* MPF Surge Capabilities required IAW MPF PWS para 6.2 1 LOT NTE $ 10,000 $ 10,000

0009 TRAVEL* Travel Periodic travel IAW the PWS para 7.8.2. The Government will only reimburse Government directed travel and allowable costs in accordance with FAR 1 LOT NTE $ 3,000 $ 3,000

0010 Transition CLIN Transition In IAW PWS para 7.13 FFP-LOE 1 MO $ - $ -

0011 DAVIS-MONTHAN AFB, AZ Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 11 MO $ - $ -

0012 LANGLEY AFB, VA Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 11 MO $ - $ -

0013 NELLIS AFB, NV Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 11 MO $ - $ -

0014 SEYMOUR JOHNSON AFB Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 11 MO $ - $ -

0015 SHAW AFB, SC Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 11 MO $ - $ -

BASE YEAR TOTAL: $ 13,000

FFP LOE= FIRM FIXED PRICE Level of Effort
MO = MONTH
NTE=NOT TO EXCEED

MPF Option Year 1 ITEM NO Human Resources (HR)/Military Personnel Flight (MPF) QTY UNIT UNIT PRICE TOTAL PRICE

OPTION YEAR ONE (1) Period of Performance: 1 November 2024-31 October 2025

1001 DAVIS-MONTHAN AFB, AZ Base Year – Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

1002 LANGLEY AFB, VA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

1003 MOODY AFB, GA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

1004 MOUNTAIN HOME AFB, ID Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

1005 NELLIS AFB, NV Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

1006 SEYMOUR JOHNSON AFB, NC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

1007 SHAW AFB, SC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

1008 MPF SURGE* MPF Surge Capabilities required IAW MPF PWS para 6.2 1 LOT NTE $ 10,000 $ 10,000

1009 TRAVEL* Travel Periodic travel IAW the PWS para 7.8.2. The Government will only reimburse Government directed travel and allowable costs in accordance with FAR 1 LOT NTE $ 3,000 $ 3,000

1010 DAVIS-MONTHAN AFB, AZ Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

1011 LANGLEY AFB, VA Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

1012 NELLIS AFB, NV Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

1013 SEYMOUR JOHNSON AFB Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

1014 SHAW AFB, SC Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

OPTION ONE (1) YEAR TOTAL: $ 13,000

FFP LOE= FIRM FIXED PRICE Level of Effort
MO = MONTH
NTE=NOT TO EXCEED

MPF Option Year 2 ITEM NO Human Resources (HR)/Military Personnel Flight (MPF) QTY UNIT UNIT PRICE TOTAL PRICE

OPTION YEAR TWO (2) Period of Performance: 1 November 2025-31 October 2026

2001 DAVIS-MONTHAN AFB, AZ Base Year – Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

2002 LANGLEY AFB, VA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

2003 MOODY AFB, GA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

2004 MOUNTAIN HOME AFB, ID Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

2005 NELLIS AFB, NV Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

2006 SEYMOUR JOHNSON AFB, NC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

2007 SHAW AFB, SC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

2008 MPF SURGE* MPF Surge Capabilities required IAW MPF PWS para 6.2 1 LOT NTE $ 10,000 $ 10,000

2009 TRAVEL* Travel Periodic travel IAW the PWS para 7.8.2. The Government will only reimburse Government directed travel and allowable costs in accordance with FAR 1 LOT NTE $ 3,000 $ 3,000

2010 DAVIS-MONTHAN AFB, AZ Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

2011 LANGLEY AFB, VA Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

2012 NELLIS AFB, NV Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

2013 SEYMOUR JOHNSON AFB Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

2014 SHAW AFB, SC Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

OPTION TWO (2) YEAR TOTAL: $ 13,000

FFP LOE= FIRM FIXED PRICE Level of Effort
MO = MONTH
NTE=NOT TO EXCEED

MPF Option Year 3 ITEM NO Human Resources (HR)/Military Personnel Flight (MPF) QTY UNIT UNIT PRICE TOTAL PRICE

OPTION YEAR THREE (3) Period of Performance: 1 November 2026-31 October 2027

3001 DAVIS-MONTHAN AFB, AZ Base Year – Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

3002 LANGLEY AFB, VA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

3003 MOODY AFB, GA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

3004 MOUNTAIN HOME AFB, ID Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

3005 NELLIS AFB, NV Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

3006 SEYMOUR JOHNSON AFB, NC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

3007 SHAW AFB, SC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

3008 MPF SURGE* MPF Surge Capabilities required IAW MPF PWS para 6.2 1 LOT NTE $ 10,000 $ 10,000

3009 TRAVEL* Travel Periodic travel IAW the PWS para 7.8.2. The Government will only reimburse Government directed travel and allowable costs in accordance with FAR 1 LOT NTE $ 3,000 $ 3,000

3010 DAVIS-MONTHAN AFB, AZ Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

3011 LANGLEY AFB, VA Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

3012 NELLIS AFB, NV Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

3013 SEYMOUR JOHNSON AFB Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

3014 SHAW AFB, SC Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

OPTION THREE (3) YEAR TOTAL: $ 13,000

FFP LOE= FIRM FIXED PRICE Level of Effort
MO = MONTH
NTE=NOT TO EXCEED

MPF Option Year 4 ITEM NO Human Resources (HR)/Military Personnel Flight (MPF) QTY UNIT UNIT PRICE TOTAL PRICE

OPTION YEAR FOUR (4) Period of Performance: 1 November 2027-31 October 2028
O
4001DAVIS-MONTHAN AFB, AZ Base Year – Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE12MO$ -$ -

4002 LANGLEY AFB, VA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

4003 MOODY AFB, GA Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

4004 MOUNTAIN HOME AFB, ID Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

4005 NELLIS AFB, NV Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

4006 SEYMOUR JOHNSON AFB, NC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

4007 SHAW AFB, SC Base Year - Performance required IAW Performance Work Statement; Customer Service, Awards and Decorations, Cyber Security Liaison, and Personnel Systems Management for the Military Personnel Flight (MPF) and Civilian Personnel Flight (CPF). FFP-LOE 12 MO $ - $ -

4008 MPF SURGE* MPF Surge Capabilities required IAW MPF PWS para 6.2 1 LOT NTE $ 10,000 $ 10,000

4009 TRAVEL* Travel Periodic travel IAW the PWS para 7.8.2. The Government will only reimburse Government directed travel and allowable costs in accordance with FAR 1 LOT NTE $ 3,000 $ 3,000

4010 DAVIS-MONTHAN AFB, AZ Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

4011 LANGLEY AFB, VA Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

4012 NELLIS AFB, NV Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

4013 SEYMOUR JOHNSON AFB Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

4014 SHAW AFB, SC Optional FTE for Personnel Computer Support Tech/Cyber Liaison FFP-LOE 12 MO $ - $ -

OPTION FOUR (4) YEAR TOTAL: $ 13,000

FFP LOE= FIRM FIXED PRICE Level of Effort
MO = MONTH
NTE=NOT TO EXCEED

Summary -Total Evaluated Price

***Offerors should not have to edit this page, all numbers should carry over from sheets 2 - 6***
SUMMARY/TOTAL EVALUATED PRICE
Base YearOption Year 1Option Year 2Option Year 3Option Year 46 Month Option
CLINProposal AmountCLINProposal AmountCLINProposal AmountCLINProposal AmountCLINProposal AmountCLINProposal Amount
0001$ -1001$ -2001$ -3001$ -4001$ -5001$ -0
0002$ -1002$ -2002$ -3002$ -4002$ -5002$ -0
0003$ -1003$ -2003$ -3003$ -4003$ -5003$ -0
0004$ -1004$ -2004$ -3004$ -4004$ -5004$ -0
0005$ -1005$ -2005$ -3005$ -4005$ -5005$ -0
0006$ -1006$ -2006$ -3006$ -4006$ -5006$ -0
0007$ -1007$ -2007$ -3007$ -4007$ -5007$ -0
0008$ 10,0001008$ 10,0002008$ 10,0003008$ 10,0004008$ 10,0005008$ 5,000.0
0009$ 3,0001009$ 3,0002009$ 3,0003009$ 3,0004009$ 3,0005009$ 1,500.0
0010$ -1010$ -2010$ -3010$ -4010$ -5010$ -0
0011$ -1011$ -2011$ -3011$ -4011$ -5011$ -0
0012$ -1012$ -2012$ -3012$ -4012$ -5012$ -0
0013$ -1013$ -2013$ -3013$ -4013$ -5013$ -0TOTAL EVALUATED PRICE
0014$ -1014$ -2014$ -3014$ -4014$ -5014$ -0
0015$ -
TOTAL$ 13,000$ 13,000$ 13,000$ 13,000$ 13,000$ 6,500.0$ 71,500

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