Attachment L-4 Price Proposal Forms-Excel Pricing Model.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
Evaluations, Assessments, and Support Services (EASS)
Solicitation number
80LARC27R0003
Issued by

About this file

This is a pricing template and instructions document for the Evaluations, Assessments, and Support Services (EASS) contract solicitation (80LARC27R0003) issued by NASA Langley Research Center. The Excel-based pricing model requires offerors to submit a comprehensive cost proposal across five contract years plus an option to extend services. Offerors must complete green-highlighted fields including: firm fixed-price (FFP) labor rates organized by seven labor categories (SME Levels I-IV, Task Manager, Editor/Technical Writer, and Data/Task Integrator); detailed labor rate build-ups showing unburdened rates, fringe, overhead, G&A, and profit; travel costs with applicable burden rates; and other direct costs (ODCs) with associated burdens. The government has pre-populated estimated travel amounts ($3,358,200 total) and ODC amounts ($395,056 total) that offerors must not adjust, with the total evaluated price showing $3,753,255.

Additional proposal requirements include completion of a Schedule of Major Subcontracts identifying all subcontractors, their addresses, contract types, basis of selection, and cost-price analyses performed; a Limitations on Subcontracting verification demonstrating compliance with FAR 52.219-14 requirements for the percentage of contract work performed by the prime contractor versus subcontractors; and a Model Task Order (MTO) evaluation tab showing labor category hours and rates across all contract periods. The template is designed with auto-calculation of yellow-highlighted fields based on offeror inputs, and offerors must ensure that total evaluated hours by labor category match the government-provided hour requirements for each year and labor classification.

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

1-1 Instructions

Insert Offeror's Name
Attachment L-4 Price Proposal Forms-Excel Pricing Model
Instructions:
Overall Offeror Instructions for Attachment L-4 Pricing Model.
1. Enter Company Name in cell A1 of this sheet. Your company name will auto-populate on all worksheets/templates.
GREEN FIELDS and other fields as instructed below are to be completed by the Offeror.
YELLOW FIELDS are auto-calculated.
2. Price Schedule Tab Instructions:
a. 1-2 Total Proposed Price: Calculations for the Total Proposed Price based on the Firm Fixed-Price (FFP) Labor, Travel, ODCs and option to extend services. This tab is auto-calculated.
b. 1-3 FFP Labor Price: The Offeror must complete all sections highlighted in green with their FFP labor rates. In addition, for each Year, offerors must propose hour breakouts for each of the SME category levels I - IV; and, the sum of those hour breakouts should equal the grand total SME hours provided on row 9. If the Offeror uses subcontractor labor, they must allocate those hours by adding additional rows. For example, independent SMEs may be included in one line item, with the hours representing the sum total and the rate representing the average rate, across all the independent SMEs. The total evaluated hours by labor category must equal the amounts included in tab 1-3 FFP Labor Price.

c. 1-3a Labor Rate Build-up: The Offeror must fill in all blanks to provide the full labor rate build-up to include unburdened labor rate, fringe, overhead, G&A, profit, and any additional burdens as applicable.

d. 1-4 Travel and ODCs: The Offeror must complete all sections highlighted in GREEN by proposing any applicable burden (Ex. Material Handling, G&A, etc.) that would be applied to Travel and/or ODCs during contract execution. The ODC and Travel burdens must NOT include profit/fee as ODCs will be awarded on a no profit or fee basis. The evaluated price for Travel and ODCs is auto-calculated and offerors must not adjust the Government provided ODC amounts.

e. 1-5 Schedule of Major Subcontractors: Offerors must fill-in and identify major subcontractors. This includes but not limited to, subcontractors address, contract type, and basis of selection. Reference section L of the solicitation for more detailed instructions.
f. 1-6 Limit on Subcontracting: Offerors must complete and provide the information necessary to demonstrate that it meets the limitations set forth in FAR 52.219-14(e)(1), Limitations on Subcontracting (see L.20 of the RFP).
g. 1-7 MTO - Evaluation: The Offeror must fill in all blanks for hours, ODCs and travel to complete the Model Task Order (MTO). Fully burdened labor rates will pull directly from tab 1-3a for each year.

1-2 Total Proposed Price

Insert Offeror's Name
Proposed Price
Firm Fixed-Price (FFP) Labor$0
Travel$3,358,200
ODCs$395,056
Total Proposed Price$3,753,255

1-3 FFP Labor Price

Insert Offeror's Name
Year 1Year 2Year 3Year 4Year 5OPTION TO EXTEND
Evaluated Price per Period$0.00$0.00$0.00$0.00$0.00$0.00
Evaluated FFP Labor Price$0.00
Firm Fixed-Price (FFP) Labor
TypeLabor Categories to be Proposed By OfferorsYear 1Year 2Year 3Year 4Year 5
Evaluated HoursLabor RateTotal Labor DollarsEvaluated HoursLabor RateTotal Labor DollarsEvaluated HoursLabor RateTotal Labor DollarsEvaluated HoursLabor RateTotal Labor DollarsEvaluated HoursLabor RateTotal Labor Dollars
FFPSubject Matter Expert (SME)42,71353,55063,00256,52529,436
FFPSME I$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
FFPSME II$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
FFPSME III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
FFPSME IV$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
FFPTask Manager6,788$0.00$0.008,510$0.00$0.0010,012$0.00$0.008,983$0.00$0.004,678$0.00$0.00
FFPEditor/Technical Writer297$0.00$0.00372$0.00$0.00438$0.00$0.00393$0.00$0.00205$0.00$0.00
FFPData/Task Integrator453$0.00$0.00567$0.00$0.00667$0.00$0.00599$0.00$0.00312$0.00$0.00
Total50,251$0.0062,999$0.0074,119$0.0066,500$0.0034,631$0.00

