A.09.01.10 Combined Synopsis Attachment 2 Pricing Worksheet.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
HQ Maintenance Services
Solicitation number
HQC01026QE022
Issued by

About this file

This is a pricing worksheet for a preventive maintenance, unscheduled maintenance, and emergency maintenance contract for the Defense Commissary Agency (DeCA) Vogelweh Headquarters facility in Germany under Solicitation Number HQC01026QE022. The worksheet is structured around three contract line items (CLINs): CLIN 1 covers preventive maintenance (PM) services on facility equipment and systems; CLIN 2 addresses unscheduled and emergency maintenance (UM/EM) labor and materials; and CLIN 3 provides repair-by-replacement (RBR) services.

CLIN 1 establishes a fixed monthly cost of EUR 1,500 for the base year and each option year (OY1-OY3), covering scheduled PM checks on inventory items including contract management, gutters and downspouts, electronic key boxes, distribution panels, lighting systems, HVAC units, fire extinguishers, and miscellaneous facility equipment. CLIN 2 projects UM/EM costs at EUR 10,000 for the base year with annual escalation of approximately 3% (EUR 10,300 OY1, EUR 10,609 OY2, EUR 10,927.27 OY3), covering labor at specified hourly rates for normal and after-hours work plus a 10% materials handling charge. CLIN 3 shows a fixed DeCA estimate of EUR 3,000 per year for repair-by-replacement services across all contract periods. The total contract value spans four years with a cumulative cost of EUR 59,836.27 for the base year through OY3, escalating to EUR 64,319.33 when including OY4 pricing. All costs are denominated in Euros and all work must be managed through the Service Order Management System (SOMS) in compliance with EU standards and English-language documentation requirements.

View the file

Other files

Show all 15

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

CLIN 1 PM

OFFERED PRICETOTAL COST
Item CodeDescriptionObject Class CodeHQLine totalPM IntervalBase Year cost (Euro)OY1 Cost (EURO)OY2 Cost (EURO)OY3 Cost (EURO)Base Year cost (Euro)OY1 Cost (EURO)OY2 Cost (EURO)OY3 Cost (EURO)OY4 Cost (EURO)
ADRContract management (monthly)112€ 0€ 0€ 0€ 0ERROR:#REF!
BEGutters and Downspouts12€ 0€ 0€ 0€ 0ERROR:#REF!
EBElectronic Key Box21€ 0€ 0€ 0€ 0ERROR:#REF!
EFDistribution Panels, Electrical81€ 0€ 0€ 0€ 0ERROR:#REF!
EHInsect Light, UV12€ 0€ 0€ 0€ 0ERROR:#REF!
EJLightning Arrestor11€ 0€ 0€ 0€ 0ERROR:#REF!
EKExit Lights (per store x)1512€ 0€ 0€ 0€ 0ERROR:#REF!
FBFire Extinguishers (portable & wheeled, DeCA owned only)51€ 0€ 0€ 0€ 0ERROR:#REF!
GEVentilation System (stores after 2007)56€ 0€ 0€ 0€ 0ERROR:#REF!
HDHeating System24€ 0€ 0€ 0€ 0ERROR:#REF!
HISplit Unit Air Conditioning36€ 0€ 0€ 0€ 0ERROR:#REF!
HLMultisplit Unit Air Conditioning with up 4 inside units (includes indoor & outdoor units)26€ 0€ 0€ 0€ 0ERROR:#REF!
LALighting, Outside21€ 0€ 0€ 0€ 0ERROR:#REF!
LDLighting, Interior (offices, bathrooms & technical rooms)31€ 0€ 0€ 0€ 0ERROR:#REF!
MLLadders, All (stocking, etc. mobile only)81€ 0€ 0€ 0€ 0ERROR:#REF!
SHDispensers, Various11€ 0€ 0€ 0€ 0ERROR:#REF!
SNIce Maker14€ 0€ 0€ 0€ 0ERROR:#REF!
SXWater Heater, Electric21€ 0€ 0€ 0€ 0ERROR:#REF!
TAKitchen Unit (including Appliances)31€ 0€ 0€ 0€ 0ERROR:#REF!
TKElectrical Isolation Test (mobile electrical devices, "E check" only, i.e. BGV A3)2001€ 0€ 0€ 0€ 0ERROR:#REF!
TOFacility Walk Through (visual inspection) (record & report to store staff)14€ 0€ 0€ 0€ 0ERROR:#REF!
XXMiscellaneous items for inventory variation11DeCA Fixed amount10DeCA fixed amount€ 1,500€ 1,500€ 1,500€ 1,500€ 1,500
Total€ 1,500€ 1,500€ 1,500€ 1,500ERROR:#REF!
Enter the cost to preform 1 PM check on one of the inventory items in the yellow cells
The Excel will calculate the annual cost, using number of items on inventory type and number of PM/year

CLIN 2 UM-EM

CLIN 2 UM/EM
Work Hoursoffer total
Euro/HourLabor
BaseOY1OY2OY3Est of hoursBaseOY1OY2OY3
Normal hours rate2000 €0 €0 €0 €
After hours rate100 €0 €0 €0 €
MaterialsPer CentMaterials
BaseOY1OY2OY3Est of materialBaseOY1OY2OY3
Handling rate10,000 €10,000.00 €10,000.00 €10,000.00 €10,000.00 €
Enter as whole number (10 for 10%)

UM/EM total 10,000.00 € 10,000.00 € 10,000.00 € 10,000.00 €

Enter hourly rates for normal work hours in row 7
Enter hourly rates for after hours work in row 8
Enter material handling rate in row 12, use whole number %
All white cells will

CLIN 3 RBR

Values are DeCA estimate

Repair by ReplacementBaseOY1OY2OY3
DeCA estimate3,000.00 €3,000.00 €3,000.00 €3,000.00 €

Summary

Summary
All values are imported from other tabs
CLIN 1 PMPM
BaseOY1OY2OY3
From other tab1,500.00 €1,500.00 €1,500.00 €1,500.00 €
CLIN 2 UM/EM
Work Hoursoffer total
Euro/HourLabor
BaseOY1OY2OY3OY4Est of hoursBaseOY1OY2OY3
Normal hours rate0000ERROR:#REF!2000 €0 €0 €0 €
After hours rate0000ERROR:#REF!100 €0 €0 €0 €
MaterialsPer CentMaterials
BaseOY1OY2OY3OY4Est of materialBaseOY1OY2OY3
Handling rate0000ERROR:#REF!10,000 €10,000.00 €10,300.00 €10,609.00 €10,927.27 €

UM/EM total 10,000.00 € 10,300.00 € 10,609.00 € 10,927.27 €

Optional CLINS
Repair by ReplacementBaseOY1OY2OY3
DeCA estimate3,000.00 €3,000.00 €3,000.00 €3,000.00 €
BaseOY1OY2OY3
Contract total14,500.00 €14,800.00 €15,109.00 €15,427.27 €
Total59,836.27 €
64,319.33 €
Make no entries here
All values are from other tabs

File details come from the government source that posted it. Updated .