Attrachment 0009-CDRL A012 Performance and Cost Report Worksheet Jan 202....xlsx

XLSX spreadsheet 46 KB Posted Jan 28, 2020

Attached to: STARLite ER SAR/GMTI Federal contract opportunity
Solicitation number: W56JSR-18-R-0008
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

Written by GovTribe AI · Dec 30, 2023

This document outlines requirements for a sole source solicitation seeking sustainment services for the STARLite ER SAR/GMTI radar system. Requirements include engineering, technical, and logistics support services; lay-in materials; repairs; and obsolescence monitoring and mitigation. The solicitation will be a five-year IDIQ contract awarded on a sole source basis to Northrop Grumman Systems Corporation, the original equipment manufacturer and sole provider of the proprietary technology. The Army Contracting Command at Aberdeen Proving Ground will award firm fixed price, cost plus fixed fee, cost plus incentive fee, and cost reimbursable contract types. The place of performance will be the contractor's facility.

View the file

Other files for this federal contract opportunity

Other files attached to STARLite ER SAR/GMTI, newest first.
File	Type	Posted
A07- Solicitation W56JSR-18-R-0008_02.pdf	PDF	Jan 28, 2020
Section L STARLite_08Oct2019_FINAL.DOCX	DOCX document	Jan 28, 2020
A01-Attachment 0006 STARLite Data Rqmts Form_01302019.pdf	PDF	Jan 28, 2020
A01-Attachment 0007 STARLite Data Elements Defs_01302019.pdf	PDF	Jan 28, 2020
A01-Attachment 0001 - STARLite ER PWS Amd 02.pdf	PDF	Jan 28, 2020
Exh A_STARLite_Base_CDRL_8 JAN 2020.docx	DOCX document	Jan 28, 2020
A01-Attachment 0005 STARLite Prov Rqmt_01302019.pdf	PDF	Jan 28, 2020
A01-Attachment 0002 STARLite Acronyms_01302019.pdf	PDF	Jan 28, 2020
A01-Attachment 0003 STARLite QASP 20190124.pdf	PDF	Jan 28, 2020
A01-Attachment 0004 STARLite Parts List_01302019.pdf	PDF	Jan 28, 2020
A01-Attachment 0008 STARLite DD254_SIGNED.PDF	PDF	Jan 28, 2020
Amend_0001_W56JSR_18_R_0008.pdf	PDF	Jul 24, 2019
A01-STARLite_Base_CDRL_(A001-A014)_24_July_2019_Amend_0001.docx	DOCX document	Jul 24, 2019
A01-Base_PWS_STARLite_NMC_FINAL_7__24_2019_(updated).docx	DOCX document	Jul 24, 2019
A01_STARLite_ER_Appendix_C_-_Intel_Access.doc	DOC document	Jul 22, 2019
A01-STARLite_Base_CDRL_(A001-A014)_19_July_2019.docx	DOCX document	Jul 22, 2019
A01-Attachment_0010__STARLite_ER_DD254_SIGNED.pdf	PDF	Jul 22, 2019
A01-Base_PWS_STARLite_NMC_FINAL_7_19_2019.docx	DOCX document	Jul 22, 2019
STARLite_ER_Parts_List.docx	DOCX document	Jul 22, 2019
A01-Attachment_0005__STARLite_ER_Prov_Rqmt.docx	DOCX document	Jul 22, 2019
A01-Attachment_0002__STARLite_ER_Acronyms.docx	DOCX document	Jul 22, 2019
W56JSR_18_R_0008_Final_Solicitation.pdf	PDF	Jul 22, 2019
STARLite_ER_QASP_FINAL.docx	DOCX document	Jul 22, 2019
A01-DA_FORM_2410.pdf	PDF	Jul 22, 2019
A01_STARLite_ER_FOUO_Appendix_D.doc	DOC document	Jul 22, 2019
A01_STARLite_ER_Appendix_A-_COMSEC.doc	DOC document	Jul 22, 2019
A01-Attachment_0007__STARLite_ER_Data_Elements_Defs.docx	DOCX document	Jul 22, 2019
A01-Attachment_0006_STARLite_ER_Data_Rqmts_Form.docx	DOCX document	Jul 22, 2019

Show all 28

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.

Instructions

Overall Instructions:

* All financial data/totals should tie to the monthly data dumps from your system of record and cumulate to the costs on the ITD (Inception to Date) Actuals tab for the current POP. If your contract has multiple POPs occuring at the same time,

