REVISED - ATTACHMENT R - Pricing Worksheet - Columbia CBOC.xlsx

33 KB Posted

Attached to
Q702--Columbia Community Based Outpatient Clinic - Initial Outfitting Transition & Activation (IOTA) Services
Solicitation number
36C77626Q0045
Issued by

About this file

Written by GovTribe AI ·

This is a revised pricing worksheet template for the Columbia Community Based Outpatient Clinic (CBOC) Initial Outfitting Transition & Activation (IOTA) Services contract (Solicitation 36C77626Q0045), issued by the Department of Veterans Affairs Technology Acquisition Center Austin. The worksheet is designed for contractors to submit labor rates and costs across three contract years (02/10/2026-01/09/2029) organized by Contract Line Item Number (CLIN).

CLIN 0001 addresses IOTA Services with seven primary work tasks: Project Management Services, Interior Design/FF&E & Space Planning Services, CONOPS/Transition Planning & Project Staffing Planning, Acquisition Planning Services, Acquisition Packages Development, Activation Services & Post Occupancy Support, and Staff Training & Orientation. The worksheet provides an example of labor category pricing for Project Management Services, showing rates for a Program Manager (Activation) as a subcontractor ($100-$140/hour across three periods), a Senior Designer as prime ($150-$180/hour), and a Senior Transition Planner as prime ($200-$250/hour), with total Project Management Services costs of $194,625. CLIN 0002 covers travel costs (not included in evaluated pricing and to be added by the Government post-award). CLIN 0003 addresses optional warehousing services for 04/01/2028-11/30/2028, priced as a fixed-price item including rent and insurance. Contractors must provide labor rates for all three years regardless of when tasks are performed, identify personnel as prime or subcontractor, ensure formulas auto-populate correctly, and submit pricing worksheets separate from basis of estimate documentation without including labor rates or costs in the latter.

View the file

Other files

File Type Posted
Columbia TN IOTA - Additional RFQ Questions.pdf PDF
36C77626Q0045 0002.docx DOCX document
Columbia IOTA - RFQ Questions and Answers.pdf PDF
36C77626Q0045 0001.docx DOCX document
ATTACHMENT N - PDAT Summary - Columbia.pdf PDF
ATTACHMENT M - QASP.pdf PDF
ATTACHMENT I - Equipment Inventory_ReUse and Disposal Plan Template.xlsx XLSX spreadsheet
ATTACHMENT H - Integrated Move Plan Template.xlsx XLSX spreadsheet
ATTACHMENT F - WBS Template.pdf PDF
ATTACHMENT A - Maury County-Columbia - IOTA PWS.pdf PDF
ATTACHMENT R - Pricing Worksheet - Columbia CBOC.xlsx XLSX spreadsheet
ATTACHMENT P - Wage Determination - Columbia.pdf PDF
ATTACHMENT L - Procurement Package Template and 6500 5.20.2025.pdf PDF
ATTACHMENT K - Furniture IDIQ Templates.pdf PDF
ATTACHMENT C - Contract Staff Roster.pdf PDF
ATTACHMENT B - Travel Authorization Request.pdf PDF
ATTACHMENT Q - Room Contents List - Columbia.xlsx XLSX spreadsheet
ATTACHMENT O - VSC Security Package 7.15.2025.pdf PDF
ATTACHMENT J - Proposed FTE Report.xlsx XLSX spreadsheet
ATTACHMENT G - Room Contents Acq Plan Template 9.21.2023.xlsx XLSX spreadsheet
ATTACHMENT E - Change Management Plan and Log Template.xlsx XLSX spreadsheet
ATTACHMENT D - Risk Management Plan and Register Template.xlsx XLSX spreadsheet
36C77626Q0045_1.docx DOCX document
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Pricing-BOE

LABOR CATEGORYProvider (Prime/Sub)LABOR RATE Period 1LABOR RATE Period 2LABOR RATE Period 3HOURS Period 1PRICE Period 1HOURS Period 2PRICE Period 2HOURS Period 3PRICE Period 3Total HoursTotal Price
YEAR 1YEAR 2YEAR 3
CLIN 0001 - IOTA SERVICES02/10/2026-01/09/202702/10/2027-01/09/202802/10/2028-01/09/2029ERROR:#REF!ERROR:#REF!
PWS Task 16.1 --- PROJECT MANAGEMENT SERVICES325$ 57,500.00325$ 65,625.00325$ 71,500.00975$ 194,625.00
*Program Manager (Activation)Sub$100.00$125.00$140.0025$ 2,500.0025$ 3,125.0025$ 3,500.0075$ 9,125.00
*Senior DesignerPrime$150.00$175.00$180.00100$ 15,000.00100$ 17,500.00100$ 18,000.00300$ 50,500.00
*Senior Transition PlannerPrime$200.00$225.00$250.00200$ 40,000.00200$ 45,000.00200$ 50,000.00600$ 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 --- 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.7 --- 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 SERVICES04/01/2028-11/30/2028- 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$ - 01$ - 0
PROJECT:
COLUMBIA CBOC IOTA
CLIN DESCRIPTIONHOURSPRICE
CLIN 0001 - IOTA SERVICESERROR:#REF!ERROR:#REF!
CLIN 0003 - WAREHOUSING SERVICES- 0$0.00
*Total Base + Optional Task (Total Evaluated Price)ERROR:#REF!ERROR:#REF!
*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 .