Attachment 1 Pricing Spreadsheet.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
R425 - Aviation Warfare Analytical Operational Test and Evaluation Support Services
Solicitation number
N0018926RW014
Issued by

About this file

This is a Pricing Spreadsheet template for federal contract pricing submission related to Aviation Warfare Analytical Operational Test and Evaluation Support Services for the Department of the Navy Naval Supply Systems Command. The spreadsheet establishes labor rate and pricing structure requirements across a five-year contract period plus a six-month FAR clause 52.217-8 ordering period option.

The template requires offerors to provide fully burdened hourly rates for six labor categories: Senior Program Manager, Journeyman Program Manager, Senior Test and Evaluation (T+E) Engineer, Journeyman T+E Engineer, Senior Operations Analyst, and Journeyman Operations Analyst. Fixed labor hours are specified for each category across the Base Year and four subsequent contract years, with Base Year consisting of 66,346 total labor hours. The spreadsheet also incorporates Government-provided travel amounts ranging from $798,078.35 in the Base Year to $898,244.37 in Year 4, with instructions to apply any applicable burdens to these travel costs. Offerors must complete extended pricing calculations for each labor category and performance period, calculate labor subtotals, and provide final totals for both individual years and the entire five-year plus optional six-month ordering period. The FAR clause 52.217-8 option period covers six months with 33,173 labor hours and $462,595.85 in travel costs.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Attachment 4

Instructions: Provide the fully burdened hourly rate for each labor category for each performance period. Complete the extended price and the labor subtotals for each performance period Apply burdens, if any, to the Government-provided travel amount and complete the fully burdened travel amount for each performance period. Provide the sum of the labor and travel for each performance period. Provide the total for the entire five-year and FAR clause 52.217-8 ordering period.
BASE Year Labor CategoriesBASE Year HoursBASE Year RateBASE Year Extended Price
Senior Program Manager1,721$ - 0
Journeyman Program Manager574$ - 0
Senior T+E Engineer36,902$ - 0
Journeyman T+E Engineer7,266$ - 0
Senior Operation Analyst14,340$ - 0
Journeyman Operations Analyst5,545$ - 0
BASE Year Labor Subtotal66,346$ - 0
UnburdenedBurdens (if any)Burdened Travel
BASE Year Travel$ 798,078.35

BASE Year Labor + Travel $0.00

Year 1 Labor CategoriesYear 1 HoursYear 1 RateYear 1 Extended Price
Senior Program Manager1,721$ - 0
Journeyman Program Manager574$ - 0
Senior T+E Engineer36,902$ - 0
Journeyman T+E Engineer7,266$ - 0
Senior Operation Analyst14,340$ - 0
Journeyman Operations Analyst5,545$ - 0
Year 1 Labor Subtotal66,346$ - 0
UnburdenedBurdens (if any)Burdened Travel
Year 1 Travel$ 822,020.70

Year 1 Labor + Travel $0.00

Year 2 Labor CategoriesYear 2 HoursYear 2 RateYear 2 Extended Price
Senior Program Manager1,721$ - 0
Journeyman Program Manager574$ - 0
Senior T+E Engineer36,902$ - 0
Journeyman T+E Engineer7,266$ - 0
Senior Operation Analyst14,340$ - 0
Journeyman Operations Analyst5,545$ - 0
Year 2 Labor Subtotal66,346$ - 0
UnburdenedBurdens (if any)Burdened Travel
Year 2 Travel$ 846,681.32
Year 2 Labor + Travel$0.00
Year 3 Labor CategoriesYear 3 HoursYear 3 RateYear 3 Extended Price
Senior Program Manager1,721$ - 0
Journeyman Program Manager574$ - 0
Senior T+E Engineer36,902$ - 0
Journeyman T+E Engineer7,266$ - 0
Senior Operation Analyst14,340$ - 0
Journeyman Operations Analyst5,545$ - 0
Year 3 Labor Subtotal66,346$ - 0
UnburdenedBurdens (if any)Burdened Travel
Year 3 Travel$ 872,081.91
Year 3 Labor + Travel$0.00
Year 4 Labor CategoriesYear 4 HoursYear 4 RateYear 4 Extended Price
Senior Program Manager1,721$ - 0
Journeyman Program Manager574$ - 0
Senior T+E Engineer36,902$ - 0
Journeyman T+E Engineer7,266$ - 0
Senior Operation Analyst14,340$ - 0
Journeyman Operations Analyst5,545$ - 0
Year 4 Labor Subtotal66,346$ - 0
UnburdenedBurdens (if any)Burdened Travel
Year 4 Travel$ 898,244.37
Year 4 Labor + Travel$0.00
FAR clause 52.217-8 (6 month) Categories52.217-8 Hours52.217-8 Rate52.217-8 Extended Price
Senior Program Manager860$ - 0
Journeyman Program Manager287$ - 0
Senior Program Manager18,451$ - 0
Journeyman T+E Engineer3,633$ - 0
Senior Operation Analyst7,170$ - 0
Journeyman Operations Analyst2,772$ - 0
FAR clause 52.217-8 Labor Subtotal33,173$ - 0
UnburdenedBurdens (if any)Burdened Travel
FAR clause 52.217-8 Travel$ 462,595.85
FAR clause 52.217-8 Labor + Travel$0.00
Total - 5 years + 52.217-8$0.00

File details come from the government source that posted it. Updated .