Attachment J-14 National Staff_Compensation_Report_Data_Att_J-13.xls

XLS spreadsheet 125 KB Posted May 8, 2012

Attached to: Operation of the Gadsden Job Corps Center
Solicitation number: DOL121RP20475
Issued by: Department of Labor Employment and Training Administration

About this file

From the source

Attachment J-14

View the file

Other files

File	Type	Posted
Gadsden Job Corps Vehicle Annual Mileage Report May 2011-April 2012	—	Jun 29, 2012
REvised Attachment for Wage and Determination WD 05-2001.pdf	PDF	Jun 29, 2012
GSA Vehicles for Question 33.pdf	PDF	Jun 29, 2012
SF30 amendment 0003 DOL121RP20475.pdf	PDF	Jun 29, 2012
Questions and Answers for Clarification DOL121RP20475 06292012.doc	DOC document	Jun 29, 2012
Attachment J-8.pdf	PDF	Jun 29, 2012
Revised Section L as of 06292012.pdf	PDF	Jun 29, 2012
SF 1408 - Accounting System Certification.pdf	PDF	Jun 29, 2012
Revised Section G as of 06292012.pdf	PDF	Jun 29, 2012
Revised Attachment for J-6.pdf	PDF	Jun 29, 2012
Gadsden RFP CTT MSO 20 Vehicle Ins	—	Jun 29, 2012
DOL121RP20475 - AMENDMENT 0002.doc	DOC document	Jun 15, 2012
DOLRP12120475 - Gadsden RFP AMENDMENT 0001.doc	DOC document	May 30, 2012
Attendance Sheet for Pre-Solicitation Gadsden.pdf	PDF	May 30, 2012
Questions for Gadsden Solicitation - 28.doc	DOC document	May 30, 2012
Attachment J-10 2011 Gadsden Facility Survey Vol1_Part15-8-12.pdf	PDF	May 8, 2012
Gadsden Job Corps Center RFP revised 5-7-2012.doc	DOC document	May 8, 2012
rved_033120121 CTT Report Card 3 12.pdf	PDF	May 8, 2012
rcdm_033120121 OMS20 3 12.pdf	PDF	May 8, 2012
Utilities Cost-Usage April 2011-March 2012.xls	XLS spreadsheet	May 8, 2012
rcmc_022920121 MPO35.pdf	PDF	May 8, 2012
Attachment J-12 Gadsden_Inventory_Estimate.doc	DOC document	May 8, 2012
Attachment J-6 Gadsden Job Corps Center.docx	DOCX document	May 8, 2012
Attachment J-11 Computerized Property Management Listing.pdf	PDF	May 8, 2012
Attachment J-10 2011_Gadsden Facility Survey Final_Vol2_5-8-12.pdf	PDF	May 8, 2012

Show all 25

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.

Instructions

CENTER RFP DOL COMPENSATION WORKSHEET
1	On TAB CENTER_TABLE Click on Cell D4 - a drop-down arrow will appear to the right of the cell. Choose a center from the drop-down menu. The correct geographic adjustment factor will automatically be displayed in Cell D5.
2	On TAB CENTER_TABLE Click on Cell I4 and enter the new conctract start date as mm/dd/yy.
3	That's all there is to it. No additional entries are required. The DOL Compensation Table is now ready for use.
	THIS CENTER CONTRACT RFP STAFF COMPENSATION WORKSHEET IS TO BE COMPLETED BY THE REGIONAL OFFICE AND MADE AVAILABLE WITH THE RFP. THE WORKSHEET IS PASSWORD PROTECTED EXCEPT FOR THE CELLS REQUIRING ENTRIES.
	tw 05-24-11 updated

center_table

