Attachment_2_Price_Schedule_63d_RSC_Logistical_Support_TX_Region.xlsx

XLSX spreadsheet 72 KB Posted Sep 12, 2017

Attached to: Logistics Readiness Support Services 63rd RSC AZ, NM, OK, TX, AR
Solicitation number: W911SA-17-R-3001
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 to the 63rd Regional Support Command in five states. The template requires vendors to itemize projected costs by contract line item number for various support services, including identifying job classifications, total hourly wages, estimated hours and workload, overhead rates, and total estimated costs. Costs should be broken out by contract line item for functions like management, maintenance, transportation services, and material purchases. Vendors must also specify the wage determinations and collective bargaining agreements applicable to any positions and calculate various labor-related costs using embedded formulas. The price schedule aims to capture all associated costs to provide the logistics support services described in the related solicitation document.

From the source

Attachment 2 Price Schedule 63d RSC Logistical Support TX Region

View the file

Other files

File	Type	Posted
W911SA-17-R-3001_0009_Amendment_9.docx	DOCX document	Jan 17, 2018
REVISED_Attachment_7_Wage_Determinations_Full_Text_20180117.docx	DOCX document	Jan 17, 2018
W911SA-17-R-3001_0008_Amendment_8.docx	DOCX document	Jan 4, 2018
REVISED_Attachment_7_Wage_Determinations_Full_Text_20180103.docx	DOCX document	Jan 4, 2018
W911SA-17-R-3001_0007_Amendment_7.docx	DOCX document	Dec 11, 2017
Attachment_15_W911SA17R3001_Government_Responses_to_Additional_Questions_updated_20171211.xlsx	XLSX spreadsheet	Dec 11, 2017
W911SA-17-R-3001_0007_Conformed_Solicitation.docx	DOCX document	Dec 11, 2017
Attachment_2_REVISED_Price_Schedule_63d_RSC_Logistical_Support_TX_Region.xlsx	XLSX spreadsheet	Dec 6, 2017
W911SA-17-R-3001_0006_Conformed_Solicitation.docx	DOCX document	Dec 6, 2017
Attachment_12_REVISED_Density_and_Workload_Texas_Region_(003)_20171206.pdf	PDF	Dec 6, 2017
W911SA-17-R-3001_0006_Amendment_6.docx	DOCX document	Dec 6, 2017
Attachment_15_W911SA17R3001_Government_Responses_to_Additional_Questions.xlsx	XLSX spreadsheet	Dec 6, 2017
Attachment_13_W911SA17R3001_Government_Responses_to_Questions.xlsx	XLSX spreadsheet	Nov 20, 2017
W911SA-17-R-3001-0005_Amendment_5.docx	DOCX document	Nov 20, 2017
Attachment_6_REVISED_Mission-Essential-Contractor-Services-Jul-2017.docx	DOCX document	Nov 20, 2017
Attachment_12_REVISED_Density_and_Workload_Texas_Region.pdf	PDF	Nov 20, 2017
Attachment_2_REVISED_Price_Schedule_63d_RSC_Logistical_Support_TX_Region.xlsx	XLSX spreadsheet	Nov 20, 2017
Attachment_11_REVISED_TX.pdf	PDF	Nov 20, 2017
W911SA-17-R-3001-0005_Conformed_Copy_of_Solicitation.docx	DOCX document	Nov 20, 2017
Attachment_9_REVISED_Worksite_Locations_Texas_Region-1.pdf	PDF	Nov 20, 2017
Attachment_3_REVISED_PRS_DOL_Maintenance_20170815.docx	DOCX document	Nov 20, 2017
W911SA-17-R-3001_0004_Amendment_4.docx	DOCX document	Nov 14, 2017
W911SA-17-R-3001-00003_Amendment_3.docx	DOCX document	Oct 30, 2017
W911SA-17-R-3001-00002_Amendment_2.docx	DOCX document	Oct 20, 2017
W911SA-17-R-3001-00001_Amendment_1.docx	DOCX document	Oct 10, 2017
Attachment_6_Mission-Essential-Contractor-Services-Jul-2017.docx	DOCX document	Sep 12, 2017
Attachment_7_Wage_Determinations_Full_Text_Texas_Region_20170911.docx	DOCX document	Sep 12, 2017
Attachment_12_Density_and_Workload_Texas_Region.pdf	PDF	Sep 12, 2017
Attachment_10_Equipment_Texas_Region.pdf	PDF	Sep 12, 2017
Attachment_11_63rd_RSC_DOL_Equipment_Time_Standards_TX..pdf	PDF	Sep 12, 2017
Attachment_14_Hands_On_Training_Course_Texas_Region.pdf	PDF	Sep 12, 2017
Attachment_3_PRS_DOL_Maintenance_20170815.docx	DOCX document	Sep 12, 2017
Attachment_9_Worksite_Locations_Texas_Region.pdf	PDF	Sep 12, 2017
Attachment_1_AT-OPSEC_63d_RSC_Logistical_Support_TX_Region.pdf	PDF	Sep 12, 2017
Attachment_4_DeliverablesTexas_Region.docx	DOCX document	Sep 12, 2017
Attachment_8_Contracted_Employees_SHARP_Info_Texas_Region.pdf	PDF	Sep 12, 2017
W911SA-17-R-3001_SOLICITATION.docx	DOCX document	Sep 12, 2017
Attachment_5_Past_performance_Attachment_Samples.docx	DOCX document	Sep 12, 2017

