1A 12319826R50001 Retailer Investigations Pricing spreedsheet.xlsx

This is a pricing spreadsheet template for the Retailer Investigations contract solicitation 12319826R5000 issued by the USDA Food and Nutrition Service, Office of Retailer Operations and Compliance. Vendors are required to submit unit costs for investigative passes in Column E, with all travel costs locked at predetermined amounts. The contract encompasses a base year plus four option years, with estimated quantities of investigative passes ranging from 23,410 in the base year to 26,347 in Option Year 4, and travel costs capped at a Not-to-Exceed (NTE) amount of $100,000 for the base year and $100,000 annually for each option year. The total contract value across all years is $500,000, excluding travel costs from the base calculation, indicating that vendors must price only the investigative passes while travel expenses remain fixed.

The pricing structure requires vendors to calculate individual unit costs for each investigative pass throughout the five-year contract period (base year plus four options). Vendors have no flexibility in pricing travel components, as these cells are locked with predetermined NTE amounts. The spreadsheet tracks cumulative costs across multiple line items (CLINs) organized by contract year, with the base year CLINs 0001-0002, Option Year 1 CLINs 1001-1002, and continuing through Option Year 4 CLINs 4001-4002. This contract supports the integrity of the Supplemental Nutrition Assistance Program (SNAP) through nonpersonal investigative services related to retailer compliance and operations.