Pricing Spreadsheet.xlsx
XLSX spreadsheet 77 KB Posted
- Attached to
- NGJ-MB Peculiar Support Equipment (PSE)
- Solicitation number
- N6833525R0274
About this file
This is a Pricing Spreadsheet for a competitive procurement by the Department of the Navy Naval Air Systems Command for the NGJ-MB Peculiar Support Equipment (PSE). The solicitation is for a Firm Fixed-Price, five-year Indefinite Delivery, Indefinite Quantity (IDIQ) contract covering two primary items: MB1/MB2 Installation Fixture (P/N 4102AS1581-1) and NGJMB Accumulator Adjustment Set (NAAS) (P/N 4102AS7713-1). The pricing template requires offerors to complete green-colored cells with fixed-price unit prices, with pricing to be evaluated at the maximum quantity unit price per ordering period.
The spreadsheet includes three detailed pricing sections: Company Information, Pricing, and Stepladder Pricing. The pricing structure covers five contract years, with varying quantities for each year ranging from 1 to 27 units for the first year and decreasing in subsequent years. Offerors are instructed to propose unit prices for different quantity ranges, with cells color-coded to indicate where pricing should be entered. The template emphasizes that Contract Deliverable Requirements List (CDRL) items are not to be separately priced, and the total evaluated price will be calculated based on the proposed unit prices.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N6833525R0274-0001.pdf | ||
| N6833525R0274.pdf |
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 TO OFFERORS |
| 1. COMPANY INFORMATION TAB: Offerors shall complete all the green colored cells on the Company Information tab. |
| 2. PRICING TAB: Offerors shall propose Fixed-Price unit prices in the green colored cells in column D for each Contract Line Item as applicable. All cells that are filled in with the color as that of Figure 1 below shall have a unit priced inserted. All Firm-Fixed-Price unit prices proposed in the Pricing tab, if awarded, shall be the contractual amounts. The amount in cell E14 is derived from the sum of the blue cells above them for each respective CLIN. Figure 2 below provides an example of what a populated pricing tab shall look like.*DO NOT PRICE CDRLs; CDRLs are NOT SEPERATELY PRICED (NSP) |
As this effort is a Fixed Price (FP) Indefinite Delivery Indefinite Quantity (IDIQ), this effort will be evaluated at the maximum quantity unit price per ordering period.
Figure 1: $8,740.00
| Figure 2: | |||||
| CLIN | ITEM | QUANTITY | UNIT PRICE | AMOUNT | TOTAL EVALUATED PRICE |
| 0001 | PSE 1 | 2000 | $2.00 | $4,000.00 | |
| 0002 | PSE2 | 300 | $15.00 | $4,500.00 | |
| 0003 | PSE3 | 20 | $12.00 | $240.00 | |
| 0004 | $0.00 | ||||
| 0005 | $0.00 | ||||
| $8,740.00 | $8,740.00 |
1. Company Info
| Offeror Company Information |
| Offeror Name: |
| Offeror Street Address: |
| Offeror City: |
| Offeror State: |
| Offeror Zip Code: |
| Offeror Primary Contact Name: |
| Offeror Primary Contact Email: |
| Offeror Primary Contact Phone Number: |
| Offeror DUNS: |
| Offeror CAGE Code: |
| Offeror Secondary Contact Name: |
| Offeror Secondary Contact Email: |
| Offeror Secondary Contact Phone Number: |
2. Pricing
| EFFORT EVALUATED AT THE MAXIMUM QUANTITY UNIT PRICE PER ORDERING PERIOD | |||||
| CLIN Number | ITEM | MAXIMUM QUANTITY PER ORDERING PERIOD | UNIT PRICE | AMOUNT | TOTAL EVALUATED PRICE |
| 1001 | MB1/MB2 Installation Fixture Year 1 | 27 | $0.00 | $0.00 | $0.00 |
| 1002 | NGJMB Accumulator Adjustment Set (NAAS) Year 1 | 27 | $0.00 | $0.00 | $0.00 |
| 2001 | MB1/MB2 Installation Fixture Year 2 | 2 | $0.00 | $0.00 | $0.00 |
| 2002 | NAAS Year 2 | 2 | $0.00 | $0.00 | $0.00 |
| 3001 | MB1/MB2 Installation Fixture Year 3 | 1 | $0.00 | $0.00 | $0.00 |
| 3002 | NAAS Year 3 | 1 | $0.00 | $0.00 | $0.00 |
| 4001 | MB1/MB2 Installation Fixture Year 4 | 1 | $0.00 | $0.00 | $0.00 |
| 4002 | NAAS Year 4 | 1 | $0.00 | $0.00 | $0.00 |
| 5001 | MB1/MB2 Installation Fixture Year 5 | 5 | $0.00 | $0.00 | $0.00 |
| 5002 | NAAS Year 5 | 5 | $0.00 | $0.00 | $0.00 |
| $0.00 | |||||
| Total | $0.00 | $0.00 |
ERROR:#REF!
3. Stepladder Pricing
| STEPLADDER PRICING | ||||
| CLIN Number | ITEM | From Quantity | To Quantity | UNIT PRICE |
| 1001 | MB1/MB2 Installation Fixture Year 1 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| 1002 | NGJMB Accumulator Adjustment Set (NAAS) Year 1 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| 2001 | MB1/MB2 Installation Fixture Year 2 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| 2002 | NAAS Year 2 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| 3001 | MB1/MB2 Installation Fixture Year 3 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| 3002 | NAAS Year 3 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| 4001 | MB1/MB2 Installation Fixture Year 4 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| 4002 | NAAS Year 4 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| 5001 | MB1/MB2 Installation Fixture Year 5 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| 5002 | NAAS Year 5 | 1 | 10 | $0.00 |
| 11 | 20 | $0.00 | ||
| 21 | 30 | $0.00 | ||
| 31 | 36 | $0.00 | ||
| Total |
ERROR:#REF!
File details come from the government source that posted it. Updated .