Attachment_2_Price_Schedule_63d_RSC_Logistical_Support_CA_Region.xlsx

XLSX spreadsheet 65 KB Posted Dec 6, 2017

Attached to: Logistics Readiness Support Services for 63rd RSC in CA and NV
Solicitation number: W911SA-17-R-3000
Issued by: Department of the Army Materiel Command Mission and Installation Contracting Command Fort McCoy

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains a price schedule template for a federal contract solicitation to provide logistics readiness support services for the 63rd Regional Support Command in California and Nevada. The price schedule template includes formulas for vendors to populate with labor categories, hourly wage rates, man hours, overhead rates, and pricing for the base period and four option years. Vendors are instructed not to modify the embedded formulas and to include any positions requiring wage rates not covered by the applicable wage determination. The related federal contract opportunity notice identifies the solicitation as amendment 10 to provide logistics readiness support services for the 63rd Regional Support Command, with an updated wage determination posted on January 16, 2018. The soliciting agency is identified as the Department of the Army Materiel Command Mission and Installation Contracting Command at Fort McCoy.

From the source

Attachment 2 Price Schedule 63d RSC Logistical Support CA Region

View the file

Other files

File	Type	Posted
W911SA-17-R-3000_0010_Amendment_10.docx	DOCX document	Jan 17, 2018
Attachment_7_Wage_Determinations_Full_length_20180117.docx	DOCX document	Jan 17, 2018
W911SA-17-R-3000_0009_Amendment_9.docx	DOCX document	Jan 3, 2018
Attachment_7_Wage_Determinations_Full_length_20180103.docx	DOCX document	Jan 3, 2018
Attachment_16_W911SA17R3000_Government_Responses_to_Additional_Questions_updated_20171211.xlsx	XLSX spreadsheet	Dec 11, 2017
W911SA-17-R-3000_0008_Conformed_Solicitation.docx	DOCX document	Dec 11, 2017
W911SA-17-R-3000_0008_Amendment_8.docx	DOCX document	Dec 11, 2017
Attachment_16_W911SA17R3000_Government_Responses_to_Additional_Questions.xlsx	XLSX spreadsheet	Dec 6, 2017
W911SA-17-R-3000_0007_Conformed_Copy_Solicitation.docx	DOCX document	Dec 6, 2017
W911SA-17-R-3000_0007_Amendment_7.docx	DOCX document	Dec 6, 2017
W911SA-17-R-3000_0006_Amendment_6.docx	DOCX document	Dec 5, 2017
W911SA-17-R-3000_0006_Conformed_Solicitation.docx	DOCX document	Dec 5, 2017
Attachment_12_Density_and_Workload_CA_Region_(002).pdf	PDF	Dec 5, 2017
Attachment_7_Wage_Determinations_Full_length_20171204.docx	DOCX document	Dec 5, 2017
Attachment_11_CA.pdf	PDF	Nov 21, 2017
Attachment_12_Density_and_Workload_CA_Region.pdf	PDF	Nov 21, 2017
Attachment_6_Mission-Essential-Contractor-Services-Jul-2017.docx	DOCX document	Nov 21, 2017
Attachment_3_PRS_DOL_Maintenance_20170815.docx	DOCX document	Nov 21, 2017
W911SA-17-R-3000-0005_Amendment_5.docx	DOCX document	Nov 21, 2017
Attachment_13_W911SA17R3000_Government_Responses_to_Questions.xlsx	XLSX spreadsheet	Nov 21, 2017
Attachment_4_Deliverables_CA_Region.docx	DOCX document	Nov 21, 2017
Attachment_2_Price_Schedule_63d_RSC_Logistical_Support_CA_Region.xlsx	XLSX spreadsheet	Nov 21, 2017
W911SA-17-R-3000-0005_Conformed_Copy_of_Solicitation.docx	DOCX document	Nov 21, 2017
Attachment_9_Worksite_Locations_CA_Region.pdf	PDF	Nov 21, 2017
Attachment_15_REVISED_Newest_Ft._Hunter_Liggett_CA_Signed_CBA_Final.pdf	PDF	Nov 21, 2017
W911SA-17-R-3000-0004_Amendment_4.docx	DOCX document	Nov 14, 2017
W911SA-17-R-3000-00003_Amendment_3.docx	DOCX document	Oct 30, 2017
W911SA-17-R-3000-00002_Amendment_2.docx	DOCX document	Oct 20, 2017
W911SA-17-R-3000-00001_Amendment_1.docx	DOCX document	Oct 10, 2017
Attachment_3_PRS_DOL_Maintenance_20170815.docx	DOCX document	Sep 11, 2017
Attachment_1_AT-OPSEC_63d_RSC_Logistical_Support_CA_Region.pdf	PDF	Sep 11, 2017
Attachment_12_Density_and_Workload_CA_Region_Revised_20170621.pdf	PDF	Sep 11, 2017
Attachment_8_Contracted_Employees_SHARP_Info_CA_Region.pdf	PDF	Sep 11, 2017
Attachment_7_Wage_Determinations_Full_length_20170911.docx	DOCX document	Sep 11, 2017
Attachment_9_Worksite_Locations_CA_Region_Revised_20170623.pdf	PDF	Sep 11, 2017
Attachment_15_CBA_Fort_Hunter_Liggett_CA_Region.pdf	PDF	Sep 11, 2017
Attachment_10_Equipment_California_Region.pdf	PDF	Sep 11, 2017
Attachment_5_Past_performance_Attachment_Samples.docx	DOCX document	Sep 11, 2017
Attachment_4_Deliverables_CA_Region.docx	DOCX document	Sep 11, 2017
Attachment_2_Price_Schedule_63d_RSC_Logistical_Support_CA_Region.xlsx	XLSX spreadsheet	Sep 11, 2017
W911SA-17-R-3000_SOLICITATION.docx	DOCX document	Sep 11, 2017
Attachment_6_Mission-Essential-Contractor-Services-Jul-2017.docx	DOCX document	Sep 11, 2017
Attachment_11_63rd_RSC_DOL_Equipment_Time_Standards_CA..pdf	PDF	Sep 11, 2017
Attachment_14_CBA_Barstow_CA_Region.pdf	PDF	Sep 11, 2017

