Attachment_1_-_Cost_Price_Forms_(Update).xlsx

XLSX spreadsheet 135 KB Posted

Attached to
Force Measurement Support Services (FMSS) Federal contract opportunity
Solicitation number
80LARC18R0002
Issued by
National Aeronautics and Space Administration Langley Research Center

About this file

Updated Attachment 1 - Cost Forms

View the file

Other files for this federal contract opportunity

Other files attached to Force Measurement Support Services (FMSS), newest first.
File Type Posted
Source_Selection_Statement.pdf PDF
Source_Selection_Statement_Final_signed.pdf PDF
RFP_80LARC18R0002___Amendment_03.pdf PDF
RFP_80LARC18R0002_Amendment_2.pdf PDF
RFP_80LARC18R0002_Amendment_1.pdf PDF
80LARC18R0002_Solicitation_PDF__Portfolio.pdf PDF
80LARC18R0002_Instructions_for_Adobe_PDF_Portfolio.pdf PDF
Pre-Solicitation_Conference_FMSS_Overview_-_12April2018_v1.pdf PDF
80LARC18R0002_Draft_SOW.pdf PDF

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

INSTRUCTIONS FOR COST FORMS 1 - 4

Please review each input for accuracy before proposal submission. All fields highlighted in yellow are self-calculating fields. Any changes made should contain calculations on all forms.

Submit all Cost Forms 1 - 4, along with supporting rates and factor data, under a single file name or folder. This allows data produced by formulas and referenced cells to "flow" through the applicable portions of all Cost Forms. Any information contained in hidden cells, columns or rows shall be disclosed and explained, along with instructions for displaying the information. Do not password protect any portion of your electronic cost proposal unless it is provided to the Government.

Form 1: Overall Proposal Summary:
The proposal summary total proposed price should match the total proposal cost listed in Section B of the RFP.
Insert the total burdened cost rate for each labor category without profit. Profit is to be separated for direct labor on the summary tab.
The subcontracting line on the price summary form pulls from Form 2 to include the total subcontracting price along with any applicable indirect rates and profit that apply.
Form 2: Subcontracting Price Summary
Data pulls from Form 2A which should be completed first before completion of Form 2.
Prime Offeror to enter any material/G&A cost, if applicable
Prime Offeror to enter profit on subcontracting cost, if applicable
Form 2A: Subcontractor Labor and Rates
This form should be completed first if a subcontractor is being proposed. Do not include any PRIME OFFEROR'S cost.
Please include all IDIQ fully burdened rates that may apply through a subcontractor onto the IDIQ Fully Budened Rates Form 4. Do not include any cost from the Prime Offeror into subcontracting rates.
Form 2B: Limitation of Subcontracting Form
This form is self calculating and pulls data from Form 1 Total Labor Cost and Form 2A Total Subcontracting Price.

Form 3: Status of Systems

Form 4: Maximum IDIQ Rates
Enter fully burdened labor rates to include all applicable indirect rates and profit for each labor category by period which should flow from Form 4A
Provide Indirect rates that may be applied to ODCs
Provide maximum profit/fee for both fixed priced and cost type task orders.
Form 4A: Fully Burdened Rates
Enter the breakdown of the fully burden labor rates for each period.
Additional Guidance/Information
Identify, explain, and reconcile any differences between Cost Form classifications and/or rates and those classifications and/or rates in your established accounting system. Fill in the Rate Charts (Form 4) with your fiscal year rates and the contract year rates. If the contract years are not consistent with your fiscal years, provide your fiscal year rates and show how the contract year rates were developed. This establishes an audit trail from the DCAA approved/recommended rates and factors to the Cost Forms. Be sure the contract year rate chart information is used, or is consistent with rates used, to complete the Cost Forms. Assume a 5 year period of performance commencing October 1, 2018.

Your electronic cost submissions shall be true self-calculating spreadsheets, i.e. including all rates, factors and formulas used to derive your costs. If possible, do not use absolute values; however, if absolute values are used they must be explained and their values supported.

Read carefully and follow the instructions provided on each Cost Form.

BEFORE YOU SUBMIT THIS COST PROPOSAL:

* Be sure you have complied with the instructions provided in the RFP and in this spreadsheet.
* Verify the cell contents are showing formulas rather than absolute values.
* Confirm all categories and elements have been addressed.
* Save all electronically submitted price information and Cost Forms under a single file or directory name.
* Indicate below that this instruction sheet has been read and submit with your cost proposal.

This instruction sheet has been read: _________________________________________________________________ (Type in your Name, Title, and the Date)

Form 1_CLINs 001 & 002