possibly certain SLINs extended on a particular option year yet the current POP is for a new option year, then you are required to populate two separate cost reports. Do not mix cost/actuals for different periods of performance.

* Do not change the layout/any cells in this template. You may populate the report with either formulas of your choosing or hard coded numbers but all data (monthly and cumulative) must be supported and match the monthly actuals and cum actuals

on the ITD actuals tab. Spot checks will be done to ensure totals match the data. You may add comments off to the side of cells or add a comment on a particular cell to provide the COR with additional information if needed.

* All cells/totals may not need to be populated depending on the costs incurred and work being performed contract by contract. If a cell or total doesn't apply to actuals incurred, leave the cell blank or enter a $0.00 value. Columns have been provided for all

cost types, even where that particular costs type might not seem reasonable, to account for any mischarging and adjustments/corrections that might need to occur.

* Before receiving this cost report, the COR should have identified and created individual tabs for each effort/system so you are aware of the cost reporting structure. If this hasn't been done please work with your COR to create the necessary tabs before

populating the report.

Program Summary Instructions:

* This tab is to be populated with totals for the entire current POP, from Inception to date through the most recent month close actuals, and also requests totals for most recent reporting period. Example: The current POP is 1/1/2019 - 12/31/2019 and the most

recent month close was April, the reporting period is 4/1/2019 - 4/30/2019 and the Cumulative Totals should be from 1/1/2019 - 4/1/2019.

* ITD actuals by Funding Type should be pulled from the SLIN data on each effort/system tab. You can add a formula to calculate this, create a pivot, or manually calculate. Keep in mind not all funding types will apply to all contracts.

Contract Mods Instructions:

* As each new Mod is received (award, funding increase/decrease, admin, etc) you are required to populate a new Mod box to account for changes in that Mod.

Effort/Sytem Tab Instructions:

* The total summary box, and data on each tab, is soley for the effort/system identified. The estimated burn out date can be calculated using a formula/theory of your choosing but you must account for actuals to date, the remaining ETC (estimate to complete),

known requirements, and known cost that is expected to post (such as lagging subcontractor invoices, labor adjustments, material/ODC costs to post once received).

* Each SLIN must have its own data set and as you receive additional funding, create a data set box for all SLINs for each effort/system. You must also identify the Mod in which the funding was provided and the Funding Type.

* All other cells should be self explainatory but if you require additional claraifcation please reach out to your COR.

Program Summary

	Program Summary - Financial Reporting			Mod 1 - Award		Mod 2 - Funding Increase		Mod 3 - Admin
				Base Ceiling	$0.00	Base Ceiling	$0.00	Base Ceiling	$0.00
	Funding Remaining			Previous Ceiling Amount	$0.00	Previous Ceiling Amount	$0.00	Previous Ceiling Amount	$0.00
	Contract Number/TO	12345 TO #1		Ceiling Increase	$0.00	Ceiling Increase	$0.00	Ceiling Increase	$0.00
	Program Name	StarLite		Labor Funding	$0.00	Labor Funding	$0.00	Labor Funding	$0.00
	Reporting Period	9/1/2019 - 9/30/2019		Travel/ODC Funding	$0.00	Travel/ODC Funding	$0.00	Travel/ODC Funding	$0.00
	POP	9/1/2019 - 9/1/2020		Material Funding	$0.00	Material Funding	$0.00	Material Funding	$0.00
				Total Funding	$0.00	Total Funding	$0.00	Total Funding	$0.00
	Task Order	Labor	ODC
Funding	$0.00	$0.00	$0.00
Funding Expended	$0.00	$0.00	$0.00
Funding Remaining
Ceiling	$0.00	$0.00	$0.00
Ceiling Expended	$0.00	$0.00	$0.00
Ceiling Remaining

	Reporting Period Amount
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
	Cumulative Amount (for Current POP)
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total

CLINs1001-5110 - T & I

Funding Remaining
Contract Number	12345 TO #1
Effort Name	Test & Inspection
Reporting Period	9/1/2019 - 9/30/2019
POP	9/1/2019 - 9/1/2020
Est Burn Out Date

		Reporting Period Amount	9/1/2019 - 9/30/2019