Show all 44

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.

NEW DIRECTIONS

DO NOT change any of the formulas embedded within these spreadsheets. If formulas must be changed please provide a detailed explanation as to why the formula was changed.							THE DOLLAR VALUES , OTHER NUMBERS AND INFORMATION GIVEN IN THE SPREADSHEET BELOW ARE SHOWN FOR SAMPLE PURPOSES ONLY! THE FORMULAS USED ARE NOT SAMPLES AND CANNOT BE CHANGED.
Transfer cost data to the appropriate section of the price schedule.
The number of lines included for CLIN X001 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X002 and X003 are plug numbers for reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases
Contractors are to identify any positions proposed that are not included in the wage determination in the "type" column of the spreadsheet. Theses pay rates shall be calculated in accordance with the DOL rules.
A. Identify CLIN Number	B. Identify PWS Paragraph Number(s)	C. Identify Paragraph Title	D. Identify PRS Number(s)	E. Identify job classification in accordance with SCA.	F. Identify Organizational Chart Position Number	G. Identify Occupation Code in accordance with SCA and CBA.	H. Identify Workload indicator	I. Identify Attachment 12 Historical Workload	J. Identify Type (SCA, Exempt, or CBA)	K. Identify Total Hourly Wage	L. Identify time per task in standard man hours.	M. Calculate total man hours using the formula provided.	N. Calculate FTE's using the formula provided.	O. Calculate total hours using the formula provided.	P. Calculate total base wages or material using the formula provided.	Q. Calculate FICA using the formula provided.	R. Calculate SUI using the formula provided. Vendor will need to put in the dollar amount in cells R13 and R14	S. Calculate FUI using the formula provided. Vendor will need to fill in cells S13 and S14	T. Calculate WC using the formula provided. Vendor will need to fill in cell T14	U. Calculate GL/UMB using the formula provided. Vendor will need to fill in cell U14	V. Identify the appropriate dollar amount for health & welfare. Fill in the dollar value for Exempt and SCA in cell V11.	W. Calculate total health and welfare using the formula provided.	X. Calculate Direct Labor before G&A using the formula provided.	Y. Identify overhead rate. Vendor is to provide a description of what is included in the overhead rate. Project Management costs should be included with Overhead.	Z Calculate G&A using the formula provided. Vendor will need to fill in cell Y13 - not referencing DCAA Audit for G&A rates should be submitted with pricing piece of package	Z. Calculate the total estimate cost using the formula provided.	AA. Calculate profit using the formula provided. Vendor will need to fill in cell AA14	AB. Calculate total CLIN cost using the formula provided.
																					3.71 Exempt and SCA
																	$13,000.00	$7,000.00			4.07+.40=4.47 CBA (DATE - DATE)
																	4.10%	0.60%	$3.68	$6.15	4.34+.50=4.84 CBA (DATE - DATE)			2.00%	6.00%		5.00%
