Attachment_9_-_Excel_Price_Model.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Link-16 Alaska (LAK) Federal contract opportunity
Solicitation number
FA8574-19-R-0002
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center Robins Air Force Base

About this file

This document contains an Excel price model template and instructions for a draft request for proposal for Link-16 Alaska services. The template includes multiple contract line item numbers across basic and option periods for services such as program management, cybersecurity, help desk support, training, teardown and testing, repair, software distribution, production support, over and above work, block cycle changes, unscheduled maintenance, travel, and data services. Offerors are instructed to only fill in the highlighted cells with unit prices and amounts. The template also includes instructions for protecting cells and including the price model as an attachment to any proposal.

Excel Price Model

View the file

Other files for this federal contract opportunity

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

Instructions

Instructions/Recommendations
1Offerors are to only fill-in the cells colored in yellow.
2Spreadsheet can be modified to fit specific CLIN structure
3While a cost for Travel will be provided by the offeror, the cost is not included in the TEP calculation.
4It is recommended that the spreadsheet is protected and the offeror can only fill in the yellow colored cells.
5Cells can be locked by selecting the cells- right click and select Format Cells. Go to Protection and ensure the Locked box is checked.
6For fillable cells, right click and select Format Cells. Go to Protection and ensure the Locked box is unchecked.
7After cells are protected based on their function in the spreadsheet, go to the Review tab up top and click Protect Worksheet to apply a password.
8It is recommended that the Price Spreadsheet be included as an Attachment to the RFP.
9If you are having the contractor fill in Schedule B as well, it is recommended that the Price Spreadsheet take precedence over Schedule B in case of errors.

Example

Example Price Spreadsheet
Solicitation FA8574-19-R-0002
Offeror shall enter data in yellow highlighted fields only
Offeror:
BASIC
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
0001FFPProgram Management9MO$0$0
0002FFPCybersecurity9MO$0$0
0003FFPHelp Desk9MO$0$0
0004AAFFPTraining - System Administrative Training4WK$0$0
0004ABFFPTraining - User Familiarization6WK$0$0
0005FFPTeardown, Test and Evaluation (TT&E)10EA$0$0
0006FFPRepair10EATBN
0007FFPSoftware Distribution1LOTBN
0008FFPProduction6EA$0$0
0009CPFFOver and Above1LOTBN
0010FFPBlock Cycle Changes (BCC) - Task Description1LO$0$0
0010FFPBlock Cycle Changes (BCC)1LOTBN
0011CPFFBlock Cycle Changes (BCC)1LOTBN
0012FFPUnscheduled Maintenance4LO$0$0
0013CRNFTravel1LO$0$0
0014NSPData1LONSP
0015FFPTransition Period1LO$0$0
Total Amount - Basic$0
OPTION I
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
1001FFPProgram Management12MO$0$0
1002FFPCybersecurity12MO$0$0
1003FFPHelp Desk12MO$0$0
1004AAFFPTraining - System Administrative Training4WK$0$0
1004ABFFPTraining - User Familiarization6WK$0$0
1005FFPTeardown, Test and Evaluation (TT&E)10EA$0$0
1006FFPRepair10EATBN
1007FFPSoftware Distribution1LOTBN
1008FFPProduction6EA$0$0
1009CPFFOver and Above1LOTBN
1010FFPBlock Cycle Changes (BCC)1LOTBN
1011CPFFBlock Cycle Changes (BCC)1LOTBN
1012FFPUnscheduled Maintenance4LO$0$0
1013CRNFTravel1LO$0$0
1014NSPData1LONSP
Total Amount - Option I$0
OPTION II
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
2001FFPProgram Management12MO$0$0
2002FFPCybersecurity12MO$0$0
2003FFPHelp Desk12MO$0$0
2004AAFFPTraining - System Administrative Training4WK$0$0
2004ABFFPTraining - User Familiarization6WK$0$0
2005FFPTeardown, Test and Evaluation (TT&E)10EA$0$0
2006FFPRepair10EATBN
2007FFPSoftware Distribution1LOTBN
2008FFPProduction6EA$0$0
2009CPFFOver and Above1LOTBN
2010FFPBlock Cycle Changes (BCC)1LOTBN
2011CPFFBlock Cycle Changes (BCC)1LOTBN
2012FFPUnscheduled Maintenance4LO$0$0
2013CRNFTravel1LO$0$0
2014NSPData1LONSP
Total Amount - Option II$0
OPTION III
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
3001FFPProgram Management12MO$0$0
3002FFPCybersecurity12MO$0$0
3003FFPHelp Desk12MO$0$0
3004AAFFPTraining - System Administrative Training4WK$0$0
3004ABFFPTraining - User Familiarization6WK$0$0
3005FFPTeardown, Test and Evaluation (TT&E)10EA$0$0
3006FFPRepair10EATBN
3007FFPSoftware Distribution1LOTBN
3008FFPProduction6EA$0$0
3009CPFFOver and Above1LOTBN
3010FFPBlock Cycle Changes (BCC)1LOTBN
3011CPFFBlock Cycle Changes (BCC)1LOTBN
3012FFPUnscheduled Maintenance4LO$0$0
3013CRNFTravel1LO$0$0
3014NSPData1LONSP
Total Amount - Option III$0
OPTION IV
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
4001FFPProgram Management12MO$0$0
4002FFPCybersecurity12MO$0$0
4003FFPHelp Desk12MO$0$0
4004AAFFPTraining - System Administrative Training4WK$0$0
4004ABFFPTraining - User Familiarization6WK$0$0
4005FFPTeardown, Test and Evaluation (TT&E)10EA$0$0
4006FFPRepair10EATBN
4007FFPSoftware Distribution1LOTBN
4008FFPProduction6EA$0$0
4009CPFFOver and Above1LOTBN
4010FFPBlock Cycle Changes (BCC)1LOTBN
4011CPFFBlock Cycle Changes (BCC)1LOTBN
4012FFPUnscheduled Maintenance4LO$0$0
4013CRNFTravel1LO$0$0
4014NSPData1LONSP
Total Amount - Option IV$0
OPTION TO EXTEND SERVICES
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
5001FFPProgram Management6MO$0$0
5002FFPCybersecurity6MO$0$0
5003FFPHelp Desk6MO$0$0
5004AAFFPTraining - System Administrative Training2WK$0$0
5004ABFFPTraining - User Familiarization3WK$0$0
5005FFPTeardown, Test and Evaluation (TT&E)5EA$0$0
5006FFPRepair5EATBN
5007FFPSoftware Distribution1LOTBN
5008FFPProduction6EA$0$0
5009CPFFOver and Above1LOTBN
5010FFPBlock Cycle Changes (BCC)1LOTBN
5011CPFFBlock Cycle Changes (BCC)1LOTBN
5012FFPUnscheduled Maintenance2LO$0$0
5013CRNFTravel1LO$0$0
5014NSPData1LONSP
Total Amount - Option to Extend Services$0
Total Evaluated Price$0

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