ANTENNA ASSEMBLY P/N 225K946G02
NSN: 5895-01-603-3398
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
RECEIVER SUBASSEMBLY RADAR ELECTRONIC_P/N247k760G01
NSN: 5481-01-603-3428
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
POWER SUPPLY P/N 146K162G01/G02/G03
NSN: 6120-01-603-3385
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
CONTROL UNIT NAVIGATION SET P/N 231K935G01
NSN: 6605-01-578-4629
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
BLOWER ASSEMBLY P/N 215K772G01
NSN: 4140-01-582-1363
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
RECEIVER/EXCITER PROGRAMMED ASSEMBLY P/N219K256G02
NSN: 5841-01-646-2364
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
RF DOWNCONVERTER PROGRAMMED ASSEMBLY P/N219K225G03
NSN: 5895-01-646-2368
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
POWER SUPPLY CASE P/N 309K116G01
NSN: 6130-01-664-8370
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
RECEIVER SUBASSEMBLY WIRED CHASSIS P/N 146K167G03
NSN: 5841-01-646-2367
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
SENSOR PROCESSOR ASSEMBLY P/N 247K759G04
NSN: 5895-01-649-9033
Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total

Funding Remaining:

	Cumulative Amount (for Current POP)
All SLINs
Funding Awarded:

Funding Expended:
Labor	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total
ODC	Quantity	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total
Funding Remaining:

Monthly Actuals Labor Data - Prime

Serial #

Employee

Hours

Direct Labor Rate

Unique Numeric Identifier (LCAT)

Proposed/Invoiced Labor Category (LCAT)

Fringe $'s

Overhead $'s

MHC $'s

G&A $'s

Misc. Indirect $'s

Fee/Profit $'s

Total Cost

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Temporary placeholder for the assets' actual serial number; serial number to be provided/updated upon task order award.		TE1001	Test Engineer Entry		Columns (D* E) + Sum(H:N)
	08		TE1001	Test Engineer Entry		Columns (D* E) + Sum(H:N)
	52		TE1004	Test Engineer Senior		Columns (D* E) + Sum(H:N)
	16		TE1004	Test Engineer Senior		Columns (D* E) + Sum(H:N)
	37		BA 2601	Budget Analyst Entry		Columns (D* E) + Sum(H:N)
	49		BA2604	Budget Analyst Senior		Columns (D* E) + Sum(H:N)
	50		PM1404	Program Manager Senior		Columns (D* E) + Sum(H:N)
	03

		Monthly Actuals Labor Data - Sub
Serial #	Employee	Hours	Direct Labor Rate	Unique Numeric Identifier (LCAT)	Proposed/Invoiced Labor Category (LCAT)	Total Cost
06

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Temporary placeholder for the assets' actual serial number; serial number to be provided/updated upon task order award.				SE3102	Software Engineer Intermediate		Column D * E
	08				SE3103	Software Engineer Journeyman		Column D * E
	52				SE3104	Software Engineer Senior		Column D * E
	16				SE3104	Software Engineer Senior		Column D * E
	37
	49
	50
	03
			Monthly Actuals Material - Prime
		Beginning Month Material Balance	Material Purchased during Month	Materials Consumed during Month	Ending Month Balance

Wienecke, Steven M CIV US USA: Suggested numbers to be replaced with actuals in the future.

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Temporary placeholder for the assets' actual serial number; serial number to be provided/updated upon task order award.	$8,000,000.00		$1,000,000.00	$500,000.00	$8,500,000.00
				Monthly Actuals Material - Sub
		Beginning Month Material Balance		Material Purchased during Month	Materials Consumed during Month	Ending Month Balance
		$2,000,000.00		$1,000,000.00	$500,000.00	$2,500,000.00

CLINs1021-5121 - Tech SVCS SUPP

	Funding Remaining	$0.00					DMSMS Monitoring & Mitigation-CLIN1021
	Contract Number	12345 TO #1					Provisioning/Design Change Notice-CLIN1021
	Effort Name	Tech Services					Test Equipment Services-CLIN1021
	Reporting Period	9/1/2019 - 9/30/2019					Mission Assurance-CLIN1021
	POP	9/1/2019 - 9/1/2020					Contract Administration/OPSEC Plan-CLIN1021
	Est Burn Out Date
							DMSMS Monitoring & Mitigation-CLIN2021
	Reporting Period Amount	9/1/2019 - 9/30/2019					Provisioning/Design Change Notice-CLIN2021
DMSMS Monitoring & Mitigation							Test Equipment Services-CLIN2021
Funding Awarded:						$0.00	Mission Assurance-CLIN2021
							Contract Administration/OPSEC Plan-CLIN2021
