TCE-HR Pricing Spreadsheet.xlsx

This is a pricing spreadsheet template for the TCE-HR Lodging and Transportation contract opportunity. The spreadsheet is structured to capture cost estimates across a five-year ordering period plus a six-month optional period, with individual worksheets for each year. The contract requires lodging facilities and transportation services for Civil Service Mariners (CIVMARs) assigned to the Military Sealift Command at Fort Eustis, Virginia.

The pricing template includes line items for direct labor (burdened rates by FTE and labor category), direct materials (lodging and other supplies), previous/historical contract costs, and other direct costs including required travel and transportation. Specifically, the lodging quantities are identified as 34,675 units annually for the base year and option years 1-4, with 17,338 units for the six-month optional period. Transportation is quantified at 1,750 trips per year for full years and 875 trips for the optional period. All pricing fields in this template are currently blank ($0.00 values), indicating this is an empty template awaiting cost data population. The spreadsheet includes escalation fields set at 0.00% for each option year and indicates that summary data is auto-populated from yearly worksheets with a notation prohibiting manual edits to the summary section.