ATTACHMENT 10 SAMPLE COMPLEX MBAS Funding Plan V2.xlsx

XLSX spreadsheet 75 KB Posted Apr 13, 2018

Attached to: Management and Business Analytics Support Federal contract opportunity
Solicitation number: N65236-16-R-0018
Issued by: Department of the Navy Information Warfare Systems Command

View the file

Other files for this federal contract opportunity

Other files attached to Management and Business Analytics Support, newest first.
File	Type	Posted
Attachment 6B BFM Support Subcontractor Model v1.2 - 12JUNE2017.xlsx	XLSX spreadsheet	Apr 13, 2018
Attachment 08 Resume Format.pdf	PDF	Apr 13, 2018
N65236-16-R-0018.pdf	PDF	Apr 13, 2018
ATTACHMENT 4A N65236-16-R-0018 Prime Model v1.6 - 12JUN2017.xlsx	XLSX spreadsheet	Apr 13, 2018
Attachment 5C MBAS SAnDS PWS Support.pdf	PDF	Apr 13, 2018
N65236-16-R-0018 Amendment 0006 14 June 2017.pdf	PDF	Apr 13, 2018
Attachment 5B SANDS Subcontractor Model v1.1 - 19MAY2017.xlsx	XLSX spreadsheet	Apr 13, 2018
N65236 16 R 0018 Amendment 0002 02 June 2017.pdf	PDF	Apr 13, 2018
ATTACHMENT 3 MBAS QASP ATCH_1 SW4335_1.pdf	PDF	Apr 13, 2018
Attachment 6A BFM Support Prime Model v1.2 - 12JUNE2017.xlsx	XLSX spreadsheet	Apr 13, 2018
Attachment 5A SANDS Prime Model v1.1 - 19MAY2017.xlsx	XLSX spreadsheet	Apr 13, 2018
Pre Acquisition Planning Industry Engagement Presentation (3-31-17).pdf	PDF	Apr 13, 2018
ATTACHMENT 2 PAST PERFORMANCE.pdf	PDF	Apr 13, 2018
CDRLS Exhibit A.pdf	PDF	Apr 13, 2018
N65236-16-R-0018 Amendment 0001 23 May 2017.pdf	PDF	Apr 13, 2018
Attachment 7C MBAS DEFENSE HEALTH IT TO Support V4.2.pdf	PDF	Apr 13, 2018
Attachment 11 FFP Ceiling Prices Final.xlsx	XLSX spreadsheet	Apr 13, 2018
ATTACHMENTS 1A and 1B.pdf	PDF	Apr 13, 2018
Attachment 7A Defense Health Prime Model v1.2 - 19MAY2017.xlsx	XLSX spreadsheet	Apr 13, 2018
Attachment 9 Charleston and Washington DC WD.pdf	PDF	Apr 13, 2018
Industry Day 31 March 2017 Participants.pdf	PDF	Apr 13, 2018
N65236-16-R-0018 Amendment 0003 08 June 2017.pdf	PDF	Apr 13, 2018
Attachment 6C MBAS BFM 1.0 PWS.pdf	PDF	Apr 13, 2018
RFP QAs from 30 May through 14 June 2017 MBAS v5.pdf	PDF	Apr 13, 2018
N65236-16-R-0018 Amendment 0004 12 June 2017.pdf	PDF	Apr 13, 2018
Industry Day QA.pdf	PDF	Apr 13, 2018
ATTACHMENT 4B N65236-16-R-0018 Subcontractor Model v1.5.3 - 12JUN2017 (2).xlsx	XLSX spreadsheet	Apr 13, 2018
Attachment 7B Defense Health Subcontractor Model v1.2 - 19MAY2017.xlsx	XLSX spreadsheet	Apr 13, 2018

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.

Option Year 1

		Contract Information Summary
		Contract and TO Number	N65236-14-D-4162-0007
		Short Title	Health Systems and Business Force Solutions Program/Financial Management Support
		Use of Multiple CLINs (Y or N)?
Mathey, Jared [USA]: This occurs if you have multiple appropriations, different sponsors, and different types of money.	Y
		Term or Completion?

Mathey, Jared [USA]: Completion is defined as the scope of work by stating a definite goal or target and specifying an end product. This form of task order normally requires the contractor to complete and deliver the specified end product within the estimated cost. The fee is payable upon acceptance by the government of the deliverable.

