80KSC019R0019 L-03b Basic Cost Template.xlsx

XLSX spreadsheet 15 MB Posted Nov 22, 2019

Attached to: NASA Environmental and Medical Contract (NEMCON)
Solicitation number: 80KSC019R0019
Issued by: National Aeronautics and Space Administration Kennedy Space Center

About this file

Written by GovTribe AI · Dec 30, 2023

This solicitation requests proposals for the NASA Environmental and Medical Contract (NEMCON) to provide a range of environmental, medical, and occupational health services to the National Aeronautics and Space Administration Kennedy Space Center, NASA Headquarters, other NASA centers, and the 45th Air Force Space Wing. Requirements include conducting environmental compliance activities; industrial hygiene and health physics services; aerospace medicine expertise; onsite medical clinics and clinical laboratory services; and occupational health services. This is a total small business set-aside solicitation with a North American Industry Classification System code of 541620 (Environmental Consulting Services) and size standard of $16.5 million. The proposal submission and award process involves registration on beta.SAM.gov and coordination with the U.S./Canada Joint Certification Office for documentation related to export controls.

View the file

Other files

File	Type	Posted
80KSC019R0019 Amendment 04.pdf	PDF	Jan 13, 2020
80KSC019R0019 Amendment 03.pdf	PDF	Jan 10, 2020
RFP Questions and Answers 1-10-2020.pdf	PDF	Jan 10, 2020
80KSC019R0019 Amendment 02.pdf	PDF	Jan 6, 2020
80KSC019R0019 Questions and Answers.pdf	PDF	Dec 17, 2019
80KSC019R0019 Amendment 01.pdf	PDF	Dec 17, 2019
80KSC019R0019-Question Card.xlsx	XLSX spreadsheet	Nov 25, 2019
80KSC019R0019-Comment Card.xlsx	XLSX spreadsheet	Nov 25, 2019
80KSC019R0019 Attachment L-04 IT Assets Maximum Available.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-02 DRL-DRD.pdf	PDF	Nov 22, 2019
Draft RFP Questions and Answers.pdf	PDF	Nov 22, 2019
80KSC019R0019 L-03a Phase-In Template.xlsx	XLSX spreadsheet	Nov 22, 2019
80KSC019R0019 Attachment L-01 NEMCON Past Perf Questionnaire.docx	DOCX document	Nov 22, 2019
80KSC019R0019 Attachment J-04 IAGFP.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-03 Glossary, Acronyms, and Abbreviations.pdf	PDF	Nov 22, 2019
80KSC019R0019 L-03c Rates and Factors Template.xlsx	XLSX spreadsheet	Nov 22, 2019
80KSC019R0019 Attachment J-07 Compliance Documents List.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment L-02 Government Standard Labor Categories and Qualifications.pdf	PDF	Nov 22, 2019
80KSC019R0019 Request for Proposal.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-16 Asbestos Support Matrix.pdf	PDF	Nov 22, 2019
80KSC019R0019 L-03d Subcontractor - Proposed Base Hourly Labor Rate Details.xlsx	XLSX spreadsheet	Nov 22, 2019
80KSC019R0019 Attachment J-06 Government Furnished Facilites.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-13 Performance Standards.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-12 Register of Wage Determination and Fringe Benefits.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-14 Instructions for Contractor Third-Party Work.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-09 IDIQ Labor Rates.xlsx	XLSX spreadsheet	Nov 22, 2019
80KSC019R0019 Attachment J-15 Government Furnished Legacy IT Systems.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-08 Labor Classification and Qualification Crosswalk.xlsx	XLSX spreadsheet	Nov 22, 2019
80KSC019R0019 Attachment J-01 Performance Work Statement.pdf	PDF	Nov 22, 2019
Significant Changes Log.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-05 Government Furnished Services.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-11 DD Form 254 Classified Work.pdf	PDF	Nov 22, 2019
80KSC019R0019 Attachment J-10 Award Fee Evaluation Plan.pdf	PDF	Nov 22, 2019
80KSC019R0019 RFP Cover Letter.pdf	PDF	Nov 22, 2019

Show all 34

On GovTribe

Work with this file

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.

blank

Cover

ATTACHMENT L-03b

BASIC COST TEMPLATE

FOR

NASA ENVIRONMENTAL

AND

MEDICAL CONTRACT

(NEMCON)

&"Arial,Regular"&10NEMCON &"Arial,Regular"&10ATTACHMENT L-03b &"Arial,Regular"&10 80KSC019R0019

&F &A SEB Sensitive - See FAR 2.101 and 3.104 Printed On: &D

Table of Contents Table of Contents - ALL WORKSHEETS Green Worksheets require data fill, as applicable

	NEMCON DRAFT RFP BASIC COST TEMPLATE (BCT)