Funding Expended:						$0.00
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total	DMSMS Monitoring & Mitigation-CLIN3021
Monthly Sub Cost							Provisioning/Design Change Notice-CLIN3021
Monthly Prime Cost							Test Equipment Services-CLIN3021
Total							Mission Assurance-CLIN3021
							Contract Administration/OPSEC Plan-CLIN3021
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost							DMSMS Monitoring & Mitigation-CLIN4021
Monthly Prime Cost							Provisioning/Design Change Notice-CLIN4021
Total							Test Equipment Services-CLIN4021
							Mission Assurance-CLIN4021
Funding Remaining:							Contract Administration/OPSEC Plan-CLIN4021

Provisioning/Design Change Notice							DMSMS Monitoring & Mitigation-CLIN5021
Funding Awarded:							Provisioning/Design Change Notice-CLIN5021
							Test Equipment Services-CLIN5021
Funding Expended:							Mission Assurance-CLIN5021
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total	Contract Administration/OPSEC Plan-CLIN5021
Monthly Sub Cost
Monthly Prime Cost							DMSMS Monitoring & Mitigation-CLIN5121
Total							Provisioning/Design Change Notice-CLIN5121
							Test Equipment Services-CLIN5121
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total	Mission Assurance-CLIN5121
Monthly Sub Cost							Contract Administration/OPSEC Plan-CLIN5121
Monthly Prime Cost
Total

Test Equipment Services

Funding Awarded:

Funding Expended:
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
Funding Remaining:

Mission Assurance

Funding Awarded:

Funding Expended:
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total

Contract Administration/OPSEC plan

Funding Awarded:

Funding Expended:
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
Funding Remaining:

	Cumulative Amount (for Current POP)
All SLINs
Funding Awarded:

Funding Expended:
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total
Funding Remaining:	Mirror for each Tech services Line

Monthly Actuals Labor Data - Prime

Tech Services

Employee Name

Hours

Direct Labor Rate

Unique Numeric Identifier (LCAT)

Proposed/Invoiced Labor Category (LCAT)

Fringe $'s

Overhead $'s

MHC $'s

G&A $'s

Misc. Indirect $'s

Fee/Profit $'s

Total Cost

DMSMS Monitoring & Mitigation-CLIN1021

TE1001

Test Engineer Entry

Columns (C * D) + Sum(G:M)

DMSMS Monitoring & Mitigation-CLIN2021

TE1001

Test Engineer Entry

Columns (C * D) + Sum(G:M)

DMSMS Monitoring & Mitigation-CLIN3021

TE1004

Test Engineer Senior

Columns (C * D) + Sum(G:M)

DMSMS Monitoring & Mitigation-CLIN4021

TE1004

Test Engineer Senior

Columns (C * D) + Sum(G:M)

DMSMS Monitoring & Mitigation-CLIN5021

BA 2601

Budget Analyst Entry

Columns (C * D) + Sum(G:M)

Contract Administration/OPSEC Plan-CLIN5121

BA2604

Budget Analyst Senior

Columns (C * D) + Sum(G:M)

PM1404

Program Manager Senior

Columns (C * D) + Sum(G:M)

		Monthly Actuals Labor Data - Sub
Tech Services	Employee Name	Hours	Direct Labor Rate	Unique Numeric Identifier (LCAT)	Proposed/Invoiced Labor Category (LCAT)	Total Cost
Contract Administration/OPSEC Plan-CLIN1021				SE3102	Software Engineer Intermediate	Column C * D
Test Equipment Services-CLIN2021				SE3103	Software Engineer Journeyman	Column C * D
Provisioning/Design Change Notice-CLIN3021				SE3104	Software Engineer Senior	Column C * D
Contract Administration/OPSEC Plan-CLIN4021				SE3104	Software Engineer Senior	Column C * D
Mission Assurance-CLIN4021
Contract Administration/OPSEC Plan-CLIN5121

	Monthly Actuals Material - Prime
Beginning Month Material Balance	Material Purchased during Month	Materials Consumed during Month	Ending Month Balance

Wienecke, Steven M CIV US USA: Fixed highlighting. Figures are placed are not actuals.

$8,000,000.00 $1,000,000.00 $500,000.00 $8,500,000.00

	Monthly Actuals Material - Sub
Beginning Month Material Balance	Material Purchased during Month	Materials Consumed during Month	Ending Month Balance
$2,000,000.00	$1,000,000.00	$500,000.00	$2,500,000.00

CLINs1022-5123 LIM & DMSMS

Funding Remaining
Contract Number	12345 TO #1

Wienecke, Steven M CIV US USA: edited

