Attachment_5_-_Pricing_Spreadsheet.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
Airfield Management Services Federal contract opportunity
Solicitation number
FA8501-19-R-A002
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center Robins Air Force Base

About this file

Attachment 5 Pricing Spreadsheet

View the file

Other files for this federal contract opportunity

Show all 22

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

Price Spreadsheet
Solicitation FA8501-19-R-A002
Offeror shall enter data in tan highlighted fields only
Offeror:
Basic
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
0001FFPAirfield Mgt Oper Mgr (AMOM)1EA$0$0
0002FFPAirfield Management-Shift 1(day shift)1EA$0$0
0003FFPAirfield Management-Shift 2(swing shift)1EA$0$0
0004FFPAirfield Managment-Shift 3 (mid shift)1EA$0$0
0005FFPDataNSP
0005AAFFPMission Essential Plan1LONSP
0005ABFFPSafety Plan1LONSP
Total Amount Basic$0
Option 1
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
1001FFPAirfield Mgt Oper Mgr (AMOM)1EA$0$0
1002FFPAirfield Management-Shift 1(day shift)1EA$0$0
1003FFPAirfield Management-Shift 2(swing shift)1EA$0$0
1004FFPAirfield Managment-Shift 3 (mid shift)1EA$0$0
Total Amount Option 1$0
Option 2
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
2001FFPAirfield Mgt Oper Mgr (AMOM)1EA$0$0
2002FFPAirfield Management-Shift 1(day shift)1EA$0$0
2003FFPAirfield Management-Shift 2(swing shift)1EA$0$0
2004FFPAirfield Managment-Shift 3 (mid shift)1EA$0$0
Total Amount Option 2$0
Option 3
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
3001FFPAirfield Mgt Oper Mgr (AMOM)1EA$0$0
3002FFPAirfield Management-Shift 1(day shift)1EA$0$0
3003FFPAirfield Management-Shift 2(swing shift)1EA$0$0
3004FFPAirfield Managment-Shift 3 (mid shift)1EA$0$0
Total Amount Option 3$0
Option 4
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
4001FFPAirfield Mgt Oper Mgr (AMOM)1EA$0$0
4002FFPAirfield Management-Shift 1(day shift)1EA$0$0
4003FFPAirfield Management-Shift 2(swing shift)1EA$0$0
4004FFPAirfield Managment-Shift 3 (mid shift)1EA$0$0
Total Amount Option 4$0
Option to Extend Services
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
5001Option to Extend Services----
5001AA**FFPAirfield Mgt Oper Mgr (AMOM)1EA$0$0
5001ABCRNFAirfield Management-Shift 1(day shift)1EA$0$0
5001ACFFPAirfield Management-Shift 2(swing shift)1EA$0$0
5001ADFFPAirfield Managment-Shift 3 (mid shift)1EA$0$0
Total Amount Option to Extend Services$0
Total Evaluated Price$0
** CLIN 5001AA will be calculated by using the offeror's proposed "Unit Price" for CLIN 4001 multiplied by 1/2 the Qty.

File details come from the government source that posted it.