Attachment J-06 TEAMS ITMA Monthly Cost Report 20 Jan 2016.xlsx

XLSX spreadsheet 53 KB Posted Oct 3, 2017

Attached to: TEAMS Information Technology Management and Analysis
Solicitation number: HQ0147-16-R-0015
Issued by: DOD Missile Defense Agency

About this file

From the source

Attachment J-06 TEAMS ITMA Monthly Cost Report 20 Ja.

View the file

Other files

File	Type	Posted
Award_Announcement_ITMA_08082018.pdf	PDF	Aug 8, 2018
ITMA_QA_-_Final_RFP_-_Amd_9_-_20180511_Final.xlsx	XLSX spreadsheet	May 18, 2018
HQ0147-18-R-0004_Conformed_Copy_ITMA.pdf	PDF	May 18, 2018
HQ0147-18-R-0004_Amend_09_ITMA.pdf	PDF	May 18, 2018
SECTION_L_May_17_2018_Clean_ITMA.pdf	PDF	May 18, 2018
Attachment_L-14_Historical_ITMA_PWS.pdf	PDF	May 18, 2018
Attachment_L-02__TEAMS_ITMA_-_Past-Performance-Questionnaire.pdf	PDF	May 18, 2018
HQ014718R0004_Amend_08.zip	ZIP file	May 8, 2018
HQ014718R0004_Conformed_04_May_2018.pdf	PDF	May 4, 2018
HQ014718R0004_Amend_07_04May2018.pdf	PDF	May 4, 2018
Attachment_L-12_Bidders_Documents_Library_Index.pdf	PDF	May 4, 2018
Attachment_J-01_ITMA_PWS__Clean.pdf	PDF	May 4, 2018
Attachment_L-02__TEAMS_ITMA_-_Past-Performance-Questionnaire.docx	DOCX document	May 4, 2018
Attachment_J-02_TEAMS_ITMA_-_QASP_TrackChanges.pdf	PDF	May 4, 2018
Attachment_L-01_TEAMS_ITMA_-_Past_Performance_Information_(PPI).docx	DOCX document	May 4, 2018
SECTION_L_May_4_2018_TrackChanges.pdf	PDF	May 4, 2018
Attachment_J-01_ITMA_PWS__TC.pdf	PDF	May 4, 2018
Attachment_L-09__ITMA_Historical_Information.pdf	PDF	May 4, 2018
SECTION_L_May_4_2018_Clean.pdf	PDF	May 4, 2018
Attachment_J-02_TEAMS_ITMA_-_QASP_Clean.pdf	PDF	May 4, 2018
SECTION_M_May_4_2018.pdf	PDF	May 4, 2018
Attachment_L-07_EPW_r4.xlsx	XLSX spreadsheet	May 4, 2018
Attachment_L-10_TEAMS_ITMA_-_Labor_Competency_Descriptions_v3_021518_(003).pdf	PDF	May 4, 2018
Attachment_L-03_TEAMS_ITMA_-_Consent_Letter.pdf	PDF	May 4, 2018
SECTION_M_May_4_2018_TrackChanges.pdf	PDF	May 4, 2018
ITMA_QA_-_2Final_RFP_-_20180316_-_JC_Update.pdf	PDF	May 4, 2018
Attachment J-14 Monthly Manpower Report.xlsx	XLSX spreadsheet	Oct 3, 2017
Attachment L-09 Historical Information by Stakeholder.pdf	PDF	Oct 3, 2017
Attachment L-02_ TEAMS ITMA - Past-Performance-Questionnaire.pdf	PDF	Oct 3, 2017
Attachment J-13 SOFA Travel Clauses 4-2017.pdf	PDF	Oct 3, 2017
Attachment J-03a_TEAMS ITMA - SCI Supp.pdf	PDF	Oct 3, 2017
Attachment L-06 TEAMS Resume Format Update.pdf	PDF	Oct 3, 2017
Attachment J-03 TEAMS ITMA - DD254.pdf	PDF	Oct 3, 2017
Attachment J-11 MDA OCI Policy Memo 51.pdf	PDF	Oct 3, 2017
Attachment J-01 - ITMA PWS v29 - 20170622.pdf	PDF	Oct 3, 2017
Exhibit A005 - Physical Inventory Plan for GFP - ITMA - v2.pdf	PDF	Oct 3, 2017
Exhibit A007 - IA Workforce Management Reporting - ITMA - v2.pdf	PDF	Oct 3, 2017
Exhibit A001 - Monthly Status Report - ITMA - v2.pdf	PDF	Oct 3, 2017
ITMA_RFP_HQ0147-18-R-0004.pdf	PDF	Oct 3, 2017
Exhibit A006 - Monthly Manpower Report - ITMA - v2.pdf	PDF	Oct 3, 2017
Attachment L-03_TEAMS ITMA - Consent Letter.pdf	PDF	Oct 3, 2017
Exhibit A002 - Monthly Cost Report - ITMA - v2.pdf	PDF	Oct 3, 2017
Attachment L-11_TEAMS ITMA - Historical Key Product Tables.pdf	PDF	Oct 3, 2017
Attachment J-15 SGFP Form.pdf	PDF	Oct 3, 2017
Attachment L-07_TEAMS ITMA - Excel Pricing Workbook_CPFF	—	Oct 3, 2017
Attachment J-05 Reserved.pdf	PDF	Oct 3, 2017
Attachment J-04 PPBE NDA	—	Oct 3, 2017
Attachment J-01a_TEAMS ITMA - Key Product Tables - 20170509.pdf	PDF	Oct 3, 2017
Attachment J-09 TEAMS ITMA - Quarterly Self Assessment.pdf	PDF	Oct 3, 2017
Section_M_v21_-_20171002_Evaluation_Factors.pdf	PDF	Oct 3, 2017

Show 40 more

Latest 50 of 65 listed here. See the rest on GovTribe.

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

XX MMM YY Attachment J-06
TEAMS COST REPORT FORMAT
BY CLIN
CONTRACT TITLE:	TEAMS ITMA																		CONTRACT VALUE: ($M)						56.000
FUNCTIONAL AREA:	IC																			LABOR					50.000
CONTRACTOR NAME:																				TRAVEL					5.000
CONTRACT NUMBER:	HQ0147-18-R-0004																			ODC					1.000
RFP NUMBER:																			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	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 %		0.404	0.040	0.271	0.076	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
	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: For Example: TEAMS ITMA
Functional Area: IC
Contractor Name:
Contract Number: HQ0147-16-R-0015
RFP Number:
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 Nov 14, 2017.