ATTACHMENT R - Pflugerville Pricing Worksheet.xlsx
XLSX spreadsheet 34 KB Posted
- Attached to
- Q702--Pflugerville Initial Outfitting Transition and Activation (IOTA) Services Federal contract opportunity
- Solicitation number
- 36C77625Q0079
About this file
This is a pricing worksheet template for the Pflugerville Initial Outfitting Transition and Activation (IOTA) Services project for the Department of Veterans Affairs Technology Acquisition Center in Austin. The worksheet breaks down pricing across multiple Contract Line Item Numbers (CLINs) including project management services, interior design/FF&E, concept of operations, transition planning, acquisition planning, and optional tasks such as acquisition packages development, warehousing management, activation services, and staff training.
The template provides an example pricing structure under CLIN 0001 showing sample labor categories (Program Manager, Senior Designer, Senior Transition Planner) with hourly rates across base and option years, totaling $57,500 for 325 hours of work. The worksheet includes instructions for contractors to input their own labor categories, rates, and hours across a base year and two option years. Travel costs are to be cost-reimbursable and excluded from the total evaluated price. Other Direct Costs (ODCs) must be itemized separately for base and optional tasks. The document serves as a pricing template only and cannot include actual labor rates if used as a Basis of Estimate.
View the file
Other files for this federal contract opportunity
Show all 20
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Pricing-BOE PROJECT NAME: Pflugerville IOTA
| Labor Rates | Year 1 (Base) Total Hours | Year 1 Total Price | Option Year 1 Total Hours | Option Year 1 Total Price | Option Year 2 Total Hours | Option Year 2 Total Price | Optional Tasks (CLIN 0007, 0008, 0009, 0010) Total Hours | Optional Tasks (CLIN 0007, 0008, 0009, 0010) Total Price | Total Hours | Total Price | |||||
| Labor Category | Provider (Prime/Sub) | Year 1 | Year 2 | Year 3 | Year 4 | 325 | $ 57,500.00 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | 325 | $ 57,500.00 |
| CLIN 0001 - COMPREHENSIVE PROJECT MANAGEMENT SERVICES | 325 | $ 57,500.00 | 325 | $ 57,500.00 | |||||||||||
| *Program Manager (Activation) | Sub | $100.00 | $125.00 | $140.00 | $160.00 | 25 | $ 2,500.00 | 25 | $ 2,500.00 | ||||||
| *Senior Designer | Prime | $ 150.00 | $175.00 | $180.00 | $190.00 | 100 | $ 15,000.00 | 100 | $ 15,000.00 | ||||||
| *Senior Transition Planner | Prime | $200.00 | $225.00 | $250.00 | $275.00 | 200 | $ 40,000.00 | 200 | $ 40,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 | |||||||||||||
| CLIN 0002 - COMPREHENSIVE INTERIOR DESIGN, FF&E AND 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 | |||||||||||||
| CLIN 0003 - CONCEPT OF OPERATIONS (CONOPS), TRANSITION PLANNING, AND PROJECT STAFFING | - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||
| $ - 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 - 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 |
OPTIONS/ OPTIONAL TASKS
| OPTIONAL TASK: CLIN 0007 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 | |||||||
| OPTIONAL TASK: CLIN 0008 WAREHOUSE & 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 | |||||||
| OPTIONAL TASK: CLIN 0009 ACTIVATION SERVICES AND 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 | |||||||
| OPTIONAL TASK: CLIN 0010 STAFF TRAINING AND 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 | |||||||
| CLIN 1001 OPTION YEAR 1 COMPREHENSIVE 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 | |||||||
| CLIN 1002 TRAVEL (Cost Reimbursable) | |||||||||
| CLIN 2001 OPTION YEAR 2 COMPREHENSIVE 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 | ||||||
| ODCs: CLINS 0006, 1003, 2003 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Year 1 - CLIN 0006 (ex. Postage, printing….) | $ - 0 | ||||||||
| Year 2 - CLIN 1003 | $ - 0 | ||||||||
| Year 3 - CLIN 2003 | $ - 0 |
| Base Tasks + ODCs | $ 57,500.00 |
| Option Year 1 Tasks +ODCs | $ - 0 |
| Option Year 2 Tasks + ODCs | $ - 0 |
| Total ALL Optional Tasks CLINs 0007, 0008, 0009, 0010 | $ - 0 |
*Total Base + Options and Optional Tasks (Total Evaluated Price) $ 57,500.00
*Total Evaluated Price Exclusive of Cost-Reiumbursable Travel
Instructions
| INSTRUCTIONS |
| ***EXAMPLE LABOR CATEGORIES, RATES, AND HOURS ARE PROVIDED FOR UNDER CLIN 0001 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 CLIN. All Key Personnel must be identified. CLIN 0001 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 Year 1, Year 2, and Year 3 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 should auto populate - but it is 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. ODCs must be itemized as qty of 1 each and total price to support both the base, and optional tasks. Add descriptions of ODCs on one line item in the year proposed. |
| 9. Confirm that the pricing for each task, provided in Attachment R - Pricing Workbook, mirrors that of the pricing provided for in Section B.2 "Price/Cost Schedule" of the solicitation document |
| 11. 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 CLIN001 ARE EXAMPLES ONLY!!!****** |
File details come from the government source that posted it. Updated .