Attachment 1 Pricing Spreadsheet.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- N0018926RW014
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 Categories | BASE Year Hours | BASE Year Rate | BASE Year Extended Price |
| Senior Program Manager | 1,721 | $ - 0 | |
| Journeyman Program Manager | 574 | $ - 0 | |
| Senior T+E Engineer | 36,902 | $ - 0 | |
| Journeyman T+E Engineer | 7,266 | $ - 0 | |
| Senior Operation Analyst | 14,340 | $ - 0 | |
| Journeyman Operations Analyst | 5,545 | $ - 0 | |
| BASE Year Labor Subtotal | 66,346 | $ - 0 | |
| Unburdened | Burdens (if any) | Burdened Travel | |
| BASE Year Travel | $ 798,078.35 |
BASE Year Labor + Travel $0.00
| Year 1 Labor Categories | Year 1 Hours | Year 1 Rate | Year 1 Extended Price |
| Senior Program Manager | 1,721 | $ - 0 | |
| Journeyman Program Manager | 574 | $ - 0 | |
| Senior T+E Engineer | 36,902 | $ - 0 | |
| Journeyman T+E Engineer | 7,266 | $ - 0 | |
| Senior Operation Analyst | 14,340 | $ - 0 | |
| Journeyman Operations Analyst | 5,545 | $ - 0 | |
| Year 1 Labor Subtotal | 66,346 | $ - 0 | |
| Unburdened | Burdens (if any) | Burdened Travel | |
| Year 1 Travel | $ 822,020.70 |
Year 1 Labor + Travel $0.00
| Year 2 Labor Categories | Year 2 Hours | Year 2 Rate | Year 2 Extended Price |
| Senior Program Manager | 1,721 | $ - 0 | |
| Journeyman Program Manager | 574 | $ - 0 | |
| Senior T+E Engineer | 36,902 | $ - 0 | |
| Journeyman T+E Engineer | 7,266 | $ - 0 | |
| Senior Operation Analyst | 14,340 | $ - 0 | |
| Journeyman Operations Analyst | 5,545 | $ - 0 | |
| Year 2 Labor Subtotal | 66,346 | $ - 0 | |
| Unburdened | Burdens (if any) | Burdened Travel | |
| Year 2 Travel | $ 846,681.32 |
| Year 2 Labor + Travel | $0.00 | ||
| Year 3 Labor Categories | Year 3 Hours | Year 3 Rate | Year 3 Extended Price |
| Senior Program Manager | 1,721 | $ - 0 | |
| Journeyman Program Manager | 574 | $ - 0 | |
| Senior T+E Engineer | 36,902 | $ - 0 | |
| Journeyman T+E Engineer | 7,266 | $ - 0 | |
| Senior Operation Analyst | 14,340 | $ - 0 | |
| Journeyman Operations Analyst | 5,545 | $ - 0 | |
| Year 3 Labor Subtotal | 66,346 | $ - 0 | |
| Unburdened | Burdens (if any) | Burdened Travel | |
| Year 3 Travel | $ 872,081.91 |
| Year 3 Labor + Travel | $0.00 | ||
| Year 4 Labor Categories | Year 4 Hours | Year 4 Rate | Year 4 Extended Price |
| Senior Program Manager | 1,721 | $ - 0 | |
| Journeyman Program Manager | 574 | $ - 0 | |
| Senior T+E Engineer | 36,902 | $ - 0 | |
| Journeyman T+E Engineer | 7,266 | $ - 0 | |
| Senior Operation Analyst | 14,340 | $ - 0 | |
| Journeyman Operations Analyst | 5,545 | $ - 0 | |
| Year 4 Labor Subtotal | 66,346 | $ - 0 | |
| Unburdened | Burdens (if any) | Burdened Travel | |
| Year 4 Travel | $ 898,244.37 |
| Year 4 Labor + Travel | $0.00 | ||
| FAR clause 52.217-8 (6 month) Categories | 52.217-8 Hours | 52.217-8 Rate | 52.217-8 Extended Price |
| Senior Program Manager | 860 | $ - 0 | |
| Journeyman Program Manager | 287 | $ - 0 | |
| Senior Program Manager | 18,451 | $ - 0 | |
| Journeyman T+E Engineer | 3,633 | $ - 0 | |
| Senior Operation Analyst | 7,170 | $ - 0 | |
| Journeyman Operations Analyst | 2,772 | $ - 0 | |
| FAR clause 52.217-8 Labor Subtotal | 33,173 | $ - 0 | |
| Unburdened | Burdens (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 .