Attachment L-4 Price Proposal Forms-Excel Pricing Model.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- 80LARC27R0003
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 1 | Year 2 | Year 3 | Year 4 | Year 5 | OPTION 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 | ||||||||||||||||
| Type | Labor Categories to be Proposed By Offerors | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||
| Evaluated Hours | Labor Rate | Total Labor Dollars | Evaluated Hours | Labor Rate | Total Labor Dollars | Evaluated Hours | Labor Rate | Total Labor Dollars | Evaluated Hours | Labor Rate | Total Labor Dollars | Evaluated Hours | Labor Rate | Total Labor Dollars | ||
| FFP | Subject Matter Expert (SME) | 42,713 | 53,550 | 63,002 | 56,525 | 29,436 | ||||||||||
| FFP | SME I | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| FFP | SME II | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| FFP | SME III | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| FFP | SME IV | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| FFP | Task Manager | 6,788 | $0.00 | $0.00 | 8,510 | $0.00 | $0.00 | 10,012 | $0.00 | $0.00 | 8,983 | $0.00 | $0.00 | 4,678 | $0.00 | $0.00 |
| FFP | Editor/Technical Writer | 297 | $0.00 | $0.00 | 372 | $0.00 | $0.00 | 438 | $0.00 | $0.00 | 393 | $0.00 | $0.00 | 205 | $0.00 | $0.00 |
| FFP | Data/Task Integrator | 453 | $0.00 | $0.00 | 567 | $0.00 | $0.00 | 667 | $0.00 | $0.00 | 599 | $0.00 | $0.00 | 312 | $0.00 | $0.00 |
| Total | 50,251 | $0.00 | 62,999 | $0.00 | 74,119 | $0.00 | 66,500 | $0.00 | 34,631 | $0.00 |
1-3a Labor Rate Build-up
| Offeror: _________________________________________________ | Instructions: | ||||||||||
| Offeror to provide: | |||||||||||
| Year 1 | Labor Rate | ||||||||||
| Labor Category | Direct Labor Rate | Fringe | G&A | Overhead | *Add any additional burdens applicable | *Add any additional burdens applicable | Profit | Burdened Rate | Burdened rate including ALL indirect costs and profit | Hours per WYE reconciliation | |
| Total annual hours | 2080 | ||||||||||
| SME I | $0.00 | Less Holiday | |||||||||
| SME II | $0.00 | Less Vacation | |||||||||
| SME III | $0.00 | Less other leave | |||||||||
| SME IV | $0.00 | Hours/WYE | 2080 | ||||||||
| Task Manager | $0.00 | ||||||||||
| Editor/Technical Writer | $0.00 | ||||||||||
| Data/Task Integrator | $0.00 | ||||||||||
| Year 2 | |||||||||||
| Labor Category | Direct Labor Rate | Fringe | G&A | Overhead | *Add any additional burdens applicable | *Add any additional burdens applicable | Profit | Burdened 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 Category | Direct Labor Rate | Fringe | G&A | Overhead | *Add any additional burdens applicable | *Add any additional burdens applicable | Profit | Burdened 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 Category | Direct Labor Rate | Fringe | G&A | Overhead | *Add any additional burdens applicable | *Add any additional burdens applicable | Profit | Burdened 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 Category | Direct Labor Rate | Fringe | G&A | Overhead | *Add any additional burdens applicable | *Add any additional burdens applicable | Profit | Burdened 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 | ||||||
| Travel | Period | Estimated Amount | Proposed Burden | Indirect Evaluated Amount | Evaluated Amount |
| Travel | Year 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 | ||||
| ODCs | Period | Estimated Amount | Proposed Burden | Indirect Evaluated Amount | Evaluated Amount |
| ODCs | Year 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 Address | Subcontract (2) Name and Address | Subcontract (3) Name and Address | Subcontract (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 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | |||||||||||
| Labor Category | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | |
| 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 | |||||||||||||||
| Total | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | $0.00 |
File details come from the government source that posted it. Updated .