ATTACHMENT 0002 Pricing Worksheet.xlsx

XLSX spreadsheet 68 KB Posted

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

About this file

This is a pricing worksheet template for contractors to submit labor rates and hours across a base period, four option years, and six option months under FAR 52.217-8. The worksheet requires input of both on-site and off-site fully burdened labor rates (including indirect rates and profit) for seven predetermined labor categories: Systems Engineer Levels II-IV, Information Assurance Analyst III, Test Analyst Level III, Staff Logistician Level III, and Fielding Coordinator IV.

The template includes separate tabs for the base year, option years 1-4, and six individual option months. Contractors must enter labor rates, hours, and location information (on-site vs off-site) for each performance period. A Contract Access Fee line item is included but entries are restricted to row 52. The worksheet automatically calculates total labor costs based on the hours and rates entered.

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, Year 2 through Year 5 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, Year 2 through 5, 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
Systems Engineer Level II$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
Systems Engineer Level III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Systems Engineer Level IV$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Information Assurance Analyst III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Test 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
Staff Logistician Level III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Fielding Coordinator IV$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
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

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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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
Systems Engineer Level II$0.00
Systems Engineer Level III$0.00
Systems Engineer Level IV$0.00
Information Assurance Analyst III$0.00
Test Analyst Level III$0.00
Staff Logistician Level III$0.00
Fielding Coordinator IV$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
$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 .