Show all 38

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

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, X009 and X013 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X017 and X018 are plug numbers for cost 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	01-A to 01-B	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	02-A to 02-B	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 AZ, MN, OK, TX, AR 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, X009 and X013 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X017 and X018 are plug numbers for cost 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 00013
0013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0013	0.00	0.000	0.000	$0.00	$0.00	$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 0013	$0.00	$0.00	$0.00	$0.00	$0.00	$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 0014	$0.00
CLIN 0015	$0.00
CLIN 0016	$0.00

CLIN 0017 TRAVEL (COST REIMBURABLE)	$150,000.00
CLIN 0018 MATERIALS (COST REIMBURABLE)	$10,000.00
CLIN 0019 CONTRACTOR MANPOWER REPORTING
CLIN 0020 PHASE-IN
TOTAL - BASE PERIOD	$160,000.00

For Official Use only

OPT 1

ATTACHMENT 2: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support AZ, MN, OK, TX, AR Region- OPTION 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, X009 and X013 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X017 and X018 are plug numbers for cost 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
1013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1013	0.00	0.000	0.000	$0.00	$0.00	$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 1013	$0.00	$0.00	$0.00	$0.00	$0.00	$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 1014	$0.00
CLIN 1015	$0.00
CLIN 1016	$0.00

CLIN 1017 TRAVEL (COST REIMBURABLE)	$150,000.00
CLIN 1018 MATERIALS (COST REIMBURABLE)	$10,000.00
CLIN 1019 CONTRACTOR MANPOWER REPORTING
TOTAL - OPTION 1	$160,000.00

For Official Use only

OPT 2

ATTACHMENT 2: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support AZ, MN, OK, TX, AR Region- OPTION 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, X009 and X013 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X017 and X018 are plug numbers for cost 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
2013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2013	0.00	0.000	0.000	$0.00	$0.00	$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 2013	$0.00	$0.00	$0.00	$0.00	$0.00	$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 2014	$0.00
CLIN 2015	$0.00
CLIN 2016	$0.00

CLIN 2017 TRAVEL (COST REIMBURABLE)	$150,000.00
CLIN 2018 MATERIALS (COST REIMBURABLE)	$10,000.00
CLIN 2019 CONTRACTOR MANPOWER REPORTING
TOTAL - OPTION 2	$160,000.00

For Official Use only

OPT 3

ATTACHMENT 2: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support AZ, MN, OK, TX, AR Region- OPTION 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, X009 and X013 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X017 and X018 are plug numbers for cost 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
3013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3013	0.00	0.000	0.000	$0.00	$0.00	$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 3013	$0.00	$0.00	$0.00	$0.00	$0.00	$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 3014	$0.00
CLIN 3015	$0.00
CLIN 3016	$0.00

CLIN 3017 TRAVEL (COST REIMBURABLE)	$150,000.00
CLIN 3018 MATERIALS (COST REIMBURABLE)	$10,000.00
CLIN 3019 CONTRACTOR MANPOWER REPORTING
TOTAL - OPTION 3	$160,000.00

For Official Use only

OPT 4

ATTACHMENT 2: PRICING SCHEDULE - 63rd RSC Maintenance Logistics Readiness Support AZ, MN, OK, TX, AR Region- OPTION 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, X009 and X013 are not indicative of the number of positions; lines may be added or deleted based on performance requirements
Amounts for CLINS X017 and X018 are plug numbers for cost 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
4013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4013	0.00	0.000	0.000	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4013	0.00	0.000	0.000	$0.00	$0.00	$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 4013	$0.00	$0.00	$0.00	$0.00	$0.00	$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 4014	$0.00
CLIN 4015	$0.00
CLIN 4016	$0.00

CLIN 4017 TRAVEL (COST REIMBURABLE)	$150,000.00
CLIN 4018 MATERIALS (COST REIMBURABLE)	$10,000.00
CLIN 4019 CONTRACTOR MANPOWER REPORTING
CLIN 4020 PHASE-OUT
TOTAL - OPTION 4	$160,000.00

For Official Use only

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