Revised Pricing Spreadsheet.xlsx

XLSX spreadsheet 27 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 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 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
Aircraft Handling Specialist478$ - 0
Joint Strike Fighter Specialist478$ - 0
Strike Warfare Aviation Specialist-Data Links478$ - 0
Strike Warfare Aviation Specialist-Air to Ground Weapons478$ - 0
Strike Warfare Aviation Specialist-Air to Air Weapons478$ - 0
E-2D Specialist478$ - 0
Marine Rotary/Tiltrotor Specialist478$ - 0
Joint Precision Approach and Landing System (JPALS) Specialist478$ - 0
Naval Aviation Maintenance Technician478$ - 0
Aviation Logistics Specialist478$ - 0
Aviation Electronic Attack Specialist478$ - 0
Aviation Electronic Warfare Self Protect Specialist478$ - 0
Aviation Infrared Self Protect Specialist478$ - 0
Naval Rotary Anti-Surface Warfare/Anti-Submarine Warfare Specialist478$ - 0
Navy Unmanned Aviation Systems Specialist478$ - 0
Marine Corps Unmanned Aviation Systems Specialist478$ - 0
Naval Fixed-Wing Anti-Surface Warfare/Anti-Submarine Warfare Specialist478$ - 0
JMPS-M_T&E Specialist478$ - 0
Automated Test Information System Specialist478$ - 0
Cyber Security Subject Matter Expert/Operational (SME)478$ - 0
BASE Year Labor Subtotal75,906$ - 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
Aircraft Handling Specialist478$ - 0
Joint Strike Fighter Specialist478$ - 0
Strike Warfare Avaiation Specialist-Data Links478$ - 0
Strike Warfare Aviation Specialist- Air to Ground Weapons478$ - 0
Strike Warfare Aviation Specialist- Air to Air Weapons478$ - 0
E-2D Specialist478$ - 0
Marine Rotary/Tiltrotor Specialist478$ - 0
Joint Precision Approach and Landing System (JPALS) Specialist478$ - 0
Naval Aviation Maintenance Technician478$ - 0
Aviation Logistics Specialist478$ - 0
Aviation Electronic Attack Specialist478$ - 0
Aviation Electronic Warfare Self Protect Specialist478$ - 0
Aviation Infrared Self Protect Specialist478$ - 0
Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist478$ - 0
Navy Unmanned Aviation Systems Specialist478$ - 0
Marine Corps Unmanned Aviation Systems Specialist478$ - 0
Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist478$ - 0
JMPS-M_T&E Specialist478$ - 0
Automated Test Information System Specialist478$ - 0
Cyber Security Subject Matter Expert/Operational (SME)478$ - 0
Year 1 Labor Subtotal75,906$ - 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
Aircraft Handling Specialist478$ - 0
Joint Strike Fighter Specialist478$ - 0
Strike Warfare Avaiation Specialist-Data Links478$ - 0
Strike Warfare Aviation Specialist- Air to Ground Weapons478$ - 0
Strike Warfare Aviation Specialist- Air to Air Weapons478$ - 0
E-2D Specialist478$ - 0
Marine Rotary/Tiltrotor Specialist478$ - 0
Joint Precision Approach and Landing System (JPALS) Specialist478$ - 0
Naval Aviation Maintenance Technician478$ - 0
Aviation Logistics Specialist478$ - 0
Aviation Electronic Attack Specialist478$ - 0
Aviation Electronic Warfare Self Protect Specialist478$ - 0
Aviation Infrared Self Protect Specialist478$ - 0
Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist478$ - 0
Navy Unmanned Aviation Systems Specialist478$ - 0
Marine Corps Unmanned Aviation Systems Specialist478$ - 0
Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist478$ - 0
JMPS-M_T&E Specialist478$ - 0
Automated Test Information System Specialist478$ - 0
Cyber Security Subject Matter Expert/Operational (SME)478$ - 0
Year 2 Labor Subtotal75,906$ - 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
Aircraft Handling Specialist478$ - 0
Joint Strike Fighter Specialist478$ - 0
Strike Warfare Avaiation Specialist-Data Links478$ - 0
Strike Warfare Aviation Specialist- Air to Ground Weapons478$ - 0
Strike Warfare Aviation Specialist- Air to Air Weapons478$ - 0
E-2D Specialist478$ - 0
Marine Rotary/Tiltrotor Specialist478$ - 0
Joint Precision Approach and Landing System (JPALS) Specialist478$ - 0
Naval Aviation Maintenance Technician478$ - 0
Aviation Logistics Specialist478$ - 0
Aviation Electronic Attack Specialist478$ - 0
Aviation Electronic Warfare Self Protect Specialist478$ - 0
Aviation Infrared Self Protect Specialist478$ - 0
Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist478$ - 0
Navy Unmanned Aviation Systems Specialist478$ - 0
Marine Corps Unmanned Aviation Systems Specialist478$ - 0
Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist478$ - 0
JMPS-M_T&E Specialist478$ - 0
Automated Test Information System Specialist478$ - 0
Cyber Security Subject Matter Expert/Operational (SME)478$ - 0
Year 3 Labor Subtotal75,906$ - 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
Aircraft Handling Specialist478$ - 0
Joint Strike Fighter Specialist478$ - 0
Strike Warfare Avaiation Specialist-Data Links478$ - 0
Strike Warfare Aviation Specialist- Air to Ground Weapons478$ - 0
Strike Warfare Aviation Specialist- Air to Air Weapons478$ - 0
E-2D Specialist478$ - 0
Marine Rotary/Tiltrotor Specialist478$ - 0
Joint Precision Approach and Landing System (JPALS) Specialist478$ - 0
Naval Aviation Maintenance Technician478$ - 0
Aviation Logistics Specialist478$ - 0
Aviation Electronic Attack Specialist478$ - 0
Aviation Electronic Warfare Self Protect Specialist478$ - 0
Aviation Infrared Self Protect Specialist478$ - 0
Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist478$ - 0
Navy Unmanned Aviation Systems Specialist478$ - 0
Marine Corps Unmanned Aviation Systems Specialist478$ - 0
Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist478$ - 0
JMPS-M_T&E Specialist478$ - 0
Automated Test Information System Specialist478$ - 0
Cyber Security Subject Matter Expert/Operational (SME)478$ - 0
Year 4 Labor Subtotal75,906$ - 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
Aircraft Handling Specialist239$ - 0
Joint Strike Fighter Specialist239$ - 0
Strike Warfare Avaiation Specialist-Data Links239$ - 0
Strike Warfare Aviation Specialist- Air to Ground Weapons239$ - 0
Strike Warfare Aviation Specialist- Air to Air Weapons239$ - 0
E-2D Specialist239$ - 0
Marine Rotary/Tiltrotor Specialist239$ - 0
Joint Precision Approach and Landing System (JPALS) Specialist239$ - 0
Naval Aviation Maintenance Technician239$ - 0
Aviation Logistics Specialist239$ - 0
Aviation Electronic Attack Specialist239$ - 0
Aviation Electronic Warfare Self Protect Specialist239$ - 0
Aviation Infrared Self Protect Specialist239$ - 0
Naval Rotary Anit-Surface Warfare/ Anti-Submarince Warfare Specialist239$ - 0
Navy Unmanned Aviation Systems Specialist239$ - 0
Marine Corps Unmanned Aviation Systems Specialist239$ - 0
Naval Fixed-Wing Anti-Surface Warfare/ Anit-Submarine Warfare Specialist239$ - 0
JMPS-M_T&E Specialist239$ - 0
Automated Test Information System Specialist239$ - 0
Cyber Security Subject Matter Expert/Operational (SME)239$ - 0
FAR clause 52.217-8 Labor Subtotal37,953$ - 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 .