ATTACHMENT 0002 Pricing Worksheet.xlsx

XLSX spreadsheet 68 KB Posted

Attached to
CBRND Professional Services JPM Sensors Task Order Draft RFP Federal contract opportunity
Solicitation number
W911QY25RJS01
Issued by
Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

This is a pricing worksheet template for a professional services contract that includes labor categories across a base year, four option years, and six monthly options under FAR 52.217-8. The worksheet requires vendors to input fully-burdened labor rates (including indirect rates and profit) for both on-site and off-site work across 15 specified labor categories including Acquisition Analysts (Levels III-V), Administrative Assistants (Levels III-IV), Program Analysts (Levels III-IV), Security Analyst, Strategic Planners (Levels IV-V), Executive Assistants (Levels III-IV), Agreements Analyst III, Integrated Master Scheduler Level IV, and Operations Support Specialist Level III.

The template includes separate tabs for each performance period and a total proposed tab that aggregates all costs. Vendors must separate on-site and off-site hours in designated columns and include a Contract Access Fee. The worksheet is structured to automatically calculate total costs based on input hours and rates. No specific pricing targets or estimates are provided as this is purely a template for vendors to complete with their proposed rates and staffing levels.

View the file

Other files for this federal contract opportunity

Show all 11

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

Instructions

Add labor category titles from the Performance Work Statement (PWS) to the labor category columns in the Base Year tab, Option Year 1 through 4 tabs, and Option tabs as needed.
Add the same labor categories to the "Total Proposed" tab.
Enter labor categories, hours, rates and other requested information in appropriate columns on tabs for Base Year, Option Year 1 to 4, and Option Period.
The option periods are for the six month period referenced in FAR 52.217-8, Option to Extend Services. The option may be exercised more than once, but…shall not exceed 6 months.
-For labor rates, include fully burdened rates including indirect rates and profit.
-Separate On-Site and Off-Site hours in the appropriate columns.
-Do not make entries in Column I on the labor tabs
Contract Access Fee - Input amount in row 52 by year or in total

Total Proposed

`
Add labor categories from PWS as neededDO NOT MAKE ENTRIES IN THESE CELLS
FAR 52.217-8 Option to Extend Services
Labor CategoryBase YearOption Year 1Option Year 2Option Year 3Option Year 4Option Month 1Option Month 2Option Month 3Option Month 4Option Month 5Option Month 6
Acquisition Analyst Level III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00Total Labor$0.00
Acquisition Analyst Level IV$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Acquisition Analyst Level V$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Administrative Assistant Level III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Administrative Assistant Level IV$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Program Analyst Level III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Program Analyst Level IV$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Security Analyst$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Strategic Plann Level IV$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Strategic Plann Level V$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Executive Assistant Level III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Executive Assistant Level IV$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Agreements Analyst III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Integrated Master Scheduler Level IV$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Operations Support Specialist Level III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Contract Access Fee$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
Total Labor$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Contract Access Fee

Base Year

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Option Year 1

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Option Year 2

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Option Year 3

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Option Year 4

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

FAR 52.217-8 Option Month 1

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

FAR 52.217-8 Option Month 2

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

FAR 52.217-8 Option Month 3

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

FAR 52.217-8 Option Month 4

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

FAR 52.217-8 Option Month 5

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

FAR 52.217-8 Option Month 6

Add labor categories from PWS as neededCalculated
Labor CategoryRequiring OfficeSupport LocationOn-Site Hourly RateTotal On-Site HoursOff-Site Hourly RateTotal Off-Site HoursHours x Rate
Acquisition Analyst Level III$0.00
Acquisition Analyst Level IV$0.00
Acquisition Analyst Level V$0.00
Administrative Assistant Level III$0.00
Administrative Assistant Level IV$0.00
Program Analyst Level III$0.00
Program Analyst Level IV$0.00
Security Analyst$0.00
Strategic Plann Level IV$0.00
Strategic Plann Level V$0.00
Executive Assistant Level III$0.00
Executive Assistant Level IV$0.00
Agreements Analyst III$0.00
Integrated Master Scheduler Level IV$0.00
Operations Support Specialist Level III$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

File details come from the government source that posted it. Updated .