CLIN Number	PWS Para #	Paragraph Title	PRS #	Job Classification	Org Chart Position Number	Occupation Code (SCA & CBA)	Workload Indicator	TE 3 Historical WL	Type	Total Hourly Wage	Time Per Task in Man Hours (Standard)	Total Man Hours	FTE's	Total Hours	Total Base Wages or Material	FICA	SUI per FTE	FUI per FTE	WC	GL/UMB	Health & Welfare	HEALTH & WELFARE TOTAL	DIRECT LABOR (Before G&A)	Overhead	G&A	Total Estimated Cost	Profit	TOTAL CLIN COST
												I15*L15	ROUND(M15/1920,3)	N15*2080	O15*K15	ROUND(IF(P15<118500,P150.062,1185000.062),2)+(ROUND((P15*0.0145),2))	R$12R$13N15	S$12S$13N15	T$13*P15/100	P15/1000*U$13		V15*O15	ROUND(SUM(P15:U15,W15),2)	ROUND(Y$13*X15,2)	ROUND(Z$13*X15,2)	ROUND(SUM(X15:Z15),2)	ROUND(AB$13*AA15,2)	ROUND(SUM(AA15:AB15),2)
CLIN 0001 ECS XX
CLIN 0001:
0001AA	C.5.2.1	CIF Operation	7	Warehouse Specialist		21410	# of inventories	1.00	SCA	$14.29	40.0000	40.00	0.021	43.680	$624.19	$47.75	$11.19	$0.88	$22.97	$3.84	$3.71	$162.05	$872.87	$17.46	$52.37	$942.70	$47.14	$989.84
0001AA	C.5.2.2	Shipping and Receiving Equipment	7	General Clerk III		01113	# of pieces of equipment shipped and received using FEDLOG Unit of Issue	2000.00	SCA	$14.25	0.0030	6.00	0.003	6.240	$88.92	$6.80	$1.60	$0.13	$3.27	$0.55	$3.71	$23.15	$124.41	$2.49	$7.46	$134.36	$6.72	$141.08
TOTAL CLIN 0001												46.00	0.02	49.92	713.11	54.55	12.79	1.01	26.24	4.39	7.42	185.20	997.28	19.95	59.83	1077.06	53.86	1130.92
TOTAL CLIN 0001 ECS XX												46.00	0.02	49.92	713.11	54.55	12.79	1.01	26.24	4.39	7.42	185.20	997.28	19.95	59.83	1077.06	53.86	1130.92

BASE PERIOD

ATTACHMENT 2: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support CA Region- BASE PERIOD

