HQ0858-21-R-0016_Attachment J-11 Cost Report Template_Final.xlsx

XLSX spreadsheet 88 KB Posted Aug 18, 2021

Attached to: TEAMS Next Facilities Lifecycle Management (FLCM)
Solicitation number: HQ085821R0016
Issued by: DOD Missile Defense Agency

About this file

Written by GovTribe AI · Dec 28, 2023

This cost report template and related federal contract opportunity are for facilities lifecycle management services to be provided to the Missile Defense Agency. The cost report template outlines the labor categories, funding amounts, spending plans, and accruals across multiple contract line item numbers for a base period of three years plus five additional option years. Services will include facility and infrastructure planning, design, construction oversight, and configuration management. The federal contract opportunity is a full and open solicitation seeking proposals for a cost-plus-fixed-fee level of effort contract with a ceiling of $120.6 million. Proposals are due by September 17, 2021. Eligible offerors must be registered in SAM and have a small business size standard of $41.5 million under the specified NAICS code.

View the file

Other files

File	Type	Posted
HQ0858-21-R-0016_TN-FLCM Final Section L 9.24.21_redline.pdf	PDF	Sep 27, 2021
HQ0858-21-R-0016_TN-FLCM Final Section M 9.24.21_redline.pdf	PDF	Sep 27, 2021
HQ0858-21-R-0016-U0003 CONFORMED.pdf	PDF	Sep 27, 2021
HQ0858-21-R-0016_TN-FLCM Final Section M 9.24.21_clean.pdf	PDF	Sep 27, 2021
HQ0858-21-R-0016_TN-FLCM Final Section L 9.24.21_clean.pdf	PDF	Sep 27, 2021
HQ0858-21-R-0016-U0003 FLCM AMDT 3 27sep21.pdf	PDF	Sep 27, 2021
HQ0858-21-R-0016-U0002 Amdt 0002 FLCM.pdf	PDF	Sep 15, 2021
HQ0858-21-R-0016_TN-FLCM Final Section L 9.15.21 Amdt 0002.pdf	PDF	Sep 15, 2021
HQ0858-21-R-0016_TN-FLCM Final Section L 9.15.21_redline Amdt 0002.pdf	PDF	Sep 15, 2021
HQ0858-21-R-0016-U0002 Amdt 0002 FLCM CONFORMED.pdf	PDF	Sep 15, 2021
HQ0858-21-0016-P0001.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_TN-FLCM Final Section L 9.10.21_redline.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_TN-FLCM_Industry_Comment_Matrix consolidated 9.10.21 final.xlsx	XLSX spreadsheet	Sep 10, 2021
HQ0858-21-R-0016_Attachment J-03 TERP Procedures 10 Sept 21_redline.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_TN-FLCM Final Section M 8.31.21_redline.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_Attachment J-01 Statement of Work_8.31.21.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_TN-FLCM Final Section M 8.31.21.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_Attachment L-05 FLCM Final EPW 9.10.21.xlsx	XLSX spreadsheet	Sep 10, 2021
HQ0858-21-0016-P0001 CONFORMED.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_TN-FLCM Final Section L 9.10.21.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_Attachment J-01 Statement of Work_8.31.21 redline.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_Attachment J-03 TERP Procedures 10 Sept 21_clean.pdf	PDF	Sep 10, 2021
HQ0858-21-R-0016_Attachment L-07 OCI Disclosure Form_Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-05 TERP Pricing Model 7.28.21 FLCM.xlsx	XLSX spreadsheet	Aug 18, 2021
HQ0858-21-R-0016_Attachment L-04 Client Authorization Letter_Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_TN-FLCM Final Section L 8.11.21_Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-04 TERP Form 23 Jul 21.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment L-01 PPI Form 04.21.2021.docx	DOCX document	Aug 18, 2021
HQ0858-21-R-0016_Attachment L-06 Accounting System Checklist_Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-08 DD254 - 12MAY21.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-01 Statement of Work_7.26.21.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-17 IMCP Supplier Compliance Supplement_Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_CDRL A005 Organizational Conflict of Interest Management Plan - Redacted.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_CDRL A003 Government Property Inventory Report - Redacted.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-06 NDA Individual Contractor_Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-21 TEAMS-Next OCI Guiding Principles - Rev3.0 - 15Sept2020.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-13 Monthly Manpower Report Template_Final.xlsx	XLSX spreadsheet	Aug 18, 2021
HQ0858-21-R-0016_Attachment L-05 FLCM Final EPW 6.3.21.xlsx	XLSX spreadsheet	Aug 18, 2021
HQ0858-21-R-0016 FLCM 8.18.21 Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-03 TERP Procedures 23 Jul 21.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-14 Quarterly Accomplishments Reporting Format_Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_TN-FLCM Final Section M 8.4.21_Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-09 Authorized ODC Travel by CLIN_Final.xlsx	XLSX spreadsheet	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-18 Mission Essential Functions -21APR21.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_TN-FLCM RFP Industry Comment Matrix.xlsx	XLSX spreadsheet	Aug 18, 2021
HQ0858-21-R-0016_Attachment L-02 PPQ Form 07.22.2021.docx	DOCX document	Aug 18, 2021
HQ0858-21-R-0016_CDRL A004 Monthly Manpower - Redacted.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_CDRL A001 Monthly Status Report - Redacted.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment L-03 Sample Consent Letter_Final.pdf	PDF	Aug 18, 2021
HQ0858-21-R-0016_Attachment J-12 Travel and ODC Report_Final.xlsx	XLSX spreadsheet	Aug 18, 2021

