Attachment 5 - LAFB Tree Removal Price Template.xlsx

XLSX spreadsheet 44 KB Posted

Attached to
Laughlin AFB Tree Removal Blanket Purchase Agreement
Solicitation number
FA3099-23-Q-0001
Issued by

View the file

Other files

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

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

Attachment 5: LAFB Tree Removal Price Template
Solicitation FA3099-23-Q-0001
Offeror shall enter data in tan highlighted fields only
Offeror:
Basic
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
0001FFPRemove Small Tree/Restore Site (less than or equal to 12” in diameter)1Each$0
0002FFPRemove Med Tree/Restore Site (less than or equal to 24” in diameter)1Each$0
0003FFPRemove Large Tree/Restore Site (less than or equal to 36” in diameter)1Each$0
$0
Total Amount Basic$0
Option 1
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
1001FFPRemove Small Tree/Restore Site (less than or equal to 12” in diameter)1Each$0
1002FFPRemove Med Tree/Restore Site (less than or equal to 24” in diameter)1Each$0
1003FFPRemove Large Tree/Restore Site (less than or equal to 36” in diameter)1Each$0
$0
Total Amount Option 1$0
Option 2
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
2001FFPRemove Small Tree/Restore Site (less than or equal to 12” in diameter)1Each$0
2002FFPRemove Med Tree/Restore Site (less than or equal to 24” in diameter)1Each$0
2003FFPRemove Large Tree/Restore Site (less than or equal to 36” in diameter)1Each$0
$0
Total Amount Option 2$0
Option 3
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
3001FFPRemove Small Tree/Restore Site (less than or equal to 12” in diameter)1Each$0
3002FFPRemove Med Tree/Restore Site (less than or equal to 24” in diameter)1Each$0
3003FFPRemove Large Tree/Restore Site (less than or equal to 36” in diameter)1Each$0
$0
Total Amount Option 3$0
Option 4
CLINContract TypeDescriptionQtyU/IUnit PriceAmount
4001FFPRemove Small Tree/Restore Site (less than or equal to 12” in diameter)1Each$0
4002FFPRemove Med Tree/Restore Site (less than or equal to 24” in diameter)1Each$0
4003FFPRemove Large Tree/Restore Site (less than or equal to 36” in diameter)1Each$0
$0
Total Amount Option 4$0

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