Price and Delivery Spreadsheet R2.xlsx

This is a Price and Delivery Spreadsheet for spare parts procurement supporting the CECOM Mast Group, Hydraulic-Pneumatic OA-9054(V)4/G (AMG). The spreadsheet details fourteen spare parts across a five-year contract period, with estimated annual quantities ranging from 2 to 16 units depending on the item. Key parts include Rotary Pump Unit (NSN 4320-01-259-0796, 9 units annually), Pneumatic Component (NSN 5895-01-126-2477, 14 units annually), Hydraulic Component (NSN 5985-01-126-2478, 16 units annually), and Antenna Positioner (NSN 5985-01-192-2031, 8 units annually). The spreadsheet includes tiered quantity pricing ranges for each item, enabling cost evaluation across different procurement volumes. For example, some items have three pricing tiers (Range A, B, and C), while others have quantity breakpoints such as 1-3, 4-8, and 9-15 units.

The delivery requirements section specifies initial shipment quantities with a 180-day production lead time and follow-on monthly quantities of 10 units. The spreadsheet establishes First Article Testing (FAT) submission and delivery milestones at 30, 90, 150, 210, and 270 days after receipt of order for FAT-related deliverables, with final test reports due at specified intervals. This pricing template is designed to support the Firm Fixed Price Indefinite Delivery/Indefinite Quantity contract, which is a total small business set-aside with a five-year base period, a guaranteed minimum of $25,000, and a maximum contract value of $13,000,000 across all awards.