Section J Attachment 5 Pricing Matrix dated 18 MAR 2021 (Locked Formulas).xlsx
XLSX spreadsheet 75 KB Posted
- Solicitation number
- FA8630-20-R-4000
View the file
Other files
Show all 13
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 To Offerors
| INSTRUCTIONS TO OFFERORS |
| The offeror shall submit a proposal which contains prices for all contract line items listed in the attached worksheets. Of the ten total worksheets available in this workbook, only the following six worksheets require input from the offeror: "5-Year Base Period", "Option Year 1", "Option Year 2", "Option Year 3", "Option Year 4", and "Option Year 5". Each worksheet contains specific instructions and help text to guide the offeror in providing Prices that meet the requirements of the solicitation. All fields requiring offeror input are highlighted in yellow. No other fields may be modified. Do not unlock or otherwise modify any cells, rows, columns, worksheets, code, or structure of this workbook in any way. If assistance is required by the offeror to import data into its own estimating models, offerors shall contact the Contracting Officer. |
Once those fields are completed, they will turn white. Pricing Matrices submitted by an offeror with incomplete (yellow) fields will not be accepted. Fields with blue text indicate estimated quantities provided by the United States Government (USG). Estimates represent historical quantities and are NOT indicative of future workload. These will only be used as a basis for proposal evaluation since exact future quantities are highly variable and cannot be known.
| Fill Prices will encompass the total overall cost for the contractor to perform on this contract. The CLIN X001, X002, 0003, X005 Fill Prices must include but not be limited to, prime contractor labor, fringe benefits, overhead, general and administrative, vendor and subcontractor management, transition phase-in costs, mandatory travel requirement at PWS 2.1.4 Meetings and Reviews, data, and prime contractor PC&H costs and storage costs (except unscheduled maintenance and those costs approved in advance by the Government on a case by case basis, which will be included in CLIN X006). The CLIN X001, X002, 0003, X005 Fill Prices must also include but not be limited to all information technology activities, development, testing, implementation, interface changes, and upgrades. |
| The cells contained in the subsequent worksheets correspond to each priced CLIN or SubCLIN in Section B of the contract. The pricing matrix is the official document for all fill Prices. Do not record prices in Section B of the contract. Pricing should only be entered in the pricing matrix. Any future changes to fill Prices will require a revised pricing matrix. Once the offeror has provided all required pricing in this workbook, their Total Evaluated Price (TEP) for the purposes of the proposal evaluation will be shown in the TEP worksheet. |
| For questions on this Attachment, please contact the PROS VI Contracting Officer using the information provided in this solicitation. |
TEP
| Total Evaluated Price (TEP) |
| This worksheet is intended to provide the offeror with their Total Evaluated Price (TEP), which is displayed in Cell G and H14 below. No input is required by the offeror in this worksheet. The worksheet will automatically calculate based upon the Fill Fees and Service Fees that are entered for the 5 Year Base Period and the five Option Years. Additionally, each offeror's fee totals will be added together with estimated values for items including Travel, Material/Maintenance Pass Through Costs, Data, the Objective Performance Incentive, and Over and Above requirements. All offerors have these same values applied to their TEP. The TEP may not equate with the estimated contract value. |
| CLIN | ||
| Chris Hoff: Contract Line Item (CLIN) corresponding to the contract | Service Type | |
| Chris Hoff: Represents Service Types that can generate Fees for the PROS contractor. No input required. | Estimated Extended Price |
Chris Hoff: Sum of the service fee values from Base and all options, as well as placeholder values we provide for travel, task orders, etc.
| 0001-5001 | Fill Fee | $ - 0 | |
| 0002-5002 | Cancellation Fee | $ - 0 | |
| 0003-5003 | Task Orders | $ 10,000,000 | |
| 0004-5004 | Travel Expenses | $ 100,000 | |
| 0005-5005 | Research / Price and Availability Fee | $ - 0 | |
| 0006-5006 | Estimated Material / Maintenance Pass Thru Cost | $ 4,538,845,312 | |
| 0007-5007 | Data | NSP | |
| 0008-5008 | Objective Performance Incentive | $ 16,200,000 | |
| 0009-5009 | Over and Above | $ 1,000,000 | |
| OFFEROR'S TOTAL EVALUATED PRICE = | $ 4,566,145,312 |
5 Year Base Period
| BASIC CONTRACT (Period of Performance: Date of Award thru 5 Years) |
| Worksheet Instructions: This worksheet is intended to capture Fill Prices for the Base Contract Period only (5 years). In the first table below, the offeror shall enter a Fill Price in whole dollars for each Requisition Value range (ex. $0.00 - $3,500) for each Requisition Type (ex. Supply) down the column. The offeror must provide a Fill Price for each Requisition Value range and Requisition Type, even if there are zero estimated requisitions in the Estimated Quantity cell. The worksheet will calculate the Extended Price by multiplying the offeror's Fill Price by the Estimated Quanity provided by the USG. In the second table below, the offeror shall enter a Price in whole dollars for services to be provided on the contract. These prices are separate from the Fill Prices. The worksheet will calculate the Extended Price based on the Prices entered by the offeror. All fields requiring offeror input are highlighted in Yellow. Values entered by the offeror will be contractually binding. No other input is required. The offeror shall not unlock or modify any part of the worksheet or underlying code. Help text is available by hovering the mouse pointer over a cell with an embedded Comment (noted by a red triangle in the top right cell corner). For further assistance, please contact the PROS VI Contracting Officer listed in the solicitation. |
| Quantities below are for proposal evaluation purposes only. |
Actual quantities are highly variable and cannot be reliably predicted.
| CLIN | |
| Chris Hoff: Contract Line Item (CLIN) corresponding to the contract. | Requisition Type |
| Chris Hoff: There are 4 requisition types - Supply, Maintenance, Supply Cancellations, and Maintenance Cancellations. A requisition value range is provided for each. No input is required in this column. | Fill Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Fill Fee for each Requisition Value Range. Enter in whole dollars only. | Est. Requisition Qty |
Chris Hoff: These are requisition quantities for each dollar range estimated using historical data. No input is required.
Estimated Extended Price Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required.
| 0001AA | Supply Requisition Value: | ||
| $ 0.00 - $ 3,500.00 | 49,535 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 22,458 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 1,897 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 314 | $0 | |
| $2,000,000.01 & up | 9 | $0 | |
| SubCLIN Total | 74,213 |
Chris Hoff: Sum of the Estimated Quantities above.
$0 Chris Hoff: Sum of the Amounts listed above.
| 0001AB | Maintenance Requisition Value | ||
| $ 0.00 - $ 3,500.00 | 19,298 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 15,826 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 525 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 89 | $0 | |
| $2,000,000.01 & up | 9 | $0 | |
| SubCLIN Total | 35,747 | $0 |
| 0002AA | Supply Cancellation | ||
| $ 0.00 - $ 3,500.00 | 30,525 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 13,876 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 1,169 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 207 | $0 | |
| $2,000,000.01 & up | 9 | $0 | |
| SubCLIN Total | 45,786 | $0 |
| 0002AB | Maintenance Cancellation | ||
| $ 0.00 - $ 3,500.00 | 7,372 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 6,082 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 224 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 36 | $0 | |
| $2,000,000.01 & up | 9 | $0 | |
| SubCLIN Total | 13,723 | $0 |
CLIN
Chris Hoff: Contract Line Item (CLIN) corresponding to the contract.
Chris Hoff: Input required. In the yellow highlighted cells, enter your Fill Fee for each Requisition Value Range. Enter in whole dollars only. Service Type Chris Hoff: Represents Service Types that can generate Fees for the PROS contractor. No input required.
Chris Hoff: These are requisition quantities for each dollar range estimated using historical data. No input is required.
| Contractor Price | |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Unit Price for each Service Type. Enter in whole dollars only. | Estimated Qty |
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | Estimated |
Extended Price Chris Hoff: Estimated Extended Price is calculated. No input is required.
0003 Task Order for Contractor Technology Solution (CTS) Implementation Study (PWS 1.2.10 and PWS 2.1.1) HOFF, CHRISTOPHER G: Input required. In the yellow highlighted cells, enter your Unit Price for each Service Type. Enter in whole dollars only.
Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required.
Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required.
Chris Hoff: Estimated Extended Price is calculated. No input is required. 1 $0
FILL Price SUBTOTAL $0
| CLIN | |
| Chris Hoff: Contract Line Item (CLIN) corresponding to the contract. | Service Type |
| Chris Hoff: Represents Service Types that can generate Fees for the PROS contractor. No input required. | Contractor Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Unit Price for each Service Type. Enter in whole dollars only. | Estimated Qty |
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | Estimated |
Extended Price Chris Hoff: Estimated Extended Price is calculated. No input is required.
0003 Task Orders HOFF, CHRISTOPHER G: Task orders will be priced at the time of need. Offeror shall not estimate price for Task Orders.
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | 53 | |
| 0005 | Research / Price and Availability Price |
Chris Hoff: Research to determine Item Eligibility, Price and Availability.
Chris Hoff: Sum of the Estimated Quantities above.
Chris Hoff: Estimated Extended Price is calculated. No input is required.
| Chris Hoff: Sum of the Amounts listed above. | 751 | $0 | |
| SERVICE Price SUBTOTAL | $0 |
Chris Hoff: Sum of the Estimated Extended Prices listed above. No input required.
TOTAL BASE PERIOD $0
Chris Hoff: Sum of the Fill Fee Subtotal and Service Fee Subtotal above. No input required.
Option Yr1
| Option Year 1 of Contract (Period of Performance: Year 6 of Period of Performance) |
| Worksheet Instructions: This worksheet is intended to capture Fill Prices for Option Year 1 only. In the first table below, the offeror shall enter a Fill Price in whole dollars for each Requisition Value range (ex. $0.00 - $3,500) for each Requisition Type (ex. Supply) down the column. The offeror must provide a Fill Price for each Requisition Value range and Requisition Type, even if there are zero estimated requisitions in the Estimated Quantity cell. The worksheet will calculate the Extended Price by multiplying the offeror's Fill Price by the Estimated Quanity provided by the USG. In the second table below, the offeror shall enter a Price in whole dollars for services to be provided on the contract. These prices are separate from the Fill Prices. The worksheet will calculate the Extended Price based on the Prices entered by the offeror. All fields requiring offeror input are highlighted in Yellow. Values entered by the offeror will be contractually binding. No other input is required. The offeror shall not unlock or modify any part of the worksheet or underlying code. Help text is available by hovering the mouse pointer over a cell with an embedded Comment (noted by a red triangle in the top right cell corner). For further assistance, please contact the PROS VI Contracting Officer listed in the solicitation. |
| Quantities below are for proposal evaluation purposes only. |
Actual quantities are highly variable and cannot be reliably predicted.
| CLIN | |
| Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…? | Requisition Type |
| Chris Hoff: There are 4 requisition types - Supply, Maintenance, Supply Cancellations, and Maintenance Cancellations. A requisition value range is provided for each. No input is required in this column. | Fill Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Fill Fee for each Requisition Value Range for this Level of Service. Enter in whole dollars only. | Est. Requisition Qty |
Chris Hoff: These are requisition quantities for each dollar range estimated using historical data. No input is required.
Estimated Extended Price Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required.
| 1001AA | Supply Requisition Value: | ||
| $ 0.00 - $ 3,500.00 | 15,661 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 7,100 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 600 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 99 | $0 | |
| $2,000,000.01 & up | 3 | $0 | |
| SubCLIN Total | 23,463 |
Chris Hoff: Sum of the Estimated Quantities above.
$0 Chris Hoff: Sum of the Amounts listed above.
| 1001AB | Maintenance Requisition Value | ||
| $ 0.00 - $ 3,500.00 | 6,101 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 5,003 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 166 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 28 | $0 | |
| $2,000,000.01 & up | 3 | $0 | |
| SubCLIN Total | 11,301 | $0 |
| 1002AA | Supply Cancellation | ||
| $ 0.00 - $ 3,500.00 | 9,651 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 4,387 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 370 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 66 | $0 | |
| $2,000,000.01 & up | 3 | $0 | |
| SubCLIN Total | 14,477 | $0 |
| 1002AB | Maintenance Cancellation | ||
| $ 0.00 - $ 3,500.00 | 2,331 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 1,923 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 71 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 11 | $0 | |
| $2,000,000.01 & up | 3 | $0 | |
| SubCLIN Total | 4,339 | $0 |
FILL Price SUBTOTAL $0
CLIN
Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…?
| Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required. | Service Type |
| Chris Hoff: Represents Service Types that can generate Fees for the PROS contractor. No input required. | Contractor Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Unit Price for each Service Type. Enter in whole dollars only. | Estimated Qty |
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | Estimated |
Extended Price Chris Hoff: Estimated Extended Price is ?? No input is required.
1003 Task Orders HOFF, CHRISTOPHER G: Task orders will be priced at the time of need. Offeror shall not estimate price for Task Orders.
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | 17 | |
| 1005 | Research / Price and Availability Price |
Chris Hoff: Research to determine Item Eligibility Chris Hoff: Estimated Extended Price is ?? No input is required.
Chris Hoff: Sum of the Estimated Quantities above.
| 237 | $0 | |
| SERVICE Price SUBTOTAL | $0 |
Chris Hoff: Sum of the Estimated Extended Prices listed above. No input required.
Chris Hoff: Sum of the Amounts listed above. TOTAL OPTION YEAR 1 $0
Option Yr2
| Option Year 2 of Contract (Period of Performance: Year 7 of Period of Performance) |
| Worksheet Instructions: This worksheet is intended to capture Fill Prices for Option Year 2 only. In the first table below, the offeror shall enter a Fill Price in whole dollars for each Requisition Value range (ex. $0.00 - $3,500) for each Requisition Type (ex. Supply) down the column. The offeror must provide a Fill Price for each Requisition Value range and Requisition Type, even if there are zero estimated requisitions in the Estimated Quantity cell. The worksheet will calculate the Extended Price by multiplying the offeror's Fill Price by the Estimated Quanity provided by the USG. In the second table below, the offeror shall enter a Price in whole dollars for services to be provided on the contract. These prices are separate from the Fill Prices. The worksheet will calculate the Extended Price based on the Prices entered by the offeror. All fields requiring offeror input are highlighted in Yellow. Values entered by the offeror will be contractually binding. No other input is required. The offeror shall not unlock or modify any part of the worksheet or underlying code. Help text is available by hovering the mouse pointer over a cell with an embedded Comment (noted by a red triangle in the top right cell corner). For further assistance, please contact the PROS VI Contracting Officer listed in the solicitation. |
| Quantities below are for proposal evaluation purposes only. |
Actual quantities are highly variable and cannot be reliably predicted.
| CLIN | |
| Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…? | Requisition Type |
| Chris Hoff: There are 4 requisition types - Supply, Maintenance, Supply Cancellations, and Maintenance Cancellations. A requisition value range is provided for each. No input is required in this column. | Fill Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Fill Fee for each Requisition Value Range for this Level of Service. Enter in whole dollars only. | Est. Requisition Qty |
Chris Hoff: These are requisition quantities for each dollar range estimated using historical data. No input is required.
Estimated Extended Price Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required.
| 2001AA | Supply Requisition Value: | ||
| $ 0.00 - $ 3,500.00 | 18,402 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 8,343 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 705 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 117 | $0 | |
| $2,000,000.01 & up | 3 | $0 | |
| SubCLIN Total | 27,570 |
Chris Hoff: Sum of the Estimated Quantities above.
$0 Chris Hoff: Sum of the Amounts listed above.
| 2001AB | Maintenance Requisition Value | ||
| $ 0.00 - $ 3,500.00 | 7,169 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 5,879 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 195 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 33 | $0 | |
| $2,000,000.01 & up | 3 | $0 | |
| SubCLIN Total | 13,279 | $0 |
| 2002AA | Supply Cancellation | ||
| $ 0.00 - $ 3,500.00 | 11,340 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 5,155 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 434 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 77 | $0 | |
| $2,000,000.01 & up | 3 | $0 | |
| SubCLIN Total | 17,009 | $0 |
| 2002AB | Maintenance Cancellation | ||
| $ 0.00 - $ 3,500.00 | 2,739 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 2,260 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 83 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 13 | $0 | |
| $2,000,000.01 & up | 3 | $0 | |
| SubCLIN Total | 5,098 | $0 |
FILL Price SUBTOTAL $0
CLIN
Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…?
| Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required. | Service Type |
| Chris Hoff: Represents Service Types that can generate Fees for the PROS contractor. No input required. | Contractor Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Unit Price for each Service Type. Enter in whole dollars only. | Estimated Qty |
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | Estimated |
Extended Price Chris Hoff: Estimated Extended Price is ?? No input is required.
2003 Task Orders HOFF, CHRISTOPHER G: Task orders will be priced at the time of need. Offeror shall not estimate price for Task Orders.
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | 20 | |
| 2005 | Research / Price and Availability Price |
Chris Hoff: Research to determine Item Eligibility Chris Hoff: Estimated Extended Price is ?? No input is required.
Chris Hoff: Sum of the Estimated Quantities above.
| 279 | $0 | |
| SERVICE Price SUBTOTAL | $0 |
Chris Hoff: Sum of the Amounts listed above. TOTAL OPTION YEAR 2 $0
Option Yr3
| Option Year 3 of Contract (Period of Performance: Year 8 of Period of Performance) |
| Worksheet Instructions: This worksheet is intended to capture Fill Prices for Option Year 3 only. In the first table below, the offeror shall enter a Fill Price in whole dollars for each Requisition Value range (ex. $0.00 - $3,500) for each Requisition Type (ex. Supply) down the column. The offeror must provide a Fill Price for each Requisition Value range and Requisition Type, even if there are zero estimated requisitions in the Estimated Quantity cell. The worksheet will calculate the Extended Price by multiplying the offeror's Fill Price by the Estimated Quanity provided by the USG. In the second table below, the offeror shall enter a Price in whole dollars for services to be provided on the contract. These prices are separate from the Fill Prices. The worksheet will calculate the Extended Price based on the Prices entered by the offeror. All fields requiring offeror input are highlighted in Yellow. Values entered by the offeror will be contractually binding. No other input is required. The offeror shall not unlock or modify any part of the worksheet or underlying code. Help text is available by hovering the mouse pointer over a cell with an embedded Comment (noted by a red triangle in the top right cell corner). For further assistance, please contact the PROS VI Contracting Officer listed in the solicitation. |
| Quantities below are for proposal evaluation purposes only. |
Actual quantities are highly variable and cannot be reliably predicted.
| CLIN | |
| Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…? | Requisition Type |
| Chris Hoff: There are 4 requisition types - Supply, Maintenance, Supply Cancellations, and Maintenance Cancellations. A requisition value range is provided for each. No input is required in this column. | Fill Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Fill Fee for each Requisition Value Range for this Level of Service. Enter in whole dollars only. | Est. Requisition Qty |
Chris Hoff: These are requisition quantities for each dollar range estimated using historical data. No input is required.
Estimated Extended Price Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required.
| 3001AA | Supply Requisition Value: | ||
| $ 0.00 - $ 3,500.00 | 21,622 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 9,803 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 828 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 137 | $0 | |
| $2,000,000.01 & up | 4 | $0 | |
| SubCLIN Total | 32,394 |
Chris Hoff: Sum of the Estimated Quantities above.
$0 Chris Hoff: Sum of the Amounts listed above.
| 3001AB | Maintenance Requisition Value | ||
| $ 0.00 - $ 3,500.00 | 8,423 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 6,908 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 229 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 39 | $0 | |
| $2,000,000.01 & up | 4 | $0 | |
| SubCLIN Total | 15,603 | $0 |
| 3002AA | Supply Cancellation | ||
| $ 0.00 - $ 3,500.00 | 13,324 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 6,057 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 510 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 91 | $0 | |
| $2,000,000.01 & up | 4 | $0 | |
| SubCLIN Total | 19,986 | $0 |
| 3002AB | Maintenance Cancellation | ||
| $ 0.00 - $ 3,500.00 | 3,218 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 2,655 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 98 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 16 | $0 | |
| $2,000,000.01 & up | 4 | $0 | |
| SubCLIN Total | 5,991 | $0 |
FILL Price SUBTOTAL $0
CLIN
Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…?
| Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required. | Service Type |
| Chris Hoff: Represents Service Types that can generate Fees for the PROS contractor. No input required. | Contractor Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Unit Price for each Service Type. Enter in whole dollars only. | Estimated Qty |
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | Estimated |
Extended Price Chris Hoff: Estimated Extended Price is ?? No input is required.
3003 Task Orders HOFF, CHRISTOPHER G: Task orders will be priced at the time of need. Offeror shall not estimate price for Task Orders.
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | 23 | |
| 3005 | Research / Price and Availability Price |
Chris Hoff: Research to determine Item Eligibility Chris Hoff: Estimated Extended Price is ?? No input is required.
Chris Hoff: Sum of the Estimated Quantities above.
| 328 | $0 | |
| SERVICE Price SUBTOTAL | $0 |
Chris Hoff: Sum of the Amounts listed above. TOTAL OPTION YEAR 3 $0
Option Yr4
| Option Year 4 of Contract (Period of Performance: Year 9 of Period of Performance) |
| Worksheet Instructions: This worksheet is intended to capture Fill Prices for Option Year 4 only. In the first table below, the offeror shall enter a Fill Price in whole dollars for each Requisition Value range (ex. $0.00 - $3,500) for each Requisition Type (ex. Supply) down the column. The offeror must provide a Fill Price for each Requisition Value range and Requisition Type, even if there are zero estimated requisitions in the Estimated Quantity cell. The worksheet will calculate the Extended Price by multiplying the offeror's Fill Price by the Estimated Quanity provided by the USG. In the second table below, the offeror shall enter a Price in whole dollars for services to be provided on the contract. These prices are separate from the Fill Prices. The worksheet will calculate the Extended Price based on the Prices entered by the offeror. All fields requiring offeror input are highlighted in Yellow. Values entered by the offeror will be contractually binding. No other input is required. The offeror shall not unlock or modify any part of the worksheet or underlying code. Help text is available by hovering the mouse pointer over a cell with an embedded Comment (noted by a red triangle in the top right cell corner). For further assistance, please contact the PROS VI Contracting Officer listed in the solicitation. |
| Quantities below are for proposal evaluation purposes only. |
Actual quantities are highly variable and cannot be reliably predicted.
| CLIN | |
| Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…? | Requisition Type |
| Chris Hoff: There are 4 requisition types - Supply, Maintenance, Supply Cancellations, and Maintenance Cancellations. A requisition value range is provided for each. No input is required in this column. | Fill Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Fill Fee for each Requisition Value Range for this Level of Service. Enter in whole dollars only. | Est. Requisition Qty |
Chris Hoff: These are requisition quantities for each dollar range estimated using historical data. No input is required.
Estimated Extended Price Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required.
| 4001AA | Supply Requisition Value: | ||
| $ 0.00 - $ 3,500.00 | 25,406 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 11,518 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 973 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 161 | $0 | |
| $2,000,000.01 & up | 5 | $0 | |
| SubCLIN Total | 38,063 |
Chris Hoff: Sum of the Estimated Quantities above.
$0 Chris Hoff: Sum of the Amounts listed above.
| 4001AB | Maintenance Requisition Value | ||
| $ 0.00 - $ 3,500.00 | 9,898 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 8,117 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 270 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 46 | $0 | |
| $2,000,000.01 & up | 5 | $0 | |
| SubCLIN Total | 18,336 | $0 |
| 4002AA | Supply Cancellation | ||
| $ 0.00 - $ 3,500.00 | 15,656 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 7,117 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 600 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 106 | $0 | |
| $2,000,000.01 & up | 5 | $0 | |
| SubCLIN Total | 23,484 | $0 |
| 4002AB | Maintenance Cancellation | ||
| $ 0.00 - $ 3,500.00 | 3,781 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 3,120 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 115 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 18 | $0 | |
| $2,000,000.01 & up | 5 | $0 | |
| SubCLIN Total | 7,039 | $0 |
FILL Price SUBTOTAL $0
CLIN
Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…?
| Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required. | Service Type |
| Chris Hoff: Represents Service Types that can generate Fees for the PROS contractor. No input required. | Contractor Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Unit Price for each Service Type. Enter in whole dollars only. | Estimated Qty |
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | Estimated |
Extended Price Chris Hoff: Estimated Extended Price is ?? No input is required.
4003 Task Orders HOFF, CHRISTOPHER G: Task orders will be priced at the time of need. Offeror shall not estimate price for Task Orders.
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | 27 | |
| 4005 | Research / Price and Availability Price |
Chris Hoff: Research to determine Item Eligibility Chris Hoff: Estimated Extended Price is ?? No input is required.
Chris Hoff: Sum of the Estimated Quantities above.
| 385 | $0 | |
| SERVICE Price SUBTOTAL | $0 |
Chris Hoff: Sum of the Amounts listed above. TOTAL OPTION YEAR 4 $0
Option Yr5
| Option Year 5 of Contract (Period of Performance: Year 10 of Period of Performance) |
| Worksheet Instructions: This worksheet is intended to capture Fill Prices for Option Year 5 only. In the first table below, the offeror shall enter a Fill Price in whole dollars for each Requisition Value range (ex. $0.00 - $3,500) for each Requisition Type (ex. Supply) down the column. The offeror must provide a Fill Price for each Requisition Value range and Requisition Type, even if there are zero estimated requisitions in the Estimated Quantity cell. The worksheet will calculate the Extended Price by multiplying the offeror's Fill Price by the Estimated Quanity provided by the USG. In the second table below, the offeror shall enter a Price in whole dollars for services to be provided on the contract. These prices are separate from the Fill Prices. The worksheet will calculate the Extended Price based on the Prices entered by the offeror. All fields requiring offeror input are highlighted in Yellow. Values entered by the offeror will be contractually binding. No other input is required. The offeror shall not unlock or modify any part of the worksheet or underlying code. Help text is available by hovering the mouse pointer over a cell with an embedded Comment (noted by a red triangle in the top right cell corner). For further assistance, please contact the PROS VI Contracting Officer listed in the solicitation. |
| Quantities below are for proposal evaluation purposes only. |
Actual quantities are highly variable and cannot be reliably predicted.
| CLIN | |
| Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…? | Requisition Type |
| Chris Hoff: There are 4 requisition types - Supply, Maintenance, Supply Cancellations, and Maintenance Cancellations. A requisition value range is provided for each. No input is required in this column. | Fill Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Fill Fee for each Requisition Value Range for this Level of Service. Enter in whole dollars only. | Est. Requisition Qty |
Chris Hoff: These are requisition quantities for each dollar range estimated using historical data. No input is required.
Estimated Extended Price Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required.
| 5001AA | Supply Requisition Value: | ||
| $ 0.00 - $ 3,500.00 | 29,852 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 13,534 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 1,143 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 189 | $0 | |
| $2,000,000.01 & up | 6 | $0 | |
| SubCLIN Total | 44,724 |
Chris Hoff: Sum of the Estimated Quantities above.
$0 Chris Hoff: Sum of the Amounts listed above.
| 5001AB | Maintenance Requisition Value | ||
| $ 0.00 - $ 3,500.00 | 11,630 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 9,537 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 317 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 54 | $0 | |
| $2,000,000.01 & up | 6 | $0 | |
| SubCLIN Total | 21,544 | $0 |
| 5002AA | Supply Cancellation | ||
| $ 0.00 - $ 3,500.00 | 18,396 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 8,362 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 704 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 125 | $0 | |
| $2,000,000.01 & up | 6 | $0 | |
| SubCLIN Total | 27,593 | $0 |
| 5002AB | Maintenance Cancellation | ||
| $ 0.00 - $ 3,500.00 | 4,443 | $0 | |
| $ 3,500.01 - $ 10,000.00 | 3,666 | $0 | |
| $ 10,000.01 - $ 250,000.00 | 135 | $0 | |
| $ 250,000.01 - $2,000,000.00 | 22 | $0 | |
| $2,000,000.01 & up | 6 | $0 | |
| SubCLIN Total | 8,272 | $0 |
FILL Price SUBTOTAL $0
CLIN
Chris Hoff: Contract Line Item (CLIN) corresponding to the contract…?
| Chris Hoff: The data in this column is auto-calculated using the Fill Fee and Estimated Qty. No input is required. | Service Type |
| Chris Hoff: Represents Service Types that can generate Fees for the PROS contractor. No input required. | Contractor Price |
| Chris Hoff: Input required. In the yellow highlighted cells, enter your Unit Price for each Service Type. Enter in whole dollars only. | Estimated Qty |
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | Estimated |
Extended Price Chris Hoff: Estimated Extended Price is ?? No input is required.
5003 Task Orders HOFF, CHRISTOPHER G: Task orders will be priced at the time of need. Offeror shall not estimate price for Task Orders.
| Chris Hoff: These are quantities for each dollar range estimated using historical data. No input is required. | 32 | |
| 5005 | Research / Price and Availability Price |
Chris Hoff: Research to determine Item Eligibility Chris Hoff: Estimated Extended Price is ?? No input is required.
Chris Hoff: Sum of the Estimated Quantities above.
| 453 | $0 | |
| SERVICE Price SUBTOTAL | $0 |
Chris Hoff: Sum of the Amounts listed above. TOTAL OPTION YEAR 5 $0
Final Fill Prices
| Contract Value Calculation - Base and All Option Years | |||||||
| The intent of this sheet is to display the offeror's fill and service Prices that will become final for the contract. No input is required by the offeror on this worksheet. | |||||||
| Fill Prices | |||||||
| Requisition Type | Base Period | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | |
| Supply Requisition Values | CLIN | 0001AA | 1001AA | 2001AA | 3001AA | 4001AA | 5001AA |
| $ 0.00 - $ 3,500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 3,500.01 - $ 10,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 10,000.01 - $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 250,000.01 - $2,000,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $2,000,000.01 & up | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| SubCLIN Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Maintenance Requisition Values | CLIN | 0001AB | 1001AB | 2001AB | 3001AB | 4001AB | 5001AB |
| $ 0.00 - $ 3,500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 3,500.01 - $ 10,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 10,000.01 - $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 250,000.01 - $2,000,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $2,000,000.01 & up | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| SubCLIN Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Supply Cancellation Values | CLIN | 0002AA | 1002AA | 2002AA | 3002AA | 4002AA | 5002AA |
| $ 0.00 - $ 3,500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 3,500.01 - $ 10,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 10,000.01 - $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 250,000.01 - $2,000,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $2,000,000.01 & up | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| SubCLIN Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Maintenance Cancellation Values | CLIN | 0002AB | 1002AB | 2002AB | 3002AB | 4002AB | 5002AB |
| $ 0.00 - $ 3,500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 3,500.01 - $ 10,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 10,000.01 - $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ 250,000.01 - $2,000,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $2,000,000.01 & up | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| SubCLIN Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Service Prices | ||||||
| Service Type | Base | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 |
| Research / Price and Availability Price | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total Value
| Contract Value Calculation - Base and All Option Years | ||||||||
| The intent of this sheet is to calculate the Total Evaluated Price from all base and option period fill Prices, service Prices, travel costs, material pass thru, OPIs, etc. No offeror input is required on this worksheet. | ||||||||
| Fill Prices | Estimated Extended Price | |||||||
| Requisition Type | Base Period | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | ||
| Supply Requisition Values | CLIN | 0001AA | 1001AA | 2001AA | 3001AA | 4001AA | 5001AA | |
| $ 0.00 - $ 3,500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 3,500.01 - $ 10,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 10,000.01 - $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 250,000.01 - $2,000,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $2,000,000.01 & up | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| SubCLIN Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 |
| Maintenance Requisition Values | CLIN | 0001AB | 1001AB | 2001AB | 3001AB | 4001AB | 5001AB | |
| $ 0.00 - $ 3,500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 3,500.01 - $ 10,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 10,000.01 - $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 250,000.01 - $2,000,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $2,000,000.01 & up | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| SubCLIN Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 |
| Supply Cancellation Values | CLIN | 0002AA | 1002AA | 2002AA | 3002AA | 4002AA | 5002AA | |
| $ 0.00 - $ 3,500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 3,500.01 - $ 10,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 10,000.01 - $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 250,000.01 - $2,000,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $2,000,000.01 & up | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| SubCLIN Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 |
| Maintenance Cancellation Values | CLIN | 0002AB | 1002AB | 2002AB | 3002AB | 4002AB | 5002AB | |
| $ 0.00 - $ 3,500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 3,500.01 - $ 10,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 10,000.01 - $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $ 250,000.01 - $2,000,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| $2,000,000.01 & up | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | |
| SubCLIN Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 |
| CLIN | ||
| Chris Hoff: Contract Line Item (CLIN) corresponding to the contract | Service Type | |
| Chris Hoff: Represents Service Types that can generate Fees for the PROS contractor. No input required. | Estimated Extended Price |
Chris Hoff: Sum of the service fee values from Base and all options, as well as placeholder values we provide for travel, task orders, etc.
| 0001-5001 | Fill Price | $ - 0 |
| 0002-5002 | Cancellation Price | $ - 0 |
| 0003-5003 | Task Order Price | $ 10,000,000 |
| 0004-5004 | Travel Expenses | $ 100,000 |
| 0005-5005 | Research / Price and Availability Price | $ - 0 |
| 0006-5006 | Estimated Material / Maintenance Pass Thru Cost | $ 4,538,845,312 |
| 0007-5007 | Data | NSP |
| 0008-5008 | Objective Performance Incentive | $ 16,200,000 |
| 0009-5009 | Over and Above | $ 1,000,000 |
| SUBTOTAL | $ 4,566,145,312 |
File details come from the government source that posted it. Updated .