Attachment_J-13.xlsx

XLSX spreadsheet 52 KB Posted Dec 3, 2015

Attached to: Operation of the Keystone Job Corps Center
Solicitation number: DOL-ETA-15-R-00072
Issued by: Department of Labor Employment and Training Administration

About this file

From the source

Attachment J-13

View the file

Other files

File	Type	Posted
Keystone_Vehicle_Log.xls	XLS spreadsheet	Jan 8, 2016
Keystone_RFP_walkthru_Questions_and_answers.docx	DOCX document	Jan 8, 2016
Updated_2015_utility_usagecost.xls	XLS spreadsheet	Jan 8, 2016
Keystone_Residential_Advisors_CBA_2010-2013_signed_(2)_pdf_-_Adobe_Acrobat_Pro.pdf	PDF	Jan 8, 2016
Keystone_Professionals_CBA_2010-2013_signed_pdf_-_Adobe_Acrobat_Pro.pdf	PDF	Jan 8, 2016
Keystone_Maintenance_CBA_2009-2012_signed.pdf	PDF	Jan 8, 2016
Basis_for_Award.docx	DOCX document	Jan 8, 2016
Attachment_J-2.pdf	PDF	Dec 3, 2015
Attachment_J-7.docx	DOCX document	Dec 3, 2015
Attachment_J-4.xlsx	XLSX spreadsheet	Dec 3, 2015
Attachment_J-10.pdf	PDF	Dec 3, 2015
Attachment_J-12.pdf	PDF	Dec 3, 2015
Attachment_J-3.xlsx	XLSX spreadsheet	Dec 3, 2015
Attachment_J-14.pdf	PDF	Dec 3, 2015
Attachment_J-6.xlsx	XLSX spreadsheet	Dec 3, 2015
Attachment_J-1.xlsx	XLSX spreadsheet	Dec 3, 2015
Attachment_J-9_Volume_II.pdf	PDF	Dec 3, 2015
Attachment_J-9_Volume_I.pdf	PDF	Dec 3, 2015
Attachment_J-8.pdf	PDF	Dec 3, 2015
Attachment_J-11.pdf	PDF	Dec 3, 2015
KEYSTONE_RFP.docx	DOCX document	Dec 2, 2015

Show all 21

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.

Positions and Pay grades

POSITION TITLES BY PAY GRADE

Position Titles Commonly Found at Job Corps Centers, including form 2110 line # generally categorized under and if non-exempt (i.e., overtime applies)

Grade Line # Non-Exempt herro.christopher: For calculation of Overtime pay

	Grade	Line #	Non-Exempt
herro.christopher: For calculation of Overtime pay	Grade	Line #	Non-Exempt

herro.christopher: For calculation of Overtime pay

1	Child Care Aide	9	Non-Exempt	4	Accountant	15		6	Academic Instructor	1
1	Cooks Helper/Assistant	9	Non-Exempt	4	Assistant Food Service Manager	9		6	Applied Academics Instructor	1
1	Culinary Worker	9	Non-Exempt	4	Assistant Student Personnel Officer	5		6	Career Preparation Development Manager	13
1	Dining Hall Aide	9	Non-Exempt	4	Career Development Specialist	13		6	Career Transition Manager	1 CTS
1	Food Service Aide	9	Non-Exempt	4	Career Preparation Advisor	13		6	Center Shift Manager	5
1	Laundry Operator	9	Non-Exempt	4	Career Preparation Coodinator	13		6	Child Care Manager	9
1	Student Intern/WBL	Various	Non-Exempt	4	Career Preparation Instructor	13		6	Communications Instructor	1
				4	Career Preparation Specialist	13		6	Counseling Supervisor	5
2	Clerical	Various	Non-Exempt	4	Career Transition Readiness Specialist	13		6	CP/CTR Supervisor	13
2	Clerk	Various	Non-Exempt	4	Child Care Specialist	9	Non-Exempt	6	CPP Supervisor	13
2	Custodian	9	Non-Exempt	4	Data Intergrity Specialist	15		6	English as a Second Language Instructor	1
2	Data Integrity Clerk	15	Non-Exempt	4	Dental Hygienist	11		6	Finance Supervisor	15
2	Driver	9	Non-Exempt	4	Diversity Coordinator	5		6	GED Instructor	1
2	Groundskeeper	18	Non-Exempt	4	Duty Officer	15		6	High School Diploma Instructor	1
2	Janitor	18	Non-Exempt	4	EEO Coordinator	15		6	Human Resources (HR) Manager	15
2	Mechanic Helper	18	Non-Exempt	4	Employment Specialist	15		6	Information Technology Instructor	13
2	Medical Assistant	11	Non-Exempt	4	Executive Assistant (CD)	15	Non-Exempt	6	IT Systems Administrator	15
2	Payroll/Clothing Clerk	15	Non-Exempt	4	Information Technology Specialist	15		6	Maintenance Manager	18
2	Procurement Clerk	15	Non-Exempt	4	IT Assisstant	15		6	Math Instructor	1
2	Property Clerk	15	Non-Exempt	4	Lead Security Officer	20		6	Personnel Manager	15
2	Receptionist	15	Non-Exempt	4	Licensed Practical Nurse	11		6	Reading Instructor	1
2	Recreation Assistant/Aide	5	Non-Exempt	4	Maintenance Engineer	18		6	Recreation Manager	5
				4	Pre-Enrolment Specialist	13
