Attachment 6A BFM Support Prime Model v1.2 - 12JUNE2017.xlsx

XLSX spreadsheet 495 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 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
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
ATTACHMENTS 1A and 1B.pdf	PDF	Apr 13, 2018
ATTACHMENT 10 SAMPLE COMPLEX MBAS Funding Plan V2.xlsx	XLSX spreadsheet	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.

COVER

This proposal includes data that shall not be disclosed outside the Government and shall not be duplicated, used, or disclosed--in whole or in part--for any purpose other than to evaluate this proposal. If, however, a contract is awarded to this offeror as a result of--or in connection with--the submission of this data, the Government shall have the right to duplicate, use, or disclose the data to the extent provided in the resulting contract. This restriction does not limit the Government's right to use information contained in this proposal if it is obtained from another source without restriction. All data in this proposal are subject to this restriction.

RESTRICTION ON DISCLOSURE

AND USE OF DATA

INSTRUCTIONS

N65236-16-R-0018

XXXXXXXXX

Business Financial Management Support

PRIME Pricing Model v1.1 dated 19MAY2017

CONTRACT SPECIALIST: Jessica Stogner (843) 218-2136

GENERAL INSTRUCTIONS AND INFORMATION

PRIME CONTRACTOR PRICING MODEL

DIRECTIONS

1.	Proposals must be submitted using this format. To save future proposal preparation time, customize this template by filling all elements that will stay the same and by making any formula changes necessary to accommodate your established accounting practices.
2.	Populate ONLY those cells highlighted yellow
3.	If applicable, modify appropriate formulas throughout workbook. Identify changes by highlighting all changed cells YELLOW, document all changes in space provided on Contractor Data Input worksheet.	CLICK HERE FOR CONTRACTOR DATA INPUT
4.	Explain basis for direct & indirect rates in space provided on Contractor Data Input worksheet. Provide copies of most recent DCAA or DCMA correspondence documenting approval of indirect rates if not previously provided to contracting specialist.	CLICK HERE FOR CONTRACTOR DATA INPUT
5.	Assign Labor Hours to Subcontractors (if applicable) on TEAM HOURS worksheet.	CLICK HERE FOR TEAM HOURS
6.	Populate labor rates on RATES worksheet.	CLICK HERE FOR RATES
7.	If company job titles are different from those in the RFP, provide this information on the OTHER LABOR DATA sheet.	CLICK HERE FOR OTHER LABOR DATA
8.	If direct labor rates are calculated by using other than 2,080 hours per year, document number of hours per year used to calculate hourly rate for each labor category on OTHER LABOR DATA sheet.	CLICK HERE FOR OTHER LABOR DATA
9.	IMPORTANT: If changing formulas to incorporate rates calculated on an outside spreadsheet, add that spreadsheet to Pricing Model.
10.	Provide all subcontractors with copy of Subcontractor Pricing Model for Task Orders.
11.	Provide information to the subcontractors regarding the labor categories and hours required for each task order.
12.	Transmit entire Pricing Model in EXCEL format (complete with active formulas) along with supporting narrative to Government in accordance with RFP instructions.
13	Fee is not applicable to any ODC (travel, material etc.) on this effort.
HELPFUL HINTS & REMINDERS
1.	Be sure to change overhead formulas on RATES worksheet if application base differentiates from Government assumption.
2.	Notify the contracting specialist if there are any questions or problems relating to Pricing Model.
3.	Provide copies of correspondence from DCAA or DCMA regarding the most recent approval of your rates and systems, such as Forward Pricing Rate Agreements (FPRAs), Forward Pricing Rate Recommendations (FPRRs), Provisional Billing Rates (PBRs), and Accounting System Approval. These should be provided each time the rates change or approvals are updated. If proposing direct labor rates based on salary survey data, provide a screen shot of the salary data information used to assist in evaluating your proposal.

&"Times New Roman,Regular"&F &"Times New Roman,Regular"&A &"Times New Roman,Regular"&P of &N

CONTRACTOR DATA INPUT

SECTION 1 - Header Information

Contractor Name:

Contractor Proposal #:

Proposal Date:

Valid until:

	SECTION 2 - Loading Factors		BASE	OPTION
1	OPTION
2	OPTION
3	OPTION
4	6 MONTH OPTION	Allocation Base

CLICK HERE FOR TEAM HOURS WORKSHEET

CLICK HERE FOR RATES WORKSHEET

Labor Escalation - PRO	N/A	0.00%	0.00%	0.00%	0.00%	0.00%
Labor Escalation - SCA	N/A	0.00%	0.00%	0.00%	0.00%	0.00%

	FRINGE		BASE	OPTION
