Attachment L-4 Price Proposal Forms-Excel Pricing Model.xlsx
XLSX spreadsheet 34 KB Posted
- Solicitation number
- 80LARC27R0003
About this file
This is a pricing proposal template for the Evaluations, Assessments, and Support Services (EASS) contract (Solicitation 80LARC27R0003) with NASA Langley Research Center. The Excel-based template is designed to capture firm fixed-price (FFP) labor rates, travel costs, and other direct costs (ODCs) across a five-year contract period with an option to extend services. Offerors must complete green-highlighted fields including company name, labor rates for four job categories (SME, Task Manager, Editor/Technical Writer, and Data/Task Integrator), and provide detailed labor rate buildups showing unburdened rates, fringe benefits, overhead, G&A, and profit margins. The template specifies evaluated hours for each labor category ranging from 297 to 63,002 hours annually depending on the category and contract year, with travel budgets ranging from approximately $191,000 to $813,000 per year and ODCs from approximately $22,500 to $95,700 per year.
The template includes mandatory sections for identifying all subcontractors with their addresses, contract types, and selection rationale; demonstrating compliance with FAR 52.219-14 limitations on subcontracting; and completing a model IDIQ task order evaluation that pulls burdened labor rates from the labor rate buildup tab. Yellow-highlighted fields auto-calculate total proposed prices, evaluated costs, and extended amounts. Offerors must verify that subcontractor costs do not exceed specified thresholds and provide cost or price analysis documentation for all proposed subcontracts. The total evaluated price shown in the template is $3,753,255, comprised of travel ($3,358,200) and ODCs ($395,056), with FFP labor costs to be calculated once rates are entered.
View the file
Other files
Show all 11
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 shall complete all sections highlighted in green with thier FFP labor rates. Offerors may allocate hours to subcontractors by adding additional rows as needed. However, 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 shall 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 shall 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 shall 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 shall not adjust the Government provided ODC amounts.
| e. 1-5 Schedule of Subcontractors: Offerors shall fill-in and identify ALL 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 shall 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 Model IDIQ TO - Evaluation: The Offeror shall 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 | ||
| (3) SUBFACTOR 3: Management Approach | 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 | Extended | Evaluated Hours | Labor Rate | Extended | Evaluated Hours | Labor Rate | Extended | Evaluated Hours | Labor Rate | Extended | Evaluated Hours | Labor Rate | Extended | ||
| FFP | SME | 42,713 | $0.00 | $0.00 | 53,550 | $0.00 | $0.00 | 63,002 | $0.00 | $0.00 | 56,525 | $0.00 | $0.00 | 29,436 | $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 | $0.00 | Less Holiday | |||||||||
| Task Manager | $0.00 | Less Vacation | |||||||||
| Editor/Technical Writer | $0.00 | Less other leave | |||||||||
| Data/Task Integrator | $0.00 | Hours/WYE | 2080 | ||||||||
| 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 | $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 | $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 | $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 | $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 of Subcontractors
| Insert Offeror's Name |
| Schedule of 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 Model IDIQ TO-Evaluation
| Model IDIQ TO 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 | $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 .