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
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 Category | Total Unit Inventory | Turnover Cycle (Years) | Turnover Rate (Annual) | Estimated Annual BOM Quantity | Estimated Total 5-Year BOM Quantity | Estimated Total 5-Year Full Painting Quantity |
| AFH - 2 BDR | 216 | 3 | 33.30% | 72 | 360 | 216 |
| AFH - 3 BDR | 741 | 3 | 33.30% | 247 | 1,235 | 741 |
| AFH - 4 BDR | 210 | 3 | 33.30% | 70 | 350 | 210 |
| AFH - 5/6 BDR | 97 | 3 | 33.30% | 32 | 160 | 97 |
| GFOQ - HOUSE | 65 | 2 | 50.00% | 33 | 165 | 65 |
| UPH - 1 ROOM | 594 | 2 | 50.00% | 297 | 1,485 | 594 |
| UPH - 2 ROOM | 90 | 2 | 50.00% | 45 | 225 | 90 |
| UPH - 3 ROOM | 7 | 2 | 50.00% | 4 | 20 | 7 |
| TOTAL | 2,020 | 800 | 4,001 | 2,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
| CLIN | Housing Type | Bedrooms/Unit Type | Work Category | Estimated Annual Quantity (Turnovers) | Offeror's Proposed FFP per Unit ($) | Offeror's Total Annual Price ($ | BASE YEAR | OY1 | OY2 | OY3 | OY4 |
| X018 | AFH | 2 Bedrooms | STANDARD BOM (All-Inclusive: maintenance+ cleaning) | 72 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 3 Bedrooms | STANDARD BOM (All-Inclusive: maintenance+ cleaning) | 247 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 4 Bedrooms | STANDARD BOM (All-Inclusive: maintenance+ cleaning) | 70 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 5/6 Bedrooms | STANDARD BOM (All-Inclusive: maintenance+ cleaning) | 32 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | GFOQ | Single House | STANDARD 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] |
| X018 | Total |
| X008 | UPH | 1 Bedroom | STANDARD BOM (All-Inclusive: maintenance+ cleaning) | 297 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | UPH | 2 Bedrooms | STANDARD BOM (All-Inclusive: maintenance+ cleaning) | 45 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | UPH | 3 Bedrooms | STANDARD BOM (All-Inclusive: maintenance+ cleaning) | 4 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | Total | ||||||||||
| CLIN | Housing Type | Bedrooms/Unit Type | Work 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 YEAR | OY1 | OY2 | OY3 | OY4 |
| X018 | AFH | 2 Bedrooms | EXPEDITED BOM SURCHARGE | 4 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 3 Bedrooms | EXPEDITED BOM SURCHARGE | 12 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 4 Bedrooms | EXPEDITED BOM SURCHARGE | 4 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 5/6 Bedrooms | EXPEDITED BOM SURCHARGE | 2 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | GFOQ | Single House | EXPEDITED BOM SURCHARGE | 2 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | Total | ||||||||||
| CLIN | Housing Type | Bedrooms/Unit Type | Work Category | Estimated Annual Quantity (Turnovers) | Offeror's Proposed FFP per Unit ($) | Offeror's Total Annual Price ($ | BASE YEAR | OY1 | OY2 | OY3 | OY4 |
| X018 | AFH | 2 Bedrooms | CLEANNING ONLY SERVICE | 1 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 3 Bedrooms | CLEANNING ONLY SERVICE | 5 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 4 Bedrooms | CLEANNING ONLY SERVICE | 1 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 5/6 Bedrooms | CLEANNING ONLY SERVICE | 1 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | GFOQ | Single House | CLEANNING ONLY SERVICE | 1 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | Total |
| X008 | UPH | 1 Bedroom | CLEANNING ONLY SERVICE | 4 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | UPH | 2 Bedrooms | CLEANNING ONLY SERVICE | 1 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | UPH | 3 Bedrooms | CLEANNING ONLY SERVICE | 1 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | Total |
| X018 | AFH | 2 Bedrooms | FULL INTERIOR PAINTING | 43 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 3 Bedrooms | FULL INTERIOR PAINTING | 148 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 4 Bedrooms | FULL INTERIOR PAINTING | 42 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | AFH | 5/6 Bedrooms | FULL INTERIOR PAINTING | 19 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | GFOQ | Single House | FULL INTERIOR PAINTING | 13 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X018 | Total |
| X008 | UPH | 1 Bedroom | FULL INTERIOR PAINTING | 119 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | UPH | 2 Bedrooms | FULL INTERIOR PAINTING | 18 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | UPH | 3 Bedrooms | FULL INTERIOR PAINTING | 1 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | Total | ||||||||||
| CLIN | Service Category | Unit of Issue | Description | Estimated Annual Quantity | Offeror's Proposed FFP per Unit ($) | Offeror's Total Annual Price ($ | BASE YEAR | OY1 | OY2 | OY3 | OY4 |
| X018 | AFH | EA (Each) | On-Demand Vacant Unit Inspection (IAW Annex I, PWS 6.1) | 50 | [Formula] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] | [SUM] |
| X008 | UPH | EA (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 .