v tw 05/07/09
DOL OFFICE OF JOB CORPS NATIONAL STAFF COMPENSATION REPORT
Offerors shall justify proposed salary levels using prevailing wage rate data from the local labor market, this National Staff Compensation Report data sheet, or a combination of both. This table reflects independent, expert advice that has been given to the Office of Job Corps USDOL.
a.	Name of Center Under Procurement...................................................		Gadsden	c.	Planned Start Date of New Contract............................................			12/01/12
b.	Geographic Adjustment Factor, This Center.....................................................................		89.2%	d.	Employer Paid Fringe Target Level....................................			24.8%
Pay Group	Budget Element	Base Year 1			Base Year 2: Inflation @		0.00%	Recommended Salary Range
		Low End	Midpoint for Use in Budgeting	High End	Low End	Midpoint for Use in Budgeting	High End
1	Annual Base Salary	17,321	19,919	22,517	17,321	19,919	22,517	30%
	Base Fringe Benefit Allowance		4,940			4,940
	Total of Base Salary + Base Fringes		24,859			24,859
2	Annual Base Salary	19,617	23,541	27,464	19,617	23,541	27,464	40%
	Base Fringe Benefit Allowance		5,838			5,838
	Total of Base Salary + Base Fringes		29,379			29,379
3	Annual Base Salary	22,635	27,162	31,689	22,635	27,162	31,689	40%
	Base Fringe Benefit Allowance		6,736			6,736
	Total of Base Salary + Base Fringes		33,898			33,898
4	Annual Base Salary	27,162	32,595	38,027	27,162	32,595	38,027	40%
	Base Fringe Benefit Allowance		8,083			8,083
	Total of Base Salary + Base Fringes		40,678			40,678
5	Annual Base Salary	30,935	37,122	43,309	30,935	37,122	43,309	40%
	Base Fringe Benefit Allowance		9,206			9,206
	Total of Base Salary + Base Fringes		46,328			46,328
6	Annual Base Salary	34,707	41,648	48,590	34,707	41,648	48,590	40%
	Base Fringe Benefit Allowance		10,329			10,329
	Total of Base Salary + Base Fringes		51,977			51,977
7	Annual Base Salary	40,743	48,892	57,041	40,743	48,892	57,041	40%
	Base Fringe Benefit Allowance		12,125			12,125
	Total of Base Salary + Base Fringes		61,017			61,017
8	Annual Base Salary	46,357	57,946	69,535	46,357	57,946	69,535	50%
	Base Fringe Benefit Allowance		14,371			14,371
	Total of Base Salary + Base Fringes		72,316			72,316
9	Annual Base Salary	54,324	67,906	81,487	54,324	67,906	81,487	50%
	Base Fringe Benefit Allowance		16,841			16,841
	Total of Base Salary + Base Fringes		84,746			84,746
10	Annual Base Salary	83,298	104,122	124,947	83,298	104,122	124,947	50%
	Base Fringe Benefit Allowance		25,822			25,822
	Total of Base Salary + Base Fringes		129,945			129,945
					Min	Midpoint	Max
		1	19,919	1	17,321	19,919	22,517
		2	23,541	2	19,617	23,541	27,464
		3	27,162	3	22,635	27,162	31,689
		4	32,595	4	27,162	32,595	38,027
		5	37,122	5	30,935	37,122	43,309
		6	41,648	6	34,707	41,648	48,590
		7	48,892	7	40,743	48,892	57,041
		8	57,946	8	46,357	57,946	69,535
		9	67,906	9	54,324	67,906	81,487
		10	104,122	10	83,298	104,122	124,947
			CY2	CY3	CY4	CY5
		Inflation Factors

hess-williams.tina:

click on cell D4 then choose center from Drop-Down Menu source_tbl