Term is defined as the scope of work in general terms and obligates the contractor to devote a specified level of effort for a stated time period. Under this form, if the performance is considered satisfactory by the Government, the fixed fee is payable as a percentage of the LOE, not at final completion of the task order.

Term
	Type of Order	MAC
	Period of Performance (Award)	1/19/17 - 1/18/18
	If applicable: TO POP adjustment	NA	MOD #	8
	Planning PR (Award)	1300502436	CRM #	CRM-15-01507
	If applicable: PPR (Ceiling increase)	NA	CRM #

Funding Table

Funding CLINS

Mathey, Jared [USA]: Information can be found on the IGE and/or provided by PR Support POC.

If CLIN numbers are unknown, use BASE1, BASE2, BASE3, etc, OPT1-1, OPT1-2, OPT1-3, etc, OPT2-1, OPT2-2, etc.	Contract ACRN
Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by the BFM.	PWS/Subtask Para #(s)
Mathey, Jared [USA]: Information can be found on the IGE and/or provided by PR Support POC.	APPN (s)

Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by the BFM.

Include Fiscal Year (if known) and appropriation (ex, RDT&E, O&M, OP, MILCON, No year, etc) Funding Type (s) Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by the BFM.

Overhead (OH) Service Center (SRVC) Direct Cite (DC)

Reimbursable (R)	CLIN POP Start
Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by PR Support POC.	CLIN POP End
Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by PR Support POC.	Contract MOD
Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by PR Support POC.	Funded PR Number
Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by PR Support POC.	DFAS Payment office
Mathey, Jared [USA]: Information can be found on the funding document as AAA code and/or provided by the BFM.	Resource Sponsor
Mathey, Jared [USA]: Information can be found on the funding document and/or provided by the BFM.	Funding Document Task Description

Mathey, Jared [USA]: Information can be found on the funding document and/or provided by the BFM.

	CEILING	FUNDING	Unfunded Ceiling Remaining
Mathey, Jared [USA]: No data should be entered. Calculated by subtracting Funding Applied to Contract from Adjusted Ceiling.	Funding NWA/BS
Mathey, Jared [USA]: Information can be found in the DCMR and/or provided by the BFM.	Funding Doc No.
Mathey, Jared [USA]: Information can be found in the DCMR and/or provided by the BFM.	PSC Code
				FROM	BY	TO	FROM	BY	TO
	(Reference)			CLIN Ceiling
Mathey, Jared [USA]: Information can be found on the Pre-Award Documentation and/or provided by PR Support POC.	Ceiling Adjustment

Mathey, Jared [USA]: No data should be entered at the CLIN-level.

Information can be provided by PR Support POC.

Calculated by via Sum Function of ceiling ajustment below.

	Adjusted Ceiling
Mathey, Jared [USA]: No data should be entered. Calculated by summing CLIN Ceiling and Ceiling Adjustments.	Previously Funded

Mathey, Jared [USA]: No data should be entered at the CLIN-level.

Information can be provided by the BFM.

Calculated by via Sum Function of historical funding actions below. Increase/De-obligation/Re-aligned funds this Action Mathey, Jared [USA]: No data should be entered at the CLIN-level.

Information can be found on the DCMR and/or provided by the BFM.

Calculated by via Sum Function of current funding actions below. Funding Applied to Contract Mathey, Jared [USA]: No data should be entered. Calculated by summing Previously Funded and Increase/De-obligation actions.

Mathey, Jared [USA]: Information can be found in the DCMR and/or provided by the BFM.

Mathey, Jared [USA]: This occurs if you have multiple appropriations, different sponsors, and different types of money.

Mathey, Jared [USA]: Information can be found on the IGE and/or provided by PR Support POC.

If CLIN numbers are unknown, use BASE1, BASE2, BASE3, etc, OPT1-1, OPT1-2, OPT1-3, etc, OPT2-1, OPT2-2, etc.

Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by the BFM.

Mathey, Jared [USA]: Information can be found on the IGE and/or provided by PR Support POC.

Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by the BFM.

Include Fiscal Year (if known) and appropriation (ex, RDT&E, O&M, OP, MILCON, No year, etc) Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by the BFM.

Overhead (OH) Service Center (SRVC) Direct Cite (DC) Reimbursable (R) Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by PR Support POC.

