SWAEA Pricing Spreadsheet Summary

This is a detailed pricing and product template spreadsheet for the Subsistence Prime Vendor (SPV) solicitation SPE300-26-R-0001 serving Southwest Asia and Eastern Africa regions. The spreadsheet captures pricing data across two geographic zones with three pricing tiers based on order quantity thresholds (Tier #1: 24 months, Tier #2: 18 months, Tier #3: 18 months). The document includes a comprehensive market basket of 114+ line items spanning dried and canned goods, frozen proteins (beef, poultry, seafood, pork), fresh produce, dairy products, beverages, bakery items, condiments, spices, and non-food items such as food service operating supplies and toiletries. Each product entry contains historical evaluation units, offered quantities, unit of measure conversions, product pricing, distribution pricing categories (ranging from CONUS dry goods to perishable airlift services), and aggregated pricing calculations for five-year contract projections weighted by both customer type (Navy versus all other customers) and geographic zone.

The pricing structure distinguishes between Navy-only distribution channels and all other federally funded customers, with separate aggregated prices calculated for each. Distribution categories include standard CONUS and OCONUS delivery options, specialized handling for perishables requiring airlift, wet ice, dry ice, and various value-added services such as inspection, storage, relabeling, and emergency order surcharges. The template enables offerors to quote competitive pricing while incorporating geographic supply chain complexities, including customs clearance, transportation costs, and regional availability constraints. All pricing calculations reference historical demand patterns and anticipated usage volumes to establish baseline cost structures for the IDIQ contract with economic price adjustment provisions.