To add Lay-In Material & DMSMS material as separate entities.

Effort Name	Lay-In Material
Reporting Period	9/1/2019 - 9/30/2019
POP	9/1/2019 - 9/1/2020
Est Burn Out Date

	Reporting Period Amount	9/1/2019 - 9/30/2019
Lay-In Material
Funding Awarded:			$0.00

Funding Expended:
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
Funding Remaining:

DMSMS Material
Funding Awarded:	$0.00

Funding Expended:
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
Funding Remaining:

	Cumulative Amount (for Current POP)
All SLINs
Funding Awarded:

Funding Expended:
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total
Funding Remaining:

Monthly Actuals Labor Data - Prime

Serial #

CLIN #

Employee

Hours

Direct Labor Rate

Unique Numeric Identifier (LCAT)

Proposed/Invoiced Labor Category (LCAT)

Fringe $'s

Overhead $'s

MHC $'s

G&A $'s

Misc. Indirect $'s

Fee/Profit $'s

Total Cost

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Temporary placeholder for the assets' actual serial number; serial number to be provided/updated upon task order award.

LIM-CLIN1022

TE1001

Test Engineer Entry

Columns (D * E) + Sum(H:N)

LIM-CLIN1022

LIM-CLIN2022

TE1001

Test Engineer Entry

Columns (D * E) + Sum(H:N)

LIM-CLIN2022

LIM-CLIN3022

TE1004

Test Engineer Senior

Columns (D * E) + Sum(H:N)

LIM-CLIN3022

LIM-CLIN4022

TE1004

Test Engineer Senior

Columns (D * E) + Sum(H:N)

LIM-CLIN4022

LIM-CLIN5022

BA 2601

Budget Analyst Entry

Columns (D * E) + Sum(H:N)

LIM-CLIN5022

DMSMS-CLIN1023

BA2604

Budget Analyst Senior

Columns (D * E) + Sum(H:N)

LIM-CLIN5122

DMSMS-CLIN2023

PM1404

Program Manager Senior

Columns (D * E) + Sum(H:N)

DMSMS-CLIN4023

DMSMS-CLIN1023

DMSMS-CLIN5123

DMSMS-CLIN2023

DMSMS-CLIN3023

DMSMS-CLIN4023

Monthly Actuals Labor Data - Subcontractor(s)

DMSMS-CLIN5023

Serial #

CLIN #

Employee

Hours

Direct Labor Rate

Unique Numeric Identifier (LCAT)

Proposed/Invoiced Labor Category (LCAT)

Total Cost

DMSMS-CLIN5123

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Temporary placeholder for the assets' actual serial number; serial number to be provided/updated upon task order award.	LIM-CLIN1022				SE3102	Software Engineer Intermediate		Column D * E		14
	08	LIM-CLIN2022				SE3103	Software Engineer Journeyman		Column D * E		15
	52	LIM-CLIN3022				SE3104	Software Engineer Senior		Column D * E		16
	16	LIM-CLIN4022				SE3104	Software Engineer Senior		Column D * E		17
	37	LIM-CLIN5022									18
	49	DMSMS-CLIN1023									19
	50	DMSMS-CLIN2023									20
	47	DMSMS-CLIN4023									21
	27	DMSMS-CLIN5123									22
				Monthly Actuals Material - Prime							23
			Beginning Month Material Balance	Material Purchased during Month	Materials Consumed during Month	Ending Month Balance

Wienecke, Steven M CIV US USA: Suggested numbers to be replaced with actuals in the future.

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Temporary placeholder for the assets' actual serial number; serial number to be provided/updated upon task order award.					24
	$8,000,000.00	$1,000,000.00	$500,000.00	$8,500,000.00		25
						26
						27
						28
						29
		Monthly Actuals Material - Sub				30
	Beginning Month Material Balance	Material Purchased during Month	Materials Consumed during Month	Ending Month Balance		31
	$2,000,000.00	$1,000,000.00	$500,000.00	$2,500,000.00		32
						33
						34
						35
						36
						37
						38
						39
						40
						41
						42
						43
						44
						45
						46
						47
						48
						49
						50
						51
						52

CLINs1011-5120 - Repairs

Funding Remaining
Contract Number	12345 TO #1
Effort Name	Repairs
Reporting Period	9/1/2019 - 9/30/2019
POP	9/1/2019 - 9/1/2020
Est Burn Out Date

		Reporting Period Amount	9/1/2019 - 9/30/2019
