Sec J Att 11 Cost Report Template 10 Feb 20.xlsx

XLSX spreadsheet 53 KB Posted Feb 21, 2020

Attached to: TEAMS-Next Contracting, Compliance, Cost/Price and Operations (C3PO)
Solicitation number: HQ0858-20-R-0001
Issued by: DOD Missile Defense Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This cost report template and federal contract opportunity notice provide details for the Missile Defense Agency's TEAMS-Next Contracting, Compliance, Cost/Price and Operations (C3PO) requirement. The cost report template outlines the required format for tracking labor, travel, other direct costs, and total contract expenditures on a monthly basis by cost line item number. It includes sections for budget baselines, planned accruals, estimated costs to complete, accrued costs, variances from plan, invoices, and payments. The federal contract opportunity notice seeks proposals for executive-level research, analysis, advice, and product development in areas such as contract policy, pricing, and operations support. Offerors must register in SAM and submit proposals by March 23, 2020 for the cost-plus-fixed-fee level of effort contract, which has a base period of two years and up to three additional one-year options. The total small business set-aside contract will be awarded based on best value.

View the file

Other files

File	Type	Posted
Contractor BETA.SAM.GOV Quick Start Guide.pdf	PDF	Mar 12, 2020
Sec J Att 15 SOFA Travel Clauses.pdf	PDF	Feb 21, 2020
Sec J Att 06 Individual Contractor NDA 9 Jan 20.pdf	PDF	Feb 21, 2020
Att L6 Accounting System Checklist 7 Feb 20.doc	DOC document	Feb 21, 2020
Att L2 PPQ Form 20 Feb 20.docx	DOCX document	Feb 21, 2020
Sec J Att 05 TERP Pricing Model 19 Feb 20.xlsx	XLSX spreadsheet	Feb 21, 2020
Att L3 Sample Consent Letter 9 Jan 20.pdf	PDF	Feb 21, 2020
Att L1 PPI Form 20 Feb 20.docx	DOCX document	Feb 21, 2020
Sec J Att 08 DD-254 19 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 03 TERP Procedures 19 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 09 Auth ODC Travel by CLIN.xlsx	XLSX spreadsheet	Feb 21, 2020
Sec J Att 13 Monthly Manpower Report Template 7 Feb 20.xlsx	XLSX spreadsheet	Feb 21, 2020
HQ0858-20-R-0001 C3PO.pdf	PDF	Feb 21, 2020
Att L7 OCI Disclosure Form 6 Feb 20.docx	DOCX document	Feb 21, 2020
Sec J Exh A CDRLs.pdf	PDF	Feb 21, 2020
Sec J Att 01 C3PO SOW 19 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 12 Travel Status Report Template 7 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 07 PPBE Form 9 Jan 20.pdf	PDF	Feb 21, 2020
TEAMS-Next C3PO Sec M 20 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 14 Quarterly Accomplishment Report Template 12 Feb 20.pdf	PDF	Feb 21, 2020
Att L5 Excel Pricing Worksheet 19 Feb 20.xlsx	XLSX spreadsheet	Feb 21, 2020
Sec J Att 04 TERP Form 19 Feb 20.pdf	PDF	Feb 21, 2020
Att L4 Client Authorization Letter 9 Jan 20.pdf	PDF	Feb 21, 2020
Sec J Att 02 G-06 Allot of Funds 11 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 10 Monthly Status Report Template 10 Feb 20.pdf	PDF	Feb 21, 2020
TEAMS-Next C3PO Sec L 20 Feb 20.pdf	PDF	Feb 21, 2020

Show all 26

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 Section J, Attachment 11
TEAMS COST REPORT FORMAT
BY CLIN
CONTRACT TITLE:																			CONTRACT VALUE: ($M)						56.000
FUNCTIONAL AREA:																				LABOR					50.000
CONTRACTOR NAME:	Contractor Name																			TRAVEL					5.000
CONTRACT NUMBER:	HQ0858-20-C-XXXX																			ODC					1.000
RFP NUMBER:	HQ0858-20-R-0001																		CONTRACT PERIOD OF PERFORMANCE: 1 Jan 15 - 30 Sep 16
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)

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: HQ0858-20-C-XXXX
RFP Number: HQ0858-20-R-0001
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

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