ATTACHMENT R - Pricing Worksheet - American Lake B201.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- 36C77626Q0155
About this file
This is a pricing worksheet template for labor categories and costs associated with the American Lake Building 201 Initial Outfitting, Transitioning, and Activation (IOTA) Services contract. The worksheet is structured around four Contract Line Items (CLINs): CLIN 0001 for Pre-Activation Services (08/03/2026 – 09/02/2029), CLIN 0003 for Warehousing Services (04/02/2029 – 12/01/2029), CLIN 0004 for Activation Services (09/03/2029 – 04/02/2030), and CLIN 0005 for travel support. The Pre-Activation Services CLIN encompasses Project Management Services (PWS Task 16.1), Interior Design and Space Planning (Task 16.2), Concept of Operations and Transition Planning (Task 16.3), Acquisition Planning (Task 16.4), and Acquisition Packages Development (Task 16.5). The Activation Services CLIN includes Warehousing and Management (Task 17.1), Personnel Files Relocation (Task 17.2), Activation and Post-Occupancy Support (Task 17.3), Staff Training and Orientation (Task 17.4), and Project Management Support.
Contractors are required to populate the worksheet with industry-standard labor category titles, identify personnel as either prime or subcontractor, provide labor rates for four distinct periods, specify total hours per category per task, and allow for automatic calculation of total hours and prices per CLIN. The worksheet includes provision for Other Direct Costs (ODCs) as firm fixed prices, such as warehouse rent with insurance. Key instructions specify that labor rates must be provided for all years regardless of when work is performed, pricing must align with Section B.2 of the solicitation, travel costs should not be included in the evaluated price as the government will add travel separately, and the Basis of Estimate submission must not include labor rates or costs. All example labor categories and rates are provided for illustration only and must be replaced with actual quoter information.
View the file
Other files
Show all 22
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 POP: 08/03/2026 - 09/02/2029 | 08/03/2026 - 08/02/2027 | 08/03/2027 - 08/02/2028 | 08/03/2028 - 09/02/2029 | 09/03/2029 - 04/02/2023 | - 0 | $ - 0 | |||||||||
| PWS Task 16.1 --- PROJECT MANAGEMENT SERVICES | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |||||
| *Program Manager (Activation) | Sub | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| *Senior Designer | Prime | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| *Senior Transition Planner | Prime | $ - 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 | ||||||||||
| 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.00 | - 0 | $ - 0 | - 0 | $ - 0 | |||||||||
| $0.00 | $ - 0 | - 0 | $ - 0 | ||||||||||||
| $0.00 | $ - 0 | - 0 | $ - 0 | ||||||||||||
| $0.00 | $ - 0 | - 0 | $ - 0 | ||||||||||||
| $0.00 | $ - 0 | - 0 | $ - 0 | ||||||||||||
| $0.00 | $ - 0 | - 0 | $ - 0 | ||||||||||||
| $0.00 | $ - 0 | - 0 | $ - 0 | ||||||||||||
| $0.00 | $ - 0 | - 0 | $ - 0 | ||||||||||||
| $0.00 | $ - 0 | - 0 | $ - 0 | ||||||||||||
| CLIN 0002 - TRAVEL - In support of IOTA Services |
OPTIONAL TASKS
| CLIN 0003 - WAREHOUSING SERVICES POP: 004/02/2029 - 12/01/2029 | 04/02/2029 - 09/02/2029 | 09/03/2029-12/01/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 | |||||
| Warehouse Rent (all inclusive-to include insurance) - FIXED PRICE - Qty. 1 | 1 | 1 | 2 | $ - 0 | ||||
| CLIN 0004 - ACTIVATION SERVICES POP: 09/03/2029 - 04/02/2030 | 09/03/2029 - 04/02/2030 | - 0 | $ - 0 | |||||
| PWS Task 17.2 --- 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 | |||||
| PWS Task 17.3 --- 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 | |||||
| PWS TASK 17.4 --- 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 | |||||
| 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 | $ - 0 | |||||
| $ - 0 | $ - 0 | - 0 | $ - 0 | |||||
| $ - 0 | $ - 0 | - 0 | $ - 0 | |||||
| $ - 0 | $ - 0 | - 0 | $ - 0 | |||||
| CLIN 0005 TRAVEL - In support of Activation Serivces | $ - 0 |
| PROJECT: | ||
| American Lake IOTA | ||
| CLIN DESCRIPTION | HOURS | PRICE |
| CLIN 0001 - PRE-ACTIVATION SERVICES | 0 | $0.00 |
| CLIN 0003 - WAREHOUSING SERVICES | - 0 | $0.00 |
| CLIN 0004 - ACTIVATION SERVICES | - 0 | $0.00 |
| *Total Base + Optional Tasks (Total Evaluated Price) | 0 | $0.00 |
| *Total Evaluated Price Exclusive of Cost-Reiumbursable Travel (CLIN 0002 & CLIN 0005) |
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 .