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 a price model template and related federal contract opportunity notice. The price model template provides instructions and an example for offerors to fill in unit prices, quantities, and amounts for various contract line item numbers (CLINs) under the Link-16 Alaska contractor logistics support requirement. This is a five-year indefinite delivery, indefinite quantity contract with one 12-month basic period and four 12-month option periods, as well as a six-month option to extend services. Pricing includes firm-fixed-price, cost-plus-fixed-fee, and cost-reimbursable no-fee arrangements. The federal contract opportunity notice seeks proposals due on or around March 22, 2019 to provide program management, cybersecurity, help desk support, training, equipment teardown and testing, repair, software distribution, production, block changes, maintenance, travel, and data services for the Link-16 Alaska system through this IDIQ vehicle. The North American Industry Classification System code is 541330 for engineering services.
Excel Price Model - Updated
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 | Production | 6 | EA | $0 | $0 |
| 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 | Production | 6 | EA | $0 | $0 |
| 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 | Production | 6 | EA | $0 | $0 |
| 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 | Production | 6 | EA | $0 | $0 |
| 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 | Production | 6 | EA | $0 | $0 |
| 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 | Production | 6 | EA | $0 | $0 |
| 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 .