Attachment 2 - Pricing Workbook_Advanced Helicopter_220124.xlsx

XLSX spreadsheet 39 KB Posted

Attached to
United States Army Aviation Center of Excellence (USAACE) Advanced Helicopter Flight Training Support Services
Solicitation number
DRAFT-RFP-W9124G24R0001
Issued by

About this file

This document package includes a pricing workbook template and information related to a draft request for proposal for advanced helicopter flight training support services. The pricing workbook template provides instructions and tables for offerors to submit proposed labor rates, fringe benefits, overhead costs, and profit for various labor categories over a five-year ordering period. Labor categories include program manager, instructor pilots for different helicopter models, maintenance examiners, and flight instructors. The template includes notes on requirements for professional employee compensation plans and service contract labor standards designations. The related draft RFP opportunity description indicates the solicitation number has changed from a prior sources sought notice and that feedback received will be used to finalize solicitation documents. The requirement is for the United States Army Aviation Center of Excellence in Fort Rucker, Alabama to provide advanced helicopter flight training support services. No further details are provided on the specific products or services required.

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

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
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0001
000101Services - Phase-In1.00Months$ - 0$ - 0
000102Services - Base Year11.00Months$ - 0$ - 0
0002UH-60M Instructor Pilot (IP) Surge (Optional)12.00Months$ - 0$ - 0
0003UH-60M Maintenance Examiner (ME) Surge (Optional)12.00Months$ - 0$ - 0
0004AH-64E IP Surge (Optional)12.00Months$ - 0$ - 0
0005CH-47F Flight Engineer (FE) Non-Rated Crew Member (NRCM) Surge (Optional)12.00Months$ - 0$ - 0
0006Service Contract Reporting (SCR)1.00Job$ - 0$ - 0
Option Year (OY) 1
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1001Services - Option Year 112.00Months$ - 0$ - 0
1002UH-60M IP Surge (Optional)12.00Months$ - 0$ - 0
1003UH-60M ME Surge (Optional)12.00Months$ - 0$ - 0
1004AH-64E IP Surge (Optional)12.00Months$ - 0$ - 0
1005CH-47F FE NRCM Surge (Optional)12.00Months$ - 0$ - 0
1006SCR1.00Job$ - 0$ - 0
OY 2
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2001Services - Option Year 112.00Months$ - 0$ - 0
2002UH-60M IP Surge (Optional)12.00Months$ - 0$ - 0
2003UH-60M ME Surge (Optional)12.00Months$ - 0$ - 0
2004AH-64E IP Surge (Optional)12.00Months$ - 0$ - 0
2005CH-47F FE NRCM Surge (Optional)12.00Months$ - 0$ - 0
2006SCR1.00Job$ - 0$ - 0
OY 3
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
3001Services - Option Year 112.00Months$ - 0$ - 0
3002UH-60M IP Surge (Optional)12.00Months$ - 0$ - 0
3003UH-60M ME Surge (Optional)12.00Months$ - 0$ - 0
3004AH-64E IP Surge (Optional)12.00Months$ - 0$ - 0
3005CH-47F FE NRCM Surge (Optional)12.00Months$ - 0$ - 0
3006SCR1.00Job$ - 0$ - 0
OY 4
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
4001Services - Option Year 112.00Months$ - 0$ - 0
4002UH-60M IP Surge (Optional)12.00Months$ - 0$ - 0
4003UH-60M ME Surge (Optional)12.00Months$ - 0$ - 0
4004AH-64E IP Surge (Optional)12.00Months$ - 0$ - 0
4005CH-47F FE NRCM Surge (Optional)12.00Months$ - 0$ - 0
4006SCR1.00Job$ - 0$ - 0
Total Price$ - 0

Fixed Price Labor

Solicitation Number: W9124G24R0001
Prime Contractor:Escalation Factor ======>
Fringe RateERROR:#DIV/0!Phase-InBase YearOption year 1Option year 2Option year 3Option year 4
1-Month Phase-InYear 1 of 5Year 2 of 5Year 3 of 5Year 4 of 5Year 5 of 5Grand Total for 5-year Ordering Period
LABOR CATEGORYFTEsAnnual Productive Hrs./FTETotal Annual Hours (FTEs X Productive Hrs.)Service Contract Act (SCA)
(Mark with 'X' in appropriate cell below)Vendor NameDirect Labor RateDirect Labor Costs (Total annual hours X Direct Labor rate)Paid time off hoursPaid time off costFICAFUTASUTAWorker's CompHealth/Life InsuranceRetirement PlanOther (Specify)Total Fringe BenefitsOverhead CostsG&A CostProftTotal Annual CostMonthly 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 PriceEscalated Total Annual PriceEscalated Total Annual PriceEscalated Total Annual PriceTotal Price @ Burdened Rate
ExemptNon-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-In11- MonthsYear 2 of 5Year 3 of 5Year 4 of 5Year 5 of 5Grand Total for 5-year Ordering Period
- 0

File details come from the government source that posted it. Updated .