Attachment_9_-_Excel_Price_Model.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Link-16 Alaska Federal contract opportunity
- Solicitation number
- FA8574-19-R-0002
About this file
This document contains an Excel price model template and information on a related federal contract opportunity. The Excel price model template provides instructions and recommendations for offerors to fill in pricing information for various contract line item numbers (CLINs). It includes CLIN structures for a basic period of performance and four option periods, with pricing arrangements of firm-fixed price, cost-plus-fixed-fee, and cost reimbursable no fee.
The related federal contract opportunity is a solicitation to provide contractor logistics support services for the Link-16 Alaska system. Services include program management, cybersecurity, help desk, training, teardown and testing, repair, software distribution, production, block cycle changes, unscheduled maintenance, shipping, and travel. The requirement is for a five-year IDIQ contract with a basic 12-month period of performance and four 12-month option periods. The pricing arrangement is a mixture of firm-fixed price, cost-plus-fixed-fee, and cost reimbursable no fee. The solicitation is expected to be issued on March 22, 2019 by the Air Force Life Cycle Management Center.
Attachment 9 - Excel Price Model
View the file
Other files for this federal contract opportunity
Show all 31
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
| Example Price Spreadsheet | ||||||
| Solicitation FA8574-19-R-0002 | ||||||
| Offeror shall enter data in yellow highlighted fields only | ||||||
| Offeror: | ||||||
| BASIC | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 0001 | FFP | Program Management | 9 | MO | $0 | $0 |
| 0002 | FFP | Cybersecurity | 9 | MO | $0 | $0 |
| 0003 | FFP | Help Desk | 9 | MO | $0 | $0 |
| 0004AA | FFP | Training - System Administrative Training | 4 | EA | $0 | $0 |
| 0004AB | FFP | Training - Operator Fam | 4 | EA | $0 | $0 |
| 0004AC | FFP | Training, Maintainer Fam | 4 | EA | $0 | $0 |
| 0005 | FFP | Teardown, Test and Evaluation (TT&E) | 10 | EA | $0 | $0 |
| 0006 | FFP | Repair | 10 | EA | TBN | |
| 0007 | FFP | Software Distribution | 1 | LO | TBN | |
| 0008 | FFP | Reserved | 1 | LO | TBN | |
| 0009 | CPFF | Over and Above | 1 | LO | TBN | |
| 0010 | FFP | Block Cycle Changes (BCC) - Task Description | 1 | LO | $0 | $0 |
| 0010 | FFP | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 0011 | CPFF | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 0012 | FFP | Unscheduled Maintenance | 4 | LO | $0 | $0 |
| 0013 | CRNF | Travel | 1 | LO | $400,000 | $400,000 |
| 0014 | NSP | Data | 1 | LO | NSP | |
| 0015 | FFP | Transition Period | 1 | LO | $0 | $0 |
| Total Amount - Basic | $400,000 | |||||
| OPTION I | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 1001 | FFP | Program Management | 12 | MO | $0 | $0 |
| 1002 | FFP | Cybersecurity | 12 | MO | $0 | $0 |
| 1003 | FFP | Help Desk | 12 | MO | $0 | $0 |
| 1004AA | FFP | Training - System Administrative Training | 4 | EA | $0 | $0 |
| 1004AB | FFP | Training - Operator Fam | 4 | EA | $0 | $0 |
| 1004AC | FFP | Training, Maintainer Fam | 4 | EA | $0 | $0 |
| 1005 | FFP | Teardown, Test and Evaluation (TT&E) | 10 | EA | $0 | $0 |
| 1006 | FFP | Repair | 10 | EA | TBN | |
| 1007 | FFP | Software Distribution | 1 | LO | TBN | |
| 1008 | FFP | Reserved | 1 | LO | TBN | |
| 1009 | CPFF | Over and Above | 1 | LO | TBN | |
| 1010 | FFP | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 1011 | CPFF | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 1012 | FFP | Unscheduled Maintenance | 4 | LO | $0 | $0 |
| 1013 | CRNF | Travel | 1 | LO | $400,000 | $400,000 |
| 1014 | NSP | Data | 1 | LO | NSP | |
| Total Amount - Option I | $400,000 | |||||
| OPTION II | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 2001 | FFP | Program Management | 12 | MO | $0 | $0 |
| 2002 | FFP | Cybersecurity | 12 | MO | $0 | $0 |
| 2003 | FFP | Help Desk | 12 | MO | $0 | $0 |
| 2004AA | FFP | Training - System Administrative Training | 4 | EA | $0 | $0 |
| 2004AB | FFP | Training - Operator Fam | 4 | EA | $0 | $0 |
| 2004AC | FFP | Training, Maintainer Fam | 4 | EA | $0 | $0 |
| 2005 | FFP | Teardown, Test and Evaluation (TT&E) | 10 | EA | $0 | $0 |
| 2006 | FFP | Repair | 10 | EA | TBN | |
| 2007 | FFP | Software Distribution | 1 | LO | TBN | |
| 2008 | FFP | Reserved | 1 | LO | TBN | |
| 2009 | CPFF | Over and Above | 1 | LO | TBN | |
| 2010 | FFP | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 2011 | CPFF | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 2012 | FFP | Unscheduled Maintenance | 4 | LO | $0 | $0 |
| 2013 | CRNF | Travel | 1 | LO | $400,000 | $400,000 |
| 2014 | NSP | Data | 1 | LO | NSP | |
| Total Amount - Option II | $400,000 | |||||
| OPTION III | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 3001 | FFP | Program Management | 12 | MO | $0 | $0 |
| 3002 | FFP | Cybersecurity | 12 | MO | $0 | $0 |
| 3003 | FFP | Help Desk | 12 | MO | $0 | $0 |
| 3004AA | FFP | Training - System Administrative Training | 4 | EA | $0 | $0 |
| 3004AB | FFP | Training - Operator Fam | 4 | EA | $0 | $0 |
| 3004AC | FFP | Training, Maintainer Fam | 4 | EA | $0 | $0 |
| 3005 | FFP | Teardown, Test and Evaluation (TT&E) | 10 | EA | $0 | $0 |
| 3006 | FFP | Repair | 10 | EA | TBN | |
| 3007 | FFP | Software Distribution | 1 | LO | TBN | |
| 3008 | FFP | Reserved | 1 | LO | TBN | |
| 3009 | CPFF | Over and Above | 1 | LO | TBN | |
| 3010 | FFP | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 3011 | CPFF | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 3012 | FFP | Unscheduled Maintenance | 4 | LO | $0 | $0 |
| 3013 | CRNF | Travel | 1 | LO | $400,000 | $400,000 |
| 3014 | NSP | Data | 1 | LO | NSP | |
| Total Amount - Option III | $400,000 | |||||
| OPTION IV | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 4001 | FFP | Program Management | 12 | MO | $0 | $0 |
| 4002 | FFP | Cybersecurity | 12 | MO | $0 | $0 |
| 4003 | FFP | Help Desk | 12 | MO | $0 | $0 |
| 4004AA | FFP | Training - System Administrative Training | 4 | EA | $0 | $0 |
| 4004AB | FFP | Training - Operator Fam | 4 | EA | $0 | $0 |
| 4004AC | FFP | Training, Maintainer Fam | 4 | EA | $0 | $0 |
| 4005 | FFP | Teardown, Test and Evaluation (TT&E) | 10 | EA | $0 | $0 |
| 4006 | FFP | Repair | 10 | EA | TBN | |
| 4007 | FFP | Software Distribution | 1 | LO | TBN | |
| 4008 | FFP | Reserved | 1 | LO | TBN | |
| 4009 | CPFF | Over and Above | 1 | LO | TBN | |
| 4010 | FFP | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 4011 | CPFF | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 4012 | FFP | Unscheduled Maintenance | 4 | LO | $0 | $0 |
| 4013 | CRNF | Travel | 1 | LO | $400,000 | $400,000 |
| 4014 | NSP | Data | 1 | LO | NSP | |
| Total Amount - Option IV | $400,000 | |||||
| OPTION TO EXTEND SERVICES | ||||||
| CLIN | Contract Type | Description | Qty | U/I | Unit Price | Amount |
| 5001 | FFP | Program Management | 6 | MO | $0 | $0 |
| 5002 | FFP | Cybersecurity | 6 | MO | $0 | $0 |
| 5003 | FFP | Help Desk | 6 | MO | $0 | $0 |
| 5004AA | FFP | Training - System Administrative Training | 2 | EA | $0 | $0 |
| 5004AB | FFP | Training - Operator Fam | 2 | EA | $0 | $0 |
| 5004AC | FFP | Training, Maintainer Fam | 2 | EA | $0 | $0 |
| 5005 | FFP | Teardown, Test and Evaluation (TT&E) | 5 | EA | $0 | $0 |
| 5006 | FFP | Repair | 5 | EA | TBN | |
| 5007 | FFP | Software Distribution | 1 | LO | TBN | |
| 5008 | FFP | Reserved | 1 | LO | TBN | |
| 5009 | CPFF | Over and Above | 1 | LO | TBN | |
| 5010 | FFP | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 5011 | CPFF | Block Cycle Changes (BCC) | 1 | LO | TBN | |
| 5012 | FFP | Unscheduled Maintenance | 2 | LO | $0 | $0 |
| 5013 | CRNF | Travel | 1 | LO | $200,000 | $200,000 |
| 5014 | NSP | Data | 1 | LO | NSP | |
| Total Amount - Option to Extend Services | $200,000 | |||||
| Total Evaluated Price | $2,200,000 |
File details come from the government source that posted it. Updated .