CYPC_Price_Model.xlsx

XLSX spreadsheet 38 KB Posted Mar 13, 2018

Attached to: CHILD YOUTH PROGRAM COORDINATION SERVICES -FINAL SOLICITATION
Solicitation number: W9133L-18-R-0001
Issued by: Department of the Army National Guard

About this file

From the source

The purpose of this mod is to add the CYPC price model that was included with the draft solicitation however, it was erroneously left out of the final solicitation.

View the file

Other files

File	Type	Posted
W9133L-18-R-0001_amendment_1.pdf	PDF	Mar 9, 2018
Response_to_CYPC_Questions_7_Mar_2018.pdf	PDF	Mar 9, 2018
CYPC_PPQ.docx	DOCX document	Mar 1, 2018
ATTACHMENT_M_-_Monthly_Training_Tracker_Updated_29JAN18.xlsx	XLSX spreadsheet	Mar 1, 2018
ATTACHMENT_H_-_SAMPLE_TRAVEL_EXPENSE_SPREADSHEET.xlsx	XLSX spreadsheet	Mar 1, 2018
ATTACHMENT_A_-_Service_Location_Matrix_Updated_29JAN18.xlsx	XLSX spreadsheet	Mar 1, 2018
ATTACHMENT_F_-_Quarterly_Report_Template.xlsx	XLSX spreadsheet	Mar 1, 2018
ATTACHMENT_E_-_Monthly_Report_Template.xlsx	XLSX spreadsheet	Mar 1, 2018
W9133L-18-R-0001_Solicitation.pdf	PDF	Feb 26, 2018
ATTACHMENT_D-_ARNG_CYSS_SOP_-_04.28.17.pdf	PDF	Feb 23, 2018
ATTACHMENT_C_-_CYSS_Training_-_15MAR17.pdf	PDF	Feb 23, 2018
ATTACHMENT_F_-_Quarterly_Report_Template.xlsx	XLSX spreadsheet	Feb 23, 2018
ATTACHMENT_H_-_SAMPLE_TRAVEL_EXPENSE_SPREADSHEET.xlsx	XLSX spreadsheet	Feb 23, 2018
ATTACHMENT_A_-_Service_Location_Matrix_Updated_29JAN18.xlsx	XLSX spreadsheet	Feb 23, 2018
ATTACHMENT_K_-MONTHLY_PROGRAM_STATUS_EXAMPLE.pdf	PDF	Feb 23, 2018
ATTACHMENT_M_-_Monthly_Training_Tracker_Updated_29JAN18.xlsx	XLSX spreadsheet	Feb 23, 2018
W9133L-18-R-0001.pdf	PDF	Feb 23, 2018
ATTACHMENT_I_-_Teen_Resilience_Program_MOI_15_August_2015.pdf	PDF	Feb 23, 2018
ATTACHMENT_B_-_Youth_Leadership_Forum_Handbook.pdf	PDF	Feb 23, 2018
ATTACHMENT_G_-_CYSS_Annual_Report_Instructions_&_National-Level_Report_example.pdf	PDF	Feb 23, 2018
ATTACHMENT_E_-_Monthly_Report_Template.xlsx	XLSX spreadsheet	Feb 23, 2018
ATTACHMENT_L_-_CRITICAL_PERSONNEL_ACTION_REPORT_Example.pdf	PDF	Feb 23, 2018
ATTACHMENT_J_-_SAMPLE_QUARTERLY_STATUS_REPORT.pdf	PDF	Feb 23, 2018

Show all 23

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.

I.a.1 - Final Pricing

Child Youth Services (CYS)