Directions:	ITEMS HIGHLIGHTED IN PINK ARE ITEMS THE VENDOR MUST FILL IN!
Itemize your projected costs in each Contract Line Item Number (CLIN) area.
Calculate cost times the number of estimated quantities required.	FORMULA'S SHOW IN GREEN IN EACH COLUMN ARE REPRESENTATIVE OF THE FORUMLA(S) EMBEDDED IN THAT COLUMN.
The positions are to be listed as one job classification per line within each CLIN listed below. If you need to add additional job classifications, insert another line in the appropriate CLIN below. Do not combine personnel or hours. One line is one job classification.
DO NOT change any of the formulas embedded within these spreadsheets. If formulas must be changed please provide a detailed explanation as to why the formula was changed.	THE DOLLAR VALUES , OTHER NUMBERS AND INFORMATION GIVEN IN THE SPREADSHEET BELOW ARE SHOWN FOR SAMPLE PURPOSES ONLY! THE FORMULAS USED ARE NOT SAMPLES AND CANNOT BE CHANGED.
Transfer cost data to the appropriate section of the price schedule.
The number of lines included for CLINs X001, X0005, and X009 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X013 and X014 are plug numbers for reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases
Contractors are to identify any positions proposed that are not included in the wage determination in the "type" column of the spreadsheet. Theses pay rates shall be calculated in accordance with the DOL rules.

CLIN Number	PWS Para #	Paragraph Title	PRS #	Job Classification	Org Chart Position Number	Occupation Code (SCA & CBA)	Workload Indicator	Attachment 12 Historical Workload	Type	Total Hourly Wage	Time Per Task in Man Hours (Standard)	Total Man Hours	FTE's	Total Hours	Total Base Wages or Material	FICA	SUI per FTE	FUI per FTE	WC	GL/UMB	Health & Welfare	HEALTH & WELFARE TOTAL	DIRECT LABOR (Before G&A)	Overhead	G&A	Total Estimated Cost	Profit	TOTAL CLIN COST
												I15*L15	ROUND(M15/1920,3)	N15*2080	O15*K15	ROUND(IF(P15<118500,P150.062,1185000.062),2)+(ROUND((P15*0.0145),2))	R$12R$13N15	S$12S$13N15	T$13*P15/100	P15/1000*U$13		V15*O15	ROUND(SUM(P15:U15,W15),2)	ROUND(Y$13*X15,2)	ROUND(Z$13*X15,2)	ROUND(SUM(X15:Z15),2)	ROUND(AB$13*AA15,2)	ROUND(SUM(AA15:AB15),2)
CLIN 0001
0001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 0001												$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	$0.00
CLIN 0003	$0.00
CLIN 0004	$0.00

CLIN 0005
0005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 0005	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0006	$0.00
CLIN 0007	$0.00
CLIN 0008	$0.00

CLIN 0009
0009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 0009	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0010	$0.00
CLIN 0011	$0.00
CLIN 0012	$0.00

CLIN 0013 TRAVEL	$50,000.00
CLIN 0014 MATERIALS	$10,000.00
CLIN 0015 CONTRACTOR MANPOWER REPORTING
CLIN 0016 Project Management

CLIN 0017 COCO FACILITY

CLIN 0018 PHASE-IN
TOTAL - BASE PERIOD	$60,000.00

For Official Use only

OPT PERIOD 1

ATTACHMENT 2: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support CA Region- OPT PERIOD 1

Directions:	ITEMS HIGHLIGHTED IN PINK ARE ITEMS THE VENDOR MUST FILL IN!
Itemize your projected costs in each Contract Line Item Number (CLIN) area.
Calculate cost times the number of estimated quantities required.	FORMULA'S SHOW IN GREEN IN EACH COLUMN ARE REPRESENTATIVE OF THE FORUMLA(S) EMBEDDED IN THAT COLUMN.
The positions are to be listed as one job classification per line within each CLIN listed below. If you need to add additional job classifications, insert another line in the appropriate CLIN below. Do not combine personnel or hours. One line is one job classification.
DO NOT change any of the formulas embedded within these spreadsheets. If formulas must be changed please provide a detailed explanation as to why the formula was changed.	THE DOLLAR VALUES , OTHER NUMBERS AND INFORMATION GIVEN IN THE SPREADSHEET BELOW ARE SHOWN FOR SAMPLE PURPOSES ONLY! THE FORMULAS USED ARE NOT SAMPLES AND CANNOT BE CHANGED.
Transfer cost data to the appropriate section of the price schedule.
The number of lines included for CLINs X001, X0005, and X009 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X013 and X014 are plug numbers for reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases
Contractors are to identify any positions proposed that are not included in the wage determination in the "type" column of the spreadsheet. Theses pay rates shall be calculated in accordance with the DOL rules.