1	OPTION
2	OPTION
3	OPTION
4	6 MONTH OPTION	Allocation Base
	Professional		0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	Direct Labor
	SCA		0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	Direct Labor

	OVERHEAD		BASE	OPTION
1	OPTION
2	OPTION
3	OPTION
4	6 MONTH OPTION	Allocation Base
	Charleston, SC	Contractor	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	Direct Labor + Fringe
	Charleston, SC	Government	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	Direct Labor + Fringe

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	1.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

Contractor	0.00%	0.00%	0.00%	0.00%	0.00%
Government	0.00%	0.00%	0.00%	0.00%	0.00%

	G&A		BASE	OPTION
1	OPTION
2	OPTION
3	OPTION
4	6 MONTH OPTION	Allocation Base
	G&A Rate on Prime Labor		0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	Direct labor + Fringe + Overhead

G&A on Subcontractor Labor 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

G&A on Prime ODCs	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
G&A on Subcontractor ODCs	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%

M&S on Subcontractor Labor	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
M&S on Sub ODCs	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Other Loading Factors as Applicable	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Other Loading Factors as Applicable	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Other Loading Factors as Applicable	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%

Profit	0.00%
Profit - ALT

raymond.noble: Used if other rates are applicable. I.E. '7% on Direct labor and 3% on ODCs and Sub labor' You will need to change 'Summary' tabs to facilitate usage.

0.00%

Target Profit (Contract Rate)	0.00%
Profit (Contract Rate)	0.00%

CONTRACTOR CHANGES TO THE PRICING MODEL AND PROPOSAL EXPLANATIONS

SUMMARY

	CLICK HERE FOR INSTRUCTIONS WORKSHEET
Contract Number:	N65236-16-R-0018	TYPE OF ORDER
RFP Number:	XXXXXXXXX	CPFF:	CPFF
Task Name:	Business Financial Management Support

	FFP:	X	FFP
Contractor Name:			LOE:	LOE
Contractor Proposal #:			Completion:	Completion
Proposal Date:
Valid until:
SUMMARY- ALL CLINS

(Individual CLINS are listed below this table)

	LABOR	BASE YEAR
1	BASE YEAR
2	BASE YEAR
3	BASE YEAR
4	BASE YEAR
5	6 MONTH OPTION	TOTAL
	PRIME LABOR COST	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	PRIME LABOR HRs	9,844.0	-0	-0	-0	-0	-0	9,844.0
	SUBCONTRACTOR LABOR COSTS
	SUB #1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Sub # 1 Labor Hrs	-0	-0	-0	-0	-0	-0	-0
	SUB #2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Sub # 2 Labor Hrs	-0	-0	-0	-0	-0	-0	-0
	SUB #3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Sub # 3 Labor Hrs	-0	-0	-0	-0	-0	-0	-0
	SUB #4	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Sub # 4 Labor Hrs	-0	-0	-0	-0	-0	-0	-0
		-0
	SUBCONTRACTOR LABOR HOURS TOTAL:	-0	-0	-0	-0	-0	-0	-0
	SUBTOTAL SUBCONTRACTOR LABOR COSTS:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	PRIME G&A ON SUBCONTRACTOR LABOR:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	TOTAL PRIME & SUBCONTRACTOR LABOR:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	TOTAL PRIME & SUBCONTRACTOR LABOR HOURS:	9,844.0	-0	-0	-0	-0	-0	9,844.0
	ODCs	BASE YEAR
1	BASE YEAR
2	BASE YEAR
3	BASE YEAR
4	BASE YEAR
5	6 MONTH OPTION	TOTAL
	Travel	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Material	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Miscellaneous ODCs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

	SUBTOTAL PRIME ODCs:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	PRIME G&A on PRIME ODCs:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	PRIME TOTAL ODCs:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	ODCs - SUBCONTRACTORS	BASE YEAR
1	BASE YEAR
2	BASE YEAR
3	BASE YEAR
4	BASE YEAR
5	6 MONTH OPTION	TOTAL
	SUB #1 TOTAL:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Additonal ODC	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Additonal ODC	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	SUB #2 TOTAL:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Additonal ODC	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Additonal ODC	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	SUB #3 TOTAL:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Additonal ODC	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Additonal ODC	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	SUB #4 TOTAL:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Additonal ODC	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Additonal ODC	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	SUBTOTAL SUBCONTRACTOR ODCs:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	PRIME G&A ON SUBCONTRACTOR ODCs:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	TOTAL PRIME & SUBCONTRACTOR ODCs:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	OTHER BURDENS	BASE YEAR
1	BASE YEAR
2	BASE YEAR
3	BASE YEAR
4	BASE YEAR
5	6 MONTH OPTION	TOTAL
	Materials and Subcontracting