Revised Pricing Spreadsheet.xlsx
XLSX spreadsheet 27 KB Posted
- Solicitation number
- N0018926RW014
About this file
This is a pricing spreadsheet template for a five-year federal services contract with an additional six-month ordering period under FAR clause 52.217-8. The spreadsheet requires contractors to provide fully burdened hourly rates for 26 distinct labor categories supporting Aviation Warfare Analytical Operational Test and Evaluation (OT&E) services for the Department of the Navy Naval Supply Systems Command. Labor categories range from Senior Program Managers and Engineers to specialized aviation warfare subject matter experts, including Joint Strike Fighter Specialists, E-2D Specialists, Cyber Security Subject Matter Experts, and Navy/Marine Corps Unmanned Aviation Systems Specialists. The base year allocation totals 75,906 hours across all categories, with identical hour distributions across the four subsequent contract years; the FAR 52.217-8 six-month period covers 37,953 hours.
The pricing template requires contractors to calculate extended prices by multiplying hourly rates by allocated hours for each performance period, apply any burden rates to both labor and Government-provided travel costs, and provide cumulative labor-plus-travel subtotals for each year and the optional six-month ordering period. Travel costs are pre-populated by the Government at $798,078.35 for the base year, escalating to $898,244.37 by Year 4, with a $462,595.85 allocation for the six-month FAR 52.217-8 period. All hourly rates and extended prices are currently blank, indicating this is a template awaiting contractor pricing submission. The contract structure demonstrates a significant commitment to sustained OT&E analytical support operations with specialized aviation domain expertise across multiple naval aviation platforms and systems.
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 | |
| Aircraft Handling Specialist | 478 | $ - 0 | |
| Joint Strike Fighter Specialist | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist-Data Links | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist-Air to Ground Weapons | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist-Air to Air Weapons | 478 | $ - 0 | |
| E-2D Specialist | 478 | $ - 0 | |
| Marine Rotary/Tiltrotor Specialist | 478 | $ - 0 | |
| Joint Precision Approach and Landing System (JPALS) Specialist | 478 | $ - 0 | |
| Naval Aviation Maintenance Technician | 478 | $ - 0 | |
| Aviation Logistics Specialist | 478 | $ - 0 | |
| Aviation Electronic Attack Specialist | 478 | $ - 0 | |
| Aviation Electronic Warfare Self Protect Specialist | 478 | $ - 0 | |
| Aviation Infrared Self Protect Specialist | 478 | $ - 0 | |
| Naval Rotary Anti-Surface Warfare/Anti-Submarine Warfare Specialist | 478 | $ - 0 | |
| Navy Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Marine Corps Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Naval Fixed-Wing Anti-Surface Warfare/Anti-Submarine Warfare Specialist | 478 | $ - 0 | |
| JMPS-M_T&E Specialist | 478 | $ - 0 | |
| Automated Test Information System Specialist | 478 | $ - 0 | |
| Cyber Security Subject Matter Expert/Operational (SME) | 478 | $ - 0 | |
| BASE Year Labor Subtotal | 75,906 | $ - 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 | |
| Aircraft Handling Specialist | 478 | $ - 0 | |
| Joint Strike Fighter Specialist | 478 | $ - 0 | |
| Strike Warfare Avaiation Specialist-Data Links | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Ground Weapons | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Air Weapons | 478 | $ - 0 | |
| E-2D Specialist | 478 | $ - 0 | |
| Marine Rotary/Tiltrotor Specialist | 478 | $ - 0 | |
| Joint Precision Approach and Landing System (JPALS) Specialist | 478 | $ - 0 | |
| Naval Aviation Maintenance Technician | 478 | $ - 0 | |
| Aviation Logistics Specialist | 478 | $ - 0 | |
| Aviation Electronic Attack Specialist | 478 | $ - 0 | |
| Aviation Electronic Warfare Self Protect Specialist | 478 | $ - 0 | |
| Aviation Infrared Self Protect Specialist | 478 | $ - 0 | |
| Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist | 478 | $ - 0 | |
| Navy Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Marine Corps Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist | 478 | $ - 0 | |
| JMPS-M_T&E Specialist | 478 | $ - 0 | |
| Automated Test Information System Specialist | 478 | $ - 0 | |
| Cyber Security Subject Matter Expert/Operational (SME) | 478 | $ - 0 | |
| Year 1 Labor Subtotal | 75,906 | $ - 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 | |
| Aircraft Handling Specialist | 478 | $ - 0 | |
| Joint Strike Fighter Specialist | 478 | $ - 0 | |
| Strike Warfare Avaiation Specialist-Data Links | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Ground Weapons | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Air Weapons | 478 | $ - 0 | |
| E-2D Specialist | 478 | $ - 0 | |
| Marine Rotary/Tiltrotor Specialist | 478 | $ - 0 | |
| Joint Precision Approach and Landing System (JPALS) Specialist | 478 | $ - 0 | |
| Naval Aviation Maintenance Technician | 478 | $ - 0 | |
| Aviation Logistics Specialist | 478 | $ - 0 | |
| Aviation Electronic Attack Specialist | 478 | $ - 0 | |
| Aviation Electronic Warfare Self Protect Specialist | 478 | $ - 0 | |
| Aviation Infrared Self Protect Specialist | 478 | $ - 0 | |
| Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist | 478 | $ - 0 | |
| Navy Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Marine Corps Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist | 478 | $ - 0 | |
| JMPS-M_T&E Specialist | 478 | $ - 0 | |
| Automated Test Information System Specialist | 478 | $ - 0 | |
| Cyber Security Subject Matter Expert/Operational (SME) | 478 | $ - 0 | |
| Year 2 Labor Subtotal | 75,906 | $ - 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 | |
| Aircraft Handling Specialist | 478 | $ - 0 | |
| Joint Strike Fighter Specialist | 478 | $ - 0 | |
| Strike Warfare Avaiation Specialist-Data Links | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Ground Weapons | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Air Weapons | 478 | $ - 0 | |
| E-2D Specialist | 478 | $ - 0 | |
| Marine Rotary/Tiltrotor Specialist | 478 | $ - 0 | |
| Joint Precision Approach and Landing System (JPALS) Specialist | 478 | $ - 0 | |
| Naval Aviation Maintenance Technician | 478 | $ - 0 | |
| Aviation Logistics Specialist | 478 | $ - 0 | |
| Aviation Electronic Attack Specialist | 478 | $ - 0 | |
| Aviation Electronic Warfare Self Protect Specialist | 478 | $ - 0 | |
| Aviation Infrared Self Protect Specialist | 478 | $ - 0 | |
| Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist | 478 | $ - 0 | |
| Navy Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Marine Corps Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist | 478 | $ - 0 | |
| JMPS-M_T&E Specialist | 478 | $ - 0 | |
| Automated Test Information System Specialist | 478 | $ - 0 | |
| Cyber Security Subject Matter Expert/Operational (SME) | 478 | $ - 0 | |
| Year 3 Labor Subtotal | 75,906 | $ - 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 | |
| Aircraft Handling Specialist | 478 | $ - 0 | |
| Joint Strike Fighter Specialist | 478 | $ - 0 | |
| Strike Warfare Avaiation Specialist-Data Links | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Ground Weapons | 478 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Air Weapons | 478 | $ - 0 | |
| E-2D Specialist | 478 | $ - 0 | |
| Marine Rotary/Tiltrotor Specialist | 478 | $ - 0 | |
| Joint Precision Approach and Landing System (JPALS) Specialist | 478 | $ - 0 | |
| Naval Aviation Maintenance Technician | 478 | $ - 0 | |
| Aviation Logistics Specialist | 478 | $ - 0 | |
| Aviation Electronic Attack Specialist | 478 | $ - 0 | |
| Aviation Electronic Warfare Self Protect Specialist | 478 | $ - 0 | |
| Aviation Infrared Self Protect Specialist | 478 | $ - 0 | |
| Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist | 478 | $ - 0 | |
| Navy Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Marine Corps Unmanned Aviation Systems Specialist | 478 | $ - 0 | |
| Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist | 478 | $ - 0 | |
| JMPS-M_T&E Specialist | 478 | $ - 0 | |
| Automated Test Information System Specialist | 478 | $ - 0 | |
| Cyber Security Subject Matter Expert/Operational (SME) | 478 | $ - 0 | |
| Year 4 Labor Subtotal | 75,906 | $ - 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 | |
| Aircraft Handling Specialist | 239 | $ - 0 | |
| Joint Strike Fighter Specialist | 239 | $ - 0 | |
| Strike Warfare Avaiation Specialist-Data Links | 239 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Ground Weapons | 239 | $ - 0 | |
| Strike Warfare Aviation Specialist- Air to Air Weapons | 239 | $ - 0 | |
| E-2D Specialist | 239 | $ - 0 | |
| Marine Rotary/Tiltrotor Specialist | 239 | $ - 0 | |
| Joint Precision Approach and Landing System (JPALS) Specialist | 239 | $ - 0 | |
| Naval Aviation Maintenance Technician | 239 | $ - 0 | |
| Aviation Logistics Specialist | 239 | $ - 0 | |
| Aviation Electronic Attack Specialist | 239 | $ - 0 | |
| Aviation Electronic Warfare Self Protect Specialist | 239 | $ - 0 | |
| Aviation Infrared Self Protect Specialist | 239 | $ - 0 | |
| Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist | 239 | $ - 0 | |
| Navy Unmanned Aviation Systems Specialist | 239 | $ - 0 | |
| Marine Corps Unmanned Aviation Systems Specialist | 239 | $ - 0 | |
| Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist | 239 | $ - 0 | |
| JMPS-M_T&E Specialist | 239 | $ - 0 | |
| Automated Test Information System Specialist | 239 | $ - 0 | |
| Cyber Security Subject Matter Expert/Operational (SME) | 239 | $ - 0 | |
| FAR clause 52.217-8 Labor Subtotal | 37,953 | $ - 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 .