CLIN Number	PWS Para #	Paragraph Title	PRS #	Job Classification	Org Chart Position Number	Occupation Code (SCA & CBA)	Workload Indicator	Attachment 12 Historical Workload	Type	Total Hourly Wage	Time Per Task in Man Hours (Standard)	Total Man Hours	FTE's	Total Hours	Total Base Wages or Material	FICA	SUI per FTE	FUI per FTE	WC	GL/UMB	Health & Welfare	HEALTH & WELFARE TOTAL	DIRECT LABOR (Before G&A)	Overhead	G&A	Total Estimated Cost	Profit	TOTAL CLIN COST
												I15*L15	ROUND(M15/1920,3)	N15*2080	O15*K15	ROUND(IF(P15<118500,P150.062,1185000.062),2)+(ROUND((P15*0.0145),2))	R$12R$13N15	S$12S$13N15	T$13*P15/100	P15/1000*U$13		V15*O15	ROUND(SUM(P15:U15,W15),2)	ROUND(Y$13*X15,2)	ROUND(Z$13*X15,2)	ROUND(SUM(X15:Z15),2)	ROUND(AB$13*AA15,2)	ROUND(SUM(AA15:AB15),2)
CLIN 1001
1001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 1001												$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 1002	$0.00
CLIN 1003	$0.00
CLIN 1004	$0.00

CLIN 1005
1005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 1005	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 1006	$0.00
CLIN 1007	$0.00
CLIN 1008	$0.00

CLIN 1009
1009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 1009	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 1010	$0.00
CLIN 1011	$0.00
CLIN 1012	$0.00

CLIN 1013 TRAVEL	$50,000.00
CLIN 1014 MATERIALS	$10,000.00
CLIN 1015 CONTRACTOR MANPOWER REPORTING

CLIN 1016 Project Management

CLIN 1017 COCO Facility
TOTAL - OPT PERIOD 1	$60,000.00

For Official Use only

OPT PERIOD2

ATTACHMENT 2: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support CA Region- OPT PERIOD 2

Directions:	ITEMS HIGHLIGHTED IN PINK ARE ITEMS THE VENDOR MUST FILL IN!
Itemize your projected costs in each Contract Line Item Number (CLIN) area.
Calculate cost times the number of estimated quantities required.	FORMULA'S SHOW IN GREEN IN EACH COLUMN ARE REPRESENTATIVE OF THE FORUMLA(S) EMBEDDED IN THAT COLUMN.
The positions are to be listed as one job classification per line within each CLIN listed below. If you need to add additional job classifications, insert another line in the appropriate CLIN below. Do not combine personnel or hours. One line is one job classification.
DO NOT change any of the formulas embedded within these spreadsheets. If formulas must be changed please provide a detailed explanation as to why the formula was changed.	THE DOLLAR VALUES , OTHER NUMBERS AND INFORMATION GIVEN IN THE SPREADSHEET BELOW ARE SHOWN FOR SAMPLE PURPOSES ONLY! THE FORMULAS USED ARE NOT SAMPLES AND CANNOT BE CHANGED.
Transfer cost data to the appropriate section of the price schedule.
The number of lines included for CLINs X001, X0005, and X009 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X013 and X014 are plug numbers for reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases
Contractors are to identify any positions proposed that are not included in the wage determination in the "type" column of the spreadsheet. Theses pay rates shall be calculated in accordance with the DOL rules.

CLIN Number	PWS Para #	Paragraph Title	PRS #	Job Classification	Org Chart Position Number	Occupation Code (SCA & CBA)	Workload Indicator	Attachment 12 Historical Workload	Type	Total Hourly Wage	Time Per Task in Man Hours (Standard)	Total Man Hours	FTE's	Total Hours	Total Base Wages or Material	FICA	SUI per FTE	FUI per FTE	WC	GL/UMB	Health & Welfare	HEALTH & WELFARE TOTAL	DIRECT LABOR (Before G&A)	Overhead	G&A	Total Estimated Cost	Profit	TOTAL CLIN COST
												I15*L15	ROUND(M15/1920,3)	N15*2080	O15*K15	ROUND(IF(P15<118500,P150.062,1185000.062),2)+(ROUND((P15*0.0145),2))	R$12R$13N15	S$12S$13N15	T$13*P15/100	P15/1000*U$13		V15*O15	ROUND(SUM(P15:U15,W15),2)	ROUND(Y$13*X15,2)	ROUND(Z$13*X15,2)	ROUND(SUM(X15:Z15),2)	ROUND(AB$13*AA15,2)	ROUND(SUM(AA15:AB15),2)
