ATTACHMENT U - Pricing Worksheet.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- Q702--Cheshire County- Keene and Brattleboro Outpatient Clinic & Burlington, VT Outpatient Clinic IOT&A
- Solicitation number
- 36C77626Q0215
About this file
This is a Pricing Worksheet template for labor categories and costs associated with a Department of Veterans Affairs solicitation (36C77626Q0215) for Interior Outfitting and Activation (IOT&A) services at two locations: Cheshire County (Keene and Brattleboro) and Burlington, Vermont outpatient clinics. The worksheet is designed for contractors to submit detailed pricing for services across a three-year contract period (August 3, 2026 through June 23, 2029).
The pricing structure covers four primary Line Items (LINs): LIN 0001 addresses IOTA Services for Cheshire with 975 total hours valued at $194,625; LIN 0002 covers IOTA Services for Burlington with 975 total hours valued at $194,625; LIN 0003 is designated for optional travel costs (excluded from evaluated price); and LIN 0004 addresses warehousing services on a fixed-price basis. Labor categories include Program Manager (Activation), Senior Designer, and Senior Transition Planner, with rates escalating across three contract periods (Period 1: August 3, 2026 - August 2, 2027; Period 2: August 3, 2027 - August 2, 2028; Period 3: August 3, 2028 - June 23, 2029). The total evaluated base price is $389,250 for 1,950 labor hours. The worksheet template includes detailed instructions requiring contractors to identify personnel as prime or subcontractor, provide labor rates for all contract years regardless of when work is performed, align pricing with solicitation Section B.3, and submit separate basis of estimate documentation without embedded labor rates or costs.
View the file
Other files
Show all 23
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 | ||||||||||
| LIN 0001 - IOTA SERVICES - Cheshire | 08/03/2026 - 08/02/2027 | 08/03/2027 - 08/02/2028 | 08/03/2028 - 06/23/2029 | 2,925 | $ 583,875.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 | ||||||||||
| PWS Task 16.6 --- RELOCATION OF PERSONNEL FILES | - 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 | ||||||||||
| PWS TASK 16.8 --- STAFF TRAINING & ORIENTATION | 325 | $ 71,500.00 | 1,950 | $ 389,250.00 | ||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 | ||||||||||
| $ - 0 | - 0 | $ - 0 |
| LIN 0002 - IOTA SERVICES - Burlington | 08/03/2026 - 08/02/2027 | 08/03/2027 - 08/02/2028 | 08/03/2028 - 06/23/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 | ||||||||||
| PWS Task 16.6 --- RELOCATION OF PERSONNEL FILES | - 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 | ||||||||||
| 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 |
LIN 0003 - TRAVEL - In support of IOTA Services
OPTIONAL TASK
| LIN 0004 - WAREHOUSING SERVICES | 08/03/2026 - 08/02/2027 | 08/03/2027 - 08/02/2028 | 08/03/2028 - 06/23/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 | |||||
| Warehouse Rent (all inclusive-to include insurance) - FIXED PRICE - Qty. 1 | 1 | $ - 0 | $ - 0 |
| PROJECT: | ||
| BURLINGTON, VT AND CHESHIRE CO. IOT&A | ||
| LIN DESCRIPTION | HOURS | PRICE |
| LIN 0001 - IOTA SERVICES- CHESHIRE | 975 | $194,625.00 |
| LIN 0002- IOTA SERVICES- BURLINGTON | 975 | $194,625.00 |
| LIN 0004 - WAREHOUSING SERVICES | - 0 | $0.00 |
*Total Base + Optional Task (Total Evaluated Price) 1,950 $389,250.00
*Total Evaluated Price Exclusive of Cost-Reiumbursable Travel (LIN 0003)
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 LIN 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.3 "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 LIN 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 .