Pricing Spreadsheet.xlsx

This is a pricing spreadsheet template for labor and travel costs associated with a five-year contract plus a six-month ordering period under FAR clause 52.217-8. The spreadsheet requires contractors to provide fully burdened hourly rates for six labor categories: Program Manager, Senior Test and Evaluation Specialist, Journeyman Test and Evaluation Specialist, Senior Database Manager, Junior Database Manager, and Aircraft Coordinator. Contractors must calculate extended prices for each labor category across five performance years plus the optional six-month period, apply any applicable burden rates, and compute labor subtotals for each period. The template includes pre-populated hour requirements that vary by year, ranging from approximately 36,920 to 42,380 hours annually, with the six-month extension requiring 19,500 hours.

The spreadsheet also requires contractors to apply burdens, if applicable, to Government-provided travel amounts and calculate fully burdened travel costs for each performance period. Pre-populated travel amounts are provided for each year, ranging from $325,130.62 in the base year to $365,937.38 in Year 4, plus $184,181.01 for the six-month ordering period. Contractors must provide cumulative totals for labor plus travel for each performance period and deliver a grand total for the entire contract duration. Currently, all rate fields display "$-0," indicating this is an unfilled template awaiting contractor pricing submission.