ATTACHMENT R - Pricing Worksheet -Junction City.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
Q702--Lieutenant General Richard J. Seitz Community-Based Outpatient Clinic (CBOC) Junction City, KS
Solicitation number
36C77626Q0140
Issued by

About this file

This is a Pricing Worksheet for CLIN 0001 (IOTA Services), CLIN 0002 (Travel), and CLIN 0003 (Warehousing Services) related to the Lieutenant General Richard J. Seitz Community-Based Outpatient Clinic (CBOC) Junction City, Kansas project. The worksheet is a template designed for contractors to populate with labor categories, rates, and hours across three contract periods: Period 1 (7/1/2026–6/30/2027), Period 2 (7/1/2027–6/30/2028), and Period 3 (7/1/2028–3/30/2029).

The pricing worksheet shows example labor categories under PWS Task 16.1 (Project Management Services) including Program Manager (Activation) at Sub status with rates of $100/$125/$140 per hour (75 total hours, $9,125 total), Senior Designer at Prime status with rates of $150/$175/$180 per hour (300 total hours, $50,500 total), and Senior Transition Planner at Prime status with rates of $200/$225/$250 per hour (600 total hours, $135,000 total). The base contract total for CLIN 0001 is $194,625 for 975 hours. Additional PWS tasks (16.2–16.8) and CLIN 0003 (Warehousing Services for 4/1/2028–11/30/2028) are included as placeholder line items with zero pricing. CLIN 0002 (Travel) is noted as optional and excluded from the total evaluated price. Contractors must replace example data with their own information, provide labor rates for all three periods regardless of when work occurs, ensure pricing mirrors Section B.3 of the solicitation, and submit basis of estimate documentation separately without labor rates or costs included in the worksheet.

View the file

Other files

Show all 19

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 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 SERVICES7/1/2026 -6/30/20277/1/202-6/30/20287/1/2028 - 3/30/2029975$ 194,625.00
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
PWS Task 16.6 --- RELOCATION OF REUSE & 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
$ - 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 SERVICES4/1/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
Warehouse Rent (all inclusive-to include insurance) - FIXED PRICE - Qty. 11$ - 0$ - 0
Project: Junction City
CLIN DESCRIPTIONHOURSPRICE
CLIN 0001 - IOTA SERVICES975$194,625.00
CLIN 0003 - WAREHOUSING SERVICES- 0$0.00
*Total Base + Optional Task (Total Evaluated Price)975$194,625.00
*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 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 .