Attachment 2 - Pricing SpreadsheetRev1.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- NSWG2 Tradet Role Players
- Solicitation number
- H92240-23-Q-2018
- Issued by
-
United States Special Operations Command
About this file
This document contains a pricing spreadsheet template for a federal contract solicitation. The solicitation is for role player support services to be provided at multiple locations over five ordering periods. Services include various categories of role players, pyrotechnic specialists, opposing force personnel, and liaison personnel. The spreadsheet requires contractors to provide fully burdened hourly rates for estimated training hours by ordering period and location for each contract line item number. It also requires contractors to provide travel cost details for airfare, hotel, rental cars, and per diem expenses for 12 personnel traveling to locations over 10 days each. Additionally, contractors must provide pricing for ordnance and pyrotechnic packages in the quantities specified for each ordering period. The related federal contract opportunity identifies this as solicitation number H92240-23-Q-2018 for NSWG2 trade role player services being issued by the United States Special Operations Command.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Combined Synopsis - H9224023Q2018Rev1.docx | DOCX document | |
| Combined Synopsis - H9224023Q2018.docx | DOCX document | |
| Attachment 5 - Wage Determination.pdf | ||
| Combined Synopsis - H9224023Q2018.docx | DOCX document | |
| Attachment 1 - PWS TRADET2 Role Player.pdf | ||
| Attachment 4 - DD Form 254- TRADET2 Role Player.pdf | ||
| Attachment 3 - Quality Assurance Surveillance Plan.docx | DOCX document | |
| Attachment 2 - Pricing Spreadsheet.xlsx | XLSX spreadsheet |
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
TEP - ELIN Price Sheet
| Instructions to Offerors: Please enter prices in yellow highlighted cells | ||
| Ordering Period One | 20 September 2023- 19 September 2024 | |
| Ordering Period Two | 20 September 2024- 19 September 2025 | **APPLICABLE PRICING IS BASED ON THE DATE OF TASK ORDER ISSUANCE. |
| Ordering Period Three | 20 September 2025- 19 September 2026 | **QUANTITIES are for evaluation purposes ONLY and will be specified in individual Task Orders** |
| Ordering Period Four | 20 September 2026- 19 September 2027 | ** ELINs for ODCs use the additional tab to calculate price. Spreadsheet is linked to carry the value into this TEP sheet. Prices will be negotiated for travel on each task order as a FFP ELIN. |
| Ordering Period Five | 20 September 2027- 19 September 2028 | ** Rates should be fully burdened to include profit. Overtime rate will be 1.5x regular rate, there is no ELIN for OT rate |
| CLIN | Description | Estimated Training Hours | Hourly Rate for Ordering Period 1 | Total Period 1 | Estimated Training Hours | Hourly Rate for Ordering Period 2 | Total Period 2 | Estimated Training Hours | Hourly Rate for Ordering Period 3 | Total Period 3 | Estimated Training Hours | Hourly Rate for Ordering Period 4 | Total Period 4 | Estimated Training Hours | Hourly Rate for Ordering Period 5 | Total Period 5 | Total Price per CLIN to include all ELINs and Ordering periods | |
| 0001 | Role Players And Support | |||||||||||||||||
| X001 | Role Player Support- Category I | Role Player I (PWS 4.9: Role Player Personnel, RPP) | 5000 | $ - 0 | 5000 | $ - 0 | 5000 | $ - 0 | 5000 | $ - 0 | 5000 | $ - 0 | ||||||
| X002 | Role Player Support- Category II | Pyrotechnic Specialist (PWS 4.7: Pyrotechnics Personnel, PP) | 400 | $ - 0 | 400 | $ - 0 | 400 | $ - 0 | 400 | $ - 0 | 400 | $ - 0 | ||||||
| X003 | Role Player Support- Category III | Tactical Role Player II (PWS 4.8: Opposing Force Personnel, OPFOR) | 10000 | $ - 0 | 10000 | $ - 0 | 10000 | $ - 0 | 10000 | $ - 0 | 10000 | $ - 0 | ||||||
| X004 | Role Player Support- Category IV | Liason Personnel (PWS 4.6: Liaison Personnel, LNO) | 1000 | $ - 0 | 1000 | $ - 0 | 1000 | $ - 0 | 1000 | $ - 0 | 1000 | $ - 0 | ||||||
| X005 | Travel | |||||||||||||||||
| X006 | ODCs | Price is linked to ODC sheet | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Total for CLIN 0001 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Travel Expense detail
| TRAVEL ELIN Expense Detail: | |
| Directions: Contractor to fill in Rate and quantity for travel for each location for total of 12 individuals for 10 days of training. Quantity for Air Expense, Hotel, and rental car are dependent on contractor strategy for filling task order requirements. Please provide details of travel strategy/explanatio below of rates and quantities used. Please use the full MI&E rate for each location as the Government understands it will be different for travel days IAW JTR. |
Travel Explanation
| ELIN X005 | Description - Sample for evaluation -- Role Player Quantity (12 personnel) for each location with training for 10 days each location | Rate | Qty/Days | Ordering Period 1 |
| Travel Estimates PWS 13.1.1 | ||||
| Air Expense | $ - 0 | |||
| Hotel | 9 | $ - 0 | ||
| Rental Car | $ - 0 | |||
| MI&E | 10 | $ - 0 | ||
| Other expenses | $ - 0 | |||
| Total Travel Price for Location PWS 13.1.1 | $ - 0 |
| Travel Estimates PWS 13.1.2 | ||
| Air Expense | $ - 0 | |
| Hotel | 9 | $ - 0 |
| Rental Car | $ - 0 | |
| MI&E | 10 | $ - 0 |
| Other expenses | $ - 0 | |
| Total Travel Price for Location PWS 13.1.2 | $ - 0 |
| Travel Estimates PWS 13.1.3 | ||
| Air Expense | $ - 0 | |
| Hotel | 9 | $ - 0 |
| Rental Car | $ - 0 | |
| MI&E | 10 | $ - 0 |
| Other expenses | $ - 0 | |
| Total Travel Price for Location PWS 13.1.3 | $ - 0 |
| Travel Estimates PWS 13.1.4 | ||
| Air Expense | $ - 0 | |
| Hotel | 9 | $ - 0 |
| Rental Car | $ - 0 | |
| MI&E | 10 | $ - 0 |
| Other expenses | $ - 0 | |
| Total Travel Price for Location PWS 13.1.4 | $ - 0 |
| Travel Estimates PWS 13.1.5 | ||
| Air Expense | $ - 0 | |
| Hotel | 9 | $ - 0 |
| Rental Car | $ - 0 | |
| MI&E | 10 | $ - 0 |
| Other expenses | $ - 0 | |
| Total Travel Price for Location PWS 13.1.5 | $ - 0 |
| Travel Estimates PWS 13.1.6 | ||
| Air Expense | $ - 0 | |
| Hotel | 9 | $ - 0 |
| Rental Car | $ - 0 | |
| MI&E | 10 | $ - 0 |
| Other expenses | $ - 0 | |
| Total Travel Price for Location PWS 13.1.6 | $ - 0 |
ODCs Detail
| Prices for ODC items will be the same across locations, therefore, prices only need to reflect the 5 ordering periods. |
| The spreadsheet is set up to link the total ODC ELIN price to each ELIN in the TEP Tab. |
| Quantities required will be identified in each Task order. The below quantities are only for evaluation of TEP. |
| ODC ELIN | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | |||||||||||
| Description | Est Quantity | Price | Total | Quantity | Price | Total | Quantity | Price | Total | Quantity | Price | Total | Quantity | Price | Total | |
| X006 | Pyrotechnics Package: Improvised Explosive Devices (IED) – 12 EA, Rocket Propelled Grenades (RPG) – 12 Each, Indirect Fire (IDF) – 12 Each, and Smoke effects as necessary to include pop flares (L312) | 15 | $ - 0 | 15 | $ - 0 | 15 | $ - 0 | 15 | $ - 0 | 15 | $ - 0 | |||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||
| ELIN TOTAL | $ - 0 |
Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):
ELIN Total is linked to TEP Tab. ELIN TOTAL $ - 0 Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):
ELIN Total is linked to TEP Tab. ELIN TOTAL $ - 0 Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):
ELIN Total is linked to TEP Tab. ELIN TOTAL $ - 0 Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):
ELIN Total is linked to TEP Tab. ELIN TOTAL $ - 0 Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):
ELIN Total is linked to TEP Tab.
Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):
ELIN Total is linked to TEP Tab.
Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):
ELIN Total is linked to TEP Tab.
File details come from the government source that posted it. Updated .