Show 40 more

Latest 50 of 54 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.

Labor by CLIN

DATE

ATTACHMENT J-11

HQ0858-21-R-0016 COST REPORT (Labor $M)

CONTRACT TITLE:

TEAMS-Next Facilities Lifecycle Management

TOTAL LABOR ($M)

120.688

TOTAL HOURS

144,150

CONTRACTOR NAME:

Contractor Name TBD

CONTRACT PERIOD OF PERFORMANCE: Day Month Year - Day Month Year

FY 21

FY 22

TITLE

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Labor - AB	Budget Baseline ($)	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205	46.205
	Baseline (Hours)		66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320	66,320
CLIN XXXX	Funds Received		10.200	10.200	10.200	10.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200	13.200
	Plnd Accruals (Cumulative $)		1.930	3.855	5.780	7.705	9.630	11.555	13.480	15.405	17.330	19.255	21.180	23.105	25.030	26.955	28.880	30.805	32.730	34.655	36.580	38.505	40.430	42.355	44.280	46.205
	Plnd Accruals (Current Period $)		1.930	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925	1.925
	Accrued $ (Cumulative)		0.468	2.521	4.691	6.861	9.031
	Accrued $ (Current Period)		0.468	2.053	2.170	2.170	2.170
	Variance to plan		1.462	1.334	1.089	0.844	0.599
	Variance %		76%	35%	19%	11%	6%
	Invoiced		0.000	0.468	2.521	4.691	6.861
	Invoiced - Paid		0.000	0.000	0.635	2.805	4.975
	Actual Hours (Cumulative)		3,450	25,275	47,274	71,051	95,501
	Actual Hours (Current Period)		3,450	21,825	21,999	23,777	24,450

Labor - DE	Budget Baseline	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483	32.483
	Baseline (Hours)		39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440	39440
CLIN XXXX	Funds Received		3.200	3.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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.364	2.717	4.070	5.423	6.776	8.129	9.482	10.835	12.188	13.541	14.894	16.247	17.600	18.953	20.306	21.659	23.012	24.365	25.718	27.071	28.424	29.777	31.130	32.483
	Plnd Accruals (Current Period $)		1.364	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353	1.353
	Accrued $ (Cumulative)		0.640	1.710	3.197	4.717	6.319
	Accrued $ (Current Period)		0.640	1.070	1.487	1.520	1.602
	Variance to plan		0.724	1.007	0.873	0.706	0.457
	Variance %		53%	37%	21%	13%	7%
	Invoiced		0.000	0.640	1.710	3.197	4.717
	Invoiced - Paid		0.000	0.000	0.640	1.710	3.197
	Actual Hours (Cumulative)		9,500	23,556	44,776	68,226	92,326
	Actual Hours (Current Period)		9,500	14,056	21,220	23,450	24,100

Labor - DT	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - DV	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - GM	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - IC	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - MS	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - SN	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - SS	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - TC	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - TH	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - AE-I-UBB/Line 021	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - AE-I-UBB/Line 026	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - JA-P-NCO/Line 018	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Labor - SR-I-WIB/Line 046	Budget Baseline	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000	42.000
	Baseline (Hours)		38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390	38,390
