Attachment 14- PE-03_BOM_and_Cleaning_and_Paint_FFP_Bidding Schedule.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
USAG-Stuttgart Base Operations
Solicitation number
W91WFU27RA001
Issued by

About this file

This is a Firm-Fixed-Price (FFP) Bidding Schedule for recurring housing turnover and painting services under an Indefinite Delivery, Indefinite Quantity (IDIQ) contract for Base Operations Support services at USAG Stuttgart. The schedule establishes pricing for three distinct service categories: Standard Between-Occupancy-Maintenance (BOM) turnovers, Full Interior Painting services, and Cleaning-Only services, with an additional Expedited BOM Surcharge option.

The bidding schedule covers housing units across multiple categories including Armed Forces Housing (AFH) units of 2, 3, 4, and 5/6 bedrooms; Government-Furnished Officer Quarters (GFOQ) single houses; and Unaccompanied Personnel Housing (UPH) units of 1, 2, and 3 bedrooms, totaling 2,020 units in inventory. Offerors must submit all-inclusive unit prices for each housing type and service category, with estimated annual quantities ranging from 4 to 297 turnovers depending on unit type and service. The Standard BOM is based on a 2–3 year turnover cycle (approximately 800 annual events), Full Interior Painting quantities reflect a 5-year lifecycle plan (approximately 404 annual events or one-fifth of inventory annually), and Cleaning-Only services represent rare exceptions with fixed minimal quantities. Pricing must include all labor, materials, equipment, transportation, supervision, overhead, and profit. The schedule emphasizes that all quantities are good-faith estimates only and do not guarantee actual order volumes; the Government is obligated only to order the minimum guaranteed amount specified in the contract. Work will be authorized through individual Preventative Work Orders (PWOs) structured with line items sourced from the appropriate contract schedules, with routine turnovers typically including only the Standard BOM line item and programmed painting turnovers including both BOM and Full Interior Paint line items.

View the file

Other files

Show all 14

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

INSTRUCTIONS

"Instructions and Guidance for Bidding Schedule PE-03"

1. General Purpose This workbook is the official Bidding Schedule for all predictable, recurring, and programmed turnover services under CLINs X008 (UPH) and X018 (AFH). All on-demand, non-routine, or damage-related repairs are priced separately under other contract schedules.

2. Structure of the Bidding Schedule This schedule is organized into three (3) distinct tables:

Table 1: STANDARD BOM (All-Inclusive): This represents the single, all-inclusive price for a standard turnover. This price includes all general maintenance tasks listed in TE-I-02/TE-C-02 and all deep cleaning tasks listed in TE-I-03/TE-C-03. The quantity is based on the estimated number of annual turnovers.

Table 2: FULL INTERIOR PAINT: This represents the price for a complete interior repaint of a unit. The quantity is based on the Government's 5-year lifecycle plan (1/5th of inventory per year).

Table 3: CLEANING ONLY SERVICE (Special Use): This represents the price for a cleaning-only turnover, to be used only in rare circumstances (e.g., a failed assignment) at the express direction of the COR. The quantity is a small, fixed estimate based on historical exceptions.

3. Instructions for Price Submission Proposed Unit Price: Offerors shall enter their proposed Firm-Fixed-Price (FFP) for one (1) unit of work in the column titled "Offeror's Proposed FFP per Unit ($)". This is the only column where pricing data should be manually entered.

All-Inclusive Pricing: The proposed unit price shall be all-inclusive, covering all labor, materials, equipment, transportation, supervision, overhead (G&A), and profit required to complete the task as described in the contract's Performance Work Statement (PWS).

Total Annual Price: The column titled "Offeror's Total Annual Price ($)" is protected and contains a formula (Quantity × Unit Price). This column will auto-populate and must not be altered. The sum of this column for all three tables will be used to determine the Offeror's total evaluated price for this CLIN.

