Attachment 2 - (Amended) Pricing Workbook_Advanced Helicopter_220324.xlsx
XLSX spreadsheet 49 KB Posted
- Solicitation number
- W9124G24R0001
About this file
This document is an amended pricing workbook for a draft Request for Proposal (RFP) related to the United States Army Aviation Center of Excellence (USAACE) Advanced Helicopter Flight Training Services (AHFTS) contract opportunity, Solicitation Number W9124G24R0001.
The pricing workbook provides instructions for offerors to complete the Section B pricing worksheet and the Fixed Price Labor worksheet. It specifies the required labor categories, including those deemed Professional Employees, and the need to provide supporting documentation for labor rates. Offerors must provide fully burdened monthly and annual labor rates for the base year and four option years, as well as daily billing rates for various training requirements and surge capabilities. The total evaluated price is to be the sum of all labor categories for the five-year ordering period.
View the file
Other files
Show all 12
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
Instructions
DRAFT RFP INSTRUCTIONS
General: Each offeror is to provide a price proposal and accompanying narrative as part of its proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed enclosed spreadsheets shall be part of the price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any subcontractors/teaming partners pricing when the prime offeror uses those rates to establish labor category rates. The proposed costs and prices will be evaluated for completeness, fairness, and reasonableness based on the price analysis criteria in FAR 15.404-1. For proprietary reasons, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror. However, the total proposed price shall be reflected in the Prime's offer.
Section B Worksheet: The Section B worksheet is used as a basis for the proposed Section B.
Fixed Price Labor Detail Worksheet:
General: It may be necessary for Offerors to revise the number of rows, columns, and/or formulas to reflect differences or nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for price analysis and contract administration purposes. Formulas may be adjusted to accommodate variances in accounting system. All data must be included and may not be linked to data not provided in the workbook.
NOTE 1: The Government has identified specific labor categories it deems as a Professional Employee. These labor categories are marked in the Fixed Price Labor tab with a bolded (PE). These labor categories require a Total Compensation Plan as required by the solicitation and FAR provision 52.222-46. For proprietary reasons, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror. However, the total proposed price shall be reflected in the Prime's offer.
NOTE 2: Please specify whether the Offeror has deemed a specific labor category to fall under the Service Contract Labor Standards by stating 'SCLS' and providing the selected SCLS occupation code in the applicable columns. For labor categories the Government has deemed to be Professional Employees, a Bureau of Labor Statistics Occupation Code shall be provided by the Offeror. These labor categories have already been entered as 'BLS' in the applicable column. If a labor category does not fall under either category, please insert an 'NA' in the SCLS/BLS column.
NOTE 3: Complete all columns for all labor categories, regardless of SCLS or Professional Employee status. For any labor categories deemed as SCLS, the direct rate, fringe benefit detail, and other information will be used to validate SCLS rate requirements (e.g.: health and wellness requirements) and may be used for future REAs were an increase in labor rate be required. Once all information has been provided, enter the total billabable labor rate for the listed labor categories and calculate the total value for each labor category for each year using the estimated hours provided. A total evaluated price is located at the bottom that shall be a sum total of all labor categories for all 5 years with the specified number of hours.
NOTE 4: The Service Contract Reporting requirement at CLIN 0003 shall not be priced at the IDIQ level. This reporting requirement shall be priced at the TO level.
DRAFT RFP DRAFT RFP
Instruction
Complete the UNIT PRICE column on the tab named ‘Section B’. The calculations on the ‘Fixed Price Labor’ tab should support the UNIT PRICEs proposed. Total Price proposed should be included below option year 4.
-Do not place price in CLIN 0001
-Place 'Services - Phase-In' price for CLIN 0001 in SLIN 000101
-Place 'Services - Base Year' price for CLIN 0001 in SLIN 000102
Complete the ‘Fixed Price Labor’ tab.
-Add rows for labor categories as necessary to agree with each offerors technical approach.
- Identify in the ‘support’ column, the page and paragraph of the Total Compensation Plan for Professional Employees (TCPPE) narrative to support the labor rate. The narrative should identify how the direct labor rate proposed was established (include all necessary information to support, including: surveys used and screenshots, internal data, etc.)
-Add columns as necessary for any applicable fringe costs not already included to agree with each offeror accounting and estimating practices.
NOTES:
- Offerors shall not include pricing for SURGE for Phase-In.
-Remember to apply escalation as appropriate to labor categories for option years.
-Offerors are responsible for their proposals. This includes checking for and correcting any errors identified in this workbook.
Section B
| Solicitation # W91QF422R0001 | |||||
| Prime Contractor: | |||||
| Base Year | |||||
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0001 | |||||
| 000101 | Services - Phase-In | 1.00 | Months | $ - 0 | $ - 0 |
| 000102 | Services - Base Year | 11.00 | Months | $ - 0 | $ - 0 |
| 0002 | UH-60M Instructor Pilot (IP) Surge (Optional) | 11.00 | Months | $ - 0 | $ - 0 |
| 0003 | UH-60M Maintenance Examiner (ME) Surge (Optional) | 11.00 | Months | $ - 0 | $ - 0 |
| 0004 | AH-64E IP Surge (Optional) | 11.00 | Months | $ - 0 | $ - 0 |
| 0005 | CH-47F Flight Engineer (FE) Non-Rated Crew Member (NRCM) Surge (Optional) | 11.00 | Months | $ - 0 | $ - 0 |
| 0006 | Service Contract Reporting (SCR) | 1.00 | Job | $ - 0 | $ - 0 |
| Option Year (OY) 1 | |||||
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 1001 | Services - Option Year 1 | 12.00 | Months | $ - 0 | $ - 0 |
| 1002 | UH-60M IP Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 1003 | UH-60M ME Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 1004 | AH-64E IP Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 1005 | CH-47F FE NRCM Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 1006 | SCR | 1.00 | Job | $ - 0 | $ - 0 |
| OY 2 | |||||
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 2001 | Services - Option Year 1 | 12.00 | Months | $ - 0 | $ - 0 |
| 2002 | UH-60M IP Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 2003 | UH-60M ME Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 2004 | AH-64E IP Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 2005 | CH-47F FE NRCM Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 2006 | SCR | 1.00 | Job | $ - 0 | $ - 0 |
| OY 3 | |||||
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 3001 | Services - Option Year 1 | 12.00 | Months | $ - 0 | $ - 0 |
| 3002 | UH-60M IP Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 3003 | UH-60M ME Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 3004 | AH-64E IP Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 3005 | CH-47F FE NRCM Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 3006 | SCR | 1.00 | Job | $ - 0 | $ - 0 |
| OY 4 | |||||
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 4001 | Services - Option Year 1 | 12.00 | Months | $ - 0 | $ - 0 |
| 4002 | UH-60M IP Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 4003 | UH-60M ME Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 4004 | AH-64E IP Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 4005 | CH-47F FE NRCM Surge (Optional) | 12.00 | Months | $ - 0 | $ - 0 |
| 4006 | SCR | 1.00 | Job | $ - 0 | $ - 0 |
| Total Price | $ - 0 |
Fixed Price Labor
| Solicitation Number: W9124G24R0001 | ||||||||||||||||||||||||||||||||
| Prime Contractor: | Escalation Factor ======> | |||||||||||||||||||||||||||||||
| Fringe Rate | ERROR:#DIV/0! | Phase-In | Base Year | Option year 1 | Option year 2 | Option year 3 | Option year 4 | |||||||||||||||||||||||||
| 1-Month Phase-In | Year 1 of 5 | Year 2 of 5 | Year 3 of 5 | Year 4 of 5 | Year 5 of 5 | Grand Total for 5-year Ordering Period | ||||||||||||||||||||||||||
| LABOR CATEGORY | FTEs | Annual Productive Hrs./FTE | Total Annual Hours (FTEs X Productive Hrs.) | Service Contract Act (SCA) | ||||||||||||||||||||||||||||
| (Mark with 'X' in appropriate cell below) | Vendor Name | Direct Labor Rate | Direct Labor Costs (Total annual hours X Direct Labor rate) | Paid time off hours | Paid time off cost | FICA | FUTA | SUTA | Worker's Comp | Health/Life Insurance | Retirement Plan | Other (Specify) | Total Fringe Benefits | Overhead Costs | G&A Cost | Proft | Total Annual Cost | Monthly Cost (divide total cost by 12) | Billable Labor Rate (divide total cost by total hours) | 1 Month Price (1/12 of total annual cost) | 11 Months Price (11/12 of total annual cost) | Escalated Total Annual Price | Escalated Total Annual Price | Escalated Total Annual Price | Escalated Total Annual Price | Total Price @ Burdened Rate | ||||||
| Exempt | Non-Exempt | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | |||||||||||||||||||||
| Program Manager | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| Alternate Program Manager | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| AH-64E Instuctor Pilot | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| CH-47F Instructor Pilot | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| CH-47F Flight Engineer | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| UH-60M Instructor Pilot | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| UH-60M Maintenance Examine | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| UH-60M Flight Instructor | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| UH-60M Instructor Pilot (Surge) | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| UH-60M Maintenance Examine (Surge) | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| AH-64E Instuctor Pilot (Surge) | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| CH-47F Flight Engineer (Surge) | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 |
| 1-Month Phase-In | 11- Months | Year 2 of 5 | Year 3 of 5 | Year 4 of 5 | Year 5 of 5 | Grand Total for 5-year Ordering Period | |
| - 0 |
Daily Billing Rates Table 1.2 Daily Billing Rates (PWS Training Requirements – Paragraph 5.4.2)
| Training Requirement | Daily Billing Rate | ||||
| Base Year | OY 1 | OY 2 | OY 3 | OY 4 |
UH-60M IP: Daily training capability of 44 flight students (22 - 2:1 student:IP sets)
UH-60M ME: Daily training capability of 6 flight students (3 - 2:1 student:ME sets)
AH-64E IP: Daily training capability for 110 flight students (55 - 2:1 student:IP sets)
CH-47F IP: Daily training capability for 16 flight students (8- 2:1 student:IP sets)
CH-47F FE NRCM: Daily support capability for 10 aircraft (10 - 1:2 aircraft:FE sets)
UH-60M FI NRCM: Daily support capacity for 1 aircraft (1 - 1:1 aircraft:FI set)
Table 1.3 Surge Daily Billing Rates (PWS Training Requirements – Paragraph 5.4.6)
| Surge Training Requirement | Daily Billing Rate | ||||
| Base Year | OY 1 | OY 2 | OY 3 | OY 4 |
UH-60M IP: Up to additional daily training capability of 16 flight students (8 - 2:1 student: IP sets)
UH-60M ME: Up to additional daily training capability of 6 flight students (3 - 2:1 student: ME sets)
AH-64E IP: Up to additional daily training capability for 30 flight students (15 - 2:1 student: IP sets)
CH-47F FE NRCM: Up to additional daily support capability for 5 aircraft (5 - 1:2 aircraft: FE sets)
File details come from the government source that posted it. Updated .