Attachment J-11 Cost Report Template 3.9.20.xlsx

XLSX spreadsheet 50 KB Posted Sep 22, 2020

Attached to: HQ0858-20-R-0014 - TEAMS-Next MDS Engineering Solicitation
Solicitation number: HQ0858-20-R-0014
Issued by: DOD Missile Defense Agency

About this file

Written by GovTribe AI · Dec 28, 2023

This document provides details for a cost-plus fixed-fee level of effort contract opportunity with the Missile Defense Agency to provide agency-wide Missile Defense System engineering services. The contract value is estimated at $56 million over a three-year base period and two two-year options plus an additional six-month option. The North American Industry Classification System code for this requirement is 541715. Offerors must register in the System for Award Management database and check the database regularly for any amendments. Proposals must be delivered no later than 4:00 pm on November 6, 2020 to the specified email addresses. The award will be made based on best value to the government for engineering support across the Missile Defense Agency directorates.

View the file

Other files

File	Type	Posted
HQ0858-20-R-0014 TN MDS Eng CONFORMED 10.21.20.pdf	PDF	Oct 21, 2020
Attachment L-05 MDS Engineering EPW 10.13.20.xlsx	XLSX spreadsheet	Oct 21, 2020
Attachment J-18 Mission Essential Functions (MDSE) 10.15.20.pdf	PDF	Oct 21, 2020
TEAMS-Next MDS Engineering Section L 10.13.20.pdf	PDF	Oct 21, 2020
HQ0858-20-R-0014 TN MDS Eng MOD 10.21.20.pdf	PDF	Oct 21, 2020
Attachment J-14 Quarterly Self Assessment 3.9.20.pdf	PDF	Sep 22, 2020
TEAMS-Next MDS Engineering Section L 9.15.20.pdf	PDF	Sep 22, 2020
Attachment L-06 Accounting System Checklist.pdf	PDF	Sep 22, 2020
Attachment J-13 Monthly Manpower Report Template 1.9.20.xlsx	XLSX spreadsheet	Sep 22, 2020
Attachment L-05 MDS Engineering EPW 9-17-20.xlsx	XLSX spreadsheet	Sep 22, 2020
Attachment J-03 TERP Procedures 5.19.20.pdf	PDF	Sep 22, 2020
Exhibit A - Contract Data Requirements List 9.17.20.pdf	PDF	Sep 22, 2020
Attachment J-15 SOFA Travel Clauses 2.7.20.pdf	PDF	Sep 22, 2020
Attachment J-09 Authorized ODC Travel by CLIN 1.9.20.xlsx	XLSX spreadsheet	Sep 22, 2020
Attachment J-01 TEAMS Next MDS Engineering Statement of Work 9.16.20.pdf	PDF	Sep 22, 2020
Attachment J-08 DD254 8.8.20 redacted.pdf	PDF	Sep 22, 2020
Attachment J-18 Mission Essential Functions.pdf	PDF	Sep 22, 2020
Attachment J-05 TERP Pricing Model 9.18.20.xlsx	XLSX spreadsheet	Sep 22, 2020
Attachment J-06 NDA Individual Contractor 1.9.20.pdf	PDF	Sep 22, 2020
Attachment L-07 OCI Disclosure Form.pdf	PDF	Sep 22, 2020
Attachment J-17 IMCP Supplier Compliance Supplement 2.24.20.pdf	PDF	Sep 22, 2020
Attachment J-04 TERP Form 6.25.20.pdf	PDF	Sep 22, 2020
TEAMS-Next MDS Engineering Section M 9.15.20.pdf	PDF	Sep 22, 2020
HQ0858-20-R-0014 TN MDSE 9.22.20.pdf	PDF	Sep 22, 2020
Attachment J-12 Travel and ODC Report 2.18.20.xlsx	XLSX spreadsheet	Sep 22, 2020
Attachment J-21 TEAMS-Next OCI Guiding Principles 9.15.20.pdf	PDF	Sep 22, 2020
Attachment J-02 G-06 Allotment of Funds HQ0858-20-R-0014 9.9.20.xlsx	XLSX spreadsheet	Sep 22, 2020

Show all 27

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.

Cost Report by CLIN

