Att L-1 EPM.xlsx

XLSX spreadsheet 57 KB Posted

Attached to
Mars Ascent Vehicle Integrated System (MAVIS) Federal contract opportunity
Solicitation number
80MSFC21R0001
Issued by
National Aeronautics and Space Administration Marshall Space Flight Center

About this file

Written by GovTribe AI ·

This Excel workbook template provides guidance and a standardized format for offerors to submit cost and pricing data in response to solicitation number 80MSFC21R0001 from NASA Marshall Space Flight Center for the Mars Ascent Vehicle Integrated System acquisition. The template includes six tabs for summarizing total proposed costs by contract year, calculating labor costs by performance work statement element, inputting materials and other direct costs, specifying travel costs, and providing supporting documentation for fringe rates, overhead rates, and general and administrative costs. Offerors must manually enter labor rates and hours, materials quantities and pricing, travel details, and other cost elements to fully populate the template for cost proposal submission.

View the file

Other files for this federal contract opportunity

Other files attached to Mars Ascent Vehicle Integrated System (MAVIS), newest first.
File Type Posted
80MSFC21R0001-P00001 MAVIS Amendment 01 Documents.zip ZIP file
MAVIS Pre-Proposal Conference Slides_19 AUG 2021.pdf PDF
J-4A Applicable Documents.zip ZIP file
MAVIS RFP 80MSFC21R0001.pdf PDF
J-4B Reference Document - Appendix 10.5 Master Test List.pdf PDF
Signed RFP Letter_MAVIS.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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Index

Company XYZ, Inc.INDEX
(A) Tab A: Summary of Total CostThis tab is designed to summarize the Offeror's total proposed cost and fee by contract year. These cells are linked to the supporting tabs within the workbook. The Offeror is responsible for inputting their burdens that will be applied to the proposed materials, travel, and Other Direct Cost. Offerors are also responsible for accounting for all subcontractors regardless of size. Areas in yellow require manual input.

(B) Tab B: Labor Calculations by PWS The tab shall reflect exempt and non-exempt labor categories applied to labor hours in accordance with the Offeror’s approach. The Offeror shall manually input data in this tab.

(C) Tab C: Materials and Other Direct Costs This tab provides input for Materials and Other Direct Cost. The Offeror shall fill in data by PWS element to the first level (i.e., Column A), with the appropriate quantities and dollars.

(D) Tab D: Travel This tab provides the necessary input to compute travel cost. The Offeror shall fill in data by PWS element with the proposed number of WYEs, number of trips, air fare, and per diem.

(E) Tab E: Supporting Documentation This tab provides the supporting documentation used to compute Tabs A and B. The tab includes the computation for fringe benefits, overhead, subcontract handling, material handling, G&A, and FCCOM (if applicable). In addition, the tab includes verification of the productive and escalation factors used in the computation of the proposed cost.

Tab A

Company XYZ, Inc.Summary of Total Cost
Contract Yr 1Contract Yr 2Contract Yr 3Contract Yr 4Contract Yr 5Contract Yr 6Totals
Direct Labor from Tab B$0$0$0$0$0$0$0
Fringe Rate0.0%0.0%0.0%0.0%0.0%0.0%
Fringe Rate Dollars$0$0$0$0$0$0$0
Overhead Rate0.0%0.0%0.0%0.0%0.0%0.0%
Overhead Rate Dollars$0
G&A Rate0.0%0.0%0.0%0.0%0.0%0.0%
G&A Dollars$0$0$0$0$0$0$0
Total Labor Dollars$0$0$0$0$0$0$0
Materials$0
Travel$0
Other Direct Costs (ODC)$0
Subtotal Material, Travel and ODC$0$0$0$0$0$0$0
Subcontractor A$0
Subcontractor B$0
Subcontractor C$0
$0
Total Subcontracts$0$0$0$0$0$0$0
Subcontract Handling Rate (if applicable)0.0%0.0%0.0%0.0%0.0%0.0%
Subcontract Handling$0
Material Handling Rate (if applicable)0.0%0.0%0.0%0.0%0.0%0.0%
Material Handling (if applicable)$0
G&A$0
Subtotal$0$0$0$0$0$0$0
Fee *$0
FCCOM (if applicable)$0
Total$0
Areas in Yellow Require Manual Input
* See FAR 15.404-4(b)(4)(i)(A)