ADJUSTMENTS TO PHASE II ANNUAL SALARY LEVELS: INFLATION & GEOGRAPHIC LOCATION					Inflation Factors		Contract Year
(Applies to First Year of New Contract)							1	2	3	4	5	6	7
1. Contract Start Date	12/1/2012	Midpoint (Used for Budgeting)	Range information displayed for information only. Budget calculations are based on Midpoints.		1, Contract Year Start Date		12/1/2012	9/1/2010	9/1/2011	9/1/2012	9/1/2013	12/31/1899	12/31/1899
2. Infl Adjustment Factor	1.0590822				2. Applicable Inflation Year Start Date		7/1/2012	7/1/2010	7/1/2011	7/1/2012	7/1/2013	12/31/1899	12/31/1899
3. Geo Adjustment Factor	89.23%				3. Inflation Factor for This Inflation Year		1.0000	1.0140	1.0000	1.0000	1.0000	0.0000	0.0000
4. Net Adj (Line 2 x Line 3)	0.9451				4. Elapsed Time in Days (Line 1 minus Line 2)		153	62	62	62	62	0	0
Pay Level	Minimum		Maximum	Range	5. Elapsed Time in Terms of Years (Line 4 / 365.25 Days)		0.4189	0.1697	0.1697	0.1697	0.1697	0.0000	0.0000
1	$17,321	$19,919	$22,517	30%	6. Inflation Factors: 10/01/2007 Thru Contract Start Date
2	$19,617	$23,541	$27,464	40%	a. Cumulative Thru Prior Inflation Year		1.0591	1.0444	1.0591	1.0591	1.0591	0.0000	0.0000
3	$22,635	$27,162	$31,689	40%	b. Added Infl, Time Elapsed This Year (Line 3 ^ Line 5)		1.0000	1.0024	1.0000	1.0000	1.0000	0.0000	0.0000
4	$27,162	$32,595	$38,027	40%	c. Cumulative Infl Thru Contract Start Date (6a x 6b)		1.0590822	1.0469	1.0591	1.0591	1.0591	0.0000	0.0000
5	$30,935	$37,122	$43,309	40%	d. Inflation Since Preceding Contract Year			0.9885	1.0116	1.0000	1.0000	0.0000	0.0000
6	$34,707	$41,648	$48,590	40%	INFLATION YEAR DATA		Days Duration	Infl Factor This Year	Cum Thru Prior Year
7	$40,743	$48,892	$57,041	40%	Start Date	End Date
8	$46,357	$57,946	$69,535	50%	10/1/2007			1.0000	1.0000
9	$54,324	$67,906	$81,487	50%	7/1/2008	6/30/2009	365	1.0140	1.0000
10	$83,298	$104,122	$124,947	50%	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					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%			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

geog_adjs

	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	Anaconda	88.9%	Anaconda, Montana
