Attachment 2 - Pricing Spreadsheet.xlsx
XLSX spreadsheet 51 KB Posted
- Attached to
- Robins AFB Airfield Management Operations Federal contract opportunity
- Solicitation number
- FA850125R0003
About this file
This is a pricing spreadsheet template for solicitation FA8501-25-R-0013 for Airfield Management Services at Robins AFB. The spreadsheet includes Contract Line Item Numbers (CLINs) for a base period and four option periods, plus a 6-month option to extend services period. Each period contains four primary FFP (Firm-Fixed-Price) CLINs covering: Airfield Management Operations Manager (AMOM), and three shifts of Airfield Management (day, swing, and mid shifts). The base period also includes NSP (Not Separately Priced) data CLINs for Mission Essential Plan and Safety Plan.
The spreadsheet provides instructions for offerors to input pricing data only in yellow-highlighted cells, with recommendations for spreadsheet protection and password settings. The template calculates a Total Evaluated Price that includes all periods except travel costs. The work covers 24/7 airfield management operations including inspections, maintenance management, flight planning, emergency response, and training at Robins AFB, Georgia, as part of a Department of the Air Force Materiel Command contract.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment 9 - Questions and Answers.pdf | ||
| Attachment 8 - Questions and Answers.pdf | ||
| Solicitation - FA850125R0003.pdf | ||
| Attachment 5 - Wage Determination 15-4495 (1).pdf | ||
| Attachment 7 - Appendix C Safety Plan.pdf | ||
| Attachment 1 - Performance Work Statement (PWS) (1).pdf | ||
| Attachment 3 - CBA June 1 2021.pdf | ||
| Attachment 4 - DD1423-2 CDRL.pdf | ||
| Attachment 6 - Quality Assurance Surveillance Plan (QASP).pdf |
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 | |
| 1 | Offerors are to only fill-in the cells colored in yellow. |
| 2 | Spreadsheet can be modified to fit specific CLIN structure |
| 3 | While a cost for Travel will be provided by the offeror, the cost is not included in the TEP calculation. |
| 4 | It is recommended that the spreadsheet is protected and the offeror can only fill in the yellow colored cells. |
| 5 | Cells can be locked by selecting the cells- right click and select Format Cells. Go to Protection and ensure the Locked box is checked. |
| 6 | For fillable cells, right click and select Format Cells. Go to Protection and ensure the Locked box is unchecked. |
| 7 | After 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. |
| 8 | It is recommended that the Price Spreadsheet be included as an Attachment to the RFP. |
| 9 | If 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-25-R-0013 | ||||||
| Offeror shall enter data in tan highlighted fields only | ||||||
| Offeror: | ||||||
| Basic | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 0001 | FFP | Airfield Mgt Oper Mgr (AMOM) | 1 | EA | $0 | $0 |
| 0002 | FFP | Airfield Management-Shift 1(day shift) | 1 | EA | $0 | $0 |
| 0003 | FFP | Airfield Management-Shift 2(swing shift) | 1 | EA | $0 | $0 |
| 0004 | FFP | Airfield Managment-Shift 3 (mid shift) | 1 | EA | $0 | $0 |
| 0005 | FFP | Data | NSP | |||
| 0005AA | FFP | Mission Essential Plan | 1 | LO | NSP | |
| 0005AB | FFP | Safety Plan | 1 | LO | NSP | |
| Total Amount Basic | $0 | |||||
| Option 1 | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 1001 | FFP | Airfield Mgt Oper Mgr (AMOM) | 1 | EA | $0 | $0 |
| 1002 | FFP | Airfield Management-Shift 1(day shift) | 1 | EA | $0 | $0 |
| 1003 | FFP | Airfield Management-Shift 2(swing shift) | 1 | EA | $0 | $0 |
| 1004 | FFP | Airfield Managment-Shift 3 (mid shift) | 1 | EA | $0 | $0 |
| Total Amount Option 1 | $0 | |||||
| Option 2 | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 2001 | FFP | Airfield Mgt Oper Mgr (AMOM) | 1 | EA | $0 | $0 |
| 2002 | FFP | Airfield Management-Shift 1(day shift) | 1 | EA | $0 | $0 |
| 2003 | FFP | Airfield Management-Shift 2(swing shift) | 1 | EA | $0 | $0 |
| 2004 | FFP | Airfield Managment-Shift 3 (mid shift) | 1 | EA | $0 | $0 |
| Total Amount Option 2 | $0 | |||||
| Option 3 | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 3001 | FFP | Airfield Mgt Oper Mgr (AMOM) | 1 | EA | $0 | $0 |
| 3002 | FFP | Airfield Management-Shift 1(day shift) | 1 | EA | $0 | $0 |
| 3003 | FFP | Airfield Management-Shift 2(swing shift) | 1 | EA | $0 | $0 |
| 3004 | FFP | Airfield Managment-Shift 3 (mid shift) | 1 | EA | $0 | $0 |
| Total Amount Option 3 | $0 | |||||
| Option 4 | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 4001 | FFP | Airfield Mgt Oper Mgr (AMOM) | 1 | EA | $0 | $0 |
| 4002 | FFP | Airfield Management-Shift 1(day shift) | 1 | EA | $0 | $0 |
| 4003 | FFP | Airfield Management-Shift 2(swing shift) | 1 | EA | $0 | $0 |
| 4004 | FFP | Airfield Managment-Shift 3 (mid shift) | 1 | EA | $0 | $0 |
| Total Amount Option 4 | $0 | |||||
| Option to Extend Services | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 5001 | Option to Extend Services | - | - | - | - | |
| 5001AA** | FFP | Airfield Mgt Oper Mgr (AMOM) | 1 | EA | $0 | $0 |
| 5001AB | CRNF | Airfield Management-Shift 1(day shift) | 1 | EA | $0 | $0 |
| 5001AC | FFP | Airfield Management-Shift 2(swing shift) | 1 | EA | $0 | $0 |
| 5001AD | FFP | Airfield Managment-Shift 3 (mid shift) | 1 | EA | $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. Updated .