2	Scheduling Clerk	15	Non-Exempt	4	Property/Supply Officer	15		6	Safety & Security Manager	20
2	Student Personnel Officer Clerk	15	Non-Exempt	4	Property/Supply Specialist	15	Non-Exempt	6	Security Manager	20
2	Student Records Clerk	15	Non-Exempt	4	Senior/Lead Cook	9	Non-Exempt	6	Senior Counselor	5
2	Substitute Driver	9	Non-Exempt	4	Senior Recreation Specialist	5	Non-Exempt	6	Student Records Manager	15
2	Supply Clerk	15	Non-Exempt	4	Senior Residential Advisor	5	Non-Exempt	6	Substitute Academic Instructor	1
2	Utility Worker	18	Non-Exempt	4	Senior Security Officer	20	Non-Exempt	6	Support Services Manager	15
2	Warehouse Worker	15	Non-Exempt	4	Transportation Supervisor	9		6	Wellness/Safety Instructor	11
				4	Vehicle Fleet Manager	9
3	Accounting Clerk	15	Non-Exempt	4	Vocational Practical Nurse	11		7	Academic Supervisor	1
3	Administrative Assistant	Various	Non-Exempt					7	Administration Manager	15
3	Arts/Crafts Instructor	5	Non-Exempt	5	ACT/OCT Coordinator	1		7	Career Preparation Manager	13
3	Bookkeeper	15	Non-Exempt	5	ACT/OCT Counselor	5		7	Counseling Manager	5
3	Cook	9	Non-Exempt	5	Admissions Counselor	1 OA		7	CP/CTR Manager	13
3	Dental Assistant	11	Non-Exempt	5	Business Community Liaison	15		7	CTT Supervisor	3
3	Dental Technician	11	Non-Exempt	5	Buyer	15		7	Finance Manager	15
3	HR Specialist	15	Non-Exempt	5	Career Development Specialist	1		7	Registered Nurse	11
3	Front Gate Officer	20	Non-Exempt	5	Career Exploration Instructor	3 or 13		7	Residential Living Manager	5
3	Lab/X-Ray Technician	11	Non-Exempt	5	Career Preparation Instructor	13		7	Wellness Supervisor	11
3	Laundry Manager	9	Non-Exempt	5	Career Transition Advisor	1 CTS
3	Leadership Coordinator	5	Non-Exempt	5	Career Transition Specialist	1 CTS		8	Academic Manager	1
3	Librarian	5	Non-Exempt	5	Center Standards Officer	5		8	Administration Director	15
3	Maintenance Mechanic	18	Non-Exempt	5	Child Care Supervisor	9		8	Admissions Manager	1 OA
3	Maintenance Technician	18	Non-Exempt	5	Child Care Teacher	9		8	Career Success Director	5
3	Maintenance Worker	18	Non-Exempt	5	Counselor	5		8	Career Transition Services Mngr	1 CTS
3	Personnel Specialist	15	Non-Exempt	5	CTST Coordinator	3		8	Counseling Director	5
3	Personnel Assistant	15	Non-Exempt	5	CTT Instructor	3		8	CTT Manager	3
3	Recreation Coordinator	5	Non-Exempt	5	Data Integrity/Quality Assurance Supervisor	15		8	Director of Residential Living	5
3	Recreation Specialist	5	Non-Exempt	5	Dining Hall Manager	9		8	Health Services Administrator	11
3	Reproductive Health Specialist	11	Non-Exempt	5	Driver's Education Instructor	1 or 13		8	Health Services Manager	11
3	Residential Advisor	5	Non-Exempt	5	Evening Studies Coordinator	5		8	Medical Services Director	11
3	Secretary	Various	Non-Exempt	5	Food Service Supervisor	9		8	Nurse Practioner	11
3	Security Guard	20	Non-Exempt	5	Human Resources (HR) Supervisor	15		8	OA & CTS Manager	1