4	Angell	97.3%	Waldport, Oregon
5	Arecibo	73.7%	Arecibo, Puerto Rico
6	Atlanta	100.3%	Atlanta, Georgia
7	Atterbury	89.7%	Franklin, Indiana
8	Bamberg	89.6%	Orangeburg, South Carolina
9	Barranquitas	71.4%	Coamo, Puerto Rico
10	Batesville	85.3%	Batesville, Mississippi
11	Blackwell	90.0%	Rhinelander, Wisconsin
12	Blue Ridge	87.2%	Marion, Virginia
13	Boxelder	87.6%	Rapid City, South Dakota
14	Brooklyn	114.0%	Brooklyn, New York
15	Brunswick	88.7%	Brunswick, Georgia
16	Carl D. Perkins	90.6%	Langley, Kentucky
17	Carville	85.0%	Geismar, Louisiana
18	Cascades	102.8%	Burlington, Washington
19	Cass	87.6%	Bentonville, Arkansas
20	Cassadaga	94.2%	Fredonia, New York
21	Centennial	94.6%	Nampa, Idaho
22	Charleston	93.5%	Charleston, West Virginia
23	Chicago	109.1%	Chicago, Illinois
24	Cincinnati	99.8%	Cincinnati, Ohio
25	Clearfield	95.7%	Clearfield, Utah
26	Cleveland	102.0%	Cleveland, Ohio
27	Collbran	94.3%	Pueblo, Colorado
28	Columbia Basin	98.1%	Moses Lake, Washington
29	Connecticut	111.4%	Statewide, Connecticut
30	Curlew	95.3%	Republic, Washington
31	David L. Carrasco	89.6%	El Paso, Texas
32	Dayton	100.6%	Dayton, Ohio
33	Delaware Valley	103.0%	Port Jervis, New York
34	Denison	91.8%	Sergeant Bluff, Iowa
35	Detroit	112.2%	Detroit, Michigan
36	Earle C. Clements	93.0%	Henderson, Kentucky
37	Edison	114.9%	Edison, New Jersey
38	Excelsior Springs	97.6%	Excelsior Springs, Missouri
39	Exeter	102.1%	Kingston, Rhode Island
40	Flatwoods	85.5%	Coeburn, Virginia
41	Flint	106.9%	Flint, Michigan
42	Flint Hills	90.2%	Manhattan, Kansas
43	Fort Simcoe	103.3%	Union Gap, Washington
44	Fred G Acosta	93.6%	Tucson, Arizona
45	Frenchburg	92.8%	Winchester, Kentucky
46	Gadsden	89.2%	Gadsden, Alabama
47	Gainesville	90.4%	Gainesville, Florida
48	Gary	95.0%	San Marcos, Texas
49	Gerald Ford	103.8%	Grand Rapids, Michigan
50	Glenmont	99.2%	Glenmont, New York
51	Golconda	91.0%	Harrisburg, Illinois
52	Grafton	102.7%	Grafton, Massachusetts
53	Great Onyx	89.5%	Bowling Green, Kentucky
54	Gulfport	90.5%	Gulfport, Mississippi
55	Guthrie	90.3%	Guthrie, Oklahoma
56	Harpers Ferry	102.2%	Charles Town, West Virginia
57	Hartford	104.3%	Hartford, Connecticut
58	Hawaii	104.1%	Waimanalo, Hawaii
59	Homestead	96.3%	Homestead, Florida
60	Hubert H. Humphrey	107.4%	St Paul, Minnesota
61	Indypendence	100.0%	Indianapolis, Indiana
62	Inland Empire	107.5%	San Bernardino, California
63	Iroquois	97.7%	Albion, New York
64	Jacksonville	96.0%	Jacksonville, Florida
65	Jacobs Creek	89.0%	Bristol, Tennessee
66	Joliet	106.6%	Joliet, Illinois
67	Keystone	96.9%	Hazleton, Pennsylvania
68	Kicking Horse	87.9%	Polson, Montana
69	Kittrell	92.0%	Henderson, North Carolina
70	Laredo	86.8%	Laredo, Texas
71	Little Rock	91.1%	Little Rock, Arkansas
72	Long Beach	112.3%	Long Beach, California
73	Loring	83.9%	Presque Isle, Maine
74	Los Angeles	113.4%	Los Angeles, California
75	Lyndon B. Johnson	88.2%	Franklin, North Carolina
76	Memphis	97.6%	Memphis, Tennessee
77	Miami	99.4%	Miami, Florida
78	Mingo	89.1%	Dexter, Missouri
79	Mississippi	88.5%	Statewide, Mississippi
80	Montgomery	91.5%	Montgomery, Alabama
81	Muhlenberg	89.2%	Madisonville, Kentucky
82	New Orleans	96.1%	New Orleans, Louisiana
83	North Texas	97.5%	Mckinney, Texas
84	Northlands	98.6%	Burlington-Downtown, Vermont
85	Oconaluftee	88.3%	Bryson City, North Carolina
86	Old Dominion	87.5%	Lynchburg, Virginia
87	Oneonta	95.6%	Oneonta, New York
88	Ouachita	86.5%	Camden, Arkansas
89	Penobscot	92.5%	Bangor, Maine
90	Philadelphia	107.7%	Philadelphia, Pennsylvania
91	Phoenix	99.5%	Phoenix, Arizona
92	Pine Knot	87.2%	Corbin, Kentucky
93	Pine Ridge	86.0%	Scottsbluff, Nebraska
94	Pittsburgh	99.6%	Pittsburgh, Pennsylvania
95	PIVOT	105.5%	Portland, Oregon
96	Potomac	107.2%	District Of Columbia, District of Columbia
97	Quetin N. Burdick	90.3%	Minot, North Dakota
98	Ramey	74.6%	Aguadilla, Puerto Rico
99	Red Rock	96.7%	Towanda, Pennsylvania
100	Roswell	89.5%	Roswell, New Mexico
101	Sacramento	108.7%	Sacramento, California
102	San Diego	107.0%	San Diego, California
103	San Jose	121.3%	San Jose, California
104	Schenck	88.3%	Brevard, North Carolina
105	Shreveport	91.9%	Shreveport, Louisiana
106	Shriver	104.1%	Leominster, Massachusetts
107	Sierra Nevada	104.7%	Reno, Nevada
108	South Bronx	113.6%	Bronx, New York
109	Springdale	101.8%	Troutdale, Oregon
110	St Louis	102.2%	St Louis, Missouri
111	Talking Leaves	88.0%	Muskogee, Oklahoma
112	Timber Lake	103.1%	Estacada, Oregon
113	Tongue Point	98.1%	Astoria, Oregon
114	Trapper Creek	90.3%	Hamilton, Montana
115	Treasure Island	120.9%	San Francisco, California
116	Treasure Lake	89.0%	Lawton, Oklahoma
117	Tulsa	95.1%	Tulsa, Oklahoma
118	Turner	93.1%	Albany, Georgia
119	Weber Basin	96.5%	Ogden, Utah
120	Westover	104.1%	Chicopee, Massachusetts
121	Whitney M. Young Jr.	95.1%	Crestwood, Kentucky
122	Wilmington	99.3%	Wilmington, Delaware
123	Wolf Creek	96.7%	Sutherlin, Oregon
124	Woodland	104.4%	Laurel, Maryland
125	Woodstock	102.6%	Randallstown, Maryland
* Note New Orleans, Louisana and Gulfport, Mississippi information is pre-Hurricane Katrina

