Attachment 1 - Pricing Spreadsheet.xlsx

This is a pricing spreadsheet template for the Undersea Warfare Analytical Operational Test and Evaluation Support Services contract (N0018926RW008) issued by the Department of the Navy Naval Supply Systems Command. The spreadsheet is designed to capture fully burdened hourly rates and extended pricing across a five-year contract period plus a six-month ordering period under FAR clause 52.217-8.

The pricing structure includes seven labor categories: Program Manager, Test and Evaluation Manager, Test and Evaluation Engineer, Senior Test and Evaluation Analyst, Junior Test and Evaluation Analyst, Cybersecurity/Operational Subject Matter Expert, and Data Engineer. Each labor category maintains consistent annual hours of 43,200 (1,920 hours for Program Manager and Data Engineer; 8,640 for Test and Evaluation Manager; 7,680 for Test and Evaluation Engineer; 12,480 for Senior Test and Evaluation Analyst; 6,720 for Junior Test and Evaluation Analyst; and 3,840 for Cybersecurity/Operational SME), with the FAR clause 52.217-8 period containing half those hours. Contractors must provide fully burdened hourly rates for each labor category and performance period, calculate extended prices, apply any burdens to government-provided travel amounts, and provide cumulative totals for labor and travel by period. Government-provided travel amounts are pre-populated for each period, ranging from $757,780.23 in the Base Year to $852,888.32 in Year 4, with a six-month travel allocation of $439,237.49. The spreadsheet requires summation of all labor and travel costs across the entire contract period including the optional ordering period.