Attachment 0004 - Pricing Worksheet.xlsx

This is a pricing worksheet attachment for a federal solicitation requiring offerors to submit unit prices for the supply of M68 Optic Close Combat Sight Reflex components across a five-year Indefinite Delivery, Indefinite Quantity (IDIQ) contract. The worksheet is structured as an Excel template with five ordering year tabs, each containing contract line items (CLINs) for production quantities and contract data requirements lists (CDRLs) marked as Not Separately Priced (NSP).

Offerors must input company name and unit prices in yellow-highlighted cells only, with prices formatted to no more than two decimal places as numerical values. The pricing structure includes CLIN 0011 for First Article Testing (FAT) as a single unit, followed by CLINs 0101-0105 for production quantities organized by tiered quantity brackets (200-500 units at 20% weighting, 501-1,000 at 20%, 1,001-3,000 at 20%, and 3,001-7,000 at 40%). Each ordering year has an estimated quantity of 6,468 units, except Order Year 5 which references the cumulative maximum of 32,340 units across all five years. The worksheet automatically calculates weighted average unit prices and total prices for each ordering year, with all formulas protected to prevent manipulation. CDRLs include Engineering Change Proposals (ECP), Requests for Variance (RFV), and Notices of Revision (NOR), all marked as NSP and requiring no pricing input.