ATTACHMENT R - Pricing Worksheet - Bowling Green.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- Q702--Bowling Green OPC IOTA
- Solicitation number
- 36C77626Q0114
About this file
This is a pricing worksheet template for the Bowling Green IOTA (Inclusive Occupancy Transition Operations and Activation) contract opportunity (Solicitation 36C77626Q0114) issued by the Department of Veterans Affairs Technology Acquisition Center Austin. The worksheet is structured to capture labor rates, hours, and pricing across three contract periods: June 1, 2026–May 31, 2027 (Period 1), June 1, 2027–May 31, 2028 (Period 2), and August 1, 2028–February 28, 2029 (Period 3).
The pricing structure includes CLIN 0001 (IOTA Services), CLIN 0002 (Travel—optional and cost-reimbursable), and CLIN 0003 (Warehousing Services). The example provided under Project Management Services (PWS Task 16.1) identifies three labor categories: Program Manager (Activation) as a subcontractor at rates of $100–$140 per hour depending on period; Senior Designer as prime at rates of $150–$180; and Senior Transition Planner as prime at rates of $200–$250. The base period pricing totals $194,625 for 975 hours across these three positions. Additional PWS tasks (16.2–16.8) for interior design, CONOPS planning, acquisition planning, relocation services, activation services, and staff training are available but show zero pricing in the template. The worksheet requires contractors to replace example labor categories and rates with actual proposed personnel and pricing, ensure consistency with the solicitation's Price/Cost Schedule in Section B.2, provide labor rates for all years regardless of when work is performed, and exclude travel costs and labor rate details from the Basis of Estimate submission.
View the file
Other files
Show all 20
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
Pricing-BOE
| LABOR CATEGORY | Provider (Prime/Sub) | LABOR RATE Period 1 | LABOR RATE Period 2 | LABOR RATE Period 3 | HOURS Period 1 | PRICE Period 1 | HOURS Period 2 | PRICE Period 2 | HOURS Period 3 | PRICE Period 3 | Total Hours | Total Price |
| YEAR 1 | YEAR 2 | YEAR 3 | ||||||||||
| CLIN 0001 - IOTA SERVICES | 06/01/2026-05/31/2027 | 06/01/2027-05/31/2028 | 08/01/2028-02/28/2029 | 975 | $ 194,625.00 | |||||||
| PWS Task 16.1 --- PROJECT MANAGEMENT SERVICES | 325 | $ 57,500.00 | 325 | $ 65,625.00 | 325 | $ 71,500.00 | 975 | $ 194,625.00 | ||||
| *Program Manager (Activation) | Sub | $100.00 | $125.00 | $140.00 | 25 | $ 2,500.00 | 25 | $ 3,125.00 | 25 | $ 3,500.00 | 75 | $ 9,125.00 |
| *Senior Designer | Prime | $150.00 | $175.00 | $180.00 | 100 | $ 15,000.00 | 100 | $ 17,500.00 | 100 | $ 18,000.00 | 300 | $ 50,500.00 |
| *Senior Transition Planner | Prime | $200.00 | $225.00 | $250.00 | 200 | $ 40,000.00 | 200 | $ 45,000.00 | 200 | $ 50,000.00 | 600 | $ 135,000.00 |
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| PWS Task 16.2 --- INTERIOR DESIGN, FF&E & SPACE PLANNING SERVICES | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| PWS Task 16.3 --- CONOPS, TRANSITION PLANNING & PROJECT STAFFING PLANNING | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| PWS Task 16.4 --- ACQUISITION PLANNING SERVICES | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| PWS Task 16.5 --- ACQUISITION PACKAGES DEVELOPMENT | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| PWS Task 16.6 --- RELOCATION OF REUSE & PERSONNEL FILES | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| PWS Task 16.7 --- ACTIVATION SERVICES & POST OCCUPANCY SUPPORT | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| PWS TASK 16.8 --- STAFF TRAINING & ORIENTATION | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| CLIN 0002 - TRAVEL - In support of IOTA Services |
OPTIONAL TASK
| CLIN 0003 - WAREHOUSING SERVICES | 08/01/2028-02/28/2029 | - 0 | $ - 0 | ||||||
| PWS Task 17.1 --- WAREHOUSING & WAREHOUSING MANAGEMENT SERVICES | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||
| Warehouse Rent (all inclusive-to include insurance) - FIXED PRICE - Qty. 1 | $ - 0 | $ - 0 | 1 | $ - 0 |
| PROJECT: | ||
| BOWLING GREEN IOTA | ||
| CLIN DESCRIPTION | HOURS | PRICE |
| CLIN 0001 - IOTA SERVICES | 975 | $194,625.00 |
| CLIN 0003 - WAREHOUSING SERVICES | - 0 | $0.00 |
| *Total Base + Optional Task (Total Evaluated Price) | 975 | $194,625.00 |
| *Total Evaluated Price Exclusive of Cost-Reiumbursable Travel (CLIN 0002) |
Instructions
| INSTRUCTIONS |
| ***EXAMPLE LABOR CATEGORIES, RATES, AND HOURS ARE PROVIDED FOR UNDER PROJECT MANAGEMENT SERVICES AS AN ILLUSTRATION ONLY, AND SHOULD BE REPLACED WITH QUOTER INFORMATION*** |
| 1. Labor Category: Fill in appropriate Labor Category (using industry standard titles) for each Task. All Key Personnel must be identified. Project Management Services is an example of how to fill in each section. |
| 2. Notate if the personnel being proposed is a Sub or Prime. |
| 3. Fill in the labor rates for Period 1, Period 2, Period 3, and Period 4 for each of the labor categories proposed for each specific task. |
| 4. Notate the total hours for each labor category for each task in the base and option periods. Those tasks which do not require pricing in either the base or the option are greyed out. |
| 5. The total CLIN price and Total Labor Hours will auto populate - but it is ulimately the responsibility of the Contractor to verify cell formulas |
| 6. The Government will add travel into the final contract award. Travel is not included in the Total Evaluated Price. Quotes should not include any travel costs in the pricing. |
| 7. Regardless of which period (base or option periods) a task is to be completed, Labor Rates must be provided for all years. |
| 8. Confirm that the pricing for each task, provided in the Pricing Workbook, mirrors that of the pricing provided for in Section B.2 "Price/Cost Schedule" of the solicitation document |
| 9. ODCs can be entered within each task as a Firm Fixed Price amount - example, Warehouse Rent. |
| 10. DO NOT submit this pricing workbook as a whole for the Basis of Estimate. If you use this worksheet for your Basis of Estimate, NO LABOR RATES OR COST CAN BE INCLUDED. |
| WE WILL NOT EVALUATE A BASIS OF ESTIMATE WHICH INCLUDE LABOR RATES AND CLIN COSTS |
****LABOR CATEGORIES AND LABOR RATES PROVIDED IN PROJECT MANAGEMENT SERVICES ARE EXAMPLES ONLY!!!******
File details come from the government source that posted it. Updated .