Form 1
Offeror Name:
Proposal Title and Date:
Proposal Number:

CLIN 001 (Firm Fixed Price) and/or CLIN 002 (Cost Plus Fixed Fee)

Year 1Year 2Year 3Year 4Year 5
Date RangeDate RangeDate RangeDate RangeDate Range
Hrs or BaseRateCostHrs or BaseRateCostHrs or BaseRateCostHrs or BaseRateCostHrs or BaseRateCostTotal HrsTotal Cost
Labor Categories
Mechanical & Electrical/Electronic Design Engineer500$0.00$0500$0.00$0500$0.00$0500$0.00$0500$0.00$02,500$0
Drafter/Designer (Mechanical & Electrical/Electronic)1,400$0.00$01,400$0.00$01,400$0.00$01,400$0.00$01,400$0.00$07,000$0
Strain Gage Instrumentation Technician5,200$0.00$05,200$0.00$05,200$0.00$05,200$0.00$05,200$0.00$026,000$0
Instrument Calibration Technician3,640$0.00$03,640$0.00$03,640$0.00$03,640$0.00$03,640$0.00$018,200$0
Fabrication Technician5,200$0.00$05,200$0.00$05,200$0.00$05,200$0.00$05,200$0.00$026,000$0
Quality Assurance Specialist500$0.00$0500$0.00$0500$0.00$0500$0.00$0500$0.00$02,500$0
Fully Burden Labor Cost16,440$016,440$016,440$016,440$016,440$082,200$0
Profit on Fully Burden Labor Cost0%$00%$00%$00%$00%$0$0
Total Fully Burden Labor Price$0$0$0$0$0$0
Other Direct Costs (ODC's)$246,920$246,920$246,920$246,920$246,920$1,234,600
Material Handling/G&A (if applicable, from Form 4)0%$00%$00%$00%$00%$0$0
Other Direct Costs (ODCs) propose$0$0$0$0$0$0
Total Subcontract Price (From Form 2)$0$0$0$0$0$0

Total CLIN 001/002 $246,920 $246,920 $246,920 $246,920 $246,920 $1,234,600

1. Provide Offeror's fully burdened labor rates EXCLUDING profit for each labor category. Profit should be separated on Form 1.
2. Escalate rates as appropriate for option periods.Show escalation calculations on Form 4 IDIQ Schedule of Rates
3. Definitions for the pre-determined Labor Categories can be found as RFP Attachment 2.
4. Profit objective for evaluation purposes shall be based on the a firm fixed price task order.

Form 2-SubPriceSummary

Form 2 - Subcontractor Price Summary
Offeror Name:
Proposal Title and Date:
Proposal Number:
Subcontractor Price Summary
Subcontractors Providing Direct LaborYear 1Year 2Year 3Year 4Year 5Total Subcontract
Enter Subcontractor name in this cell$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Enter Subcontractor name in this cell$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Enter Subcontractor name in this cell$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Enter Subcontractor name in this cell$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Subcontract Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Indirect Costs(G&A, Material Handling)$ - 0
Profit$ - 0
Subcontract Price$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
NOTES:
1. Automatically pulls Subcontractor data from form 2A. Enter data on Form 2A first.
2. Provide Prime Offeror Indirect Costs and Offeror Profit for each SubClin/performance period.

Form 2A- SubLabor Rates & Hours Form 2A - Subcontractors / Consultants for CLIN 001/002

Offeror Name:
Proposal Title and Date:
Proposal Number:

Labor Categories: Year 1 Year 2 Year 3 Year 4 Year 5 Total Contract

Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Total Hrs Total Dollars

Sub / Consultant's name(1):$0$0$0$0$00$0
Enter Subcontractor name in this cellInsert Labor Category0$0.00$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Total Burdened Labor:0$0.000$0.000$0.000$0.000$0.000$0
Subcontractor ODCs$0
Total Price:$0$0$0$0$00$0

Labor Categories: Year 1 Year 2 Year 3 Year 4 Year 5 Total Contract

Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Total Hrs Total Dollars

Sub / Consultant's name(2):$0$0$0$0$00$0
Enter Subcontractor name in this cellInsert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Total Burdened Labor:0$0.000$0.000$0.000$0.000$0.000$0
Subcontractor ODCs$0
Total Price:$0$0$0$0$00$0

Labor Categories: Year 1 Year 2 Year 3 Year 4 Year 5 Total Contract

Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Total Hrs Total Dollars

Sub / Consultant's name(3):$0$0$0$0$00$0
Enter Subcontractor name in this cellInsert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Total Burdened Labor:0$0.000$0.000$0.000$0.000$0.000$0
Subcontractor ODCs$0
Total Price:$0$0$0$0$00$0

Labor Categories: Year 1 Year 2 Year 3 Year 4 Year 5 Total Contract

Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Hours Fully Burden Rate (with profit) Total Cost Total Hrs Total Dollars

Sub / Consultant's name(4):$0$0$0$0$00$0
Enter Subcontractor name in this cellInsert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Insert Labor Category$0$0$0$0$00$0
Total Burdened Labor:0$0.000$0.000$0.000$0.000$0.000$0
Subcontractor ODCs$0
Total Price:$0$0$0$0$00$0
Total Subcontract Labor Cost$0.00$0.00$0.00$0.00$0.00$0.00
Total Subcontract ODCs$0.00$0.00$0.00$0.00$0.00$0.00
Total Subcontract Price$0$0$0$0$0$0
INSTRUCTIONS:
(1) The dollar values listed in this form shall not include any of the prime offeror's indirect or profit burdens on subcontract / consultant costs. The dollar values listed in this form are only for subcontractors' / consultants' total Price.
(2) Identify the subcontractor / consultant name.
(3) Provide the total proposed labor hours for each category and period. Subtract any proposed hours being performed by a sum from the proposed prime hours on Form 1.
(4) The proposed rates shall be burdened thru all applicable indirect costs including profit/fee for the subcontractors only.
(5) Provide total ODC Costs by SubClin including subcontractor indirect costs and profit. Provide details on the proposed ODC cost within the cost volume.

Form 2B-Lim.onSub.

Form 2B - Limitation on Subcontracting
Offeror Name:
Proposal Title and Date:
Proposal Number:
Limitations on Subcontracting
Year 1Year 2Year 3Year 4Year 5Total Contract
Total% of Total Labor CostsTotal% of Total Labor CostsTotal% of Total Labor CostsTotal% of Total Labor CostsTotal% of Total Labor CostsTotal% of Total Labor Costs

Total Subcontractor Labor Costs $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0!

Prime Fully Burdened Labor Costs (Less Profit) $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! if less than 50%, noncompliant

Total Labor Costs $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0! $ - 0 ERROR:#DIV/0!

1. Please show that the Limitations on Subcontracting per FAR 52.219-14 have been met.
2. Subcontractor Costs flow from Form 2A.
3. Prime Fully Burdened Labor Costs flow from Form 1.

Form 3_Status of Systems Form 3: Status of System Reviews

Offeror Name:
Proposal Title and Date:
Proposal Number:
Approval Status
DescriptionStatusDate ApprovedYesNoPendingN/AOutstanding Issues
Systems Reviews1
Accounting System
Estimating System
Purchasing System
Billing System
Compensation System
Budgeting System
Other Systems

Forward Pricing Rate Agreement (FPRA) 2

Note:

(1) Provide a statement verifying that you have an approved accounting system including the approval date and name of the reviewing office. Provide a copy of the
approval letter in your proposal. Show the approval status for all other systems and explain any outstanding issues.
(2) Indicate whether your labor and indirect rates are based on a Forward Pricing Rate Agreement, what period the FPRA covers, and the approval date.
Provide a copy of the FPRA in your proposal.
(3) If the Offeror’s accounting system has never been audited / reviewed by the cognizant GAA, the Offeror shall provide a detailed description of its accounting system and complete Standard Form 1408, Pre-award Survey of Prospective Contractor Accounting System (see Attachment 5).

Form 4-IDIQRates

Form 4 - IDIQ Maximum Fully Burdened Rates:
Offeror Name:
Proposal Title and Date:
Proposal Number:
IDIQ Fully Burdened Rates-Contractor Fiscal YearIDIQ Fully Burdened Rates- Contract Year
The chart below contains the labor categories and the fully burdened fixed hourly rates that are to be used for establishing Firm Fixed Price and Purchase Card orders. The rates below are to reflect the maximum rate to be priced on all Firm Fixed Price task orders for each labor category. For all Cost-Plus-Fixed Fee task orders, the rates below can be used for negotiating purposes.The chart below contains the labor categories and the fully burdened fixed hourly rates that are to be used for establishing Firm Fixed Price and Purchase Card orders. The rates below are to reflect the maximum rate to be priced on all Firm Fixed Price task orders for each labor category. For all Cost-Plus-Fixed Fee task orders, the rates below can be used for negotiating purposes.
Note: “Fully Burdened” includes all applicable direct and indirect costs such as leave, fringes, management, administration, purchasing, facility expense, and profit/fee.Note: “Fully Burdened” includes all applicable direct and indirect costs such as leave, fringes, management, administration, purchasing, facility expense, and profit/fee.
Labor CategoryWage Determination or ExemptPrice Per Hour Year 1Price Per Hour Year 2Price Per Hour Year 3Price Per Hour Year 4Price Per Hour Year 5Labor CategoryPrice Per Hour Year 1Price Per Hour Year 2Price Per Hour Year 3Price Per Hour Year 4Price Per Hour Year 5
Mechanical & Electrical/Electronic Design EngineerMechanical & Electrical/Electronic Design Engineer
Drafter/Designer (Mechanical & Electrical/Electronic)Drafter/Designer (Mechanical & Electrical/Electronic)
Strain Gage Instrumentation TechnicianStrain Gage Instrumentation Technician
Instrument Calibration TechnicianInstrument Calibration Technician
Fabrication TechnicianFabrication Technician
Quality Assurance SpecialistQuality Assurance Specialist
Material Handling Charge/G&A for Supplies, Materials, and EquipmentMaterial Handling Charge/G&A for Supplies, Materials, and Equipment
Material Handling Charge/Rate/G&A, if applicable. No other cost burden (direct or indirect). Fee or Profit will not be allowed.0.00%0.00%0.00%0.00%0.00%Material Handling Charge/Rate/G&A, if applicable. No other cost burden (direct or indirect). Fee or Profit will not be allowed.0.00%0.00%0.00%0.00%0.00%
Profit Objectives
Profit on Firm-Fixed-Price Task Orders (Profit objective used for Total Evaluated Price)0.00%0.00%0.00%0.00%0.00%
Fee on Cost Type Task Orders (Maximum Fee on Cost-Type task orders)0.00%0.00%0.00%0.00%0.00%
1. Provide Offeror's Maximum fully burdened labor rates including profit for each labor category.
2. Escalate rates as appropriate for option periods.Show escalations calculations.
3. If rates cross the contractor fiscal year, explain derivation.
4. Definitions for the pre-determined Labor Categories can be found as RFP Attachment 4.
5. Explain any differences between your accounting system and the categories listed above.
6. Please show all calculations of the of fully burden rates within your Business Volume along with an explanation for any discrepencies located on your Schedule of Rates.

7. Profit objective for the evaluation purposes should be based on the profit of a firm fixed price task order.

Form 4A- Fully Burden Rates

Form 4A - IDIQ Maximum Fully Burdened Rates:
Offeror Name:
Proposal Title and Date:
Proposal Number:
The chart below is intended as a sample only and in no way should
be considered complete or restrictive in the way any offeror
establishes the burdened labor rates to support their proposal.
Total
Labor Rate CategoryBase LaborFringeOtherBurdened
RateBenefitsOverheadIndirect RateG&AProfitLabor Rate
%%%%%
Contract Year 1
Mechanical & Electrical/Electronic Design Engineer
Drafter/Designer (Mechanical & Electrical/Electronic)
Strain Gage Instrumentation Technician
Instrument Calibration Technician
Fabrication Technician
Quality Assurance Specialist
%%%%%
Contract Year 2
Mechanical & Electrical/Electronic Design Engineer
Drafter/Designer (Mechanical & Electrical/Electronic)
Strain Gage Instrumentation Technician
Instrument Calibration Technician
Fabrication Technician
Quality Assurance Specialist
%%%%%
Contract Year 3
Mechanical & Electrical/Electronic Design Engineer
Drafter/Designer (Mechanical & Electrical/Electronic)
Strain Gage Instrumentation Technician
Instrument Calibration Technician
Fabrication Technician
Quality Assurance Specialist
%%%%%
Contract Year 4
Mechanical & Electrical/Electronic Design Engineer
Drafter/Designer (Mechanical & Electrical/Electronic)
Strain Gage Instrumentation Technician
Instrument Calibration Technician
Fabrication Technician
Quality Assurance Specialist
%%%%%
Contract Year 5
Mechanical & Electrical/Electronic Design Engineer
Drafter/Designer (Mechanical & Electrical/Electronic)
Strain Gage Instrumentation Technician
Instrument Calibration Technician
Fabrication Technician
Quality Assurance Specialist
INSTRUCTIONS
(1) Show the build-up of the fully burdened rate (excluding profit/fee) for each labor category for each CY.
(2) Explain how each element of the burdened rate is determined.
(3) The elements shown above are not all inclusive and more columns may be added. Only include applicable elements.
(4) The Fully Burdened Labor Rates must flow to Form 4 :IDIQ Rates

File details come from the government source that posted it.