Chris: 50/50 split between OA line 01 and CTS line 01

3	Security Officer	20	Non-Exempt	5	Incidental OA/CTS staff	1 OA	8	Phyisician's Assistant	11
3	Senior Custodian	18	Non-Exempt	5	Maintenance Supervisor	18	8	Residential Living Director	5
3	Senior Records Clerk	15	Non-Exempt	5	Placement/Employment Specilaist	1 CTS	8	Vocational Manager	3
3	SGA Advisor	5	Non-Exempt	5	Procurement Manager	15
3	Student Records Specialist	15	Non-Exempt	4	Property/Supply Manager	15	9	Career Training Services Director	1 and 3

Chris: 50/50 split

3	Student Store Specialist	15	Non-Exempt	5	Purchasing Agent	15	9	Deputy Center Director	15
3	Substitute RA	5	Non-Exempt	5	Recreation Supevisor	5	9	Education and Training Manager	1 and 3

Chris: 50/50 split

3 TEAP Assistant 11 Non-Exempt 5 Residential Advisor Supv 5 9 Training/Program Director 1 and 3 Chris: 50/50 split herro.christopher: For calculation of Overtime pay herro.christopher: For calculation of Overtime pay

Chris: 50/50 split between OA line 01 and CTS line 01 herro.christopher: For calculation of Overtime pay Chris: 50/50 split

Chris: 50/50 split

3	Transportation Coordinator	9	Non-Exempt		5	Residential Living Supervisor	5
	3	Women's Program Coordinator	5	Non-Exempt		5	Safety & Security Supervisor	20	10	Center Director	15
						5	Security Supervisor	20
						5	Senior Accountant	15
						5	Staff Training Coordinator	15
						5	Student Accountability Officer	15
						5	Student Personnel Officer	5
						5	Student Records Supervisor	15
						5	Student Safety Advisor/Coordinator	15
						5	Substitute CTT Instructor	3
						5	TEAP Coordinator	11
						5	TEAP Specialist	11
						5	Testing Coordinator	1
						5	Transoportation Manager	9
						5	Vocational Testing Coordinator	3
						5	WBL Coordinator	3

Salary Calc tables

	ADJUSTMENTS TO PHASE II ANNUAL SALARY LEVELS: INFLATION & GEOGRAPHIC LOCATION			Inflation Factors
Windows User: The Program Year inflation rates shown below, in rows 16 -31, are established by OFA as they become available. Accordingly, this table would be periodically updated by OFA.		Contract Year
	(Applies to First Year of New Contract)				1	2	3	4	5	6	7
	1. Contract Start Date	12/1/2016	Midpoint (Used for Budgeting)

Windows User: The amounts in this column are used and automatically brought across as the base salary for each FTE within each personnel line and as shown on the staff compensation supplement.

Windows User: The Program Year inflation rates shown below, in rows 16 -31, are established by OFA as they become available. Accordingly, this table would be periodically updated by OFA.	Range information displayed for information only. Budget calculations are based on Midpoints.			1, Contract Year Start Date		12/1/2016	9/1/2010	9/1/2011	9/1/2012	9/1/2013
	2. Infl Adjustment Factor	1.008					2. Applicable Inflation Year Start Date		7/1/2013	7/1/2010	7/1/2011	7/1/2012	7/1/2013
	3. Geo Adjustment Factor	96.88%					3. Inflation Factor for This Inflation Year		1.0000	1.0000	1.0000	1.0000	1.0000
	4. Net Adj (Line 2 x Line 3)	0.9766					4. Elapsed Time in Days (Line 1 minus Line 2)		1249	62	62	62	62
	Pay Level	Minimum		Maximum	Range	Rate/hour	5. Elapsed Time in Terms of Years (Line 4 / 365.25 Days)		3.4196	0.1697	0.1697	0.1697	0.1697
	1	$17,898	$20,583	$23,267	30%	$9.90	6. Inflation Factors: 10/01/2007 Thru Contract Start Date
	2	$20,272	$24,326	$28,381	40%	$11.70	a. Cumulative Thru Prior Inflation Year		1.0591	1.0444	1.0591	1.0591	0.0000
	3	$23,390	$28,068	$32,746	40%	$13.49	b. Added Infl, Time Elapsed This Year (Line 3 ^ Line 5)		1.0000	1.0024	1.0000	1.0000	1.0000
	4	$28,068	$33,682	$39,295	40%	$16.19	c. Cumulative Infl Thru Contract Start Date (6a x 6b)		1.0590822	1.0469	1.0591	1.0591	0.0000
	5	$31,967	$38,360	$44,754	40%	$18.44	d. Inflation Since Preceding Contract Year			0.9885	1.0116	1.0000	0.0000
	6	$35,865	$43,038	$50,211	40%	$20.69	INFLATION YEAR DATA		Days Duration	Infl Factor This Year	Cum Thru Prior Year
	7	$42,103	$50,523	$58,944	40%	$24.29	Start Date	End Date
	8	$47,903	$59,879	$71,855	50%	$28.79	10/1/2007			1.0000	1.0000
	9	$56,137	$70,171	$84,206	50%	$33.74	7/1/2008	6/30/2009	365	1.0140	1.0000
	10	$86,077	$107,596	$129,116	50%	$51.73	7/1/2009	6/30/2010	365	1.0300	1.0140
							7/1/2010	6/30/2011	365	1.0140	1.04442
	U.S. DEPARTMENT OF LABOR				$21,008		7/1/2011	6/30/2012	366	1.0000	1.05908
	OFFICE OF JOB CORPS						7/1/2012	6/30/2013	365	1.0000	1.05908
	Annual Salary Midpoints @91.65% of Levels Recommended as of						7/1/2013	6/30/2014	365	1.0000	1.05908
	10/01/07						7/1/2014	6/30/2015	365	1.0000	1.05908
	(Budgetary Effective Date of Phase II Salary Increases)						7/1/2015	6/30/2016	366	1.0000	1.0591
	Pay Level	@100%	91.65%