4. Notice Regarding Estimated Quantities (IDIQ Clause) The quantities provided in the "Estimated Annual Quantity" column are good-faith estimates for bid evaluation purposes only. These estimates are not a guarantee of the actual quantity of work that will be ordered. This is an Indefinite Delivery, Indefinite Quantity (IDIQ) contract. The Government is obligated only to order the minimum guaranteed amount specified elsewhere in the contract. Orders will be placed on an as-needed basis, subject to the availability of funds and verified requirements.

5. Billing and Execution The Government will authorize work via individual Preventative Work Orders (PWOs) for BOM services. A single PWO for a unit turnover will be structured with distinct sub-CLINs sourced from the appropriate contract schedules.

Routine Turnover (The 95% Case): A PWO for a standard turnover will include, at a minimum, one line item:

CLIN 0018AB - STANDARD BOM (All-Inclusive) - Priced from this PE-03 Schedule

Turnover with Programmed Painting: If a unit is also due for its lifecycle repaint, the PWO will include two line items:

CLIN 0018AB - STANDARD BOM (All-Inclusive) - Priced from this PE-03 Schedule CLIN 0018AJ - FULL INTERIOR PAINT - Priced from this PE-03 Schedule

Turnover with On-Demand "Add-On" Repairs: If the unit requires a major, non-routine repair (e.g., subfloor replacement), that work will be added as a separate line item priced from the On-Demand Bidding Schedules (PE-02, etc.).

ANNUAL LOAD

Unit CategoryTotal Unit InventoryTurnover Cycle (Years)Turnover Rate (Annual)Estimated Annual BOM QuantityEstimated Total 5-Year BOM QuantityEstimated Total 5-Year Full Painting Quantity
AFH - 2 BDR216333.30%72360216
AFH - 3 BDR741333.30%2471,235741
AFH - 4 BDR210333.30%70350210
AFH - 5/6 BDR97333.30%3216097
GFOQ - HOUSE65250.00%3316565
UPH - 1 ROOM594250.00%2971,485594
UPH - 2 ROOM90250.00%4522590
UPH - 3 ROOM7250.00%4207
TOTAL2,0208004,0012,020

Narrative for Annual Workload Summary Tab

Title: Annual Workload Summary & Basis of Estimates

1. Purpose This document provides Offerors with an overview of the estimated annual workload for housing turnover services. These figures represent the Government's good-faith estimate based on historical data and strategic lifecycle planning and are provided for informational purposes only. The official quantities for bidding are those listed in the Bidding Schedule.

2. Description of Workload Categoris The annual workload is broken down into two distinct categories:

A. Estimated Annual BOM Turnovers (~800 Events/Year): This represents the estimated number of housing units that will undergo a Standard Between-Occupancy-Maintenance (BOM) Turnover each year. This quantity is the basis for the "STANDARD BOM (All-Inclusive)" line items in the Bidding Schedule. This estimate is derived from historical turnover rates (typically a 2-3 year cycle).

B. Estimated Annual Lifecycle Painting (~404 Events/Year): This represents the number of units scheduled for a Full Interior Paint each year as part of the Government's 5-Year Lifecycle Sustainment Plan. This quantity is calculated as one-fifth (1/5th) of the total housing inventory and is the basis for the "FULL INTERIOR PAINT" line items.

3. Notice Regarding Estimated Quantities (IDIQ Clause) Crucially, all quantities provided in this summary and in the detailed bidding schedules are estimates only.

This is an Indefinite Delivery, Indefinite Quantity (IDIQ) contract. The Government is under no obligation to order any quantity up to the estimated amount shown. The quantities are not a promise or guarantee of the actual volume of work that will be ordered. The Government is obligated only to order the minimum guaranteed amount specified elsewhere in the contract. Actual orders will be placed based on real-world requirements and the availability of funds.

BIDING SCHEDULE

