Attach_0002-Section-B-F_Spreadsheet_SPRBL1-16-R-0028_3-29-2016.xlsx
XLSX spreadsheet 50 KB Posted
- Solicitation number
- SPRBL1-16-R-0028
About this file
Attachment 0002 - Section B-F Spreadsheet SPRBL1-16-R-0028
View the file
Other files
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
Table of Contents
| Tab | Description of Worksheet Contents |
| NSN List & Part Numbers | NSNs and part numbers included in the solicitation. |
| CLIN Min-Max | Place of inspection, unit of issue, delivery order minimum & maximum quantities, CLIN minimum percentage, CLIN maximum dollars, surge requirment. |
| Pricing | Offeror proposed prices for year 1 and percentange (%) increase/decrease (plus/mins) for years 2-5. |
| Delivery | Government required delivery & offeror proposed delivery. |
Worksheet Table of Contents SPRBL1-16-R-0028
NSN & Part Numbers
| CLIN | Price CLIN | NSN | ITEM NAME | CAGE | SYSTEM NUMBER | ROCKWELL COLLINS PART NUMBER |
| 1001-5001 | 1001AA-5001AA | 5826-01-444-0314 | Receiver Radio | 13499 | ARN-147 R-2594 | 622-6376-020 |
| 1002-5002 | 1002AA-5002AA | 5826-01-444-0317 | Control Radio Set | 13499 | ARN-147 C-12550 | 522-4408-013 |
| 1003-5003 | 1003AA-5003AA | 5826-01-293-4789 | Receiver Radio | 13499 | ARN-149 R-2383 | 622-6812-003 |
| 1004-5004 | 1004AA-5004AA | 5826-01-600-6180 | Receiver, Radio | 13499 | ARN-149 | 622-6812-102 |
| 1005-5005 | 1005AA-5005AA | 5826-01-395-5325 | Control Direction F | 13499 | ARN-149 C-12491 | 622-6813-005 |
| 1006-5006 | 1006AA-5006AA | 5985-01-446-2574 | Antenna, Black | 13499 | ARN-149 AS-4480 | 622-6820-003 |
| 1007-5007 | 1007AA-5007AA | 5826-01-341-5089 | Control Radio Set | 13499 | ARN-149 C-12192 | 622-6813-004 |
| 1008-5008 | 1008AA-5008AA | 5826-01-386-8807 | Radio Set | 13499 | ARN-153 RT-1625 | 622-8149-001 |
NSNs and Part Numbers SPRBL1-16-R-0028 Page &P of &N
CLIN Min-Max
| CLIN | NSN | Description | Place of Inspection/ Acceptance | Unit of Issue | 5 Year BEQ | Clause 52.216-19(a) Delivery Order Minimum | Clause 52.216-19(b)(1)/(b2) Delivery Order Maximum | CLIN Minimum | CLIN Maximum | Surge Item |
| 1001AA-5001AA | 5826-01-444-0314 | ARN-147 R-2594 | Origin | EA | 795 | 1 | 500 | $10,000 | $36,776,211 | N |
| 1002AA-5002AA | 5826-01-444-0317 | ARN-147 C-12550 | Origin | EA | 72 | 1 | 80 | $250 | $1,260,479 | N |
| 1003AA-5003AA | 5826-01-293-4789 | ARN-149 R-2383 | Origin | EA | 5 | 1 | 250 | $250 | $115,059 | N |
| 1004AA-5004AA | 5826-01-600-6180 | ARN-149 | Origin | EA | 511 | 1 | 80 | $3,750 | $13,653,609 | N |
| 1005AA-5005AA | 5826-01-395-5325 | ARN-149 C-12491 | Origin | EA | 5 | 1 | 60 | $250 | $41,085 | N |
| 1006AA-5006AA | 5985-01-446-2574 | ARN-149 AS-4480 | Origin | EA | 5 | 1 | 400 | $250 | $22,957 | N |
| 1007AA-5007AA | 5826-01-341-5089 | ARN-149 C-12192 | Origin | EA | 10 | 1 | 80 | $250 | $104,252 | N |
| 1008AA-5008AA | 5826-01-386-8807 | ARN-153 RT-1625 | Origin | EA | 505 | 1 | 400 | $10,000 | $40,993,941 | N |
| Total: | $25,000 | $92,967,593 |
&12CLIN Minimum and Estimated Maximum
| &12SPRBL1-16-R-0028 |
| &12Page &P of &N |
Pricing
| CLIN | 1001AA-5001AA | NSN 5826-01-444-0314 - Receiver Radio |
| Year | Quantity Range |
Proposed Price (Year 1) Proposed % Increase/ Decrease (Years 2-5) (Plus/Minus %)
| 1 | 1-150 | ----------- | |
| 1 | 151-250 | ----------- | |
| 1 | 251-350 | ----------- | |
| 1 | 351-500 | ----------- | |
| 2 | 1-150 | ----------- | |
| 2 | 151-250 | ----------- | |
| 2 | 251-350 | ----------- | |
| 2 | 351-500 | ----------- | |
| 3 | 1-150 | ----------- | |
| 3 | 151-250 | ----------- | |
| 3 | 251-350 | ----------- | |
| 3 | 351-500 | ----------- | |
| 4 | 1-150 | ----------- | |
| 4 | 151-250 | ----------- | |
| 4 | 251-350 | ----------- | |
| 4 | 351-500 | ----------- | |
| 5 | 1-150 | ----------- | |
| 5 | 151-250 | ----------- | |
| 5 | 251-350 | ----------- | |
| 5 | 351-500 | ----------- |
| CLIN | 1002AA-5002AA | NSN 5826-01-444-0317 - Control Radio Set |
| Year | Quantity Range |
Proposed Price (Year 1) Proposed % Increase/ Decrease (Years 2-5) (Plus/Minus %)
| 1 | 1-20 | ----------- | |
| 1 | 21-40 | ----------- | |
| 1 | 41-60 | ----------- | |
| 1 | 61-80 | ----------- | |
| 2 | 1-20 | ----------- | |
| 2 | 21-40 | ----------- | |
| 2 | 41-60 | ----------- | |
| 2 | 61-80 | ----------- | |
| 3 | 1-20 | ----------- | |
| 3 | 21-40 | ----------- | |
| 3 | 41-60 | ----------- | |
| 3 | 61-80 | ----------- | |
| 4 | 1-20 | ----------- | |
| 4 | 21-40 | ----------- | |
| 4 | 41-60 | ----------- | |
| 4 | 61-80 | ----------- | |
| 5 | 1-20 | ----------- | |
| 5 | 21-40 | ----------- | |
| 5 | 41-60 | ----------- | |
| 5 | 61-80 | ----------- |
| CLIN | 1003AA-5003AA | NSN 5826-01-293-4789 - Receiver Radio |
| Year | Quantity Range |
Proposed Price (Year 1) Proposed % Increase/ Decrease (Years 2-5) (Plus/Minus %)
| 1 | 1-25 | ----------- | |
| 1 | 26-50 | ----------- | |
| 1 | 51-150 | ----------- | |
| 1 | 151-250 | ----------- | |
| 2 | 1-25 | ----------- | |
| 2 | 26-50 | ----------- | |
| 2 | 51-150 | ----------- | |
| 2 | 151-250 | ----------- | |
| 3 | 1-25 | ----------- | |
| 3 | 26-50 | ----------- | |
| 3 | 51-150 | ----------- | |
| 3 | 151-250 | ----------- | |
| 4 | 1-25 | ----------- | |
| 4 | 26-50 | ----------- | |
| 4 | 51-150 | ----------- | |
| 4 | 151-250 | ----------- | |
| 5 | 1-25 | ----------- | |
| 5 | 26-50 | ----------- | |
| 5 | 51-150 | ----------- | |
| 5 | 151-250 | ----------- |
| CLIN | 1004AA-5004AA | NSN 5826-01-600-6180 - Receiver Radio |
| Year | Quantity Range |
Proposed Price (Year 1) Proposed % Increase/ Decrease (Years 2-5) (Plus/Minus %)
| 1 | 1-20 | ----------- | |
| 1 | 21-40 | ----------- | |
| 1 | 41-60 | ----------- | |
| 1 | 61-80 | ----------- | |
| 2 | 1-20 | ----------- | |
| 2 | 21-40 | ----------- | |
| 2 | 41-60 | ----------- | |
| 2 | 61-80 | ----------- | |
| 3 | 1-20 | ----------- | |
| 3 | 21-40 | ----------- | |
| 3 | 41-60 | ----------- | |
| 3 | 61-80 | ----------- | |
| 4 | 1-20 | ----------- | |
| 4 | 21-40 | ----------- | |
| 4 | 41-60 | ----------- | |
| 4 | 61-80 | ----------- | |
| 5 | 1-20 | ----------- | |
| 5 | 21-40 | ----------- | |
| 5 | 41-60 | ----------- | |
| 5 | 61-80 | ----------- |
| CLIN | 1005AA-5005AA | NSN 5826-01-395-5325 - Control Direction F |
| Year | Quantity Range |
Proposed Price (Year 1) Proposed % Increase/ Decrease (Years 2-5) (Plus/Minus %)
| 1 | 1-10 | ----------- | |
| 1 | 11-20 | ----------- | |
| 1 | 21-40 | ----------- | |
| 1 | 41-60 | ----------- | |
| 2 | 1-10 | ----------- | |
| 2 | 11-20 | ----------- | |
| 2 | 21-40 | ----------- | |
| 2 | 41-60 | ----------- | |
| 3 | 1-10 | ----------- | |
| 3 | 11-20 | ----------- | |
| 3 | 21-40 | ----------- | |
| 3 | 41-60 | ----------- | |
| 4 | 1-10 | ----------- | |
| 4 | 11-20 | ----------- | |
| 4 | 21-40 | ----------- | |
| 4 | 41-60 | ----------- | |
| 5 | 1-10 | ----------- | |
| 5 | 11-20 | ----------- | |
| 5 | 21-40 | ----------- | |
| 5 | 41-60 | ----------- |
| CLIN | 1006AA-5006AA | NSN 5985-01-446-2574 - Antenna, Black |
| Year | Quantity Range |
Proposed Price (Year 1) Proposed % Increase/ Decrease (Years 2-5) (Plus/Minus %)
| 1 | 1-100 | ----------- | |
| 1 | 101-200 | ----------- | |
| 1 | 201-300 | ----------- | |
| 1 | 301-400 | ----------- | |
| 2 | 1-100 | ----------- | |
| 2 | 101-200 | ----------- | |
| 2 | 201-300 | ----------- | |
| 2 | 301-400 | ----------- | |
| 3 | 1-100 | ----------- | |
| 3 | 101-200 | ----------- | |
| 3 | 201-300 | ----------- | |
| 3 | 301-400 | ----------- | |
| 4 | 1-100 | ----------- | |
| 4 | 101-200 | ----------- | |
| 4 | 201-300 | ----------- | |
| 4 | 301-400 | ----------- | |
| 5 | 1-100 | ----------- | |
| 5 | 101-200 | ----------- | |
| 5 | 201-300 | ----------- | |
| 5 | 301-400 | ----------- |
| CLIN | 1007AA-5007AA | NSN 5826-01-341-5089 - Control Radio Set |
| Year | Quantity Range |
Proposed Price (Year 1) Proposed % Increase/ Decrease (Years 2-5) (Plus/Minus %)
| 1 | 1-20 | ----------- | |
| 1 | 21-40 | ----------- | |
| 1 | 41-60 | ----------- | |
| 1 | 61-80 | ----------- | |
| 2 | 1-20 | ----------- | |
| 2 | 21-40 | ----------- | |
| 2 | 41-60 | ----------- | |
| 2 | 61-80 | ----------- | |
| 3 | 1-20 | ----------- | |
| 3 | 21-40 | ----------- | |
| 3 | 41-60 | ----------- | |
| 3 | 61-80 | ----------- | |
| 4 | 1-20 | ----------- | |
| 4 | 21-40 | ----------- | |
| 4 | 41-60 | ----------- | |
| 4 | 61-80 | ----------- | |
| 5 | 1-20 | ----------- | |
| 5 | 21-40 | ----------- | |
| 5 | 41-60 | ----------- | |
| 5 | 61-80 | ----------- |
| CLIN | 1008AA-5008AA | NSN 5826-01-386-8807 - Radio Set |
| Year | Quantity Range |
Proposed Price (Year 1) Proposed % Increase/ Decrease (Years 2-5) (Plus/Minus %)
| 1 | 1-100 | ----------- | |
| 1 | 101-200 | ----------- | |
| 1 | 201-300 | ----------- | |
| 1 | 301-400 | ----------- | |
| 2 | 1-100 | ----------- | |
| 2 | 101-200 | ----------- | |
| 2 | 201-300 | ----------- | |
| 2 | 301-400 | ----------- | |
| 3 | 1-100 | ----------- | |
| 3 | 101-200 | ----------- | |
| 3 | 201-300 | ----------- | |
| 3 | 301-400 | ----------- | |
| 4 | 1-100 | ----------- | |
| 4 | 101-200 | ----------- | |
| 4 | 201-300 | ----------- | |
| 4 | 301-400 | ----------- | |
| 5 | 1-100 | ----------- | |
| 5 | 101-200 | ----------- | |
| 5 | 201-300 | ----------- | |
| 5 | 301-400 | ----------- |
Pricing SPRBL1-16-R-0028 Page &P of &N
Delivery
| Delivery Schedule (see Time of Delivery in Section F) | |||||||||
| Government Required | Offered | Government Required | Offered | ||||||
| CLIN | NSN | UI | Initial Quantity | ||||||
| (Up To) | Initial Required Delivery | ||||||||
| (Days After Delivery Order) | Initial Offered Delivery | ||||||||
| (Days After Delivery Order) | Each Additional Quantity of ____ Or Less | Subsequent Delivery for Each Additional Quantity for _____ Days & Thereafter Until Order Completion (Days) | Subsequent Delivery for Each Additional Quantity for _____ Days & Thereafter Until Order Completion (Days) | ||||||
| 1001-5001 | 5826-01-444-0314 | EA | 20 | 180 | 25 | 30 | |||
| 1002-5002 | 5826-01-444-0317 | EA | 4 | 270 | 4 | 30 | |||
| 1003-5003 | 5826-01-293-4789 | EA | 20 | 180 | 25 | 30 | |||
| 1004-5004 | 5826-01-600-6180 | EA | 20 | 180 | 20 | 30 | |||
| 1005-5005 | 5826-01-395-5325 | EA | 4 | 270 | 4 | 30 | |||
| 1006-5006 | 5985-01-446-2574 | EA | 20 | 180 | 25 | 30 | |||
| 1007-5007 | 5826-01-341-5089 | EA | 4 | 270 | 4 | 30 | |||
| 1008-5008 | 5826-01-386-8807 | EA | 20 | 180 | 25 | 30 |
&12Delivery
| &12SPRBL1-16-R-0028 |
| &12Page &P of &N |
File details come from the government source that posted it. Updated .