Windows User: Budgetary limitation factor based on future appropriations				7/1/2016	6/30/2017	365	1.0000	1.0591
	1	$22,997	$21,077				7/1/2017	6/30/2018	365	1.0000	1.0591
	2	$27,179	$24,910				7/1/2018	6/30/2019	365	1.0000	1.0591
	3	$31,360	$28,741				7/1/2019	6/30/2020	366	1.0000	1.0591
	4	$37,632	$34,490				7/1/2020	6/30/2021	365	1.0000	1.0591
	5	$42,859	$39,280				7/1/2021	6/30/2022	365	1.0000	1.0591
	6	$48,085	$44,070				7/1/2022	6/30/2023	365	1.0000	1.0591
	7	$56,448	$51,735
	8	$66,901	$61,315
	9	$78,400	$71,854
	10	$120,214	$110,176

Geo Adjustment

	THIS IS THE CORRECT CURRENT MODEL 11-24-08 TW
US DEPARTMENT OF LABOR
OFFICE OF JOB CORPS
Geographic Differentials in Cost of Labor
Data Reported for All Available Locations
National Average, United States = 100%
Job Corps Center		Aggregate Differential	Comparison Cities
1	Alaska	125.8%	Palmer, Alaska
2	Albuquerque	95.3%	Albuquerque, New Mexico
3	Arecibo	73.7%	Arecibo, Puerto Rico
4	Atlanta	100.3%	Atlanta, Georgia
5	Atterbury	89.7%	Franklin, Indiana
6	Bamberg	89.6%	Orangeburg, South Carolina
7	Barranquitas	71.4%	Coamo, Puerto Rico
8	Blue Ridge	87.2%	Marion, Virginia
9	Brooklyn	114.0%	Brooklyn, New York
10	Brunswick	88.7%	Brunswick, Georgia
11	Carl Perkins	90.6%	Langley, Kentucky
12	Carville	85.0%	Geismar, Louisiana
13	Cascades	102.8%	Burlington, Washington
14	Cassadaga	94.2%	Fredonia, New York
15	Charleston	93.5%	Charleston, West Virginia
16	Paul Simon	109.1%	Chicago, Illinois
17	Cincinnati	99.8%	Cincinnati, Ohio
18	Clearfield	95.7%	Clearfield, Utah
19	Cleveland	102.0%	Cleveland, Ohio
20	Connecticut	111.4%	Statewide, Connecticut
21	David L. Carrasco	89.6%	El Paso, Texas
22	Dayton	100.6%	Dayton, Ohio
23	Delaware Valley	103.0%	Port Jervis, New York
24	Denison	91.8%	Sergeant Bluff, Iowa
25	Detroit	112.2%	Detroit, Michigan
26	Earle C. Clements	93.0%	Henderson, Kentucky
27	Edison	114.9%	Edison, New Jersey
28	Excelsior Springs	97.6%	Excelsior Springs, Missouri
29	Exeter	102.1%	Kingston, Rhode Island
30	Finch-Henry	85.3%	Batesville, Mississippi
31	Flint-Genessee	106.9%	Flint, Michigan
32	Flint Hills	90.2%	Manhattan, Kansas
33	Fred G Acosta	93.6%	Tucson, Arizona
34	Gadsden	89.2%	Gadsden, Alabama
35	Gainesville	90.4%	Gainesville, Florida
36	Gary	95.0%	San Marcos, Texas
37	Gerald Ford	103.8%	Grand Rapids, Michigan
38	Glenmont	99.2%	Glenmont, New York
39	Grafton	102.7%	Grafton, Massachusetts
40	Gulfport	90.5%	Gulfport, Mississippi
41	Guthrie	90.3%	Guthrie, Oklahoma
42	Harpers Ferry	102.2%	Charles Town, West Virginia
43	Hartford	104.3%	Hartford, Connecticut
44	Hawaii	104.1%	Waimanalo, Hawaii
45	Homestead	96.3%	Homestead, Florida
46	Hubert H. Humphrey	107.4%	St Paul, Minnesota
47	Indypendence	100.0%	Indianapolis, Indiana
48	Inland Empire	107.5%	San Bernardino, California
49	Iroquois	97.7%	Albion, New York
50	Jacksonville	96.0%	Jacksonville, Florida
51	Joliet	106.6%	Joliet, Illinois
52	Keystone	96.9%	Hazleton, Pennsylvania
53	Kicking Horse	87.9%	Polson, Montana
54	Kittrell	92.0%	Henderson, North Carolina
55	Laredo	86.8%	Laredo, Texas
56	Little Rock	91.1%	Little Rock, Arkansas
57	Long Beach	112.3%	Long Beach, California
58	Loring	83.9%	Presque Isle, Maine
59	Los Angeles	113.4%	Los Angeles, California
60	Benjamin Hooks	97.6%	Memphis, Tennessee
61	Manchester	100.0%	Manchester, New Hampshire
62	Miami	99.4%	Miami, Florida
63	Milwaukee	100.0%	Milwaukee, Wisconsin
64	Mississippi	88.5%	Statewide, Mississippi
65	Montgomery	91.5%	Montgomery, Alabama
66	Muhlenberg	89.2%	Madisonville, Kentucky
67	New Haven	100.0%	New Haven, Connecticut
68	New Orleans	96.1%	New Orleans, Louisiana
69	North Texas	97.5%	Mckinney, Texas
70	Northlands	98.6%	Burlington-Downtown, Vermont
71	Old Dominion	87.5%	Lynchburg, Virginia
72	Oneonta	95.6%	Oneonta, New York
73	Ottumwa	86.5%	Ottumwas, Iowa
74	Penobscot	92.5%	Bangor, Maine
75	Philadelphia	107.7%	Philadelphia, Pennsylvania
76	Phoenix	99.5%	Phoenix, Arizona
77	Pinellas	100.0%	St. Petersburg, Florida
78	Pittsburgh	99.6%	Pittsburgh, Pennsylvania
79	Potomac	107.2%	District Of Columbia, District of Columbia
80	Quetin N. Burdick	90.3%	Minot, North Dakota
81	Ramey	74.6%	Aguadilla, Puerto Rico
82	Red Rock	96.7%	Towanda, Pennsylvania
83	Roswell	89.5%	Roswell, New Mexico
84	Sacramento	108.7%	Sacramento, California
85	San Diego	107.0%	San Diego, California
86	San Jose	121.3%	San Jose, California
87	Shreveport	91.9%	Shreveport, Louisiana
88	Shriver	104.1%	Leominster, Massachusetts
89	Sierra Nevada	104.7%	Reno, Nevada
90	South Bronx	113.6%	Bronx, New York
91	Springdale	101.8%	Troutdale, Oregon
92	St Louis	102.2%	St Louis, Missouri
93	Talking Leaves	88.0%	Muskogee, Oklahoma
94	Tongue Point	98.1%	Astoria, Oregon
95	Treasure Island	120.9%	San Francisco, California
96	Tulsa	95.1%	Tulsa, Oklahoma
97	Turner	93.1%	Albany, Georgia
98	Westover	104.1%	Chicopee, Massachusetts
99	Whitney M. Young Jr.	95.1%	Crestwood, Kentucky
100	Wilmington	99.3%	Wilmington, Delaware
101	Wind River	100.0%	Riverton, Wyoming
102	Woodland	104.4%	Laurel, Maryland
103	Woodstock	102.6%	Randallstown, Maryland
* Note New Orleans, Louisana and Gulfport, Mississippi information is pre-Hurricane Katrina

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