Pricing Spreadsheet.xlsx

This is a pricing spreadsheet template for a five-year contract with a six-month FAR clause 52.217-8 ordering period option. The spreadsheet requires contractors to provide fully burdened hourly rates for seven labor categories: Program Manager, Senior Test and Evaluation Engineer, Journeyman Test and Evaluation Engineer, Senior Operations Analyst, Data Engineer, Software Test Engineer, and Cybersecurity/Operational Subject Matter Expert. The base year and each of the four subsequent performance years require 78,720 labor hours, with the optional six-month period requiring 39,264 hours at half the annual rate. Contractors must calculate extended prices for each labor category, apply any burdens, and provide labor subtotals for each performance period.

The spreadsheet includes pre-populated government-provided travel costs for each performance period: $220,900 (Base Year), $220,920 (Year 1), $220,080 (Year 2), $231,084 (Year 3), $242,638.20 (Year 4), and $127,385.06 (six-month option). Contractors must apply any applicable burdens to travel amounts and calculate the fully burdened travel cost for each period. The template requires cumulative totals combining labor and travel costs for each performance period and a grand total for the entire five-year contract plus the optional six-month ordering period. All pricing fields are currently blank, awaiting contractor submission of hourly rates and burden percentages.