CLIN Type	Description	TO CLIN	QTY	Unit of Measure	Extended Price
FFP	Child Youth Services (CYS) - Base Year	0001	1	JOB	$ - 0
COST	Travel	0002	1	JOB	$725,000.00
FFP	Contractor Manapower Reporting (CMRA)	0003	1	EA	NSP
FFP	Child Youth Services (CYS) - 1st Option Year	1001	1	JOB	$ - 0
COST	Travel - 1st Option Year	1002	1	JOB	$725,000.00
FFP	Contractor Manapower Reporting (CMRA)	1003	1	EA	NSP
FFP	Child Youth Services (CYS) - 2nd Option Year	2001	1	JOB	$ - 0
COST	Travel - 2nd Option Year	2002	1	JOB	$725,000.00
FFP	Contractor Manapower Reporting (CMRA)	2003	1	EA	NSP
FFP	Child Youth Services (CYS) - 3rd Option Year	3001	1	JOB	$ - 0
COST	Travel - 3rd Option Year	3002	1	JOB	$725,000.00
FFP	Contractor Manapower Reporting (CMRA)	3003	1	EA	NSP
FFP	Child Youth Services (CYS) - 4th Option Year	4001	1	JOB	$ - 0
COST	Travel - 4th Option Year	4002	1	JOB	$725,000.00
FFP	Contractor Manapower Reporting (CMRA)	4003	1	EA	NSP
Note 1: This woksheet will be populated based on rates and quantities entered into the Pricing Detail Worksheets.

Note 2: Travel Estimates reflect Government estimates at the time of solicitation. Based upon actual burn rates during the previous year, the option year travel amounts may increase/decrease.

Note 3: Contractor may, on a monthly basis, invoice the lesser of 1/12 the CLIN price or that amount minus any equitable reduction in contract price due in accordance FAR 52.246-4 -- Inspection of Services -- Fixed-Price for CLINs 0001, 1001, 2001, 3001 and 4001.

Note 4: Although Contractor Manpower Reporting is listed as "Not Seperately Priced - NSP", any offeror may propose a price if desired. Any offeror not spearately pricing this line will leave the NSP as shown.

Base Period	$725,000.00
		Option Year 1	$725,000.00
		Option Year 2	$725,000.00
		Option Year 3	$725,000.00
		Option Year 4	$725,000.00
		Total Evaluated Price	$3,625,000.00

I.a.2 - Pricing Detail - Base Child Youth Services (CYS) - Base Year Pricing Worksheet

		CLIN
Labor Category	Proposed Personnel	0001
		CYPC Services
		Rate	Hours	Price
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
		Total Price:		$ - 0

I.a.3 - Pricing Detail - OY1 Child Youth Services (CYS) - 1st Option Year Pricing Worksheet

		CLIN
Labor Category	Proposed Personnel	1001
		CYS Services
		Rate	Hours	Price
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
		Total Price:		$ - 0

I.a.4 - Pricing Detail - OY2 Child Youth Services (CYS) - 2nd Option Year Pricing Worksheet

		CLIN
Labor Category	Proposed Personnel	2001
		ARIP Program Services
		Rate	Hours	Price
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
		Total Price:		$ - 0

I.a.5 - Pricing Detail - OY3 Child Youth Services (CYS) - 3rd Option Year Pricing Worksheet

		CLIN
Labor Category	Proposed Personnel	3001
		Child Youth Services
		Rate	Hours	Price
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
		Total Price:		$ - 0

I.a.6 - Pricing Detail - OY4 Child Youth Services (CYS) - 4th Option Year Pricing Worksheet

		CLIN
Labor Category	Proposed Personnel	4001
		Child Youth Services
		Rate	Hours	Price
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
				$ - 0
		Total Price:		$ - 0

I.a.7 - Rate Buildup Child Youth Services (CYS) Rate Buildup Worksheet

	Year
	Base	Option Period 1	Option Period 2	Option Period 3	Option Period 4
Rates:		Escalation:	Escalation:	Escalation:	Escalation:
	Fringe	Fringe:	Fringe:	Fringe:	Fringe:
	Labor O/H	Labor O/H:	Labor O/H:	Labor O/H:	Labor O/H:
	G&A	G&A:	G&A:	G&A:	G&A:
	Profit	Profit:	Profit:	Profit:	Profit:

Base Year Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option Period 1 Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option Period 2 Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option Period 3 Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option Period 4 Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

File details come from the government source that posted it.