W911SA-15-R-0014_Attachment2_PriceSchedule.xlsx

XLSX spreadsheet 88 KB Posted Sep 23, 2015

Attached to: Task Order 1 -Logistics Readiness Support Services 63rd RSC
Solicitation number: W911SA15R0014
Issued by: Department of the Army Materiel Command Mission and Installation Contracting Command Fort McCoy

About this file

From the source

W911SA-15-R-0014 Attachment 2 Price Schedule

View the file

Other files

File	Type	Posted
W911SA-15-R-0014_Amendment_4.pdf	PDF	Jan 26, 2016
W911SA-15-R-0014_Amendment_3_for_Wage_Determinations.pdf	PDF	Jan 22, 2016
W911SA-15-R-0014_Attachment_15_Wage_Determinations_(Revised).docx	DOCX document	Jan 22, 2016
W911SA-15-R-0014_Attachment_18_DD254_Part_2.pdf	PDF	Nov 13, 2015
W911SA-15-R-0014_Attachment_19_Questions_ _Answers_Part_2.xlsx	XLSX spreadsheet	Nov 13, 2015
W911SA-15-R-0014_Attachment_12_Exhibit_8_FHL-CBA.pdf	PDF	Nov 13, 2015
W911SA-15-R-0014_Attachment_17_DD254_Part_1.pdf	PDF	Nov 13, 2015
W911SA-15-R-0014_Attachment_16_Exhibit_10_CBA_Barstow.pdf	PDF	Nov 13, 2015
W911SA-15-R-0014_Solicitation_Most_Conformed_Copy.pdf	PDF	Nov 13, 2015
W911SA-15-R-0014_Attachment_2_Price_Schedule_11-12-2015.xlsx	XLSX spreadsheet	Nov 13, 2015
W911SA-15-R-0014_Amendment_2.pdf	PDF	Nov 13, 2015
W911SA-15-R-0014_Attachment2_PriceSchedule_10-5-2015).xlsx	XLSX spreadsheet	Oct 9, 2015
W911SA-15-R-0014_Attachment8_Exhibit4_Density_and_Workload_(10-5-15).xlsx	XLSX spreadsheet	Oct 9, 2015
W911SA-15-R-0014-SOL-MostConformedCopy.pdf	PDF	Oct 9, 2015
W911SA-15-R-0014_Attachment8_Exhibit4_Density_and_Workload_(10-5-15).xlsx	XLSX spreadsheet	Oct 9, 2015
W911SA-15-R-0014_Attachment2_PriceSchedule_10-5-2015).xlsx	XLSX spreadsheet	Oct 9, 2015
W911SA-15-R-0014-Amendment-1.pdf	PDF	Oct 9, 2015
W911SA-15-R-0014_Attachment9_Exhibit5_HandsOnTrainingCourse.xlsx	XLSX spreadsheet	Sep 23, 2015
W911SA-15-R-0014_Attachment15_Wage_Determination.docx	DOCX document	Sep 23, 2015
W911SA-15-R-0014_Attachment6_Exhibit2b_Deliverables.docx	DOCX document	Sep 23, 2015
W911SA-15-R-0014_Attachment4_Exhibit1b_PRStable.xlsx	XLSX spreadsheet	Sep 23, 2015
W911SA-15-R-0014_Attachment10_Exhibit6_WorksiteLocations.xlsx	XLSX spreadsheet	Sep 23, 2015
W911SA-15-R-0014_Attachment14_Exhibit10_ContractedEmployeesSHARPInfo.pdf	PDF	Sep 23, 2015
W911SA-15-R-0014_Attachment5_Exhibit2a_CDRL.xlsx	XLSX spreadsheet	Sep 23, 2015
W911SA-15-R-0014_Attachment1_ATOPSEC.pdf	PDF	Sep 23, 2015
W911SA-15-R-0014_Attachment12_Exhibit8_FHL-CBA.pdf	PDF	Sep 23, 2015
W911SA-15-R-0014_Attachment13_Exhibit9_GeneralCBA.pdf	PDF	Sep 23, 2015
W911SA-15-R-0014_Solicitation.docx	DOCX document	Sep 23, 2015
W911SA-15-R-0014_Attachment11_Exhibit7_Equipment.xlsx	XLSX spreadsheet	Sep 23, 2015
W911SA-15-R-0014_Attachment8_Exhibit4_Density_and_Workload.xlsx	XLSX spreadsheet	Sep 23, 2015
W911SA-15-R-0014_Attachment3_Exhibit1a_PRSDescription.docx	DOCX document	Sep 23, 2015
W911SA-15-R-0014_Attachment7_Exhibit3_WorkloadEstimates.docx	DOCX document	Sep 23, 2015

