Cost Track_Mo Fin Report Template_CD.xls

XLS spreadsheet 64 KB Posted Feb 27, 2012

Attached to: Special Notice - HDIAC BCO Federal contract opportunity
Solicitation number: FA8075-12--R-0001
Issued by: Department of the Air Force Air Combat Command

About this file

From the source

Cost Track_Mo Fin Report Template_CD

View the file

Other files for this federal contract opportunity

Other files attached to Special Notice - HDIAC BCO, newest first.
File	Type	Posted
Compiled_QandA_as_of_25_June_2012.xlsx	XLSX spreadsheet	Jun 25, 2012
FA8075-12-R-0001_A02.doc	DOC document	Jun 21, 2012
Compiled_QandA_as_of_21_June_2012.xlsx	XLSX spreadsheet	Jun 21, 2012
Compiled_QandA_as_of_11_June_2012.xlsx	XLSX spreadsheet	Jun 11, 2012
Compiled_QandA_as_of_1_June_2012.xlsx	XLSX spreadsheet	Jun 1, 2012
Amendment 1 - HDIAC_BCO_RFP_SF30.doc	DOC document	May 23, 2012
Compiled_QandA_as_of_23_May_2012.xlsx	XLSX spreadsheet	May 23, 2012
Compiled_Q A_as_of_23_May_2012.xlsx	XLSX spreadsheet	May 23, 2012
ESG HDIAC BCO RFP.docx	DOCX document	May 15, 2012
Compiled_Q_and_A_As_of_5_March_2012.xlsx	XLSX spreadsheet	Mar 5, 2012
Compiled Q and A As of 27 Feb 2012.xlsx	XLSX spreadsheet	Feb 27, 2012
Pre-Solicitation Notice.docx	DOCX document	Feb 22, 2012
Draft _HDIAC_BCO_RFP.doc	DOC document	Jan 31, 2012

Show all 13

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.

HDIAC TO Report

	Column Number:	One	Two	Three	Four	Five	Six	Seven	Eight	Nine	Ten	Eleven	Twelve	Thirteen	Fourteen	Fifteen	Sixteen	Seventeen	Eighteen	Nineteen	Twenty	Twenty One
		Contract No.1	RMS No. 2	TO No.3	Title4	Requesting Activity 5	Start Date6	End Date7	TO Ceiling8	Total Funded9	Amount Expended10	Percent Expended
11	Obligated Balance12	Total $ Subcont. Out of Amt. Expended13	% Total Subkt out of amt. expended14	Total $ Cost of Performance Incurred for Personnel15	% of Cost of Performance Incurred for Personnel expended by Prime's employees16	Schedule Status17	Security Rqmt.18	Task Order Status19	Total FTE20	FTE Changes
(+/- During Period)21		Open Orders	Closed Orders	Ahead of Schedule	Behind Schedule	On Time
	1	FA8075-12-D-XXXX	HD-12-0045	0001	Example of title of task to complete for this effort	NAVAIR	DD-MM-YYYY	DD-MM-YYYY	$ 100,000.00	$ 50,000.00	$ 35,000.00	70%	$ 15,000.00	$ - 0	0%	N/A	N/A	Ahead	Secret	Open	1.5	0.0	1	0	1	0	0
	2								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	3								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	4								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	5								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	6								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	7								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	8								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	9								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	10								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	11								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	12								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	13								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	14								$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	N/A	N/A	*		*			0	0	0	0	0
	GRAND TOTALS:								$ 100,000.00	$ 50,000.00	$ 35,000.00		$ 15,000.00	$ - 0	0%	$ - 0	0%				1.5		1	0	1	0	0
	Total Orders		1
	Total Open Orders		1
	Total Closed Orders		0
	Total Orders On Time		0
	Total Orders Ahead of Schedule		1
	Total Orders Behind Schedule		0
	Non DTIC Funded Work (cumulative costs
	incurred/expended to date):		$____________
	Note #	Explanation of Notes/Column Headings
	1	Contract number of basic IDIQ CSIAC contract
	2	Number assigned by DTIC RMS system
	3	Task order number assigned by Contracting Officer on face of task order
	4	Brief description of order. For CATs, use description per RA's PWS. For basic BCO service task order, put "BCO Services - DTIC Funded" and the FY the order covers.
	5	Name of funding/requesting activity. For basic BCO service task order, put DTIC.
	6	Task order period of performance start date
	7	Task order period of performance end date (including all options even if not yet exercised)
	8	The total maximum ceiling value amount (for CPFF orders) or firm fixed price amount (for FFP orders) of the entire task order (inclusive of options).
	9	The dollar amount funded/obligated to date
	10	The amount the contractor has expended/incurred under the order to date - should match the cumulative invoiced amount per the latest invoice submitted concurrently with this report
	11	The amount the contractor has expended/incurred as a percentage of the amount funded (column 10 divided by column 9)
	12	The unexpended obligated funds balance (column nine minus ten)
	13	The total amount out of the expended funds (column ten) that was incurred on subcontracted costs (the term subcontractor is defined in FAR 44.1)
	14	Column thirteen divided by column ten
	15	See Code of Federal Regulations (CFR) 125.6(a)(1) and 125.6(e)(1) and 125.6(e)(2) for explanation of this term
	16	See Code of Federal Regulations (CFR) 125.6(a)(1) and 125.6(e)(1) and 125.6(e)(2) for explanation of this term
	17	Status codes are "ahead", "on time" and "behind"
	18	Indicate clearance level applicable to the order. If not specified, indicate "secret".
	19	Status = open (order is still being physically performed, period of performance end date has not passed) and completed (order performance /period of performance has ended)
	20	Total FTE = full time equivalents performing the order (average) during the reporting period. Contractor shall use its standard accounting practice to determine # hours equivalent to one FTE.
	21	Change in FTE since last report.