position_titles

POSITION TITLES BY PAY GROUP
Position Titles Commonly Found at Job Corps Centers
1	Child Care Aide	4	Accountant	6	Academic Instructor
	Cooks Helper		Career Development Specialist		Career Development Mgr
	Dining Hall/Food Service Aide		Career Exploration Instructor		Career Transition Mgr
	Laundry Operator		Career Preparation Leader/Inst		Child Care Manager
			Career Transition Specialist		Finance Manager
2	Child Care Specialist		Cook, Lead/Senior		Human Resources (HR) Manager
	Clerk/Receptionist		Dental Hygienist		IT System Administrator
	Driver		EEO Coordinator		Recreation Manager
	Groundskeeper		Exec Secretary/Office Mgr		Security Manager
	Janitor/Custodian		Licensed Practical Nurse
	Maintenance Worker		Property/Supply Manager	7	Registered Nurse
	Property/Supply Clerk				Counseling Director
	Purchasing Clerk	5	ACT Coordinator		Admissions Manager
	Recreation/Avocation Assistant		Bus/Community Liaison		Career Transition Services Mngr
	Student Records Clerk		Center Standards Officer
			Child Care Teacher	8	Academic Manager
3	Arts/Crafts Instructor		Counselor		Admin Manager/Director
	Assistant CSO		Dining Hall Manager		Director of Residential Living
	Bookkeeper/Accounting Clerk		Drivers Education Instructor		Health Services Administrator
	Cook		Maintenance Manager		Vocational Manager
	Dental Assistant		Purchasing Agent/Buyer		OA & CTS Manager
	HR Specialist/Benefits Asst		Residential Advisor Supv
	Lab/X-Ray Technician		Safety Instructor/Coordinator	9	Deputy Center Director
	Librarian		Student Records Manager		Education and Training Manager
	Recreation Specialist		TEAP Counselor
	Residential Advisor		Testing Coordinator	10	Center Director
	Secretary/Admin Assistant		Vocational Instructor
	Security Guard/Officer		Vocational Testing Coordinator
	SGA Advisor		VST Project Coordinator
	Transportation Coordinator		Work-Based Learning Coordinator
			Admissions Counselor
			Placement/Employment Spec.
			Career Transition Specialist
			Career Development Specialist

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