CLIN 2001
2001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 2001												$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 2002	$0.00
CLIN 2003	$0.00
CLIN 2004	$0.00

CLIN 2005
2005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 2005	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 2006	$0.00
CLIN 2007	$0.00
CLIN 2008	$0.00

CLIN 2009
2009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 2009	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 2010	$0.00
CLIN 2011	$0.00
CLIN 2012	$0.00

CLIN 2013 TRAVEL	$50,000.00
CLIN 2014 MATERIALS	$10,000.00
CLIN 2015 CONTRACTOR MANPOWER REPORTING

CLIN 2016 Project Management

CLIN 2017 COCO Facility
TOTAL - OPT PERIOD 2	$60,000.00

For Official Use only

OPT PERIOD 3

ATTACHMENT 2: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support CA Region- OPT PERIOD 3

Directions:	ITEMS HIGHLIGHTED IN PINK ARE ITEMS THE VENDOR MUST FILL IN!
Itemize your projected costs in each Contract Line Item Number (CLIN) area.
Calculate cost times the number of estimated quantities required.	FORMULA'S SHOW IN GREEN IN EACH COLUMN ARE REPRESENTATIVE OF THE FORUMLA(S) EMBEDDED IN THAT COLUMN.
The positions are to be listed as one job classification per line within each CLIN listed below. If you need to add additional job classifications, insert another line in the appropriate CLIN below. Do not combine personnel or hours. One line is one job classification.
DO NOT change any of the formulas embedded within these spreadsheets. If formulas must be changed please provide a detailed explanation as to why the formula was changed.	THE DOLLAR VALUES , OTHER NUMBERS AND INFORMATION GIVEN IN THE SPREADSHEET BELOW ARE SHOWN FOR SAMPLE PURPOSES ONLY! THE FORMULAS USED ARE NOT SAMPLES AND CANNOT BE CHANGED.
Transfer cost data to the appropriate section of the price schedule.
The number of lines included for CLINs X001, X0005, and X009 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X013 and X014 are plug numbers for reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases
Contractors are to identify any positions proposed that are not included in the wage determination in the "type" column of the spreadsheet. Theses pay rates shall be calculated in accordance with the DOL rules.

CLIN Number	PWS Para #	Paragraph Title	PRS #	Job Classification	Org Chart Position Number	Occupation Code (SCA & CBA)	Workload Indicator	Attachment 12 Historical Workload	Type	Total Hourly Wage	Time Per Task in Man Hours (Standard)	Total Man Hours	FTE's	Total Hours	Total Base Wages or Material	FICA	SUI per FTE	FUI per FTE	WC	GL/UMB	Health & Welfare	HEALTH & WELFARE TOTAL	DIRECT LABOR (Before G&A)	Overhead	G&A	Total Estimated Cost	Profit	TOTAL CLIN COST
												I15*L15	ROUND(M15/1920,3)	N15*2080	O15*K15	ROUND(IF(P15<118500,P150.062,1185000.062),2)+(ROUND((P15*0.0145),2))	R$12R$13N15	S$12S$13N15	T$13*P15/100	P15/1000*U$13		V15*O15	ROUND(SUM(P15:U15,W15),2)	ROUND(Y$13*X15,2)	ROUND(Z$13*X15,2)	ROUND(SUM(X15:Z15),2)	ROUND(AB$13*AA15,2)	ROUND(SUM(AA15:AB15),2)
CLIN 3001
3001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 3001												$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 3002	$0.00
CLIN 3003	$0.00
CLIN 3004	$0.00

