A.15.01.03.10 Solicitation Attachment 1 Pricing Sheet.xlsx

This is a Pricing Sheet template for a comprehensive maintenance services contract at the Spangdahlem Commissary facility in Germany. The spreadsheet is organized into four main pricing sections (CLINs): CLIN 1 for Preventive Maintenance (PM), CLIN 2 for Unscheduled and Emergency Maintenance (UM/EM), CLIN 3 for Repair by Replacement (optional), and CLIN 4 for Work Order tracking system (optional).

CLIN 1 breaks down PM pricing by equipment type and cost code across multiple occupancy categories (2512, 2516, 2521), with line items for over 300 pieces of equipment including fire alarm systems, intrusion alarms, HVAC systems, refrigeration units, electrical panels, doors, lighting, kitchen equipment, and various facility infrastructure. Contractors must enter unit costs per preventive maintenance service, and Excel calculates total annual costs for each equipment item multiplied by required service intervals across a Base year plus two optional years (OY1, OY2). CLIN 2 requires contractors to provide hourly labor rates (normal and after-hours), material handling percentages, and estimated hours for non-emergency repairs and emergency services. The pricing structure includes estimated hours (750 normal, 50 after-hours) and material handling rate of 33,000 EUR baseline. CLIN 3 allows for an optional repair-by-replacement pricing approach with a DeCA estimate baseline of 10,000 EUR. The instructions specify that only yellow cells should contain contractor data and that formulas in white cells must remain unaltered. The contract summary shows a total contract value of 129,000 EUR (approximately $138,664.95 at a 0.9303 EUR/USD exchange rate) when including the optional Repair by Replacement CLIN.