DATE Attachment J-06
TEAMS COST REPORT FORMAT
BY CLIN
CONTRACT TITLE:	Missile Defense System (MDS) Engineering																		CONTRACT VALUE: ($M)						56.000
FUNCTIONAL AREA:																				LABOR					50.000
CONTRACTOR NAME:	Contractor Name TBD																			TRAVEL					5.000
CONTRACT NUMBER:	HQ0858-20-C-xxxx																			ODC					1.000
RFP NUMBER:	HQ0858-20-R-0014																		CONTRACT PERIOD OF PERFORMANCE: xx xxx xxxx - xx xxx xxxx
TITLE OF CONTRACT
			FY 15											FY 16
TITLE		$M	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct
			CUMULATIVE DATA
Labor - AB	Budget Baseline	50.000			50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000
CLIN XXXX	Funds Received				10.200	10.200	10.200	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000
	Plnd Accruals				2.600	5.000	7.900	10.100	12.500	14.500	16.700	18.800	21.000	23.200	25.600	27.900	30.000	32.600	34.700	37.000	39.390	41.600	44.000	46.200	50.000
	ETC								12.400	14.400	16.600	18.700	20.900	23.100	25.500	27.800	29.900	32.500	34.600	36.900	39.290	41.500	43.900	46.100	49.900
	Accrued				2.250	5.100	7.800	9.970
	Current Period Accruals				2.250	2.850	2.700	2.170
	Variance to plan				0.350	-0.100	0.100	0.130
	Variance %				13%	-2%	1%	1%
	Invoiced					2.100	2.640	9.850
	Invoice paid						2.100	2.640
	Hours (Current Period)				25,275	21,999	23,777	24,450
	Hours (Cumulative)				25,275	47,274	71,051	95,501

Labor - BC	Budget Baseline	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000
CLIN XXXX	Funds Received		10.200	10.200	10.200	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000
	Plnd Accruals		2.600	5.000	7.900	10.100	12.500	14.500	16.700	18.800	21.000	23.200	25.600	27.900	30.000	32.600	34.700	37.000	39.390	41.600	44.000	46.200	50.000
	ETC						12.400	14.400	16.600	18.700	20.900	23.100	25.500	27.800	29.900	32.500	34.600	36.900	39.290	41.500	43.900	46.100	49.900
	Accrued		2.250	5.100	7.800	9.970
	Current Period Accruals		2.250	2.850	2.700	2.170
	Variance to plan		0.350	-0.100	0.100	0.130
	Variance %		13%	-2%	1%	1%
	Invoiced			2.100	2.640	9.850
	Invoice paid				2.100	2.640
	Hours (Current Period)		23,556	21,220	23,450	24,100
	Hours (Cumulative)		23,556	44,776	68,226	92,326

Labor - DT	Budget Baseline	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000	50.000
CLIN XXXX	Funds Received		10.200	10.200	10.200	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000	13.000
	Plnd Accruals		2.600	5.000	7.900	10.100	12.500	14.500	16.700	18.800	21.000	23.200	25.600	27.900	30.000	32.600	34.700	37.000	39.390	41.600	44.000	46.200	50.000
	ETC						12.400	14.400	16.600	18.700	20.900	23.100	25.500	27.800	29.900	32.500	34.600	36.900	39.290	41.500	43.900	46.100	49.900
	Accrued		2.250	5.100	7.800	9.970
	Current Period Accruals		2.250	2.850	2.700	2.170
	Variance to plan		0.350	-0.100	0.100	0.130
	Variance %		13%	-2%	1%	1%
	Invoiced		0.000	2.100	2.640	9.850
	Invoice paid		0.000	0.000	2.100	2.640
	Hours (Current Period)		20,150	22,660	21,550	20,160
	Hours (Cumulative)		20,150	42,810	64,360	84,520

Travel	Budget Baseline	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000	5.000
CLIN XXXX	Funds Received		0.750	0.750	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
OPR	Plnd Accruals		0.000	0.250	0.300	0.300	0.600	0.750	0.800	1.125	1.900	2.150	2.400	2.750	2.980	3.200	3.450	3.890	4.350	4.540	4.750	4.800	5.000
	ETC						0.500	0.650	0.700	1.025	1.800	2.050	2.300	2.650	2.880	3.100	3.350	3.790	4.250	4.440	4.650	4.700	4.900
	Accrued		0.000	0.225	0.290	0.295
	Current Period Accruals		0.000	0.225	0.065	0.005
	Variance to plan		0.000	0.025	0.010	0.005
	Variance %		0%	10%	3%	2%
	Invoiced		0.000	0.000	0.225	0.280
	Invoice paid		0.000	0.000	0.000	0.225