1	Instructions		51	1	99	IDIQ Burdened Labor
2	Changes		52	1.1	100	Labor Cost by PWS
3	Productive Hours		53	1.2	101	Non-Labor Cost by PWS
4	Labor Classification		54	1.3	102	WYE by PWS
5	Rates Summary		55	1.4	103	Cost by PWS
6	OH-G&A-Fee Application		56	1.5	104	Dir Lab ST Rate Summary
7	Direct Labor Rate FY 21		57	1.6	105	Dir Lab Eff ST Rate Summary
8	Direct Labor Rate FY 22		58	1.7	106	Dir Lab OT Rate Summary
9	Direct Labor Rate FY 23		59	1.8	107	Labor Cost with fee by PWS
10	Direct Labor Rate FY 24		60	2	108	Labor Fringe by PWS
11	Direct Labor Rate FY 25		61	2.1	109	Overhead by PWS
12	Direct Labor Rate FY 26		62	2.2	110	G&A by PWS
13	Direct Labor Rate FY 27		63	2.3	111	Labor Cost Other by PWS
14	Direct Labor Rate FY 28		64	2.4	112	Total Labor Hours by Gov LC
15	Direct Labor Rate FY 29		65	2.5	113	Total WYE by Gov LC
16	Direct Labor Rate FY 30		66	2.6	114	PWS Structure
17	Supplies Materials & Equipment		67	2.7
18	Calibration & Maintenance		68	2.8
19	Travel		69	2.9
20	Training		70	3
21	HW Disposal & Spill Clean-Up		71	3.1
22	Rolling Stock		72	3.2
23	ODC		73	3.3
24	Summary Non-Proposed Costs		74	3.4
25	Additional Form A		75	3.5
26	Additional Form B		76	3.6
27	Additional Form C		77	3.7
28	Additional Form D		78	4
29	Subcontractor Lists	Sub-1	79	4.1
30	Subcontractor 1	Sub-2	80	4.2
31	Subcontractor 2	Sub-3	81	4.3
32	Subcontractor 3	Sub-4	82	4.4
33	Subcontractor 4	Sub-5	83	4.5
34	Subcontractor 5	Sub-6	84	4.6
35	Subcontractor 6	Sub-7	85	4.7
36	Subcontractor 7	Sub-8	86	4.8
37	Subcontractor 8	Sub-9	87	5
38	Subcontractor 9	Sub-10	88	5.1
39	Subcontractor 10	Sub-11	89	5.2
40	Subcontractor 11	Sub-12	90	5.3
41	Subcontractor 12	Sub-13	91	6
42	Subcontractor 13	Sub-14	92	6.1
43	Subcontractor 14	Sub-15	93	6.2
44	Subcontractor 15	Sub-16	94	6.3
45	Subcontractor 16	Sub-17	95	6.4
46	Subcontractor 17	Sub-18	96	6.5
47	Subcontractor 18	Sub-19	97	6.6
48	Subcontractor 19	Sub-20	98	Total
49	Subcontractor 20
50	Subcontractor Summary

ERROR:#REF!

&"Arial,Regular"&10NEMCON &"Arial,Regular"&10ATTACHMENT L-03b &"Arial,Regular"&10 80KSC019R0019

&A SEB Sensitive - See FAR 2.101 and 3.104 Printed On: &D