CLIN 3005
3005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 3005	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 3006	$0.00
CLIN 3007	$0.00
CLIN 3008	$0.00

CLIN 3009
3009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 3009	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 3010	$0.00
CLIN 3011	$0.00
CLIN 3012	$0.00

CLIN 3013 TRAVEL	$50,000.00
CLIN 3014 MATERIALS	$10,000.00
CLIN 3015 CONTRACTOR MANPOWER REPORTING

3016 Project Management

3017 COCO Facility
TOTAL - OPT PERIOD 3	$60,000.00

For Official Use only

OPT PERIOD 4

ATTACHMENT 2: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support CA Region- OPTION PERIOD 4

Directions:	ITEMS HIGHLIGHTED IN PINK ARE ITEMS THE VENDOR MUST FILL IN!
Itemize your projected costs in each Contract Line Item Number (CLIN) area.
Calculate cost times the number of estimated quantities required.	FORMULA'S SHOW IN GREEN IN EACH COLUMN ARE REPRESENTATIVE OF THE FORUMLA(S) EMBEDDED IN THAT COLUMN.
The positions are to be listed as one job classification per line within each CLIN listed below. If you need to add additional job classifications, insert another line in the appropriate CLIN below. Do not combine personnel or hours. One line is one job classification.
DO NOT change any of the formulas embedded within these spreadsheets. If formulas must be changed please provide a detailed explanation as to why the formula was changed.	THE DOLLAR VALUES , OTHER NUMBERS AND INFORMATION GIVEN IN THE SPREADSHEET BELOW ARE SHOWN FOR SAMPLE PURPOSES ONLY! THE FORMULAS USED ARE NOT SAMPLES AND CANNOT BE CHANGED.
Transfer cost data to the appropriate section of the price schedule.
The number of lines included for CLINs X001, X0005, and X009 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X013 and X014 are plug numbers for reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases
Contractors are to identify any positions proposed that are not included in the wage determination in the "type" column of the spreadsheet. Theses pay rates shall be calculated in accordance with the DOL rules.

CLIN Number	PWS Para #	Paragraph Title	PRS #	Job Classification	Org Chart Position Number	Occupation Code (SCA & CBA)	Workload Indicator	Attachment 12 Historical Workload	Type	Total Hourly Wage	Time Per Task in Man Hours (Standard)	Total Man Hours	FTE's	Total Hours	Total Base Wages or Material	FICA	SUI per FTE	FUI per FTE	WC	GL/UMB	Health & Welfare	HEALTH & WELFARE TOTAL	DIRECT LABOR (Before G&A)	Overhead	G&A	Total Estimated Cost	Profit	TOTAL CLIN COST
												I15*L15	ROUND(M15/1920,3)	N15*2080	O15*K15	ROUND(IF(P15<118500,P150.062,1185000.062),2)+(ROUND((P15*0.0145),2))	R$12R$13N15	S$12S$13N15	T$13*P15/100	P15/1000*U$13		V15*O15	ROUND(SUM(P15:U15,W15),2)	ROUND(Y$13*X15,2)	ROUND(Z$13*X15,2)	ROUND(SUM(X15:Z15),2)	ROUND(AB$13*AA15,2)	ROUND(SUM(AA15:AB15),2)
CLIN 4001
4001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4001												0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 4001												$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 4002	$0.00
CLIN 4003	$0.00
CLIN 4004	$0.00

CLIN 4005
4005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4005	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 4005	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 4006	$0.00
CLIN 4007	$0.00
CLIN 4008	$0.00

CLIN 4009
4009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4009	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL CLIN 4009	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 4010	$0.00
CLIN 4011	$0.00
CLIN 4012	$0.00

CLIN 4013 TRAVEL	$50,000.00
CLIN 4014 MATERIALS	$10,000.00
CLIN 4015 CONTRACTOR MANPOWER REPORTING
CLIN 4016 PROJECT MANAGEMENT

4017 COCO FACILITY

4018 PHASE-OUT
TOTAL - OPT PERIOD 4	$60,000.00

For Official Use only

File details come from the government source that posted it. Updated Dec 30, 2023.