&CBCO COST TRACKING/MONTHLY FINANCIAL REPORT

CONTRACTOR: _____________&R&D

&RCDRL-A002

Contract Ceiling Balance

Contract Ceiling Value Inclusive of Base Period and All Options Exercised to Date:	$ 10,000,000.00
Combined cumulative ceiling value, all Task Orders Issued To Date:	$ 100,000.00
Balance of Unordered Contract Ceiling Remaining:	$ 9,900,000.00
Percentage of Contract Ceiling Ordered:	1%
Percentage of Contract Ceiling Remaining:	99%

BCO Cost Breakdown

	Report of BCO Costs Incurred By CDRL/Task Area
	Instructions: The contractor shall provide a report the total cumulative costs incurred/expended to date in performance of basic "core" (aka "BCO") services, as well as
	a detailed itemization of costs by task/CDRL area, for the open BCO "core services/DTIC funded" task order from the date of task order award.
	The total cumulative costs incurred amount reported should correspond with the latest cumulative invoiced amount for BCO services that was reflected in the latest invoice,
	that was submitted concurrently with submission of this report.
	The total cumulative expended/incurred amount reported should match the amount reported in column ten of the HDIAC TO Report for the open BCO core services task order.
	Only billable/invoiced costs shall be reported as expended/incurred.
	The itemization of costs shall be as set forth below. Note this report covers core (non CAT) services only, therefore CDRL A014 (CAT technical reports) is not applicable.
	Each labor hour or other cost reported in the contractor's accounting system should be charged to one of the task areas below. If a cost (for example one labor hour)
	is allocable to more than one task, that cost should be allocated/charted to the appropriate multiple task areas in increments of no less than .5 (1/2 hour) each.
	For example, if an analyst performs 1 labor hour that benefits both the web page and newsletter equally, they would charge 1/2 hour to each task.
	Task Area	Cumulative Costs Incurred/Expended to Date
1	Technical Inquiries	$
2	CDRL A001 - Web Page support and development	$
3	CDRL A002- Information System Support	$
4	CDRL A003 - Service Promotion/Awareness Products	$
5	CDRL A004 - Quarterly Newsletter	$
6	CDRL A005 - Models, Software and Databases	$
7	CDRL A006 - Performance Metrics Reporting	$
8	CDRL A007 - Quarterly Progress Report	$
9	CDRL A008 - IAC Operational and Strategic Plan	$
10	CDRL A009 - Weekly Activity Report (WAR)	$
11	CDRL A010 - Basic BCO Products	$
12	CDRL A011 - Govt Property List/DPAS Reporting	$
13	CDRL A012 - Weekly Phase In/Transition Report	$
14	CDRL A013 - CAT STI Assessment Report	$
15	CDRL A015 - Cost Tracking/Monthly Financial Reporting	$
16	CDRL A016 - DTIC IAC PMO Ad Hoc Deliverables and Data Requests	$
17	All other services, not elsewhere classified	$
	TOTAL:	$________(This amount should match the figure in column 10 for the BCO task order in the HDIAC TO Report)

File details come from the government source that posted it. Updated Nov 14, 2017.