Tab B Company XYZ, Inc. Labor Calculations by PWS Tab B

Contract Year 1
PWS 3.0PWS 4.0PWS 5.0PWS 6.0PWS 7.0Total
LABOR BREAKDOWNRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsHoursDollars
Labor category$10.0010.0$100.00$10.301.0$10.30$10.615.0$53.05$10.9310.0$109.27$11.2610.0$112.5536.0$385
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
$0
Contract Year 2
PWS 3.0PWS 4.0PWS 5.0PWS 6.0PWS 7.0Total
LABOR BREAKDOWNRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsHoursDollars
Labor category$10.0010.0$100.00$10.301.0$10.30$10.615.0$53.05$10.9310.0$109.27$11.2610.0$112.5536.0$385
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
$0
Contract Year 3
PWS 3.0PWS 4.0PWS 5.0PWS 6.0PWS 7.0Total
LABOR BREAKDOWNRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsHoursDollars
Labor category$10.0010.0$100.00$10.301.0$10.30$10.615.0$53.05$10.9310.0$109.27$11.2610.0$112.5536.0$385
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
$0
Contract Year 4
PWS 3.0PWS 4.0PWS 5.0PWS 6.0PWS 7.0Total
LABOR BREAKDOWNRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsHoursDollars
Labor category$10.0010.0$100.00$10.301.0$10.30$10.615.0$53.05$10.9310.0$109.27$11.2610.0$112.5536.0$385
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
$0
Contract Year 5
PWS 3.0PWS 4.0PWS 5.0PWS 6.0PWS 7.0Total
LABOR BREAKDOWNRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsHoursDollars
Labor category$10.0010.0$100.00$10.301.0$10.30$10.615.0$53.05$10.9310.0$109.27$11.2610.0$112.5536.0$385
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
$0
Contract Year 6
PWS 3.0PWS 4.0PWS 5.0PWS 6.0PWS 7.0Total
LABOR BREAKDOWNRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsRateHoursDollarsHoursDollars
Labor category$10.0010.0$100.00$10.301.0$10.30$10.615.0$53.05$10.9310.0$109.27$11.2610.0$112.5536.0$385
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
Labor category-0$0
$0

Tab C

Company XYZ, Inc.Tab C
Materials and Other Direct Costs
Items are listed only as examples
Year 1Year 2Year 3Year 4Year 5Year 6
PWSMaterials (List Items As Necessary)Unit PriceQuantityTotal PriceUnit PriceQuantityTotal PriceUnit PriceQuantityTotal PriceUnit PriceQuantityTotal PriceUnit PriceQuantityTotal PriceUnit PriceQuantityTotal PriceNotes
Avionics$0$0$0$0$0$0
Power/Batteries$0$0$0$0$0$0
Telecommunications (Antenna, Beacon)$0$0$0$0$0$0
Structures$0$0$0$0$0$0
Reaction Control Systems$0$0$0$0$0$0
Thermal Control System$0$0$0$0$0$0
Instrumentation (Develop, Test and Operations)$0$0$0$0$0$0
Ground Support Equipment (MGSE, EGSE)$0$0$0$0$0$0
Carts and Logistics Materials$0$0$0$0$0$0
Clean Room Supplies$0$0$0$0$0$0
Add lines as necessary$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
Total Materials Cost$0$0$0$0$0$0$0$0$0$0$0$0
Year 1Year 2Year 3Year 4Year 5Year 6
PWSOther Direct Costs (List Items As Necessary)Unit PriceQuantityTotal PriceUnit PriceQuantityTotal PriceUnit PriceQuantityTotal PriceUnit PriceQuantityTotal PriceUnit PriceQuantityTotal PriceUnit PriceQuantityTotal Price
Ground Shipping Costs (permits, etc)$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0
Air Shipping Cost (flight test)$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0
Calibration Lab Services$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0
Calibration Lab Services$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0
Add lines as necessary$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0
$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0
$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0
$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0$0.00- 0$0
Total Other Direct Costs$0$0$0$0$0$0$0$0$0$0$0$0