CLINHousing TypeBedrooms/Unit TypeWork CategoryEstimated Annual Quantity (Turnovers)Offeror's Proposed FFP per Unit ($)Offeror's Total Annual Price ($BASE YEAROY1OY2OY3OY4
X018AFH2 BedroomsSTANDARD BOM (All-Inclusive: maintenance+ cleaning)72[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH3 BedroomsSTANDARD BOM (All-Inclusive: maintenance+ cleaning)247[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH4 BedroomsSTANDARD BOM (All-Inclusive: maintenance+ cleaning)70[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH5/6 BedroomsSTANDARD BOM (All-Inclusive: maintenance+ cleaning)32[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018GFOQSingle HouseSTANDARD BOM (All-Inclusive: maintenance+ cleaning)
Note on GFOQ Pricing: The Offeror's proposed FFP for the 'STANDARD BOM - GFOQ' line item shall be all-inclusive. In addition to the standard tasks in TE-I-02 and TE-I-03, this price must also include the cost of professional dry-cleaning for all Government-furnished curtains in the unit, as required by TE-I-02, Task 6.5."33[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018Total
X008UPH1 BedroomSTANDARD BOM (All-Inclusive: maintenance+ cleaning)297[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008UPH2 BedroomsSTANDARD BOM (All-Inclusive: maintenance+ cleaning)45[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008UPH3 BedroomsSTANDARD BOM (All-Inclusive: maintenance+ cleaning)4[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008Total
CLINHousing TypeBedrooms/Unit TypeWork Category - This surcharge is paid in addition to the Standard BOM price when a 4-day (AFH) or 1-day (UPH) turnaround is ordered (5% of Annual QTY)Estimated Annual Quantity (Turnovers)Offeror's Proposed FFP per Unit ($)Offeror's Total Annual Price ($BASE YEAROY1OY2OY3OY4
X018AFH2 BedroomsEXPEDITED BOM SURCHARGE4[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH3 BedroomsEXPEDITED BOM SURCHARGE12[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH4 BedroomsEXPEDITED BOM SURCHARGE4[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH5/6 BedroomsEXPEDITED BOM SURCHARGE2[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018GFOQSingle HouseEXPEDITED BOM SURCHARGE2[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018Total
CLINHousing TypeBedrooms/Unit TypeWork CategoryEstimated Annual Quantity (Turnovers)Offeror's Proposed FFP per Unit ($)Offeror's Total Annual Price ($BASE YEAROY1OY2OY3OY4
X018AFH2 BedroomsCLEANNING ONLY SERVICE1[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH3 BedroomsCLEANNING ONLY SERVICE5[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH4 BedroomsCLEANNING ONLY SERVICE1[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH5/6 BedroomsCLEANNING ONLY SERVICE1[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018GFOQSingle HouseCLEANNING ONLY SERVICE1[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018Total
X008UPH1 BedroomCLEANNING ONLY SERVICE4[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008UPH2 BedroomsCLEANNING ONLY SERVICE1[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008UPH3 BedroomsCLEANNING ONLY SERVICE1[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008Total
X018AFH2 BedroomsFULL INTERIOR PAINTING43[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH3 BedroomsFULL INTERIOR PAINTING148[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH4 BedroomsFULL INTERIOR PAINTING42[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018AFH5/6 BedroomsFULL INTERIOR PAINTING19[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018GFOQSingle HouseFULL INTERIOR PAINTING13[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X018Total
X008UPH1 BedroomFULL INTERIOR PAINTING119[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008UPH2 BedroomsFULL INTERIOR PAINTING18[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008UPH3 BedroomsFULL INTERIOR PAINTING1[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008Total
CLINService CategoryUnit of IssueDescriptionEstimated Annual QuantityOfferor's Proposed FFP per Unit ($)Offeror's Total Annual Price ($BASE YEAROY1OY2OY3OY4
X018AFHEA (Each)On-Demand Vacant Unit Inspection (IAW Annex I, PWS 6.1)50[Formula][SUM][SUM][SUM][SUM][SUM][SUM]
X008UPHEA (Each)On-Demand Vacant Unit Inspection (IAW Annex C, PWS 6.1)20[Formula][SUM][SUM][SUM][SUM][SUM][SUM]

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