CLIN XXXX	Funds Received		5.350	5.350	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	14.000	15.000
	Plnd Accruals (Cumulative $)		1.750	3.500	5.250	7.000	8.750	10.500	12.250	14.000	15.750	17.500	19.250	21.000	22.750	24.500	26.250	28.000	29.750	31.500	33.250	35.000	36.750	38.500	40.250	42.000
	Plnd Accruals (Current Period $)		1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750	1.750
	Accrued $ (Cumulative)		0.995	2.250	5.100	7.800	9.970
	Accrued $ (Current Period)		0.995	1.255	2.850	2.700	2.170
	Variance to plan		0.755	1.250	0.150	-0.800	-1.220
	Variance %		43%	36%	3%	-11%	-14%
	Invoiced		0.000	0.995	2.250	5.100	7.800
	Invoiced - Paid		0.000	0.000	0.995	2.250	5.100
	Actual Hours (Cumulative)		4,680	20,150	42,810	64,360	84,520
	Actual Hours (Current Period)		4,680	15,470	22,660	21,550	20,160

Total Labor	Budget Baseline	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688	120.688
	Baseline (Hours)		144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150	144,150
	Funds Received		18.750	18.750	30.600	30.600	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	39.200	41.200	43.200
	Plnd Accruals (Cumulative $)		5.044	10.072	15.100	20.128	25.156	30.184	35.212	40.240	45.268	50.296	55.324	60.352	65.380	70.408	75.436	80.464	85.492	90.520	95.548	100.576	105.604	110.632	115.660	120.688
	Plnd Accruals (Current Period $)		5.044	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028	5.028
	Accrued $ (Cumulative)		2.103	6.481	12.988	19.378	25.320
	Accrued $ (Current Period)		2.103	4.378	6.507	6.390	5.942
	Variance to plan		2.941	3.591	2.112	0.750	-0.164
	Variance %		58%	36%	14%	4%	-1%
	Invoiced		0.000	2.103	6.481	12.988	19.378
	Invoiced - Paid		0.000	0.000	2.270	6.765	13.272
	Actual Hours (Cumulative)		17,630	68,981	134,860	203,637	272,347
	Actual Hours (Current Period)		17,630	51,351	65,879	68,777	68,710
Variance Explanation: Explain a +/- 10% or $100K variance to planned accruals. The format is in the Variance Explanation worksheet
Cost report should include the entire period of performance for active CLINS
The spend plan, i.e., planned accruals, for LOE CLINS should be straight-lined based upon number of weeks in each accounting month.
DEFINITIONS
Budget Baseline	CLIN value of current period of performance; requires update if change orders are issued
Funds Received	Total dollars (cumulative) obligated on contract
Plnd Accruals (Cumulative $)	Cumulative spend plan; requires update if change orders are issued
Plnd Accruals (Current Period $)	Monthly increment of planned accrual
Accrued $ (Cumulative)	Cumulative amount of invoices submitted for payment plus work performed but not billed
Accrued $ (Current Period)	Monthly increment of actual accruals
Variance to Plan	Difference between planned accruals (cum) and accrued $ (cum)
Variance %	Variance to Plan divided by Planned Accrual (cum)
Invoiced	Cumulative amount of invoices submitted in WAWF
Invoice Paid	Cumulative amount of payment received
Actual Hours (Cumulative)	Cumulative amount of actual hours
Actual Hours (Current Period)	Monthy increment of actual hours

Add additional months as necessary to ensure all data is reported at the end of the POP

Variance Explanation

Variance Explanation: Explain a +/- 10% or $.100M variance to planned accruals
CLIN	Stakeholder	Variance Amount ($M)	Variance %	Explanation

Labor Detail by CLIN

TEAMS-NEXT LABOR DETAIL COST REPORT
Contract Title: FLCM
Contractor Name: Contractor Name TBD
Contract Number: HQ0858-21-R-0016
Report Date: Month - Year
Labor Category	Total Labor Dollars Incurred this Period $M	Cumulative Labor Dollars (Total Labor Expense Incurred) $M
Program Manager	1.020	1.020
Engineer - Basic	1.093	1.093
Engineer - Intermediate	1.450	1.450
Engineer - Advanced	1.780	1.780
Analyst - Basic	0.950	0.950
Analyst - Intermediate	1.650	1.650
Analyst - Advanced	1.050	1.050
Subject Matter Expert	0.000	0.000
Fee	0.038	0.038
CLIN XXXX LABOR Subtotal	9.031	9.031
Total Accrued Expenditures	9.031	9.031
Authorized Funded Ceiling		120.688
Percent Spent (Based on Authorized Funded Ceiling)		7.48%
Estimated Date Current Authorized Funded Ceiling is expected to run out:
	DATE:

Approved for Public Release

21-MDA-10882 (11JUL2021)

File details come from the government source that posted it. Updated Aug 18, 2021.