27REBAUMHOLDER_Attachment 1_ROM_090926.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- DoWEA Daily Commute Student Transportation Services to the Baumholder Military Community, Germany
- Solicitation number
- HE1254-27-RE-BAUMHOLDER
- Issued by
-
Department of Defense Education Activity
About this file
This is a Rate of Markup (ROM) spreadsheet that appears to be a pricing template or cost estimation tool related to the DoWEA Daily Commute Student Transportation Services requirement for Baumholder Military Community in Germany. The file is formatted as an Excel worksheet designed to calculate or document markup rates, likely for use in preparing pricing proposals for the student bus transportation services solicitation (HE1254-27-RE-BAUMHOLDER). The ROM tool would enable potential contractors to establish and track cost markups across various service categories or line items associated with the transportation contract, which is scheduled to commence on August 1, 2027.
The spreadsheet serves as a financial planning instrument for prospective bidders responding to this pre-solicitation market research phase. Given that the underlying requirement involves comprehensive student transportation services—including personnel (drivers, safety attendants, supervision), equipment, supplies, and all necessary resources to support the Baumholder Military Community—the ROM template likely facilitates calculation of profitability margins across different cost categories. As this is a pre-solicitation RFI phase for market research purposes, the ROM attachment provides a baseline pricing structure or methodology that may be refined prior to formal solicitation release expected later in 2027.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 27REBAUMHOLDER_RFI_SSN_091826.pdf | ||
| 27REBAUMHOLDER_RFI_SSN_090926.pdf | ||
| 27REBAUMHOLDER_RFI_SSN_090826.pdf | ||
| 27REBAUMHOLDER_RFI_SSN_090326.pdf | ||
| 27REBAUMHOLDER_Attachment 1_ROM_090326.xlsx | XLSX spreadsheet | |
| 27REBAUMHOLDER_PWS_090326.pdf |
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
ROM Cost Breakdown
| Base Period | |||||||||||
| Labor Category | # of Personnel | # of Labor Hours | Direct Rate | Direct Labor | Fringe | Overhead | G&A | Fee | Total | ||
| Daily Commute Driver | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | ||||
| Co-Curricular/Curricular | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | ||||
| Safety Attendant | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | Indirect Cost Element | Rate (%) | ||
| Dispatcher | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | Fringe | |||
| Contract Manager | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | Overhead | |||
| Alternate Contract Manager | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | G&A | |||
| € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | Fee | ||||
| Base Period Labor | 0 | 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | |||
| Subtotal Fleet Capital & Operating Cost | |||||||||||
| Vehicle Capital/Lease Cost | € - 0 | ||||||||||
| Vehicle Depreciation | € - 0 | ||||||||||
| Maintenance & Repair Cost | € - 0 | ||||||||||
| Fuel (Diesel/Gas) | € - 0 | ||||||||||
| Fleet Insurance | € - 0 | ||||||||||
| Vehicle Inspections (state, host nation) | € - 0 | ||||||||||
| Vehicle Enhancements (GPS, Routing Software, etc) | € - 0 | ||||||||||
| Vehicle Overhead & G&A | € - 0 | ||||||||||
| Subtotal Fleet Capital & Operating Cost | € - 0 | ||||||||||
| Other Direct Cost (ODCs) | |||||||||||
| Driver Training | € - 0 | ||||||||||
| Safety Training | € - 0 | ||||||||||
| Other ODCs | € - 0 | ||||||||||
| Subtotal ODC Cost | € - 0 |
Base Year Total Estimated Price € - 0
Rough Order of Magnitude (ROM) Pricing Workbook Instructions
Tab 1 – Complete all yellow cells, as applicable, including the Indirect Cost Element table.
Tab 2 – Complete all yellow cells with unit prices. Totals will calculate automatically.
Tab 3 – Cost element definitions.
Note - Add any additional cost elements not included in Tab 1.
ROM CLIN Structure
| SOLICITATION HE125427REBAUMHOLDER |
| DoWEA EUROPE CENTRAL |
| Baumholder Daily Commute Transportation Services |
| Summary of Base plus Option Periods |
| Baumholder Daily Commute Student Transportation | Base Year School Year 2027-2028 | ||||
| CLIN | Description | Unit of Issue | Quantity | Unit Price | Total Cost |
| 0001 | Daily Commute Transportation Service | ||||
| 0001AA | Ridership Population 351-450 | Days | 180 | € - 0 | € - 0 |
| 0001AB | Ridership Population 451-550 | Days | 180 | € - 0 | € - 0 |
| 0001AC | Curricular (career practicum, gym, day trips, etc) | Runs | 1500 | € - 0 | € - 0 |
| 0001AD | Co-Curricular (late activity, sports, etc) | Runs | 1500 | € - 0 | € - 0 |
| 0001AE | Safety Attendants | Runs | 15000 | € - 0 | € - 0 |
| 0001AF | Drivers Training | Sessions | 2 | € - 0 | € - 0 |
| 0001AG | Student Safety Training | Sessions | 4 | € - 0 | € - 0 |
| BASE YEAR TOTAL | € - 0 |
| Baumholder Daily Commute Student Transportation | Option Year One School Year 2028-2029 | ||||
| CLIN | Description | Unit of Issue | Quantity | Unit Price | Total Cost |
| 1001 | Daily Commute Transportation Service | ||||
| 1001AA | Ridership Population 351-450 | Days | 180 | € - 0 | € - 0 |
| 1001AB | Ridership Population 451-550 | Days | 180 | € - 0 | € - 0 |
| 1001AC | Curricular (career practicum, gym, day trips, etc) | Runs | 1500 | € - 0 | € - 0 |
| 1001AD | Co-Curricular (late activity, sports, etc) | Runs | 1500 | € - 0 | € - 0 |
| 1001AE | Safety Attendants | Runs | 15000 | € - 0 | € - 0 |
| 1001AF | Drivers Training | Sessions | 2 | € - 0 | € - 0 |
| 1001AG | Student Safety Training | Sessions | 4 | € - 0 | € - 0 |
| OPTION YEAR 1 TOTAL | € - 0 |
| Baumholder Daily Commute Student Transportation | Option Year Two School Year 2029-2030 | ||||
| CLIN | Description | Unit of Issue | Quantity | Unit Price | Total Cost |
| 2001 | Daily Commute Transportation Service | ||||
| 2001AA | Ridership Population 351-450 | Days | 180 | € - 0 | € - 0 |
| 2001AB | Ridership Population 451-550 | Days | 180 | € - 0 | € - 0 |
| 2001AC | Curricular (career practicum, gym, day trips, etc) | Runs | 1500 | € - 0 | € - 0 |
| 2001AD | Co-Curricular (late activity, sports, etc) | Runs | 1500 | € - 0 | € - 0 |
| 2001AE | Safety Attendants | Runs | 15000 | € - 0 | € - 0 |
| 2001AF | Drivers Training | Sessions | 2 | € - 0 | € - 0 |
| 2001AG | Student Safety Training | Sessions | 4 | € - 0 | € - 0 |
| OPTION YEAR 2 TOTAL | € - 0 |
| Baumholder Daily Commute Student Transportation | Option Year Three School Year 2030-2031 | ||||
| CLIN | Description | Unit of Issue | Quantity | Unit Price | Total Cost |
| 3001 | Daily Commute Transportation Service | ||||
| 3001AA | Ridership Population 351-450 | Days | 180 | € - 0 | € - 0 |
| 3001AB | Ridership Population 451-550 | Days | 180 | € - 0 | € - 0 |
| 3001AC | Curricular (career practicum, gym, day trips, etc) | Runs | 1500 | € - 0 | € - 0 |
| 3001AD | Co-Curricular (late activity, sports, etc) | Runs | 1500 | € - 0 | € - 0 |
| 3001AE | Safety Attendants | Runs | 15000 | € - 0 | € - 0 |
| 3001AF | Drivers Training | Sessions | 2 | € - 0 | € - 0 |
| 3001AG | Student Safety Training | Sessions | 4 | € - 0 | € - 0 |
| OPTION YEAR 3 TOTAL | € - 0 |
| Baumholder Daily Commute Student Transportation | Option Year Four School Year 2031-2032 | ||||
| CLIN | Description | Unit of Issue | Quantity | Unit Price | Total Cost |
| 4001 | Daily Commute Transportation Service | ||||
| 4001AA | Ridership Population 351-450 | Days | 180 | € - 0 | € - 0 |
| 4001AB | Ridership Population 451-550 | Days | 180 | € - 0 | € - 0 |
| 4001AC | Curricular (career practicum, gym, day trips, etc) | Runs | 1500 | € - 0 | € - 0 |
| 4001AD | Co-Curricular (late activity, sports, etc) | Runs | 1500 | € - 0 | € - 0 |
| 4001AE | Safety Attendants | Runs | 15000 | € - 0 | € - 0 |
| 4001AF | Drivers Training | Sessions | 2 | € - 0 | € - 0 |
| 4001AG | Student Safety Training | Sessions | 4 | € - 0 | € - 0 |
| OPTION YEAR 4 TOTAL | € - 0 |
| Baumholder Daily Commute Student Transportation | FAR 52.217-8 Option School Year 2027-2032 | ||||
| FAR 52.217-8 Option to Extend Services may be exercised for an additional six (6) months of service to be exercised at any time during the contract. Considering the potential exercise of FAR 52.217-8, the unit prices proposed for Option Period 4 will be considered in making the award. | |||||
| CLIN | Description | Unit of Issue | Quantity | Unit Price | Total Cost |
| 5001 | Daily Commute Transportation Service | ||||
| 5001AA | Ridership Population 351-450 | Days | 90 | € - 0 | € - 0 |
| 5001AB | Ridership Population 451-550 | Days | 90 | € - 0 | € - 0 |
| 5001AC | Curricular (career practicum, gym, day trips, etc) | Runs | 750 | € - 0 | € - 0 |
| 5001AD | Co-Curricular (late activity, sports, etc) | Runs | 750 | € - 0 | € - 0 |
| 5001AE | Safety Attendants | Runs | 7500 | € - 0 | € - 0 |
| 5001AF | Drivers Training | Sessions | 1 | € - 0 | € - 0 |
| 5001AG | Student Safety Training | Sessions | 2 | € - 0 | € - 0 |
| FAR 52.217-8 OPTION TOTAL | € - 0 |
Cost Element Descriptions
1. Labor Category Development Labor categories were developed to support the objectives from the PWS that the labor categories address.
2. Direct Labor Rate Direct Labor is the cost of labor that can be specifically identified and charged to this specific student transportation requirements. These employees perform the actual work required by the contract.
3 Indirect Cost Structure Fringe Benefits: Includes benefits such as health insurance, retirement contributions, payroll taxes, and paid leave, as applicable.
Overhead: Covers indirect labor, facilities, equipment, utilities, and program support costs.
General & Administrative (G&A): Covers corporate-level expenses including finance, HR, legal, and executive management.
Fee/Profit: Represents contractor profit consistent with competitive federal services contracting environments.
4. Escalation :Expected wage inflation in the area(s) where contract performance will take place labor market Anticipated increases in compensation for cleared and specialized personnel
5. Fleet Capital & Operating Cost Development Fleet capital and operating costs required to acquire, maintain, and operate vehicles and equipment dedicated to or utilized in direct support of the PWS requirements.
| -Cost Composition: the estimate accounts for both capital components (such as vehicle depreciation, capital lease charges or financing costs) compliant with FAR 31.205-11 and operating components (including fuel, routine maintenance, repairs, tires, insurance, state registration and mandatory local licensing fees. | |
| -Pricing Assumption: Because this is a fixed-price requirement, fleet capital and operating costs are incorporated into the fixed unit or total prices. The Offeror assumes the risk of market fluctuations in fuel prices, maintenance expenses, and vehicle parts. Projections used reflect realistic lifecycle cost assumptions over | |
| the period of performance without adjustment for actual cost variances. | |
| -Allocation & Basis of Projections: Fleet quantities, vehicle types and mileage/usage assumptions are tied directly to operational support volume, geographic dispersion, and travel requirements within the place of performance. Option year pricing incorporates appropriate vehicle maintenance inflation and fuel price trend factors | where applicable. |
6. Other Direct Cost (ODCs) ODCs to capture essential non-labor, non-fleet expenses requried for successful contract performance that are not otherwise included in indirect cost pools or standard labor pricing. Under a fixed-price arrangement, projected ODCs are incorporated into the fixed unit or total price. ODCs may include but are not limited to:
| -Materials and Supplies: Software licenses, training materials, office supplies or specialized equipment required exclusively for contract execution. |
| -Driver & Safety Training: Specialized training required to ensure all personnel operating government or contractor-owned fleet vehicles meet strict regulatory, safety and operational standards. |
File details come from the government source that posted it. Updated .