ATTACHMENT R - Pricing Worksheet - Martinsburg Warehouse.xlsx
XLSX spreadsheet 34 KB Posted
- Attached to
- Q702--Martinsburg, WV Warehouse IOTA
- Solicitation number
- 36C77626Q0274
About this file
This is a Pricing Worksheet template for the Martinsburg Warehouse IOTA (Improve, Optimize, Transition, Activate) project, a Department of Veterans Affairs Technology Acquisition Center procurement (Solicitation Number 36C77626Q0274). The worksheet provides the structure for submitting labor rates, hours, and pricing across four contract line items (CLINs) covering a performance period from December 1, 2026, through May 31, 2029.
The pricing template is organized into CLIN 0001 (Pre-Activation Services, 12/01/2026–11/30/2027), which includes PWS Task 16.1 (Project Management Services), Task 16.2 (Interior Design, FF&E & Space Planning Services), Task 16.3 (ConOps, Transition Planning & Project Staffing Planning), Task 16.4 (Acquisition Planning Services), and Task 16.5 (Acquisition Packages Development); CLIN 0002 (Travel supporting IOTA Services); CLIN 0003 (Activation Services, 11/01/2028–05/31/2029); and CLIN 0004 (Travel supporting Activation Services). The example pricing provided in the base period shows 650 total hours at $123,125.00 for Project Management Services, which is evaluated for Years 1–3. Contractors must provide labor rates for four distinct periods, identify personnel as Prime or Subcontractor, and notate total hours and associated pricing for each labor category and task. The instructions specify that labor rates must be provided for all years regardless of when work occurs, travel costs should not be included in the Total Evaluated Price, and Other Direct Costs (ODCs) can be entered as firm fixed prices. Contractors are prohibited from submitting the pricing worksheet itself as a Basis of Estimate and must ensure internal pricing formulas are verified for accuracy.
View the file
Other files
Show all 21
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 | LABOR RATE Period 4 | HOURS Period 1 | PRICE Period 1 | HOURS Period 2 | PRICE Period 2 | HOURS Period 3 | PRICE Period 3 | HOURS Period 4 | PRICE Period 4 | Total Hours | Total Price |
| YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | ||||||||||||
| CLIN 0001 - PRE ACTIVATION SERVICES | 12/01/2026-11/30/2027 | 12/01/2027-11/30/2028 | 12/01/2028-05/31/2029 | 650 | $ 123,125.00 | ||||||||||
| PWS Task 16.1 --- PROJECT MANAGEMENT SERVICES | 325 | $ 57,500.00 | 325 | $ 65,625.00 | 650 | $ 123,125.00 | |||||||||
| *Program Manager (Activation) | Sub | $100.00 | $125.00 | 25 | $ 2,500.00 | 25 | $ 3,125.00 | 50 | $ 5,625.00 | ||||||
| *Senior Designer | Prime | $150.00 | $175.00 | 100 | $ 15,000.00 | 100 | $ 17,500.00 | 200 | $ 32,500.00 | ||||||
| *Senior Transition Planner | Prime | $200.00 | $225.00 | 200 | $ 40,000.00 | 200 | $ 45,000.00 | 400 | $ 85,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 | ||||||||||||
| 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 | |||||||||||||
| CLIN 0002 - TRAVEL - In support of IOTA Services |
OPTIONAL TASKS
| CLIN 0003 - ACTIVATION SERVICES | 11/01/2028-05/31/2029 | - 0 | $ - 0 | ||
| PWS Task 17.1 --- RELOCATION OF REUSE AND PERSONNEL FILES | - 0 | $ - 0 | - 0 | $ - 0 | |
| $ - 0 | - 0 | $ - 0 | |||
| $ - 0 | - 0 | $ - 0 | |||
| $ - 0 | - 0 | $ - 0 | |||
| $ - 0 | - 0 | $ - 0 | |||
| $ - 0 | - 0 | $ - 0 | |||
| PWS Task 17.2 --- ACTIVATION SERVICES & POST OCCUPANCY SUPPORT | - 0 | $ - 0 | - 0 | $ - 0 | |
| $ - 0 | - 0 | $ - 0 | |||
| $ - 0 | - 0 | $ - 0 | |||
| $ - 0 | - 0 | $ - 0 | |||
| $ - 0 | - 0 | $ - 0 | |||
| $ - 0 | - 0 | $ - 0 | |||
| PWS Task 16.1 --- PROJECT MANAGEMENT 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 | $ - 0 | |||
| $ - 0 | - 0 | $ - 0 | |||
| CLIN 0004 TRAVEL - In support of Activation Serivces | $ - 0 |
| PROJECT: | ||
| MARTINSBURG WAREHOUSE IOTA | ||
| CLIN DESCRIPTION | HOURS | PRICE |
| CLIN 0001 - PRE-ACTIVATION SERVICES | 650 | $123,125.00 |
| CLIN 0003 - ACTIVATION SERVICES | - 0 | $0.00 |
| *Total Base + Optional Tasks (Total Evaluated Price) | 650 | $123,125.00 |
| *Total Evaluated Price Exclusive of Cost-Reiumbursable Travel (CLIN 0002 & CLIN 0004) |
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 .