Copy of 2.02 Pricing Spreadsheet-updated.xlsx

This is a Pricing Spreadsheet template for submission of labor rates and travel costs across a five-year contract period plus an optional six-month extension. The spreadsheet requires contractors to provide fully burdened hourly rates for nine labor categories: Program Manager, Senior Test and Evaluation Specialist, Junior Test and Evaluation Specialist, NSW Test Specialist, CBRD Test Specialist, EOD Test Specialist, Information System Test and Evaluation Specialist, Cyber Systems Test Engineer, and Small Boat/Craft Test Specialist. Contractors must complete extended pricing calculations for each performance period (Base Year, Years 1-4, and the optional FAR clause 52.217-8 six-month extension), with each year containing 27,648 labor hours across the nine categories. The template also requires contractors to apply any applicable burden rates to a Government-provided travel budget and calculate combined labor and travel subtotals for each performance period, culminating in a total cost across the entire five-year ordering period plus the optional extension period.

The spreadsheet is currently populated with pre-filled hours for each labor category and Government-provided travel amounts for each performance period, ranging from $483,578.38 in the Base Year to $544,271.72 in Year 4, with the optional extension period travel budgeted at $280,299.94. All rate fields and extended price calculations are currently blank, indicating this template awaits contractor pricing input. The template contains several formula errors (shown as "#REF!" errors) that require correction before submission, particularly in the FAR clause 52.217-8 section and the final total calculation row.