National Staff Compensation.xls
XLS spreadsheet 112 KB Posted
- Attached to
- Grafton Job Corps Center Federal contract opportunity
- Solicitation number
- DOLJ08RFP00007
About this file
National Staff Compensation
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| J-22AttachmentGrafton.pdf | ||
| Amendment 1.doc | DOC document | |
| Grafton RFP 04-06-09.doc | DOC document |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
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. |
center_table
| v tw 02-27-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................................................... | Grafton | c. | Planned Start Date of New Contract............................................ | 03/01/10 | |||
| b. | Geographic Adjustment Factor, This Center..................................................................... | 102.7% | d. | Employer Paid Fringe Target Level.................................... | 24.8% | |||
| Pay Group | Budget Element | Base Year 1 | Base Year 2: Inflation @ | 1.40% | 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 | 19,270 | 22,160 | 25,050 | 19,539 | 22,470 | 25,401 | 30% |
| Base Fringe Benefit Allowance | 5,496 | 5,573 | ||||||
| Total of Base Salary + Base Fringes | 27,656 | 28,043 | ||||||
| 2 | Annual Base Salary | 21,825 | 26,190 | 30,555 | 22,130 | 26,556 | 30,983 | 40% |
| Base Fringe Benefit Allowance | 6,495 | 6,586 | ||||||
| Total of Base Salary + Base Fringes | 32,685 | 33,142 | ||||||
| 3 | Annual Base Salary | 25,182 | 30,219 | 35,255 | 25,535 | 30,642 | 35,749 | 40% |
| Base Fringe Benefit Allowance | 7,494 | 7,599 | ||||||
| Total of Base Salary + Base Fringes | 37,713 | 38,241 | ||||||
| 4 | Annual Base Salary | 30,219 | 36,262 | 42,306 | 30,642 | 36,770 | 42,898 | 40% |
| Base Fringe Benefit Allowance | 8,993 | 9,119 | ||||||
| Total of Base Salary + Base Fringes | 45,255 | 45,889 | ||||||
| 5 | Annual Base Salary | 34,416 | 41,299 | 48,182 | 34,898 | 41,877 | 48,857 | 40% |
| Base Fringe Benefit Allowance | 10,242 | 10,386 | ||||||
| Total of Base Salary + Base Fringes | 51,541 | 52,263 | ||||||
| 6 | Annual Base Salary | 38,612 | 46,335 | 54,057 | 39,153 | 46,984 | 54,814 | 40% |
| Base Fringe Benefit Allowance | 11,491 | 11,652 | ||||||
| Total of Base Salary + Base Fringes | 57,826 | 58,636 | ||||||
| 7 | Annual Base Salary | 45,328 | 54,394 | 63,459 | 45,963 | 55,155 | 64,348 | 40% |
| Base Fringe Benefit Allowance | 13,490 | 13,678 | ||||||
| Total of Base Salary + Base Fringes | 67,883 | 68,834 | ||||||
| 8 | Annual Base Salary | 51,573 | 64,466 | 77,359 | 52,295 | 65,369 | 78,442 | 50% |
| Base Fringe Benefit Allowance | 15,988 | 16,211 | ||||||
| Total of Base Salary + Base Fringes | 80,454 | 81,580 | ||||||
| 9 | Annual Base Salary | 60,437 | 75,547 | 90,656 | 61,283 | 76,604 | 91,925 | 50% |
| Base Fringe Benefit Allowance | 18,736 | 18,998 | ||||||
| Total of Base Salary + Base Fringes | 94,282 | 95,602 | ||||||
| 10 | Annual Base Salary | 92,671 | 115,839 | 139,007 | 93,968 | 117,460 | 140,953 | 50% |
| Base Fringe Benefit Allowance | 28,728 | 29,130 | ||||||
| Total of Base Salary + Base Fringes | 144,567 | 146,591 | ||||||
| Min | Midpoint | Max | ||||||
| 1 | 22,160 | 1 | 19,270 | 22,160 | 25,050 | |||
| 2 | 26,190 | 2 | 21,825 | 26,190 | 30,555 | |||
| 3 | 30,219 | 3 | 25,182 | 30,219 | 35,255 | |||
| 4 | 36,262 | 4 | 30,219 | 36,262 | 42,306 | |||
| 5 | 41,299 | 5 | 34,416 | 41,299 | 48,182 | |||
| 6 | 46,335 | 6 | 38,612 | 46,335 | 54,057 | |||
| 7 | 54,394 | 7 | 45,328 | 54,394 | 63,459 | |||
| 8 | 64,466 | 8 | 51,573 | 64,466 | 77,359 | |||
| 9 | 75,547 | 9 | 60,437 | 75,547 | 90,656 | |||
| 10 | 115,839 | 10 | 92,671 | 115,839 | 139,007 | |||
| CY2 | CY3 | CY4 | CY5 | |||||
| Inflation Factors | 1.4% | 1.4% | 1.4% | 1.4% |
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 | 3/1/2010 | Midpoint (Used for Budgeting) | Range information displayed for information only. Budget calculations are based on Midpoints. | 1, Contract Year Start Date | 3/1/2010 | 9/1/2010 | 9/1/2011 | 9/1/2012 | 9/1/2013 | 12/31/1899 | 12/31/1899 | ||
| 2. Infl Adjustment Factor | 1.0234226 | 2. Applicable Inflation Year Start Date | 7/1/2009 | 7/1/2010 | 7/1/2011 | 7/1/2012 | 7/1/2013 | 12/31/1899 | 12/31/1899 | ||||
| 3. Geo Adjustment Factor | 102.7% | 3. Inflation Factor for This Inflation Year | 1.0140 | 1.0140 | 1.0140 | 1.0140 | 1.0140 | 0.0000 | 0.0000 | ||||
| 4. Net Adj (Line 2 x Line 3) | 1.0514 | 4. Elapsed Time in Days (Line 1 minus Line 2) | 243 | 62 | 62 | 62 | 62 | 0 | 0 | ||||
| Pay Level | Minimum | Maximum | Range | 5. Elapsed Time in Terms of Years (Line 4 / 365.25 Days) | 0.6653 | 0.1697 | 0.1697 | 0.1697 | 0.1697 | 0.0000 | 0.0000 | ||
| 1 | $19,270 | $22,160 | $25,050 | 30% | 6. Inflation Factors: 10/01/2007 Thru Contract Start Date | ||||||||
| 2 | $21,825 | $26,190 | $30,555 | 40% | a. Cumulative Thru Prior Inflation Year | 1.0140 | 1.0282 | 1.0426 | 1.0572 | 1.0720 | 0.0000 | 0.0000 | |
| 3 | $25,182 | $30,219 | $35,255 | 40% | b. Added Infl, Time Elapsed This Year (Line 3 ^ Line 5) | 1.009292 | 1.0024 | 1.0024 | 1.0024 | 1.0024 | 0.0000 | 0.0000 | |
| 4 | $30,219 | $36,262 | $42,306 | 40% | c. Cumulative Infl Thru Contract Start Date (6a x 6b) | 1.0234226 | 1.0306 | 1.0451 | 1.0597 | 1.0746 | 0.0000 | 0.0000 | |
| 5 | $34,416 | $41,299 | $48,182 | 40% | d. Inflation Since Preceding Contract Year | 1.0070 | 1.0140 | 1.0140 | 1.0140 | 0.0000 | 0.0000 | ||
| 6 | $38,612 | $46,335 | $54,057 | 40% | INFLATION YEAR DATA | Days Duration | Infl Factor This Year | Cum Thru Prior Year | |||||
| 7 | $45,328 | $54,394 | $63,459 | 40% | Start Date | End Date | |||||||
| 8 | $51,573 | $64,466 | $77,359 | 50% | 10/1/2007 | 1.0000 | 1.0000 | ||||||
| 9 | $60,437 | $75,547 | $90,656 | 50% | 7/1/2008 | 6/30/2009 | 365 | 1.0140 | 1.0000 | ||||
| 10 | $92,671 | $115,839 | $139,007 | 50% | 7/1/2009 | 6/30/2010 | 365 | 1.0140 | 1.0140 | ||||
| 7/1/2010 | 6/30/2011 | 365 | 1.0140 | 1.02820 | |||||||||
| U.S. DEPARTMENT OF LABOR | 7/1/2011 | 6/30/2012 | 366 | 1.0140 | 1.04263 | ||||||||
| OFFICE OF JOB CORPS | 7/1/2012 | 6/30/2013 | 365 | 1.0140 | 1.05723 | ||||||||
| Annual Salary Midpoints @91.65% of Levels Recommended as of | 7/1/2013 | 6/30/2014 | 365 | 1.0140 | 1.07203 | ||||||||
| 10/01/07 | 7/1/2014 | 6/30/2015 | 365 | 1.0140 | 1.08704 | ||||||||
| (Budgetary Effective Date of Phase II Salary Increases) | 7/1/2015 | 6/30/2016 | 366 | 1.0140 | 1.1023 | ||||||||
| Pay Level | @100% | 91.65% | 7/1/2016 | 6/30/2017 | 365 | 1.0140 | 1.1177 | ||||||
| 1 | $22,997 | $21,077 | 7/1/2017 | 6/30/2018 | 365 | 1.0140 | 1.1334 | ||||||
| 2 | $27,179 | $24,910 | 7/1/2018 | 6/30/2019 | 365 | 1.0140 | 1.1492 | ||||||
| 3 | $31,360 | $28,741 | 7/1/2019 | 6/30/2020 | 366 | 1.0140 | 1.1654 | ||||||
| 4 | $37,632 | $34,490 | 7/1/2020 | 6/30/2021 | 365 | 1.0140 | 1.1817 | ||||||
| 5 | $42,859 | $39,280 | 7/1/2021 | 6/30/2022 | 365 | 1.0140 | 1.1982 | ||||||
| 6 | $48,085 | $44,070 | 7/1/2022 | 6/30/2023 | 365 | 1.0140 | 1.2150 | ||||||
| 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 .