1-3a Labor Rate Build-up

Offeror: _________________________________________________Instructions:
Offeror to provide:
Year 1Labor Rate
Labor CategoryDirect Labor RateFringeG&AOverhead*Add any additional burdens applicable*Add any additional burdens applicableProfitBurdened RateBurdened rate including ALL indirect costs and profitHours per WYE reconciliation
Total annual hours2080
SME I$0.00Less Holiday
SME II$0.00Less Vacation
SME III$0.00Less other leave
SME IV$0.00Hours/WYE2080
Task Manager$0.00
Editor/Technical Writer$0.00
Data/Task Integrator$0.00
Year 2
Labor CategoryDirect Labor RateFringeG&AOverhead*Add any additional burdens applicable*Add any additional burdens applicableProfitBurdened Rate
SME I$0.00
SME II$0.00
SME III$0.00
SME IV$0.00
Task Manager$0.00
Editor/Technical Writer$0.00
Data/Task Integrator$0.00
Year 3
Labor CategoryDirect Labor RateFringeG&AOverhead*Add any additional burdens applicable*Add any additional burdens applicableProfitBurdened Rate
SME I$0.00
SME II$0.00
SME III$0.00
SME IV$0.00
Task Manager$0.00
Editor/Technical Writer$0.00
Data/Task Integrator$0.00
Year 4
Labor CategoryDirect Labor RateFringeG&AOverhead*Add any additional burdens applicable*Add any additional burdens applicableProfitBurdened Rate
SME I$0.00
SME II$0.00
SME III$0.00
SME IV$0.00
Task Manager$0.00
Editor/Technical Writer$0.00
Data/Task Integrator$0.00
Year 5
Labor CategoryDirect Labor RateFringeG&AOverhead*Add any additional burdens applicable*Add any additional burdens applicableProfitBurdened Rate
SME I$0.00
SME II$0.00
SME III$0.00
SME IV$0.00
Task Manager$0.00
Editor/Technical Writer$0.00
Data/Task Integrator$0.00

1-4 Travel and ODCs

Insert Offeror's Name
TravelPeriodEstimated AmountProposed BurdenIndirect Evaluated AmountEvaluated Amount
TravelYear 1$548,209$0$548,209
Year 2$689,465$0$689,465
Year 3$813,905$0$813,905
Year 4$732,767$0$732,767
Year 5$382,569$0$382,569
Option to Extend Services$191,285
Evaluated Travel Price$3,358,200
ODCsPeriodEstimated AmountProposed BurdenIndirect Evaluated AmountEvaluated Amount
ODCsYear 1$64,491$0$64,491
Year 2$81,108$0$81,108
Year 3$95,747$0$95,747
Year 4$86,202$0$86,202
Year 5$45,005$0$45,005
Option to Extend Services$22,503
Evaluated ODC Price$395,056

1-5 Schedule Major Subcontracts

Insert Offeror's Name
Schedule of Major Subcontracts

[ ] Prime Contractor: ______________________________________

Description of Work:

Number of quotes solicited/received
Subcontractor selected:Subcontract (1) Name and AddressSubcontract (2) Name and AddressSubcontract (3) Name and AddressSubcontract (4) Name and Address

Basis of Selection:*

Type of Subcontract:**

Cost
Fee/Profit
Total Amount Proposed$ - 0$ - 0$ - 0$ - 0
Affiliation with Prime:***

Cost/Price Analysis Performed by Prime:****

* Lowest price, teaming partner, technical qualifications, etc.
** FFP, CPAF, CPFF, T&M, etc.
*** Subcontractor, subsidiary, interdivisional, etc.
**** FAR 15.404-3(b) requires that contractors conduct appropriate cost or price analyses to establish the reasonableness of proposed subcontract prices and include the results of these analyses in the price proposal. If response above is "No", explain why cost or price analysis was not performed and how the Offeror determined that the proposed subcontract price was reasonable.

1-6 Limit on Subcontracting

Verification of Limitations on Subcontracting
EASS

Offeror: _________________________________________________

FAR 52.219-14, Limitations on Subcontracting

Cost of Contract Performance Calculations:
Prime Offeror's cost of contract performance including similarly situated Subcontractors/Independent Contractors (i.e., burdened labor cost excluding fee).
Not Similarly Situated Subcontractors' cost of contract performance (i.e., burdened labor cost excluding fee).
Total Cost of Contract Performance:
Percent Calculations:
Prime Offeror's percent of the cost of contract performance:
Subcontractors' percent of the cost of contract performance:
TOTAL:

1-7 MTO-Evaluation

MTO Evaluation Task
Year 1Year 2Year 3Year 4Year 5Total
Labor CategoryHoursRateTotalHoursRateTotalHoursRateTotalHoursRateTotalHoursRateTotal
SME I$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
SME II$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
SME III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
SME IV$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Task Manager$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Editor/Technical Writer$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Data/Task Integrator$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Travel$0.00
ODCs$0.00
Total0$0.000$0.000$0.000$0.000$0.00$0.00

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