Show all 32

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.

Directions

DIRECTIONS FOR SOLICITATION W911SA-15-R-0014 - ATTACHMENT 2 PRICE SCHEDULE

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 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 cost reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases

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 Technical Exhibit 1-1 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 TMP CBA (1 Jan - 30 Sep 13)
																	4.10%	0.60%	$3.68	$6.15	4.34+.50=4.84 TMP CBA (1 Oct - Dec 13)			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/1927,3)	N15*2080	O15*K15	ROUND(IF(P15<110100,P150.062,1101000.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 CENTRAL ISSUE FACILITY (CIF)
CLIN 0001AA: CIF 01 Oct - 31 Mar
0001AA	C.5.2.1	CIF Operation	01-A to 01-D	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	$3.24	$52.37	$928.48	$46.42	$974.90
0001AA	C.5.2.2	Shipping and Receiving Equipment	02-A to 02-D	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	$0.46	$7.46	$132.33	$6.62	$138.95
TOTAL CLIN 0001AA CIF 01 Oct - 31 Mar												46.00	0.02	49.92	713.11	54.55	12.79	1.01	26.24	4.39	7.42	185.20	997.28	3.70	59.83	1060.81	53.04	1113.85
TOTAL CLIN 0001 CENTRAL ISSUE FACILITY												46.00	0.02	49.92	713.11	54.55	12.79	1.01	26.24	4.39	7.42	185.20	997.28	3.70	59.83	1060.81	53.04	1113.85

BASE PERIOD

ATTACHMENT 3: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support - 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 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 cost reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases

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/1880,3)	N15*2080	O15*K15	ROUND(IF(P15<110100,P150.062,1101000.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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

CLIN 0002 TRAVEL (COST REIMBURABLE)	$200,000.00
CLIN 0003 MATERIALS (COST REIMBURABLE)	$150,000.00
CLIN 0004 CONTRACTOR MANPOWER REPORTING
CLIN 0005 PHASE-IN
TOTAL - BASE PERIOD	$350,000.00

For Official Use only

OPT PERIOD 1

ATTACHMENT 3: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support - OPTION 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 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 cost reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases

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/1880,3)	N15*2080	O15*K15	ROUND(IF(P15<110100,P150.062,1101000.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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
CLIN 1002 TRAVEL (COST REIMBURSABLE)																												$207,000.00
CLIN 1003 MATERIALS (COST REIMBURSABLE)																												$155,250.00
CLIN 1004 CONTRACTOR MANPOWER REPORTING
TOTAL - OPTION PERIOD 1																												$362,250.00

OPT PERIOD 2

ATTACHMENT 3: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support - OPTION 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 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 cost reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases

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/1880,3)	N15*2080	O15*K15	ROUND(IF(P15<110100,P150.062,1101000.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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
CLIN 2002 TRAVEL (COST REIMBURSABLE)																												$207,000.00
CLIN 2003 MATERIALS (COST REIMBURSABLE)																												$155,250.00
CLIN 2004 CONTRACTOR MANPOWER REPORTING
TOTAL - OPTION PERIOD 2																												$362,250.00

OPT PERIOD 3

ATTACHMENT 3: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support - OPTION 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 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 cost reimbursable items; the only reimbursable material authorized is material related in support of PWS Contractor Reimbursable Purchases

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/1880,3)	N15*2080	O15*K15	ROUND(IF(P15<110100,P150.062,1101000.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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
CLIN 3002 TRAVEL (COST REIMBURSABLE)																												$207,000.00
CLIN 3003 MATERIALS (COST REIMBURSABLE)																												$155,250.00
CLIN 3004 CONTRACTOR MANPOWER REPORTING

CLIN 3005 PHASE-OUT
TOTAL - OPTION PERIOD 3	$362,250.00

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