A07_SolicAttach-J.6_CLIN_PricingMatrix_17Nov2017_18R0001.xlsx

XLSX spreadsheet 39 KB Posted

Attached to
Lightweight Laser Designator Rangefinder (LLDR) 3
Solicitation number
W91CRB-18-R-0001
Issued by

About this file

CLIN Pricing Matrix

View the file

Other files

Show all 19

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

LLDR 3 CLIN Pricing Matrix

LLDR 3 CLIN PRICING MATRIX

Instructions:Offerors must first complete this CLIN Pricing Matrix before filling out Section B
Enter proposed quanity ranges and unit prices for for each CLIN with step ladder (range) pricing
Matrix will automatically compute Average Weighted Unit Price and Weighted Maximum Amount
Enter the computed Average Weighted Unit Price as the Unit Price in the Section B CLIN
Enter the computed Weighted Maximum Amount as the Max Amount in the Section B CLIN
Ancillary Parts/Spares - Offeror shall also complete the Ancillary Parts/Spares Worksheet (at the Ancillary Spares tab) to provide
the proposed ancillary parts/spares to be offered as part of the lot.
Offeror Data Entry in YellowGreen cells are calculated from input
Notes:Quantity ranges and prices shown below are for example only; each Offeror must insert quantity ranges and provide
proposed unit price for each range (see example 1).
Quantities priced must include the entire range without overlaps or gaps, with the last range ending
with the maximum quantity identifed for the CLIN.
No more than FOUR (4) price ranges will be allowed per CLIN.
If all ranges are not used, enter ranges from the bottom row up, and enter zero-to-zero range and zero ($0) price
in unused range rows (see example 2)
Do not delete unused range rows.
Do not alter totals, formulas or links in any way.
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0006LLDR 3 Systems - PY 5150$19.00
51100$18.00
101150$17.00
151357$16.00
Average Weighted Unit Price$16.84$6,012.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0010TLM Spares - PY 500$0.00
00$0.00
115$19.00
1636$18.00
Average Weighted Unit Price$18.42$663.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICEAMOUNT
0001LLDR 3 Systems PY's 1 & 215$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICEAMOUNT
0002Additional LLDR 3 Systems PY's 1 & 210$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICEAMOUNT
0003First Article Testing - PY 31$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICEAMOUNT
0004Initial Production LLDR 3 Systems - PY 325$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0005Additional Initial Production LLDR 3 Systems - PY 300$0.00
00$0.00
00$0.00
0100$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0006LLDR 3 Systems - PY 400$0.00
00$0.00
00$0.00
0150$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0007LLDR 3 Systems - PY 500$0.00
00$0.00
00$0.00
0222$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0008LLDR 3 Systems - PY 600$0.00
00$0.00
00$0.00
0200$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0009LLDR 3 Systems - PY 700$0.00
00$0.00
00$0.00
0200$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0010LLDR 3 Systems - PY 800$0.00
00$0.00
00$0.00
0200$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0011LLDR 3 Systems - PY 900$0.00
00$0.00
00$0.00
0200$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0012LLDR 3 Systems - PY 1000$0.00
00$0.00
00$0.00
0200$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0013TLM Spares - PY 400$0.00
00$0.00
00$0.00
015$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0014TLM Spares - PY 500$0.00
00$0.00
00$0.00
022$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0015TLM Spares - PY 600$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0016TLM Spares - PY 700$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0017TLM Spares - PY 800$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0018TLM Spares - PY 900$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0019TLM Spares - PY 1000$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0020TIM Spares - PY 400$0.00
00$0.00
00$0.00
015$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0021TIM Spares - PY 500$0.00
00$0.00
00$0.00
022$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0022TIM Spares - PY 600$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0023TIM Spares - PY 700$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0024TIM Spares - PY 800$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0025TIM Spares - PY 900$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0026TIM Spares - PY 1000$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0027LDM Spares - PY 400$0.00
00$0.00
00$0.00
015$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0028LDM Spares - PY 500$0.00
00$0.00
00$0.00
022$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0029LDM Spares - PY 600$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0030LDM Spares - PY 700$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0031LDM Spares - PY 800$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0032LDM Spares - PY 900$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0033LDM Spares - PY 1000$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0034Ancillary Parts/Spares - PY 300$0.00
00$0.00
00$0.00
03$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0035Ancillary Parts/Spares - PY 400$0.00
00$0.00
00$0.00
015$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0036Ancillary Parts/Spares - PY 500$0.00
00$0.00
00$0.00
022$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0037Ancillary Parts/Spares - PY 600$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0038Ancillary Parts/Spares - PY 700$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0039Ancillary Parts/Spares - PY 800$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0040Ancillary Parts/Spares - PY 900$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0041Ancillary Parts/Spares - PY 1000$0.00
00$0.00
00$0.00
020$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0042Training Emulators - PY 300$0.00
00$0.00
00$0.00
030$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0043Training Emulators - PY 400$0.00
00$0.00
00$0.00
030$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0044Training Emulators - PY 500$0.00
00$0.00
00$0.00
030$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0045Training Emulators - PY 600$0.00
00$0.00
00$0.00
030$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0046Training Emulators - PY 700$0.00
00$0.00
00$0.00
030$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0047Training Emulators - PY 800$0.00
00$0.00
00$0.00
030$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0048Training Emulators - PY 900$0.00
00$0.00
00$0.00
030$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITY RANGEUNIT PRICEWEIGHTED MAXIMUM AMOUNT
0049Training Emulators - PY 1000$0.00
00$0.00
00$0.00
030$0.00
Average Weighted Unit Price$0.00$0.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0050System Technology Support (STS) PYs 3-5N/AN/A$17,538,165.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0051System Technology Support (STS) PY 6N/AN/A$5,846,055.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0052System Technology Support (STS) PY 7N/AN/A$5,846,055.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0053System Technology Support (STS) PY 8N/AN/A$5,846,055.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0054System Technology Support (STS) PY 9N/AN/A$5,846,055.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0055System Technology Support (STS) PY 10N/AN/A$5,846,055.00

