Attachment_J-06_Cost_Report_Template.xlsx

XLSX spreadsheet 52 KB Posted Jun 14, 2018

Attached to: Protocol Federal contract opportunity
Solicitation number: HQ014718R0007
Issued by: DOD Missile Defense Agency

About this file

From the source

Final RFP Section J Attachment J-06 Cost Report Template

View the file

Other files for this federal contract opportunity

Other files attached to Protocol, newest first.
File	Type	Posted
Protocol_Q&A_Matrix.docx	DOCX document	Jun 27, 2018
Attachment_L-13_Corporate_Experience_5-17-2018.doc	DOC document	Jun 14, 2018
Section_L_-_Protocol_6-8-18.pdf	PDF	Jun 14, 2018
Attachment_L-08_Pre-Award_Survey_of_Prospective_Contractor.pdf	PDF	Jun 14, 2018
Protocol_Q&A_Matrix.docx	DOCX document	Jun 14, 2018
Attachment_L-06_TEAMS_Resume_Format_Update.pdf	PDF	Jun 14, 2018
Attachment_L-12_TEAMS_OCI_Memorandum.pdf	PDF	Jun 14, 2018
Attachment_J-04_Monthly_Manpower_Report_Template.xlsx	XLSX spreadsheet	Jun 14, 2018
Attachment_J-16_wage_determination_for_Madison_AL.PDF	PDF	Jun 14, 2018
Section_M_-_Protocol_6-5-18.pdf	PDF	Jun 14, 2018
Attachment_J-07_Monthly_Status_Report.pdf	PDF	Jun 14, 2018
Attachment_J-01_Protocol_II_PWS_v36.pdf	PDF	Jun 14, 2018
Attachment_L-05_-_OCI_Disclosure_Form.pdf	PDF	Jun 14, 2018
Attachment_J-13_wage_determination_for_CO_counties_of_EL_Paso-Teller.pdf	PDF	Jun 14, 2018
Attachment_J-15_wage_determination_for_King_George_VA.PDF	PDF	Jun 14, 2018
Exhibit_A_CDRLs.pdf	PDF	Jun 14, 2018
A006_Monthly_Manpower_Report_-_Protocol_signed_DAP_v2.pdf	PDF	Jun 14, 2018
Attachment_J-05_Labor_Competency_Level_Descriptions_-_Protocol__final.pdf	PDF	Jun 14, 2018
A005_Government_Property_-_Protocol_signed_DAP_v2.docx.pdf	PDF	Jun 14, 2018
Attachment_J-03_DD-254_for_HQ0147-18-R-0007.pdf	PDF	Jun 14, 2018
Attachment_J-17_WD_-_Alaska_Fairbanks.pdf	PDF	Jun 14, 2018
Attachment_J-14_wage_determination_for_DC_Statewide.pdf	PDF	Jun 14, 2018
Attachment_J-08_Travel_Status_Report_-_Revised_08212017.xlsm	XLSM spreadsheet	Jun 14, 2018
Attachment_J-12_MDA_OCI_Policy_Memo__51.pdf	PDF	Jun 14, 2018
HQ0147-18-R-0007_Protocol_Final.pdf	PDF	Jun 14, 2018
Protocol_Draft_RFP_Q&A.pdf	PDF	Jun 14, 2018
Attachment_L-14_Protocol_EPW.XLSX	XLSX spreadsheet	Jun 14, 2018
A001_Monthly_Status_Report_-_Protocol_v1_(002).pdf	PDF	Jun 14, 2018
Attachment_J-09_Quarterly_Self_Assessment.pdf	PDF	Jun 14, 2018
Attachment_L-10_Labor_Competency_Level_Descriptions_-_Protocol__final.pdf	PDF	Jun 14, 2018
Attachment_L-13_Corporate_Experience_4-23-2018.doc	DOC document	May 11, 2018
Attachment_J-03_DD-254_for_HQ0147-18-R-0007.pdf	PDF	May 11, 2018
Attachment_L-12_TEAMS_OCI_Memorandum.pdf	PDF	May 11, 2018
Attachment_J-04_PPBE_Form.pdf	PDF	May 11, 2018
Attachment_J-12_MDA_OCI_Policy_Memo__51.pdf	PDF	May 11, 2018
Attachment_J-07_Monthly_Status_Report.pdf	PDF	May 11, 2018
A005_Government_Property_-_Protocol_signed_DAP.PDF	PDF	May 11, 2018
Atch_J-10_Labor_Competency_Level_Descriptions_-_Protocol__final.xlsx	XLSX spreadsheet	May 11, 2018
Attachment_L-06_TEAMS_Resume_Format_Update.pdf	PDF	May 11, 2018
Section_L_-_Protocol_5-9-18.docx	DOCX document	May 11, 2018
Attachment_L-05_-_OCI_Disclosure_Form.pdf	PDF	May 11, 2018
Attachment_J-02_QASP_Protocol_4192018.docx	DOCX document	May 11, 2018
A006_(Monthly_Manpower)_-_Protocol_signed_DAP.PDF	PDF	May 11, 2018
Attachment_L-08_Pre-Award_Survey_of_Prospective_Contractor.pdf	PDF	May 11, 2018
Attachment_J-01_Protocol_II_PWS_v33_5-2-18.doc	DOC document	May 11, 2018
Attachment_J-09_Quarterly_Self_Assessment.pdf	PDF	May 11, 2018
PROTOCOL-Comments_Matrix.xlsx	XLSX spreadsheet	May 11, 2018
Attachment_J-08_Travel_Status_Report_-_Revised_08212017.xlsm	XLSM spreadsheet	May 11, 2018
Attachment_L-10_Labor_Competency_Level_Descriptions_-_Protocol__final.xlsx	XLSX spreadsheet	May 11, 2018
HQ014718R0007_Protocol_Draft_4-24-18.docx	DOCX document	May 11, 2018

Show all 50

Protocol has more files on GovTribe.

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.

Cost Report by CLIN

DATE Attachment J-06
TEAMS COST REPORT FORMAT
BY CLIN
CONTRACT TITLE:	Protocol Support																		CONTRACT VALUE: ($M)						56.000
FUNCTIONAL AREA:																				LABOR					50.000
CONTRACTOR NAME:	Contractor Name																			TRAVEL					5.000
CONTRACT NUMBER:	HQ0147-18-C-xxxx																			ODC					1.000
RFP NUMBER:	HQ0147-18-R-000X																		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: Protocol Support
Functional Area:
Contractor Name: Contractor Name
Contract Number: HQ0147-18-C-xxxx
RFP Number: HQ0147-18-R-000X
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.