Pricing Spreadsheet.xlsx

This is a pricing spreadsheet template for a five-year federal contract with an additional six-month ordering period under FAR clause 52.217-8. The spreadsheet is designed to capture fully burdened hourly rates and extended pricing 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. Each labor category has fixed hours allocated across the Base Year, Year 1, Year 2, Year 3, Year 4, and the six-month FAR clause 52.217-8 period, with 78,720 total labor hours per performance period. The spreadsheet requires contractors to input hourly rates for each category and calculate extended prices, labor subtotals, burden rates, and burdened travel costs for each performance period.

Government-provided travel costs are specified for each 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 (FAR clause 52.217-8). The template calculates total labor and travel costs for each performance period and provides a grand total for the entire five-year contract plus the six-month ordering period. Currently, all hourly rates and extended prices are blank, indicating this is a template awaiting contractor pricing submission for the Navy's Information Warfare Analytical Operational Test and Evaluation Support Services contract (N0018926RW005).