ANTENNA ASSEMBLY P/N 225K946G02
NSN: 5895-01-603-3398
Funding Expended:
Labor	Serial Number	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
RECEIVER SUBASSEMBLY RADAR ELECTRONIC_P/N247k760G01
NSN: 5481-01-603-3428
Funding Expended:
Labor		Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
POWER SUPPLY P/N 146K162G01/G02/G03
NSN: 6120-01-603-3385
Funding Expended:
Labor		Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
CONTROL UNIT NAVIGATION SET P/N 231K935G01
NSN: 6605-01-578-4629
Funding Expended:
Labor		Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
BLOWER ASSEMBLY P/N 215K772G01
NSN: 4140-01-582-1363
Funding Expended:
Labor		Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
RECEIVER/EXCITER PROGRAMMED ASSEMBLY P/N219K256G02
NSN: 5841-01-646-2364
Funding Expended:
Labor		Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
RF DOWNCONVERTER PROGRAMMED ASSEMBLY P/N219K225G03
NSN: 5895-01-646-2368
Funding Expended:
Labor		Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
POWER SUPPLY CASE P/N 309K116G01
NSN: 6130-01-664-8370
Funding Expended:
Labor		Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
RECEIVER SUBASSEMBLY WIRED CHASSIS P/N 146K167G03
NSN: 5841-01-646-2367
Funding Expended:
Labor		Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
SENSOR PROCESSOR ASSEMBLY P/N 247K759G04
NSN: 5895-01-649-9033
Funding Expended:
Labor		Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Monthly Sub Cost
Monthly Prime Cost
Total
Funding Remaining:

	Cumulative Amount (for Current POP)
All SLINs
Funding Awarded:

Funding Expended:
Labor	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total
ODC	Hours	Direct Labor	Direct Travel	Materials	Sub Labor	Total
Cumulative Sub Cost
Cumulative Prime Cost
Total
Funding Remaining:

		Monthly Actuals Labor Data - Prime
Serial #	Employee	Hours	Direct Labor Rate	Unique Numeric Identifier (LCAT)	Proposed/Invoiced Labor Category (LCAT)	Fringe $'s	Overhead $'s	MHC $'s	G&A $'s	Misc. Indirect $'s	Misc. Indirect $'s

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

OPSEC Security; Direct Charge. Perhaps list as DL entry and a sense of the % of security cost relative to the entire center and other contracts (?).	Fee/Profit $'s	Total Cost
	06

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Temporary placeholder for the assets' actual serial number; serial number to be provided/updated upon task order award.		TE1001	Test Engineer Entry		Columns (D* E) + Sum(H:N)
	08		TE1001	Test Engineer Entry		Columns (D* E) + Sum(H:N)
	52		TE1004	Test Engineer Senior		Columns (D* E) + Sum(H:N)
	16		TE1004	Test Engineer Senior		Columns (D* E) + Sum(H:N)
	37		BA 2601	Budget Analyst Entry		Columns (D* E) + Sum(H:N)
	49		BA2604	Budget Analyst Senior		Columns (D* E) + Sum(H:N)
	50		PM1404	Program Manager Senior		Columns (D* E) + Sum(H:N)
	03

		Monthly Actuals Labor Data - Sub
Serial #	Employee	Hours	Direct Labor Rate	Unique Numeric Identifier (LCAT)	Proposed/Invoiced Labor Category (LCAT)	Total Cost
51

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Temporary placeholder for the assets' actual serial number; serial number to be provided/updated upon task order award.				SE3102	Software Engineer Intermediate		Column D * E
	08				SE3103	Software Engineer Journeyman		Column D * E
	52				SE3104	Software Engineer Senior		Column D * E
	16				SE3104	Software Engineer Senior		Column D * E
	37
	49
	50
	03
			Monthly Actuals Material - Prime
		Beginning Month Material Balance	Material Purchased during Month	Materials Consumed during Month	Ending Month Balance

Wienecke, Steven M CIV US USA: Suggested numbers to be replaced with actuals in the future.

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Temporary placeholder for the assets' actual serial number; serial number to be provided/updated upon task order award.	$8,000,000.00		$1,000,000.00	$500,000.00	$500,000.00
				Monthly Actuals Material - Sub
		Beginning Month Material Balance		Material Purchased during Month	Materials Consumed during Month	Ending Month Balance
		$2,000,000.00		$1,000,000.00	$500,000.00	$500,000.00

ITD Actuals for TO

File details come from the government source that posted it. Updated Jan 28, 2020.