Mathey, Jared [USA]: Information can be found on the DCMR and/or provided by PR Support POC.

Mathey, Jared [USA]: Information can be found on the funding document as AAA code and/or provided by the BFM.

Mathey, Jared [USA]: Information can be found on the funding document and/or provided by the BFM.

Mathey, Jared [USA]: Information can be found on the Pre-Award Documentation and/or provided by PR Support POC.

Mathey, Jared [USA]: No data should be entered at the CLIN-level.

Information can be provided by PR Support POC.

Calculated by via Sum Function of ceiling ajustment below.

Mathey, Jared [USA]: No data should be entered. Calculated by summing CLIN Ceiling and Ceiling Adjustments.

Mathey, Jared [USA]: No data should be entered at the CLIN-level.

Information can be provided by the BFM.

Calculated by via Sum Function of historical funding actions below.

Mathey, Jared [USA]: No data should be entered. Calculated by subtracting Funding Applied to Contract from Adjusted Ceiling.

Mathey, Jared [USA]: No data should be entered at the CLIN-level.

Information can be found on the DCMR and/or provided by the BFM.

Calculated by via Sum Function of current funding actions below.	CLIN	2002		All	O&M	DC	7/1/17	6/30/18			044226	ABC	$ 500,000.00	$ 500,000.00	$ 258,000.00	$ - 0	258,000.00	242,000.00
	SLIN/PR	200201	AA	All	O&M	DC	7/1/17	6/30/18	09	1300123456	044226	ABC			$ 100,000.00				100009999999 0001	HT0000000001	D310
	SLIN/PR	200202	AB	All	O&M	DC	7/1/17	6/30/18	09	1300123456	044226	ABC			$ 25,000.00				100009999999 0002	HT0000000002	D310
	SLIN/PR	200203	AC	All	O&M	DC	7/1/17	6/30/18	09	1300123456	044226	ABC			$ 63,000.00				100009999999 0003	HT0000000003	D310
		200204	AD	All	O&M	DC	7/1/17	6/30/18	11	1300123457	044226	ABC			$ 15,000.00	$ - 0			100009999999 0004	HT0000000004	D318
		200205	AE	All	O&M	DC	7/1/17	6/30/18	11	1300123457	044226	ABC			$ 55,000.00	$ - 0			100009999999 0005	HT0000000005	D318

2201		6.5, 6.6, 6.7	O&M	R	7/1/17	6/30/18			044226	ABC	$100,000.00	$ 100,000.00	$ 76,500.00	$ - 0	76,500.00	23,500.00
220101	AF	6.5, 6.6, 6.7	O&M	R	7/1/17	6/30/18	09	1300614236	044226	ABC			$ 5,000.00				100009999999 0006	HT0000000006	D310
220102	AG	6.5, 6.6, 6.7	O&M	R	7/1/17	6/30/18	09	1300614236	044226	ABC			$ 15,000.00				100009999999 0007	HT0000000007	D310
220103	AH	6.5, 6.6, 6.7	O&M	R	7/1/17	6/30/18	09	1300614236	044226	ABC			$ 30,000.00				100009999999 0008	HT0000000008	D310
220104	AI	All	O&M	R	7/1/17	6/30/18	11	1300123457	044226	ABC			$ 7,000.00	$ - 0			100009999999 0009	HT0000000009	D310
220105	BA	All	O&M	R	7/1/17	6/30/18	11	1300123457	044226	ABC			$ 10,000.00	$ - 0			100009999999 0010	HT0000000010	D310
220106	BB	All	O&M	R	7/1/17	6/30/18	11	1300123457	044226	ABC			$ 2,000.00	$ - 0			100009999999 0011	HT0000000011	D310
220107	BC	6.5, 6.6, 6.7	O&M	R	7/1/17	6/30/18	12	1300123458	044226	ABC			$ 7,500.00	$ - 0			100009999999 0012	HT0000000012

2202		6.5, 6.6, 6.7	OP	DC	7/1/17	6/30/18			044226	ABC	$ 100,000.00	$ 100,000.00	$ 75,000.00	$ - 0	75,000.00	25,000.00
220201	BD	6.5, 6.6, 6.7	OP	DC	7/1/17	6/30/18	09	1300123456	044226	ABC			$ 75,000.00				100001226139 0020	HT0003614519	D310

												All