Areas in Yellow Require Manual Input

Tab D

Company XYZ, Inc.Tab D
Travel Cost
Items are listed only as examples
Year 1
PWSOriginDestination#Trips# WYE# DaysModeAir Fare/RentalHotel & Per DiemTotal CostTravel Purpose (List Items As Necessary)
4.0Houston, TXHuntsville, AL134Air / Rental Car$770.00$2,400.00$3,170.00Project Reviews
Add lines as necessary
Total Travel Cost$0.00
Areas in Yellow Require Manual Input
Year 2
PWSOriginDestination#Trips# WYE# DaysModeAir Fare/RentalHotel & Per DiemTotal CostTravel Purpose (List Items As Necessary)
Add lines as necessary
Total Travel Cost$0.00
Year 3
PWSOriginDestination#Trips# WYE# DaysModeAir Fare/RentalHotel & Per DiemTotal CostTravel Purpose (List Items As Necessary)
Add lines as necessary
Total Travel Cost$0.00
Year 4
PWSOriginDestination#Trips# WYE# DaysModeAir Fare/RentalHotel & Per DiemTotal CostTravel Purpose (List Items As Necessary)
Add lines as necessary
Total Travel Cost$0.00
Year 5
PWSOriginDestination#Trips# WYE# DaysModeAir Fare/RentalHotel & Per DiemTotal CostTravel Purpose (List Items As Necessary)
Add lines as necessary
Total Travel Cost$0.00
Year 6
PWSOriginDestination#Trips# WYE# DaysModeAir Fare/RentalHotel & Per DiemTotal CostTravel Purpose (List Items As Necessary)
Add lines as necessary

Total Travel Cost $0.00

Tab E

Company XYZ, Inc.Tab E
Supporting Documentation
ElementsContract Yr 1Contract Yr 2Contract Yr 3Contract Yr 4Contract Yr 5Contract Yr 6
Fringe Pool$0.00$0.00$0.00$0.00$0.00$0.00
Fringe Base$0.00$0.00$0.00$0.00$0.00$0.00
Fringe Rate0%0%0%0%0%0%
If Applicable:
Overhead Pool$0.00$0.00$0.00$0.00$0.00$0.00
Overhead Base$0.00$0.00$0.00$0.00$0.00$0.00
Overhead Rate0%0%0%0%0%0%
If Applicable:
Subcontract Handling Pool$0.00$0.00$0.00$0.00$0.00$0.00
Subcontract Handling Base$0.00$0.00$0.00$0.00$0.00$0.00
Subcontract Handling Rate0%0%0%0%0%0%
If Applicable:
Material Handling Pool$0.00$0.00$0.00$0.00$0.00$0.00
Material Handling Base$0.00$0.00$0.00$0.00$0.00$0.00
Material Handling Rate0%0%0%0%0%0%
G&A Pool$0.00$0.00$0.00$0.00$0.00$0.00
G&A Base$0.00$0.00$0.00$0.00$0.00$0.00
G&A Rate0%0%0%0%0%0%
Productive FactorContract Yr 1Contract Yr 2Contract Yr 3Contract Yr 4Contract Yr 5Contract Yr 6
Hours Available in Contract Year208820802088208820882096
Productive Hours
Labor Escalation
Material Escalation
ODC Escalation
Travel Escalation
If Applicable:
FCCOMContract Yr 1Contract Yr 2Contract Yr 3Contract Yr 4Contract Yr 5Contract Yr 6
FCCOM Rate on Labor
FCCOM Rate on Materials/Subcontracts
FCCOM Price-G&A basis
Additional Indirect rates can be added if they are utilized in the build-up of the total cost.

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