ODC	Budget Baseline	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
CLIN XXXX	Funds Received		0.000	0.000	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050	0.050
OPR	Plnd Accruals		0.000	0.000	0.040	0.049	0.460	0.460	0.642	0.642	0.642	0.870	0.870	0.870	0.870	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
	ETC						0.360	0.360	0.542	0.542	0.542	0.770	0.770	0.770	0.770	0.900	0.900	0.900	0.900	0.900	0.900	0.900	0.900
	Accrued		0.000	0.000	0.032	0.048
	Current Period Accruals		0.000	0.000	0.032	0.016
	Variance to plan		0.000	0.000	0.008	0.001
	Variance %		0%	0%	20%	2%
	Invoiced		0.000	0.000	0.000	0.030
	Invoice paid		0.000	0.000	0.000	0.000
Total Contract	Budget Baseline	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000	156.000
	Funds Received		31.350	31.350	31.650	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050	40.050
	Plnd Accruals		7.800	15.250	24.040	30.649	38.560	44.710	51.542	58.167	65.542	72.620	80.070	87.320	93.850	102.000	108.550	115.890	123.520	130.340	137.750	144.400	156.000
	ETC						38.060	44.210	51.042	57.667	65.042	72.120	79.570	86.820	93.350	101.500	108.050	115.390	123.020	129.840	137.250	143.900	155.500
	Accrued		6.750	15.525	23.722	30.253	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
	Current Period Accruals		6.750	8.775	8.197	6.531	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
	Variance to plan		1.050	-0.275	0.318	0.396	38.560	44.710	51.542	58.167	65.542	72.620	80.070	87.320	93.850	102.000	108.550	115.890	123.520	130.340	137.750	144.400	156.000
	Variance %		13%	-2%	1%	1%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%
	Invoiced		0.000	6.300	8.145	29.860	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
	Invoice paid		0.000	0.000	6.300	8.145	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Variance Explanation: Explain a +/- 10% or $100K variance to planned accruals
Cost report should include the entire POP for active CLINS
DEFINITIONS:

Budget Baseline:	Total budget for the contract.
Funds Received:	Total dollars (cumulative) obligated on contract.
Planned Accruals:	Baseline Plan by month that will only change with Scope changes (cumulative)
ETC	Projected spend plan (cumulative)
Accrued	Total amount of invoices (cumulative) submitted for payment plus work performed but not billed
Current Period Accruals:	Monthly increment of accruals
Variance to Plan:	Difference in accruals compared to planned accruals.
Variance %	Variance to Plan divided by Planned Accrual
Invoiced	Total amount of invoices (cumulative) submitted in WAWF
Invoice Paid	Contractor has received payment (cumulative)

Approved for Public Release 20-MDA-10578 (18 Sep 20)

Add additional months as necessary to ensure all accruals are reported at the end of the POP

Detail Report by CLIN

TEAMS DETAIL COST REPORT
Contract Title:
Functional Area:
Contractor Name: Contractor Name
Contract Number: HQ0147-16-C-xxxx
RFP Number: HQ0147-16-R-xxxx
Report Date: Month - Year ("n"th Report for Option "x")
Labor Category	Total Labor Dollars Incurred this Period	Cumulative Labor Dollars (Total Labor Expense Incurred)
Program Manager	0.020	0.020
Engineer - Basic	0.030	0.030
Engineer - Intermediate	0.050	0.050
Engineer - Advanced	0.010	0.010
Analyst - Basic	0.050	0.050
Analyst - Intermediate	0.050	0.050
Analyst - Advanced	1.050	1.050
Subject Matter Expert	0.010	0.010
Fee	0.005	0.005
CLIN XXXX LABOR Subtotal	1.275	1.275
Total Expenditures	1.275	1.275
Authorized Funded Ceiling		56.000
Percent Spent (Based on Authorized Funded Ceiling)		2.28%
Estimated Date Current Authorized Funded Ceiling is expected to run out:*
*Must show/provide how run out dates are calculated

Approved for Public Release 20-MDA-10578 (18 Sep 20)

File details come from the government source that posted it. Updated Sep 22, 2020.