2203		All	RDT&E	R	7/1/17	6/30/18			044226	ABC	$ 75,000.00		$ 75,000.00	$ 50,000.00	$ - 0	50,000.00	25,000.00
220301	BE	All	RDT&E	R	7/1/17	6/30/18	09	1300123456	044226	ABC				$ 50,000.00				100009999999 0013	HT0000000013	D310

2204		6.5, 6.6, 6.7	OP	DC	7/1/17	6/30/18			S12137	DEF	$ 125,000.00	$ 125,000.00	$ 45,000.00	$ - 0	45,000.00	80,000.00
220401	AK	6.5, 6.6, 6.7	OP	DC	7/1/17	6/30/18	09	1300123456	S12137	DEF			$ 25,000.00				100009999999 0014	HT0000000014	D399
220402	BF	6.5, 6.6, 6.7	OP	DC	7/1/17	6/30/18	09	1300123456	S12137	DEF			$ 20,000.00				100009999999 0015	HT0000000015	D399

2205		All	O&M	R	7/1/17	6/30/18			S12137	DEF	$ 95,000.00	$ 95,000.00	$ 5,000.00	$ - 0	5,000.00	90,000.00
220501	BK	All	O&M	R	7/1/17	6/30/18	09	1300123456	S12137	DEF			$ 5,000.00				100009999999 0016	HT0000000016	D399

2206		All	RDT&E	R	7/1/17	6/30/18			S12137	DEF	$ 75,000.00	$ 75,000.00	$ 10,000.00	$ - 0	10,000.00	65,000.00
220601	BT	All	RDT&E	R	7/1/17	6/30/18	09	1300123456	S12137	DEF			$ 10,000.00				100009999999 0016	HT0000000016	D399

2207		6.5, 6.6, 6.7	O&M	R	7/1/17	6/30/18			068688	XYZ	$ 35,000.00	$ 35,000.00	$ 30,000.00	$ - 0	30,000.00	5,000.00
220701	AA	6.5, 6.6, 6.7	O&M	R	7/1/17	6/30/18	09	1300123456	068688	XYZ			$ 5,000.00				100009999999 0016	HT0000000016	D310
220702	AL	6.5, 6.6, 6.7	O&M	R	7/1/17	6/30/18	12	1300123458	068688	XYZ			$ 10,000.00	$ - 0			100009999999 0016	HT0000000016
220703	BB	6.5, 6.6, 6.7	O&M	R	7/1/17	6/30/18	12	1300123458	068688	XYZ			$ 15,000.00	$ - 0			100009999999 0016	HT0000000016
2208					1/19/17	1/18/18				HIJ	$ 55,000.00	$ 55,000.00	$ 30,000.00	$ - 0	30,000.00	25,000.00
220801	BG	All	OP	DC	7/1/17	6/30/18	11	1300123456	387700	HIJ			$ 30,000.00	$ - 0			100009999999 0016	HT0000000016	D310

2209					7/1/17	6/30/18					$ 30,000.00	$ 30,000.00	$ 20,000.00	$ - 0	20,000.00	10,000.00
220901	BR	6.1, 6.2, 6.3, 6.7	RDT&E	R	7/1/17	6/30/18	11	1300619136	050210	KLM			$ 20,000.00	$ - 0			100009999999 0016	HT0000000016	R408
														$ - 0

2210					7/1/17	6/30/18					$ 70,000.00	$ 70,000.00	$ 15,000.00	$ - 0	15,000.00	55,000.00
221001	BT	6.1, 6.2, 6.3, 6.7	RDT&E	R	7/1/17	6/30/18	12	1300627569	044226	ABC			$ 15,000.00	$ - 0			100009999999 0016	HT0000000016

2211					7/1/17	6/30/18					$ 200,000.00	$ 200,000.00	$ 15,000.00	$ 75,000.00	90,000.00	110,000.00
221101	BZ	All	RDT&E	DC	7/1/17	6/30/18	12	1300627569	S12137	DEF			$ 15,000.00	$ - 0			100009999999 0016	HT0000000016
221102	BZ	All	RDT&E	DC	7/1/17	6/30/18	13	1300635258	S12137	DEF				$ 75,000.00			100009999999 0016	HT0000000016

TOTAL 1,460,000.00 0.00 1,460,000.00 629,500.00 75,000.00 704,500.00 755,500.00

File details come from the government source that posted it.