Instructions

	FORMS INSTRUCTIONS (these worksheet by worksheet instructions should be part of the cost model and no longer in the RFP, however, Offerors are advised to review RFP L.23 C Volume III of the Draft RFP for pricing information supplemental to this pricing model.
	Attachment L-03b, Basic Cost Template (BCT)
1	All Cells with green require input as applicable.
2	"Changes" Tab: Any changes made to any other than the input cells, shall be documented with sufficient detail. In addition, annotate if the Offeror identifies any Government errors or inconsistencies in any other than the input cells.
3	"Table of Contents" Tab: contains hyperlinks to cost forms to facilitate navigation between cost worksheets.
4	"Productive Hours" Tab: Identify whether the position is exempt, non-represented/non-exempt (CBA) or union (specify each union). Specify the number of productive hours per Work Year Equivalent (WYE) for each year of anticipated contract performance. Productive hour calculations should show the total number of available hours by whole-year, the total hours estimated for holidays, vacation time, sick hours, and other. WYE calculations are based on total annual available hours and should not be adjusted to reflect partial years. Specify in the notes section provided on how the figure was calculated (e.g. 2080 available hours per year – 100 hours vacation – 40 hours sick – 80 hours holiday = 1860 Productive Hours). Proposed uncompensated overtime would affect the calculations, since uncompensated time redefines the traditional 8 hour day and 40 hour week generally used for calculation of total available, productive and non-productive time.
5	"Labor Classification" Tab: The Offeror shall use this template to identify labor classifications, exempt or non-exempt status and the overtime premium multiplicative factor. Include escalation by each labor classification proposed. RFP L.23 C Volume III - Cost has specific escalation proposal instructions. Offeror must propose labor classifications used in their normal day to day activities, and NOT the Government Labor Categories. Column C has a pull down menu to select Labor Status. Column D has a pull down menu to select an equivalent Government Labor Category (for informational usage only).
6	"Rate Summary" Tab (applicable to Non Labor): The Offeror shall identify fee for labor and Other Cost Elements (OCE), G&A for OCE, and Overhead for OCE for the basic/option periods GFY 21 through GFY 30. In addition, there is a requirement to

convert the proposed rates from Offeror FY to GFY.

"OH-G&A-Fee Application (applicable to Non Labor)" Tab: The Offeror shall identify the elements of cost which have Other Cost Elements (OCE) overhead, OCE G&A, and labor and OCE fee applied.

"Direct Labor Rate – GFY 21 through GFY 30" Tabs: This set of worksheets allow labor rates (straight-time and over-time), by classification, built from direct pay rate to fully burdened, through G&A. These worksheets allow for multiple fringe benefit, overhead and G&A rates. The rate application base formulas can be changed to accommodate various accounting practices. The Offeror shall fully explain base formulas used and ensure consistency with the Rates and Factors cost template. Note: Outyear Escalation of base rates is performed via escalation % provided by Offeror in the Labor Classification tab".

The application indirects and fee may be changed by the offeror to calculate labor burden dollars according to Offeror's accounting practice. Further, a straight-time and over-time additional adjustment cells are available for Offeror's to proposed an effective fully burdened labor rates for GFY 21 through GFY 30.

24	Major Subcontractors shall remove all Gov't provided non proposed values prior to submittal of their proposal to the Prime
9	"Supplies Materials & Equipment" Tab: Offeror (Prime Only) shall include the non-proposed costs in accordance with clause B.8, non-proposed cost. These values have been pre-populated on this form.
10	"Calibration & Maintenance" Tab: Offeror (Prime Only) shall include the Standardized Values in accordance with clause B.8, Non-proposed costs. These values have been pre-populated on this form.
11	"Travel" Tab: Offeror (Prime Only) shall include the Standardized Values in accordance with clause B.8, Non-proposed costs. These values have been pre-populated on this form.
12	"Training" Tab: Offeror (Prime Only) shall include the non-proposed costs in accordance with clause B.8, non-proposed cost. These values have been pre-populated on this form.
13	"Hazardous Waste & Labs" Tab: Offeror (Prime Only) shall include the non-proposed costs in accordance with clause B.8, non-proposed cost. These values have been pre-populated on this form.
14	"Rolling Stock" Tab: Offeror (Prime Only) shall include the non-proposed costs in accordance with clause B.8, non-proposed cost. These values have been pre-populated on this form.
15	"ODC" (if applicable) Tab: Offeror shall propose ODCs in accordance with clause B.8, Non-proposed costs.
17	"Additional Forms - A through D" Tabs: These worksheets are provided for the Offeror use to add additional non-labor information and items that do not fit in the categories provided in other cost forms.
18	"Subcontractor List" Tabs: The Offeror shall identify the subcontractor name, type of contract, size of contract (major or minor) and small business classification, as applicable. Contract Type and Small Business Class tables are located on the bottom of this worksheet for offertory to add any additional contract type or grouping of small business classes to meeting their requirements. Once the table is updated, all data in the tables will be available for the offeror to select when using the drop-down menus above.
19	"Subcontractor 1 - 20 Worksheets" Tabs: Offeror shall provide information for each subcontractor. Offeror (or major subcontractor) will fill in Subcontractor: PWS, Labor Category (occupational title), Non-Labor Description, Productive Straight-Time and Productive Over-Time Hours per WYE for each GFY, Straight Time and Overtime Burdened Hourly Costs per WYE for each GFY for work anticipated. Non-Labor cost per unit and quantity being proposed will be proposed using these forms. Non-labor costs shall not include fee, in accordance with clause B.8 . Each subcontractor (major and minor) must be in a separate worksheet. Offeror shall conduct appropriate cost or price analysis to establish the reasonableness of the proposed subcontract prices and include the results of these analyses (submit the results) in the proposal (FAR 15.404-3(b)). Address the basis for selection and degree of competition for competed subcontracts included in this proposal. The Offeror shall ensure a rollup is provided for total subcontractor cost.
20	"Subcontractor Summary" Tab: This form is populated from other forms and requires no input from the Offeror.
21	"Cost Sheets by PWS 1.0 through 6.6 at 2nd level" Tabs: PWS 1.0 through 6.6 worksheets automatically populate with following labor information: WYE, straight time dollars (ST$), Overtime dollars (OT$), Fringe dollars (Fringe $), Overhead dollars (OH$), and G&A dollars (G&A$). Offerors with additional Other Cost Element (OCE) indirect rates shall complete the appropriate “Cost/Adj block” in the green input boxes provided in PWS 1.0 through 6.6. The Offeror shall ensure sufficient supporting documentation to allow evaluation of the Offeror's proposed methodology to include sample calculations. The Offeror is cautioned when inputting data into these cost worksheets, to verify the calculations are appropriately capturing the offertory's proposed cost. Forms display the costs associated with each PWS.

Note: Non-Proposed Costs have been pre-populated on worksheets: 1.0, 2.0, 3.0, 4.0, 5.0, & 6.0.

22	"Total" Tab: This is populated from other forms and requires no input from the Offeror. This worksheet includes total proposed contract value for PWS' 1.0 through 6.0.
23	"IDIQ Burdened Labor" Tab: The Offeror shall populate labor classifications, prime and subcontractor listed separately, mapped to Government labor classifications (selected from pull-down list) and hourly rates, for GFY 21 through GFY 30, fully burdened through prime G&A, for future IDIQ requirements in the PWS. The fully burdened labor rate shall be inclusive of fee. IDIQ labor classifications and associated burdened labor rates similar to the ones proposed in the BCT for basic work, shall be consistent with one another. Proposed Fixed-Fee shall be populated separately and evaluated for cost realism and reasonableness. This worksheet will become part of the final contract, for estimating task orders, as Attachment J-09, IDIQ Labor Rates.
25	"Labor Cost by PWS" Tab: This is populated from other forms and requires no input from the Offeror.
26	"Non-labor Cost by PWS" Tab. This is populated from other forms and requires no input from the Offeror.
27	"WYE by PWS" Tab: This is populated from other forms and requires no input from the Offeror.
28	"Cost by PWS" Tab: This is populated from other forms and requires no input from the Offeror.
30	"Dir Lab Straight Time Rate Summary" Tab: This form is populated from other forms and requires no input from the Offeror.
31	"Dir Lab Effective Rate Summary" Tab: This form is populated from other forms and requires no input from the Offeror.
32	"Dir Lab Overtime Rate Summary" Tab: This form is populated from other forms and requires no input from the Offeror.
33	"Labor Cost with fee by PWS" Tab: This is populated from other forms and requires no input from the Offeror.
34	"Labor Fringe by PWS" Tab: This is populated from other forms and requires no input from the Offeror.
35	"Overhead by PWS" Tab: This is populated from other forms and requires no input from the Offeror.
36	"G&A by PWS" Tab: This is populated from other forms and requires no input from the Offeror.
37	"Labor Cost Other by PWS" Tab: This is populated from other forms and requires no input from the Offeror.
38	"Total Labor hours by Gov LC" Tab: This is populated from other forms and requires no input from the Offeror.
39	"Total WYE by Gov LC" Tab: This is populated from other forms and requires no input from the Offeror.
41	"PWS Structure" Tab: Pre-Populated, no input from the Offeror.

&"Arial,Regular"&10NEMCON &"Arial,Regular"&10ATTACHMENT L-03b &"Arial,Regular"&10 80KSC019R0019

&A SEB Sensitive - See FAR 2.101 and 3.104 Printed On: &D

ToC /xl/drawings/drawing1.xml#'Table%20of%20Contents'!A1 Changes

Changes

NOTE: This table applies to any changes made to any other than the input cells.

Tab Name Cell # Description of Change Purpose/Basis

&"Arial,Regular"&10NEMCON &"Arial,Regular"&10ATTACHMENT L-03b &"Arial,Regular"&10 80KSC019R0019

&A SEB Sensitive - See FAR 2.101 and 3.104 Printed On: &D

ToC /xl/drawings/drawing2.xml#'Table%20of%20Contents'!A1 Productive Hours Productive Hours

		GFY 21	GFY 22	GFY 23	GFY 24	GFY 25	GFY 26	GFY 27	GFY 28	GFY 29	GFY 30
Exempt Employees	Exempt

Non-Exempt Employees	Non-Represented/Non-Exempt (SCA)
	Union/CBA … Please Identify below, as applicable:

Exempt Employee Categories 1 through 4 are available for use when different productive hours factors are used (example: same labor classifications, but different locations)

Exempt Employees Only:

Notes/Calculation for GFY 1: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for GFY 2: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for GFY 3: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for GFY 4: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for GFY 5: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for GFY 6: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for GFY 7: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for GFY 8: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for GFY 9: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for GFY 10: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for CY 6: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for CY 7: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for CY 8: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for CY 9: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Notes/Calculation for CY 10: Total Available Hours of: xxxx minus xx Holiday Hours minus xx Vacation Hours minus xx Sick Hours minus x for Other Hours. This equates to xxxx Total Productive Hours.

Non-exempt Employees Only (Non-Represented/Non-Exempt(SCA) & Union/CBA):