NOTE: CLINs 0056-0059 are reserved for future use.

CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0060Sustainment Support - PYs 4-5N/AN/A$3,780,807.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0061Sustainment Support - PY 6N/AN/A$1,890,403.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0062Sustainment Support - PY 7N/AN/A$1,890,403.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0063Sustainment Support - PY 8N/AN/A$1,890,403.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0064Sustainment Support - PY 9N/AN/A$1,890,403.00
CLINSUPPLIES/SERVICESQUANTITYUNIT PRICENormalized Amount
0065Sustainment Support - PY 10N/AN/A$1,890,403.00
Total
$60,001,262.00

Example 1 Example 2

Ancillary Spares

LLDR 3 ANCILLARY PARTS/SPARES WORKSHEET
Offeror Data Entry in Yellow
This sheet represents the proposed ancillary parts/spares to be offered as part of the LLDR 3 system that are not included in any larger spared modules.
For each ancillary parts/spare item listed, offeror shall fill in National Stock Number (NSN) (if available), part number, unit of issue, and unit price.
For any additional, offeror proposed ancillary parts/spare item, Offeror shall fill in Description, NSN (if available), part number, unit of issue, and unit price.
If any spares entry row is unused, enter "n/a" in offeror data fields.
Do not delete unused spare entry rows.
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Tripod Assesmbly$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Energy Test Cover$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Multi-Media Training Adapter$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
USB Field Communications Cable$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Vehicle Power Cable$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Carry Bag$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Carry Bag$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Carry Bag$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Transport Case$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Transport Case$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Transport Case$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Hard Case$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Hard Case$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Hard Case$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
Lens Cleaning Kit$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
(Ancillary Spare - Offeror provided description)$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
(Ancillary Spare - Offeror provided description)$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
(Ancillary Spare - Offeror provided description)$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
(Ancillary Spare - Offeror provided description)$0.00
DESCRIPTIONNSNPart NumberUnit of IssueUNIT PRICE
(Ancillary Spare - Offeror provided description)$0.00

$0.00

File details come from the government source that posted it.