Attachment 2 Southern Europe-Northern Africa and Western Africa Pricing Spreadsheet.xlsx

This is a pricing spreadsheet for a Subsistence Prime Vendor (SPV) contract (Solicitation SPE300-26-R-0011) covering Southern Europe/Northern Africa and Western Africa regions. The spreadsheet contains a market basket of 92+ food line items with historical and offered unit pricing across two geographic zones (Zone 2 for Southern Europe & Northern Africa, and Zone 3 for Western Africa). Products include frozen and fresh proteins (beef, poultry, seafood), produce (fresh fruits and vegetables), dairy items, beverages, frozen prepared foods, and dry goods sourced from the continental United States. The pricing structure includes weighted product prices calculated at 30% weighting, aggregate pricing for 5-year contract terms, and distribution price categories organized by product type (dry case stock, frozen case stock, fresh produce, water, etc.) with tiered delivery options based on contract months (Tier #1: 24 months, Tier #2: 18 months, Tier #3: 18 months). Multiple columns track evaluated quantities based on historical demand versus offered quantities, with error values (#DIV/0!) indicating incomplete pricing submissions. A separate distribution worksheet details 45+ distribution price categories including standard shipping, airlift options for perishable and semi-perishable items, inspection and storage services, and specialized handling (dry ice, tri-wall pallets, cross-leveling). The spreadsheet references current catalog countries including Italy, Bulgaria, Croatia, Cyprus, Georgia, Greece, Israel, Kosovo, Macedonia, Moldova, Morocco, Romania, Slovenia, Spain, Tunisia, Turkey, Egypt, Niger, Gabon, Ghana, Nigeria, Senegal, and Côte d'Ivoire, with demand totals shown by country for each line item in both zones.